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

Changeset 1768


Ignore:
Timestamp:
Feb 6, 2007, 5:57:08 PM (13 years ago)
Author:
takanashi
Message:

f_homeで王冠が表示されないバグの対処及びdbライブラリの修正

Location:
OpenPNE/branches/debug/2_6_1/webapp
Files:
4 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/debug/2_6_1/webapp/lib/db/commu.php

    r1262 r1768  
    615615    $is_recurred = false;
    616616
    617     $sql = "SELECT c_commu.c_commu_id, c_commu.image_filename, c_commu.name" .
     617    $sql = "SELECT c_commu.c_commu_id, c_commu.image_filename, c_commu.name, c_commu.c_member_id_admin" .
    618618        " FROM c_commu ,c_commu_member " .
    619619        " WHERE c_commu_member.c_member_id = ?".
     
    624624
    625625    foreach ($lst as $key => $value) {
    626         $lst[$key]['count_commu_member'] = _db_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
     626        $lst[$key]['count_commu_members'] = db_commu_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
    627627    }
    628628    return $lst;
     
    893893
    894894/**
    895  * 参加コミュニティのリスト
     895 * 参加コミュニティのリスト(2.6.2以降は未使用)
    896896 *
    897897 * @param int $c_member_id
     
    911911    $is_recurred = false;
    912912
    913     $sql = "SELECT c.* FROM c_commu_member AS cm, c_commu AS c";
    914     $sql .= " WHERE cm.c_member_id=?";
    915     $sql .= " AND c.c_commu_id=cm.c_commu_id";
    916     $sql .= " ORDER BY RAND()";
     913    $sql = "SELECT c.* FROM c_commu_member AS cm, c_commu AS c" .
     914       " WHERE cm.c_member_id=?" .
     915       " AND c.c_commu_id=cm.c_commu_id" .
     916      " ORDER BY RAND()";
    917917    $params = array(intval($c_member_id));
    918918    $c_commu_list = db_get_all_limit($sql, 0, $limit, $params);
    919919
    920920    foreach ($c_commu_list as $key => $value) {
    921         $c_commu_list[$key]['count_commu_members'] =
    922             _db_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
     921        $c_commu_list[$key]['count_commu_members'] =  db_commu_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
    923922    }
    924923    return $c_commu_list;
     
    11961195    foreach ($c_commu_list as $key => $value) {
    11971196        $c_commu_list[$key]['count_members'] =
    1198             _db_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
     1197            db_commu_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
    11991198    }
    12001199
     
    13291328    foreach ($c_commu_list as $key => $value) {
    13301329        $c_commu_list[$key]['count_members'] =
    1331             _db_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
     1330            db_commu_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
    13321331    }
    13331332
     
    14321431    }
    14331432
    1434     $total_num = _db_count_c_commu_member_list4c_commu_id($c_commu_id);
     1433    $total_num = db_commu_count_c_commu_member_list4c_commu_id($c_commu_id);
    14351434    if ($total_num != 0) {
    14361435        $total_page_num = ceil($total_num / $page_size);
     
    17181717        if (!isset($value['count_commu_member'])) {
    17191718            $list[$key]['count_commu_member'] =
    1720                 _db_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
     1719                db_commu_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
    17211720        }
    17221721    }
     
    17661765    foreach ($list as $key => $value) {
    17671766        $list[$key]['count_commu_member'] =
    1768             _db_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
     1767            db_commu_count_c_commu_member_list4c_commu_id($value['c_commu_id']);
    17691768    }
    17701769
  • OpenPNE/branches/debug/2_6_1/webapp/lib/db/deprecated_lib.php

    r1606 r1768  
    274274function p_h_home_c_commu_list4c_member_id($c_member_id, $limit)
    275275{
    276     return db_commu_c_commu_list4c_member_id_3($c_member_id, $limit);
     276    return db_commu_c_commu_list4c_member_id_2($c_member_id, $limit);
    277277}
    278278
  • OpenPNE/branches/debug/2_6_1/webapp/modules/pc/page/h_home.php

    r1766 r1768  
    6262        $this->set('c_friend_count', db_friend_count_friends($u));
    6363        // 参加コミュニティ
    64         $c_commu_user_list = db_commu_c_commu_list4c_member_id_3($u, 9);
     64        $c_commu_user_list = db_commu_c_commu_list4c_member_id_2($u, 9);
    6565        $this->set('c_commu_user_list', $c_commu_user_list);
    6666        $this->set('fh_com_count_user', db_commu_count_c_commu4c_member_id($u));
  • OpenPNE/branches/debug/2_6_1/webapp/modules/pc/templates/inc_f_home_h_prof.tpl

    r1761 r1768  
    594594&pne_item({$key+1})_linkurl=({t_url m=pc a=page_c_home _urlencode=true _html=false})%26target_c_commu_id=({$item.c_commu_id})
    595595&pne_item({$key+1})_imageurl=({t_img_url filename=$item.image_filename w=76 h=76 noimg=no_logo_small _urlencode=true _html=false})
    596 &pne_item({$key+1})_count=({$item.count_commu_member})
     596&pne_item({$key+1})_count=({$item.count_commu_members})
    597597({/foreach})
    598598({/strip})({/capture})
     
    636636<td class="bg_02" align="center">
    637637<a href="({t_url m=pc a=page_c_home})&amp;target_c_commu_id=({$item.c_commu_id})">
    638 ({$item.name}) (({$item.count_commu_member}))
     638({$item.name}) (({$item.count_commu_members}))
    639639</a>
    640640</td>
     
    675675<td class="bg_02" align="center">
    676676<a href="({t_url m=pc a=page_c_home})&amp;target_c_commu_id=({$item.c_commu_id})">
    677 ({$item.name}) (({$item.count_commu_member}))
     677({$item.name}) (({$item.count_commu_members}))
    678678</a>
    679679</td>
     
    714714<td class="bg_02" align="center">
    715715<a href="({t_url m=pc a=page_c_home})&amp;target_c_commu_id=({$item.c_commu_id})">
    716 ({$item.name}) (({$item.count_commu_member}))
     716({$item.name}) (({$item.count_commu_members}))
    717717</a>
    718718</td>
Note: See TracChangeset for help on using the changeset viewer.