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.

[Antivirus]

Thank you Husain, this is very nice

I think i found a small insignificant bug- in the settings group (admincp) the following should have URL, not URI...

Competition Entry Guidelines URI 
Enter the URI of the page containing the entry guidelines.

[Antivirus]

Originally Posted by funinthesun

I've just installed this and I get this error:
MySQL Error : Table '*****db.hkc_competitions' doesn't exist
Any idea what's wrong?

seems that your error might be caused by the table prefix "db."

[P.E.L]

this sounds great .. thx for sharing man ..:banana:

[criscokid]

Originally Posted by criscokid

Another useful addition for the next feature: a text block or something that site admins can use to write something like "Are you a company looking to promote your product? Why not offer some of your products as prizes for a competition? Click here to find out more..."

And another suggestion... use the same concept (start and end dates, etc)and layout to advertise special promotions that site owners are able to provide for their community. It wouldn't need to have an 'enter competition' link as the details of the promotion would go in the same place where site owners put the competition info at the moment.

[vb_guru]

Hi,

Is it possible to e-mail (instead of PM) the winners of a competition. I want to have a long running competition where users enter a bunch of information into the profile fields. If I like what they enter then I want to make them a winner and send them an e-mail automatically once they are selected as a winner.

[jamiepryer@hotm]

hey all, getting the following error, please advise:

PHP Code:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT competitionid, title, description, startdate, enddate, entrycount
        FROM hkc_competitions
        WHERE is_enabled = 1 AND startdate < 1152489172 AND enddate > 1152489172
        ORDER BY enddate ASC, startdate DESC, datestamp DESC;

MySQL Error  : Table 'newSMCCforumdb.hkc_competitions' doesn't exist
Error Number : 1146
Date         : Monday, July 10th 2006 @ 12:52:52 AM
Script       : http://www.sussexcarz.com/forum/upload2/competitions.php
Referrer     : http://www.sussexcarz.com/forum/upload2/competitions.php
IP Address   : 80.3.64.11
Username     : Admin
Classname    : vb_database 


[jamiepryer@hotm]

anyone?

[jellybaby]

Will this work on 3.6

[husain]

Originally Posted by jellybaby

Will this work on 3.6

I just upgraded my board to 3.6 and haven't had any problems yet.

[Hoffi]

No Problems here with 3.6