/** *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> '; }