#
#-----[ SQL ]------------------------------------------
#
DROP TABLE IF EXISTS phpbb_approve_forums;
CREATE TABLE phpbb_approve_forums (
forum_id smallint(5) unsigned NOT NULL default '0',
enabled tinyint(1) NOT NULL default '0',
approve_posts tinyint(1) NOT NULL default '0',
approve_topics tinyint(1) NOT NULL default '0',
approve_users tinyint(1) NOT NULL default '0',
approve_poste tinyint(1) NOT NULL default '0',
approve_topice tinyint(1) NOT NULL default '0',
approve_notify tinyint(1) NOT NULL default '0',
approve_notify_approval tinyint(1) NOT NULL default '0',
approve_notify_type tinyint(1) NOT NULL default '0',
approve_notify_message tinyint(1) NOT NULL default '0',
approve_notify_message_len smallint(5) NOT NULL default '500',
approve_notify_user varchar(255) NOT NULL default '0',
approve_notify_posts tinyint(1) NOT NULL default '0',
approve_notify_poste tinyint(1) NOT NULL default '0',
approve_notify_topics tinyint(1) NOT NULL default '0',
approve_notify_topice tinyint(1) NOT NULL default '0',
PRIMARY KEY (forum_id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS phpbb_approve_posts;
CREATE TABLE phpbb_approve_posts (
approval_id mediumint( unsigned NOT NULL auto_increment,
topic_id mediumint( unsigned NOT NULL default '0',
post_id mediumint( unsigned NOT NULL default '0',
is_topic tinyint(1) NOT NULL default '0',
is_post tinyint(1) NOT NULL default '0',
poster_id mediumint( NOT NULL default '0',
PRIMARY KEY (approval_id),
KEY post_id (post_id),
KEY topic_id (topic_id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS phpbb_approve_topics;
CREATE TABLE phpbb_approve_topics (
topic_id mediumint( unsigned NOT NULL default '0',
approve_moderate tinyint(1) NOT NULL default '0',
PRIMARY KEY (topic_id)
) TYPE=MyISAM;
DROP TABLE IF EXISTS phpbb_approve_users;
CREATE TABLE phpbb_approve_users (
user_id mediumint( NOT NULL default '0',
approve_moderate tinyint(1) NOT NULL default '0',
PRIMARY KEY (user_id)
) TYPE=MyISAM;
issue addressed..
Could not insert forum approval information
DEBUG MODE
SQL Error : 1054 Unknown column 'approve_moderators' in 'field list'
INSERT INTO phpbb_approve_forums (forum_id, enabled, approve_posts, approve_topics, approve_users, approve_poste, approve_topice, approve_notify, approve_notify_type, approve_notify_message, approve_notify_message_len, approve_moderators, approve_notify_posts, approve_notify_poste, approve_notify_topics, approve_notify_topice, approve_notify_approval) VALUES ('3', '1', '1', '1', '1', '1', '1', '1', '-1', '1', '200', '2', '1', '1', '1', '1', '0')
Line : 611
File : /home/MYACCOUNT/MYFORUMURL/admin/admin_forums.php
#
#----[ SQL ] -----------
#
ALTER TABLE `phpbb_approve_forums` CHANGE `approve_notify_user` `approve_moderators` VARCHAR(255) NOT NULL
$last_post_author = ( $topic_rowset[$i]['id2'] == ANONYMOUS ) ? $lang['Guest'] : $last_post_author;
Code: Select all
//
// Begin Approve_Mod
//
$approve_mod = array();
$approve_sql = "SELECT * FROM " . APPROVE_FORUMS_TABLE . " WHERE forum_id = '" . $forum_data[$j]['forum_id'] . "' LIMIT 0,1";
if ( !($approve_result = $db->sql_query($approve_sql)) )
{
message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql);
}
if ( $approve_row = $db->sql_fetchrow($approve_result) )
{
if ( intval($approve_row['enabled']) == 1 )
{
$approve_mod = $approve_row;
$approve_mod['enabled'] = true;
}
}
$approve_mod['moderators'] = array();
$approve_mod['moderators'] = explode("|", $approve_mod['approve_moderators']);
if ( $approve_mod['enabled'] && !in_array($userdata['user_id'], $approve_mod['moderators']) && !$is_auth_ary[$forum_id]['auth_mod'])
{
if( $last_post != $lang['No_Posts'] && $forum_data[$j]['user_id'] == ANONYMOUS )
{
$last_post = $last_post_time . '<br />';
$last_post .= $lang['Guest'] . ' ' . '<a href="' . append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $forum_data[$j]['forum_id']) . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '" /></a>';
}
}
//
// End Approve_Mod
//
Code: Select all
//
// Begin Approve_Mod
//
$approve_mod = array();
$approve_sql = "SELECT enabled, approve_moderators FROM " . APPROVE_FORUMS_TABLE . " WHERE forum_id = '" . $forum_data[$j]['forum_id'] . "' LIMIT 0,1";
if ( !($approve_result = $db->sql_query($approve_sql)) )
{
message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql);
}
if ( $approve_row = $db->sql_fetchrow($approve_result) )
{
if ( intval($approve_row['enabled']) == 1 )
{
$approve_mod = $approve_row;
$approve_mod['enabled'] = true;
}
}
if ( $approve_mod['enabled'] )
{
$approve_mod['moderators'] = array();
$approve_mod['moderators'] = explode("|", $approve_mod['approve_moderators']);
if ( !in_array($userdata['user_id'], $approve_mod['moderators']) && !$is_auth_ary[$forum_id]['auth_mod'] && $last_post != $lang['No_Posts'] && $forum_data[$j]['user_id'] == ANONYMOUS )
{
$approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . " WHERE post_id = " . intval($forum_data[$j]['forum_last_post_id']) . " LIMIT 0,1";
if ( !$approve_result = $db->sql_query($approve_sql) )
{
message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql);
}
$approve_row = $db->sql_fetchrow($approve_result);
if( intval($approve_row['post_id']) == intval($forum_data[$j]['forum_last_post_id']) )
{
$last_post = $last_post_time . '<br />';
$last_post .= $lang['Guest'] . ' ' . '<a href="' . append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $forum_data[$j]['forum_id']) . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '" /></a>';
}
}
}
//
// End Approve_Mod
//