query( "SELECT COUNT(*) as count, user_id FROM " . PREFIX . "_comments WHERE post_id='$id' AND is_register='1' GROUP BY user_id" ); while ( $row = $db->get_array( $result ) ) { $db->query( "UPDATE " . USERPREFIX . "_users set comm_num=comm_num-{$row['count']} where user_id='{$row['user_id']}'" ); } $db->query( "DELETE FROM " . PREFIX . "_comments WHERE post_id='$id'" ); $db->query( "UPDATE " . PREFIX . "_post set comm_num='0' where id ='$id'" ); clear_cache(); msg( "info", $lang['mass_head'], $lang['mass_delokc'], "$PHP_SELF?mod=editnews&action=list" ); } elseif( $action == "mass_delete" ) { if( $_REQUEST['user_hash'] == "" or $_REQUEST['user_hash'] != $dle_login_hash ) { die( "Hacking attempt! User not found" ); } if( ! $_POST['selected_comments'] ) { msg( "error", $lang['mass_error'], $lang['mass_dcomm'], "$PHP_SELF?mod=comments&action=edit&id={$id}" ); } foreach ( $_POST['selected_comments'] as $c_id ) { $c_id = intval( $c_id ); $row = $db->super_query( "SELECT * FROM " . PREFIX . "_comments where id = '$c_id'" ); $author = $row['autor']; $is_reg = $row['is_register']; $post_id = $row['post_id']; $db->query( "DELETE FROM " . PREFIX . "_comments WHERE id = '$c_id'" ); if( $is_reg ) { $db->query( "UPDATE " . USERPREFIX . "_users set comm_num=comm_num-1 where name ='$author'" ); } $db->query( "UPDATE " . PREFIX . "_post SET comm_num=comm_num-1 where id='$post_id'" ); } clear_cache( 'news_' ); msg( "info", $lang['mass_head'], $lang['mass_delokc'], "$PHP_SELF?mod=comments&action=edit&id={$id}" ); } elseif( $action == "edit" ) { include_once ENGINE_DIR . '/classes/parse.class.php'; $parse = new ParseFilter( ); $parse->safe_mode = true; if ( $id ) $where = "post_id = '{$id}' AND "; else $where = ""; $start_from = intval( $_GET['start_from'] ); if( $start_from < 0 ) $start_from = 0; $news_per_page = 50; $i = $start_from; $gopage = intval( $_GET['gopage'] ); if( $gopage > 0 ) $start_from = ($gopage - 1) * $news_per_page; $js_array[] = "engine/classes/js/dle_ajax.js"; echoheader( "", "" ); $entries = ""; $result_count = $db->super_query( "SELECT COUNT(*) as count FROM " . PREFIX . "_comments WHERE {$where}approve='1'" ); $db->query( "SELECT id, autor, text, ip FROM " . PREFIX . "_comments WHERE {$where}approve='1' order by date DESC LIMIT $start_from,$news_per_page" ); while ( $row = $db->get_array() ) { $i ++; if( $config['allow_comments_wysiwyg'] == "yes" ) { $row['text'] = $parse->decodeBBCodes( $row['text'] ); } else $row['text'] = $parse->decodeBBCodes( $row['text'], false ); $row['text'] = ""; $entries .= "" . stripslashes( $row['autor'] ) . ""; $entries .= "" . stripslashes( $row['ip'] ) . ""; $entries .= "" . $row['text'] . ""; $entries .= ""; $entries .= ""; $entries .= ""; } $db->free(); // pagination $npp_nav = "

"; if( $start_from > 0 ) { $previous = $start_from - $news_per_page; $npp_nav .= "<< "; } if( $result_count['count'] > $news_per_page ) { $enpages_count = @ceil( $result_count['count'] / $news_per_page ); $enpages_start_from = 0; $enpages = ""; if( $enpages_count <= 10 ) { for($j = 1; $j <= $enpages_count; $j ++) { if( $enpages_start_from != $start_from ) { $enpages .= "$j "; } else { $enpages .= "$j "; } $enpages_start_from += $news_per_page; } $npp_nav .= $enpages; } else { $start = 1; $end = 10; if( $start_from > 0 ) { if( ($start_from / $news_per_page) > 4 ) { $start = @ceil( $start_from / $news_per_page ) - 3; $end = $start + 9; if( $end > $enpages_count ) { $start = $enpages_count - 10; $end = $enpages_count - 1; } $enpages_start_from = ($start - 1) * $news_per_page; } } if( $start > 2 ) { $enpages .= "1 ... "; } for($j = $start; $j <= $end; $j ++) { if( $enpages_start_from != $start_from ) { $enpages .= "$j "; } else { $enpages .= "$j "; } $enpages_start_from += $news_per_page; } $enpages_start_from = ($enpages_count - 1) * $news_per_page; $enpages .= "... $enpages_count "; $npp_nav .= $enpages; } } if( $result_count['count'] > $i ) { $how_next = $result_count['count'] - $i; if( $how_next > $news_per_page ) { $how_next = $news_per_page; } $npp_nav .= ">>"; } $npp_nav .= "

"; // pagination echo << HTML; echofooter(); } else { msg( "error", $lang['addnews_denied'], $lang['addnews_denied'], "$PHP_SELF?mod=editnews&action=list" ); } ?>