SA-MP Forums Archive
Aka help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Aka help (/showthread.php?tid=568746)


Aka help - ReD_HunTeR - 24.03.2015

solved :/

Re: Aka help - X337 - 25.03.2015

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);


Re: Aka help - ReD_HunTeR - 25.03.2015

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

Re: Aka help - ReD_HunTeR - 25.03.2015

Bump,

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

Re: Aka help - WaJeeH - 25.03.2015

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

Re: Aka help - ReD_HunTeR - 25.03.2015

where can u see "return 0" ?

Re: Aka help - ReD_HunTeR - 26.03.2015

bump

Re: Aka help - ReD_HunTeR - 27.03.2015

bump

Re: Aka help - Aly - 27.03.2015

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


Re: Aka help - ReD_HunTeR - 27.03.2015

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