i get error anyone help :rtfm:

Page 1 of 2 1 2
01/07/2010 12:06 skystar2003#1
i get error anyone help :rtfm:

thesis the fill A [Only registered and activated users can see links. Click Here To Register...] i love to use it
so fix it to me i cant fix it i don't knew how to fix it
or show to me how to fix it i video or Pictures
Belize help me


[Only registered and activated users can see links. Click Here To Register...]


[Only registered and activated users can see links. Click Here To Register...]
01/07/2010 13:19 gedimazs#2
it was already posted by me [Only registered and activated users can see links. Click Here To Register...]
No1 wants to help or they don't need automatic DF :)
01/08/2010 00:52 NicoBlacktir#3
Quote:
Originally Posted by gedimazs View Post
it was already posted by me [Only registered and activated users can see links. Click Here To Register...]
No1 wants to help or they don't need automatic DF :)

yea if i found the problem then i tell it all ;)

i hate noob DEV where dont help other
01/09/2010 07:39 xfactorbowler#4
you pretty much need to change the year in your scripts. an thats as far as i got Lol
01/09/2010 11:49 Decima#5
Quote:
Originally Posted by xfactorbowler View Post
you pretty much need to change the year in your scripts. an thats as far as i got Lol
actually u have to change how the sql scripts process the year . . .

i thought i explained it a little better than that tho ;), but maybe it was one of the nights you were sick :P
01/09/2010 12:52 gedimazs#6
Quote:
Originally Posted by Decima View Post
actually u have to change how the sql scripts process the year . . .

i thought i explained it a little better than that tho ;), but maybe it was one of the nights you were sick :P
If you know how why you are not sharing your knowladges? "to change how the sql scripts process the year..." is not saying anything.
01/09/2010 16:07 xfactorbowler#7
Quote:
Originally Posted by Decima View Post
actually u have to change how the sql scripts process the year . . .

i thought i explained it a little better than that tho ;), but maybe it was one of the nights you were sick :P
Lol? why would I need you to explain anything to me? I could care less on how the script works or how its proccessed I just gave the answer, so what if it was wrong I atleast tried to help someone for once.
01/09/2010 20:12 gedimazs#8
Quote:
Originally Posted by xfactorbowler View Post
Lol? why would I need you to explain anything to me? I could care less on how the script works or how its proccessed I just gave the answer, so what if it was wrong I atleast tried to help someone for once.
what scripts you are talking about?
01/10/2010 02:19 xfactorbowler#9
Quote:
Originally Posted by gedimazs View Post
what scripts you are talking about?
the 2010 script procedures for siege/df
01/10/2010 08:04 Zombe#10
Quote:
Originally Posted by Zombe View Post
Quote:
Originally Posted by Darth Nerd View Post
Maybe you need to modify the function binary date to date time,
just an idea, don't ask me how.

[Only registered and activated users can see links. Click Here To Register...]
Try this, go to that function and where it says
SELECT @v_strtime = '200' + CAST(CAST(@i_bin_time as int) as varchar(20))

Try changing the 200 to 201, since I guess the time in their binary format doesn't store decades, it is just put in the function, that its year 200X, and since we entered a new decade, it won't work anymore. No one thought that people will still play Dekaron in 2010+. So changing 200 to 201 will make it think its year 201X, and it should fix the problem of time converting.

Though the time storing may also cause a problem somewhere else, because if it cuts off millenniums, centuries and decades, it stored the time like
905172351 (9 digints), meaning 2009.05.17 23:51, but I wonder, will it now store it as 005172351 (9 digits) or 1005172351 (10 digits). If its the second case, More changes will have to be made. If it's the first case, changing that function, and maybe a few other functions like that, should fix the problem.

I hope that helps, and sorry, I cant test it myself, because my MSSQL evaluation period is over >_>
Just quoted myself. As I said, I didn't test this, but u can try it.
01/10/2010 09:59 skystar2003#11
Quote:
Originally Posted by Zombe View Post
Just quoted myself. As I said, I didn't test this, but u can try it.
how to us it ?
bot in her or ?

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)
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_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)
declare @guild_name char(20)
set @i_GetDate=getdate()
--// ??SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000' ^EG\iO2X
--// ???SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000' ,lA.C%4au~
--// ?????SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000' VvFC -r,=G
SELECT @v_siege_start_date= CONVERT(VARCHAR(10),GetDate()+1,112)+'210000'
--//???? &[NG]V!Oc
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 = '<color=green>LoLz'
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
01/10/2010 11:52 vi3tdrgn#12
should help u
01/10/2010 12:00 skystar2003#13
Quote:
Originally Posted by skystar2003 View Post
how to us it ?
bot in her or ?

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)
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_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)
declare @guild_name char(20)
set @i_GetDate=getdate()
--// ??SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000' ^EG\iO2X
--// ???SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000' ,lA.C%4au~
--// ?????SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000' VvFC -r,=G
SELECT @v_siege_start_date= CONVERT(VARCHAR(10),GetDate()+1,112)+'210000'
--//???? &[NG]V!Oc
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 = '<color=green>LoLz'
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
after thees
New error
01/10/2010 19:30 gedimazs#14
Quote:
Originally Posted by Zombe View Post
Just quoted myself. As I said, I didn't test this, but u can try it.
changing from 200 to 201 did not help. :confused:
01/11/2010 01:00 skystar2003#15
thesis the fill A [Only registered and activated users can see links. Click Here To Register...] i love to use it
so fix it to me i cant fix it i don't knew how to fix it
or show to me how to fix it i video or Pictures
Belize help me
Page 1 of 2 1 2