[Toni]

I'm not sure what I am having a problem with right now, seems as everything is fine;

pawn Код:

if(dialogid == DReg)
    {
        if(response == 1)
        {
            new
                str[128],
                password[50];
            format(str, 128, "SELECT * FROM `playerinfo` WHERE `user` = '%s'", pName(playerid));
            mysql_query(str);
            mysql_store_result();
            if(mysql_num_rows() == 1)
            {
                SendClientMessage(playerid, RED, "ERROR: This account is already registered!");
                ShowPlayerDialog(playerid, DLogin, DIALOG_STYLE_INPUT, "RC:RP Login", "Please enter your password below to login", "Login", "Cancel");
                mysql_free_result();
                return 1;
            }
            mysql_free_result();
            CMySQL_Create(str, ACCOUNT_TABLE, "User");
            CMySQL_Password(str, ACCOUNT_TABLE, "Password", inputtext);
            CMySQL_SetInt(str, ACCOUNT_TABLE, "User", "Money", 5000);
        }
        else
        {
            SendClientMessage(playerid, GREEN, "You have cancelled registration, you have been kicked");
            Kick(playerid);
        }
    }

This is my dialog code; used for DIALOG_STYLE_INPUT.

I have tried registering, but it comes out pretty odd.
Console Output (Stricken Kid's):

Quote:

[12:59:22] [join] Toni_Tang has joined the server (0:192.168.1.75) [12:59:27] MySQL Error (0): Could not execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `playerinfo` WHERE `user` = \'Toni_Tang\' = ''' at line 1.

And this is the output after registering in phpMyAdmin:

Quote:

SELECT * FROM `playerinf

Apparently that was my value 'username'.

Can someone please help.

[Toni]

Sorry for the bump, I really need help.

[Kar]

can someone help him;\

[MadeMan]

Which line is causing the problem?

[Toni]

Idnno..I'm guessing the format(str one.

[Kar]

i believe its this

pawn Код:

format(str, 128, "SELECT * FROM `playerinfo` WHERE `user` = '%s'", pName(playerid));
            mysql_query(str);
            mysql_store_result();

as said in the error. he posted

edit try this

pawn Код:

new Query[200], Pname[24]; //Creates the Query string and the Pname
    GetPlayerName(playerid, Pname, 24); //Gets the players name
    format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s'", Pname); //Selects the line where the playername is the player
    mysql_query(Query); //Querys the string
    mysql_store_result(); //Stores the result

ik it doesnt look like a difference has been made.

[Carlton]

It looks right to me, but just incase

pawn Код:

mysql_real_escape_string(pName(playerid), str);
format(str, 128, "SELECT * FROM `playerinfo` WHERE `user` = '%s'", str);
mysql_query(str);
mysql_store_result();

[Toni]

Quote:

Originally Posted by Carlton It looks right to me, but just incase pawn Код: mysql_real_escape_string(pName(playerid), str); format(str, 128, "SELECT * FROM `playerinfo` WHERE `user` = '%s'", str); mysql_query(str); mysql_store_result();

Sorry to say, it didn't work :/

[Kar]

ffs lol just use the reg system i gave you why do u even need to change it

[Toni]

Quote:

Originally Posted by Kar ffs lol just use the reg system i gave you why do u even need to change it

Meh.

Anyone else have ideas on how to fix?