function updatePageRating($url, $url_param, $user_name, $title, $rating) { $return_string = ""; if (!isset($_SESSION['user_name'])) { $return_string .= "<returncode>0</returncode>\n"; $return_string .= "<errormessage>You're not logged in!</errormessage>\n"; return $return_string; } $query = "SELECT id FROM WebPage WHERE url = '" . $url . "'"; $result = mysql_query($query); $webpage_id = -1; if (mysql_num_rows($result) == 0) { $webpage_id = registerPage($url); } else { $result_row = mysql_fetch_assoc($result); $webpage_id = $result_row['id']; } $webpagequery_id = updatePageParameter($webpage_id, $url_param, $title); $user_id = $_SESSION['user_id']; $query = "SELECT * FROM WebPageRating WHERE user_id={$user_id}" . " AND webpagequery_id={$webpagequery_id}"; $result = mysql_query($query); if (mysql_num_rows($result) == 0) { $query2 = "INSERT INTO WebPageRating (webpagequery_id, user_id, rating)" . "VALUES({$webpagequery_id}, {$user_id}, {$rating})"; $result = mysql_query($query2); $return_string .= "<returncode>1</returncode>\n"; } else { $query2 = "UPDATE WebPageRating SET rating={$rating} " . "WHERE webpagequery_id={$webpagequery_id} AND user_id={$user_id}"; $result = mysql_query($query2); $return_string .= "<returncode>1</returncode>\n"; } return $return_string; }
function getPageRating($url, $url_param) { $return_string = ""; $query = "SELECT id FROM WebPage WHERE url = '" . $url . "'"; $result = mysql_query($query); $webpage_id = -1; if (mysql_num_rows($result) == 0) { $webpage_id = registerPage($url); } else { $result_row = mysql_fetch_assoc($result); $webpage_id = $result_row['id']; } $webpagequery_id = getPageParameterId($webpage_id, $url_param); $query = "SELECT (ROUND(AVG(rating),2)) AS avgRating FROM WebPageRating" . " WHERE webpagequery_id={$webpagequery_id}"; $result = mysql_query($query); $result_row = mysql_fetch_assoc($result); $average_rating = $result_row['avgRating']; $return_string .= "<averagerating>{$average_rating}</averagerating>\n"; if (isset($_SESSION['user_id'])) { $user_id = $_SESSION['user_id']; $query = "SELECT * FROM WebPageRating WHERE user_id={$user_id}" . " AND webpagequery_id={$webpagequery_id}"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) { $result_row = mysql_fetch_assoc($result); $user_rating = $result_row['rating']; $return_string .= "<userrating>{$user_rating}</userrating>\n"; } else { $return_string .= "<userrating>0</userrating>\n"; } } else { $return_string .= "<userrating>0</userrating>\n"; } return $return_string; }
function getWebpageId($url) { $query = "SELECT id FROM WebPage WHERE url = '" . $url . "'"; $result = mysql_query($query); $webpage_id = -1; if (mysql_num_rows($result) == 0) { $webpage_id = registerPage($url); } else { $result_row = mysql_fetch_assoc($result); $webpage_id = $result_row['id']; } return $webpage_id; }
function addTag($url, $url_param, $tag) { $return_string = ""; if (!isset($_SESSION['user_name'])) { $return_string .= "<returncode>0</returncode>\n"; $return_string .= "<errormessage>You're not logged in!</errormessage>\n"; return $return_string; } $query = "SELECT id FROM WebPage WHERE url = '" . $url . "'"; $result = mysql_query($query); $webpage_id = -1; if (mysql_num_rows($result) == 0) { $webpage_id = registerPage($url); } else { $result_row = mysql_fetch_assoc($result); $webpage_id = $result_row['id']; } $webpagequery_id = getPageParameterId($webpage_id, $url_param); $user_id = $_SESSION['user_id']; $query = "SELECT * FROM Tag WHERE text='{$tag}'"; $result = mysql_query($query); if (mysql_num_rows($result) == 0) { $query2 = "INSERT INTO Tag (text) VALUES('{$tag}')"; $result = mysql_query($query2); $result = mysql_query($query); } $result_row = mysql_fetch_assoc($result); $tag_id = $result_row['id']; $query = "SELECT * FROM WebPageTag " . "WHERE webpagequery_id={$webpagequery_id} " . "AND user_id={$user_id} AND tag_id={$tag_id}"; $result = mysql_query($query); if (mysql_num_rows($result) == 0) { $query = "INSERT INTO WebPageTag (webpagequery_id, user_id, tag_id) " . "VALUES({$webpagequery_id}, {$user_id}, {$tag_id})"; $result = mysql_query($query); } $return_string .= "<returncode>1</returncode>"; return $return_string; }
function getComments($url) { $query = "SELECT id FROM WebPage WHERE url = '" . $url . "'"; $result = mysql_query($query); $return_val = array(); if (mysql_num_rows($result) > 0) { $result_row = mysql_fetch_assoc($result); $return_string = "<chatroomjid>room_" . $result_row['id'] . "</chatroomjid>\n"; $query = "SELECT Comment.*,User.name,Rating.total_rating " . "FROM (Comment " . " JOIN User ON Comment.user_id = User.id " . " LEFT JOIN (SELECT comment_id, " . " SUM(rating) as total_rating " . " FROM CommentRating GROUP BY comment_id) as Rating " . " ON Rating.comment_id=Comment.id) " . " WHERE Comment.webpage_id = " . $result_row['id'] . " ORDER BY id"; $result = mysql_query($query); $return_string .= "<resultno>" . mysql_num_rows($result) . "</resultno>\n"; $return_string .= "<comments>\n"; while ($result_row = mysql_fetch_assoc($result)) { $return_string .= "<comment id=\"comment_" . $result_row['id'] . "\""; if ($result_row['parent_id'] != null) { $return_string .= " parentid=\"comment_" . strval($result_row['parent_id']) . "\""; } $return_string .= ">\n"; if ($result_row['total_rating'] == null) { $result_row['total_rating'] = 0; } $return_string .= "<rating>" . $result_row['total_rating'] . "</rating>"; $return_string .= "<webpageid>" . strval($result_row['web_page_id']) . "</webpageid>\n"; $return_string .= "<username>" . strval($result_row['name']) . "</username>\n"; $return_string .= "<timestamp>" . strval($result_row['timestamp']) . "</timestamp>\n"; $return_string .= "<text>" . htmlentities($result_row['text']) . "</text>\n"; $return_string .= "</comment>\n"; } $return_string .= "</comments>\n"; } else { $page_id = registerPage($url); $return_string = "<chatroomjid>room_{$page_id}</chatroomjid>\n"; $return_string .= "<resultno>0</resultno>"; } return $return_string; }
function updateTitle($url, $url_param, $title) { $return_string = ""; if (!isset($_SESSION['user_name'])) { $return_string .= "<returncode>0</returncode>\n"; $return_string .= "<errormessage>You're not logged in!</errormessage>\n"; return $return_string; } $query = "SELECT id FROM WebPage WHERE url = '{$url}'"; $result = mysql_query($query); $webpage_id = -1; if (mysql_num_rows($result) == 0) { $webpage_id = registerPage($url); } else { $result_row = mysql_fetch_assoc($result); $webpage_id = $result_row['id']; } $webpagequery_id = getPageParameterId($webpage_id, $url_param); $user_id = $_SESSION['user_id']; $query = "UPDATE WebPageQuery SET title='" . mysql_real_escape_string($title) . "' WHERE id={$webpagequery_id}"; $result = mysql_query($query); $return_string .= "<returncode>1</returncode>"; return $return_string; }
function mainLogic() { global $debugMode, $option, $requestCategory, $optionValue, $serverName; //$category = $data[4]; switch ($option) { case "newEntry": if ($debugMode == "on") { echo "Calling newEntryPass()"; } newEntryForm(); break; case "newEntryForm": if ($debugMode == "on") { echo "Calling newEntryForm()"; } newEntryForm(); break; case "newEntrySubmit": newEntrySubmit(); break; case "newEntrySuccess": newEntrySuccess(); break; case "mainPage": $requestCategory = ''; listPosts(); $referrer = $serverName . $_SERVER['REQUEST_URI']; $_SESSION['referrer'] = $referrer; break; case "adminPage": adminPage(); break; case "adminPageBasic": if ($debugMode == "on") { echo "adminPageBasic " . $_POST['process'] . "<br>"; } adminPageBasic(); break; case "adminPageBasicSubmit": if ($debugMode == "on") { echo "adminPageBasicSubmit " . $_POST['process'] . "<br>"; } adminPageBasicSubmit(); break; case "adminPageAdvanced": if ($debugMode == "on") { echo "adminPageAdvanced " . $_POST['process'] . "<br>"; } adminPageAdvanced(); break; case "adminPageAdvancedSubmit": if ($debugMode == "on") { echo "adminPageAdvancedSubmit " . $_POST['process'] . "<br>"; } adminPageAdvancedSubmit(); break; case "adminPageAuthors": if ($debugMode == "on") { echo "adminPageAuthors " . $_POST['process'] . "<br>"; } adminPageAuthors(); break; case "adminAuthorsAdd": if ($debugMode == "on") { echo "adminAuthorsAdd " . $_POST['process'] . "<br>"; } adminAuthorsAdd(); break; case "adminAuthorsEdit": if ($debugMode == "on") { echo "adminAuthorsEdit " . $_POST['process'] . "<br>"; } adminAuthorsEdit(); break; case "adminPluginsSubmit": case "adminPagePlugins": adminPagePlugins(); break; case "adminPageModerate": case "adminModerateSubmit": adminPageModerate(); break; case "deleteEntry": if ($debugMode == "on") { echo "deleteEntry " . $_POST['process'] . "<br>"; } //deleteEntrySubmit(); if ($_POST['process'] !== "deleteEntrySubmit") { deleteEntryForm(); } else { deleteEntrySubmit(); } break; case "editEntry": if ($debugMode == "on") { echo "editEntry " . $_POST['process'] . "<br>"; } editEntryForm(); $referrer = $serverName . $_SERVER['REQUEST_URI']; $_SESSION['referrer'] = $referrer; break; case "editEntryForm": editEntryForm(); break; case "editEntrySubmit": editEntrySubmit(); break; case "posts": viewEntry(); break; case "archives": viewArchive(); break; case "month": viewArchiveMonth(); break; case "category": $requestCategory = $optionValue; listPosts(); $referrer = $serverName . $_SERVER['REQUEST_URI']; $_SESSION['referrer'] = $referrer; break; case "searchPosts": searchPosts(); break; case "sendComment": sendComment(); break; case "sendCommentSuccess": sendCommentSuccess(); break; case "listAllComments": listAllComments(); break; case "deleteComment": if ($debugMode == "on") { echo "deleteEntry " . $_POST['process'] . "<br>"; } $process = isset($_POST['process']) ? $_POST['process'] : ""; if ($process !== "deleteCommentSubmit") { deleteCommentForm(); } else { deleteCommentSubmit(); } break; case "loginPage": loginPage(); break; case "logoutPage": logoutPage(); break; case "registerPage": registerPage(); break; case "registerPageSubmit": registerPageSubmit(); break; case "forgotPass": forgotPass(); break; case "forgotPassSubmit": forgotPassSubmit(); break; case "activation": activation(); break; case "myProfile": myProfile(); break; case "myProfileSubmit": myProfileSubmit(); break; case "pluginFunction1": pluginFunction1(); break; case "pluginFunction2": pluginFunction2(); break; case "pluginFunction3": pluginFunction3(); break; case "pluginFunction4": pluginFunction4(); break; case "pluginFunction5": pluginFunction5(); break; } }
function getPageRatingBulk($urlString, $paramsString, $user_name) { $return_string = ""; $urls = explode("|||", $urlString); $params = explode("|||", $paramsString); $i = 0; $url_sql_string = "("; $params_sql_string = "("; for ($i = 0; $i < count($urls); $i++) { $url_sql_string .= "'" . $urls[$i] . "', "; $params_sql_string .= "'" . $params[$i] . "', "; } $url_sql_string = substr($url_sql_string, 0, strlen($url_sql_string) - 2); $url_sql_string .= ")"; $params_sql_string = substr($params_sql_string, 0, strlen($params_sql_string) - 2); $params_sql_string .= ")"; $user_id = -1; if (isset($_SESSION['user_id'])) { $user_id = $_SESSION['user_id']; } $query = "SELECT tab_1.link, tab_1.avg_rating, IFNULL(user_rating, 0) AS user_rating " . "FROM " . " (SELECT CONCAT(wp.url, wpq.query) as link, (ROUND(AVG(wpr.rating),2)) AS avg_rating " . " FROM " . " (SELECT id, url FROM WebPage WHERE url IN " . $url_sql_string . ") wp, " . " (SELECT * FROM WebPageQuery WHERE query IN " . $params_sql_string . ") wpq, " . " WebPageRating wpr " . " WHERE wp.id = wpq.webpage_id " . " AND wpq.id = wpr.webpagequery_id " . " GROUP BY CONCAT(wp.url, wpq.query) " . " ) tab_1 LEFT JOIN " . " (SELECT CONCAT(wp.url, wpq.query) as link, (ROUND(AVG(wpr.rating),2)) AS user_rating " . " FROM " . " (SELECT id, url FROM WebPage WHERE url IN " . $url_sql_string . ") wp, " . " (SELECT * FROM WebPageQuery WHERE query IN " . $params_sql_string . ") wpq, " . " WebPageRating wpr " . " WHERE wp.id = wpq.webpage_id " . " AND wpq.id = wpr.webpagequery_id " . " AND wpr.user_id = {$user_id} " . " GROUP BY CONCAT(wp.url, wpq.query) " . " ) tab_2 ON (tab_1.link = tab_2.link)"; $result = mysql_query($query); while ($result_row = mysql_fetch_assoc($result)) { $current_link = $result_row['link']; $current_average_rating = $result_row['avg_rating']; $current_user_rating = $result_row['user_rating']; for ($i = 0; $i < count($urls); $i++) { $link = $urls[$i] . $params[$i]; if ($current_link == $link) { $return_string .= "<link num='{$i}'>\n"; $return_string .= "<averagerating>{$current_average_rating}</averagerating>\n"; $return_string .= "<userrating>{$current_user_rating}</userrating>\n"; $return_string .= "</link>\n"; } } } return $return_string; // ------------------------------------------------------------------- foreach ($urls as $url) { $query = "SELECT id FROM WebPage WHERE url = '" . $url . "'"; $result = mysql_query($query); $webpage_id = -1; if (mysql_num_rows($result) == 0) { $webpage_id = registerPage($url); } else { $result_row = mysql_fetch_assoc($result); $webpage_id = $result_row['id']; } $url_param = $params[$i]; $webpagequery_id = getPageParameterId($webpage_id, $url_param); $query = "SELECT (ROUND(AVG(rating),2)) AS avgRating FROM WebPageRating" . " WHERE webpagequery_id={$webpagequery_id}"; $result = mysql_query($query); $average_rating = 0; $result_row = mysql_fetch_assoc($result); if ($result_row['avgRating']) { $average_rating = $result_row['avgRating']; } if ($average_rating > 0) { $return_string .= "<link num='{$i}'>\n"; $return_string .= "<averagerating>{$average_rating}</averagerating>\n"; if (isset($_SESSION['user_id'])) { $user_id = $_SESSION['user_id']; $query = "SELECT * FROM WebPageRating WHERE user_id={$user_id}" . " AND webpagequery_id={$webpagequery_id}"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) { $result_row = mysql_fetch_assoc($result); $user_rating = $result_row['rating']; $return_string .= "<userrating>{$user_rating}</userrating>\n"; } else { $return_string .= "<userrating>0</userrating>\n"; } } else { $return_string .= "<userrating>0</userrating>\n"; } $return_string .= "</link>\n"; } $i++; } return $return_string; }