xthreads error

[ZiNgA BuRgA]

(01-12-2011 07:32 PM)1master1 Wrote:  found that the xthread custom field permissions are not synchronizing withe the default mybb permissions.

It's not meant to.

It appears that the join is not being put into your query.
XThreads searches for the WHERE statement and part of it to replace it:

PHP Code:

'WHERE t.fid=' => 'LEFT JOIN `'.$db->table_prefix.'threadfields_data` tfd ON t.tid=tfd.tid'.$sortjoin.' WHERE t.fid=',

---

You said you've done some core file edits.  Have you modified this query in forumdisplay.php in any way?

PHP Code:

1 2 3 4 5 6 7 8 9 10 11

// Start Getting Threads $query = $db->query(" SELECT t.*, p.displaystyle AS threadprefix, {$ratingadd}{$select_rating_user}t.username AS threadusername, u.username FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid){$select_voting} LEFT JOIN ".TABLE_PREFIX."threadprefixes p ON (p.pid = t.prefix) WHERE t.fid='$fid' $tuseronly $tvisibleonly $datecutsql2 GROUP BY t.tid ORDER BY t.sticky DESC, {$t}{$sortfield} $sortordernow $sortfield2 LIMIT $start, $perpage ");

---