
12-17-2013, 05:12 AM
|
team canada
|
 |
Join Date: Jul 2004
Location: Canada
Posts: 5,200
|
|
I mean using it for more than just tracking quest progress. You could have a stats table. I.e.
character_id
strength
dexterity
stamina
intelligence
exp
level
ID would be auto-generating.
Characters
1 toranksu
2 toranksu
3 fp4
4 (npcserver)
5 toranksu
To get character IDs you would do:
SELECT Character.id AS character_id
WHERE acct = player.account
Your character system would keep track of what character they're currently on using a flag like clientr.character_id and you would use that with your other tables rather than hardcoding account ids.
also my bad, it's escapestring2. |
|
|