Moderators ProSkyDesign Posted February 4, 2017 Moderators Report Share Posted February 4, 2017 Hi, i'm using phpvms 5.3 (crewcenter.travelskyalliance.com) and when I tried to delete a bid from smartCARS, it is delete in the acars but no in the webpage... And now he flights mark as "bidded" (Reservado) but these flights aren't bidded... How can I delete these fake or ghost bids? ... Sql? (Look attached screen) Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted February 6, 2017 Moderators Report Share Posted February 6, 2017 Could you please let us know if you can view the bids in your admin center? admin center -> pilots & groups -> view bids If yes, then I believe that your acars system did not deleted the bids. Quote Link to comment Share on other sites More sharing options...
Moderators ProSkyDesign Posted February 6, 2017 Author Moderators Report Share Posted February 6, 2017 5 hours ago, servetas said: Could you please let us know if you can view the bids in your admin center? admin center -> pilots & groups -> view bids If yes, then I believe that your acars system did not deleted the bids. No, I can't.... The bids aren't in bids admin center when a pilot delete it from SmartCARS Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted February 6, 2017 Moderators Report Share Posted February 6, 2017 What about the bids database table of your phpVMS website? You can review it using phpmyadmin. Quote Link to comment Share on other sites More sharing options...
Moderators ProSkyDesign Posted February 7, 2017 Author Moderators Report Share Posted February 7, 2017 8 hours ago, servetas said: What about the bids database table of your phpVMS website? You can review it using phpmyadmin. I removed all bids from sql but still continue the problem Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted February 7, 2017 Moderators Report Share Posted February 7, 2017 Are the bids shown in your website? If yes, I would suggest pasting the part of code which shows the bids to identify the source of the data (considering that you have empty the bids table). Quote Link to comment Share on other sites More sharing options...
Moderators ProSkyDesign Posted February 7, 2017 Author Moderators Report Share Posted February 7, 2017 9 hours ago, servetas said: Are the bids shown in your website? If yes, I would suggest pasting the part of code which shows the bids to identify the source of the data (considering that you have empty the bids table). <div id="mainbox"> <h3>Vuelos Reservados</h3> <?php if(!$lastbids) { echo '<p align="center">No hay vuelos reservados</p>'; return; } ?> <table class="table table-striped"> <thead> <tr bgcolor=""> <th height="25" width="15%"><div align="center">Vuelo</div></th> <th height="25" width="13%"><div align="center">Origen</div></th> <th height="25" width="13%"><div align="center">Destino</div></th> <th height="25" width="20%"><div align="center">Piloto</div></th> <th height="25" width="15%"><div align="center">Avión</th> <th height="25" width="12%"><div align="center">Matrícula</div></th> </tr> </thead> <tbody> <?php foreach($lastbids as $lastbid) { ?> <tr bgcolor=""> <td height="25" width="15%" align="center"><?php echo $lastbid->code . $lastbid->flightnum; ?></a> </td> <td height="25" width="13%" align="center"><span><?php echo $lastbid->depicao; ?></span></td> <td height="25" width="13%" align="center"><span><?php echo $lastbid->arricao; ?></span></td> <?php $params = $lastbid->pilotid; $pilot = PilotData::GetPilotData($params); $pname = $pilot->firstname; $psurname = $pilot->lastname; ?> <td height="25" width="20%" align="center"><span><?php echo $pname; ?> <?php echo $psurname; ?></span></td> <td height="25" width="15%" align="center"><span><?php echo $lastbid->aircraft; ?></span></td> <td height="25" width="12%" align="center"><?php echo $lastbid->registration?></td> </tr> <?php } ?> </tbody> </table> <hr> </div> frontpage_recentbids.tpl 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.