From 3591f6718171c766a935f7eb6270b4707f5101b1 2017-07-11 23:43:28
From: DarkMorford <DarkMorford@Gmail.com>
Date: 2017-07-11 23:43:28
Subject: [PATCH] Fix a SQL query and a couple of validation issues.

---

diff --git a/rss/rss.php b/rss/rss.php
index 829de5d..201f084 100644
--- a/rss/rss.php
+++ b/rss/rss.php
@@ -101,7 +101,7 @@ if ($type == 'strips' or $type == '')
 	$f_title = 'Megatokyo Comics';
 
 	$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
+	                FROM strip s JOIN strip_t t ON s.type = t.id
 	                WHERE s.published <= NOW()
 	                ORDER BY s.id DESC LIMIT 5';
 
@@ -112,7 +112,7 @@ if ($type == 'strips' or $type == '')
 		$s[$k]->link = SITE_HOST . SITE_PATH . "/strip/$v->id";
 		$s[$k]->title = "Comic [$v->id] \"" . utfentities($v->title) . '"';
 		$s[$k]->desc = "<![CDATA[$v->chapdesc comic $v->id
-					<br />[<a href=\"http://www.megatokyo.com/\">read...</a>]
+					<br />[<a href=\"https://megatokyo.com/\">read...</a>]
 					<br />[<a href=\"" . $s[$k]->link . "\">permalink</a>]
 					]]>";
 		$s[$k]->date = date(DATE_RSS, $v->udate);
@@ -173,7 +173,7 @@ usort($f_items, 'datesort');
 
 $f_date = $f_items[0]->date;
 
-$rfc1123_date = gmdate(DATE_RFC1123, $f_items[0]->udate);
+$rfc1123_date = gmdate('D, d M Y H:i:s T', $f_items[0]->udate);
 $etag = md5($rfc1123_date);
 
 /* Conditional Get */