?> <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>