Raised This Month: $51 Target: $400
 12% 

MySQL Polls


Post New Thread Reply   
 
Thread Tools Display Modes
DontWannaName
Veteran Member
Join Date: Jun 2007
Location: VALVe Land, WA
Old 07-23-2010 , 02:18   Re: MySQL Polls
Reply With Quote #21

Thanks, I already installed it. It works great. The ability to offer the same vote on all servers would be a plus but atm I dont need that and I could just make 4 separate votes. But to the author, the timer would be nice instead of instantly on connect.
__________________

DontWannaName is offline
crazydog
AlliedModders Donor
Join Date: Jan 2006
Old 07-23-2010 , 04:52   Re: MySQL Polls
Reply With Quote #22

I actually changed the plugin to do the following. Maybe it's of some use to you:
-It asks the newest questions first
-Adds an "Ask me Later" option as the first choice in the poll
-Does not toss up a vote until the player's first death on the server (For our server, I check if mp_friendlyfire is 0 since we use pre round mayhem).
-Asks 2 questions per client per connection
Attached Files
File Type: sp Get Plugin or Get Source (mysql_polls.sp - 344 views - 8.1 KB)
crazydog is offline
Cep}|{
Member
Join Date: Nov 2009
Old 07-25-2010 , 12:07   Re: MySQL Polls
Reply With Quote #23

Quote:
Originally Posted by crazydog View Post
Maybe you should just link to my post ...
done)
__________________
Cep}|{ is offline
Stinkyfax
BANNED
Join Date: Aug 2007
Old 07-27-2010 , 14:47   Re: MySQL Polls
Reply With Quote #24

Very useful plugin, is a must to have on a server which takes care of players opinion. Thanks for saving my time from writing it
Stinkyfax is offline
DontWannaName
Veteran Member
Join Date: Jun 2007
Location: VALVe Land, WA
Old 08-08-2010 , 14:59   Re: MySQL Polls
Reply With Quote #25

The result php doesnt seem to be working

http://topnotchclan.com/polls/results.php

Also, I used the wrong server id on my server and made the question for the correct server and I think they question was asked on the server but since the ID was wrong, the system never associated it with a question on the site. I changed the ID and votes are working but the votes when it wasnt arent being included.
__________________


Last edited by DontWannaName; 08-08-2010 at 15:13.
DontWannaName is offline
crazydog
AlliedModders Donor
Join Date: Jan 2006
Old 08-08-2010 , 15:20   Re: MySQL Polls
Reply With Quote #26

Quote:
Originally Posted by DontWannaName View Post
The result php doesnt seem to be working

http://topnotchclan.com/polls/results.php

Also, I used the wrong server id on my server and made the question for the correct server and I think they question was asked on the server but since the ID was wrong, the system never associated it with a question on the site. I changed the ID and votes are working but the votes when it wasnt arent being included.
Would you be able to turn on php errors, or at least share related parts of your php error log?
crazydog is offline
DontWannaName
Veteran Member
Join Date: Jun 2007
Location: VALVe Land, WA
Old 08-09-2010 , 03:51   Re: MySQL Polls
Reply With Quote #27

Ok, on line 65 you have an extra } and ;. Now I dont know how to fix the new error:

http://topnotchclan.com/polls/results.php
__________________

DontWannaName is offline
DarthNinja
SourceMod Plugin Approver
Join Date: Mar 2009
Location: PreThinkHook()
Old 08-09-2010 , 08:41   Re: MySQL Polls
Reply With Quote #28

Quote:
Originally Posted by DontWannaName View Post
Ok, on line 65 you have an extra } and ;. Now I dont know how to fix the new error:

http://topnotchclan.com/polls/results.php
Code:
Warning:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dontwannaname/topnotchclan/public/polls/results.php on line 11
Post line 11?

These may be relevant (or not):
http://www.daniweb.com/forums/thread6923.html
http://forums.mysql.com/read.php?52,...1835#msg-31835
__________________
DarthNinja is offline
crazydog
AlliedModders Donor
Join Date: Jan 2006
Old 08-09-2010 , 11:19   Re: MySQL Polls
Reply With Quote #29

Oh dang, I figured it out.
I'm looking for mysql_num_rows of $inactivepolls, but I've never even referenced that variable before. wtf?

I guess I just had that in there from an older version.

Fixed, see http://forums.alliedmods.net/showpos...7&postcount=13

Last edited by crazydog; 08-09-2010 at 11:32.
crazydog is offline
DontWannaName
Veteran Member
Join Date: Jun 2007
Location: VALVe Land, WA
Old 08-09-2010 , 11:25   Re: MySQL Polls
Reply With Quote #30

OK, I just realized there is no delete button so I can delete polls instead if just making them inactive since inactive show up on that page.
__________________

DontWannaName is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:48.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode