mysql doesnt save ip to the table
#1

I did something like this after player registration:

PHP Code:
    GetPlayerIp(playerid, ip, 50);
    
mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `IP` = %d WHERE `id` = %d LIMIT 1",ip, pInfo[playerid][ID]);
    
mysql_tquery(g_SQL, query); 
It doesn't work.
Reply
#2

Change

pawn Code:
`IP` = %d
To

pawn Code:
`IP` = %s
Make sure IP row is varchar(24).
Reply
#3

PHP Code:
`ip` varchar(24) NOT NULL 
PHP Code:
    GetPlayerIp(playerid, ip, 16);
    
mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `IP` = %s WHERE `id` = %d LIMIT 1",ip, pInfo[playerid][ID]);
    
mysql_tquery(g_SQL, query);
    
pInfo[playerid][IsLoggedIn] = true; 
Doesn't work.
Reply
#4

SA-MP uses IPv4 addresses, so you need maximum 16 characters as your IP variable buffer/ length.

Also, be sure to use ' with strings, for example: '%s'.
Reply
#5

Quote:
Originally Posted by xMoBi
View Post
SA-MP uses IPv4 addresses, so you need maximum 16 characters as your IP variable buffer/ length.

Also, be sure to use ' with strings, for example: '%s'.
Yes forgot this, sorry.
Reply
#6

Thanks! works.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)