Competitions

[husain]

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 (https://vborg.vbsupport.ru/showpost.php?p=876085&postcount=114))
Very customizable


Installation

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


Upgrade

Upload all necessary files to their respective directories.
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.

[D|ver]

great thank you for this hack :)
i will definately test this out :D

[Mastar]

I don't see it on the forum only in the admincp.

When I run the ./competitions.php I get this error:

Warning: Division by zero in /includes/functions.php(4259) : eval()'d code on line 10

This is probably because I'm running vb 3.50?

If so is there a competition for Vb 3.50?

[D|ver]

i can't access competitins.php (userid=1)

[jellybaby]

Edited because I found out why I couldnt access it, had to go into usergroups and right to the bottom to select allow to enter

[BoYagoob]

i can't access competitins.php (userid=1)

I get a you do not have permission page when I do competitions.php


Me too :(


BoYagoob, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Log Out Home

[jellybaby]

I have this working ok on my site now thank you:nervous:

[D|ver]

ah thanks, now its also working for me
great addon :)

[SnowBot]

Looks very interesting, i will check this out later

[michaelbenson]

Looks very interesting, i will check this out later
Ditto, good job :nervous:

[stonyarc]

Looks like a great addition to me.

Will definately try it out

[MaTraX]

Me too :(


BoYagoob, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Log Out Home
Same here.. what`s wrong? What to do to make it work properly?

[Snake]

Oh sweet. I was hoping to see a competition hack but I thought that it's not possible but were we go, you have just made it!

Thank you VERY much! :D

[D|ver]

Same here.. what`s wrong? What to do to make it work properly?

edit the permissions for each usergroup in the acp

[MaTraX]

@D|ver -thank you :)
It`s working fine now.

[husain]

Thank you all for your feedback. It is apparent that I forgot to mention very important post-installation steps and left you all to do some detective work. Sorry -- this is the first time I am publishing something here. I have added instructions on how to install the extension.

This is probably because I'm running vb 3.50?

If so is there a competition for Vb 3.50?This extension was developed for vBulletin 3.5 and I am running it on my forums (v 3.5.1) without any problems.

[yinyang]

is there a referral competition hack for 3.5.x? if not, can this be modified to do that?

[Kurisu]

Nice hack, installed.

Yet I think the hack is quite useless if you can only specify one question...

[husain]

Nice hack, installed.

Yet I think the hack is quite useless if you can only specify one question...Agree. I meant to add multiple-question functionality for quite some time now. Unfortunately I haven't been able to dedicate enough time for it's development. Maybe if enough people show interest, I may be motivated to set aside a couple of hours everyday to add this functionality :)

[C.Birch]

I really need multiple-question functionality so if you could add it that be great :)

[JsnakeJ]

Any chance of a working demo? Thank you.

[Snake]

<a href="http://forums.mgszone.com/competitions.php" target="_blank">http://forums.mgszone.com/competitions.php</a>

You'll need to register inorder to view the competition page.

[concepts]

is there any way to delete entries? per the admincp?
and how do you change the thankyou PM?

[Snake]

Yes you can delete entries via the ACP.

You'll need to edit the phrase using Phrase Manager.

[JsnakeJ]

Nice forum man. Thanks for this hack.

[Snake]

Hehe thank you for your compliment. Wait to see the new skin. :p

[husain]

For those who would like to customize this hack, all phrases and templates begin with hkc_

[SnowBot]

Agree. I meant to add multiple-question functionality for quite some time now. Unfortunately I haven't been able to dedicate enough time for it's development. Maybe if enough people show interest, I may be motivated to set aside a couple of hours everyday to add this functionality :)

Multiple questions is the way to go so yer i second the motion to do it mate :)

[Hoffi]

What about to build in a start date? I want to build a Advent Calendar, and every Day only one Question should be displayed.

[DJ XtAzY]

yay i hope i can use this as a contest thing

[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/competitionmanager.php
Referrer : http://www.xxx.com/forums/admincp/competitionmanager.php?do=getwinner&competitionid=1
Benutzername : xxx
Klassenname : vb_database

[husain]

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/competitionmanager.php
Referrer : http://www.xxx.com/forums/admincp/competitionmanager.php?do=getwinner&competitionid=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]

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 :D

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]

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.

[husain]

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.

Could you please tell me what problems you faced, error messages you got, etc. Your feedback will help me in checking where the problem lies. Thank you.

[VaaKo]

I got this when I first tried to upload the plugin

Database error in vBulletin 3.5.1:

Invalid SQL:

CREATE TABLE `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;;

MySQL Error : You have an error in your SQL syntax near ';
' at line 24
Error Number : 1064
Date : Monday, November 7th 2005 @ 02:59:28 PM
Script : http://www.oneforum.org/admincp/plugin.php
Referrer : http://www.oneforum.org/admincp/plugin.php?do=productadd
IP Address : 194.146.154.1
Username : Snitz
Classname : vb_database

[husain]

That's strange. The SQL in the XML file doesn't have 2 semi-colons at the end.

I also installed this hack on a vanilla copy of vBulletin 3.5 and I didn't get any errors.

[VaaKo]

what could be cause of this error than?
I recently upgraded to 3.5.1, could it be the reason?

[peterska2]

Mine's a 3.5.1 too.

Have a list of errors with what I had done below each one and what I did to fix it. :)

Please note: every error was obtained via the product import function when set to overwrite exisiting.


Database error in vBulletin 3.5.1:

Invalid SQL:

CREATE TABLE `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;;

MySQL Error : You have an error in your SQL syntax near ';
' at line 24
Error Number : 1064
Date : Sunday, November 6th 2005 @ 11:47:35 PM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Initial import of product. Fixed error by removing the ; at the end of above query. In the xml file you have
) TYPE=MyISAM;
"; which is where you are getting the double ;; from.


Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE usergroup ADD hkc_competition_permissions INT(10) UNSIGNED DEFAULT '1' NOT NULL;

MySQL Error : Duplicate column name 'hkc_competition_permissions' Error Number : 1060
Date : Sunday, November 6th 2005 @ 11:50:58 PM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Re-import brought this error. Could not uninstall product as the install had not been completed. Tried again.


Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE usergroup ADD hkc_competition_permissions INT(10) UNSIGNED DEFAULT '1' NOT NULL;

MySQL Error : Duplicate column name 'hkc_competition_permissions' Error Number : 1060
Date : Sunday, November 6th 2005 @ 11:52:34 PM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Error upon re-import overwrite existing set to yes. Edited XML to eliminate this query and bypass the error, but forgot to upload it.


Database error in vBulletin 3.5.1:

Invalid SQL:
ALTER TABLE usergroup ADD hkc_competition_permissions INT(10) UNSIGNED DEFAULT '1' NOT NULL;

MySQL Error : Duplicate column name 'hkc_competition_permissions' Error Number : 1060
Date : Sunday, November 6th 2005 @ 11:53:39 PM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Error upon re-import overwrite existing set to yes. Uploaded edited XML.


Database error in vBulletin 3.5.1:

Invalid SQL:

CREATE TABLE `` (
`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;;

MySQL Error : Incorrect table name ''
Error Number : 1103
Date : Sunday, November 6th 2005 @ 11:54:43 PM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Got a bit carried away when editing the xml and so had to go back and manually insert the table names.

Database error in vBulletin 3.5.1:

Invalid SQL:

CREATE TABLE `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;;

MySQL Error : You have an error in your SQL syntax near ';
' at line 24
Error Number : 1064
Date : Sunday, November 6th 2005 @ 11:55:28 PM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Problem with double ;; again. See error one for solution.

Database error in vBulletin 3.5.1:

Invalid SQL:

CREATE TABLE `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;;

MySQL Error : You have an error in your SQL syntax near ';
' at line 10
Error Number : 1064
Date : Sunday, November 6th 2005 @ 11:57:42 PM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Problem with double ;; again. See error one for solution.


Database error in vBulletin 3.5.1:

Invalid SQL:

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

MySQL Error : You have an error in your SQL syntax near ';
' at line 6
Error Number : 1064
Date : Sunday, November 6th 2005 @ 11:58:14 PM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Problem with double ;; again. See error one for solution.


Database error in vBulletin 3.5.1:

Invalid SQL:

CREATE TABLE `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;

MySQL Error : Table 'hkc_competitions' already exists
Error Number : 1050
Date : Sunday, November 6th 2005 @ 11:59:27 PM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Adding query manually gave this error. I had already added it manually eariler in the install process and just completely forgot - I was fed up getting errors by this point.


Database error in vBulletin 3.5.1:

Invalid SQL:

CREATE TABLE `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;

MySQL Error : Table 'hkc_competitions' already exists
Error Number : 1050
Date : Monday, November 7th 2005 @ 12:00:41 AM
Script : http://www.peterska2.co.uk/admincp/plugin.php
Referrer : http://www.peterska2.co.uk/admincp/plugin.php?do=productadd
IP Address :
Username : peterska2
Classname : vb_database


Again forgot that I had already manually added this table.


Database error in vBulletin 3.5.1:

Invalid SQL:
INSERT INTO hkc_winners (competitionid, userid) VALUES (1, 1);

MySQL Error : Table 'talkyaAn.hkc_winners' doesn't exist
Error Number : 1146
Date : Monday, November 7th 2005 @ 12:06:24 AM
Script : http://www.peterska2.co.uk/admincp/competitionmanager.php
Referrer : http://www.peterska2.co.uk/admincp/competitionmanager.php?do=getwinner&competitionid=1
IP Address :
Username : peterska2
Classname : vb_database

Addition of this table failed. Had to manually create.

I'd send you a copy of my XML file but it's got big chunks missing so it probably isn't a good idea. However, if you wish to have a copy for your reference then I will be happy to send it over.

* peterska2 hopes this post isn't over the character limit!

[husain]

peterska2, thanks for your detailed report. I really appreciate your efforts and patience. I would like to have your copy of the XML file. I can use that to fix my XML file. You can email the file to me at husainsfabbas AT hotmail.com

From your error report, is it safe to assume that all problems faced were because of poorly written SQL queries?

[Holidazed]

I installed this mod and it seems to be working properly as long as I am using internet explorer. When I goto my site in Firefox, none of the dhtml drop down menus work and the shoutbox does not load and various other java functions do not work.

When I disable this product, all is working again.

[Paul M]

From your error report, is it safe to assume that all problems faced were because of poorly written SQL queries?Most of the errors appear to be due to the extra semi colon.

Also, once you know the sql is correct, you should add the following line to the start of your installation code;

$db->hide_errors()
and this to the end;

$db->show_errors()
The simple reason being that if tables or columns already exist then failure messages are expected, but need to be ignored.

[husain]

Thanks for the tip Paul. I have uploaded another copy of the ZIP file to incorporate your suggestion.

[peterska2]

peterska2, thanks for your detailed report. I really appreciate your efforts and patience. I would like to have your copy of the XML file. I can use that to fix my XML file. You can email the file to me at husainsfabbas AT hotmail.com

From your error report, is it safe to assume that all problems faced were because of poorly written SQL queries?

I'll just tidy it up a bit for you then get it uploaded.

Won't be long. :)

Here you go :)

[VaaKo]

is there a way to show the entries within the competition page?
I mean is there a way to add a link "View Entries" to be able who posted what?

[husain]

is there a way to show the entries within the competition page?
I mean is there a way to add a link "View Entries" to be able who posted what?I am afraid there isn't such a feature. Wouldn't such a feature defeat the purpose of a competition? Why should someone be able to view entries submitted by other users?

[VaaKo]

well I have this competition on my board, where users comment on a certain picture and upon their comments they win points (ucash)
we have now a thread for this competition, but I would like to integrate it with the competitions hack... so i need to show all the entries for all the users

[sensimilla]

great hack thanks :)

[Holidazed]

I installed this mod and it seems to be working properly as long as I am using internet explorer. When I goto my site in Firefox, none of the dhtml drop down menus work and the shoutbox does not load and various other java functions do not work.

When I disable this product, all is working again.

Any ideas on this?

[Lyricsmama]

Nice hack, thank you very much.
I would love it if you do enable more than one question per competition.

Suggestion: is it possible to have the Thank you for Participating PM sent only once, even if a competition allows more than one entry per member?

[husain]

Any ideas on this?

No ideas, unfortunately. I haven't been able to reproduce this behaviour on any installations of the forums. Are you running a vanilla install of vB3.5 or is it upgraded? Any other extensions you have installed?

[husain]

Suggestion: is it possible to have the Thank you for Participating PM sent only once, even if a competition allows more than one entry per member?Hmmm. Never gave a though to that. I will add this to my list of things to do.

[mrahul]

how to edit the text which is produced as a pm to the winners throogh pm ?

[husain]

how to edit the text which is produced as a pm to the winners throogh pm ?

They are all phrases. All phrases used in this hack start with hkc_ so if you do a search for phrase names that contain this string, you will get them.

[Allan]

Great hack !! :)

File attach: French language ;)

Click Install

[Hoffi]

well I have this competition on my board, where users comment on a certain picture and upon their comments they win points (ucash)
we have now a thread for this competition, but I would like to integrate it with the competitions hack... so i need to show all the entries for all the users
Maybe you should take a look at the InfernoQuiz.

[mrahul]

They are all phrases. All phrases used in this hack start with hkc_ so if you do a search for phrase names that contain this string, you will get them.

okie fine mate. found out :) thanks for the help. I am getting some problem with the cookies. the cookies are not getting saved. when ever i try to login it logs and comes back so not logged in any solution ? I get this problem only in Opera 7.54., it works good in firefox & opera 8.5

[Allan]

@Tidy_boy

What code do you use for it ?

[tidy_boy]

@Tidy_boy

What code do you use for it ?
Hey there I used this bb code to do it

check ou thtis link http://www.vbulletin.com/forum/showthread.php?t=137967&highlight=align+image

[husain]

@Tidy_boy

What code do you use for it ?

You can use HTML to style your question. For example:

<div style="float:right">
<img src="..." width="100" height="30" alt="" />
</div>
<p>Enter your competition details here.</p>
<p>Is this the competition question?</p>

[Allan]

thanks :)

[Holidazed]

No ideas, unfortunately. I haven't been able to reproduce this behaviour on any installations of the forums. Are you running a vanilla install of vB3.5 or is it upgraded? Any other extensions you have installed?I have lots of other extensions and plugins installed. Are you saying that yours is in conflict with another one I am running? I suppose I can turn them all off and see if yours gives me the same problem.

[SpanishHarlem]

ok I am starting to get the hang of these hack's but still find some that give me a bit of trouble.

Can someone explain in steps exactly how this is done.

Edit the navbar template to add a link to competitions.php page.
Set necessary permissions for each usergroup to access and/or participate in competitions.
Edit the "hkc_nopermission_loggedin" and "hkc_winner_congratulate_message" phrase to customize to your taste

[Hoffi]

1) Open the Template navbar
search for:

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

And add after

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

2)
Go in the ACP to the Usergroup permissions
Edir all Usergroups and set the permissions (nearly at the end of the page)
3)
Go in the ACP to search Phrases
type in on the two Phrase-Names
hit search and then Edit

[SpanishHarlem]

1) Open the Template navbar
search for:

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

And add after

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

2)
Go in the ACP to the Usergroup permissions
Edir all Usergroups and set the permissions (nearly at the end of the page)
3)
Go in the ACP to search Phrases
type in on the two Phrase-Names
hit search and then Edit


thank you so much :nervous:

[SpanishHarlem]

oh poop. I can't do it on my other skin

[lawahdy]

excellent work husain.

was wondering if you could add the option of uploading images to the competition.. i mean usually on my site i get sponsors to provide me with prizes.. i would love to add their logo to the competition they are providing the gift for..

same as your site.. i like the way images are displayed with questions..

that could be done with html..right..?

what if i don't have ftp access.. uploading images would be a nicer job.

[Hoffi]

Released the German Version with Permission from husain on www.vbhacks-germany.com

http://www.vbhacks-germany.com/forum/showthread.php?p=14812#post14812

This Version is a modified version with an extra field for the start-date for every competition! You can set in the settings if - and how many - pending questions should be displayed.

Husain adds this feature in his new release!

[husain]

excellent work husain.


was wondering if you could add the option of uploading images to the competition.. i mean usually on my site i get sponsors to provide me with prizes.. i would love to add their logo to the competition they are providing the gift for..

same as your site.. i like the way images are displayed with questions..

that could be done with html..right..?

what if i don't have ftp access.. uploading images would be a nicer job.

I use PhotoBucket (http://www.photobucket.com) to upload pictures.

[version2]

Does this allow folks to 'upload' submissions?

[mrahul]

I have set to max. of only 1 entry per member but one member had given out 4 entries. How is it possible ?? r it tht his browser might hav got struck at tht moment ?

[husain]

Does this allow folks to 'upload' submissions?

No, it doesn't allow submissions by uploading files/images/etc.

[husain]

I have set to max. of only 1 entry per member but one member had given out 4 entries. How is it possible ?? r it tht his browser might hav got struck at tht moment ?

It is very unlikely that this would happen. The script checks how many times a person has entered in the competitions against the database.

I will re-check my script just in case there is a bug.

[mrahul]

It is very unlikely that this would happen. The script checks how many times a person has entered in the competitions against the database.

I will re-check my script just in case there is a bug.

oki mate.. I got one more member now with more than one entry

one member has 5 entries , now the new guy has 2 entries while for the rest itz perfect.

[husain]

oki mate.. I got one more member now with more than one entry

one member has 5 entries , now the new guy has 2 entries while for the rest itz perfect.

Ok I am stumped here. I can't find anything wrong with my code -- since I wrote it I don't know where I may have made a mistake. Perhaps someone else on these forums can audit it for me.

[cbr929rrerion]

** installed **

also the mutliple box idea would be nice..

I want to have contests where I give stuff away just for posting in the thread or now just by entering this way.. is there a way to number the entries in the view entries page, ie.. 1, 2, 3, so I can pick a random number for a winner and see who it is..

If it numbers them then I can pick a number between 1 and whatever, go to that entry # and they win.. other wise I will have to count them ...

[cbr929rrerion]

How can we have it redirect you back to the forum home page after they enter...

another words after they submit it, it takes them to the forum home page

[puertoblack2003]

nice one **INSTALLED ** no problems

[MThornback]

Ok, maybe i'm missing something...

I installed it, edited permissions etc...but its still giving me the no permission errors on 3.5.1

any thoughts?

[MThornback]

its working now...but only because the profile conditions were removed...

[fiber_cut]

Where did you edit the permissions?

When I try to access competitions.php I get -

fiber_cut, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

[fiber_cut]

Ahh never mind this post I was jsut an idiot like always..

[MThornback]

Ahh never mind this post I was jsut an idiot like always..

Someone entered my competiton...and it tottally FUBAR'd my whole language table, Ihad to drop and add it...and I checked...and the submission happened today...and so did the crash...and this is the only product I use that uses that table....thought you'd like to know

[EasyTarget]

I think it'd be nice to expand this past just a Question/Answer type thing and include events or something as well. Let the administrator choose what the competition is, say like first person to X amount of posts or whatever.

[Mastar]

I'm getting problems when selecting Multiple-Line Text Box in Competions.

When I enter a date and save it, it saves it as: 01-01-1970 08:00 AM

[lazyseller]

has anyone had any problems with this ?

[havefun]

very nice. THX
* havefun clicked install :)

[D|ver]

husain you are awesome been wanting something like this :D

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

yeah a cmps mpodule would be so great :) :)

[tidy_boy]

yeah can anyone make a cmps module for this hack please

[4number8]

I was needing something similar to this, but for my questions the answer would be unknown untill the event was over, can I still use this and add the event date a day later, than update the answer? would doing it this way still work correctly with the PM's? I have installed it and been playing around with it, but it always states that the event end date has ended... like this: End Date: 1 Minute Ago 06:00 PM
anyone have idea's why this is doing this? thanks for a great hack btw

[husain]

If you don't know the correct answer or if your question doesn't have a correct answer you can leave that field blank. You must however specify a valid end date.

Not specifying the correct answer will not affect the competition in any way. The only thing that will not work is the automatic picking of a winner -- you will have to manually select winners and feed their user IDs into the system.

[4number8]

Is there anyway to get the time to work with detailed in the Datestamp Display Option, that is what is causing it to show up as already ended, if i swith to normal, or today/yesterday it will work. Thanks

[MSheraz86]

A great mod!! Works perfectly :D thanks!

Though, How can I edit the message in the PM that is autmatically sent??

[Hoffi]

That is stored in the Phrases hkc_pm_conform_message and hkc_pm_conform_subject and hkc_winner_congratulate_message and hkc_winner_congratulate_subject.

[MSheraz86]

Thanks a lot :D

[FROGGYJ]

1)when I start a new competition I have to set the date 1 day ahead to actually end on the day I want. So for example if I want to end the competition on Dec 23...I have to set the date to Dec 24th. Weird thing is if I go to edit the competition after setting it up it shows Dec 23.....???

2)how can we change what time the competition ends? Currently they all end at 5pm on the given day. Is there somewhere we can change the time?

3)also I often do giveaways and members simply have to reply to a thread. This would be more useful though...but not sure how to configure properly. I can setup a radio button and check it as default so its their only option....but will that work so at the end of the competition time I just hit select winner and it will randomly select someone from all the entries even though there is no "correct answer"....guess I can test this.

4)even though read receipt is selected I never get a receipt back from a user who does hit send read receipt.

[husain]

1)when I start a new competition I have to set the date 1 day ahead to actually end on the day I want. So for example if I want to end the competition on Dec 23...I have to set the date to Dec 24th. Weird thing is if I go to edit the competition after setting it up it shows Dec 23.....???

2)how can we change what time the competition ends? Currently they all end at 5pm on the given day. Is there somewhere we can change the time?I am aware of this and have been trying to study how vBulletin handles dates. What the hack is doing right now is that it is ending competitions depending on the GMT setting. So if you competiton ends on 31st Dec and your timezone is set to GMT+5, it will end the competition on 31st Dec at 5am.

I know this is not a desired effect and I am working on it.

3)also I often do giveaways and members simply have to reply to a thread. This would be more useful though...but not sure how to configure properly. I can setup a radio button and check it as default so its their only option....but will that work so at the end of the competition time I just hit select winner and it will randomly select someone from all the entries even though there is no "correct answer"....guess I can test this.If you want to use the "select winner" feature you will have to set the correct answer.

This is what I had done for one competition. My sponsors were giving a way a Westlife album but they wanted everyone to be able to enter without answering a question (because some may answer incorrectly and they didn't want that). So I created a competition without specifying a question and said "to enter, simply type WESTLIFE in the field below and hit submit". The text box also had the default value of WESTLIFE. The correct answer field was also set to WESTLIFE. In that way, everyone entered, everyone got the correct answer and I was able to select a winner using Get Winner. There was also no need to create a thread for people to reply (and increase their postcount for no reason).

[FROGGYJ]

thanks husain! There is only 1 more feature which would really make this perfect and that is usergroup permissions. I often have giveaways only for site supporters and hence why I have a giveaway forum in which only site supporters can post. If you could build in some sort of permissions settings for this app....that would be awesome.

[husain]

The hack already has built-in usergroup permissions that you can use for this. So if you want to restrict a particular usergroup from participating in the competition, you can edit the permissions of that usergroup.

[FROGGYJ]

haha nevermind, I had actually already edited them correctly...just forgot. Thanks for the quick response!

[ChrisBaktis]

i have looked and looked but cannot seem to find the admincp option to delete an entry....any help?

[husain]

There is no option to delete an entry at the moment. It will be added in a future release of the hack.

[ChrisBaktis]

oh ok - there was another post that said you could delete entries via admincp - looking forward to that feature being added.

[FOZ13]

I have ongoing monthly competitions, based on 1 usergroup which is for the financial members only.

Has anyone created a hack that will draw a random winner from a specific user group?

[tris]

I have made a hack which includes more information about the winners in the PM to the competition admin. (e.g. Name, Surname, Street, City etc.)

You only need to modify the custom profile fields to your needs.

E.g. if your customprofile field9 contains the user surname, field10 contains the lastname etc.

Just replace the competitionmanager.php with the attached and modify the customfields on line 590 and 592.

[kadafi_alive]

Any update on the more-than-1-question development?

[husain]

Any update on the more-than-1-question development?

Nope. Multiple-question feature will essentially take this hack back to the drawing board stage as it requires a huge database and code change. While I am working on this, I am not making any commitments to deliver it.

[husain]

I have updated the hack to add some new features that were requested here.


Ability to schedule competitions. You can now set a starting date for competitions. This feature was contributed by Hoffi so all credit goes to him.
You can now delete entries.
Competitions can be disabled. This is useful if you want to preserve the competition information and entries but do not want it to appear on the live website.
Some other minor changes.

As always suggestions, criticism, and feedback is welcome.

[tris]

Many thanks for the update.

I have already integrated the "Include profilefields in Winnerlist PM"

You must edit line 656 and line 658 to include your profile field numbers.

$userinfo .= "Username: {$row['username']}\nEmail: {$row['email']}\n {$userfields['field9']} {$userfields['field10']} {$userfields['field11']} {$userfields['field12']}\n";

unset($row['username'], $row['email'], $userfields['field9'], $userfields['field10'], $userfields['field11'], $userfields['field12']);

[kadafi_alive]

Nope. Multiple-question feature will essentially take this hack back to the drawing board stage as it requires a huge database and code change. While I am working on this, I am not making any commitments to deliver it.

Alright.

Can you also tell me why End Date says:
1 Minute Ago 12:00 AM

instead of showing the actual end date?

Thanks

[husain]

Alright.

Can you also tell me why End Date says:
1 Minute Ago 12:00 AM

instead of showing the actual end date?

Thanks

I haven't been able to reproduce this error on my installation. Does it show you for any competition you create?

[kadafi_alive]

I haven't been able to reproduce this error on my installation. Does it show you for any competition you create?
Yes and it stays at that. It doesn't change at all.

In fact, 4number8 has also the same problem:

I was needing something similar to this, but for my questions the answer would be unknown untill the event was over, can I still use this and add the event date a day later, than update the answer? would doing it this way still work correctly with the PM's? I have installed it and been playing around with it, but it always states that the event end date has ended... like this: End Date: 1 Minute Ago 06:00 PM
anyone have idea's why this is doing this? thanks for a great hack btw

[Hoffi]

Can you also tell me why End Date says:
1 Minute Ago 12:00 AM
This depends onb your local Settings. You display the detailed Versin for the Date. This also happens to this Hack.

[kadafi_alive]

This depends onb your local Settings. You display the detailed Versin for the Date. This also happens to this Hack.

Yes, I use the detailed time on my forum. Are you saying that it's not compatible with the detailed time function?

[criscokid]

This is a fantastic plugin!! Thank you :-)

Constructive comment: At the moment unregistered users (or people who don't have the correct permission to enter a competition) get the standard vBulletin 'you do not have permssion' message...

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

In my opinion this is a very crude message. I'd like to suggest that this part of the plugin be re-written to show a user friendly message that says the competition is only open to registered users and include a link to the user registration page. The user friendly message and the link will definitely encourage more people to register on the forum.

A similar user friendly message should also be used for people who are in the 'user awaiting confirmation category' - maybe they're still unconfirmed because they enterred and invalid email address when they registered and not aware of the fact.

Here's an example message:
Your account has not been confirmed and is not yet active! To become a registered user on scene-OUT.com (required to access many special features) you will need to verify your email address by clicking a special link sent to you in our original welcome email. If you have lost this email, or it never arrived, please go here (/forums/register.php?do=requestemail) to request another activation email be sent to you. If you suspect your email address is set wrong, go here (/forums/sendmessage.php) and fill the form out so an administrator can fix your account. Also please be sure to disable any spam filters you may have for our website, so that this and all future messages can reach you.

[criscokid]

I'd love to see the next version of this plugin include the following features:

* Draw the winners based on the content of a specified field. Example: It's no good giving a person who lives in Sydney the prize of free entry for a year to a club that's in London. In this case the competition should select the winner based on an entrant's city field being London or country field being United Kingdom. There needs to be the flexibity to have the winner based on at least two fields in a case where the prize is say only suited to a man or a woman that lives in a particular city.

* The ability to upload a product photo in the competiton (and set the 'alt' tag - maybe also include a hyperlink for the image that could be used to take a user to the website of the company that sponsored the prize). This will add more colour top the page and make the competition look more appealing! :-)

* If a user attempt to entered more than the allowed number of entries he get's the following message: 'You have already participated in this competition. You cannot enter more than once.' Include a linl back to the competitions page.

[jellybaby]

What happens when you have a lot of competitions running, is it possible to have a click through list to the competitions first so you can go to each individual competition and just have one comp at a time showing on a page?

[husain]

What happens when you have a lot of competitions running, is it possible to have a click through list to the competitions first so you can go to each individual competition and just have one comp at a time showing on a page?You can do that by modifying the templates.

Replace the content of hkc_COMPETITIONS with this:$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$headinclude
<title>$vboptions[bbtitle] - $pagetitle</title>
</head>
<body>
$header
$navbar

<if condition="$showopencompetitions">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td colspan="<if condition="$vboptions[hkc_show_total_entries]">3<else />2</if>" class="tcat">$vbphrase[hkc_open_competitions]</td>
</tr>
<tr>
<td class="thead">$vbphrase[hkc_competitions]</td>
<td class="thead" align="center">$vbphrase[hkc_competition_end_date]</td>
<if condition="$vboptions[hkc_show_total_entries]"><td class="thead" align="center">$vbphrase[hkc_entries]</td></if>
</tr>
$opencompetitionlist
</table>
</if>

<br />

<if condition="$showpendingcompetitions">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td colspan="2" class="tcat">$vbphrase[hkc_pending_competitions]</td>
</tr>
<tr>
<td width="100%" class="thead">$vbphrase[title]</td>
<td class="thead" align="center">$vbphrase[hkc_competition_start_date]</td>
</tr>
$pendingcompetitionlist
</table>

<br />
</if>

<if condition="$showclosedcompetitions">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td colspan="<if condition="$vboptions[hkc_show_total_entries]">4<else />3</if>" class="tcat">$vbphrase[hkc_closed_competitions]</td>
</tr>
<tr>
<td width="100%" class="thead">$vbphrase[title]</td>
<td class="thead" align="center">$vbphrase[hkc_competition_end_date]</td>
<if condition="$vboptions[hkc_show_total_entries]"><td class="thead" align="center">$vbphrase[hkc_entries]</td></if>
<td class="thead" align="center">$vbphrase[hkc_winner]</td>
</tr>
$closedcompetitionlist
</table>
</if>

$footer
</body>
</html>

and replace the content of hkc_competitions_openbit with this:<tr>
<td class="alt2" width="100%"><a href="competitions.php?do=participate&amp;cid=$competition[competitionid]">$competition[title]</a></td>
<td class="alt2"><nobr>$competition[enddate] $competition[endtime]</nobr></td>
<if condition="$vboptions[hkc_show_total_entries]"><td align="center" class="alt2">$competition[entrycount]</td></if>
</tr>

[MorrisMcD]

Forgive me.. But I have this installed and I am not quite sure what it does... It seems to be like a questionair and if you answer the questions right, you win? I dont actually get it.. Can you give me an example of what you use it for?

[jellybaby]

Thats brilliant Husain, thank you :)

Another question, when I select Get Winner, it comes up with a box asking me to put the winners ID in, is that right, and if so does that mean I have to go and look through the entries and select the winner?

Thanks

[husain]

Thats brilliant Husain, thank you :)

Another question, when I select Get Winner, it comes up with a box asking me to put the winners ID in, is that right, and if so does that mean I have to go and look through the entries and select the winner?

ThanksYes you would have to select the winners manually. My code is not intelligent enough at the moment to pick winners in an unbiased fashion and it is best that the owners of the website pick the winners.

If you select a single-selection radio button as the answer type and specify the correct answer, the code will automatically select the specified number of winners provided that they have answered correctly. This happens by selecting a record from the database at random though I cannot guarantee that it would be the most unbiased selection.

--

I would be happy if anyone is willing to develop some intelligent form of selecting winners for this hack. Please get in touch with me to discuss ideas.

[jellybaby]

This will make it so much easier. Will this affect performance on my board at all if I run a lot of competitions and they have a lot of entries?

Again, many thanks for this great plugin.

[husain]

No it shouldn't affect the performace of your board.

[jellybaby]

Brilliant thanks. Must admit I added this to my board when you first put it out and then forgot all about it as I was inundated on my site. This will help me out so much!

[3dsoft]

Is there a hook for ebux (https://vborg.vbsupport.ru/showthread.php?t=106953&highlight=eBux) available?

So that the winners get points.

[criscokid]

Here's another suggestion for the the next version of this fantastic plugin:

The ability to capture personal details of the winner like name and address. I run competitions on my site with tangable items as prizes like DVDs theatre tickets, etc. The prizes need to be posted to the winners. WHen the site admin tells the plugin who the winners are it would be great if the plugin fired off an email to the winner congratulting them and asking them to reply to the email by filling in their name and address so ther prize can be sent out in the post.

[jellybaby]

I have a problem with this in that when the competition ends it puts me (Admin) as the winner. Dont seem to be showing the section for me to pick a winner, any ideas please?

[bada_bing]

Would love to see this hack progress as my site host many contests per year and this hack would be a better way to do them. I would like to see many of the brillant ideas suggested by other in the next version before I install

[D|ver]

Is there a hook for ebux (https://vborg.vbsupport.ru/showthread.php?t=106953&highlight=eBux) available?

So that the winners get points.
yeah a vbbux integration would be so great :)

joining a competition should also cost eg. 100 bucks oder something, that would be really nice :)

[Oddjob]

yeah a vbbux integration would be so great :)

joining a competition should also cost eg. 100 bucks oder something, that would be really nice :)


Thats why i dont have this installed...no vbbux integration.

[criscokid]

Another idea to further enhance this great plugin:

Create a competitions block for the front page of a portal (like vbPortal) that lists the title of the current competitions. This would help draw people's attention so a site's competitions section.

[Tommm]

Hi!

This is a great plugin - I find it very useful!

I've just closed a competition which I set to have 3 winners. When I click Get Winners and enter the winning user IDs as: 789,16,81 or 79, 16, 81 I'm presented with the following message:

vBulletin Message


Please enter a custom message.

GO BACK

Any ideas how to get around this? Thanks!

[husain]

You get this error message if you have set not to send Private Messages to winners. This was a bug which I fixed in the original file. Here is how to fix it:

admincp/competitionmanager.php

Find:
if ($vbulletin->options['hkc_send_pm_to_winners'])
{
print_textarea_row($vbphrase['hkc_custom_pm_message'], 'custom_message', $vbphrase['hkc_pm_custom_message'], 4, 40, false);
}


Replace with:
if ($vbulletin->options['hkc_send_pm_to_winners'])
{
print_textarea_row($vbphrase['hkc_custom_pm_message'], 'custom_message', $vbphrase['hkc_pm_custom_message'], 4, 40, false);
}
else
{
construct_hidden_code('custom_message', 'nothing');
}

[Tommm]

Perfect - thank you!

[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]

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/competitionmanager.php?do=modify
Referrer : http://www.clubx360.it/forum/admincp/index.php?do=nav
IP Address :
Username :
Classname : vb_database

[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`
--

[swantonio]

the querry non funzionano !!!!

[SLGR]

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

[husain]

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]

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/competitionmanager.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/competitionmanager.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?
:)

[husain]

Can you reproduce the unread PM error again? Has anyone else had this problem too?

--

When a competition ends, nothing happens really other than the competition being shown in the Closed Competitions list. It is up to you to remember when competitions close and select winners.

I am working on setting up a cron job to notify the administrator when a competition ends. Other than that, what would you want the hack to do when a competition ends?

[criscokid]

Husain: are you planning on any new versions of this great mod anytime soon? Just curious as I've previously submitted some suggestions to this thread.

[Smiry Kin's]

possible to make it work on posts..

it selects a X amount of people from a X group( the top X people who posted the most ), and randomly choose who will win??

[cat4m]

Argggh ! I still get the following message in the amin cp

Start Date End Date Controls
1 Minute Ago 01:00 AM 1 Minute Ago 01:00 AM

Also I uploaded the 2nd XML file and disabled the first one and dont have anything showing on my forums now. I have put all the files to their original settings and still have no Competition showing on the forum page. ??

The dates and times still remain the same. Can someone help please.

[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..."

I've already had a few companies discover my competitions section - they've gone on to email me asking how they can get involved. If there was a link there I'd probably get even more enquiries and prizes being donated. The link could open a new page telling them the low down and what they need to do to get the ball rolling or maybe the link could just open a page asking for more deatils like company name, what they have in mind as prizes, etc and that info can then get sent as an email to the site admin.

[funinthesun]

I've just installed this and I get this error:
Database error in vBulletin 3.5.3:

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

MySQL Error : Table '*****db.hkc_competitions' doesn't exist
Error Number : 1146
Date : Friday, May 12th 2006 @ 09:54:46 PM
Script : http://www.*******.com/competitions.php
Referrer : http://www.******.com/competitions.php
IP Address : **.*.***.**
Username : ******
Classname : vb_database

Any idea what's wrong?

[Jaymee]

Thanks ALOT dude!. Really helpfull

[SimonVlc]

Hi all,

I´m having one trouble using this mod with one line answer. The system didn´t recognize any winners.

Ex. I create a dummy competition with answer "anything". I´ve enter the comp with a user, write the correct answer, close the comp, and pushed on get winners, but the system ask me to enter the id of the winners.

If I do the same with radio buttons, the system identifies correctly the winners.

Is this the normal behaviour? Thanks in advance, Simon.

[peterska2]

I've never used the free text answers, just the radio buttons and it has worked every time for me.

Using free text requires exact capitalization and spelling so it could be difficult for the system to match it.

[SimonVlc]

Thx for the answer peterska, but I´m still unnable to get it working.

Copy pasting the answer didn´t work... anyone else did notice this behaviour?

Thanks in advance, Simon.

[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]

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]

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:

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]

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

[Hoffi]

No Problems here with 3.6

[powerbook]

I installed and also get access not allowed. I can't see the permision in the usergroups. There is nothing in group permissions about competition...

[Antivirus]

I installed and also get access not allowed. I can't see the permision in the usergroups. There is nothing in group permissions about competition...

It's under Usergroup Permissions, the second table down from top.
Admincp>Usergroups>UsergroupManager>EditUsergroup

[red-dna]

ok, working fine. But, how the users can post new competitions ?

[criscokid]

how the users can post new competitions ?
It's not designed for users to create new competitions only for site admins.

[mcyates]

this WORKS in version 3.6.0 also.

[VViper]

what an awesome hack, i would love the ability to add an image in the competion, like name that band based on an album cover. Any chances of that in upcoming editions. :)

[ibetthis]

Well, how do admin select a winner. I don't see an option to do that...

[jellybaby]

if you click on competition managers it should show your competitions there and it should show "Get Winner" next to the individual competitions

[criscokid]

i would love the ability to add an image in the competion
You can do that using HTML in the text block.

[fishhub]

any links to show how the competition hack works?:)

[JohnBee]

Can this MOD be used for image competitions?
In a case where users would attach images and members could vote on them?

[criscokid]

Can this MOD be used for image competitions?
In a case where users would attach images and members could vote on them?
It's the site admin who loads new competitions.

[fishhub]

It's the site admin who loads new competitions.

yes, the site admin will load new competitions. But can the site admin set the competitions for users to upload pictures for polling?
TIA

[criscokid]

You could use it for 'polling'... you'd have to word the text accordingly because the mod uses sentences / phrases like 'enter competition'.

The text and images that you add uses HTML so you can do whatever you want.

[pcoskat]

It's not designed for users to create new competitions only for site admins.

Anyway this can be modified for users to create competitions?

[wilde108]

Is there a way that I can have user's upload images for a contest. To see what im talking about check out my contest section on my site. I want to use this to simplify what im already doing. http://www.photoshopchop.com/Contest

[tidy_boy]

I would like to see this mod edited for users to upload comps as well. Any chance this will be done?

[Kodyr]

When I go to edit the permissions of the usergroups,
The permissions arnt there >.<
What did I do wrong?

[provedel]

Is this hack dead?

Is one of favorites mods, and I find really pleased if this continues to growing...

There a several suggestions can be added to the mod, i hope its continue to be developed.

[Mum]

I would love it for 3.6

[ringleader]

I would love it for 3.6

I installed it (probably without looking at the versioning).
I now use 3.6.8 and it's still working fine.

[MuzzyElite]

For those who dont get access, just goto usergroups and goto the bottom and set the competition settings to yes.

And, how do I add competitions?

[Hoffi]

In the Admin CP you can add them.

[daFish]

First: Great addon. I really like it, but I might have found a bug.

I've created a competition with a multiple line answer type and typed in the possible answers, e.g.:

Bill Gates & Steve Jobs
George Bush & Bill Clinton
etc.In the field for the right answer I copied the text from the textfield and pasted it into the field.
When viewing the recent entries for this competition, one of the usermade entries was the correct answer, although it is displayed as wrong.
Seems to be a bug.

[daFish]

After looking at the database were the competition data is stored, I noticed that the possible answers a HTML encoded (&amp;) while the real answer was not. After fixing this by hand, the correct answer is no more striken.

[vwdforum]

I've just added this close protection competitions (http://www.closeprotectionworld.co.uk/competitions.php) which is version 3.8

It works like a dream, I've added a competition easily

thanks

[manning]

I've just added this close protection competitions (http://www.closeprotectionworld.co.uk/competitions.php) which is version 3.8



Do you mean 3.6.8 ?

[pmcnamara]

So this works on ver 3.6.x then also ?

[hrk]

is this comp with vb3.7 series?

thanks

[leannet]

Editing the navbar template

Where do I find this?

[pkallberg21]

Do you have any plans of updating this script to 3.6.7? That would be very nice :)

Also, I would be very happy if you could create a template to show who if a user has won a tournament in their member profile.

By the way, thanks for this great mod!

[dartho]

seems to work a treat on 3.6.8PL2 :up

[Bilderback]

...working so far on 3.7.0 RC 1
I love it when clean code products are released that will span to multiple versions.
Amazing how this was developed for 3.5.3 and still works on my 3.7.0

[Mum]

Works fine on 3.7.1

[TheSupportForum]

works great on 3.7.3

[EAMedia]

I play habbo, and i think this is just what i needed for my forum.

[manning]

Is the script supposed to redirect to a "thank you for entering" type page after a user enters? Mine just redirects to the main script page where users can click enter again - of course it wont let them, but would be nice if they were shown a thanks page instead...

[GreigScott]

Is the script supposed to redirect to a "thank you for entering" type page after a user enters? Mine just redirects to the main script page where users can click enter again - of course it wont let them, but would be nice if they were shown a thanks page instead...

go into options then edit?

[manning]

go into options then edit?

All I see in the settings section is an option to PM users ... nothing about a redirect to thank you for entering page.

[tandalier]

doesn't work here in 3.7.1
can't see the panel, where to change user-rights and cant't see the competition-admin-system.
Any good advise?

[dartho]

I installed and had working under 3.7.3 pl1 with no issues - double check all your settings

[Nadavy]

Would it be possible to make this mod controllable through administrator permissions so only some administrators see it :D ?

[jessp]

icecubejackal, you do not have permission to access this page. This could be due to one of several reasons:

1. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
2. You have not filled out some required fields in your profile. Please ensure that the following fields are filled out:

1. I already do the permission on admincp
2. Im confused of the Mandatory Profile Fields?? which id im going to put user id? or group id?

im using 3.7.3 version

[jessp]

Anybody here can give any help regarding with my current problem encountered?

[uwebgg]

does anybody got it working on 3.8.0? I got a DB error when I complete a competition

[SVTCobraLTD]

Can anyone post a demo?

[dmknights]

will this be updated to 3.8?

[thompson]

i have it online since 3.6 without problems.

has anyone changed the mod, that competitions did by moderators ?

[SVTCobraLTD]

Anyone have a demo they could post of this?

[Veelox]

Edited because I found out why I couldnt access it, had to go into usergroups and right to the bottom to select allow to enter

Thats what i had to do for every usergroup.

Mod
Super mod
admin
registered

[Razfaz]

i need the Competitions Hack for the new Version VB4.
Could to release a new version please?

[Kolbi]

Am I allowed to update it for vB 4?

[Razfaz]

@ Kolbi : I think this is no problem, how long do you think it takes?

[Kolbi]

@Razfaz

First I have to get the permission from the developer :)

I guess around May it would be ready :)

[Helmut71]

anything new??
Has this add on updates for vb4 yet?

[Kolbi]

Sorry I never had the time to update :)

Perhaps I can overview the code this week...

[Kolbi]

I only need someone who updates me the php code :)

The template things can I manage... :)

I guess the competitions.php has to be splitted up into some plugins...

[the_ace]

works fine on vb .3.8.6 PL 1

[flr]

Hi,

I have installed onto a new copy of 4.1.1 and customised the NAVBAR code myself. All working but when i click on COMPETITION on the navbar i get the following error:

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: hkc_competitions_openbit in [path]/includes/functions.php on line 4097

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: navbar in [path]/includes/functions.php on line 4097

Parse error: syntax error, unexpected T_STRING in /homepages/1/d348433514/htdocs/cpmedic/competitions.php(353) : eval()'d code on line 1

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: hkc_COMPETITIONS in [path]/includes/functions.php on line 4097

Any idea?

[dartho]

This add-on will not work under 4.x. Some 3.x functions, in particular those that fetch templates and generate the content do not work under 4.x

[flr]

Is there anyway it could work, or does anyone know of an alternate mod to run competitions on vbulletin?

thanks!

[Razfaz]

The Coder was Last Online: Feb 2010
Can anyone make this cool Script for vB 4.1.x ???

[Kolbi]

Had updated it to vB4 and it works very well.

Currently I have to learn for my exams. After my exams I'm working on some last style changes and then I publish the new vB4 version.

vB4 version: http://www.2-wheel-planet.de/competitions.php

[vwdforum]

Had updated it to vB4 and it works very well.

Currently I have to learn for my exams. After my exams I'm working on some last style changes and then I publish the new vB4 version.

vB4 version: http://www.2-wheel-planet.de/competitions.php

Hi, I'm looking forward to seeing your new version. Any idea when it will be released? thanks

[MusixP]

Hi, I'm looking forward to seeing your new version. Any idea when it will be released? thanks

me2

[keledan2]

Had updated it to vB4 and it works very well.

Currently I have to learn for my exams. After my exams I'm working on some last style changes and then I publish the new vB4 version.

vB4 version: http://www.2-wheel-planet.de/competitions.php

We're looking forward your hack! Have you got news for us?

[vwdforum]

Hi, any update for a version 4?

[Kolbi]

Hi guys, today I'm reconstruct my developement machine :) Then the work goes on...

[keledan2]

Hurry please! We can't do without it:)

[Kolbi]

Has anyone tested vBQuiz developed by Dragonsbyte?
https://vborg.vbsupport.ru/showthread.php?t=262358

I guess this can be used, too.

Or is more or less better than the competitions mod.

[vwdforum]

any news on a upgrade?

[vwdforum]

Hi, any update please?

[keledan2]

up!

[vwdforum]

I'm wondering if this will work on vbulletin 4?