Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [jdgamble] ajax rating system

Quote Reply
Re: [jdgamble] ajax rating system In reply to
Everytime I think everything is working fine, I find something new that is a problem.

Here is my lasted global:

Code:
sub {
use Links qw/$DB/;
my ($id, $static) = @_;
my $db = $DB->table("Links");
my $results = $db->select({ID => $id})->fetchrow_hashref();
my $units = 5;
my $rating_unitwidth = 30;
my $ip = $ENV{REMOTE_ADDR};
my $count = $results->{Votes};
$count = 0 if $count < 1;
my $current_rating = $results->{Rating};

my $tense = ($count == 1) ? "vote" : "votes";
my $condition = GT::SQL::Condition->new('used_ips', 'LIKE', '%'.$ip.'%');
my $sth = $db->select(['used_ips'], $condition, {ID => $id}) or die $GT::SQL::error;
my $voted = $sth->fetchrow_hashref();
my $rating_width = ($count > 0) ? sprintf("%.2f", ($current_rating/$count)*$rating_unitwidth) : 0;
my $rating1 = ($count > 0) ? sprintf("%.2f", ($current_rating/$count)) : 0;
my $rating2 = ($count > 0) ? sprintf("%.2f", ($current_rating/$count)) : 0;

if ($static) {
my $static_rater;
$static_rater .= "\n".'<div class="ratingblock">';
$static_rater .= '<div id="unit_long'.$id.'">';
$static_rater .= '<ul id="unit_ul'.$id.'" class="unit-rating" style="width:'.$rating_unitwidth*$units.'px;">';
$static_rater .= '<li class="current-rating" style="width:'.$rating_width.'px;">Currently '.$rating2.'/'.$units.'</li>';
$static_rater .= '</ul>';
$static_rater .= '<p class="static">Rating: <strong> '.$rating1.'</strong>/'.$units.' ('.$count.' '.$tense.' cast) <em>This is \'static\'.</em></p>';
$static_rater .= '</div>';
$static_rater .= '</div>'."\n\n";
return join("\n", $static_rater);
} else {
my $rater ='';
$rater.='<div class="ratingblock">';
$rater.='<div id="unit_long'.$id.'">';
$rater.=' <ul id="unit_ul'.$id.'" class="unit-rating" style="width:'.$rating_unitwidth*$units.'px;">';
$rater.=' <li class="current-rating" style="width:'.$rating_width.'px;">Currently '.$rating2.'/'.$units.'</li>';
my $ncount;
for ($ncount = 1; $ncount <= $units; $ncount++) {
if(!$voted) {
$rater.='<li><a href="http://www.jokecan.com/...amp;amp;c='.$units.'" title="'.$ncount.' out of '.$units.'" class="r'.$ncount.'-unit rater" rel="nofollow">'.$ncount.'</a></li>';
}
}
$ncount=0;
$rater.=' </ul>';
$rater.=' <p';
if($voted){ $rater.=' class="voted"'; }
$rater.='>Rating: <strong> '.$rating1.'</strong>/'.$units.' ('.$count.' '.$tense.' cast)';
$rater.=' </p>';
$rater.='</div>';
$rater.='</div>';
return $rater;
}
}


Everything works fine in Internet Explorer, however in firefox, I still have problems.

I translated this global from this php file: _drawrating.php

Code:

<?php
/*
Page: _drawrating.php
Created: Aug 2006
Last Mod: Mar 18 2007
The function that draws the rating bar.
---------------------------------------------------------
ryan masuga, masugadesign.com
ryan@masugadesign.com
Licensed under a Creative Commons Attribution 3.0 License.
http://creativecommons.org/licenses/by/3.0/
See readme.txt for full credit details.
--------------------------------------------------------- */
function rating_bar($id,$units='',$static='') {
require('_config-rating.php'); // get the db connection info

//set some variables
$ip = $_SERVER['REMOTE_ADDR'];
if (!$units) {$units = 10;}
if (!$static) {$static = FALSE;}
// get votes, values, ips for the current rating bar
$query=mysql_query("SELECT total_votes, total_value, used_ips FROM $rating_dbname.$rating_tableName WHERE id='$id' ")or die(" Error: ".mysql_error());

// insert the id in the DB if it doesn't exist already
// see: http://www.masugadesign.com/...ing-bar/#comment-121
if (mysql_num_rows($query) == 0) {
$sql = "INSERT INTO $rating_dbname.$rating_tableName (`id`,`total_votes`, `total_value`, `used_ips`) VALUES ('$id', '0', '0', '')";
$result = mysql_query($sql);
}
$numbers=mysql_fetch_assoc($query);

if ($numbers['total_votes'] < 1) {
$count = 0;
} else {
$count=$numbers['total_votes']; //how many votes total
}
$current_rating=$numbers['total_value']; //total number of rating added together and stored
$tense=($count==1) ? "vote" : "votes"; //plural form votes/vote
// determine whether the user has voted, so we know how to draw the ul/li
$voted=mysql_num_rows(mysql_query("SELECT used_ips FROM $rating_dbname.$rating_tableName WHERE used_ips LIKE '%".$ip."%' AND id='".$id."' "));
// now draw the rating bar
$rating_width = @number_format($current_rating/$count,2)*$rating_unitwidth;
$rating1 = @number_format($current_rating/$count,1);
$rating2 = @number_format($current_rating/$count,2);

if ($static == 'static') {
$static_rater = array();
$static_rater[] .= "\n".'<div class="ratingblock">';
$static_rater[] .= '<div id="unit_long'.$id.'">';
$static_rater[] .= '<ul id="unit_ul'.$id.'" class="unit-rating" style="width:'.$rating_unitwidth*$units.'px;">';
$static_rater[] .= '<li class="current-rating" style="width:'.$rating_width.'px;">Currently '.$rating2.'/'.$units.'</li>';
$static_rater[] .= '</ul>';
$static_rater[] .= '<p class="static">'.$id.'. Rating: <strong> '.$rating1.'</strong>/'.$units.' ('.$count.' '.$tense.' cast) <em>This is \'static\'.</em></p>';
$static_rater[] .= '</div>';
$static_rater[] .= '</div>'."\n\n";
return join("\n", $static_rater);

} else {
$rater ='';
$rater.='<div class="ratingblock">';
$rater.='<div id="unit_long'.$id.'">';
$rater.=' <ul id="unit_ul'.$id.'" class="unit-rating" style="width:'.$rating_unitwidth*$units.'px;">';
$rater.=' <li class="current-rating" style="width:'.$rating_width.'px;">Currently '.$rating2.'/'.$units.'</li>';
for ($ncount = 1; $ncount <= $units; $ncount++) { // loop from 1 to the number of units
if(!$voted) { // if the user hasn't yet voted, draw the voting stars
$rater.='<li><a href="db.php?j='.$ncount.'&amp;q='.$id.'&amp;t='.$ip.'&amp;c='.$units.'" title="'.$ncount.' out of '.$units.'" class="r'.$ncount.'-unit rater" rel="nofollow">'.$ncount.'</a></li>';
}
}
$ncount=0; // resets the count
$rater.=' </ul>';
$rater.=' <p';
if($voted){ $rater.=' class="voted"'; }
$rater.='>'.$id.' Rating: <strong> '.$rating1.'</strong>/'.$units.' ('.$count.' '.$tense.' cast)';
$rater.=' </p>';
$rater.='</div>';
$rater.='</div>';
return $rater;
}
}
?>


Does anyone see anything off the top off their heads that says "INCOMPATIBLE" with firefox. I have the php version working fine in both browsers... all the other files are basically the same.
Eye yah eye yah eye... lol

Maybe someone can see something I don't... here is the example: http://www.jokecan.com/

I'm taking a break for a while...

- Jonathan

Last edited by:

jdgamble: May 30, 2009, 7:24 PM
Subject Author Views Date
Thread ajax rating system jdgamble 28761 May 26, 2009, 1:24 PM
Post Re: [jdgamble] ajax rating system
Andy 28466 May 27, 2009, 12:34 AM
Thread Re: [jdgamble] ajax rating system
Andy 28471 May 27, 2009, 12:45 AM
Thread Re: [Andy] ajax rating system
tora 12387 Apr 8, 2018, 4:02 AM
Thread Re: [tora] ajax rating system
Andy 12337 Apr 11, 2018, 12:08 AM
Post Re: [Andy] ajax rating system
tora 12331 Apr 11, 2018, 12:46 AM
Thread Re: [Andy] ajax rating system
tora 12324 Apr 11, 2018, 12:52 PM
Thread Re: [tora] ajax rating system
Andy 12315 Apr 12, 2018, 12:59 AM
Post Re: [Andy] ajax rating system
tora 12311 Apr 12, 2018, 1:21 AM
Thread Re: [jdgamble] ajax rating system
tandat 28431 May 27, 2009, 4:53 AM
Thread Re: [tandat] ajax rating system
jdgamble 28391 May 27, 2009, 8:08 AM
Thread Re: [jdgamble] ajax rating system
Andy 28378 May 27, 2009, 8:31 AM
Thread Re: [Andy] ajax rating system
jdgamble 28375 May 27, 2009, 10:38 AM
Thread Re: [jdgamble] ajax rating system
Andy 28439 May 27, 2009, 10:44 AM
Thread Re: [Andy] ajax rating system
jdgamble 28326 May 29, 2009, 11:34 AM
Thread Re: [jdgamble] ajax rating system
Matthias70 28340 May 29, 2009, 11:44 AM
Thread Re: [Matthias70] ajax rating system
jdgamble 28289 May 29, 2009, 6:55 PM
Thread Re: [jdgamble] ajax rating system
jdgamble 28280 May 29, 2009, 10:15 PM
Thread Re: [jdgamble] ajax rating system
jdgamble 28277 May 30, 2009, 7:22 PM
Thread Re: [jdgamble] ajax rating system
Andy 28392 May 31, 2009, 1:58 AM
Thread Re: [Andy] ajax rating system
jdgamble 28186 Jun 6, 2009, 10:48 AM
Thread Re: [jdgamble] ajax rating system
Andy 28275 Jun 6, 2009, 11:05 AM
Thread Re: [Andy] ajax rating system
jdgamble 28226 Jun 6, 2009, 12:42 PM
Post Re: [jdgamble] ajax rating system
Andy 28232 Jun 6, 2009, 11:58 PM