[zippel]

Сообщение от strelock

У меня нету таблицы такой в БД

создай таблицу db_l2jdc и зделай sql запрос:

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `clan_introductions`;
CREATE TABLE `clan_introductions` (
  `serverId` int(8) NOT NULL,
  `clanId` int(8) NOT NULL,
  `introduction` text collate ucs2_bin NOT NULL,
  PRIMARY KEY  (`serverId`,`clanId`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;

DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `serverId` int(8) NOT NULL default '0',
  `comment_id` int(8) NOT NULL default '0',
  `comment_ownerid` int(8) NOT NULL default '0',
  `comment_date` decimal(20,0) NOT NULL default '0',
  `comment_post_id` int(8) NOT NULL default '0',
  `comment_topic_id` int(8) NOT NULL default '0',
  `comment_forum_id` int(8) NOT NULL default '0',
  `comment_txt` text collate ucs2_bin NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;

DROP TABLE IF EXISTS `forums`;
CREATE TABLE `forums` (
  `serverId` int(8) NOT NULL default '0',
  `forum_id` int(8) NOT NULL default '0',
  `forum_name` varchar(255) collate ucs2_bin NOT NULL default '',
  `forum_post` int(8) NOT NULL default '0',
  `forum_type` int(8) NOT NULL default '0',
  `forum_owner_id` int(8) NOT NULL default '0',
  PRIMARY KEY  (`serverId`,`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;

DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `serverId` int(8) NOT NULL default '0',
  `post_id` int(8) NOT NULL default '0',
  `post_ownerid` int(8) NOT NULL default '0',
  `post_recipient_list` varchar(255) collate ucs2_bin NOT NULL default '0',
  `post_parent_id` int(8) NOT NULL default '0',
  `post_date` decimal(20,0) NOT NULL default '0',
  `post_topic_id` int(8) NOT NULL default '0',
  `post_forum_id` int(8) NOT NULL default '0',
  `post_txt` text collate ucs2_bin NOT NULL,
  `post_title` text collate ucs2_bin,
  `post_type` int(8) NOT NULL default '0',
  `post_read_count` int(8) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;

DROP TABLE IF EXISTS `registered_gameservers`;
CREATE TABLE `registered_gameservers` (
  `serverId` int(11) NOT NULL default '0',
  `hex_id` varchar(50) collate ucs2_bin NOT NULL default '',
  `host` varchar(50) collate ucs2_bin NOT NULL default '',
  PRIMARY KEY  (`serverId`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;

DROP TABLE IF EXISTS `topics`;
CREATE TABLE `topics` (
  `serverId` int(8) NOT NULL default '0',
  `topic_id` int(8) NOT NULL default '0',
  `topic_forum_id` int(8) NOT NULL default '0',
  `topic_name` varchar(255) collate ucs2_bin NOT NULL default '',
  `topic_ownerid` int(8) NOT NULL default '0',
  `topic_permissions` int(8) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=ucs2 COLLATE=ucs2_bin;