<?php

/*
	NOMEFILE : index.php
	DATA CREAZIONE : 08/09/2007
	AUTORE : TAGLIAVINI DANIELE
	UTILIZZO : Home page di Emi Challenge
*/

require_once "config.inc.php";
require_once $_ROOT.$_HOMEDIR.$_INCLUDEDIR."/login.inc.php";
include      $_ROOT.$_HOMEDIR.$_INCLUDEDIR."/next.class.php";

$_CONTENT    = get_template($_ROOT.$_HOMEDIR.$_MODELDIR."/challenge.html");
$_HTMLTITLE .= "Vota la sfida tra ";

$db = new db_MYSQL;
$id_MYSQL = $db->open($_MYSQL_HOST, $_MYSQL_USER, $_MYSQL_PASS);
if(!$id_MYSQL)
    error_redir("DB_CONNECTION", $_SERVER["PHP_SELF"]);

if(!$db->set_db($_MYSQL_DB, $id_MYSQL))
    error_redir("DB_SELECTION", $_SERVER["PHP_SELF"]);

if(isset($_GET["id"]) && is_numeric($_GET["id"])) {
    $id_challenge = $_GET["id"];
}
else {
    error_redir("DB_SELECTION", $_SERVER["PHP_SELF"]);
}

$query =    "SELECT challenge.*, artist.id_artist, artist.name, video.id_video, video.title_video, video.video, video.picture_video
            FROM challenge
            INNER JOIN video ON (challenge.id_video1=video.id_video OR challenge.id_video2=video.id_video)
            INNER JOIN artist ON video.id_artist=artist.id_artist WHERE (NOW() BETWEEN date_start_challenge AND date_end_challenge) AND id_challenge=$id_challenge AND state_challenge=1";

$result = $db->do_query($query, $id_MYSQL);

if($result === FALSE) {
    error_redir("DB_ERROR_RESULT", $_SERVER["PHP_SELF"], $query);
}

$_UNIQUE = uniqid("hp");

$nvideo = 0;

while($row = $db->get_row($result, MYSQL_ASSOC)) {
    extract($row);
    $nvideo++;
    $_CHALLENGEID        = $id_challenge;
    ${"_VIDEO".$nvideo}  = $_ARTISTDIR."/".getArtistPath($name)."/".$video;
    ${"_IMAGE".$nvideo}  = $_ARTISTDIR."/".getArtistPath($name)."/".$picture_video;
    ${"_TITLE".$nvideo}  = $title_video;
    ${"_ARTIST".$nvideo} = $name;
    ${"_VIDEOID".$nvideo}= $id_video;
    ${"_VOTE".$nvideo}   = 0;
    ${"_VIEW".$nvideo}   = 0;

    $_KEYWORDS[] = $name;


    $queryVoteCount = "SELECT COUNT(*) as COUNT, type FROM stat WHERE id_video=$id_video AND id_challenge=$id_challenge GROUP BY type";
    $resultVoteCount = $db->do_query($queryVoteCount, $id_MYSQL);
    if($resultVoteCount === FALSE) {
            error_redir("DB_ERROR_RESULT", $_SERVER["PHP_SELF"], $queryVoteCount);
    }
    while($rowVoteCount = $db->get_row($resultVoteCount, MYSQL_ASSOC)){
        extract($rowVoteCount);
        ($type==1) ? ${"_VIEW".$nvideo} = $COUNT : ${"_VOTE".$nvideo} = $COUNT;
    }

    /* CONTO I RECORD */
    $COUNT=0;
    $queryCommentCount = "SELECT COUNT(*) as COUNT FROM comment INNER JOIN user ON comment.id_user=user.id_user WHERE comment.id_challenge=$id_challenge AND comment.id_video=$id_video AND comment.state_comment=1 AND user.state=1";

    $resultCommentCount = $db->do_query($queryCommentCount, $id_MYSQL);
    if($resultCommentCount === FALSE) {
            error_redir("DB_ERROR_RESULT", $_SERVER["PHP_SELF"], $queryCommentCount);
    }
    if($row = $db->get_row($resultCommentCount, MYSQL_ASSOC)) {
        $COUNT = $row["COUNT"];
    }

    ${"_COMMENTS".$nvideo}   = $COUNT;
}

$_KEYWORDS = array_unique($_KEYWORDS);
$_KEYWORD  = implode(", ", $_KEYWORDS);

if(!$nvideo) {
    header ("Location: http://".$_SERVERNAME.$_HOMEDIR."/index.php");
    exit;
}

/* CALCOLO PERCENTUALI */
$_TOTVOTI = $_VOTE1 + $_VOTE2;
if(!$_TOTVOTI) {
    $_RATINGS1 = $_RATINGS2 = 50;
}
else {
    $_RATINGS1 = sprintf("%.2f", (($_VOTE1*100) / $_TOTVOTI));
    $_RATINGS2 = sprintf("%.2f", (($_VOTE2*100) / $_TOTVOTI));
}

$_CALLBACK1 = urlencode($_HOMEDIR."/video_callback.php?videoId=$_VIDEOID1&challengeId=$_CHALLENGEID&session=$_UNIQUE");
$_CALLBACK2 = urlencode($_HOMEDIR."/video_callback.php?videoId=$_VIDEOID2&challengeId=$_CHALLENGEID&session=$_UNIQUE");

$_FROM = array ("{MEDIAPLAYER}", "{CHALLENGE_ID}", "{CHALLENGE_URL}",
                "{CALLBACK1}", "{VIDEO_ID1}", "{VIDEO1}", "{IMAGE1}", "{ARTIST_NAME1}", "{VIDEO_TITLE1}", "{VOTE1}", "{COMMENTS1}", "{VIEW1}", "{EMOTICONS1}", "{TIMESTAMP1}",
                "{CALLBACK2}", "{VIDEO_ID2}", "{VIDEO2}", "{IMAGE2}", "{ARTIST_NAME2}", "{VIDEO_TITLE2}", "{VOTE2}", "{COMMENTS2}", "{VIEW2}", "{EMOTICONS2}", "{TIMESTAMP2}", "{SESSION}");

$_TO   =  array($_MEDIAPLAYERDIR, $_CHALLENGEID, urlencode("http://$_SERVERNAME$_HOMEDIR/challenge.php?id=$_CHALLENGEID"),
                $_CALLBACK1, $_VIDEOID1, $_VIDEO1, $_IMAGE1, $_ARTIST1, $_TITLE1, $_RATINGS1, $_COMMENTS1, $_VIEW1, ($_EMOTICONS) ? smile_create(1) : "", "c1".time(),
                $_CALLBACK2, $_VIDEOID2, $_VIDEO2, $_IMAGE2, $_ARTIST2, $_TITLE2, $_RATINGS2, $_COMMENTS2, $_VIEW2, ($_EMOTICONS) ? smile_create(2) : "", "c2".time(), $_UNIQUE);

$_HTMLTITLE .= "$_ARTIST1 e $_ARTIST2.";

$_CONTENT = str_replace($_FROM, $_TO, $_CONTENT);

// CARICO IL FORM DI LOGIN O IL NOME UTENTE
getLoginForm($_CONTENT);

// CARICO I SOCIAL BOOKMARK
//getSocialBookmark($_CONTENT);

// CARICO LA CLASSIFICA
getCharts($_CONTENT);

replaceCommonTag($_CONTENT, false);
include $_ROOT.$_HOMEDIR.$_MODELDIR."/main.php";
?>