WP Polls

Hmm, looks nice, I’ve been using other polling systems for awhile now and its quite a pain to have to login to 10 different places… just one problem, after I voted I hit reload to see if the site would remember me when I returned. The votes went up, and it went up EVERY time I hit reload (12 total I think). Is there anyway to fix this?

just downloaded it and when I wnet to install I get this message:
SQL/DB Error:
[You have an error in your SQL syntax near ') ' at line 1]
CREATE TABLE b2pollsa ( aid int(10) unsigned NOT NULL auto_increment, qid int(10) NOT NULL default '0', answers varchar(200) NOT NULL default '', votes int(10) NOT NULL default '0', PRIMARY KEY (aid),)
SQL/DB Error:
[You have an error in your SQL syntax near ') ' at line 1]
CREATE TABLE b2pollsq ( id int(10) unsigned NOT NULL auto_increment, question varchar(200) NOT NULL default '', timestamp varchar(20) NOT NULL default '', total_votes tinyint(4) NOT NULL default '0', PRIMARY KEY (id),)
any idea?

erm, the reloading problem is a common problem. Any form you click reload it would submit as many times as it is being reloaded.
Anonymous
: can mail me the script?

done wasn’t sure what file you needed so I sent myhacks, polls manager and polls install, do you need anything else?

okie solved

would it be easy to make it check IP’s or something before it readd’s the vote?

People can also cheat by removeing the cookie for the poll (Which is very easy to do with Opera). If it saved a list of ip’s that could be fixed too.

from what I know, CS Nation CMS also uses cookie based.
If you are using a IP based checking, there will be overhead. And to 56k users, it will make no difference.
Cheers.

Could always use both. ??
IP based checking is minimal overhead. A 15 character IP (or 32-bit integer…), plus however big a number for which poll ID, plus however bug a number (likely a smallint) for poll response. Let’s say 32 bytes per entry, and you get 1000 entries. Still only 32K in a database. If your site gets more than a few thousand entries for a given poll, you might want to look at other options.
Also note that you can do some level of ‘rough cross-poll results’ by doing a JOIN between two (or more) poll-ID queries, based on q1.IP == q2.IP. Could give you some interesting results for niche websites.
-d
https://www.chait.net

hey where is the latest version located?

Max_Barrel posted this:
“About the answer order: My choice was to supress the “ORDER BY vote DESC” query option in answer query.”
Could anybody direct me to where exactly I would do this?

lilandra: $poll_answers = $wpdb->get_results(“SELECT aid, answers, votes FROM $tablepollsa WHERE qid = $poll_question->id ORDER BY votes DESC”);
sush: latest as in?

I’m afraid I’m having the same problem as Anonymous. GamerZ, how were you able to fix it? TIA

Hey, thanks for the great hack…
My trouble is that it doesn’t seem to validate:
https://validator.w3.org/check?uri=http%3A%2F%2Fmtwib.enlumina.org%2Fjournal%2Findex.php%3Fp%3D11#line-98
Any ideas?

1) Put your wp-grins JS in external.js
2) You have to edit poll some for it to validate… It took me about 10 mins to accomplish it, you can see example @ https://www.MaxT.dk