MC1028 Posted May 28, 2014 Report Share Posted May 28, 2014 Hello All, Recently I encountered around 40 spam attacks, and it now means my pilot IDs go from 3 to around 45. Is there anyway to delete these from the table and what tables should I be editing. Thanks in advance Myles Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted May 28, 2014 Moderators Report Share Posted May 28, 2014 You will have to opwn your phpmyadmin and go to your pilots database table. After that go to the opetations tab of the table you are viewing.  The value is called AUTO_INCREMENT.  The number in that field is the next number to be assigned when a record is added. You can change it to last pilot id+1. 1 Quote Link to comment Share on other sites More sharing options...
MC1028 Posted May 28, 2014 Author Report Share Posted May 28, 2014 Thanks, that sorted it! 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.