Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringWeird Request.

Author : spyderuk
Subject : Weird Request.
Posted : 12 August 2006, 10:40
Message :

I have a member that is currently posting in the forum then deleting the post just to increase their post count's. I have sat and watched him do it from active users, seen new post, then it's gone. Have reduced post count in profile then get moaning pm's from him, then he goes and does it again.
I was wondering if anyone could help with a line of code or the edit for the exisiting code to go in post.asp (is it?) that would check for members id before increasing the post count and if it was that member ID then -1 from the post count?

A bit messy I know but would be apreciated if anyone could help!<

Reply Author: HuwR
Replied on: 12 August 2006, 12:41
Message:

look in inc_func_count.asp for the doUCount function<

Reply Author: spyderuk
Replied on: 12 August 2006, 15:12
Message:

Ah so the proposed change would go in here somewhere? Maybe an if, else statement. Sorry my asp knowledge is very bad.

sub doUCount(sUser_Name)
'## Forum_SQL - Update Total Post for user
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET M_POSTS = M_POSTS + 1 "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(sUser_Name, "SQLString") & "'"

my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
end sub<

Reply Author: bobby131313
Replied on: 12 August 2006, 19:16
Message:

You have a whole lot more patience than me. He'd get one warning then I'd push the

button.

<

Reply Author: AnonJr
Replied on: 12 August 2006, 19:30
Message:

Or as punishment (after a warning of course) you could use the UserGroup MOD to set his access to all forums to "Read Only" for a week...<

Reply Author: ruirib
Replied on: 12 August 2006, 20:05
Message:

Originally posted by spyderuk
Ah so the proposed change would go in here somewhere? Maybe an if, else statement. Sorry my asp knowledge is very bad.
sub doUCount(sUser_Name)
'## Forum_SQL - Update Total Post for user
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET M_POSTS = M_POSTS + 1 "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(sUser_Name, "SQLString") & "'"

my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
end sub

Even though I agree with the previous comments about locking him without many hesitations, you could code it like this:

Code:


sub doUCount(sUser_Name)
	'## Forum_SQL - Update Total Post for user
	strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
	strSql = strSql & " SET M_POSTS = M_POSTS + 1 "
	strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(sUser_Name, "SQLString") & "'"
        If MemberId<>xxx then
	my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
        end if
end sub

<

Reply Author: AnonJr
Replied on: 12 August 2006, 23:00
Message:

Correct me if I'm wrong, but wouldn't that only execute the query if the Member ID is the one in question? thereby only incrementing that member's post count?<

Reply Author: ruirib
Replied on: 12 August 2006, 23:15
Message:

Originally posted by AnonJr
Correct me if I'm wrong, but wouldn't that only execute the query if the Member ID is the one in question? thereby only incrementing that member's post count?

Where?

<

Reply Author: AnonJr
Replied on: 13 August 2006, 11:55
Message:

Nothin like a quick edit.

I mean, it must have been the lack of sleep blurring the code...

<

Reply Author: spyderuk
Replied on: 13 August 2006, 12:51
Message:

Thanks for the code. I'm getting grief now of other members cos my co Admin decided to put him on probation for 4 weeks! Ah well.
Would that edit result in no post increase as I was thinking of a Minus post count for that 1 user?
AnonJr I use usergroups to make a "Probation Area" They don't even get to see the other forums and in conjuction with the IP gate mod they get blocked from accessing all PM related pages

<

Reply Author: Shaggy
Replied on: 14 August 2006, 07:32
Message:

A better option may be to decrement a member's post count if one of their posts is deleted either by themself or a staff member. This way, only the legitimate posts this particular member made would be counted towards their total. For even more fun, don't tell anyone what you've done and watch htis member post & delete fruitlessly for a while before they realise what you've done!

I posted the necessary changes to pop_delete.asp a while back, you should be able to find them with a search.
<

Reply Author: HuwR
Replied on: 14 August 2006, 08:28
Message:

That is not what the postcount is for, so decrementing when a post is deleted is not correct<

Reply Author: Shaggy
Replied on: 14 August 2006, 09:13
Message:

Ay, I know, but there are some, like me, who prefer to do it the incorrect way.

<

Reply Author: spyderuk
Replied on: 16 August 2006, 12:41
Message:

I think it is the fun way to deal with the phantom posters that make 30 new posts and delete around 25 of them.
Shaggy, That sounds spot on! I'll have to search harder, Cheers

<

Reply Author: Shaggy
Replied on: 16 August 2006, 12:58
Message:

Note that this will effect all users and will decrement their post count whether they delete their own posts or it's down my a mod/admin. If that's not what you want to do, then go with Rui's suggestion.
<

Weird Request.

Topic

Replies ...