Announcement

**Toby B** · 09-May-2007, 09:39 AM

Hi Paul,

Could you please provide a bit more info on this review script and perhaps an example?

**woodywoo** · 19-Oct-2007, 10:06 PM

Review Script

Hi

I am after a script that allows users to rate either my site or the product, i.e. 1 out of 10 or 10 out of 10, I can then aprove the listing and put it on my site, its a bit like the amazon rating system. Any ideas would be appreciated, and Toby (Actinic) thanks for all your help over the past week or so. TOP MAN

**leehack** · 22-Oct-2007, 10:34 AM

There will shortly be available an add-on to do this for you, which will involve a monthly rental fee and the solution will be fully integrated with actinic. If you can wait a couple of weeks for this, i would do so as it should fit the bill perfectly.

**GrahamL** · 20-Nov-2007, 09:34 AM

Just wondering whether this is nearer to being available yet? Also is it only suitable for V8 or will the add-in work on V7 too?

Just I'm looking for some way of adding either a product rating script and/or a review script to a V7 site.

Cheers.

**onlineolives** · 23-Nov-2007, 12:23 PM

I'd also really like this add on

Any news please?

Thanks,

N.

**leehack** · 23-Nov-2007, 05:36 PM

It's about a week away from BETA i am told. I have mentioned to him about this thread, he is going to contact you direct once it's launched.

**TraceyHand** · 23-Nov-2007, 05:39 PM

Originally posted by leehack

It's about a week away from BETA i am told. I have mentioned to him about this thread, he is going to contact you direct once it's launched.

is that an Actinic week? or a "rest of the world" week?

**leehack** · 23-Nov-2007, 05:40 PM

Probably somewhere in between lol.

**Andy@codepath** · 04-Dec-2007, 08:36 PM

Product Review Management for Actinic.

Hope I'm not flouting the non-commercial rules here but for those of you who have specifically asked to be kept informed (and after the astutely predicted 'Actinic Week' Tracey

) the Product Review plug-in (alias "Soapbox") for Actinic v8 is now available. Just follow the links from the plug-ins page http://www.codepath.biz/actinic_plugins.htm

Please contact me directly via Codepath's website if I can be of any further help.

Kind regards

**TraceyHand** · 04-Dec-2007, 09:38 PM

Originally posted by Andy@codepath

Hope I'm not flouting the non-commercial rules here but for those of you who have specifically asked to be kept informed (and after the astutely predicted 'Actinic Week' Tracey

) the Product Review plug-in (alias "Soapbox") for Actinic v8 is now available. Just follow the links from the plug-ins page http://www.codepath.biz/actinic_plugins.htm

Please contact me directly via Codepath's website if I can be of any further help.

Kind regards

Andy, that wasn't anywhere NEAR as long as an Actinic week

**Andy@codepath** · 05-Dec-2007, 12:57 PM

it sure felt like one

**Mike Hughes** · 05-Dec-2007, 01:22 PM

Hi Andy,

have you a demo of this in action somewhere?

Mike

**Andy@codepath** · 05-Dec-2007, 10:38 PM

Soapbox Demonstration Site

Hi Mike

Just got the demo uploaded. The Actinic site is only very basic but see the Books section (in particular the "Pride & Prejudice" product item) which shows the integration of Soapbox.

You can see the links from the product, read reviews and write your own review. (Please note that submitted test reviews will not be listed as the site owner would need to moderate them first).

Demo here....
http://www.codepath.co.uk/soapbox-site-demo.htm

Any feedback welcome (good and bad).

Regards

**Marci** · 06-Dec-2007, 11:14 AM

If you have MySQL / PHP on the server...

Code:

<html>
<body bgcolor="#e9e9e9">
<?php
$host = "localhost";
$db_username = "ratings";
$db_pass = "";
$db_name = "rating";

$max_rows = 10000;
$ratings=Array("- select -", "Poor", "Fair", "Good", "Very good", "Excellent");
$_GET['id'] = intval($_GET['id']);

if ($_GET[ID]) {
	$connection = mysql_connect($host,$db_username,$db_pass);
	mysql_selectdb($db_name);
	$result = mysql_query("SELECT * FROM rating WHERE ID=$_GET[ID]");
	$fields = mysql_fetch_row($result);

	if (!$fields[0]) {
		$num_rows = mysql_result(mysql_query("SELECT COUNT(ID) FROM rating"),0);
		if ($num_rows <= $max_rows) {
			mysql_query("INSERT INTO rating VALUES ($_GET[ID],0,0,'0.0.0.0')");
			$rating = 0;
			$votes = 0;
		}
		else die("Error: Max rows reached.");
	}
	else {
		$rating = $fields[2];
		$votes = $fields[1];
	}

	if ($_POST[your_rating] > 0 and $fields[3] != $REMOTE_ADDR) {
		$your_rating = $_POST[your_rating] * 10;
		$votes++; 
		$rating = ($fields[2]*$fields[1]+$your_rating)/$votes;
		mysql_query("UPDATE rating SET votes = $votes, rating = $rating, last_ip = '$REMOTE_ADDR' WHERE ID=$_GET[ID]");
	}

	$image = (round($rating/50,1)*50)."-star.gif";
	$note = number_format($rating/10, 1);

echo "<center><font size=\"2\" face=\"Arial, Helvetica, sans-serif\">Product Rating for Ref# ".$_GET[ID]."</font><br /><a href=\"javascript:window.close();\"><font size=\"1\" face=\"Arial, Helvetica, sans-serif\">Close Window</font></a><br /><br /><form action=\"rating.php?ID=".$_GET[ID]."\" method=\"POST\">
<font size=\"2\" face=\"Arial, Helvetica, sans-serif\"><B>Rating:</B></FONT>&nbsp;&nbsp;<img src=\"$image\" alt=\"Rating: $note\" align=\"middle\"><br><font size=1 face=Verdana color=RED>($note from $votes votes)</font>
&nbsp;&nbsp;&nbsp;
<select name=\"your_rating\" style=\"font-size: 8pt\">
<option value=\"0\" selected>$ratings[0]</form>
</center>";

	for ($i=5; $i>=1; $i--) { 
		echo "<option value=\"$i\">$ratings[$i]\n";
	}
}
else die("Error: ID not set!");

?>
</select>
<input type="submit" value="Rate!" style="font-size: 8pt">
</form>
</font>
</center>
</body>
<html>

Save the code above as rating.php (after sticking in relevant database auth info), include as an additional file within actinic. Call it by sticking the following code within your product layout... can add the usual dimensional code if needed also...

Code:

<iframe src="rating.php&amp;ID=<actinic:variable name="ProductReference" />" />

Create a MySQL database called "rating" with a table within called "rating", with fields of ID, votes, rating, last_ip.
Create a subdirectory on the server within acatalog called rating (so /acatalog/rating/) and in there stick image files from this zip archive: www.over-clock.co.uk/marci/rating.zip

With some butchery you could probably sort out reviews within it also... sure someone with some PHP knowledge would be able to sort it out.

Downside is if you create a new product using the reference of a previous deleted product, you need to remember to go in and reset the database record for that product ID.

Can't remember for the life of me where I found it, can't remember exactly how to use it, and don't use it myself at the mo, but it works for a simple 5 star rating script.

I possibly posted summat about it in the v6 section a year or two ago... might be able to find it with a search...

Announcement

Product Review Scripts

Product Review Scripts

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment