$wppb_output .= "</div>";
$wppb_output .= "</div>";
/**
* now return the progress bar
*/
return $wppb_output;
}
?>
<div class="chapters-progress-list">
<?php
global $wpdb;
$publishedstatus = wpmanga_get('wpmanga_release_statuspublished', 0);
if ($publishedstatus != 0) {
if ($projectCategory) {
$projects = get_sListCategory($projectCategory);
}
$sql = "\t\n\t\tSELECT rel.*, p.title AS project_title\n\t\tFROM `{$wpdb->prefix}projects_releases` AS rel\n\t\tINNER JOIN `{$wpdb->prefix}projects` AS p ON rel.project_id = p.id\n\t\tINNER JOIN (\n\t\t\tSELECT project_id, MIN(`chapter`) AS chapter\n\t\t\tFROM `{$wpdb->prefix}projects_releases`\n\t\t\tWHERE `status` <> {$publishedstatus}\n\t\t\tAND `type` = 0";
if ($projects) {
$ids = "";
$first = true;
foreach ($projects as $project) {
if (!$first) {
$ids .= ",";
}
$ids .= $project->id;
$first = false;
}
$sql .= "\n\t\t\t\tAND `project_id` IN ({$ids})";
}
$sql .= "\n\t\t\tGROUP BY `project_id`\n\t\t) AS r ON rel.project_id = r.project_id and rel.chapter = r.chapter\n\t\tORDER BY project_title ASC";
/**
* Display Administrative Menu for Projects.
* @return menu
*/
function wpmanga_listProjects()
{
global $wpdb;
// Display Specified Category
if (isset($_GET['view'])) {
$projects = $wpdb->get_results($wpdb->prepare("SELECT * FROM `{$wpdb->prefix}projects` WHERE `category` = '%d' ORDER BY `title` ASC", (int) $_GET['view']));
} else {
$projects = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}projects` ORDER BY `title` ASC");
}
if ($projects || isset($_GET['view'])) {
?>
<div class="wrap">
<?php
screen_icon('edit-pages');
?>
<h2>Manga Projects <a href="?page=manga/project" class="add-new-h2">Add a New Project</a></h2>
<ul class="subsubsub">
<li class="all">
<a href="admin.php?page=manga"<?php
if (!isset($_GET['view'])) {
echo ' class="current"';
}
?>
>All <span class="count">(<?php
echo count(get_sListProject());
?>
)</span></a>
</li>
<?php
$categories = get_sListCategories();
foreach ($categories as $category) {
?>
|
<li class="">
<a href="admin.php?page=manga&view=<?php
echo $category->id;
?>
"<?php
if ($_GET['view'] == $category->id) {
echo ' class="current"';
}
?>
><?php
echo $category->name;
?>
<span class="count">(<?php
echo get_sListCategory($category->id, false);
?>
)</span></a>
</li>
<?php
}
?>
</ul>
<table class="wp-list-table widefat">
<thead>
<th scope="col" width="65px"></th>
<th scope="col">Title</th>
</thead>
<tfoot>
<th scope="col" width="65px"></th>
<th scope="col">Title</th>
</tfoot>
<tbody id="the-list">
<?php
$row = 1;
?>
<?php
foreach ($projects as $project) {
?>
<tr id="manga-<?php
echo $project->id;
?>
" <?php
if ($row % 2) {
echo 'class="alternate" ';
}
$row++;
?>
valign="top">
<td style="padding-bottom: 5px;">
<img src="<?php
echo get_sThumbnail('60x60', empty($project->image_thumbnail) ? $project->image : $project->image_thumbnail);
?>
" style="padding: 1px; border: 1px double #878e98; border-radius: 3px; -moz-border-radius: 3px; -webkit-border-radius: 3px;" width="60" height="60" alt="<?php
the_title();
?>
" />
</td>
<td>
<strong>
<a href="admin.php?page=manga/project&action=edit&id=<?php
echo $project->id;
?>
" title="Edit “<?php
echo $project->title;
?>
“"><?php
echo $project->title;
?>
</a>
</strong> <?php
if ($project->author) {
echo 'by ' . $project->author;
}
?>
<br>
Status: <?php
echo get_sTitleCategory($project->category);
?>
; Genre(s): <?php
if ($project->genre) {
echo $project->genre;
} else {
echo "N/A";
}
?>
<div class="row-actions">
<span class="edit">
<a href="admin.php?page=manga/project&action=edit&id=<?php
echo $project->id;
?>
" title="Edit this Project">Edit</a>
</span>
|
<span class="trash">
<a href="admin.php?page=manga/project&action=delete&id=<?php
echo $project->id;
?>
" title="Delete this Project">Delete</a>
</span>
|
<span class="view">
<a href="<?php
echo get_sPermalink($project);
?>
" title="View “<?php
echo $project->title;
?>
” Project Page">View</a>
</span>
</div>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<?php
} else {
?>
<script type="text/javascript">
location.replace("admin.php?page=manga/project")
</script>
<?php
}
}
if (project[id][0].last_release_title != "") { output = output + '<br /><i>' + project[id][0].last_release_title + '</i>'; }
if (project[id][0].last_release_time != "") { output = output + '<br /><font size="1">(' + project[id][0].last_release_time + ')</font>'; }
jQuery("#projects-tooltip").html(output).show();
} else {
jQuery("#projects-tooltip").html('').hide();
}
}
</script>
<?php
$categories = get_sListCategories();
$thumbnail_width = wpmanga_get('wpmanga_thumbnail_list_width', 145);
$thumbnail_height = wpmanga_get('wpmanga_thumbnail_list_height', 300);
foreach ($categories as $category) {
$projects = get_sListCategory($category->id);
if ($projects) {
echo "<h2>{$category->description}</h2>";
echo '<div id="projects-wrapper">';
foreach ($projects as $project) {
echo "<div class='item'><a href='" . get_sPermalink($project) . "'><img src='" . get_sThumbnail($thumbnail_width . "x" . $thumbnail_height, empty($project->image_thumbnail) ? $project->image : $project->image_thumbnail) . "' width='{$thumbnail_width}' height='{$thumbnail_height}' id='{$project->id}' title='{$project->name}' alt='{$project->name}'>";
if ($project->mature) {
echo "<div class='mature'>R-18</div>";
}
echo "</a></div>";
}
echo '</div><br class="wpmanga-clear"><br>';
}
}
?>
