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

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

		// Get latest blogs
		$sql_array = [
			'SELECT'	=> 'b.*, u.user_id, u.username, u.user_colour',

			'FROM'		=> [
				$this->ub_blogs_table => 'b',
			],

			'LEFT_JOIN' => [
				[
					'FROM'	=> [USERS_TABLE => 'u'],
					'ON'	=> 'b.poster_id = u.user_id',
				]
			],

			'ORDER_BY'	=> 'b.post_time DESC',
		];

		$sql = $this->db->sql_build_query('SELECT', $sql_array);
		$result = $this->db->sql_query_limit($sql, $this->config['ub_blogs_per_page'], $start);

		while ($row = $this->db->sql_fetchrow($result))
		{
			// Grab category name
			$cat_sql = 'SELECT cat_name
						FROM ' . $this->ub_cats_table . '
						WHERE cat_id = ' . (int) $row['cat_id'];
			$cat_result = $this->db->sql_query($cat_sql);
			$cat_name = $this->db->sql_fetchfield('cat_name');
			$this->db->sql_freeresult($cat_result);

			// Grab rating
			$r_sql = 'SELECT COUNT(rating) as total_rate_users, SUM(rating) as total_rate_sum
					FROM ' . $this->ub_rating_table . '
					WHERE blog_id = ' . (int) $row['blog_id'];
			$r_result = $this->db->sql_query($r_sql);
			$extra = $this->db->sql_fetchrow($r_result);
			$this->db->sql_freeresult($r_result);
....

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

[phpBB Debug] PHP Warning: in file [ROOT]/ext/mrgoldy/ultimateblog/controller/posting.php on line 195: Invalid argument supplied for foreach()