[split] Coding Question

[leefish]

Reporting back - yes it works! But, it has lost the ability to select only the first attachment in a post.

Using my current settings (pull last 5 attachments from forum 30) with the MyBB attachments version would give me five attachment thumbnails from 5 posts.

Using the same settings in the Xthreads version gives me five attachment thumbnails from 3 posts.  This is because one of the posts has three attachment thumbnails.

I am looking at the differences in the two code sets posted above, and I see that in Rateus code there is a line to group by pid, then to pull the attachments. I have no pid in the Zinga version, but I see that Zinga is using the threads table to join to in the database.

So, I added a line in the code (line6):

Code:

1 2 3 4 5 6 7 8 9

$query = $db->query(" SELECT a.updatetime, a.md5hash, a.uploadtime, a.aid, a.attachname, a.filename, t.* FROM ".TABLE_PREFIX."xtattachments a LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=a.tid) WHERE t.visible=1 AND t.fid IN ('".implode("','", $mnlatatgal_tid_array)."') GROUP BY a.tid ORDER BY a.aid DESC LIMIT $mnlatatgal_num ");

---

I tested it and it worked perfectly. My next challenge is to work out how to get this to show on the forum display. I do think that this is a plug in that many other users would like to have and I would like to ask Rateu if he would consider posting it as a plug in here on MyBBhacks? I can't post it as it is not my plugin.