Fix a SQL query and a couple of validation issues.
darkmorford -
3591f6718171
Not Reviewed
Show More
Add another comment
TODOs: 0 unresolved 0 Resolved
COMMENTS: 0 General 0 Inline
@@ -101,7 +101,7 if ($type == 'strips' or $type == '')
101 101 $f_title = 'Megatokyo Comics';
102 102
103 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 105 WHERE s.published <= NOW()
106 106 ORDER BY s.id DESC LIMIT 5';
107 107
@@ -112,7 +112,7 if ($type == 'strips' or $type == '')
112 112 $s[$k]->link = SITE_HOST . SITE_PATH . "/strip/$v->id";
113 113 $s[$k]->title = "Comic [$v->id] \"" . utfentities($v->title) . '"';
114 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 116 <br />[<a href=\"" . $s[$k]->link . "\">permalink</a>]
117 117 ]]>";
118 118 $s[$k]->date = date(DATE_RSS, $v->udate);
@@ -173,7 +173,7 usort($f_items, 'datesort');
173 173
174 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 177 $etag = md5($rfc1123_date);
178 178
179 179 /* Conditional Get */
Comments 0
You need to be logged in to leave comments. Login now