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.

[pgowder]

Can someone help????

[LangTuDaTinh]

Today at 05:02 AM pgowder said this in Post #90
I'm getting an error when anyone with a ' in thier username is nominated. How can this be fixed??

look for that line

and replace

PHP Code:

'$bbuserinfo[username]' 


with

PHP Code:

'".addslashes(htmlspecialchars($bbuserinfo[username]))."' 


[pgowder]

Replace every instance of that??

[LangTuDaTinh]

yes...it's best to do that....and let me know the result...

[pgowder]

Thanks, I've done that. I'll let you know if I still get errors!

[trafix]

sorry for taking so long to reply as i have been flat out on my next hack release

Im not sure if that last suggestion is correct....however try this

find in memberschoice.php

PHP Code:

$update=date("Y-m-d",time()+86400 * $days);
  $DB_site->query("INSERT INTO memberschoice (id,nominatorid,nomnameid,ndate,nomreason,nomname,nominator) VALUES (NULL,'$bbuserinfo[userid]',$nomnameid,UNIX_TIMESTAMP('$update'),'".addslashes($nomreason)."','".addslashes($nominatemember)."','".addslashes($nominatorid)."')");
  $DB_site->query("UPDATE memberschoiceadmin SET nominees=nominees+1 WHERE event=1"); 


replace with

PHP Code:

$update=date("Y-m-d",time()+86400 * $days);
  $DB_site->query("INSERT INTO memberschoice (id,nominatorid,nomnameid,ndate,nomreason,nomname,nominator) VALUES (NULL,'$bbuserinfo[userid]','".addslashes($nomnameid)."',UNIX_TIMESTAMP('$update'),'".addslashes($nomreason)."','".addslashes($nominatemember)."','".addslashes($nominatorid)."')");
  $DB_site->query("UPDATE memberschoiceadmin SET nominees=nominees+1 WHERE event=1"); 


let my know if it works and i will update the zip....even if the other suggestion works..

[pgowder]

The other changes did solve the problem.

I've made this change also, and will let you know if it causes any problems.

Thanks

[pgowder]

After adding that change, I'm now getting errors.

Invalid SQL: SELECT * FROM memberschoice WHERE nomname='Smokin' Ace' mysql error: You have an error in your SQL syntax near 'Ace'' at line 1

[pgowder]

Another question...

Right now, my users have two monthly contest. Male member of the month and female member of the month. Can I run two at the same time?

[pgowder]

That changed generated a php error for line 145 on memberchoice.php.

I changed it back, and everything is working great.