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

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

	//
	// Get Weblog Data from Weblogs with at least one valid entry
	//
	$sql = "SELECT w.*, u.*, e.entry_id, e.entry_subject, e.entry_access, e.entry_mood, e.entry_currently, e.entry_time, e.currently_text, e.bbcode_uid, e.entry_text
		FROM " . USERS_TABLE . " u, " . WEBLOGS_TABLE . " w
			LEFT JOIN " . WEBLOG_ENTRIES_TABLE . " e
				ON e.weblog_id = w.weblog_id
				AND e.entry_deleted = 0
				AND e.entry_time <= " . time() . "
			WHERE w.weblog_id = u.user_weblog
				AND w.deleted = 0
			ORDER BY $sort $order";

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

	$sql = "SELECT w.*, u.*, e.entry_id, e.entry_subject, e.entry_access, e.entry_mood, e.entry_currently, e.entry_time, e.currently_text, e.bbcode_uid, e.entry_text
		FROM " . USERS_TABLE . " u, " . WEBLOGS_TABLE . " w
			LEFT JOIN " . WEBLOG_ENTRIES_TABLE . " e
				ON e.weblog_id = w.weblog_id
				AND e.entry_deleted = 0
				AND e.entry_time <= " . time() . "
			WHERE w.weblog_id = u.user_weblog
				AND w.deleted = 0
			ORDER BY $sort $order
			LIMIT 0 , 300";

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

Couldn't delete blocked user information.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND owner_id = 2' at line 1

DELETE FROM phpbb_weblog_blocked WHERE blocked_id IN () AND owner_id = 2

Line : 312
File : weblog_blocked.php