Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 02:37

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Reply
 
Old 02/02/2010, 03:07   #16
 
elite*gold: 0
Join Date: Nov 2008
Posts: 74
Received Thanks: 2
Quote:
Originally Posted by sun7684 View Post
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'
Dyrizy is offline  
Old 02/02/2010, 06:16   #17
 
Decima's Avatar
 
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 . . . . .
Decima is offline  
Old 02/02/2010, 06:55   #18
 
elite*gold: 0
Join Date: Nov 2008
Posts: 74
Received Thanks: 2
Quote:
Originally Posted by Decima View Post
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 ****.
Dyrizy is offline  
Thanks
1 User
Old 02/02/2010, 07:21   #19
 
Zombe's Avatar
 
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 833
Quote:
Originally Posted by Dyrizy View Post
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.
Zombe is offline  
Old 02/02/2010, 07:24   #20
 
elite*gold: 0
Join Date: Nov 2008
Posts: 74
Received Thanks: 2
Quote:
Originally Posted by Zombe View Post
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.
Dyrizy is offline  
Old 05/18/2012, 20:20   #21
 
elite*gold: 0
Join Date: Dec 2011
Posts: 46
Received Thanks: 3
Thanks so much!!!!!!!
kbgqedtt is offline  
Old 02/18/2013, 07:50   #22
 
gedimazs's Avatar
 
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?
gedimazs is offline  
Old 02/18/2013, 14:04   #23
 
imissblood's Avatar
 
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.
imissblood is offline  
Old 02/18/2013, 15:09   #24
 
gedimazs's Avatar
 
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.
gedimazs is offline  
Thanks
1 User
Old 03/04/2013, 06:43   #25
 
gedimazs's Avatar
 
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
BTW want to say that my posted method above is working.
gedimazs is offline  
Thanks
2 Users
Old 03/20/2013, 19:23   #26
 
mcsamuraicz's Avatar
 
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
mcsamuraicz is offline  
Reply


Similar Threads 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.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.