33 replies to this topic

[BPNation]

Is there a way to integrate a random pic block with this portal? The portal is decent, but on my site it's missing that feature. Had it with bfarber's portal for 2.0.4, and would love to get it to work with this one.

[cricket]

BPNation, on Dec 2 2005, 05:51 PM, said:

Is there a way to integrate a random pic block with this portal? The portal is decent, but on my site it's missing that feature. Had it with bfarber's portal for 2.0.4, and would love to get it to work with this one.

I don't have unreal gallery, so I can't make it. If you can make me an admin on your site with the ability to use the sql toolbox, then I can look at the structure of the table for the gallery and create a block for you.

Edited by cricket, 06 December 2005 - 10:28 AM.

[Hottt]

I need new/random image block too, i use IPB gallery.

[chutieu]

Hottt, on Dec 13 2005, 03:31 AM, said:

I need new/random image block too, i use IPB gallery.

try this code (not mine, can't recall who the author is) . Make sure you change the bold to reflect your site

<?php
echo('<CENTER><TABLE BORDER=0><TR>');
$MZresult = @mysql_query("SELECT ibf_gallery_images.id as picid,ibf_members.name as mname,`masked_file_name`,`directory`,`caption`
FROM `ibf_gallery_images` , `ibf_members`
WHERE ibf_gallery_images.member_id = ibf_members.id and ibf_gallery_images.approved=1
ORDER BY rand()
LIMIT 1");
while ( $MZrow = mysql_fetch_array($MZresult) ) {
echo('<TD ALIGN=CENTER width=99%><a href="../forum/index.php?act=module&module=gallery&cmd=si&img='.$MZrow['picid'].'">');
echo('<B>'.$MZrow['caption'].'</B><BR><IMG SRC="../forum/uploads/');
echo($MZrow['directory']. '/tn_'.$MZrow['masked_file_name'].'" alt="click HERE more info on the image"'. 'border=0 ><BR>by '.$MZrow['mname'].'</TD>');
echo ('</TR><TR>');
}
echo('</TR></TABLE>');
?>

[Hottt]

Hi!
When i try to add a block with that code i get this:

mySQL query error: UPDATE ibf_up_custcontent SET html='<?php
echo('<CENTER><TABLE BORDER=0><TR>');
$MZresult = @mysql_query("SELECT ibf_gallery_images.id as picid,ibf_members.name as mname,`masked_file_name`,`directory`,`caption`
FROM `ibf_gallery_images` , `ibf_members`
WHERE ibf_gallery_images.member_id = ibf_members.id and ibf_gallery_images.approved=1
ORDER BY rand()
LIMIT 1");
while ( $MZrow = mysql_fetch_array($MZresult) ) {
echo('<TD ALIGN=CENTER width=99%><a href="http://kulabu.ru/index.php?act=module&module=gallery&cmd=si&img='.$MZrow['picid'].'">');
echo('<B>'.$MZrow['caption'].'</B><BR><IMG SRC="http://kulabu.ru/photos/1120819310/');
echo($MZrow['directory']. '/tn_'.$MZrow['masked_file_name'].'" alt="click HERE more info on the image"'. 'border=0 ><BR>by '.$MZrow['mname'].'</TD>');
echo ('</TR><TR>');
}
echo('</TR></TABLE>');
?>' WHERE name='photos'

SQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '><TABLE BORDER=0><TR>');
$MZresult = @mysql_query("SELECT ibf_
SQL error code:
Date: Thursday 12th of January 2006 04:56:32 PM

What's wrong?
Thank you!

[RobioAXP]

I get the same error! Anyone have a suggestion on where the SQL error is coming from?

[Arkidas]

I also need this

[chutieu]

what is your table prefix? the default prefix is ibf_* . If anything different than the default then you have to change it.

CT

[quote name='Hottt' post='677' date='Jan 12 2006, 08:57 AM']
Hi!
When i try to add a block with that code i get this:

mySQL query error: UPDATE ibf_up_custcontent SET html='<?php
echo('<CENTER><TABLE BORDER=0><TR>');
$MZresult = @mysql_query("SELECT ibf_gallery_images.id as picid,ibf_members.name as mname,`masked_file_name`,`directory`,`caption`
FROM `ibf_gallery_images` , `ibf_members`
WHERE ibf_gallery_images.member_id = ibf_members.id and ibf_gallery_images.approved=1
ORDER BY rand()
LIMIT 1");
while ( $MZrow = mysql_fetch_array($MZresult) ) {
echo('<TD ALIGN=CENTER width=99%><a href="http://kulabu.ru/index.php?act=module&module=gallery&cmd=si&img='.$MZrow['picid'].'">');
echo('<B>'.$MZrow['caption'].'</B><BR><IMG SRC="http://kulabu.ru/photos/1120819310/');
echo($MZrow['directory']. '/tn_'.$MZrow['masked_file_name'].'" alt="click HERE more info on the image"'. 'border=0 ><BR>by '.$MZrow['mname'].'</TD>');
echo ('</TR><TR>');
}
echo('</TR></TABLE>');
?>' WHERE name='photos'

SQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '><TABLE BORDER=0><TR>');
$MZresult = @mysql_query("SELECT ibf_
SQL error code:
Date: Thursday 12th of January 2006 04:56:32 PM

What's wrong?
Thank you!
[/quote]

[Sysop]

Thank you, thank you., thank yoU!!!!!!!!!!

Works fine!!

[Sysop]

Sysop, on Feb 17 2006, 01:58 AM, said:

Thank you, thank you., thank yoU!!!!!!!!!!

Works fine!!

Actually, I should say, I had to modify the code to make it work on my board. The code I used is;



<?php
echo('<CENTER><TABLE BORDER=0><TR>');
$MZresult = @mysql_query("SELECT ipb_gallery_images.id as picid,ipb_members.name as mname,`masked_file_name`,`directory`,`caption`
FROM `ipb_gallery_images` , `ipb_members`
WHERE ipb_gallery_images.member_id = ipb_members.id
ORDER BY rand()
LIMIT 1");
while ( $MZrow = mysql_fetch_array($MZresult) ) {
echo('<TD ALIGN=CENTER width=99%><a href="../index.php?act=module&module=gallery&cmd=si&img='.$MZrow['picid'].'">');
echo('<B>'.$MZrow['caption'].'</B><BR><IMG SRC="../uploads/');
echo($MZrow['directory']. '/tn_'.$MZrow['masked_file_name'].'" alt="click HERE more info on the image"'. 'border=0 ><BR>by '.$MZrow['mname'].'</TD>');
echo ('</TR><TR>');
}
echo('</TR></TABLE>');
?>


because I don't have my webboard installed in a /forums/ directory.

[Sweetz]

Does anyone no or have tried this with coppermine gallery ? i would love to random pic block with this portal for my Diva site.
Thank you for any help

Sweetz

[Sweetz]

hello anyone here help plz and not at the end of summer either thank you

[cwpc]

chutieu, on Jan 1 2006, 06:27 PM, said:

try this code (not mine, can't recall who the author is) . Make sure you change the bold to reflect your site

<?php
echo('<CENTER><TABLE BORDER=0><TR>');
$MZresult = @mysql_query("SELECT ibf_gallery_images.id as picid,ibf_members.name as mname,`masked_file_name`,`directory`,`caption`
FROM `ibf_gallery_images` , `ibf_members`
WHERE ibf_gallery_images.member_id = ibf_members.id and ibf_gallery_images.approved=1
ORDER BY rand()
LIMIT 1");
while ( $MZrow = mysql_fetch_array($MZresult) ) {
echo('<TD ALIGN=CENTER width=99%><a href="../forum/index.php?act=module&module=gallery&cmd=si&img='.$MZrow['picid'].'">');
echo('<B>'.$MZrow['caption'].'</B><BR><IMG SRC="../forum/uploads/');
echo($MZrow['directory']. '/tn_'.$MZrow['masked_file_name'].'" alt="click HERE more info on the image"'. 'border=0 ><BR>by '.$MZrow['mname'].'</TD>');
echo ('</TR><TR>');
}
echo('</TR></TABLE>');
?>

I used this and it worked Great

Thanks

[Azrael]

Sysop, on Feb 20 2006, 05:49 AM, said:

Actually, I should say, I had to modify the code to make it work on my board. The code I used is;
<?php
echo('<CENTER><TABLE BORDER=0><TR>');
$MZresult = @mysql_query("SELECT ipb_gallery_images.id as picid,ipb_members.name as mname,`masked_file_name`,`directory`,`caption`
FROM `ipb_gallery_images` , `ipb_members`
WHERE ipb_gallery_images.member_id = ipb_members.id
ORDER BY rand()
LIMIT 1");
while ( $MZrow = mysql_fetch_array($MZresult) ) {
echo('<TD ALIGN=CENTER width=99%><a href="../index.php?act=module&module=gallery&cmd=si&img='.$MZrow['picid'].'">');
echo('<B>'.$MZrow['caption'].'</B><BR><IMG SRC="../uploads/');
echo($MZrow['directory']. '/tn_'.$MZrow['masked_file_name'].'" alt="click HERE more info on the image"'. 'border=0 ><BR>by '.$MZrow['mname'].'</TD>');
echo ('</TR><TR>');
}
echo('</TR></TABLE>');
?>
because I don't have my webboard installed in a /forums/ directory.

This worked fabulously on the site I maintain, I merely substituded the Uploads dir for where my gallery images are stored.

Thank you very muchly!

[Innes]

could this be done with reflections image gallery?

http://klingmandesign.com/reflections/

[RisingPhoenix]

I noticed that If I change

LIMIT 1");

to

LIMIT 3");

It will show 3 pictures instead of one.

Which is what im looking for, but Does anyone know how to make them run horizontal apposed to vertical?

[Gerry]

Would anyone have this for 2.2 please. This does not work.

Many thanks

[nightwisher]

Working fine to me ! Thanks a lot !

Friendly
Nightwisher

[Gerry]

Does not work for me, this is the error I get, anyone help please

IPB WARNING [2] mysql_fetch_array(): supplied argument is not a valid MySQL result resource (Line: 8 of /sources/action_public/uportal.php(859) : eval()'d code)

[chetanhooli]

Yup woyuld be great if we could have a Horizontal version let us know what to change in the code.