Arun Posted August 4, 2009 Share Posted August 4, 2009 I haven't been using WHMCS inbuilt ticket system and I thought of using it now. I noticed that there are thousands of spam tickets created by now and I was able to stop them as soon as I enabled CAPTCHA. Is there any way I can delete all tickets together or easily? 0 Quote Link to comment Share on other sites More sharing options...
DataHosts Posted August 5, 2009 Share Posted August 5, 2009 Support --> All Active Ticket Check the ones you want to delete and then: With Selected: Delete 0 Quote Link to comment Share on other sites More sharing options...
Arun Posted August 5, 2009 Author Share Posted August 5, 2009 Thanks, but I know how to delete tickets normally. There are about 50000 spam tickets and that means about 1000 pages in the drop down selector. So I am looking for an easier way to delete them rather than opening 1000 pages and deleting for each page. 0 Quote Link to comment Share on other sites More sharing options...
scurrell Posted August 5, 2009 Share Posted August 5, 2009 Thanks, but I know how to delete tickets normally. There are about 50000 spam tickets and that means about 1000 pages in the drop down selector. So I am looking for an easier way to delete them rather than opening 1000 pages and deleting for each page. Remove them directly in the database. 0 Quote Link to comment Share on other sites More sharing options...
Arun Posted August 5, 2009 Author Share Posted August 5, 2009 Thanks, thats something I am looking for. Do you know any mysql command to empty the support ticket tables? 0 Quote Link to comment Share on other sites More sharing options...
DedicatedPros Posted August 5, 2009 Share Posted August 5, 2009 You could just login to phpmyadmin, select the database, and press empty That will delete all the tickets and leave the database empty, if you want to save some of the tickets do this: -login to phpmyadmin, and select the database -select the databases you want -export to file -empty the rest 0 Quote Link to comment Share on other sites More sharing options...
daferub Posted September 20, 2010 Share Posted September 20, 2010 Hello, I'm planning to clean, deleting all tickets and reply into the tblticketreplies and tbltickets, doing this, not interfere with the normal functionallity of the system? Awaiting reply. Thank you! 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.