"; echo "
"; //if ($urlID=="") { echo ""; echo ""; //} echo ""; echo ""; //} echo "
Get Flash to see this player.
Etusivu Piia-Noora Mepin työ Kalenteri Kuvagalleria Tiimi Yhteystiedot
Kuvagalleria
Kansalaisten perusoikeuskirjan hyväksymisen kunniaksi järjestetyissä EPP-ryhmän juhlallisuuksissa
Lehdistökuvat
Mielenkiintoisia henkilöitä vuosien varrelta
Tilaisuuksia parlamentissa
Vapaalla
lang_active; //$galsprak = 'ger'; $address="?tocID=$tocID&slideshow=".$_REQUEST['slideshow']; $address="?tocID={$this->tocID}"; //echo _LANG_; ################################################## # Generella konfigs och funktioner include(".inc/PhPicture_config.php"); ?> "; echo "
"; if ($urlID!="") { $id=$urlID; //$sql="select imgID, imgNamn, date_format(imgDatum,'%d.%m.%Y %H:%i') AS idat, imgText, imgKat1, imgFil from $dbtable WHERE (imgID=$id) ORDER BY imgDatum ASC"; $sql="select $dbtable.nID, $dbtablelang.nlHeading, date_format($dbtable.nDatum,'%d.%m.%Y %H:%i') AS idat, $dbtablelang.nlText, $dbtable.nPicture, $dbtable.nSort from $dbtable, $dbtablelang WHERE ( $dbtable.nID='$id' AND $dbtable.nID=$dbtablelang.nID AND $dbtablelang.nlLang='$galsprak' ) ORDER BY $dbtable.nID ASC"; //echo $sql; $result=$this->db_query($sql,$db) or die("PICTURE NOT FOUND IN DATABASE!!!"); $count=0; while($myrow=MySQL_fetch_array($result)) { $id=$myrow["nID"]; $fil=$myrow["nPicture"]; $name=html_entity_decode($this->unicode_to_entities_preserving_ascii($this->utf8_to_unicode($myrow["nlHeading"])),ENT_NOQUOTES,"ISO-8859-15"); $datum=$myrow["idat"]; $description=$myrow["nlText"]; $sort=$myrow["nSort"]; //$markkat=$myrow["ncID"]; $markkat=$kat; $size = getimagesize("$path/gallery/$fil"); //echo $markkat."
"; } if ($kat=="0" || $kat=="") { $ss="WHERE $dbtable.nID=$dbtablelang.nID AND $dbtablelang.nlLang='$galsprak'"; $kat=0; } else { $ss=", $dbtabletocat WHERE $dbtable.nID=$dbtablelang.nID AND $dbtablelang.nlLang='$galsprak' AND $dbtable.nID=$dbtabletocat.nID AND $dbtabletocat.ncID=".$kat ; } $sql="SELECT * FROM $dbtable, $dbtablelang $ss ORDER by $dbtable.nSort ASC, $dbtable.nID asc"; //echo $sql; $result=$this->db_query($sql,$db) or die("PICTURE NOT FOUND IN DATABASE!!!"); $count=0; $prevID_tmp=0; while($myrow=MySQL_fetch_array($result)) { if (isset($prevID2)) $nextID=$myrow["nID"]; unset($prevID2); if ($myrow["nID"]==$id) { $prevID=$prevID_tmp; $prevID2=$prevID_tmp; } $prevID_tmp=$myrow["nID"]; //echo $myrow["nID"] .", "; //echo $prevID .", "; $count++; } if ($nextID==$id) $nextID=0; if ($prevID==$id) $prevID=0; //echo $prevID ." - ".$nextID; } //$gals = $this->gallery_maketree($catid,"SELECT katID,katPaID,katLangNamn,katText,katNamnFin,katTextFin FROM gallerykat,gallerykat_lang where katID=katLangPaID AND katLangSprak='$galsprak' AND katLangNamn <> '' order by katPaID",$maxlevel); $gals = $this->gallery_maketree($catid,"SELECT $dbtablecat.ncID, $dbtablecat.ncParent, $dbtablecatlang.nclName FROM $dbtablecat, $dbtablecatlang WHERE $dbtablecat.ncID=$dbtablecatlang.ncID AND $dbtablecatlang.nclLang='$galsprak' AND $dbtablecatlang.nclName<>'' ORDER BY $dbtablecat.ncParent",$maxlevel); $this->gk[0]=ALLA; //echo "

".$this->gk[$kat]."


"; ?>
 "; if ($urlID!="") { echo ' '; echo $name.""; } elseif ($kat!="") { echo ' '; echo $this->gk[$kat].""; } if ($kat>0 && $kat!="") { echo "  |  "; //echo BILD ." ". $outputVars["currentPos"] . " / ".$outputVars["total"]."  "; if ($_REQUEST['slideshow']=='play') { if ($outputVars["action"]=="end") { echo BILD ." ". $outputVars["currentPos"] . " / ".$outputVars["total"]."  "; echo ''.REPLAY.' '.SLIDESHOW.''; } else { echo BILD ." ". $outputVars["currentPos"] . " / ".$outputVars["total"]."  "; echo ''.PAUSE.' '.SLIDESHOW.''; } } else { echo ''.PLAY.' '.SLIDESHOW.''; } } echo " "; //if ($antal[$kat]>1) echo $antal[$kat]." ".BILDER; ################################################ # Kategorilista echo ""; echo "

"; if ($urlID!="") { ?>
style="background-color:darkgray;width:px;height:px;"> alt="">
unicode_to_entities_preserving_ascii($this->utf8_to_unicode($description)),ENT_NOQUOTES,"ISO-8859-15")); ?>

db_query($sql,$db); $total=mysql_num_rows($result); $myrow=MySQL_fetch_array($result); //$sql2="SELECT imgID FROM gallery WHERE imgKat1=$markkat AND imgID > $id AND imgSprak='$galsprak' ORDER BY imgID asc LIMIT 1"; $sql2="SELECT $dbtable.nID FROM $dbtable, $dbtabletocat, $dbtablelang WHERE $dbtable.nID=$dbtabletocat.nID AND $dbtabletocat.ncID='$markkat' AND $dbtable.nID>$id AND $dbtablelang.nlLang='$galsprak' AND $dbtable.nID=$dbtablelang.nID ORDER BY $dbtable.nSort ASC, $dbtable.nID asc LIMIT 1"; $result2=$this->db_query($sql2,$db); $total2=mysql_num_rows($result2); $myrow2=MySQL_fetch_array($result2); $n=$myrow["nID"]; $f=$myrow2["nID"]; echo ""; if ($markkat!="") { echo ""; } else { echo ""; } echo "
"; if ($prevID > 0) { echo "« ".FÖREGÅENDE_BILD.""; } else { echo "« ".FÖREGÅENDE_BILD.""; } echo "".KATEGORI.": ".$this->gk[$markkat]." "; if ($nextID > 0) { echo "".NÄSTA_BILD." »"; } else { echo "".NÄSTA_BILD." »"; } echo "
"; ?>



".VÄLJ_KATEGORI."...

"; $sql="SELECT count($dbtable.nID) AS antal FROM $dbtable, $dbtablelang WHERE $dbtable.nID=$dbtablelang.nID AND $dbtablelang.nlLang='$galsprak'"; $result=$this->db_query($sql,$db); $myrow=MySQL_fetch_array($result); echo sprintf(BILDER_I_GALLERIET,"".$myrow['antal'].""); echo "

 "; echo SENAST_TILLAGDA; $sql="SELECT $dbtable.nID FROM $dbtable, $dbtablelang WHERE $dbtable.nID=$dbtablelang.nID AND $dbtablelang.nlLang='$galsprak' ORDER BY $dbtable.nDatum DESC LIMIT 1"; $result=$this->db_query($sql,$db); $myrow=MySQL_fetch_array($result); $id=$myrow['nID']; if (!isset($id)) { $id == 1; } $storlek = @getimagesize($path."/images/gallery/$id.jpg"); echo "

"; echo "
"; } else { $visa=$grans; if ($_GET["lista"]=="") { $lista=0; } else { $lista= $_GET["lista"]; } if ($kat=="0") { $ss="WHERE $dbtable.nID=$dbtablelang.nID AND $dbtablelang.nlLang='$galsprak'"; $kat=0; } else { $ss=", $dbtabletocat WHERE $dbtable.nID=$dbtablelang.nID AND $dbtablelang.nlLang='$galsprak' AND $dbtable.nID=$dbtabletocat.nID AND $dbtabletocat.ncID=".$kat ; } $sql="SELECT * FROM $dbtable, $dbtablelang $ss ORDER by $dbtable.nSort ASC, $dbtable.nID asc LIMIT $lista,$visa"; $result=$this->db_query($sql,$db); $i=0; echo ""; echo ""; echo "
"; while($myrow=MySQL_fetch_array($result)) { $id=$myrow['nID']; $kat=$myrow['ncID']; if ($kat=="") $kat=0; $storlek = @getimagesize($path."/images/gallery/$id.jpg"); echo ""; $i++; $r++; if ($i==$cols) { echo "
"; $i=0; } } echo "
"; $sql="SELECT $dbtable.nID FROM $dbtable, $dbtablelang $ss"; $result=$this->db_query($sql,$db); $total=mysql_num_rows($result); if ($_GET["lista"]!="") { $list=$_GET["lista"]; } else { $list=$_GET["lista"]; } $n=$lista+$visa; $f=$lista-$visa; echo "

"; if ($f >= 0) { echo "« ".FÖREGÅENDE_SIDA.""; } else { echo "« ".FÖREGÅENDE_SIDA.""; } echo " "; if ($n < $total) { echo "".NÄSTA_SIDA." »"; } else { echo "".NÄSTA_SIDA." »"; } echo "
"; } } ?>

© Piia-Noora Kauppi 2020-2021
Powered by: Creamarketing WebAdmin Kokoomusmepit
KokoomusEPP-ED