Здравствуйте дорогие гуру!
не смогли бы помочь адаптировать данные коды под опенкарт?
в product.php
public function videolike() {
include 'configrating.php';
extract($_POST);
$user_ip = $_SERVER['REMOTE_ADDR'];
// check if the user has already clicked on the unlike (merating = 2) or the like (merating = 1)
$dislike_sql = mysql_query('SELECT COUNT(*) FROM rat_ing WHERE ip = "'.$user_ip.'" and product_id = "'.$product_id.'" and merating = 2 ');
$dislike_count = mysql_result($dislike_sql, 0);
$like_sql = mysql_query('SELECT COUNT(*) FROM rat_ing WHERE ip = "'.$user_ip.'" and product_id = "'.$product_id.'" and merating = 1 ');
$like_count = mysql_result($like_sql, 0);
if($act == 'like'): //if the user click on "like"
if(($like_count == 0) && ($dislike_count == 0)){
mysql_query('INSERT INTO rat_ing (product_id, ip, merating )VALUES("'.$product_id.'", "'.$user_ip.'", "1")');
}
if($dislike_count == 1){
mysql_query('UPDATE rat_ing SET merating = 1 WHERE product_id = '.$product_id.' and ip ="'.$user_ip.'"');
}
endif;
if($act == 'dislike'): //if the user click on "like"
if(($like_count == 0) && ($dislike_count == 0)){
mysql_query('INSERT INTO rat_ing (product_id, ip, merating )VALUES("'.$product_id.'", "'.$user_ip.'", "2")');
}
if($like_count == 1){
mysql_query('UPDATE rat_ing SET merating = 2 WHERE product_id = '.$product_id.' and ip ="'.$user_ip.'"');
}
endif;
}
в product.tpl
<?php
include 'configrating.php';
$user_ip = $_SERVER['REMOTE_ADDR'];
//function to calculate the percent
function percent($num_amount, $num_total) {
$count1 = $num_amount / $num_total;
$count2 = $count1 * 100;
$count = number_format($count2, 0);
return $count;
}
// check if the user has already clicked on the unlike (merating = 2) or the like (merating = 1)
$dislike_sql = mysql_query('SELECT COUNT(*) FROM rat_ing WHERE ip = "'.$user_ip.'" and product_id = "'.$product_id.'" and merating = 2 ');
$dislike_count = mysql_result($dislike_sql, 0);
$like_sql = mysql_query('SELECT COUNT(*) FROM rat_ing WHERE ip = "'.$user_ip.'" and product_id = "'.$product_id.'" and merating = 1 ');
$like_count = mysql_result($like_sql, 0);
// count all the merating
$merating_all_count = mysql_query('SELECT COUNT(*) FROM rat_ing WHERE product_id = "'.$product_id.'"');
$merating_all_count = mysql_result($merating_all_count, 0);
$merating_like_count = mysql_query('SELECT COUNT(*) FROM rat_ing WHERE product_id = "'.$product_id.'" and merating = 1');
$merating_like_count = mysql_result($merating_like_count, 0);
$merating_like_percent = percent($merating_like_count, $merating_all_count);
$merating_dislike_count = mysql_query('SELECT COUNT(*) FROM rat_ing WHERE product_id = "'.$product_id.'" and merating = 2');
$merating_dislike_count = mysql_result($merating_dislike_count, 0);
$merating_dislike_percent = percent($merating_dislike_count, $merating_all_count);
?>
<div class="rat_ing">
<script>
$(function(){
var product_id = <?php echo $product_id; ?>;
$('.like-btn').click(function(){
$('.dislike-btn').removeClass('dislike-h');
$(this).addClass('like-h');
$.ajax({
type:"POST",
url:"index.php?route=video/video/videolike&product_id=<?php echo $product_id; ?>",
data:'act=like&product_id='+product_id,
success: function(){
}
});
});
$('.dislike-btn').click(function(){
$('.like-btn').removeClass('like-h');
$(this).addClass('dislike-h');
$.ajax({
type:"POST",
url:"index.php?route=video/video/videolike&product_id=<?php echo $product_id; ?>",
data:'act=dislike&product_id='+product_id,
success: function(){
}
});
});
});
</script>
<div class="ld">
<div class="like-btn <?php if($like_count == 1){ echo 'like-h';} ?>"><?php echo $merating_like_count; ?></div>
<div class="dislike-btn <?php if($dislike_count == 1){ echo 'dislike-h';} ?>"><?php echo $merating_dislike_count; ?></div>
</div>
</div>
так же былоб хорошо если бы помогли сделать обновление лайков ибо количество лайков и дизлайков обновляются только после обновления страницы!
заранее всем спасибо