Ozzu Competition winners and table

  • SB
  • Moderator
  • Genius
  • User avatar
  • Posts: 8745
  • Loc: Aberdeen, Scotland

Post 3+ Months Ago

Over the last few years Ozzu has introduced many different competitions for the member to participate in. Two of the more common competitions found on Ozzu are the Digital Art and Photography competitions, with the Photography one initially starting on September 1st 2003 and the Digital Art competition initially starting up on February 16th 2006.

It seemed wrong not to allow you all the opportunity to see how everyone has done over the last 4 years, so having spent the last short while i've compiled all the information on the competitions previous winners and given you all a ranking in the hope that you might see this as something to improve on.

Image

To find out the overall totals of all the winners the please visit the...

Ozzu Competition Winners Table

I'm working on creating a more automated system, however in the meantime i am hoping this will suffice. If you have any suggestions on anything you would like to see or be included in this topic then please don't hesitate in sending a PM to me with your suggestion.

Over the coming days i also hope to have some sort of statistics up here for you to all have a look at. As you might imagine, this sort of stuff takes time to put together so i'm not going to set a fixed date on doing this.

Good luck!
  • Mas Sehguh
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 1853

Post 3+ Months Ago

Could you merge Mr. Sehguh and Mr. Hughes please? They have the same user id in the database table.
  • SB
  • Moderator
  • Genius
  • User avatar
  • Posts: 8745
  • Loc: Aberdeen, Scotland

Post 3+ Months Ago

I had no idea that was the case. I'll do that in a few moments and update it soon enough.
  • Fabinator
  • Proficient
  • Proficient
  • Fabinator
  • Posts: 467

Post 3+ Months Ago

Hey everyone and especially SB,

I've scripted a program with PHP to make the Ozzu Statistics easier to adjust.
It's now an automatic list on a webpage. The only thing that has to be changed is the points someone has. It's automaticaly sorted.

It can be found here: Ozzu Statistics
  • Fabinator
  • Proficient
  • Proficient
  • Fabinator
  • Posts: 467

Post 3+ Months Ago

Soory mistake, this is the right adress: http://www.onyx-design.net/test/rank.php
  • bleepnik
  • Professor
  • Professor
  • User avatar
  • Posts: 971
  • Loc: South Jersey, US

Post 3+ Months Ago

This is totally cool, thanks SB. =)
  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8416
  • Loc: USA

Post 3+ Months Ago

How does the ranking works?
  • Fabinator
  • Proficient
  • Proficient
  • Fabinator
  • Posts: 467

Post 3+ Months Ago

I'm feeling free to answer, because I made it ;)

It's a php file in which an array is entered with all the winners and their points. A arsort() function of php sorts it on points. It's set in a table after that with a while-construction that echoes the array. There is also one part of the program that knows what the highest number of achieved points is. That part also makes the one with most points gold, the ones with one less silver and the one with 2 less bronze. That works with if/ifelse/else.
  • SB
  • Moderator
  • Genius
  • User avatar
  • Posts: 8745
  • Loc: Aberdeen, Scotland

Post 3+ Months Ago

I would say though Fabinator, i've found the rankings doesn't order it in alphabetical order on the amount of wins. It doesn't matter how i organise it in the file, it is still not working. I'm not sure how it works, not had as much time to figure it all out.

I'll have a look at it over the coming days and sort it out so that it is in alphabetical order from the amounts won. A work in progress. Thanks to Fabinator for the help in producing the coding though.
  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Posts: 2733
  • Loc: Nashville, TN

Post 3+ Months Ago

Woo hoo! Looks like I need to jump back into another competition or two & rack up a few more points! :)
  • SB
  • Moderator
  • Genius
  • User avatar
  • Posts: 8745
  • Loc: Aberdeen, Scotland

Post 3+ Months Ago

I'll try and update this.

Just moved country so no time at the moment.
  • Fabinator
  • Proficient
  • Proficient
  • Fabinator
  • Posts: 467

Post 3+ Months Ago

Hurry up SB! :P :lol:
  • SB
  • Moderator
  • Genius
  • User avatar
  • Posts: 8745
  • Loc: Aberdeen, Scotland

Post 3+ Months Ago

Fabinator, when i am with more time i will. I just recently moved country and my access isn't as frequent as i would like.

I can't do it now, but the second i have spare time it will be updated and i will let you all know then.
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2193
  • Loc: Canada

Post 3+ Months Ago

Wouldn't this be easier to put into a sql table? Admin/SB just clicks [+] next to a winner's name, and voila! Dynamically sorted descending wins and alphabetical tied places.
  • SB
  • Moderator
  • Genius
  • User avatar
  • Posts: 8745
  • Loc: Aberdeen, Scotland

Post 3+ Months Ago

I've sort of neglected this of late. As soon as i get the time i'll work on improving this, whether it be physically or on the behind the scenes way.
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2193
  • Loc: Canada

Post 3+ Months Ago

I'm already on it ;)
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2193
  • Loc: Canada

Post 3+ Months Ago

Still needs a user/rankings list, but that won't take much longer.

For now here's a table showing the competitions and who won them - the rankings table will then show which comps people have won :)
http://64.15.130.247/~camroth/ozzu/
  • SB
  • Moderator
  • Genius
  • User avatar
  • Posts: 8745
  • Loc: Aberdeen, Scotland

Post 3+ Months Ago

Whoa, that's pretty darn impressive. If you can PM me any of that code i'd really appreciate that.

You certainly know how to make a come back :lol:
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2193
  • Loc: Canada

Post 3+ Months Ago

I'll make you a login, don't you worry :P

edit- once it's final I'll send it your way.
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13504
  • Loc: Florida

Post 3+ Months Ago

Considering the built-in phpBB3 polls are used to determine the winners, someone could put together a mod that pulls & presents the poll data for topics in the Competitions forum in a special way.

All that anyone would need is a default phpBB3 installation & development could be done.
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2193
  • Loc: Canada

Post 3+ Months Ago

I'm not sure I follow what you're getting at by
joebert wrote:
someone could put together a mod that pulls & presents the poll data for topics in the Competitions forum in a special way.


How exactly were you thinking the topics could be presented?
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13504
  • Loc: Florida

Post 3+ Months Ago

neksus wrote:
I'm not sure I follow what you're getting at by
joebert wrote:
someone could put together a mod that pulls & presents the poll data for topics in the Competitions forum in a special way.


How exactly were you thinking the topics could be presented?
neksus wrote:
Wouldn't this be easier to put into a sql table? Admin/SB just clicks [+] next to a winner's name, and voila! Dynamically sorted descending wins and alphabetical tied places.


Well going with what you brought up about SQL, technically everything needed is already stored.
Using the right SQL queries, this information could be presented exactly as you & SB have done without the need for manually marking the winners, or anything other than setting the voting threads up really.
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2193
  • Loc: Canada

Post 3+ Months Ago

That entire link I posted is drawing from a duplicated table that I set up - granted it would have been easier having privileges to Ozzu's database, but that wasn't likely to happen ;)
All you have to do to update this one is enter the winner of a new competition, and BAM live results!
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13504
  • Loc: Florida

Post 3+ Months Ago

http://www.phpbb.com/downloads/

Look at the TOPICS_TABLE, POLL_OPTIONS_TABLE, and POLL_VOTES_TABLE.

The winners can be determined automaticly using the POLL_VOTES_TABLE the same way they're determined in the thread the poll was started in. :D
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Posts: 2193
  • Loc: Canada

Post 3+ Months Ago

Wouldn't I still need access to the database where the poll is being held?
  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8416
  • Loc: USA

Post 3+ Months Ago

neksus wrote:
Wouldn't I still need access to the database where the poll is being held?

Kind of a poke at a dead animal, I think he meant to create the mod, give the code to bigweb and he'll integrate it into this site or something.
  • SB
  • Moderator
  • Genius
  • User avatar
  • Posts: 8745
  • Loc: Aberdeen, Scotland

Post 3+ Months Ago

I've been meaning to do something with this. This year has passed so fast!
  • spork
  • Brewmaster
  • Silver Member
  • User avatar
  • Posts: 6254
  • Loc: Seattle, WA

Post 3+ Months Ago

SB wrote:
I've been meaning to do something with this. This year has passed so fast!

Man, you're telling me.
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

Just a dumb question, why are the oscars not included on the winners table? What has happened to all the previous result pages as well?
  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Posts: 2733
  • Loc: Nashville, TN

Post 3+ Months Ago

Speaking of, we really need to get you guys some new siggy images. The current ones are kinda dated and pixelated.

Post Information

  • Total Posts in this topic: 40 posts
  • Users browsing this forum: No registered users and 6 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.