$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

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?

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

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

partang
here is the full template

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

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

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

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

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>

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

awesome idea!

Have you installed?

Works fine now

just got some template editing to do and its fine

Works here too!

*Clicks Install*

Thanks!

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

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.

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.

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

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.

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

missing a java script code for popup.

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.

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.

just replace memberschoice template /w this.

perfect cheers m8

update v 2.0 is nearly ready

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

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.

Works great m8! Thanks!

Installed - thank you!

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

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

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

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.

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

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

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)

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.

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

find near top of memberschoice.php
move it to under this
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