[-Prodigy-]

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.

[-Prodigy-]

BUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUMP

[CoaPsyFactor]

you want to get username from ip? what if someone, like me, have dynamic ip?

[-Prodigy-]

Yes the username, and don't worry about that.

[-Prodigy-]

Bump! Anyone??