ARV187
-
Posts
260 -
Joined
-
Last visited
-
Days Won
2
Content Type
Profiles
Forums
phpVMS Resources
Downloads
Posts posted by ARV187
-
-
I have a problem with frontpage, swf not work. You can see the test page here: http://sparkadsl.0lx.net/phpvms/
I dont have idea about this question, I would appreciate someone help me please.
Frontpage_main.tpl
<!--mi codigo script swfobject empieza aqui--> <script type="text/javascript" src="js/swfobject.js"></script> <script type="text/javascript"> var flashvars = {}; flashvars.xml_file = "photo_list.xml"; var params = {}; params.wmode = "transparent"; var attributes = {}; attributes.id = "slider"; swfobject.embedSWF("sparkadsl.0lx.net/phpvms/lib/skins/templatemo_254_agency/flash_slider.swf", "flash_grid_slider", "930", "250", "9.0.0", false, flashvars, params, attributes); </script> <body> <div id="templatemo_banner_wrapper"> <div id="templatemo_banner"> <div id="flash_grid_slider"> <a href="http://www.flashmo.com/preview/flashmo_224_grid_slider" target="_blank"> Flash XML Grid Slider </a> <br /><br /> <a href="http://www.adobe.com/go/getflashplayer"> <img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /> </a> </div> </div> </div> <!--mi codigo script swfobject termina aqui--> <div id="mainbox"> continue.........
-
I finish it! but i have trouble with slider flash images. I need help, but i go to open other post to see if this way anyone can help me.
To clear somethings to newbies:
Im not a expert, i learn since cero.
You have two files in front page (index.html), the index.html is in blank, because in that page the phpvms show this two files: layout tpl & frontpage_main.tpl
Layout.tpl show header and footer in all pages, is this: top banner or company logo, menus, & credits at final of page.
frontpage_main.tpl modify the content of frontpage (index.html page) this is news, recent pilots pireps, recent new pilots, and other that you want put in.
And by last you have the xxxxxxxxxx_style.css this put the form, color, and position of all web site. Have the <id> tag names and your especifications. you can add a <id> tag with properties, and after link it with a <id> tag in your frontmain_page.tpl or other template.
For example
<id= "live_table">
</id>
In xxxxxxxxxxx_styles.css:
#live_table
I recommend "firebug" to learn in live about styles.css and a editor web with grafical interface & code in same site to see the changes.
-
This code is right? not work to me.
<div id="mainbox"> <?php // Show the News module, call the function ShowNewsFront // This is in the modules/Frontpage folder MainController::Run('News', 'ShowNewsFront', 5); ?> <script type="text/javascript" src="js/swfobject.js"></script> <script type="text/javascript"> var flashvars = {}; flashvars.xml_file = "photo_list.xml"; var params = {}; params.wmode = "transparent"; var attributes = {}; attributes.id = "slider"; swfobject.embedSWF("flash_slider.swf", "flash_grid_slider", "930", "250", "9.0.0", false, flashvars, params, attributes); </script> <body> <div id="templatemo_banner_wrapper"> <div id="templatemo_banner"> <div id="flash_grid_slider"> <a href="http://www.flashmo.com/preview/flashmo_224_grid_slider" target="_blank"> Flash XML Grid Slider </a> <br /><br /> <a href="http://www.adobe.com/go/getflashplayer"> <img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /> </a> </div> </div> </div> </body> </div> <div id="sidebar">
-
Slider flash not work,Definitely i dont know where put it.
layout.tpl
<?php /** * * STOP!!!!!!!! * * Are you editing the crystal skin directly? * DON'T * * Copy and rename the crystal folder. Otherwise it'll get * overwritten in an update. * * Also, READ THE DOCS * * http://www.phpvms.net/docs/skinning * */ ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <meta http-equiv="X-UA-Compatible" content="IE=7"> <title><?php echo $page_title; ?></title> <link rel="stylesheet" media="all" type="text/css" href="<?php echo SITE_URL?>/lib/skins/templatemo_254_agency/templatemo_style.css" /> <?php /* This is required, so phpVMS can output the necessary libraries it needs */ echo $page_htmlhead; ?> <?php /*Any custom Javascript should be placed below this line, after the above call */ ?> </head> <body> <?php echo $page_htmlreq; ?> <div id="body"> <div id="templatemo_header_wrapper"> <div id="templatemo_header"> <div id="site_title"> <h1><img src="http://sparkadsl.0lx.net/phpvms/lib/skins/templatemo_254_agency/images/topbanner.jpg" alt="Argavirtual" /><span></span></h1> </div> <!-- end of site_title --> <div id="templatemo_banner_wrapper"> <div id="templatemo_banner"> </div> </div> <div id="topLogin"> <?php /* Quick example of how to see if they're logged in or not Only show this login form if they're logged in */ if(Auth::LoggedIn() == false) { ?> <form name="loginform" action="<?php echo url('/login'); ?>" method="post"> Sign-in with your pilot id or email, or <a href="<?php echo url('/registration'); ?>">register</a><br /> <input type="text" name="email" value="" onclick="this.value=''" /> <input type="password" name="password" value="" /> <input type="hidden" name="remember" value="on" /> <input type="hidden" name="redir" value="index.php/profile" /> <input type="hidden" name="action" value="login" /> <input type="submit" name="submit" value="Log In" /> </form> <?php } /* End the Auth::LoggedIn() if */ else /* else - they're logged in, so show some info about the pilot, and a few links */ { /* Auth::$userinfo has the information about the user currently logged in We will use this next line - this gets their full pilot id, formatted properly */ $pilotid = PilotData::GetPilotCode(Auth::$userinfo->code, Auth::$userinfo->pilotid); ?> <img align="left" height="50px" width="50px" style="margin-right: 10px;" src="<?php echo PilotData::getPilotAvatar($pilotid);?>" /> <strong>Pilot ID: </strong> <?php echo $pilotid ; ?> <strong>Rank: </strong><?php echo Auth::$userinfo->rank;?><br /> <strong>Total Flights: </strong><?php echo Auth::$userinfo->totalflights?>, <strong>Total Hours: </strong><?php echo Auth::$userinfo->totalhours;?> <br /> <a href="<?php echo url('/pireps/new');?>">File a New PIREP</a> | <a href="<?php echo url('/schedules/bids');?>">View My Bids</a> | <a href="<?php echo url('/profile/');?>">View Pilot Center</a> <?php } /* End the else */ ?> </div> <div id="templatemo_menu"> <ul> <?php /* You can modify this template into a table or something, by default it's list elements inside of a UL. Here's a link with some info: http://articles.sitepoint.com/article/css-anthology-tips-tricks-4/2 */ Template::Show('core_navigation.tpl'); ?> </ul> </div> <div id="bodytext"> <?php /* This will insert all of the "meat" of the page in there - the template which is generated, depending on which page you're on. To change these templates, check out the docs on the site. They're under the /core/templates folder, and to change them, copy them into the folder of your skin (the folder this file is in right now. */ echo $page_content; ?> </div> </div> <div id="footer"> <p>Copyright © 2007 - <?php echo date('Y') ?> - <?php echo SITE_NAME; ?><!-- Please retain this!! It's part of the phpVMS license. You must display a "powered by phpVMS" somewhere on your page. Thanks! --> <a href="http://www.phpvms.net" target="_blank">powered by phpVMS</a> </p> <p>Copyright © 2013 <a href="http://argavirtual.weebly.com/">Argavirtual</a> | Designed by <a href="https://sites.google.com/site/fsxworldspain/" target="_parent">ARV187</a> | With <a href="http://www.templatemo.com/page/1">CSS Templates</a></p> </div> </div> </body> </html>
frontpage_main.tpl
<div id="mainbox"> <?php // Show the News module, call the function ShowNewsFront // This is in the modules/Frontpage folder MainController::Run('News', 'ShowNewsFront', 5); ?> <script type="text/javascript" src="js/swfobject.js"></script> <script type="text/javascript"> var flashvars = {}; flashvars.xml_file = "photo_list.xml"; var params = {}; params.wmode = "transparent"; var attributes = {}; attributes.id = "slider"; swfobject.embedSWF("flash_slider.swf", "flash_grid_slider", "930", "250", "9.0.0", false, flashvars, params, attributes); </script> <body> <div id="templatemo_banner_wrapper"> <div id="templatemo_banner"> <div id="flash_grid_slider"> <a href="http://www.flashmo.com/preview/flashmo_224_grid_slider" target="_blank"> Flash XML Grid Slider </a> <br /><br /> <a href="http://www.adobe.com/go/getflashplayer"> <img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /> </a> </div> </div> </div> </body> </div> <div id="sidebar"> <!--mi codigo va-central empieza aqui--> <H3>Ranking VaCentral</h3> <Strong><font color="#FF6734" size="3"> <?php $cws = new CodonWebService(); $xml = $cws->get('http://www.vacentral.net/airline/xml/arv_argavirtual'); $xml = simplexml_load_string($xml); echo "Estamos en el puesto nº: {$xml->rank}"; ?></strong></font> <a href="http://www.vacentral.net/airline/arv_argavirtual" target="_blank"><img src="http://sparkadsl.0lx.net/phpvms/lib/images/VaCentral.JPG" width="125" height="40" /></a> <!--mi codigo va-central termina aqui--> <h3>Informes recientes</h3> <?php MainController::Run('PIREPS', 'RecentFrontPage', 5); ?> <h3>Nuevos pilotos</h3> <?php MainController::Run('Pilots', 'RecentFrontPage', 5); ?> <h3>Usuarios Online</h3> <p><i>Han sido <?php echo count($usersonline)?> usuario(s), y <?php echo count($guestsonline);?> invitado(s) online en los ultimos <?php echo Config::Get('USERS_ONLINE_TIME')?> minutos.</i></p> <?php /* $usersonline also has the list of users - really simple example Or if you're not on the frontpage: $usersonline = StatsData::UsersOnline(); foreach($usersonline as $pilot) { echo "{$pilot->firstname} {$pilot->lastname}<br />"; } */ ?> </div>
-
I have a problem, in dreamweaver the slider work, but not in web page, in adition the page is in line, main menu, not lateral panel of last pireps, etc. I only modified layout.tpl
¿Any idea?
In dreamweaver:
In web page:
P.D: Im changin relatives urls by absolutes. but the linear menus... i dont know the cause of that.
-
Finally im fighting with default layout.tpl and copying the templatemo index.htm code.
-
I find a simple code in this forum to live traffic table, and where add gif images, but i still need help to customice the phpvms.
I have read that files to edit are layout.tpl & frontpage_main.tpl, want apply this template: http://www.templatemo.com/preview/templatemo_254_agency
But i dont know what steps i have to follow.
Im editing index.html of template following the default phpvms layout.tpl, and after i will renamed it how layout.tpl, but i dont know if is rigth, or how hell make it. I want make it by my self, and i dont want pay to others, i want learn, only need help with steps to follow.
Thanks again & regards
-
27 views and not answers? i have much post with not answers, only parkho answer me to one, im sad... If is by my bad english im sorry.
I have the table ready, but i want make a principal page, with table, image slider, etc, etc, but i dont know yet which file i should edit.
And i have a trouble, my server is banned by google adsenses, so i dont kwon if i can make a principal page in a adsense compatible site and that live table work in a diferent site of installation or how make that.
-
Hi again, i saw this table: http://www.italianiv...t/iv/index.php/ Live Flight Information,
i love it!
How i can made it?
Another doubt is what is the template or php file to change the index page? i want custom it, the index.php isn't i think, so what is? may be front_page.php?
Thanks you very much to yours future answers!
-
I deleted my database from phpmyadmin and now is showing the schedules, but not airports in admin page.
-
Sorry Parkho, i dont see this answer, my virtual airline boss said me return to normal phpvms and work.
Anyway i think that there entry wasn't duplicated, could be another issue?
P.D: really what is phpvms extended? is a underground versión? not is the same that official, why?
-
The flights operates all days, in normal web page and normal database (not test web & DB) all work.
Anyway, in admin/index.php/operations/schedules is where dont show. I can add bid how a normal pilot, etc. but schedules & airports not is showing in /admin/schedules & airports page.
-
I have the same problem in a web & database to make test apart of original web, i imported all files with ftp and DB from phpmyadmin, all work well, local.config was changed correctly, but in admin panel, airports & schedules routes not show, as if they did not exist, but they are in Database, in phpmyadmin.
-
Hi, normally we have this errors in log file, how i can fix it?
thanks!
===== Time: 03.20.13 04:58:22 ===== Time: 03.20.13 04:58:22 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='83.53.112.115' WHERE `pilotid`= 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 '' at line 1 ===== ===== ===== Time: 03.20.13 11:25:28 ===== Time: 03.20.13 11:25:28 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='83.32.189.60' WHERE `pilotid`= 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 '' at line 1 ===== ===== ===== Time: 03.20.13 11:28:28 ===== Time: 03.20.13 11:28:28 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='95.20.213.42' WHERE `pilotid`= 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 '' at line 1 ===== ===== ===== Time: 03.20.13 13:08:39 ===== Time: 03.20.13 13:08:39 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='95.20.213.42' WHERE `pilotid`= 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 '' at line 1 ===== ===== ===== Time: 03.20.13 13:23:51 ===== Time: 03.20.13 13:23:51 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='87.221.212.64' WHERE `pilotid`= 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 '' at line 1 ===== ===== ===== Time: 03.20.13 13:34:09 ===== Time: 03.20.13 13:34:09 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByExportStatus > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE p.exported = '0' ORDER BY p.submitdate DESC Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 13:34:09 ===== Time: 03.20.13 13:34:09 Backtrace: DB::write_debug > DB::get_results > StatsData::UsersOnline > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.* FROM phpvms_pilots p, phpvms_sessions s WHERE s.pilotid = p.pilotid AND DATE_SUB(NOW(), INTERVAL 20 MINUTE) <= s.`logintime` Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 13:34:09 ===== Time: 03.20.13 13:34:09 Backtrace: DB::write_debug > DB::get_results > StatsData::GuestsOnline > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT s.* FROM phpvms_sessions s WHERE s.pilotid = 0 AND DATE_SUB(NOW(), INTERVAL 20 MINUTE) <= s.`logintime` Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 13:34:09 ===== Time: 03.20.13 13:34:09 Backtrace: DB::write_debug > DB::get_row > SettingsData::getSettingValue > StatsData::TotalHours > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 16:21:32 ===== Time: 03.20.13 16:21:32 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='95.20.213.42' WHERE `pilotid`= 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 '' at line 1 ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByExportStatus > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE p.exported = '0' ORDER BY p.submitdate DESC Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > StatsData::PilotCount > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT COUNT(*) as `total` FROM phpvms_pilots Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_row > StatsData::TotalFlights > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT COUNT(*) AS `total` FROM `phpvms_pireps` WHERE `accepted`=1 Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_row > SettingsData::getSettingValue > StatsData::TotalHours > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > StatsData::TotalMilesFlown > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT SUM(`distance`) AS `total` FROM phpvms_pireps WHERE accepted = '1' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > StatsData::TotalSchedules > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT COUNT(`id`) as `total` FROM phpvms_schedules Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:16:29 ===== Time: 03.20.13 17:16:29 Backtrace: DB::write_debug > DB::get_results > StatsData::TotalFlightsToday > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT COUNT(*) AS `total` FROM phpvms_pireps WHERE DATE(`submitdate`) = CURDATE() Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:23:03 ===== Time: 03.20.13 17:23:03 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByExportStatus > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE p.exported = '0' ORDER BY p.submitdate DESC Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:23:03 ===== Time: 03.20.13 17:23:03 Backtrace: DB::write_debug > DB::get_row > SettingsData::getSettingValue > StatsData::TotalHours > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:24:19 ===== Time: 03.20.13 17:24:19 Backtrace: DB::write_debug > DB::get_results > PIREPData::findPIREPS > PIREPData::getReportsByExportStatus > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT p.*, UNIX_TIMESTAMP(p.submitdate) as submitdate, u.pilotid, u.firstname, u.lastname, u.email, u.rank, a.id AS aircraftid, a.name as aircraft, a.registration, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM phpvms_pireps p LEFT JOIN phpvms_aircraft a ON a.id = p.aircraft LEFT JOIN phpvms_airports AS dep ON dep.icao = p.depicao LEFT JOIN phpvms_airports AS arr ON arr.icao = p.arricao LEFT JOIN phpvms_pilots u ON u.pilotid = p.pilotid WHERE p.exported = '0' ORDER BY p.submitdate DESC Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:24:19 ===== Time: 03.20.13 17:24:19 Backtrace: DB::write_debug > DB::get_row > SettingsData::getSettingValue > StatsData::TotalHours > include > TemplateSet->getTemplate > TemplateSet->showTemplate > Template::show > CodonModule->render > Dashboard->index > call_user_func_array > MainController::RunAllActions Query: SELECT value FROM phpvms_settings WHERE name='TOTAL_HOURS' Error: (2006) - MySQL server has gone away ===== ===== ===== Time: 03.20.13 17:24:47 ===== Time: 03.20.13 17:24:47 Backtrace: DB::write_debug > DB::query > PilotData::updateProfile > Auth::ProcessLogin > Login->ProcessLogin > Login->login > Login->index > call_user_func_array > MainController::RunAllActions Query: UPDATE phpvms_pilots SET `lastlogin`=NOW(), `lastip`='187.135.47.79' WHERE `pilotid`= 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 '' at line 1 ===== =====
-
-
Here is how it works my way:
1. Create a class file like GetSchedules.class.php and paste the following in there and save it. Then upload into your core/common folder:
<?php class GetSchedules extends CodonData { publicfunction getscheds() { $sql = SELECT * FROM phpvms_schedules ORDER BY arrtime + 0 ASC"; return DB::get_results($sql); } } ?>
2. Use a table where you want to show the pulled out data like this:
<?php $list = GetSchedules::getscheds(); ?> Upcoming Arrivals - Current Time is <?php echo date('G:i') ;?></h3> <table width="100%" border="1"> <tr> <td>Departure</td> <td>Arrival</td> <td>Arrival Time</td> <td>Aircraft</td> <td>Status</td> </tr> <?php $count = 0; foreach($list as $flight) { if(($flight->arrtime + 0) > date('G:i')) { if($count < 5) { $aircraft = OperationsData::getAircraftInfo($flight->aircraft); ?> <tr> <td><?php echo $flight->depicao ;?></td> <td><?php echo $flight->arricao ;?></td> <td><?php echo $flight->arrtime ;?></td> <td><?php echo $aircraft->fullname ;?></td> </tr> <tr> <td> <?php if(($flight->arrtime - date('G:i')) <= 1) { echo 'Arriving Soon'; } else { echo 'In Flight'; } $count++; ?> </td> </tr> } } } </table>
Hi Parkho, I did that, created with notepad of windows with the first code, and after rename it as "GetSchedules.class.php" (extension included), after i uploaded to core/common folder via ftp.
The table was created in admin options "Add new page". i think i did something wrong. this is the result:
http://www.argavirtual.xtrweb.com/pruebas/index.php/pages/schedules2
-
Hi, i updated the phpvms to phpvms_extended (sqli i think and more options), https://github.com/D...ab=repositories i follow the steps :
There is an easier way around all that...
First: open your core/app.config.php
Second: find this...
# Pilot pilots to only fly aircraft they're ranked to Config::Set('RESTRICT_AIRCRAFT_RANKS', false);
Make this true.
Third: copy and paste that code in your core/local.config.php file so it doesn't get overwritten during any updates to phpVMS.
Fourth: change all your aircraft to the rank you want each of them to be flown by. Now when a member searches for a flight, only those routes that have the aircraft they are ranked for will show up in the results page.
Note: All aircraft at and below their rank will show, not the ones that they aren't ranked for.
But not work, a "student" or "new hired" pilot can see all routes, inclusive the routes (schedules) of commander rank.
Regards.
Please, i only did two questions in this forum (this is the third) nobody answer my questions.
-
Hi, i dont understand the install instrucctions, Can someone help me please?
I make a .txt, paste the code and after change de .txt extension by .php extension, after i copy the code in a new page, in phpvms, and up the file .php that i did in hosting, but i have a error.
http://www.argavirtual.xtrweb.com/core/modules/Schedules/Schedules%20board.php
Fatal error: Class 'DB' not found in /home/u131375289/public_html/core/modules/Schedules/Schedules board.php on line 3
<?php $query = "SELECT * FROM phpvms_schedules ORDER BY arrtime + 0 ASC"; $list = DB::get_results($query); echo '<h3>Upcoming Arrivals - Current Time is '.date('G:i').'</h3>'; echo '<table width="100%" border="1">'; echo '<tr><td>Departure</td><td>Arrival</td><td>Arrival Time</td><td>Aircraft</td><td>Status</td></tr>'; $count = 0; foreach($list as $flight) { if(($flight->arrtime + 0) > date('G:i')) { if($count < 5) { $aircraft = OperationsData::getAircraftInfo($flight->aircraft); echo '<tr><td>'.$flight->depicao.'</td><td>'.$flight->arricao.'</td><td>'.$flight->arrtime.'</td><td>'.$aircraft->fullname.'</td>'; echo '<td>'; if(($flight->arrtime - date('G:i')) <= 1) { echo 'Arriving Soon'; } else { echo 'In Flight'; } echo '</td></tr>'; $count++; } } } echo '</table>'; ?>
-
Hi, i updated the phpvms to phpvms_extended (sqli i think and more options), https://github.com/DavidJClark?tab=repositories i follow the steps :
There is an easier way around all that...
First: open your core/app.config.php
Second: find this...
# Pilot pilots to only fly aircraft they're ranked to Config::Set('RESTRICT_AIRCRAFT_RANKS', false);
Make this true.
Third: copy and paste that code in your core/local.config.php file so it doesn't get overwritten during any updates to phpVMS.
Fourth: change all your aircraft to the rank you want each of them to be flown by. Now when a member searches for a flight, only those routes that have the aircraft they are ranked for will show up in the results page.
Note: All aircraft at and below their rank will show, not the ones that they aren't ranked for.
But not work, a "student" or "new hired" pilot can see all routes, inclusive the routes (schedules) of commander rank.
Regards.
I need help with phpvms frontpage [solved by my self]
in Support Forum
Posted
In my server can play flash: a default html page from template package: http://sparkadsl.0lx...ash_slider.html , youtube & vimeo videos. http://sparkadsl.0lx...tribAyrton.html
My file directory contain: /htdocs/phpvms/lib/skins/templatemo_254_agency/js/swfobject.js
http://sparkadsl.0lx..._254_agency/js/
P.D: too i uploaded it here http://sparkadsl.0lx.net/phpvms/lib/js/swfobject.js
And this contain this :
I go try in principal directory and i say you, may be that the fail....