public function getFromProject($_id, $_num = 20) { $return = null; try { $db = new DB(); $items = $db->query("SELECT id\n FROM " . $this->table . "\n WHERE project = '{$_id}'\n AND replyTo = '0'\n ORDER BY date DESC LIMIT {$_num}"); $result = $items->fetchAll(); if ($result) { $return = array(); foreach ($result as $item) { $obC = new ProjectComment(); $return[] = $obC->getFromId($item['id']); } } } catch (PDOException $e) { print "Error!: " . $e->getMessage() . "<br/>"; die; } return $return; }
$this->addTwigVars('title', $_project->name() . " - PH Clone"); switch (@$this->url_var[2]) { default: if (!empty($_POST) and $_user->logged && isset($_POST['comment'])) { $comment = new ProjectComment(); if (!empty($_POST['reply-to']) && isset($_POST['reply-to'])) { $comment->replyTo = (int) addslashes($_POST['reply-to']); } else { $comment->replyTo = 0; } $comment->user = $_user->id; $comment->language = $this->language; $comment->project = $_project->id; $comment->date = date('Y-m-d H:i:s', time()); $comment->comment = htmlentities(strip_tags($_POST['comment'])); $comment->save(); $goTo = strip_tags($this->url_var[0]) . '#comment-' . $comment->id; header("Location: {$goTo}"); exit; } $obC = new ProjectComment(); $commentsArray = $obC->getFromProject($_project->id); $this->addTwigVars('comments', $commentsArray); $this->addTwigVars('userVotes', $_project->getUserVotes()); $template = $this->twig->loadTemplate('projects/project.twig'); echo $template->render($this->twigVars); break; } ?> <?php