Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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

Initiate Mage
Joined
Jun 29, 2008
Messages
4
Reaction score
0
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:

Code:
-- 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:

Code:
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 :p

That's it ;) Enjoy :)
 
Last edited:
Junior Spellweaver
Joined
Jun 5, 2006
Messages
133
Reaction score
0
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.
 
Initiate Mage
Joined
Jun 29, 2008
Messages
4
Reaction score
0
Re: [Share]Tele characters totheirownMainland automatically when they're logged out i

USKO style ;)
 
Newbie Spellweaver
Joined
Jan 18, 2006
Messages
10
Reaction score
0
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.
 
Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
Re: [Share]Tele characters totheirownMainland automatically when they're logged out i

Thx
 
Initiate Mage
Joined
Sep 1, 2008
Messages
2
Reaction score
0
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
 
Back
Top