[ Index ]
 

Code source de e107 0.7.8

Accédez au Source d'autres logiciels libresSoutenez Angelica Josefina !

title

Body

[fermer]

/e107_plugins/links_page/ -> links.php (source)

   1  <?php
   2  /*
   3  + ----------------------------------------------------------------------------+
   4  |     e107 website system
   5  |
   6  |     ©Steve Dunstan 2001-2002
   7  |     http://e107.org
   8  |     jalist@e107.org
   9  |
  10  |     Released under the terms and conditions of the
  11  |     GNU General Public License (http://gnu.org).
  12  |
  13  |     $Source: /cvsroot/e107/e107_0.7/e107_plugins/links_page/links.php,v $
  14  |     $Revision: 1.44 $
  15  |     $Date: 2006/12/31 15:06:59 $
  16  |     $Author: e107coders $
  17  +----------------------------------------------------------------------------+
  18  */
  19  require_once ('../../class2.php');
  20  
  21  require_once(e_HANDLER."rate_class.php");
  22  $rater = new rater;
  23  require_once(e_PLUGIN.'links_page/link_shortcodes.php');
  24  require_once(e_PLUGIN.'links_page/link_defines.php');
  25  require_once(e_HANDLER."userclass_class.php");
  26  e107_require_once(e_HANDLER.'arraystorage_class.php');
  27  $eArrayStorage = new ArrayData();
  28  require_once(e_HANDLER."form_handler.php");
  29  $rs = new form;
  30  require_once(e_HANDLER."file_class.php");
  31  $fl = new e_file;
  32  require_once(e_HANDLER."comment_class.php");
  33  $cobj = new comment;
  34  require_once(e_PLUGIN.'links_page/link_class.php');
  35  $lc = new linkclass();
  36  global $tp;
  37  
  38  $linkspage_pref = $lc -> getLinksPagePref();
  39  
  40  $deltest = array_flip($_POST);
  41  
  42  if(e_QUERY){
  43      $qs = explode(".", e_QUERY);
  44  
  45      if(is_numeric($qs[0])){
  46          $from = array_shift($qs);
  47      }else{
  48          $from = "0";
  49      }
  50  }
  51  if (file_exists(e_PLUGIN."links_page/languages/".e_LANGUAGE.".php")) {
  52      include_once(e_PLUGIN."links_page/languages/".e_LANGUAGE.".php");
  53      } else {
  54      include_once(e_PLUGIN."links_page/languages/English.php");
  55  }
  56  $lc -> setPageTitle();
  57  
  58  //submit comment
  59  if (isset($_POST['commentsubmit'])) {
  60      if (!$sql->db_Select("links_page", "link_id", "link_id = '".intval($qs[1])."' ")) {
  61          header("location:".e_BASE."index.php");
  62          exit;
  63      } else {
  64          $row = $sql->db_Fetch();
  65          if ($row[0] && (ANON === TRUE || USER === TRUE)) {
  66  
  67              $cobj->enter_comment($_POST['author_name'], $_POST['comment'], "links_page", $qs[1], $pid, $_POST['subject']);
  68              $e107cache->clear("comment.links_page.{$qs[1]}");
  69          }
  70      }
  71  }
  72  
  73  //update refer
  74  if (isset($qs[0]) && $qs[0] == "view" && isset($qs[1]) && is_numeric($qs[1]))
  75  {
  76      if($sql->db_Select("links_page", "*", "link_id='".intval($qs[1])."' AND link_class REGEXP '".e_CLASS_REGEXP."' "))
  77      {
  78          $row = $sql->db_Fetch();
  79          $sql->db_Update("links_page", "link_refer=link_refer+1 WHERE link_id='".intval($qs[1])."' ");
  80          //header("location:".$row['link_url']); exit;
  81          js_location($row['link_url']);
  82      }
  83  }
  84  
  85  require_once(HEADERF);
  86  
  87  
  88  if (is_readable(THEME."links_template.php")) {
  89      require_once (THEME."links_template.php");
  90      } else {
  91      require_once(e_PLUGIN."links_page/links_template.php");
  92  }
  93  
  94  //submit / manage link
  95  if (isset($_POST['add_link'])) {
  96      if($qs[0] == "submit"){
  97          if(check_class($linkspage_pref['link_submit_class'])){
  98              if(isset($linkspage_pref['link_submit_directpost']) && $linkspage_pref['link_submit_directpost']){
  99                  $lc -> dbLinkCreate();
 100              }else{
 101                  $lc -> dbLinkCreate("submit");
 102              }
 103          }else{
 104              js_location(e_SELF);
 105          }
 106      }
 107      if($qs[0] == "manage"){
 108          if(check_class($linkspage_pref['link_manager_class'])){
 109              if(isset($linkspage_pref['link_directpost']) && $linkspage_pref['link_directpost']){
 110                  $lc -> dbLinkCreate();
 111              }else{
 112                  $lc -> dbLinkCreate("submit");
 113              }
 114          }else{
 115              js_location(e_SELF);
 116          }
 117      }
 118  }
 119  //message submitted link
 120  if(isset($qs[0]) && $qs[0] == "s"){
 121      $lc->show_message(LAN_LINKS_29, LAN_LINKS_28);
 122  }
 123  $qsorder = FALSE;
 124  if(isset($qs[0]) && substr($qs[0],0,5) == "order"){
 125      $qsorder = TRUE;
 126  }
 127  //show all categories
 128  if((!isset($qs[0]) || $qsorder) && $linkspage_pref['link_page_categories']){
 129        echo displayNavigator('cat');
 130      displayCategory();
 131  }
 132  //show all categories
 133  if(isset($qs[0]) && $qs[0] == "cat" && !isset($qs[1]) ){
 134     echo displayNavigator('cat');
 135      displayCategory();
 136  }
 137  //show all links in all categories
 138  if( ((!isset($qs[0]) || $qsorder) && !$linkspage_pref['link_page_categories']) || (isset($qs[0]) && $qs[0] == "all") ){
 139    //    displayNavigator('');
 140      displayCategoryLinks();
 141  }
 142  //show all links in one categories
 143  if(isset($qs[0]) && $qs[0] == "cat" && isset($qs[1]) && is_numeric($qs[1])){
 144      echo displayNavigator('');
 145      displayCategoryLinks($qs[1]);
 146  }
 147  //view top rated
 148  if(isset($qs[0]) && $qs[0] == "rated"){
 149      echo displayNavigator('');
 150      displayTopRated();
 151  }
 152  //view top refer
 153  if(isset($qs[0]) && $qs[0] == "top"){
 154      echo displayNavigator('');
 155      displayTopRefer();
 156  }
 157  //personal link managers
 158  if (isset($qs[0]) && $qs[0] == "manage"){
 159      echo displayNavigator('');
 160      displayPersonalManager();
 161  }
 162  //comments on links
 163  if (isset($qs[0]) && $qs[0] == "comment" && isset($qs[1]) && is_numeric($qs[1]) ){
 164      echo displayNavigator('');
 165      displayLinkComment();
 166  }
 167  //submit link
 168  if (isset($qs[0]) && $qs[0] == "submit")
 169  {
 170    if (check_class($linkspage_pref['link_submit_class'])) 
 171    {
 172      echo displayNavigator('');
 173      displayLinkSubmit();
 174    }
 175    else
 176    {
 177      $lc->show_message(LAN_LINKS_50);
 178    }
 179  }
 180  
 181  
 182  function displayTopRated(){
 183      global $qs, $sql, $lc, $tp, $rowl, $link_shortcodes, $from, $ns, $linkspage_pref;
 184      global $LINK_RATED_TABLE_START, $LINK_RATED_TABLE, $LINK_RATED_TABLE_END, $LINK_RATED_RATING, $LINK_RATED_APPEND;
 185  
 186      $number        = (isset($linkspage_pref["link_nextprev_number"]) && $linkspage_pref["link_nextprev_number"] ? $linkspage_pref["link_nextprev_number"] : "20");
 187      $np            = ($linkspage_pref["link_nextprev"] ? "LIMIT ".intval($from).",".intval($number) : "");
 188      $catrate    = (isset($qs[1]) && is_numeric($qs[1]) ? " AND l.link_category='".$qs[1]."' " : "");
 189      $ratemin    = (isset($linkspage_pref['link_rating_minimum']) && $linkspage_pref['link_rating_minimum'] ? $linkspage_pref['link_rating_minimum'] : "0");
 190      $qry = "
 191      SELECT l.*, r.*, lc.link_category_id, lc.link_category_name, (r.rate_rating / r.rate_votes) as rate_avg
 192      FROM #rate AS r
 193      LEFT JOIN #links_page AS l ON l.link_id = r.rate_itemid
 194      LEFT JOIN #links_page_cat AS lc ON lc.link_category_id = l.link_category
 195      WHERE l.link_class REGEXP '".e_CLASS_REGEXP."' ".$catrate." AND lc.link_category_class REGEXP '".e_CLASS_REGEXP."' AND r.rate_table='links_page'
 196      ORDER BY rate_avg DESC
 197      ";
 198      $qry2 = $qry." ".$np;
 199  
 200      if(!is_object($sql)){ $sql = new db; }
 201      $linktotalrated = $sql -> db_Select_gen($qry);
 202      if (!$ratedlinks = $sql->db_Select_gen($qry2)){
 203          $lc -> show_message(LAN_LINKS_33, LAN_LINKS_11);
 204      }else{
 205          $link_rated_table_string = "";
 206          $list = $sql -> db_getList();
 207            foreach($list as $rowl) {
 208              if( ($rowl['rate_avg'] > $ratemin) ){
 209              $cat = $rowl['link_category_name'];
 210              $LINK_RATED_APPEND            = $lc -> parse_link_append($rowl);
 211              $LINK_RATED_RATING            = $tp -> parseTemplate('{LINK_RATED_RATING}', FALSE, $link_shortcodes);
 212              $link_rated_table_string    .= $tp -> parseTemplate($LINK_RATED_TABLE, FALSE, $link_shortcodes);
 213              }
 214          }
 215          $link_rated_table_start = $tp -> parseTemplate($LINK_RATED_TABLE_START, FALSE, $link_shortcodes);
 216          $link_rated_table_end = $tp -> parseTemplate($LINK_RATED_TABLE_END, FALSE, $link_shortcodes);
 217  
 218          if(isset($qs[1])){
 219              $captioncat = " : ".LAN_LINKS_40." : ".$cat;
 220          }
 221          $caption = LAN_LINKS_11." ".(isset($captioncat) ? $captioncat : "");
 222          $text = $link_rated_table_start.$link_rated_table_string.$link_rated_table_end;
 223  
 224          $ns->tablerender($caption, $text);
 225          $lc->ShowNextPrev($from, $number, $linktotalrated);
 226      }
 227  }
 228  
 229  function displayTopRefer(){
 230      global $qs, $sql2, $lc, $link_shortcodes, $cobj, $rowl, $from, $tp, $ns, $linkspage_pref;
 231      global $LINK_TABLE_START, $LINK_TABLE, $LINK_TABLE_END, $LINK_APPEND;
 232  
 233      $number    = ($linkspage_pref["link_nextprev_number"] ? $linkspage_pref["link_nextprev_number"] : "20");
 234      $np        = ($linkspage_pref["link_nextprev"] ? "LIMIT ".intval($from).",".intval($number) : "");
 235      $min    = (isset($linkspage_pref['link_refer_minimum']) && $linkspage_pref['link_refer_minimum'] ? " AND l.link_refer > ".$linkspage_pref['link_refer_minimum'] : "");
 236  
 237      $qry = "
 238      SELECT l.*, lc.*, COUNT(c.comment_id) AS link_comment
 239      FROM #links_page AS l
 240      LEFT JOIN #links_page_cat AS lc ON lc.link_category_id = l.link_category
 241      LEFT JOIN #comments as c ON c.comment_item_id=l.link_id AND comment_type='links_page'
 242      WHERE l.link_class REGEXP '".e_CLASS_REGEXP."' ".$min."
 243      GROUP BY l.link_id
 244      ORDER BY l.link_refer DESC
 245      ";
 246      $qry2 = $qry." ".$np;
 247  
 248      if(!is_object($sql2)){ $sql2 = new db; }
 249      $link_total = $sql2 -> db_Select_gen($qry);
 250      if(!$sql2 -> db_Select_gen($qry2)){
 251          $lc -> show_message(LAN_LINKS_42, LAN_LINKS_10);
 252      }else{
 253          $link_top_table_string = "";
 254          $list = $sql2 -> db_getList();
 255            foreach($list as $rowl) {
 256              $category                = $rowl['link_category_id'];
 257              $LINK_APPEND            = $lc -> parse_link_append($rowl);
 258              $link_top_table_string .= $tp -> parseTemplate($LINK_TABLE, FALSE, $link_shortcodes);
 259          }
 260          $link_top_table_start        = $tp -> parseTemplate($LINK_TABLE_START, FALSE, $link_shortcodes);
 261          $link_top_table_end            = $tp -> parseTemplate($LINK_TABLE_END, FALSE, $link_shortcodes);
 262  
 263          $text = $link_top_table_start.$link_top_table_string.$link_top_table_end;
 264          $caption = LAN_LINKS_10;
 265          $ns->tablerender($caption, $text);
 266          $lc->ShowNextPrev($from, $number, $link_total);
 267      }
 268  }
 269  
 270  function displayPersonalManager(){
 271      global $qs, $sql, $sql2, $lc, $link_shortcodes, $cobj, $row, $from, $tp, $ns, $linkspage_pref;
 272      global $LINK_TABLE_MANAGE_START, $LINK_TABLE_MANAGE, $LINK_TABLE_MANAGE_END;
 273  
 274      if(!(isset($linkspage_pref['link_manager']) && $linkspage_pref['link_manager'])){
 275          js_location(e_SELF);
 276      }
 277      //delete link
 278      if(isset($linkspage_pref['link_directdelete']) && $linkspage_pref['link_directdelete']){
 279          if(isset($_POST['delete'])){
 280              $tmp = array_pop(array_flip($_POST['delete']));
 281              list($delete, $del_id) = explode("_", $tmp);
 282          }
 283          if (isset($delete) && $delete == 'main') {
 284              $sql->db_Select("links_page", "link_order", "link_id='".intval($del_id)."'");
 285              $row = $sql->db_Fetch();
 286              if (!is_object($sql2)){ $sql2 = new db; }
 287              $sql->db_Select("links_page", "link_id", "link_order>'".$row['link_order']."' && link_category='".intval($id)."'");
 288              while ($row = $sql->db_Fetch()) {
 289                  $sql2->db_Update("links_page", "link_order=link_order-1 WHERE link_id='".$row['link_id']."'");
 290              }
 291              if ($sql->db_Delete("links_page", "link_id='".intval($del_id)."'")) {
 292                  $lc->show_message(LCLAN_ADMIN_10." #".$del_id." ".LCLAN_ADMIN_11);
 293              }
 294          }
 295      }
 296      //upload link icon
 297      if(isset($_POST['uploadlinkicon'])){
 298          $lc -> uploadLinkIcon();
 299      }
 300  
 301      //show existing links
 302      if(!(check_class($linkspage_pref['link_manager_class']))){
 303          js_location(e_SELF);
 304      }else{
 305          $qry = "
 306          SELECT l.*, lc.*
 307          FROM #links_page AS l
 308          LEFT JOIN #links_page_cat AS lc ON lc.link_category_id = l.link_category
 309          WHERE l.link_author = '".USERID."'
 310          ORDER BY l.link_name
 311          ";
 312          $link_table_manage = "";
 313          if(!$manager_total = $sql -> db_Select_gen($qry)){
 314              $text = LAN_LINKS_MANAGER_4;
 315          }else{
 316              $link_table_manage_start    = $tp -> parseTemplate($LINK_TABLE_MANAGE_START, FALSE, $link_shortcodes);
 317              while($row = $sql -> db_Fetch()){
 318                  $link_table_manage .= $tp -> parseTemplate($LINK_TABLE_MANAGE, FALSE, $link_shortcodes);
 319              }
 320              $link_table_manage_end        = $tp -> parseTemplate($LINK_TABLE_MANAGE_END, FALSE, $link_shortcodes);
 321              $text = $link_table_manage_start.$link_table_manage.$link_table_manage_end;
 322          }
 323          $ns->tablerender(LAN_LINKS_35, $text);
 324  
 325          //show link create
 326          $lc->show_link_create();
 327      }
 328      return;
 329  }
 330  
 331  //comments on links
 332  function displayLinkComment(){
 333      global $qs, $cobj, $tp, $sql, $linkbutton_count, $lc, $rowl, $link_shortcodes, $ns, $linkspage_pref, $LINK_TABLE_START, $LINK_TABLE, $LINK_TABLE_END, $LINK_APPEND;
 334      if(!(isset($linkspage_pref["link_comment"]) && $linkspage_pref["link_comment"])){
 335          js_location(e_SELF);
 336      }else{
 337          $qry = "
 338          SELECT l.*, lc.*
 339          FROM #links_page AS l
 340          LEFT JOIN #links_page_cat AS lc ON lc.link_category_id = l.link_category
 341          WHERE l.link_id = '".intval($qs[1])."' AND lc.link_category_class REGEXP '".e_CLASS_REGEXP."' AND l.link_class REGEXP '".e_CLASS_REGEXP."'
 342          ";
 343          $link_comment_table_string = "";
 344          if(!$linkcomment = $sql -> db_Select_gen($qry)){
 345              js_location(e_SELF);
 346          }else{
 347              $rowl = $sql->db_Fetch();
 348              $linkbutton_count   = ($rowl['link_button']) ?  $linkbutton_count + 1 : $linkbutton_count;
 349              $LINK_APPEND    = $lc -> parse_link_append($rowl);
 350              $subject        = $rowl['link_name'];
 351              $text = $tp -> parseTemplate($LINK_TABLE_START, FALSE, $link_shortcodes);
 352              $text .= $tp -> parseTemplate($LINK_TABLE, FALSE, $link_shortcodes);
 353              $text .= $tp -> parseTemplate($LINK_TABLE_END, FALSE, $link_shortcodes);
 354              $ns->tablerender(LAN_LINKS_36, $text);
 355  
 356              $cobj->compose_comment("links_page", "comment", $qs[1], $width, $subject, $showrate=FALSE);
 357          }
 358      }
 359      return;
 360  }
 361  
 362  function displayLinkSubmit(){
 363      global $qs, $sql, $tp, $rs, $ns, $linkspage_pref, $link_shortcodes, $LINK_SUBMIT_TABLE, $LINK_SUBMIT_CAT;
 364      if ($link_cats = $sql->db_Select("links_page_cat", "*", " link_category_class REGEXP '".e_CLASS_REGEXP."' ")) {
 365          $LINK_SUBMIT_CAT = $rs -> form_select_open("cat_id");
 366          while (list($cat_id, $cat_name, $cat_description) = $sql->db_Fetch()) {
 367              $LINK_SUBMIT_CAT .= $rs -> form_option($cat_name, "0", $cat_id);
 368          }
 369          $LINK_SUBMIT_CAT .= $rs -> form_select_close();
 370      }
 371      $text = $tp -> parseTemplate($LINK_SUBMIT_TABLE, FALSE, $link_shortcodes);
 372  
 373      $ns->tablerender(LAN_LINKS_31, $text);
 374      return;
 375  }
 376  
 377  function displayCategory(){
 378      global $sql, $sql2, $ns, $lc, $tp, $qs, $rowl, $link_shortcodes, $linkspage_pref, $total_links, $category_total, $alllinks;
 379      global $LINK_MAIN_TABLE_END_ALL, $LINK_MAIN_TABLE, $LINK_MAIN_TABLE_START;
 380  
 381      $order = $lc -> getOrder('cat');
 382  
 383      $qry = "
 384      SELECT lc.*
 385      FROM #links_page_cat AS lc
 386      WHERE lc.link_category_class REGEXP '".e_CLASS_REGEXP."'
 387      ".$order."
 388      ";
 389  
 390      if(!is_object($sql)){ $sql = new db; }
 391      if(!is_object($sql2)){ $sql2 = new db; }
 392      if (!$category_total = $sql->db_Select_gen($qry)){
 393          $lc -> show_message(LAN_LINKS_41, LAN_LINKS_30);
 394      }else{
 395          $link_main_table_string = "";
 396          $list = $sql->db_getList();
 397          foreach($list as $rowl) {
 398              $rowl['total_links'] = $sql2 -> db_Count("links_page", "(*)", "WHERE link_category = '".$rowl['link_category_id']."' AND link_class REGEXP '".e_CLASS_REGEXP."' ");
 399              if((!isset($linkspage_pref['link_cat_empty']) || $linkspage_pref['link_cat_empty'] == 0 && $rowl['total_links'] > "0") || (isset($linkspage_pref['link_cat_empty']) && $linkspage_pref['link_cat_empty'])){
 400                  $alllinks = $alllinks + $rowl['total_links'];
 401                  $link_main_table_string .= $tp -> parseTemplate($LINK_MAIN_TABLE, FALSE, $link_shortcodes);
 402              }
 403          }
 404          $link_main_table_start = $tp -> parseTemplate($LINK_MAIN_TABLE_START, FALSE, $link_shortcodes);
 405          $link_main_table_end = $tp -> parseTemplate($LINK_MAIN_TABLE_END_ALL, FALSE, $link_shortcodes);
 406          $text = $link_main_table_start.$link_main_table_string.$link_main_table_end;
 407  
 408          $caption = LAN_LINKS_30;
 409          $ns->tablerender($caption, $text);
 410      }
 411      return;
 412  }
 413  
 414  function displayNavigator($mode=''){
 415      global $sql2, $ns, $lc, $tp, $cobj, $rowl, $qs, $linkspage_pref, $from, $link_shortcodes;
 416      global $LINK_NAVIGATOR_TABLE, $LINK_SORTORDER, $LINK_NAVIGATOR, $LINK_NAVIGATOR_TABLE_PRE, $LINK_NAVIGATOR_TABLE_POST;
 417  
 418      if($mode == "cat"){
 419          if(isset($linkspage_pref['link_cat_sortorder']) && $linkspage_pref['link_cat_sortorder']){
 420              $LINK_SORTORDER = $lc->showLinkSort('cat');
 421          }
 422      }else{
 423          if(isset($linkspage_pref['link_sortorder']) && $linkspage_pref['link_sortorder']){
 424              $LINK_SORTORDER = $lc->showLinkSort();
 425          }
 426      }
 427      $nav    = $tp -> parseTemplate('{LINK_NAVIGATOR}', FALSE, $link_shortcodes);
 428      $so        = $tp -> parseTemplate('{LINK_SORTORDER}', FALSE, $link_shortcodes);
 429      $LINK_NAVIGATOR_TABLE_PRE = FALSE;
 430      $LINK_NAVIGATOR_TABLE_POST = FALSE;
 431      if ($nav!="" || $so!="" ) {
 432          $LINK_NAVIGATOR_TABLE_PRE = TRUE;
 433          $LINK_NAVIGATOR_TABLE_POST = TRUE;
 434      }
 435      $text = $tp -> parseTemplate($LINK_NAVIGATOR_TABLE, FALSE, $link_shortcodes);
 436      return $text;
 437  }
 438  
 439  function displayCategoryLinks($mode=''){
 440      global $sql2, $ns, $lc, $tp, $cobj, $rowl, $qs, $linkspage_pref, $from, $link_shortcodes, $link_category_total;
 441      global $LINK_TABLE_START,$linkbutton_count, $LINK_TABLE,$link_category_total, $LINK_TABLE_CAPTION, $LINK_TABLE_END, $LINK_APPEND;
 442  
 443      $order            = $lc -> getOrder();
 444      $number            = ($linkspage_pref["link_nextprev_number"] ? $linkspage_pref["link_nextprev_number"] : "20");
 445      $nextprevquery    = ($mode && $linkspage_pref["link_nextprev"] ? "LIMIT ".intval($from).",".intval($number) : "");
 446      $cat            = ($mode ? " AND l.link_category='".intval($mode)."' " : "");
 447      $qry            = "
 448      SELECT l.*, lc.*, COUNT(c.comment_id) AS link_comment
 449      FROM #links_page AS l
 450      LEFT JOIN #links_page_cat AS lc ON lc.link_category_id = l.link_category
 451      LEFT JOIN #comments as c ON c.comment_item_id=l.link_id AND comment_type='links_page'
 452      WHERE l.link_class REGEXP '".e_CLASS_REGEXP."' AND lc.link_category_class REGEXP '".e_CLASS_REGEXP."' ".$cat."
 453      GROUP BY l.link_id
 454      ".$order."
 455      ".$nextprevquery."
 456      ";
 457  
 458      $link_table_string = "";
 459      if(!is_object($sql2)){ $sql2 = new db; }
 460      $link_total = $sql2 -> db_Count("links_page as l", "(*)", "WHERE l.link_class REGEXP '".e_CLASS_REGEXP."' ".$cat." ");
 461      if (!$sql2->db_Select_gen($qry)){
 462          $lc -> show_message(LAN_LINKS_34, LAN_LINKS_39);
 463      }else{
 464          $linkbutton_count = 0;
 465          $list = $sql2 -> db_getList();
 466            foreach($list as $rowl) {
 467              $linkbutton_count   = ($rowl['link_button']) ?  $linkbutton_count + 1 : $linkbutton_count;
 468              if($mode){
 469                  $cat_name            = $rowl['link_category_name'];
 470                  $cat_desc            = $rowl['link_category_description'];
 471                  $LINK_APPEND        = $lc -> parse_link_append($rowl);
 472                  $link_table_string .= $tp -> parseTemplate($LINK_TABLE, FALSE, $link_shortcodes);
 473              }else{
 474                  $arr[$rowl['link_category_id']][] = $rowl;
 475              }
 476          }
 477          if($mode){
 478              $link_category_total    = $link_total;
 479              $link_table_start        = $tp -> parseTemplate($LINK_TABLE_START, FALSE, $link_shortcodes);
 480              $link_table_end            = $tp -> parseTemplate($LINK_TABLE_END, FALSE, $link_shortcodes);
 481              $text = $link_table_start.$link_table_string.$link_table_end;
 482              $caption = LAN_LINKS_32." ".$cat_name." ".($cat_desc ? " <i>[".$cat_desc."]</i>" : "");
 483              //number of links
 484              $caption .= " (<b title='".(ADMIN ? LAN_LINKS_2 : LAN_LINKS_1)."' >".$link_total."</b>".(ADMIN ? "/<b title='".(ADMIN ? LAN_LINKS_1 : "" )."' >".$link_total."</b>" : "").") ";
 485              $ns->tablerender($caption, $text);
 486  
 487              if(is_numeric($mode)){
 488                  $lc->ShowNextPrev($from, $number, $link_total);
 489              }
 490          }else{
 491              foreach($arr as $key => $value){
 492                  $link_table_string = "";
 493                  $linkbutton_count = 0;
 494                  $i=0;
 495                  for($i=0;$i<count($value);$i++){
 496                      $rowl                = $value[$i];
 497  
 498                      $linkbutton_count   = ($rowl['link_button']) ?  $linkbutton_count + 1 : $linkbutton_count;
 499                      $cat_name            = $rowl['link_category_name'];
 500                      $cat_desc            = $rowl['link_category_description'];
 501                       $LINK_APPEND        = $lc -> parse_link_append($rowl);
 502                      $link_table_string .= $tp -> parseTemplate($LINK_TABLE, FALSE, $link_shortcodes);
 503                  }
 504  
 505                  $link_category_total = count($value);
 506                  $link_table_caption     = $tp -> parseTemplate($LINK_TABLE_CAPTION, FALSE, $link_shortcodes);
 507                  $link_table_start        = $tp -> parseTemplate($LINK_TABLE_START, FALSE, $link_shortcodes);
 508                  $link_table_end            = $tp -> parseTemplate($LINK_TABLE_END, FALSE, $link_shortcodes);
 509                  $text .= $link_table_start.$link_table_string.$link_table_end;
 510  
 511              }
 512  
 513                  $ns->tablerender($link_table_caption, $text);
 514          }
 515      }
 516      return;
 517  }
 518  
 519  require_once(FOOTERF);
 520  
 521  
 522  
 523  
 524  ?>


Généré le : Sun Apr 1 01:23:32 2007 par Balluche grâce à PHPXref 0.7