COMPLETE PUBLIC SERVER SETUP - Jan-2011

[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