X-Cart forums - View Single Post

deniz · #1 05-22-2004, 02:59 PM

Hi anyone,

I ve tried to make a simple mode for xcart product review,
When a review sended , first admin should confirm.

Simple steps to make this mode. (Please change some values to as yours)

1.
make a template under admin/main/yorum.tpl

Code:

In this screen you can confirm your product reviews.
Mode Deniz made.. 


 
{capture name=dialog} 
<table border=0 cellspacing=5> 
<tr> 
<td valign=top>Review Id </td> 
<td valign=top>Email</td> 
<td valign=top>Message</td> 
<td valign=top>Product</td> 
<td valign=top><div align="center">?</div></td>
</tr> 
{section name=cust_num loop=$wl_data2} 
<tr> 
<td valign=top>{$wl_data2[cust_num].review_id}</td> 
<td valign=top> {$wl_data2[cust_num].email}</td> 
<td valign=top> {$wl_data2[cust_num].message}</td> 
<td valign=top>{$wl_data2[cust_num].productid}</td> 
<td valign=top>Confirm</td>
</tr> 
{/section} 
</table> 
{/capture} 
{include file="dialog.tpl" title="Reviews Confirmation Addon " content=$smarty.capture.dialog extra="width=100%"}

2.

create yorum.php under admin directory

admin/yorum.php

Code:

<? 
require "../smarty.php"; 
require "../config.php"; 
require "./auth.php"; 
require "../include/security.php"; 
# 
# Deniz  Reviews modul...
# 

$wl_data2= func_query("SELECT * FROM xcart_product_reviews WHERE confirm='N'"); 

{
if ($_GET['mode'] = 'update') {

mysql_query ("UPDATE xcart_product_reviews SET confirm ='Y' WHERE review_id='$_GET[review_id]'");

}
  }

$smarty->assign("wl_data2",$wl_data2); 
$smarty->assign("main","yorum"); 

@include "../modules/gold_display.php"; 
$smarty->display("admin/home.tpl"); 
?>

3. After you did , you have to add some lines to "include/vote.php" forexampe in SQL string " AND confirm='Y' "

Code:

<?php
$N="N";
	if (($mode=='vote') and ($productid) and ($vote>=1) and ($vote<=5)) {
		$result = func_query_first ("SELECT * FROM $sql_tbl[product_votes] WHERE remote_ip='$REMOTE_ADDR' AND productid='$productid'");
		if ($result) {
			header ("Location: error_message.php?error_already_voted");
			exit;
		} else {
			db_query ("INSERT INTO $sql_tbl[product_votes] (remote_ip, vote_value, productid) VALUES ('$REMOTE_ADDR','$vote', '$productid')");
			header ("Location: product.php?productid=$productid");
			exit;
		}
	} elseif (($mode=='review') and ($productid)) {
		$result = func_query_first ("SELECT * FROM $sql_tbl[product_reviews] WHERE remote_ip='$REMOTE_ADDR' AND productid='$productid' AND confirm='Y'");
		if ($result) {
			header ("Location: error_message.php?error_review_exists");
			exit;
		} else {
			$review_author = htmlspecialchars($review_author);
			$review_message = htmlspecialchars($review_message);
			db_query ("INSERT INTO $sql_tbl[product_reviews] (remote_ip, email, message, productid, confirm) VALUES ('$REMOTE_ADDR', '$review_author', '$review_message', '$productid', '$N')");
			header ("Location: product.php?productid=$productid");
			exit;
		}
	}

	$vote_result = func_query_first ("SELECT COUNT(remote_ip) as total, AVG(vote_value) as rating FROM $sql_tbl[product_votes] WHERE productid='$productid'");
	if ($vote_result["total"] == 0)
		$vote_result["rating"] = 0;
	$smarty->assign ("vote_result", $vote_result);
	
	$vote_max_cows = floor ($vote_result["rating"]);
	$vote_little_cow = round (($vote_result["rating"]-$vote_max_cows) * 4);
	$vote_free_cows = 5 - $vote_max_cows - (($vote_little_cow==0) ? 0 : 1);
	$smarty->assign ("vote_max_cows", $vote_max_cows);
	$smarty->assign ("vote_little_cow", $vote_little_cow);
	$smarty->assign ("vote_free_cows", $vote_free_cows);

	if(!empty($login)) {
		$customer_info = func_userinfo($login,$login_type);
		$smarty->assign ("customer_info", $customer_info);
	}

	$reviews = func_query ("SELECT * FROM $sql_tbl[product_reviews] WHERE productid='$productid' AND confirm='Y'");

	if (!empty($reviews))
		foreach ($reviews as $k => $val) {
			$reviews[$k]["email"] = $val["email"];
			$reviews[$k]["message"] = $val["message"];
		}

	$smarty->assign ("reviews", $reviews);
?>

4. Add field to SQL database.
in your xcart_product_reviews
add the field

"Confirm" With VarChar 1 Default "N"

the Sql string is: (3.3.5 ? I didnot test the other versions but I guess no diffrences in)

SQL executer is:

Code:

CREATE TABLE xcart_product_reviews (
  review_id int(11) NOT NULL auto_increment,
  remote_ip varchar(15) NOT NULL default '',
  email varchar(128) NOT NULL default '',
  message varchar(255) NOT NULL default '',
  productid int(11) NOT NULL default '0',
  confirm char(1) default 'N',
  PRIMARY KEY  (review_id),
  KEY productid (productid),
  KEY remote_ip (remote_ip)
) TYPE=MyISAM;

5.
add the lines to single/home.tpl

Code:

{elseif $main eq "yorum"} 
{include file="admin/main/yorum.tpl"}

6.

Add the line under /admin/menu_admin.tpl

Code:

Reviews Addon

under the the line and save thatsall.

Code:

Payment methods

Yes this first step , I am not much time to improve the module , bu i will .

Have fun from Turkiye.....

Deniz.