butasro 1 Posted January 29, 2016 how do i add @charwipe command, thanks Quote Share this post Link to post Share on other sites
0 Kuya Jeo 120 Posted February 3, 2016 (edited) @@butasro here you go //===========================================// // Charwipe Script // version 1.0 // By Zhao Chow // Plug and Play Philippines // https://facebook.com/plugandplayPH //==========================================// - script plugandplay#charwipe -1,{ OnInit: bindatcmd "charwipe",strnpcinfo( 3 )+"::OnCharWipe",99,99; end; OnCharWipe: if ( .@atcmd_numparameters < 1 ) { message strcharinfo( 0 ),"Usage: @charwipe <char name>"; } else { .@charname$ = ""; for (.@i = 0; .@i < .@atcmd_numparameters; ++.@i) { .@charname$ += (.@i > 0 ? " " : "") + .@atcmd_parameters$[.@i]; } // Sql query // query_sql("SELECT `name` , `online` FROM `char` WHERE `name` = '"+.@charname$+"'",.@CharNameqry$, .@Onlineqry ); //----------// if ( .@CharNameqry$ != .@charname$ ) { message strcharinfo( 0 ),"Invalid Character Name"; end; } if ( .@CharNameqry$ == .@charname$ && .@Onlineqry == 1 ) { message strcharinfo( 0 ),"Character "+.@charname$+" has been reseted"; atcommand "@kick "+.@charname$; query_sql("UPDATE `char` SET `class`= 0 , `base_level` = 1 , `job_level` = 1 , `base_exp` = 1 , `job_exp` = 1 , `str` = 1 , `agi` = 1 , `vit` = 1 , `INT` = 1 , `dex` = 1 , `luk` = 1 , `status_point` = 48 , `skill_point` = 0 , `homun_id` = 0 WHERE `name`='"+.@charname$+"'"); end; } if ( .@CharNameqry$ == .@charname$ && .@Onlineqry == 0 ) { message strcharinfo( 0 ),"Character "+.@charname$+" has been reseted"; query_sql("UPDATE `char` SET `class`= 0 , `base_level` = 1 , `job_level` = 1 , `base_exp` = 1 , `job_exp` = 1 , `str` = 1 , `agi` = 1 , `vit` = 1 , `INT` = 1 , `dex` = 1 , `luk` = 1 , `status_point` = 48 , `skill_point` = 0 , `homun_id` = 0 WHERE `name`='"+.@charname$+"'"); end; } } end; } Edited February 3, 2016 by Zhao Chow 2 Quazi and butasro reacted to this Quote Share this post Link to post Share on other sites
0 Legend 43 Posted January 30, 2016 You can also do it via script.*sorry can't provide a working script right now, im currently using mobile.* Quote Share this post Link to post Share on other sites
0 Kuya Jeo 120 Posted January 31, 2016 @@butasro explain it so that we can make a script Quote Share this post Link to post Share on other sites
0 Dastgir 1246 Posted January 31, 2016 @@butasro explain it so that we can make a script Probably he means, delete all entries of specific character However I feel, this kind of thing should be atcommand but rather be scriptcommand for safety reasons. Quote Share this post Link to post Share on other sites
0 Kuya Jeo 120 Posted January 31, 2016 @@butasro explain it so that we can make a script Probably he means, delete all entries of specific character However I feel, this kind of thing should be atcommand but rather be scriptcommand for safety reasons. Like deleting the whole character for example : @charwipe dastgir, then all entries in dbase would be deleted? something like that? Quote Share this post Link to post Share on other sites
0 butasro 1 Posted February 2, 2016 @@butasro explain it so that we can make a script Probably he means, delete all entries of specific character However I feel, this kind of thing should be atcommand but rather be scriptcommand for safety reasons. Like deleting the whole character for example : @charwipe dastgir, then all entries in dbase would be deleted? something like that? sorry i mean, rivert back the character to lvl 1 all stats and skill will be gone, and stats point, it will rivert as new character, something like that Quote Share this post Link to post Share on other sites
0 Kuya Jeo 120 Posted February 2, 2016 @@butasro explain it so that we can make a script Probably he means, delete all entries of specific character However I feel, this kind of thing should be atcommand but rather be scriptcommand for safety reasons. Like deleting the whole character for example : @charwipe dastgir, then all entries in dbase would be deleted? something like that? sorry i mean, rivert back the character to lvl 1 all stats and skill will be gone, and stats point, it will rivert as new character, something like that Hmm, give us the whole info Only the Characters? How about Inventory Items? Storage Items? Cart Items? it will wipe or stay the same? Quote Share this post Link to post Share on other sites
0 butasro 1 Posted February 3, 2016 @@butasro explain it so that we can make a script Probably he means, delete all entries of specific character However I feel, this kind of thing should be atcommand but rather be scriptcommand for safety reasons. Like deleting the whole character for example : @charwipe dastgir, then all entries in dbase would be deleted? something like that? sorry i mean, rivert back the character to lvl 1 all stats and skill will be gone, and stats point, it will rivert as new character, something like that Hmm, give us the whole info Only the Characters? How about Inventory Items? Storage Items? Cart Items? it will wipe or stay the same? just the skillpoint statpoint joblevel baselevel of specific character, , Quote Share this post Link to post Share on other sites
0 Kuya Jeo 120 Posted February 3, 2016 (edited) @@butasro explain it so that we can make a script Probably he means, delete all entries of specific character However I feel, this kind of thing should be atcommand but rather be scriptcommand for safety reasons. Like deleting the whole character for example : @charwipe dastgir, then all entries in dbase would be deleted? something like that? sorry i mean, rivert back the character to lvl 1 all stats and skill will be gone, and stats point, it will rivert as new character, something like that Hmm, give us the whole info Only the Characters? How about Inventory Items? Storage Items? Cart Items? it will wipe or stay the same? just the skillpoint statpoint joblevel baselevel of specific character, , example : @charwipe butasro then your char will become novice and blvl & jlvl will turn into 1 right? Edit : give me 10mins to make the script Edited February 3, 2016 by Zhao Chow 1 butasro reacted to this Quote Share this post Link to post Share on other sites
0 butasro 1 Posted February 3, 2016 @@butasro explain it so that we can make a script Probably he means, delete all entries of specific character However I feel, this kind of thing should be atcommand but rather be scriptcommand for safety reasons. Like deleting the whole character for example : @charwipe dastgir, then all entries in dbase would be deleted? something like that? sorry i mean, rivert back the character to lvl 1 all stats and skill will be gone, and stats point, it will rivert as new character, something like that Hmm, give us the whole info Only the Characters? How about Inventory Items? Storage Items? Cart Items? it will wipe or stay the same? just the skillpoint statpoint joblevel baselevel of specific character, , example : @charwipe butasro then your char will become novice and blvl & jlvl will turn into 1 right? Edit : give me 10mins to make the script Thanks Master ^^ Quote Share this post Link to post Share on other sites
how do i add @charwipe command, thanks
Share this post
Link to post
Share on other sites