Halo

Re: Counting (nr game) 1845

Re: Count Backwards :D 4973

Re: 3 Word Game husband walks in

This function allows you to reset a specific user. First Of All Open staff_users.php Find:   case 'massdd': massdd_user_form(); break; case 'massddsub': massdd_user_submit(); break;   add below:   case 'resetform': reset_user_form(); break; case 'resetsub': reset_user_submit(); break;   Then find:   $h->endpage(); ?>   add above:   //Reset Specific User Function Created By BlackDragon //Free For CE Members function reset_user_form() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] != 2) { die("403"); } print "<h3>Reseting User</h3> Make sure you want to do this because once you do theres no turning back <form action='staff_users.php?action=resetsub' method='post'> User: ".user_dropdown($c,'user')." Reason: <input type='text' name='reason' /> <input type='submit' value='RESET' /></form>"; } function reset_user_submit() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] != 2) { die("403"); } $db->query("UPDATE users SET money=100, crystals=0, bankmoney=0, cybermoney=0, donatordays=0 WHERE userid={$_POST['user']}"); $db->query("UPDATE users SET level=1, exp=0.0000, energy=12, will=100, brave=5, hp=100, maxenergy=12, maxwill=100, maxbrave=5, maxhp=100 WHERE userid={$_POST['user']}"); $db->query("UPDATE users SET job=0, jobrank=0, location=1, hospital=0, jail=0, user_level=1, daysold=0, gang=0, daysingang=0, course=0, cdays=0 WHERE userid={$_POST['user']}"); $db->query("UPDATE users SET posts=0, new_mail=0, new_events=0, friend_count=0, enemy_count=0, new_announcements=0, boxes_opened=0 WHERE userid={$_POST['user']}"); $db->query("UPDATE users SET equip_primary=0, equip_secondary=0, equip_armor=0 WHERE userid={$_POST['user']}"); $db->query("UPDATE userstats SET strength=10.0000, agility=10.0000, labour=10.0000, guard=10.0000, IQ=10.000000 WHERE userid={$_POST['user']}"); $db->query("DELETE FROM inventory WHERE inv_userid={$_POST['user']}"); $d=$db->query("SELECT username FROM users WHERE userid='{$_POST['user']}'"); $un=$db->fetch_single($d); print "[b]$un[/b] Reseted."; $d=$db->query("SELECT username FROM users WHERE userid='{$_POST['user']}'"); $un=$db->fetch_single($d); stafflog_add("{$ir['username']} reseted $un [{$_POST['user']}] for the following reason: {$_POST['reason']}."); }   Then Open smenu.php Find:   > [url='staff_users.php?action=deluser']Delete User[/url] ";   Replace with:   > [url='staff_users.php?action=deluser']Delete User[/url] > [url='staff_users.php?action=resetform']Reset User[/url] ";   You can easily add or remove queries! Please post updates, bug or views!

Re: [v2]Assassin.php[v2]   Lol, i know mine never worked i will fix it when i have time

Re: Customisable Merit System ($15+) Nice Work Akash Well Worth The $15!

Re: [mccodes][V2] owner`s pannel (In First Post)   [url='Delete An Item']Delete An Item[/url]   ???, Look at what your typing!

Re: crons On a lot of your crons you havn't added "WHERE" so i don't think it will work properly

Re: securing against mysql injection Whats the exact injection?

Re: 3 Word Game to japan to

Re: Count Backwards :D 4976

Re: Gym Record Nice one Akash, but i made my own one like this before

Re: Advanced RentASpy[V2] Like the way it shows if his stats are weaker than your but thats easyily seen from the index.php just compare them

Re: 3 Word Game people in spain

Re: Count Backwards :D 4978

Re: Counting (nr game) 1844

Re: [v2]Assassin.php[v2]   The original mod was even worse

Re: [Free] Maths Challenge Great mod

Re: hi everyone Welcome...

Re: Favorite TV shows   Forgot to add that in my one

Re: Free Starter Pack Nice Mod, This Is A Mod I Might Use But After My Game Has Finished Testing

Re: [v2]***UPDATED*** Staff Action: Full User Details[v2]   Thanks

Re: [v2]UPDATED Staff Action: Full User Details[v2] Updated this post, please give your thoughts... BlackDragon

Re: [v2]Staff Action: Full User Details[v2]   I'm adding more features for staff members to view as well as functions

Re: I really need someone's help with my money and stats, please help Just Run This on phpMyAdmin:   ALTER TABLE `users` CHANGE `money` `money` BIGINT( 92 ) NOT NULL DEFAULT '0' ALTER TABLE `users` CHANGE `crystals` `crystals` BIGINT( 92 ) NOT NULL DEFAULT '0' ALTER TABLE `users` CHANGE `bankmoney` `bankmoney` BIGINT( 92 ) NOT NULL DEFAULT '0' ALTER TABLE `users` CHANGE `cybermoney` `cybermoney` BIGINT( 92 ) NOT NULL DEFAULT '0'   etc... And do not change STATS into bigint because stats are decimals, again run the following queries:   ALTER TABLE `userstats` CHANGE `strength` `strength` DECIMAL( 65, 4 ) NOT NULL DEFAULT '0.0000', CHANGE `agility` `agility` DECIMAL( 65, 4 ) NOT NULL DEFAULT '0.0000', CHANGE `guard` `guard` DECIMAL( 65, 4 ) NOT NULL DEFAULT '0.0000', CHANGE `labour` `labour` DECIMAL( 65, 4 ) NOT NULL DEFAULT '0.0000', CHANGE `IQ` `IQ` DECIMAL( 65, 6 ) NOT NULL DEFAULT '0.000000'