| Author |
 Topic  |
|
modifichicci
Average Member
Italy
787 Posts |
 Posted - 02 June 2007 : 09:57:33
|
Using antispam mod checking for a number of posts to allow sending mail or PM, if a memeber post and delete his posts can raise the count and then begin to spam..
But snitz code doesn't update member post count if post is deleted.
So I have modified pop_delete to update count when deleting topics, replies, forum and cat.
This is the pop_delete modified in an original snitz 06 file.
Changing are marked by
' #### post count update modifichicci mod #####
and
' #### post count update modifichicci mod ##### END
pop_delete mod
It works on my sql forum, but I think no problem with access also
save file as pop_delete.asp and if you haven't made changes overwrite the old file, or compare files..
Title changed by ruirib< |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
Edited by - modifichicci on 11 December 2007 13:38:00 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 03 June 2007 : 09:12:50
|
Will it not decrease the post count if they delete a post made in a forum that doesn't increase the post count?
For instance, if I make a post in the testing forum here it doesn't increase my post count. Would your MOD subtract one post if I deleted said post?< |
 |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 03 June 2007 : 13:09:01
|
Nice work.  < |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 04 June 2007 : 07:01:02
|
Thanks! Good idea!  < |
Edited by - Etymon on 04 June 2007 07:01:42 |
|
|
|
Hermes
Junior Member
Croatia
113 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Hermes
Junior Member
Croatia
113 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 11 December 2007 : 05:14:19
|
Nice work, Mod'
Worked on this meself a couple of times over the years but never got around to finishing it off.
< |
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
Posted - 11 December 2007 : 12:31:18
|
Yes Image, that is true, I have been confused as in pop delete is used strActivePrefix because it works both on A_TABLE and TABLE, but FORUM doesn't need of archived function.
CHange the function to this
function getForumCount(fPostCount)
Dim strSql
Dim rsgetForumCount
'## Forum_SQL
if isNull(fPostCount) then exit function
strSql = "SELECT F_COUNT_M_POSTS "
strSql = strSql & "FROM " & strTablePrefix & "FORUM "
strSql = strSql & "WHERE FORUM_ID = " & cLng(fPostCount)
Set rsgetForumCount = Server.CreateObject("ADODB.Recordset")
rsgetForumCount.Open strSql, my_Conn
if rsgetForumCount.EOF or rsgetForumCount.BOF then
getForumCount = ""
else
getForumCount = rsgetForumCount("F_COUNT_M_POSTS")
end if
rsgetForumCount.Close
Set rsgetForumCount = nothing
end function
Thanks Shaggy!!
I will update the zip on snitzbitz (mod is in approve mod till now..)< |
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
philsbbs
Junior Member
United Kingdom
397 Posts |
Posted - 15 December 2007 : 07:08:48
|
| thanks for this, ive installed it and it works a treat.< |
Phil |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
natty
Starting Member
United States
31 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Topic |
|
Decrease members post count on post deletion
