{"id":62,"date":"2006-06-06T15:29:30","date_gmt":"2006-06-06T21:29:30","guid":{"rendered":"http:\/\/thepizzy.net\/blog\/?p=62"},"modified":"2011-02-24T10:05:44","modified_gmt":"2011-02-24T16:05:44","slug":"update-tsnx-database-conversion-50","status":"publish","type":"post","link":"https:\/\/thepizzy.net\/blog\/2006\/06\/update-tsnx-database-conversion-50\/","title":{"rendered":"Update: tsnX Database Conversion @ 50%"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1181\" data-permalink=\"https:\/\/thepizzy.net\/blog\/2008\/04\/tsn7-style-in-progress\/untitled-2-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&amp;ssl=1\" data-orig-size=\"400,400\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"the-spot.net logo\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&amp;ssl=1\" class=\"alignleft size-thumbnail wp-image-1181\" title=\"the-spot.net logo\" src=\"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2-150x150.png?resize=150%2C150\" alt=\"\" width=\"150\" height=\"150\" srcset=\"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?resize=150%2C150&amp;ssl=1 150w, https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?resize=300%2C300&amp;ssl=1 300w, https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?resize=36%2C36&amp;ssl=1 36w, https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?resize=115%2C115&amp;ssl=1 115w, https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?w=400&amp;ssl=1 400w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/>Ok, so I&#8217;m converting the tsnV database into one that will work with the tsnX database structure. What this will do is bring our posts, user accounts, and forums over from the old site and make it work with the mods and settings of the new site. It&#8217;s something I have not done before, but is apparently going rather smoothly.<\/p>\n<p>I spent all night working on it, and then another 3 hours today already, and am going to take a break from it. But once the database conversion is finished, and I revisit the bugs in the code, I&#8217;ll load the database, and start working on the site design.<\/p>\n<p>The theme that I&#8217;m going to be working off of is just going to be a re-coded subSilver theme. If you want to use the theme as I build it, to be one of the first to experience the tsnX feel, then feel free to do so. However, the theme is going to be in the alpha phase, which will guarantee nothing as far as it&#8217;s ability to function is concerned. So if I&#8217;m working on something, and the theme breaks, and it&#8217;s not something that I can fix immediately, then you will most likely be SOL until I get it fixed, as far as using the site is concerned.<\/p>\n<p>For this purpose if you wish to create a separate user on the site and use the settings for it to work with everything beta, then that will be acceptable. Just name your user account _beta so that you can distinguish which is which, and we&#8217;ll still know who you are.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ok, so I&#8217;m converting the tsnV database into one that will work with the tsnX database structure. What this will do is bring our posts, user accounts, and forums over from the old site and make it work with the mods and settings of the new site. It&#8217;s something I have not done before, but [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[11,3,9,347,2],"tags":[444,460,456,449,214,207,455,457,226,350,209,459,361,355,441,137,458],"class_list":["post-62","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-projects","category-tech","category-the-spot-net","category-the-spot-network","category-updates","tag-account","tag-alpha","tag-alpha-phase","tag-beta","tag-code","tag-database","tag-database-conversion","tag-database-structure","tag-design","tag-forums","tag-site","tag-subsilver","tag-tsnv","tag-tsnx","tag-update","tag-user","tag-user-accounts"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1","jetpack_likes_enabled":false,"jetpack_shortlink":"https:\/\/wp.me\/prOO4-10","jetpack-related-posts":[{"id":63,"url":"https:\/\/thepizzy.net\/blog\/2006\/06\/update-tsnx-database-movement\/","url_meta":{"origin":62,"position":0},"title":"Update: tsnX Database Movement","author":"[[Neo]]","date":"June 9, 2006","format":false,"excerpt":"I'm backing up the tsnX.3 Beta's Database (with the posts, forums, and accounts) and going to start moving the tsnV database into the tsnX site. The site is going to be down for a bit, while I do this, and iron out the kinks of auth-access, and conversions. If things\u2026","rel":"","context":"In &quot;Projects&quot;","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":61,"url":"https:\/\/thepizzy.net\/blog\/2006\/06\/update-tsnx-coding-100\/","url_meta":{"origin":62,"position":1},"title":"Update: tsnX Coding @ 100%","author":"[[Neo]]","date":"June 3, 2006","format":false,"excerpt":"Well, I finished updating the basic forums to work with what I want and what people expect in the-spot.net. It's taken about a month and a half, with some restarts in coding, and lots of frustration and a couple feature scale-backs. What's next on the list, is debugging some of\u2026","rel":"","context":"In &quot;Projects&quot;","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":94,"url":"https:\/\/thepizzy.net\/blog\/2007\/12\/new-version-of-tsn-under-way\/","url_meta":{"origin":62,"position":2},"title":"New Version of tsn, under-way","author":"[[Neo]]","date":"December 26, 2007","format":false,"excerpt":"Yes, you heard it right, there is a new version of the-spot.net being put up as you read this. The folks over at www.phpbb.com have released version 3.0.0 of their forum software, and it has all the functions and features that we used in tsnX built-in to it, and everything\u2026","rel":"","context":"In &quot;Programming&quot;","block_context":{"text":"Programming","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/programming\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":33,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/update-tsnx-profile-cp-999\/","url_meta":{"origin":62,"position":3},"title":"Update: tsnX &#8211; Profile CP @ 99.9%","author":"[[Neo]]","date":"April 9, 2006","format":false,"excerpt":"I just finished editing the code for the profile control panel. I only have to test it now, but I can't do that until I get a response and resolution to the domain name issues. For some reason \"the-spot.net\" does not work, but the other domains that I have on\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":35,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/update-tsnx-beta-release-information-upgrade-to-2020-100\/","url_meta":{"origin":62,"position":4},"title":"Update: tsnX &#8211; Beta Release information, Upgrade to 2.0.20 @ 100%","author":"[[Neo]]","date":"April 11, 2006","format":false,"excerpt":"Well, I updated the files necessary for the .19 to .20 switch, but for some reason, the page still says that I am running .19. So I will have to go edit the database to get it to show the proper version, and then all will be well - and\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65,"url":"https:\/\/thepizzy.net\/blog\/2006\/06\/update-tsnx-site-is-useable-again\/","url_meta":{"origin":62,"position":5},"title":"Update: tsnX \u00e2\u20ac\u201c Site is useable again!","author":"[[Neo]]","date":"June 16, 2006","format":false,"excerpt":"For those just stopping by, the-spot.net is now useable like it was in the past. There are still some updates to the database and site code that I am working on, but everything works as it should for the regular users. I'm currently working on the first theme for the\u2026","rel":"","context":"In &quot;Projects&quot;","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/62","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/comments?post=62"}],"version-history":[{"count":4,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":1215,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/62\/revisions\/1215"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/media\/1181"}],"wp:attachment":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/media?parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/categories?post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/tags?post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}