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)
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.
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
What about the bids database table of your phpVMS website? You can review it using phpmyadmin.
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
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).
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