Constantinople Fortress Struct

[ToLiv3]

Hello Epvp
I have a struct problem on cons fw.


_SiegeFortressStruct

4	0	342	19616	1104000	2012-08-22 15:27:48.000	0
4	0	382	19543	0	2012-11-11 13:15:01.950	0
4	0	383	19543	0	2012-11-11 13:15:01.950	0
4	0	384	19543	0	2012-11-11 13:15:01.950	0
4	0	385	19543	0	2012-11-11 13:15:01.950	0
4	0	386	19543	0	2012-11-11 13:15:01.950	0
4	0	387	19543	0	2012-11-11 13:15:01.950	0
4	0	388	19543	0	2012-11-11 13:15:01.950	0
4	0	389	19543	0	2012-11-11 13:15:01.950	0
4	0	343	19521	464000	2012-08-22 15:20:00.150	0
4	0	344	19526	640000	2012-08-22 15:26:51.000	0
4	0	345	19534	640000	2012-08-22 15:27:15.000	0
4	0	350	19511	256000	2012-08-22 15:27:42.000	0
4	0	351	19511	256000	2012-08-22 15:27:45.000	0
4	0	352	19511	256000	2012-08-22 15:27:40.000	0
4	0	353	19511	256000	2012-08-22 15:27:36.000	0
4	0	354	19511	256000	2012-08-22 15:27:21.000	0
4	0	355	19511	256000	2012-08-22 15:27:18.000	0
4	0	356	19509	0	2012-08-22 15:20:00.150	0
4	0	357	19509	0	2012-08-22 15:20:00.150	0
4	0	358	19509	0	2012-08-22 15:20:00.150	0
4	0	359	19509	0	2012-08-22 15:20:00.150	0
4	0	360	19509	0	2012-08-22 15:20:00.150	0
4	0	361	19509	0	2012-08-22 15:20:00.150	0
4	0	362	19511	256000	2012-08-22 15:26:57.000	0
4	0	363	19511	256000	2012-08-22 15:26:59.000	0
4	0	364	19511	256000	2012-08-22 15:27:05.000	0
4	0	365	19511	256000	2012-08-22 15:27:03.000	0
4	0	366	19511	256000	2012-08-22 15:27:32.000	0
4	0	367	19511	256000	2012-08-22 15:27:29.000	0
4	0	368	19509	0	2012-08-22 15:20:00.150	0
4	0	369	19509	0	2012-08-22 15:20:00.150	0
4	0	346	19580	936000	2012-08-22 15:20:00.000	0
4	0	347	19581	1104000	2012-08-22 15:27:59.000	0
4	0	348	19581	1104000	2012-08-22 15:27:25.000	0
4	0	349	19581	1104000	2012-08-22 15:27:23.000	0

Help Me Please.

[Serif94]

how u did ur sr_gameserver working oO iam using the one from cher ... can u help me via teamviewer ??

[torachiyo]

_SiegeFortressStruct Script

USE [SRO_VT_SHARD]
GO

truncate table _SiegeFortressStruct

-- Fortress JA
INSERT INTO [_SiegeFortressStruct]
SELECT
1 as FortressID, -- FortressID
0 as OwnerGuildID , -- OwnerGuildID
_RefEventZone.ID as RefEventStructID,
_RefObjCommon.ID as RefObjID,
_RefObjChar.MaxHP as HP,
GETDATE() as MakeDate,
0 as State -- State
FROM 
_RefEventZone
JOIN [_RefObjCommon] ON _RefObjCommon.CodeName128 = _RefEventZone.strParam1
JOIN [_RefObjChar] ON _RefObjChar.ID = _RefObjCommon.Link
WHERE _RefEventZone.strParam2 = 'INS_FORT_JA'

-- Fortress HT
INSERT INTO [_SiegeFortressStruct]
SELECT
3 as FortressID, -- FortressID
0 as OwnerGuildID , -- OwnerGuildID
_RefEventZone.ID as RefEventStructID,
_RefObjCommon.ID as RefObjID,
_RefObjChar.MaxHP as HP,
GETDATE() as MakeDate,
0 as State -- State
FROM 
_RefEventZone
JOIN [_RefObjCommon] ON _RefObjCommon.CodeName128 = _RefEventZone.strParam1
JOIN [_RefObjChar] ON _RefObjChar.ID = _RefObjCommon.Link
WHERE _RefEventZone.strParam2 = 'INS_FORT_HT'

-- Fortress CT
INSERT INTO [_SiegeFortressStruct]
SELECT
4 as FortressID, -- FortressID
0 as OwnerGuildID , -- OwnerGuildID
_RefEventZone.ID as RefEventStructID,
_RefObjCommon.ID as RefObjID,
_RefObjChar.MaxHP as HP,
GETDATE() as MakeDate,
0 as State -- State
FROM 
_RefEventZone
JOIN [_RefObjCommon] ON _RefObjCommon.CodeName128 = _RefEventZone.strParam1
JOIN [_RefObjChar] ON _RefObjChar.ID = _RefObjCommon.Link
WHERE _RefEventZone.strParam2 = 'INS_FORT_CT'

-- Fortress BJ
INSERT INTO [_SiegeFortressStruct]
SELECT
6 as FortressID, -- FortressID
0 as OwnerGuildID , -- OwnerGuildID
_RefEventZone.ID as RefEventStructID,
_RefObjCommon.ID as RefObjID,
_RefObjChar.MaxHP as HP,
GETDATE() as MakeDate,
0 as State -- State
FROM 
_RefEventZone
JOIN [_RefObjCommon] ON _RefObjCommon.CodeName128 = _RefEventZone.strParam1
JOIN [_RefObjChar] ON _RefObjChar.ID = _RefObjCommon.Link
WHERE _RefEventZone.strParam2 = 'INS_FORT_BJ'

DELETE _SiegeFortressStruct WHERE HP = 80000
--UPDATE _SiegeFortressStruct SET HP = 0 WHERE HP = 80000