mt-admin Files · include/pages.php

Allow static pages to contain iframe elements. This is necessary for twitch embedding.

darkmorford - - Load All Authors

File last commit:

c1e4c31f199d

293d44211c32

Download file

             pages.php
        
                    53 lines
            
             | 1.8 KiB
            
                | text/x-php
            
             |
                PhpLexer
            
             / include / pages.php
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      <?php

      class Page {

      	var $url_name, $status, $title, $body, $style;

      }

      function savepage($page) {

      	if($page->url_name)

      		return updatepage($page);

      	else

      		return insertpage($page);

      }

      function insertpage($page) {

      	global $mtdb;

      	$sql = 'INSERT INTO static_page ( url_name, status, title, body, style ) VALUES ('

      		. '   "' . mysql_real_escape_string($page->url_name)

      		. '", "' . mysql_real_escape_string($page->status)

      		. '", "' . mysql_real_escape_string( trim( $page->title ) )

      		. '", "' . mysql_real_escape_string( trim( $page->body ) )

      		. '", "' . mysql_real_escape_string( trim( $page->style ) )

      		. '")';

      	adminlog("Page '".$page->url_name."' has been added.", MTS_PAGE, MTA_ADD);

      	return $mtdb->query($sql);

      }	

      function updatepage($page) {

      	if ( !$page->url_name ) return false;

      	global $mtdb;

      	$sql = 'UPDATE static_page SET url_name = "' . mysql_real_escape_string($page->url_name)

      		. '", status = "' . mysql_real_escape_string($page->status)

      		. '", title = "' . mysql_real_escape_string( trim($page->title) )

      		. '", body = "' . mysql_real_escape_string( trim($page->body ) )

      		. '", style = "' . mysql_real_escape_string( trim($page->style ) )

      		. '" WHERE url_name = "' . mysql_real_escape_string($page->url_name) . '"';

      	adminlog("Page '".$page->url_name."' has been updated.", MTS_PAGE, MTA_MODIFY);

      	return $mtdb->query( $sql );

      }

      function deletepage($url_name) {

      	if ( !$url_name ) return false;

      	global $mtdb;

      	adminlog("Page '".$page->url_name."' has been deleted.", MTS_PAGE, MTA_DELETE);

      	return $mtdb->query( 'DELETE FROM static_page WHERE url_name = "' . mysql_real_escape_string($url_name) . '"' );

      }

      function getpage($url_name) {

      	global $mtdb;

      	return $mtdb->getRow( 'SELECT url_name, status, title, body, style FROM static_page WHERE url_name = "'. mysql_real_escape_string($url_name) . '"' );

      }

      ?>

	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

		class Page {
		var $url_name, $status, $title, $body, $style;
		}

		function savepage($page) {
		if($page->url_name)
		return updatepage($page);
		else
		return insertpage($page);
		}

		function insertpage($page) {
		global $mtdb;
		$sql = 'INSERT INTO static_page ( url_name, status, title, body, style ) VALUES ('
		. ' "' . mysql_real_escape_string($page->url_name)
		. '", "' . mysql_real_escape_string($page->status)
		. '", "' . mysql_real_escape_string( trim( $page->title ) )
		. '", "' . mysql_real_escape_string( trim( $page->body ) )
		. '", "' . mysql_real_escape_string( trim( $page->style ) )
		. '")';
		adminlog("Page '".$page->url_name."' has been added.", MTS_PAGE, MTA_ADD);
		return $mtdb->query($sql);
		}

		function updatepage($page) {
		if ( !$page->url_name ) return false;
		global $mtdb;

		$sql = 'UPDATE static_page SET url_name = "' . mysql_real_escape_string($page->url_name)
		. '", status = "' . mysql_real_escape_string($page->status)
		. '", title = "' . mysql_real_escape_string( trim($page->title) )
		. '", body = "' . mysql_real_escape_string( trim($page->body ) )
		. '", style = "' . mysql_real_escape_string( trim($page->style ) )
		. '" WHERE url_name = "' . mysql_real_escape_string($page->url_name) . '"';
		adminlog("Page '".$page->url_name."' has been updated.", MTS_PAGE, MTA_MODIFY);
		return $mtdb->query( $sql );
		}

		function deletepage($url_name) {
		if ( !$url_name ) return false;
		global $mtdb;
		adminlog("Page '".$page->url_name."' has been deleted.", MTS_PAGE, MTA_DELETE);
		return $mtdb->query( 'DELETE FROM static_page WHERE url_name = "' . mysql_real_escape_string($url_name) . '"' );
		}

		function getpage($url_name) {
		global $mtdb;
		return $mtdb->getRow( 'SELECT url_name, status, title, body, style FROM static_page WHERE url_name = "'. mysql_real_escape_string($url_name) . '"' );
		}

		?>