[FalconWingsX]

Hi, I got two problems related to mysql.

first one, more cirtical.

Код:

[Sun Nov 18 04:32:57 2012] Error (0): Function: mysql_store_result called when no prior successful query executed. 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 ''Tommy_Ve' at line 1.
[Sun Nov 18 04:32:57 2012] Error (0): Function: mysql_num_rows called when no result stored. 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 ''Tommy_Ve' at line 1.

it's kind of an odd error. And I haven't found a solution to it, heres the snippet

pawn Код:

stock IsUsernameRegistered(playerid, usernm[])
{
    new query[50];
    format(query, sizeof(query),"SELECT * FROM playerdb WHERE username = '%s'", usernm);
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        ShowPlayerDialog(playerid,LOGIN_DIALOG,DIALOG_STYLE_PASSWORD,"Login!","Welcome to CHANGEME roleplay, The current version is 0.01a. \n we are currently under developement!","Login","Cancel");
    }
    else
    {
        ShowPlayerDialog(playerid,REGISTER_DIALOG,DIALOG_STYLE_PASSWORD,"Register Account.","Enter your password below:","Register","Cancel");
    }
    mysql_free_result();
    return 1;
}

stock LoginPlayer(playerid, pass[])
{
    new query[1000];
    format(query, sizeof(query),"SELECT * FROM playerdb WHERE username = '%s' AND password = md5('%s')",playerdb[playerid][username],pass);
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        if(mysql_fetch_row(query, "|"))
        {
            sscanf(query,"e<p<|>s[24]s[32]iii>", playerdb[playerid]);
            new str[80];
            format(str, sizeof(str),"Welcome %s, you have been loged to your account",playerdb[playerid][username]);
            SendClientMessage(playerid, COLOR_BLUE, str);
            SetPlayerInterior(playerid, 0);
            SetPlayerVirtualWorld(playerid, 0);
            SetPlayerScore(playerid, playerdb[playerid][score]);
            GivePlayerMoney(playerid, playerdb[playerid][money]);
            SpawnPlayer(playerid);
            playerdb[playerid][loged] = 1;
    mysql_free_result(); 
        }
    }
    else
    {
        ShowPlayerDialog(playerid,LOGIN_DIALOG,DIALOG_STYLE_PASSWORD,"Login to Account.","Wrong password:","Login","Cancel");
    }
}

EDIT:
Found what was bugging me, in a whole new section.
it was

pawn Код:

format(Query, sizeof(Query), "SELECT * FROM `playerdb` WHERE `username` = '%s'", pname);

I weren't calling anything