diff --git a/rss/rss.php b/rss/rss.php
index da37320..1a5da9d 100644
--- a/rss/rss.php
+++ b/rss/rss.php
@@ -3,27 +3,37 @@
require_once('../LocalSettings.php');
/* Get the database working */
-$link = mysqli_connect(DB_SERVER, DB_READ_USER, DB_READ_PASS, DB_NAME) or trigger_error('Problem connecting to the SQL database server: '.mysqli_error($link), E_USER_ERROR);
+$link = mysqli_connect(DB_SERVER, DB_READ_USER, DB_READ_PASS, DB_NAME)
+ or trigger_error('Problem connecting to the SQL database server: ' . mysqli_error($link), E_USER_ERROR);
-function numeric_entities($string){
+function numeric_entities($string)
+{
$mapping = array();
- foreach (get_html_translation_table(HTML_ENTITIES, ENT_QUOTES) as $char => $entity){
+ foreach (get_html_translation_table(HTML_ENTITIES, ENT_QUOTES) as $char => $entity)
+ {
$mapping[$entity] = '' . ord($char) . ';';
}
return str_replace(array_keys($mapping), $mapping, $string);
}
-function Excerpt( $excerpt ) {
- $excerpt = strip_tags( $excerpt );
- if (strlen($excerpt) > 455) {
- $excerpt = substr($excerpt,0,452) . '...';
+function Excerpt($excerpt)
+{
+ $excerpt = strip_tags($excerpt);
+ if (strlen($excerpt) > 455)
+ {
+ $excerpt = substr($excerpt, 0, 452) . '...';
}
return $excerpt;
}
-function datesort( $a , $b ) {
- if( $a->udate == $b->udate ) return 0;
- return( $a->udate > $b->udate ) ? -1 : 1;
+function datesort($a , $b)
+{
+ if ($a->udate == $b->udate)
+ {
+ return 0;
+ }
+
+ return ($a->udate > $b->udate) ? -1 : 1;
}
function utfentities($string)
@@ -31,19 +41,28 @@ function utfentities($string)
return htmlentities($string, ENT_COMPAT, 'UTF-8');
}
-function _query( $s, $byid = false ) {
+function _query($s, $byid = false)
+{
global $link;
- $r = mysqli_query($link, $s ) or die( mysqli_error($link) );
- $ret=array();
- $i=0;
+ $r = mysqli_query($link, $s) or die(mysqli_error($link));
+ $ret = array();
+ $i = 0;
- if( $byid ) {
- while ($row = mysqli_fetch_object($r) )
+ if ($byid)
+ {
+ while ($row = mysqli_fetch_object($r))
+ {
$ret[$row->id] = $row;
- } else {
- while ($row = mysqli_fetch_object($r) )
+ }
+ }
+ else
+ {
+ while ($row = mysqli_fetch_object($r))
+ {
$ret[$i++] = $row;
+ }
}
+
return $ret;
}
@@ -77,54 +96,66 @@ $f_desc = 'News and Comics from Megatokyo.';
$f_items = array_merge( $f_items, $s );
}*/
-if( $type == 'strips' or $type == '') {
+if ($type == 'strips' or $type == '')
+{
$f_title = 'Megatokyo Comics';
- $s = _query("SELECT DISTINCT s.id, UNIX_TIMESTAMP(s.published) as udate, t.description as chapdesc, t.name as chapname, s.title
- FROM media_t media, strip s, strip_t t
- WHERE s.media = media.id AND s.published < NOW()
- AND s.type = t.id
- ORDER BY s.id DESC LIMIT 5") or die(mysqli_error($link));
- foreach($s as $k=>$v) {
+
+ $comic_query = 'SELECT s.id, UNIX_TIMESTAMP(s.published) as udate, t.description as chapdesc, t.name as chapname, s.title
+ FROM strip s JOIN strip_t ON s.type = t.id
+ WHERE s.published <= NOW()
+ ORDER BY s.id DESC LIMIT 5';
+
+ $s = _query($comic_query) or die(mysqli_error($link));
+
+ foreach($s as $k => $v)
+ {
$s[$k]->link = SITE_HOST . SITE_PATH . "/strip/$v->id";
- #$s[$k]->title = "Comic [$v->id] \"" . utfentities($v->title, ENT_COMPAT, ini_get('default_charset')) . '"';
$s[$k]->title = "Comic [$v->id] \"" . numeric_entities(utfentities($v->title)) . '"';
$s[$k]->desc = "chapdesc comic $v->id
[read...]
[link . "\">permalink]
]]>";
- $s[$k]->date = date( DATE_RSS, $v->udate );
+ $s[$k]->date = date(DATE_RSS, $v->udate);
$s[$k]->guid = $s[$k]->link;
$s[$k]->perm = 'true';
}
- $f_items = array_merge( $f_items, $s );
+
+ $f_items = array_merge($f_items, $s);
}
-if( $type == 'rants' or $type == '' ) {
+if ($type == 'rants' or $type == '')
+{
$f_title = 'Megatokyo Rants';
- $contributers = _query("SELECT * FROM contributor", true);
- $s = _query("SELECT r.id, r.body as body, UNIX_TIMESTAMP(r.published) as udate, r.author as authorno, r.title
- FROM rant r
- WHERE r.published < NOW()
- AND r.status = 'published'
- ORDER BY udate DESC LIMIT 5");
- foreach($s as $k=>$v) {
+
+ $rant_query = 'SELECT r.id, r.body, UNIX_TIMESTAMP(r.published) as udate, c.name, r.title
+ FROM rant r JOIN contributor c ON r.author = c.id
+ WHERE r.published <= NOW() AND r.status = "published"
+ ORDER BY udate DESC LIMIT 5';
+
+ $s = _query($rant_query) or die(mysqli_error($link));
+
+ foreach($s as $k => $v)
+ {
$s[$k]->link = SITE_HOST . SITE_PATH . "/rant/$v->id";
- $s[$k]->author = utfentities( $contributers[$v->authorno]->name, ENT_COMPAT, ini_get('default_charset') );
- $s[$k]->title = "Rant [$v->id] \"" . utfentities($v->title, ENT_COMPAT, ini_get('default_charset')) . '"';
+ $s[$k]->author = utfentities($v->name);
+ $s[$k]->title = "Rant [$v->id] \"" . utfentities($v->title) . '"';
$s[$k]->desc = "body) . "