[IndependentGaming]

Hello, my weapons are saving in the mysql "Accounts" so i have done the same with ammo but when i edit /givegun command:

PHP код:

GivePlayerValidWeapon(playa, gun, 60); 


60 is the ammo when i give my self a weapon it gives me 60 ammo but when i relog i got unlimited ammo again

How can i save it where do i need to put it in ?

[Passmerd]

I think you did it well but you didn't add a script that when player relog. the ammo saves automatically in the local database or in the scriptfile.

[IndependentGaming]

No see

PHP код:

    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun0", PlayerInfo[playerid][pGuns][0]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun1", PlayerInfo[playerid][pGuns][1]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun2", PlayerInfo[playerid][pGuns][2]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun3", PlayerInfo[playerid][pGuns][3]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun4", PlayerInfo[playerid][pGuns][4]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun5", PlayerInfo[playerid][pGuns][5]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun6", PlayerInfo[playerid][pGuns][6]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun7", PlayerInfo[playerid][pGuns][7]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun8", PlayerInfo[playerid][pGuns][8]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun9", PlayerInfo[playerid][pGuns][9]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun10", PlayerInfo[playerid][pGuns][10]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Gun11", PlayerInfo[playerid][pGuns][11]);
    
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "ammo0", PlayerInfo[playerid][pAmmo][0]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo1", PlayerInfo[playerid][pAmmo][1]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo2", PlayerInfo[playerid][pAmmo][2]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo3", PlayerInfo[playerid][pAmmo][3]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo4", PlayerInfo[playerid][pAmmo][4]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo5", PlayerInfo[playerid][pAmmo][5]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo6", PlayerInfo[playerid][pAmmo][6]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo7", PlayerInfo[playerid][pAmmo][7]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo8", PlayerInfo[playerid][pAmmo][8]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo9", PlayerInfo[playerid][pAmmo][9]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo10", PlayerInfo[playerid][pAmmo][10]);
    SavePlayerInteger(query, GetPlayerSQLId(playerid), "Ammo11", PlayerInfo[playerid][pAmmo][11]); 


placed on

PHP код:

stock g_mysql_SaveAccount(playerid) 


[IndependentGaming]

or do i need to place it onplayerconnect and onplayerdisconnect ?

[Passmerd]

Yes, onplayerdisconnect.


And a load onplayerconnect.

[IndependentGaming]

Like how ?

[Passmerd]

Код:

Server_Load();
    
    mysql_tquery(query, "SELECT * FROM `gun0`", "ammo", "");

OnGameModeUnit. this is just a example.

[IndependentGaming]

Can someone help me a bit what do i need to create under OnPlayerDisconnect ?

I got this under OnPlayerConnect:

PHP код:

for(new s = 0; s < 12; s++) {
        PlayerInfo[playerid][pMGuns][s] = 0;
        PlayerInfo[playerid][pGuns][s] = 0;
        PlayerInfo[playerid][pAmmo][s] = 0;
    } 


[IndependentGaming]

Anyone ?