Coming Soon to DOL: Factions!!

[WisdomConners]

Will DOL ever implement factions with mobs as Mythic did where if you kill one races enemy mobs you gain faction and loose faction if you kill that race? I ask this because there's a certain village in Alb SI, probably in Mid and Hib as well, where there are NPC Merchants who are currently set to aggressive because all mobs in that village are set to aggressive.

[Dinberg]

It's already in. Try the /faction commands, and you should find you get some luck!

[Etaew]

Code support exists, but no-one has filled the database, same with areas, i.e. You have entered xxx.

[WisdomConners]

LOL! Between those two answers I'm not sure if I got a yes or a no.

[Roozzz]

It is a yes.

But in order for it to work the factions have to be defined in the database and nobody has gotten arround to do that. So it is possible on DOL, but you will need to do some db work for it.

[Overdriven]

We need somebody to actually do it. Feel free to start on it, there's like absolutely nothing done on it so far. So anything you do, will be a plus.

[WisdomConners]

I don't mind trying but someone will need to kick start me with a few things like what's the name of the DB that I need to edit, and where do I find the data for filling the DB with? I'm a newb to database stuff. I barely have the DOL server working on my own network right now. Links to tutorial's and where to find the data for the database would definately motivate me to try my hand at it.

[Etaew]

There are 4 tables that are used within this system.

Faction, FactionAggroLevel, LinkedFaction and Mob

Faction

This table is used to store the faction details, it contains the following fields.

ID - This a number representing the faction
Name - This is the name of the faction
BaseAggroLevel - This is the aggro level that players default as

FactionAggroLevel

This table is used to store players faction aggro levels, it contains the following fields.

CharacterID - This is the character ID
FactionID - This is the faction ID from the above table
AggroLevel - This is the current players aggro level to the faction

LinkedFaction

This table links factions together, such as killing a faction that has enemies will raise reputation with that faction, it contains the following fields.

FactionID - The ID of the faction
LinkedFactionID - The ID of the friend or enemy faction
Friend - 0 or 1 if the faction is a friend or enemy.

Mob

This table then sets the faction for individual mobs using the FactionID field.

This is how I presume it works, just looking at the code briefly now.

1) Your first task I imagine would be to fill out the Faction table with all factions in the game.
2) Your second task I imagine would be to fill out the LinkedFaction table with the relations between factions.
3) Your third task I imagine would be to fill out each mobs faction ID with their associated faction.

But this might not be the best order.

I'm not quite sure where you would get this information either.

[Ravaella]

http://camelot.allakhazam.com/db/factionlist.html has a good list of factions, and mobs you can kill to raise or lower the faction.

[WisdomConners]

Yeah I looked at that list. It's not as helpful as you'd imagine not having the ID numbers and such for each faction. I'm definitely starting to see why it's not done yet.

[Etaew]

ID numbers for factions are something only we would use, you don't need them.

If you create the faction table, the numbers you fill them with will be what we use, so that list seems quite a good resource for names and lower / gain etc.

[WisdomConners]

Ahhh... Ok then, I'll see what I can do about filling in those databases on my network test server and get back to you when I think I'm done so you can look at the work. Obviously being a newb, this will take a while but I'm enjoying learning new things.

[WisdomConners]

Question: What should BaseAgroLevel start out at? IE: What's the range of numbers used for this field? +/- 100? 500? I'm starting to fill in my faction table from that list and don't want to screw up the BaseAgroLevels too much.

IE: BaseAgroLevel 0=Neutral +1 - +100=Friendly -1 - -100=Agressive?

Right now I'm just filling up the DB list with the names and assigning ID numbers with everything getting a BaseAgroLevel of 100 since I'm clueless on how much that should be.

[WisdomConners]

Ok so I've completely filled out my FactionDB from the names on that list. Currently every single mob is set to a baseAgroLevel of 100 since I'm not sure what else to put there for now.

[Etaew]

0 is friendly, 100 is agressive i think, i'm not sure where you can get information about whether a faction hates you or not to start with