Hi Guys,
What im trying to do is when a manual PIREP is submitted on my website I need the arricao to go into a custom field in my aircraft table called location. I have tried changing this section in PIREPData.class.php but it don’t work:
$sql = "INSERT INTO ".TABLE_PREFIX."pireps(
`pilotid`,
`code`,
`flightnum`,
`depicao`,
`arricao`,
`location`,
`route`,
`route_details`,
`distance`,
`aircraft`,
`flighttime`,
`flighttime_stamp`,
`landingrate`,
`submitdate`,
`accepted`,
`log`,
`load`,
`fuelused`,
`expenselist`,
`source`,
`pob`,
`exported`,
`rawdata`)
VALUES ( {$pirepdata['pilotid']},
'{$pirepdata['code']}',
'{$pirepdata['flightnum']}',
'{$pirepdata['depicao']}',
'{$pirepdata['arricao']}',
'{$pirepdata['arricao']}',
'{$pirepdata['route']}',
'{$pirepdata['route_details']}',
'{$pirepdata['distance']}',
'{$pirepdata['aircraft']}',
'{$pirepdata['flighttime']}',
'{$flighttime_stamp}',
'{$pirepdata['landingrate']}',
NOW(),
".PIREP_PENDING.",
'{$pirepdata['log']}',
'{$pirepdata['load']}',
'{$pirepdata['fuelused']}',
'0',
'{$pirepdata['source']}',
'{$pirepdata['pob']}',
{$pirepdata['exported']},
'{$pirepdata['rawdata']}')";
Any Ideas how to simply put the arricao in the arricao field and in my extra location field in my SQL table?
Many Thanks
Scott