COMPLETE PUBLIC SERVER SETUP - Jan-2011

[werebat]

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.

[Malpercio]

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

[lerxst2112]

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

[Malpercio]

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

[joligario]

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.

[Malpercio]

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

[werebat]

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

[Malpercio]

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.
¯\_(ツ)_/¯

[lerxst2112]

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

[helman]

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.

[Valdis01]

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?

[lerxst2112]

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.

[Valdis01]

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.

[Oaric]

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?

[lerxst2112]

Originally Posted by Oaric

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.