|
You last visited: Today at 02:37
Advertisement
[RELEASE] Siege Script for every 3day,1week and twice a month
Discussion on [RELEASE] Siege Script for every 3day,1week and twice a month within the Dekaron Private Server forum part of the Dekaron category.
02/02/2010, 03:07
|
#16
|
elite*gold: 0
Join Date: Nov 2008
Posts: 74
Received Thanks: 2
|
Quote:
Originally Posted by sun7684
SET @v_siege_no = SUBSTRING(dbo.FN_DateToShortStrDate(GetDate()), 3, 4) + '0001'
Individual name 'dbo.FN_DateToShortStrDate' error
|
should be
SUBSTRING(character.dbo.FN_DateToShortStrDate(GetD ate()), 3, 4) + '0001'
|
|
|
02/02/2010, 06:16
|
#17
|
elite*gold: 0
Join Date: Aug 2009
Posts: 1,297
Received Thanks: 928
|
wow, and u resurrected a 6 month old thread for nothing at all, thx for the info chief . . . . .
|
|
|
02/02/2010, 06:55
|
#18
|
elite*gold: 0
Join Date: Nov 2008
Posts: 74
Received Thanks: 2
|
Quote:
Originally Posted by Decima
wow, and u resurrected a 6 month old thread for nothing at all, thx for the info chief . . . . .
|
yeah but this info is important from the forum I come from You can resurrect a thread as long as its helpful am I right if not sorry, and sorry for trying to help some people, what I'm not sorry about is you trying to get your post number up by posting useless ****.
|
|
|
02/02/2010, 07:21
|
#19
|
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 833
|
Quote:
Originally Posted by Dyrizy
yeah but this info is important from the forum I come from You can resurrect a thread as long as its helpful am I right if not sorry, and sorry for trying to help some people, what I'm not sorry about is you trying to get your post number up by posting useless ****.
|
If a mod decides the thread is useful, he makes it sticky. And this is not useful anymore as it won't work as of 2010.
|
|
|
02/02/2010, 07:24
|
#20
|
elite*gold: 0
Join Date: Nov 2008
Posts: 74
Received Thanks: 2
|
Quote:
Originally Posted by Zombe
If a mod decides the thread is useful, he makes it sticky. And this is not useful anymore as it won't work as of 2010.
|
Edit the thing to work as of 2010 lol not that hard pretty simple I would aspect.
|
|
|
05/18/2012, 20:20
|
#21
|
elite*gold: 0
Join Date: Dec 2011
Posts: 46
Received Thanks: 3
|
Thanks so much!!!!!!!
|
|
|
02/18/2013, 07:50
|
#22
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
I'm sorry for bumping so old topic but something happened after I reinstalled mssql. I use siege script every sunday that ItsNobody posted but after the first siege next one is only after 2 weeks. why so happening?
|
|
|
02/18/2013, 14:04
|
#23
|
elite*gold: 0
Join Date: Jul 2010
Posts: 233
Received Thanks: 107
|
I have the same problem. First siege was oke, but the next siege was after 2 weeks.
|
|
|
02/18/2013, 15:09
|
#24
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
I think I found the problem only need to test.
when you open character.dbo.FN_GetSiegeStartBinTime you find:
Code:
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
even if you used script with:
Code:
-Once Week every Sunday-//SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
So just need try to change it manually and relaunch the script.
|
|
|
03/04/2013, 06:43
|
#25
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
BTW want to say that my posted method above is working.
|
|
|
03/20/2013, 19:23
|
#26
|
elite*gold: 0
Join Date: Mar 2008
Posts: 168
Received Thanks: 82
|
guys sorry for bumping again, but where is siege ritual start time in DB? or how to change it manually
|
|
|
Similar Threads
|
Please help siege script
08/31/2010 - Dekaron Private Server - 27 Replies
when i run siege script i got this error msg.
Msg 241, Level 16, State 1, Procedure SP_SIEGE_START_TIME_U, Line 52
Conversion failed when converting date and/or time from character string.
Why i try to run siege srcipt again ? !!!
cuz i got this error.
http://upic.me/i/gb/siegeerror.jpg
|
Help Change Siege Time ( Full Script )
07/20/2010 - Dekaron Private Server - 2 Replies
hello , i got my siege time on my test server start on sunday 21:00 server time ,
can someone please tell me how to change it to saturday 21:00 ? with the full script replacement.
Thanks, Zakurin
|
script to siege!
01/07/2010 - Dekaron Private Server - 41 Replies
this is the full script to siege enjoy!
DECLARE @v_siege_no char(10)
DECLARE @guild_code varchar(10)
DECLARE @v_strDate varchar(10)
DECLARE @v_regdate varchar(10)
DECLARE @v_strChannel varchar(2)
DECLARE @i_bychannel tinyint
DECLARE @o_dwDungeonRegistTime varbinary(4)
|
All times are GMT +1. The time now is 02:37.
|
|