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
If this helps anyone please thank me
Regards Duindain
---------- Post added at 10:31 AM ---------- Previous post was at 10:30 AM ----------
Originally Posted by
unikome
pliz help me !!T_T
when i run Game server it's write
"An internal exception occured(address: 0x0)
please, contact
support@oreans.com. Thank you!"
Are you using windows xp? because the server doesnt support that os
Reply With Quote
