Jump to content
  • 0
butasro

@charwipe any one?

Question

10 answers to this question

Recommended Posts

  • 0

@@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 by Zhao Chow

Share this post


Link to post
Share on other sites
  • 0

You can also do it via script.
*sorry can't provide a working script right now, im currently using mobile.*

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

 

@@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?

Share this post


Link to post
Share on other sites
  • 0

 

 

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

Share this post


Link to post
Share on other sites
  • 0

 

 

 

@@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?

 

Share this post


Link to post
Share on other sites
  • 0

 

 

 

 

@@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, ,

Share this post


Link to post
Share on other sites
  • 0

 

 

 

 

 

@@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 by Zhao Chow

Share this post


Link to post
Share on other sites
  • 0

 

 

 

 

 

 

@@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 ^^

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.