Пример #1
0
} elseif ($_SESSION[SCRIPT_NAME]['c']) {
    $c = $_SESSION[SCRIPT_NAME]['c'];
}
if ($c) {
    $where = " WHERE CATEGORY_ID = " . $db->qstr($c);
    $tpl->assign('CATEGORY_ID', $c);
} else {
    $tpl->assign('CATEGORY_ID', 0);
    if (isset($where)) {
        $where .= ' AND ' . ($_REQUEST['f'] == '1' ? '' : 'NOT') . $featured_where;
    } else {
        $where = 'WHERE ' . ($_REQUEST['f'] == '1' ? '' : 'NOT') . $featured_where;
    }
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    do_bulk_link_actions($c);
}
$categs = get_categs_tree($db, 0);
$tpl->assign('categs', $categs);
$tpl->assign('featured', $_REQUEST['f'] == '1');
$tpl->assign('ENABLE_REWRITE', ENABLE_REWRITE);
$tpl->assign('stats', array(0 => _L('Inactive'), 1 => _L('Pending'), 2 => _L('Active')));
$tpl->assign('valid', array(0 => _L('Broken'), 1 => _L('Unknown'), 2 => _L('Ok')));
$columns = array('TITLE' => _L('Title'), 'PAGERANK' => _L('PR'), 'URL' => _L('URL'));
if (PAY_ENABLE) {
    $columns = array_merge($columns, array('LINK_TYPE' => _L('Type')));
    $tpl->assign('link_type_str', $link_type_str);
}
$columns = array_merge($columns, array('CATEGORY' => _L('Category'), 'STATUS' => _L('Status'), 'HITS' => _L('Hits'), 'DATE_ADDED' => _L('Date Added')));
$tpl->assign('columns', $columns);
$tpl->assign('col_count', count($columns) + 3);
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
# **********************************************************************
#
# For questions, help, comments, discussion, etc., please join the
# PHP Link Directory Forum http://www.phplinkdirectory.com/forum/
#
# @link           http://www.phplinkdirectory.com/
# @copyright      2004-2006 NetCreated, Inc. (http://www.netcreated.com/)
#                 Portions copyright 2013 Bruce Clement (http://www.clement.co.nz/)
# @projectManager David DuVal <*****@*****.**>
# @package        PHPLinkDirectory
# ######################################################################
*/
require_once 'init.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    do_bulk_link_actions('0');
}
$tpl->assign('ENABLE_REWRITE', ENABLE_REWRITE);
$tpl->assign('stats', array(0 => _L('Inactive'), 1 => _L('Pending'), 2 => _L('Active')));
$tpl->assign('columns', array('TITLE' => _L('Title'), 'URL' => _L('URL'), 'DESCRIPTION' => _L('Description'), 'CATEGORY' => _L('Category'), 'RECPR_URL' => _L('Recpr. Link URL'), 'DATE_ADDED' => _L('Date Added'), 'EXTRA' => _L('Extra')));
$tpl->assign('extra_fields', array('URL1' => _L('URL 1'), 'TITLE1' => _L('Title 1'), 'DESCRIPTION1' => _L('Description 1'), 'URL2' => _L('URL 2'), 'TITLE2' => _L('Title 2'), 'DESCRIPTION2' => _L('Description 2'), 'URL3' => _L('URL 3'), 'TITLE3' => _L('Title 3'), 'DESCRIPTION3' => _L('Description 3'), 'URL4' => _L('URL 4'), 'TITLE4' => _L('Title 4'), 'DESCRIPTION4' => _L('Description 4'), 'URL5' => _L('URL 5'), 'TITLE5' => _L('Title 5'), 'DESCRIPTION5' => _L('Description 5')));
if (defined('SORT_FIELD') && SORT_FIELD != '') {
    $orderBy = ' ORDER BY ' . (SORT_FIELD == 'CATEGORY' ? 'C.TITLE' : 'L.' . SORT_FIELD) . ' ' . SORT_ORDER;
}
if ($_SESSION['is_admin']) {
    $list_total = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `STATUS` = '1'");
    $page = get_page($list_total);
    $tpl->assign('list_limit', LINKS_PER_PAGE);
    $tpl->assign('list_total', $list_total);
    $rs = $db->SelectLimit("SELECT L.*, " . $db->IfNull('C.TITLE', "'Top'") . " AS `CATEGORY` FROM `{$tables['link']['name']}` AS `L` LEFT OUTER JOIN `{$tables['category']['name']}` AS `C` ON L.CATEGORY_ID = C.ID WHERE L.STATUS = '1' {$orderBy}", LINKS_PER_PAGE, LINKS_PER_PAGE * ($page - 1));
    $list = $rs->GetAssoc(true);