Snitz Forums 2000 - Snitz Polls (voting) addon

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 MOD-Group

MOD Add-On Forum (W/Code)

Snitz Polls (voting) addon

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 4

phynias
New Member

USA
64 Posts

Posted - 22 September 2000 : 11:47:06

Well here is the instructions and files needed for polls in Snitz.

Demo:
http://www.greeneggsnspam.com/forum/topic.asp?TOPIC_ID=110&FORUM_ID=6&CAT_ID=2&Topic_Title=Testing+voting+in+forums%2E%2E%2E&Forum_Title=User+Made+Add%2DOns%2FHacks%2FModifications
Files/Instructions:
http://www.greeneggsnspam.com/forum/topic.asp?TOPIC_ID=113&FORUM_ID=6&CAT_ID=2&Topic_Title=Snitz+Poll+V1%2E0&Forum_Title=User+Made+Add%2DOns%2FHacks%2FModifications

-By the way slemieux if you want to still get together and make this better let me know.

Edited by - phynias on 22 September 2000 11:49:48

Darker
Starting Member

USA
7 Posts

Posted - 23 September 2000 : 10:16:33

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Well here is the instructions and files needed for polls in Snitz.

Demo:
http://www.greeneggsnspam.com/forum/topic.asp?TOPIC_ID=110&FORUM_ID=6&CAT_ID=2&Topic_Title=Testing+voting+in+forums%2E%2E%2E&Forum_Title=User+Made+Add%2DOns%2FHacks%2FModifications
Files/Instructions:
http://www.greeneggsnspam.com/forum/topic.asp?TOPIC_ID=113&FORUM_ID=6&CAT_ID=2&Topic_Title=Snitz+Poll+V1%2E0&Forum_Title=User+Made+Add%2DOns%2FHacks%2FModifications

-By the way slemieux if you want to still get together and make this better let me know.

Edited by - phynias on 22 September 2000 11:49:48
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Nice add-on, just a lil thing I noticed tho: Make sure that every time you open any objects with
<pre id=code>
set (whatever) = ...
</pre id=code>

You also set that object = nothing when you're done with it, or your code becomes a memory hog after many many hours. :)

I found a few Connection & Recordset objects this was left out on.

Hopin to be Helpful
Darker

Edited by - Darker on 23 September 2000 10:18:40

KoopaOne
Starting Member

Austria
11 Posts

Posted - 24 September 2000 : 05:07:03

You didn't include the modifications made in the database, do i have to guess <img src=icon_smile_question.gif border=0 align=middle><img src=icon_smile_wink.gif border=0 align=middle>

phynias
New Member

USA
64 Posts

Posted - 24 September 2000 : 12:53:10

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
You didn't include the modifications made in the database, do i have to guess <img src=icon_smile_question.gif border=0 align=middle><img src=icon_smile_wink.gif border=0 align=middle>

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Yeah you can't guess the changes. Man dont you read minds..Hehe.

Create a Table in the snitz db called
POLL_IPLIST
fields= TOPIC_ID (number), IP (text)
create a table called FORUM_POLL_RESULTS:
fields= POLL_IS (number), IP (text), Vote (number)
create a table FORUM_POLL:
fields= TOPIC_ID (autonumber, key), totans (text), question (memo), answer1 (text), tot1 (number), answer2 (text), tot2 (number), answer3 (text), tot3 (number), answer4 (text), tot4 (number),answer5 (text), tot5 (number), AUTHOR (number)
in FORUM_TOPIC:
add field= ispoll (yes/no)

see wasnt that simple..

phynias
New Member

USA
64 Posts

Posted - 24 September 2000 : 12:55:27

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
I found a few Connection & Recordset objects this was left out on.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Where and what so I can fix it....

James
Average Member

USA
539 Posts

Posted - 24 September 2000 : 14:26:11

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Create a Table in the snitz db called
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Is MS Access required to be able to open and modify the database?

Edited by - James on 24 September 2000 14:29:24

phynias
New Member

USA
64 Posts

Posted - 24 September 2000 : 16:09:59

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Create a Table in the snitz db called
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Is MS Access required to be able to open and modify the database?

Edited by - James on 24 September 2000 14:29:24
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

huh?

James
Average Member

USA
539 Posts

Posted - 24 September 2000 : 22:36:23

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
huh?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

What I'm asking is what should I use to edit the database? I'm assuming that we are referring to the snitz_forums_2000.mdb (or whatever it's renamed too) file. If so, you can not edit this file with a text editor without corrupting something, right?

Interested in Radio Control - http://www.rcwebboard.com/

phynias
New Member

USA
64 Posts

Posted - 25 September 2000 : 00:09:21

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
huh?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

What I'm asking is what should I use to edit the database? I'm assuming that we are referring to the snitz_forums_2000.mdb (or whatever it's renamed too) file. If so, you can not edit this file with a text editor without corrupting something, right?

Interested in Radio Control - http://www.rcwebboard.com/
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>
It's an access db. Just open it up with access, make your changes and save...

James
Average Member

USA
539 Posts

Posted - 26 September 2000 : 21:49:51

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
It's an access db. Just open it up with access, make your changes and save...
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

That's what I figured. Is there anyway to edit this file with Star Office? Or some other way than Access (don't have it)?

-
*Interested in Radio Control - http://www.rcwebboard.com/*

phynias
New Member

USA
64 Posts

Posted - 26 September 2000 : 22:11:16

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
That's what I figured. Is there anyway to edit this file with Star Office? Or some other way than Access (don't have it)?

-
*Interested in Radio Control - http://www.rcwebboard.com/*
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Ive seen some web based db mangers. check http://www.aspin.com look around there, pretty sure there are a couple there.

pier
Starting Member

Italy
22 Posts

Posted - 27 September 2000 : 13:30:15

I've some problems on the istructions file...

<pre id=code>
'around line 391 find
if strIPLogging <> "0" then
strSql = strSql & ", '" & Request.ServerVariables("REMOTE_ADDR") & "'"
end if

'after this add
if request("ispoll")="on" then
strSql=strSql& ", Yes"
end if

'a couple line after the one you just found (391) add this after my_Conn.Execute (strSql)
'SideShow BEGIN you may have to change the location of your forum below
strtemp="select top 1 TOPIC_ID from FORUM_TOPICS order by TOPIC_ID DESC"
set rstemp=my_Conn.execute(strtemp)
tdata=rstemp.getrows
rstemp.close
set rstemp=nothing
topic_id=tdata(0,0)
dstring="<a target=_blank href=""/forum/member_profile.asp?mode=display&id="&rs("MEMBER_ID") &""">"&Request.Form("UserName") &"</a>: <a href=""/forum/topic.asp?TOPIC_ID="&tdata(0,0)&"&FORUM_ID="&Request.Form("Forum_ID")&"&CAT_ID="& Request.Form("CAT_ID")&"&Topic_Title="&trim((Server.HTMLEncode(txtSubject))) &"&FORUM_TITLE="&server.urlencode(request("FORUM_Title"))&"&M=0#bottom"">"&trim((Server.HTMLEncode(Request.Form("Subject"))))&"...</a>"
application("forumlast")=dstring
application("forumlast_time")=now
update_last(dstring)
'SideShow END
</pre id=code>

Is this SIDESHOW part of the poll system ? I cannot get the update_last function to work...

<pre id=code>
'around line 1269 find
select case Request.Form("Method_Type")

'BEFORE this add
if request("ispoll")="on" then
response.redirect "post.asp?method=Poll&FORUM_ID="&FORUM_ID&"&CAT_ID="&CAT_ID&"&TOPIC_ID="&topic_id&"&tauthor="&tauthor&"&Refer="&server.urlencode(request("Refer"))
end if
</pre id=code>

I've 2 select cases statement very near... if I put the mod on the 1st one there's an error about html headers ... if I put on the second nothings happens...

HELP!

Pier

phynias
New Member

USA
64 Posts

Posted - 27 September 2000 : 13:37:21

woooooooops do not add the sideshow part.. just the lines before it.. i fixed the readme. thanks as for the second question its also updated in the readme.. sorry about that.

Edited by - phynias on 27 September 2000 13:38:30

pier
Starting Member

Italy
22 Posts

Posted - 28 September 2000 : 03:02:53

Thanks for the update,
my actual code looked like the one you said but... I still have this error when I try to post a poll:

<pre id=code>

Response object error 'ASP 0156 : 80004005'

Header Error

/post_info.asp, line 1276

The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.
</pre id=code>

If I remove the "response.redirect" object everything runs fine but (of course) I'm unable to create the pool and I see only a topic with the "poll logo"

any help!?

pier

phynias
New Member

USA
64 Posts

Posted - 28 September 2000 : 03:45:56

at the top of the page put

<pre id=code>
<%response.buffer=true%>
</pre id=code>
<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Thanks for the update,
my actual code looked like the one you said but... I still have this error when I try to post a poll:

<pre id=code>

Response object error 'ASP 0156 : 80004005'

Header Error

/post_info.asp, line 1276

The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.
</pre id=code>

If I remove the "response.redirect" object everything runs fine but (of course) I'm unable to create the pool and I see only a topic with the "poll logo"

any help!?

pier

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

=P
http://www.greeneggsnspam.com/newstrax/

KenDude
New Member

USA
87 Posts

Posted - 03 October 2000 : 10:47:06

Phynias,
Do you have a cleaned up version of the Poll modification that works with Beta 5 and hence the coming release of 3.1?
Thanks,

KenDude was Here!

Page: of 4

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.2 seconds.