Competitions

Description
Adds a competition module to your forums. You can create as many competitions and allow members to participate in them.

Features

• Ability to force participants to fill certain custom profile fields
• Send Private Message to members who participate in the competitions
• Ability to allow more than one entry from a participant
• Input field for answers can be either a textbox, a textarea, radio buttons or a drop-down menu
• If the input type is radio buttons or a drop-down menu, the system can filter out wrong answers and generate a list of winners by picking random participants
• Schedule competitions by setting the starting date (user contributed)
• Very customizable

Installation

1. Upload all necessary files to their respective directories.
2. Install the product XML file.
3. Edit the navbar template to add a link to competitions.php page. (see below)
4. Set necessary permissions for each usergroup to access and/or participate in competitions.
5. Edit the "hkc_nopermission_loggedin" and "hkc_winner_congratulate_message" phrase to customize to your taste.

Upgrade

1. Upload all necessary files to their respective directories.
2. Install the product XML file. Be sure to set "Allow Overwrite" to Yes.

Editing the navbar template

1. Open the navbar template

2. Find:

<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

3. Add after:

<td class="vbmenu_control"><a href="competitions.php$session[sessionurl_q]">$vbphrase[hkc_competitions]</a></td>

4. Save template

Author Notes
This extension was developed specifically for my website but I am releasing the code since a few members here have have shown interest. I cannot state that it is totally free of bugs. I would appreciate your feedback in making this extension better.

Maybe in Future
At the moment, the question is only restricted to one per competition. I would like to have the ability to add more than one question per competition.

[Lea Verou]

How is this different from the inferno quiz apart from the number of questions?

[D|ver]

hmm i got an error message after picking winners



Datenbankfehler in vBulletin 3.5.1:

Invalid SQL:

SELECT profilefieldid, title
FROM profilefield
WHERE profilefieldid IN ();

MySQL-Fehler : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
Fehler-Nr. : 1064
Datum : Sunday, November 6th 2005 @ 01:18:13 PM
Skript : http://www.xxx.com/forums/admincp/co...ionmanager.php
Referrer : http://www.xxx.com/forums/admincp/co...ompetitionid=1
Benutzername : xxx
Klassenname : vb_database

[husain]

Originally Posted by D|ver

hmm i got an error message after picking winners



Datenbankfehler in vBulletin 3.5.1:

Invalid SQL:

SELECT profilefieldid, title
FROM profilefield
WHERE profilefieldid IN ();

MySQL-Fehler : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
Fehler-Nr. : 1064
Datum : Sunday, November 6th 2005 @ 01:18:13 PM
Skript : http://www.xxx.com/forums/admincp/co...ionmanager.php
Referrer : http://www.xxx.com/forums/admincp/co...ompetitionid=1
Benutzername : xxx
Klassenname : vb_database

Fixed. You can download the zip file and only replace the old competitionmanager.php file (in admincp) with the new one.

[husain]

Originally Posted by Loukrhtia

How is this different from the inferno quiz apart from the number of questions?

Oh dear! I didn't realize there was another hack that could do the same things that my hack does

[tidy_boy]

husain you are awesome been wanting something like this

Just one thing is there away you can make a module for my cmps to show open competitions please

Here is my site www.harddanceaddict.net

Thanks

[husain]

I am afraid not: due to time constraints. However, it shouldn't be too difficult and I can offer my help should you wish to code it yourself.

[tidy_boy]

I do not know anything about coding :-(

[Snake]

Originally Posted by husain

Oh dear! I didn't realize there was another hack that could do the same things that my hack does

What are you talking about? This is a competition hack. The other one is a quiz hack.

[C.Birch]

the quiz hack is not anything like this hack husain

[peterska2]

Well it took me about 3 dozen attempts to install including having to re-write the XML and manually do the queries, but eventually we got there and it now works.

On the whole, a nice little hack, but a complete ball ache to get working. I recommend you revisit your XML and check it over again.