Runescape Bits & Bytes
https://www.rsbandb.com/forums/

SOTW: New Stuff and Week 202 Voting
https://www.rsbandb.com/forums/viewtopic.php?f=47&t=74385		 Page 1 of 1
Author:  Chief Snake [ April 25th, 2009, 2:02 am ]
Post subject:  SOTW: New Stuff and Week 202 Voting
A few things on the agenda today...
Firstly, I've decided it would be a better idea to announce winners in the voting threads of the following weeks. And I'm a week behind with the winner announcements as it is. :P

Week 200 was won by Harkaan with this astounding signature...

Image

And week 201 was won by Warren with his hand...

Image

Congratulations to both of you! Here are your shiny new trophies (fingers crossed they look good against black)...

Image Image


Second thing on the agenda is something I've been working on for a little while, but I rushed to finish in the past week so that I could announce it with the new trophies. Which I also just finished last night. 8-[ 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?

Ladies and gentlemen, I give you the Signature of the Week Database!

I'm in the process of recreating trophies for weeks 20-100, so bear with me a while until that's all sorted out (as you can imagine it is a long and tedious job), but the rest should all be working smoothly. At least all 200 weeks' data has been entered now, the most monotonous task is over. :P


Finally we have the week 202 voting as usual. Vote wisely! Pleasing to see so many entries this week.

  1. Image

  2. Image

  3. Image

  4. Image

  5. Image

  6. Image

  7. Image

  8. Image
Author:  Adbot [ April 25th, 2009, 2:02 am ]
Post subject:  Register and login to get these in-post ads to disappear
Author:  Humus [ April 25th, 2009, 6:50 am ]
Post subject:  Re: SOTW: New Stuff and Week 202 Voting
The database is a great idea, good work on it, must be a very hard task.

As for the vote, I voted for #2, because its an interesting angle, its a pop-out, which you don't see very often, and it just works well together. Gl to all. Was good to see so many entries this week!
Author:  Tim [ April 25th, 2009, 8:38 am ]
Post subject:  Re: SOTW: New Stuff and Week 202 Voting
It wasn't hard for Chief to do that, he can do anything! Anyway, I voted for 2 because it's my favorite!
Author:  Marking22 [ April 25th, 2009, 11:05 pm ]
Post subject:  Re: SOTW: New Stuff and Week 202 Voting
I love the new trophies.And number 2 looks cool so i picked it.
Author:  Iron Maiden [ April 26th, 2009, 6:52 am ]
Post subject:  Re: SOTW: New Stuff and Week 202 Voting
I voted for #2 because it's Pit.Noticed the irony? The sig is my fav of all that's why it got my vote
Author:  Kirby [ April 26th, 2009, 11:38 am ]
Post subject:  Re: SOTW: New Stuff and Week 202 Voting
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...
Author:  Adbot [ April 26th, 2009, 11:38 am ]
Post subject:  Register and login to get these in-post ads to disappear
Author:  jrdgames [ April 27th, 2009, 7:45 pm ]
Post subject:  Re: SOTW: New Stuff and Week 202 Voting
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?
Author:  Chief Snake [ April 28th, 2009, 6:47 am ]
Post subject:  Re: SOTW: New Stuff and Week 202 Voting
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. :P *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. :oops: 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. :P 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*
Page 1 of 1 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/