source: extensions/Comments_on_Albums/include/coa_admin_comments.php @ 9766

<?php
/* Code adapted from admin/comments.php */
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

load_language('plugin.lang', COA_PATH);

// +-----------------------------------------------------------------------+
//                              Tabsheet
// +-----------------------------------------------------------------------+
include_once(PHPWG_ROOT_PATH.'admin/include/tabsheet.class.php');

$tabs = array(
        array(
                'code' => 'pictures',
                'label' => l10n('COA_comments_photos'),
        ),
        array(
                'code' => 'albums',
                'label' => l10n('COA_comments_albums'),
        ),
);

$tab_codes = array_map(create_function('$a', 'return $a["code"];'), $tabs);

if (isset($_GET['section']) and in_array($_GET['section'], $tab_codes)) {
        $page['tab'] = $_GET['section'];
} else {
        $page['tab'] = $tabs[0]['code'];
}

$tabsheet = new tabsheet();
foreach ($tabs as $tab) {
        $tabsheet->add(
                $tab['code'],
                $tab['label'],
                get_root_url().'admin.php?page=comments&amp;section='.$tab['code']
        );
}
$tabsheet->select($page['tab']);
$tabsheet->assign();


if ($page['tab'] == 'albums') {
        $template->clear_assign(array('ADMIN_CONTENT', 'comments', 'LIST', 'F_ACTION'));

        // +-----------------------------------------------------------------------+
        //                              Actions
        // +-----------------------------------------------------------------------+
        if (!empty($_POST)) {
                if (!empty($_POST['comments'])) {
                        check_input_parameter('comments', $_POST, true, PATTERN_ID);

                        if (isset($_POST['validate_albums'])) {
                                $query = 'UPDATE '.COA_TABLE.' SET 
                                                validated = \'true\',
                                                validation_date = NOW()
                                        WHERE id IN ('.implode(',', $_POST['comments']).')
                                ;';
                                pwg_query($query);

                                array_push($page['infos'], l10n_dec(
                                        '%d user comment validated', '%d user comments validated',
                                        count($_POST['comments'])
                                ));
                        }

                        if (isset($_POST['reject_albums'])) {
                                $query = 'DELETE FROM '.COA_TABLE.'
                                        WHERE id IN ('.implode(',', $_POST['comments']).')
                                ;';
                                pwg_query($query);

                                array_push($page['infos'], l10n_dec(
                                        '%d user comment rejected', '%d user comments rejected',
                                        count($_POST['comments'])
                                ));
                        }
                }
        }

        // +-----------------------------------------------------------------------+
        //                              Infos (re-assignation needed)
        // +-----------------------------------------------------------------------+
        if (count($page['infos']) != 0) {
                $template->assign('infos', $page['infos']);
        }

        // +-----------------------------------------------------------------------+
        //                              Comments display
        // +-----------------------------------------------------------------------+
        $list = array();

        $query = 'SELECT 
                        com.id, 
                        com.category_id, 
                        com.date, 
                        com.author,
                        '.$conf['user_fields']['username'].' AS username, 
                        com.content, 
                        cat.name
                FROM '.COA_TABLE.' AS com
                INNER JOIN '.CATEGORIES_TABLE.' AS cat
                ON cat.id = com.category_id
                LEFT JOIN '.USERS_TABLE.' AS u
                ON u.'.$conf['user_fields']['id'].' = com.author_id
                WHERE validated = \'false\'
                ORDER BY com.date DESC
        ;';
        $result = pwg_query($query);

        while ($row = pwg_db_fetch_assoc($result)) {
                // author
                if (empty($row['author_id'])) {
                        $author_name = $row['author'];
                } else {
                        $author_name = stripslashes($row['username']);
                }
                
                // comment content
                $template->append('comments', array(
                        'CAT_URL' => PHPWG_ROOT_PATH.'admin.php?page=cat_modify&amp;cat_id='.$row['category_id'],
                        'CAT_NAME' => $row['name'],
                        'ID' => $row['id'],
                        'AUTHOR' => trigger_event('render_comment_author', $author_name),
                        'DATE' => format_date($row['date'], true),
                        'CONTENT' => trigger_event('render_comment_content',$row['content']),
                ));

                array_push($list, $row['id']);
        }

        // template
        $template->set_filename('comments', dirname(__FILE__) .'/../template/coa_admin_comments.tpl');
        $template->assign(array(
                'F_ACTION' => get_root_url().'admin.php?page=comments&amp;section=albums',
                'LIST' => implode(',', $list),
        ));
        $template->assign_var_from_handle('ADMIN_CONTENT', 'comments');
}

?>