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

Changeset 9296


Ignore:
Timestamp:
Nov 21, 2008, 1:06:25 AM (11 years ago)
Author:
akamine
Message:

#3107 各関数定義を従来の形に戻し、新規関数の定義を作成

Location:
OpenPNE/branches/stable-2.12.x/webapp
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.12.x/webapp/lib/db/friend.php

    r9295 r9296  
    581581 *              message_disp    : 表示用メッセージ
    582582 */
    583 function db_friend_ktai_anatani_c_friend_confirm_list4c_member_id($c_member_id_to, $page_size, $page)
     583function db_friend_ktai_anatani_c_friend_confirm_list4c_member_id($c_member_id_to)
     584{
     585    $sql = "SELECT * FROM c_friend_confirm WHERE c_member_id_to = ?";
     586    $sql .= " ORDER BY r_datetime DESC";
     587    $params = array(intval($c_member_id_to));
     588    $c_friend_confirm_list = db_get_all($sql, $params);
     589
     590    foreach ($c_friend_confirm_list as $key => $value) {
     591        $c_member = db_member_c_member4c_member_id_LIGHT($value['c_member_id_from']);
     592        $c_friend_confirm_list[$key]['nickname'] = $c_member['nickname'];
     593    }
     594    return $c_friend_confirm_list;
     595}
     596
     597function db_friend_ktai_anatani_c_friend_confirm_list4c_member_id2($c_member_id_to, $page_size, $page)
    584598{
    585599    $sql = "SELECT * FROM c_friend_confirm WHERE c_member_id_to = ?";
     
    634648 *              message_disp    : 表示用メッセージ
    635649 */
    636 function db_friend_ktai_anataga_c_friend_confirm_list4c_member_id($c_member_id_from, $page_size, $page)
     650function db_friend_ktai_anataga_c_friend_confirm_list4c_member_id($c_member_id_from)
     651{
     652    $sql = "SELECT * FROM c_friend_confirm WHERE c_member_id_from = ?";
     653    $sql .= " ORDER BY r_datetime DESC";
     654    $params = array(intval($c_member_id_from));
     655    $c_friend_confirm_list = db_get_all($sql, $params);
     656
     657    foreach ($c_friend_confirm_list as $key => $value) {
     658        $c_member = db_member_c_member4c_member_id_LIGHT($value['c_member_id_to']);
     659        $c_friend_confirm_list[$key]['nickname'] = $c_member['nickname'];
     660    }
     661    return $c_friend_confirm_list;
     662}
     663
     664function db_friend_ktai_anataga_c_friend_confirm_list4c_member_id2($c_member_id_from, $page_size, $page)
    637665{
    638666    $sql = "SELECT * FROM c_friend_confirm WHERE c_member_id_from = ?";
  • OpenPNE/branches/stable-2.12.x/webapp/modules/ktai/page/h_anataga_c_friend_confirm_list.php

    r9295 r9296  
    2929        $page += $direc;
    3030        //ターゲットの詳細なリスト
    31         $list = db_friend_ktai_anataga_c_friend_confirm_list4c_member_id($u, $page_size, $page);
     31        $list = db_friend_ktai_anataga_c_friend_confirm_list4c_member_id2($u, $page_size, $page);
    3232        $total_num = db_friend_count_c_anataga_friend_confirm($u);
    3333        $this->set("c_friend_confirm_list", $list[0]);
  • OpenPNE/branches/stable-2.12.x/webapp/modules/ktai/page/h_anatani_c_friend_confirm_list.php

    r9295 r9296  
    2929        $page += $direc;
    3030        //ターゲットの詳細なリスト
    31         $list = db_friend_ktai_anatani_c_friend_confirm_list4c_member_id($u, $page_size, $page);
     31        $list = db_friend_ktai_anatani_c_friend_confirm_list4c_member_id2($u, $page_size, $page);
    3232        $total_num = db_friend_count_c_anatani_friend_confirm($u);
    3333        $this->set("c_friend_confirm_list", $list[0]);
Note: See TracChangeset for help on using the changeset viewer.