A real world example working with factions
Hey there,
I just successfully fixed a faction problem that I ran into with my Paladin doing the armor of ro quests. Before I go any further I want to once again express my gratitude to the IMMENSE amount of work that has happened here. What I learned about factions today once again increases my awe for the people who have dug into this project.
OK here's the Issue:
Part of the Armor of Ro Quests is turning fairy dusts into Priestess Ghalea in Kaladim. Well the Priestess is on Clerics of Underfoot Faction, and one good way to improve her faction is to give Bone Chips to Gunlok Jure. So I turned in a bunch of chips (summoned due to testing) but go no where. So I did some digging around the database here is what I found.
The following was all done using NaviCat for Mysql, it is assumed you know how to get this tool working...
Open Navicat and open your database, (I use ax_classic) The first table you need to look at is FACTION_LIST
1. Faction_list contains what I'll call for lack of better term, the primary faction groups, with a whole crapload of 'mods' which I've yet undertaken. Anyway open up the faction table and notice that "ID" column is all numerical and in this case Clerics of Underfoot are 44. Ok that is really important to know. So jot that down.
2. Now open up NPC_FACTION, I did a name sort until I found Priestess Ghalea. Now alterately, and faster you could use George NPC editor and get this information. However you'll notice her FACTION_ID is 2792. That is her personal faction identifier, if you go one column to the right in PRIMARY_FACTION you'll notice this value is zero. She has no link to a primary faction group.
3. So now let's get the priestess fixed. In the NPC_FACTION table, ID 2792 change the primary faction to 44. Now Ghalea is officially tied to the Clerics of Underfoot.
ASSUMPTION: Every NPC needs to have a primary_faction associated with it if you actually plan to align them in the faction system. Even if the Primary faction is actually just the invidual NPC. The reason I assume this is because of the further testing that I did:
4. Now to fix the bone chip quest, Open your EQEMU folder and then open the quests folder. Browse to folder KaladimB and location Gunlok_Jure.pl. Open that in a text editor and add the line that I've made red for this example
sub EVENT_ITEM {
if($itemcount{13073} > 0 && $itemcount{13073} < 4 ){
quest::say("I called for the remains of four skeletons.");
} elsif($itemcount{13073} == 4){
quest::say("You have done well. We thank you for your deed with this humble reward. The power behind the raising of our dead shall soon be found. You will earn more respect with more bone chips. I only wish you could assist in the return of the [remains of Cromil].");
quest::summonitem("2116");
quest::givecash("7","10","0","0");
quest::faction("10803","1");
quest::faction("44","5");
Now I'm a bit generous in this example, for every 4 bone chips you hand to Gunlok he will increase your faction with the Clerics of Underfoot 5 points.
NOTE: If you see a faction message about your faction improving with "somenumber" that means that there is no primary_faction associated because if it was, as we've seen in the last example, when you get the faction message you will get the value of the "name" column in faction_list rather than some obscure number.
Shortcut, ok you want to fix this fast? Here's a quick fix, Do step 2 above, that gives Ghalea an association. Then open up the Faction_Values table, this tracks the Player's Factions, find you characterid and either insert or edit the row for faction 44. So now my faction_value table, has a row:0 129 (my char_id with 44 as the faction_id and 126(slightly into amiable) in the current_value.
I wanted to post this as much for me to find it later, as hoping it helps others.
Laxa
|
Threaded Mode
