auto give all maps to new chars (timed)

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
 
why do not go to Account > cabal_newchardata_table and add it? O.O
 
Back