[HELP]MySQL load & set
#1

if(mysql_fetch_row(line))
{
new data[3][55];
new data2[7];
sscanf(line, "p<|>s[50]s[300]dddds[50]ds[100]", data[0], largestring, data2[0], data2[1], data2[2], data2[3], data[2], data2[4], estring);
stringempty(estring);
stringempty(largestring);
SetPVarInt(playerid, "Kills", data2[0]);
SetPVarInt(playerid, "Logged", 1);
SetPVarInt(playerid, "Deaths", data2[1]);
SetPlayerScore(playerid, data2[2]);
GivePlayerMoney(playerid, data2[3]);
SetPVarInt(playerid, "AdminLevel", data2[4]);
SendClientMessage(playerid, 0x0000D9AA, "Logirani ste!");
mysql_free_result();
GetPlayerIp(playerid, PIP, 1;
format(Query, sizeof(Query), "UPDATE `playerinfo` SET IP = '%s' WHERE user='%s'", PIP, escpname(playerid));
mysql_query(Query);
}
Here i got AdminLevel it's not last table after it i got table "leader" and "member"
I want to set leader and member like a AdminLevel in Pvar int ...Can you help me ? I don't know to work with sscanf?
Reply
#2

what do u mean... explain more .. and use [pawn] [/ pawn] tags next time pl0x
Reply
#3

here -
i want when player connect to server to SetPVar Int Member, leader, drzava and godine like he sets admin...but i don't know how to
Reply
#4

BUMP i need help!
Reply
#5

I have never used MySQL, but Kills and Deaths/Score/Money etc.. are integer, aren't they?
Reply
#6

i don't know i just want to load it by string help pls!
Reply
#7

i fixed it
D
Lock here
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)