flyalaska Posted March 17, 2014 Report Share Posted March 17, 2014 Anyone know how to get my pilot list in order? Ever since the pilot ID went over 1,000 they went out of order. How do I fix this? Quote Link to comment Share on other sites More sharing options...
flyalaska Posted March 28, 2014 Author Report Share Posted March 28, 2014 Anyone? Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted March 30, 2014 Moderators Report Share Posted March 30, 2014 While listening to music i though about something ... Why don't you order them based on their submitdate? Quote Link to comment Share on other sites More sharing options...
Strider Posted March 30, 2014 Report Share Posted March 30, 2014 Good idea but only problem, it will keep changing anytime they file a pirep. Only thing I can suggest, is to try and order it by the 3rd number in the pilot ID. Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted March 30, 2014 Moderators Report Share Posted March 30, 2014 You are not correct. He can order them based on their joindate (db pilots table) which does not change when someone files a pirep. Quote Link to comment Share on other sites More sharing options...
flyalaska Posted April 1, 2014 Author Report Share Posted April 1, 2014 You are not correct. He can order them based on their joindate (db pilots table) which does not change when someone files a pirep. How do I do that? Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted April 1, 2014 Moderators Report Share Posted April 1, 2014 This can be done via your PilotData.class.php file (i think). I will let you know the change specifically as soon as i get back home. 1 Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted April 1, 2014 Moderators Report Share Posted April 1, 2014 I managed to access my phpvms site and get some files on my mobile phone. Can you add this on your codon.config.php file and let me know if it works? Config::Set('PILOT_ORDER_BY', 'p.joindate ASC'); I have not tested it but it has to work from what i see on the phpvms files. Quote Link to comment Share on other sites More sharing options...
Strider Posted April 1, 2014 Report Share Posted April 1, 2014 Servetas, the way you said it, it looked like you meant their pireps. Quote Link to comment Share on other sites More sharing options...
flyalaska Posted April 1, 2014 Author Report Share Posted April 1, 2014 I get an error Parse error: syntax error, unexpected ')' in /home/flyakaco/public_html/core/codon.config.php on line 148 Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted April 1, 2014 Moderators Report Share Posted April 1, 2014 Ok, can you please place it on your local.config.php file and let me know if it works? Quote Link to comment Share on other sites More sharing options...
flyalaska Posted April 3, 2014 Author Report Share Posted April 3, 2014 Changed the order, still not the correct order. Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted April 3, 2014 Moderators Report Share Posted April 3, 2014 As i can see your pilots are now ordered correctly... http://www.flyaka.com/index.php/pilots Which list are you trying to order because the list in the screenshot is different from the one i can see on the link i gave you. Quote Link to comment Share on other sites More sharing options...
flyalaska Posted April 3, 2014 Author Report Share Posted April 3, 2014 I don't use the default, I use http://www.flyaka.com/index.php/fsp_PilotRoster which is not separated by hubs. Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted April 3, 2014 Moderators Report Share Posted April 3, 2014 Why don't you tell it from the beggining? You want us to customize a table in which we have not access to it? In the database function which selects your pilots, add this: ORDER BY joindate ASC Let me know if you have any question. 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.