Script for items wipeout

[Abry]

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

 

[michael2k10]

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

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

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

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:

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

 

[Practiz]

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

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

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

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:

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?

 

[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!!!

 

[Practiz]

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!!!

 

[michael2k10]

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

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)

 

[Practiz]

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

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'.

 

[austhistikated]

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

 

[Practiz]

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 .