WarMad Posted September 28, 2016 Share Posted September 28, 2016 how do i do a reset? so lets say i want to reset the users table and delete everyone and every new user sign up will start over at 1? Quote Link to comment Share on other sites More sharing options...
TheMasterGeneral Posted September 29, 2016 Share Posted September 29, 2016 In PHPMyAdmin, check the "Check All" box at the bottom of the table listing, then click the dropdown next to it and click empty. This'll keep the table setup, but just clear the information stored in the tables. Quote Link to comment Share on other sites More sharing options...
KyleMassacre Posted September 29, 2016 Share Posted September 29, 2016 truncate table users Quote Link to comment Share on other sites More sharing options...
sniko Posted September 29, 2016 Share Posted September 29, 2016 Remember to reset the auto_increment value, and truncate "inventory", "user_stats", "*_logs" Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted September 30, 2016 Share Posted September 30, 2016 For your setup.. <?php require_once __DIR__ . '/lib/allpage.php'; $tables = [ 'attacklogs', 'attacklogs', 'blacklist', 'blacklist', 'cashxferlogs', 'cashxferlogs', 'challengesbeaten', 'coursesdone', 'crystalmarket', 'dps_process', 'events', 'fedjail', 'fedjail', 'fight_challenges', 'fight_challenges', 'forum_forums', 'forum_forums', 'forum_posts', 'forum_posts', 'forum_topics', 'forum_topics', 'friendslist', 'friendslist', 'gymlogs', 'hitlist', 'imarketaddlogs', 'imbuylogs', 'imbuylogs', 'imremovelogs', 'imremovelogs', 'inventory', 'itembuylogs', 'itemmarket', 'itemselllogs', 'itemxferlogs', 'itemxferlogs', 'jaillogs', 'jaillogs', 'logs_staff', 'mail', 'mail', 'mugger_oth', 'mugger_oth_global', 'preports', 'preports', 'referals', 'referals', 'reports_bugs', 'reports_bugs_responses', 'review', 'rr_challenges', 'rr_challenges', 'rr_logs', 'rr_logs', 'rr_logs', 'scoment', 'staffnotelogs', 'staffnotelogs', 'status', 'syndicates', 'syndicates', 'syndicate_apps', 'syndicate_coment', 'unjaillogs', 'unjaillogs', 'users', 'userstats', 'user_imageusername', 'warnings', 'warnings', 'willplogs' ]; $db->startTrans(); foreach($tables as $table) { $db->query('TRUNCATE TABLE '.$query); $db->execute(); } $db->endTrans(); session_unset(); session_destroy(); echo 'Game reset'; 1 Quote Link to comment Share on other sites More sharing options...
WarMad Posted September 30, 2016 Author Share Posted September 30, 2016 Thanks everyone Quote Link to comment Share on other sites More sharing options...
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.