require "connect.php3";
$id = addslashes($_REQUEST['id']);
/*
require_once("diskuse/tblsetup.php");
//brrr, autentikace.... ;((
if (md5("$user_id[id]".HKLIC)==$user_id["k"])
$user_id=$user_id["id"];
else
unset($user_id);
*/
require_once("user_auth.php");
update_cookie();
require_once("gallery_com.php");
function dateFormat($date) {
return EReg_Replace("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", "\\3.\\2.\\1, \\4:\\5", $date);
}
if(!empty($user_id)) {
$qw_user = mysql_query("select * from uzivatel where id = '$user_id'") or die("Chyba pri selekci uzivatele!");
$res_user = mysql_fetch_array($qw_user);
if($_REQUEST['comment'] && $res_user['can_add'] && (strlen($_REQUEST['comment'])>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 "
> |
if ($zaz['obkr'])
echo " (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=''; } ?>
if (is_favourite($user_id, $zaz['author_id']))
{
echo "Odebrat z oblíbených\n";
}
else
{
echo "Přidat k oblíbeným\n";
}
?>
if ( (!empty($user_id)) && (($zaz['author_id']==$user_id) || ($UI['msgs'] & 2) || ($user_id==1)) && !empty($zaz['approved']) ) { ?>
} ?>
if ((!empty($user_id)) && (!empty($UI['can_add']))) { ?>
} ?>
|
if ((!isset($_REQUEST['noh'])) && (!isset($_REQUEST['noc']))):?> Vyšlo |