carlg

Re: 1 more thing with a query no i am still getting QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''carl41', 'addinge','11','11','11','11','11','1'' at line 1 Query was UPDATE ships_types SET 'carl41', 'addinge','11','11','11','11','11','1' i have been up all night trying to debug this but i have no ider

$name=$_POST['name']; $q=$db->query("SELECT * FROM ships_types WHERE shipid={$_POST['id']}"); $old=$db->fetch_row($q); $db->query("UPDATE ships_types SET '{$_POST['name']}', '{$_POST['desc']}','{$_POST['shipCOST']}','{$_POST['shipACC']}','{$_POST['shipHAN']}','{$_POST['shipsPD']}','{$_POST['shipsHD']}','{$_POST['shipBUYABLE']}");   this is the error i get QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''carl41','addinge','11','11','11','11','1','1' at line 1 Query was UPDATE ships_types SET 'carl41','addinge','11','11','11','11','1','1

Re: i need a little help with a function thanks for that but i have a nothere problem it is not listing my ships would it be a error in my script or in the global_func this is what i put in the global_func   function ship_dropdown($connection,$ddname="ship",$selected=-1) { global $db; $ret="<select name='$ddname' type='dropdown'>"; $q=$db->query("SELECT * FROM ships_types ORDER BY shipname ASC"); if($selected < 1) { $ret.="<option value='0' selected='selected'>-- None --</option>"; } else { $ret.="<option value='0'>-- None --</option>"; } while($r=$db->fetch_row($q)) { $ret.="\n<option value='{$r['shipid']}'"; if ($selected == $r['shipid']) { $ret.=" selected='selected'";$first=1; } $ret.=">{$r['shipname']}</option>"; } $ret.="\n</select>"; return $ret; }

thanks for your help working now

Re: New!! Free!! Staff can change any users back ground yes but it would change it for all members not just one player

Re: New!! Free!! Staff can change any users back ground i was just looking though the mod and i saw this and i cant see how this works as it would have to edit the header every time would it?

i have seen about 6 or 7 sites with this but not sure how they are doing it and iders???

Re: Need Help Badly poo i i was sure i was missing something lol

Re: Need Help Badly   <?php include "globals.php"; global $c; db->query("UPDATE businesses SET bDAYSOLD=bDAYSOLD+1",$c); db->query("UPDATE users SET dib=dib+1 WHERE business >0",$c); $rra=db->query("SELECT * FROM businesses",$c); while($r=db->fetch_array($rra)) { $profitgt=$r['bPOPULATION']*1; db->query("UPDATE businesses SET bPROFIT=bPROFIT+$profitgt WHERE bID={$r['bID']}",$c); } $xd=include "db->query("SELECT * FROM businesses WHERE bPOPULATION<0",$c); while($p=db->fetch_array($xd)) { db->query("UPDATE users SET business=0 WHERE business={$p['bID']}",$c); } db->query("DELETE FROM businesses WHERE bPOPULATION<0",$c); ?>     i think

Re: Monorail     ty that worked ty

Re: Crystal market exploit? s##t happens lol

Re: Monorail   nope nothing

Re: Crystal market exploit? nice i have been having problems and did not know how they were doing it so i made him admin he told me and i have banned his ass

Re: Monorail   think that is right lol aint coded in a while and no-where to test as of this moment... yer this was my first ider and all that comes up is the id of the city and not the name

Re: Monorail yes i have tryed this to please note that i am useing v2 codes

Re: Monorail no i have tryed that lol but ty for your help

ty for the help sorted now

Re: Welcome back CE nice to see ce back up and running agen

sorted ty any way

Re: [mccodes][V2] owner`s pannel thanks for that !

Ok i was looking for a owners panel here ther was just 1 topic with on code, so i thought i would make a quick one. All i have done is edit the explore page   <?php include "globals.php"; if($ir['userid'] != 1) { die("404 u are not alowerd here"); } if($_POST['submit']) $tresder=(int) rand(100,999); print "[b]WELCOLME WELARD.[/b] <table width=75%><tr height=100><td valign=top> <u>Quick links</u> [url='staff.php']staff panel[/url] <a href='secpanel.php'>Secretary Panel<a/> [url='asspanel.php']Assistant Panel[/url]</td> <td valign=top> <u>General</u> [url='staff.php?action=basicset']basic settings[/url] [url='staff.php?action=appview']staff apps[/url] [url='staff.php?action=announce']add a Announcement[/url]"; print "</td> <td valign=top> <u>Users</u> [url='staff_users.php?action=newuser']Create New User[/url] [url='staff_users.php?action=edituser']Edit User[/url] [url='staff_users.php?action=deluser']Delete User[/url] [url='staff_users.php?action=invbeg']View User Inventory[/url] [url='staff_users.php?action=creditform']Credit User[/url] [url='staff_users.php?action=masscredit']Mass Payment[/url] [url='staff_users.php?action=forcelogout']Force User Logout[/url] [url='staff_users.php?action=reportsview']Player Reports[/url] "; print "</td> <td valign=top> <u>Items</u> [url='staff_items.php?action=newitem']Create New Item[/url] [url='staff_items.php?action=giveitem']Give User a Item[/url] [url='staff_items.php?action=edititem']Edit Item[/url] [url='Delete An Item']Delete An Item[/url] [url='staff_items.php?action=newitemtype']Add Item Type[/url] "; print "</td></tr><tr height=100> <td valign=top> <u>Logs</u> [url='staff_logs.php?action=atklogs']Attack Logs[/url] [url='staff_logs.php?action=cashlogs']Cash Xfer Logs[/url] [url='staff_logs.php?action=cryslogs']Crystals Xfer Logs[/url] [url='staff_logs.php?action=banklogs']Bank Xfer Logs[/url] [url='staff_logs.php?action=itmlogs']Item Xfer Logs[/url] [url='staff_logs.php?action=maillogs']Mail Logs[/url] [url='staff_logs.php?action=stafflogs']Staff Logs[/url] [url='clearlogs.php']Clear Logs[/url] "; print "</td> <td valign=top> <u>Gangs</u> [url='staff_gangs.php?action=grecord']Gang Record[/url] [url='staff_gangs.php?action=gcredit']Credit Gang[/url] [url='staff_gangs.php?action=gwar']Manage Gang Wars[/url] [url='staff_gangs.php?action=createoc']Create Organised Crime[/url] [url='staff_gangs.php?action=gedit']Edit Gang[/url] [url='staff_gangs.php?action=gedel']Delete Gang[/url] "; print "</td> <td valign=top> <u>Shops</u> [url='staff_shops.php?action=newshop']Create a New Shop[/url] [url='staff_shops.php?action=newstock']Add Item To Shop[/url] [url='staff_shops.php?action=delshopl']Delete shop[/url] "; print "</td> <td valign=top> <u>Jobs</u> [url='staff_jobs.php?action=newjob']Make a new Job[/url] [url='staff_jobs.php?action=jobedit']Edit a Job[/url] [url='staff_jobs.php?action=jobdele']Delete a Job[/url] [url='staff_jobs.php?action=newjobrank']Make a new Job Rank[/url] [url='staff_jobs.php?action=jobrankedit']Edit a Job Rank[/url] [url='staff_jobs.php?action=jobrankdele']Delete a Job Rank[/url] "; print "</td></tr><tr height=100> <td valign=top> <u>Houses</u> [url='staff_houses.php?action=addhouse']Make A new House[/url] [url='staff_houses.php?action=edithouse']Edit House[/url] [url='staff_houses.php?action=delhouse']Remove House[/url] "; print "</td> <td valign=top> <u>Cities</u> [url='staff_cities.php?action=addcity']Add A New City[/url] [url='staff_cities.php?action=editcity']Edit City[/url] [url='staff_cities.php?action=delcity']Remove City[/url] "; print "</td> <td valign=top> <u>Courses</u> [url='staff_courses.php?action=addcourse']Create a New Course[/url] [url='staff_courses.php?action=editcourse']Edit Course[/url] [url='staff_courses.php?action=delcourse']Delete Course[/url] "; print "</td> <td valign=top> <u>Crimes</u> [url='staff_crimes.php?action=newcrime']Make a New Crime[/url] [url='staff_crimes.php?action=editcrime']Edit a Crime[/url] [url='staff_crimes.php?action=delcrime']Delete a Crime[/url] [url='staff_crimes.php?action=newcrimegroup']Make a new Crime Group[/url] [url='staff_crimes.php?action=editcrimegroup']Edit a Crime Group[/url] [url='staff_crimes.php?action=delcrimegroup']Delete a Crime Group[/url] [url='staff_crimes.php?action=reorder']Reorder Crime Groups[/url] "; print "</td></tr><tr height=100> <td valign=top> <u>Battle Tent</u> [url='staff_battletent.php?action=addbot']Add Challenge Bot[/url] [url='staff_battletent.php?action=editbot']Edit Challenge Bot[/url] [url='staff_battletent.php?action=delbot']Remove Challenge Bot[/url] "; print "</td> <td valign=top> <u>Punishments</u> [url='staff_punit.php?action=mailform']Mail Ban User[/url] [url='staff_punit.php?action=unmailform']Un-Mailban User[/url] [url='staff_punit.php?action=fedform']Jail User[/url] [url='staff_punit.php?action=fedeform']Edit Fedjail Sentence[/url] [url='staff_punit.php?action=unfedform']Unjail User[/url] [url='staff_punit.php?action=ipform']Ip Search[/url] "; print "</td> <td valign=top> <u>Special</u> [url='staff_special.php?action=editnews']Edit Newspaper[/url] [url='staff_special.php?action=massmailer']Mass mailer[/url] [url='staff_special.php?action=stafflist']Staff List[/url] [url='staff_special.php?action=userlevelform']Adjust User Level[/url] [url='staff_special.php?action=givedpform']Give User Donator Pack[/url] [url='nuclearbomb.php?action=givedpform']Nuclear Bomb every one[/url] "; print "</td> <td valign=top> <u>Cpanel</u> [url='http://{$domain}:2082']Cpanel Mainmenu[/url] [url='http://{$domain}:2082/frontend/x3/backup/index.html']Backup Game[/url] [url='http://{$domain}:2082/3rdparty/phpMyAdmin/index.php']phpMyAdmin[/url] [url='http://{$domain}:2082/frontend/x3/stats/errlog.html']Error Logs[/url] [url='http://{$domain}:2082/frontend/x3/cron/index.html']Edit crons[/url] "; $h->endpage(); ?>   hope u like haha i forgot about that ty sorted now!

Re: [mccode] voting Pimped Out i have done that but when they vote it does not chane to yes it just stayes no

Re: armory did tht sortit???

Re: [mccode] voting Pimped Out when my users use this they dont get say 10 crystals and so on

Re: how can i link A+++ ty m8