[Mod] Random Pic in vBulletin - Update: 25.01.2008

[Nicky]

hi,

change both

Code: [Select]

$row = $DB_site->query_first($sql)

to

Code: [Select]

$row = $db->query_first($sql)

in MOD.
works now?

[Mr_LovaLove]

Perfect thanks alot

was tryin to show 3 randoms pic

but seems still not good in coding

this is my site for who want to see the random image

www.143.ae

and it will be nice if 3 randoms can be showed

@Nicky

thanks 

[Nicky]

hi Mr_Lova_Love:

try this

Code: [Select]

// START RANDOM PIC MOD

// Set here the URL to your 4images Gallery. WITH trailing slash!
define('SCRIPT_URL', 'http://YOUR-URL-TO/4images/');

function is_remote($file_name) {
  return (preg_match('#^https?\\:\\/\\/[a-z0-9\-]+\.([a-z0-9\-]+\.)?[a-z]+#i', $file_name)) ? 1 : 0;
}

// NUMBER OF THUMBNAILS TO DISPLAY / NUMMER DER GEWÜNSCHTEN THUMBNAILS
$num_images = 3;

// In following query CHANGE 4images table PREFIX if it doesn't match (Standard "4images_")!
$sql = "SELECT 4images_images.image_id,4images_images.cat_id,4images_images.image_name,
               4images_images.image_active,4images_images.image_thumb_file,4images_images.image_comments
        FROM 4images_images
        LEFT JOIN 4images_categories ON (4images_images.cat_id=4images_categories.cat_id)
        WHERE 4images_images.image_active=1
        AND 4images_categories.auth_viewcat=0
        AND 4images_categories.auth_viewimage=0
        ORDER BY RAND()
        LIMIT $num_images";
$result = $site_db->query($sql);

while ($row = $db->fetch_array($result)){
  $image_id = $row['image_id'];
  $cat_id = $row['cat_id'];
  $image_name = $row['image_name'];
  $image_comments = $row['image_comments'];
$thumb_src = (is_remote($row['image_thumb_file'])) ? $row['image_thumb_file'] : SCRIPT_URL.THUMB_DIR."/".$cat_id."/".$row['image_thumb_file'];

$randompic = "<a href=\"".SCRIPT_URL."details.php?image_id=$image_id\"><img src=\"".$thumb_src."\" border=\"0\" alt=\"$image_name\"></a><br /><smallfont>Image Name: $image_name<br />Comments: $image_comments</smallfont>\n";
}
// HAVE FUN
// END RANDOM PIC MOD

i can't test it because i don't have vbulletin at company

edit:
i think we should play with tables.. because it will be shown in this order

1
2
3

[Mr_LovaLove]

i can't test it because i don't have vbulletin at company

lOol !! yeah like ur site in my country

its not working as an array

it shows me only one image

 

[Nicky]

i didn't have time at home yesterday to check that.
please send your VB global.php and index.php to 4images AT nicky DOT net


[EDIT]
try this

Code: [Select]

// START RANDOM PIC MOD

// Set here the URL to your 4images Gallery. WITH trailing slash!
define('SCRIPT_URL', 'http://YOUR-URL-TO/4images/');

// Set here your THUMBNAIL directory. Normally no need to change. WITHOUT trailing slash!
define('THUMB_DIR', 'data/thumbnails');


function is_remote($file_name) {
  return (preg_match('#^https?\\:\\/\\/[a-z0-9\-]+\.([a-z0-9\-]+\.)?[a-z]+#i', $file_name)) ? 1 : 0;
}

// NUMBER OF THUMBNAILS TO DISPLAY / NUMMER DER GEWÜNSCHTEN THUMBNAILS
$num_images = 3;

// In following query CHANGE 4images table PREFIX if it doesn't match (Standard "4images_")!
$sql = "SELECT 4images_images.image_id, 4images_images.cat_id, 4images_images.image_name,
               4images_images.image_active, 4images_images.image_thumb_file, 4images_images.image_comments
        FROM 4images_images
        LEFT JOIN 4images_categories ON (4images_images.cat_id=4images_categories.cat_id)
        WHERE 4images_images.image_active=1
        AND 4images_categories.auth_viewcat=0
        AND 4images_categories.auth_viewimage=0
        ORDER BY RAND()
        LIMIT $num_images";

$result = $db->query($sql);

$randompic = "<table><tr>\n";  // START NEW TABLE
while ($row = $db->fetch_array($result)){
  $image_id = $row['image_id'];
  $cat_id = $row['cat_id'];
  $image_name = $row['image_name'];
  $image_comments = $row['image_comments'];
$thumb_src = (is_remote($row['image_thumb_file'])) ? $row['image_thumb_file'] : SCRIPT_URL.THUMB_DIR."/".$cat_id."/".$row['image_thumb_file'];

$randompic .=  "<td><a href=\"".SCRIPT_URL."details.php?image_id=$image_id\"><img src=\"".$thumb_src."\" border=\"0\" alt=\"$image_name\" title=\"$image_name\"></a><br /><smallfont>Image Name: $image_name<br />Comments: $image_comments</smallfont></td>\n";
}
$randompic .= "</tr></table>\n"; // END OF NEW TABLE


// END RANDOM PIC MOD

tested on VB 3.6.8 Patch Level 2..
works now with 3 pics

[Mr_LovaLove]

tested on VB 3.6.8 Patch Level 2..
works now with 3 pics

Perfect choice

thanks Nicky  

works fine

[Nicky]

thanks for posting 

[Mr_LovaLove]

Hi Nicky

First, thanks for updating the topic
Kurt has another MOD which we tried to let it works with 4images that integrated with VB

but we have one problem

the session.php which is in 4images is for 1.7.2  or less << and im using this one

and PIN MOD desnt work with 4images 1.7.2 or less

here is my problem
http://www.4homepages.de/forum/index.php?topic=20034.msg110160#msg110160

if u can take  a look

and its better to open a topic for the MODs which works with the integration

Sorry for posting here

Mr Lova

[Mr_LovaLove]

i dont want to include a category in the random

for example i have a category called cards and it tooks id = 10

i tried v@no mod

but didnt work

i will try and at same tome wating for a solution

[Mr_LovaLove]

i dont want to include a category in the random

for example i have a category called cards and it tooks id = 10

i tried v@no mod

but didnt work

i will try and at same tome wating for a solution

still im looking for a solution

infact, i add a video category and i dont want to show that in the VB

any solutions ?

[Mr_LovaLove]

i added this in the select statement

   WHERE
   4images_images.cat_id <> 11

untill now it works fine !!! :S

if its wrong plz correct it for me

[Nicky]

example:

Code: [Select]

   4images_images.cat_id NOT IN (11)