It will work on XP, I've set up a few servers to goof around on in XP.

Cool beans.

Thanks!

So im trying to make my own server and am stuck on the whole make the new DB thing with navicat. Everytime i right clcik i can't click create database,and my connection keeps failing,any ideas?

Well I fixed my mySQL problem,and now theres a new one.



Now open a command prompt and go to the folder that has the peqdb_RevXXXX.sql you just extracted
• run this command
o mysql -uUSERNAME -pPASSWORD PEQ < peqdb_RevXXXX.sql
o mysql -uUSERNAME -pPASSWORD PEQ < load_player.sql


Keeps saying " The system cannot find the file specified." can anyone help me out or atleast give me a 100% retard break down step by step so i can figure this out? lol

Start in CMD and change directory to where those files are stored then run mysql and those command lines.

Er, actually... split those lines...

do:

mysql -u [username] -p
enter your password
source peqdb_RevXXXX.sql;
source load_player.sql;

(Remember your semi-colons)

Well I followed 2 guides perfectly,but i cant get my server to launch im not sure what i did wrong in this mess lol had to many problems. Guess ima just give up on making one,hopefully i can find someone to make one for me lol,nice guide tho

If you find yourself getting stuck here, with Navicat, remove the single quotes from the bolded area (i.e. table name and all variable names in the first statement)

Wow. Took me a long time to notice the obvious. :wink:

Also, thank you very much for posting this. I tried to do the Linux walkthroughs, but I am a Windows Guy and don't need the extra headaches.

Now a question of my own. From here:

eqemulogin.ini was not found. I made the assumption that the plain login.ini was the file needed, but once I got to the above steps, I noticed there were changes. Now what? There is different info than the above. It looks more like this:

Suggestions on how to proceed? I, of course will check further down and put an answer here for people reading this excellent how-to.

Got a question regarding an error I ran into while trying to setup my server.

I can log in remotely and get as far as the character creation screen but when I try to enter the world I get the following errors in the log files.

The errors state:

"Client discconnected (not active in process)"

"New Client from 192.168.1.100"
"Client 'Pucr' was destroyed before reaching the connected state:"
"Client sent initial zone packet, but we never got their player info from the database."

Any ideas on where to look?

The database settings in the eqemu_config file look fine i guess

<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>xxxxx</password>
<db>peq</db>
</database>


Im running the peq database rev 1667 and the latest eqemu server

Found the solution.

I had to update the PEQ database from 1667 to 1750

You probably didn't have to do that, you just needed to apply the SQL changes that are required with the current version of the code that were newer than your database version. Updating the whole thing got you those changes, but it's a good habit to get into making sure you apply the updates regularly when you update code, because the PEQ database may not always have all of them.

I got the meat and potatos of this tutorial. I'm very close to the end of it, the only request I have is, could someone possibly post a Screenshot of the folder structure of the EQEmu folder (c:\eqemu)

Expletus, go here http://code.google.com/p/projecteqemu/downloads/list
download EQEmu-Rev1771.zip or EQEmu-Rev1771-Bots.zip then use the contents of either zip file as a template for completing your EQEmu folder.

Couple of Questions:

1. Can i just copy and paste over what I have compiled into that folder from the zip files?

2. Do I have to have a version of perl installed if I used wammp?

1) Short answer is yes. Just make sure you don't overwrite your config files or you will get to redo them.

2) What is wammp?

Sorry, was tired...

XAMPP

I have no idea what XAMPP is either. Maybe someone else can help you with that one.

You should be able to just copy and paste. But make sure you have perl 5.10. I use that to build the executables. Backup your executables first just in case. Make sure you check the sql folder for updates to your database if you already have one installed.

XAMPP -- X is a placeholder for any OS (I think), and (A)pache, (M)ysql, (P)erl, and (P)HP.

Okay, so I'm at the last part.. of course an error.

any ideas?

And another :(

Can anybody recommend another compiling program aside from Microsoft Visual C++ 2008 and 2010 Express?

I have gotten so many errors, fixed alot, but they keep on coming and I am burnt out!
(Vista 64bit, up-to-date from Windows Update. Installed all service packs for each version of MVC++ Express.)

Seems most errors went away after I tweeked a ton of crap (i got lucky). I am now having an issue with the server not showing up on my server list. I am completely lost now.

Anyone point me in the right direction?

Apparently something is wrong in my DB but i'm not sure what it is.. i've copied and pasted from the guides here...

If you open up Navicat, and then open your database from there, do you see any main tables labled 'tblWorldServerRegistration'?

Yep! I got tblloginserveraccounts, serveradminregistration, serverlisttype, and the worldserverregistration table.

Seems that was an sql error, think i worked that out. still no server on the list. get this awesome error from the world.exe window:

Okay, here's a shot in the dark, perhaps it'l help ya.... but I still haven't had my coffee yet so all my advice is suspect:

Are you planning to use the public login server or were you intending to use Eqemulogin?

I got that same error for a while as I was puttering around.. mainly because I hadn't set up a public worldserver account here. Each has to be registered, you're allowed a total of 2 world accounts and... 3? player accounts. These are completely separate from your login account to post here.

If you're trying for a private login using eqemulogin, then it gets a little more difficult... there are guides, one by 'Huffy' out there that really go into detail what needs to be changed and what needs to stay the same or blank. It's -very- particular about it, too.

I'm trying to make it work for a lan server and client on the same computer. At this point I just want something to start working :(

Ah, I see... well, hands-down easiest thing to do is to have it run through the public server. I'm sure you'll get it running, it just takes patience, a little more patience, and a grasp of how the whole thing works together. That said, it was a long time before I got my first server playable.

I couldnt find that post by "huffy"

I did check out some others, and figured i'd go with the private self server/client way.

I got it to change to "Setting world to mini login server type"

but I can't get it to connect, gives me error 10061.

Minilogin is a different method of logging in... most of the most vocal veterans around here suggest you use the Eqemulogin which is said to be superior in all ways. I've never worked with Minilogin so this is all simply hearsay.

I'm not saying that you shouldn't play around with it, get a feel for the thing as a whole by any means.

... but if you'd like to learn from the mistakes I've made? Backup everything before you change a single thing... that way once things start to click together for ya, you can look back and get a good idea of how they started.

Yea, I wish I did that, unfortunatly I went in under the environment and altered the "PATH" and doing so ruined multiple files. I just uninstalled everything and going to have to start from scratch. :(

No worries... I did much the same thing when starting up. The second time around is so much easier, believe me. ;)

Of course, I formatted and reinstalled the OS from scratch, gutted it of all the things I didn't need that time to be 100% sure there would be no registry conflicts.

The EQEmuLoginServer is a pain in the neck to get working. It seems to be more finicky about what must done than the other server types.

Huppy, did a write up on how to set it up a few months ago. Here is the link:
http://www.eqemulator.org/forums/showthread.php?t=32293

"Huppy" may be the author you are looking for.

For your Server to show up in the public list (easiest method), you need to follow the suggestion to sign up for a server account.

Ironic as it may be I had to install Xampp to get the source to compile.
At least at this point in time I have no errors and can focus on creating content and learning how to query in changes on a larger scale to speed things up.
This was a great guide to follow even if it was slightly dated. Still applies in all areas.

So I went all the way through this guide, have everything set up (or so I believe), and I'm puzzled as to how I am supposed to launch my private client EQ now. Once I created the .bat file, I went ahead and moved it to the 'EQEmu' folder since it wouldn't work anywhere else, then ran it. It popped up 3 windows which looked like they were initiating all the files and loading zones. Then I went to my client (running the server on a VM), and changed the eqhost.txt file to reflect my svr's IP:5998. I'm not sure if the shortcut still needs to have in the Target: "...eqgame.exe patchme -w", or if that was for the public servers only ? Anyway, I left it as is and tried launching it. I get up to login and tried the root and pass for mysql (the only account which was actually set up during that guide), and nothing. I also tried admin password with all variations of capitals, etc. Am I to be running a different load file or what is going on? When I try those user/pass combinations, it just tells me it's not valid. I'd love to get this at least launching soon if anyone can give me insight. Thanks!

From the guide:

INSERT INTO tblLoginServerAccounts (AccountName, AccountPassword, AccountEmail, LastLoginDate, LastIPAddress) VALUES('Admin', sha('password'), 'admin@somewhere.com', now(), '127.0.0.1');
• Edit the above statement as follows:
• After “VALUES”, edit 'Admin' and 'password' to what you would like the login information to be. Edit 127.0.0.1 to the i.p. address of the client machine you will be logging in from.

Yeah I saw that part of the guide and made the file on my desktop with the user I am attempting to utilize and pass & host IP. The account shows in the DB but when I attempt to log in it's not working out. I posted the full details of this problem on Windows Server support here: http://www.eqemulator.org/forums/showthread.php?t=32877