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

Changeset 4970


Ignore:
Timestamp:
Jan 21, 2008, 8:48:19 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.10.x/webapp/lib/db/commu.php

    r4815 r4970  
    789789function db_commu_anataga_c_commu_sub_admin_confirm_list4c_member_id($c_member_id_sub_admin)
    790790{
    791     $sql = "SELECT cac.*, c.name AS c_commu_name, c.c_member_id_sub_admin";
     791    $sql = "SELECT cac.*, c.name AS c_commu_name, c.c_member_id_admin";
    792792    $sql .= " FROM c_commu_sub_admin_confirm AS cac, c_commu AS c";
    793     $sql .= " WHERE c.c_member_id_sub_admin = ? AND cac.c_commu_id=c.c_commu_id";
     793    $sql .= " WHERE c.c_member_id_admin = ? AND cac.c_commu_id=c.c_commu_id";
    794794    $params = array(intval($c_member_id_sub_admin));
    795795    $c_commu_sub_admin_confirm_list = db_get_all($sql, $params);
Note: See TracChangeset for help on using the changeset viewer.