Members Choice voting hack - V2 with usergroup permissions

I have eventually got around to porting and releasing this hack on vborg for vb 3.0.5

1 file edit
3 template edit
3 new db table

This hack uses and includes a copy of the [HIS] Hack Installer System (Build 3)
released by Link14716 and can be found here --> https://vborg.vbsupport.ru/showthread.php?t=71542


This is similar to the earlier version however i have mane some changes including the ability to run more that one polling booth at a time

The member who nominates another can give reason for nominating the person.
and then the nominee can add an acceptance speech.
Avatars are also displayed for both nominee and nominator.

A Tutorial for manual install can be found here https://vborg.vbsupport.ru/showthread.php?t=76050

UPDATE V1.1

missing phrases added
changed wrong phrase call in template
fixed db quirie to add the table prefix


UPDATE V1.2

Changed phrasegroup id due to conflict with another hack

Update V2
1. Booth auto close.
2. Add option for nominate to be able to vote for the person they nominated
3. Add option to deny admin from nomination.
4. Added usergroup permissions for
-- Who can vote
-- Who can nominate
-- who can remove nominees
-- who can see votes.
5) fixed some phrases
If you are upgrading please be sure to remove the "1" folder before starting the install of v2

[shadiguy1]

i keep getting this error when i try and install it right after it says it changed all my stykes and i click done i get thsi error ill post a pic

[shadiguy1]

Bump

[MR-2ZZ]

I too get the same error

[Marco van Herwaarden]

In file install/hacks/Members Choice/2/queries.php change

PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
)'; 


into (remove the closing ")"):

PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
'; 


[MR-2ZZ]

Great now I cant update any of my usergroups

[MR-2ZZ]

Originally Posted by MarcoH64

In file install/hacks/Members Choice/2/queries.php change

PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
)'; 


into (remove the closing ")"):

PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 
                ADD mcpollingbooth INT( 12 ) NOT NULL
'; 


same error occured

[MR-2ZZ]

Ok here is what I did, I removed from the queries the first 2 and the last query, and removed all mc_xxx from my db. Install went through, I then manually enterered this:

 ALTER TABLE `usergroup` ADD `mcpollingbooth` INT( 12 ) UNSIGNED NOT NULL ;

and now everything is back working on my site. I can give user group permissions and what not. I added a booth and it went fine, but nothing else seems to work. I am also going to have to figure out why there is no title for the drop down in the admincp.

[MR-2ZZ]

It appears that it is working as normal after I did the above.

[shadiguy1]

trying everything damn thing will not install i keep getting the database error

[MR-2ZZ]

Do This...

* Make necessary changes per Readme
* Go into your DB and drop all mc_ tables
* Find the /Members choice v2/upload/install/hacks/Members Choice/2/quieries.sql, and change it to the below form.

PHP Code:

<?php

$query['new'][] = 'CREATE TABLE '. TABLE_PREFIX .'mc_nominee (
`mc_nomineeid` int(11) unsigned NOT NULL auto_increment,
`boothid` int( 11 ) NOT NULL default \'0\',
`userid` int( 11 ) NOT NULL default \'0\',
`username` varchar( 225 ) default \'0\',
`nominatorid` smallint( 5 ) default \'0\',
`nominatorname` varchar( 50 ) NOT NULL default \'\',
`votes` smallint( 6 ) default \'0\',
`nomreason` mediumtext NOT NULL ,
`acceptspeach` mediumtext NOT NULL ,
`datestamp` int( 10 ) NOT NULL default \'0\',
PRIMARY KEY ( `mc_nomineeid` ) 
) TYPE = MYISAM ;';

$query['new'][] = 'CREATE TABLE '. TABLE_PREFIX .'mc_pollbooth (
  `mc_pollboothid` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default \'\',
  `status` smallint(2) default \'0\',
  `statusreason` varchar(255) NOT NULL default \'\',
  `startdate` int(11) unsigned NOT NULL default \'0\',
  `enddate` int(11) unsigned NOT NULL default \'0\',
  `qty_nominees` smallint(3) default \'0\',
  `qty_votes` int(11) NOT NULL default \'0\',
  PRIMARY KEY  (`mc_pollboothid`))';

$query['new'][] = 'CREATE TABLE '. TABLE_PREFIX .'mc_whovoted (
  `mc_whovotedid` int(11) unsigned NOT NULL auto_increment,
  `boothid` int(11) NOT NULL default \'0\',
  `nomuserid` int(11) default \'0\',
  `nomusername` varchar(255) NOT NULL default \'\',
  `voteruserid` int(11) default \'0\',
  `votername` varchar(255) NOT NULL default \'\',
  `votereason` mediumtext NOT NULL,
  `votedate` int(10) unsigned NOT NULL default \'0\',
  PRIMARY KEY  (`mc_whovotedid`)
)';

?>

* Re-Run the Install script.
* Manuall enter this code into your DB

ALTER TABLE `usergroup` ADD `mcpollingbooth` INT( 12 ) UNSIGNED NOT NULL ;

* Next goto AdminCP, goto Languages and Phrases, select any phrase (edit) and save without changing anything.

* That should work now