[severance]

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.

[KinderClans]

Change

pawn Code:

`IP` = %d

To

pawn Code:

`IP` = %s

Make sure IP row is varchar(24).

[severance]

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.

[xMoBi]

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'.

[KinderClans]

Quote:

Originally Posted by xMoBi 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.

[severance]

Thanks! works.