COMPLETE PUBLIC SERVER SETUP - Jan-2011

[Huppy]

Originally Posted by Bamzal

This link? For Zlib, go here -
http://sourceforge.net/projects/libp...l.zip/download

Just checked, same one as I previsouy had. There is NO zlib.lib file contained in that zip.

Obvously something has changed.

In the LIB directory, there is:
zdll.lib
zdll.exp
zlib.def

By the way I just went to the link I posted for the download of ZLIB.
I downloaded the zip file it points to and extracted it (TODAY) and it does
contain all the files you need. (INCLUDING the ZLIB1.dll that needs to be
copied over to the windows system folder) (ZLIB1.dll - NOT ZLIB.dll)
THIS FILE -ZLIB1.dll is right in the main extract of the zip file when you
download it. (You can see it when you open up the zip file before you even
extract it all) (I use WinRAR)
Once you extract the zlib folder to your c-drive, and copy that zlib1.dll
you don't need to do anything else with it.
When you are adding the folders to your 2008 express, keep in mind, you
are looking for FOLDER NAMES, not file names.

[lerxst2112]

Try here: http://sourceforge.net/projects/gnuw...es/zlib/1.2.3/

You'll need both the bin and lib files extracted to the same place.

You may have to fiddle with the order of the library directories to get it to work properly. MySQL also distributes zlib.lib and if they are not the same version you will have linking errors as you saw. If you put the MySQL directory above the zLib directory it should work.

[dranovir45]

Ok, when trying to do the 1711 file as shown here

So first click on the 1711 file called 1711_account_restricted_aa.sql and click Open
Then click Start. It will source that sql in to your database.

It will say this when i try

[Err] ALTER TABLE `account` ADD `time_creation` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `suspendeduntil`;
[Err] 1146 - Table 'peq.account' doesn't exist
[Err] UPDATE `account` SET `time_creation` = UNIX_TIMESTAMP() WHERE `time_creation` = 0;
[Msg] Finished - Unsuccessfully

any ideas on how to fix this?

; I saw in guide it told me to delete first 3 lines ( that was the whole file basically ) but i did it and i just get
[Msg] Finished - 0 queries executed successfully

Also; when i try anything else i get

[Err] 1146 - Table 'peq.rule_values' doesn't exist
[Err] INSERT INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'Combat:NPCBashKickStunChance', '15', 'Percent chance that a bash/kick will stun');
[Msg] Finished - Unsuccessfully

[lerxst2112]

Looks like you missed step 15 or typoed somewhere along the way.

[dranovir45]

Now lets say i did miss something (cus i did ><) is it easy fix to just do it and a fix will happens or what exactly?

[dranovir45]

Ok, i typed my IP into the internet browser ( im with AT&T ) anyone work with them that knows how to forwards ports on the page, if so plesae let me know.

[Zandig]

Compiling with MySQL Server 5.5.9 will fail as it's not supported.
I use 5.1.56 (32 bit version) which works fine.

[Bamzal]

Thank you Zandig and lerxst2112.

I now have a legit looking zlib but still running into the same errors:
"mysqlclient.lib(inflate.obj) : error LNK2005: _inflate already defined in zlib.lib(zlib1.dll)"

My thought is that MySQL is now the problem, and Zandig you just confirmed my assumption.

I will try downgrading right now and report back.

[lerxst2112]

You have no config file. The eqemu_config.xml.full is supposed to be copied to eqemu_config.xml and edited to suit your needs.

[dranovir45]

I made that change, finally made progress, then got this ...

[dranovir45]

Originally Posted by dranovir45

I made that change, finally made progress, then got this ...

Anyone know exactly what is what at this point, ive read whole guide word for word, it should "be working now" im thinking ive missed a few lil key things and hoping that message could give you guys hints on whats going on.

[Zandig]

The most up to date compile guide can always be found in the Wiki:
http://www.eqemulator.net/wiki/wikka.php?wakka=VS2008

I don't have ZLIB1.DLL in my 'windows/system32' directory and it compiles properly. I only have that file in the c:\zlib directory where it belongs.....for what it's worth.

[lerxst2112]

The issue is with the library name, not the DLL, and it has in fact been renamed for whatever reason. I've used that link many times before as well, and it was always named properly when I've downloaded it, but it has been a few months since I've done so.

Annoying, but easily fixable if necessary. Some people might not even notice the rename since MySQL also includes the library and if that directory is searched first it would choose that file to link against and not even look in the zlib directory.

[sorvani]

i find the wiki hard to use, but maybe that's just me.
Maybe the landing page for the wiki needs redone somehow to help drive things better, I dunno.

[dranovir45]

Still getting same error as posted above ; and still seeking an answer for what im supposed to do with the 7000-7100 (following bamzal's advice i made multiple files with the ports etc using from:5998 to: 5999 and making the other shit standard, along with making it 9000 to 9000 when making another TCP, UPD or w/e is different im told but what exactly then, this mean i need 7000-7100 for UPD ?