Posts

Showing posts from September, 2025

copy thread

DROP TABLE IF EXISTS `fcsapxmy_forum4hk`.`mybb_threads`; CREATE TABLE `fcsapxmy_forum4hk`.`mybb_threads` (   `tid` int UNSIGNED NOT NULL,   `fid` smallint UNSIGNED NOT NULL DEFAULT '0',   `subject` varchar(120) NOT NULL DEFAULT '',   `prefix` smallint UNSIGNED NOT NULL DEFAULT '0',   `icon` smallint UNSIGNED NOT NULL DEFAULT '0',   `poll` int UNSIGNED NOT NULL DEFAULT '0',   `uid` int UNSIGNED NOT NULL DEFAULT '0',   `username` varchar(80) NOT NULL DEFAULT '',   `dateline` int UNSIGNED NOT NULL DEFAULT '0',   `firstpost` int UNSIGNED NOT NULL DEFAULT '0',   `lastpost` int UNSIGNED NOT NULL DEFAULT '0',   `lastposter` varchar(120) NOT NULL DEFAULT '',   `lastposteruid` int UNSIGNED NOT NULL DEFAULT '0',   `views` int UNSIGNED NOT NULL DEFAULT '0',   `replies` int UNSIGNED NOT NULL DEFAULT '0',   `closed` varchar(30) NOT NULL DEFAULT '',   `sticky` tinyint(1) NOT NULL D...

Copy Post to forum

DROP TABLE IF EXISTS `fcsapxmy_forum4hk`.`mybb_posts`; CREATE TABLE `fcsapxmy_forum4hk`.`mybb_posts` (   `pid` int UNSIGNED NOT NULL,   `tid` int UNSIGNED NOT NULL DEFAULT '0',   `replyto` int UNSIGNED NOT NULL DEFAULT '0',   `fid` smallint UNSIGNED NOT NULL DEFAULT '0',   `subject` varchar(120) NOT NULL DEFAULT '',   `icon` smallint UNSIGNED NOT NULL DEFAULT '0',   `uid` int UNSIGNED NOT NULL DEFAULT '0',   `username` varchar(80) NOT NULL DEFAULT '',   `dateline` int UNSIGNED NOT NULL DEFAULT '0',   `message` text NOT NULL,   `ipaddress` varbinary(16) NOT NULL DEFAULT '',   `includesig` tinyint(1) NOT NULL DEFAULT '0',   `smilieoff` tinyint(1) NOT NULL DEFAULT '0',   `edituid` int UNSIGNED NOT NULL DEFAULT '0',   `edittime` int UNSIGNED NOT NULL DEFAULT '0',   `editreason` varchar(150) NOT NULL DEFAULT '',   `visible` tinyint(1) NOT NULL DEFAULT '0' ) ENGINE=MyISAM D...

Drop Table

DROP TABLE IF EXISTS `fcsapxmy_forum4hk`.`mybb_forums`; CREATE TABLE `fcsapxmy_forum4hk`.`mybb_forums` (   `fid` smallint UNSIGNED NOT NULL,   `name` varchar(120) NOT NULL DEFAULT '',   `description` text NOT NULL,   `linkto` varchar(180) NOT NULL DEFAULT '',   `type` char(1) NOT NULL DEFAULT '',   `pid` smallint UNSIGNED NOT NULL DEFAULT '0',   `parentlist` text NOT NULL,   `disporder` smallint UNSIGNED NOT NULL DEFAULT '0',   `active` tinyint(1) NOT NULL DEFAULT '0',   `open` tinyint(1) NOT NULL DEFAULT '0',   `threads` int UNSIGNED NOT NULL DEFAULT '0',   `posts` int UNSIGNED NOT NULL DEFAULT '0',   `lastpost` int UNSIGNED NOT NULL DEFAULT '0',   `lastposter` varchar(120) NOT NULL DEFAULT '',   `lastposteruid` int UNSIGNED NOT NULL DEFAULT '0',   `lastposttid` int UNSIGNED NOT NULL DEFAULT '0',   `lastpostsubject` varchar(120) NOT NULL DEFAULT '',   `allowhtml` tinyint(1) ...