Joahim2509 Posted January 3, 2016 Share Posted January 3, 2016 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) Quote Link to comment Share on other sites More sharing options...
♥14steve14 Posted January 3, 2016 Share Posted January 3, 2016 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. Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
Joahim2509 Posted January 3, 2016 Author Share Posted January 3, 2016 (edited) 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 January 3, 2016 by Joahim2509 Quote Link to comment Share on other sites More sharing options...
Joahim2509 Posted January 3, 2016 Author Share Posted January 3, 2016 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 Quote Link to comment Share on other sites More sharing options...
♥14steve14 Posted January 3, 2016 Share Posted January 3, 2016 You want to search the addons area for 'customer testimonials' then. There are several to choose from depending on your oscommerce version. Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.