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.

[lawahdy]

husain .. ma man..

i'm getting an sql error.. when i try to manage comps and or enter new ones..

Unknown column 'startdate' in 'field list'

i've upgraded my hack from the old version "that was working fine" to the new one.. hmmm

[lawahdy]

Originally Posted by lawahdy

husain .. ma man..

i'm getting an sql error.. when i try to manage comps and or enter new ones..



i've upgraded my hack from the old version "that was working fine" to the new one.. hmmm

okay now it is working fine.. i had to uninstall the plugin and reinstall it again..

i lost some data .. but that is okay... nothing important..

hope this doesn't happen when i have a bigger competition database.. looll

[swantonio]

problem vbulletin 3,.5.4

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT competitionid, title, startdate, enddate, winnercount, is_enabled
FROM vb3_hkc_competitions
ORDER BY startdate DESC, enddate DESC;

MySQL Error : Unknown column 'startdate' in 'field list'
Error Number : 1054
Date : Monday, April 17th 2006 @ 11:38:41 PM
Script : http://www.clubx360.it/forum/admincp....php?do=modify
Referrer : http://www.clubx360.it/forum/admincp/index.php?do=nav
IP Address :
Username :
Classname : vb_database

[swantonio]

the querry non funzionano !!!!

[swantonio]

-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 18 Apr, 2006 at 10:16 AM
-- Versione MySQL: 3.23.58
-- Versione PHP: 5.0.4
--
-- Database: `IPB`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `vb3_hkc_competitions`
--

CREATE TABLE `vb3_hkc_competitions` (
`competitionid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` mediumtext NOT NULL,
`type` enum('input','select','radio','textarea','checkbox ','select_multiple') NOT NULL default 'input',
`data` mediumtext NOT NULL,
`maxlength` smallint(6) NOT NULL default '250',
`size` smallint(6) NOT NULL default '25',
`height` smallint(6) NOT NULL default '0',
`optional` smallint(5) unsigned NOT NULL default '0',
`def` smallint(6) NOT NULL default '0',
`regex` varchar(255) NOT NULL default '',
`enddate` int(10) unsigned NOT NULL default '0',
`datestamp` int(10) unsigned NOT NULL default '0',
`correctanswer` mediumtext NOT NULL,
`entrycount` mediumint(8) unsigned NOT NULL default '0',
`maxentries` smallint(5) unsigned NOT NULL default '1',
`maxwinners` smallint(5) unsigned NOT NULL default '1',
`winnercount` smallint(5) unsigned NOT NULL default '0',
`enableguidelines` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`competitionid`),
KEY `enddate` (`enddate`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dump dei dati per la tabella `vb3_hkc_competitions`
--


-- --------------------------------------------------------

--
-- Struttura della tabella `vb3_hkc_entries`
--

CREATE TABLE `vb3_hkc_entries` (
`entryid` int(10) unsigned NOT NULL auto_increment,
`competitionid` smallint(5) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`answer` mediumtext NOT NULL,
`entrydate` int(11) NOT NULL default '0',
PRIMARY KEY (`entryid`),
KEY `competitionid_userid` (`competitionid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dump dei dati per la tabella `vb3_hkc_entries`
--


-- --------------------------------------------------------

--
-- Struttura della tabella `vb3_hkc_winners`
--

CREATE TABLE `vb3_hkc_winners` (
`competitionid` smallint(5) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`competitionid`,`userid`)
) TYPE=MyISAM;

--
-- Dump dei dati per la tabella `vb3_hkc_winners`
--

[SLGR]

I'm currently on vB version 3.5.2 (patched)
Do i need to upgrade to use this hack?

[husain]

Originally Posted by SLGR

I'm currently on vB version 3.5.2 (patched)
Do i need to upgrade to use this hack?

There is no need to upgrade for this hack to work.

[husain]

Originally Posted by swantonio

problem vbulletin 3,.5.4

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT competitionid, title, startdate, enddate, winnercount, is_enabled
FROM vb3_hkc_competitions
ORDER BY startdate DESC, enddate DESC;

MySQL Error : Unknown column 'startdate' in 'field list'
Error Number : 1054
Date : Monday, April 17th 2006 @ 11:38:41 PM
Script : http://www.clubx360.it/forum/admincp....php?do=modify
Referrer : http://www.clubx360.it/forum/admincp/index.php?do=nav
IP Address :
Username :
Classname : vb_database

I think you have an older version of the hack with new PHP files. If your products page shows any version less than 1.0.2, please download the ZIP file again, and reinstall the hack. Make sure you check the box that says "Allow Overwrite".

[swantonio]

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT competitionid, title, startdate, enddate, winnercount, is_enabled
FROM vb3_hkc_competitions
ORDER BY startdate DESC, enddate DESC;

MySQL Error : Unknown column 'startdate' in 'field list'
Error Number : 1054
Date : Tuesday, April 18th 2006 @ 01:30:54 PM
Script : http://www.clubx360.it/forum/admincp....php?do=modify
Referrer : http://www.clubx360.it/forum/admincp/index.php?do=nav
IP Address : 213.xxx.xxx.xxx
Username : SWANTONIO
Classname : vb_database

no non funziona :ermm:

[SLGR]

I set up a test competition.
I, myself, participated in it... as soon as i voted i received a pm informing me of my competition. Now, is sais: (in the main forum page)

Welcome, {Nickname}.
You last visited: Today at 11:20
Private Messages: Unread 29, Total 635.
No pop-up for them, i logged out and logged in again, no change, i still have 29 unread pms which i can't find.

Any thought?

Edit:
I just found them, the oldest 29 was marked as unread.
But why? For sure, this happened after i received the "thank you" pm and send the report back (ok, the report came to me).

also, one question.
As soon as the Competitions comes to an end, what happens then?