[Yaa]

Hello !

Why it's Don't load Informations ? :/

PHP Code:

    if(rows > 0)
    {
        cache_get_field_content(0, "password", PlayerInfo[playerid][pPass]);
        PlayerInfo[playerid][pKills] = cache_get_field_content_int(0, "kills");
        PlayerInfo[playerid][pDeaths] = cache_get_field_content_int(0, "deaths");
        PlayerInfo[playerid][pCash] = cache_get_field_content_int(0, "cash");
        PlayerInfo[playerid][pKicks] = cache_get_field_content_int(0, "kicks");
        PlayerInfo[playerid][pAdmin] = cache_get_field_content_int(0, "admin");
        PlayerInfo[playerid][pBans] = cache_get_field_content_int(0, "bans");
        PlayerInfo[playerid][pSkin] = cache_get_field_content_int(0, "skin");
        new plrIP[16];
        PlayerInfo[playerid][pIP] = GetPlayerIp(playerid, plrIP, sizeof(plrIP));
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""WHITE"Login...",""RED"Welcome Back ! We Miss You here !.\n"WHITE"Please Type You password to get back you rights","Login","Quit");
    } 


Thanks in advence

[oMa37]

Check if(rows).
It's oblivious, open your eyes, You are loading the data with number row 0 and checking if rows > 0 ? How could that be even possible?

[Yaa]

Quote:

Originally Posted by oMa37 Check if(rows). It's oblivious, open your eyes, You are loading the data with number row 0 and checking if rows > 0 ? How could that be even possible?

still same error

[oMa37]

Can you show the full code? The query and the function you load the data in.
Also check your mysql log if there is any error.

[Yaa]

Last lines [in the last hour] Mysql_log

PHP Code:

[09:38:53] [WARNING] cache_get_row_count - no active cache
[09:38:53] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[09:38:55] [ERROR] CMySQLQuery::Execute - (error #1064) 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 'SET `deaths` = '0' SET `skin` = '0' SET `cash` = '0' SET `admin` = '0' SET `kick' at line 1 


Full Querys :

PHP Code:

OnPlayerDisconnect : 
format(querylist, sizeof(querylist), "UPDATE `accounts` SET `kills` = '%d', `deaths` = '%d', `skin` = '%d', `cash` = '%d',`admin` = '%d', `kicks` = '%d', `bans` = '%d' WHERE `name` = '%s'", PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], GetPlayerSkin(playerid), GetPlayerMoney(playerid), PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pKicks], PlayerInfo[playerid][pBans], GetName(playerid)); 


PHP Code:

OnDialogReponse:
format(querylist, sizeof(querylist), "INSERT INTO `accounts`(`name`, `ip`, `password`, `admin`, `skin`, `kills`, `deaths`, `cash`, `kicks`, `Bans`) VALUES('%s', '%s', '%s', '0', '0', '0', '0', '4000', '0', '0')", GetName(playerid), ip, inputtext); 


that good ?

[oMa37]

How you load the data?
Like when the player connect, How you check if the account is exist or not?

[Yaa]

Lol ! i like the pic xD

anyway

PHP Code:

    new query[100], Cache:result;
        format(query, 128, "SELECT * FROM `accounts` WHERE `name` = '%s'", GetName(playerid));
       result =  mysql_query(MySQL, query);
    new rows = cache_get_row_count();
    cache_delete(result);
    if(rows)
    {
            // Is Exists
        else 
        {
            // Is not 
         } 


Data load :

PHP Code:

        cache_get_field_content(0, "password", PlayerInfo[playerid][pPass]);
        PlayerInfo[playerid][pKills] = cache_get_field_content_int(0, "kills");
        PlayerInfo[playerid][pDeaths] = cache_get_field_content_int(0, "deaths");
        PlayerInfo[playerid][pCash] = cache_get_field_content_int(0, "cash");
        PlayerInfo[playerid][pKicks] = cache_get_field_content_int(0, "kicks");
        PlayerInfo[playerid][pAdmin] = cache_get_field_content_int(0, "admin");
        PlayerInfo[playerid][pBans] = cache_get_field_content_int(0, "bans");
        PlayerInfo[playerid][pSkin] = cache_get_field_content_int(0, "skin"); 


i put this after if(rows) { // Exist

[oMa37]

I can't fix your code atm because i'm using the phone, But you have to use a threaded way, Take a look on this example script by Konstantinos; CLICKHERE

[Yaa]

Thank You ! i will try this looks like good

+Repped for u time

EDIT: FIXED !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! UPDATED to R41 You credits added to script oMa37