[Calisthenics]

Provide a .sql file about the table structure please.

Few tips to consider:

• Save dates as TIMESTAMP OR DATETIME datatype and not as string. There is mysql function to format a readable form and an integrated system can even allow you retrieving total online time and many more benefits.
• Avoid non-threaded queries as it can lead to memory leaks (you forgot to delete the cache instance).
• Do not copy strings directly as this:
  
  pawn Code:

  g_ConnectionDate[playerid] = ReturnDate();
  g_pIP[playerid] = ReturnIP(playerid);
  
  g_DisconnectionDate[playerid] = ReturnDate();

  There is `strcpy` (macro of `strcat`) or `memcpy` function. Avoid `format` function.
• Select columns you want to retrieve and not everything. `Name` or `Disconnected` columns are never retrieved.
• Set appropriate keys to table structure. Searching by a string is slower than an integer. Searching by a non-indexed string is even slower.