Example #1
0
     //end parenting foreach loop
     //inherit hits from old topic
     $kunena_db->setQuery("SELECT hits FROM #__fb_messages WHERE id='{$id}'");
     $hits = (int) $kunena_db->loadResult();
     $kunena_db->setQuery("UPDATE #__fb_messages set hits={$hits} WHERE id={$new_topic}");
     $kunena_db->query();
     //set the highest sorting for old topic
     $kunena_db->setQuery("UPDATE #__fb_messages set ordering='2' WHERE id={$id}");
     $kunena_db->query();
     //copy over sticky bit to new topic
     $kunena_db->setQuery("UPDATE #__fb_messages set ordering='{$sticky_bit}' WHERE id={$new_topic} AND parent=0");
     $kunena_db->query();
     //split succeeded
     CKunenaTools::reCountBoards();
     echo '<br /><br /><div align="center">' . _POST_SUCCESS_SPLIT . "</div><br />";
     echo CKunenaLink::GetLatestPostAutoRedirectHTML($fbConfig, $new_topic, $fbConfig->messages_per_page, $catid);
 } else {
     if ($do == "subscribe") {
         $catid = (int) $catid;
         $id = (int) $id;
         $success_msg = _POST_NO_SUBSCRIBED_TOPIC;
         $kunena_db->setQuery("SELECT thread, catid from #__fb_messages WHERE id='{$id}'");
         if ($id && $kunena_my->id && $kunena_db->query()) {
             $row = $kunena_db->loadObject();
             //check for permission
             if (!$is_Moderator) {
                 if ($fbSession->allowed != "na") {
                     $allow_forum = explode(',', $fbSession->allowed);
                 } else {
                     $allow_forum = array();
                 }