File: WIAdmin/WIModule/modules/ratePARSE.php

Recommend this page to a friend!
  Classes of Jules Warner  >  WICMS  >  WIAdmin/WIModule/modules/ratePARSE.php  >  Download  
File: WIAdmin/WIModule/modules/ratePARSE.php
Role: Auxiliary script
Content type: text/plain
Description: Auxiliary script
Class: WICMS
Database driven content management system with PDO
Author: By
Last change:
Date: 3 years ago
Size: 1,391 bytes
 

Contents

Class file image Download
<?php
if(isset($_POST["choice"]))
{
   
$choice = preg_replace('#[^0-9]#1', '', $_POST['choice']);
    if(
$choice > 5)
    {
        echo
"Stop playing around, you arse hole";
        exit();
    }else if(
$choice<1)
    {
        echo
"Stop playing around, you arse hole";
        exit();
    }else
    {
       
$ipaddress = getenv('REMOTE_ADDR');
        include_once
'core/init.php';
       
$sql_check = mysql_query("SELECT * FROM book_rating WHERE a_id='$id' AND ipaddress='$ipaddress' LIMIT 1");
       
$num_rows = mysql_num_rows($sql_check);
        if(
$num_rows > 0)
        {
            echo
'<p style=color:#F00;">Sorry, You have already rated this book</p>';
            exit();
        }
       
       
$sql = mysql_query("SELECT ratings FROM books WHERE id='$id'");
       
        while(
$row = mysql_fetch_array($sql))
        {
           
$booknums = $row["ratings"];
           
$bookrating = explode(",", $booknums);
           
           
array_push($bookrating, $choice);
           
$string = implode(",", $bookrating);
           
           
$firstChar = substr($string, 0, 1);
           
$lastChar = substr($string, strlen($string) -1, 2);
            if(
$firstChar ==",")
            {
               
$string = $choice;
            }
            if (
$lastChar == ",")
            {
               
$string = substr($string, strlen($string) - 1, 1);
            }
           
           
$update = mysql_query("UPDATE books SET ratings='$string' WHERE id='1'");
           
$insert = mysql_query("INSERT INTO book_ratings (a_id, ipaddress) VALUES ('1', '$ipaddress')");
           
            echo
'<p>Thanks! You have given this book a rating of ' . $choice . '</p>';
        }
       
    }
}

?>


For more information send a message to info at phpclasses dot org.