So HOW exactly can I change the SIEGE START TIME! I have looked EVERYWHERE all over for the last 4 hours and not ONE thread has a complete answer or they are just all not answered at all.
You can change this line all day and you won't get anywhere!:
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '160000'
You can also change this line all day and you wont get any difference!:
VALUES (@v_siege_no, 1, @guild_code, @guild_name,@v_siege_start_time, 16, 0X0000, 'Y')
As you can tell... I'm trying to change my server siege start time to 4 pm. After changing those line anyway you want I reboot the server and its still 1 am. After doing siege start and end, it just changes my original day from (sat) to (sun) and the new siege start time is now starting at 21:00 aka 9 pm.
Like really, there is NO thread with a full answer and I can almost bet there is no thread on why after siege 1, siege 2 starts 8 days after and with a new time completely..
Any knowledge and info would be much appreciated! Thanks!