Problem i give rep ++! Thanks!

Problem i give rep ++! Thanks! - 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: Problem i give rep ++! Thanks! (/showthread.php?tid=545937)

Problem i give rep ++! Thanks! - buburuzu19 - 11.11.2014

I have a problem with the next response:

pawn Код:

case 696:
        {
            if(response)
            {
                if(!isnull(inputtext))
                {
                    new playerName[1][MAX_PLAYER_NAME],querySz[150];
                    format(querySz, sizeof(querySz), "SELECT playerName FROM playeraccounts WHERE playerName = '%s'", inputtext);
                    mysql_tquery(handle, querySz);
                    cache_get_data(rows, fields, handle);
                    if(rows > 0)
                    {
                        SendClientMessage(playerid, COLOR_GREY, "That name is already taken.");
                        return 1;
                    }

                    GetPlayerName(playerid, playerName[0], MAX_PLAYER_NAME);

                    mysql_format(handle, querySz, sizeof(querySz), "UPDATE playeraccounts SET playerName = '%e' WHERE playerID = '%d'", inputtext, playerVariables[playerid][pInternalID]);
                    mysql_tquery(handle, querySz); // No point in threading a simple response...

                    format(querySz, sizeof(querySz), "You have changed your name to %s.", inputtext);
                    SendClientMessage(playerid, COLOR_WHITE, querySz);
                    SetPlayerName(playerid, inputtext);
                    strcpy(playerVariables[playerid][pNormalName], inputtext, MAX_PLAYER_NAME);

                    playerVariables[playerid][pPremiumPoints] -= 20;
                }
                else
                {
                    SCM(playerid, -1,"Invalid new nickname.");
                }
            }
        }

every name i put it's says me that it is already taken but it isn't. what is wrong? i am using mysql r39-2 , the response is for a dialog who change your name but no name is valid because it's saying it's already taken.

Re: Problem i give rep ++! Thanks! - Stinged - 11.11.2014

Try this.

pawn Код:

case 696:
{
    if(response)
    {
        if(!isnull(inputtext))
        {
            new querySz[128];
            format(querySz, sizeof(querySz), "SELECT playerName FROM playeraccounts WHERE playerName = '%s'", inputtext);
            mysql_tquery(handle, querySz, "NewPlayerName", "is", playerid, inputtext);
        }
        else
        {
            SCM(playerid, -1,"Invalid new nickname.");
        }
    }
}

forward NewPlayerName(playerid, inputtext[]);
public NewPlayerName(playerid. inputtext[])
{
    new rows, fields;
    cache_get_data(rows, fields, handle);
    if(rows > 0)
    {
        SendClientMessage(playerid, COLOR_GREY, "That name is already taken.");
        return 1;
    }

    new playerName[24];
    GetPlayerName(playerid, playerName, MAX_PLAYER_NAME);

    new querySz[150];
    mysql_format(handle, querySz, sizeof(querySz), "UPDATE playeraccounts SET playerName = '%e' WHERE playerID = '%d'", inputtext, playerVariables[playerid][pInternalID]);
    mysql_tquery(handle, querySz);

    format(querySz, sizeof(querySz), "You have changed your name to %s.", inputtext);
    SendClientMessage(playerid, COLOR_WHITE, querySz);
    SetPlayerName(playerid, inputtext);
    strcpy(playerVariables[playerid][pNormalName], inputtext, MAX_PLAYER_NAME);

    playerVariables[playerid][pPremiumPoints] -= 20;
    return 1;
}