function process_data($rated, $vid) { global $cp; if (is_numeric($rated) && $rated >= 2 && $rated <= 10) { $flag = video_rating($vid, $rated); if ($flag) { global $conn; $sql = "select rate,ratedby from video where VID='{$vid}'"; $rs = $conn->execute($sql); $x = $rs->getarray(); $trate = $x[0][0]; $tvote = $x[0][1]; #PROCESS RATE TO FLAG $rate = ceil($trate); $cnt = floor($rate / 2); $a_result_node =& $cp->add_node("trate"); $a_result_node->set_data($cnt); $a_result_node =& $cp->add_node("tvote"); $a_result_node->set_data($tvote); } else { $a_result_node =& $cp->add_node("trate"); $a_result_node->set_data('exist'); } } else { $a_result_node =& $cp->add_node("tvote"); $a_result_node->set_data('0'); $a_result_node =& $cp->add_node("tvote"); $a_result_node->set_data('0'); } }
$conn->execute($sql); if (mysql_affected_rows() == 1) { $sql = "update video set fav_num=fav_num+1 WHERE VID={$list['0']}"; $conn->execute($sql); } if (mysql_affected_rows() >= 1) { $msg = "The video successfully added to your favourite!"; } else { $msg = "You already added this video to your favourite."; } } } //END //RATE VIDEO if (is_numeric($rated) && $rated >= 2 && $rated <= 10) { video_rating($list[0], $rated); header("location:{$config['baseurl']}/view_video.php?viewkey={$_REQUEST['viewkey']}&berated=yes"); exit; } else { $_REQUEST[rated] = ""; } //END //PAGING STARTS if ($category == "") { $config[items_per_page] = $config[rel_video_per_page]; $ch = explode(" ", $list[2]); if (count($ch) > 1) { for ($i = 1; $i < count($ch); $i++) { $chnl .= "or keyword like '%{$ch[$i]}%'"; } }