|
You last visited: Today at 06:04
Advertisement
Please help siege script
Discussion on Please help siege script within the Dekaron Private Server forum part of the Dekaron category.
01/01/2010, 11:32
|
#1
|
elite*gold: 0 
Join Date: Nov 2008
Posts: 134
Received Thanks: 8
|
Please help siege script
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.
OMG ma friend please help with this **** error
i'm try to fix by my self buy not success
I thing should be fix some proceture right ?
any idea ?
who are *** of siege script please help
thank you for your kind.
|
|
|
|
01/01/2010, 11:53
|
#2
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
I become similarly such error
Asked a question, but did not get clear replyㅠㅠ
|
|
|
|
|
01/01/2010, 11:58
|
#3
|
elite*gold: 0
Join Date: Nov 2008
Posts: 134
Received Thanks: 8
|
you got this probl too ?.
|
|
|
|
|
01/01/2010, 12:09
|
#4
|
elite*gold: 0
Join Date: Feb 2009
Posts: 577
Received Thanks: 412
|
try google (conversion failed when converting data and/or time from character string) tons of sites about this
|
|
|
|
|
01/01/2010, 12:21
|
#5
|
elite*gold: 0
Join Date: Nov 2008
Posts: 134
Received Thanks: 8
|
Quote:
Originally Posted by yosef07212
try google (conversion failed when converting data and/or time from character string) tons of sites about this
|
sir! i already your intruct but i don't know how to apply to my script
pleas guide again 
|
|
|
|
|
01/01/2010, 12:56
|
#6
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
yap
Quote:
Originally Posted by augustabyron
you got this probl too ?.
|
yap
It was said that search, but did not inform correct reply or script
|
|
|
|
|
01/01/2010, 13:04
|
#7
|
elite*gold: 0
Join Date: Nov 2008
Posts: 134
Received Thanks: 8
|
Quote:
Originally Posted by l2zeo
yap
It was said that search, but did not inform correct reply or script
|
so tried!!!!
try to fix by my self buy don't know where point to fix it.
you know anything please share.
|
|
|
|
|
01/01/2010, 13:13
|
#8
|
elite*gold: 0
Join Date: Nov 2008
Posts: 134
Received Thanks: 8
|
Code:
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()
---DEFAULT-//SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
--Once Week every Sunday-//SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
--Every 3 Days-//SELECT @v_siege_start_date= CONVERT(VARCHAR(10),GetDate()+3,112)+'210000'
--//Set the line below with which one you want above after you do, delete above lines and query it
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-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 = 'SIEGEWAR'
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_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
i use this script then i got error
aneyone know where to fix in this scipt
|
|
|
|
|
01/01/2010, 13:14
|
#9
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
If I know ..
Quote:
Originally Posted by augustabyron
so tried!!!!
try to fix by my self buy don't know where point to fix it.
you know anything please share.
|
Solution for this part janvier increase that know ?
If I know ..
Already would be fertilized 
|
|
|
|
|
01/01/2010, 13:17
|
#10
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
Quote:
Originally Posted by augustabyron
Code:
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()
---DEFAULT-//SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
--Once Week every Sunday-//SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'
--Every 3 Days-//SELECT @v_siege_start_date= CONVERT(VARCHAR(10),GetDate()+3,112)+'210000'
--//Set the line below with which one you want above after you do, delete above lines and query it
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-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 = 'SIEGEWAR'
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_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
i use this script then i got error
aneyone know where to fix in this scipt |
I am same query too
Error is similar part too
|
|
|
|
|
01/01/2010, 14:49
|
#11
|
elite*gold: 0
Join Date: Dec 2007
Posts: 26
Received Thanks: 10
|
The script itself is fine, it's something else that you have to adapt. Once found, it's an easy fix really, but giving the solution here would be too easy. Play around with the database a bit. If you get to know it better, you'll know where to look. 
|
|
|
|
|
01/01/2010, 14:58
|
#12
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
firestarter gaming server
Quote:
Originally Posted by Razgr!z
The script itself is fine, it's something else that you have to adapt. Once found, it's an easy fix really, but giving the solution here would be too easy. Play around with the database a bit. If you get to know it better, you'll know where to look. |
did firestarter gaming server complete siege correction? .
|
|
|
|
|
01/01/2010, 15:00
|
#13
|
elite*gold: 0
Join Date: Dec 2007
Posts: 26
Received Thanks: 10
|
Quote:
Originally Posted by l2zeo
did firestarter gaming server complete siege correction? .
|
Uhm, yes, I fixed it for FSG.
|
|
|
|
|
01/01/2010, 15:11
|
#14
|
elite*gold: 0
Join Date: Aug 2009
Posts: 267
Received Thanks: 39
|
Siege error
Quote:
Originally Posted by Razgr!z
Uhm, yes, I fixed it for FSG.
|
Siege error refering correction teach should ? 
|
|
|
|
|
01/03/2010, 09:52
|
#15
|
elite*gold: 0
Join Date: Apr 2009
Posts: 56
Received Thanks: 5
|
Reported,, Double post.
Use search or google.
|
|
|
|
Similar Threads
|
[RELEASE] Siege Script for every 3day,1week and twice a month
03/20/2013 - Dekaron Private Server - 25 Replies
Hit thanks if you like :)
|
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 06:04.
|
|
