mischka
-
Posts
287 -
Joined
-
Last visited
Content Type
Profiles
Forums
phpVMS Resources
Downloads
Posts posted by mischka
-
-
Hey highflyer,
yes, you would use foreach, just like you would on any other "recordset". I posted the query assuming you'd know how to implement it in the code
the table_prefix variable should be already set in the config.php so you didn't have to change it.
-
2
-
-
here's the query I use:
$utc_now_str = gmdate("H:i");
$query= "SELECT ".TABLE_PREFIX."schedules.id, deptime, arrtime, code, flightnum, arricao, ".TABLE_PREFIX."airports.name destination, depicao, aircraft, ".TABLE_PREFIX."aircraft.icao equipment, bidid,
round( time_to_sec( timediff( time( str_to_date( deptime, '%H:%i' ) ) ,'".$utc_now_str."' ) ) /60, 0 ) timediff
FROM ".TABLE_PREFIX."schedules, ".TABLE_PREFIX."aircraft, ".TABLE_PREFIX."airports
WHERE code = 'EUR'
AND locate(dayofweek(convert_tz(now(),'+1:00','+0:00'))-1,".TABLE_PREFIX."schedules.daysofweek)>0
AND ".TABLE_PREFIX."schedules.arricao = ".TABLE_PREFIX."airports.icao
AND ".TABLE_PREFIX."schedules.aircraft = ".TABLE_PREFIX."aircraft.id
AND round( time_to_sec( timediff( time( str_to_date( deptime, '%H:%i' ) ) , '".$utc_now_str."' ) ) /60, 0 ) <60
AND round( time_to_sec( timediff( time( str_to_date( deptime, '%H:%i' ) ) , '".$utc_now_str."' ) ) /60, 0 ) > -15
ORDER BY timediff limit 12";
The timetable is on the frontpage of my VA.
-
come on nab, lmgtfy is brilliant
aside of that, I'm using phpvms for the new VA search engine that's currently under construction. Once you get your head around it, it's actually quite good piece of software to build on
-
1
-
-
great, thanks I'll give that a try!
-
Hmmmm.. I'm quite good in MD81's but about md5 I haven't got a clue lol
how about a random snapshot of 5 or 10 characters from the salt? that would be enough to identify the record but I suppose just a part of the salt wouldn't be enough to do anything, right?
-
Right... some time has passed by and it got a bit busy at my VA, so I've been up to other things. This project is not cancelled though!
So far, I've been thinking about a list of "features" to include in the search engine
- Supported simulators (Flightgear, FSX, FS9, X-plane)
- Airline name
- Airline description
- Inauguration date
- Type (Passengers/Cargo/Charter/Theme)
- Fictional airline (Yes/No)
- Aircraft restricted to ranks (Yes/No)
- Fleet
- ICAO region(s) covered (first letter of airport icao code, selectable from a map)
- Countries covered
- Jumpseat system (Yes/No)
- Entry exam (Yes/No)
- Vatsim (Not supported/Optional/Mandatory)
- IVAO (Not supported/Optional/Mandatory)
- ACARS system (None/kACARS/Xacars/FSacars/FK/VAF/Other
The way I envision it is that, when a pilot does a search, an airline gets a certain score based on the amount of criteria that match the search, and the results are then sorted by that score.
Let me know what you think guys
-
1
- Supported simulators (Flightgear, FSX, FS9, X-plane)
-
Hi Guys,
I'm currently contemplating a module to "validate" pilots with a validation email. You know the drill: you sign up for something, you get an email and then you click on the link and you get validated.
PHPvms currently doesn't support this - we only have the option to let everyone in or to manually validate people. So I thought this might be a good idea.
All I have to do is set pilots to not be automatically validated and then to write a module which validates them when clicking on a link.
Now, the question is, what to put in the link? I thought about the 'salt' field, which is unique for each user and also quite cryptic. Just putting a pilotid in the link wouldn't be secure enough.
But does this pose any security risks? I mean, if somebody knows the 'salt', could they use this to somehow decrypt passwords or something?
-
I have a vanilla forum and would take it again if I'd start a new VA. Its a bit different than usual forums but thats ok... the best thing is it has a "bridge" with phpvms so pilots dont need to create a separate account and can log in with 1 click once they are online on phpvms
note you have to install the bridge yourself, I think its a simpilot plugin if I remember correctly. Its a bit of work but you save your pilots a lot of hassle, which will ultimately bring more visitors.
-
It's strange that its a website of a german airline, presumably aimed at german pilots, but no german-language website.
it looks very pretty though! Let's see for how long
-
Maybe someone can explain me the point of railway simulators?
Do you get to drive for virtual railway companies?
-
No, My idea was more of a voting a airline airline search thing.
Now THAT would be a waste of time, since its exactly what va-list already does
the phpvms system(..) as it is not really suitable. In fact I can't see how you'd be able to do that without significant editing to the phpvms system.
Well, I'm earning a living with programming, so maybe I can see possibilities you can't
-
Although I must admit. I had an idea like this ages ago. Facebook can verify that as I created a group.
you crack me up... first saying an idea is bad and than saying you had that idea ages ago
I'm so tired with your bull**** .... go away!
-
2
-
-
Tom understood very well and said most important things in a nutshell. However I'd like to elaborate a bit more on this.
While VA-list certainly provides hits and signups for VA's (ie it serves our needs as CEO's) the downside is that if you're not on the first page you almost get no traffic from it. People sooner reach for google than go through 20 entries on va-list. This is not what I think or believe: I can see it in my website stats!
This is why va-list doesn't quite completely and effectively fill the needs of pilots. Pilots are not interested in how many votes an airline has. When looking for a VA a pilot generally looks for:
- certain airport(s) he likes to fly to, or certain regions.
- certain aircraft he likes to use and/or has installed
- a certain simulator he uses
- other features, like he may come from a VA with a jumpseat arrangement and he doesn't want that, or the other way around.
For example, somebody who only uses flightgear would have to trawl through quite a few VA-list entries and possibly also websites to find out the VA is best for him. At my website he'd just select "flightgear" and whatever other criteria he needs, and he gets a list of VA's that suit his needs. THEN he can look for features, size or whatever.
Really, the amount of votes or a score on phpvms doesn't say much about the airline except it's size. It'd be much better to have a kind of "ISO certificate" for an airline, which airlines only get when certain quality criteria are met. Lack of spelling mistakes, for example, or a CEO that doesn't start new VA's every other day
This is certainly something I'll look into later on. You do not need to put a list of your Schedules as it will never be up to date
The import of schedules will not serve as a VA-wide schedule search (although it might be an idea) but rather to facilitate an easy way for CEO's to enter their featured airports and aircraft. Nobody will want to click/select 100 or more airports and aircraft from a list!
In other words its advertising that encourages pilots to leave when they get bored and then find another airline.
I don't see why this would accelerate bored pilots leaving more quickly than they do already. If they are bored, they will leave. Pilots who stay with you just because they can't find a better airline are pretty useless.
Do it if you want. But I won't be signing up for it.
I'm quite sure this search engine will be a success and a welcome addition to the VA world.
I foresee a stealthbird begging at my virtual door to be let in when everyone else signed up
-
1
-
-
the discrepancy between my plan and the concept of va-list has clearly passed by you, stealthbird
-
1
-
-
basicly what I meant is when I click "stop flight" I want to be able to click "start flight" again without having to clear and re-query the bid, at least until pushback commences... but I suppose I'm the only one.
in which language did you program kacars?
-
nice new site, well done!
One idea for kacars might be that if you have to stop the flight tracking in kacars for whatever reason, before pushback, you can start it again without having to re-load the bid and pop in the flightlevel. I had it a few times that I've had to stop the sim and start it again and having to re-do kacars is "one of those annoyances" at a stage when ur already annoyed cause things dont go as they should.
Also, it'd be great to have a time-out setting for the connection to the FS.. sometimes when my pc gets very busy the kacars times out and when u dont notice (eg on fullscreen) then its a huge problem.
Another thing... right now the flight time is calculated from the moment you start tracking till the moment you arrive. The flight time should rather start from the moment you push back though (block time) like xacars does it, for example.
anyway, apart of it it's a great product.. good luck for the future of kacars!
-
True but this is more for the smaller type flights Props and regional type flights. And when you fill up your gas tan for your at the pump you don't drain out the gas you don't use. your using what you pay for
yeah, but the amount of V$ that is charged to the airline is not what you fill into your virtual tanks before departure, it's what your aircraft actually consumes.
Also, unlike in real life, its not a given that an aircraft departs from the same airports as it last landed ... at least at most VA's... so while your idea is nice, I don't think it applies to virtual aviation!
-
I've been thinking for some time now about making a search engine for virtual airlines, but before starting development I'd like to have some feedback
what I have in mind is a phpvms based site where VA's can register and upload their schedules file. From this the site then knows where the VA flies and with which aircraft.
Apart of this there would be a small questionnaire to fill out about the features they provide eg is there a jumpseat system, type of simulator, cargo or pax, how many minimum hours, free to fly any aircraft or restricted by rank... you know, the kind of stuff that really matters to a pilot who chooses an airline
I haven't found anything like this on the web. IMHO vacentral isn't useful for pilots who look for an airline and I personally had no registrants from there. From my experience and reading the forums, pilots select an airline based on the airports/region and aircraft they can operate at that va, and of course the general "idea" of the airline.. not whether it has a certain rank in relation to other va's
I personally think this could be a useful site both for va's as well as pilots, but maybe im the only one
Let me know!
-
12
-
-
Hehe, the opening post reminds me of the movie "snakes on a plane"
I personally like travelling to foreign countries, which is not hard cause once I press the accelerator of one of my Beemers I'm out of this tiny country in no time
I cherish my bmw's; an '89 525 and an '90 850i and they want to be not only driven but also repaired lol I also frequently travel by plane as I tend to go on holidays 2-3 times a year I also like doing DIY stuff like building my own furniture, but haven't had much time this year.
Apart of it, when I'm at home and not flying my time is divided between my friends, my girlfriend, and my books
oh, what a miserable life!
-
It's st. Maarten, not st Marteen!
Also, the snowflakes are a tad annoying, as is the fact that i had to copy & paste the url because you didn't create a proper link.
Not to mention plagiarism of sava's site.... not good!
-
I think if you go to "show all pireps" in the admin section, it'll let you remove it. at least it was like this with a va I used to manage before
-
Then again, I wonder why the thread-starter even signed up with the airline and not made any flights?
-
Why not set up a separate email account for your va and send individual mails via that? In gmail you can specify different accounts to use as "from" address, and I assume other providers provide this feature as well.
-
I think it looks sweet. If i'd be a pilot looking for a new va I wouldnt care much about colors, but I'd be interested to know whats your fleet, your destinations, rank thresholds and if you have certain rules and regulations. all these things are not really visible from your homepage
Departure board
in Support Forum
Posted
@parkho: Well, normally if you click on the flight number on my departure board you get to the flight info page, where logged-in pilots can place a bid
that's ok... I never did anything with PHP before I started working on phpvms. I kinda learned php because phpvms is written in it and now, 6 months later, my phpvms is very different from the stock phpvms
Once I get my VA search engine working, I'll start publishing some of the "add-ons" I made for PHPvms, but until then I think you'll have to crawl the web and learn php yourself
or you may try this: http://www.utr-onlin...ware.asp?page=7