public static function loadBasicDummyData()
{
TestManager::clearDatabase();
$database = new DatabaseManager();
UserManager::verifyTable($database);
AddonManager::verifyTable($database);
BoardManager::verifyTable($database);
TagManager::verifyTable($database);
GroupManager::verifyTable($database);
DependencyManager::verifyTable($database);
CommentManager::verifyTable($database);
RatingManager::verifyTable($database);
BuildManager::verifyTable($database);
StatManager::verifyTable($database);
ScreenshotManager::verifyTable($database);
if (!$database->query("INSERT INTO `addon_boards` (name, video, description) VALUES ('General Content', 'general_content_bg', 'Bricks, Events, Sounds, Prints, Environments, and much more!')")) {
throw new Exception("Database error: " . $database->error());
}
if (!$database->query("INSERT INTO `addon_boards` (name, video, description) VALUES ('Minigames', 'minigames_bg', 'Weapons, Vehicles, Gamemodes, and all your gaming needs!')")) {
throw new Exception("Database error: " . $database->error());
}
if (!$database->query("INSERT INTO `addon_boards` (name, video, description) VALUES ('Client Mods', 'client_mods_bg', 'Mods that run on your client.')")) {
throw new Exception("Database error: " . $database->error());
}
if (!$database->query("INSERT INTO `addon_boards` (name, video, description) VALUES ('Bargain Bin', 'bargain_bin_bg', 'A home for \\'special\\' content.')")) {
throw new Exception("Database error: " . $database->error());
}
if (!$database->query("INSERT INTO `users` (username, blid, password, email, salt, verified) VALUES ('testuser', '4833', '1d8436e97ef95a7a6151f47b909167c77cfe1985ee5500efa8d46cfe825abc59', '*****@*****.**', '273eb4', '1')")) {
throw new Exception("Database error: " . $database->error());
}
//the default json types likely need to be reworked
if (!$database->query("INSERT INTO `addon_addons` (board, blid, name, filename, description, approved, versionInfo, authorInfo, reviewInfo) VALUES ('1', '4833', 'crapy adon', 'sciprt_hax.zip', 'bad addone pls delete', '1', '{}', '[]', '[]')")) {
throw new Exception("Database error: " . $database->error());
}
StatManager::addStatsToAddon(1);
if (!$database->query("INSERT INTO `addon_tags` (name, base_color, icon) VALUES ('dum tag', 'ff6600', 'brokenimage')")) {
throw new Exception("Database error: " . $database->error());
}
if (!$database->query("INSERT INTO `addon_tagmap` (aid, tid) VALUES ('1', '1')")) {
throw new Exception("Database error: " . $database->error());
}
if (!$database->query("INSERT INTO `group_groups` (leader, name, description, color, icon) VALUES ('4833', 'legion of dumies', 'a group for people who just want to be in a group', '00ff00', 'brokenimage')")) {
throw new Exception("Database error: " . $database->error());
}
if (!$database->query("INSERT INTO `group_usermap` (gid, blid, administrator) VALUES ('1', '4833', '1')")) {
throw new Exception("Database error: " . $database->error());
}
if (!$database->query("INSERT INTO `addon_comments` (blid, aid, comment) VALUES ('4833', '1', 'glorious addon comrade')")) {
throw new Exception("Database error: " . $database->error());
}
if (!$database->query("INSERT INTO `addon_ratings` (blid, aid, rating) VALUES ('4833', '1', '1')")) {
throw new Exception("Database error: " . $database->error());
}
}
public static function getRatingsFromAddon($aid)
{
$database = new DatabaseManager();
RatingManager::verifyTable($database);
$resource = $database->query("SELECT * FROM `addon_ratings` WHERE `aid` = '" . $database->sanitize($aid) . "'");
if (!$resource) {
throw new Exception("Database error: " . $database->error());
}
$addonRatings = [];
while ($row = $resource->fetch_object()) {
$addonRatings[] = RatingManager::getFromID($row->id, $row)->getID();
}
$resource->close();
return $addonRatings;
}
</div> <!--entry_record_value-->
</div> <!--entry_record_value-->
<!--- comments section finish --->
<!--- rating section start --->
<?php
if ($user_logged_in) {
//check if user logged in, if yes, show rating and report part
?>
<div class="entry_record">
<div class="entry_record_title">Do you like this entry?</div>
<div class="entry_record_value">
<?php
//get the like number
$rm = new RatingManager();
$like_entry = "";
if ($rm->hasRatingByEntityLikeUser("ent" . $entryId, $loggedIn_userId) == 1) {
$like_entry = "Unlike";
} else {
if ($rm->hasRatingByEntityDislikeUser("ent" . $entryId, $loggedIn_userId) == 1) {
$like_entry = "Like";
} else {
$like_entry = "";
}
}
$likeRating = $rm->CountRatingByLikeEntity("ent" . $entryId);
$likeRating = $likeRating > 0 ? $likeRating : 0;
$dislikeRating = $rm->CountRatingByDislikeEntity("ent" . $entryId);
$dislikeRating = $dislikeRating > 0 ? $dislikeRating : 0;
if ($like_entry != "") {
$new_rating->setLikeUserId($like_user_id);
$new_rating->setDislikeUserId($dislike_user_id);
$new_rm = new RatingManager();
$new_rating_id = $new_rm->addRating($new_rating);
if ($new_rating_id > 0) {
echo "Adding a new rating succeeded.";
} else {
echo "Adding a new rating failed.";
}
/* } else {
echo "Passing comment id and user id are failed.";
}*/
} else {
if ($rating_like_exist == 1 || $rating_dislike_exist == 1) {
//update a rating
$ratingManager = new RatingManager();
if ($is_like == "Y") {
$like_user_id = $user_id;
$dislike_user_id = NULL;
$edited_rating = $ratingManager->getRatingByEntityDislikeUser($entity_id, $user_id);
} else {
if ($is_like == "N") {
$like_user_id = NULL;
$dislike_user_id = $user_id;
$edited_rating = $ratingManager->getRatingByEntityLikeUser($entity_id, $user_id);
}
}
//if($comment_id != "" && $user_id !="") {
$edited_rating = isset($edited_rating) ? $edited_rating : "";
$edited_rating->setLikeUserId($like_user_id);
$edited_rating->setDislikeUserId($dislike_user_id);
$created_by = $coms->getCreatedBy();
//get the username who created the comment
$userManager = new UserManager();
$created_user = $userManager->getUserByUserId($created_by);
$created_user_name = $created_user->getLogin();
//define ids for html tags in the loop
$edit_icon_id = "editIcon_" . $id;
$edit_area_id = "edit_area_" . $id;
$edit_comment_text_id = "comment_text_id_" . $id;
$form_name = "formEditComment_" . $id;
$edit_comment_textarea = "editCommentText_" . $id;
$edit_comment_input_hidden = "editCommentId_" . $id;
$edit_comment_submit = "editCommentSub_" . $id;
$delete_icon_id = "deleteIcon_" . $id;
$comment_like_id = $user_id . "_commentLike_" . $id;
$ratingManager = new RatingManager();
$rating_content = "";
if ($ratingManager->hasRatingByEntityLikeUser("com" . $id, $created_by) == 1) {
$rating_content = "Unlike";
} else {
if ($ratingManager->hasRatingByEntityDislikeUser("com" . $id, $created_by) == 1 || $ratingManager->hasRatingByEntityLikeUser("com" . $id, $created_by) == 0 || $ratingManager->hasRatingByEntityDislikeUser("com" . $id, $created_by) == 0) {
$rating_content = "Like";
}
}
$likeRating = $ratingManager->CountRatingByLikeEntity("com" . $id);
$likeRating = $likeRating > 0 ? $likeRating : "";
$comment_report_id = $user_id . "_reportCommentId_" . $id;
?>
<div>
<div>
$new_rating->setLikeUserId($like_user_id);
$new_rating->setDislikeUserId($dislike_user_id);
$new_rm = new RatingManager();
$new_rating_id = $new_rm->addRating($new_rating);
if ($new_rating_id > 0) {
echo "Adding a new rating succeeded.";
} else {
echo "Adding a new rating failed.";
}
/* } else {
echo "Passing comment id and user id are failed.";
}*/
} else {
if ($rating_like_exist == 1 || $rating_dislike_exist == 1) {
//update a rating
$ratingManager = new RatingManager();
if ($is_like == "Y") {
$like_user_id = $user_id;
$dislike_user_id = NULL;
$edited_rating = $ratingManager->getRatingByEntityDislikeUser($entity_id, $user_id);
} else {
if ($is_like == "N") {
$like_user_id = NULL;
$dislike_user_id = $user_id;
$edited_rating = $ratingManager->getRatingByEntityLikeUser($entity_id, $user_id);
}
}
//if($comment_id != "" && $user_id !="") {
$edited_rating = isset($edited_rating) ? $edited_rating : "";
$edited_rating->setLikeUserId($like_user_id);
$edited_rating->setDislikeUserId($dislike_user_id);
