Register for your free account! | Forgot your password?

You last visited: Today at 04:58

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


Siege Question

Discussion on Siege Question within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
Exclamation Siege Question

hello, I got a small question

I want change the start time of SIEGE BATTLE

Can someone tell me how to edit the start time?


Code that I now use;
PHP Code:
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(d7-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()), 34) + '0001'
INSERT
INTO GUILD_INFO
(guild_codeguild_nameguild_Levelbystatebychannel)
VALUES (@guild_code, @guild_name311)
INSERT
INTO SIEGE_INFO
(SIEGE_NOCHANNEL_NOGUILD_CODEGUILD_NAMEDWSTARTTIMEBYREGISTTIMEFLAGDEFENDER_INFOSIEGE_TAG)
VALUES (@v_siege_no1, @guild_code, @guild_name,@v_siege_start_time10X0000'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_start_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 



҉ THT ҉ is offline  
Old 03/20/2010, 05:42   #2
 
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
There seems to be this part.
Is not certain. XD

PHP Code:
'210000' 


l2zeo is offline  
Thanks
1 User
Old 03/20/2010, 07:39   #3
 
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 824
The part associated with siege time.
PHP Code:
SET @i_GetDate=getdate() //Gets the current date in the default timestamp format

-- Siege War Every Saturday

SELECT @v_siege_start_date CONVERT(VARCHAR(10), DATEADD(d7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000' //Turns the timestamp into the siege-start time.

-- 

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//Transforms the timestamp to the required format 
Though it's not rly php.
Zombe is offline  
Thanks
1 User
Old 03/20/2010, 11:27   #4
 
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
I really cant see what I need to change.
'210000' , WTH is this

I need it running on saturdays 19:00 +1GTM

Can anyone help


҉ THT ҉ is offline  
Old 03/20/2010, 19:43   #5
 
elite*gold: 0
Join Date: Jan 2008
Posts: 568
Received Thanks: 175
look at how the DF fix works, its the same for siege
pieter is offline  
Old 03/20/2010, 20:30   #6
 
elite*gold: 0
Join Date: Dec 2009
Posts: 296
Received Thanks: 162
Change the '210000' to '190000', and see if works.
daddycool. is offline  
Old 03/21/2010, 04:30   #7
 
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
Quote:
Originally Posted by kidksl33 View Post
jingyouting
what's this? XD
l2zeo is offline  
Old 03/21/2010, 07:36   #8
 
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
Quote:
Originally Posted by l2zeo View Post
what's this? XD
I think it's spam. Ban him
gedimazs is offline  
Old 03/21/2010, 08:00   #9

 
elite*gold: 0
Join Date: Oct 2008
Posts: 2,040
Received Thanks: 598
#7 deleted


~Twister~ is offline  
Reply



« [PREVIEW] OsDs V2 | Help plz again »

Similar Threads
[QUESTION] Siege War
12/24/2009 - Dekaron - 6 Replies
i have some questions about siege war Is there any gifts for siege war winners?? Now the guild "FATE" is winner..And all players in FATE has a light under their char..There is a spinning light like a buff..What is that??
[Question]Siege Kits.
01/08/2009 - RF Online - 3 Replies
is it possible to have a normal SK with the effect of RSK?:confused:
[Question] Siege Mastery
12/26/2008 - RF Online - 1 Replies
after editing address of siege mastery does your gen attack bar change? i've been trying this for almost a week now.. errrr.. I'am stuck at editing the damage but i don't now and how bout the "REAL DAMAGE"?:confused: any ideas????
A good Question About Siege Kits
06/08/2008 - RF Online - 0 Replies
A good Question About Siege KitsA good Question About Siege KitsA good Question About Siege KitsA good Question About Siege KitsA good Question About Siege Kits
[QUESTION] USING RED SIEGE KIT
05/19/2008 - RF Online - 12 Replies
any1 knows how to use red siege kit.. even ur not lvl 50?? since u can edit armors and weapons.. how about siege kit..? a few hints will be good thx..!



All times are GMT +1. The time now is 04:58.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2019 elitepvpers All Rights Reserved.