/**
*Retorna um registro da tabela directories definido pelo campo directory_id
*
*@param Links
*/
function getInHomeLinks($link)
{
$strsql = "SELECT * FROM user_links WHERE user_id = " . $link->getUser_id() . " and in_home=1 order by rate desc";
$result = $this->_db->databaseQuery($strsql);
$linkList = array();
for ($i = 0; $i < count($result); $i++) {
$link = new Links();
$link->setLink_id($result[$i]['link_id']);
$link->setUser_id($result[$i]['user_id']);
$link->setName($result[$i]['name']);
$link->setUrl($result[$i]['url']);
$link->setDescription($result[$i]['description']);
$link->setInHome($result[$i]['in_home']);
$link->setRate($result[$i]['rate']);
array_push($linkList, $link);
}
return $linkList;
}
<h3>
<span>
<?php
echo MY_LINKS;
?>
<?php
echo $params["sort"] == "rate" ? SHOW_BY_RATE : SHOW_BY_DATE;
?>
</span>
</h3>
<div class="articleList">
<div class="topicFolder">
<?
//echo "DIRECTORY_ID ".$_COOKIE['directory_id'];
$link = new Links();
$link->setUser_id($_COOKIE['userID']);
$total = $link->getTotalPages();
$page = $_GET['page']?$_GET['page']:0;
if($page < 0)
$page = 0;
if (($total) && ($page > $total -1)){
$page = $total - 1;
}
if($total > 1)
{
echo '<div class="pagination">';
if($page != 0){
echo '<a href="?page=0">'.FIRST_PAGE.'</a> ';
}else{
echo '<b>'.FIRST_PAGE.'</b> ';
}
