Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function galeria($album)
- {
- $ile = 3;
- if(!$album OR $album=="") $q = "SELECT distinct id, header, id_album FROM malta_gallery where id_album=(SELECT distinct id FROM `malta_albums` ORDER BY date DESC limit 1) ORDER BY RAND() limit 6;";
- if($album AND $album!="" AND $album!="all") $q = "SELECT * FROM malta_gallery where id_album=".$album." order by date asc";
- if($album=="all")
- {
- $ile = 6;
- $q = "SELECT m.id id_album, n.id id, n.header header, n.date date FROM malta_albums m LEFT JOIN malta_gallery n ON n.id_album = m.id GROUP BY m.id;";
- }
- $r = mysql_query($q);
- if ( $r !== false && mysql_num_rows($r) > 0 )
- {
- $j = 0;
- while ( $a = mysql_fetch_assoc($r) ) {
- $j++;
- $title = stripslashes($a['header']);
- $date = $a['date'];
- $file = $a['id'].".jpg";
- $id_album = $a['id_album'];
- $katalog = './albums/'.$id_album.'/';
- // if(!is_file( $katalog."mini/".$file))
- // {
- // $src= $katalog.$file;
- // $wydruk=$katalog."mini/".$file;
- /// $this->createThumb($src,$wydruk);
- // }
- if($album=="all")
- {
- $wyjscie .= ("<a title=\"".$title."\" href=\"galeria,test,".$id_album."\"><img class='galeria_img' src=\"".$katalog."mini/".$file."\" border=\"1\"></a>");
- }
- else
- {
- $wyjscie .= ("<a rel=\"gb_imageset[nowosci]\" title=\"".$title."\" href=\"".$katalog.$file."\"><img class='galeria_img' src=\"".$katalog."mini/".$file."\" border=\"1\"></a>");
- }
- if ($j%$ile==0) { $wyjscie .= "<br>";}
- }
- }
- /*
- $katalog = './albums/'.$album.'/';
- $i = 1;
- if ($handle = opendir($katalog))
- {
- while (false !== ($file = readdir($handle)))
- {
- if ($file != "." && $file != ".." && $file!="mini")
- {
- $tablica[$i] = $file;
- $i++;
- }
- }
- closedir($handle);
- }
- for ($j=($ktora*20)-1;$j<(($ktora*20)+21);$j++)
- {
- $file = $tablica[$j];
- if($tablica[$j]!=""){
- if(!is_file( $katalog."mini/".$file))
- {
- $src= $katalog.$file;
- $wydruk=$katalog."mini/".$file;
- $this->createThumb($src,$wydruk);
- }
- $wyjscie .= ("<a rel=\"gb_imageset[nowosci]\" title=\"$j. $file\" href=\"".$katalog.$file."\"><img class='galeria_img' src=\"".$katalog."mini/".$file."\" border=\"1\"></a>");
- if ($j%3==0) { $wyjscie .= "<br>";}
- }
- }
- */
- return $wyjscie;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement