Kalo
-
Posts
50 -
Joined
-
Last visited
Content Type
Profiles
Forums
phpVMS Resources
Downloads
Posts posted by Kalo
-
-
(I am using the latest official phpvms release, but I am only on php5.3 since it does not work on later versions (I coudln't get the phpvms forks to work with 5.5+))
thanks, mine is only located in /core/templates/pl. I replaced that file completely and got the error, then tried your fix on line 8 which made the page load properly but broke the previous functionality I had setup (showing top 100 pilots from most to least hours)(it would now load all 800 pilots by pilot ID).
It did show both airlines on the page but for the second airline it only showed pilots that were registered with that second airline. I was hoping it would be possible to list a pilot in both airline lists since they can submit pireps to each airline even though they can only register for one airline at a time(sorry that sounds confusing
). Basically I wanted to know if its possible to show Pilot X who registered with Airline A to appear in BOTH pilot lists for Airline A and B even though he is only registered to Airline A (because he submitted pireps to both Airlines).
I am trying to set this up because we will have a commercial airline and a general aviation airline, but I want to keep the pilot list of hours separate since as you can imagine commercial pilots rack up way more hours then general aviation pilots. We are pretty casual so I wanted a pilot who is registered in the commercial airline to also be able to submit pireps for the general aviation airline, and show up in both pilot lists for each airline.
Thanks for all the help, I have to call it a night, so I will check back in tomorrow.
-
I don't have lib/skins/YOURSKINNAME/pilots_list.php, so I tried replacing my files \core\template\pl\pilot_list.tpl and \core\modules\PilotList\PilotList.php and got these errors:
Parse error: syntax error, unexpected '[', expecting ')' in /home1/msflight/public_html/pilots/phpvms/core/templates/pl/pilots_list.tpl on line 8Parse error: syntax error, unexpected '[', expecting ')' in /home1/msflight/public_html/pilots/phpvms/core/modules/PilotList/PilotList.php on line 8 -
Thanks for the help, unfortunately I'm embarrassed to admit I'm not sure exactly where to paste in the airlines code/name.
I tried a few different spots without success...I'm sure its really simple and I have been starring right at it...but PHP is still like a foreign language to me -
Hello, if anyone would be able to help me create separate Pilot Lists for each airline it would be much appreciated! I am not very experienced with PHP but thanks to the help of Parkho in a previous thread I setup a pilot list that lists all pilots by hours here: http://www.msflights.net/pilots/phpvms/index.php/pilotlist
We have two airlines, one Commercial and one for General Aviation aircraft, I would like to create separate lists that show pilots by hours for each airline on separate pages. I'm not quite sure if it's possible to show flights/hours for each airline separately especially since we allow pilots to submit pireps for BOTH airlines even though they are signed up for only one.
These are my files for the pilot list so far:
\core\template\pl\pilot_list.tpl: http://pastebin.com/r4yWRUbt
\core\modules\PilotList\PilotList.php: http://pastebin.com/jXmDpVeb
\core\common\PilotListData.class.php: http://pastebin.com/mu2T5gkB
Thanks for any help!
-
I'm not sure if this is related, but whenever I try to access these forums by the main link on the phpvms homepage with my android device, my browser is overtaken by a spam sweepstakes scam. I tried 2 different browsers with the same result, and I also scanned my phone for viruses which it had none. This forum link is the only link I have seen this happen with my android device.
-
thanks for your help web, I decided I will unfortunately have to rent a separate server for phpvms so I can run php5.3 solely on that server. It's probably better to stick with the official release version anyways in case there ever is an update to phpvms.
-
In your local.config.php, is your DB_NAME the correct one and have you imported the table from the old database now?
Just need to clear some things up first.
Yes to both questions.
-
The pilots are showing up in admin center from my old database, all 500 or so. When I put that code into frontpage_main.php it listed all the pilots in a big paragraph format and shewed a bunch of code....it looked pretty messy.
-
Oh, I forgot to mention, go into core/logs/logs.txt and see if anything has been recorded.
Are the pilots showing up in the admin center? Were they before you imported?
If you open up the front page of you skin and for a test put this on it (you can remove it after)
Nothing is in logs. Pilots do show up in admin center. I'm not sure where to put the code you suggested, do you mean put it index.php all by itself? I tried that and got a white page. Thanks again.
-
thanks for all the help. My database connections were fine but I don't know much about all the other settings, I'll upload a copy of my local.config.php. I tried the above changes but the pilots list did not show on the website. I didn't make any changes to the database, but since there doesn't seem to be an "official" version, each version out there are slightly different sizes like the two links I referenced in post #1, so I'm not sure if I have the best version.
my local.config.php: http://pastebin.com/vARD4r6E
[/code]
-
Hi Kalo,
All I did to fix foreign key errors was to delete the table and let the create new table in the backup file re-build it.
In fact with the last few test server rebuilds after install a fresh copy of phpVMS I deleted all the tables and just let import of the backup file rebuild them all.
I tried this to, but got the above errors. It seems like the problems are because the phpvms php5.5 versions add all kinds of new fields to the tables. Do you think there's a version out there for php5.5 that uses only the default tables of phpvms without adding extra stuff?
-
hmmm,
Using the new database (not the original)
For the following, use phpMyAdmin
1. Export the pilots table
2. Go to the new database
3. Run this query in the SQL tab (near Import or Export, etc.)
SET FOREIGN_KEY_CHECKS=0; TRUNCATE phpvms_pilots;
This will effectively empty the new pilots table and reset the auto-increment
4. Import the data as usual
Still some errors:
when importing my old pilot table:
when I did the above to my old pilot table, but also added what you said to do in post #7 SET FOREIGN_KEY_CHECKS=0; before create table:
when re-importing phpvms5.5 default pilot table:
See if that works, if it doesn't, post your errors again and see if in the .sql file contains the following
-- -- Indexes for table `phpvms_pilots` -- ALTER TABLE `phpvms_pilots` ADD PRIMARY KEY (`pilotid`), ADD KEY `code` (`code`), ADD KEY `rank` (`rank`);
If it does, this may be conflicting with the import, so remove it and anything below it and then try the steps again.
A little success here! I could get both my old pilot table and the new unchanged pilot table to import...but now the pilot list shown on the webpage does not show pilots from the database @ /index.php/pilots (it's an empty list, even though in phpMyadmin it shows all pilots in the table in the old format...I guess because the fields are different?)
To get the phpvms5.5 default pilot table to import I had to delete from line 74 and down:
to get my old pilot table to import I had to add SET FOREIGN_KEY_CHECKS=0; before Creat Table like you said AND delete from line 824 and down:
-
this is kind of interesting, I exported a default pilots table and tried to import it without making any changes and I got the same error. Could there be some other problem since I cant even re-import the default tables it makes?
-
ah ok, it's a foreign key constraint failure, try opening the SQL file and place this before the CREATE_TABLE... or even running this before you import
thanks, hmm I got the same error with pilots table and a slightly different one with schedules. Did I put the foreign_key_checks in the right spot?
new schedules error:
-
try exporting the pilots table out of the original database and importing it into the new one and then if it gives you errors, post them here so we can take a look.
thanks, these are the errors I get when importing the pilots and schedules tables. Last picture is my import settings:
-
What you could do is export lets say the aircraft, airlines, airports, hubs, pilots, pireps, ranks and schedules table (as they have had minor changes) and then install the newer phpvms version into a different folder in your public_html, connect it to a different database (so technically you'd have two version running simultaneously with no conflict) and then import the tables above. No guarantees it will work, but theoretically it should import the data into the columns specified and I believe none have been removed, only added during the upgrade.
Remember to BACKUP first if you try this though.
If I understand you correctly I think I have done this already. I installed a fresh phpvms5.5 version into a fresh database...then I tried to import my old database. It gave me a bunch of errors I'm assuming because of the different table fields. I even tried importing individual tables like my old pilots or schedules tables into the fresh 5.5 database but that did not work either.
-
Does anyone know if there are any plans to make phpvms compatible with php5.4 or higher? I have found simpilots php5.5 version here https://github.com/V...rs/phpvms_5.5.x and here http://www.flyaka.co....5.x-master.zip but it seems it would be a nightmare to import my database from php5.3. There are lots of new fields added in tables preventing an import. Such as in the pilots table there is a new "payadjust" field. There are a bunch of new fields in the schedules tables, and probably a bunch of other tables as well.
Does anyone know if there's a php5.4+ version that uses all default tables? Or are there any plans for an official 5.4+ version?
-
put <div> before the opening of the table and </div> after the closing tag of the table.
hmm did not work...the table was very large did I put the <div>'s in the right spot? : http://pastebin.com/trJ0VxuR
-
I put up a tutorial on how to get pagination to work, and it should work there too. Have a look for topics made by me, you will know it when you see it.
Thanks, I tried your tutorial but could not get it to work. Here is my post in your tutorial: http://forum.phpvms...._20#entry110548
-
Hmm I haven't got it to work. Any suggestions?
I copied the three .js files to lib/js
i copies the images to lib/images
and I put the two template files to core/templates
This is what the top of my schedule_results.tpl file looks like:
http://pastebin.com/mftXxdxV I just used the default table listed in there which was named "tabledlist". Should I be editing tables somewhere else besides this schedule_results.tpl file?
And this is what my core_htmlhead.tpl js links looks like:
Thanks for anyhelp!
-
I would like to paginate the "View PIREPS" page in the Admin center where you are looking at individual pilot pages.
I have one pilot that has completed over 1300 PIREPS, and right now when I look at his PIREPS page to make edits, it takes a terribly long time to load because it is loading ALL 1300+ of his PIREPS on one page. If the page only showed 10 or 20 PIREPS per page it would be a lifesaver.
I was referred to FS Products website for a pagination module but I could not get it to work: http://fs-products.net/index.php/downloads/viewdownload/6-phpvms-modules/23-pagination-example
I copied the files into the correct areas, but there must be some kind of edits you have to make in the files them selves, which I do not know how to do (I do have dreamweaver to make these kind of edits). In addition, I believe this module may ONLY be for the public OPEN BIDS page, when I need the View Pireps page paginated in the ADMIN CENTER.
Would anyone be able to help me with this? Thanks!
P.S. Here is a picture of the PIREP page I would like paginated in case I did not describe it properly:
-
You want to paginate it. You can download it from Jeffs page (FS Products) - http://fs-products.n...-phpvms-modules
You can see how it looks on my site
Thanks for the recomendation, but I am having trouble getting this module to work. Are there any instruction around for it?
Do you have to edit the files somewhere to make them work on your site? Any tips would be apreciated! Thanks!
-
I had a sunnah.html in about 5 places on my ftp server (not just in the phpvms folder)
They had also replaced my content.php file for my vbulletin site.
I also found a log.php file that was not there before.
I got everything back to normal...lets hope it stays that way. Also for people wondering why they did this, I think they are hoping people will call them and pay them money to fix this problem.
-
thanks, but will this paginate the PIREPs in the Admin center as well? (not just the "open bids" page everyone can see)
I will give it a try later when I get home.
). Basically I wanted to know if its possible to show Pilot X who registered with Airline A to appear in BOTH pilot lists for Airline A and B even though he is only registered to Airline A (because he submitted pireps to both Airlines).
I tried a few different spots without success...I'm sure its really simple and I have been starring right at it...but PHP is still like a foreign language to me 
separate Pilot List per Airline?
in Support Forum
Posted
Would this only work for specific PIREPS you list or could you pull all PIREPS from that airline?