CREATE TABLE ipb_macro ( macro_id smallint(3) NOT NULL auto_increment, macro_value varchar(200) default NULL, macro_replace text, can_remove tinyint(1) default '0', macro_set smallint(3) NOT NULL default '', PRIMARY KEY (macro_id), KEY macro_set (macro_set) ) TYPE=MyISAM;

macro_set smallint(3) NOT NULL default ''

macro_set smallint(3) NOT NULL default '0'

CREATE TABLE ipb_subscription_logs ( sublog_id int(10) NOT NULL auto_increment, sublog_date int(10) NOT NULL default '', sublog_member_id mediumint(8) NOT NULL default '0', sublog_transid int(10) NOT NULL default '', sublog_ipaddress varchar(16) NOT NULL default '', sublog_data text, sublog_postdata text, PRIMARY KEY (sublog_id) ) TYPE=MyISAM;

sublog_date int(10) NOT NULL default ''

sublog_date int(10) NOT NULL default '0'

sublog_transid int(10) NOT NULL default ''

sublog_transid int(10) NOT NULL default '0'

CREATE TABLE ipb_subscription_methods ( submethod_id smallint(5) NOT NULL auto_increment, submethod_title varchar(250) NOT NULL default '', submethod_name varchar(20) NOT NULL default '', submethod_email varchar(250) NOT NULL default '', submethod_sid text, submethod_custom_1 text, submethod_custom_2 text, submethod_custom_3 text, submethod_custom_4 text, submethod_custom_5 text, submethod_is_cc tinyint(1) NOT NULL default '0', submethod_is_auto tinyint(1) NOT NULL default '0', submethod_desc text, submethod_logo text, submethod_active tinyint(1) NOT NULL default '', submethod_use_currency varchar(10) NOT NULL default 'USD', PRIMARY KEY (submethod_id) ) TYPE=MyISAM;

ubmethod_active tinyint(1) NOT NULL default ''

ubmethod_active tinyint(1) NOT NULL default '0'

$DB->query("SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
                   c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
                   FROM ipb_forums f, ipb_categories c
                     LEFT JOIN ipb_moderators m ON (f.id=m.forum_id)
                   WHERE c.id=f.category
                   ORDER BY c.position, f.position");

$DB->query("SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
                   c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
                   FROM (ibf_forums f, ibf_categories c)
                     LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
                   WHERE c.id=f.category
                   ORDER BY c.position, f.position");