who has an sql of the accounts table menu

User Tag List

Results 1 to 4 of 4
  1. #1
    anonymous23's Avatar Active Member
    Reputation
    20
    Join Date
    Nov 2007
    Posts
    220
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    who has an sql of the accounts table

    can someone just dump it? i lost mine....

    who has an sql of the accounts table
  2. #2
    anonymous23's Avatar Active Member
    Reputation
    20
    Join Date
    Nov 2007
    Posts
    220
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    and i mean the one named muted at the end

  3. #3
    Ebon's Avatar Contributor
    Reputation
    218
    Join Date
    Sep 2007
    Posts
    604
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sure, I suppose I can get you one... 40101 SET NAMES utf8 */;
    create table `accounts` (
    `acct` double ,
    `login` varchar (96),
    `password` varchar (96),
    `gm` varchar (96),
    `banned` tinyint (3),
    `lastlogin` timestamp ,
    `lastip` varchar (4,
    `email` varchar (192),
    `flags` tinyint (3),
    `forceLanguage` varchar (15)
    );

    No idea if that will work, gonna get a different one.

    Edit - Yeah, I don't thank that's what you need. If Notepad will open this quickly I can get it to you .

    Double Edit - Here it is!

    CREATE TABLE `accounts` (
    `acct` bigint(20) NOT NULL auto_increment,
    `login` varchar(255) NOT NULL default '',
    `password` varchar(2 NOT NULL default '',
    `gm` varchar(27) NOT NULL default '',
    `banned` int(30) NOT NULL default '0',
    `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
    `lastip` varchar(15) NOT NULL default '',
    `email` varchar(50) NOT NULL default '',
    `flags` int(11) NOT NULL default '0',
    `forceLanguage` varchar(5) character set utf8 collate utf8_unicode_ci NOT NULL default 'enUS',
    PRIMARY KEY (`acct`,`login`),
    UNIQUE KEY `acct` (`acct`)
    ) ENGINE=MyISAM AUTO_INCREMENT=910232 DEFAULT CHARSET=latin1;

    Tripile Edit - They look the same for the most part T_T.
    Last edited by Ebon; 02-03-2008 at 02:16 PM. Reason: Added some text yo!


  4. #4
    WiKKiD's Avatar Member
    Reputation
    6
    Join Date
    Jan 2008
    Posts
    58
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

Similar Threads

  1. Replies: 0
    Last Post: 08-10-2015, 04:49 AM
  2. Replies: 3
    Last Post: 09-03-2010, 08:31 AM
  3. Who has the best sig on mmowned?
    By Kazin420 in forum Community Chat
    Replies: 0
    Last Post: 08-05-2010, 01:52 AM
  4. Who has the biggest?
    By Don_SyStEmS in forum Community Chat
    Replies: 8
    Last Post: 08-10-2009, 06:13 PM
  5. [info] The account table set up!
    By runiker in forum World of Warcraft Emulator Servers
    Replies: 0
    Last Post: 01-28-2008, 05:00 PM
All times are GMT -5. The time now is 11:37 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search