vb.org Archive - Competitions

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Competitions (https://vborg.vbsupport.ru/showthread.php?t=100150)

Quote:

Originally Posted by 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.

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.

I got this when I first tried to upload the plugin

Code:

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

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.

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

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.

Quote:

Originally Posted by error one

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/p...?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

Code:

) TYPE=MyISAM;

";

which is where you are getting the double ;; from.

Quote:

Originally Posted by error two

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/p...?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.

Quote:

Originally Posted by error three

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/p...?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.

Quote:

Originally Posted by error four

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/p...?do=productadd
IP Address :
Username : peterska2
Classname : vb_database

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

Quote:

Originally Posted by error five

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/p...?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.

Quote:

Originally Posted by error six

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/p...?do=productadd
IP Address :
Username : peterska2
Classname : vb_database

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

Quote:

Originally Posted by error seven

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/p...?do=productadd
IP Address :
Username : peterska2
Classname : vb_database

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

Quote:

Originally Posted by error eight

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/p...?do=productadd
IP Address :
Username : peterska2
Classname : vb_database

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

Quote:

Originally Posted by error nine

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/p...?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.

Quote:

Originally Posted by error ten

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/p...?do=productadd
IP Address :
Username : peterska2
Classname : vb_database

Again forgot that I had already manually added this table.

Quote:

Originally Posted by error eleven

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/c...ionmanager.php
Referrer : http://www.peterska2.co.uk/admincp/c...ompetitionid=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.

[high]* peterska2 hopes this post isn't over the character limit![/high]

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

Quote:

Originally Posted by husain

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;

PHP Code:


		
			
$db->hide_errors()

and this to the end;

PHP Code:


		
			
$db->show_errors()

The simple reason being that if tables or columns already exist then failure messages are expected, but need to be ignored.

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

Quote:

Originally Posted by husain

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

Won't be long. :)

Here you go :)

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?

Quote:

Originally Posted by Don Corleone

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?

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

great hack thanks :)

Quote:

Originally Posted by bitg

Any ideas on this?

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?

Quote:

Originally Posted by bitg

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?

Quote:

Originally Posted by Lyricsmama

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.

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

Quote:

Originally Posted by mrahul

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.

Great hack !! :)

File attach: French language ;)

Click Install

Quote:

Originally Posted by Don Corleone

Maybe you should take a look at the InfernoQuiz.

Quote:

Originally Posted by husain

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

@Tidy_boy

What code do you use for it ?

Quote:

Originally Posted by Allan

@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/showt...ht=align+image

Quote:

Originally Posted by Allan

@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>

Quote:

Originally Posted by husain

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.

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

1) Open the Template navbar
search for:

HTML Code:

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

And add after

HTML Code:

<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

Quote:

Originally Posted by Hoffi

1) Open the Template navbar
search for:

HTML Code:

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

And add after

HTML Code:

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

thank you so much :nervous:

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

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.

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

http://www.vbhacks-germany.com/forum...4812#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!

Quote:

Originally Posted by lawahdy

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

Does this allow folks to 'upload' submissions?

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 ?

Quote:

Originally Posted by version2

Does this allow folks to 'upload' submissions?

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

Quote:

Originally Posted by 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 ?

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.

Quote:

Originally Posted by husain

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.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01410 seconds Memory Usage 1,912KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (4)bbcode_html_printable (2)bbcode_php_printable (29)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: