21.02.2018, 12:47
Quote:
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. |