[Guide]Easy Server Creation/Makeing Public.

[Santonsan]

Sorry about the double post. It never appeared, so i posted another one.

[MachinesofE]

When I try to execute the SQL thingy from Antrix ( or something ) I get this error message :

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:01:57
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:02:18
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:02: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-28 23:02:57
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:07:28
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

[DarkFever]

Ok ill be home wensday or thursday so illm post my Antrix.wtf,logonserver.wtf and my realms.wtf.
-------------------------------------
also i thank people for not flamming even tho you guys ben having alot of problems. I make this promis that i will help you get your server up and running i hope you believe me...i keep my promises.

[runiker]

ok so my ad.exe aint working for me
am i doing somthing wrong
ive followed every step

id rather add the maps manualy is there a link
or can u make me a pack for it plz?

[evanowns]

Hey,
This is a very well written guide, and i thank you so much for creating it!
I have got this server running before and all was goin well, untill i shutdown my computer and then started it up again and then when i tried to run the atrix.conf file it simpley says:

Loading Config File...
>> antrix.conf : : ok!
>> realms.conf : : Unterminated Block.
fail.

And then the program closes. I have studied the realms.conf file closely and I cannot find any flaws. I have even cleared, and re-dowloaded the Repack folder and ran the ad.exe programs correctly.
I would greatly appreciate it if someone could tell what just might be going on here. Thank you!

[runiker]

i got it to log in but it keeps circleing the relm list my relm dont even apper its my old privit realm i used to play on but it lets me use my new name and pass but it says error getting char list and i cant make one ither

[aznboy]

omg thnx i can make it public without hamaci cuz of the thing u show me.. instead of the hamaci i put my ip code n there it works now

[Andersen13]

I dont undeterstsand anything :s.... "Inside the folder are two thing. Copy thos two things into your wow folder near Repair" <--- ??

[VadarRevan]

Hey where do i get the MySqlyog thing? Like where on the site that you provided is it?

[aznboy]

hmm i restarted my router.. now i am trouble... i cant connect like it say connecting n stay there.. o yeah i alrdy open the port

[storek55]

Whic port i most open

[wrighty91]

when i click execute for mysl i get this message : Cannot create Windows service for MySQL.Error:0

[storek55]

Whic ports i most open?

[Kyane]

thanks for guide i always wanted to get my own private server

[StefanSwe]

i got it working, used the ad_enGB.exe from herleybobs guide, worked fine. Now i have another problem, i got my server up, took the realms file from Nightfoxx121s archive, i could start and log in but the realm is named somerealm and when my friend tries to connect he gets thrown back to the list

I got the same problem....but, im getting thrown back to the realmlist all the time...