function acceptPost($post_id) { $db =& JFactory::getDBO(); // set WFM to 0 and published to 1 $sql = "UPDATE " . $db->nameQuote('#__discussions_messages') . " SET wfm = '0'" . "," . " published = '1'" . " WHERE id = '" . $post_id . "'"; $db->setQuery($sql); $db->query(); // update the stats now // get user id of this post $sql = "SELECT user_id FROM " . $db->nameQuote('#__discussions_messages') . " WHERE id='" . $post_id . "'"; $db->setQuery($sql); $_user_id = $db->loadResult(); // get thread id of this post $sql = "SELECT thread FROM " . $db->nameQuote('#__discussions_messages') . " WHERE id='" . $post_id . "'"; $db->setQuery($sql); $_thread_id = $db->loadResult(); // get category id of this post $sql = "SELECT cat_id FROM " . $db->nameQuote('#__discussions_messages') . " WHERE id='" . $post_id . "'"; $db->setQuery($sql); $_cat_id = $db->loadResult(); // set user post counter ++ $result = $this->increaseUserPostCounter($_user_id); // todo check if user is no rookie any more $postUser = new CofiUser($_user_id); // get Rookie Mode setting from com_discussions parameters $params = JComponentHelper::getParams('com_discussions'); $rookie = $params->get('rookie', '0'); if ($postUser->isRookie()) { // check if he is now no rookie any more if ($postUser->getPosts() >= $rookie) { $postUser->setRookie(0); } } // update thread stats $result = $this->updateThreadStats($_thread_id); // update category stats $result = $this->updateCategoryStats($_cat_id); return 0; }