auto give all maps to new chars (timed)

[HellCat_666]

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 =

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

 

[terzo]

why do not go to Account > cabal_newchardata_table and add it? O.O

 

[cyfren]

Thanks man are working fine !

 

[BUDS4EVER]

what make in Account > cabal_newchardata_table? terzo

 

[cypher]

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.