Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Mod Req: Anti-Bump Protection
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Mod Req: Anti-Bump Protection

 Post Reply Post Reply Page  <123>
Author
venki View Drop Down
Groupie
Groupie


Joined: 20 April 2003
Status: Offline
Points: 40
Post Options Post Options   Thanks (0) Thanks(0)   Quote venki Quote  Post ReplyReply Direct Link To This Post Posted: 29 April 2006 at 4:17pm

in file new_post.asp at line 534 you will find this code

'******************************************
'***       Anti-spam Check  ***
'******************************************
 
and ADD this code after this code (add it at line 537)
 
'Mod by Venky, http://venki.somee.com, hrvojevencl@gmail.com
strSQL = "SELECT "
If strDatabaseType = "SQLServer" OR strDatabaseType = "Access" Then
 strSQL = strSQL & "TOP 1"
End If
strSQL = strSQL & " " & strDbTable & "Thread.Author_ID " & _
"FROM " & strDbTable & "Thread " & strDBNoLock & " " & _
"WHERE " & strDbTable & "Thread.Topic_ID = " & lngTopicID & " " & _
"ORDER BY " & strDbTable & "Thread.Message_date DESC"
If strDatabaseType = "mySQL" Then
 strSQL = strSQL & " LIMIT 1"
End If
strSQL = strSQL & ";"
'Open the recordset
rsCommon.Open strSQL, adoCon
 if not rsCommon.EOF then
  if rsCommon("Author_ID") = lngLoggedInUserID then strReturnCode = "bump"
 End if
 
'Clean up
rsCommon.Close
then in file not_posted.asp at line 116 you will find this code
 
End If       

REPLACE it whit this code

ElseIf strErrorCode = "bump" Then
 Response.Write("You are not allowed to create bump posts. Please wait until someone replies to the thread, or edit your last post to include additional information.")
End If      
 

Back to Top
Mikey View Drop Down
Senior Member
Senior Member

1979

Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mikey Quote  Post ReplyReply Direct Link To This Post Posted: 29 April 2006 at 4:23pm
Good old Venki...
I'll give this a try in a sec and let you know how it goes...

EDIT: Nice one Venki it works a treat with no problems Clap


Edited by Mikey - 29 April 2006 at 4:57pm
Handyman man?
Back to Top
GuidingLight View Drop Down
Newbie
Newbie


Joined: 29 April 2006
Location: United Kingdom
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote GuidingLight Quote  Post ReplyReply Direct Link To This Post Posted: 29 April 2006 at 10:56pm
Thanks Venki, haven't actually got around to trying it yet, but does it allow for admins to double post in case they need update a post such as a news and updates one or can they just edit the original and it will come up in active topics again.
Back to Top
nexus View Drop Down
Groupie
Groupie
Avatar

Joined: 23 May 2005
Status: Offline
Points: 60
Post Options Post Options   Thanks (0) Thanks(0)   Quote nexus Quote  Post ReplyReply Direct Link To This Post Posted: 01 May 2006 at 4:52pm
GREAT SUGGESTION!!
 
I even like this idea so much that I think -Borg (if you're reading this, then listen to us ;)) should consider implementing it in WWF as an official feature :D
 
Back to Top
venki View Drop Down
Groupie
Groupie


Joined: 20 April 2003
Status: Offline
Points: 40
Post Options Post Options   Thanks (0) Thanks(0)   Quote venki Quote  Post ReplyReply Direct Link To This Post Posted: 01 May 2006 at 6:11pm

This MOD will not allow admin duble posts, to allow it for admins use changed code here:

in file new_post.asp at line 534 you will find this code

'******************************************
'***       Anti-spam Check  ***
'******************************************
 
and ADD this code after this code (add it at line 537)
 
'Mod by Venky, http://venki.somee.com, hrvojevencl@gmail.com
if NOT blnAdmin then
strSQL = "SELECT "
If strDatabaseType = "SQLServer" OR strDatabaseType = "Access" Then
 strSQL = strSQL & "TOP 1"
End If
strSQL = strSQL & " " & strDbTable & "Thread.Author_ID " & _
"FROM " & strDbTable & "Thread " & strDBNoLock & " " & _
"WHERE " & strDbTable & "Thread.Topic_ID = " & lngTopicID & " " & _
"ORDER BY " & strDbTable & "Thread.Message_date DESC"
If strDatabaseType = "mySQL" Then
 strSQL = strSQL & " LIMIT 1"
End If
strSQL = strSQL & ";"
'Open the recordset
rsCommon.Open strSQL, adoCon
 if not rsCommon.EOF then
  if rsCommon("Author_ID") = lngLoggedInUserID then strReturnCode = "bump"
 End if
 
'Clean up
rsCommon.Close
End if
 
then in file not_posted.asp at line 116 you will find this code
 
End If       

REPLACE it whit this code

ElseIf strErrorCode = "bump" Then
 Response.Write("You are not allowed to create bump posts. Please wait until someone replies to the thread, or edit your last post to include additional information.")
End If    
Back to Top
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877
Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post Posted: 03 May 2006 at 2:51am
Originally posted by psycotik psycotik wrote:

bump!

LOL
Back to Top
aks427 View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 06 December 2003
Location: United States
Status: Offline
Points: 276
Post Options Post Options   Thanks (0) Thanks(0)   Quote aks427 Quote  Post ReplyReply Direct Link To This Post Posted: 06 May 2006 at 2:49am

Only if it was in the forum permissions with all the other ones (Post, Edit, Delete, Calendar Event, etc), otherwise it would grow into too much of a pain.

Back to Top
venki View Drop Down
Groupie
Groupie


Joined: 20 April 2003
Status: Offline
Points: 40
Post Options Post Options   Thanks (0) Thanks(0)   Quote venki Quote  Post ReplyReply Direct Link To This Post Posted: 06 May 2006 at 11:21am
That would request new column (Yes/No) in database.
Back to Top
 Post Reply Post Reply Page  <123>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.