Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
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
Next Page
Author Previous Topic Topic Next Topic
Page: of 4

phynias
New Member

USA
64 Posts

Posted - 22 September 2000 :  11:47:06  Show Profile  Visit phynias's Homepage  Send phynias an ICQ Message
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  Show Profile
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" 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></font id=quote><font face="Verdana, Arial, Helvetica" size=2 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><font face=courier size=2 id=code>
set (whatever) = ...
</font id=code></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
Go to Top of Page

KoopaOne
Starting Member

Austria
11 Posts

Posted - 24 September 2000 :  05:07:03  Show Profile  Visit KoopaOne's Homepage  Send KoopaOne an ICQ Message
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>

Go to Top of Page

phynias
New Member

USA
64 Posts

Posted - 24 September 2000 :  12:53:10  Show Profile  Visit phynias's Homepage  Send phynias an ICQ Message
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" 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></font id=quote><font face="Verdana, Arial, Helvetica" size=2 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..

Go to Top of Page

phynias
New Member

USA
64 Posts

Posted - 24 September 2000 :  12:55:27  Show Profile  Visit phynias's Homepage  Send phynias an ICQ Message
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" 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></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

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

Go to Top of Page

James
Average Member

USA
539 Posts

Posted - 24 September 2000 :  14:26:11  Show Profile  Visit James's Homepage
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" 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></font id=quote><font face="Verdana, Arial, Helvetica" size=2 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
Go to Top of Page

phynias
New Member

USA
64 Posts

Posted - 24 September 2000 :  16:09:59  Show Profile  Visit phynias's Homepage  Send phynias an ICQ Message
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" 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></font id=quote><font face="Verdana, Arial, Helvetica" size=2 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></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

huh?

Go to Top of Page

James
Average Member

USA
539 Posts

Posted - 24 September 2000 :  22:36:23  Show Profile  Visit James's Homepage
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
huh?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 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/
Go to Top of Page

phynias
New Member

USA
64 Posts

Posted - 25 September 2000 :  00:09:21  Show Profile  Visit phynias's Homepage  Send phynias an ICQ Message
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
huh?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 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></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
It's an access db. Just open it up with access, make your changes and save...

Go to Top of Page

James
Average Member

USA
539 Posts

Posted - 26 September 2000 :  21:49:51  Show Profile  Visit James's Homepage
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" 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></font id=quote><font face="Verdana, Arial, Helvetica" size=2 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)?

-
<font color=red>*</font id=red><font color=blue>Interested in <b>Radio Control</b> </font id=blue><font color=red>-</font id=red> http://www.rcwebboard.com/<font color=red>*</font id=red>
Go to Top of Page

phynias
New Member

USA
64 Posts

Posted - 26 September 2000 :  22:11:16  Show Profile  Visit phynias's Homepage  Send phynias an ICQ Message
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" 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)?

-
<font color=red>*</font id=red><font color=blue>Interested in <b>Radio Control</b> </font id=blue><font color=red>-</font id=red> http://www.rcwebboard.com/<font color=red>*</font id=red>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

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

Go to Top of Page

pier
Starting Member

Italy
22 Posts

Posted - 27 September 2000 :  13:30:15  Show Profile  Visit pier's Homepage  Send pier an AOL message  Send pier an ICQ Message
I've some problems on the istructions file...

<pre id=code><font face=courier size=2 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") &"""><font color=red>"&Request.Form("UserName") &"</font></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""><font color=black><u>"&trim((Server.HTMLEncode(Request.Form("Subject"))))&"...</font></u></a>"
application("forumlast")=dstring
application("forumlast_time")=now
update_last(dstring)
'SideShow END
</font id=code></pre id=code>

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

<pre id=code><font face=courier size=2 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
</font id=code></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

Go to Top of Page

phynias
New Member

USA
64 Posts

Posted - 27 September 2000 :  13:37:21  Show Profile  Visit phynias's Homepage  Send phynias an ICQ Message
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
Go to Top of Page

pier
Starting Member

Italy
22 Posts

Posted - 28 September 2000 :  03:02:53  Show Profile  Visit pier's Homepage  Send pier an AOL message  Send pier an ICQ Message
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><font face=courier size=2 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.
</font id=code></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

Go to Top of Page

phynias
New Member

USA
64 Posts

Posted - 28 September 2000 :  03:45:56  Show Profile  Visit phynias's Homepage  Send phynias an ICQ Message
at the top of the page put

<pre id=code><font face=courier size=2 id=code>
<%response.buffer=true%>
</font id=code></pre id=code>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" 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><font face=courier size=2 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.
</font id=code></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></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

=P
http://www.greeneggsnspam.com/newstrax/
Go to Top of Page

KenDude
New Member

USA
87 Posts

Posted - 03 October 2000 :  10:47:06  Show Profile  Visit KenDude's Homepage
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!
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07