[Delphiprogrammi]

Originally Posted by wwesn1

did you read my posts?

Change The

		" . TABLE_PREFIX . "postreport.*,
		" . TABLE_PREFIX . "user.username modname,
		" . TABLE_PREFIX . "user2.username reporter,
		" . TABLE_PREFIX . "post.username postername,
		" . TABLE_PREFIX . "post.userid posterid,
		" . TABLE_PREFIX . "thread.title,
		" . TABLE_PREFIX . "thread.threadid,
		" . TABLE_PREFIX . "forum.title forumtitle,
		" . TABLE_PREFIX . "forum.forumid

TO

		postreport.*,
		user.username modname,
		user2.username reporter,
		post.username postername,
		post.userid posterid,
		thread.title,
		thread.threadid,
		forum.title forumtitle,
		forum.forumid

That will work untill he fixes it

yeah i did read your posts but i'm getting anothr error as you had php code that's causing the error ...

PHP Code:

$postreports = $DB_site->query("
    SELECT
    " . TABLE_PREFIX . "postreport.*,
    " . TABLE_PREFIX . "user.username modname,
    " . TABLE_PREFIX . "post.username postername,
    " . TABLE_PREFIX . "post.userid posterid,
    " . TABLE_PREFIX . "thread.title, thread.threadid
    FROM " . TABLE_PREFIX . "postreport AS postreport
    LEFT JOIN " . TABLE_PREFIX . "user AS user ON (postreport.modid = user.userid)
    LEFT JOIN " . TABLE_PREFIX . "post AS post ON (postreport.postid = post.postid)
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
    WHERE " . TABLE_PREFIX ."postreport.userid = $userid
    ORDER BY postreport.dateline DESC
    LIMIT $page_start, $reports_per_page
");