[RELEASE] Siege Script for every 3day,1week and twice a month

Page 2 of 2

02/02/2010 03:07 Dyrizy#16

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 Decima#17

wow, and u resurrected a 6 month old thread for nothing at all, thx for the info chief . . . . .

02/02/2010 06:55 Dyrizy#18

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 crap.

02/02/2010 07:21 Zombe#19

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 crap.

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 Dyrizy#20

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 kbgqedtt#21

Thanks so much!!!!!!!

02/18/2013 07:50 gedimazs#22

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 imissblood#23

I have the same problem. First siege was oke, but the next siege was after 2 weeks.

02/18/2013 15:09 gedimazs#24

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 gedimazs#25

BTW want to say that my posted method above is working.

03/20/2013 19:23 mcsamuraicz#26

guys sorry for bumping again, but where is siege ritual start time in DB? or how to change it manually

Page 2 of 2