Register for your free account! | Forgot your password?

You last visited: Today at 23:26

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


Siege Question

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 23:26.


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

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