Ozzu Competition winners and table

  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Joined: 10 Sep 2004
  • Posts: 1904
  • Loc: Canada
  • Status: Offline

Post March 31st, 2008, 9:30 am

I'm already on it ;)
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post March 31st, 2008, 9:30 am

  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Joined: 10 Sep 2004
  • Posts: 1904
  • Loc: Canada
  • Status: Offline

Post March 31st, 2008, 11:49 am

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
  • Joined: 16 Nov 2004
  • Posts: 5366
  • Loc: Scotland
  • Status: Offline

Post March 31st, 2008, 11:53 am

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:
Image
  • neksus
  • Mastermind
  • Mastermind
  • User avatar
  • Joined: 10 Sep 2004
  • Posts: 1904
  • Loc: Canada
  • Status: Offline

Post March 31st, 2008, 11:57 am

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

edit- once it's final I'll send it your way.
  • joebert
  • Packaging Tape
  • Genius
  • User avatar
  • Joined: 10 Feb 2004
  • Posts: 8384
  • Loc: Clearwater, FL
  • Status: Offline

Post March 31st, 2008, 1:18 pm

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
  • Joined: 10 Sep 2004
  • Posts: 1904
  • Loc: Canada
  • Status: Offline

Post March 31st, 2008, 1:31 pm

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
  • Packaging Tape
  • Genius
  • User avatar
  • Joined: 10 Feb 2004
  • Posts: 8384
  • Loc: Clearwater, FL
  • Status: Offline

Post March 31st, 2008, 2:07 pm

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
  • Joined: 10 Sep 2004
  • Posts: 1904
  • Loc: Canada
  • Status: Offline

Post March 31st, 2008, 3:26 pm

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
  • Packaging Tape
  • Genius
  • User avatar
  • Joined: 10 Feb 2004
  • Posts: 8384
  • Loc: Clearwater, FL
  • Status: Offline

Post March 31st, 2008, 3:49 pm

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
  • Joined: 10 Sep 2004
  • Posts: 1904
  • Loc: Canada
  • Status: Offline

Post March 31st, 2008, 4:00 pm

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

Post Information

  • 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
 
 

© Unmelted Enterprises 1998-2008. Driven by phpBB © 2001-2008 phpBB Group.

 
 
 
 

Need a pre-made web design for your website?

Check out our templates here: Ozzu Templates


400+ FREE Website Templates. Download Now!