Recall character in ID to save point

[saovarott159]

Hello...

    Script request  (for example in Picture...)

Thank you so much

 

Edited January 17, 2017 by saovarott159

[Athan17]

3 minutes ago, saovarott159 said:

Thank you so much

But don,t work (Bug in Picture)

haha i thought so, here's an update regarding bug check. sorry i cant test it in office.
 

// Reset Position In-game version

prontera,160,160,4	script	Position Reset	909,{
	mes "[System]";
	mes "Please select a character";
	mes "return to save point...";
	set [email protected], query_sql("SELECT `char_id`,`name` FROM `char` WHERE `account_id` = "+getcharid(3),[email protected],[email protected]$);
	set [email protected]$, "";

	for ( set @ctr,0; @ctr < [email protected]; @ctr++ )
		[email protected]$ = [email protected]$ + [email protected]$[@ctr]+":";
	[email protected] = [email protected]$ + "Cancel";

	set [email protected], select([email protected]$)-1;
	next;

	if( [email protected] < [email protected] )
	{
		if( getcharid(0) != [email protected][[email protected]] )
		{
			query_sql("UPDATE `char` AS ch SET ch.last_map = ch.save_map, ch.last_x = ch.save_x, ch.last_y = ch.save_y WHERE ch.char_id = "[email protected][[email protected]]);
			mes [email protected]$[@selectedchar] + "'s position has been reset.";
		}
		else
		{
			// TODO: instead of having if-else, its better not to show the invoker's name in selection.
			mes "you cant reset your own position";
		}
	}
	end;
}

 

[Athan17]

made this script few hours ago, but im too scared to post it, might have a lot of bugs on it coz didnt tested it yet.

// Reset Position In-game version

prontera,160,160,4	script	Position Reset	909,{
	mes "[System]";
	mes "Please select a character";
	mes "return to save point...";
	set .@count, query_sql("SELECT `char_id`,`name` FROM `char` WHERE `account_id` = "+getcharid(3),.@charid,.@charname$);
	set .@menu$, "";

	for ( set @ctr,0; @ctr < .@count; @ctr++ )
		.@menu$ = .@menu$ + .@charname$[@ctr]+":";
	.@menu = .@menu$ + "Cancel";

	set .@selectedchar, select(.@menu)-1;
	next;

	if( .@selectedchar < .@count )
	{
		if( getcharid(0) != .@charid[.@selectedchar] )
		{
			query_sql("UPDATE `char` AS ch SET ch.last_map = ch.save_map, ch.last_x = ch.save_x, ch.last_y = ch.save_y WHERE ch.char_id = "+.@charid[.@selectedchar]);
			mes .@charname$[@selectedchar] + "'s position has been reset.";
		}
		else
		{
			// TODO: instead of having if-else, its better not to show the invoker's name in selection.
			mes "you cant reset your own position";
		}
	}
	end;
}

 

[Athan17]

may i know who will use this NPC? anyone or GM only?
is it like, a reset position in-game? so if you have another character that is stuck, you can just character select~>use another char then talk to this npc, list up all your characters then return to savepoint the selected char?
or GM only npc that once accessed, the npc will list up all/online players then return a chosen player to their save point?

[saovarott159]

2 minutes ago, Athan17 said:

may i know who will use this NPC? anyone or GM only?
is it like, a reset position in-game? so if you have another character that is stuck, you can just character select~>use another char then talk to this npc, list up all your characters then return to savepoint the selected char?
or GM only npc that once accessed, the npc will list up all/online players then return a chosen player to their save point?

Hi..

1.use this NPC? anyone or GM only?  >>  Anyone

2.reset position in-game?  >>  Yes

3.so if you have another character that is stuck, you can just character select~>use another char then talk to this npc, list up all your characters then return to savepoint the selected char?  >> Yes

4.or GM only npc that once accessed >>  Anyone

5.the npc will list up all/online players then return a chosen player to their save point? >> list up offline players in ID

 

[saovarott159]

55 minutes ago, Athan17 said:

made this script few hours ago, but im too scared to post it, might have a lot of bugs on it coz didnt tested it yet.

// Reset Position In-game version

prontera,160,160,4	script	Position Reset	909,{
	mes "[System]";
	mes "Please select a character";
	mes "return to save point...";
	set .@count, query_sql("SELECT `char_id`,`name` FROM `char` WHERE `account_id` = "+getcharid(3),.@charid,.@charname$);
	set .@menu$, "";

	for ( set @ctr,0; @ctr < .@count; @ctr++ )
		.@menu$ = .@menu$ + .@charname$[@ctr]+":";
	.@menu = .@menu$ + "Cancel";

	set .@selectedchar, select(.@menu)-1;
	next;

	if( .@selectedchar < .@count )
	{
		if( getcharid(0) != .@charid[.@selectedchar] )
		{
			query_sql("UPDATE `char` AS ch SET ch.last_map = ch.save_map, ch.last_x = ch.save_x, ch.last_y = ch.save_y WHERE ch.char_id = "+.@charid[.@selectedchar]);
			mes .@charname$[@selectedchar] + "'s position has been reset.";
		}
		else
		{
			// TODO: instead of having if-else, its better not to show the invoker's name in selection.
			mes "you cant reset your own position";
		}
	}
	end;
}

 

Thank you so much

But don,t work (Bug in Picture)

[saovarott159]

3 minutes ago, Athan17 said:

haha i thought so, here's an update regarding bug check. sorry i cant test it in office.
 

// Reset Position In-game version

prontera,160,160,4	script	Position Reset	909,{
	mes "[System]";
	mes "Please select a character";
	mes "return to save point...";
	set [email protected], query_sql("SELECT `char_id`,`name` FROM `char` WHERE `account_id` = "+getcharid(3),[email protected],[email protected]$);
	set [email protected]$, "";

	for ( set @ctr,0; @ctr < [email protected]; @ctr++ )
		[email protected]$ = [email protected]$ + [email protected]$[@ctr]+":";
	[email protected] = [email protected]$ + "Cancel";

	set [email protected], select([email protected]$)-1;
	next;

	if( [email protected] < [email protected] )
	{
		if( getcharid(0) != [email protected][[email protected]] )
		{
			query_sql("UPDATE `char` AS ch SET ch.last_map = ch.save_map, ch.last_x = ch.save_x, ch.last_y = ch.save_y WHERE ch.char_id = "[email protected][[email protected]selectedchar]);
			mes [email protected]$[@selectedchar] + "'s position has been reset.";
		}
		else
		{
			// TODO: instead of having if-else, its better not to show the invoker's name in selection.
			mes "you cant reset your own position";
		}
	}
	end;
}

 

Thank you very so much....

[saovarott159]

Hello help me please...

         Script system recall character it work 

but system recall character in jail to save point

How to fix...

// Reset Position In-game version

prontera,179,99,3	script	Position Reset	541,{
	mes "[System recall]";
	mes "Please select character";
	set .@count, query_sql("SELECT `char_id`,`name` FROM `char` WHERE `account_id` = "+getcharid(3),.@charid,.@charname$);
	set .@menu$, "";

	for ( set @ctr,0; @ctr < .@count; @ctr++ )
		.@menu$ = .@menu$ + .@charname$[@ctr]+":";
	.@menu = .@menu$ + "Cancel";

	set .@selectedchar, select(.@menu$)-1;
	next;

	if( .@selectedchar < .@count )
	{
		if( getcharid(0) != .@charid[.@selectedchar] )
		{
			query_sql("UPDATE `char` AS ch SET ch.last_map = ch.save_map, ch.last_x = ch.save_x, ch.last_y = ch.save_y WHERE ch.char_id = "+.@charid[.@selectedchar]);
//			mes [email protected]$[@selectedchar] + "'s position has been reset.";  //not work because show name incorrect.
			mes "recalled";
		}
		else
		{
			// TODO: instead of having if-else, its better not to show the invoker's name in selection.
			mes "not recall";
		}
	}
	end;
}

 

 

[Emistry]

set [email protected], query_sql("SELECT `char_id`,`name` FROM `char` WHERE `account_id` = "+getcharid(3),[email protected],[email protected]$);

change to

set [email protected], query_sql("SELECT `char_id`,`name` FROM `char` WHERE `last_map` <> 'sec_pri' AND `account_id` = "+getcharid(3),[email protected],[email protected]$);

 

[saovarott159]

15 minutes ago, Emistry said:

set [email protected], query_sql("SELECT `char_id`,`name` FROM `char` WHERE `account_id` = "+getcharid(3),[email protected],[email protected]$);

change to

set [email protected], query_sql("SELECT `char_id`,`name` FROM `char` WHERE `last_map` <> 'sec_pri' AND `account_id` = "+getcharid(3),[email protected],[email protected]$);

 

It work thank you somuch...

How to fix show charector name recall to save point..

Please...

//			mes [email protected]$[@selectedchar] + "'s position has been reset.";  //not work because show name incorrect.

[Emistry]

1 hour ago, saovarott159 said:

@selectedchar

change to

[email protected]

 

[saovarott159]

11 minutes ago, Emistry said:

change to

[email protected]

 

Thank you very so much..