2.1.3 Antrix Server Cretion

[Dolfonwow]

Shall i download all the 3 programs ... or can i just download MySql ...

[lokal]

ok i dont see the Winrar zip file in the repack after i get down with sqlyog accounts, can someone help me?

[adar]

iv tried and i cant get it

[adar]

Oghh i figured it out!!!!!!!!!!!!!!!!!!!!!!!!!!!

[adar]

duhhhhhh!!!! i did the realmlist wrong....

[crazy_pirate1337]

Im trying to open the logonserver.conf with adobe reader but its not working, anyone know of another progam that will open .conf files?
It would be a great help thnx.

[aznboy]

i need help... can u pm me for the answer?? i alwasy get
The application failed to initialize properly (0xc0150002). Click on OK to terminate the application.. so i cant get it to work

[Soddie]

Query:
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',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-10-28 23:42:49
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
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',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-10-28 23:43:03
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
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',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-10-28 23:43:37
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
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',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-10-28 23:44:11
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
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',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-10-29 06:00:42
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
INSERT INTO `creatureloot` VALUES (593385,21867,32280,10),(593386,21867,32323,10),(593387,21867,32324,10),(593388, 21867,32325,10),(593389,21867,32326,10),(593390,21867,32327,10),(593391,21867,32 328,10),(593392,21867,32329,10),(593393,21867,32330,10),(593394,21867,32348,10), (593395,21867,32510,10),(593396,21867,32512,10),(593397,21867,32737,10),(593398, 21867,32739,10),(593399,21867,32745,10),(593400,21867,32745,10),(593401,21867,32 747,10),(593402,21867,32749,10),(593403,21867,32751,10),(593404,21867,32752,10), (593405,21867,32755,10),(593406,21867,32738,10),(593407,21867,32744,10),(593408, 21867,32753,1),(593409,21867,32750,1),(593410,21867,32746,1),(593411,21867,32753 ,1)

Error occured at:2007-10-29 06:03:17
Line no.:1
Error Code: 1062 - Duplicate entry '593385' for key 1

Query:
INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435, 23420,32352,10)

Error occured at:2007-10-29 06:03:25
Line no.:1
Error Code: 1062 - Duplicate entry '593432' for key 1

Query:
CREATE TABLE `ai_agents` (
`entryId` int(6) NOT NULL default '0',
`AI_AGENT` int(2) NOT NULL default '0',
`procEvent` int(2) NOT NULL default '0',
`procChance` int(3) NOT NULL default '0',
`procCount` int(6) NOT NULL default '0',
`spellId` int(6) NOT NULL default '0',
`spellType` int(2) NOT NULL default '0',
`spelltargetType` int(2) NOT NULL default '0',
`spellCooldown` int( NOT NULL default '0',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(6) NOT NULL default '0',
PRIMARY KEY (`entryId`,`AI_AGENT`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Error occured at:2007-10-29 06:03:39
Line no.:32
Error Code: 1050 - Table 'ai_agents' already exists

Query:
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',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-10-29 06:20:13
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
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',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-10-29 06:20:21
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
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',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-10-29 06:20:39
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
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',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1

Error occured at:2007-10-29 06:23:11
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

How do i fix this? :/ happens whenever i try to upload antrix database or account and tables, pm me with the reply please, thanks.

[aznboy]

uh i am having problem with creating a character now i made them but the login things cant find them can u help me??

[Equinox69]

Great job! other than the typo's everything worked great on the first try

keep it up man.

[Happyguy]

I got private servers on 3 different computers thanks to this! Really awesome guide, man! Tho my virus scanner did managed to go off once o_O was nothing bad actually. Once again, thanks for this awesome guide!

[kristian92]

i tried to set up the server and i thought i did it right. i logged inn and was assigned a realm. i chose it. it said logging in to game server, but after a while, it just switched back to the list of realms.... it does this evrytime i try.. is i because i have vista or somethin... could use some hlp..

[kristian92]

plz! can some1 help me?

[kristian92]

plz! pm me or something!

[whitefox]

this has gotten too full. I am going to make a troubleshoot guide for this, refer to it for answers.