Re: ユーザ共通カテゴリーの生成

445
446
447
448
449
450
451
452
453

    //$sql = "SELECT *    //          FROM ".$xoopsDB->prefix($mydirname.'_category')."    //          WHERE uid=".intval($req_uid)." ORDER BY corder";     // naao changed for common category (uid=0)    $sql = "SELECT *              FROM ".$xoopsDB->prefix($mydirname.'_category')."              WHERE uid=".intval($req_uid)." OR uid=0 ORDER BY corder";    $result = $xoopsDB->query($sql);

112
113
114
115
116
117
118
119
120
121
122
123
124
125

if($diary->cid>10000){    $category->uid=0;    $category->cid=$diary->cid;    $category->readdb($mydirname);    $yd_data['cname'] = $category->cname;}elseif($diary->cid>0){//if($diary->cid>0){    $category->uid=$diary->uid;    $category->cid=$diary->cid;    $category->readdb($mydirname);    $yd_data['cname'] = $category->cname;}else{    $yd_data['cname'] = _MD_NOCNAME;}

 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113

    // added common category query    $common_cid=intval(d3diary_getpost_param('cid'));    if( 10000 < $common_cid ){        $whr_common_cid = " AND diary.cid='".$common_cid."'";    } else {        $whr_common_cid = "";    }     $sql = "SELECT diary.diary, diary.create_time, diary.cid, diary.title, diary.bid, diary.openarea, diary.dohtml, usr.uname, usr.uid            FROM ".$xoopsDB->prefix($mydirname.'_diary')." diary             INNER JOIN ".$xoopsDB->prefix('users')." usr ON diary.uid=usr.uid            LEFT JOIN ".$xoopsDB->prefix($mydirname.'_config')." cfg ON diary.uid=cfg.uid "            .$sql_tag            ." WHERE ".$whr_openarea.$whr_common_cid.$whr_tag." AND (cfg.blogtype=0 OR cfg.blogtype IS NULL) ORDER BY diary.create_time DESC";     // naao changed for hide draft entries of other person    //$sql = "SELECT diary.diary, diary.create_time, diary.cid, diary.title, diary.bid, diary.openarea, diary.dohtml, usr.uname, usr.uid    //        FROM ".$xoopsDB->prefix($mydirname.'_diary')." diary     //        INNER JOIN ".$xoopsDB->prefix('users')." usr ON diary.uid=usr.uid    //        LEFT JOIN ".$xoopsDB->prefix($mydirname.'_config')." cfg ON diary.uid=cfg.uid "    //        .$sql_tag    //        ." WHERE ".$whr_openarea.$whr_tag." AND (cfg.blogtype=0 OR cfg.blogtype IS NULL) ORDER BY diary.create_time DESC";

467
468
469
470
471
472
473
474

    //$sql = "SELECT *    //          FROM ".$xoopsDB->prefix($mydirname.'_category')."    //          WHERE uid=".intval($uid)." ORDER BY corder";     // naao changed for common category (uid=0)    $sql = "SELECT *              FROM ".$xoopsDB->prefix($mydirname.'_category')."              WHERE uid=".intval($uid)." OR uid=0 ORDER BY corder";