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

[tomshawk]

Originally Posted by bgtking

I'm getting this error when installing:

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE " . TABLE_PREFIX . "usergroup 
				ADD mcpollingbooth INT( 12 ) NOT NULL
)
mysql error: You have an error in your SQL syntax near '" . TABLE_PREFIX . "usergroup 
				ADD mcpollingbooth INT( 12 ) NOT NULL
)' at line 1

mysql error number: 1064

I got the same problem.

Seems something got changed in 3.0.7, What, Thats another question

I tryed the manual install pointed out here and it didn't work either

[tomshawk]

Is there no support for this hack anymore?

Just asking, I realize you may be busy.

[Marco van Herwaarden]

In your './install/hacks/Members Choice/2/queries.php' file, find:

PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 


Replace :

PHP Code:

$query['new'][] = 'ALTER TABLE ' . TABLE_PREFIX . 'usergroup 


[tomshawk]

Originally Posted by MarcoH64

In your './install/hacks/Members Choice/2/queries.php' file, find:

PHP Code:

$query['new'][] = 'ALTER TABLE " . TABLE_PREFIX . "usergroup 


Replace :

PHP Code:

$query['new'][] = 'ALTER TABLE ' . TABLE_PREFIX . 'usergroup 


Thank you

Now I get this

Invalid SQL: ALTER TABLE language ADD `phrasegroup_members_choice` MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'phrasegroup_members_choice'

mysql error number: 1060

Warning: halt(./includes/functions_log_error.php): failed to open stream: No such file or directory in /home/techunit/public_html/forums/includes/db_mysql.php on line 387

Warning: halt(): Failed opening './includes/functions_log_error.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/techunit/public_html/forums/includes/db_mysql.php on line 387

Thoughts?

[Marco van Herwaarden]

This is probably because some of the queries already have run. Sorry i don't have time today to have a look how to fix this. If nobody else helps you today, i will try to have a look tomorrow.

[tomshawk]

Originally Posted by MarcoH64

This is probably because some of the queries already have run. Sorry i don't have time today to have a look how to fix this. If nobody else helps you today, i will try to have a look tomorrow.

But I went through the uninstall so I couls start over with your changes and it did not uninstall

Hopefully I'll hear from you tomorrow, Thank you

[Marco van Herwaarden]

Please send me a PM about this or i will forget.

[Marco van Herwaarden]

Ok, run the following queries, ignoring any errors you might get to really uninstall all database changes. Then install again, using the modified queries.php. If you are using a table_prefix, you should manually add this in front of all table names.

[sql]ALTER TABLE language DROP COLUMN phrasegroup_members_choice;
DELETE FROM phrasetype WHERE phrasetypeid = 887 AND fieldname = 'members_choice';
DROP TABLE mc_nominee;
DROP TABLE mc_pollbooth;
DROP TABLE mc_whovoted;
ALTER TABLE usergroup DROP COLUMN mcpollingbooth;
DELETE FROM setting WHERE grouptitle = 'mc_polling';
[/sql]
That should do the trick i think.

[tomshawk]

Thank you for the assistance MarcoH64

This let me attempt to reinstall again, but I got the same error

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE " . TABLE_PREFIX . "usergroup 
				ADD mcpollingbooth INT( 12 ) NOT NULL
)
mysql error: You have an error in your SQL syntax near '" . TABLE_PREFIX . "usergroup 
				ADD mcpollingbooth INT( 12 ) NOT NULL
)' at line 1

mysql error number: 1064

[Marco van Herwaarden]

Then you have used the original queries.php, and not the modified one (the first fix i gave you). Like i posted you should run the modified one, or you will have the same problems again.