mt-site
RSS
Fix a SQL query and a couple of validation issues.
darkmorford -
3591f6718171
Not Reviewed
Show More
Add another comment
Collapse all files
TODOs: 0 unresolved 0 Resolved
COMMENTS: 0 General 0 Inline
Show file before | Show file after | Show commentsHide comments
@@ -101,7 +101,7 if ($type == 'strips' or $type == '')
101 $f_title = 'Megatokyo Comics';
101 $f_title = 'Megatokyo Comics';
102
102
103 $comic_query = 'SELECT s.id, UNIX_TIMESTAMP(s.published) as udate, t.description as chapdesc, t.name as chapname, s.title
103 $comic_query = 'SELECT s.id, UNIX_TIMESTAMP(s.published) as udate, t.description as chapdesc, t.name as chapname, s.title
104 FROM strip s JOIN strip_t ON s.type = t.id
104 FROM strip s JOIN strip_t t ON s.type = t.id
105 WHERE s.published <= NOW()
105 WHERE s.published <= NOW()
106 ORDER BY s.id DESC LIMIT 5';
106 ORDER BY s.id DESC LIMIT 5';
107
107
@@ -112,7 +112,7 if ($type == 'strips' or $type == '')
112 $s[$k]->link = SITE_HOST . SITE_PATH . "/strip/$v->id";
112 $s[$k]->link = SITE_HOST . SITE_PATH . "/strip/$v->id";
113 $s[$k]->title = "Comic [$v->id] \"" . utfentities($v->title) . '"';
113 $s[$k]->title = "Comic [$v->id] \"" . utfentities($v->title) . '"';
114 $s[$k]->desc = "<![CDATA[$v->chapdesc comic $v->id
114 $s[$k]->desc = "<![CDATA[$v->chapdesc comic $v->id
115 <br />[<a href=\"http://www.megatokyo.com/\">read...</a>]
115 <br />[<a href=\"https://megatokyo.com/\">read...</a>]
116 <br />[<a href=\"" . $s[$k]->link . "\">permalink</a>]
116 <br />[<a href=\"" . $s[$k]->link . "\">permalink</a>]
117 ]]>";
117 ]]>";
118 $s[$k]->date = date(DATE_RSS, $v->udate);
118 $s[$k]->date = date(DATE_RSS, $v->udate);
@@ -173,7 +173,7 usort($f_items, 'datesort');
173
173
174 $f_date = $f_items[0]->date;
174 $f_date = $f_items[0]->date;
175
175
176 $rfc1123_date = gmdate(DATE_RFC1123, $f_items[0]->udate);
176 $rfc1123_date = gmdate('D, d M Y H:i:s T', $f_items[0]->udate);
177 $etag = md5($rfc1123_date);
177 $etag = md5($rfc1123_date);
178
178
179 /* Conditional Get */
179 /* Conditional Get */
Comments 0
You need to be logged in to leave comments. Login now