Aaron Posted November 29, 2011 Report Share Posted November 29, 2011 I got my site up, I want my staff ID to be CFC001, CFC002 and so on. I want my pilots ID to be CFC101, CFC102 and so on. How do I go about changing this? I changed 2 pilots ID's to 101 and then 102 and then if another pilot signs up it puts them at CFC005 and I have to manually change this. Help plz and thanks Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted November 29, 2011 Moderators Report Share Posted November 29, 2011 thats not possible itsw one or the other Quote Link to comment Share on other sites More sharing options...
Aaron Posted November 29, 2011 Author Report Share Posted November 29, 2011 It has to be possible. If I have a pilot register as for example CFC004, if I delete him completely then have another user sign up, their ID will be CFC005. There must be somewhere it keeps a record of some sort of the last pilot ID used, and I should be able to change it. Quote Link to comment Share on other sites More sharing options...
MBrown Posted November 29, 2011 Report Share Posted November 29, 2011 thats not possible itsw one or the other Yes that should be perfectly fine. Make sure your Pilot ID offset is set to CFC000 first, so then you become CFC001 and someone else in staff CFC002. Then when a new Pilot registers he will become CFC003. But you don't want this. Simply in the admin panel go to "change a pilot's id" and change him to CFC101. Then the next person who registers after that will become CFC102 and so on. Quote Link to comment Share on other sites More sharing options...
Strider Posted November 29, 2011 Report Share Posted November 29, 2011 Just for your information, it is the database that controls the sequence. So when you have CFC003, CFC004, but then you delete CFC004 the next one is going to be CFC005. There is no way you can have two different pilot ID formats, it is either CFC001 or CFC101, not both at the same time. Quote Link to comment Share on other sites More sharing options...
Sava Posted November 29, 2011 Report Share Posted November 29, 2011 Or you can make the starting id 100 and then just change the ids of staff members. Quote Link to comment Share on other sites More sharing options...
Aaron Posted December 1, 2011 Author Report Share Posted December 1, 2011 If I make the ID Offset 100, CFC001 turns to CFC101, and I tryed puting in -99 to see if that works (100-99=CFC001) but I get an error. If theres a way to change the starting ID that isn't the offset can you please tell me how. Quote Link to comment Share on other sites More sharing options...
Aaron Posted December 1, 2011 Author Report Share Posted December 1, 2011 Also, I changed a pilots ID to CFC101 but new users still are assigned CFC004, CFC005... Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted December 1, 2011 Moderators Report Share Posted December 1, 2011 the pilot registration is like this coded with autoincrement so when you have a pilot registering with 001 the next one wil be 002 no mather what you do or like you say 101 then the next wil be 102 messing with the change pilot id in the admin works but yo ucan change it to what you want the let say 101 to 3298 the next registration wil be 102 also messing with the change pilo id isn't the best thing you can do. like stated in that template it could possible mess all things up regards Quote Link to comment Share on other sites More sharing options...
avdesigns Posted December 14, 2011 Report Share Posted December 14, 2011 I made 2 test accounts them deleted them then the next person who signed up there id was 0002 it was 0004, can you please help me? Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted December 14, 2011 Moderators Report Share Posted December 14, 2011 llok at the other post you made the system remembers the last registration number and then does +1 so iff you have id004 as last registration and you delete 2 its still going to remember the id004 and thus the next registration wil be id005 there is no easy way arround it iff you have sql skills then it is possible but only to an extend 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.