<?php

/*
    NOMEFILE : index.php
    DATA CREAZIONE : 08/09/2007
    AUTORE : TAGLIAVINI DANIELE
    UTILIZZO : Home page di Emi Challenge
*/

require_once "config.inc.php";

$_CONTENT    = get_template($_ROOT.$_HOMEDIR.$_MODELDIR."/home.html");
$_HTMLTITLE .= "Il portale dei tuoi video preferiti!";

$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"]);

$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 special>0 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");

$_IMAGE1VIDEO = $_IMAGEDIR."/white.gif";

while($row = $db->get_row($result, MYSQL_ASSOC)) {
    extract($row);

    $_CHALLENGEID= $id_challenge;

    $title_video = htmlentities($title_video);
    $name = htmlentities($name);
    // VIDEO DELLA SETTIMANA
    if($special==$id_video) {
        $_VIDEO1_30SEC = str_replace(".flv", "_30.flv", $_ARTISTDIR."/".getArtistPath($name)."/".$video);
        if($_INTROVIDEO) {
            $_VIDEO1 = $_ARTISTDIR."/intro/intro_ilovethisvideo.flv";
            $_IMAGE1VIDEO = $_ARTISTDIR."/intro/intro.jpg";
        }
        else if(file_exists($_HOMEDIR.$_VIDEO1_30SEC)) {
            $_VIDEO1 = $_VIDEO1_30SEC;
        }
        else {
            $_VIDEO1 = $_ARTISTDIR."/".getArtistPath($name)."/".$video;
        }

        $_IMAGE1 = $_ARTISTDIR."/".getArtistPath($name)."/".$picture_video;
        $_TITLE1  = $title_video;
        $_ARTIST1 = $name;
        $_VIDEOID = $id_video;
    }
    // VIDEO IN SFIDA
    else {
        $_IMAGE2  = $_ARTISTDIR."/".getArtistPath($name)."/".$picture_video;
        $_TITLE2  = $title_video;
        $_ARTIST2 = $name;
    }
    $_KEYWORDS[] = $name;
    $_LINK_SFIDA  = "id=$id_challenge";
}
// PRIME SOSTITUZIONI NEL TEMPLATE

$_CALLBACK = urlencode("$_HOMEDIR/video_callback.php?videoId=$_VIDEOID&challengeId=$id_challenge&session=$_UNIQUE");

$_FROM = array("{MEDIAPLAYER}", "{VIDEO_ID}", "{CHALLENGE_ID}", "{VIDEO1}", "{IMAGE1}", "{IMAGE1VIDEO}", "{ARTIST_NAME1}", "{VIDEO_TITLE1}", "{IMAGE2}", "{ARTIST_NAME2}", "{VIDEO_TITLE2}", "{LINK_SFIDA}", "{CALLBACK}", "{AUTOSTART}");
$_TO = array($_MEDIAPLAYERDIR, $_VIDEOID, $_CHALLENGEID, $_VIDEO1, $_IMAGE1, $_IMAGE1VIDEO, $_ARTIST1, $_TITLE1, $_IMAGE2, $_ARTIST2, $_TITLE2, $_LINK_SFIDA, $_CALLBACK, isset($_SESSION["user_login"]) ? "false" : "true");
$_CONTENT = str_replace($_FROM, $_TO, $_CONTENT);

$_LIMIT = isset($_GET["all"]) ? "" : "LIMIT 20";
/* ELENCO DELLE ALTRE SFIDE */
$querySfide = "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 special=0 AND state_challenge=1 ORDER BY date_start_challenge DESC, id_challenge $_LIMIT";
$resultSfide = $db->do_query($querySfide, $id_MYSQL);

if($resultSfide === FALSE) {
    error_redir("DB_ERROR_RESULT", $_SERVER["PHP_SELF"], $querySfide);
}

$riga=0;
$_TMP = $_TO1 = array();
while($rowSfide = $db->get_row($resultSfide, MYSQL_ASSOC)) {
    extract($rowSfide);

    $id_videoTmp = ($id_video1==$id_video) ? $id_video1 : $id_video2;
    $queryVoti = "SELECT COUNT(*) as COUNT, type FROM stat WHERE id_challenge=$id_challenge AND id_video=$id_videoTmp GROUP BY type";
    $resultVoti = $db->do_query($queryVoti, $id_MYSQL);

    if($resultVoti === FALSE) {
        error_redir("DB_ERROR_RESULT", $_SERVER["PHP_SELF"], $queryVoti);
    }

    // INIZIALIZZO LE VARIABILI A 0
    $_VIEW[$id_videoTmp] = $_VOTE[$id_videoTmp] = 0;

    while($rowVoti = $db->get_row($resultVoti, MYSQL_ASSOC)) {
        extract($rowVoti);
        ($type==1) ? $_VIEW[$id_videoTmp] = $COUNT : $_VOTE[$id_videoTmp] = $COUNT;
    }
    $_TMP[$id_challenge][$id_videoTmp] = array($_ARTISTDIR."/".getArtistPath($name)."/".$picture_video, $name, $title_video, $_VOTE[$id_videoTmp], $_VIEW[$id_videoTmp]);

    $_KEYWORDS[] = $name;
}

$_KEYWORDS = array_unique($_KEYWORDS);
$_KEYWORD  = implode(", ", $_KEYWORDS);

//var_export($_TO);
preg_match("'<ELENCO_SFIDE>(.*)</ELENCO_SFIDE>'s", $_CONTENT, $RIGA_SFIDE);
$_ELENCO = "";
$_FROM = array("{IMAGE_SFIDA1}", "{SFIDA_ARTIST_NAME1}", "{SFIDA_VIDEO_TITLE1}", "{VOTE1}", "{VIEW1}", "{IMAGE_SFIDA2}", "{SFIDA_ARTIST_NAME2}", "{SFIDA_VIDEO_TITLE2}", "{VOTE2}", "{VIEW2}", "{SFIDA_LINK_SFIDA}", "{ROW}");

foreach($_TMP as $id_challenge=>$detailsVideo) {
    $videoIdArray = array_keys($detailsVideo);

    $_TOTVOTI = $detailsVideo[$videoIdArray[0]][3] + $detailsVideo[$videoIdArray[1]][3];
    if(!$_TOTVOTI) {
        $_RATINGS1 = $_RATINGS2 = "50.00 %";
    }
    else {
        $_RATINGS1 = sprintf("%.2f %%", (($detailsVideo[$videoIdArray[0]][3]*100) / $_TOTVOTI));
        $_RATINGS2 = sprintf("%.2f %%", (($detailsVideo[$videoIdArray[1]][3]*100) / $_TOTVOTI));
    }

    if($detailsVideo[$videoIdArray[0]][3]>$detailsVideo[$videoIdArray[1]][3]) {
        $_TO1 = array($detailsVideo[$videoIdArray[0]][0], $detailsVideo[$videoIdArray[0]][1], $detailsVideo[$videoIdArray[0]][2], $_RATINGS1, $detailsVideo[$videoIdArray[0]][4], $detailsVideo[$videoIdArray[1]][0], $detailsVideo[$videoIdArray[1]][1], $detailsVideo[$videoIdArray[1]][2], $_RATINGS2, $detailsVideo[$videoIdArray[1]][4], "id=$id_challenge", $id_challenge);
    }
    else {
        $_TO1 = array($detailsVideo[$videoIdArray[1]][0], $detailsVideo[$videoIdArray[1]][1], $detailsVideo[$videoIdArray[1]][2], $_RATINGS2, $detailsVideo[$videoIdArray[1]][4], $detailsVideo[$videoIdArray[0]][0], $detailsVideo[$videoIdArray[0]][1], $detailsVideo[$videoIdArray[0]][2], $_RATINGS1, $detailsVideo[$videoIdArray[0]][4], "id=$id_challenge", $id_challenge);
    }

    $_ELENCO .= str_replace($_FROM, $_TO1, $RIGA_SFIDE[1]);
    $_TO1 = array();
}

$_CONTENT = preg_replace("'<ELENCO_SFIDE>(.*)</ELENCO_SFIDE>'s", $_ELENCO, $_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";
?>