$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
if ($custPlot == $plot) {
$result = $connection->query($sql);
set_time_limit(0);
while ($row = $result->fetch_assoc()) {
$wiki = new wikiQuery();
$cvVolumeID = $row['cvVolumeID'];
$issue_number = $row['issue_number'];
$series_vol = $row['series_vol'];
$comic_id = $row['comic_id'];
$wiki->issueSearch($cvVolumeID, $issue_number, $series_vol);
$cover_image = $wiki->coverURL;
if ($cover_image == 'assets/nocover.jpg') {
$cover_image_file = 'assets/nocover.jpg';
} else {
$cover_image_file = $wiki->coverFile;
$path = '../' . $cover_image_file;
$wiki->downloadFile($cover_image, $path);
}
$sql = "UPDATE comics SET comics.cover_image='{$cover_image_file}', comics.wikiUpdated=1 WHERE comics.comic_id={$comic_id}";
if (mysqli_query($connection, $sql)) {
} else {
$rangeSearch = false;
$messageNum = 51;
$sqlMessage = '<strong class="text-danger">Error</strong>: ' . $sql . '<br><code>' . mysqli_error($connection) . '</code>';
}
$message = "The following cover images were downloaded:";
$downloadList .= "URL: {$wiki->coverURL}";
$downloadList .= "<br/>";
$downloadList .= "Saved to: {$path}";
$downloadList .= "<br/>";
sleep(4);
}
