Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Customer Review


Joahim2509

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)

Link to comment
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

Link to comment
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
Link to comment
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...