R7 MySQL issue, finding name from row, returning

R7 MySQL issue, finding name from row, returning - 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: R7 MySQL issue, finding name from row, returning (/showthread.php?tid=401376)

R7 MySQL issue, finding name from row, returning - tuuker - 22.12.2012

I'm having issue with getting if there's any player name in row with connected player name.

OnPlayerConnect i have

pawn Код:

format(query, sizeof(query), "SELECT `Name` FROM `accounts` WHERE `Name` = '%s' LIMIT 1", returnName(playerid));
    mysql_function_query(dbHandle, query, true, "OnAccountCheckExists", "d", playerid);

in custon public OnAccountCheckExists i have:

pawn Код:

public OnAccountCheckExists(playerid) 
{
    new rows, fields;
    cache_get_data(rows,fields);
    if(!rows) {
        hasAccount[playerid] = 0;
    } else {
        hasAccount[playerid] = 1;
    }
}

All this code should select name with player name that is connected and onAccountCheck it should set hasAccount[playerid] to 0 if there's no on with that name in table or if there is someone with that name then hasAccount[playerid] should be set to 1.

Problem is that hasAccount returns all the time 0...

Here's second thing i tried:
OnPlayerAccount:

pawn Код:

if(CheckAccount(UserStats[playerid][ID])) hasAccount[playerid] = 1;

pawn Код:

stock CheckAccount(playerid)
{
    new query[82];
    format(query, sizeof(query), "SELECT ID,Password FROM `accounts` WHERE `Name` = '%s' LIMIT 1", returnName(playerid));
    mysql_function_query(dbHandle, query, true, "OnAccountCheck", "d", playerid);
    return 1;
}

pawn Код:

public OnAccountCheck(playerid)
{
    if(playerid != INVALID_PLAYER_ID) {
        
        new rows, fields;
        cache_get_data(rows, fields, dbHandle);
        
        if(rows) {
            
            new id[30];
            cache_get_row(0, 0, id, dbHandle);  UserStats[playerid][ID] = strval(id);
            cache_get_row(0, 1, UserStats[playerid][pPass], dbHandle);
            hasAccount[playerid] = 1;
        }
        else {
            hasAccount[playerid] = 0;
        }
    }
    return 1;
}

Still same issue, hasAccount returned 0 every time tho i have account registered. It can't find my account from my row so it returns it 0.

Re: R7 MySQL issue, finding name from row, returning - tuuker - 22.12.2012

Nvm, fixed this issue

Code needed bit tweaking.