|
|
<?php
|
|
|
|
|
|
// Book: The offset from 0 at the beginning of time
|
|
|
// Page: The offset from 0 at the beginning of the volume
|
|
|
|
|
|
class Strip {
|
|
|
var $id, $old_id, $published, $media, $type, $title, $book, $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 $mtdb;
|
|
|
|
|
|
$strip->book = ($strip->book == '') ? 'NULL' : (int)$strip->book;
|
|
|
$strip->page = ($strip->page == '') ? 'NULL' : (int)$strip->page;
|
|
|
|
|
|
$mtdb->query('START TRANSACTION');
|
|
|
$newid = $mtdb->getOne('SELECT MAX(id) FROM strip') + 1;
|
|
|
$sql = 'INSERT INTO strip ( id, published, media, type, title, book, page ) VALUES ('
|
|
|
. $newid
|
|
|
. ', FROM_UNIXTIME(' . (int)$strip->published
|
|
|
. '), '. (int)$strip->media
|
|
|
. ', ' . (int)$strip->type
|
|
|
. ', "' . mysqli_real_escape_string( $mtdb->link, trim($strip->title) )
|
|
|
. '", '. $strip->book
|
|
|
. ', ' . $strip->page
|
|
|
. ')';
|
|
|
|
|
|
$r = $mtdb->query( $sql );
|
|
|
if( !$r ) {
|
|
|
$mtdb->query('ROLLBACK');
|
|
|
return false;
|
|
|
}
|
|
|
$mtdb->query('COMMIT');
|
|
|
adminlog("Comic ".$newid." posted.", MTS_STRIP, MTA_ADD);
|
|
|
|
|
|
$strip->id = $newid;
|
|
|
if( $strip->id == 0 ) return false;
|
|
|
return true;
|
|
|
}
|
|
|
|
|
|
function updatestrip(&$strip) {
|
|
|
global $mtdb;
|
|
|
|
|
|
$strip->book = ($strip->book === '') ? 'NULL' : (int)$strip->book;
|
|
|
$strip->page = ($strip->page === '') ? 'NULL' : (int)$strip->page;
|
|
|
|
|
|
$mtdb->query('START TRANSACTION');
|
|
|
$sql = 'UPDATE strip SET
|
|
|
published = FROM_UNIXTIME(' . (int)$strip->published .')
|
|
|
, media = '. (int)$strip->media .'
|
|
|
, type = ' . (int)$strip->type .'
|
|
|
, title = "' . mysqli_real_escape_string( $mtdb->link, trim($strip->title) ) .'"
|
|
|
, book = ' . (int)$strip->book .'
|
|
|
, page = ' . (int)$strip->page .'
|
|
|
WHERE id = ' . (int)$strip->id;
|
|
|
$mtdb->query( $sql );
|
|
|
$mtdb->query('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 $mtdb;
|
|
|
$from_id = (int) $from_id;
|
|
|
$to_id = (int) $to_id;
|
|
|
|
|
|
// Ensure our source exists
|
|
|
$num_strips = $mtdb->getOne( "SELECT COUNT(*) FROM strip WHERE id = $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
|
|
|
$mtdb->query( "UPDATE strip SET id = $to_id WHERE id = $from_id" );
|
|
|
$strip = $mtdb->getRow( "SELECT strip.id, extension FROM strip, media_t WHERE media_t.id = strip.media AND strip.id = $to_id" );
|
|
|
|
|
|
// 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 $mtdb;
|
|
|
$r = $mtdb->query( 'DELETE FROM strip WHERE id=' . $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 $mtdb;
|
|
|
return $mtdb->getRow( 'SELECT id, UNIX_TIMESTAMP(published) as published, type, media, title, book, page FROM strip WHERE id=' . (int)$id);
|
|
|
}
|
|
|
|
|
|
function get_stripimage_filename( $strip ) {
|
|
|
global $mtdb;
|
|
|
$ext = $mtdb->getOne( 'SELECT extension FROM media_t WHERE id=' . (int)$strip->media ); // filename extension
|
|
|
return sprintf( '%s/%04d.%s', SITE_STRIP, $strip->id, $ext );
|
|
|
}
|
|
|
|
|
|
function get_stripid_by_rantid($rantid) {
|
|
|
global $mtdb;
|
|
|
return $mtdb->getOne('SELECT MAX(strip.id) FROM strip,rant WHERE strip.published<=rant.published AND rant.id=' . (int)$rantid);
|
|
|
}
|
|
|
|
|
|
?>
|
|
|
|
