Parkho

Hi As I mentioned in the first post, I wanted the "addbid" function to insert the aircraft into the bids table, so I added one column to the bids table and changed the code to insert the aircraft and that was successful as I checked the DB and the table was updated and the A/C was inserted. Then this problem came up that the "add to bid" link didn't change to "bid added" as it was supposed to, so I did check the code to see if it actually gave the Flase value in return but that didn't happen either meaning the function didn't return True value nor did return False value. All of these changes are for that i want to block the A/C with a unique id once the bid is placed, so that anyone else can't place the bid with that A/C.

Hi there Okay. Here is what I have changed in schedules.tpl and schedulesdata.class.tpl: public function addbid() { if(!Auth::LoggedIn()) return; $routeid = $this->get->id; $aircraft = $this->get->aircraft; <<<added this if($routeid == '') { echo 'No route passed'; return; } // See if this is a valid route $route = SchedulesData::findSchedules(array('s.id' => $routeid)); if(!is_array($route) && !isset($route[0])) { echo 'Invalid Route'; return; } CodonEvent::Dispatch('bid_preadd', 'Schedules', $routeid, $aircraft<<<added this); /* Block any other bids if they've already made a bid */ if(Config::Get('DISABLE_BIDS_ON_BID') == true) { $bids = SchedulesData::getBids(Auth::$userinfo->pilotid); # They've got somethin goin on if(count($bids) > 0) { echo 'bid exist'; return; } } $ret = SchedulesData::AddBid(Auth::$userinfo->pilotid, $routeid, $aircraft); CodonEvent::Dispatch('bid_added', 'Schedules', $routeid, $aircraft<<<<added this); if($ret == true) { echo 'Bid Added'; } else { echo 'Already in bids'; } } and: public static function addBid($pilotid, $routeid, $aircraft <<<<<<added this) { $pilotid = DB::escape($pilotid); $routeid = DB::escape($routeid); $aircraft = DB::escape($aircraft); if(DB::get_row('SELECT bidid, aircraft<<<<<added this FROM '.TABLE_PREFIX.'bids WHERE pilotid='.$pilotid.' AND routeid='.$routeid.' AND aircraft='.$aircraft)) { return false; } $pilotid = DB::escape($pilotid); $routeid = DB::escape($routeid); $aircraft = DB::escape($aircraft); $sql = 'INSERT INTO '.TABLE_PREFIX.'bids (pilotid, routeid, dateadded, aircraft<<<<<added this) VALUES ('.$pilotid.', '.$routeid.', NOW(), '.$aircraft.'<<<<<<added this)'; DB::query($sql); self::setBidOnSchedule($routeid, DB::$insert_id); if(DB::errno() != 0) return false; return true; } Also in schedulesresults.tpl: <td align="center"><a id="<?php echo $schedule->id.'added this>>>>>>&aircraft='.$schedule->aircraft; ?>" class="addbid" href="<?php echo url('/schedules/addbid');?>">add bid</a></td>

I changed the code of schedulesdata.class and schedules tpl in order to insert the aircraft into the bids. There is one part in the function that has to be returned true in order for the link to change but I'm not getting any false value either!

Thanks for the reply! IE and Fox are the same.

Hello All A while ago I posted a topic regarding a way to insert the A/C into the bids table and I figured out that part and was able to insert that value into the table. Now a new problem is come up and that's when I hit the "Add to bid" link it's supposed to change to "Bid Added" but it doesn't and when I look at the DB the bid was actually added with no problem. Some people were helping me out but they suddenly stopped responding and left me in the dark and I believe that has something to do with the browser but still can't figure out where the problem is. Please help with this issue I really appreciate it. Thanks

Hi here is my email : pkhorraminejad@gmail.com and explain what will you be needing. thanks

Okay! The first problem is that you want this add-on to search by airline and your current location because now it only shows you the scheds from your last location which is EHAM. Now I remember I changed the code to disregard the airline search in order for it to get scheds from current location since I don't have multiple airlines, so I will have to go over it to see if I can fix it. the second problem, just copy the following line without the description: Config::Set('JUMPSEAT_COST','.25'); That should kill the bug! thanks

eliminate, destroy, truncate, erase, etc.

Okay! do these steps: 1. Get rid of first install. 2. DL Second Zip and install it (sql table too if not yet installed). 3. let me know if there is still a problem. cheers

That's weird! Are you sure you added the code to LOCAL.CONFIG.PHP cause that's where it has to go. About the airline search, it's working on my site with no problem maybe you want to reinstall everything.

Hello there Okay! I've been trying to change the codes in a way to add the A/C id to the bids table in DB. Here is what i've done so far: 1- Added one column to bids table as "aircraftid". 2- changed the code in ScheduleData.class.php/ Add Bid section as follows: public function setBidOnSchedule($scheduleid, $bidid, $aircraftid) { $scheduleid = intval($scheduleid); $bidid = intval($bidid); [color="#FF0000"]$aircraftid = intval($aircraftid);[/color] $sql = 'UPDATE '.TABLE_PREFIX.'schedules SET `bidid`='.$bidid.' [color="#FF0000"]SET `aircraftid`='.$aircraftid.'[/color] WHERE `id`='.$scheduleid; DB::query($sql); if(DB::errno() != 0) return false; return true; } /** * Add a bid */ public static function addBid($pilotid, $routeid, [color="#FF0000"]$aircraftid[/color]) { $pilotid = DB::escape($pilotid); $routeid = DB::escape($routeid); $aircraftid = DB::escape($aircraftid); if(DB::get_row('SELECT bidid FROM '.TABLE_PREFIX.'bids WHERE pilotid='.$pilotid.' AND routeid='.$routeid.' AND aircraftid='.$aircraftid )) { return false; } $pilotid = DB::escape($pilotid); $routeid = DB::escape($routeid); $aircraftid = DB::escape($aircraftid); $sql = 'INSERT INTO '.TABLE_PREFIX.'bids (pilotid, routeid, dateadded) VALUES ('.$pilotid.', '.$routeid.', '.$aircraftid.', NOW())'; DB::query($sql); self::setBidOnSchedule($routeid, $aircraftid, DB::$insert_id); if(DB::errno() != 0) return false; return true; } 3- Changed the code in schedules.php as follows: public function addbid() { if(!Auth::LoggedIn()) return; $routeid = $this->get->id; $aircraftid = $this->get->id; if($routeid == '' && $aircraftid == '') { echo 'No route passed'; return; } // See if this is a valid route $route = SchedulesData::findSchedules(array('s.id' => $routeid)); if(!is_array($route) && !isset($route[0])) { echo 'Invalid Route'; return; } CodonEvent::Dispatch('bid_preadd', 'Schedules', $routeid); /* Block any other bids if they've already made a bid */ if(Config::Get('DISABLE_BIDS_ON_BID') == true) { $bids = SchedulesData::getBids(Auth::$userinfo->pilotid); # They've got somethin goin on if(count($bids) > 0) { echo '<img src="http://alvandair.com/lib/skins/aqua/images/BookingButt/Exist_.png" border="0">'; return; } } $ret = SchedulesData::AddBid(Auth::$userinfo->pilotid, $routeid, $aircraftid); CodonEvent::Dispatch('bid_added', 'Schedules', $routeid, $aircraftid); if($ret == true) { echo '<img src="http://alvandair.com/lib/skins/aqua/images/BookingButt/Booked.png" border="0">'; } else { echo '<img src="http://alvandair.com/lib/skins/aqua/images/BookingButt/Next.png" border="0">'; } } Now I need help since these changes doesn't insert the A/C id into the DB. Please tell me where I'm wrong. Thanks

Hi Michael Add this code to your local.config.php any where at the bottom. and set the price to whatever you want. # Jumpseat Ticket Cost Per NM Config::Set('JUMPSEAT_COST', '.25')//0.25 is now the rate change it to your desire ; Cheers

Hi Yes unfortunately that is the case but don't worry I'm working on it and soon it'll be resolved. I just removed the upload for the time being until it's fixed. Thanks

Hi All I played with code in realschedulelite_index.tpl and managed to get it to show only the airports with any aircraft available rather than the long list of all Airports. Here is how it looks: Just replace the realschedulelite_index.php with the one you have up and you should be good to go. Let me know if you have any problems. Cheers >>NOT WORKING YET!<<

Hi All I played with code in realschedulelite_index.tpl and managed to get it to show only the airports with any aircraft available rather than the long list of all Airports. Here is how it looks: Just replace the realschedulelite_index.php with the one you have up and you should be good to go. Let me know if you have any problems. Cheers core.zip

Hi I have a question. Is it possible to change the calculation of pilotpay in PIREP.class.data so that it calculates a percentage of the flight revenue instead of per hour pay? I appreciate any help. Thanks

Hi Is it possible to do a calculation based on a percentage of the revenue for pilotpay? meaning the pilot gets paid for example 0.03 % of the total revenue instead of per hour. Thanks

Unzip the folder and upload the contents in lib/images/ranks. remember that if you want to use them you need to create ranks and use the link of these images.

Thanks mark. You're a life saver.

Hello All I'm trying to change the country flags in lib/images/countries using the original namme.png but I still get the default flag even if I removed it. Any suggestions? Thanks

You're welcome. The pilot will be transfered once the PIREP is sent and right now I'm working on A/C transfer too and I will publish it when finished.

Hi there I think it might be a good idea to share the link to your VA's website here. Thanks

Thank you

Hi Add this to your profile_main.tpl: <li><a href="<?php echo SITE_URL?>/index.php/FrontSchedules">Book a Flight</a></li>

Sorry! Here it is www.alvandair.com