Anyone have this fixedz problem?

[solid11]

Hey all,

Just thought I would run this past anyone and see if there was a fix. I reinstalled 6.3DR1 with velious RC1 and ran the fix from FNW that corrected the unknown STR error to load NPCs. Well it removed the field Fixedz in the DB but when loading up it still says unknown Fixedz when trying to load NPCs for that zone. Why would it have the error if the field was takin out? Thanks guys.

[fathernitwit]

you running from cvs or the crappy zip on sourceforge?

fixedz does not appear anywhere in my source code...

[solid11]

I use the file from the wiki.

http://www.eqemulator.net/wiki/wikka.php?wakka=Windows6

problem is it has that error loading NPCs from only RC1 and not cavedude's DB. I tried 6.3DR1 and 6.2 on that link from above. Even though the fixedz field has been successfully deleted from the DB it still says unknown Fixedz field error during loading of NPCs.

[Belfedia]

Last cvs is here : http://eqfroggy.ath.cx/download/EQEmuCVS-12-09-2005.rar
I don't know how compil it on windows.

[1Boppoom1]

run this query

ALTER TABLE ground_spawns ADD temp_x float NOT NULL; 
UPDATE ground_spawns SET temp_x=min_x; 
UPDATE ground_spawns SET min_x=min_y; 
UPDATE ground_spawns SET min_y=temp_x; 
UPDATE ground_spawns SET temp_x=max_x; 
UPDATE ground_spawns SET max_x=max_y; 
UPDATE ground_spawns SET max_y=temp_x; 
ALTER TABLE ground_spawns DROP temp_x; 
ALTER TABLE object ADD temp_x float NOT NULL; 
UPDATE object SET temp_x=xpos; 
UPDATE object SET xpos=ypos; 
UPDATE object SET ypos=temp_x; 
ALTER TABLE object DROP temp_x; 
ALTER TABLE npc_types ADD STR MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD STA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD DEX MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD AGI MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD _INT MEDIUMINT UNSIGNED NOT NULL DEFAULT '80'; 
ALTER TABLE npc_types ADD WIS MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD CHA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types DROP fixedz; 
ALTER TABLE npc_types ADD fixedz float DEFAULT '0'; 
ALTER TABLE zone_points DROP keep_x; 
ALTER TABLE zone_points DROP keep_y;

This will fix all your NPC errors...... Post if it works if so

Fix is a curtesy from http://support.eqemulogin.net

[solid11]

If that was the fix that FNW posted then I tried that, if not then I will give it a try. I noticed that one doens't have you drop pets. Does it matter if you don't and not resource the pets.sql? Thanks.