function dbcong() { //--[db server]------------------------------------------------------- // adresa db serveru $dbserverg="xxx"; //tvuj db server // uzivatelske informace (user information) $dbuserg="xxx"; //tvoje db user $dbpassg="xxx"; //tvoje db name // jmeno databaze fora $dbnameg="xxx"; //jmeno db s forem $predponagalerie="cpg1410_"; @$spojenig=mysql_connect($dbserverg,$dbuserg,$dbpassg); if (!$spojenig): die('Spojeni se serverem nelze vytvorit! / Could not connect to database server!'); endif; mysql_select_db($dbnameg,$spojenig); return $spojenig; } $dbspojenig=dbcong(); //pripadne spojeni s db $GLOBALS["dbspojenig"]=&$dbspojenig; //jako global $GLOBALS["predponagalerie"]=&$predponagalerie; //jako global mysql_query("SET NAMES utf-8",$GLOBALS["dbspojenig"]); //propojeni s kodovanim WIN function UkazObrazek() { $jaky_obrazek=mysql_query("SELECT "); $rozdel=explode("_",$GLOBALS["vzhledwebu"]->AktBlokNazev()); $nazev_bloku=$rozdel[1]; if($rozdel[0]!="nahodny" and $rozdel[0]!="nejnovejsi" and $rozdel[0]!="nejgal"): $rozdel[0]="nahodny"; $rozdel[1]="Název bloku"; endif; switch($rozdel[0]): case "nahodny": $podminka="ORDER BY RAND() LIMIT 1"; break; case "nejnovejsi": $podminka="ORDER BY RAND() LIMIT 1"; break; case "nejgal": $podminka="ORDER BY RAND() LIMIT 1"; break; // case "nejhodnoceny": break; endswitch; $sql = "SELECT * FROM cpg1410_pictures ".$podminka; $obrazek=mysql_query($sql,$GLOBALS["dbspojenig"]); if (!obrazek) echo "DB ERROR IN QUERY: $sql"; $obr_pid=$obrazek["pictures_pid"]; $obr_width=$obrazek["pictures_pwidth"]; $obr_height=$obrazek["pictures_pheight"]; $obr_popis=$obrazek["pictures_caption"]; $obr_titulek=$obrazek["pictures_title"]; $obr_zobrazeni=$obrazek["pictures_hits"]; $obr_slozka=$obrazek["pictures_filepath"]; $obr_jmeno=$obrazek["pictures_filename"]; $obr_zobrazeni=$obrazek["pictures_hits"]; $obrazek="<div class=\"blokgalnad\"></div>"; $obrazek.="<div class=\"blokgal\"><a title=\"\" onclick=\"window.open('http://fotogalerie.rozsec.cz/displayimage.php?album=random&cat=0&pos=-".$obr_pid."','_blank','toolbar=yes,menubar=yes,scrollbars=yes,resizable=yes,location=yes'); return false\" href=\"http://fotogalerie.rozsec.cz/displayimage.php?album=random&cat=0&pos=-".$obr_pid."\"><img style=\"border: 1px solid #000000;\" width=\"".$obr_width."\" height=\"".$obr_height."\" src=\"http://fotogalerie.rozsec.cz/albums/".$obrazek_slozka."nahled_".$obrazek_jmeno."\" alt=\"\" title=\"\"></a></div>"; echo mysql_error(); switch ($GLOBALS["vzhledwebu"]->AktBlokTyp()): case 1: Blok1($nazev_bloku,$obrazek); break; case 2: Blok2($nazev_bloku,$obrazek); break; case 3: Blok3($nazev_bloku,$obrazek); break; case 4: Blok4($nazev_bloku,$obrazek); break; case 5: Blok5($nazev_bloku,$obrazek); break; case 6: Blok6($nazev_bloku,$obrazek); break; default: Blok1($nazev_bloku,$obrazek); break; endswitch; $dbspojeni=phprs_sql_dbcon();
$jaky_obrazek=mysql_query("SELECT ");
and media_gallery_id='28'..
select cpg1410_pictures.pid, cpg1410_pictures.filepath, cpg1410_pictures.filename, cpg1410_pictures.hits, cpg1410_pictures.votes as hodnoceni, cpg1410_albums.title , cpg1410_albums.description from cpg1410_pictures, cpg1410_albums where cpg1410_pictures.aid = cpg1410_albums.aid and aid='5' ORDER BY RAND() LIMIT 1tak to vypíše hlášku