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

Changeset 4972


Ignore:
Timestamp:
Jan 21, 2008, 9:05:46 PM (12 years ago)
Author:
ebihara
Message:

#1693:db_commu_anataga_c_commu_sub_admin_confirm_list4c_member_id()(あなたがコミュニティ副管理者要請しているメンバー一覧取得関数)のSQL文が誤っていたのを修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/stable-2.8.x/webapp/lib/db/commu.php

    r3691 r4972  
    778778function db_commu_anataga_c_commu_sub_admin_confirm_list4c_member_id($c_member_id_sub_admin)
    779779{
    780     $sql = "SELECT cac.*, c.name AS c_commu_name, c.c_member_id_sub_admin";
     780    $sql = "SELECT cac.*, c.name AS c_commu_name, c.c_member_id_admin";
    781781    $sql .= " FROM c_commu_sub_admin_confirm AS cac, c_commu AS c";
    782     $sql .= " WHERE c.c_member_id_sub_admin = ? AND cac.c_commu_id=c.c_commu_id";
     782    $sql .= " WHERE c.c_member_id_admin = ? AND cac.c_commu_id=c.c_commu_id";
    783783    $params = array(intval($c_member_id_sub_admin));
    784784    $c_commu_sub_admin_confirm_list = db_get_all($sql, $params);
Note: See TracChangeset for help on using the changeset viewer.