Kirby wrote:
Nice db and trophies!
though, I got to say I'm not a fan of that text on the trophies. Number two is my pick. Come to think of it, he still hasn't made mine...
I had another comment about the text from someone else and I think I will change it; even though I quite like this myself, I know what I like the look of is not necessarily what others do.
*cough signature that I voted for only got the one vote cough*
Thanks for your input, I appreciate it.
jrdgames wrote:
That is nice but why is there not an option to sort the winners by # of wins?
And did you gather all this information yourself?
Rushed coding.
When I have time it'll be streamlined and little things like that will be patched up.
I should of course give a huge thanks to you for collating much of the data. Jrdgames created an archive of themes for judge reference, which was accurate from the very beginning up to around week 180. This was only in table form however and rather confusing to update (at least I found), and additionally it was the third separate archive; we had one for Winners, one for Weeks, and then Themes. Technically Themes and Weeks could have been merged as has been done here.
Basically my job was to combine the data from the Themes and Weeks archives and store it in the new database. Even though it was mostly collected for me that didn't stop it from taking a few hours to do; 200 weeks is more than it sounds.
The opening and closing times/dates of weeks are also stored as they were originally, if you were wondering, but I didn't think it necessary to include them in the output archives. It certainly made me feel sorry for you collecting all the information for the Themes archive as I imagine a massive amount of time was involved. Thanks again.
In the new database, I believe all previous issues have been eliminated, with data integrity now as the priority - I already stumbled across someone who has two of the same trophy, for example; in future it would be difficult for this to occur (although admittedly never completely fool proof since the trophies are still hand made and sometimes I don't get around to doing the SOTW duties until it's a bit past my bed time). I considered getting PHP to generate the trophies for me but the text wouldn't have looked anywhere near as fancy.
And speaking of bed times... *passes out*
It's something that was originally intended primarily to make my life easier, but I figured, why not extend it a bit more to make it useful to the public?
