[ReD_HunTeR]

solved :/

[X337]

For /aka :
change :

Код:

mysql_format(mysql, query, sizeof(query), "SELECT Username FROM players WHERE IP = %s",  IP[targetid]);

to:

Код:

mysql_format(mysql, query, sizeof(query), "SELECT `Username` FROM players WHERE IP = '%s'",  IP[targetid]);

Don't forget to rescape string in SQL syntax.

and you didn't save the data on "GetInfoOfPlayer(playerid)" to a player variables.

Код:

cash = cache_get_field_content_int(row, "Cash", mysql);

You must save in player variable.
Example:

Код:

PlayerInfo[playerid][cash] = cache_get_field_content_int(row, "Cash", mysql);

[ReD_HunTeR]

bump,
1. changed
2. that cmd is used to check offline player stats -_-, not for Giving Player his old stats

[ReD_HunTeR]

Bump,

the one is fixed,
need to fix second one, "cant see player stats" it's just showing "NULL" and "0"

[WaJeeH]

Dude,check outt the script
maybe it's "return 0" but it should be return 1
I hope it will work.

[ReD_HunTeR]

where can u see "return 0" ?

[ReD_HunTeR]

bump

[ReD_HunTeR]

bump

[Aly]

Код:

mysql_format(mysql, query, sizeof(query), "SELECT * FROM `players` WHERE `Username` = '%s' LIMIT 1", name); 
    mysql_tquery(mysql, query, "GetInfoOfPlayer", "d", playerid);

[ReD_HunTeR]

oh i got it myself -_-, topic locked, solved :3