<?php
require_once "../../maincore.php";
require_once THEMES."templates/header.php";

if($userdata['user_id']==1){
error_reporting(E_ALL ^ E_NOTICE);
}

if(!iMEMBER){redirect(BASEDIR."index.php");}

if(isset($_GET['veiksmas']) && $_GET['veiksmas'] == 'balsuoti' && isnum($_POST['song_id'])){
$daina = stripinput($_POST['song_id']);

$sql = dbquery("SELECT vote_artist, vote_user FROM ".$db_prefix."charts_votes WHERE vote_artist='$daina' ");
$rez = dbarray($sql);

if($rez['vote_user'] != $userdata['user_id']){
opentable("Balsuojam");
echo "
<table style='border: 1px solid #663333;' align='center'><tr><td colspan='2' style='border: 1px solid #663333;'>
<form action='".FUSION_SELF."?veiksmas=ivertinti&daina_id=".$daina."' method='POST' name='reitingavimas' style='font-size: 13px; margin:0px;'>
<input name='rate' type='radio' value='1'>1
<input name='rate' type='radio' value='2'>2
<input name='rate' type='radio' value='3'>3
<input name='rate' type='radio' value='4'>4
<input name='rate' type='radio' value='5'>5
<input name='rate' type='radio' value='6'>6
<input name='rate' type='radio' value='7'>7
<input name='rate' type='radio' value='8'>8
<input name='rate' type='radio' value='9'>9
<input name='rate' type='radio' value='10'>10
<center><input type='submit' name='submit' value='Vertinti' style='border: 1px solid #663333; cursor: pointer; align:center; width: 100%;'></center>

</form></td></tr>
</table>";
closetable();
}else{
opentable("Klaida");
echo "Jau balsavai";
closetable();
}
}
if(isset($_GET['veiksmas']) && $_GET['veiksmas'] == 'ivertinti' && isnum($_GET['daina_id']) && isnum($_POST['rate'])){
$result3 = dbquery("SELECT * FROM ".$db_prefix."charts WHERE id = '".$_GET['daina_id']."' ");
$rezas = dbarray($result3);


$n_reitingas = (int)$_POST['rate']+$rezas['reitingas'];
$daina = stripinput($_GET['daina_id']);

$result1 = dbquery("UPDATE ".$db_prefix."charts SET vote = vote+ $n_reitingas, 
reitingas = '$n_reitingas' 
WHERE id = '$daina' LIMIT 1 ;");
$result4 = dbquery("INSERT INTO ".$db_prefix."charts_votes (vote_id,vote_artist,vote_user) VALUES ('','$daina','".$userdata['user_id']."')");
redirect(INFUSIONS."song_charts/charts.php");
}

require_once THEMES."templates/footer.php";
?>