SIEGE DATE ERROR

Sintese · Friday at 3:30 AM

I'm trying to set a siege date, but "Residence" isn't accepting my date. I also tried using the "Castle" database, but the dates aren't working correctly in the game.

WhatsApp Image 2026-03-19 at 21.29.30.webp

test · Friday at 4:58 AM

Sintese said:
I'm trying to set a siege date, but "Residence" isn't accepting my date. I also tried using the "Castle" database, but the dates aren't working correctly in the game.View attachment 8173

необходимо заполнять все поля в редактировании даты, насколько я помню

Sintese · Friday at 5:51 AM

test said:
Não é necessário informar todos os dados de redacção, que estão no início

O problema é que não consigo agendar o próximo cerco.

test said:
Não é necessário informar todos os dados de redacção, que estão no início

Trance · Friday at 6:15 AM

Sintese said:
The problem is that I can't schedule the next siege.

While server is offline:

Wipe sieges:

SQL:

DELETE FROM castle_manor_production;
DELETE FROM castle;
INSERT INTO castle VALUES ('1', 'Gludio', '0', '0', '0', '0', '0', '0'),('2', 'Dion', '0', '0', '0', '0', '0', '0'),('3', 'Giran', '0', '0', '0', '0', '0', '0'),('4', 'Oren', '0', '0', '0', '0', '0', '0'),('5', 'Aden', '0', '0', '0', '0', '0', '0'),('6', 'Innadril', '0', '0', '0', '0', '0', '0'),('7', 'Goddard', '0', '0', '0', '0', '0', '0'),('8', 'Rune', '0', '0', '0', '0', '0', '0'),('9', 'Schuttgart', '0', '0', '0', '0', '0', '0');
DELETE FROM clanhall;
INSERT INTO clanhall VALUES ('21', 'Fortress of Resistance', '0', '0', '0', '0', '0', null, '0', '0'),('22', 'Moonstone Hall', '0', '0', '0', '0', '0', null, '0', '0'),('23', 'Onyx Hall', '0', '0', '0', '0', '0', null, '0', '0'),('24', 'Topaz Hall', '0', '0', '0', '0', '0', null, '0', '0'),('25', 'Ruby Hall', '0', '0', '0', '0', '0', null, '0', '0'),('26', 'Crystal Hall', '0', '0', '0', '0', '0', null, '0', '0'),('27', 'Onyx Hall', '0', '0', '0', '0', '0', null, '0', '0'),('28', 'Sapphire Hall', '0', '0', '0', '0', '0', null, '0', '0'),('29', 'Moonstone Hall', '0', '0', '0', '0', '0', null, '0', '0'),('30', 'Emerald Hall', '0', '0', '0', '0', '0', null, '0', '0'),('31', 'The Atramental Barracks', '0', '0', '0', '0', '0', null, '0', '0'),('32', 'The Scarlet Barracks', '0', '0', '0', '0', '0', null, '0', '0'),('33', 'The Viridian Barracks', '0', '0', '0', '0', '0', null, '0', '0'),('34', 'Devastated Castle', '0', '0', '0', '0', '0', null, '0', '0'),('35', 'Bandit Stronghold', '0', '0', '0', '0', '0', null, '0', '0'),('36', 'The Golden Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('37', 'The Silver Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('38', 'The Mithril Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('39', 'Silver Manor', '0', '0', '0', '0', '0', null, '0', '0'),('40', 'Gold Manor', '0', '0', '0', '0', '0', null, '0', '0'),('41', 'The Bronze Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('42', 'The Golden Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('43', 'The Silver Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('44', 'The Mithril Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('45', 'The Bronze Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('46', 'Silver Manor', '0', '0', '0', '0', '0', null, '0', '0'),('47', 'Moonstone Hall', '0', '0', '0', '0', '0', null, '0', '0'),('48', 'Onyx Hall', '0', '0', '0', '0', '0', null, '0', '0'),('49', 'Emerald Hall', '0', '0', '0', '0', '0', null, '0', '0'),('50', 'Sapphire Hall', '0', '0', '0', '0', '0', null, '0', '0'),('51', 'Mont Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('52', 'Astaire Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('53', 'Aria Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('54', 'Yiana Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('55', 'Roien Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('56', 'Luna Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('57', 'Traban Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('58', 'Eisen Hall', '0', '0', '0', '0', '0', null, '0', '0'),('59', 'Heavy Metal Hall', '0', '0', '0', '0', '0', null, '0', '0'),('60', 'Molten Ore Hall', '0', '0', '0', '0', '0', null, '0', '0'),('61', 'Titan Hall', '0', '0', '0', '0', '0', null, '0', '0'),('62', 'Rainbow Springs', '0', '0', '0', '0', '0', null, '0', '0'),('63', 'Wild Beast Reserve', '0', '0', '0', '0', '0', null, '0', '0'),('64', 'Fortress of the Dead', '0', '0', '0', '0', '0', null, '0', '0');

UPDATE clan_data SET hasCastle=0;

Set clan hall, castle siege time from db:

SQL:

UPDATE clanhall
SET siege_date = UNIX_TIMESTAMP('2027-12-01 12:00:00') * 1000;

UPDATE castle
SET siege_date = UNIX_TIMESTAMP('2027-12-01 12:00:00') * 1000
WHERE name IN ('Giran', 'Oren', 'Aden', 'Innadril', 'Goddard', 'Rune', 'Schuttgart');

UPDATE castle
SET siege_date = UNIX_TIMESTAMP('2025-02-01 20:30:00') * 1000
WHERE name = 'Gludio';

UPDATE castle
SET siege_date = UNIX_TIMESTAMP('2025-01-25 20:30:00') * 1000
WHERE name = 'Dion';

SELECT siege_date, FROM_UNIXTIME(siege_date / 1000) AS siege_date_utc
FROM clanhall;

SELECT name, siege_date, FROM_UNIXTIME(siege_date / 1000) AS siege_date_utc
FROM castle
WHERE name IN ('Giran', 'Oren', 'Aden', 'Innadril', 'Goddard', 'Rune', 'Schuttgart', 'Gludio', 'Dion');

Sintese · 2026-03-21T01:44:37+0300

Trance said:

Enquanto o servidor estiver offline:

Eliminar cercos:

SQL:

EXCLUIR DE castle_manor_production;
EXCLUIR DO castelo;
INSERIR NO castelo VALORES ('1', 'Gludio', '0', '0', '0', '0', '0', '0'),('2', 'Dion', '0', '0', '0', '0', '0', '0'),('3', 'Giran', '0', '0', '0', '0', '0', '0'),('4', 'Oren', '0', '0', '0', '0', '0', '0'),('5', 'Aden', '0', '0', '0', '0', '0', '0'),('6', 'Innadril', '0', '0', '0', '0', '0', '0'),('7', 'Goddard', '0', '0', '0', '0', '0', '0'),('8', 'Runa', '0', '0', '0', '0', '0'),('9', 'Schuttgart', '0', '0', '0', '0', '0', '0');
EXCLUIR DO salão do clã;
INSERT INTO clanhall VALUES ('21', 'Fortaleza da Resistência', '0', '0', '0', '0', '0', null, '0', '0'),('22', 'Salão da Pedra da Lua', '0', '0', '0', '0', '0', null, '0', '0'),('23', 'Salão de Ônix', '0', '0', '0', '0', '0', null, '0', '0'),('24', 'Salão de Topázio', '0', '0', '0', '0', '0', null, '0', '0'),('25', 'Salão de Rubi', '0', '0', '0', '0', '0', null, '0', '0'),('26', 'Salão de Cristal', '0', '0', '0', '0', '0', nulo, '0', '0'),('27', 'Salão de Ônix', '0', '0', '0', '0', '0', nulo, '0', '0'),('28', 'Salão de Safira', '0', '0', '0', '0', '0', nulo, '0', '0'),('29', 'Salão da Pedra da Lua', '0', '0', '0', '0', '0', nulo, '0', '0'),('30', 'Salão de Esmeralda', '0', '0', '0', '0', '0', nulo, '0', '0'),('31', 'O Quartel Atramental', '0', '0', '0', '0', '0', nulo, '0', '0'),('32', 'O Quartel Escarlate', '0', '0', '0', '0', '0', null, '0', '0'),('33', 'O Quartel Viridiano', '0', '0', '0', '0', '0', null, '0', '0'),('34', 'Castelo Devastado', '0', '0', '0', '0', '0', null, '0', '0'),('35', 'Fortaleza dos Bandidos', '0', '0', '0', '0', '0', null, '0', '0'),('36', 'A Câmara Dourada', '0', '0', '0', '0', '0', null, '0', '0'),('37', 'A Câmara de Prata', '0', '0', '0', '0', '0', nulo, '0', '0'),('38', 'A Câmara de Mithril', '0', '0', '0', '0', '0', nulo, '0', '0'),('39', 'Mansão de Prata', '0', '0', '0', '0', '0', nulo, '0', '0'),('40', 'Mansão de Ouro', '0', '0', '0', '0', '0', nulo, '0', '0'),('41', 'A Câmara de Bronze', '0', '0', '0', '0', '0', nulo, '0', '0'),('42', 'A Câmara Dourada','0', '0', '0', '0', '0', null, '0', '0'),('43', 'A Câmara de Prata', '0', '0', '0', '0', '0', null, '0', '0'),('44', 'A Câmara de Mithril', '0', '0', '0', '0', '0', null, '0', '0'),('45', 'A Câmara de Bronze', '0', '0', '0', '0', '0', null, '0', '0'),('46', 'Mansão de Prata', '0', '0', '0', '0', '0', null, '0', '0'),('47', 'Salão da Pedra da Lua', '0', '0', '0', '0', '0', null, '0', '0'),('48', 'Salão de Ônix', '0', '0', '0', '0', '0', null, '0', '0'),('49', 'Salão Esmeralda', '0', '0', '0', '0', '0', null, '0', '0'),('50', 'Salão de Safira', '0', '0', '0', '0', '0', null, '0', '0'),('51', 'Câmara Mont', '0', '0', '0', '0', '0', null, '0', '0'),('52', 'Câmara Astaire', '0', '0', '0', '0', '0', null, '0', '0'),('53', 'Câmara Aria', '0', '0', '0', '0', '0', null, '0', '0'),('54', 'Yiana Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('55', 'Roien Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('56', 'Luna Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('57', 'Traban Chamber', '0', '0', '0', '0', '0', null, '0', '0'),('58', 'Eisen Hall', '0', '0', '0', '0', '0', null, '0', '0'),('59', 'Heavy Metal Hall', '0', '0', '0', '0', '0', null, '0', '0'),('60', 'Molten Ore Hall', '0', '0', '0', '0', '0', null, '0', '0'),('61', 'Titan Hall', '0', '0', '0', '0', '0', null, '0', '0'),('62', 'Rainbow Springs', '0', '0', '0', '0', '0', null, '0', '0'),('63', 'Wild Beast Reserve', '0', '0', '0', '0', '0', null, '0', '0'),('64', 'Fortaleza dos Mortos', '0', '0', '0', '0', '0', nulo, '0', '0');

ATUALIZAR clan_data SET hasCastle=0;

Defina o tempo de cerco a partir do banco de dados:

[CÓDIGO=sql]ATUALIZAR salão do clã
DEFINIR data_do_cerco = UNIX_TIMESTAMP('2027-12-01 12:00:00') * 1000;

ATUALIZAÇÃO castelo
DEFINIR data_do_cerco = UNIX_TIMESTAMP('2027-12-01 12:00:00') * 1000
ONDE nome IN ('Giran', 'Oren', 'Aden', 'Innadril', 'Goddard', 'Rune', 'Schuttgart');

ATUALIZAÇÃO castelo
DEFINIR data_do_cerco = UNIX_TIMESTAMP('2025-02-01 20:30:00') * 1000
ONDE nome = 'Gludio';

ATUALIZAÇÃO castelo
DEFINIR data_do_cerco = UNIX_TIMESTAMP('2025-01-25 20:30:00') * 1000
ONDE nome = 'Dion';

SELECT siege_date, FROM_UNIXTIME(siege_date / 1000) AS siege_date_utc
DO salão do clã;

SELECT nome, data_do_cerco, FROM_UNIXTIME(data_do_cerco / 1000) AS data_do_cerco_utc
DO castelo
ONDE nome IN ('Giran', 'Oren', 'Aden', 'Innadril', 'Goddard', 'Rune', 'Schuttgart', 'Gludio', 'Dion');[/CODE]

Ok, muito obrigada!

SIEGE DATE ERROR

Sintese

Vassal

test

Heir

Sintese

Vassal

Trance

Heir

Sintese

Vassal