[Help] IA Julia 4.6 Castle Siege

Hello all, i have problem with my Castle Siege, i was reading all the threads ,what i found in "Ragezone", i'm sorry if this not place for my thread... So, i can't config or i miss something, but i been try all info from all threads. This is my problem :

https://files.fm/u/gpzvs4dz

And this is my settings:
CommonServer.cfg

Code:

---

//=================================
//Castle Siege Options
//=================================
CastleSiegeRun                = 1
BlockCastleSiegeMapEnter        = 0
IsDropGemOfDefend            = 1
GemOfDefendDropRate            = 30
GemOfDefendDropLevel            = 75
IsDropSetItemInCastleHuntZone        = 1
SetItemInCastleHuntZoneDropRate        = 30
SetItemInCastleHuntZoneDropLevel    = 75
MarkOfTheLord                = 100
CastleCycleStartYear            =0
CastleCycleStartMonth            =0
CastleCycleStartDay            =0
CastleSpecificState            =0
CastleStateStartYear            =0
CastleStateStartMonth            =0
CastleStateStartDay            =0
CastleStateStartHour            =0
CastleStateStartMinute            =0

---

ServerInfo.dat from GSCS

Code:

---

[GameServerInfo]
ServerName                    = GGCS
ServerCode                    = 2
NonPK                        = 0
PkLimitFree                    = 0
ConnectMemberLoad                = 0
ChangeCharacterName                = 0
NewServer                    = 0
EventOff                    = 0

---

MapServerInfo.dat

Code:

---

//--------------------------------------------------------------------------------//
//    SrvCode        MapServerGroup    InitSetting    IpAddress    PortNum  //
//--------------------------------------------------------------------------------//
0
    0        0        1        S192.168.1.69    55901
    2        0        -1        S192.168.1.69    55919
   
end

//--------------------------------------------------------------------------------//
//    SrvCode        MoveAbleOption    Map        DestServerCode            //
//--------------------------------------------------------------------------------//
1


    0    0        30        2
    0    0        31        2
    0    0        34        2
    0    0        41        2
    0    0        42        2
   
    2    1        30        -1
    2    1        31        -1
    2    1        34        -1
    2    1        41        -1
    2    1        42        -1
   
end

---

BoR_ServerList.dat

Code:

---

//---------------------------------------------------------------------------
// MU Server List
// MU ConnectServer by S@nek © Copyright 2007-2009
// In one Server can be a maximum 16 Sub-Servers. (16 visibles)
//---------------------------------------------------------------------------

//---------------------------------------------------------------------------
// "GameServerID" | "NameServer" | "IP" | "Port" | "Status(SHOW, HIDE)"
//---------------------------------------------------------------------------
// 0-65535 | 0-30 characters | 0-16 characters | 0-65535 | SHOW/HIDE
//---------------------------------------------------------------------------

// Server-1: 0-19
0 "GS"        "192.168.1.69" 55901 "SHOW"
2 "GSCS"    "192.168.1.69" 55919 "HIDE"

// Server-2: 20-39

// Server-3: 40-59

// Server-4: 60-79

// Server-21: 400-419

---

- - - Updated - - -

https://files.fm/u/gpzvs4dz

in mapserverinfo also change this

Code:

---

    2        0      -1 to 0        S192.168.1.69    55919

---

and how did u configure in mucastle_data in SQL?

Quote:

---

Originally Posted by KarLi

in mapserverinfo also change this

Code:

---

    2        0      -1 to 0        S192.168.1.69    55919

---

and how did u configure in mucastle_data in SQL?

---

in sql i believe i set up correct, it's not hard. But it still the same , if i change that -1 to 0

if sql is correct everything else must be correct mate @natzugen what u say?

try with this query

Code:

---

Use MuOnline
go
Declare @GuiLd varchar(10)
Declare @MaxGuild int
Declare @Estado int
Select @MaxGuild = Max(G_Score) from Guild
Select @GuiLd=G_Name from Guild where g_Score = @MaxGuild
IF  @GuiLd<>'')
BEGIN
set @Estado = 1
END
ELSE
BEGIN
set @Estado = 0
set @GuiLd = 'Castle owner guild here'
END
UPDATE [MuCastle_DATA]
SET
[SIEGE_START_DATE]=getdate(),
[SIEGE_END_DATE]=CAST(year(getdate()) AS varchar(4)) + '-' + CAST(Month(getdate()) AS varchar(2)) + '-' + CAST((day(getdate()) + 7) AS varchar(2))
,CASTLE_OCCUPY @Estado
,OWNER_GUILD @GuiLd

---

Quote:

---

Originally Posted by natzugen

try with this query

Code:

---

Use MuOnline
go
Declare @GuiLd varchar(10)
Declare @MaxGuild int
Declare @Estado int
Select @MaxGuild = Max(G_Score) from Guild
Select @GuiLd=G_Name from Guild where g_Score = @MaxGuild
IF  @GuiLd<>'')
BEGIN
set @Estado = 1
END
ELSE
BEGIN
set @Estado = 0
set @GuiLd = 'Castle owner guild here'
END
UPDATE [MuCastle_DATA]
SET
[SIEGE_START_DATE]=getdate(),
[SIEGE_END_DATE]=CAST(year(getdate()) AS varchar(4)) + '-' + CAST(Month(getdate()) AS varchar(2)) + '-' + CAST((day(getdate()) + 7) AS varchar(2))
,CASTLE_OCCUPY @Estado
,OWNER_GUILD @GuiLd

---

---

I get this error

Code:

---

Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near ')'.
Server: Msg 156, Level 15, State 1, Line 10
Incorrect syntax near the keyword 'ELSE'.
Server: Msg 170, Level 15, State 1, Line 19
Line 19: Incorrect syntax near '@Estado'.

---

I think in these files not working Castle Siege, because i launch another IA Julia 4,6 with the same settings and works perfect :), thanks for help you all :)

Thread can be closed, i solve my problem with another files :)