1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MySQL Loading and Saving issue
arko123
Big Clucker
***
Posts: 174
Threads: 70
Joined: Jun 2012
Reputation: 0
#1

03.08.2014, 17:48
Hello recently I have started using cache functions from BlueG's Plugin but for some reason when I go to save the players name it comes out as blank for a reason I am un aware of but when I looked at the logs it says it loaded it.

Could someone please tell me what I am doing wrong.

pawn Код:
[18:27:16] [DEBUG] Calling callback "OnPlayerLoad"..
[18:27:16] [DEBUG] cache_get_data - connection: 1
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 0, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "1"
[18:27:16] [DEBUG] cache_get_row - row: 0, field_idx: 1, connection: 1, max_len: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "Royston_Marshall"
[18:27:16] [DEBUG] cache_get_row_float - row: 0, field_idx: 3, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "100"
[18:27:16] [DEBUG] cache_get_row_float - row: 0, field_idx: 4, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "0"
[18:27:16] [DEBUG] cache_get_row_float - row: 0, field_idx: 5, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "0"
[18:27:16] [DEBUG] cache_get_row_float - row: 0, field_idx: 6, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "0"
[18:27:16] [DEBUG] cache_get_row_float - row: 0, field_idx: 7, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "0"
[18:27:16] [DEBUG] cache_get_row_float - row: 0, field_idx: 8, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 9, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '9', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 10, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '10', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 11, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '11', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 12, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '12', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 13, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '13', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 14, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '14', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 15, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '15', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 16, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '16', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 17, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '17', data: "1"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 18, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '18', data: "0"
[18:27:16] [DEBUG] cache_get_row - row: 0, field_idx: 19, connection: 1, max_len: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '19', data: ""
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 20, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '20', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 21, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '21', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 22, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '22', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 23, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '23', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 24, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '24', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 25, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '25', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 26, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '26', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 27, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '27', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 28, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '28', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 29, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '29', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 30, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '30', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 31, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '31', data: "0"
[18:27:16] [DEBUG] cache_get_row_int - row: 0, field_idx: 32, connection: 1
[18:27:16] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '32', data: "0"
pawn Код:
[18:27:24] [DEBUG] mysql_format - connection: 1, len: 450, format: "UPDATE `accounts` SET name='%e', health=%f, armour=%f, pos_x=%f, pos_y=%f, pos_z=%f, pos_r=%f, interior=%d, virtual_world=%d, sk..."
[18:27:24] [DEBUG] mysql_format - connection: 1, len: 450, format: "%s, wep_slot_0=%d, wep_slot_1=%d, wep_slot_2=%d, wep_slot_3=%d, wep_slot_4=%d, wep_slot_5=%d, wep_slot_6=%d, wep_slot_7=%d, wep_..."
[18:27:24] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET name='', health=100.0, armour=0.0, pos_x=0", callback: "EmptyQuery", format: "(null)"
[18:27:24] [DEBUG] CMySQLQuery::Execute[EmptyQuery] - starting query execution
[18:27:24] [DEBUG] CMySQLQuery::Execute[EmptyQuery] - query was successfully executed within 27.183 milliseconds
pawn Код:
public OnPlayerLoad(playerid)
{
    new
        Rows,
        Fields;

    cache_get_data(Rows, Fields);
    
    if(Rows > 0)
    {
        Player[playerid][pSQLID] = cache_get_row_int(playerid, 0);
        
        cache_get_row(playerid, 1, Player[playerid][pName], MAX_PLAYER_NAME);
        
        // Password is index 2
        
        Player[playerid][pHealth] = cache_get_row_float(playerid, 3);
        
        Player[playerid][pArmour] = cache_get_row_float(playerid, 4);
        
        Player[playerid][pPos][0] = cache_get_row_float(playerid, 5);
        
        Player[playerid][pPos][1] = cache_get_row_float(playerid, 6);
        
        Player[playerid][pPos][2] = cache_get_row_float(playerid, 7);
        
        Player[playerid][pPos][3] = cache_get_row_float(playerid, 8);
        
        Player[playerid][pInterior] = cache_get_row_int(playerid, 9);
        
        Player[playerid][pVirtualWorld] = cache_get_row_int(playerid, 10);
        
        Player[playerid][pSkin] = cache_get_row_int(playerid, 11);
        
        Player[playerid][pAge] = cache_get_row_int(playerid, 12);
        
        Player[playerid][pGender] = cache_get_row_int(playerid, 13);
        
        Player[playerid][pMoney] = cache_get_row_int(playerid, 14);
        
        Player[playerid][pBankMoney] = cache_get_row_int(playerid, 15);
        
        Player[playerid][pHospitalized] = cache_get_row_int(playerid, 16);
        
        Player[playerid][pSetup] = cache_get_row_int(playerid, 17);
        
        Player[playerid][pAdminLevel] = cache_get_row_int(playerid, 18);
        
        cache_get_row(playerid, 19, Player[playerid][pAdminName], MAX_PLAYER_NAME);
        
        Player[playerid][pWeapon][0] = cache_get_row_int(playerid, 20);
        
        Player[playerid][pWeapon][1] = cache_get_row_int(playerid, 21);
        
        Player[playerid][pWeapon][2] = cache_get_row_int(playerid, 22);
        
        Player[playerid][pWeapon][3] = cache_get_row_int(playerid, 23);
        
        Player[playerid][pWeapon][4] = cache_get_row_int(playerid, 24);
        
        Player[playerid][pWeapon][5] = cache_get_row_int(playerid, 25);
        
        Player[playerid][pWeapon][6] = cache_get_row_int(playerid, 26);
        
        Player[playerid][pWeapon][7] = cache_get_row_int(playerid, 27);
        
        Player[playerid][pWeapon][8] = cache_get_row_int(playerid, 28);
        
        Player[playerid][pWeapon][9] = cache_get_row_int(playerid, 29);
        
        Player[playerid][pWeapon][10] = cache_get_row_int(playerid, 30);
        
        Player[playerid][pWeapon][11] = cache_get_row_int(playerid, 31);
        
        Player[playerid][pWeapon][12] = cache_get_row_int(playerid, 32);
        
        SetPVarInt(playerid, "LoggedIn", 1);
        
        if(Player[playerid][pSetup] == 1)
        {
            if(Player[playerid][pHospitalized] == 1)
            {
                InitPlayerHospitalize(playerid);
            }
            else
            {
                TogglePlayerSpectating(playerid, false);

                SetSpawnInfo(playerid, 0, Player[playerid][pSkin], Player[playerid][pPos][0], Player[playerid][pPos][1], Player[playerid][pPos][2], Player[playerid][pPos][3], 0, 0, 0, 0, 0, 0);
                SpawnPlayer(playerid);
            }
        }
        else CharacterSetup(playerid);
    }
    else
    {
        ShowPlayerDialog(playerid, Dialog_Login, DIALOG_STYLE_PASSWORD, "Login", "This account is registered!\nIf you are the account owner please enter the password below to login", "Login", "Cancel");
        SendClientMessage(playerid, Colour_White, "Incorrect password entered, please try again!");
    }
    return 1;
}
pawn Код:
stock SavePlayer(playerid)
{
    if(GetPVarInt(playerid, "LoggedIn") > 0)
    {
        new 
            Query[450];
            
        mysql_format(Connection, Query, sizeof Query, "UPDATE `accounts` SET name='%e', health=%f, armour=%f, pos_x=%f, pos_y=%f, pos_z=%f, pos_r=%f, interior=%d, virtual_world=%d, skin=%d, age=%d, gender=%d, money=%d, bank_money=%d, hospitalized=%d, setup=%d, admin_level=%d, admin_name='%e'",
            Player[playerid][pName],
            Player[playerid][pHealth],
            Player[playerid][pArmour],
            Player[playerid][pPos][0],
            Player[playerid][pPos][1],
            Player[playerid][pPos][2],
            Player[playerid][pPos][3],
            Player[playerid][pInterior],
            Player[playerid][pVirtualWorld],
            Player[playerid][pSkin],
            Player[playerid][pAge],
            Player[playerid][pGender],
            Player[playerid][pMoney],
            Player[playerid][pBankMoney],
            Player[playerid][pHospitalized],
            Player[playerid][pSetup],
            Player[playerid][pAdminLevel],
            Player[playerid][pAdminName]
        );
        
        mysql_format(Connection, Query, sizeof Query, "%s, wep_slot_0=%d, wep_slot_1=%d, wep_slot_2=%d, wep_slot_3=%d, wep_slot_4=%d, wep_slot_5=%d, wep_slot_6=%d, wep_slot_7=%d, wep_slot_8=%d, wep_slot_9=%d, wep_slot_10=%d, wep_slot_11=%d, wep_slot_12=%d WHERE `id` = %d",
            Query,
            Player[playerid][pWeapon][0],
            Player[playerid][pWeapon][1],
            Player[playerid][pWeapon][2],
            Player[playerid][pWeapon][3],
            Player[playerid][pWeapon][4],
            Player[playerid][pWeapon][5],
            Player[playerid][pWeapon][6],
            Player[playerid][pWeapon][7],
            Player[playerid][pWeapon][8],
            Player[playerid][pWeapon][9],
            Player[playerid][pWeapon][10],
            Player[playerid][pWeapon][11],
            Player[playerid][pWeapon][12],
            Player[playerid][pSQLID]
        );
        
        mysql_function_query(Connection, Query, false, "EmptyQuery", "");
    }
    return 1;
}
Find
Reply
arko123
Big Clucker
***
Posts: 174
Threads: 70
Joined: Jun 2012
Reputation: 0
#2

03.08.2014, 21:10
Anyone? I couldn't find a solution.
Find
Reply
arko123
Big Clucker
***
Posts: 174
Threads: 70
Joined: Jun 2012
Reputation: 0
#3

04.08.2014, 10:19
Still in need of help.
Find
Reply
arko123
Big Clucker
***
Posts: 174
Threads: 70
Joined: Jun 2012
Reputation: 0
#4

04.08.2014, 11:47
Fixed.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help