Looking for someone to help identify and set up our Factions tables (factions and faction_alliances). Since we're venturing out into more areas than the Qeynos and Freeport zones, many other factions have yet to be identified. This can be in the form of a simple common-delimited list, excel spreadsheet, or even a web page showing every possible faction in the game.

Along with these we need the defaults for races/classes (are DE's hated in Qeynos, etc), and if known, the amount of pos/neg change when that faction is effected. Ie., you kill a Centaur in Thundering Steppes, you take a faction hit with The Great Herd. How much of a hit? Likewise, you kill that centaur and the Sabertooth Gnolls like you more. So how much more?

Example:

You have killed an Amazon archer.
Your faction standing with The Steppes Settlers got better.
Your faction standing with The Great Herd could not possibly get any worse.
Your faction standing with The Sabertooth Gnolls got better.

If you do not know the pos/neg defaults, you can leave them at 0 for now, as this is secondary to at least setting up the faction names in our DB.

Here's our current factions list as we know it today:

Scowls (KOS)
Threatening
Dubious
Apprehensive
Indifferent
Amiably
Kindly
Warmly
Ally
The City of Qeynos
The City of Freeport
The Coalition of Tradesfolke
The Freeport Militia
The Seafury Buccaneers
The Academy of Arcane Science
The Dismal Rage
The Kromise
The Order of the Blade
The Guardians of Thyr
The Court of the Master Djinn
The Steppes Settlers
The Great Herd
The Seamist Faeries
The Enchanted Reapers
The Guardians of the Vale
The Runnyeye Goblins
The Dervish Cutthroats
The Far Seas Trading Company
The Greenhoods
The Deathfist Orcs
The Bloodskull Orcs
The Ree Orcs
The Sabertooth Gnolls
The Evol Ew Lizardmen
The Tae Ew Lizardmen
The Thexians
The Asilian Fairies
The Sullian Fairies
The Aravu Naga
The Kaentrik Bards
The Court of the Blades
The Court of Truth
The Court of the Coin
Maj'Dul Citizens
The Rujarkian Orcs
Exile
The City of Kelethin
The City of Neriak

Is this everything in EQ2?

Thanks

There are more factions here.
But I do think that there are more since RoK & TSO came out.

Here is a start Factionlist has 199 factions so far however it is just that a list not much use but it is a start. I combined your list + a few from other sources

That is indeed a good start. I will add the names to our factions table.

Any resources out there for how much of a faction adjustment you get depending on helping or opposing a faction? I think we default ours to +75 pts to aide and -100 pts to oppose currently. If anyone is brave enough to poke through a mob death packet, maybe it will show where we can fetch the amounts in there.

Two last things we'll need is 1) what are all races/classes by default - neutral, hated, loved etc... and 2) what factions oppose one another.

How much faction you gain or lose by killing a mob or doing a quest varies but it seems to be dependent on the lvl of the quest or mob so maybe we can just create a scale based on level if we can't get that by any other means.

all races/classes are indifferent to all cities until you go to freeport or qeynos i believe thats when your faction gets adjusted to what it should be. I can get this info in more detail. I will make a few new chars and report on that. I will try to get that done tomorrow

I don't know why I remember this, but I definitely remember gaining/losing faction 100 points at a time for killing things. Quests are a different story though; don't know if they're manually done or what.

Well quests actually tell you how much you gain or lose when you are offered the quest, so that's not a problem. We just need to figure out how much is gained or lost from killing mobs or anything else.

Playing in kunark and grinding a lot of faction there it was -100 and +25, again I only ever paid attention to this in kunark not sure if it is the same on other lands, this was also constant, my level never had an impact on it.

The list that was posted from EQ2 Wikia is a good list but at minimum it is missing all the RoK and All of the TSO factions.

OK, excellent into. Keep it coming. I will assume -100 and +25 for now, and we can always change it. I will try to remember to look at my newbie character next time I log in to see what it's factions are by "default".

I'm sure not every one of these factions is listed in the client P:ersona menu, right? Or is it once you alter it from default, maybe the client shows it? I'll have to check that out.

I always thought it was an even 100 +/- for factions. Maybe I was wrong, or maybe it's for the old factions :/...

The base faction info is in the DB now, totalling 199 factions (+3 I created for emu only). I'd like to get the faction descriptions updated as we come across them, and verify the default levels and +/- adjustments.

Thanks for the info. Any more, let me know.

John Adams wrote:OK, excellent into. Keep it coming. I will assume -100 and +25 for now ...

Last time I closely watched faction gains/losses it was +25/-100, but of note, this was in RoK zones. Don't know if it applies to all factions.

Zcoretri wrote:

John Adams wrote:OK, excellent into. Keep it coming. I will assume -100 and +25 for now ...

Last time I closely watched faction gains/losses it was +25/-100, but of note, this was in RoK zones. Don't know if it applies to all factions.

Same for TSO factions

OK Starting Factions are a little odd. If you start in Qeynos or Freeport you start on the isle and your faction with the other cities start out as one thing then they change pretty massively after you talk to the captain and he ships you off to your city
you receive a handbook and faction change. I thought this was a quest step that got put in your journal and then deleted but no does not have a quest packet around those steps.

So what I did was log in with a few chars in each city and took note of the faction and built a starting_faction table. no matter the class/race for each city it was the same faction. with freeport and qeynos while on the isle you do not have any faction with your main city but you do with others. the other cities however you start with all your faction for all the cities out of the gate. I have 5 of the 6 cities do not have exile yet.

Here are some csv files of all this data if you want to play with it. The starting_faction.csv file contains all of the other csv files except freeport and qeynos's city area.

i put this in there in case they were needed but did not put them into the main file since you dont get it when you start you get that when you leave the isle. however the isle one for both of those cities i did put into the starting_faction.csv

I added in my factions.csv file it is a dump of my factions table. it currently has 86 factions in it please add to this if you can. atm there is no default_level for any of them because I have not thought of a good way to get this data. Some of the factions are so dependent on different variables. the best way I think to get most of these is to engage these factions with a brand new char. Only problem with that is I am not sure if you have to kill a mob and get faction with them before it puts it in the table or will being killed by them be enough. If the latter it will not be too hard just will take sometime.

edit: added a -loadfactions fuction you can use that to load the factions from raw to your database

A easy way to check if you have any new factions that is not in that csv file is to source it to your faction table uncheck everything after description when you do this the other fields will be auto done as the data comes in.

After that you should have all these factions in your table. Get a new log from the game with your faction data in it.. All that is needed to do is log in and just open your faction window then you can log out. take that log for this next part it requires you having the sql for the raw_faction table or create your own.

Then using the parser -factions logfile. after that go to your sql client i use heidi for example and use a sql query like this
[code]
select faction_id, name, category, description from database.raw_factions where faction_id not in (select id from database.factions);
[/code]

where database is use your corresponding databases can be separate ones.
that will give you a dump of what is not in the faction table that you have just parsed. insert that into the faction table. the way that is easiest for me is I export the output to a csv then go to the table i want the data in and import it unchecking whatever column i don't have in that csv file. and then export the faction table out to a csv and you should have rights to put it in that folder date it please so that we know it is new or put it on svn.

I know that is a noobish way of doing it and I have not put in a load function yet for it because I do not know of a good way of doing it atm.

you can also just get me the logs of you logging in and opening up your faction window. and i can pull this info off. I should have most factions up to the middle of eof so anything after that I need for sure. we do have this data gotten another way but that list lacks descriptions.