XoopsModules25x /
news
| @@ 83-89 (lines=7) @@ | ||
| 80 | /** |
|
| 81 | * @param $topicid |
|
| 82 | */ |
|
| 83 | public function getTopic($topicid) |
|
| 84 | { |
|
| 85 | $topicid = (int)$topicid; |
|
| 86 | $sql = 'SELECT * FROM ' . $this->table . ' WHERE topic_id=' . $topicid . ''; |
|
| 87 | $array = $this->db->fetchArray($this->db->query($sql)); |
|
| 88 | $this->makeTopic($array); |
|
| 89 | } |
|
| 90 | ||
| 91 | /** |
|
| 92 | * @param $array |
|
| @@ 414-421 (lines=8) @@ | ||
| 411 | * |
|
| 412 | * @return mixed |
|
| 413 | */ |
|
| 414 | public function getCountbyStory($storyid) |
|
| 415 | { |
|
| 416 | $sql = 'SELECT count(fileid) as cnt FROM ' . $this->table . ' WHERE storyid=' . (int)$storyid . ''; |
|
| 417 | $result = $this->db->query($sql); |
|
| 418 | $myrow = $this->db->fetchArray($result); |
|
| 419 | ||
| 420 | return $myrow['cnt']; |
|
| 421 | } |
|
| 422 | ||
| 423 | /** |
|
| 424 | * @param $stories |
|
| @@ 279-285 (lines=7) @@ | ||
| 276 | /** |
|
| 277 | * @param $storyid |
|
| 278 | */ |
|
| 279 | public function getStory($storyid) |
|
| 280 | { |
|
| 281 | $storyid = (int)$storyid; |
|
| 282 | $sql = 'SELECT * FROM ' . $this->table . ' WHERE storyid=' . $storyid . ''; |
|
| 283 | $array = $this->db->fetchArray($this->db->query($sql)); |
|
| 284 | $this->makeStory($array); |
|
| 285 | } |
|
| 286 | ||
| 287 | /** |
|
| 288 | * @param $array |
|
