{"id":1405,"date":"2007-11-03T10:44:39","date_gmt":"2007-11-03T15:44:39","guid":{"rendered":"http:\/\/www.shamusyoung.com\/twentysidedtale\/?p=1405"},"modified":"2008-08-17T14:22:27","modified_gmt":"2008-08-17T19:22:27","slug":"dexter-up-and-running","status":"publish","type":"post","link":"https:\/\/www.shamusyoung.com\/twentysidedtale\/?p=1405","title":{"rendered":"Dexter: Up and running"},"content":{"rendered":"<p>So Dexter, the latest version of WordPress, is up and running here on Twenty Sided.  I managed to break the site for an hour or so this morning but I think I have it all ironed out now.  Let me know if you see anything screwy.  I&#8217;ve also modified the CSS so that when people post huge URLs in the comments it won&#8217;t break the formatting.  This is only tested in IE and Firefox.  If the right side of comments are getting chopped off, please let me know.<\/p>\n<p>I got a decent start on tagging some of my old posts.  I worked my way backwards through the videogame archives, adding tags.  I have noticed some things about this process:<\/p>\n<p>1.  It is very easy.<br \/>\n2. It makes the site more useful, even for me.<br \/>\n3. It is a gigantic task that would take forever.<\/p>\n<p>That last item worries me a little.  I&#8217;ll try to do it in bite-sized bits.  Ideally, I&#8217;d like to have all of the videogame and anime posts tagged at some point.  In any case, at least I won&#8217;t be adding any more un-tagged stuff to the site.<\/p>\n<p>EDIT: DEV NULL Below points out there aren&#8217;t any tags visible.  I guess I should have mentioned that.  Tags should appear at the end of posts&#8230; but only for ones where I&#8217;vbe manually added tags.  The most recent posts in videogames are mostly tagged.  All other posts are withouttags at the moment.<\/p>\n<p><strong>LATER:<\/strong> Thanks to those who pointed out that wordpress is puking SQL errors all over the DMotR entries.  Turns out that Dexter has a totally different way of sorting posts into categories.  The First \/ Last navigation links need to query SQL to find the first and last posts in a given category.  This would be easy if the category was stored <i>with the post data in the same table<\/i> but instead this information is in another table. Sigh.  It was already a crazy process to find out this simple bit of information, requiring an INNER JOIN and some other hocus-pocus that goes beyond my limited SQL-fu.  I couldn&#8217;t even understand the new system, much less figure out how to query it.<\/p>\n<p>About an hour in I realized I was re-inventing the wheel for nothing:  DMotR is done.  I don&#8217;t need fancy queries or anything else.  The first post is #612 and the closing credits are #1306.  I just hard-coded them to always point to these posts and called it a day.  The downside is that if I ever added a comic the navigation links would ignore it, but I don&#8217;t think it&#8217;s worth the hassle right now.<\/p>\n<p>Okay, problem &#8220;solved&#8221;.  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>So Dexter, the latest version of WordPress, is up and running here on Twenty Sided. I managed to break the site for an hour or so this morning but I think I have it all ironed out now. Let me know if you see anything screwy. I&#8217;ve also modified the CSS so that when people [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[111],"tags":[40],"class_list":["post-1405","post","type-post","status-publish","format-standard","hentry","category-notices","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/www.shamusyoung.com\/twentysidedtale\/index.php?rest_route=\/wp\/v2\/posts\/1405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.shamusyoung.com\/twentysidedtale\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shamusyoung.com\/twentysidedtale\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shamusyoung.com\/twentysidedtale\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shamusyoung.com\/twentysidedtale\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1405"}],"version-history":[{"count":0,"href":"https:\/\/www.shamusyoung.com\/twentysidedtale\/index.php?rest_route=\/wp\/v2\/posts\/1405\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.shamusyoung.com\/twentysidedtale\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shamusyoung.com\/twentysidedtale\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shamusyoung.com\/twentysidedtale\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}