Snitz Forums 2000 - Poll Mod v2.0.5

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Completed Add-Ons

Poll Mod v2.0.5

Forum Locked

Topic Locked

Printer Friendly

Author

Topic

Page: of 8

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 09 April 2003 : 16:21:28

I have every single version of the poll mod that I have released. What version are you talking about? And why do you want an older version?<

Support Snitz Forums

mrose
Starting Member

Canada
43 Posts

Posted - 09 April 2003 : 17:17:43

I will explain... I had to move our sql server and re-install sql. I exported the database to an access file, re-installed the forum and tried to import the database from access file. Unfortunately it looks like if the rows don't exist, e.g. poll rows in eh tables, it wont restore and "ignores" them. So I need to re-prepare the database with the poll and restore again. I figured that I should do this all from the org ver of the pol that I had already installed.

Mik
<

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 09 April 2003 : 19:15:16

What version do you want?
I have:
Poll Mod for Snitz Forums 3.1 SR4
Poll Mod for Snitz Forums 3.3.03
Poll Mod v2.0 for Snitz Forums 3.4

And send me an email so i can get your email address to send you the file.<

Support Snitz Forums

Edited by - Davio on 09 April 2003 19:16:11

VodkaFish
Average Member

USA
654 Posts

Posted - 18 April 2003 : 23:47:40

Davio, I'd like to make a suggestion. I was thinking for the active_polls.asp page we might not want to have locked polls included since they're not really "active".

I made this change to my active_polls.asp page:

around line 101:


'## Forum_SQL - Get all active polls
strSql = "SELECT C.CAT_ID, C.CAT_NAME, C.CAT_STATUS, F.FORUM_ID, F.F_SUBJECT, F.F_STATUS, T.TOPIC_ID, " &_ 
	"T.T_SUBJECT, T.T_STATUS, T.T_AUTHOR, T.T_REPLIES, M.M_NAME, P.P_LASTVOTE, P.P_WHOVOTES "
For nCount = 1 To 15
	strSql = strSql & ", P.ANSWER" & CStr(nCount)
	strSql = strSql & ", P.COUNT" & CStr(nCount)
Next
strSql = strSql & " FROM " & strTablePrefix & "CATEGORY C, " & strTablePrefix & "FORUM F, " &_
	strTablePrefix & "TOPICS T, " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "POLLS P " &_
	"WHERE C.CAT_ID = T.CAT_ID AND F.FORUM_ID = T.FORUM_ID AND P.TOPIC_ID = T.TOPIC_ID " &_
	"AND M.MEMBER_ID = T.T_AUTHOR AND T.T_ISPOLL = 1"
if nDays > 0 then
	strSql = strSql & " AND (P.P_LASTVOTE > '" & defDate & "' OR T.T_DATE > '" & defDate & "')"
end if
strSql = strSql & " ORDER BY C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, P.P_LASTVOTE DESC"

replace with:


'## Forum_SQL - Get all active polls
strSql = "SELECT C.CAT_ID, C.CAT_NAME, C.CAT_STATUS, F.FORUM_ID, F.F_SUBJECT, F.F_STATUS, T.TOPIC_ID, " &_ 
	"T.T_SUBJECT, T.T_STATUS, T.T_AUTHOR, T.T_REPLIES, M.M_NAME, P.P_LASTVOTE, P.P_WHOVOTES "
For nCount = 1 To 15
	strSql = strSql & ", P.ANSWER" & CStr(nCount)
	strSql = strSql & ", P.COUNT" & CStr(nCount)
Next
strSql = strSql & " FROM " & strTablePrefix & "CATEGORY C, " & strTablePrefix & "FORUM F, " &_
	strTablePrefix & "TOPICS T, " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "POLLS P " &_
	"WHERE C.CAT_ID = T.CAT_ID AND F.FORUM_ID = T.FORUM_ID AND P.TOPIC_ID = T.TOPIC_ID " &_
	"AND M.MEMBER_ID = T.T_AUTHOR AND T.T_ISPOLL = 1 AND T.T_POLLSTATUS = 1"
if nDays > 0 then
	strSql = strSql & " AND (P.P_LASTVOTE > '" & defDate & "' OR T.T_DATE > '" & defDate & "')"
end if
strSql = strSql & " ORDER BY C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, P.P_LASTVOTE DESC"

Just my opinion/suggestion. This should be done on the admin_polls.asp page as well (unless you want a locked poll to be your featured poll).

If you (or everyone else) disagree with me, you could always add a little note to the active polls page (like how it says "members only"). Let me know if you want me to whip up the code for that.<

v ø d k â f ï § h

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 19 April 2003 : 13:42:12

Doesn't sound like a bad idea to me. I'll include it in the current version.<

Support Snitz Forums

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 22 May 2003 : 21:51:53

Just bumping this so it won't get archived.

Support Snitz Forums

D3mon
Senior Member

United Kingdom
1685 Posts

Posted - 03 June 2003 : 06:44:38

Here's a Poll Mod icon for users of my XP icon set:

Copy it over the original file and don't forget to edit your inc_iconfiles.asp and change this line:

Const strIconPoll = "icon_poll.gif|15|15"

to:

Const strIconPoll = "icon_poll.gif|24|24"

Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won"

Edited by - D3mon on 03 June 2003 06:48:27

C-DUB
Starting Member

USA
3 Posts

Posted - 25 June 2003 : 20:02:20

Hey Davio! I got the mod to work, and it's great!

I have a couple of questions. Could the vote also log the option, and the poll results show the usernames? I know this was brought up earlier last year, but are there plans to include or attach user names to their votes?

I ask because I'm trying to convert our club from the clunky, ad-ridden Yahoo site to our new forum. The polls over there were used extensively for guaging interest for events, and they were also used as sign up sheets. The polls simply showed the usernames next to the vote totals on the right, showing which members voted for which options.

It sounds simple enough, but after checking the db I noticed that the even though the members id gets saved to the db, their poll option doesn't. If I tried to create a table to log the option the user made, I could pass the option to that table when they vote, and then pull the usernames into the results page? Would that be a correct way to go?

It sounds crazy, but this is the big kicker for converting from the Yahoo groups since it's used so much...

Thanks for your time!

C-DUB<

wizard
Junior Member

208 Posts

Posted - 27 June 2003 : 22:18:25

Does anyone know if the poll mod will work toegther with events calendar and smile manager?<

whizkid
Starting Member

5 Posts

Posted - 30 June 2003 : 04:26:27

quote:
Originally posted by wizard

Does anyone know if the poll mod will work toegther with events calendar and smile manager?

Not really. I have had problems to get it to work with the New Event Calendar mod. Now I want to try to install the poll module first (on a plain Snitz 3.4.03) and then install the calendar...

Basically poll was working (no error), but there was no link to add a new poll...

-whiz<

Page: of 8

Topic

Forum Locked

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.08 seconds.