Register for your free account! | Forgot your password?


Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 06:03

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

Advertisement



[HELP]Dekaron Siege War Time

Discussion on [HELP]Dekaron Siege War Time within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jun 2011
Posts: 159
Received Thanks: 2
[HELP]Dekaron Siege War Time

I have a problem.

How can i fix the time of Server?

you will see in game at Bastian(NPC) it says

Next Siege War Battle Time
2002 9/23 Wednesday 21:00

is that the original one?
yepee22 is offline  
Old 09/13/2012, 17:41   #2
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,122
Received Thanks: 223
you can start siege with GM command ...
elfulll is offline  
Old 09/13/2012, 19:09   #3
 
elite*gold: 0
Join Date: Apr 2011
Posts: 305
Received Thanks: 44
Me Use


And

Quote:
USE [Character];
GO

DECLARE @v_siege_no char(10)
DECLARE @guild_code varchar(10)
DECLARE @guild_name varchar(30)
DECLARE @v_strDate varchar(10)
DECLARE @v_regdate varchar(10)
DECLARE @v_strChannel varchar(2)
DECLARE @i_bychannel tinyint
DECLARE @o_dwDungeonRegistTime varbinary(4)
DECLARE @o_DeadFrontTimeInfo varbinary(1000)
DECLARE @o_sp_rtn int
DECLARE @o_dwRegistTimeStart varbinary(4)
DECLARE @o_dwRegistTimeEnd varbinary(4)
DECLARE @o_dwTaxRegistTime varbinary(4)
DECLARE @o_dwStartTime varbinary(4)
DECLARE @o_dwRegistTime varbinary(4)
DECLARE @v_strDate1 varchar(10)
DECLARE @i_GetDate datetime
DECLARE @v_siege_start_date varchar(14)
DECLARE @v_siege_start_time varbinary(4)

SET @i_GetDate=getdate()

-- Siege War Every Saturday:

SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

--

SELECT @v_siege_start_time = SUBSTRING(@v_siege_start_date,4,1) * 100000000
+ SUBSTRING(@v_siege_start_date,5,2) * 1000000
+ SUBSTRING(@v_siege_start_date,7,2) * 10000
+ SUBSTRING(@v_siege_start_date,9,2) * 100
+ SUBSTRING(@v_siege_start_date,11,2)

SET @guild_code = '001'
SET @guild_name = 'FIRSTGUILD'
SET @v_siege_no = SUBSTRING(dbo.FN_DateToShortStrDate(GetDate()), 3, 4) + '0001'
INSERT
INTO GUILD_INFO(guild_code, guild_name, guild_Level, bystate, bychannel)
VALUES (@guild_code, @guild_name, 3, 1, 1)
INSERT

INTO SIEGE_INFO(SIEGE_NO, CHANNEL_NO, GUILD_CODE, GUILD_NAME, DWSTARTTIME, BYREGISTTIMEFLAG, DEFENDER_INFO, SIEGE_TAG)
VALUES (@v_siege_no, 1, @guild_code, @guild_name,@v_siege_start_time, 1, 0X0000, 'Y')

EXEC SP_SIEGE_START_TIME_U @guild_code,1,0x01,@v_siege_start_time output,@o_dwRegistTime output,@o_sp_rtn output

SET @v_strDate1=dbo.FN_BinDateToDateTime(@v_siege_star t_time)

DECLARE @P1 varchar(13)
SET @P1=NULL
DECLARE @P2 varchar(33)
SET @P2=NULL
DECLARE @P3 varchar(25)
SET @P3=NULL
DECLARE @P4 varbinary(4)
SET @P4=NULL
DECLARE @P5 varbinary(4)
SET @P5=NULL
DECLARE @P6 varbinary(4)
SET @P6=NULL
DECLARE @P7 varbinary(4)
SET @P7=NULL
DECLARE @P8 varbinary(4)
SET @P8=NULL
DECLARE @P9 varbinary(4)
SET @P9=NULL
DECLARE @P10 varbinary(4)
SET @P10=NULL
DECLARE @P11 varbinary(2)
SET @P11=NULL
DECLARE @P12 varbinary(2)
SET @P12=NULL
DECLARE @P13 varbinary(2)
SET @P13=NULL
DECLARE @P14 int
SET @P14=NULL
DECLARE @P15 int
SET @P15=NULL
DECLARE @P16 varbinary(4)
SET @P16=NULL
DECLARE @P17 varbinary(996)
SET @P17=NULL
DECLARE @P18 varbinary(996)
SET @P18=NULL
DECLARE @P19 varbinary(1000)
SET @P19=NULL
DECLARE @P20 int
SET @P20=NULL
EXEC SP_SIEGE_INFO_R 1, @P1 output, @P2 output, @P3 output, @P4 output, @P5 output, @P6 output, @P7 output, @P8 output, @P9 output, @P10 output, @P11 output, @P12 output, @P13 output, @P14 output, @P15 output, @P16 output, @P17 output, @P18 output, @P19 output, @P20 output
SELECT @P1, @P2, @P3, @P4, @P5, @P6,@v_strDate1
Result :

ronaldfa is offline  
Old 09/13/2012, 22:28   #4
 
elite*gold: 0
Join Date: May 2012
Posts: 77
Received Thanks: 20
lostisgood is offline  
Old 01/20/2013, 21:12   #5
 
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
sorry for bumping old topic but need someones help. I have used ronaldfa given codes but still seeing wrong years.
gedimazs is offline  
Old 01/21/2013, 19:19   #6
 
elite*gold: 0
Join Date: Feb 2011
Posts: 150
Received Thanks: 74
here is a post on DKu about changing it.
PyrexiaStudios is offline  
Thanks
1 User
Old 01/24/2013, 18:46   #7
 
elite*gold: 0
Join Date: Jul 2010
Posts: 233
Received Thanks: 106
Quote:
Originally Posted by ronaldfa View Post
Me Use


And



Result :

Actualy you used the db that contains the aloken and siege.
imissblood is offline  
Reply


Similar Threads Similar Threads
Can u change time for Siege???!!!!!!!
07/15/2013 - Dekaron Private Server - 10 Replies
so, is there any way to change the time for siege/ritual? :)
Siege Start Time
05/29/2012 - Dekaron Private Server - 4 Replies
What part of the Siege Script actually controls the start time? I can set the year and fix the display in the client but what controls the time? USE GO /****** Object: UserDefinedFunction . Script Date: 01/10/2011 19:35:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO ALTER FUNCTION . (
Hi How To Change Siege Time ?
04/09/2012 - Dekaron Private Server - 4 Replies
hello I can change the siege to be every Saturday at 8 pm? some script to change it?
Siege time
01/19/2012 - Rappelz Private Server - 6 Replies
Hello i try alot in siege time in dbo.dungeonresoucre but nothing i try to convert the time to seconds : didn't work i try to convert the time to unix: didn't work does any one know how to change the time for siege?
Siege Time Help!
07/20/2010 - Dekaron Private Server - 15 Replies
Hello I do it for my server the siege battle. But when I looked the next siege's time i seen this: http://kepfeltoltes.hu/100708/dekaron_2010_07_08_ 21h_22m_24s_0014_www.kepfeltoltes.hu_.jpg I done with the: -request a siege battle -Seal ritual -Seal register



All times are GMT +2. The time now is 06:03.


Powered by vBulletin®
Copyright ©2000 - 2021, 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 ©2021 elitepvpers All Rights Reserved.