問題外掛:Coppermine Photo Gallery 1.2.1
參考連結:here
使用版本:phpBB 2.0.4
網站位置:
狀況描述:
可否把 "隨機圖片" 放在討論版討頁內 ? phpBB2/index.php
我要如何修改
[問題] Coppermine Photo Gallery
版主: 版主管理群
Coppermine Photo Gallery 這個功能竹貓好像支援的不多help 寫:沒有人可以幫忙 ?
有空也可以到其它友站發問看看或許就能問出個答案來也說不定
Coppermine Photo Gallery 這個功能我也是在竹貓看到的教學文
但是是去友站發問才慢慢架成功的
說了那麼多~你的問題我也不會 ^"^║║(汗)
~§ 架站系統:WindowsXP §~
~§ 架站程式:Appserv2.4.4a §~
~§ 使用網路:giga ADSL §~
~§ 安裝程式:Apache + php + MySql §~
~§ 論壇版本: 2.0.18 §~
申明檔
1.新手發問並不是可恥的事.可恥的是沒有按照發文規則及格式還裝做沒解決你的問題是我們的錯。
2.很樂意大家pm給我.或把我加入即時通.msn,但加入並不是代表小弟已成為您的私人看護。
3.還是想不通嗎? 那可以到地下十八樓找你的答案。
[http://microduo.home99.tw/?fromuid=6331]微剋多資訊[/url]
~§ 架站程式:Appserv2.4.4a §~
~§ 使用網路:giga ADSL §~
~§ 安裝程式:Apache + php + MySql §~
~§ 論壇版本: 2.0.18 §~
申明檔
1.新手發問並不是可恥的事.可恥的是沒有按照發文規則及格式還裝做沒解決你的問題是我們的錯。
2.很樂意大家pm給我.或把我加入即時通.msn,但加入並不是代表小弟已成為您的私人看護。
3.還是想不通嗎? 那可以到地下十八樓找你的答案。
[http://microduo.home99.tw/?fromuid=6331]微剋多資訊[/url]
找到一個文章 .... 不過好似唔係咁明白內容
http://coppermine.sourceforge.net/board ... pic=1196.0
Ok here we go:
In your case create a file e.g 'gallery_side_random_block.php' in you coppermine dir, put the code below in it and change the path to your '/gallery' and correct the connection to your mySql database, further you could change the number of dispayed thumbs with 'LIMIT 0,4' on row 30 to the amount you like. Now there are random 4 thumbs vertically displayed.
[php]<?php
<?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>' );
}
?>
?>[/php]
Go to your sidenav.tpl and add the code below to your table/block 'my gallery' section (change to he right path).
[php]<?php
<?php include("/inetpub/coppermine/gallery_side_random_block.php");>
?>[/php]
有沒有人可翻譯一下內容 ?
http://coppermine.sourceforge.net/board ... pic=1196.0
Ok here we go:
In your case create a file e.g 'gallery_side_random_block.php' in you coppermine dir, put the code below in it and change the path to your '/gallery' and correct the connection to your mySql database, further you could change the number of dispayed thumbs with 'LIMIT 0,4' on row 30 to the amount you like. Now there are random 4 thumbs vertically displayed.
[php]<?php
<?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>' );
}
?>
?>[/php]
Go to your sidenav.tpl and add the code below to your table/block 'my gallery' section (change to he right path).
[php]<?php
<?php include("/inetpub/coppermine/gallery_side_random_block.php");>
?>[/php]
有沒有人可翻譯一下內容 ?
-
- 星球普通子民
- 文章: 26
- 註冊時間: 2004-04-25 09:46
- 來自: 我阿媽個肚!