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

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

$this->db->sql_query("SET SESSION sql_mode = 'TRADITIONAL'");

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

$sql = 'SELECT a.attach_id, a.post_msg_id, a.physical_filename, a.real_filename, a.extension, a.filetime, t.topic_title
			FROM ' . ATTACHMENTS_TABLE . ' a, ' . FORUMS_TABLE . ' f, ' . TOPICS_TABLE . ' t
				' . $sql_where . '
				AND (mimetype = "image/jpeg" OR mimetype = "image/png" OR mimetype = "image/gif")
				AND a.topic_id = t.topic_id
				AND t.topic_first_post_id = a.post_msg_id
				GROUP BY a.post_msg_id DESC';
                        $result = $this->db->sql_query_limit($sql, $this->config['last_images_attachment_count']);