$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}");
