function DB_select_gp($dataArray) { $_sch_id = $_SESSION['org_id']; $_userkey = $_SESSION['userkey']; $requreStr = ''; if (isset($dataArray) && isset($dataArray['subject']) && $dataArray['subject'] != '' && $dataArray['subject'] != '000') { $requreStr = " WHERE subjectkey='" . $dataArray['subject'] . "' "; } $sql_userjoin = " (SELECT userkey as _userkey ,groupkey as _groupkey,1 as countA FROM p_group_list WHERE BINARY userkey='" . $_userkey . "' AND enable ='1') AS pgl"; $sql_schjoin = " (SELECT groupkey as __groupkey,1 as countB FROM p_group WHERE BINARY gp_orgkey Like '%" . $_sch_id . "%' AND enable ='1') AS pgs"; $sql_postjoin = " (SELECT COUNT(postkey) as postNum,to_key FROM p_post WHERE create_date >= DATE_SUB(NOW(),INTERVAL 7 DAY) AND enable ='1' GROUP BY to_key ) AS pp "; $sql = "SELECT pg.groupkey,pg.subjectkey,pg.gp_topic,pg.gp_scratch,pg.gp_pic,pg.gp_edition,pg.gp_intro,pg.gp_member,pg.gp_orgkey,pg.edit_date,pp.postNum FROM p_group AS pg LEFT JOIN " . $sql_userjoin . " ON pg.groupkey = pgl._groupkey LEFT JOIN " . $sql_schjoin . " ON pgs.__groupkey = pg.groupkey LEFT JOIN " . $sql_postjoin . " ON pp.to_key = pg.groupkey " . $requreStr . " and pg.enable = '1' ORDER BY pg.gp_edition DESC,countA DESC,countB DESC limit 21"; echo $sql; $sql_result = mysql_query($sql); while ($row_data = mysql_fetch_assoc($sql_result)) { toPrint_multiTagWithoutAttr_special('group', $row_data, ''); } }
function DB_get_post_info($dataArray) { $area = 'p_'; $tableName = $area . 'post'; $tableName_comment = $area . 'post_comment'; $tableName_attach = $area . 'post_attach'; $comment_str = ''; $attach_str = ''; $action = $dataArray['subAction']; toPrint_oneMsg('subAction', $dataArray['subAction']); switch ($action) { case "init": $sql = "Select cp.post_id,cp.postkey,cp.from_userkey,cp.to_key,cp.update_date,cp.create_date,cp.remark,cp.post_topic,cp.post_text,cp.post_attach,cp.num_comment,cp.create_date,up.username,up.userpic FROM " . $tableName . " as cp LEFT JOIN user_profile as up ON cp.from_userkey = up.userkey WHERE cp.enable = '1' AND cp.to_key ='" . $dataArray['to_key'] . "' ORDER BY cp.update_date DESC limit 21"; break; case "more": $sql = "Select cp.post_id,cp.postkey,cp.from_userkey,cp.to_key,cp.update_date,cp.create_date,cp.post_topic,cp.post_text,cp.post_attach,cp.num_comment,cp.create_date,up.username,up.userpic FROM " . $tableName . " as cp LEFT JOIN user_profile as up ON cp.from_userkey = up.userkey WHERE cp.enable = '1' AND cp.to_key ='" . $dataArray['to_key'] . "' AND cp.update_date < '" . $dataArray['getPost_min_editdate'] . "' ORDER BY cp.update_date DESC limit 21"; break; case "update": $sql = "Select cp.post_id,cp.postkey,cp.from_userkey,cp.to_key,cp.update_date,cp.create_date,cp.remark,cp.post_topic,cp.post_text,cp.post_attach,cp.num_comment,cp.create_date,up.username,up.userpic FROM " . $tableName . " as cp LEFT JOIN user_profile as up ON cp.from_userkey = up.userkey WHERE cp.enable = '1' AND cp.to_key ='" . $dataArray['to_key'] . "' AND cp.update_date >= '" . $dataArray['getPost_max_editdate'] . "' ORDER BY cp.update_date DESC limit 21"; break; } //echo($sql); $sql_result = mysql_query($sql); while ($row_data = mysql_fetch_assoc($sql_result)) { $postkey = $row_data['postkey']; if ($row_data['num_comment'] != '0') { $comment_str = ''; $sql2 = "Select cp.postkey,cp.from_userkey,cp.create_date,cp.post_text,up.username,up.userpic FROM " . $tableName_comment . " as cp LEFT JOIN user_profile as up ON cp.from_userkey = up.userkey WHERE cp.from_postkey= '" . $postkey . "' AND cp.enable = '1' ORDER BY cp.create_date ASC"; $sql2_result = mysql_query($sql2); while ($row_data2 = mysql_fetch_assoc($sql2_result)) { $comment_str = $comment_str . toString_multiTagWithoutAttr('comment', $row_data2); } } if ($row_data['post_attach'] != '0') { $attach_str = ''; $sql3 = "Select attach_type,attach_link FROM " . $tableName_attach . " WHERE from_postkey='" . $postkey . "' AND enable = '1' ORDER BY post_attach_id ASC"; $sql3_result = mysql_query($sql3); while ($row_data3 = mysql_fetch_assoc($sql3_result)) { $attach_str = $attach_str . toString_multiTagWithoutAttr('attach', $row_data3); } } toPrint_multiTagWithoutAttr_special('post', $row_data, $comment_str . $attach_str); } $recordStr = 'Result:' . $sql_result . '|Userkey:' . $_SESSION['userkey']; recordlog('GetPost', $dataArray['to_key'], $recordStr); }
function DB_select_getGpInfo($dataArray) { $_userKey = ''; if (isset($_SESSION['userkey'])) { $_userKey = $_SESSION['userkey']; } $sql = "SELECT groupkey,subjectkey,gp_topic,gp_intro,gp_pic,gp_scratch,gp_control,gp_join,gp_member,gp_orgkey FROM p_group WHERE BINARY groupkey='" . $dataArray['groupkey'] . "' AND enable='1'"; $result = mysql_query($sql); while ($row_data = mysql_fetch_assoc($result)) { toPrint_multiTagWithoutAttr_special('groupinfo', $row_data, ''); } $recordStr = 'Result:' . $result . '|Group:' . $dataArray['groupkey'] . '|Userkey:' . $_userKey; recordlog('getGpInfo', $dataArray['groupkey'], $recordStr); }