Who can tell me in Phpbb index.php Show random image (Crosswise) ?

[ken8yan]

i have See this Post

http://forum.coppermine-gallery.net/index.php?topic=1196.0

Who can tell me in Phpbb index.php Show random image Horizontal display ?
Now only show vertically display ... i want use Horizontal display i need edit where ?

<?php 

//***Enter Path information here***
//***absolute path to main coppermine directory***

$copperminepath = '/gallery';  //***YOU MUST CHANGE THIS***

//This connects to the mysql DB
//***change username and password below***

$MZrandompic = @mysql_connect('localhost', 'root', ''); //***YOU MUST CHANGE THIS***

if (!$MZrandompic) { 
echo( '<p>Unable to connect to the ' . 
'database server at this time.</p>' ); 
exit(); 
} 

//select photo DB
//***YOU MUST CHANGE THIS***

if (! @mysql_select_db('coppermine') ) {
die( '<p>Unable to locate the picture ' . 
'database at this time.</p>' ); 
} 

//This gets a random picture record from the database and
//the picture's location and displays it

$MZresult = @mysql_query("SELECT * FROM cpg11d_pictures ORDER BY RAND() LIMIT 0,4"); 
if (!$MZresult) { 
die('<p>Error performing query: ' . mysql_error() . 
'</p>'); 
} 

while ( $MZrow = mysql_fetch_array($MZresult) ) { 

// $albumid = $MZrow['aid'];  //This gets the picture's associated album name
$pos = $MZrow['pid'];      //This finds the picture's coppermine location

echo('<P ALIGN=center>'); 

echo('<a target = "_new" href="' . $copperminepath . '/displayimage.php?album=' . $albumid . 
'&pos=-' . $pos . '">'); //make thumbnail clickable

echo('<IMG SRC="' . $copperminepath . '/albums/');           //append base dir structure
echo($MZrow['filepath'].thumb_.$MZrow['filename'] .
     '" alt=' . $MZrow['filename'] . ' '. 'border=0 width=80 height=50>' . '</a>'); //outputs path from /userspics
} 

//This displays the picture's album name and
//links it to the coppermine album

$MZalbumresult = @mysql_query("SELECT * FROM cpg11d_albums WHERE aid = '$albumid'"); 
if (!$MZalbumresult) { 
die('<p>Error performing query: ' . mysql_error() . 
'</p>'); 
} 

while ( $MZalbumname = mysql_fetch_array($MZalbumresult) ) { 
echo('<FONT SIZE=1>');
echo('<P ALIGN=center>'); 

echo('<a href="' . $copperminepath . 
'/thumbnails.php?album=' . $albumid . '">' . 
$MZalbumname['title'] . '</a>' . '</p>'); 
} 

if (! @mysql_select_db('coppermine') ) { 
die( '<p>Unable to reload the main website ' . 
'database at this time.</p>' ); 
} 

?>

[DaMysterious]

i have See this Post

http://forum.coppermine-gallery.net/index.php?topic=1196.0

Scroll a little down in the tread and you may find some answers  .

[ken8yan]

i have See this Post

http://forum.coppermine-gallery.net/index.php?topic=1196.0

Scroll a little down in the tread and you may find some answers  .

Sorry Sir ... Can you tell me edit where code ?

[DaMysterious]

i have See this Post

http://forum.coppermine-gallery.net/index.php?topic=1196.0

Scroll a little down in the tread and you may find some answers  .

Sorry Sir ... Can you tell me edit where code ?

Follow this link and scroll down til '2) gallery_center_random_block.php' the solution you'r looking for though.