ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 784


Ignore:
Timestamp:
Nov 19, 2006, 11:29:12 PM (14 years ago)
Author:
takanashi
Message:

マイフレ数ランキングの1位をOpenPNE君でないものに

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/webapp/lib/db/ranking.php

    r546 r784  
    2323{
    2424    $sql = 'SELECT c_member_id_to as c_member_id, count(*) as count' .
    25         ' FROM c_friend' .
    26         ' GROUP BY c_member_id_to' .
     25        ' FROM c_friend';
     26    if (!IS_CLOSED_SNS) {
     27      $sql .= ' WHERE c_member_id_to != 1';
     28    }
     29    $sql .= ' GROUP BY c_member_id_to' .
    2730        ' ORDER BY count DESC';
    2831    return db_get_all_limit($sql, 0, $limit);
Note: See TracChangeset for help on using the changeset viewer.