function list_by_qid($qid, $ordertype = 1, $rownum = 0, $start = 0, $limit = 10) { $answerlist = array(); $already = 0; if (1 == $ordertype) { $timeorder = 'ASC'; $floor = $start + 1; } else { $timeorder = 'DESC'; $floor = $start ? $rownum - $start : $rownum; } $query = $this->db->query("SELECT * FROM " . DB_TABLEPRE . "answer WHERE qid={$qid} AND status>0 AND adopttime =0 ORDER BY supports DESC,time {$timeorder} LIMIT {$start},{$limit}"); while ($answer = $this->db->fetch_array($query)) { if ($answer['authorid'] == $this->base->user['uid']) { $already = 1; } $answer['floor'] = $floor; $answer['time'] = tdate($answer['time']); $answer['ip'] = formatip($answer['ip']); $answer['author_avartar'] = get_avatar_dir($answer['authorid']); $answer['appends'] = $this->get_appends($answer['id']); $answerlist[] = $answer; if (1 == $floor) { $floor++; } else { $floor--; } } return array($answerlist, $already); }
function get($id) { $question = $this->db->fetch_first("SELECT * FROM " . DB_TABLEPRE . "question WHERE id='{$id}'"); if ($question) { $question['format_time'] = tdate($question['time']); $question['ip'] = formatip($question['ip']); $question['author_avartar'] = get_avatar_dir($question['authorid']); } return $question; }