mt-admin Files · include/strip.php

Configure the new TinyMCE to have almost the same buttons as the old one.

darkmorford - - Load All Authors

File last commit:

2f20c7105050

3cf3f8fd35f8

Download file

             strip.php
        
                    130 lines
            
             | 4.2 KiB
            
                | text/x-php
            
             |
                PhpLexer
            
             / include / strip.php
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content

     darkmorford
  
Add most necessary files for admin interface.

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

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	$strip->book = ($strip->book == '') ? 'NULL' : (int)$strip->book;

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
      	$strip->page = ($strip->page == '') ? 'NULL' : (int)$strip->page;

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	$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

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
      		. ', "' . mysqli_real_escape_string( $mtdb->link, trim($strip->title) )

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      		. '", '. $strip->book

      		. ', ' . $strip->page

      		. ')';

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	$r = $mtdb->query( $sql );

      	if( !$r ) {

      		$mtdb->query('ROLLBACK');

      		return false;

      	}

      	$mtdb->query('COMMIT');

      	adminlog("Comic ".$newid." posted.", MTS_STRIP, MTA_ADD);

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	$strip->id = $newid;

      	if( $strip->id == 0 ) return false;

      	return true;

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
      }

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      function updatestrip(&$strip) {

      	global $mtdb;

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	$strip->book = ($strip->book === '') ? 'NULL' : (int)$strip->book;

      	$strip->page = ($strip->page === '') ? 'NULL' : (int)$strip->page;

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	$mtdb->query('START TRANSACTION');

      	$sql = 'UPDATE strip SET

      		published = FROM_UNIXTIME(' . (int)$strip->published .')

      		, media = '. (int)$strip->media .'

      		, type = ' . (int)$strip->type .'

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
      		, title = "' . mysqli_real_escape_string( $mtdb->link, trim($strip->title) ) .'"

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      		, 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;

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
      }

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      // 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;

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	// 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 );

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	// 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;

     darkmorford
  
Update include/*.php to use mysqli_* functions.

              r4
            
     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	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);

      }

      ?>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings

darkmorford Add most necessary files for admin interface.	r1	<?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;
darkmorford Update include/.php to use mysqli_ functions.	r4
darkmorford Add most necessary files for admin interface.	r1	$strip->book = ($strip->book == '') ? 'NULL' : (int)$strip->book;
darkmorford Update include/.php to use mysqli_ functions.	r4	$strip->page = ($strip->page == '') ? 'NULL' : (int)$strip->page;

darkmorford Add most necessary files for admin interface.	r1	$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
darkmorford Update include/.php to use mysqli_ functions.	r4	. ', "' . mysqli_real_escape_string( $mtdb->link, trim($strip->title) )
darkmorford Add most necessary files for admin interface.	r1	. '", '. $strip->book
		. ', ' . $strip->page
		. ')';
darkmorford Update include/.php to use mysqli_ functions.	r4
darkmorford Add most necessary files for admin interface.	r1	$r = $mtdb->query( $sql );
		if( !$r ) {
		$mtdb->query('ROLLBACK');
		return false;
		}
		$mtdb->query('COMMIT');
		adminlog("Comic ".$newid." posted.", MTS_STRIP, MTA_ADD);
darkmorford Update include/.php to use mysqli_ functions.	r4
darkmorford Add most necessary files for admin interface.	r1	$strip->id = $newid;
		if( $strip->id == 0 ) return false;
		return true;
darkmorford Update include/.php to use mysqli_ functions.	r4	}
darkmorford Add most necessary files for admin interface.	r1
		function updatestrip(&$strip) {
		global $mtdb;
darkmorford Update include/.php to use mysqli_ functions.	r4
darkmorford Add most necessary files for admin interface.	r1	$strip->book = ($strip->book === '') ? 'NULL' : (int)$strip->book;
		$strip->page = ($strip->page === '') ? 'NULL' : (int)$strip->page;
darkmorford Update include/.php to use mysqli_ functions.	r4
darkmorford Add most necessary files for admin interface.	r1	$mtdb->query('START TRANSACTION');
		$sql = 'UPDATE strip SET
		published = FROM_UNIXTIME(' . (int)$strip->published .')
		, media = '. (int)$strip->media .'
		, type = ' . (int)$strip->type .'
darkmorford Update include/.php to use mysqli_ functions.	r4	, title = "' . mysqli_real_escape_string( $mtdb->link, trim($strip->title) ) .'"
darkmorford Add most necessary files for admin interface.	r1	, 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;
darkmorford Update include/.php to use mysqli_ functions.	r4	}
darkmorford Add most necessary files for admin interface.	r1
		// 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;
darkmorford Update include/.php to use mysqli_ functions.	r4
darkmorford Add most necessary files for admin interface.	r1	// 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 );
darkmorford Update include/.php to use mysqli_ functions.	r4
darkmorford Add most necessary files for admin interface.	r1	// 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;
darkmorford Update include/.php to use mysqli_ functions.	r4
darkmorford Add most necessary files for admin interface.	r1	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);
		}

		?>