soemmore info.
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 followign simpler structure.
rather than go:
Race1 race2 race 3
Faction 1 +5 +5 +7
Faction 2 +15 +25 +7
etc
he proposes to go liek 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 swithing 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
Hybrid Mode
