Query putting items into backpack

[Uebermorgen]

Hi,

 

is there any possiblity to add an item via query in the backpack of a user?

would be nice!
 

 

 

cheers

[ElDubya]

You can remove items via SQL from backpacks, safes, vehicles, etc. I see no reason why you couldn't add items, providing you have the correct item code. I am by no means an expert in these matters though.

[Uebermorgen]

yea, but how?

[syco]

Open HeidiSQL or PhpMyAdmin or w/e you connect to your database. Find the player you wish to give inventory to in Player_data. Remember the last four of his/her PlayerUID. Now under Character_data search for that PlayerUID. Check to make sure the character's inventory is alive that you will be editing by looking at the Alive row. For HeidiSQL. If Alive = 1 then that character is alive. If Alive = 0 then that character is dead.

I think for PhpMyAdmin.  I could be wrong. Have not used PhpMyAdmin in years but it should be the opposite Alive = 1 is dead and Alive = 0 is alive. NOTE: The Alive one will stand out because only one of the characters of the PlayerUID will be one number while every other one is all another number. Only can have one alive, the rest dead.

 

To add items in backpack. The first set of brackets is for weapon slots. Second set of brackets is for the number of weapon for each from the first bracket. Third set of brackets is for Magazine slots with the forth set of brackets for number of magazine from the third set. Each number of weapon/magazine from the second/forth set of brackets starts from left to right from the first/third set of brackets.

["DZ_TK_Assault_Pack_EP1",[[],[]],[[],[]]]

So to add one weapon and 6 mags to a backpack It will look like this.

["DZ_TK_Assault_Pack_EP1",[["M4A1_AIM_SD_camo"],[1]],[["30Rnd_556x45_StanagSD"],[6]]]

To add 2 weapons and 6 mags for each weapon to a backpack it will look like this.

["DZ_Backpack_EP1",[["M4A1_AIM_SD_camo","DMR"],[1,1]],[["30Rnd_556x45_StanagSD","20Rnd_762x51_DMR"],[6,6]]]

The key thing is to know the class name of each item and follow the format.

 

Example of a lot of stuff added to a backpack.

["DZ_CivilBackpack_EP1",[["BAF_LRR_scoped","ItemCompass","ItemKnife"],[1,1,1]],[["ItemAntibiotic","ItemBloodbag","ItemEpinephrine","PartPlankPack","ItemPainkiller","5Rnd_86x70_L115A1","Skin_Soldier1_DZ","ItemWaterbottleBoiled","fuel_pump_kit","ItemJerrycan","ItemMorphine","SmokeShell","ItemDocumentRamp","PartPlywoodPack","ItemSodaRbull","ItemGoldBar2oz","TrashTinCan"],[1,3,1,2,1,1,1,1,1,1,1,1,1,1,1,1,1]]]

I think you see the trend starting. Its not very hard and good thing is if you mess up the player just will have nothing and you can start over.

 

NOTE: The player needs to in the lobby when you edit there inventory/backpack.

 

Hope this helps, cheers.

[ElDubya]

^^^^What he said, tested tonight and works perfectly.

[Scaramanga]

Not a query though