mmkader Posted September 21, 2010 Share Posted September 21, 2010 Hi all, whats the sql query to get the latest posts along with the user details in a specific forum in vBulletin? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/213967-mysql-query-in-vbulletin/ Share on other sites More sharing options...
Pikachu2000 Posted September 21, 2010 Share Posted September 21, 2010 You'd be better off asking that in the vBulletin support forums, especially since it's specific to the vBulletin software. Quote Link to comment https://forums.phpfreaks.com/topic/213967-mysql-query-in-vbulletin/#findComment-1113563 Share on other sites More sharing options...
mmkader Posted September 21, 2010 Author Share Posted September 21, 2010 Hi pikachu, thanks for your reply. i thought of asking there first. In order to post a topic on vbulletin forum, we need to buy a license for vbulletin before. Right now iam analysing the popular forum softwares and so i havent bought vbulletin license yet. Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/213967-mysql-query-in-vbulletin/#findComment-1113576 Share on other sites More sharing options...
mmkader Posted September 23, 2010 Author Share Posted September 23, 2010 Figured out myself.. The query is, SELECT p.pagetext, u.userid, u.username, t.title, t.threadid, p.dateline AS posttime FROM post p, thread t, user u WHERE t.forumid = 315 AND t.threadid = p.threadid AND p.userid = u.userid ORDER BY posttime DESC LIMIT 5 Was wondering if anyone working in vbulletin could help in optimizing this query.. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/213967-mysql-query-in-vbulletin/#findComment-1114334 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.