Pet shows/contests

[Dinocanid]

I planned to have some sort of pet show/contest mechanic on my site, but how would I go about it? I wanted to have it so the show would be held on a certain date and the pet with the highest stats in that category would win and get a trophy. (For example, a cuteness contest would pick the pet with the highest cute stat as the winner). I already know how to do stats, but I don't know how to make it so users can enter the contest and the script would check the stats of each entered pet. I could just make the trophies key items that sit in the user's inventory, but I wanted it to show up on their profile.

[Abronsyth]

It's doable (I've been planning on making something such as this), but it would be complicated. You would need to do some things with mysql, make a new table to create new shows that would store the show ID, show name?, date to run, show type (i.e.; cute show), and a section for entries. The entries section would store individual pet IDs, and you'd need to design the code to check and make sure each pet is only entered once, no pets can be entered after the date, and have it check each pet ID and draw, from the IDs, each pets stat information (and then pick whichever pet has the highest of the chosen stat). You'd also need to code it so that if the show type is "cute" that it is specifically looking at "cute" stats only.

So...it'd be complicated, as I said, and with my current skill set I'm not able to do all of this. It's mostly looking at the stats from the pets ID number that I'm not sure how to do. I'll be looking into this, though, and if I make any breakthroughs I'll be sure to share.