public function __construct($connection, $user, $dbPrefix) { $this->connect = $connection; $this->user = $user; $this->dbPrefix = $dbPrefix; foreach ($connection->query("SELECT * FROM " . $this->dbPrefix . "forum_threads;") as $row) { $this->nrOfThreads += 1; $thread = new thread(); $thread->setId($row['forumid']); $thread->setText($row['text']); $thread->setTimestamp($row['timestamp']); $thread->setTitle($row['title']); $thread->setUserId($row['userid']); $thread->setTopTopic($row['toptopic']); $thread->setThreadState($row['threadstate']); $thread->setEditCounter($row['editcounter']); if ($row['userid'] != -1) { $thread->setUsername(usertools::getUsernameById($row['userid'], $connection)); } else { $thread->setUsername("Public", $connection); } array_push($this->threads, $thread); } foreach ($this->threads as $thread) { $thread->setSubThreadCounter($this->countSubThreads($thread->getId())); } }
public function createNewThread($title, $text, $toptopic = -1) { $this->connect->exec("INSERT INTO `learncards`.`forum_threads` (`forumid`, `userid`, `title`, `text`, `timestamp`, `toptopic`) VALUES (NULL, '" . $this->user->getId() . "', '" . $title . "', '" . $text . "', CURRENT_TIMESTAMP, '" . $toptopic . "');"); $this->nrOfThreads += 1; $thread = new thread(); $thread->setId($this->connect->lastInsertId()); $thread->setText($text); $thread->setTimestamp(""); $thread->setTitle($title); $thread->setUserId($this->user->getId()); $thread->setTopTopic($toptopic); $thread->setUsername(usertools::getUsernameById($this->user->getId(), $this->connect)); array_push($this->threads, $thread); return $this->connect->lastInsertId(); }