|
|
 |
|
$INFO = array();
require "forum/conf_global.php";
$DB->obj['sql_database'] = $INFO['sql_database'];
$DB->obj['sql_user'] = $INFO['sql_user'];
$DB->obj['sql_pass'] = $INFO['sql_pass'];
$DB->obj['sql_host'] = $INFO['sql_host'];
mysql_connect($INFO['sql_host'],$INFO['sql_user'],$INFO['sql_pass']);
#mysqli_set_charset($DB, "utf8");
mysql_select_db($INFO['sql_database']);
// херня с кодировкой
$res = mysql_query( "SHOW CHARSET LIKE '" . $INFO['mysql_codepage'] . "'");
$charset = mysql_fetch_row($res);
mysql_query( "SET NAMES " . $INFO['mysql_codepage']);
//mysql_query('SET NAMES utf-8;');
mysql_query( "SET CHARACTER SET " . $INFO['mysql_codepage']);
mysql_query( "SET character_set_connection = " . $INFO['mysql_codepage']);
mysql_query( "SET collation_connection = " . $charset[2]);
//Конец херни
$limit=10000000;//Сколько новостей выдавать на странице
$result=mysql_query('select T.tid,T.title,T.starter_name,T.starter_id,T.start_date,P.post from ibf_topics T, ibf_posts P where T.forum_id=2 and T.tid=P.topic_id and P.new_topic=1 order by T.tid desc LIMIT '.$limit);
$numrow=1;
while($row=mysql_fetch_array($result,MYSQL_ASSOC)){
?>
if($numrow<$limit){
?>
}
$numrow+=1;
}
mysql_free_result($result);
mysql_close();
?> |
|
|
|
|
|
|