From the unofficial fan-run MindCrack and HermitCraft wiki
Jump to: navigation, search

Database formatting issue[edit]

Is there a possible fix for cases in which the MindCrackers release videos on the same date? The case is an issue with adlingtont with his first few episodes...He appeared to have released these in a single burst and they have become all jumbled. -- 10:23, 4 July 2013 (CEST)

I think we need to add another parameter to the videos to make them sort correctly. This is also a problem in BTC's and Guude's video lists. This has been discussed previously Talk:Main_Page#Video_Timeline.3F, but the solution (reversing the order of videos in the database) does not work. We can set each query to sort by date and then by an episode number/sort number. If it's a number type property we can assign decimal numbers to a video thats released the same day. I'd prefer to have the option of having the episode number (which means we need decimals) so it could be used in other ways, but we could set the default in the video template at 1, so there is always a number. The downside of this strategy is that it will need to be added to all the video lists eventually. The faster option would be if we could add a fake hour to the date, but I don't know that we can make it not display the time in the list. --Atharsea (talk) 20:00, 4 July 2013 (CEST)
Sorry for the immense delay. If you check out the Sandbox, that is what I have envisioned. The time added to adlingtont/videos are obtained from<video id>?v=2&alt=json
where <video id> is the YouTube video id. Find "published" and it will tell you the exact time of publication. One main issue with adding episode numbers is that some lists like Nebris/videos have videos that do not have episode numbers. Creating more rules to accommodate that would be too much work. I'm trying to find a solution to the bullet lists not working but you can roll out this new technique if you want.--Admin 19:49, 11 July 2013 (CEST)
Thanks for figuring it out. Being able to use the date was always my preference, since it didn't call for revising all the entries/adding information that most videos didn't need. I just couldn't figure out how to force the time not to display, and I had no idea how to find the correct time. I didn't realize that there was a way that a template could make it display correctly! I'll roll out the new query to all of the MindCrack vanilla video lists, and I'll try to add times to the all the ones we already have issues with. --Atharsea (talk) 20:43, 11 July 2013 (CEST)