Изменения: 1)Информация теперь берётся из t_catalog и t_ct_item. 2)Информацию о включении видимости предмета берёт из строки a_active. 3)Чуть поправлены функции логов. 4)И так по мелочи. Структура
DROP TABLE IF EXISTS `t_catalog`; CREATE TABLE `t_catalog` ( `a_ctid` int(11) unsigned NOT NULL AUTO_INCREMENT, `a_ctname` varchar(60) NOT NULL DEFAULT '', `a_category` int(11) NOT NULL DEFAULT '0', `a_type` int(11) unsigned NOT NULL DEFAULT '0', `a_subtype` int(11) NOT NULL DEFAULT '0', `a_cash` int(11) unsigned NOT NULL DEFAULT '0', `a_ctdesc` text NOT NULL, `a_mileage` int(11) unsigned NOT NULL DEFAULT '0', `a_enable` tinyint(1) unsigned NOT NULL DEFAULT '1', `a_texture_id` tinyint(4) NOT NULL DEFAULT '-1', `a_texture_row` tinyint(4) NOT NULL DEFAULT '-1', `a_texture_col` tinyint(4) NOT NULL DEFAULT '-1', `a_flag` int(11) NOT NULL DEFAULT '0', `a_icon` tinyint(3) unsigned DEFAULT '0', `a_ctname_tld` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_tld` text NOT NULL, `a_ctname_twn` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_twn` text NOT NULL, `a_ctname_jpn` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_jpn` text NOT NULL, `a_ctname_usa` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_usa` text NOT NULL, `a_ctname_brz` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_brz` text NOT NULL, `a_ctname_hk` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_hk` text NOT NULL, `a_ctname_hk_eng` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_hk_eng` text NOT NULL, `a_ctname_ger` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_ger` text NOT NULL, `a_ctname_rus` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_rus` text NOT NULL, `a_ctname_tur` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_tur` text NOT NULL, `a_ctname_spn` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_spn` text NOT NULL, `a_ctname_frc` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_frc` text NOT NULL, `a_ctname_pld` varchar(60) NOT NULL DEFAULT '', `a_ctdesc_pld` varchar(60) DEFAULT NULL, `bill_item` varchar(60) DEFAULT NULL, `a_active` tinyint(1) NOT NULL, PRIMARY KEY (`a_ctid`), KEY `name` (`a_ctname`) ) ENGINE=MyISAM AUTO_INCREMENT=3425 DEFAULT CHARSET=latin1;