SPAM - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

Site Related Discussions

SPAM

Author

Topic

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-05-18 : 12:10:42

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83749

Dinakar Nethi
SQL Server MVP
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-18 : 12:12:44

deleted. thanx.

i've already deleted one spam message from this guy... this is the second one.

Edit: make that 5th

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

nr
SQLTeam MVY

12543 Posts

Posted - 2007-05-18 : 12:26:42

Don't you lock/delete the user as well?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-18 : 12:32:09

nope. can't do that yet.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-05-18 : 12:37:09

Bill didn't give out the keys to that function.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-05-18 : 12:37:28

quote:
Originally posted by spirit1

nope. can't do that yet.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

ohh..so you just go after the posts?
am surprised you cant delete the user...

DELETE FROM table WHERE user = 'sniperidz"

wont work?

Dinakar Nethi
SQL Server MVP
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-18 : 12:39:22

yup. we don't really have access to the db

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-05-18 : 12:42:54

Locking/deleting/editing posts is a moderator function. Apparently locking users is an administrator function. I'm at the PASS Board meeting but I'm going to look into this when I get back.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Kristen
Test

22859 Posts

Posted - 2007-05-19 : 07:44:41

If you lock the user does that kill them off in their current session, or can they still get away with posting until they disconnect?

(Just curious)

Kristen

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-05-19 : 10:51:48

I have no idea. I've been curious about that myself. I may be able to figure it out when I look at whether moderators can lock accounts.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Kristen
Test

22859 Posts

Posted - 2007-05-21 : 06:41:23

Not sure if this is Spam, but its a first post, and what seems to be some serious $ numbers!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82735

3rd post

Kristen

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-21 : 07:51:47

yup this is spam... deleted

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Kristen
Test

22859 Posts

Posted - 2007-05-21 : 08:21:37

Speaking from my usual hobby-horse!! that is a result.

The thread did NOT show up in Active Topics after your deletion, and in the Forum List [at least] it has reverted to the date of the last "real" post - 04/26/2007

Kristen

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-21 : 08:24:50

ok... so?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Kristen
Test

22859 Posts

Posted - 2007-05-21 : 10:21:59

If you delete a Spam the "date" of the post is that of the "last post" it contains, not the date of the newer (now-deleted) spam. So it doesn't appear in the various lists as a New Postings.

I think that's a good thing.

Of course if someone posts a follow-up in the thread saying "This is spam" then that will tickle the thread's latest-posting date - unless you delete the Spam and the follow-up!

All that power, eh?!

Kristen

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-21 : 10:29:14

i really don't see a problem here, K-bot

the spammer didn't contribute anything to the thread so why keep the date?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Kristen
Test

22859 Posts

Posted - 2007-05-21 : 11:28:02

There is NO problem

If a Spammer adds a post to the Thread it gets todays date.

If you MODERATED the Spam then the thread gets an even newer date.

If you DELETE the Spam then the date REVERTS to the date of the latest post in the thread (i.e. most likely back to what it was before the Spam was added)

This is PERFECT to my way of thinking, and why I think that Deleting spam is better than Moderating/Censoring it.

K-Bot

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources