i get error anyone help :rtfm:

skystar2003 · 01/07/2010, 12:06

i get error anyone help

thesis the fill A

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

gedimazs · 01/07/2010, 13:19

it was already posted by me

No1 wants to help or they don't need automatic DF

NicoBlacktir · 01/08/2010, 00:52

Quote:

Originally Posted by gedimazs

it was already posted by me
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

xfactorbowler · 01/09/2010, 07:39

you pretty much need to change the year in your scripts. an thats as far as i got Lol

Decima · 01/09/2010, 11:49

Quote:

Originally Posted by xfactorbowler

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

gedimazs · 01/09/2010, 12:52

Quote:

Originally Posted by Decima

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.

xfactorbowler · 01/09/2010, 16:07

Quote:

Originally Posted by Decima

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.

gedimazs · 01/09/2010, 20:12

Quote:

Originally Posted by xfactorbowler

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?

xfactorbowler · 01/10/2010, 02:19

Quote:

Originally Posted by gedimazs

what scripts you are talking about?

the 2010 script procedures for siege/df

Zombe · 01/10/2010, 08:04

Quote:

Originally Posted by Zombe

Quote:

Originally Posted by Darth Nerd

Maybe you need to modify the function binary date to date time,
just an idea, don't ask me how.

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.

skystar2003 · 01/10/2010, 09:59

Quote:

Originally Posted by Zombe

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

vi3tdrgn · 01/10/2010, 11:52

should help u

skystar2003 · 01/10/2010, 12:00

Quote:

Originally Posted by skystar2003

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

gedimazs · 01/10/2010, 19:30

Quote:

Originally Posted by Zombe

Just quoted myself. As I said, I didn't test this, but u can try it.

changing from 200 to 201 did not help.

skystar2003 · 01/11/2010, 01:00

thesis the fill A

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