Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Poll Mod - How to clear the tables?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

nepf
Starting Member

Germany
30 Posts
Posted - 23 October 2003 :  12:21:21  Show Profile
Poll Mod 2.06

When I delete a poll the tables

FORUM_POLL_VOTES and
FORUM_POLLS

aren't cleared up.

So I get dataspam from poll to poll.

What ist to do?
nepf

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 23 October 2003 :  15:27:50  Show Profile
It should delete the poll info from those tables. Did you add the poll mod code to your pop_delete.asp file?
Support Snitz Forums
Go to Top of Page

nepf
Starting Member

Germany
30 Posts
Posted - 24 October 2003 :  09:28:20  Show Profile
quote:
Originally posted by Davio

Did you add the poll mod code to your pop_delete.asp file?

Yes!

Any other idea?
I installed the poll mod to version 2.4.02
nepf
Go to Top of Page

nepf
Starting Member

Germany
30 Posts
Posted - 25 October 2003 :  07:12:40  Show Profile
I checkes the code of the pop_delete.asp again:
No mistake!

Has nobody an idea?
nepf
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 25 October 2003 :  09:38:43  Show Profile
Let me see your pop_delete.asp file. Post a link to a txt version of the file.

How do you know the poll isn't deleted from the poll tables?
Support Snitz Forums
Go to Top of Page

nepf
Starting Member

Germany
30 Posts
Posted - 25 October 2003 :  15:28:41  Show Profile
Hi davio,

look here:
http://www.cornelius-kirche.de/pop_delete.txt

I tested the poll mod on my local system an viewed the tables with MSAccess.

Thank you!
nepf
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 25 October 2003 :  17:58:41  Show Profile
Oh man. You're right. The code wasn't deleting the poll data from the poll tables. I can't believe I missed this one.

Change lines 61 - 63 from this:
if Request.QueryString("poll") <> "" then
	if IsNumeric(Request.QueryString("poll")) = True then IsPoll = cLng(Request.QueryString("poll")) else IsPoll = 0
end if
to this:
if Request("Poll") <> "" then
	if IsNumeric(Request("Poll")) = True then IsPoll = cLng(Request("Poll")) else IsPoll = 0
end if

Then after line 804 add the following code in green:
"      <input type=""hidden"" name=""MEMBER_ID"" value=""" & Member_ID & """>" & vbNewLine & _
"      <input type=""hidden"" name=""Poll"" value=""" & IsPoll & """>" & vbNewLine & _
"      <table border=""0"" cellspacing=""0"" cellpadding=""0"">" & vbNewLine & _
That should fix it.
Support Snitz Forums
Go to Top of Page

nepf
Starting Member

Germany
30 Posts
Posted - 26 October 2003 :  07:57:07  Show Profile
YEAH! I found a bug!
But DAVIO solved the problem.
Thank you for your help and for your mod.
nepf
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.49 seconds. Powered By: Snitz Forums 2000 Version 3.4.07