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

Changeset 506


Ignore:
Timestamp:
Oct 18, 2006, 8:23:55 AM (14 years ago)
Author:
kunitada
Message:

db_commu read完了

Location:
OpenPNE/branches/tejima/prj_db_refine/webapp/lib/db
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/tejima/prj_db_refine/webapp/lib/db/commu.php

    r505 r506  
    279279 *              c_member_id_admin       : 管理者のメンバーID
    280280 */
    281 function _db_c_commu_admin_confirm4c_commu_admin_confirm_id($c_commu_admin_confirm_id)
     281function db_c_commu_admin_confirm4c_commu_admin_confirm_id($c_commu_admin_confirm_id)
    282282{
    283283    $sql = "SELECT cac.*, c.c_member_id_admin FROM c_commu_admin_confirm AS cac, c_commu AS c";
     
    289289
    290290// 参加コミュニティリスト
    291 function p_fh_com_list_c_commu_list4c_member_id($c_member_id, $page, $page_size)
     291function db_commu_c_commu_list4c_member_id($c_member_id, $page, $page_size)
    292292{
    293293    $sql = "SELECT c_commu.*" .
     
    336336 * コミュニティトピックからコミュニティIDを取得
    337337 */
    338 function p_c_bbs_c_commu_id4c_commu_topic_id($c_commu_topic_id)
     338function db_commu_c_commu_id4c_commu_topic_id($c_commu_topic_id)
    339339{
    340340    $sql = "SELECT c_commu_id FROM c_commu_topic WHERE c_commu_topic_id = ?";
     
    344344
    345345// $c_commu_id の community に参加しているメンバを返す
    346 function p_c_edit_member_c_member_list4c_commu_id($c_commu_id, $page_size, $page)
     346function db_commu_c_member_list4c_commu_id($c_commu_id, $page_size, $page)
    347347{
    348348    $c_commu = _db_c_commu4c_commu_id($c_commu_id);
     
    410410 * コミュニティメンバーのリストを得る
    411411 */
    412 function p_c_home_c_commu_member_list4c_commu_id($c_commu_id ,$limit = 9)
     412function db_commu_c_commu_member_list4c_commu_id($c_commu_id ,$limit = 9)
    413413{
    414414    $sql = 'SELECT c_member.* FROM c_member, c_commu_member' .
     
    424424}
    425425
    426 function p_c_home_new_topic_comment4c_commu_id($c_commu_id, $limit, $event_flag = 0)
     426function db_commu_new_topic_comment4c_commu_id($c_commu_id, $limit, $event_flag = 0)
    427427{
    428428    $sql = "SELECT cct.c_commu_topic_id , cct.name, MAX(cctc.r_datetime) as r_datetime , cct.c_commu_id " .
     
    450450 * @param   int $c_commu_id
    451451 */
    452 function p_c_invite_invite_list4c_member_id4c_commu_id($c_member_id, $c_commu_id)
     452function db_commu_invite_list4c_member_id4c_commu_id($c_member_id, $c_commu_id)
    453453{
    454454    //友達リスト
     
    477477}
    478478
    479 function p_c_member_list_c_members4c_commu_id($c_commu_id, $page_size, $page)
     479function db_commu_c_members4c_commu_id($c_commu_id, $page_size, $page)
    480480{
    481481    $sql = 'SELECT c_member_id FROM c_commu_member WHERE c_commu_id = ? ORDER BY r_datetime DESC';
     
    514514}
    515515
    516 function p_f_home_c_commu_list4c_member_id($c_member_id, $limit = 9)
     516function db_commu_c_commu_list4c_member_id_2($c_member_id, $limit = 9)
    517517{
    518518    $sql = "SELECT c_commu.c_commu_id, c_commu.image_filename, c_commu.name" .
     
    541541 * @see     h_confirm_list.php
    542542 */
    543 function p_h_confirm_list_anatani_c_commu_member_confirm_list4c_member_id($c_member_id)
     543function db_commu_anatani_c_commu_member_confirm_list4c_member_id($c_member_id)
    544544{
    545545    $sql = "SELECT cmc.*, c.name AS c_commu_name";
     
    568568 * @see     h_confirm_list.php
    569569 */
    570 function p_h_confirm_list_anataga_c_commu_member_confirm_list4c_member_id($c_member_id)
     570function db_commu_anataga_c_commu_member_confirm_list4c_member_id($c_member_id)
    571571{
    572572    $sql = "SELECT cmc.*, c.name AS c_commu_name, c.c_member_id_admin";
     
    596596 * @see     h_confirm_list.php
    597597 */
    598 function p_h_confirm_list_anatani_c_commu_admin_confirm_list4c_member_id($c_member_id_to)
     598function db_commu_anatani_c_commu_admin_confirm_list4c_member_id($c_member_id_to)
    599599{
    600600    $sql = "SELECT cac.*, c.name AS c_commu_name, c.c_member_id_admin";
     
    622622 * @see     h_confirm_list.php
    623623 */
    624 function p_h_confirm_list_anataga_c_commu_admin_confirm_list4c_member_id($c_member_id_admin)
     624function db_commu_anataga_c_commu_admin_confirm_list4c_member_id($c_member_id_admin)
    625625{
    626626    $sql = "SELECT cac.*, c.name AS c_commu_name, c.c_member_id_admin";
     
    641641 * 参加コミュニティ新着書き込みリスト取得
    642642 */
    643 function p_h_home_c_commu_topic_comment_list4c_member_id($c_member_id, $limit)
     643function db_commu_c_commu_topic_comment_list4c_member_id($c_member_id, $limit)
    644644{
    645645    $sql = "SELECT cc.c_commu_topic_id, c.name AS c_commu_name, ct.name AS c_commu_topic_name , cm.c_member_id, cc.number, max(cc.r_datetime) as r_datetime";
     
    678678}
    679679
    680 function p_h_com_comment_list_c_commu_topic_comment_list4c_member_id($c_member_id, $limit,$page)
     680function db_commu_c_commu_topic_comment_list4c_member_id($c_member_id, $limit,$page)
    681681{
    682682    $sql = "SELECT cc.c_commu_topic_id, c.name AS c_commu_name, ct.name AS c_commu_topic_name , cm.c_member_id, cc.number, max(cc.r_datetime) as r_datetime";
     
    745745 * @return  array コミュニティ情報
    746746 */
    747 function p_h_home_c_commu_list4c_member_id($c_member_id, $limit)
     747function db_commu_c_commu_list4c_member_id_3($c_member_id, $limit)
    748748{
    749749    $sql = "SELECT c.* FROM c_commu_member AS cm, c_commu AS c";
     
    761761}
    762762
    763 function p_c_topic_list_c_topic_list4target_c_commu_id($c_commu_id, $c_member_id, $page = 1, $page_size = 10, $event_flag = 0, $topic_with_event = 0)
     763function db_commu_c_topic_list4target_c_commu_id($c_commu_id, $c_member_id, $page = 1, $page_size = 10, $event_flag = 0, $topic_with_event = 0)
    764764{
    765765    $sql = " SELECT cct.c_commu_topic_id, max(cctc.r_datetime) as newest_write_datetime " .
     
    819819}
    820820
    821 function c_topic_detail_c_topic4c_commu_topic_id($c_commu_topic_id)
     821function db_commu_c_topic4c_commu_topic_id($c_commu_topic_id)
    822822{
    823823    $sql = "SELECT ct.*, ctc.*, c_member.nickname" .
     
    832832}
    833833
    834 function p_c_edit_is_topic4c_commu_id($c_commu_id)
     834function db_commu_is_topic4c_commu_id($c_commu_id)
    835835{
    836836    $sql = 'SELECT c_commu_topic_id FROM c_commu_topic WHERE c_commu_id = ?';
     
    845845 * @return array
    846846 */
    847 function _db_common_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id)
     847function db_commu_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id)
    848848{
    849849    $sql = "SELECT ctc.*, ct.name AS topic_name, c.name AS commu_name" .
     
    898898}
    899899
    900 function _db_is_c_commu_member_confirm($c_member_id, $c_commu_id)
     900function db_commu_is_c_commu_member_confirm($c_member_id, $c_commu_id)
    901901{
    902902    $sql = "SELECT COUNT(*) FROM c_commu_member_confirm" .
     
    906906}
    907907
    908 function _db_c_commu_member4c_member_id($c_member_id, $c_commu_id)
     908function db_commu_c_commu_member4c_member_id($c_member_id, $c_commu_id)
    909909{
    910910    $sql = "SELECT * FROM c_commu_member" .
     
    920920 * @return  array トピック情報
    921921 */
    922 function _do_c_bbs_c_commu_topic4c_commu_topic_id($c_commu_topic_id)
     922function db_commu_c_commu_topic4c_commu_topic_id($c_commu_topic_id)
    923923{
    924924    $sql = 'SELECT * FROM c_commu_topic WHERE c_commu_topic_id = ?';
     
    935935 *              c_member_id_admin
    936936 */
    937 function _do_c_commu_member_confirm4c_commu_member_confirm_id($c_commu_member_confirm_id)
     937function db_commu_c_commu_member_confirm4c_commu_member_confirm_id($c_commu_member_confirm_id)
    938938{
    939939    $sql = "SELECT cmc.*, c.c_member_id_admin";
     
    951951define('STATUS_C_JOIN_ALREADY', "4"); //コミュニティ参加(既に参加)
    952952
    953 function do_common_get_c_join_status($c_member_id,$c_commu_id)
     953function db_commu_get_c_join_status($c_member_id,$c_commu_id)
    954954{
    955955    $is_c_commu_member = _db_is_c_commu_member($c_commu_id, $c_member_id);
     
    979979 * トピックコメントIDからトピックを得る
    980980 */
    981 function do_c_bbs_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id)
     981function db_commu_c_commu_topic_comment4c_commu_topic_comment_id_2($c_commu_topic_comment_id)
    982982{
    983983    $sql = 'SELECT * FROM c_commu_topic_comment WHERE c_commu_topic_comment_id = ?';
     
    992992 * @return  array $c_commu_topic
    993993 */
    994 function do_common_c_commu_topic4c_commu_topic_id($c_commu_topic_id, $c_member_id)
     994function db_commu_c_commu_topic4c_commu_topic_id_2($c_commu_topic_id, $c_member_id)
    995995{
    996996    $sql = "SELECT * FROM c_commu_topic WHERE c_commu_topic_id = ?";
  • OpenPNE/branches/tejima/prj_db_refine/webapp/lib/db/deplicated_kunitada.php

    r505 r506  
    7373        return db_commu_is_receive_mail_ktai($c_commu_id, $c_member_id);
    7474}
     75function db_commu_is_receive_mail_pc($c_commu_id, $c_member_id)
     76{
     77        return db_commu_is_receive_mail_pc($c_commu_id, $c_member_id);
     78}
     79
     80function db_commu_is_receive_message($c_commu_id, $c_member_id)
     81{
     82        return db_commu_is_receive_message($c_commu_id, $c_member_id);
     83}
     84
     85function db_common_receive_ktai_address_list4c_commu_id($c_commu_id)
     86{
     87        return db_common_receive_ktai_address_list4c_commu_id($c_commu_id);
     88}
     89
     90function db_common_receive_pc_address_list4c_commu_id($c_commu_id)
     91{
     92        return db_common_receive_pc_address_list4c_commu_id($c_commu_id);
     93}
    7594*/
     95function _db_c_commu_admin_confirm4c_commu_admin_confirm_id($c_commu_admin_confirm_id)
     96{
     97        return db_c_commu_admin_confirm4c_commu_admin_confirm_id($c_commu_admin_confirm_id);
     98}
     99
     100function p_fh_com_list_c_commu_list4c_member_id($c_member_id, $page, $page_size)
     101{
     102        return db_commu_c_commu_list4c_member_id($c_member_id, $page, $page_size);
     103}
     104
     105function p_c_bbs_c_commu_id4c_commu_topic_id($c_commu_topic_id)
     106{
     107        return db_commu_c_commu_id4c_commu_topic_id($c_commu_topic_id);
     108}
     109
     110function p_c_edit_member_c_member_list4c_commu_id($c_commu_id, $page_size, $page)
     111{
     112        return db_commu_c_member_list4c_commu_id($c_commu_id, $page_size, $page);
     113}
     114
     115function p_c_home_c_commu_member_list4c_commu_id($c_commu_id ,$limit = 9)
     116{
     117        return db_commu_c_commu_member_list4c_commu_id($c_commu_id ,$limit = 9);
     118}
     119
     120
     121function p_c_home_new_topic_comment4c_commu_id($c_commu_id, $limit, $event_flag = 0)
     122{
     123        return db_commu_new_topic_comment4c_commu_id($c_commu_id, $limit, $event_flag = 0);
     124}
     125
     126function p_c_invite_invite_list4c_member_id4c_commu_id($c_member_id, $c_commu_id)
     127{
     128        return db_commu_invite_list4c_member_id4c_commu_id($c_member_id, $c_commu_id);
     129}
     130
     131
     132function p_c_member_list_c_members4c_commu_id($c_commu_id, $page_size, $page)
     133{
     134        return db_commu_c_members4c_commu_id($c_member_id, $c_commu_id);
     135}
     136
     137function p_f_home_c_commu_list4c_member_id($c_member_id, $limit = 9)
     138{
     139        return db_commu_c_commu_list4c_member_id_2($c_member_id, $limit = 9);
     140}
     141
     142function p_h_confirm_list_anatani_c_commu_member_confirm_list4c_member_id($c_member_id)
     143{
     144        return db_commu_anatani_c_commu_member_confirm_list4c_member_id($c_member_id);
     145}
     146
     147function p_h_confirm_list_anataga_c_commu_member_confirm_list4c_member_id($c_member_id)
     148{
     149        return db_commu_anataga_c_commu_member_confirm_list4c_member_id($c_member_id);
     150}
     151
     152function p_h_confirm_list_anatani_c_commu_admin_confirm_list4c_member_id($c_member_id_to)
     153{
     154        return db_commu_anatani_c_commu_admin_confirm_list4c_member_id($c_member_id_to);
     155}
     156
     157function p_h_confirm_list_anataga_c_commu_admin_confirm_list4c_member_id($c_member_id_admin)
     158{
     159        return db_commu_anataga_c_commu_admin_confirm_list4c_member_id($c_member_id_admin);
     160}
     161
     162function p_h_home_c_commu_topic_comment_list4c_member_id($c_member_id, $limit)
     163{
     164        return db_commu_c_commu_topic_comment_list4c_member_id($c_member_id, $limit);
     165}
     166
     167function p_h_com_comment_list_c_commu_topic_comment_list4c_member_id($c_member_id, $limit,$page)
     168{
     169        return db_commu_c_commu_topic_comment_list4c_member_id($c_member_id, $limit,$page);
     170}
     171
     172function p_h_home_c_commu_list4c_member_id($c_member_id, $limit)
     173{
     174        return db_commu_c_commu_list4c_member_id_3($c_member_id, $limit);
     175}
     176
     177function p_c_topic_list_c_topic_list4target_c_commu_id($c_commu_id, $c_member_id, $page = 1, $page_size = 10, $event_flag = 0, $topic_with_event = 0)
     178{
     179        return db_commu_c_topic_list4target_c_commu_id($c_commu_id, $c_member_id, $page = 1, $page_size = 10, $event_flag = 0, $topic_with_event = 0);
     180}
     181
     182function c_topic_detail_c_topic4c_commu_topic_id($c_commu_topic_id)
     183{
     184        return db_commu_c_topic4c_commu_topic_id($c_commu_topic_id);
     185}
     186
     187function p_c_edit_is_topic4c_commu_id($c_commu_id)
     188{
     189        return db_commu_is_topic4c_commu_id($c_commu_id);
     190}
     191
     192function _db_common_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id)
     193{
     194        return db_commu_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id);
     195}
     196
    76197/*
    77 function db_commu_is_receive_mail_pc($c_commu_id, $c_member_id)
    78 {
    79         return db_commu_is_receive_mail_pc($c_commu_id, $c_member_id);
    80 }
    81 
    82 function db_commu_is_receive_message($c_commu_id, $c_member_id)
    83 {
    84         return db_commu_is_receive_message($c_commu_id, $c_member_id);
    85 }
    86 
    87 function db_common_receive_ktai_address_list4c_commu_id($c_commu_id)
    88 {
    89         return db_common_receive_ktai_address_list4c_commu_id($c_commu_id);
    90 }
    91 
    92 function db_common_receive_pc_address_list4c_commu_id($c_commu_id)
    93 {
    94         return db_common_receive_pc_address_list4c_commu_id($c_commu_id);
    95 }
    96 
    97 function _db_c_commu_admin_confirm4c_commu_admin_confirm_id($c_commu_admin_confirm_id)
    98 {
    99         return _db_c_commu_admin_confirm4c_commu_admin_confirm_id($c_commu_admin_confirm_id);
    100 }
    101 
    102 function p_fh_com_list_c_commu_list4c_member_id($c_member_id, $page, $page_size)
    103 {
    104         return p_fh_com_list_c_commu_list4c_member_id($c_member_id, $page, $page_size);
    105 }
    106 
    107 function p_c_bbs_c_commu_id4c_commu_topic_id($c_commu_topic_id)
    108 {
    109         return p_c_bbs_c_commu_id4c_commu_topic_id($c_commu_topic_id);
    110 }
    111 
    112 function p_c_edit_member_c_member_list4c_commu_id($c_commu_id, $page_size, $page)
    113 {
    114         return p_c_edit_member_c_member_list4c_commu_id($c_commu_id, $page_size, $page);
    115 }
    116 
    117 function p_c_home_c_commu_member_list4c_commu_id($c_commu_id ,$limit = 9)
    118 {
    119         return p_c_home_c_commu_member_list4c_commu_id($c_commu_id ,$limit = 9);
    120 }
    121 
    122 function p_c_home_new_topic_comment4c_commu_id($c_commu_id, $limit, $event_flag = 0)
    123 {
    124         return p_c_home_new_topic_comment4c_commu_id($c_commu_id, $limit, $event_flag = 0);
    125 }
    126 
    127 function p_c_invite_invite_list4c_member_id4c_commu_id($c_member_id, $c_commu_id)
    128 {
    129         return p_c_invite_invite_list4c_member_id4c_commu_id($c_member_id, $c_commu_id);
    130 }
    131 
    132 function p_c_member_list_c_members4c_commu_id($c_commu_id, $page_size, $page)
    133 {
    134         return p_c_invite_invite_list4c_member_id4c_commu_id($c_member_id, $c_commu_id);
    135 }
    136 
    137 function p_f_home_c_commu_list4c_member_id($c_member_id, $limit = 9)
    138 {
    139         return p_f_home_c_commu_list4c_member_id($c_member_id, $limit = 9);
    140 }
    141 
    142 function p_h_confirm_list_anatani_c_commu_member_confirm_list4c_member_id($c_member_id)
    143 {
    144         return p_h_confirm_list_anatani_c_commu_member_confirm_list4c_member_id($c_member_id);
    145 }
    146 
    147 function p_h_confirm_list_anataga_c_commu_member_confirm_list4c_member_id($c_member_id)
    148 {
    149         return p_h_confirm_list_anataga_c_commu_member_confirm_list4c_member_id($c_member_id);
    150 }
    151 
    152 function p_h_confirm_list_anatani_c_commu_admin_confirm_list4c_member_id($c_member_id_to)
    153 {
    154         return p_h_confirm_list_anatani_c_commu_admin_confirm_list4c_member_id($c_member_id_to);
    155 }
    156 
    157 function p_h_confirm_list_anataga_c_commu_admin_confirm_list4c_member_id($c_member_id_admin)
    158 {
    159         return p_h_confirm_list_anataga_c_commu_admin_confirm_list4c_member_id($c_member_id_admin);
    160 }
    161 
    162 function p_h_home_c_commu_topic_comment_list4c_member_id($c_member_id, $limit)
    163 {
    164         return p_h_home_c_commu_topic_comment_list4c_member_id($c_member_id, $limit);
    165 }
    166 
    167 function p_h_com_comment_list_c_commu_topic_comment_list4c_member_id($c_member_id, $limit,$page)
    168 {
    169         return p_h_com_comment_list_c_commu_topic_comment_list4c_member_id($c_member_id, $limit,$page);
    170 }
    171 
    172 function p_h_home_c_commu_list4c_member_id($c_member_id, $limit)
    173 {
    174         return p_h_home_c_commu_list4c_member_id($c_member_id, $limit);
    175 }
    176 
    177 function p_c_topic_list_c_topic_list4target_c_commu_id($c_commu_id, $c_member_id, $page = 1, $page_size = 10, $event_flag = 0, $topic_with_event = 0)
    178 {
    179         return p_c_topic_list_c_topic_list4target_c_commu_id($c_commu_id, $c_member_id, $page = 1, $page_size = 10, $event_flag = 0, $topic_with_event = 0);
    180 }
    181 
    182 function c_topic_detail_c_topic4c_commu_topic_id($c_commu_topic_id)
    183 {
    184         return c_topic_detail_c_topic4c_commu_topic_id($c_commu_topic_id);
    185 }
    186 
    187 function p_c_edit_is_topic4c_commu_id($c_commu_id)
    188 {
    189         return p_c_edit_is_topic4c_commu_id($c_commu_id);
    190 }
    191 
    192 function _db_common_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id)
    193 {
    194         return _db_common_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id);
    195 }
    196 
    197198function db_common_commu_status($u, $target_c_commu_id)
    198199{
    199200        return db_common_commu_status($u, $target_c_commu_id);
    200201}
    201 
     202*/
    202203function _db_is_c_commu_member_confirm($c_member_id, $c_commu_id)
    203204{
    204         return _db_is_c_commu_member_confirm($c_member_id, $c_commu_id);
     205        return db_commu_is_c_commu_member_confirm($c_member_id, $c_commu_id);
    205206}
    206207
    207208function _db_c_commu_member4c_member_id($c_member_id, $c_commu_id)
    208209{
    209         return _db_c_commu_member4c_member_id($c_member_id, $c_commu_id);
     210        return db_commu_c_commu_member4c_member_id($c_member_id, $c_commu_id);
    210211}
    211212
    212213function _do_c_bbs_c_commu_topic4c_commu_topic_id($c_commu_topic_id)
    213214{
    214         return _do_c_bbs_c_commu_topic4c_commu_topic_id($c_commu_topic_id);
     215        return db_commu_c_commu_topic4c_commu_topic_id($c_commu_topic_id);
    215216}
    216217
    217218function _do_c_commu_member_confirm4c_commu_member_confirm_id($c_commu_member_confirm_id)
    218219{
    219         return _do_c_commu_member_confirm4c_commu_member_confirm_id($c_commu_member_confirm_id);
     220        return db_commu_c_commu_member_confirm4c_commu_member_confirm_id($c_commu_member_confirm_id);
    220221}
    221222
    222223function do_common_get_c_join_status($c_member_id,$c_commu_id)
    223224{
    224         return do_common_get_c_join_status($c_member_id,$c_commu_id);
     225        return db_commu_get_c_join_status($c_member_id,$c_commu_id);
    225226}
    226227
    227228function do_c_bbs_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id)
    228229{
    229         return do_c_bbs_c_commu_topic_comment4c_commu_topic_comment_id($c_commu_topic_comment_id);
     230        return db_commu_c_commu_topic_comment4c_commu_topic_comment_id_2($c_commu_topic_comment_id);
    230231{
    231232}
     
    233234function do_common_c_commu_topic4c_commu_topic_id($c_commu_topic_id, $c_member_id)
    234235{
    235         return do_common_c_commu_topic4c_commu_topic_id($c_commu_topic_id, $c_member_id);
    236 }
    237 */
     236        return db_commu_c_commu_topic4c_commu_topic_id_2($c_commu_topic_id, $c_member_id);
     237}
    238238?>
    239239<?php
Note: See TracChangeset for help on using the changeset viewer.