mt-admin Files · include/pages.php

Squash some bugs.

darkmorford - - Load All Authors

File last commit:

089a8bc9edcb

b9ac5124675f

Download file

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

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      <?php

     darkmorford
  
Update pages and rants to use DBAL.

              r27
            
      class Page

      {

      	public $url_name;

      	public $status;

      	public $title;

      	public $body;

      	public $style;

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      }

     darkmorford
  
Update pages and rants to use DBAL.

              r27
            
      function savepage($page)

      {

      	if ($page->url_name)

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      		return updatepage($page);

      	else

      		return insertpage($page);

      }

     darkmorford
  
Update pages and rants to use DBAL.

              r27
            
      function insertpage($page)

      {

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

      	global $dbConnection;

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

      	$stmt = $dbConnection->prepare($sql);

      	$stmt->bindValue('slug',   $page->url_name);

      	$stmt->bindValue('status', $page->status);

      	$stmt->bindValue('title',  trim($page->title));

      	$stmt->bindValue('body',   trim($page->body));

      	$stmt->bindValue('style',  trim($page->style));

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

      	return $stmt->execute();

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

              r4
            
      }

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
     darkmorford
  
Update pages and rants to use DBAL.

              r27
            
      function updatepage($page)

      {

     darkmorford
  
Add most necessary files for admin interface.

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

     darkmorford
  
Update pages and rants to use DBAL.

              r27
            
      	global $dbConnection;

      	$sql = 'UPDATE static_page SET url_name = :slug, status = :status, title = :title, body = :body, style = :style WHERE url_name = :slug';

      	$stmt = $dbConnection->prepare($sql);

      	$stmt->bindValue('slug',   $page->url_name);

      	$stmt->bindValue('status', $page->status);

      	$stmt->bindValue('title',  trim($page->title));

      	$stmt->bindValue('body',   trim($page->body));

      	$stmt->bindValue('style',  trim($page->style));

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

      	return $stmt->execute();

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      }

     darkmorford
  
Update pages and rants to use DBAL.

              r27
            
      function deletepage($url_name)

      {

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      	if ( !$url_name ) return false;

     darkmorford
  
Update pages and rants to use DBAL.

              r27
            
      	global $dbConnection;

      	$sql = 'DELETE FROM static_page WHERE url_name = :slug';

      	$stmt = $dbConnection->prepare($sql);

      	$stmt->bindValue('slug', $url_name);

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

      	return $stmt->execute();

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      }

     darkmorford
  
Update pages and rants to use DBAL.

              r27
            
      function getpage($url_name)

      {

      	if ( !$url_name ) return false;

      	global $dbConnection;

      	$sql = 'SELECT url_name, status, title, body, style FROM static_page WHERE url_name = :slug';

      	$stmt = $dbConnection->prepare($sql);

      	$stmt->bindValue('slug', $url_name);

      	$stmt->execute();

      	return $stmt->fetch();

     darkmorford
  
Add most necessary files for admin interface.

              r1
            
      }

      ?>

	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

darkmorford Update pages and rants to use DBAL.	r27	class Page
		{
		public $url_name;
		public $status;
		public $title;
		public $body;
		public $style;
darkmorford Add most necessary files for admin interface.	r1	}

darkmorford Update pages and rants to use DBAL.	r27	function savepage($page)
		{
		if ($page->url_name)
darkmorford Add most necessary files for admin interface.	r1	return updatepage($page);
		else
		return insertpage($page);
		}

darkmorford Update pages and rants to use DBAL.	r27	function insertpage($page)
		{
		if ( !$page->url_name ) return false;
		global $dbConnection;

		$sql = 'INSERT INTO static_page (url_name, status, title, body, style) VALUES (:slug, :status, :title, :body, :style)';
		$stmt = $dbConnection->prepare($sql);

		$stmt->bindValue('slug', $page->url_name);
		$stmt->bindValue('status', $page->status);
		$stmt->bindValue('title', trim($page->title));
		$stmt->bindValue('body', trim($page->body));
		$stmt->bindValue('style', trim($page->style));

		adminlog("Page '" . $page->url_name . "' has been added.", MTS_PAGE, MTA_ADD);
		return $stmt->execute();
darkmorford Update include/.php to use mysqli_ functions.	r4	}
darkmorford Add most necessary files for admin interface.	r1
darkmorford Update pages and rants to use DBAL.	r27	function updatepage($page)
		{
darkmorford Add most necessary files for admin interface.	r1	if ( !$page->url_name ) return false;
darkmorford Update pages and rants to use DBAL.	r27	global $dbConnection;

		$sql = 'UPDATE static_page SET url_name = :slug, status = :status, title = :title, body = :body, style = :style WHERE url_name = :slug';
		$stmt = $dbConnection->prepare($sql);

		$stmt->bindValue('slug', $page->url_name);
		$stmt->bindValue('status', $page->status);
		$stmt->bindValue('title', trim($page->title));
		$stmt->bindValue('body', trim($page->body));
		$stmt->bindValue('style', trim($page->style));

		adminlog("Page '" . $page->url_name . "' has been updated.", MTS_PAGE, MTA_MODIFY);
		return $stmt->execute();
darkmorford Add most necessary files for admin interface.	r1	}

darkmorford Update pages and rants to use DBAL.	r27	function deletepage($url_name)
		{
darkmorford Add most necessary files for admin interface.	r1	if ( !$url_name ) return false;
darkmorford Update pages and rants to use DBAL.	r27	global $dbConnection;

		$sql = 'DELETE FROM static_page WHERE url_name = :slug';
		$stmt = $dbConnection->prepare($sql);

		$stmt->bindValue('slug', $url_name);

		adminlog("Page '" . $page->url_name . "' has been deleted.", MTS_PAGE, MTA_DELETE);
		return $stmt->execute();
darkmorford Add most necessary files for admin interface.	r1	}

darkmorford Update pages and rants to use DBAL.	r27	function getpage($url_name)
		{
		if ( !$url_name ) return false;
		global $dbConnection;

		$sql = 'SELECT url_name, status, title, body, style FROM static_page WHERE url_name = :slug';
		$stmt = $dbConnection->prepare($sql);

		$stmt->bindValue('slug', $url_name);

		$stmt->execute();
		return $stmt->fetch();
darkmorford Add most necessary files for admin interface.	r1	}

		?>