PHP Vote::user_list_all_votes方法代碼示例

 function get_current_user_votes($user)
 {
     require_once mnminclude . 'votes.php';
     $vote = new Vote();
     $vote->type = 'links';
     $vote->user = $user;
     $vote->link = $this->id;
     $results = $vote->user_list_all_votes();
     $votes = 0;
     $reports = 0;
     if (is_array($results)) {
         foreach ($results as $row) {
             if (isset($row->vote_value)) {
                 if ($row->vote_value > 0) {
                     $votes = $votes + 1;
                 }
                 if ($row->vote_value < 0) {
                     $reports = $reports + 1;
                 }
             }
         }
     }
     $this->current_user_votes = $votes;
     $this->current_user_reports = $reports;
 }

    }
    if ($ls_debug == true) {
        echo '<br />' . sanitize($rows, 3) . '<br />';
    }
    $links = $db->get_col($linksum_sql);
    $the_results = $links;
}
if ($the_results) {
    // find out if the logged in user voted / reported each of
    // the stories that the search found and cache the results
    require_once mnminclude . 'votes.php';
    $vote = new Vote();
    $vote->type = 'links';
    $vote->user = $current_user->user_id;
    $vote->link = $the_results;
    $results = $vote->user_list_all_votes();
    $vote = '';
    $results = '';
    // we don't actually need the results
    // we're just calling this to cache the results
    // so when we foreach the links we don't have to
    // run 1 extra query for each story to determine
    // current user votes
    // setup the link cache
    $sql = "SELECT " . table_links . ".* FROM " . table_links . " WHERE ";
    $sql_saved = "SELECT * FROM " . table_saved_links . " WHERE saved_user_id=" . $current_user->user_id . " AND ";
    $ids = array();
    foreach ($the_results as $link_id) {
        // first make sure we don't already have it cached
        if (!isset($cached_links[$link_id])) {
            $ids[] = $link_id;

 function get_current_user_votes($user)
 {
     require_once mnminclude . 'votes.php';
     $vote = new Vote();
     $vote->type = 'links';
     $vote->user = $user;
     $vote->link = $this->id;
     $results = $vote->user_list_all_votes();
     $votes = 0;
     $reports = 0;
     if (is_array($results)) {
         foreach ($results as $row) {
             if (isset($row->vote_value)) {
                 if ($row->vote_value > 0) {
                     $votes = $votes + 1;
                 }
                 if ($row->vote_value < 0) {
                     $reports = $reports + 1;
                 }
             }
         }
     }
     $this->current_user_votes = $votes;
     $this->current_user_reports = $reports;
     if (votes_per_ip > 0 && $user == 0) {
         $ac_vote_from_IP = $this->votes_from_ip();
         if ($ac_vote_from_IP <= 1) {
             $ac_vote_from_IP = 0;
         }
         $ac_report_from_IP = $this->reports_from_ip();
         if ($ac_report_from_IP <= 1) {
             $ac_report_from_IP = 0;
         }
         $this->vote_from_this_ip = $ac_vote_from_IP;
         $this->report_from_this_ip = $ac_report_from_IP;
     }
 }

 function show($fetch = false)
 {
     global $main_smarty, $db, $cached_links, $current_user;
     include_once mnminclude . 'search.php';
     $search = new Search();
     $search->orderBy = $this->orderBy;
     $search->pagesize = $this->pagesize;
     $search->filterToStatus = $this->filterToStatus;
     $search->filterToTimeFrame = $this->filterToTimeFrame;
     $search->category = $this->category;
     $search->doSearch();
     $linksum_sql = $search->sql;
     $link = new Link();
     $links = $db->get_col($linksum_sql);
     $the_results = $links;
     if ($the_results) {
         // find out if the logged in user voted / reported each of
         // the stories that the search found and cache the results
         require_once mnminclude . 'votes.php';
         $vote = new Vote();
         $vote->type = 'links';
         $vote->user = $current_user->user_id;
         $vote->link = $the_results;
         $results = $vote->user_list_all_votes();
         $vote = '';
         $results = '';
         // we don't actually need the results
         // we're just calling this to cache the results
         // so when we foreach the links we don't have to
         // run 1 extra query for each story to determine
         // current user votes
         // setup the link cache
         $i = 0;
         // if this query changes also change it in the read() function in /libs/link.php
         $sql = "SELECT " . table_links . ".* FROM " . table_links . " WHERE ";
         foreach ($the_results as $link_id) {
             // first make sure we don't already have it cached
             if (!isset($cached_links[$link_id])) {
                 if ($i > 0) {
                     $sql .= ' OR ';
                 }
                 $sql .= " link_id = {$link_id} ";
                 $i = $i + 1;
             }
         }
         // if $i = 0 then all the links are already cached
         // so don't touch the db
         // if $i > 0 then there is at least 1 link to get
         // so get the SQL and add results to the cache
         if ($i > 0) {
             $results = $db->get_results($sql);
             // add the results to the cache
             foreach ($results as $row) {
                 $cached_links[$row->link_id] = $row;
             }
         }
         // end link cache setup
     }
     $ssLinks = '';
     if ($links) {
         foreach ($links as $link_id) {
             $link->id = $link_id;
             $link->check_saved = false;
             $link->get_author_info = false;
             $link->check_friends = false;
             $link->read();
             if (is_numeric($this->TitleLengthLimit) && strlen($link->title) > $this->TitleLengthLimit) {
                 $link->title = utf8_substr($link->title, 0, $this->TitleLengthLimit) . '...';
             }
             $main_smarty = $link->fill_smarty($main_smarty);
             $ssLinks .= $main_smarty->fetch($this->template);
         }
     }
     if ($fetch == true) {
         return $ssLinks;
     } else {
         echo $ssLinks;
     }
 }