Ayuda con mysql
#1

El dia entero he intentado arreglar esto, pero ya me di por vencido, alguien tiene alguna idea por que estara mal este codigo?
pawn Код:
stock LoginPlayer(playerid,password[])
{
    new query[300];
    mysql_real_escape_string(password,pInfo[playerid][pass]);
    format(query,sizeof(query),"SELECT `score`,`kills`,`deaths`,`money`, `AdminLvl` FROM `jugadores` WHERE `nickname` = '%s' AND `pass` = sha1('%s') LIMIT 1",
    pInfo[playerid][nickname],pInfo[playerid][pass]);
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        new Query[500];
        format(Query, sizeof(Query), "SELECT * FROM `jugadores` WHERE `nickname` = '%s'", pInfo[playerid][nickname]);
        mysql_query(Query);
        mysql_fetch_row_format(Query, "|");
        sscanf(Query, "p<|>s[24]s[128]iiiiis[16]",pInfo[playerid][nickname],pInfo[playerid][pass],pInfo[playerid][score],
        pInfo[playerid][kills],pInfo[playerid][deaths],pInfo[playerid][money],pInfo[playerid][AdminLvl],pInfo[playerid][IP]);
        mysql_free_result();
        printf("%s",Query);
        pInfo[playerid][LoggedIn] = true;
        GivePlayerMoney(playerid, pInfo[playerid][money]);
        SetPlayerScore(playerid, pInfo[playerid][score]);
        SendClientMessage(playerid,0x00FF00FF,"You have been successfully logged in!");
        PlayerPlaySound(playerid, 1149, 0,0,0);
    }
    else
    {
        SendClientMessage(playerid,-1,""ERROR"Wrong Password");
    }
    return 1;
}
Estos son los errores:
1. No printea todos los datos, solo los integers [00:03:42] 0|0|0|1000|0
2. Si pongo el valor de 1000 en la pestaсa de 'money' en MySQL, a la hora de logear no me da el dinero
3. En el Debug.txt:
Код:
[00:03:54] CMySQLHandler::Query(UPDATE `jugadores` SET `score`='0', `kills`='1000', `deaths`='0', `money`='0', `AdminLvl`='0' WHERE (`nickname` = 'Onfroi')) - An error has occured. (Error ID: 2014, Commands out of sync; you can't run this command now)
Por alguna razon le pone el valor de 'money' a 'kills' y sale ese error.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)