Auto Teleport Idea..

[NourAyman]

Hello ..

I saw that there are many interests about " Auto Equipment "

so idk maybe no one made it work with auto teleport at the same POS . but without any program

and some people made it work with scrolls .. but i thought about making it with auto teleport

i think maybe these help us ..

StoredProcedure [dbo].[_ModifyCharPos]

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_ModifyCharPos]    Script Date: 2/9/2014 5:47:15 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

-- ¾È¹Ù²ãµµ µÇ°Ú´Ù by novice.
ALTER  PROCEDURE [dbo].[_ModifyCharPos]
 @name 		varchar(64),
 @region		smallint,
	@x		float,
	@y		float,
	@z		float,
 @WorldiD	smallint
AS
	-- not existing character
	declare @Charid int
	set @Charid = 0
	select @Charid = charid from _char where charname16 = @name
	if (@@rowcount = 0 or @Charid is null or @Charid = 0)
	begin
		select -2
		return
	end
	-- failed to rename
	update _Char set LatestRegion = @region, PosX = @x, PosY = @y, PosZ = @z, WorldID = @WorldiD where CharName16 = @name
	if (@@error <> 0 or @@rowcount = 0)
	begin
		select -4
		return
	end
	select 1
	return

and i think this can help us at that Stored Procedure

update _Char set LatestRegion = @region, PosX = @x, PosY = @y, PosZ = @z, WorldID = @WorldiD where CharName16 = @name
	if (@@error <> 0 or @@rowcount = 0)
	begin
		select -4
		return
	end
	select 1
	return

and maybe that too _ResetCharPos

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_ResetCharPos]    Script Date: 2/9/2014 6:06:09 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_ResetCharPos]
as
	set xact_abort on
	
begin transaction
	-- reset aux pos
	update _Char set TelRegion = 0, TelPosX = 0, TelPosY = 0, TelPosZ = 0, DiedRegion = 0, DiedPosX = 0, DiedPosY = 0, DiedPosZ = 0
	
	-- initialize char pos
	declare @ReFTelID int
	declare @regionID int
	declare @PosX real
	declare @PosY real
	declare @PosZ real
	declare @CharID int
	declare @teliD int
	declare @CharName	varchar (64)

	declare char_cursor 	cursor fast_forward for
	select CharID, AppointedTeleport, CharName16
	from	_Char with(nolock) 
	
	open char_cursor
	fetch next from char_cursor into @CharID, @teliD, @CharName
	while (@@fetch_status = 0)
	begin
		if  @teliD is not null and @teliD <> 0)
		begin
	
			set @regionID = 0 
			set @PosX = 0
			set @PosY = 0
			set @PosZ = 0
			
			select @ReFTelID = ID from _RefObjCommon where ID = @teliD
			select @regionID = GenRegionID, @PosX = GenPos_X, @PosY = GenPos_Y, @PosZ = GenPos_Z from _RefTeleport where AssocRefObjID = @ReFTelID
	
			update _char set LatestRegion = @regionID, PosX = @PosX, PosY = @PosY, PosZ = @PosZ where CharID = @CharID
		
		exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',2,1
		exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RESURRECTION_100P_SCROLL',1,1
	
end
	
		fetch next from char_cursor into @CharID, @teliD, @CharName
	end
	close char_cursor
	deallocate char_cursor
commit transaction

By using this idea

EXEC dbo.xxx @Charid, @curRegionID, @curPOSY ..etc

but it maybe client side not gameserver


So .. Any ideas about that ? :?

[MentaL]

[Molten]

You can't teleport a player through a database query or a procedure.

[NourAyman]

So it's client side .. huh ?

[DrugDealers]

So it's client side .. huh ?

you have to create a program with C# like auto notice

and you will make DB Log For People which you need to teleport them

than you will just change the packets from program auto notice to packet of > recalluser command of gm

sry for bad english :)

[NourAyman]

Hmm .. sounds good :)

can you give us the packets ? :)

[Tazdingo]

Hmm .. sounds good :)

can you give us the packets ? :)

0x7010
17
0
Charname

[DrugDealers]

Hmm .. sounds good :)

can you give us the packets ? :)

you can get it by your self with edx loader just run the command via gm console and you will find it in the loader console

[karemsame]

0x7010
17
0
Charname

bro from where you got the number 17 and 0 ?

[Tazdingo]

bro from where you got the number 17 and 0 ?

The bytes you must send for the client that know that you are using recalluser.

[karemsame]

The bytes you must send for the client that know that you are using recalluser.

sory bro i'm newbie, i need to know thing , you got the number 17 for Recall user how i can get number byte for make item or loadmonster ?

[pr0xy1337]

You need a C# bot to do this :
if conditions is true (level 81 reached for example)
/movetouser UserThatReached81
===
/recalluser UserThatReached81

You won't need to get any positions or something just on level up movetouser and recalluser :)

[Royalblade]

well then, what happens, if 50 people level up within the same minute?
Ya know it? I do... SHIT happens. It doesn't reload cuz its busy doing some ass penetration on other chars.
You'll need multiple bots for that crap and you'll need to mark one as "busy" while he's porting around. This whole thing prolly takes 3 secs. That'd be you can only have 20 level ups per minute which is real bullshit.
Also, why do you keep chewing on old "systems" instead of developing new ones?

[pr0xy1337]

nobody said it will be a perfect.. but still is some shitty way :D

[Royalblade]

0x7010
17
0
Charname

By the way, that's wrong.

0x7010 -- GM Command opcode.. usually the same for all gm commands.
17 -- Identifier for /recalluser
UInt16 -- Amount of bytes of charname
Charname -- ascii, charname simply.

[lemoniscool]

You need a C# bot to do this :
if conditions is true (level 81 reached for example)
/movetouser UserThatReached81
===
/recalluser UserThatReached81

You won't need to get any positions or something just on level up movetouser and recalluser :)

tried already, it failed at only 300 players already and not all of them were leveling up at the time the bot failed