Criminal Posted February 3, 2008 Posted February 3, 2008 Wots the code to delete gangs after 0 respect because mine is 0 respect on not deleted gang And wots the cron for local school cuz my school days are -48 Quote
Criminal Posted February 3, 2008 Author Posted February 3, 2008 Re: Delete Wots the code to delete gangs after 0 respect because mine is 0 respect on not deleted gang And wots the cron for local school cuz my school days are -48 And wot do i do to gt more money then 214768686 in v2 game Quote
Magictallguy Posted February 3, 2008 Posted February 3, 2008 Re: Delete Add into attackwon.php if ($ga['gangRESPECT']<=0 && $r['gang']) { $db->query("UPDATE users SET gang=0 WHERE gang={$r['gang']}"); $db->query("DELETE FROM gangs WHERE gangRESPECT<='0'"); $db->query("DELETE FROM gangwars WHERE warDECLARER={$ga['gangID']} or warDECLARED={$ga['gangID']}"); } ---- Add into attackbeat.php if ($ga['gangRESPECT']<=0 && $r['gang']) { $db->query("UPDATE users SET gang=0 WHERE gang={$r['gang']}"); $db->query("DELETE FROM gangs WHERE gangRESPECT<='0'"); $db->query("DELETE FROM gangwars WHERE warDECLARER={$ga['gangID']} or warDECLARED={$ga['gangID']}"); } Quote
Magictallguy Posted February 3, 2008 Posted February 3, 2008 Re: Delete Why you would want to overdo your economy is above me..but fine.. Go into phpMyAdmin -> SQL ALTER TABLE `users` CHANGE `money` `money` INT( 12 ) NOT NULL DEFAULT '0', CHANGE `crystals` `crystals` INT( 12 ) NOT NULL DEFAULT '0', CHANGE `bankmoney` `crystals` INT( 12 ) NOT NULL DEFAULT '0', CHANGE `cybermoney` `crystals` INT( 12 ) NOT NULL DEFAULT '0' Quote
Magictallguy Posted February 3, 2008 Posted February 3, 2008 Re: Delete If you want to be able to credit yourself more than 2,147,483,647 then: Go into your File Manager Find staff_users.php In there find the code function credit_user_submit() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] > 3) { die("403"); } $_POST['money'] = (int) $_POST['money']; $_POST['crystals'] = (int) $_POST['crystals']; $db->query("UPDATE users u SET money=money+{$_POST['money']}, crystals=crystals+{$_POST['crystals']} WHERE u.userid={$_POST['user']}"); print "User credited."; $d=$db->query("SELECT username FROM users WHERE userid='{$_POST['user']}'"); $un=$db->fetch_single($d); stafflog_add("Credited $un [{$_POST['user']}] \${$_POST['money']} and/or {$_POST['crystals']} crystals."); } And replace with: function credit_user_submit() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] > 3) { die("403"); } $_POST['money'] = (float) $_POST['money']; $_POST['crystals'] = (float) $_POST['crystals']; $db->query("UPDATE users u SET money=money+{$_POST['money']}, crystals=crystals+{$_POST['crystals']} WHERE u.userid={$_POST['user']}"); print "User credited."; $d=$db->query("SELECT username FROM users WHERE userid='{$_POST['user']}'"); $un=$db->fetch_single($d); stafflog_add("Credited $un [{$_POST['user']}] \${$_POST['money']} and/or {$_POST['crystals']} crystals."); } Quote
Magictallguy Posted February 3, 2008 Posted February 3, 2008 Re: Delete For the school...The code should already be there.. cron_day.php (about half way down) $q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 0"); while($r=$db->fetch_row($q)) { $cd=$db->query("SELECT * FROM courses WHERE crID={$r['course']}"); $coud=$db->fetch_row($cd); $userid=$r['userid']; $db->query("INSERT INTO coursesdone VALUES({$r['userid']},{$r['course']})"); Quote
Criminal Posted February 3, 2008 Author Posted February 3, 2008 Re: Delete Do i do sumthing in myphpadmin for more money Quote
Criminal Posted February 3, 2008 Author Posted February 3, 2008 Re: Delete And wot do i do for stats and crystals to gt more then 214775858 Quote
BlatantDude Posted February 3, 2008 Posted February 3, 2008 Re: Delete If you looked its a few of posts above this one.. Quote
Criminal Posted February 3, 2008 Author Posted February 3, 2008 Re: Delete cba looking its ok if sum posts it here thnx Quote
Magictallguy Posted February 3, 2008 Posted February 3, 2008 Re: Delete If you looked its a few of posts above this one.. Does badboy act stoopid on purpose? :P Quote
Criminal Posted February 3, 2008 Author Posted February 3, 2008 Re: Delete Wot do i do to gt more stats and crystals then 214756885 Quote
Klikoka Posted February 3, 2008 Posted February 3, 2008 Re: Delete ALTER TABLE `users` CHANGE `crystals` `crystals` INT( 12 ) NOT NULL DEFAULT '0' ALTER TABLE `userstats` CHANGE `strength` `strength` INT( 12 )NOT NULL DEFAULT '0', CHANGE `IQ` `IQ` INT( 12 )NOT NULL DEFAULT '0', CHANGE `agility` `agility` INT( 12 )NOT NULL DEFAULT '0', CHANGE `guard` `guard` INT( 12 )NOT NULL DEFAULT '0', CHANGE `labour` `labour` INT( 12 )NOT NULL DEFAULT '0', Quote
BlatantDude Posted February 3, 2008 Posted February 3, 2008 Re: Delete If you looked its a few of posts above this one.. Does badboy act stoopid on purpose? :P Most probs..lol :roll: Quote
Criminal Posted February 3, 2008 Author Posted February 3, 2008 Re: Delete klikoka this was rong ALTER TABLE `userstats` CHANGE `strength` `strength` INT( 12 )NOT NULL DEFAULT '0', CHANGE `IQ` `IQ` INT( 12 )NOT NULL DEFAULT '0', CHANGE `agility` `agility` INT( 12 )NOT NULL DEFAULT '0', CHANGE `guard` `guard` INT( 12 )NOT NULL DEFAULT '0', CHANGE `labour` `labour` INT( 12 )NOT NULL DEFAULT '0', the right one is ALTER TABLE `userstats` CHANGE `strength` `strength` INT( 12 )NOT NULL DEFAULT '0' CHANGE `IQ` `IQ` INT( 12 )NOT NULL DEFAULT '0' CHANGE `agility` `agility` INT( 12 )NOT NULL DEFAULT '0' CHANGE `guard` `guard` INT( 12 )NOT NULL DEFAULT '0' CHANGE `labour` `labour` INT( 12 )NOT NULL DEFAULT '0' Just by taking , that of at the end thanks for trying Quote
Criminal Posted February 3, 2008 Author Posted February 3, 2008 Re: Delete From v2 staff panel edit user i put my stats to 4000000000000000000 straength but it bes 21478868 Quote
Criminal Posted February 3, 2008 Author Posted February 3, 2008 Re: Delete So do you know how to edit ur stats form staff panel v2 cuz i edit it to 69999999999 then it goes to 214768868 Quote
Jesse60905 Posted February 3, 2008 Posted February 3, 2008 Re: Delete Try running this query. TRUNCATE TABLE crimegroups After that shut up and learn PHP. "Cba to look". Lazy brat... Quote
Cruisey Posted February 3, 2008 Posted February 3, 2008 Re: Delete why do you need to edit your stats that much anyway? Quote
Jesse60905 Posted February 3, 2008 Posted February 3, 2008 Re: Delete Probably compensating for something else... Quote
Criminal Posted February 3, 2008 Author Posted February 3, 2008 Re: Delete Please anyone just tell me i done the sql wot file do i edit and wot do i edit Sory am nt a fully coder Am learning on w3schools.com Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.