Proposition for More Races on Faction table to allow more Illusion mods

[cavedude]

I agree with this, and I know KLS does too. The table needs to be changed so it isn't so static. That would require code changes, though more than just adding support for the new columns.

[ChaosSlayerZ]

That awesome to hear Cavedude

Consider this:

I talked to my friend who is an sql coder, and he looked at the table, and sugested a diffirent way of implementing it.
essentialy he offers to scrap the curent table and replace it with a following simpler structure.

rather than go:
Race1 race2 race 3
Faction 1 +5 +5 +7
Faction 2 +15 +25 +7

etc

he proposes to go like this:


Faction column - Race coulm
(ID of faction 1) - (ID of race/deyty/class 1)
(ID of faction 1) - (ID of race/deyty/class 2)
(ID of faction 1) - (ID of race/deyty/class 3)
(ID of faction 2) - (ID of race/deyty/class 1)
(ID of faction 2) - (ID of race/deyty/class 2)
(ID of faction 2) - (ID of race/deyty/class 3)



this will automaticly allow addition of ANy ammount of extra races
AND it will save Db space since in MANy cases faction relation to any class, or race is ZERO (0), and all thode zeros are still stored. (just think of TONS of KOS npc faction who never change faction regadless of your race, class or deyty, yet you still store 0 for them)

By switching to new system - you won't need to store any 0s. you will ONLY put in values that carry faction modifier (negative or positive)

and as far as I can tell faction table is 80% zeros

[pfyon]

I think that the tables are like that because they're old, and no one's bothered to fix them up since it would require somewhat of an overhaul of code and tables.

I agree, the current design for many of the tables isn't great.

[Expletus]

*bump*

Has any progress been made towards this? This would be awesome and open up a whole theme park of quests