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