phpBB Guru - Официальная русская поддержка форума phpBB3

Код: Выделить всё

//Выводим ссылку на топик, приоритет, дату последнего обновления, частоту обновлений
$sql = “SELECT t.topic_id, topic_views, DATE_FORMAT(FROM_UNIXTIME(IFNULL(post_edit_time, post_created)), ‘%Y-%m-%d’) as lastdate,
DATEDIFF( FROM_UNIXTIME( UNIX_TIMESTAMP( ) ) , FROM_UNIXTIME( IFNULL( post_edit_time, post_created ) ) ) as datedif
FROM “.$table_prefix.’topics as t, ‘.$table_prefix.’posts as p WHERE (t.topic_last_post_id = p.post_id)’;

замени на 

//Выводим ссылку на топик, приоритет, дату последнего обновления, частоту обновлений
$sql = “SELECT t.topic_id, topic_views, DATE_FORMAT(FROM_UNIXTIME(IFNULL(post_edit_time, post_time )), ‘%Y-%m-%d’) as lastdate,
DATEDIFF( FROM_UNIXTIME( UNIX_TIMESTAMP( ) ) , FROM_UNIXTIME( IFNULL( post_edit_time, post_time ) ) ) as datedif
FROM “.$table_prefix.’topics as t, ‘.$table_prefix.’posts as p WHERE (t.topic_last_post_id = p.post_id)’;

Код: Выделить всё

$sql = 'SELECT t.topic_id, topic_views, DATE_FORMAT(FROM_UNIXTIME(IFNULL(post_edit_time, post_created)), '%Y-%m-%d') as lastdate,
		DATEDIFF( FROM_UNIXTIME( UNIX_TIMESTAMP( ) ) , FROM_UNIXTIME( IFNULL( post_edit_time, post_time ) ) ) as datedif
		FROM '.$table_prefix.'topics as t LEFT JOIN '.$table_prefix.'posts as p ON (t.topic_last_post_id = p.post_id)';