$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') {
$cover_image_file = 'assets/nocover.jpg';
$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 {
if ($wiki->releaseDate !== '') {
$releaseDate = $wiki->releaseDate;
$updatedSet .= 'Release Date; ';
}
}
