执行前注意 以下文件，有些位置可能不一样，主要是vqcache modify 源代码 三个地方
前台需要修改的
1 修改前台文件 /public_html/catalog/model/catalog 里面的 review.php
在public function getReviewsByProductId
原来的$query注释
添加
// todo
$query = $this->db->query(“SELECT r.review_id, r.author_image, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM ” . DB_PREFIX . “review r LEFT JOIN ” . DB_PREFIX . “product p ON (r.product_id = p.product_id) LEFT JOIN ” . DB_PREFIX . “product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = ‘” . (int)$product_id . “‘ AND p.date_available <= NOW() AND p.status = ‘1’ AND r.status = ‘1’ AND pd.language_id = ‘” . (int)$this->config->get(‘config_language_id’) . “‘ ORDER BY r.date_added DESC LIMIT ” . (int)$start . “,” . (int)$limit);
// toend
2 修改 /public_html/system/storage/modification/catalog/controller/product 的product.php
查找 $data[‘reviews’] = array();
将有todo开始 toend结束的代码 添加进去
$data[‘reviews’] = array();
$review_total = $this->model_catalog_review->getTotalReviewsByProductId($this->request->get[‘product_id’]);
$results = $this->model_catalog_review->getReviewsByProductId($this->request->get[‘product_id’], ($page – 1) * 5, 5);
// todo
$this->load->model(‘tool/image’);
// toend
foreach ($results as $result) {
// todo
// 判断图像文件是否存在
$authorimg = DIR_IMAGE .$result[‘author_image’];
if (file_exists($authorimg) && $result[‘author_image’] != ”) {
$authorimg = $this->model_tool_image->resize($result[‘author_image’] , 100, 100);
} else {
$authorimg = ‘image/catalog/review/anonymus.jpg’;
};
// toend
$data[‘reviews’][] = array(
‘author’ => $result[‘author’],
‘text’ => nl2br($result[‘text’]),
‘rating’ => (int)$result[‘rating’],
‘date_added’ => date($this->language->get(‘date_format_short’), strtotime($result[‘date_added’])),
// todo
‘author_image’ => $authorimg,
// toend
);
}
3 修改 catalog\view\theme\clearshop\template\product\ review.tpl 注意备份，可能会问题
将文件内全部代码，替换成
<?php if ($reviews) { ?>
<?php foreach ($reviews as $review) { ?>
<article class=”content”>
<?php if(isset($review[‘author_image’])){ ?>
<div><img id=”authorimgcircle” src=”<?php echo $review[‘author_image’]; ?>”></div>
<?php } ?>
<div class=”author”><?php echo $review[‘author’]; ?></div>
<?php for ($i = 1; $i <= 5; $i++) { ?>
<?php if ($review[‘rating’] < $i) { ?>
<span class=”fa fa-stack”><i class=”fa fa-star-o fa-stack-2x”></i></span>
<?php } else { ?>
<span class=”fa fa-stack”><i class=”fa fa-star fa-stack-2x”></i><i class=”fa fa-star-o fa-stack-2x”></i></span>
<?php } ?>
<?php } ?>
<div class=”review-date”><?php echo $review[‘date_added’]; ?></div>
<?php echo $review[‘text’]; ?>
</article>
<?php } ?>
<div class=”pagination”><?php echo $pagination; ?></div>
<?php } else { ?>
<div class=”empty”>
<div class=”empty-inner”><?php echo $text_no_reviews; ?></div>
</div>
<?php } ?>
<style>
#authorimgcircle{
border-radius: 50% 50% 50% 50%;
max-width: 100px;
max-height: 100px;
min-width: 70px;
min-height: 70px;
padding: 5px;
border: 1px solid #eee
}
@media only screen and (min-width: 302px) and (max-width: 400px) {
#review .author{
margin-left: 10%;
}
}
@media only screen and (min-width: 360px) and (max-width: 640px) {
#review .author{
margin-left: 10%;
}
}
@media screen and (min-width: 411px) and (max-width: 823px) {
#review .author{
margin-left: 9%;
}
}
@media only screen and (min-width: 320px) and (max-width: 568px) {
#review .author{
margin-left: 13%;
}
}
@media only screen and (min-width: 375px) and (max-width: 677px) {
#review .author{
margin-left: 11%;
}
}
@media only screen and (min-width: 414px) and (max-width: 736px) {
#review .author{
margin-left: 9%;
}
}
@media only screen and (min-width: 375px) and (max-width: 812px) {
#review .author{
margin-left: 11%;
}
}
@media only screen and (min-width: 768px) and (max-width: 1024px) {
#review .author{
margin-left: 10%;
}
}
@media only screen and (min-width: 1024px) {
#review .author{
margin-left: 5%;
}
}
</style>
后台需要修改的（修改钱注意备份）
1 admin\controller\catalog 的 review.php 代码全部替换
<?php
class ControllerCatalogReview extends Controller {
private $error = array();
public function index() {
$this->load->language(‘catalog/review’);
$this->document->setTitle($this->language->get(‘heading_title’));
$this->load->model(‘catalog/review’);
$this->getList();
}
public function add() {
$this->load->language(‘catalog/review’);
$this->document->setTitle($this->language->get(‘heading_title’));
$this->load->model(‘catalog/review’);
if (($this->request->server[‘REQUEST_METHOD’] == ‘POST’) && $this->validateForm()) {
$this->model_catalog_review->addReview($this->request->post);
$this->session->data[‘success’] = $this->language->get(‘text_success’);
$url = ”;
if (isset($this->request->get[‘filter_product’])) {
$url .= ‘&filter_product=’ . urlencode(html_entity_decode($this->request->get[‘filter_product’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_author’])) {
$url .= ‘&filter_author=’ . urlencode(html_entity_decode($this->request->get[‘filter_author’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_status’])) {
$url .= ‘&filter_status=’ . $this->request->get[‘filter_status’];
}
if (isset($this->request->get[‘filter_date_added’])) {
$url .= ‘&filter_date_added=’ . $this->request->get[‘filter_date_added’];
}
if (isset($this->request->get[‘sort’])) {
$url .= ‘&sort=’ . $this->request->get[‘sort’];
}
if (isset($this->request->get[‘order’])) {
$url .= ‘&order=’ . $this->request->get[‘order’];
}
if (isset($this->request->get[‘page’])) {
$url .= ‘&page=’ . $this->request->get[‘page’];
}
$this->response->redirect($this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . $url, true));
}
$this->getForm();
}
public function edit() {
$this->load->language(‘catalog/review’);
$this->document->setTitle($this->language->get(‘heading_title’));
$this->load->model(‘catalog/review’);
if (($this->request->server[‘REQUEST_METHOD’] == ‘POST’) && $this->validateForm()) {
$this->model_catalog_review->editReview($this->request->get[‘review_id’], $this->request->post);
$this->session->data[‘success’] = $this->language->get(‘text_success’);
$url = ”;
if (isset($this->request->get[‘filter_product’])) {
$url .= ‘&filter_product=’ . urlencode(html_entity_decode($this->request->get[‘filter_product’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_author’])) {
$url .= ‘&filter_author=’ . urlencode(html_entity_decode($this->request->get[‘filter_author’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_status’])) {
$url .= ‘&filter_status=’ . $this->request->get[‘filter_status’];
}
if (isset($this->request->get[‘filter_date_added’])) {
$url .= ‘&filter_date_added=’ . $this->request->get[‘filter_date_added’];
}
if (isset($this->request->get[‘sort’])) {
$url .= ‘&sort=’ . $this->request->get[‘sort’];
}
if (isset($this->request->get[‘order’])) {
$url .= ‘&order=’ . $this->request->get[‘order’];
}
if (isset($this->request->get[‘page’])) {
$url .= ‘&page=’ . $this->request->get[‘page’];
}
$this->response->redirect($this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . $url, true));
}
$this->getForm();
}
public function delete() {
$this->load->language(‘catalog/review’);
$this->document->setTitle($this->language->get(‘heading_title’));
$this->load->model(‘catalog/review’);
if (isset($this->request->post[‘selected’]) && $this->validateDelete()) {
foreach ($this->request->post[‘selected’] as $review_id) {
$this->model_catalog_review->deleteReview($review_id);
}
$this->session->data[‘success’] = $this->language->get(‘text_success’);
$url = ”;
if (isset($this->request->get[‘filter_product’])) {
$url .= ‘&filter_product=’ . urlencode(html_entity_decode($this->request->get[‘filter_product’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_author’])) {
$url .= ‘&filter_author=’ . urlencode(html_entity_decode($this->request->get[‘filter_author’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_status’])) {
$url .= ‘&filter_status=’ . $this->request->get[‘filter_status’];
}
if (isset($this->request->get[‘filter_date_added’])) {
$url .= ‘&filter_date_added=’ . $this->request->get[‘filter_date_added’];
}
if (isset($this->request->get[‘sort’])) {
$url .= ‘&sort=’ . $this->request->get[‘sort’];
}
if (isset($this->request->get[‘order’])) {
$url .= ‘&order=’ . $this->request->get[‘order’];
}
if (isset($this->request->get[‘page’])) {
$url .= ‘&page=’ . $this->request->get[‘page’];
}
$this->response->redirect($this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . $url, true));
}
$this->getList();
}
protected function getList() {
if (isset($this->request->get[‘filter_product’])) {
$filter_product = $this->request->get[‘filter_product’];
} else {
$filter_product = null;
}
if (isset($this->request->get[‘filter_author’])) {
$filter_author = $this->request->get[‘filter_author’];
} else {
$filter_author = null;
}
if (isset($this->request->get[‘filter_status’])) {
$filter_status = $this->request->get[‘filter_status’];
} else {
$filter_status = null;
}
if (isset($this->request->get[‘filter_date_added’])) {
$filter_date_added = $this->request->get[‘filter_date_added’];
} else {
$filter_date_added = null;
}
if (isset($this->request->get[‘order’])) {
$order = $this->request->get[‘order’];
} else {
$order = ‘ASC’;
}
if (isset($this->request->get[‘sort’])) {
$sort = $this->request->get[‘sort’];
} else {
$sort = ‘r.date_added’;
$order = ‘DESC’;
}
if (isset($this->request->get[‘page’])) {
$page = $this->request->get[‘page’];
} else {
$page = 1;
}
$url = ”;
if (isset($this->request->get[‘filter_product’])) {
$url .= ‘&filter_product=’ . urlencode(html_entity_decode($this->request->get[‘filter_product’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_author’])) {
$url .= ‘&filter_author=’ . urlencode(html_entity_decode($this->request->get[‘filter_author’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_status’])) {
$url .= ‘&filter_status=’ . $this->request->get[‘filter_status’];
}
if (isset($this->request->get[‘filter_date_added’])) {
$url .= ‘&filter_date_added=’ . $this->request->get[‘filter_date_added’];
}
if (isset($this->request->get[‘sort’])) {
$url .= ‘&sort=’ . $this->request->get[‘sort’];
}
if (isset($this->request->get[‘order’])) {
$url .= ‘&order=’ . $this->request->get[‘order’];
}
if (isset($this->request->get[‘page’])) {
$url .= ‘&page=’ . $this->request->get[‘page’];
}
$data[‘breadcrumbs’] = array();
$data[‘breadcrumbs’][] = array(
‘text’ => $this->language->get(‘text_home’),
‘href’ => $this->url->link(‘common/dashboard’, ‘token=’ . $this->session->data[‘token’], true)
);
$data[‘breadcrumbs’][] = array(
‘text’ => $this->language->get(‘heading_title’),
‘href’ => $this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . $url, true)
);
$data[‘add’] = $this->url->link(‘catalog/review/add’, ‘token=’ . $this->session->data[‘token’] . $url, true);
$data[‘delete’] = $this->url->link(‘catalog/review/delete’, ‘token=’ . $this->session->data[‘token’] . $url, true);
$data[‘reviews’] = array();
$filter_data = array(
‘filter_product’ => $filter_product,
‘filter_author’ => $filter_author,
‘filter_status’ => $filter_status,
‘filter_date_added’ => $filter_date_added,
‘sort’ => $sort,
‘order’ => $order,
‘start’ => ($page – 1) * $this->config->get(‘config_limit_admin’),
‘limit’ => $this->config->get(‘config_limit_admin’)
);
$review_total = $this->model_catalog_review->getTotalReviews($filter_data);
$results = $this->model_catalog_review->getReviews($filter_data);
foreach ($results as $result) {
$data[‘reviews’][] = array(
‘review_id’ => $result[‘review_id’],
‘name’ => $result[‘name’],
‘author’ => $result[‘author’],
‘rating’ => $result[‘rating’],
‘status’ => ($result[‘status’]) ? $this->language->get(‘text_enabled’) : $this->language->get(‘text_disabled’),
‘date_added’ => date($this->language->get(‘date_format_short’), strtotime($result[‘date_added’])),
‘edit’ => $this->url->link(‘catalog/review/edit’, ‘token=’ . $this->session->data[‘token’] . ‘&review_id=’ . $result[‘review_id’] . $url, true)
);
}
$data[‘heading_title’] = $this->language->get(‘heading_title’);
$data[‘text_list’] = $this->language->get(‘text_list’);
$data[‘text_no_results’] = $this->language->get(‘text_no_results’);
$data[‘text_confirm’] = $this->language->get(‘text_confirm’);
$data[‘text_enabled’] = $this->language->get(‘text_enabled’);
$data[‘text_disabled’] = $this->language->get(‘text_disabled’);
$data[‘column_product’] = $this->language->get(‘column_product’);
$data[‘column_author’] = $this->language->get(‘column_author’);
$data[‘column_rating’] = $this->language->get(‘column_rating’);
$data[‘column_status’] = $this->language->get(‘column_status’);
$data[‘column_date_added’] = $this->language->get(‘column_date_added’);
$data[‘column_action’] = $this->language->get(‘column_action’);
$data[‘entry_product’] = $this->language->get(‘entry_product’);
$data[‘entry_author’] = $this->language->get(‘entry_author’);
$data[‘entry_rating’] = $this->language->get(‘entry_rating’);
$data[‘entry_status’] = $this->language->get(‘entry_status’);
$data[‘entry_date_added’] = $this->language->get(‘entry_date_added’);
$data[‘button_add’] = $this->language->get(‘button_add’);
$data[‘button_edit’] = $this->language->get(‘button_edit’);
$data[‘button_delete’] = $this->language->get(‘button_delete’);
$data[‘button_filter’] = $this->language->get(‘button_filter’);
$data[‘token’] = $this->session->data[‘token’];
if (isset($this->error[‘warning’])) {
$data[‘error_warning’] = $this->error[‘warning’];
} else {
$data[‘error_warning’] = ”;
}
if (isset($this->session->data[‘success’])) {
$data[‘success’] = $this->session->data[‘success’];
unset($this->session->data[‘success’]);
} else {
$data[‘success’] = ”;
}
if (isset($this->request->post[‘selected’])) {
$data[‘selected’] = (array)$this->request->post[‘selected’];
} else {
$data[‘selected’] = array();
}
$url = ”;
if ($order == ‘ASC’) {
$url .= ‘&order=DESC’;
} else {
$url .= ‘&order=ASC’;
}
if (isset($this->request->get[‘page’])) {
$url .= ‘&page=’ . $this->request->get[‘page’];
}
$data[‘sort_product’] = $this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . ‘&sort=pd.name’ . $url, true);
$data[‘sort_author’] = $this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . ‘&sort=r.author’ . $url, true);
$data[‘sort_rating’] = $this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . ‘&sort=r.rating’ . $url, true);
$data[‘sort_status’] = $this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . ‘&sort=r.status’ . $url, true);
$data[‘sort_date_added’] = $this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . ‘&sort=r.date_added’ . $url, true);
$url = ”;
if (isset($this->request->get[‘filter_product’])) {
$url .= ‘&filter_product=’ . urlencode(html_entity_decode($this->request->get[‘filter_product’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_author’])) {
$url .= ‘&filter_author=’ . urlencode(html_entity_decode($this->request->get[‘filter_author’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_status’])) {
$url .= ‘&filter_status=’ . $this->request->get[‘filter_status’];
}
if (isset($this->request->get[‘filter_date_added’])) {
$url .= ‘&filter_date_added=’ . $this->request->get[‘filter_date_added’];
}
if (isset($this->request->get[‘sort’])) {
$url .= ‘&sort=’ . $this->request->get[‘sort’];
}
if (isset($this->request->get[‘order’])) {
$url .= ‘&order=’ . $this->request->get[‘order’];
}
$pagination = new Pagination();
$pagination->total = $review_total;
$pagination->page = $page;
$pagination->limit = $this->config->get(‘config_limit_admin’);
$pagination->url = $this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . $url . ‘&page={page}’, true);
$data[‘pagination’] = $pagination->render();
$data[‘results’] = sprintf($this->language->get(‘text_pagination’), ($review_total) ? (($page – 1) * $this->config->get(‘config_limit_admin’)) + 1 : 0, ((($page – 1) * $this->config->get(‘config_limit_admin’)) > ($review_total – $this->config->get(‘config_limit_admin’))) ? $review_total : ((($page – 1) * $this->config->get(‘config_limit_admin’)) + $this->config->get(‘config_limit_admin’)), $review_total, ceil($review_total / $this->config->get(‘config_limit_admin’)));
$data[‘filter_product’] = $filter_product;
$data[‘filter_author’] = $filter_author;
$data[‘filter_status’] = $filter_status;
$data[‘filter_date_added’] = $filter_date_added;
$data[‘sort’] = $sort;
$data[‘order’] = $order;
$data[‘header’] = $this->load->controller(‘common/header’);
$data[‘column_left’] = $this->load->controller(‘common/column_left’);
$data[‘footer’] = $this->load->controller(‘common/footer’);
$this->response->setOutput($this->load->view(‘catalog/review_list’, $data));
}
protected function getForm() {
$data[‘heading_title’] = $this->language->get(‘heading_title’);
$data[‘text_form’] = !isset($this->request->get[‘review_id’]) ? $this->language->get(‘text_add’) : $this->language->get(‘text_edit’);
$data[‘text_enabled’] = $this->language->get(‘text_enabled’);
$data[‘text_disabled’] = $this->language->get(‘text_disabled’);
$data[‘entry_product’] = $this->language->get(‘entry_product’);
$data[‘entry_author’] = $this->language->get(‘entry_author’);
$data[‘entry_rating’] = $this->language->get(‘entry_rating’);
$data[‘entry_status’] = $this->language->get(‘entry_status’);
$data[‘entry_text’] = $this->language->get(‘entry_text’);
$data[‘help_product’] = $this->language->get(‘help_product’);
$data[‘button_save’] = $this->language->get(‘button_save’);
$data[‘button_cancel’] = $this->language->get(‘button_cancel’);
if (isset($this->error[‘warning’])) {
$data[‘error_warning’] = $this->error[‘warning’];
} else {
$data[‘error_warning’] = ”;
}
if (isset($this->error[‘product’])) {
$data[‘error_product’] = $this->error[‘product’];
} else {
$data[‘error_product’] = ”;
}
if (isset($this->error[‘author’])) {
$data[‘error_author’] = $this->error[‘author’];
} else {
$data[‘error_author’] = ”;
}
if (isset($this->error[‘text’])) {
$data[‘error_text’] = $this->error[‘text’];
} else {
$data[‘error_text’] = ”;
}
if (isset($this->error[‘rating’])) {
$data[‘error_rating’] = $this->error[‘rating’];
} else {
$data[‘error_rating’] = ”;
}
$url = ”;
if (isset($this->request->get[‘filter_product’])) {
$url .= ‘&filter_product=’ . urlencode(html_entity_decode($this->request->get[‘filter_product’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_author’])) {
$url .= ‘&filter_author=’ . urlencode(html_entity_decode($this->request->get[‘filter_author’], ENT_QUOTES, ‘UTF-8’));
}
if (isset($this->request->get[‘filter_status’])) {
$url .= ‘&filter_status=’ . $this->request->get[‘filter_status’];
}
if (isset($this->request->get[‘filter_date_added’])) {
$url .= ‘&filter_date_added=’ . $this->request->get[‘filter_date_added’];
}
if (isset($this->request->get[‘sort’])) {
$url .= ‘&sort=’ . $this->request->get[‘sort’];
}
if (isset($this->request->get[‘order’])) {
$url .= ‘&order=’ . $this->request->get[‘order’];
}
if (isset($this->request->get[‘page’])) {
$url .= ‘&page=’ . $this->request->get[‘page’];
}
$data[‘breadcrumbs’] = array();
$data[‘breadcrumbs’][] = array(
‘text’ => $this->language->get(‘text_home’),
‘href’ => $this->url->link(‘common/dashboard’, ‘token=’ . $this->session->data[‘token’], true)
);
$data[‘breadcrumbs’][] = array(
‘text’ => $this->language->get(‘heading_title’),
‘href’ => $this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . $url, true)
);
if (!isset($this->request->get[‘review_id’])) {
$data[‘action’] = $this->url->link(‘catalog/review/add’, ‘token=’ . $this->session->data[‘token’] . $url, true);
} else {
$data[‘action’] = $this->url->link(‘catalog/review/edit’, ‘token=’ . $this->session->data[‘token’] . ‘&review_id=’ . $this->request->get[‘review_id’] . $url, true);
}
$data[‘cancel’] = $this->url->link(‘catalog/review’, ‘token=’ . $this->session->data[‘token’] . $url, true);
if (isset($this->request->get[‘review_id’]) && ($this->request->server[‘REQUEST_METHOD’] != ‘POST’)) {
$review_info = $this->model_catalog_review->getReview($this->request->get[‘review_id’]);
}
/*************************** todo 后台评论修改***********************************************/
if (isset($this->request->post[‘author_image’])) {
$data[‘author_image’] = $this->request->post[‘author_image’];
} elseif (!empty($review_info)) {
$data[‘author_image’] = $review_info[‘author_image’];
} else {
$data[‘author_image’] = ”;
}
if (isset($this->request->post[‘date_added’])) {
$data[‘date_added’] = $this->request->post[‘date_added’];
} elseif (!empty($review_info)) {
$data[‘date_added’] = ($review_info[‘date_added’] != ‘0000-00-00’) ? date(‘Y-m-d’,strtotime($review_info[‘date_added’])): ”;
} else {
$data[‘date_added’] = date(‘Y-m-d’);
}
$this->load->model(‘tool/image’);
if (isset($this->request->post[‘author_image’]) && is_file(DIR_IMAGE . $this->request->post[‘author_image’])) {
$data[‘author_thumb’] = $this->model_tool_image->resize($this->request->post[‘author_image’], 100, 100);
} elseif (!empty($review_info) && is_file(DIR_IMAGE . $review_info[‘author_image’])) {
$data[‘author_thumb’] = $this->model_tool_image->resize($review_info[‘author_image’], 100, 100);
} else {
$data[‘author_thumb’] = $this->model_tool_image->resize(‘no_image.png’, 100, 100);
}
$data[‘placeholder’] = $this->model_tool_image->resize(‘no_image.png’, 100, 100);
/******************************* toend ****************************************/
$data[‘token’] = $this->session->data[‘token’];
$this->load->model(‘catalog/product’);
if (isset($this->request->post[‘product_id’])) {
$data[‘product_id’] = $this->request->post[‘product_id’];
} elseif (!empty($review_info)) {
$data[‘product_id’] = $review_info[‘product_id’];
} else {
$data[‘product_id’] = ”;
}
if (isset($this->request->post[‘product’])) {
$data[‘product’] = $this->request->post[‘product’];
} elseif (!empty($review_info)) {
$data[‘product’] = $review_info[‘product’];
} else {
$data[‘product’] = ”;
}
if (isset($this->request->post[‘author’])) {
$data[‘author’] = $this->request->post[‘author’];
} elseif (!empty($review_info)) {
$data[‘author’] = $review_info[‘author’];
} else {
$data[‘author’] = ”;
}
if (isset($this->request->post[‘text’])) {
$data[‘text’] = $this->request->post[‘text’];
} elseif (!empty($review_info)) {
$data[‘text’] = $review_info[‘text’];
} else {
$data[‘text’] = ”;
}
if (isset($this->request->post[‘rating’])) {
$data[‘rating’] = $this->request->post[‘rating’];
} elseif (!empty($review_info)) {
$data[‘rating’] = $review_info[‘rating’];
} else {
$data[‘rating’] = ”;
}
if (isset($this->request->post[‘status’])) {
$data[‘status’] = $this->request->post[‘status’];
} elseif (!empty($review_info)) {
$data[‘status’] = $review_info[‘status’];
} else {
$data[‘status’] = ”;
}
$data[‘header’] = $this->load->controller(‘common/header’);
$data[‘column_left’] = $this->load->controller(‘common/column_left’);
$data[‘footer’] = $this->load->controller(‘common/footer’);
$this->response->setOutput($this->load->view(‘catalog/review_form’, $data));
}
protected function validateForm() {
if (!$this->user->hasPermission(‘modify’, ‘catalog/review’)) {
$this->error[‘warning’] = $this->language->get(‘error_permission’);
}
if (!$this->request->post[‘product_id’]) {
$this->error[‘product’] = $this->language->get(‘error_product’);
}
if ((utf8_strlen($this->request->post[‘author’]) < 3) || (utf8_strlen($this->request->post[‘author’]) > 64)) {
$this->error[‘author’] = $this->language->get(‘error_author’);
}
if (utf8_strlen($this->request->post[‘text’]) < 1) {
$this->error[‘text’] = $this->language->get(‘error_text’);
}
if (!isset($this->request->post[‘rating’]) || $this->request->post[‘rating’] < 0 || $this->request->post[‘rating’] > 5) {
$this->error[‘rating’] = $this->language->get(‘error_rating’);
}
return !$this->error;
}
protected function validateDelete() {
if (!$this->user->hasPermission(‘modify’, ‘catalog/review’)) {
$this->error[‘warning’] = $this->language->get(‘error_permission’);
}
return !$this->error;
}
}
2 admin\model\catalog 的 review.php 代码全部替换
<?php
class ModelCatalogReview extends Model {
public function addReview($data) {
$this->db->query(“INSERT INTO ” . DB_PREFIX . “review SET author = ‘” . $this->db->escape($data[‘author’])
// todo
. “‘, author_image = ‘” . $this->db->escape($data[‘author_image’])
//toend
// . “‘, product_id = ‘” . (int)$data[‘product_id’] . “‘, text = ‘” . $this->db->escape(strip_tags($data[‘text’])) . “‘, rating = ‘” . (int)$data[‘rating’] . “‘, status = ‘” . (int)$data[‘status’] . “‘, date_added = NOW()”);
. “‘, product_id = ‘” . (int)$data[‘product_id’] . “‘, text = ‘” . $this->db->escape(strip_tags($data[‘text’])) . “‘, rating = ‘” . (int)$data[‘rating’] . “‘, status = ‘” . (int)$data[‘status’] . “‘, date_added = ‘” . $this->db->escape($data[‘date_added’]) . “‘ “);
$review_id = $this->db->getLastId();
// todo
$this->db->query(“INSERT INTO ” . DB_PREFIX . “review_userimg SET review_id = ‘”.$review_id.”‘, user_img = ‘” . $this->db->escape($data[‘author_image’]). “‘”);
//toend
$this->cache->delete(‘product’);
// todo
$this->event->trigger(‘post.admin.review.add’, $review_id);
// toend
return $review_id;
}
public function editReview($review_id, $data) {
$this->db->query(“UPDATE ” . DB_PREFIX . “review SET author = ‘” . $this->db->escape($data[‘author’])
//todo
. “‘, author_image = ‘” . $this->db->escape($data[‘author_image’])
//toend
// . “‘, product_id = ‘” . (int)$data[‘product_id’] . “‘, text = ‘” . $this->db->escape(strip_tags($data[‘text’])) . “‘, rating = ‘” . (int)$data[‘rating’] . “‘, status = ‘” . (int)$data[‘status’] . “‘, date_modified = NOW() WHERE review_id = ‘” . (int)$review_id . “‘”);
. “‘, product_id = ‘” . (int)$data[‘product_id’] . “‘, text = ‘” . $this->db->escape(strip_tags($data[‘text’])) . “‘, rating = ‘” . (int)$data[‘rating’] . “‘, status = ‘” . (int)$data[‘status’] . “‘, date_modified = NOW() , date_added = ‘” . $this->db->escape($data[‘date_added’]) . “‘ WHERE review_id = ‘” . (int)$review_id . “‘”);
//todo
$this->db->query(“UPDATE ” . DB_PREFIX . “review_userimg SET user_img = ‘” . $this->db->escape($data[‘author_image’]). “‘ WHERE review_id = ‘” . (int)$review_id . “‘ “);
//toend
$this->cache->delete(‘product’);
// todo
$this->event->trigger(‘post.admin.review.edit’, $review_id);
// toend
}
public function deleteReview($review_id) {
// todo
$this->event->trigger(‘pre.admin.review.delete’, $review_id);
// toend
$this->db->query(“DELETE FROM ” . DB_PREFIX . “review WHERE review_id = ‘” . (int)$review_id . “‘”);
$this->cache->delete(‘product’);
// todo
$this->event->trigger(‘post.admin.review.delete’, $review_id);
// toend
}
public function getReview($review_id) {
$query = $this->db->query(“SELECT DISTINCT *, (SELECT pd.name FROM ” . DB_PREFIX . “product_description pd WHERE pd.product_id = r.product_id AND pd.language_id = ‘” . (int)$this->config->get(‘config_language_id’) . “‘) AS product FROM ” . DB_PREFIX . “review r WHERE r.review_id = ‘” . (int)$review_id . “‘”);
return $query->row;
}
public function getReviews($data = array()) {
$sql = “SELECT r.review_id, pd.name, r.author, r.rating, r.status, r.date_added FROM ” . DB_PREFIX . “review r LEFT JOIN ” . DB_PREFIX . “product_description pd ON (r.product_id = pd.product_id) WHERE pd.language_id = ‘” . (int)$this->config->get(‘config_language_id’) . “‘”;
if (!empty($data[‘filter_product’])) {
$sql .= ” AND pd.name LIKE ‘” . $this->db->escape($data[‘filter_product’]) . “%'”;
}
if (!empty($data[‘filter_author’])) {
$sql .= ” AND r.author LIKE ‘” . $this->db->escape($data[‘filter_author’]) . “%'”;
}
if (isset($data[‘filter_status’]) && !is_null($data[‘filter_status’])) {
$sql .= ” AND r.status = ‘” . (int)$data[‘filter_status’] . “‘”;
}
if (!empty($data[‘filter_date_added’])) {
$sql .= ” AND DATE(r.date_added) = DATE(‘” . $this->db->escape($data[‘filter_date_added’]) . “‘)”;
}
$sort_data = array(
‘pd.name’,
‘r.author’,
‘r.rating’,
‘r.status’,
‘r.date_added’
);
if (isset($data[‘sort’]) && in_array($data[‘sort’], $sort_data)) {
$sql .= ” ORDER BY ” . $data[‘sort’];
} else {
$sql .= ” ORDER BY r.date_added”;
}
if (isset($data[‘order’]) && ($data[‘order’] == ‘DESC’)) {
$sql .= ” DESC”;
} else {
$sql .= ” ASC”;
}
if (isset($data[‘start’]) || isset($data[‘limit’])) {
if ($data[‘start’] < 0) {
$data[‘start’] = 0;
}
if ($data[‘limit’] < 1) {
$data[‘limit’] = 20;
}
$sql .= ” LIMIT ” . (int)$data[‘start’] . “,” . (int)$data[‘limit’];
}
$query = $this->db->query($sql);
return $query->rows;
}
public function getTotalReviews($data = array()) {
$sql = “SELECT COUNT(*) AS total FROM ” . DB_PREFIX . “review r LEFT JOIN ” . DB_PREFIX . “product_description pd ON (r.product_id = pd.product_id) WHERE pd.language_id = ‘” . (int)$this->config->get(‘config_language_id’) . “‘”;
if (!empty($data[‘filter_product’])) {
$sql .= ” AND pd.name LIKE ‘” . $this->db->escape($data[‘filter_product’]) . “%'”;
}
if (!empty($data[‘filter_author’])) {
$sql .= ” AND r.author LIKE ‘” . $this->db->escape($data[‘filter_author’]) . “%'”;
}
if (isset($data[‘filter_status’]) && !is_null($data[‘filter_status’])) {
$sql .= ” AND r.status = ‘” . (int)$data[‘filter_status’] . “‘”;
}
if (!empty($data[‘filter_date_added’])) {
$sql .= ” AND DATE(r.date_added) = DATE(‘” . $this->db->escape($data[‘filter_date_added’]) . “‘)”;
}
$query = $this->db->query($sql);
return $query->row[‘total’];
}
public function getTotalReviewsAwaitingApproval() {
$query = $this->db->query(“SELECT COUNT(*) AS total FROM ” . DB_PREFIX . “review WHERE status = ‘0’”);
return $query->row[‘total’];
}
}
3 admin\view\template\catalog 的 review_form.tpl 代码全部替换
<?php echo $header; ?><?php echo $column_left; ?>
<div id=”content”>
<div class=”page-header”>
<div class=”container-fluid”>
<div class=”pull-right”>
<button type=”submit” form=”form-review” data-toggle=”tooltip” title=”<?php echo $button_save; ?>” class=”btn btn-primary”><i class=”fa fa-save”></i></button>
<a href=”<?php echo $cancel; ?>” data-toggle=”tooltip” title=”<?php echo $button_cancel; ?>” class=”btn btn-default”><i class=”fa fa-reply”></i></a></div>
<h1><?php echo $heading_title; ?></h1>
<ul class=”breadcrumb”>
<?php foreach ($breadcrumbs as $breadcrumb) { ?>
<li><a href=”<?php echo $breadcrumb[‘href’]; ?>”><?php echo $breadcrumb[‘text’]; ?></a></li>
<?php } ?>
</ul>
</div>
</div>
<div class=”container-fluid”>
<?php if ($error_warning) { ?>
<div class=”alert alert-danger”><i class=”fa fa-exclamation-circle”></i> <?php echo $error_warning; ?>
<button type=”button” class=”close” data-dismiss=”alert”>×</button>
</div>
<?php } ?>
<div class=”panel panel-default”>
<div class=”panel-heading”>
<h3 class=”panel-title”><i class=”fa fa-pencil”></i> <?php echo $text_form; ?></h3>
</div>
<div class=”panel-body”>
<form action=”<?php echo $action; ?>” method=”post” enctype=”multipart/form-data” id=”form-review” class=”form-horizontal”>
<div class=”form-group required”>
<label class=”col-sm-2 control-label” for=”input-author”><?php echo $entry_author; ?></label>
<div class=”col-sm-10″>
<input type=”text” name=”author” value=”<?php echo $author; ?>” placeholder=”<?php echo $entry_author; ?>” id=”input-author” class=”form-control” />
<?php if ($error_author) { ?>
<div class=”text-danger”><?php echo $error_author; ?></div>
<?php } ?>
</div>
</div>
<!– todo –>
<!– author image –>
<div class=”form-group”>
<label class=”col-sm-2 control-label” for=”input-author_image”>entry_author_image</label>
<div class=”col-sm-10″>
<a href=”” id=”thumb-author_image” data-toggle=”image” class=”img-thumbnail”><img src=”<?php echo $author_thumb; ?>” alt=”” title=”” data-placeholder=”<?php echo $placeholder; ?>” /></a>
<input type=”hidden” name=”author_image” value=”<?php echo $author_image; ?>” id=”input-author_image” />
</div>
</div>
<!– toend –>
<div class=”form-group required”>
<label class=”col-sm-2 control-label” for=”input-product”><span data-toggle=”tooltip” title=”<?php echo $help_product; ?>”><?php echo $entry_product; ?></span></label>
<div class=”col-sm-10″>
<input type=”text” name=”product” value=”<?php echo $product; ?>” placeholder=”<?php echo $entry_product; ?>” id=”input-product” class=”form-control” />
<input type=”hidden” name=”product_id” value=”<?php echo $product_id; ?>” />
<?php if ($error_product) { ?>
<div class=”text-danger”><?php echo $error_product; ?></div>
<?php } ?>
</div>
</div>
<div class=”form-group required”>
<label class=”col-sm-2 control-label” for=”input-text”><?php echo $entry_text; ?></label>
<div class=”col-sm-10″>
<textarea name=”text” cols=”60″ rows=”8″ placeholder=”<?php echo $entry_text; ?>” id=”input-text” class=”form-control”><?php echo $text; ?></textarea>
<?php if ($error_text) { ?>
<div class=”text-danger”><?php echo $error_text; ?></div>
<?php } ?>
</div>
</div>
<div class=”form-group required”>
<label class=”col-sm-2 control-label” for=”input-name”><?php echo $entry_rating; ?></label>
<div class=”col-sm-10″>
<label class=”radio-inline”>
<?php if ($rating == 1) { ?>
<input type=”radio” name=”rating” value=”1″ checked=”checked” />
1
<?php } else { ?>
<input type=”radio” name=”rating” value=”1″ />
1
<?php } ?>
</label>
<label class=”radio-inline”>
<?php if ($rating == 2) { ?>
<input type=”radio” name=”rating” value=”2″ checked=”checked” />
2
<?php } else { ?>
<input type=”radio” name=”rating” value=”2″ />
2
<?php } ?>
</label>
<label class=”radio-inline”>
<?php if ($rating == 3) { ?>
<input type=”radio” name=”rating” value=”3″ checked=”checked” />
3
<?php } else { ?>
<input type=”radio” name=”rating” value=”3″ />
3
<?php } ?>
</label>
<label class=”radio-inline”>
<?php if ($rating == 4) { ?>
<input type=”radio” name=”rating” value=”4″ checked=”checked” />
4
<?php } else { ?>
<input type=”radio” name=”rating” value=”4″ />
4
<?php } ?>
</label>
<label class=”radio-inline”>
<?php if ($rating == 5) { ?>
<input type=”radio” name=”rating” value=”5″ checked=”checked” />
5
<?php } else { ?>
<input type=”radio” name=”rating” value=”5″ />
5
<?php } ?>
</label>
<?php if ($error_rating) { ?>
<div class=”text-danger”><?php echo $error_rating; ?></div>
<?php } ?>
</div>
</div>
<!– todo –>
<!– 添加时间 –>
<div class=”form-group”>
<label class=”col-sm-2 control-label” for=”input-date_added”>Date Added</label>
<div class=”col-sm-3″>
<div class=”input-group date”>
<input type=”text” name=”date_added” value=”<?php echo $date_added; ?>” placeholder=”<?php echo $entry_date_added; ?>” data-date-format=”YYYY-MM-DD” id=”input-date_added” class=”form-control” />
<span class=”input-group-btn”>
<button class=”btn btn-default” type=”button”><i class=”fa fa-calendar”></i></button>
</span></div>
</div>
</div>
<!– 添加时间 –>
<!– toend –>
<div class=”form-group”>
<label class=”col-sm-2 control-label” for=”input-status”><?php echo $entry_status; ?></label>
<div class=”col-sm-10″>
<select name=”status” id=”input-status” class=”form-control”>
<?php if ($status) { ?>
<option value=”1″ selected=”selected”><?php echo $text_enabled; ?></option>
<option value=”0″><?php echo $text_disabled; ?></option>
<?php } else { ?>
<option value=”1″><?php echo $text_enabled; ?></option>
<option value=”0″ selected=”selected”><?php echo $text_disabled; ?></option>
<?php } ?>
</select>
</div>
</div>
</form>
</div>
</div>
</div>
<script type=”text/javascript”><!–
$(‘input[name=\’product\’]’).autocomplete({
‘source’: function(request, response) {
$.ajax({
url: ‘index.php?route=catalog/product/autocomplete&token=<?php echo $token; ?>&filter_name=’ + encodeURIComponent(request),
dataType: ‘json’,
success: function(json) {
response($.map(json, function(item) {
return {
label: item[‘name’],
value: item[‘product_id’]
}
}));
}
});
},
‘select’: function(item) {
$(‘input[name=\’product\’]’).val(item[‘label’]);
$(‘input[name=\’product_id\’]’).val(item[‘value’]);
}
});
//点击出现日期框
$(‘.date’).datetimepicker({
pickTime: false
});
//–></script></div>
<?php echo $footer; ?>
数据库需要修改的
1 进入数据库后台
在数据库中查找 表 oc_review
该表添加指定字段 author_image
2 再将oc_review_userimg导入数据库 以下是该表的代码，导入后记得清空这张表的数据
— phpMyAdmin SQL Dump
— version 4.4.15.10
— https://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: 2018-05-30 14:10:42
— 服务器版本： 5.5.57
— PHP Version: 5.6.30
SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;
SET time_zone = “+00:00″;
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
—
— Database: `hf_vipgui_com`
—
— ——————————————————–
—
— 表的结构 `oc_review_userimg`
—
CREATE TABLE IF NOT EXISTS `oc_review_userimg` (
`id` int(11) NOT NULL,
`review_id` int(11) DEFAULT NULL,
`user_img` varchar(255) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=142 DEFAULT CHARSET=utf8;
—
— 转存表中的数据 `oc_review_userimg`
—
INSERT INTO `oc_review_userimg` (`id`, `review_id`, `user_img`) VALUES
(141, 0, ”),
(140, 0, ”),
(139, 0, ‘catalog/review/anonymus.jpg’),
(138, 0, ”),
(137, 0, ‘catalog/actcartqt.png’),
(54, 31, ‘catalog/Reviewers/T13.jpg’),
(55, 32, ‘catalog/Reviewers/T14.jpg’),
(56, 33, ‘catalog/Reviewers/T15.jpg’),
(57, 34, ‘catalog/Reviewers/T16.jpg’),
(58, 35, ‘catalog/Reviewers/T17.jpg’),
(59, 36, ‘catalog/Reviewers/T18.jpg’),
(60, 37, ‘catalog/Reviewers/T19.jpg’),
(61, 38, ‘catalog/Reviewers/T20.jpg’),
(62, 39, ‘catalog/Reviewers/T21.jpg’),
(63, 40, ‘catalog/Reviewers/T22.jpg’),
(64, 41, ‘catalog/Reviewers/T23.jpg’),
(65, 42, ‘catalog/Reviewers/T24.jpg’),
(66, 43, ‘catalog/Reviewers/T25.jpg’),
(67, 44, ‘catalog/Reviewers/T26.jpg’),
(68, 45, ‘catalog/Reviewers/T27.jpg’),
(69, 46, ‘catalog/Reviewers/T28.jpg’),
(70, 47, ‘catalog/Reviewers/T29.jpg’),
(71, 48, ‘catalog/Reviewers/T30.jpg’),
(72, 49, ‘catalog/Reviewers/T31.jpg’),
(73, 50, ‘catalog/Reviewers/T32.jpg’),
(74, 51, ‘catalog/Reviewers/10yue/T33.jpg’),
(75, 52, ‘catalog/Reviewers/10yue/T34.jpg’),
(76, 53, ‘catalog/Reviewers/10yue/T35.jpg’),
(77, 54, ‘catalog/Reviewers/10yue/T36.jpg’),
(78, 55, ‘catalog/Reviewers/10yue/T37.jpg’),
(79, 56, ‘catalog/Reviewers/10yue/T38.png’),
(80, 57, ‘catalog/Reviewers/10yue/T39.jpg’),
(81, 58, ‘catalog/Reviewers/10yue/T39.png’),
(82, 59, ‘catalog/Reviewers/10yue/T40.png’),
(83, 60, ‘catalog/Reviewers/10yue/T41.png’),
(84, 61, ‘catalog/Reviewers/10yue/T42.jpg’),
(85, 62, ‘catalog/Reviewers/10yue/T43.jpg’),
(86, 63, ‘catalog/Reviewers/10yue/T44.jpg’),
(87, 64, ‘catalog/Reviewers/10yue/T45.jpg’),
(88, 65, ‘catalog/Reviewers/10yue/T46.png’),
(89, 66, ‘catalog/Reviewers/10yue/T47.jpg’),
(90, 67, ‘catalog/Reviewers/10yue/T48.jpg’),
(91, 68, ‘catalog/Reviewers/10yue/T49.jpg’),
(92, 69, ‘catalog/Reviewers/10yue/T50.jpg’),
(93, 70, ‘catalog/Reviewers/10yue/T51.jpg’),
(94, 71, ‘catalog/Reviewers/12yue/T52.jpg’),
(95, 72, ‘catalog/Reviewers/12yue/T53.jpg’),
(96, 73, ‘catalog/Reviewers/12yue/T54.jpg’),
(97, 74, ‘catalog/Reviewers/12yue/T55.jpg’),
(98, 75, ‘catalog/Reviewers/12yue/T56.jpg’),
(99, 76, ‘catalog/Reviewers/12yue/T57.jpg’),
(100, 77, ‘catalog/Reviewers/12yue/T58.jpg’),
(101, 78, ‘catalog/Reviewers/12yue/T59.jpg’),
(102, 79, ‘catalog/review 1/T60.jpg’),
(103, 80, ‘catalog/Reviewers/20183/T61.jpg’),
(104, 81, ‘catalog/Reviewers/20183/T62.jpg’),
(105, 82, ‘catalog/Reviewers/20183/T63.jpg’),
(106, 83, ‘catalog/Reviewers/20183/T64.jpg’),
(107, 84, ‘catalog/Reviewers/20183/T65.jpg’),
(108, 85, ‘catalog/Reviewers/20183/T66.jpg’),
(109, 86, ‘catalog/Reviewers/20183/T67.jpg’),
(110, 87, ‘catalog/Reviewers/20183/T68.jpg’),
(111, 88, ‘catalog/Reviewers/20183/T69.jpg’),
(112, 89, ‘catalog/Reviewers/20183/T70.jpg’),
(113, 90, ‘catalog/Reviewers/20183/T71.jpg’),
(114, 91, ‘catalog/Reviewers/20183/T72.jpg’),
(115, 92, ‘catalog/Reviewers/20183/T73.jpg’),
(116, 93, ‘catalog/Reviewers/20183/T74.jpg’),
(117, 94, ‘catalog/Reviewers/20183/T75.jpg’),
(118, 95, ‘catalog/Reviewers/20183/T77.jpg’),
(119, 96, ‘catalog/Reviewers/20183/T80.jpg’),
(120, 97, ‘catalog/Reviewers/20183/T84.jpg’),
(121, 98, ‘catalog/Reviewers/20183/T88.jpg’),
(122, 99, ‘catalog/Reviewers/201804/T91.jpg’),
(123, 100, ‘catalog/Reviewers/201804/T93.jpg’),
(124, 101, ‘catalog/Reviewers/201804/T94.jpg’),
(125, 102, ‘catalog/Reviewers/201804/T96.jpg’),
(126, 103, ‘catalog/Reviewers/201804/T97.jpg’),
(127, 104, ‘catalog/Reviewers/201804/T98.jpg’),
(128, 105, ‘catalog/Reviewers/201804/T84.jpeg’),
(129, 107, ‘catalog/Reviewers/201804/T99.jpeg’),
(130, 108, ‘catalog/Reviewers/201805/T101.jpg’),
(131, 109, ‘catalog/Reviewers/201805/T102.jpeg’),
(132, 110, ‘catalog/Reviewers/201805/T103.jpeg’),
(133, 111, ‘catalog/Reviewers/201805/T104.jpeg’),
(134, 112, ‘catalog/Reviewers/201805/T105.jpg’),
(135, 113, ‘catalog/Reviewers/201805/T106.jpg’),
(136, 114, ‘catalog/Reviewers/201805/T107.jpg’);
—
— Indexes for dumped tables
—
—
— Indexes for table `oc_review_userimg`
—
ALTER TABLE `oc_review_userimg`
ADD PRIMARY KEY (`id`);
—
— AUTO_INCREMENT for dumped tables
—
—
— AUTO_INCREMENT for table `oc_review_userimg`
—
ALTER TABLE `oc_review_userimg`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=142;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Comments