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.
complete eqlive-like faction v1.0!
Oooh Oooh whats next! 
Linear Mode
