Port Abysmal crafting quests to other zones?

[wolvenbane]

Hey all. Been searching the forum and can't find what I need - I'm hoping someone can provide a link and/or further info to help out.

I'm trying to get the Abysmal Sea "crafting freebie" quests to work in PoK. Unfortunately I don't speak Perl so it's a bit confusing. I understand that the functions are pointing to a table in the database (probably the activities table?). The SQL should be easy enough I'm just not sure which tables and what values to change/add to get the quests to work correctly outside the original zone. Oh and of course I'll have to point the Perl functions to those new entries as well (no prob once I get the data into the DB).

I'm using PEQ rev 1589. I've been using the GeorgeS quest program with basic stuff so I have a handle on the simple functions. The NPCs are all in place (quick #dbspawn/#npcspawn create copies) and functioning with the merchant lists; just the quests are broken since they point to Abysmal instead of PoK.

I appreciate any help!

[Secrets]

Originally Posted by wolvenbane

Hey all. Been searching the forum and can't find what I need - I'm hoping someone can provide a link and/or further info to help out.

I'm trying to get the Abysmal Sea "crafting freebie" quests to work in PoK. Unfortunately I don't speak Perl so it's a bit confusing. I understand that the functions are pointing to a table in the database (probably the activities table?). The SQL should be easy enough I'm just not sure which tables and what values to change/add to get the quests to work correctly outside the original zone. Oh and of course I'll have to point the Perl functions to those new entries as well (no prob once I get the data into the DB).

I'm using PEQ rev 1589. I've been using the GeorgeS quest program with basic stuff so I have a handle on the simple functions. The NPCs are all in place (quick #dbspawn/#npcspawn create copies) and functioning with the merchant lists; just the quests are broken since they point to Abysmal instead of PoK.

I appreciate any help!

Perl quests are found in the quests folder in your main server directory. This may be why they don't work in other zones. Simply copy them from the /quests/abysmal/* folder to the /quests/poknowledge/* folder

[wolvenbane]

I should have mentioned in the first post that I had already copied the relevant quests from Abysmal to PoK. (I'm not so nooby as to assume quests will work without being in the proper place.) They don't work correctly in PoK; the turn-in count is supposed to increase but it never does.

I assume parts like this (quest::istaskactivityactive(167,4) are checking the 'activities' table in the database but I'm not certain. Also, I have no idea how to create a new activity (that is: what values I should be using) and if that would even be enough to fix the quests. That's where I need help.

Do I need to create an entirely new activity in the DB and point the PoK versions to that one? If so, is that all I need to do or will I also have to add data to another table? Or could I simply copy the relevant rows of data, change a few things, and point the PoK quests to the new one?

Thanks!

[joligario]

Most likely the activities have the zone specified in the database. You can remove the zone or change the zone to PoK.

[wolvenbane]

Ah, figured it out. I didn't want to break the originals in Abysmal so I created new entries in the DB. Just did copy/paste to a couple diff tables and changed the IDs / zones. Made the perl quests reflect the new numbers and fixed!