$comic->seriesInfo($series_id, $ownerID); $series_name = $comic->series_name; $series_vol = $comic->series_vol; $cvVolumeID = $comic->cvVolumeID; foreach ($issue_list as $issue_number) { $comic->issueCheck($series_id, $issue_number); if ($comic->issueExists == 1) { $sql = "INSERT INTO users_comics (user_id, comic_id, originalPurchase)\n VALUES ('{$ownerID}', '{$comic->comic_id}', '{$originalPurchase}')"; if (mysqli_query($connection, $sql)) { $listSearch = true; } else { $messageNum = 61; $sqlMessage = '<strong class="text-danger">Error</strong>: ' . $sql . '<br><code>' . mysqli_error($connection) . '</code>'; } } else { $wiki = new wikiQuery(); $wiki->issueSearch($cvVolumeID, $issue_number, $series_vol); $release_date = $wiki->releaseDate; $plot = addslashes($wiki->synopsis); $story_name = addslashes($wiki->storyName); $cover_image = $wiki->coverURL; $coverThumbURL = $wiki->coverThumbURL; $coverSmallURL = $wiki->coverSmallURL; $script = $wiki->script; $pencils = $wiki->pencils; $colors = $wiki->colors; $letters = $wiki->letters; $editing = $wiki->editing; $coverArtist = $wiki->coverArtist; $creatorsList = $wiki->creatorsList; if ($cover_image == 'assets/nocover.jpg') {
$originalPurchase = filter_input(INPUT_POST, 'singleOriginalPurchase'); $creatorsList = filter_input(INPUT_POST, 'creatorsList'); $quantity = filter_input(INPUT_POST, 'quantity'); $issueCondition = filter_input(INPUT_POST, 'issueCondition'); // Formats date if ($released_date == 00 - 00 - 00) { $release_date = ""; } else { $release_date = $released_date; } // Downloads the cover from Wikia and stores is locally, otherwise show the nocover.jpg image. if ($cover_image == 'assets/nocover.jpg') { $cover_image_file = 'assets/nocover.jpg'; } else { $path = __ROOT__ . '/' . $cover_image_file; $wiki = new wikiQuery(); $wiki->downloadFile($cover_image, $path); } if ($coverThumbFile == 'assets/nocover.jpg') { $noThumb = 1; } else { $path = __ROOT__ . '/' . $coverThumbFile; $wiki->downloadFile($coverThumbURL, $path); } if ($coverSmallFile == 'assets/nocover.jpg') { $noSmall = 1; } else { $path = __ROOT__ . '/' . $coverSmallFile; $wiki->downloadFile($coverSmallURL, $path); } // Checks if the plot has been modified by the user
<?php require_once 'views/head.php'; require_once 'classes/wikiFunctions.php'; $wiki_id = filter_input(INPUT_GET, 'wiki_id'); $comic = new wikiQuery(); $comic->comicCover($wiki_id); $comic->comicDetails($wiki_id); ?> <title>Add Issue :: POW! Comic Book Manager</title> </head> <body> <div class="container"> <div class="row"> <div class="col-sm-12"> <img src="<?php echo $comic->coverURL; ?> " alt="Cover" /> <h3><?php echo $comic->wikiTitle; ?> </h3> <p><?php echo $comic->storyName; ?> </p> <p><?php echo $comic->synopsis; ?> </p>
<?php $type = $_GET['type']; if ($type) { require_once __ROOT__ . '/classes/wikiFunctions.php'; require_once __ROOT__ . '/classes/functions.php'; switch ($type) { case 'edit': $ownerID = __userID__; $updatedSet = ''; $comic_id = filter_input(INPUT_GET, 'comic_id'); $comic = new comicSearch(); $wiki = new wikiQuery(); $comic->issueLookup($comic_id); $series_id = $comic->series_id; $comic->seriesInfo($series_id, $userID); $issue_number = $comic->issue_number; $cvVolumeID = $comic->cvVolumeID; $series_vol = $comic->series_vol; $series_name = $comic->series_name; $originalPurchase = $comic->originalPurchase; $quantity = $comic->issue_quantity; $issue_condition = $comic->issueCondition; // Wiki updates automatically if field is blank $wiki->issueSearch($cvVolumeID, $issue_number, $series_vol); $creatorsList = $wiki->creatorsList; // Release Date if ($comic->release_date != '') { if ($wiki->releaseDate !== '' && $wiki->releaseDate == $comic->release_date) { $releaseDate = $comic->release_date; } else {
<?php require_once '../views/head.php'; require_once __ROOT__ . '/classes/wikiFunctions.php'; ?> <title>Maintenance :: POW! Comic Book Manager</title> </head> <body> <?php include '../views/header.php'; if ($login->isUserLoggedIn() == true) { //fill in missing wiki IDs $fillIn = new wikiQuery(); $fillIn->addWikiID(); //Update records that have a wiki id, but have not been updated with information from the marvel wikia $fillIn->addDetails(); $time = microtime(true) - $_SERVER["REQUEST_TIME_FLOAT"]; } else { include '../views/not_logged_in.php'; } ?> <div class="container"> <div class="row"> <div class="col-sm-12"> <table> <thead> <tr> <th>Results: <?php echo $fillIn->AddWikiIDMsg . " "; echo $fillIn->addDetailsMsg;
<?php require_once __ROOT__ . '/classes/wikiFunctions.php'; $ownerID = __userID__; $updatedSet = ''; $comic_id = filter_input(INPUT_POST, 'comic_id'); echo $comic_id; $comic = new comicSearch(); $wiki = new wikiQuery(); $comic->issueLookup($comic_id); $series_id = $comic->series_id; $comic->seriesInfo($series_id, $userID); $issue_number = $comic->issue_number; $cvVolumeID = $comic->cvVolumeID; $series_vol = $comic->series_vol; $series_name = $comic->series_name; $originalPurchase = $comic->originalPurchase; $quantity = $comic->issue_quantity; $condition = $comic->issue_condition; // Wiki updates automatically if field is blank $wiki->issueSearch($cvVolumeID, $issue_number); $creatorsList = $wiki->creatorsList; // Release Date if ($comic->release_date != '') { if ($wiki->releaseDate !== '' && $wiki->releaseDate == $comic->release_date) { $releaseDate = $comic->release_date; } else { $releaseDate = $wiki->releaseDate; $updatedSet .= 'Release Date; '; } } else {
<?php // ADD SERIES: Part one of the series process. Displays API search results. require_once __ROOT__ . '/classes/wikiFunctions.php'; $series_name = filter_input(INPUT_POST, 'series_name'); $publisherID = filter_input(INPUT_POST, 'publisherID'); $series_vol = filter_input(INPUT_POST, 'series_vol'); $wiki = new wikiQuery(); $wiki->seriesSearch("{$series_name}");