The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
forumdisplay.php just like cgtalk.com
Hello,
We discussed that topic a bit at vbulletin (http://www.vbulletin.com/forum/showthread.php?t=118083) and now I'd like to have something like that. I don't think it's a large problem to display the thumbnail of an attached image on forumdisplay.php but Iam just searching for a way to randomly display an image.. Most of the threads have 3 or even more images (the members are using the threads to publish pictures) and i'd like to display them randomly. Is there a way to add this function directly to the query or do I need some special code to generate a random ID with which I can pull it of the database and display it. Here's a basic SQL Query which wouldn't work (obviously ) but which should give you an impression of what I want: SELECT random(id) FROM attachment WHERE threadid = $threadid LIMIT 1; In this case there is more than just one result because there are 3 or more images attached to that thread but I just want to have one random entry out of the 3. I hope you get what I mean and I hope you can help me |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|