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

Changeset 9380


Ignore:
Timestamp:
Nov 25, 2008, 8:33:14 PM (12 years ago)
Author:
akamine
Message:

#3107 承認待ちリストの各詳細画面の表示順を古い順に統一しました

Location:
OpenPNE/branches/stable-2.10.x/webapp/lib/db
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • OpenPNE/branches/stable-2.10.x/webapp/lib/db/commu.php

    r9358 r9380  
    833833    $sql .= " FROM c_commu_member_confirm AS cmc, c_commu AS c";
    834834    $sql .= " WHERE (c.c_member_id_admin = ? OR c.c_member_id_sub_admin = ?) AND cmc.c_commu_id=c.c_commu_id";
     835    $sql .= " ORDER BY cmc.r_datetime ASC";
    835836    $params = array(intval($c_member_id), intval($c_member_id));
    836837    $c_commu_member_confirm_list = db_get_all_page($sql, $page, $page_size, $params);
    … …  
    892893    $sql .= " FROM c_commu_member_confirm AS cmc, c_commu AS c";
    893894    $sql .= " WHERE cmc.c_member_id = ? AND cmc.c_commu_id=c.c_commu_id";
     895    $sql .= " ORDER BY cmc.r_datetime ASC";
    894896    $params = array(intval($c_member_id));
    895897    $c_commu_member_confirm_list = db_get_all_page($sql, $page, $page_size, $params);
    … …  
    951953    $sql .= " FROM c_commu_admin_confirm AS cac, c_commu AS c";
    952954    $sql .= " WHERE cac.c_member_id_to = ? AND cac.c_commu_id=c.c_commu_id";
     955    $sql .= " ORDER BY cac.r_datetime ASC";
    953956    $params = array(intval($c_member_id_to));
    954957    $c_commu_admin_confirm_list = db_get_all_page($sql, $page, $page_size, $params);
    … …  
    10071010    $sql .= " FROM c_commu_admin_confirm AS cac, c_commu AS c";
    10081011    $sql .= " WHERE c.c_member_id_admin = ? AND cac.c_commu_id=c.c_commu_id";
     1012    $sql .= " ORDER BY cac.r_datetime ASC";
    10091013    $params = array(intval($c_member_id_admin));
    10101014    $c_commu_admin_confirm_list = db_get_all_page($sql, $page, $page_size, $params);
    … …  
    10661070    $sql .= " FROM c_commu_sub_admin_confirm AS cac, c_commu AS c";
    10671071    $sql .= " WHERE cac.c_member_id_to = ? AND cac.c_commu_id=c.c_commu_id";
     1072    $sql .= " ORDER BY cac.r_datetime ASC";
    10681073    $params = array(intval($c_member_id_to));
    10691074    $c_commu_sub_admin_confirm_list = db_get_all_page($sql, $page, $page_size, $params);
    … …  
    11221127    $sql .= " FROM c_commu_sub_admin_confirm AS cac, c_commu AS c";
    11231128    $sql .= " WHERE c.c_member_id_admin = ? AND cac.c_commu_id=c.c_commu_id";
     1129    $sql .= " ORDER BY cac.r_datetime ASC";
    11241130    $params = array(intval($c_member_id_admin));
    11251131    $c_commu_sub_admin_confirm_list = db_get_all_page($sql, $page, $page_size, $params);

  • OpenPNE/branches/stable-2.10.x/webapp/lib/db/friend.php

    r9354 r9380  
    598598{
    599599    $sql = "SELECT * FROM c_friend_confirm WHERE c_member_id_to = ?";
    600     $sql .= " ORDER BY r_datetime DESC";
     600    $sql .= " ORDER BY r_datetime ASC";
    601601    $params = array(intval($c_member_id_to));
    602602    $c_friend_confirm_list = db_get_all_page($sql, $page, $page_size, $params);
    … …  
    665665{
    666666    $sql = "SELECT * FROM c_friend_confirm WHERE c_member_id_from = ?";
    667     $sql .= " ORDER BY r_datetime DESC";
     667    $sql .= " ORDER BY r_datetime ASC";
    668668    $params = array(intval($c_member_id_from));
    669669    $c_friend_confirm_list = db_get_all_page($sql, $page, $page_size, $params);
Note: See TracChangeset for help on using the changeset viewer.