Thread: Server problems
View Single Post
  #24  
Old 06-21-2006, 04:51 PM
Zandig's Avatar
Zandig
Hill Giant
 
Join Date: Jun 2006
Location: New York City
Posts: 180
Default

If you are updating from Server Pack 3.52 to the latest build you must follow the changelogs: http://www.eqemulator.net/releases/l...-0.7.0-804.txt
and make the appropriate adjustments to your database.

So to update to the newest release: 0.7.0-804 (which is the newest as of this post) you must run these lines into your database:

Code:
ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;

ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0';

alter table account DROP packencrypt;
alter table character_ change extprofile extprofile blob NULL;
alter table player_corpses change data data blob NULL;
alter table player_corpses_backup change data data blob NULL;
I'm using the PEQ database (works with Cavedude's as well) and it works great. If I didn't do exactly as I stated above it would not work properly and say the zone is unavailable. Trust me I've already found out

I also find that using MySQL Control Center is easiest for making database modifications. Load the control center, select your database, select the SQL/Query button, copy and paste the code and then execute the query.
Reply With Quote