hiwd Posted January 4, 2007 Share Posted January 4, 2007 Hi there, I've had an issue that caused over 15,000 tickets to be opened from an email "postmaster@mdnotes.com". I was wondering if there was a quick way to delete all of these? Thanks Regards, Stephen 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted January 4, 2007 WHMCS CEO Share Posted January 4, 2007 Yep, run the following SQL on your database: DELETE FROM tbltickets WHERE email='postmaster@mdnotes.com' Matt 0 Quote Link to comment Share on other sites More sharing options...
johhnyb Posted January 4, 2007 Share Posted January 4, 2007 That's simple use an sql query ex. . DELETE FROM tbltickets WHERE email = 'postmaster@mdnotes.com' I'm just not sure if this table is corerect 0 Quote Link to comment Share on other sites More sharing options...
hiwd Posted January 4, 2007 Author Share Posted January 4, 2007 Thanks guys 0 Quote Link to comment Share on other sites More sharing options...
johhnyb Posted January 4, 2007 Share Posted January 4, 2007 I missed my reply first 0 Quote Link to comment Share on other sites More sharing options...
johnh Posted January 4, 2007 Share Posted January 4, 2007 how can I prevent this thing? or will WHMCS detect it automatically? thanks 0 Quote Link to comment Share on other sites More sharing options...
hiwd Posted January 4, 2007 Author Share Posted January 4, 2007 Hi John, You can't prevent it in the current version but v3 will have an anti-spam feature built in which will stop it if 5 tickets are opened within 5 minutes. 5 is alot better than 15,000! 0 Quote Link to comment Share on other sites More sharing options...
johnh Posted January 5, 2007 Share Posted January 5, 2007 actually I am on ver3.. so I am fine, right? and is this settable? like change setting like 10 tickets with in 5 min like that? thanks 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.