Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Script for items wipeout

Joined
Jan 17, 2008
Messages
320
Reaction score
0
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
 
Upvote 0
Newbie Spellweaver
Joined
Jun 16, 2008
Messages
26
Reaction score
0
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?
 
Upvote 0
Joined
Jan 17, 2008
Messages
320
Reaction score
0
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!!!
 
Upvote 0
Joined
Jan 17, 2008
Messages
320
Reaction score
0
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)
 
Upvote 0
Newbie Spellweaver
Joined
Jun 16, 2008
Messages
26
Reaction score
0
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'.
 
Upvote 0
Back
Top