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.
