CPC900

I noticed that when a flight, on my VA, is accepted and complete, it shows it was completed flight 5 hours prior, when it actually just happened finished?! Am I missing a config setting somewhere?

Thanks Jeff, as usual.

What was said in the above mentioned part. I have multiple MD11's, lets say, with different registrations. The code Lucas mentioned at the top of this thread works, but only shows for ONE registration of MD11, for instance; it does not lump all the MD11's into one, as I would want, to show the proper stats for all. Does that not make sense?!

Ok, that would be great, but how do I display the individual aircraft then? I would add what you just said into the "core/common/TouchdownStatsData.class.php" correct? Then what for the "core/modules/Touchdownstats/TouchdownStats.php" section? Sorry, I get lost too easy trying to follow

One question??? How do you combine the stats for ONE type of aircraft, when you have multiple registrations?? For instance, I have 5 different registration for the MD11. They do NOT show up under one total, for the purpose of the landing stats?! I tried to do: public function get_planemd11_stats($howmany) { $query = "SELECT pilotid, code, flightnum, depicao, arricao, aircraft, landingrate, submitdate FROM `".TABLE_PREFIX."pireps` WHERE landingrate < '0' AND Aircraft = '105,106,107,108,109' ORDER BY landingrate DESC LIMIT $howmany"; return DB::get_results($query); } Under the AND Aircraft = part, but it did not like that format. Is there a way to combine the same types??

Yes, works great

So, I need this update then?! It is like a "946A" then?!

What would I need to change to have just ONE column all the way down, instead of 2? Sorry, in other words.....A table that does not have 4 columns to it, just 2. I took out the second: echo '<th width="150px"><div align="left">Country Location</div></th>'; echo '<th width="100px"><div align="center">pilots</div></th></tr>'; But not sure what to take out of the rest?! And why do I need that "else" statement in there? As usual, it is something simple I am not grasping, I am sure

Now, from what I see.....I will have to change the core directory permission to 777 every time I update the schedule?! Never had to do that before. Is there something from my server crash I am missing then?!??

AWESOME!!!!! That is EXACTLY what I did. Changed the core file permission, uploaded the csv file, and changed the core folder back. Thanks a MILLION..... pun intended

I have. Believe me, I don't understand why it is doing it?! I had a server crash a couple months ago and all was corrected, to my knowledge. But I am having an issue now with this updating of the schedule. I assume you mean the core/cache directory for permissions. It is set correctly?!

When I try to use the admin panel, I get the above errors. When I manually add it into the SQL database, it seems to drop the CODE from my CSV file. Because of this, everything gets moved out of place. I have NO idea why this is happening this way. I can't figure why it would drop a field from the CSV file?!? Please......someone help, if you can. Thanks.

I changed over to my winter schedule, by importing it via my sql. I did this before, but now I get these errors?! Warning: move_uploaded_file(/home/woodsdom/public_html/CPC/core/cachecpc_schedules_Jan25.csv) [function.move-uploaded-file]: failed to open stream: Permission denied in /home/woodsdom/public_html/CPC/admin/modules/Import/Import.php on line 233 Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/php3HLTc1' to '/home/woodsdom/public_html/CPC/core/cachecpc_schedules_Jan25.csv' in /home/woodsdom/public_html/CPC/admin/modules/Import/Import.php on line 233 Warning: fopen(/home/woodsdom/public_html/CPC/core/cachecpc_schedules_Jan25.csv) [function.fopen]: failed to open stream: No such file or directory in /home/woodsdom/public_html/CPC/admin/modules/Import/Import.php on line 235 Warning: fgetcsv() expects parameter 1 to be resource, boolean given in /home/woodsdom/public_html/CPC/admin/modules/Import/Import.php on line 251 The import process is complete, added 0 schedules, updated 0, for a total of 0 Warning: unlink(/home/woodsdom/public_html/CPC/core/cachecpc_schedules_Jan25.csv) [function.unlink]: No such file or directory in /home/woodsdom/public_html/CPC/admin/modules/Import/Import.php on line 404 What have I missed?! I now have no schedules

Ok, maybe you can help me here..... I want to export my sql data to excel. I have basically done what you guys are talking about, by separating it in amounts of 3000, 5000, 10000. But once exported to .csv format, excel will NOT read it properly. Keeps saying too many rows or columns. I must be missing something simple here. I just want to be able to edit/correct the data in stages, to make one complete big file.

Sorry, but....what would I change to add an individual's map to their profile(profile_main.tpl) page? I want to show THEIR last number of flights there as well.

I want to add a table to the profile_main.tpl that lists all the different aircraft types a pilot has flow and how many hours they have logged for each. Have been off editing stuff for awhile and need a little nudge

It REALLY helps if the aircraft has a good paintkit already. Here are a couple links to how to paint: http://www.calclassic.com/repaint.htm http://www.leveldsim.com/forums/forum_posts.asp?TID=14159 (<------ You have to be a member of LevelD, though)

Awesome, thanks!

Nevermind. I forgot to change my database reference. I don't use the "phpvms_schedules" sql format on line 4. All good now. Thanks.

Hmmm.....I get this: "Warning: Invalid argument supplied for foreach() in ....../core/templates/topflights_main.tpl on line 6"

Yeah, they look A LOT ALIKE! That is a bit sad.

I can't remember where I started with a template. It was not one of the ones on here. I think it is the one used as a sample on the original traing videos for phpvms. Will take a look when I get home. Regardless, it has changed a lot since the early days.

I can't figure this out. Getting frustrated trying to understand the smf forums. I was here: http://www.simplemachines.org/community/index.php?topic=145838.0 could not make that work. I guess I am just getting overblown with data. My logic is simple......Can I not just add in header data to the "index_template.php" file of smf. I find the more I read, the more stupid it makes me. I need a break. Be back later.

I'll be honest with you Dave.......I have NO IDEA what I am doing here. Can I just use the .css from my main site or do I have to, kind of, combine the 2 to make one, if you know what I mean?!?

I was hoping I could just 'include' the core_navigation and footer files somehow.