} 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);