?>
<header class="headline col-xs-12">
<h2>Add a range of issues</h2>
</header>
<div class="col-xs-12">
<form id="input_select" class="add-form" method="post" action="">
<p>Use the form below to add several issues of one series in consecutive order. To add details like <strong>quantity</strong>, <strong>custom story name</strong>, <strong>custom plot</strong>, and <strong>variant cover</strong> please edit the individual issues after submitting.</p>
<div class="row">
<div class="col-xs-12 col-md-6">
<div class="form-group">
<label for="series_name">Series</label>
<select class="form-control" name="series_id" required>
<option value="" disabled selected>Choose a series</option>
<?php
$listAllSeries = 1;
$comic = new comicSearch();
$comic->seriesList($listAllSeries, NULL, $userID);
while ($row = $comic->series_list_result->fetch_assoc()) {
$list_series_name = $row['series_name'];
$list_series_vol = $row['series_vol'];
$list_series_id = $row['series_id'];
echo '<option value="' . $list_series_id . '">' . $list_series_name . ' (' . $list_series_vol . ')</option>';
}
?>
</select>
</div>
</div>
<div class="col-xs-12 col-md-6">
<div class="form-inline">
<div class="form-group">
<label for="first_issue">First Issue</label>
}
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) {
// If it's the same as the API data, then clear it out.
$custPlot = '';
}
if (!isset($issueCondition) && $issueCondition !== '') {
$issueCondition = 'Mint';
}
$comic = new comicSearch();
$comic->issueCheck($series_id, $issue_number);
if ($comic->issueExists == 1) {
// Checks if the new issues being added are already in the master database. If so, then just adds to the user table.
$comic_id = $comic->comic_id;
$sql = "INSERT INTO users_comics (user_id, comic_id, quantity, originalPurchase, custPlot, custStoryName, issueCondition) VALUES ('{$ownerID}', '{$comic_id}', '{$quantity}', '{$originalPurchase}', '{$custPlot}', '{$custStoryName}', '{$issueCondition}')";
if (mysqli_query($connection, $sql)) {
$messageNum = 1;
} else {
$sqlMessage = '<strong class="text-warning">Error:</strong> ' . $sql . '<br>' . mysqli_error($connection);
$messageNum = 51;
}
} else {
// Comic does not exist in the master table. Add all details and then associate with the user table.
$sql = "INSERT INTO comics (series_id, issue_number, story_name, release_date, plot, cover_image, wikiUpdated)\n VALUES ('{$series_id}', '{$issue_number}', '{$story_name}', '{$release_date}', '{$plot}', '{$cover_image_file}', 1)";
if (mysqli_query($connection, $sql)) {
<?php
require_once '../views/head.php';
if ($login->isUserLoggedIn() == false) {
include __ROOT__ . "/views/not_logged_in.php";
die;
}
require_once __ROOT__ . '/classes/wikiFunctions.php';
$wiki_id = filter_input(INPUT_GET, 'wiki_id');
$comic_id = filter_input(INPUT_GET, 'comic_id');
$comic = new wikiQuery();
$comic->comicCover($wiki_id);
$comic->comicDetails($wiki_id);
$dbValues = new comicSearch();
$dbValues->issueLookup($comic_id);
?>
<title>Edit Issue :: POW! Comic Book Manager</title>
</head>
<body>
<?php
include __ROOT__ . '/views/header.php';
?>
<div class="container edit-form content">
<div class="row">
<div class="col-sm-12 headline">
<h2>Update Issue</h2>
<a href="#">< Back</a>
</div>
<div class="col-md-8 col-sm-12">
<form method="post" action="formprocess.php">
<div class="form-group">
<?php
$canonUrl = "http://comicmanager.com{$_SERVER['REQUEST_URI']}";
$articleID = "comic" . $comic_id;
$comic = new comicSearch();
$comic->issueLookup($comic_id);
$series_id = $comic->series_id;
if (!isset($userID)) {
$userID = NULL;
}
$comic->seriesInfo($series_id, $userID);
// Required values
// Standardizes values for common variables
if (isset($comic->series_name) && isset($comic->series_vol) && isset($comic->issue_number) && isset($comic->publisherName)) {
$series_name = $comic->series_name;
$series_vol = $comic->series_vol;
$series_id = $comic->series_id;
$issue_num = $comic->issue_number;
$publisherID = $comic->publisherID;
$publisherName = $comic->publisherName;
$publisherShort = $comic->publisherShort;
} else {
$messageNum = 99;
}
// Optional values below
// Making sure a release date exists or format function throws an error
if (isset($comic->release_date)) {
$release_dateShort = DateTime::createFromFormat('Y-m-d', $comic->release_date)->format('M Y');
$release_dateLong = DateTime::createFromFormat('Y-m-d', $comic->release_date)->format('M d, Y');
} else {
$release_dateShort = '';
<?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 {
require_once 'views/head.php';
if (isset($_COOKIE['user_name'])) {
$userName = $_COOKIE['user_name'];
$validUser = 1;
}
$publisherSearchId = filter_input(INPUT_GET, 'pid');
if ($publisherSearchId !== NULL) {
$listAll = 2;
}
if (isset($profile_name) && $profile_name != '') {
$user->userLookup($profile_name);
$profileID = $user->browse_user_id;
} else {
$profileID = $userID;
}
$comic = new comicSearch();
$comic->publisherList($publisherSearchId);
$publisherName = $comic->publisherName;
?>
<title><?php
echo $publisherName;
?>
:: POW! Comic Book Manager</title>
</head>
<body>
<?php
include 'views/header.php';
?>
<div class="container content">
<?php
if ($login->isUserLoggedIn() == true) {
<?php
require_once __ROOT__ . '/classes/wikiFunctions.php';
$series_id = filter_input(INPUT_POST, 'series_id');
$issue_number = filter_input(INPUT_POST, 'issue_number');
$comic = new comicSearch();
$comic->seriesInfo($series_id, $userID);
$cvVolumeID = $comic->cvVolumeID;
$series_vol = $comic->series_vol;
if (isset($comic->publisherName)) {
$publisherName = $comic->publisherName;
$publisherShort = $comic->publisherShort;
} else {
$messageNum = 60;
}
$wiki = new wikiQuery();
$wiki->issueSearch($cvVolumeID, $issue_number, $series_vol);
$searchResults = $wiki->searchResults;
if ($searchResults != false) {
$series_name = $comic->series_name;
$series_vol = $comic->series_vol;
$story_name = $wiki->storyName;
$plot = $wiki->synopsis;
$release_date = $wiki->releaseDate;
$release_dateShort = DateTime::createFromFormat('Y-m-d', $wiki->releaseDate)->format('M Y');
$release_dateLong = DateTime::createFromFormat('Y-m-d', $wiki->releaseDate)->format('M d, Y');
$script = $wiki->script;
$pencils = $wiki->pencils;
$colors = $wiki->colors;
$letters = $wiki->letters;
$editing = $wiki->editing;
<?php
require_once 'views/head.php';
$filename = $_SERVER["PHP_SELF"];
$comic_id = filter_input(INPUT_GET, 'comic_id');
$comic = new comicSearch();
$comic->issueLookup($comic_id);
$editMode = filter_input(INPUT_GET, 'type');
if ($editMode == 'edit' || $editMode == 'edit-save') {
include 'admin/formprocess.php';
}
?>
<title><?php
echo $comic->series_name . " #" . $comic->issue_number;
?>
:: POW! Comic Book Manager</title>
</head>
<body>
<?php
include 'views/header.php';
?>
<?php
if ($editMode == 'edit') {
include 'modules/edit_comic/edit_comic.php';
} else {
include 'modules/single_comic/single_comic.php';
}
?>
<?php
include 'views/footer.php';
<?php
} else {
?>
<header class="headline col-xs-12"><h2>Add Series</h2></header>
<div class="col-xs-12" id="form-series-add">
<form method="post" action="<?php
echo $filename;
?>
#addSeries" class="form-inline add-form" id="form-add-series-1">
<p>Use the form below to add a new series to your collection.</p>
<div class="form-group">
<label for="publisherID">Publisher</label>
<select class="form-control" name="publisherID" required>
<option value="">Choose a Publisher</option>
<?php
$comic = new comicSearch();
$comic->publisherList('%');
while ($row = $comic->publisher_list_result->fetch_assoc()) {
$list_publisher_name = $row['publisherName'];
$list_publisherID = $row['publisherID'];
echo '<option value="' . $list_publisherID . '">' . $list_publisher_name . '</option>';
}
?>
</select>
</div>
<div class="form-group">
<label for="series_name">Series Name</label>
<input name="series_name" class="form-control" type="text" size="50" value="" required />
</div>
<input type="hidden" name="addSeriesSearch" value="true" />
<button type="submit" name="submit" class="btn btn-lg btn-danger form-submit"><span class="icon-loading"><i class="fa fa-spinner fa-spin"></i></span><span class="text-submit"><i class="fa fa-search"></i> Search</span></button>
<?php
require_once 'views/head.php';
$issue_list = null;
$series_id = filter_input(INPUT_GET, 'series_id');
$profile_name = filter_input(INPUT_GET, 'user');
$comic = new comicSearch();
$user = new userInfo();
if (isset($profile_name) && $profile_name != '') {
$user->userLookup($profile_name);
$profileID = $user->browse_user_id;
} else {
$profileID = $userID;
}
$comic->seriesInfo($series_id, $profileID);
$comic->issuesList($series_id, $profileID);
$publisherID = $comic->publisherID;
$publisherName = $comic->publisherName;
$publisherShort = $comic->publisherShort;
$series_name = $comic->series_name;
$series_vol = $comic->series_vol;
$issue_num = $comic->issue_number;
?>
<title><?php
echo $series_name;
?>
(Vol <?php
echo $series_vol;
?>
) :: POW! Comic Book Manager</title>
</head>
<?php
require_once 'views/head.php';
$listAllSeries = 1;
$comics = new comicSearch();
$comics->seriesList($listAllSeries);
$dropdown = '<select class="form-control" name="series_name">';
$dropdown .= '<option value="default" selected>Choose a series</option>';
while ($row = $comics->series_list_result->fetch_assoc()) {
$series_id = $row['series_id'];
$series_name = $row['series_name'];
$series_vol = $row['series_vol'];
$dropdown .= '<option value="' . $series_name . '">' . $series_name . ' Vol ' . $series_vol . '</option>';
}
$dropdown .= "</select>";
$last_series_id_query = "select series_id from series ORDER BY series_id DESC LIMIT 1";
// $writer_query = "SELECT writer_name FROM writer_link LEFT JOIN writers ON (writers.writer_id = writer_link.writer_id) WHERE writer_link.comic_id = $_GET[comic_id]";
$last_series_id = mysqli_query($connection, $last_series_id_query);
// $writer = mysqli_query($connection,$writer_query);
if (mysqli_num_rows($last_series_id) > 0) {
while ($row = mysqli_fetch_assoc($last_series_id)) {
$new_series_id = ++$row['series_id'];
}
} else {
echo "0 results.";
}
mysqli_close($connection);
?>
<title>Comic Search :: POW! Comic Book Manager</title>
</head>
<body>
