reset

[WarMad]

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?

[TheMasterGeneral]

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.

[KyleMassacre]

truncate table users

[sniko]

Remember to reset the auto_increment value, and truncate "inventory", "user_stats", "*_logs"

[Magictallguy]

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';

 

[WarMad]

Thanks everyone