Constantinople Fortress Struct

ToLiv3 · 11/11/2012, 13:15

Hello Epvp
I have a struct problem on cons fw.

_SiegeFortressStruct

Code:

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~~ · 11/12/2012, 17:38

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

~~torachiyo~~ · 08/21/2023, 06:03

_SiegeFortressStruct Script

Code:

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

kotsh23 · 02/17/2026, 09:51

Code:

USE [SRO_VT_SHARD]
GO

IF OBJECT_ID('dbo.usp_InitSiegeFortressStructs', 'P') IS NOT NULL
    DROP PROCEDURE dbo.usp_InitSiegeFortressStructs
GO

CREATE PROCEDURE dbo.usp_InitSiegeFortressStructs
     [MENTION=486320]forcer[/MENTION]ebuild BIT = 0,        -- Set to 1 to truncate and rebuild
     [MENTION=992054]Fortress[/MENTION]ID   INT = NULL       -- NULL = all fortresses, or specify 1/3/4/6
AS
BEGIN
    SET NOCOUNT ON;
    SET XACT_ABORT ON;

    -- Fortress definitions
    DECLARE  [MENTION=992054]Fortress[/MENTION]es TABLE (
        FortressID  INT,
        FilterParam NVARCHAR(50)
    );

    INSERT INTO  [MENTION=992054]Fortress[/MENTION]es VALUES
        (1, 'INS_FORT_JA'),
        (3, 'INS_FORT_HT'),
        (4, 'INS_FORT_CT'),
        (6, 'INS_FORT_BJ');

    -- Validate FortressID if provided
    IF  [MENTION=992054]Fortress[/MENTION]ID IS NOT NULL AND NOT EXISTS (
        SELECT 1 FROM  [MENTION=992054]Fortress[/MENTION]es WHERE FortressID =  [MENTION=992054]Fortress[/MENTION]ID
    )
    BEGIN
        RAISERROR('Invalid  [MENTION=992054]Fortress[/MENTION]ID [%d]. Valid values: 1 (JA), 3 (HT), 4 (CT), 6 (BJ).', 16, 1,  [MENTION=992054]Fortress[/MENTION]ID);
        RETURN;
    END

    BEGIN TRY
        BEGIN TRANSACTION;

        -- Force rebuild: delete target records
        IF  [MENTION=486320]forcer[/MENTION]ebuild = 1
        BEGIN
            IF  [MENTION=992054]Fortress[/MENTION]ID IS NULL
                TRUNCATE TABLE _SiegeFortressStruct;
            ELSE
                DELETE FROM _SiegeFortressStruct
                WHERE FortressID =  [MENTION=992054]Fortress[/MENTION]ID;
        END

        -- Insert missing records
        INSERT INTO [_SiegeFortressStruct]
        SELECT
            f.FortressID,
            0 AS OwnerGuildID,
            ez.ID AS RefEventStructID,
            oc.ID AS RefObjID,
            och.MaxHP AS HP,
            GETDATE() AS MakeDate,
            0 AS State
        FROM  [MENTION=992054]Fortress[/MENTION]es f
        CROSS APPLY (
            SELECT ID, strParam1
            FROM _RefEventZone
            WHERE strParam2 = f.FilterParam
        ) ez
        JOIN _RefObjCommon oc ON oc.CodeName128 = ez.strParam1
        JOIN _RefObjChar och ON och.ID = oc.Link
        WHERE   [MENTION=992054]Fortress[/MENTION]ID IS NULL OR f.FortressID =  [MENTION=992054]Fortress[/MENTION]ID)
        AND och.MaxHP <> 80000
        AND NOT EXISTS (
            SELECT 1
            FROM _SiegeFortressStruct sfs
            WHERE sfs.FortressID = f.FortressID
              AND sfs.RefEventStructID = ez.ID
              AND sfs.RefObjID = oc.ID
        );

        -- Clean up any existing 80000 HP records
        DELETE FROM _SiegeFortressStruct
        WHERE HP = 80000
          AND   [MENTION=992054]Fortress[/MENTION]ID IS NULL OR FortressID =  [MENTION=992054]Fortress[/MENTION]ID);

        COMMIT TRANSACTION;

        -- Summary
        SELECT
            FortressID,
            COUNT(*) AS StructCount,
            MIN(HP) AS MinHP,
            MAX(HP) AS MaxHP
        FROM _SiegeFortressStruct
        WHERE   [MENTION=992054]Fortress[/MENTION]ID IS NULL OR FortressID =  [MENTION=992054]Fortress[/MENTION]ID)
        GROUP BY FortressID
        ORDER BY FortressID;

    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0
            ROLLBACK TRANSACTION;

        THROW;
    END CATCH
END
GO

Code:

-- Safe insert all fortresses (skip existing)
EXEC dbo.usp_InitSiegeFortressStructs;

-- Full rebuild all fortresses
EXEC dbo.usp_InitSiegeFortressStructs  [MENTION=486320]forcer[/MENTION]ebuild = 1;

-- Safe insert only Fortress JA
EXEC dbo.usp_InitSiegeFortressStructs  [MENTION=992054]Fortress[/MENTION]ID = 1;

-- Rebuild only Fortress HT
EXEC dbo.usp_InitSiegeFortressStructs  [MENTION=486320]forcer[/MENTION]ebuild = 1,  [MENTION=992054]Fortress[/MENTION]ID = 3;

-- Invalid ID → error message
EXEC dbo.usp_InitSiegeFortressStructs  [MENTION=992054]Fortress[/MENTION]ID = 99;