0)) { //pridavame komentar $comment = form2db($_REQUEST['comment']); $author_id = addslashes($_REQUEST['author_id']); mysql_query("insert into nf_fanart_comment set author_id='$author_id', comment='$comment', date=now(), image_id='$id'") or die("Chyba pri vkladani komentare!"); } } if (!empty($user_id) && (isset($_REQUEST['act']))) { fav_ops($user_id, intval($_REQUEST['author']), $_REQUEST['act']); } $NF_FANART_TABLE = 'nf_fanart'; $NF_FANART_AUTHOR_TABLE = 'nf_fanart_author'; $GALLERY_DIR = 'gallery/'; //FANART: otevira se jako nove okno $_q="SELECT *, UNIX_TIMESTAMP($NF_FANART_TABLE.datum) AS tsdatum, $NF_FANART_TABLE.author_id AS author_id, uzivatel.fanart_name as fname, uzivatel.name as uname, $NF_FANART_TABLE.name as pic_name, predloha AS obkr FROM $NF_FANART_TABLE, uzivatel WHERE $NF_FANART_TABLE.id=$id and uzivatel.id = $NF_FANART_TABLE.author_id"; $vys = MySQL_Query($_q) or die("Chyba: fanart select
"); if (!MySQL_Num_Rows($vys)) { if ($user_id==1) echo "1\n"; exit; } $zaz=MySQL_Fetch_Array($vys); // overit, ze se ma ten obrazek vubec zobrazit - prvni moznost je v soutezi, druha normalni schvaleny obrazek if ( !(( (empty($zaz['publish'])) && (!empty($zaz['join_contest'])) && (!empty($zaz['contest_id'])) && (empty($zaz['approved'])) && (isset($_REQUEST['noc']) || isset($_REQUEST['noh'])) ) ||( ($zaz['publish']>0) && ($zaz['tsdatum']<=time()) && (!empty($zaz['approved']))) ) ) { if ($user_id==1) { echo "2\n"; if ( ($zaz['publish']>0) && ($zaz['tsdatum']<=time()) && (!empty($zaz['approved']))) echo "B"; else echo "A $zaz[tsdatum]:".time()."
\n"; if ( (empty($zaz['publish'])) && (!empty($zaz['join_contest'])) && (!empty($zaz['contest_id'])) && (empty($zaz['approved'])) && (isset($_REQUEST['noc']) || isset($_REQUEST['noh']))) echo "X"; else echo "Y"; echo "
\n"; // print_r($zaz); } echo "Obrázek neexistuje!"; exit; } $_pn = str_replace("\"","'", strip_tags(stripslashes($zaz["name"]))); $_fname = ($zaz['fname']) ? $zaz['fname'] : $zaz['uname']; if ($UI['can_add'] && ($user_id!=$zaz['author_id']) && (intval($_REQUEST['stars']>0))) // hodnoti { $_st=intval($_REQUEST['stars'])%6; $_q="INSERT INTO nf_vote SET user_id='$user_id', image_id='$id', stars='$_st'"; if (!MySQL_Query($_q)) { echo "Nepodařilo se přidat Váš hlas!
\n"; } } ?> <?echo stripslashes($_fname)." - ".stripslashes($zaz["pic_name"]);?>
\"".stripslashes($zaz["pic_name"])."\"";>
(kresleno podle předlohy)\n"; $_qs="select avg(stars) AS prum, COUNT(user_id) AS poc from nf_vote where image_id='$id'"; if ($_rs=MySQL_Query($_qs)) { $_vs=MySQL_Fetch_Array($_rs); } else { echo "Chyba při výpočtu hodnocení!
\n"; } $_vs['prum']=number_format($_vs['prum'], 2, ',', ' '); $_vs['poc']=intval($_vs['poc']); if ($_vs['poc']>0) { $_haveCh = ($_vs['poc']>4)?('ch'):(''); $commentSkore = "Průměrné hodnocení: $_vs[prum] ($_vs[poc] hlasující$_haveCh)"; } else { $commentSkore=''; } ?>
Vyšlo