session_start();
include("includes/config.php");
$pid=$_GET['pid'];
if($_POST['rate'])
{
$catid=$_POST['id'];
$h_preid=$catid;
$newvot=$_POST['vote'];
for($loop=10;$loop<=100;$loop+=5)
{
if(($loop/10) == $newvot)
{
$v = "vote$loop";
$$v = 1;
}
else
{
$v = "vote$loop";
$$v = 0;
}
}
$sqlpre = "select rte_votes,rte_value from ratings where rte_userid ='$h_preid'";
$row = mysql_query($sqlpre);
$n = mysql_num_rows($row);
if($n==1)
{
$rs = mysql_fetch_array($row);
$vot = $rs['rte_votes'] + 1;
$val = $rs['rte_value'] + $newvot;
$avg = $val/$vot;
$sqlup = "update ratings set
rte_votes=$vot,rte_value=$val,rte_average=$avg,
vote10=vote10+$vote10,
vote15=vote15+$vote15,
vote20=vote20+$vote20,
vote25=vote25+$vote25,
vote30=vote30+$vote30,
vote35=vote35+$vote35,
vote40=vote40+$vote40,
vote45=vote45+$vote45,
vote50=vote50+$vote50,
vote55=vote55+$vote55,
vote60=vote60+$vote60,
vote65=vote65+$vote65,
vote70=vote70+$vote70,
vote75=vote75+$vote75,
vote80=vote80+$vote80,
vote85=vote85+$vote85,
vote90=vote90+$vote90,
vote95=vote95+$vote95,
vote100=vote100+$vote100
where rte_userid ='$h_preid'";
$row = mysql_query($sqlup);
}
else
{
$sqlins = "insert into ratings
(rte_userid,rte_votes,rte_value,rte_average,vote10,vote15,vote20,vote25,vote30,vote35,vote40,vote45,vote50,vote55,vote60,vote65,vote70,vote75,vote80,vote85,vote90,vote95,vote100)
values
('$h_preid',1,$newvot,$newvot,$vote10,$vote15,$vote20,$vote25,$vote30,$vote35,$vote40,$vote45,$vote50,$vote55,$vote60,$vote65,$vote70,$vote75,$vote80,$vote85,$vote90,$vote95,$vote100)";
mysql_query($sqlins);
}
}
mysql_query("update poetry set views=views+1 where id='$pid'");
$sql="select * from poetry where id='$pid'";
$row=mysql_fetch_array(mysql_query($sql));
include("templates/header.php");
?>
include("templates/leftbar.php");?> |
|
Total Views:
|
$rat=mysql_fetch_array(mysql_query("select * from ratings where rte_userid='$pid'"));
?>
Rating:
if($rat[rte_average]=="") echo "0"; else echo $rat[rte_average];?>
|
This Poetry has been rated
if($rat[rte_votes]=="") echo "0"; else echo $rat[rte_votes];?>
times |
|
|
|
Poem Title: |
|
$c=mysql_fetch_array(mysql_query("select * from categories where catid='$row[catid]'"));
?>
Poem Category: |
|
Poet: |
|
$sql=mysql_fetch_array(mysql_query("select * from poet where poetname='$row[poet]'"));
if($sql[description]!="")
{
?>
Poet Biography: |
|
}
$m=mysql_fetch_array(mysql_query("select * from ads where name='middle'"));
?>
echo $m[code]; ?>
|
Poem: |
|
|
|
include("templates/rightbar.php");?> |
include("templates/footer.php"); ?>