cdoyle |
11-03-2011 03:22 AM |
Quote:
Originally Posted by Dylanblitz
(Post 2263855)
ACP -> Plugins&Products -> Plugin Manager
Edit the plugin
VB Pro Garage Forum Home Pictures
Find
PHP Code:
$pic_query = $vbulletin->db->query("SELECT gi.vehicle_id, gi.attach_thumb_location, guv.user_id FROM " . TABLE_PREFIX . "garage_images gi LEFT JOIN " .TABLE_PREFIX . "garage_user_vehicle guv ON gi.vehicle_id = guv.vehicle_id WHERE guv.active = '1' GROUP BY gi.vehicle_id" . $orpic);
replace with
PHP Code:
$pic_query = $vbulletin->db->query("SELECT gi.vehicle_id, gi.attach_thumb_location, guv.user_id FROM " . TABLE_PREFIX . "garage_images gi LEFT JOIN " .TABLE_PREFIX . "garage_user_vehicle guv ON gi.vehicle_id = guv.vehicle_id WHERE guv.active = '1' ORDER BY rand(NOW()) LIMIT " . $displayrecords);
That should do it
|
that worked perfectly thank you!
One last question, and I think I'll have this exactly like I want.
The latest image within the garage, does not seem to be updating. I just added an image, and it's not appearing there.
Where is this query for this located?
|