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;
}
