[Summary view] [Print] [Text view]

   1  <?php
   2  // $Id: favorites.php,v 1.7 2006/01/04 00:01:53 glen Exp $
   3  // Copyright (c)2005, Glen Campbell. All rights reserved.
   4  
   5  require_once  'siteframe.inc';
   6  
   7  // check for ID
   8  $u = new User($_GET['id']);
   9  if (!$_GET['id'])
  10  {
  11      if (is_object($_SESSION['user']) && $_SESSION['user']->id())
  12          $u = $_SESSION['user'];
  13      else
  14      {
  15          $PAGE->assign('page_title', "Error");
  16          $PAGE->assign('error', lang('err_noid'));
  17          $PAGE->display();
  18          exit;
  19      }
  20  }
  21  $PAGE->assign('page_title', sprintf(lang('page_title_friends'), $u->get_title()));
  22  $PAGE->assign('user', $u->get_all());
  23  
  24  // get list of favorite users
  25  $f = new Favorite;
  26  $f->set('user_id', $u->id());
  27  $q = sprintf(
  28      "SELECT fav_user_id FROM %s friends LEFT JOIN %s users ".
  29      "ON (friends.fav_user_id=users.user_id) ".
  30      "WHERE friends.user_id=%d ".
  31      "ORDER BY user_name",
  32      $f->table_name(),
  33      $u->table_name(),
  34      $u->id());
  35  $myquery = new Query('User', $q);
  36  
  37  $arr = array();     // output values
  38  while($row = $myquery->get_all())
  39  {
  40      $arr[] = $row;
  41  }
  42  $PAGE->assign('users', $arr);
  43  
  44  // get recent activity by favorite users
  45  $p = new Page;
  46  $q = sprintf(
  47      "SELECT * FROM %s WHERE page_user_id IN
  48          (SELECT fav_user_id FROM %s WHERE user_id=%d)
  49      ORDER BY page_id DESC
  50      LIMIT %d",
  51      $p->table_name(),
  52      $f->table_name(),
  53      $u->id(),
  54      config('recent_items', 20)
  55  );
  56  $myquery = new Query('Page', $q);
  57  $arr = array();
  58  while ($row = $myquery->get_all())
  59      $arr[] = $row;
  60  $PAGE->assign('item_template', $TEMPLATES['index_item']);
  61  $PAGE->assign('fav_recent', $arr);
  62  $PAGE->assign('rss_url', $f->get_rss_url());
  63  $PAGE->display();
  64  ?>