[Help] Siege & Character

[~PsychoPathic~]

FIXED!!!!!! Close please

[yahoo5000]

use this

PHP Code:

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_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 


this help to you make working siege

[~PsychoPathic~]

TY... Testing now... Anyone know how to edit the data & Time of it?
EDIT: Still says Siege Info Call Fail =.=

[CROvic]

[~PsychoPathic~]

Updated!

[frezser]

Please guide to fix this problem
1. when I change character name to [GM]Name I can't connect the game the client terminate. How I fix it?
2. when I move to some skill item in the shop the game client terminate. How I fix it?
3. I add character [DEV]ALOKEN at user_character, user_suite already but not show on create character window. How I fix it?
4. How add a gate to some map?

Thank you

[CROvic]

Originally Posted by Blunt420

Alright.... I got the Siege info call fail error to go away... but now it says Not siege channel index= [1]...
Whats that???? And how do I edit the time/date of it

Originally Posted by frezser

Please guide to fix this problem
1. when I change character name to [GM]Name I can't connect the game the client terminate. How I fix it?
2. when I move to some skill item in the shop the game client terminate. How I fix it?
3. I add character [DEV]ALOKEN at user_character, user_suite already but not show on create character window. How I fix it?
4. How add a gate to some map?

Thank you

1.Maybe your Anti gm system delete the char
2. and 4. go to

3.I was never doing something with aloken so idk

[6shadow6]

Does anyone know how to change the required number of guild members in order to fall at least three guild member