SA-MP Forums Archive
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??