wer hat diese beiden Mods sauber ans Laufen gebracht
CH-Mod 2.0.5 RC2 und Approve-Mod 1.0.10 (http://www.phpbb.com/phpBB/viewtopic.php?t=76852).
Hab da gewisse Schwierigkeiten den sauber in der index.php einzubauen. Hab versucht das Ganze in der functions_categories_hierarchy.php zusammenzubauen, aber stosse da auf Schwierigkeiten mit den Daten.
Zugriffe auf bsplw. $forum_data[$j]['user_id'] oder $forum_data[$j]['forum_id'] werden in diesem Codeblock angegeben, existieren aber leider nicht:
Code: Alles auswählen
//
// Begin Approve_Mod Block : 1
//
$approve_mod = array();
$approve_sql = "SELECT enabled, approve_moderators, forum_hide_unapproved_posts, forum_hide_unapproved_topics
FROM " . APPROVE_FORUMS_TABLE . "
WHERE forum_id = " . intval($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'] )
{
if ( $forum_data[$j]['user_id'] == ANONYMOUS || $approve_mod['forum_hide_unapproved_posts'] || $approve_mod['forum_hide_unapproved_topics'] )
{
$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'] )
{
$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']) )
{
if ( $approve_mod['forum_hide_unapproved_posts'] || $approve_mod['forum_hide_unapproved_topics'] )
{
$approve_sql = "SELECT p.post_id, p.poster_id, p.post_time, p.post_username, u.username, u.user_id
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u
WHERE p.forum_id = " . intval($forum_data[$j]['forum_id']) . "
AND u.user_id = p.poster_id
ORDER BY p.post_time DESC";
if ( !($approve_result = $db->sql_query($approve_sql)) )
{
message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql);
}
while( $approve_row = $db->sql_fetchrow($approve_result) )
{
$approve_sql = "SELECT * FROM " . APPROVE_POSTS_TABLE . "
WHERE post_id = " . intval($approve_row['post_id']) . "
LIMIT 0,1";
if ( !($approve_result2 = $db->sql_query($approve_sql)) )
{
message_die(GENERAL_ERROR, $lang['approve_posts_error_obtain'], '', __LINE__, __FILE__, $approve_sql);
}
$approve_row2 = $db->sql_fetchrow($approve_result2);
if ( !$approve_row2['post_id'] )
{
$last_post_time = create_date($board_config['default_dateformat'], $approve_row['post_time'], $board_config['board_timezone']);
$last_post = $last_post_time . '<br />';
$last_post .= ( $approve_row['user_id'] == ANONYMOUS ) ? ( ($approve_row['post_username'] != '' ) ? $approve_row['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '=' . $approve_row['poster_id']) . '">' . $approve_row['username'] . '</a> ';
$last_post .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $approve_row['post_id']) . '#' . $approve_row['post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '" /></a>';
break;
}
}
}
else
{
$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 Block : 1
//
