<?php /* Forum Class for subeta. * This API is for better expandability */ class forums { protected $error; protected $object; protected $query; public $categories=array(); public $forums=array(); public $threads=array(); public $posts=array(); public $topic; public $forum_one; public $mods; public function __construct() { } public function get_categories() { unset($this->categories); global $thisuser; $this->query = mysql_query("SELECT `name`,`catid` FROM `new_forum_categorys` WHERE open=1 AND level LIKE '%".$thisuser->usertype."%'") or forums::error(mysql_error()); while ($temp = mysql_fetch_array($this->query)) { $this->categories[] = $temp; } return $this->categories; } public function get_forums($parent) { unset($this->forums); global $thisuser; $parent = mysql_real_escape_string($parent); $this->query = mysql_query("SELECT `forumid`,`desc`,`name`,`order`,`last_topic`,`last_user` FROM `new_forum_forum` WHERE catid=$parent AND level LIKE '%".$thisuser->usertype."%' AND `sub` = 'f' ORDER BY `order` DESC") or forums::error(mysql_error()); while ($temp = mysql_fetch_array($this->query)) { $this->forums[] = $temp; } return $this->forums; } public function get_topic($topic,$type='object') { $topic = mysql_real_escape_string($topic); $this->query = mysql_query("SELECT * FROM `new_forum_topic` a, `new_forum_forum` b WHERE a.forumid=b.forumid AND topicid=$topic") or forums::error(mysql_error()); switch ($type) { case 'object': $this->topic=mysql_fetch_object($this->query); break; case 'array': $this->topic=mysql_fetch_array($this->query); break; case 'assoc': $this->topic=mysql_fetch_assoc($this->query); break; } return $this->topic; } public function get_forum_one($topic,$type='object') { $topic = mysql_real_escape_string($topic); $this->query = mysql_query("SELECT * FROM `new_forum_forum` WHERE forumid=$topic") or forums::error(mysql_error()); switch ($type) { case 'object': $this->forum_one=mysql_fetch_object($this->query); break; case 'array': $this->forum_one=mysql_fetch_array($this->query); break; case 'assoc': $this->forum_one=mysql_fetch_assoc($this->query); break; } return $this->forum_one; } public function get_moderators($topic,$type='object') { $topic = mysql_real_escape_string($topic); $this->query = mysql_query("SELECT `mods` FROM `new_forum_forum` WHERE forumid=$topic") or forums::error(mysql_error()); switch ($type) { case 'object': $this->mods=mysql_fetch_object($this->query); break; case 'array': $this->mods=mysql_fetch_array($this->query); break; case 'assoc': $this->mods=mysql_fetch_assoc($this->query); break; } return $this->mods; } private function error($what) { echo $what; } }?>