Jump to content

McWilliams

Members
  • Posts

    10
  • Joined

  • Last visited

Everything posted by McWilliams

  1. May I suggest that you change the lime green text, it is very hard for me to read with the white background. Other then that good luck and Welcome to the Virtual Airline world
  2. Thanks for the the great layout, http://www.dlhvirtual.com we used it for our site and have heavily edited but Thanks for starting us off in the right direction A cool thing would be if the Partners Images were maybe a auto scroll image carousel.
  3. Update: I have found in Admin>Modules>Maintenance>Maintenance.php public static function resetpirepcount() { echo '<h3>Reset PIREP Counts</h3>'; $all_pilots = PilotData::findPilots(array()); foreach($all_pilots as $pilot) { $pireps = PIREPData::getReportsByAcceptStatus($pilot->pilotid, PIREP_ACCEPTED); $total = count($pireps); unset($pireps); $code = PilotData::getPilotCode($pilot->code, $pilot->pilotid); echo "{$code} - {$pilot->firstname} {$pilot->lastname} - {$total} pireps<br />"; # Update the pireps table PilotData::updateProfile($pilot->pilotid, array('totalpireps' => $total)); } echo 'Completed!'; } I changed this: # Update the pireps table PilotData::updateProfile($pilot->pilotid, array('totalpireps' => $total)); } To this: # Update the pireps table PilotData::updateProfile($pilot->pilotid, array('totalflights' => $total)); } Then when i run reset pirep count I get no more errors and the totalflights update just fine in the phpvms_pilots table and their profiles.
  4. Well I can tell you I have cleared the cache and it didn't help, also everyone can see the numbers aren't updating so I'm pretty sure its not my browser. I did do a little experiment since the Error (1054) is looking for a column called totalpireps in the phpvms_pilots table and there isn't one, I changed the totalflights column to totalpireps and hit reset pirep count and it updated all the profiles to the correct Total Flights. I did have to change the column back to totalflights for that to be shown, my question is why does it call for a column thats not even there? Also thanks for the answer.
  5. Hello, I know this has been discussed and I'm going assumed fixed in the latest version of phpvms, I've had a problem with my phpvms for the past 2 days now the total hours and total flights have not been updating at all before the 2/10/2014 they worked just fine. I've checked the DB it looks like the table is updating but if you run reset PIREP count it does re-count them but never updates the Pilot profile itself or the phpvms_pilot table. I did turn on debug mode and I will post what came up in the logs.txt here, I'm just really stumped as to why they won't update. The checks you normally ask someone who needs to run, I did that and they all came back as OK. I also sent an email to Jeff about the 1064 as I see the would kACARS in there so I assume he may know something about. ===== Time: 02.11.14 14:01:22 ===== Time: 02.11.14 14:01:22 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > kACARS->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='116.202.177.148' WHERE `pilotid`= Error: (1064) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ===== ===== ===== Time: 02.11.14 14:23:03 ===== Time: 02.11.14 14:23:03 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > kACARS->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='116.73.138.121' WHERE `pilotid`= Error: (1064) - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ===== ===== ===== Time: 02.11.14 14:25:29 ===== Time: 02.11.14 14:25:29 Backtrace: DB::write_debug > DB::get_row > OperationsData::getAircraftInfo > FinanceData::getLoadCount > PIREPData::populatePIREPFinance > PIREPData::fileReport > ACARSData::FilePIREP > kACARS->index > call_user_func_array > MainController::RunAllActions Query: SELECT * FROM phpvms_aircraft WHERE `id`=B77F - GOOD Error: (1054) - Unknown column 'B77F' in 'where clause' ===== ===== ===== Time: 02.11.14 20:08:45 ===== Time: 02.11.14 20:08:45 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalpireps`=16 WHERE `pilotid`=104 Error: (1054) - Unknown column 'totalpireps' in 'field list' ===== ===== ===== Time: 02.11.14 20:08:45 ===== Time: 02.11.14 20:08:45 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalpireps`=4 WHERE `pilotid`=107 Error: (1054) - Unknown column 'totalpireps' in 'field list' ===== ===== ===== Time: 02.11.14 20:08:45 ===== Time: 02.11.14 20:08:45 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalpireps`=24 WHERE `pilotid`=108 Error: (1054) - Unknown column 'totalpireps' in 'field list' ===== ===== ===== Time: 02.11.14 20:08:45 ===== Time: 02.11.14 20:08:45 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalpireps`=36 WHERE `pilotid`=109 Error: (1054) - Unknown column 'totalpireps' in 'field list' ===== ===== ===== Time: 02.11.14 20:08:45 ===== Time: 02.11.14 20:08:45 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalpireps`=87 WHERE `pilotid`=110 Error: (1054) - Unknown column 'totalpireps' in 'field list' ===== ===== ===== Time: 02.11.14 20:08:45 ===== Time: 02.11.14 20:08:45 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalpireps`=27 WHERE `pilotid`=114 Error: (1054) - Unknown column 'totalpireps' in 'field list' ===== ===== ===== Time: 02.11.14 20:08:45 ===== Time: 02.11.14 20:08:45 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalpireps`=9 WHERE `pilotid`=119 Error: (1054) - Unknown column 'totalpireps' in 'field list' ===== ===== ===== Time: 02.11.14 20:08:45 ===== Time: 02.11.14 20:08:45 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Maintenance->resetpirepcount > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `totalpireps`=15 WHERE `pilotid`=120 Error: (1054) - Unknown column 'totalpireps' in 'field list' ===== Regards, Chris McWilliams
  6. Hello, I would just like to introduce my self and update you guys on whats going on over at DLH Virtual. Well my name is Chris and I am the one who runs and builds the site for DLH Virtual, My first child was born the day after this VA started officially, so I take great pride in the VA as if it were part of my real family. Anyways on to DLH Virtual I would just like to say we have been VATSIM Approved recently, we are steadily moving forward to hopefully achieve what some of the other great VAs in here have achieved and we hope to become a team player on a higher level with all of you. So far we've been open for 4 months and we're hoping the wind doesn't stop blowing from beneath our wings anytime soon. We are always looking for pilots, and staff when needed. Any Questions I'd be happy to answer them. http://www.dlhvirtual.com Regards, Chris McWilliams
  7. Anyone willing to export navdata table?
  8. I just changed the template files that end with .php back to .tpl and it worked fine.
×
×
  • Create New...