18.03.2013, 15:33
Oh man. Is your ID field auto_increment? mysql_insert_id doesn't go well with caching.
I'll assume that you have some sort of validation for ip and nick already earlier.
pawn Код:
new tmp[64];
mysql_real_escape_string(inputtext, tmp, connection);
format(query,sizeof(query),"INSERT INTO `players` VALUES (NULL, '%s', '%s', '%s', 0, 0)", name(playerid), ip, tmp);