Support Forum
Any questions or bug reports go here.
7150 topics in this forum
-
- 1 follower
- 4 replies
- 2.3k views
Hello Guys, we in our Airline got our complete schedule in utc time. At the end of the Month we are switching to the "wintertime" and so we must reschedule all Flights. Is there an way that we can change all Flights in mysql to be set deptime -1 Hour ??? Thanks in advance for your help. BRGDS
Last reply by Thomasha, -
- 7 replies
- 3.1k views
Hi folks. Just getting back into the swing of things and I got a new domain for my website and tried to use Big Dump for the database and it failed. So i tired to do it manually via phpMyAdmin and it is not wanting to create several tables. Funny part is, it is the same server, but different domain name. I do not have any clue why it dont want to create them tables now. I went back to my old domain and created the same exact database and all info was imported successfully. Kinda odd huh? Heres one example. Its probably so dam simple that it is not even gonna be funny when I figure it out SQL query: CREATE TABLE `phpvms_fieldvalues` ( `id` int( 11 ) NOT NULL AUTO_I…
Last reply by Nabeel, -
Hi my phpvms_aircraft file has gone out of my mysql database please will some one export theres or is there another way? Thanks in advance Jacob
Last reply by Nabeel, -
- 13 replies
- 2.7k views
I am trying to run a CRON job containing the following commands: mysql_query("update pireps set rawdata='', log='', route='' where submitdate < DATE_SUB(NOW(), INTERVAL 3 MONTH)") or die(mysql_error()); mysql_query("update adminlog set id='', pilotid='', datestamp='', message='' where datestamp < DATE_SUB(NOW(), INTERVAL 1 MONTH)") or die(mysql_error()); mysql_query("update pirepcomments set id='', pirepid='', pilotid='', comment='', postdate='' where postdate < DATE_SUB(NOW(), INTERVAL 3 MONTH)") or die(mysql_error()); The first two lines appear to run OK. However the last line generates the following error: All suggestions welcomed
Last reply by Strider, -
- 4 replies
- 1.9k views
Hey, I'm trying to make an query to get all of the passenger loads columns from the PIREP tables. Here's the SQL Query i ran in our database manager SELECT SUM(load) AS passengers FROM pireps And I got the Query 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 'load) AS passengers FROM pireps' at line 1 Does anyone know why? I tried to sum the fuelused column and it worked, same query, but what the heck, why not to the loads column? Hopefully someone can shine in!
Last reply by Kyle, -
Hey everyone, I added fields on my pilot brief to have information such as arrival and departure gate listed, I changed the import.tpl but have no luck in getting the SQL file to take the gate number and post it back on the brief. I made it work once as then I imported the schedule again and it all got deleted. I'm going crazy trying to fix it. Can anyone please help me? Zeke
Last reply by ZekeElias, -
- 3 replies
- 1.7k views
Hi, I am writing a module to only display unique ICAO aircraft, this is what i have, /** * Get an aircraft by unique name */ public static function getAircraftByName1() { $sql = 'SELECT DISTINCT icao, fullname, weight, cruise, maxpax, maxcargo, imagelink, downloadlink FROM ' . TABLE_PREFIX . 'aircraft WHERE `enabled` = 1 '; return DB::get_results($sql); } That works fine, but when i try to add the range nothing is displayed so if i do, /** * Get an aircraft by unique name */ public static function getAircraftByName1() { $sql = 'SELECT DISTINCT icao, fullname, range, weight, cruise, maxpax, maxcargo, imag…
Last reply by mark1million, -
- 3 replies
- 2k views
Hello, I recently changed host for my VA, and I am currently trying to update my SQL tables to be the same as the old site. So I erased the contents of the database I created for the installation of phpvms, and imported a backup I made of my previous host's database. Now, here is my problem. Within PHPMyAdmin, if I select the pilot's table, I can see all of my old site's pilots, except when I go on the website and look at the pilot rooster, none of them appear. This goes for every single piece of data. Could my problem come from the way I created the backup, or does it come from the way I imported it? Looking forward to your help: Raphat
Last reply by Raphat, -
- 2 replies
- 1.6k views
Hello, I'm trying to solve a problem on my module, its a sql injection problem but I don't know to solve it since its a text field... Here its code: protected function add_request_post() { /* id pilotid schedule type */ if($this->post->id == '') { $this->set('message', 'Invalid Certificate specified'); $this->render('core_error.tpl'); return; } if($this->post->pilotid == '' || $this->post->schedule == '' || $this->post->type == '') { $this->set('message', 'You must write your schedules'); $this->render('core_error.tpl'); return; } $data = array( 'id'=>$this->post->id, 'pilotid'=>$this->post->pilotid, 'type'=&…
Last reply by Joaogl, -
Hi there, when I tried installing PHPVMS 5.6. I get the following error below Warning: mysqli::mysqli(): (HY000/1045): ProxySQL Error: Access denied for user 'id14765983_phpvms_install'@'2a02:4780:bad:f00d::4' (using password: YES) in /storage/ssd5/983/14765983/public_html/core/classes/ezdb/ezdb_mysqli.class.php on line 101 Fatal error: Uncaught <blockquote><font face=arial size=2 color=000099><b>Last Error --</b> [<font color=000000><b>ProxySQL Error: Access denied for user 'id14765983_phpvms_install'@'2a02:4780:bad:f00d::4' (using password: YES) (1045)</b></font>]<br />[<font color=000…
Last reply by Strider, -
- 5 replies
- 4.8k views
So, has anyone had the same issues with the navdat.sql file?! It does NOT show accurately where certain VOR's are, nor correct listings of fixes etc. For instance, MANY vor's don't list a correct latitude. It just will put a '0' in there. This is very prevalent in many U.S. vor's. So when someone flies a route, on the map, it shows the vor along the equator. Also, many FIX'es get listed as vors and vice versa, on the map. So what I am getting at, is.....did I do something wrong with the install, or is the navdata file just really bad?!
Last reply by Nabeel, -
hey all i need a quick help i want to change all my pilots on leave to retired as it seems the system is setting all retired pilots on leave how do i setup the sql query to change the numbers from 3 to 2 regards joeri
Last reply by mark1million, -
- 5 replies
- 2k views
I want to modify: public static function getAircraftInfo($reg) { $reg = DB::escape($reg); return DB::get_row('SELECT * FROM '.TABLE_PREFIX.'aircraft WHERE `registration` ='.$reg ); } so it will return the hours as well.. I have no idea how I am going to this so can someone please provide the code. Thanks, Mitch
Last reply by simpilot, -
- 2 replies
- 1.6k views
I noticed in the SQL database, that under active pilots, it showed a value of "2010" under pilots who have flown a flight. Ones who haven't had a "0". Is that normal or should they all be "0"??
Last reply by joeri, -
- 3 replies
- 1.7k views
Nabeel, I am using the command DB::get_row($query) to run a query on the database but it seems to limit the number of times I can run it on one page view to four..... Does this make any sense to you... after the fourth call it always comes back empty.... I can make it work using a standard sql select from the tpl file but do not want to do that.. you can see what I mean at the link below then click on KBOS http://www.simpilotgroup.com/dev/index.php/RealSchedule Here is the snippet public function get_next_flight($aircraft, $location) { $query = "SELECT * FROM ".TABLE_PREFIX."schedules WHERE aircraft='$aircraft' AND depicao='$location'"; return…
Last reply by Nabeel, -
- 13 replies
- 3.2k views
HI guys, When you delete a pilot from the admin I want to be able to edit that code to also update another field in my database, basically what i have is external authentication switched on for IPB, I have pilot id and the password and the account creation for the fourm, i also have a further check retired=0 so when i delete a pilot that has never flown i also want to update that field to retired preventing forum access. So to finally get to the point where does that code live and can i just reference it to the pilot id and update the retired column? Thanks.
Last reply by simpilot, -
Hi
Last reply by chris2, -
Hi Can anyone please show me how i can make a page in dreamwever, where a user can enter information, store it on the SQL database and then another page which shows the information? Many Thanks chris
Last reply by Sava, -
IMG 1 IMG 2 this is what i did, as far as uploading goes, do i have all the files right? because when i run the install i just shows this IMG 3 and when i run the check database i see this IMG 4 Thanks in advance, Theo
Last reply by Jeff, -
Quick question, is there a way to change all of the shortcuts in the admin panel to use https? I am looking into forcing ssl connections on the admin side. Thanks Tom
Last reply by t_bergman, -
- 3 replies
- 1.4k views
Hello, i have a small question can i install better phpvms stable version or beta? greets Michael Kraan
Last reply by michael Kraan, -
- 2 replies
- 1.6k views
HI all I hope I can write this so you can understand, http://transatlanticvirtual.org/index.php/pilots http://transatlanticvirtual.org/index.php/Toppilot above is our ranks and hours flying, there are 3 staff that I need to assign there ranks on the VA TVA0001, TVA0002, TVA0003 now the only way I can see, is to assign stupid hours transfered across for them to get the rank but is there a way I can just assign the rank with out transferring hours over ? and if so please help driving me mad showing incorrect hours example TVA0001 correct hours are 75.31 and not 31075.31 but it seems I can only award them hours to get the rank.. as you can see here. http://transa…
Last reply by mseiwald, -
- 1 reply
- 1.2k views
Hello guys, I have installed phpvms on my website and I have on the topbar 6 options: Home, Pilot Center, Pilots, Live maps, Admin Center, Log out. I would like to add "Staff" , how can I do this? Thank you. Rob
Last reply by in2tech, -
- 8 replies
- 2.2k views
Hi, in my company there are some Staff position like the Event Coordinator, Flight Operations Coordinator, Membership Coordinator etc. I want to know if is possible that the Flight Operations can see only the Airline Operations Section (in the admin center), or the Membership Coordinator can see only the Pilot & Group Section and the Pilot Report Section(in the admin center), for example!!!. There is also a tool for the Event Coordinator!? Tell me something please!!!! Best Regards Alessandro
Last reply by vancouverA380, -
- 4 replies
- 2.3k views
hi there is there any file or add on to make a page on my site for staff vacant position applying? just when someone want to apply he/she will redirected to page where will fill his information.i think you understand
Last reply by Connor1994, -
- 4 replies
- 1.5k views
I am wondering how VA's in the community rank staff members. For instance, staff, instructor, ceo, hub manager, etc. Are your staff members visible on the public ranks page? Thanks
Last reply by cfitz619, -
- 0 replies
- 1k views
It possible view the image country on my staff online ? ---------------------> look the picture http://qs.lc/o7p5 Thanks
Last reply by simonecatalano, -
Staff vs Pilot Permissions
by Guest- 1 reply
- 1.9k views
Hello, Is there a way to add a page on the VA site, linking to the admin panel, BUT pilots won't be able to see it, and staff wont have to type in the admin URL? Thanks! Jorge Rojas
Last reply by Jeff, -
- 2 replies
- 1.3k views
hello Nadeel the standard fuel pricing is 5.10... kg now my question whats the value of the 5.10 is it the current currency of the site or standard in $. gr joeri
Last reply by joeri, -
- 2 replies
- 2.4k views
Hi, I am starting a VA that is going to Simulate Widerøe and the airline's operations. I contacted the VA and I am waiting for approval for usage of logo's, name's etc. I wonder what other expences I have to keep in mind (if so, let me know) How to manage a VA, and if there is any services which help me program the page and perhaps how to it. Basicly I would like as much info as possible! Here is a summary of what I have planned: Domain - Buying from tfdi (VirtualWideroe.net) Hosting - Tfdi Smartcars v2 - Tfdi Web Design - a friend of mine I want the following things to be featured in my va: -Compatibility with Smartcars v2 -I want a login/register feature …
Last reply by VirtualWideroe,
