<?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

<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+1, 

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";

?>