15.09.2012, 20:08
Hello there,
I think I am having certain issues with MySQL database, basically I have two questions regarding this, which I couldn't or haven't tried yet to find an answer to. First of all, my player user enum has the AccID primary key, but even once the table is clean from all of accounts, the AccID starts at something ridiculous like 303. In long term, this might be a bit annoying :P
Second of all, at random times, the statistics on my account get reset. For instance, my friend crashed from the server, and I entered just after he's crashed. My account then reset to default state, as after registration.
EDIT: We've both crashed after testing some objects, and I've received his stats, and he received mine. Odd, or I've made a mistake somewhere? The only columns that weren't jumbled up are AccID, Username, IP and Password.
How can I solve these? I'm happy to supply any snippets of code, in case I went wrong anywhere.
Cheers.
I think I am having certain issues with MySQL database, basically I have two questions regarding this, which I couldn't or haven't tried yet to find an answer to. First of all, my player user enum has the AccID primary key, but even once the table is clean from all of accounts, the AccID starts at something ridiculous like 303. In long term, this might be a bit annoying :P
Second of all, at random times, the statistics on my account get reset. For instance, my friend crashed from the server, and I entered just after he's crashed. My account then reset to default state, as after registration.
EDIT: We've both crashed after testing some objects, and I've received his stats, and he received mine. Odd, or I've made a mistake somewhere? The only columns that weren't jumbled up are AccID, Username, IP and Password.
How can I solve these? I'm happy to supply any snippets of code, in case I went wrong anywhere.
Cheers.