评论回复功能添加.doc

1./SQL代码全选ALTER TABLE reviews_description ADD reviews_reply TEXT NOT NULL2./文件：adminreviews.php/功能：后台显示，修改$reviews_reply = zen_db_prepare_input($_POSTreviews_reply);$db-Execute(update . TABLE_REVIEWS_DESCRIPTION . set reviews_text = . zen_db_input($reviews_text) . ,reviews_reply = . zen_db_input($reviews_reply) . where reviews_id = . (int)$reviews_id . );if ($action = edit) $rID = zen_db_prepare_input($_GETrID);$reviews = $db-Execute(select r.reviews_id, ducts_id, r.customers_name, r.date_added,r.last_modified, r.reviews_read, rd.reviews_text, r.reviews_rating,rd.reviews_replyfrom . TABLE_REVIEWS . r, . TABLE_REVIEWS_DESCRIPTION . rdwhere r.reviews_id = . (int)$rID . and r.reviews_id = rd.reviews_id);reviews_text); ?reviews_reply); ? elseif ($action = preview) if (zen_not_null($_POST) $rInfo = new objectInfo($_POST); else $rID = zen_db_prepare_input($_GETrID);$reviews = $db-Execute(select r.reviews_id, ducts_id, r.customers_name, r.customers_email,r.customers_ip, r.date_added,r.last_modified, r.reviews_read, rd.reviews_text,rd.reviews_reply,r.reviews_ratingfrom . TABLE_REVIEWS . r, . TABLE_REVIEWS_DESCRIPTION . rdwhere r.reviews_id = . (int)$rID . and r.reviews_id = rd.reviews_id); reviews_rating . .gif, sprintf(TEXT_OF_5_STARS, $rInfo-reviews_rating); ? reviews_rating); ?reviews_reply!= null)?php echo Reply: .nl2br(zen_db_output(zen_break_string($rInfo-reviews_reply,15).?3. /文件：includesmodulespagesproduct_reviews_writeheader_php.php/功能：保存客户IP，客户EMAIL（修正原版本BUG）$customers_ip = $_SESSIONcustomers_ip_address;$sql = INSERT INTO . TABLE_REVIEWS . (products_id, customers_id,customers_email,review_title,customers_name, reviews_rating, date_added, status,customers_ip)VALUES (:productsID, :customersID,:customers_email,:review_title, :customersName, :rating, now(), . $review_status . ,:customers_ip);$sql = $db-bindVars($sql, :productsID, $_GETproducts_id, integer);$sql = $db-bindVars($sql, :customersID, (isset($_SESSIONcustomer_id) | $_SESSIONcustomer_id=)?0:$_SESSIONcustomer_id, integer);/ $sql = $db-bindVars($sql, :customersName, $customer-fieldscustomers_firstname . . $customer-fieldscustomers_lastname, string);$sql = $db-bindVars($sql, :customers_email, $customer_email, string);$sql = $db-bindVars($sql, :review_title, $review_title, string);$sql = $db-bindVars($sql, :customersName,$customer_name, string);$sql = $db-bindVars($sql, :rating, $rating, string);$sql = $db-bindVars($sql, :customers_ip, $customers_ip, string);$db-Execute($sql);4./文件：includestemplatesezppttemplatestpl_product_reviews_default.php/功能：显示reviews_reply内容?php echo Reply: .$reviewsreviewsReply .?5./文件：includesmodulespagesproduct_infoheader_php.php/功能：读取reviews_reply字段并赋值$reviews_query_raw = SELECT r.reviews_id, left(rd.reviews_text, 400) as reviews_text, r.reviews_rating, r.date_added, r.customers_name,rd.reviews_reply FROM . TABLE_REVIEWS . r, . TABLE_REVIEWS_DESCRIPTION . rdWHERE ducts_id = :productsIDAND r.reviews_id = rd.reviews_idAND rd.languages_id = :languagesID . $review_status . ORDER BY r.reviews_id desc;$reviews_query_raw = $db-bindVars($reviews_query_raw, :productsID, $_GETproducts_id, integer);$reviews_query_raw = $db-bindVars($reviews_query_raw, :languagesID, $_SESSIONlanguages_id, integer);$reviews_split = new splitPageResults($reviews_query_raw, MAX_DISPLAY_NEW_REVIEWS);$reviews = $db-Execute($reviews_split-sql_query);$reviewsArray = array();while (!$reviews-EOF) $reviewsArray = array(id=$reviews-fieldsreviews_id,customersName=$reviews-fieldscustomers_name,dateAdded=$reviews-fieldsdate_added,reviewsText=$reviews-fieldsreviews_text,reviewsReply=$reviews-fie