| @@ 83-89 (lines=7) @@ | ||
| 80 | * |
|
| 81 | * @param int $id |
|
| 82 | */ |
|
| 83 | public function load($id) |
|
| 84 | { |
|
| 85 | $id = (int)$id; |
|
| 86 | $sql = 'SELECT * FROM ' . $this->db->prefix('newblocks') . ' WHERE bid = ' . $id; |
|
| 87 | $arr = $this->db->fetchArray($this->db->query($sql)); |
|
| 88 | $this->assignVars($arr); |
|
| 89 | } |
|
| 90 | ||
| 91 | /** |
|
| 92 | * Store Block Data to Database |
|
| @@ 81-87 (lines=7) @@ | ||
| 78 | * |
|
| 79 | * @param int $id |
|
| 80 | */ |
|
| 81 | public function load($id) |
|
| 82 | { |
|
| 83 | $id = (int)$id; |
|
| 84 | $sql = 'SELECT * FROM ' . $this->ctable . ' WHERE comment_id=' . $id; |
|
| 85 | $arr = $this->db->fetchArray($this->db->query($sql)); |
|
| 86 | $this->assignVars($arr); |
|
| 87 | } |
|
| 88 | ||
| 89 | /** |
|
| 90 | * Save Comment |
|
| @@ 272-278 (lines=7) @@ | ||
| 269 | /** |
|
| 270 | * @param $storyid |
|
| 271 | */ |
|
| 272 | public function getStory($storyid) |
|
| 273 | { |
|
| 274 | $storyid = (int)$storyid; |
|
| 275 | $sql = 'SELECT * FROM ' . $this->table . ' WHERE storyid=' . $storyid . ''; |
|
| 276 | $array = $this->db->fetchArray($this->db->query($sql)); |
|
| 277 | $this->makeStory($array); |
|
| 278 | } |
|
| 279 | ||
| 280 | /** |
|
| 281 | * @param $array |
|
| @@ 85-91 (lines=7) @@ | ||
| 82 | /** |
|
| 83 | * @param $topicid |
|
| 84 | */ |
|
| 85 | public function getTopic($topicid) |
|
| 86 | { |
|
| 87 | $topicid = (int)$topicid; |
|
| 88 | $sql = 'SELECT * FROM ' . $this->table . ' WHERE topic_id=' . $topicid . ''; |
|
| 89 | $array = $this->db->fetchArray($this->db->query($sql)); |
|
| 90 | $this->makeTopic($array); |
|
| 91 | } |
|
| 92 | ||
| 93 | /** |
|
| 94 | * @param $array |
|