# @package PHPLinkDirectory # @version 3.2.0 # ################################################################################ */ require_once 'init.php'; //Determine link ID if (ENABLE_REWRITE == 1) { preg_match ('#(.*)link(_|-)(\d+)\.htm[l]?$#i', request_uri(), $matches); $id = (!empty ($matches[3]) ? intval ($matches[3]) : 0); } else { $id = (!empty ($_REQUEST['id']) ? $_REQUEST['id'] : 0); } if (!empty ($id)) { if (!preg_match ('`^[\d]+$`', $id)) { $tpl->assign('error', "Invalid Link ID"); } else { $rdata = $db->GetRow("SELECT *, DATE_FORMAT(DATE_ADDED, '%M %d, %Y %r') AS `DAT` FROM `{$tables['link']['name']}` WHERE `ID` = ".$db->qstr($id)); $data = array (); if (!$rdata) $tpl->assign('error', "Invalid ID [{$id}] passed - not found in database"); else { $data['ID'] = $id; $data['TITLE'] = $rdata['TITLE']; $data['DESCRIPTION'] = $rdata['DESCRIPTION']; $data['URL'] = $rdata['URL']; $data['RECPR_URL'] = $rdata['RECPR_URL']; $data['CATEGORY_ID'] = $rdata['CATEGORY_ID']; $data['OWNER_NAME'] = $rdata['OWNER_NAME']; $data['DATE_ADDED'] = $rdata['DAT']; $data['HITS'] = $rdata['HITS']; $data['PAGERANK'] = $rdata['PAGERANK']; $data['RATE_COUNT'] = $rdata['RATE_COUNT']; $data['RATE'] = $rdata['RATE']; $data['RATE_ENABLED'] = $rdata['RATE_ENABLED']; $cdata = $db->GetRow("SELECT `TITLE` AS `CATEGORY_TITLE`, `CACHE_TITLE`, `CACHE_URL` FROM `{$tables['category']['name']}` WHERE `ID` = '{$rdata['CATEGORY_ID']}' LIMIT 1"); $data['CATEGORY_TITLE'] = $cdata['CATEGORY_TITLE']; $data['CACHE_TITLE'] = $cdata['CACHE_TITLE']; $site_url = (substr (SITE_URL, -1) != '/' ? SITE_URL.'/' : SITE_URL); $data['CATEGORY_URL'] = $site_url; $data['CATEGORY_URL'] .= (ENABLE_REWRITE == 1 ? trim ($cdata['CACHE_URL']) : 'index.php?c='.$data['CATEGORY_ID']); $data['META_KEYWORDS'] = $rdata['META_KEYWORDS']; $data['META_DESCRIPTION'] = $rdata['META_DESCRIPTION']; unset ($cdata, $site_url); $odata = $db->GetAll("SELECT * FROM `{$tables['link']['name']}` WHERE `OWNER_EMAIL` LIKE ".$db->qstr($rdata['OWNER_EMAIL'])." LIMIT 0 , 30"); usort ($odata, "cmp"); $data['RELATED'] = ""; foreach ($odata as $value) if ($value['ID'] !== $id) { if (preg_match ("/\/$/", SITE_URL)) $link = SITE_URL."details.php?id=".$value['ID']; else $link = SITE_URL."/details.php?id=" . $value['ID']; $data['RELATED'] .= "