complete eqlive-like faction v1.0!

[govtcheeze]

VERSION:
1.0

BACK UP YOUR DATABASE BEFORE APPLYING THIS PATCH!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 (http://home.gravyisgood.com/govtcheeze/faction%20v1.0.rar) 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:
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:

DELETE FROM npc_faction;
DELETE FROM npc_faction_entries;
--DELETE FROM faction_values;

INSERT INTO npc_faction VALUES ('1', 'Bonecrusher', '0'); -- NO FACTION
type: 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: mysql -f eq<factionNpcUpdate.sql and wait for it to finish. It will take many, many hours.
6) type 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.

[Xabob]

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

[vetoeq]

Govtcheeze is doing AMAZING work, props are indeed due.

[themushygod]

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 :)

[Jesusonsteroids]

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

:shock: Oooh Oooh whats next! 8)

Thanks man :)

[Gossamer]

Excellent job! Thanks for the faction!

[RangerDown]

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

[eq_addict_08]

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.

[NarutoLegacy]

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

[WildcardX]

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?

[Gossamer]

This deserves a bump!

[NarutoLegacy]

Umm read the rules buddy....

[RangerDown]

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?


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.

[Gossamer]

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

[GreatSageCorban]

Does this faction database set the guards to protecting you?

[Gossamer]

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.

[RexChaos]

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.

[govtcheeze]

File location has changed. New link is:

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

- and -

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

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

[mikenune]

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

ERROR 1062: Duplicate entry '39-209' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' -27)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 9)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' -36)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 12)' at line 1
Has anyone else gotten this? Is there anything I'm doing wrong or is this normal?

[mikenune]

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

[govtcheeze]

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 :(

[mikenune]

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:

[govtcheeze]

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

[govtcheeze]

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:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\theoden>cd c:\mysql\bin

C:\mysql\bin>mysql -f eq<newFactionList.sql

C:\mysql\bin>

Please report any errors or additions to this thread!

[vrated]

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

ERROR 1062: Duplicate entry '39-209' for key 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' -27)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 9)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' -36)' at line 1
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 12)' at line 1
Has anyone else gotten this? Is there anything I'm doing wrong or is this normal?

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

[phasepuma]

I got no errors : /

[stclairguy]

ERROR 1064 at line 73918: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73919: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73920: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73921: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73922: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73923: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73924: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14941 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73925: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73926: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73927: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73928: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73929: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73930: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73931: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73932: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73933: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73934: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73935: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73936: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73937: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73938: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73939: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73940: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73941: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73942: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73943: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73944: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73945: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73946: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73947: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73948: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73949: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73950: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73951: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73952: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73953: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73954: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73955: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73956: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73957: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73958: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73959: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73960: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73961: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73962: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73963: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73964: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14942 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73965: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73966: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73967: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73968: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73969: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73970: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73971: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73972: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73973: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73974: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73975: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73976: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73977: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73978: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73979: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73980: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73981: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73982: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73983: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73984: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73985: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73986: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73987: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73988: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73989: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73990: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73991: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73992: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73993: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73994: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73995: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73996: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73997: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73998: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 73999: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74000: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74001: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74002: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74003: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74004: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14943 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74005: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14944 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74006: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14944 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74007: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14944 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74008: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14944 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74009: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14945 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74010: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14945 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74011: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14945 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74012: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14945 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74013: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14946 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74014: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14946 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74015: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14946 WHERE npc_types.name li' at line 1

ERROR 1064 at line 74016: You have an error in your SQL syntax near ' spawn2, sp
awnentry SET npc_types.npc_faction_id = 14946 WHERE npc_types.name li' at line 1


C:\mysql\bin>


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)

[Darkwaters]

I've been following the instructions from
http://www.eqemulator.net/forums/viewtopic.php?t=15161&start=0&postdays=0&postorder =asc&highlight=&sid=fe130575efbbad3b522a595ede8c0d 4c
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

[govtcheeze]

version 1.0 released...thread is stickied, but want it to become active so people realize this

[cavedude]

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.

[Ulfast]

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.

[cavedude]

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.

[sotonin]

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

[cavedude]

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.

[govtcheeze]

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:

delete from npc_faction where id = 100000 or id = 100001

[sotonin]

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 )

[govtcheeze]

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.

[Elkay]

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.

[govtcheeze]

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

[Elkay]

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.

[zephyr325]

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

Question - if this is included in the current PEQ database download, I'm confused - the date on the downloads page (http://www.peqserver.com/view_files.php?filter=release) shows 9/18?

Or should I be grabbing the database from somewhere else?

Thanks...

[sotonin]

it's included in the classic database.

[zephyr325]

it's included in the classic database.

Cool - I'll keep using that.

Just a thought - might any changes going into the database, if it is getting updated, have anything to do with the "6.0-black-screen-after-character-create" problem? I ask as we've narrowed down (Lethal, Schoppew and I) that we don't get the error when using a barebones database, but we do when we try to use the PEQ database (and follow the steps on the DB page).

TIA...

[sotonin]

You can try the PEQ classic fix i posted on peqserver.com

We are using 6.0 on PEQ the grand creation and have 0 black screen issues.

[Cisyouc]

You can try the PEQ classic fix i posted on peqserver.com

We are using 6.0 on PEQ the grand creation and have 0 black screen issues.lil shameless plug there sotonin?

[govtcheeze]

Sounds like he is stating a fact to me, and being helpful at the same time.

Now this is a plug: USE PEQ, its the best DB publicly available

[sotonin]

shameless plug? He asked why it was screwing up. we have a fix to startzones available. how is that a plug. There's no database besides our anyways. the only other one is a db that "uses" 2 of our databases combined.

[Xothin]

Some of the mobs in Nektulos forest are not doling out their faction when killed, using the PEQ_Classic DB.

To name a couple... Missionaries of Rodcet(or any of the male versions of the Rodcet mobs), any of the Leatherfoots that spawn around the treestump, and a couple that are around the druid ring ruins.

[govtcheeze]

If you can post any of the bugs on http://peqserver.com/forums this will expidite their fixing. Please include the mobs name, zone, and which faction should be added/removed from their list.

Thanks!

[Xothin]

No problem Govt. Appreciate you letting me know where to put them. ^.^

[Maulgak]

Think this will work with the 5.9dr2 DB released by malignus on a 6.0 server?

[govtcheeze]

It will work on any server using live mobs and live items.

[Maulgak]

It will work on any server using live mobs and live items.

Nice, thanks man :)

[SiliconeClone]

looking for a working link

[RangerDown]

Download the PEQ database at www.projecteq.net for (mostly) live like faction. We do not have the individual faction update that was listed anymore, and it may not be compatible with the current database even if it was.

[SiliconeClone]

ok am using PEQ_Velious ... didn't think it had the factions in it since like places in oasis and such things are completely indifferent like the mummies and what not... what column is the column to change a mob faction to KOS to a player

[fathernitwit]

guys,

sorry to bump this ancient thread, but I am looking for this patch, anybody have it laying around?

EDIT: got it. Thanks cavedude.

[snowyiet]

Is this safe for a 0.6.4 database? im just asking since this was posted 2004.

[cavedude]

Yes it is safe. I still use it to this day on my 0.6.6 database.

[Smedy]

i need this thing! please could someone who has this contact me, either here by pm, or on irc.eqemulator.net #legacyofzek (my name is dke) thanks alot!

[Smedy]

this didnt work for my 0.6.6 :/

cant boot zones now, luckly i backuped my db, also explorer tells me the code to install this would be mysql -f eq&lt;sqlfilename.sql but &lt; is false, the code you need is mysql -f < sqlfilename.sql

didnt work for me, i got LOADS of error though, not sure whats wrong..

Trying a different way now, just mysql -u root , use databasename; and source sqlfilename.sql in your order.

Ive ignored the errors but on the factionNpcUpdate.sql i get every single row like this : ERROR 1064: You have an error in your SQL syntax near ' spawn2, spawnentry SET n
pc_types.npc_faction_id = 18799 WHERE npc_types.name li' at line 1

the 18799 is a changing number that begins with 1 and ends with 18799..

[Smedy]

somthing is wrong in kos.sql,

sourcing the other files seems to work, with LOADS of errors though (everyline in factionpcupdate.sql gives me a error)

never the less, when sourcing kos.sql everything goes wrong, it says some rows are affected okey, but when i try to boot my server after sourcing kos.sql my zones wont boot.

if i try before i source kos.sql the zones work.

NM, just saw cavedudes post about this!

[Smedy]

so it worked to source this now, but factions are wrong, im running around as a gnome in oggok with indiff faction, and also indiff to my akanon gnomes, also indiff to hole so im guessing it dosnt work so good with 0.6.6 or im doing somthing wrong, who knows :)

[Sourdough35]

Will this faction file work with the current PEQ and eme 7.xxx? It sounds like a great piece of work that should be included in the project. So much so that when I asked about Faction and kOS settings on the PEQ forums, I was referred to this post. Is this guy's work still usable with current versions?