[ankam26]

Седня решил посмотреть сколько осталось до продажи клан холла Чуть больше тысячелетия!!! Можно ли включить "Машину Времени" и сократить период ожидания до прям того момента, как ты прочтешь это сообщение? Избавиться от КХ необходимо до 13 июня до 17 часов 30 минут ) Связано с захватом Элитного КХ.
))) как то так

[unteam]

это еще со времен авейкинга так)

[l2gold]

непонятно как так игроки делают xD
следовательно фикса не будет xD

[ankam26]

какого хора я сейчас выслушиваю от игроков которые бабки в эти кх вкладывают и прочее??
давайте хоть какое решение. времени сутки осталось

[Core]

Можно дамп вашей таблицы clanhall?

[l2gold]

--
-- Структура таблицы `clanhall`
--

CREATE TABLE IF NOT EXISTS `clanhall` (
  `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(40) NOT NULL DEFAULT '',
  `last_siege_date` int(10) unsigned NOT NULL,
  `own_date` int(10) unsigned NOT NULL,
  `siege_date` int(10) unsigned NOT NULL,
  `auction_min_bid` bigint(20) NOT NULL,
  `auction_length` int(11) NOT NULL,
  `auction_desc` text,
  `cycle` int(11) NOT NULL,
  `paid_cycle` int(11) NOT NULL,
  PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `clanhall`
--

INSERT INTO `clanhall` (`id`, `name`, `last_siege_date`, `own_date`, `siege_date`, `auction_min_bid`, `auction_length`, `auction_desc`, `cycle`, `paid_cycle`) VALUES
(21, 'Fortress of Resistance', 0, 0, 1371747600, 0, 0, '', 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, 1371920400, 0, 0, '', 0, 0),
(35, 'Bandit Stronghold', 0, 0, 1371920400, 0, 0, '', 0, 0),
(36, 'The Golden Chamber', 0, 0, 0, 100000000, 1, '', 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, 1371924000, 0, 0, '', 0, 0),
(63, 'Wild Beast Reserve', 0, 0, 1371920400, 0, 0, '', 0, 0),
(64, 'Fortress of the Dead', 0, 0, 1371909600, 0, 0, '', 0, 0);

CREATE TABLE IF NOT EXISTS `clanhall` (
  `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(40) NOT NULL DEFAULT '',
  `last_siege_date` int(10) unsigned NOT NULL,
  `own_date` int(10) unsigned NOT NULL,
  `siege_date` int(10) unsigned NOT NULL,
  `auction_min_bid` bigint(20) NOT NULL,
  `auction_length` int(11) NOT NULL,
  `auction_desc` text,
  `cycle` int(11) NOT NULL,
  `paid_cycle` int(11) NOT NULL,
  PRIMARY KEY (`id`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `clanhall`
--

INSERT INTO `clanhall` (`id`, `name`, `last_siege_date`, `own_date`, `siege_date`, `auction_min_bid`, `auction_length`, `auction_desc`, `cycle`, `paid_cycle`) VALUES
(21, 'Fortress of Resistance', 0, 0, 1371747600, 0, 0, '', 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, 1369652400, 1371466800, 20000000, 7, '', 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, 1370862000, 0, 0, 0, '', 137, 137),
(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, 1371920400, 0, 0, '', 0, 0),
(35, 'Bandit Stronghold', 0, 0, 1371920400, 0, 0, '', 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, 100000000, 7, '', 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, 1371924000, 0, 0, '', 0, 0),
(63, 'Wild Beast Reserve', 0, 0, 1371920400, 0, 0, '', 0, 0),
(64, 'Fortress of the Dead', 0, 0, 1371909600, 0, 0, '', 0, 0);