[bulbasnore]

Hey there! I now have WebTemplates installed on our production forum and will be moving the pages from the test board into it this weekend. That is the last use I have for our test board before I start testing our systems with 3.5, so when I get around to testing WT with 3.5 I'll let you know the results (probably not 'til late Sept).

I did some further exploration in this vast system and tried the priv_privatemessages template. This template is to return the last 30 pms on the board! However, it returns 30 pms, in an order I don't understand (database hash?).

Anyway, as I microscopic contribution to this vast system, I provide the code to to change the privatemessages example so it does give you the last 30. Insert the code in red into the $WQ_priv_privatemessages webquery.

SELECT pm.pmid, pm.pmtextid, pm.userid, pm.folderid, pm.messageread, pt.fromusername, pt.fromuserid, pt.title, pt.message, pt.touserarray, pt.dateline, u.username AS tousername
FROM " . TABLE_PREFIX . "pm pm
LEFT JOIN " . TABLE_PREFIX . "pmtext pt ON pm.pmtextid = pt.pmtextid
LEFT JOIN " . TABLE_PREFIX . "user u ON pm.userid = u.userid
WHERE pm.folderid = '0' order by pm.pmid DESC
LIMIT 0 , 30

Anyway, this is dangerous code, like any code! After I'm done putting up our price guide in WT, I think I'll adapt this example so that members can see their last 50 PMs on a page. We have people who make lots of trades and I imagine going one by one through their PMs to find where to send the requested items can be a pain. Seeing the last 30-50 at once will let them pick off the addresses and items in one scroll.