Changeset 9380
- Timestamp:
- Nov 25, 2008, 8:33:14 PM (12 years ago)
- 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 833 833 $sql .= " FROM c_commu_member_confirm AS cmc, c_commu AS c"; 834 834 $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"; 835 836 $params = array(intval($c_member_id), intval($c_member_id)); 836 837 $c_commu_member_confirm_list = db_get_all_page($sql, $page, $page_size, $params); … … 892 893 $sql .= " FROM c_commu_member_confirm AS cmc, c_commu AS c"; 893 894 $sql .= " WHERE cmc.c_member_id = ? AND cmc.c_commu_id=c.c_commu_id"; 895 $sql .= " ORDER BY cmc.r_datetime ASC"; 894 896 $params = array(intval($c_member_id)); 895 897 $c_commu_member_confirm_list = db_get_all_page($sql, $page, $page_size, $params); … … 951 953 $sql .= " FROM c_commu_admin_confirm AS cac, c_commu AS c"; 952 954 $sql .= " WHERE cac.c_member_id_to = ? AND cac.c_commu_id=c.c_commu_id"; 955 $sql .= " ORDER BY cac.r_datetime ASC"; 953 956 $params = array(intval($c_member_id_to)); 954 957 $c_commu_admin_confirm_list = db_get_all_page($sql, $page, $page_size, $params); … … 1007 1010 $sql .= " FROM c_commu_admin_confirm AS cac, c_commu AS c"; 1008 1011 $sql .= " WHERE c.c_member_id_admin = ? AND cac.c_commu_id=c.c_commu_id"; 1012 $sql .= " ORDER BY cac.r_datetime ASC"; 1009 1013 $params = array(intval($c_member_id_admin)); 1010 1014 $c_commu_admin_confirm_list = db_get_all_page($sql, $page, $page_size, $params); … … 1066 1070 $sql .= " FROM c_commu_sub_admin_confirm AS cac, c_commu AS c"; 1067 1071 $sql .= " WHERE cac.c_member_id_to = ? AND cac.c_commu_id=c.c_commu_id"; 1072 $sql .= " ORDER BY cac.r_datetime ASC"; 1068 1073 $params = array(intval($c_member_id_to)); 1069 1074 $c_commu_sub_admin_confirm_list = db_get_all_page($sql, $page, $page_size, $params); … … 1122 1127 $sql .= " FROM c_commu_sub_admin_confirm AS cac, c_commu AS c"; 1123 1128 $sql .= " WHERE c.c_member_id_admin = ? AND cac.c_commu_id=c.c_commu_id"; 1129 $sql .= " ORDER BY cac.r_datetime ASC"; 1124 1130 $params = array(intval($c_member_id_admin)); 1125 1131 $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 598 598 { 599 599 $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"; 601 601 $params = array(intval($c_member_id_to)); 602 602 $c_friend_confirm_list = db_get_all_page($sql, $page, $page_size, $params); … … 665 665 { 666 666 $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"; 668 668 $params = array(intval($c_member_id_from)); 669 669 $c_friend_confirm_list = db_get_all_page($sql, $page, $page_size, $params);
Note: See TracChangeset
for help on using the changeset viewer.