Make sure you have the VC++ directories in the exact order as shown in the guide. If you are using XP 32 bit then you can use the programs I listed above, I know that combination works.

The problem is that it's looking for, but not finding, a file called zlib.lib (which makes perfect sense, as that file doesn't exist, and isn't supposed to, as it's not in either 1.2.3 or 1.2.5)
Example build log, using world specifically: http://dl.dropbox.com/u/9192467/BuildLog.htm

Change the projects to link zdll.lib, or rename the file.

http://dl.dropbox.com/u/9192467/BuildLog.htm Same general problem, different specific error.

Are you using MySQL 5.5 lib/includes to compile? You should be able to get 5.1 folders for the compile while still running 5.5.

no, I'm using MySQL 5.1 (the full complete pack, not just essentials) and ActivePerl 5.10 build 1007, VC++ 2008 express edition.

You should not have to rename the file. My is zlib1.dll and works perfectly. Make sure a copy of it is in the system32 directory. I am usng zlib125-dll.zip from the zlib site. www.zlib.net

Okay, I have no explanation for this whatsoever, but renaming the file back to zdll.lib fixed everything.
Originally, it failed looking for zlib.lib
Then, giving it a zlib.lib to find caused collisons and broke stuff.
Then, giving it zdll.lib back somehow worked.
¯\_(ツ)_/¯

Because it's finding zlib.lib in your mysql directory.

I don't know if this has been said and i don't want to look through 18 pages to see. But instead of WinRAR how about 7zip? Its free and can open ever thing. Just a suggestion.

Hey guys, I had a quick question, so when doing the said updates using Navicat, the current DB that's out (As of... 10:25 PST January, 08 -2012) is, peqdb_rev2092... So, when opening the command prompt, and type 'source peqdb_rev2092.sql - it goes through all of it's files (Records, Query's etc) all of it's okay, gives me NO errors, at all... same with source load_player.sql (No errors) as well as the bots....

But then I get to the next part, where I have to update them through Navi, Since the PEQ DB is 2092... Wouldn't I need a higher one then 1711? At least, I thought that, but since the highest one there is 2087, I just clicked 1711 anyway... It gave me this,

[Err] 1060 - Duplicate column name 'account_time_required'
[Err] ALTER TABLE `altadv_vars` ADD `account_time_required` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `clientver`;
ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I followed the guide to a T, went over it 30 times + to make sure everything was right... and I got nothing... Help?

You only apply updates newer than your database version, so unless there are updates named 2093+ then you don't need to apply any.

Keep in mind this guide was written a long time ago, so you may have to use some common sense about a few things, like the updates.

I just realized that when I read on further and actually READ what the hell it said... That there was a duplicate detected, there for, the DB already had it made, my apologies, it's like, 2 AM, and I'm a bit tired... Heh, THANKS FOR THE GUIDE IT WORKS WONDERS! Now to edit everything =)..

By the way, Solo progression server (2 bots allowed and 2 box total) is up. =) Come have some fun.

idk why but i just can't get my server to work. Every time i try to do the build after clean solution it always ends up with 4 fails. Any ideas?

Without any information on why it fails, like the actual error messages, no we have no ideas.