Postado originalmente por
Lucas S.
o Certo seria $FORUM_CONFIGS['NUMBER_FORUM'] = 3 , 4;
Se eu nao me engano eu usava assim...
Lucas, testei dessa forma, e infelizmente não deu
Postado originalmente por
hadeslan
pasa saber a id do forum so ir na categoria que esta localizado tipo se tiver a organização meio diferente ele pode puxar 2 categorias de uma lapa so tipo assim
usando o exemplo da imperyus se eu puxar a categoria ouvidoria vai puxar todas as categorias que esta dentro dela
hadeslan, testei como você falo, mais tambem não deu certo.
Postado originalmente por
navossoc
Cola o trecho do código que faz a leitura que alguém te explica.
[]'s
navossoc, segue abaixo.
Código PHP:
private function loadLastForum()
{
global $ldTpl, $FORUM_CONFIGS;
if($FORUM_CONFIGS['DATABASE']['TYPE'] == 0)
{
$objCon = mysql_connect($FORUM_CONFIGS['DATABASE']['HOST'], $FORUM_CONFIGS['DATABASE']['USERNAME'], $FORUM_CONFIGS['DATABASE']['PASSWORD']);
if($objCon == false)
$tempTpl = "<li><div style=\"border-bottom-color:#C2CAD3; border-bottom-width:thin; border-bottom-style:dotted;\">".LLF_ERROR_CONNECT_DATABASE." (MYSQL)</div></li>";
if(mysql_select_db($FORUM_CONFIGS['DATABASE']['DB_NAME'], $objCon) == false)
$tempTpl = "<li><div style=\"border-bottom-color:#C2CAD3; border-bottom-width:thin; border-bottom-style:dotted;\">".LLF_ERROR_SELECT_DATABASE." (MYSQL)</div></li>";
else
{
switch($FORUM_CONFIGS['TYPE'])
{
case 0: //vBulletin
$query = "SELECT threadid as topicId, title as title FROM {$FORUM_CONFIGS['DATABASE']['TABLE_PREFIX']}thread WHERE forumid = ".($FORUM_CONFIGS['NUMBER_FORUM'] == -1 ? "forumid" : $FORUM_CONFIGS['NUMBER_FORUM'])." ORDER BY threadid DESC LIMIT {$FORUM_CONFIGS['LAST_TOPICS']}";
break;
case 1: //IPB
$query = "SELECT tid as topicId, start_date, views, starter_name, title as title FROM {$FORUM_CONFIGS['DATABASE']['TABLE_PREFIX']}topics WHERE forum_id = ".($FORUM_CONFIGS['NUMBER_FORUM'] == -1 ? "forum_id" : $FORUM_CONFIGS['NUMBER_FORUM'])." ORDER BY tid DESC LIMIT {$FORUM_CONFIGS['LAST_TOPICS']}";
break;
case 2: //phpBB
$query = "SELECT topic_title as title, topic_id as topicId FROM {$FORUM_CONFIGS['DATABASE']['TABLE_PREFIX']}topics WHERE forum_id = ".($FORUM_CONFIGS['NUMBER_FORUM'] == -1 ? "forum_id" : $FORUM_CONFIGS['NUMBER_FORUM'])." ORDER BY topic_id DESC LIMIT {$FORUM_CONFIGS['LAST_TOPICS']}";
break;
}
$query = mysql_query($query);
while($findLastForum = mysql_fetch_object($query))
{
$tempTpl .= sprintf("<li>
<table border='0' width='640px' style='border-bottom-color:#22272a; border-bottom-width:thin; border-bottom-style:dotted; list-style-type:none; margin-left:10px; margin-top:5px; margin-right:10px;'>
<tr>
<td width='480px' style=\"font-size: 12px;\"> <a href=\"{$FORUM_CONFIGS['LINKS_TOPICS']}\" target=\"_blank\">%s</a></td>
<td align='right' style=\"font-size: 12px;\" rowspan='2'>[%s] </td>
</tr>
<tr>
<td width='480px' height='10px' style=\"font-size: 9px;\"><i> Publicado por: <b>%s</b> - com %s views</i></td>
</tr>
</table>
</li>", $findLastForum->topicId, $findLastForum->title, date("d/m/Y - G:i", $findLastForum->start_date), $findLastForum->starter_name, $findLastForum->views);
}
}
}
elseif($FORUM_CONFIGS['DATABASE']['TYPE'] == 1)
{
$objCon = mssql_connect($FORUM_CONFIGS['DATABASE']['HOST'], $FORUM_CONFIGS['DATABASE']['USERNAME'], $FORUM_CONFIGS['DATABASE']['PASSWORD']);
if($objCon == false)
$tempTpl = "<li><div style=\"border-bottom-color:#C2CAD3; border-bottom-width:thin; border-bottom-style:dotted;\">".LLF_ERROR_CONNECT_DATABASE." (MSSQL)</div></li>";
if(mssql_select_db($FORUM_CONFIGS['DATABASE']['DB_NAME'], $objCon) == false)
$tempTpl = "<li><div style=\"border-bottom-color:#C2CAD3; border-bottom-width:thin; border-bottom-style:dotted;\">".LLF_ERROR_SELECT_DATABASE." (MSSQL)</div></li>";
else
{
switch($FORUM_CONFIGS['TYPE'])
{
case 0: //vBulletin
$query = "SELECT TOP {$FORUM_CONFIGS['LAST_TOPICS']} threadid as topicId, title as title FROM {$FORUM_CONFIGS['DATABASE']['TABLE_PREFIX']}thread WHERE forumid = ".($FORUM_CONFIGS['NUMBER_FORUM'] == -1 ? "forumid" : $FORUM_CONFIGS['NUMBER_FORUM'])." ORDER BY threadid DESC";
break;
case 1: //IPB
$query = "SELECT TOP {$FORUM_CONFIGS['LAST_TOPICS']} tid as topicId, views, starter_name, start_date, title as title FROM {$FORUM_CONFIGS['DATABASE']['TABLE_PREFIX']}topics WHERE forum_id = ".($FORUM_CONFIGS['NUMBER_FORUM'] == -1 ? "forum_id" : $FORUM_CONFIGS['NUMBER_FORUM'])." ORDER BY tid DESC";
break;
case 2: //phpBB
$query = "SELECT TOP {$FORUM_CONFIGS['LAST_TOPICS']} topic_title as title, topic_id as topicId FROM {$FORUM_CONFIGS['DATABASE']['TABLE_PREFIX']}topics WHERE forum_id = ".($FORUM_CONFIGS['NUMBER_FORUM'] == -1 ? "forum_id" : $FORUM_CONFIGS['NUMBER_FORUM'])." ORDER BY topic_id DESC";
break;
}
$query = mssql_query($query);
while($findLastForum = mssql_fetch_object($query))
{
$tempTpl .= sprintf("<li><div style=\"border-bottom-color:#C2CAD3; border-bottom-width:thin; border-bottom-style:dotted;\"><a href=\"{$FORUM_CONFIGS['LINKS_TOPICS']}\" target=\"_blank\">%s</a></div></li>", $findLastForum->topicId, $findLastForum->title);
}
}
$this->connect();
}
if($FORUM_CONFIGS['UTF8_DECODE'] == true)
$tempTpl = utf8_decode($tempTpl);
$ldTpl->set("LAST_FORUM_HOME", $tempTpl);
unset($tempTpl);
}