Perl/Quest Questions

[tkd1991a]

Also can you guys tell me do most of the classic quests work? I've never had one work yet and I'm curious can I get the Greenmist sword for my Iksar Shadowknight or the epic quest for my warrior??/

[Belfedia]

if i'm remember good, no epic quest works.
But you can ask to a Peq-Quest member for more informations (http://www.projecteq.net).
Or make this yourself for the community ?

[HurtinuDaily]

Crap sorry, cant believe I didnt think of the zone pearl thing..... I didnt have to change it cause I was using the boot5zones.bat from jim0thy's 6.2 compile which already had zonepearl.exe in it.

[tkd1991a]

I'm hoping that will explain the whole npc loading error thing as well

[HurtinuDaily]

What npc loading error? if its not loading npc's I know that fix for sure! post back if its not loading npc's at all and saying something about invalid something 'str'.

[tkd1991a]

yep that is the problem exactly

[HurtinuDaily]

ok you have to make your database compatable with the latest exe's
open the command prompt and start up your mysql with you username and password you used when creating it.

use db eq - if this is the name of the db you created.
and source this code in: ( i got it from http://www.projecteq.net/phpBB2/viewtopic.php?t=308)


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';

UPDATE npc_types SET _INT=80 WHERE _INT=75;
UPDATE npc_types SET _INT=60 WHERE _INT=80 AND ( bodytype=3 OR bodytype=


and your mobs will spawn.

[tkd1991a]

alright did that and that helped to get the mobs spawned.

I'm still having a problem with the quests and it showed an error message when it perl started to run and said something about reverting back to the original quest. I'll probably have to wait till after the weekend so I can copy the error down and post it up.