Pawn MySQL Weapon save custom

Zow · (This post was last modified: 2019-09-30, 04:18 PM by Zow.)

They saved every weapon from the server after disconnected
But I wants them to custom save
exam: /getgun from the gang = not save
/weapon = save
sorry for my bad explain I don't know how to explain to be clear

PHP Code:
public OnPlayerDisconnect(playerid, reason)
{
for (new i = 0; i <= 12; i++)
{
   GetPlayerWeaponData(playerid, i, weapons1[i][0], weapons1[i][1]);
   if(!weapons1[i][0]) continue; // don't insert if there's no weapon in this slot
mysql_format(dbCon, query, sizeof(query), "INSERT INTO `WeaponData` (ID, WeaponID, Ammo) VALUES (%d, %d, %d) ON DUPLICATE KEY UPDATE `Ammo` = `Ammo` + %d", PlayerInfo[playerid][pSQLID], weapons1[i][0], weapons1[i][1], weapons1[i][1]);
mysql_query(dbCon, query);
printf("weapon: %d, ammo: %d", weapons1[i][0], weapons1[i][1]);
}
return 1;
} 

PHP Code:
 if(strcmp(cmd, "/weapon", true) == 0)
 {
     GivePlayerWeapon(playerid, 24, 500);
     GivePlayerWeapon(playerid, 30, 500);
     GivePlayerWeapon(playerid, 8, 1);
 } 

PHP Code:
 if(strcmp(cmd, "/getgun", true) == 0)
 {
     GivePlayerWeapon(playerid, 24, 500);
     GivePlayerWeapon(playerid, 30, 500);
     GivePlayerWeapon(playerid, 8, 1);
 } 

Tama · (This post was last modified: 2019-10-01, 04:27 AM by Tama.)

Make a detection variable and use it like this:

PHP Code:
new bool:gTemporaryGuns[MAX_PLAYERS]; //create a boolean (true/false)

public OnPlayerCommandText(playerid, cmdtext[])
{
      if (!strcmp(cmdtext, "/weapons", true))
      {
             //your code here.
             gTemporaryGuns[playerid] = false;
      }
      if(!strcmp(cmdtext, "/getgun", true))
      {
             //your code here.
             gTemporaryGuns[playerid] = true;
      }  
}

public OnPlayerDisconnect(playerid, reason)
{
        if (!gTemporaryGuns[playerid]) 
       {
               for (new i = 0; i <= 12; i++)
              {
                      GetPlayerWeaponData(playerid, i, weapons1[i][0], weapons1[i][1]);

                      if(!weapons1[i][0]) 
                            continue; // don't insert if there's no weapon in this slot

                      mysql_format(dbCon, query, sizeof(query), "INSERT INTO `WeaponData` (ID, WeaponID, Ammo) VALUES (%d, %d, %d) ON DUPLICATE KEY UPDATE `Ammo` = `Ammo` + %d", PlayerInfo[playerid][pSQLID], weapons1[i][0], weapons1[i][1], weapons1[i][1]);
                      mysql_query(dbCon, query);
                      printf("weapon: %d, ammo: %d", weapons1[i][0], weapons1[i][1]);
            }
     }
} 

So, with this, you can save only gun from /weapon.
I just give you an example tho, don't blame me if this not work :3