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.

[bandersen]

Installed - thank you!

Changed "leaber Board" spelling in the memberschoice.php...

[bandersen]

If you have more updates coming... could you include it so that a member gets an Email when nominated? Thank you!!!!

[trafix]

Today at 01:00 AM bandersen said this in Post #72
If you have more updates coming... could you include it so that a member gets an Email when nominated? Thank you!!!!

ooooops...i didnt notice the spelling....lol...i will fix zip soon, i have to do a shut down before my pc crashes

re: email.....i have thought about adding a auto PM upon nomination.

Thanks for your comments, enjoy the hack

[trafix]

ok spelling error fix in zip

ps if you where waiting for any bugs to be ironed out of the "Links To Us" hack before installing it....

it now also is installing without a problem

[NuclioN]

Working fine so far trafix But when you vote on for example yourself, the vote is not counted but when you after this 'non legitimate' vote place your vote on another member you can not vote because you have made a (false) vote.

[trafix]

ok...i dont know why but i will look into it

[LangTuDaTinh]

there is one problem /w memberschoice_bit , so open it and remove this line

http://www.atmyparty.com/network


also, more suggestions

1. limit number of vote a user can have
2. number of posts require before a user can be vote or nominate a person
3. remove this "&name=$voters[nomname]" from memberschoice.php or use addslashes before do this (if usename have a ' , then the link will not work. )
4. allow guest to view but not vote (do not display the link when guest view memberchoice award.

it's just my suggestions...this is a great add-on.

thanks trafix

Langtudatinh
http://www.tvseriesfans.com/forums/memberschoice.php

[USODJA]

I run this but look what pops up in the database error:
http://www.com/forums/memberschoice.php?action=leaders
____________________________________________

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT * FROM memberschoice ORDER BY votes DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Thursday 27th of March 2003 01:11:19 PM
Script: http://www.com/forums/forums/members...action=leaders
Referer:
________________________________________________

Why is it doubling forums and even when you manually type in with one forum, it still 404s

(i took site name out or people could keep creating database error)

[trafix]

Please check your config settings.....make sure that there IS in all fields.....the quiry that is included to add and alter the database should set a defult in all admin config fields....if nothing there

"Drop" (delete) the three members choice tables from phpmyadmin and use the memberschoicequiry.pfp included in the v2.0 zip of this hack to re-install your tables

This should fix your problem.

Today at 06:18 AM USODJA said this in Post #78
I run this but look what pops up in the database error:
http://www.com/forums/memberschoice.php?action=leaders
____________________________________________

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT * FROM memberschoice ORDER BY votes DESC LIMIT
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Thursday 27th of March 2003 01:11:19 PM
Script: http://www.com/forums/forums/members...action=leaders
Referer:
________________________________________________

Why is it doubling forums and even when you manually type in with one forum, it still 404s

(i took site name out or people could keep creating database error)

[trafix]

Today at 03:53 AM LangTuDaTinh said this in Post #77
there is one problem /w memberschoice_bit , so open it and remove this line

http://www.atmyparty.com/network
**************this is fixed in the current zip file***********

also, more suggestions

1. limit number of vote a user can have
********next update*********

2. number of posts require before a user can be vote or nominate a person
********next update*********

3. remove this "&name=$voters[nomname]" from memberschoice.php or use addslashes before do this (if usename have a ' , then the link will not work. )
*******please tell me the line number(s) of the memberschoice.php where this occours********

it's just my suggestions...this is a great add-on.

thanks trafix

Langtudatinh
http://www.tvseriesfans.com/forums/memberschoice.php

4. allow guest to view but not vote (do not display the link when guest view memberchoice award.

find near top of memberschoice.php

PHP Code:

if ($bbuserinfo[userid]==0) {
    eval("standarderror(\"".gettemplate("error_nopermission_loggedout")."\");");
  } 


move it to under this

PHP Code:

// ##################### check if user exists or has been nominated ################
if ($action=="nominate") { 


This will allow guests to see the main nomination / voting screen but not be able to view "who voted" or cast a vote or nominate