Mangos, Trinity and Aspire Account Structure?

[Kiev]

So i was wondering if anyone actually has the structure for these 3 tables.

I need it for a project im working on.

+rep for correct answer. Thanks

[eddyhack]

ill see what i can do

[slade1000]

Here is the Arcemu Structure, I think this is what you were asking for sorry if it was not haha

pastebin - collaborative debugging tool

[Kiev]

I have that...

Its all the others i need

[slade1000]

Ohh im sorry lol

[Hellgawd]

Last time I checked (Which was a while ago, mind you) TrinityCore2 & Mangos had the same accounts table structure.
Aspire's different than Arc & Mangos though.
Here are the structures for you:
---
TrinityCore2 / Mangos

CREATE TABLE `account` (
  `id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier',
  `username`      varchar(32) NOT NULL default '',
  `sha_pass_hash` varchar(40) NOT NULL default '',
  `gmlevel` tinyint(3) unsigned NOT NULL default '0',
  `sessionkey` longtext,
  `v` longtext,
  `s` longtext,
  `email` text,
  `joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `last_ip` varchar(30) NOT NULL default '127.0.0.1',
  `failed_logins` int(11) unsigned NOT NULL default '0',
  `locked` tinyint(3) unsigned NOT NULL default '0',
  `last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
  `online` tinyint(4) NOT NULL default '0',
  `expansion` tinyint(3) unsigned NOT NULL default '0',
  `mutetime` bigint(40) unsigned NOT NULL default '0',
  `locale` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC COMMENT='Account System';

...And, an example:

(1,'Hellgawd','a34b29541b87b7e4823683ce6c7bf6ae68beaaac',3,'','0','0','','2006-04-25 10:18:56','127.0.0.1',0,0,'0000-00-00 00:00:00',0,0,0,0),

(Just use sha1 encryption, if you're using a PHP script, to get a hash like that. Just google eet and you'll find all sorts of tutorials and such.)

---

Aspire:

CREATE TABLE `accounts`(
	  `acct` int(5) NOT NULL AUTO_INCREMENT ,
	  `login` varchar(32) NOT NULL DEFAULT '' ,
	  `password` varchar(255) NOT NULL DEFAULT '' ,
  `SessionKey` varchar(255) NOT NULL DEFAULT '' ,
	  `gm` varchar(10) NOT NULL DEFAULT '0' ,
	  `flags` int(11) NOT NULL DEFAULT 24 ,
	  `banned` tinyint(1) NOT NULL DEFAULT 0 ,
  `lastlogin` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	  `lastip` varchar(15) NOT NULL DEFAULT '' ,
	  `forceLanguage` varchar(5) NOT NULL DEFAULT 'enUS' ,
  `email` varchar(32) DEFAULT NULL ,
  `muted` int(30) NOT NULL DEFAULT 0 ,
 PRIMARY KEY (`acct`),
 UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

No need for an example here, it's similair to ArcEmu just a few slight changes that's all. I'm sure you can fill it in yourself.

Hope this helped you,
Hellgawd

[Kiev]

Thank you very much.

Not a PHP script as such, but VB.net, but ill be able to find a way to do that.

Thanks Hell +rep. (If possible)