mt-admin Files · rss-scratchpad.php

Fix empty SQL error when editing transcripts.

darkmorford - - Load All Authors

File last commit:

104fb88d66f8

ffd74ed9508d

Download file

             rss-scratchpad.php
        
                    33 lines
            
             | 1.3 KiB
            
                | text/x-php
            
             |
                XmlPhpLexer
            
             / rss-scratchpad.php
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content

      <?php

      require_once('include/admin.inc.php');

      auth_basic();

      $count = isset($_REQUEST['count']) && ctype_digit($_REQUEST['count']) ? $_REQUEST['count'] : 25;

      $entries = $dbConnection->fetchAll('SELECT UNIX_TIMESTAMP(s.published) AS pubdate, c.name AS cname, c.email AS cmail, message FROM scratchpad s JOIN contributor c ON s.contributor = c.id ORDER BY published DESC LIMIT ?', array($count), array(PDO::PARAM_INT));

      header("Content-Type: application/rss+xml;charset=utf-8");

      echo "<?xml version=\"1.0\" ?>\n";

      ?>

      <rss version="2.0">

      	<channel>

      		<title>Megatokyo Admin Scratchpad</title>

      		<link>http://www.megatokyo.com/admin</link>

      		<description>Listing of administrative events: errors, warnings, and notifications.</description>

      		<language>en-us</language>

      		<?php foreach($entries as $k=>$v) { ?>

      			<item>

      				<title><?php echo $v->cname, ': ', htmlentities($v->message, ENT_COMPAT, 'UTF-8') ?></title>

      				<author><?php printf('%s (%s)', $v->cmail, $v->cname) ?></author>

      				<pubDate><?php echo date( DATE_RFC822, $v->pubdate ) ?></pubDate>

      				<guid><?php printf('%s%s/%s/?timestamp=%d', SITE_HOST, SITE_PATH, SITE_ADMIN, $v->pubdate) ?></guid>

      				<description><?php echo $v->cname, ': ', htmlentities($v->message, ENT_COMPAT, 'UTF-8') ?></description>

      			</item>

      		<?php } ?>

      	</channel>

      </rss>

	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

				<?php

				require_once('include/admin.inc.php');

				auth_basic();

				$count = isset($_REQUEST['count']) && ctype_digit($_REQUEST['count']) ? $_REQUEST['count'] : 25;

				$entries = $dbConnection->fetchAll('SELECT UNIX_TIMESTAMP(s.published) AS pubdate, c.name AS cname, c.email AS cmail, message FROM scratchpad s JOIN contributor c ON s.contributor = c.id ORDER BY published DESC LIMIT ?', array($count), array(PDO::PARAM_INT));

				header("Content-Type: application/rss+xml;charset=utf-8");

				echo "<?xml version=\"1.0\" ?>\n";
				?>
				<rss version="2.0">
				<channel>
				<title>Megatokyo Admin Scratchpad</title>
				<link>http://www.megatokyo.com/admin</link>
				<description>Listing of administrative events: errors, warnings, and notifications.</description>
				<language>en-us</language>

				<?php foreach($entries as $k=>$v) { ?>
				<item>
				<title><?php echo $v->cname, ': ', htmlentities($v->message, ENT_COMPAT, 'UTF-8') ?></title>
				<author><?php printf('%s (%s)', $v->cmail, $v->cname) ?></author>
				<pubDate><?php echo date( DATE_RFC822, $v->pubdate ) ?></pubDate>
				<guid><?php printf('%s%s/%s/?timestamp=%d', SITE_HOST, SITE_PATH, SITE_ADMIN, $v->pubdate) ?></guid>

				<description><?php echo $v->cname, ': ', htmlentities($v->message, ENT_COMPAT, 'UTF-8') ?></description>
				</item>
				<?php } ?>
				</channel>
				</rss>