Tele characters totheirownMainland automatically when they're logged out in CZ

[Thales]

Hi. I have created a Stored Procedure. This procedure teleports to all users to own mainland if they are logged out game in CZ.

Launch Query Analyzer, paste this code, select your DB and press F5:

-- This SP has written by Thales.
CREATE PROCEDURE MAINLAND

AS

BEGIN

-- For El Morad users

update USERDATA set Zone = '2', PX = '159609', PZ = '42089', PY= '1569' where Zone = '201' and Nation = '2'

-- For Karus users

update USERDATA set Zone = '1', PX = '44600', PZ = '163100', PY = '1240' where Zone = '201' and Nation = '1'

END
GO

Go to Stored Procedures in your DB, open ACCOUNT_LOGOUT and ACCOUNT_LOGOUT2 (If you have), write this code above GO:

exec MAINLAND

What is that PX, PY and PZ's?

They are located the character to coordinates I have been written. I created an El Morad and a Karus character and I used /Town command, I looked at USERDATA and I added that to procedure If I did not use this codes, I was resurrecting near Hornets

That's it Enjoy

 

[spamman]

Re: Teleport characters to their own Mainland automatically when they're logged out i

why do you need to be out of cz? I don't get it.

 

[Thales]

Re: [Share]Tele characters totheirownMainland automatically when they're logged out i

USKO style

 

[YaNnIXx]

Re: [Share]Tele characters totheirownMainland automatically when they're logged out i

If they login they don't get nuked by four thousand humans.
Nice creation.

 

[OMEGAbuffer]

Re: [Share]Tele characters totheirownMainland automatically when they're logged out i

Thx

 

[Sinner_KO]

Re: [Share]Tele characters totheirownMainland automatically when they're logged out i

why not just modify update userdata procedure add to end

if @zone = 201 and @nation = 2 update userdata set @zone = 2 where struserid = @id
if @zone = 201 and @nation = 1 update userdata set @zone = 1 where struserid = @id