Reset query Inventory

[Boossik]

Hello!
Can someone help my write mssql query for reset? I need make reset script who delete ONLY equipment items (not all inventory and personal shop)

i know all inventory is 108 items
12 equipment (who i need reset)
64 invenotry (dont need touch)
32 personal shop (dont need touch)

1 empty item code is 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF

and how make full script why dont delete items from inventory and personal shop? need delete only equipment items

i make 32*12 (F) all ok, script delete equipment items, but in all others places (inventory and personal shop) in all slots is kris...

0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF

[MentaL]

[ScriptKid]

you mean you want to delete all of them i.e p.shop inventory and equip?

[afonsolage]

You'll need to do a SUBSTRING, getting only what you want to save, in this case 64+32 items, and save on a variable, after it, you update the Inventory field with a concate REPEAT(12, 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')+@VARIABLE_WITH_SAVED_ITEMS.

This is the logic, if you are having trouble with SQL Syntax, post it here and we can help you.

[ScriptKid]

check my thread in the release section. SQL Script new character with starting items

[Boossik]

You'll need to do a SUBSTRING, getting only what you want to save, in this case 64+32 items, and save on a variable, after it, you update the Inventory field with a concate REPEAT(12, 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF')+@VARIABLE_WITH_SAVED_ITEMS.

This is the logic, if you are having trouble with SQL Syntax, post it here and we can help you.

Thanks for idea!
Need make script

1 step need save player inventory begin reset
2 step need change (fill with FFFFFF...) first 12 item codes and other 64 and 32 dont touch

i dont know REPEAT string