FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter
Help with ports
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Newer Topic  |  Older Topic 
 How I delete spammers
Author: Dan 
Date:   06-11-12 20:33

begin;delete from forums_auth where ID NOT IN
(
select FA.id
from forums_auth FA JOIN feedback F on (F.userid = FA.id)
Union
select FA.id
from forums_auth FA JOIN help F on (F.userid = FA.id)
);


--
The Man Behind The Curtain
Reply To This Message
 Forum List  |  Threaded View   Newer Topic  |  Older Topic 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD 		Valid HTML, CSS, and RSS.
Copyright © 2000-2013 DVL Software Limited. All rights reserved.