Script for items wipeout

i need a script that can wipeout all the items exept the char level,etc/.

easy dude ^_^!! here try mine!!

Code:

---

Use [RanGame1]
Update [ChaInfo] set [ChaInfo].ChaInven = NULL

---

or if you want all of items to remove (you wearing and on the inventory) here

Code:

---

Use [RanGame1]
Update [ChaInfo] set [ChaInfo].ChaInven = NULL
Update [ChaInfo] set [ChaInfo].ChaPutOnItems = NULL

---

and if you want to delete all items and all skills here:

Code:

---

Use [RanGame1]
Update [ChaInfo] set [ChaInfo].ChaInven = NULL
Update [ChaInfo] set [ChaInfo].ChaPutOnItems = NULL
Update [ChaInfo] set [ChaInfo].ChaSkills = NULL
Update [ChaInfo] set [ChaInfo].ChaSkillSlot = NULL

---

that's all ^^ hope it helps

Quote:

---

Originally Posted by michael2k10

easy dude ^_^!! here try mine!!

Code:

---

Use [RanGame1]
Update [ChaInfo] set [ChaInfo].ChaInven = NULL

---

or if you want all of items to remove (you wearing and on the inventory) here

Code:

---

Use [RanGame1]
Update [ChaInfo] set [ChaInfo].ChaInven = NULL
Update [ChaInfo] set [ChaInfo].ChaPutOnItems = NULL

---

and if you want to delete all items and all skills here:

Code:

---

Use [RanGame1]
Update [ChaInfo] set [ChaInfo].ChaInven = NULL
Update [ChaInfo] set [ChaInfo].ChaPutOnItems = NULL
Update [ChaInfo] set [ChaInfo].ChaSkills = NULL
Update [ChaInfo] set [ChaInfo].ChaSkillSlot = NULL

---

that's all ^^ hope it helps

---

michael
how 2 apply this? how doesn't working
sorry no idea how to used this?

just go to RanGame1 and right click then new query and execute it will have like this :

(# row(s) affected)

NOTE: it will erase your char all items!!!

Quote:

---

Originally Posted by michael2k10

just go to RanGame1 and right click then new query and execute it will have like this :

(# row(s) affected)

NOTE: it will erase your char all items!!!

---

i see thx dude!!!

added if you want to erase only your choice character here's the script

Code:

---

Use [RanGame1]
Update [ChaInfo]
set [ChaInfo].ChaInven = NULL
where ChaNum = (the num of Char)
Update [ChaInfo]
set [ChaInfo].ChaPutOnItems = NULL
where ChaNum = (the num of Char)

---

Quote:

---

Originally Posted by michael2k10

added if you want to erase only your choice character here's the script

Code:

---

Use [RanGame1]
Update [ChaInfo]
set [ChaInfo].ChaInven = NULL
where ChaNum = (the num of Char)
Update [ChaInfo]
set [ChaInfo].ChaPutOnItems = NULL
where ChaNum = (the num of Char)

---

---

got error
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'num'.
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near 'num'.

Replace (the num of Char) with the character number of the character you wish to erase the items.

Quote:

---

Originally Posted by austhistikated

Replace (the num of Char) with the character number of the character you wish to erase the items.

---

i see i get now thx for the wonderful explanation .