Announcement

Collapse
No announcement yet.

reset

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • reset

    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?

  • #2
    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.
    Please, if you're going to add me on Skype, include that you're from MWG or something.

    Comment


    • #3
      Code:
      truncate table users
      [My NWE Modules]
      Originally posted by Djkanna
      So after 10 pages of non-stop bickering, all it has amounted to is: Guest likes Midgets, well isn't that productive?

      Comment


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


        If you found this post useful, consider donating: https://www.paypal.me/harrydenley
        Latest free module: Free real time chat for McCodes.
        Humanity sets its own stage for extinction

        Comment


        • #5
          For your setup..
          Code:
          <?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';
          Bear - Magictallguy

          Comment


          • #6
            Thanks everyone

            Comment

            Working...
            X