
Originally Posted by
matran
how do we know any charactor is in dark or light side?
Im looking on PS_GameData.dbo.Chars but i still can't find out.
anyone knows?
Select Family + Job
Family values:
* 0 - human
* 1 - elf
* 2 - vail
* 3 - deatheater
Job values:
* 0 - fighter/warrior
* 1 - defender/guardian
* 2 - ranger/assassin
* 3 - archer/hunter
* 4 - mage/pagan
* 5 - priest/oracle
example sql
return all charnames human with job fighter/warrior
Code:
USE PS_GameData;
GO
SELECT CharName, Family, Job
FROM Chars
WHERE (Family = 0) AND (Job = 0)
ORDER BY CharName