<?php
!defined('W_P') && exit('Forbidden');
!$windid && wap_msg('not_login');
InitGP(array('action', 'tid'));
$rts = array();
$result = $db->query("SELECT typeid FROM pw_collection WHERE type = 'postfavor' AND typeid = " . S::sqlEscape($tid) . " AND uid = " . S::sqlEscape($winduid));
while ($rt = $db->fetch_array($result)) {
$rts[] = $rt['typeid'];
}
$rs['tids'] = implode(',', $rts);
$rs['type'] = '';
if ($rs['tids']) {
$count = 0;
$tiddb = getFavor($rs['tids']);
foreach ($tiddb as $key => $t) {
if (is_array($t)) {
if (CkInArray($tid, $t)) {
favShowMsg('job_favor_error');
}
$count += count($t);
} else {
unset($tiddb[$key]);
}
}
$count > $_G['maxfavor'] && favShowMsg('job_favor_full');
InitGP(array('type'), 2);
$typeid = array('0' => 'default');
if ($rs['type']) {
$typeid = array_merge($typeid, explode(',', $rs['type']));
if (!isset($type)) {
exit();
} */
$from = ($_GET['page'] - 1) * $count;
$sql = "select comment_id,username,users.imageurl,content,food_comments.time,favor from food_comments,users \n\t\t\t\twhere food_comments.user_id=users.user_id and canteen_id={$_POST['canteen_id']}\n\t\t\t\t and food_id={$_POST['food_id']} order by food_comments.time desc limit {$from},{$count};";
$db = Db::getInstance();
try {
$db->connect();
$res = $db->query($sql);
if ($res !== false) {
if (empty($res)) {
$res = null;
} else {
foreach ($res as &$value) {
$value['user_imageurl'] = $value['imageurl'];
getImageUrl($db, $value);
getFavor($db, $_POST['user_id'], $value);
}
}
$json = getJsonResponse(0, "success", $res);
/* if($cache->set($cachename, $json,1200)===false)
Log::error_log($cachename.' '.$cache->error); */
echo $json;
} else {
echo getJsonResponse(1, $db->error, null);
Log::error_log('database error：' . $db->error . ' in ' . basename(__FILE__));
}
$db->close();
} catch (Exception $e) {
echo getJsonResponse(1, "数据库连接错误", null);
Log::error_log("数据库连接错误");
exit;
