Page 1 of 1
Pilots Ids start
#1
Posted 28 July 2010 - 01:26 PM
Hello,
Yesterday a pilot register to Greece AIrways VA and he requests from me to change his pilots id.I make his pilot id from GRW042 to id GRW312.But after that i saw but there would be some problem so i change again the pilots id from GRW312 to GRW042.But now when a user register with my company his pilot id is the GRW313,GRW314,GRW315,GRW316.How can i set the system when a pilot register with us his pilots id will be the GRW043,GRW044,GRW045,GRW046?
Yesterday a pilot register to Greece AIrways VA and he requests from me to change his pilots id.I make his pilot id from GRW042 to id GRW312.But after that i saw but there would be some problem so i change again the pilots id from GRW312 to GRW042.But now when a user register with my company his pilot id is the GRW313,GRW314,GRW315,GRW316.How can i set the system when a pilot register with us his pilots id will be the GRW043,GRW044,GRW045,GRW046?
#2
Posted 28 July 2010 - 07:24 PM
Once you change the ID to a higher one, it starts from there... there's a warning about it
Twitter | Docs | API Docs | Bug Tracker | Getting Debug Info
phpVMS Hosting - Cheap, fast, and reliable! Check it out here
phpVMS Hosting - Cheap, fast, and reliable! Check it out here
#3
Posted 28 July 2010 - 07:31 PM
so i cannot make the pilot id starts again from GRW043?
#4
Posted 28 July 2010 - 08:16 PM
you would have to change all pilotids above where you want to continue at to below that point and then reset your auto-increment number in phpadmin to the highest pilotid +1.
Custom ACARS - PIREP Filing / ACARS Live Map Update / Full Flight Log / Flight info / Aircraft info / More to come
FS-Products | Support Forum
#5
Posted 28 July 2010 - 08:47 PM
#6
Posted 28 July 2010 - 08:48 PM
do you mean phpmyadmin?and if you mean this where can i find it?
#8
Posted 28 July 2010 - 08:52 PM
i know that but where can i find the highest pilotid +1?
#9
Posted 28 July 2010 - 08:58 PM
I have to caution you that if you do not know what you are doing you can really do some damage inside of phpAdmin. Since you don't know where to find phpAdmin I would say that your best bet is to just leave it alone.
If you want to go for it then it is under the operations tab of the table you are viewing. It is called AUTO_INCREMENT. The number in that field is the next number to be assigned when a record is added.
If you want to go for it then it is under the operations tab of the table you are viewing. It is called AUTO_INCREMENT. The number in that field is the next number to be assigned when a record is added.
Custom ACARS - PIREP Filing / ACARS Live Map Update / Full Flight Log / Flight info / Aircraft info / More to come
FS-Products | Support Forum
#10
Posted 28 July 2010 - 09:08 PM
lorathon, on 29 July 2010 - 12:58 AM, said:
I have to caution you that if you do not know what you are doing you can really do some damage inside of phpAdmin. Since you don't know where to find phpAdmin I would say that your best bet is to just leave it alone.
If you want to go for it then it is under the operations tab of the table you are viewing. It is called AUTO_INCREMENT. The number in that field is the next number to be assigned when a record is added.
If you want to go for it then it is under the operations tab of the table you are viewing. It is called AUTO_INCREMENT. The number in that field is the next number to be assigned when a record is added.
Thank you lorathon !!! you save us ! servetas is my VCEO and his knowledge about web develop and phpmyadmin isn't good... It is ok now and working fine ! Thanks once again
p.s im the web manager
Share this topic:
Page 1 of 1
Help



Promote to Article
MultiQuote










