phpVMS Forums: Pilots Ids start - phpVMS Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Pilots Ids start Rate Topic: -----

#1 User is offline   servetas 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 46
  • Joined: 30-April 10

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?
0

#2 User is offline   Nabeel 

  • Advanced Member
  • Group: Administrators
  • Posts: 6227
  • Joined: 17-February 08
  • LocationWestchester, NY

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
0

#3 User is offline   servetas 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 46
  • Joined: 30-April 10

Posted 28 July 2010 - 07:31 PM

so i cannot make the pilot id starts again from GRW043?
0

#4 User is offline   lorathon 

  • Advanced Member
  • Group: Moderators
  • Posts: 485
  • Joined: 20-February 10
  • LocationRiverside, California

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.
Posted Image
Custom ACARS - PIREP Filing / ACARS Live Map Update / Full Flight Log / Flight info / Aircraft info / More to come
FS-Products | Support Forum
0

#5 User is offline   dimitris 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 51
  • Joined: 16-May 10

Posted 28 July 2010 - 08:47 PM

View Postlorathon, on 29 July 2010 - 12:16 AM, said:

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.

can you explain much more please i can't understand :rolleyes:
0

#6 User is offline   servetas 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 46
  • Joined: 30-April 10

Posted 28 July 2010 - 08:48 PM

do you mean phpmyadmin?and if you mean this where can i find it?
0

#7 User is offline   Jeff 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 418
  • Joined: 20-May 10
  • LocationAthens, Tennessee USA

Posted 28 July 2010 - 08:49 PM

phpMyAdmin is found in your cPanel
Posted Image
0

#8 User is offline   servetas 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 46
  • Joined: 30-April 10

Posted 28 July 2010 - 08:52 PM

i know that but where can i find the highest pilotid +1?
0

#9 User is offline   lorathon 

  • Advanced Member
  • Group: Moderators
  • Posts: 485
  • Joined: 20-February 10
  • LocationRiverside, California

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.
Posted Image
Custom ACARS - PIREP Filing / ACARS Live Map Update / Full Flight Log / Flight info / Aircraft info / More to come
FS-Products | Support Forum
0

#10 User is offline   dimitris 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 51
  • Joined: 16-May 10

Posted 28 July 2010 - 09:08 PM

View Postlorathon, 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.

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 :rolleyes: :rolleyes: :rolleyes:

p.s im the web manager ;)
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic