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!

auto give all maps to new chars (timed)

Newbie Spellweaver
Joined
May 15, 2006
Messages
82
Reaction score
1
ok for the people who dont know how to ad all maps ore dont want to
take the time to do it every time manualy
i put a litle guide together

1 Enterprise Manager
2 Open you server and choose Management > SQL Server Agent > job
3 Click right mouse button in you right side, New Job
4 General Tab
Name = ad maps/warps System
Owner = sa
5 Steps Tab
Press NEW... button
6 New Job Step - General Tab
Step Name = ad maps/warps
Database = GameDB
Command =
Code:
update dbo.cabal_character_table set WarpBfield=1023, MapsBField=1023



7 Edit Recurring Job Schedule
Occurs = Daily
Daily Frequecy = Occurs Every
1 = 10 Hour(s) = Minute(s)
00:00:00 = 23:00:00
Start Date = 1 day before today
Press OK
Press OK
Press OK
thats it

now it wil update every hour but edit time to your liking for deverent time's

WarpBfield=1023, MapsBField=1023 is for all maps til pontus ferum
WarpBfield=511, MapsBField=511 is for al maps til lake side

i use some pieces from other guides so credits go to terzo for his reset guide AND dezon for ths sql code

gr HellCat
 
Banned
Banned
Joined
Sep 6, 2007
Messages
834
Reaction score
167
why do not go to Account > cabal_newchardata_table and add it? O.O
 
Experienced Elementalist
Joined
Sep 26, 2008
Messages
211
Reaction score
2
Thanks man are working fine !
 
The Cat in the Hat
Legend
Joined
Oct 26, 2005
Messages
4,475
Reaction score
677
I should have watched my mouth and not said/talked poop to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.
 
Back
Top