16.06.2016, 11:09
Using GetPlayerIp in OnPlayerDisconnect callback from localhost always return 255.255.255.255
When a player logins, send a query to update the IP rather when disconnecting.
Another thing is:
- Have a unique ID for each player in the table (auto increment enabled). Whenever you want to update or select (I'm not referring to check whether the player is registered or not) data for a player, use that "ID" in WHERE clause instead of "Username". Use FOREIGN KEY Constraints for the "Admins" table.
- Update data to the table ONLY when needed.
When a player logins, send a query to update the IP rather when disconnecting.
Another thing is:
- Have a unique ID for each player in the table (auto increment enabled). Whenever you want to update or select (I'm not referring to check whether the player is registered or not) data for a player, use that "ID" in WHERE clause instead of "Username". Use FOREIGN KEY Constraints for the "Admins" table.
- Update data to the table ONLY when needed.