protected static function create($cat, $specifics, $user)
{
// Call DB Connector
$callDB = new PGSdb();
$callDB->connDB();
$newThreadName = $specifics['title'];
$newThreadPost = $specifics['content'];
$newThreadCategory = $cat;
$newThreadTime = time();
$newThreadAuthor = $user['Username'];
//Prepare
$newThreadPrep = $callDB->db->prepare("INSERT INTO forum_threads(category, title, author, lastposter, timecreated, timelastpost) VALUES(:categoryN, :titleN, :authorN, :lastposterN, :timecreatedN, :timelastpostN)");
//Execute
$newThreadPrep->execute(array('categoryN' => $newThreadCategory, 'titleN' => $newThreadName, 'authorN' => $newThreadAuthor, 'lastposterN' => $newThreadAuthor, 'timecreatedN' => $newThreadTime, 'timelastpostN' => $newThreadTime));
//Get the thread id
$getNewThreadID = thread::get_by_title($newThreadName, $newThreadTime);
$newThreadID = $getNewThreadID['id'];
//Queue in the thread message into posts
//Prepare
$newPostPrep = $callDB->db->prepare("INSERT INTO forum_posts(category, thread, postorderid, author, post, timeposted) VALUES(:categoryN, :threadN, :postorderidN, :authorN, :postN, :timepostedN)");
//Execute
$postOrderID = '1';
$newPostPrep->execute(array('categoryN' => $newThreadCategory, 'threadN' => $newThreadID, 'postorderidN' => $postOrderID, 'authorN' => $newThreadAuthor, 'postN' => $newThreadPost, 'timepostedN' => $newThreadTime));
// //Incriment users post and thread count
// $this->updateUserPostCount($newThreadAuthor);
return array('createCategory' => $cat, 'threadCreated' => $getNewThreadID, 'postCreated' => $newPostPrep->rowCount());
}
