|
You last visited: Today at 09:08
Advertisement
[Help]Siege Critical Errro !
Discussion on [Help]Siege Critical Errro ! within the Dekaron Private Server forum part of the Dekaron category.
04/14/2011, 05:20
|
#1
|
elite*gold: 0 
Join Date: Mar 2007
Posts: 149
Received Thanks: 10
|
[Help]Siege Critical Errro !
Can some1 give me a tip for the erro? Im using this scritp
[IMG]  [/IMG]
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(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 = 'FIRSTGUILD'
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
|
|
|
|
04/14/2011, 15:11
|
#2
|
elite*gold: 0
Join Date: Aug 2007
Posts: 554
Received Thanks: 136
|
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()
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 = '系统默认'
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
select @P1, @P2, @P3, @P4, @P5, @P6,@v_strDate1
theres the original
|
|
|
|
|
04/14/2011, 23:26
|
#3
|
elite*gold: 0
Join Date: Nov 2009
Posts: 170
Received Thanks: 15
|
i did that and i get an error invalid object name 'dbo.FN_DateToShortStrDate'.
|
|
|
|
|
04/15/2011, 03:59
|
#4
|
elite*gold: 0
Join Date: Mar 2007
Posts: 149
Received Thanks: 10
|
Quote:
Originally Posted by xfactorbowler
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()
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 = '系统默认'
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
select @P1, @P2, @P3, @P4, @P5, @P6,@v_strDate1
theres the original |
hmm how do we set the time on the script or which line is for the timing? i see on my Dbmonitor Siege Alarm time [0]
|
|
|
|
|
05/13/2020, 18:31
|
#5
|
elite*gold: 0
Join Date: May 2011
Posts: 60
Received Thanks: 6
|
CRITICAL ERROR: SP_LOGIN_FLAG_SET PROC CALL FAIL
how to solve this problem already tried everything
|
|
|
|
|
05/14/2020, 18:03
|
#6
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
the problem can be with connection between Session Server and your MSSQL server.
|
|
|
|
|
05/14/2020, 20:11
|
#7
|
elite*gold: 0
Join Date: Feb 2016
Posts: 231
Received Thanks: 64
|
Quote:
Originally Posted by [DEV]Dekaron
the problem can be with connection between Session Server and your MSSQL server.
|
<a href="http://epvpimg.com/n1zFdab"><img src="http://i.epvpimg.com/n1zFdab.png" alt="" title="Hosted by epvpimg.com" /></a>
3464: OnDefenderSetting:  nParsing TotalSize
3764: [FAIL ERROR ]SP_POST_SEND_SIEGE_TAX [ RESULT : -1
3764: [FAIL ERROR ]SP_SIEGE_TAX_U [ TAX : 0 ] [ RESULT : -2 ]
why does it appear like this thanks in advance
|
|
|
|
|
05/14/2020, 20:25
|
#8
|
elite*gold: 393
Join Date: Jan 2012
Posts: 2,445
Received Thanks: 1,102
|
check the stored procedure and see why it returns -1 and -2...
it tells you the name, it tells you the result, all you gotta do is a tiny bit of research in mssql
|
|
|
|
05/14/2020, 23:38
|
#9
|
elite*gold: 0
Join Date: Feb 2011
Posts: 150
Received Thanks: 74
|
If we look at the stored procedure they give results as for example:
[FAIL ERROR ]SP_POST_SEND_SIEGE_TAX [ RESULT : -1
I looked into the SP and roughly translated the Korean text to no character, so there is no character to send the tax to.
And the second error, if I am reading the SP correctly roughly translates to:
Siege Channel Tax Correction Error
Correct me if I am way off.
I am also working on updating my SQL Script for 2020 and learning how this all works.
|
|
|
|
 |
Similar Threads
|
[HELP]Siege
02/06/2011 - Dekaron Private Server - 13 Replies
Hello again i need help with siege i need some1 to tell me step by step how to add siege scripts and i need siege scripts too... i ve rode last post bout help with siege , and shadow posted alots of scripts and i was like wtf and i coudnt understand nothing so can some1 help pls ?
-Thanks
|
How to edit Critical Rate/Critical DMG?
11/14/2009 - Cabal Online - 2 Replies
How to edit Critical Rate/Critical DMG with MHS? I need a help to do this...
TY
|
Siege Help...
11/03/2009 - Dekaron Private Server - 7 Replies
Hello,
I searched in the whole forum, but cant find anything about my error:
SP_SIEGE_INFO_R CALL FAIL
Please help me!
|
Siege help
09/26/2009 - Dekaron Private Server - 7 Replies
First of all my server is running 100%. But here my problem i put Siege code in db and i can start it in game but when i go to the teleport to go there i get this message "You are not authorized to participate in the \Siege Battle" How can i fix this so i and other's can enter. Thanks givin in advance.
Also i have seached and found nothing on this .
|
[HELP]SIege War
07/13/2009 - Dekaron Private Server - 16 Replies
I would like to know how the system of Siege, because I bought my gameserver from a client which runs the Siege, but I asked them they told that the time of the Siege is automatic to start, I just do not know how to enter the gild The Siege and do the ritual, someone could explain me? because when I use the command / gm siegestart of an error in dekaronserver.exe, I would like someone to help me
|
All times are GMT +1. The time now is 09:09.
|
|
![[Help]Siege Critical Errro !](https://www.elitepvpers.com/forum/iconimages/dekaron-private-server/help-siege-critical-errro_ltr.gif){kind=small}
