[Help]Siege error

[Josinho]

I have a problem with my server, I already run those siege script:



and



However I still got error of [CRITICAL ERROR] SP_SIEGE_INFO_R CALL FAIL, if someone can tell me how fix it please

Note: In the game the guild that I have I get as the crown of the castle but is the same, don't work :s



Please help me.

[Synns]

Debes usar el siege Scrip + la version del SQL 2k para ejecutarse normal, hay algunas bases de datos que tienen siege incluido, intenta buscarlas que las encontraras, y si no puedes enviame un MP para ayudarte..

u need siege Scrip and SQL 2k to run normal. there are some databases that are included siege, try searching it, and if u can't send me a PM to help u

[Decima]

run the second link FIRST, then do the first one to fix the date, dont run either with any of the server exe's open.

and synns, wtf makes you think he isnt running SQL 2k? and the second link he posted IS the siege script, what kinda dev are u planning to be when you dont even pay attention to wtf is going on in a small post? a good dev never assumes anything

[Josinho]

Originally Posted by Decima

run the second link FIRST, then do the first one to fix the date, dont run either with any of the server exe's open.

Ok, I'm gonna try that.

Thanks for reply.

The analyzer gave this:

 Spoiler

(1 filas afectadas)

(1 filas afectadas)

Servidor: mensaje 242, nivel 16, estado 3, procedimiento FN_SetSiegeStartTime_U, línea 34
La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.

(1 filas afectadas)

Servidor: mensaje 242, nivel 16, estado 3, procedimiento SP_DEADFRONT_GET_TIMEINFO, línea 30
La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.

Servidor: mensaje 242, nivel 16, estado 3, procedimiento FN_BinDateToDateTime, línea 38
La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.

What i'm doing wrong? Maybe that be cuz I don't have the SP4?

[Synns]

Try running these 2 scripts in Query,
You must own SQL 2000 SP 4 installed, this problem is often the 40%
run it 1 by 1

Step 1

USE [Character]
GO

/****** Object: UserDefinedFunction [dbo].[FN_BinDateToDateTime] Script Date: 01/10/2011 19:35:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER   FUNCTION [dbo].[FN_BinDateToDateTime] (
        @i_bin_time     binary(4)
) RETURNS datetime
AS
BEGIN
        DECLARE @v_datetime     datetime
        DECLARE @v_strAux varchar(20)
        DECLARE @v_strtime      varchar(20)
        SET @v_strAux = CAST(CAST(@i_bin_time as int) as varchar(20))
        IF len(@v_strAux) = 7   
                SELECT  @v_strtime      = '20110' + CAST(CAST(@i_bin_time as int) as varchar(20))
        ELSE
                IF len(@v_strAux) = 8 
                        SELECT  @v_strtime      = '2011' + CAST(CAST(@i_bin_time as int) as varchar(20))
                ELSE
                                SELECT  @v_strtime      = '201' + CAST(CAST(@i_bin_time as int) as varchar(20))

        
        SELECT  @v_strtime      = SUBSTRING(@v_strtime,1,4)
                                                +'-'+SUBSTRING(@v_strtime,5,2)
                                                +'-'+SUBSTRING(@v_strtime,7,2)
                                                +' '+SUBSTRING(@v_strtime,9,2)
                                                +':'+SUBSTRING(@v_strtime,11,2) 
        SELECT  @v_datetime = CAST(@v_strtime as datetime)
        RETURN @v_datetime
END

Step 2

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(d, 7-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 = 'FirstSiege'
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

[daikim]

CRITICAL ERROR: SP_LOGIN_FLAG_SET PROC CALL FAIL
how to solve this problem already tried everything

[DekaronService]

hello who can help me and I do all the installation but it gives me this error I tried with sql 2014 and now sql 2000 but nothing doesn't work anymore I don't know what else to do please someone help me here I leave the image that I got from the error https:/ /www.facebook.com/photo/?fbid=892544508810578&set=a.160927781972258