Changeset 8539
- Timestamp:
- Oct 1, 2008, 7:22:08 AM (12 years ago)
- Location:
- OpenPNE/branches/stable-2.10.x/webapp
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/branches/stable-2.10.x/webapp/lib/db/commu.php
r8527 r8539 3042 3042 3043 3043 /** 3044 * コミュニティIDからパブリックフラグを取得 3045 */ 3046 function db_commu_public_flg4c_commu_id($c_commu_id) 3047 { 3048 $sql = "SELECT public_flag FROM c_commu WHERE c_commu_id = ?"; 3044 * コミュニティ参加要請状況をコミュニティIDから取得 3045 * 3046 * @param int $c_commu_id 3047 * @return array コミュニティ参加要請状況 3048 */ 3049 function db_commu_c_commu_member_confirm4c_commu_id($c_commu_id) 3050 { 3051 $sql = 'SELECT c_commu_member_confirm_id, c_member_id FROM c_commu_member_confirm' 3052 . ' WHERE c_commu_id = ?'; 3049 3053 $params = array(intval($c_commu_id)); 3050 return db_get_one($sql, $params); 3054 $c_commu_member_confirm = db_get_all($sql, $params); 3055 3056 return $c_commu_member_confirm; 3051 3057 } 3052 3058 -
OpenPNE/branches/stable-2.10.x/webapp/modules/ktai/do/c_edit_update_c_commu.php
r8473 r8539 36 36 37 37 // 承認待ちメンバー登録処理 38 $registered_public_flag = db_commu_public_flg4c_commu_id($target_c_commu_id); 39 if ($public_flag == 'public' && ($registered_public_flag == 'auth_sns' || $registered_public_flag == 'auth_commu_member')) { 40 $sql = 'SELECT c_commu_member_confirm_id, c_member_id FROM c_commu_member_confirm' 41 . ' WHERE c_commu_id = ?'; 42 $params = array(intval($target_c_commu_id)); 43 $c_commu_member_confirm_list = db_get_all($sql, $params); 38 $c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id); 39 if ($public_flag == 'public' && ($c_commu['publec_flag'] == 'auth_sns' || $c_commu['publec_flag'] == 'auth_commu_member')) { 40 $c_commu_member_confirm_list = db_commu_c_commu_member_confirm4c_commu_id($target_c_commu_id); 44 41 foreach ($c_commu_member_confirm_list as $c_commu_member_confirm) { 45 42 db_commu_join_c_commu($target_c_commu_id, $c_commu_member_confirm['c_member_id']); -
OpenPNE/branches/stable-2.10.x/webapp/modules/pc/do/c_edit_update_c_commu.php
r8473 r8539 86 86 } 87 87 88 $c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id); 89 88 90 //画像アップデート 89 91 $sessid = session_id(); … … 99 101 if ($image_filename) { 100 102 //画像削除 101 $c_commu = db_commu_c_commu4c_commu_id($target_c_commu_id);102 103 image_data_delete($c_commu['image_filename']); 103 104 } 104 105 105 106 // 承認待ちメンバー登録処理 106 $registered_public_flag = db_commu_public_flg4c_commu_id($target_c_commu_id); 107 if ($public_flag == 'public' && ($registered_public_flag == 'auth_sns' || $registered_public_flag == 'auth_commu_member')) { 108 $sql = 'SELECT c_commu_member_confirm_id, c_member_id FROM c_commu_member_confirm' 109 . ' WHERE c_commu_id = ?'; 110 $params = array(intval($target_c_commu_id)); 111 $c_commu_member_confirm_list = db_get_all($sql, $params); 107 if ($public_flag == 'public' && ($c_commu['publec_flag'] == 'auth_sns' || $c_commu['publec_flag'] == 'auth_commu_member')) { 108 $c_commu_member_confirm_list = db_commu_c_commu_member_confirm4c_commu_id($target_c_commu_id); 112 109 foreach ($c_commu_member_confirm_list as $c_commu_member_confirm) { 113 110 db_commu_join_c_commu($target_c_commu_id, $c_commu_member_confirm['c_member_id']); … … 131 128 $map_zoom); 132 129 133 134 130 $p = array('target_c_commu_id' => $target_c_commu_id); 135 131 openpne_redirect('pc', 'page_c_home', $p);
Note: See TracChangeset
for help on using the changeset viewer.