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]

Click cklick....bang bang......run this quiry and all will be ok

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


i am just about to update zip......for the final time....lol

[partang2]

You are a hardworking hacker m8! Looking forward to try this thing.

[trafix]

i think most of the problem is that i am still learning.....database stuff isnt my strong point.

Thanks for your support and let me know how you get on.

[partang2]

Will try it right now. Will let you know soon....

[partang2]

Well, I have tested it now and it worked ok. The reason I don't wanna use this (even if I liked it) is that you have put links in the templates back to your own forum registation so that peoples who clicks the nick to the nominated member's at my forum are beeing redirected straight to your place...! God knows where else there are links like that... NOT GOOD!!! :angry:

[trafix]

i cant see the last post here but i did get it in my mail,

are you talking about the "members choice hack by trafix" bit at the bottom?????

i can assure you that there is no other links, hidden or otherwise.

[trafix]

i see what you are talking about......whoops another bug..thank you for pointing it out,
will update zip to 1.7 soon

replace entire memberschoice_bit template with

[partang2]

Ok that's fine, but I can't get the same colors as the rest of my forum in the memberschoice_nominate_member template:

__________________________________________________ __
<p align="center"><normalfont><br>What is your reason for nominating <b>$nominatemember?</b></p><p align="center">
<TEXTAREA cols=80 name=nomreason rows=8 wrap=Virtual></TEXTAREA></p><br></td>
</tr>

<tr>

<td bgcolor="#000ec0" colspan='2' align='middle'><p id='submitrow'><input type="submit" value=" Nominate Now " accesskey="s">

</p></td>

</tr></table></form></TD>
</TR>
</TABLE>

$footer

</body>

</html>

__________________________________________________ __

Maybe I am tired here, but what is wrong with this?
All the others are ok...

[DPoole]

$DB_site->query("INSERT INTO memberschoiceadmin VALUES (1,'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 (1,'1', 'Voting for the n' at line 1

[trafix]

damn damn damn

try

$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')")