ultrazero wrote: or would there be no harm in leaving the sql queries the way they are?
You can leave DB as is. It shouldn't cause any problems.
Code: Select all
Couldn't insert row in forums table
DEBUG MODE
SQL Error : 1054 Unknown column 'auth_ban' in 'field list'
INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, attached_forum_id, forum_desc, forum_order, forum_status, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_ban, auth_greencard, auth_bluecard, auth_vote, auth_pollcreate) VALUES ('42', 'test', 7, 28, '', 20, 0, 0, 1, 1, 1, 1, 1, 1, 1, 3, 3, 5, 1, 1, 1)
Line : 513
File : admin_forums.php
Code: Select all
<b> text </b>
Code: Select all
'sub_name'=>$value['forum_name'],
Code: Select all
'sub_color'=>$value['forum_color'],
Code: Select all
'L_FORUM_IMAGE' => $attached_forums[$k]['sub_alt'],
Code: Select all
'FORUM_COLOR' => ( $attached_forums[$k]['sub_color'] != '' ) ? 'style="color: #'.$attached_forums[$k]['sub_color'].'"' : '',
Code: Select all
<a class="nav" href="{catrow.forumrow.switch_attached_forums.attached_forums.U_VIEWFORUM}"><img alt="{catrow.forumrow.switch_attached_forums.attached_forums.L_FORUM_IMAGE}" border="0" src="{catrow.forumrow.switch_attached_forums.attached_forums.FORUM_IMAGE}" title="{catrow.forumrow.switch_attached_forums.attached_forums.L_FORUM_IMAGE}" />{catrow.forumrow.switch_attached_forums.attached_forums.FORUM_NAME}</a>
Code: Select all
<a class="nav" {catrow.forumrow.switch_attached_forums.attached_forums.FORUM_COLOR} href="{catrow.forumrow.switch_attached_forums.attached_forums.U_VIEWFORUM}"><img alt="{catrow.forumrow.switch_attached_forums.attached_forums.L_FORUM_IMAGE}" border="0" src="{catrow.forumrow.switch_attached_forums.attached_forums.FORUM_IMAGE}" title="{catrow.forumrow.switch_attached_forums.attached_forums.L_FORUM_IMAGE}" />{catrow.forumrow.switch_attached_forums.attached_forums.FORUM_NAME}</a>
Code: Select all
#
#-----[ FIND ]------------------------------------------------
#
else
{
$unread_topics = false;
if ( $userdata['session_logged_in'] )
{
// Added by Attached Forums MOD
$unread_topics=check_unread($forum_id);
// END Added by Attached Forums MOD
}
$folder_image = ( $unread_topics ) ? $images['forum_new'] : $images['forum'];
$folder_alt = ( $unread_topics ) ? $lang['New_posts'] : $lang['No_new_posts'];
}
#
#-----[ REPLACE WITH ]----------------------------------------
#
else
{
//MOD Keep_Unread_2 * Forum_unread flags set earlier
$unread_topic = $forum_unreads[$forum_id];
$folder_image = ( $unread_topic ) ? $images['forum_new'] : $images['forum'];
$folder_alt = ( $unread_topic ) ? $lang['New_posts'] : $lang['No_new_posts'];
}