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.

[DPoole]

$DB_site->query("INSERT INTO memberschoiceadmin VALUES (NULL,'1', 'Voting for the next award will start soon', '1', '10', 'Member of the Month', '1', '1')")

You have an error in your SQL syntax near '$DB_site->query("INSERT INTO memberschoiceadmin VALUES (NULL,'1', 'Voting for th' at line 1

[trafix]

partang2,

hmm interesting...the area where the textbox is should be the second alt colour ..... is it not doing that?
can you pm me a link to your board?

[partang2]

There is nothing in that template who shows to "second alt colour"....?

[trafix]

Today at 12:42 AM DPoole said this in Post #41
$DB_site->query("INSERT INTO memberschoiceadmin VALUES (NULL,'1', 'Voting for the next award will start soon', '1', '10', 'Member of the Month', '1', '1')")

You have an error in your SQL syntax near '$DB_site->query("INSERT INTO memberschoiceadmin VALUES (NULL,'1', 'Voting for th' at line 1

You seen to be fairly capable with mysql...open your phpmyadmin
select memberschoiceadmin from the table list..then click on "insert row" you can manually enter the data ensuring that "event"=1

[trafix]

partang
here is the full template

[partang2]

Did you check your templates m8? Think there are some errors in them.... several .gif's linked from vbulletin doesent show up etc...

[trafix]

in the 21 templates there is only 6 .gif images apart from the avatars, all being at the start of the nav

<img src="{ imagesfolder }/vb_bullet.gif" alt="" border="0" align="absmiddle">

[DPoole]

ok i tired that trafix but it was already set at 1 as far as i could see so i thought id be smart and delete the tables from teh database now i get mysql errors just trying to run the mychoicequery.php

I thought dropping tables would allow me to re-add em running this but obviously it never.

No problem though i can just drop database and install again

Is the zip in first post updated to reflect all the database queries that are needed??

thanks for help as well

[trafix]

yep the zip is updated...for the doqurie php file to work you will need to drop all 3 tables

[partang2]

Today at 03:20 PM trafix said this in Post #47
in the 21 templates there is only 6 .gif images apart from the avatars, all being at the start of the nav

<img src="{ imagesfolder }/vb_bullet.gif" alt="" border="0" align="absmiddle">

Nope, this is from memberschoice_bit:

<table cellpadding="10" cellspacing="0" border="1" width="100%" bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif"><tr><td>