This is the community forum. For a developer response use the Client Area.
Follow us on Facebook, Twitter and YouTube!

New user question on extracting rating with stars
#1

Hi
I used to use this script to display stars but it no longer works.(this is from commentics1.7)
I uploaded: upload/comments/includes/db/connect.php
<?php
define ('IN_COMMENTICS', '1');
require "upload/comments/includes/db/connect.php";
/*custom_id = page name */

$query = mysql_query("SELECT id FROM `".$mysql_table_prefix."pages` WHERE custom_id = 'Page Four'");
$result = mysql_fetch_assoc($query);
$id = $result["id"];

$query = mysql_query("SELECT MAX(rating) AS highest_rating FROM `".$mysql_table_prefix."comments` WHERE is_approved = '1' AND page_id = '$id'");
$result = mysql_fetch_assoc($query);
$highest_rating = $result["highest_rating"];


switch ($highest_rating) {
case 0:
echo "It's waiting for a star rating";
break;
case 1:
echo "Best score so far";

echo "&nbsp;&nbsp;";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_half.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
break;
case 2:
echo "Best score so far";
echo "&nbsp;&nbsp;";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
break;
case 2.5:
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_half.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
break;
case 3:
echo "Best score so far";
echo "&nbsp;&nbsp;";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
break;
case 3.5:
echo "Best score so far";
echo "&nbsp;&nbsp;";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_half.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
break;
case 4:
echo "Best score so far";
echo "&nbsp;&nbsp;";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_empty.png'/>";
break;
case 4.5:
echo "Best score so far";
echo "&nbsp;&nbsp;";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_half.png'/>";
break;
case 5:
echo "Best score so far";
echo "&nbsp;&nbsp;";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";
echo "<img src='//comments/images/stars/star_full.png'/>";

break;
}

?>

Any help welcome
Thanks
Reply
#2

Which version of Commentics are you currently using?

Have you completed the interview?
Reply
#3

Just installed  4
thanks
Reply
#4

Hi
here is what page shows

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/vhosts/tryblog.eu5.org/example4score.php on line 22

It's waiting for a star rating

line22
$result = mysql_fetch_assoc($query);

Thanks
Reply
#5

Try changing 'custom_id' to 'identifier'.

Also in v4.0 Commentics uses font awesome instead of images for the stars, so for your above code to work properly you'll have to copy over those images from your v1.7 installation and place them at the src location so it finds them.

Have you completed the interview?
Reply
#6

Hi Steven
That worked
thanks
Sue
Reply


Possibly Related Threads…
Thread / Author Replies Views Last Post
Last Post by Seven Thunders
20-Jun-2019, 03:56 AM
Last Post by Seven Thunders
21-Aug-2018, 04:05 AM
Last Post by ruslan58
20-Sep-2016, 06:28 AM
Last Post by cecilia
15-Jun-2014, 01:08 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)