complete eqlive-like faction v1.0!
 

VERSION:
1.0

BACK UP YOUR DATABASE BEFORE APPLYING THIS PATCH! where (username) = your mySQL username, and (database) = your eqemu database

PURPOSE:
This code will add a complete faction system to eqemu. You lose faction at 3x the rate you gain it. Tested on PEQ's database, but this script (like all that I release) should work with any eqemu server that uses the same table definitions.

Version 1.0 has a lot more accurate data than the previous 0.1 version, and the plan is that you will not have to wipe your faction tables to use any updates I release in the future. This means you can modify your faction table and source in my updates w/o losing any work :) Faction is no longer gained and lost based on a mob's level...that was a stupid idea and is fixed.

If you plan on running the PEQ released databases, all of my work will be included in those releases. IE, you do not need to apply this patch to the classic DB once released by PEQ.

KNOWN ISSUES:
1) Some KOS mobs are not...please let me know which ones need to be KOS and as much info as possible.

HOW TO INSTALL:
1) download this file and extract it to your mysql\bin directory
2) at the dos prompt, browse to the mysql\bin directory
3) type the following, assuming your database name is eq:
and wait for it to finish (should be fairly fast)
4) -- IMPORTANT --

If you are using my v0.1 update AND HAVE NOT ADDED ANY NEW FACTIONS to your database, comment out the third line with 2 minuses. This will allow your players to keep their current faction work. It should look like this:

type: and wait for it to finish, should be fairly fast and ignore any errors.
5) right before you leave for work/school, or go to bed, type in the following: and wait for it to finish. It will take many, many hours.
6) type and wait for it to finish (should be very fast)
7) Enjoy your faction!

Post all questions and bugs on http://peqserver.com/forums/ in the database bugs forum.

Please, help me make this better. I need people to post any and all faction related problems in this thread. This includes mobs giving the wrong faction hits, mobs responding to the wrong faction, and MOST importantly getting the right mobs on KOS. I have not played live in forever, so I am not too familiar with who should be on what. Please include not only the problem, but the solution if you know which faction needs to be changed to, etc.

OK thats it this guy deserves some god damn fucking butts i mean this is great frist a almost complete loot table then the same with fraction come on guys just a few butts

Govtcheeze is doing AMAZING work, props are indeed due.

holy crap where do you keep pulling this work from

im impressed and will be adding it to my db tonight

seriously well done on all you recent work

peace


btw what can we expect next couse i cant wait :)

OMG!
 

Omg man! Great job with the faction I am VERY VERY impressed!

:shock: Oooh Oooh whats next! 8)

Thanks man :)

Excellent job! Thanks for the faction!

Just in the last couple days have I had time to source the factions in. You did a terrific job!

I was wondering, if there any practical way to set factions up so that they are similar to the fields that tells what classes/races can use an item? I know there are many more factions ingame than classes and races, so would not be as easily implimented. But, you could have several factions associated with a mob, not just one.

This is great man! Thanks alot! Again with the amazing shit!

i'm doing a little DB work on factions and I'm confused about how the tables "npc_faction" and "npc_faction_entries" relate.. what field is the "key" that ties these 2 tables together?

Also, what field is the actual faction value that determines how a mob will con to a player? is it in the "primaryfaction" field? or the "value" field?

This deserves a bump!

Umm read the rules buddy....

The tables are linked by npc_faction.id=npc_faction_entries.npc_faction_id

You're correct, the 'primaryfaction' field determines how a mob cons to a player.

The npc_faction_entries table serves two purposes: 1) a list of faction hits the player will take when killing a mob of that faction ID, and 2) determines which mobs hate each other and which mobs like each other.
If you would take a positive hit for Faction A by killing Mob B, then Faction A hates Mob B and will kill it. If you would take a negative hit for Faction A for killing Mob B, then Faction A likes Mob B and will assist it in combat.

Oops Naruto, Im on so many forums I brainfarted, sorry bout that. I know better.

Does this faction database set the guards to protecting you?

Corban, no. It just puts the faction tables in to your database. You will then either have to start killing to lower/raise factions, or edit your database yourself. As far as guards helping out, I have not seen this working yet either.

To get the guards working you need to adjust racial modifiers for them or put them on an opposing faction to have them attack.

File location has changed. New link is:

http://govtcheeze.eqemulator.net/download/faction.rar

- and -

http://govtcheeze.eqemulator.net/dow...action_log.rar

You can always browse to http://govtcheeze.eqemulator.net/download/ for a list of all files I have released.

When I source the second file (add_factions.sql), I get the following errors:

Has anyone else gotten this? Is there anything I'm doing wrong or is this normal?

Well, since nobody's answered, I'm going to assume those errors are normal. . .

I didn't see this post before. The top error is normal, but the rest are not. I have never gotten the errors when sourcing, and I did not hear any reports of people getting those errors either. Since I know the SQL statements are good, I really do not know what the fix would be for you :(

Yeah, I was afraid you would say that. . .

The interesting thing is that MySQL is reporting all the errors as happening on line 1. I've looked at the file and, well, the earliest line where I find any of the text reported in the errors is around line 20 or so. . . :?

I'll try re-downloading and sourcing that copy later today and see if it's still happening.

Although, if it's already included in the new TCSMyWorld release, then I probably won't need it. :roll:

Yea it is (with some base factions added by TCS!), guess I should have mentioned that earlier :)

Updated faction_list is available, making many of the mobs non-beta neutral:

browse to http://govtcheeze.eqemulator.net/download/ and get the newFactionList.rar file.

This includes all faction entries from MW_055_alpha2.

Extract it to mysql\bin and source it. This is how my session looked:

Please report any errors or additions to this thread!

I have this exact problem also. I am using MySql 4.0.18 (Linux).

I got no errors : /

Error
 

I keep getting this error whenever i try and source new_faction_update.sql. Any ideas and fixes? (Btw, i also get this error with the npc_types_update.sql too)

yeah i know what your error is about
 

I've been following the instructions from
http://www.eqemulator.net/forums/vie...2a595ede8c0d4c
hope this helps.
You need to source in the following order
source (db.sql or MW_057DR2_alpha_1.sql depending on which db you decided to use)
source newdumpeditems.sql;
RENAME TABLE items TO items_;
RENAME TABLE items_new TO items;
source itemtablechanges.sql; <----- (in the source folder of the 7/31/2004 source)
source loot_update.sql;
source npc_types_update.sql;
source factionsList.sql;
source add_factions.sql;
source npc_faction_update.sql;
source newFactionList.sql;

If you do not source itemtablechanges.sql prior to loot_update.sql and all that follows in the instructions your gonna be hosed no matter what you do.
Darkwaters
Soulfood_Takeout

animal_not_KOS gets sourced in as ID 100001 That means you need set MMF_MAX_NPCFactionList_ID to 100001 or higher in NPCFactionLists.h and re-compile. Its set at 50000 by default. You might want to lower the ID before people start wondering why Zone is crying.

You have to set the MMF_MAX_NPCFactionList_ID higher then the highest id you have in the npc_faction table.

I set my MMF_MAX_NPCFactionList_ID to 101000 and it works fine by me.

LOL... I jusat said that ;) I was just letting him know he may wanna lower that number. Seems kinda silly to have those 2 up in the 100k range consdiering the other factions end at 19k.

they were put up there so they wouldnt ever interfere with the others that wil be added as time goes on in future updates

Yes that I realize and agree with. However, my point of view is that those last 2 factions could have been 49998 and 49999. That would have prevented the need for a re-compile. Emu is probably one of the easest compiles around, however my experiences have taught me to not re-compile when you don't have to. Also, when you think that Gov has merged most of the factions in Live into that databse and they end at around 19k entries, it is unlikely that will ever even get close to 100k, or even 50k for that matter. I know this is a stupid little point but I just like to keep things simple.

Anyway I just played around for a bit with the new factions and I have to say you impressed me once again. Our databases are beginning to look more and more like Live everyday and your faction and loot tables are a big reason for that.

That is a good point about the faction and recompiling...

For anyone who hasn't sourced this yet, change any instance of 100000 to 49999 in kos.sql and 100001 to 49998 (simple search and replace will work).

I will update the sql and upload a new rar file :)

If you have sourced this in and want to change it, simply do the above and source it in, and be sure to:

I think this update is a bit off. I got it to work without modifying source. You only have to change about 10 entries. Thats how many have 10 or more faction hits. They were all except 1 related to orcs as well. Which makes me think the faction update is a bit wonky. NO orc on live has 10 faction hits. what i am thinking is it perhaps merged the crushbone and deathfist factions together onto every orc.. may be wrong though, not sure exactly. Anyways i deleted the bottom faction hit off each of those 10 factions and it doesnt complain )

Damnit I forgot to fix that before releasing this. Yes, eqmaps did not differenciate between gbay and commons orcs, so they have all factions. I will post a sql fix for it.

Can't get to the downloads for the faction updates. Just a heads up and hoping it's temporary because I haven't downloaded them yet.

Its back up, but if you are using the PEQ DB you do NOT need to use these files...they are already included.

Ah cool thanks. I was using a non-PEQ db but I've had so many problems with it that I'm starting over with a fresh PEQ db and importing what I've done into that.