EQEmulator Forums - complete eqlive-like faction v1.0!

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - complete eqlive-like faction v1.0! (https://www.eqemulator.org/forums/showthread.php?t=13038)

complete eqlive-like faction v1.0!

VERSION:
1.0

BACK UP YOUR DATABASE BEFORE APPLYING THIS PATCH!

Code:

mysqldump -u(username) -p (database) > DBBackup.sql

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:

Code:

mysql -f eq<faction_listUpdate.sql

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:

Code:

DELETE FROM npc_faction;

DELETE FROM npc_faction_entries;

--DELETE FROM faction_values;



INSERT INTO npc_faction VALUES ('1', 'Bonecrusher', '0'); -- NO FACTION

type:

Code:

mysql -f eq<factionTablesUpdate.sql

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:

Code:

mysql -f eq<factionNpcUpdate.sql

and wait for it to finish. It will take many, many hours.
6) type

Code:

mysql -f eq<kos.sql

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 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....

Quote:

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?