Members Choice Voting Hack

I built this hack at the request of one of my members before reading many requests for it on vb.org.
I have not added an auto award sequence as I have Lesane's awars/medals/card hack. However you can use this as a stand alone addition, I have a forum called "Spotlight" where I announce a member, product and service of the month.
This hack also makes use of my Links To Us hack if you have it installed.

The member who nominates another can give reason for nominating the person.
Each nominee will see a red "You have been nominated." on their home page, they then go to the members choice area to add a nomination acceptance speech.
Avatars are also displayed for both nominee and nominator, (Defult included)

As a member is nominated he is added to the nominee list.
For each nominee, members can:
1) See who voted for each.
2) Vote for a nominee if permitted, they can also add a reason for their vote
3) Read the nomination reasons and acceptance speeches etc
4) view their forum stats, this includes: amount of new posts, amount of new threads, amount of member votes, amount of new member refferals and if you have my "Links To Us" hack it will also display the amount of people that have clicked on their website banner. These stats start from the time of nomination.

Nomination and voting rules:
1) You may not vote or nominate yourself.
2) You may not vote for the person that you nominated.
3) You may not vote more than once for the same nominee.
4) Only X nominations will be accepted. (can change from admin)
5) You may nominate more than one member. (can change to one only from admin)
6) You may vote for more than one nominee. (can change to one only from admin)
7) You may only nominate members from their posts.

DEMO: www.atmyparty.com

SCREENSHOT: Next posts

REQUIREMENTS:

6 X php file alteration
1 X database query
23 X new templates
1 X template modifications

INSTALATION TIME: aprox. 20 min

Includes a php file to do database changes.

Please click "Install" if you use it.

This update includes the following new features:
1) Leader board link from main page as requested by DPoole .
2) Limiting the viewing of "Who Voted" to selected user groups as requested by USODJA.

~ This hack is Copyright ~
Please note that I reserve the right to code and release this hack for VB3, I have not and will not grant permission for anyone else to code this hack for VB3.

[trafix]

not nominated

[trafix]

member nominated

[trafix]

nomination accepted

[trafix]

nomination screen

[trafix]

voting screen

[trafix]

last...admin

[Koutaru]

This looks very interesting I'll definately try to install it onto my testboard and try it out

[trafix]

ok thanks..please let me know how you go

[DPoole]

easy to install - took 15mins

i ran the query in admin as stated and everything went fine until i went to the config in admin cp

then whenever i enter the title of the vote or swich any setting on i get this

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE memberschoiceadmin set status='1', statusreason='yes', nomineesmax='10', awardname='member', nominateone='1', voteone='1' WHERE event=1
mysql error: Unknown column 'status' in 'field list'

mysql error number: 1054