OneWorldVirtual
-
Posts
14 -
Joined
-
Last visited
Content Type
Profiles
Forums
phpVMS Resources
Downloads
Posts posted by OneWorldVirtual
-
-
Can anyone give me some advice on editing this module? A kick in the right direction would be very much appreciated!
Cheers,
DeeQ @ OWV
-
Great skin, looks really good on the test site, but when I upload it to mine, the blue header banners are missing as well as the black nav banner. Any ideas?
DeeQ @ OWV
-
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 21
STR: =================================================
SQL: The pilotshop table
=================================================
CREATE TABLE `phpvms_pilotshop` (
`id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`pid` INT( 15 ) NULL ,
`name` VARCHAR( 100 ) NULL ,
`shop_type` INT( 15 ) NULL ,
`product_type` INT( 15 ) NULL ,
`image_link` TEXT NULL ,
`description` TEXT NULL ,
`price` FLOAT NULL )
The pilotshop_types table
=================================================
CREATE TABLE `phpvms_pilotshop_types` (
`id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`type` INT( 1 ) NULL ,
`name` VARCHAR( 100 ) NULL ,
`description` TEXT NULL )
The pilotshop_bought table
=================================================
CREATE TABLE `phpvms_pilotshop_bought` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`pilot_id` INT( 11 ) NULL ,
`product_id` INT( 11 ) NULL )
SQL query:
The pilotshop table ================================================= CREATE TABLE `phpvms_pilotshop` ( `id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `pid` INT( 15 ) NULL , `name` VARCHAR( 100 ) NULL , `shop_type` INT( 15 ) NULL , `product_type` INT( 15 ) NULL , `image_link` TEXT NULL , `description` TEXT NULL , `price` FLOAT NULL ) The pilotshop_types table ================================================= CREATE TABLE `phpvms_pilotshop_types` ( `id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `type` INT( 1 ) NULL , `name` VARCHAR( 100 ) NULL , `description` TEXT NULL ) The pilotshop_bought table ================================================= CREATE TABLE `phpvms_pilotshop_bought` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `pilot_id` INT( 11 ) NULL , `product_id` INT( 11 ) NULL )
MySQL said: Documentation
#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 'The pilotshop table
=================================================
CREATE TA' at line 1
Any ideas anyone?
-
If you have removed the prieps, which it seems may be the case here, you will start to see many odd things happen. When the system updates a pilots time and hours it recalculates all the pireps, so if they are not there they will not be in the final figures.
Yeah thats what I figured. Thanks for the reply.
DeeQ @ OWV
-
Since the update to v2.0, there is an occasional time when a pilot uploads a PIREP and when it is approved the hours and flights reset to a lower number. For example, a pilot has 96.1 hours and 27 flights, uploaded 2 new ones taking him to 102.23 hours but instead it reset to 16 flights and 37.8 hours.
Is this a problem with the SQL database? we had to switch to a new one and port the info from the previous one, but I didn't move the PIREPS (because the flight numbers changed).
It's not really a big problem, as they can be manually edited obviously, but If anyone has any theories towards a resoloution then I'd be most grateful.
Cheers,
DeeQ @ OWV
-
I've come up with a cunning plan thanks for the input. Your the man
DeeQ @ OWV
-
Okay, but how do I embed the counter? the only referance i have is in javascript which is just gonna return an 'unexpected <' error or something i'm sure
-
Well, I had to disable GA through my hosting provider because it was interfering with the whole site, specifically the map and uploads (it was adding bunches of code onto outputs). Is there a way to do it without using GA entirely?
DeeQ @ OWV
-
Yeah I know this but GA interferes with our live map and FSPax uploading so it's a no-go. Thx anyway.
DeeQ @ OWV
-
I'm trying to add a basic hit counter to the main index.php page of our VA but i'm having no luck. I have a basic php counter installed but I can't seem to imbed it to the site.
Thanks in advance,
DeeQ @ OWV
-
Anyone got any ideas how to resolve this?
When checking the database connection durind the upgrade, I get this:-
Fatal error: Cannot redeclare class ezDB_mysql in /home/a8554731/public_html/phpvms/core/classes/ezDB_MySQL.class.php on line 315
Thanks in advance
DeeQ
-
I'm afraid not, since we upgraded to the beta the boxes no longer show up under FSACARS or XACARS. Previously, the flight info appeared below the map, but the aircraft icon was always a grey box instead of a red or green plane.
If there's any files you need to take a look at, i'll give you acces to our FTP server via whatever FTP client software you have. Just let me know where to mail the info if you need it.
Cheers,
Andy @ OWV
www.oneworldvirtual.com
-
We've been running the phpVMS system for a while now, and were originally able to get the live map to show grey squares only, along with the flight info listed below. We attempted to fix it with no success, so moved to the latest beta.
Now, the map shows up, but no flights appear either on the map or in the list below. Is there a step-by-step set-up guide for FSACARS or XACARS because no matter what we try, we get no results.
Many Thanks,
Andy Russell
One World Virtual
EXAMCenter Beta 1.0
in Simpilot Group Addons
Posted
Hi
This looks like a great project, but I have a small problem. The button that appears in the admin panel just closes the drop-down list it's in. The orange highlight bar is missing also from the mouse-over.
Cheers in advance,
DeeQ