21.02.2018, 05:43
Why the username is 128 long, the max name length in-game is 20
Why is the IP 128 long, the max ipv2 length is 16
Why register and lastlogin are varchars and not int
Why are all the int's so huge.
Why you don't nave a primary key
Why do you save conntime like this? use the return of gettime(), it increases by 1 every 1 second, you can record the time player spent in-game from playerspawn
OnPlayerSpawn
startOfGameplay=gettime();
And then on player disconnect
OnPlayerDisconnect
totalPlaytime+=gettime() - startOfGameplay;
And just add it to the number you already have in the database.
Why is the IP 128 long, the max ipv2 length is 16
Why register and lastlogin are varchars and not int
Why are all the int's so huge.
Why you don't nave a primary key
Why do you save conntime like this? use the return of gettime(), it increases by 1 every 1 second, you can record the time player spent in-game from playerspawn
OnPlayerSpawn
startOfGameplay=gettime();
And then on player disconnect
OnPlayerDisconnect
totalPlaytime+=gettime() - startOfGameplay;
And just add it to the number you already have in the database.