RogerB Posted February 12, 2011 Report Share Posted February 12, 2011 Do to the spam attack on the phpvms apply form a bunch of my pilot id's got used, so when pilots join i change their pilot id. Only issue is the system removes them from the new pilot section. I know why it does this but can we fix it? Quote Link to comment Share on other sites More sharing options...
Moderators Kyle Posted February 12, 2011 Moderators Report Share Posted February 12, 2011 I would reset the pilot ID count, I think but I done something like that similar to the schedules. But If you want to change the pilot's ID, then head over to that link, admin/index.php/maintenance/changepilotid and take a look and see if you can try to reorder the ID, BUT BE CAREFUL!!! Read everything before you jack it up and mess up the site, happened to me many times. But other hand, for Advance things, go to your DB and go to the pilot, and edit the pilot per pilot ID's and it should work, but not sure. Be careful. Back up first before you jack the things up. Quote Link to comment Share on other sites More sharing options...
Tom Posted February 12, 2011 Report Share Posted February 12, 2011 After deleting pilots, go into your phpmyadmin and run SQL: ALTER TABLE phpvms_pilots AUTO_INCREMENT = 1 Or whatever your table prefix is. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 14, 2011 Administrators Report Share Posted February 14, 2011 After deleting pilots, go into your phpmyadmin and run SQL: ALTER TABLE phpvms_pilots AUTO_INCREMENT = 1 Or whatever your table prefix is. I'm not sure that's the best idea, I don't know how MySQL will handle that with existing pilots, not sure if it will skip over to the first available ID Quote Link to comment Share on other sites More sharing options...
Tom Posted February 14, 2011 Report Share Posted February 14, 2011 I've been using it for quite some time for various things. All it does is reset the next auto increment number to current highest + 1. Not had any adverse effects yet... Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted February 14, 2011 Administrators Report Share Posted February 14, 2011 I've been using it for quite some time for various things. All it does is reset the next auto increment number to current highest + 1. Not had any adverse effects yet... Ah ok, then it's all good. I've just never done it personally, so wasn't sure how it would handle 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.