flyalaska Posted March 17, 2014 Report 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
Moderators servetas Posted March 30, 2014 Moderators Report Posted March 30, 2014 While listening to music i though about something ... Why don't you order them based on their submitdate? Quote
Strider Posted March 30, 2014 Report 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
Moderators servetas Posted March 30, 2014 Moderators Report 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
flyalaska Posted April 1, 2014 Author Report 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
Moderators servetas Posted April 1, 2014 Moderators Report 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
Moderators servetas Posted April 1, 2014 Moderators Report 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
Strider Posted April 1, 2014 Report Posted April 1, 2014 Servetas, the way you said it, it looked like you meant their pireps. Quote
flyalaska Posted April 1, 2014 Author Report 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
Moderators servetas Posted April 1, 2014 Moderators Report Posted April 1, 2014 Ok, can you please place it on your local.config.php file and let me know if it works? Quote
flyalaska Posted April 3, 2014 Author Report Posted April 3, 2014 Changed the order, still not the correct order. Quote
Moderators servetas Posted April 3, 2014 Moderators Report 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
flyalaska Posted April 3, 2014 Author Report 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
Moderators servetas Posted April 3, 2014 Moderators Report 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
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.