String returning a weird value

String returning a weird value - 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: String returning a weird value (/showthread.php?tid=541047)

String returning a weird value - [CG]Milito - 09.10.2014

Hey folks!

I have a problem with an unban command, the string keeps returning a weird value.

PHP код:



CMD:unban(playerid,params[])

{

    new query[126];

    new usertounban[24];

    if(sscanf(params, "u[24]", usertounban)) return SendClientMessage(playerid,-1,"{FF0000}__**ERROR**__ {FFFFFF}Usage /Unban <Username>");

    if(PlayerInfo[playerid][pAdmin] < 5) return SendClientMessage(playerid, -1, "{FF0000}__**ERROR**__ {FFFFFF} You are not authorized to use that command!");

    format(query, sizeof(query), "SELECT * FROM 'BannedAccounts' WHERE 'UserName' = %s ", usertounban);

    mysql_tquery(mysql, query,"CheckBan","d",playerid); 

    printf("%s",query);

    printf("%s",usertounban);

    print("CMD:unban -- properly executed");

    return 1;

}

As you can see above, I'm telling the console to output the string value, and it returns this weird character: я
No matter what name I type in the command, it keeps returning the same value
I know this is a easy to solve problem but I can't figure it out!

Thanks for your help
-Milito

Re: String returning a weird value - The__ - 09.10.2014

What I would actually do, instead of u[24], use a s[24] and check to see if that string is an actual account or whatever, that actually might be your problem cause I don't really see nothing wrong with it.

Re: String returning a weird value - ThePhenix - 09.10.2014

The problem is what The_ exactly said, you are using the incorrect sscanf specifier.
It should be s[24], u[24] is not right!

Re: String returning a weird value - [CG]Milito - 09.10.2014

Quote:

Originally Posted by The__

What I would actually do, instead of u[24], use a s[24] and check to see if that string is an actual account or whatever, that actually might be your problem cause I don't really see nothing wrong with it.

Oh thanks guys
Problem solved

Re: String returning a weird value - [CG]Milito - 09.10.2014

Now, I got another problem....

The callback is not getting called.

I don't see anything wrong.

PHP код:



public CheckBan(playerid)

{

    print("CheckBan is working");

    if(cache_num_rows() >=1)

    {

        SendClientMessage(playerid,-1,"{FF0000}__**INFO**__ {FFFFFF} Username found, now you should finish the code!");

    }

    else

    {

        SendClientMessage(playerid,-1,"{FF0000}__**ERROR**__ {FFFFFF} Username not found in our database!");

    }

    return 1;

}

Re: String returning a weird value - Emmet_ - 09.10.2014

You are using the incorrect MySQL query syntax in your /unban command. In other words, table and column names must be enclosed in grave accents (`), not singular quotes.

Try:

pawn Код:

SELECT * FROM `BannedAccounts` WHERE `UserName` = %s

Re: String returning a weird value - ThePhenix - 09.10.2014

Quote:

Originally Posted by Emmet_

You are using the incorrect MySQL query syntax in your /unban command. In other words, table and column names must be enclosed in grave accents (`), not singular quotes.

Try:

pawn Код:

SELECT * FROM `BannedAccounts` WHERE `UserName` = %s

I'm not quite sure, but I think the %s should be enclosed between ' ' aswell. Just like this:

pawn Код:

SELECT * FROM `BannedAccounts` WHERE `UserName` = '%s'