XoopsModules25x /
news
| @@ 382-389 (lines=8) @@ | ||
| 379 | * |
|
| 380 | * @return mixed |
|
| 381 | */ |
|
| 382 | public function getCountbyStory($storyid) |
|
| 383 | { |
|
| 384 | $sql = 'SELECT count(fileid) as cnt FROM ' . $this->table . ' WHERE storyid=' . (int)$storyid . ''; |
|
| 385 | $result = $this->db->query($sql); |
|
| 386 | $myrow = $this->db->fetchArray($result); |
|
| 387 | ||
| 388 | return $myrow['cnt']; |
|
| 389 | } |
|
| 390 | ||
| 391 | /** |
|
| 392 | * @param $stories |
|
| @@ 270-276 (lines=7) @@ | ||
| 267 | /** |
|
| 268 | * @param $storyid |
|
| 269 | */ |
|
| 270 | public function getStory($storyid) |
|
| 271 | { |
|
| 272 | $storyid = (int)$storyid; |
|
| 273 | $sql = 'SELECT * FROM ' . $this->table . ' WHERE storyid=' . $storyid . ''; |
|
| 274 | $array = $this->db->fetchArray($this->db->query($sql)); |
|
| 275 | $this->makeStory($array); |
|
| 276 | } |
|
| 277 | ||
| 278 | /** |
|
| 279 | * @param $array |
|
| @@ 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 |
|
