Some SQL / db Questions...

[fowlplay4]

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.