Members Choice Voting Hack [Archive]

trafix

03-25-2003, 10:00 PM

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 (http://www.atmyparty.com/network/)

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

03-26-2003, 12:12 AM

not nominated

trafix

03-26-2003, 12:13 AM

member nominated

trafix

03-26-2003, 12:14 AM

nomination accepted

trafix

03-26-2003, 12:15 AM

nomination screen

trafix

03-26-2003, 12:16 AM

voting screen

trafix

03-26-2003, 12:17 AM

last...admin

Koutaru

03-26-2003, 12:20 AM

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

trafix

03-26-2003, 12:25 AM

ok thanks..please let me know how you go

DPoole

03-26-2003, 02:24 AM

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

LangTuDaTinh

03-26-2003, 03:27 AM

$DB_site->query("CREATE TABLE memberschoiceadmin (
event smallint(1) unsigned DEFAULT '0' NOT NULL auto_increment,
nominees smallint(4) DEFAULT '0',
nomineesmax smallint(5) DEFAULT '10',
awardname varchar(255) NOT NULL,
nominateone smallint(2) DEFAULT '0',
voteone smallint(2) DEFAULT '0',
PRIMARY KEY (event)
)");

look like status and statusreason is missing from install script

trafix

03-26-2003, 03:41 AM

Yep, your right! ok i will update the zip file asap.

if you know how to enter queries manually

ALTER TABLE memberschoiceadmin ADD status smallint(2) AFTER `event`

and then

ALTER TABLE memberschoiceadmin ADD statusreason varchar(225) AFTER `status`

I will edit first post once i get a Chance to update it, again my apponlgies

DPoole

03-26-2003, 03:57 AM

Perfect - cheers

DPoole

03-26-2003, 04:01 AM

well i not getting no error LOL

even after adding them queries - this happens

When i add title to the Award name in Admin CP and enter no of nominees etc and press submit i get this `Action is succesfully updated!

but when i check it again all boxes are blank so i cant nominate on main board as its not available as it resets to nothing.

trafix

03-26-2003, 04:18 AM

Zip file updated

trafix

03-26-2003, 04:20 AM

so all is ok now??

could you post of pm me a link to your forum please?

snyx

03-26-2003, 04:54 AM

this is a very cool idea, but just not what my members were asking for. they wanted to be able to nominate users based on categories. (ie. best avatar, funniest replies, worst signature, ect..) so im going to wait on this one, see where it goes :)

trafix

03-26-2003, 05:04 AM

you can call the award what ever you want....dosnt have to be member of the month...you can change each month if you want to.

You can nominate the name of the award from your config admin

DPoole

03-26-2003, 05:11 AM

I have tested this on Local machine and also on Active web and i get the same prob

as soon as i enter any details into the admin cp for it : example Member of the month the boxes go blank once i press Submit

So cause of this the hack aint activated but besides this the rest went well

will wait to see if anyone else has same prob

I gone over the hack line by line - been at since 5am so im pretty sure i aint missed anything.

trafix

03-26-2003, 05:25 AM

did you do the table alterations in post no.12?

partang2

03-26-2003, 05:29 AM

Does this work now?

DPoole

03-26-2003, 05:31 AM

did a total new install using your new upload zip as i presumed it was all complete in their now.

I aint getting no database errors or anything - only prob im getting is when i go to add details in CP they dont stay for some reason they just revert back to orginal setting which are blank

partang2

03-26-2003, 05:40 AM

Guess not...

DPoole

03-26-2003, 05:41 AM

<a href="https://vborg.vbsupport.ru/attachment.php?s=&postid=373376" target="_blank">this pic </a>

you see how yours are filled in - in the above pic well when i do it (twice now and 2 seperate installs as well) it says Updated etc and then the boxes go blank as if i aint entered anything.

trafix

03-26-2003, 06:04 AM

zip file updated again...i uploaded the admin file from the original zip and ....yep.....i wouldnt work....i have replaced the file with the operating one from my server,

Sorry for stuffing you around and thanks for your help persistance and understanding

DPoole

03-26-2003, 06:10 AM

trafix i feel really bad about saying thi sand i can see that you have gone out of your way to help on this problem.
I have deleted the admin file and replaced it with yours and still get exactly same prob.

Best thing is to leave it and see if others can install it as id hate to thing it may be me and you running around trying to fix a problem that may not exist.

trafix

03-26-2003, 06:37 AM

ok, after tea i will completly bebuild the zip folder from my server...cos it does work

trafix

03-26-2003, 07:01 AM

zip now rebuilt completley from my server

trafix

03-26-2003, 07:07 AM

ok i downloaded the v1.5 zip and uploaded the admin php to my server....works here

anybody else??

DPoole

03-26-2003, 07:26 AM

its as if something is misisng

like why is the admin cp restting as soon as i press Submit ?

should it store the details that i entered into it.

I just re-done your zip and nothing changes - just goes all blank boxes once again.

Need to suzz out why its not storing the details.

trafix

03-26-2003, 08:55 AM

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

03-26-2003, 09:05 AM

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

trafix

03-26-2003, 09:08 AM

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

03-26-2003, 09:10 AM

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

partang2

03-26-2003, 11:17 AM

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

03-26-2003, 11:21 AM

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

03-26-2003, 11:49 AM

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

03-26-2003, 12:29 PM

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

03-26-2003, 12:35 PM

$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

03-26-2003, 12:40 PM

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

DPoole

03-26-2003, 12:42 PM

$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

03-26-2003, 12:45 PM

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

03-26-2003, 12:49 PM

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

trafix

03-26-2003, 12:58 PM

Today at 12:42 AM DPoole said this in Post #41 (https://vborg.vbsupport.ru/showthread.php?postid=373578#post373578)
$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

03-26-2003, 12:59 PM

partang
here is the full template

partang2

03-26-2003, 01:12 PM

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

trafix

03-26-2003, 01:20 PM

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

03-26-2003, 01:26 PM

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

03-26-2003, 01:28 PM

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

partang2

03-26-2003, 01:35 PM

Today at 03:20 PM trafix said this in Post #47 (https://vborg.vbsupport.ru/showthread.php?postid=373588#post373588)
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>

trafix

03-26-2003, 01:58 PM

Sorry, but i cant find that line in any of the templates

these 2 come from the memberschoice_bit

<table cellpadding="10" cellspacing="0" border="1" width="100%" bgcolor="{ categorybackcolor }"><tr><td>

and

<table cellpadding="10" cellspacing="0" border="0" width="100%"><tr>

If it is a backgroung image that is missing...check that the image is in the right folder and the spelling is correct

alkatraz

03-26-2003, 02:08 PM

awesome idea!

trafix

03-26-2003, 02:12 PM

Today at 02:08 AM alkatraz said this in Post #52 (https://vborg.vbsupport.ru/showthread.php?postid=373605#post373605)
awesome idea!

Have you installed?

DPoole

03-26-2003, 02:45 PM

Works fine now

just got some template editing to do and its fine

partang2

03-26-2003, 02:50 PM

Works here too!

*Clicks Install*

Thanks!

DPoole

03-26-2003, 02:51 PM

one small query

u know on this screen where it shows

Who Voted Nominee No. 1 Vote Now

well when i press who voted nothing happens ? is this correct

also yellow writing on grey background is hard to read on that page.

Example this text is yellow to me

`test's Nomination
Acceptance Speech
`

but besides minor template probs the hacks works perfect

iggy123

03-26-2003, 04:17 PM

Nice idea am installing now -- even though i am thick and can't read the dam instructions

DPoole

03-26-2003, 04:31 PM

Today at 06:17 PM iggy123 said this in Post #57 (https://vborg.vbsupport.ru/showthread.php?postid=373657#post373657)
Nice idea am installing now -- even though i am thick and can't read the dam instructions

Besides few teething probs earlier on this hack is well easy to install and takes about 15mins all in all.The probs earlier on where only minor but they are sorted now so is worth downloading it now.

DPoole

03-26-2003, 04:52 PM

also a quick suggestion if possible

how about a link on main page that shows who has the most votes so u can see at a glance who winning in the member of the month award

MODS can u delete most of my posts in this section besides the one 2 posts up as they not needed no more as the hack is sorted for installing now.

USODJA

03-26-2003, 09:52 PM

Is it possible for a secret vote, where members don't (only admin) know who voted for who. Can a on off button be added for that..

trafix

03-26-2003, 10:01 PM

Thank you for your suggestions and comments, I am glad that we seemed to have got over our early hurdles.
Give me a little time and I will add your suggestions.

DPoole

03-26-2003, 11:15 PM

<a href="https://vborg.vbsupport.ru/showthread.php?postid=373628#post373628" target="_blank">just this small prob</a>

Java window dont pop up just gives me a java error

as for the yellow text i fixed that prob now.

LangTuDaTinh

03-26-2003, 11:50 PM

Today at 05:15 PM DPoole said this in Post #62 (https://vborg.vbsupport.ru/showthread.php?postid=373845#post373845)
just this small prob (https://vborg.vbsupport.ru/showthread.php?postid=373628#post373628)

Java window dont pop up just gives me a java error

as for the yellow text i fixed that prob now.

missing a java script code for popup.

LangTuDaTinh

03-27-2003, 12:03 AM

another suggestion, add page navigation . forexample, i have total 20 Nominees i want to display 10 of them one 1 page and other 10 on second page in random order.

trafix

03-27-2003, 12:57 AM

Today at 04:52 AM DPoole said this in Post #59 (https://vborg.vbsupport.ru/showthread.php?postid=373665#post373665)
also a quick suggestion if possible

how about a link on main page that shows who has the most votes so u can see at a glance who winning in the member of the month award

MODS can u delete most of my posts in this section besides the one 2 posts up as they not needed no more as the hack is sorted for installing now.

Ok good to see that you got the colors sorted out.

with regard to the java bit...LangTuDaTinh can you attach a .txt file containing the correct memberschoice_bit so I can add it to the new upgrade zip, just so I dont stuff it up...lol

i am working in the additions that have been requested and hopt to get finished soon.

LangTuDaTinh

03-27-2003, 01:43 AM

just replace memberschoice template /w this.

DPoole

03-27-2003, 02:12 AM

perfect cheers m8

trafix

03-27-2003, 07:10 AM

update v 2.0 is nearly ready

will include
1) leaderboard
2) limiting usergroups that can see "who Voted"

trafix

03-27-2003, 10:47 AM

update v 2.0 is now available

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.

partang2

03-27-2003, 12:42 PM

Works great m8! Thanks!

bandersen

03-27-2003, 12:47 PM

Installed - thank you!

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

bandersen

03-27-2003, 01:00 PM

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

trafix

03-27-2003, 01:19 PM

Today at 01:00 AM bandersen said this in Post #72 (https://vborg.vbsupport.ru/showthread.php?postid=374015#post374015)
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

03-27-2003, 01:53 PM

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

03-27-2003, 02:01 PM

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

03-27-2003, 02:11 PM

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

LangTuDaTinh

03-27-2003, 03:53 PM

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

03-27-2003, 06:18 PM

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/memberschoice.php?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

03-28-2003, 02:09 AM

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 (https://vborg.vbsupport.ru/showthread.php?postid=374154#post374154)
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/memberschoice.php?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

03-28-2003, 02:32 AM

Today at 03:53 AM LangTuDaTinh said this in Post #77 (https://vborg.vbsupport.ru/showthread.php?postid=374106#post374106)
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
if ($bbuserinfo[userid]==0) {
eval("standarderror(\"".gettemplate("error_nopermission_loggedout")."\");");
}

move it to under this
// ##################### 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

LangTuDaTinh

03-28-2003, 02:48 AM

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***********

this is template in 1.x update folder - not from clean install template

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 from those line where u just added which limited to which usergroup can view - line 84 to 93. i don't think action==whovoted need it. but if a username have a ' (for example like "Jade's A") a database error will appear if that user click on the link.

thanks trafix...

trafix

03-28-2003, 02:57 AM

I have been spying on you....lol

I like your board, and the hack looks great, It seems your members are loving it big time :)

Would you like to post the alterations as an addon?

limited voting and x posts to vote

It saves me working it out...if you dont want to post it...pm it to me..

Im glay you like the hack!

Today at 02:48 PM LangTuDaTinh said this in Post #81 (https://vborg.vbsupport.ru/showthread.php?postid=374364#post374364)
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***********

this is template in 1.x update folder - not from clean install template

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 from those line where u just added which limited to which usergroup can view - line 84 to 93. i don't think action==whovoted need it. but if a username have a ' (for example like "Jade's A") a database error will appear if that user click on the link.

thanks trafix...

LangTuDaTinh

03-28-2003, 01:55 PM

Yesterday at 08:57 PM trafix said this in Post #82 (https://vborg.vbsupport.ru/showthread.php?postid=374368#post374368)
I have been spying on you....lol

I like your board, and the hack looks great, It seems your members are loving it big time :)

Would you like to post the alterations as an addon?

limited voting and x posts to vote

It saves me working it out...if you dont want to post it...pm it to me..

Im glay you like the hack!

thanks for your comments trafix, i'll post some when i'm done (about two more days). hehhee i need to sort out which one cause i have "change username via usercp" hack and multi-avatars hack (make by me) so i modified most of the codes.

this hack is great ....my members love it so much that they request many modifications for this hack.
maybe i need to change the layout.

also they just request me this: allow members to vote only when all Nominees are selected.

USODJA

03-29-2003, 02:19 AM

I like that last one too...

Lesane

03-31-2003, 12:34 PM

hehe, this is a very well known line in memberschoice.php:

// ###################### Start Top10 Richest Persons #######################

CopyNPaste? ;):D

A good hack nonetheless!

trafix

03-31-2003, 12:47 PM

OOOOPS,

Sorry Lesane....

Yes I know...slap my wrist....

If you were not such a great inspirator and teacher....people would still be requesting this hack....Thank you

Im glad you like it :)

Im probibly not the only person to learn for your great work!

Lesane

03-31-2003, 01:09 PM

hehe np, i am glad that people learn from my work and create hacks for vbulletin. ;)

kevinnguyen

04-02-2003, 10:17 PM

hey i got this prob
even though i set all members can view Who Voted, the link still doesnt appear for registered members
anyone help plz

kevinnguyen

04-03-2003, 09:59 PM

nvm, i fixed it
nice hack btw

pgowder

04-08-2003, 11:02 AM

I'm getting an error when anyone with a ' in thier username is nominated. How can this be fixed??

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

pgowder

04-08-2003, 10:22 PM

Can someone help????

LangTuDaTinh

04-08-2003, 11:30 PM

Today at 05:02 AM pgowder said this in Post #90 (https://vborg.vbsupport.ru/showthread.php?postid=379213#post379213)
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

'$bbuserinfo[username]'

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

pgowder

04-08-2003, 11:34 PM

Replace every instance of that??

LangTuDaTinh

04-08-2003, 11:58 PM

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

pgowder

04-09-2003, 12:12 AM

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

trafix

04-09-2003, 01:27 AM

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
$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
$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

04-09-2003, 12:22 PM

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

04-09-2003, 02:57 PM

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

04-09-2003, 03:18 PM

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

04-10-2003, 12:38 AM

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

I changed it back, and everything is working great.

LangTuDaTinh

04-10-2003, 12:56 AM

it's possible...i was thinking the same thing but didn't have time to do it yet....i want to add more contests but don't want to lose the old one.../w version 1 trafix...didn't do that yet... maybe v2.

trafix

04-10-2003, 02:34 AM

hmmmmmm......

pgowder
Im glad that everything is working ok for you know.

RE second contest.........let me think about that one

Jakor Sevel

04-30-2003, 07:40 PM

Trafix, it looks like a great hack. The only reason I won't install it is because, like someone else said, I like to have a lot of contests. Like....20 categories. It's almost like the Oscars :p Anywayz. My suggestion is that if/when you make the next version, make it so that you can run many contests at the same time. I'm sure it's possible but it might take a long time. That way people could have as many contests as they want at the same time.

trafix

05-01-2003, 11:38 AM

Ok I will look at adding this in the next version .....

cinq

05-11-2003, 06:32 AM

I know u are working on VBTraider right now , but any chance you will get back to working on this hack for version 2 ? :)

DPoole

05-17-2003, 01:55 AM

anychance once a member enters his nomination speech it auto gets added to his sig so it shows in that user posts as well as a link to the MOTM hack as a lot of people dont even know its there so this way it would add more traffic to it.

trafix

05-17-2003, 02:08 AM

Good idea!

I will look to include it with V2 :)

I must appologise for not getting on with this hack but i am spending every possible moment trying to get VB Trader released. I have spent over 2 weeks on it already and i havent even started on the auction section yet....

LangTuDaTinh

05-17-2003, 08:03 PM

check out my Members Choice Awards with Multi Events Added..

http://www.tvseriesfans.com/forums/awards.php?event=2

DPoole

05-17-2003, 08:30 PM

Today at 10:03 PM LangTuDaTinh said this in Post #108 (https://vborg.vbsupport.ru/showthread.php?postid=396298#post396298)
check out my Members Choice Awards with Multi Events Added..

http://www.tvseriesfans.com/forums/awards.php?event=2

would do m8 but at moment u have it turned off so i just see the screen and nothing else

how do u mean Multi events anyway ??

LangTuDaTinh

05-17-2003, 08:40 PM

currently event two is off
check out event 1

http://www.tvseriesfans.com/forums/awards.php?event=1

kevinnguyen

05-18-2003, 02:06 AM

very good job LTDT *thumbs up*

DPoole

05-18-2003, 07:09 AM

looks nice well done m8

kevinnguyen

05-20-2003, 05:19 PM

when will V2 come out?

Vile

05-29-2003, 08:31 PM

Awesome hack, and works great, except for one part..

The message that is supposed to be displayed on forumhome when someone is nominated, does not show up for me.

I read through all the posts, but noone else had this problem.

As the directions stated, in root\index.php

I placed:

// members choice voting announce bit

$userstatus = $DB_site->query_first("SELECT * FROM memberschoice WHERE nomname='$bbuserinfo[username]'");
if (empty($userstatus[nomname])) {
$nomination="No Nomination";
} else if ($userstatus[acceptnom]=='No') {
$nomination="<b><font color=\"#ffoooo\">You have been nominated</font></b>";
} else {
$nomination="Nomination accepted";
}

// members choice announce bit

After

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=number_format($countposts['posts']);

But it still doesnt show up :\

Any ideas?

Thanks :)

DPoole

06-03-2003, 01:17 PM

traffic can u make a small addon please

where anyone who is nominated gets a small gif or anything in their postbit (something which stands out) and once that gif is clicked it takes u straight to the Main page of the voting hack.

Not many people are using it as they dont know its there unless they been nominated so id like to make more traffic for it.

If nominated - get an ICON under avator - if not nominated nothing shows

trafix

06-03-2003, 01:43 PM

It has been brought to my ayyension that I missed a template to edit in the instructions, thanks Vile :)

This tells the ,e,ber on the forum home page if they have been nominated

**********************************
OPEN Postbit Templates > forum home
**********************************

------------------
Add to your welcome panel or approiate place near top of forum
------------------

$nomination

**********************************
SAVE Postbit Templates > forum home
**********************************

Vile

06-03-2003, 03:55 PM

Today at 03:43 PM trafix said this in Post #116 (https://vborg.vbsupport.ru/showthread.php?postid=403873#post403873)
It has been brought to my ayyension that I missed a template to edit in the instructions, thanks Vile :)

No, thank you for the fix :D

Hack is working excellent, and the members are loving it :)

DPoole

06-04-2003, 07:40 PM

Yesterday at 03:17 PM DPoole said this in Post #115 (https://vborg.vbsupport.ru/showthread.php?postid=403865#post403865)
traffic can u make a small addon please

where anyone who is nominated gets a small gif or anything in their postbit (something which stands out) and once that gif is clicked it takes u straight to the Main page of the voting hack.

Not many people are using it as they dont know its there unless they been nominated so id like to make more traffic for it.

If nominated - get an ICON under avator - if not nominated nothing shows

No Possibilty of update to this traffic ??

vbulletin-arab

06-17-2003, 10:53 AM

helloo trafix

i have 2 prob...

the 1 set :
As the directions stated, in root\index.php

I placed:

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=number_format($countposts['posts']);

add after :

// members choice voting announce bit

$userstatus = $DB_site->query_first("SELECT * FROM memberschoice WHERE nomname='$bbuserinfo[username]'");
if (empty($userstatus[nomname])) {
$nomination="<a href=\"memberschoice.php?s=[sessionhash]">No Nomination</a>";
} else if ($userstatus[acceptnom]=='No') {
$nomination="<b><a href=\"memberschoice.php?s=[sessionhash]"><font color=\"#ffoooo\">You have been nominated</font></a></b>";
} else {
$nomination="<a href=\"memberschoice.php?s=[sessionhash]">Nomination accepted</A>";
}

// members choice announce bit

i will add but give me an error on line 142

and i am removed this code

the 2 set prob...

i am go to - Nominations & Voting > Nominate Member

and click on the Nominate Now dont do anything's

????

plz help me :(

vbulletin-arab

06-19-2003, 01:28 AM

any body help me ?!

ChurchMedia

07-24-2003, 04:59 AM

There were some missing \ in the code. I had the same problem. Try this code:

// members choice voting announce bit

$userstatus = $DB_site->query_first("SELECT * FROM memberschoice WHERE nomname='$bbuserinfo[username]'");
if (empty($userstatus[nomname])) {
$nomination="<smallfont><a href=\"memberschoice.php?s=[sessionhash]\">You have not been nominated for any awards at this time.</a></smallfont>";
} else if ($userstatus[acceptnom]=='No') {
$nomination="<smallfont><b><a href=\"memberschoice.php?s=[sessionhash]\">You have been nominated for an award!</a></b></smallfont>";
} else {
$nomination="<smallfont><a href=\"memberschoice.php?s=[sessionhash]\">Your nomination has been accepted!</A></smallfont>";
}

// members choice announce bit

ChurchMedia

07-25-2003, 12:06 AM

If anyone's interested, I've modified this way-cool hack to nominate/vote on pictures, etc. in PhotoPost. It shows thumbnails and let's you vote from within the gallery instead of the board. We just started it today, but I'm sure my members will love it. You can preview it here. (http://www.churchmedia.net/community/forum/memberschoice.php?s=)

Thanks for the great hack!

y2krazy

08-20-2003, 04:14 AM

Well, I am testing this hack on the Forums I Admin, but when i try to access the main index.php, all I get is a white screen. I've edited all the files to the 't', even went to my backups and edited those to see if it would work, but still nothing. But, when I remove the code that is to be placed in the index.php file, the main page works fine, except for the display of the Nominations and such because of the missing code. Is there any way to help resolve this problem? Thanks in advance!

-y2k-

y2krazy

08-24-2003, 04:33 PM

Well, I guess I'll just leave the code out on the Forum Home template. No big deal, just one of the features that won't be used. Other than that, a great hack, and I am going to run it by the head Admin to see if we can install it. Thanks!

-y2k-

lasto

08-24-2003, 06:06 PM

07-25-03 at 02:06 AM ChurchMedia said this in Post #122 (https://vborg.vbsupport.ru/showthread.php?postid=420397#post420397)
If anyone's interested, I've modified this way-cool hack to nominate/vote on pictures, etc. in PhotoPost. It shows thumbnails and let's you vote from within the gallery instead of the board. We just started it today, but I'm sure my members will love it. You can preview it here. (http://www.churchmedia.net/community/forum/memberschoice.php?s=)

Thanks for the great hack!

that is excellant that m8 anychance of a release