try this
If anyone is having issues with castle event date and doesnt want to manually change it every 6-7 days if the server goes down or something I wrote this short fix and tutorial
Change your data/commonserverCS.cfg with the following values
The values are close to the bottom of the txt file on my config
Code:
CastleSiegeRun = 1
CastleCycleStartYear =0
CastleCycleStartMonth =0
CastleCycleStartDay =0
CastleSpecificState =0
CastleStateStartYear =0
CastleStateStartMonth =0
CastleStateStartDay =0
CastleStateStartHour =0
CastleStateStartMinute =0
That tells the castle siege event to run now we need to schedule automatic updating for the start and end dates
open Enterprise manager
go to MuOnline database
Click Tools->Job Scheduling
Click next then next
Make sure MuOnline is selected in drop down box
paste the following code into the transact-sql statement area
Code:
DECLARE @begindate datetime
DECLARE @enddate datetime
set @begindate = (dateadd(day,-1,GETDATE()))
set @enddate = (dateadd(day,6,GETDATE()))
update MuCastle_DATA
set SIEGE_START_DATE=@begindate, SIEGE_END_DATE=@enddate;
Click next
Select on a reoccuring basis
Click Schedule
Select Daily
Click ok
Click next then Click next
Write a meaningful job name and click Finish
In enterprise manager go to Management folder
Right click on SQL server agent and click Start if it isnt started already
The new job we just made is in the Jobs section
You can enable disable delete it reschedule whatever you like
Once these steps are complete once a day it will set the event start date to yesturday and the event end date to 6 days from today
or
// Setting of castle periods..
// Period ID Day Hour Minute
//=========================================================================
1
1 0 0 0 // Register Period
2 0 23 59 // Idle
3 0 0 0 // Register Mark Of The Lord
4 0 0 0 // Idle
5 0 12 0 // Castle Attack Guild Notification
6 0 19 0 // Ready For Castle Siege
7 0 20 0 // Castle Siege Start
8 0 22 0 // Castle Siege End
9 0 0 0 // End of Cycle
end
also check
http://forum.ragezone.com/f196/play-...nt-1-a-129791/
anyway? anyone want to explain what is in the image? as you notice a add mark in every line in the image because I want to know what is that
