function fbMovePosts($catid, $isMod, $return)
{
$app =& JFactory::getApplication();
$backUrl = $app->getUserState("com_kunena.ActionBulk");
$kunena_db =& JFactory::getDBO();
$kunena_my =& JFactory::getUser();
// $isMod if user is moderator in the current category
if (!$isMod) {
// Test also if user is a moderator in some other category
$kunena_db->setQuery("SELECT userid FROM #__fb_moderation WHERE userid='{$kunena_my->id}'");
$isMod = $kunena_db->loadResult();
check_dberror("Unable to load moderation info.");
}
$isAdmin = CKunenaTools::isModOrAdmin();
//isMod will stay until better group management comes in
if (!$isAdmin && !$isMod) {
$app->redirect($return, _POST_NOT_MODERATOR);
}
$catid = (int) $catid;
if ($catid > 0) {
$items = fbGetArrayInts("fbDelete");
// start iterating here
foreach ($items as $id => $value) {
$id = (int) $id;
$kunena_db->setQuery("SELECT subject, catid, time AS timestamp FROM #__fb_messages WHERE id='{$id}'");
$oldRecord = $kunena_db->loadObjectList();
check_dberror("Unable to load message detail.");
$newCatObj = new jbCategory($kunena_db, $oldRecord[0]->catid);
if (fb_has_moderator_permission($kunena_db, $newCatObj, $kunena_my->id, $isAdmin)) {
$newSubject = _MOVED_TOPIC . " " . $oldRecord[0]->subject;
$kunena_db->setQuery("SELECT MAX(time) AS timestamp FROM #__fb_messages WHERE thread='{$id}'");
$lastTimestamp = $kunena_db->loadResult();
check_dberror("Unable to load messages max(time).");
if ($lastTimestamp == "") {
$lastTimestamp = $oldRecord[0]->timestamp;
}
//perform the actual move
$kunena_db->setQuery("UPDATE #__fb_messages SET `catid`='{$catid}' WHERE `id`='{$id}' OR `thread`='{$id}'");
$kunena_db->query();
check_dberror("Unable to move thread.");
$err = _POST_SUCCESS_MOVE;
} else {
$err = _POST_NOT_MODERATOR;
}
}
//end foreach
} else {
$err = _POST_NO_DEST_CATEGORY;
}
CKunenaTools::reCountBoards();
$app->redirect($return, $err);
}
if (file_exists(KUNENA_ABSTMPLTPATH . '/fb_layout.php')) {
require_once KUNENA_ABSTMPLTPATH . '/fb_layout.php';
} else {
require_once KUNENA_PATH_TEMPLATE_DEFAULT . DS . 'fb_layout.php';
}
require_once KUNENA_PATH_LIB . DS . 'kunena.permissions.php';
require_once KUNENA_PATH_LIB . DS . 'kunena.category.class.php';
require_once JPATH_BASE . '/libraries/joomla/template/template.php';
if ($catid != '') {
$thisCat = new jbCategory($kunena_db, $catid);
}
$KunenaTemplate = new patTemplate();
$KunenaTemplate->setRoot(KUNENA_ABSTMPLTPATH);
$KunenaTemplate->readTemplatesFromFile("header.html");
$KunenaTemplate->readTemplatesFromFile("footer.html");
$is_Moderator = fb_has_moderator_permission($kunena_db, $thisCat, $kunena_my->id, $is_admin);
if ($func == '') {
switch ($fbConfig->fbdefaultpage) {
case 'recent':
$func = 'latest';
break;
case 'my':
$func = $kunena_my->id > 0 ? 'mylatest' : 'latest';
break;
default:
$func = 'listcat';
}
}
// Kunena Current Template Icons Pack
// See if there's an icon pack installed
$useIcons = 0;
</th>
</tr>
<?php
// show forums within the categories
$kunena_db->setQuery("SELECT c.*, m.id AS mesid, m.subject, mm.catid, m.name AS mname, m.userid, u.username, u.name AS uname FROM #__fb_categories AS c\n LEFT JOIN #__fb_messages AS m ON c.id_last_msg=m.id\n LEFT JOIN #__users AS u ON u.id=m.userid\n LEFT JOIN #__fb_messages AS mm ON mm.id=c.id_last_msg\n WHERE c.parent='{$cat->id}' AND c.published='1' ORDER BY ordering");
$rows = $kunena_db->loadObjectList();
check_dberror("Unable to load categories.");
$tabclass = array("sectiontableentry1", "sectiontableentry2");
$k = 0;
if (sizeof($rows) == 0) {
echo '' . _GEN_NOFORUMS . '';
} else {
foreach ($rows as $singlerow) {
$obj_fb_cat = new jbCategory($kunena_db, $singlerow->id);
$is_Mod = fb_has_moderator_permission($kunena_db, $obj_fb_cat, $kunena_my->id, $is_admin);
if (in_array($singlerow->id, $allow_forum)) {
// $k=for alternating row colors:
$k = 1 - $k;
$numtopics = $singlerow->numTopics;
$numreplies = $singlerow->numPosts;
$lastPosttime = $singlerow->time_last_msg;
$lastptime = KUNENA_timeformat(CKunenaTools::fbGetShowTime($singlerow->time_last_msg));
$forumDesc = stripslashes(smile::smileReplace($singlerow->description, 0, $fbConfig->disemoticons, $smileyList));
$forumDesc = nl2br($forumDesc);
$forumDesc = smile::htmlwrap($forumDesc, $fbConfig->wrap);
// Get the forumsubparent categories :: get the subcategories here
$kunena_db->setQuery("SELECT id, name, numTopics, numPosts FROM #__fb_categories WHERE parent='{$singlerow->id}' AND published='1' ORDER BY ordering");
$forumparents = $kunena_db->loadObjectList();
check_dberror("Unable to load categories.");
foreach ($forumparents as $childnum => $childforum) {
?>
"/>
</form>
<?php
} else {
if ($do == "domovepost") {
$catid = (int) $catid;
$id = (int) $id;
$bool_leaveGhost = JRequest::getInt('leaveGhost', 0);
//get the some details from the original post for later
$kunena_db->setQuery("SELECT id, subject, catid, time AS timestamp FROM #__fb_messages WHERE id='{$id}'");
$oldRecord = $kunena_db->loadObjectList();
check_dberror("Unable to load messages.");
$newCatObj = new jbCategory($kunena_db, $oldRecord[0]->catid);
if (!fb_has_moderator_permission($kunena_db, $newCatObj, $kunena_my->id, $is_admin)) {
$app->redirect(htmlspecialchars_decode(JRoute::_(KUNENA_LIVEURLREL)), _POST_NOT_MODERATOR);
}
$newSubject = _MOVED_TOPIC . " " . $oldRecord[0]->subject;
$kunena_db->setQuery("SELECT MAX(time) AS timestamp FROM #__fb_messages WHERE thread='{$id}'");
$lastTimestamp = $kunena_db->loadResult();
check_dberror("Unable to load last timestamp.");
if ($lastTimestamp == "") {
$lastTimestamp = $oldRecord[0]->timestamp;
}
//perform the actual move
//Move topic post first
$kunena_db->setQuery("UPDATE #__fb_messages SET `catid`='{$catid}' WHERE `id`='{$id}'");
$kunena_db->query() or trigger_dberror('Unable to move thread.');
$kunena_db->setQuery("UPDATE #__fb_messages set `catid`='{$catid}' WHERE `thread`='{$id}'");
$kunena_db->query() or trigger_dberror('Unable to move thread.');
}
$obj_KUNENA_tmpl = new patTemplate();
$obj_KUNENA_tmpl->setBasedir(KUNENA_ABSTMPLTPATH);
// Permissions: Check for administrators and moderators
if ($my->id != 0) {
$aro_group = $acl->getAroGroup($my->id);
if ($aro_group and CKunenaTools::isJoomla15()) {
$aro_group->group_id = $aro_group->id;
}
// changed fieldname in Joomla 1.5: "group_id" -> "id"
$is_admin = strtolower($aro_group->name) == 'super administrator' || strtolower($aro_group->name) == 'administrator';
} else {
$aro_group = 0;
$is_admin = 0;
}
$is_Moderator = fb_has_moderator_permission($database, $thisCat, $my->id, $is_admin);
//intercept the RSS request; we should stop afterwards
if ($func == 'fb_rss') {
include KUNENA_ABSSOURCESPATH . 'kunena.rss.php';
die;
}
if ($func == 'fb_pdf') {
include KUNENA_ABSSOURCESPATH . 'kunena.pdf.php';
die;
}
if ($func == '') {
switch ($fbConfig->fbdefaultpage) {
case 'recent':
$func = 'latest';
break;
case 'my':
