|
|
<?php
|
|
|
|
|
|
// Book: The offset from 0 at the beginning of time
|
|
|
// Page: The offset from 0 at the beginning of the volume
|
|
|
|
|
|
class Strip
|
|
|
{
|
|
|
public $id;
|
|
|
public $old_id;
|
|
|
public $published;
|
|
|
public $media;
|
|
|
public $type;
|
|
|
public $title;
|
|
|
public $book;
|
|
|
public $page;
|
|
|
}
|
|
|
|
|
|
// old_id is used to detect alterations to the strip id in forms. Not saved in database.
|
|
|
// media is imagetype
|
|
|
|
|
|
// Strip id is automatically incremented
|
|
|
function insertstrip(&$strip) {
|
|
|
global $dbConnection;
|
|
|
|
|
|
$strip->book = ($strip->book == '') ? 'NULL' : (int)$strip->book;
|
|
|
$strip->page = ($strip->page == '') ? 'NULL' : (int)$strip->page;
|
|
|
|
|
|
$dbConnection->beginTransaction();
|
|
|
$newid = $dbConnection->fetchColumn('SELECT MAX(id) FROM strip') + 1;
|
|
|
|
|
|
$sql = 'INSERT INTO strip (id, published, media, type, title, book, page) VALUES(?, FROM_UNIXTIME(?), ?, ?, ?, ?, ?)';
|
|
|
$stmt = $dbConnection->prepare($sql);
|
|
|
|
|
|
$stmt->bindValue(1, $newid);
|
|
|
$stmt->bindValue(2, $strip->published, PDO::PARAM_INT);
|
|
|
$stmt->bindValue(3, $strip->media, PDO::PARAM_INT);
|
|
|
$stmt->bindValue(4, $strip->type, PDO::PARAM_INT);
|
|
|
$stmt->bindValue(5, trim($strip->title));
|
|
|
$stmt->bindValue(6, $strip->book);
|
|
|
$stmt->bindValue(7, $strip->page);
|
|
|
|
|
|
$r = $stmt->execute();
|
|
|
if( !$r ) {
|
|
|
$dbConnection->rollback();
|
|
|
return false;
|
|
|
}
|
|
|
$dbConnection->commit();
|
|
|
adminlog("Comic ".$newid." posted.", MTS_STRIP, MTA_ADD);
|
|
|
|
|
|
$strip->id = $newid;
|
|
|
if( $strip->id == 0 ) return false;
|
|
|
return true;
|
|
|
}
|
|
|
|
|
|
function updatestrip(&$strip) {
|
|
|
global $dbConnection;
|
|
|
|
|
|
$strip->book = ($strip->book === '') ? 'NULL' : (int)$strip->book;
|
|
|
$strip->page = ($strip->page === '') ? 'NULL' : (int)$strip->page;
|
|
|
|
|
|
$dbConnection->beginTransaction();
|
|
|
|
|
|
$sql = 'UPDATE strip SET published = FROM_UNIXTIME(?), media = ?, type = ?, title = ?, book = ?, page = ? WHERE id = ?';
|
|
|
$stmt = $dbConnection->prepare($sql);
|
|
|
|
|
|
$stmt->bindValue(1, $strip->published, PDO::PARAM_INT);
|
|
|
$stmt->bindValue(2, $strip->media, PDO::PARAM_INT);
|
|
|
$stmt->bindValue(3, $strip->type, PDO::PARAM_INT);
|
|
|
$stmt->bindValue(4, trim($strip->title));
|
|
|
$stmt->bindValue(5, $strip->book, PDO::PARAM_INT);
|
|
|
$stmt->bindValue(6, $strip->page, PDO::PARAM_INT);
|
|
|
$stmt->bindValue(7, $strip->id, PDO::PARAM_INT);
|
|
|
|
|
|
$stmt->execute();
|
|
|
$dbConnection->commit();
|
|
|
adminlog("Comic ".$strip->id." modified.", MTS_STRIP, MTA_MODIFY);
|
|
|
return true;
|
|
|
}
|
|
|
|
|
|
// Delete destination strip from DB and FS, and Update/Rename the source strip into place. Destructive Move!
|
|
|
function move_strip($from_id, $to_id)
|
|
|
{
|
|
|
global $dbConnection;
|
|
|
$from_id = (int) $from_id;
|
|
|
$to_id = (int) $to_id;
|
|
|
|
|
|
// Ensure our source exists
|
|
|
$num_strips = $dbConnection->fetchColumn('SELECT COUNT(*) FROM strip WHERE id = ?', array($from_id));
|
|
|
if($num_strips < 1)
|
|
|
mtdie("Cannot move strip number $from_id, because it cannot be found in database.");
|
|
|
|
|
|
// Ready the destination
|
|
|
deletestrip( $to_id );
|
|
|
|
|
|
// Update database
|
|
|
$dbConnection->executeUpdate('UPDATE strip SET id = ? WHERE id = ?', array($to_id, $from_id));
|
|
|
$strip = $dbConnection->executeQuery('SELECT strip.id, extension FROM strip, media_t WHERE media_t.id = strip.media AND strip.id = ?', array($to_id))->fetch();
|
|
|
|
|
|
// Update filesystem
|
|
|
foreach(glob(sprintf(SITE_PATH_ABS.'/'.SITE_STRIP.'/%04d.*', $from_id)) as $item) {
|
|
|
preg_match('/\.(\w{3})$/', $item, $match) or die("Invalid filename: $item");
|
|
|
rename($item, sprintf(SITE_PATH_ABS.'/'.SITE_STRIP.'/%04d.%s', $to_id, $match[1]));
|
|
|
}
|
|
|
}
|
|
|
|
|
|
// Classic swap function, using strip 0 as temporary storage. Can cause concurrency issues. FLOCK!
|
|
|
function swap_strips( $from_id, $to_id ) {
|
|
|
move_strip($from_id, 0);
|
|
|
move_strip($to_id, $from_id);
|
|
|
move_strip(0, $from_id );
|
|
|
adminlog("Comics ".$from_id." and ".$to_id." swapped.", MTS_STRIP, MTA_MODIFY);
|
|
|
}
|
|
|
|
|
|
function deletestrip($id) {
|
|
|
$id = (int)$id;
|
|
|
if ( !$id ) return false;
|
|
|
|
|
|
global $dbConnection;
|
|
|
$r = $dbConnection->executeUpdate('DELETE FROM strip WHERE id = ?', array($id));
|
|
|
foreach(glob(sprintf(SITE_PATH_ABS.'/'.SITE_STRIP.'/%04d*.*', $id)) as $item)
|
|
|
unlink($item);
|
|
|
foreach(glob(sprintf(SITE_PATH_ABS.'/'.SITE_STRIP.'/restricted/%04d*.*', $id)) as $item)
|
|
|
unlink($item);
|
|
|
adminlog("Comic ".$id." deleted.", MTS_STRIP, MTA_DELETE);
|
|
|
return $r;
|
|
|
}
|
|
|
|
|
|
function getstrip($id) {
|
|
|
global $dbConnection;
|
|
|
return $dbConnection->executeQuery('SELECT id, UNIX_TIMESTAMP(published) as published, type, media, title, book, page FROM strip WHERE id = ?', array($id))->fetch();
|
|
|
}
|
|
|
|
|
|
function get_stripimage_filename( $strip ) {
|
|
|
global $dbConnection;
|
|
|
$ext = $dbConnection->fetchColumn('SELECT extension FROM media_t WHERE id = ?', array($strip->media)); // filename extension
|
|
|
return sprintf( '%s/%04d.%s', SITE_STRIP, $strip->id, $ext );
|
|
|
}
|
|
|
|
|
|
function get_stripid_by_rantid($rantid) {
|
|
|
global $dbConnection;
|
|
|
return $dbConnection->fetchColumn('SELECT MAX(strip.id) FROM strip, rant WHERE strip.published <= rant.published AND rant.id = ?', array($rantid));
|
|
|
}
|
|
|
|
|
|
?>
|
|
|
|
