if ($settings["action"] == "reset") {
$mysql->query("delete from `user_contact_history` WHERE UserID = '" . $settings["userid"] . "'");
$mysql->query("delete from `user_response_history` WHERE UserID = '" . $settings["userid"] . "'");
$mysql->query("delete from `user_profile` WHERE UserID = '" . $settings["userid"] . "'");
$mysql->query("CALL `addNewUser`(" . $settings["userid"] . ")");
$mysql->query("CALL `update_knn_clusters` (" . $settings["userid"] . ", " . $settings["max_clusters"] . ")");
}
switch ($settings["action"]) {
case "rate":
$mysql->query("INSERT INTO `user_response_history` (`UserID`, `OfferID`, `Rate`, `DateTime`) VALUES ('" . $settings["userid"] . "', '" . $settings["offerid"] . "', '" . $settings["rate"] . "', NOW())");
$mysql->query("CALL `update_user_profile` (" . $settings["userid"] . ")");
$mysql->query("CALL `update_knn_clusters` (" . $settings["userid"] . ", " . $settings["max_clusters"] . ")");
case "recommend":
default:
// read history
$userHistory = getUserHistory($settings["userid"], $mysql);
$mysql->query("SET SQL_BIG_SELECTS=1");
$mysql->query("CALL `prepare_recommendations`(" . $settings["userid"] . ", " . $settings["max_offers"] . ");");
$recoQuery = "SELECT a.*, ((Rate*" . $settings["w_rate"] . " + Reviews*" . $settings["w_review"] . " + (Occurance*" . $settings["w_occurance"] . ") + (Age*" . $settings["w_age"] . ") + (Showed*" . $settings["w_contact"] . ") + (Responded*" . $settings["w_response"] . "))/(Distance*" . $settings["w_distance"] . "))" . " as Points FROM `tmp_user_recommendation` a WHERE a.UserID = " . $settings["userid"] . " ORDER BY Points DESC LIMIT " . $settings["max_offers"];
$movieResult = $mysql->query($recoQuery);
$movieCount = 0;
$recommendedList = array();
while ($row = $movieResult->fetch_assoc()) {
$recommendedList[$movieCount]['id'] = intval($row["OfferID"]);
$recommendedList[$movieCount]['cluster'] = $row["Cluster"];
$recommendedList[$movieCount]['cluster_distance'] = $row["Distance"];
$recommendedList[$movieCount]['cluster_rate'] = $row["Rate"];
$recommendedList[$movieCount]['cluster_reviews'] = $row["Reviews"];
$recommendedList[$movieCount]['rate_age'] = $row["Age"];
$recommendedList[$movieCount]['occurance'] = $row["Occurance"];
$recommendedList[$movieCount]['showed'] = $row["Showed"];
<div id="user">
<?php
getUserInfo($username, $dbconn);
?>
</div>
<div id="devices">
<?php
getUserDevices($username, $dbconn);
?>
</div>
<div id="history">
<?php
getUserHistory($username, $dbconn);
?>
</div>
<div class="clearfix"></div>
<br/>
<br/>
<br/>
<br/>
<div class="logout-container">
<a href="edit.php">
<div class="edit">Edit</div>
</a>
<br />
<a href="logout.php">
<div class="logout">Logout</div>
</a>
