Wrong values - MySQL - 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: Wrong values - MySQL (
/showthread.php?tid=308621)
Wrong values - MySQL -
-Prodigy- - 04.01.2012
I'm getting wrong values with this:
OnPlayerConnect..
pawn Code:
format(gQuery, sizeof(gQuery), "SELECT Username FROM AKA WHERE IP = '%s'", gPIP[playerid]);
mysql_query(gQuery, THREAD_USER_AKA, playerid);
OnQueryFinish..
pawn Code:
new
//iAKA[128],
iAKATemp[128];
if(mysql_num_rows() > 0)
{
if(mysql_retrieve_row()) mysql_get_field("Username", gAKA[extraid]); // Store the AKA in a global string
if(strfind(gAKA[extraid], gName[extraid], true) != -1) { }
else
{
format(iAKATemp, sizeof(iAKATemp), "%s - %s", gAKA[extraid], gName[extraid]);
strcpy(gAKA[extraid], iAKATemp, sizeof(iAKATemp));
format(gQuery, sizeof(gQuery), "UPDATE AKA SET Username = '%s' WHERE IP = '%s'", iAKATemp, gPIP[extraid]);
mysql_query(gQuery);
}
}
else
{
format(gQuery, sizeof(gQuery), "INSERT INTO AKA (IP, Username) VALUES ('%s', '%s')", gPIP[extraid], gName[extraid]);
mysql_query(gQuery);
strcpy(gAKA[extraid], gName[extraid], MAX_PLAYER_NAME);
}
//strcpy(gAKA[extraid], iAKA, sizeof(gAKA[]));
I'm getting the wrong info.
Re: Wrong values - MySQL -
-Prodigy- - 05.01.2012
BUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUMP
Re: Wrong values - MySQL -
CoaPsyFactor - 05.01.2012
you want to get username from ip? what if someone, like me, have dynamic ip?
Re: Wrong values - MySQL -
-Prodigy- - 05.01.2012
Yes the username, and don't worry about that.
Re: Wrong values - MySQL -
-Prodigy- - 06.01.2012
Bump! Anyone??