Jump to content
Sign in to follow this  
Joahim2509

Customer Review

Recommended Posts

Hallo. Can somebody point me to a Costumer Review add=on or script that I can integrate to my shop. I need a script that have a user form like name, pseudo-name, text for review. After user  write all this dated the form write all in database and site admin get an email that the shop have a new review and it have possibility to moderate it (set the status for it, to appear online or not)

Share this post


Link to post
Share on other sites

Most of that is already included I think as standard, unless it has been removed by someone for your site.

 

It would help when you asked this type of question to also include useful information like the version of oscommerce you are using.


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

Share this post


Link to post
Share on other sites

I have this code but it doset work for me. It make no inserts to database.

<?php

define ("ADMIN_MAIL", "roma@[member='some']_domain.de");
define ("ADMIN_MAIL_SUBJECT", "!!! Neue Bewertung im  Shop !!! ");
define ("ADMIN_MAIL_FROM", "noreply@[member='some']_domain.de");

/*
  $Id: minen.php,v 1.22 2003/06/05 23:26:23 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/

  require('includes/application_top.php');

  require(DIR_WS_LANGUAGES . $language . '/' . "bewertung-abgeben.php");

  $breadcrumb->add("Bewertung abgeben", tep_href_link("bewertung-abgeben.php"));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
  <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
    </table></td>
<!-- body_text //-->
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td class="pageHeading"><?php echo "Bewertung abgeben"; ?></td>
            <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_specials.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
          <tr>
            <td class="main">
<?php

if($action=="abgeben")
{
	if($ueberschrift && $bewertung)
	{
		tep_db_query("INSERT INTO bewertungen SET bewertungen_pseudonym='".$pseudonym."', bewertungen_ueberschrift='".$ueberschrift."', bewertungen_text='".$bewertung."', bewertungen_datum=NOW();");
		$id = tep_db_insert_id();
		
		$mailtext = $pseudonym.":\n\n".$ueberschrift."\n\n".$bewertung."\n\n";
		$mailtext .= "Bewertung aktivieren: \nhttp://www.some_domain.de/bewertung-abgeben.php?action=status&p=ej2k34jfkdfjr4545fsdfxvbffwku&id=".$id."\n\n";
		
		mail(ADMIN_MAIL, ADMIN_MAIL_SUBJECT.date("H:i:s"), $mailtext,
"From: ".ADMIN_MAIL_FROM."
Content-Type: text");
	}
?>

Wir haben Ihre Bewertung in unserer Datenbank aufgenommen.

<?php

} else
if($action=="status" && $p=="ej2k34jfkdfjr4545fsdfxvbffwku")
{
	tep_db_query("UPDATE bewertungen SET bewertungen_status='1' WHERE bewertungen_id='".$id."';");
	echo "Bewertung aktiviert!";
} else
if($action=="statusx" && $p=="ej2k34jfkdfjr4545fsdfxvbffwku")
{
	tep_db_query("UPDATE bewertungen SET bewertungen_status='0' WHERE bewertungen_id='".$id."';");
	echo "Bewertung aktiviert!";
}
 else
{

?>

Hier k�nnen Sie Ihre Bewertung f�r unseren Shop abgeben.
<form action="bewertung-abgeben.php" method="post">
<input type="hidden" name="action" value="abgeben">
<table>
<tr><td>Name/Psoydonym</td><td><input type="text" name="pseudonym"></td></tr>
<tr><td>�berschrift</td><td><input type="text" name="ueberschrift"></td></tr>
<tr><td valign="top">Ihre Bewertung:</td><td><textarea cols=30 rows=8 name="bewertung"></textarea></td></tr>
</table>
<input type="submit" value="Bewertung jetzt senden">
</form>


<?php

}

?>	
			
			</td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td></td>
      </tr>
    </table></td>
<!-- body_text_eof //-->
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
    </table></td>
  </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>

Edited by Joahim2509

Share this post


Link to post
Share on other sites

Most of that is already included I think as standard, unless it has been removed by someone for your site.

 

It would help when you asked this type of question to also include useful information like the version of oscommerce you are using.

I dont need a review for a product but the review from the customer that have bout on my site

Share this post


Link to post
Share on other sites

You want to search the addons area for 'customer testimonials' then. There are several to choose from depending on your oscommerce version.


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×