Re: Script for items wipeout
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
Re: Script for items wipeout
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?
Re: Script for items wipeout
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!!!
Re: Script for items wipeout
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!!!
Re: Script for items wipeout
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)
Re: Script for items wipeout
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'.
Re: Script for items wipeout
Replace (the num of Char) with the character number of the character you wish to erase the items.
Re: Script for items wipeout
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 .