qcminecraft/Carbon-Forum-F

<?php
require(LanguagePath . 'favorite_tags.php');
Auth(1);
$Page = Request('Get', 'page');
if ($Page < 0 || $Page == 1) 
    Redirect('tags/following');
if ($Page == 0)
    $Page = 1;
$TagsFollowing = $DB->query('SELECT * FROM ' . PREFIX . 'favorites force index(UsersFavorites) Where UserID=? and Type=2', array(
    $CurUserID
));
$TopicIDArray  = array();
if ($TagsFollowing)
    $TopicIDArray = $DB->column('SELECT TopicID 
            FROM ' . PREFIX . 'posttags force index(TagsIndex) 
            WHERE TagID in (?) 
            ORDER BY TopicID DESC 
            LIMIT ' . ($Page - 1) * $Config['TopicsPerPage'] . ',' . ($Config['TopicsPerPage'] + 1),
        ArrayColumn($TagsFollowing, 'FavoriteID'));

if (count($TopicIDArray) > $Config['TopicsPerPage']) {
    $IsLastPage = false;
    array_pop($TopicIDArray);
} else {
    $IsLastPage = true;
}

array_unique($TopicIDArray);
$TopicsArray = array();
if ($TopicIDArray)
    $TopicsArray = $DB->query('SELECT `ID`, `Topic`, `Tags`, `UserID`, `UserName`, `LastName`, `LastTime`, `Replies` 
            FROM ' . PREFIX . 'topics force index(PRI) 
            WHERE ID in (?) and IsDel=0 
            ORDER BY LastTime DESC',
        $TopicIDArray);
$DB->CloseConnection();
$PageTitle = $Lang['My_Following_Tags'];
$PageTitle .= $Page > 1 ? ' Page' . $Page : '';
$ContentFile = $TemplatePath . 'favorite_tags.php';
include($TemplatePath . 'layout.php');