Jump to content

DisposableHero

Members
  • Posts

    623
  • Joined

  • Last visited

  • Days Won

    97

Everything posted by DisposableHero

  1. Possible other causes of airport dropdowns not working Cross Origin Scripting Errors (APP_URL should match your current url, having http in .env but using https while visiting your website fails due to cross origin restrictions, can be solved either by fixin the APP_URL or allowing cross origin scripting between your domains) Custom Theme Errors (Dropdown live search introduced recently, so if your theme is not properly configured to utilize the scripts and select2 features it will fail) Custom Blade Errors (If you have an edited theme, they need to be updated to utilize the search properly, check provided default theme from original source: github or from latest dev release, implement the necessary changes to your blades) Hope this helps people in the future
  2. Great news then @SKD I will check the status field from v5 data and provide a solution for v7 too (not for you anymore but for future Legacy Imports). Enjoy v7 Side Note: Status should be ARR (ARRIVED) for v7 pireps, it is designed like that. When a pirep is finalized/closed by the pilot, it gets this status. So we should set this for imported pireps, even if they are rejected, they should be arrived. Thanks for sharing your findings on this.
  3. Unfortunately yes, your imported pireps do not have `submitted_at` data And this is causing the issue because my modules rely on the submit date, not creation date for operational reasons. A kind friend provided some v5 and imported v7 data yesterday night and I saw what I need (Summary; Legacy importer needs to be updated for at least two missing fields) By the mean time, you can copy the created_at field as your submitted_at field in your v7 database with a query (cause the future update of the imported will do the exact same thing)... This will solve your statistic problems, something like below may work; UPDATE pireps SET submitted_at = created_at WHERE submitted_at IS NULL; Good luck
  4. What is the `submitted_at` date of your pireps ? I am not asking the v5 pireps, we should check v7 tables from now on. As I am pretty sure those stats do work fine, we need to find the difference between an "imported old pirep" and a fresh v7 one to provide a solution (if it is possible of course)
  5. Yeah, exactly what I though Below that part, at line 406 you have the passenger and cargo counts of accepted pireps, which uses laravel's whereIn() function and fails because your placeholders passing the maria/mysql 65k limit. If you check the latest update/version of my Disposable Basic module, you will see that I limited it and now it should pass that line, do not cause an exception and work without pax and cgo counts. BTW, my idea reversing the logic causes inaccurate results due to cancelled, deleted, rejected pireps. Hope it helps. (at least until we find a better solution)
  6. Another solution can be reversing the logic for the stats, instead of using whereIn(...) , I can use whereNotIn(...) with rejected pirep id's array That will be much less and below 65k I think for everyone.
  7. Probably you will be hitting MySQL/MariaDB's placeholder limits with my module's stat service, it tries to read all accepted pireps and pirep fares to get the pax/cargo counts. If this is the case we can look further to improve that logic with only laravel relationships. Looping thought 170k pireps to get the total count may take some server time though, but we will see how it goes. Another solution would be limiting that feature with 65k pireps, so pax/cgo counts will not work on your setup but will be present on others until they hit 65k pireps
  8. Checked flight import code, if the distance is not supplied (empty, null) importer is designed to auto calculate @nobleord ... If it is not working please open a bug report instead of a feature request Safe flights
  9. Of course, there is a Feature Request option at GitHub, also bug reporting is possible, both being tracked and discussed there. https://github.com/nabeelio/phpvms/issues/new/choose https://github.com/nabeelio/phpvms/issues Safe flights
  10. It is auto calculated when creating a new flight via admin interface but not during import as far as I remember.
  11. Yeah we already have "Total Pause Time" in pirep field values, but the OP's question was not about pause, also pause is not counted as flight time as expected. What he wants is simply eliminating sandbaggers with some automation.
  12. Did somebody claimed that being an admin would be fun (or not boring, not time consuming) ? You are trying to go the same path with some others, I should not do anything, everything should be automatic, why I am working for this etc. etc. Then I would ask the above question After all, you can have some code to auto reject pireps by comparing planned (scheduled) flight times with actual flight times (side questions; what will happen to free flights, flights without simbrief plans to precisely check times, flights planned for different aircraft types). In the end, this will have side effects though, then you will work to fix the mis-identified ones 'cause a code will never know the difference between sandbagging and real holding (as it is not an AI with tons of resources). It will only look to your schedule and reject a non matching pirep. And when this happens, you will come here again to ask for another feature for inspecting and identifying, correcting those to reduce your workload Still my advise is same, punish and fire them, this will greatly reduce sandbaggers and you will have a clean roster after a while. Safe flights
  13. What kind of possibility you are after ? If someone is doing unnecessary holdings, waiting at the gate for hours after landing (gaming term : sandbagging) only option is to reject their pireps (as ProAvia suggested) manually and kick them from your VA (if you are really sure about their actions). You can NOT automate this with a software (here in this forum it is phpvms and vmsacars), so it will NOT be possible unless you come up with an AI, reading your pilots mind, getting all other info (like online traffic, IVAO/VATSIM ATC chatter, weather etc.) and decide if he is sandbagging or holding for something really necessary. Safe flights
  14. You are getting mixed content errors because your .env is set to use http (insecure content) but your register page uses https (secure content). Fix it and your early stage showstopper will be gone. (Or you can allow cross origin scripting for your domains.) And thanks for replying to a 3 year old topic
  15. Which part ? Send the log please if it is something Disposable related , either theme or module, I need full error details with stacktrace (your laravel log) to find it out (and solve if possible)
  16. Depends on what you are asking, 65k limit is applicable for queries not database entries... So if the above query contains more than 65k entries in that IN (...) statement then yes it may fail, but this can be handled with batch inserts or optimized queries etc. Anyway, database can handle way more than 170k entries, so your pirep count will not be a problem but importing (handling : reading - processing - saving them with php and queries) can be a real pain. I would suggest opening a bug report via GitHub or tag @Nabeel, he was improving the import code, maybe he can check this issue too.
  17. You do not need to lookup airports one by one @MichaelTrickett, as explained in the pinned guides you can just import your flight schedule. phpVMS v7 is capable of auto lookup for airports and adding them to your database with proper information. Please check your settings and check the guides Safe flights
  18. He may be switching his install to v7, or maybe working on a navdata package for v7 Hope he continues to support v5 though, it is nice to keep the community rolling.
  19. Dear Michael, unfortunately your airport file may cause problems with v7 during usage (not during import). Instead of using the same IATA code for airports not recognized by IATA, you should be leaving that field empty (v7 allows null iata codes as it is not required). Also you have an airport with `\N` as ICAO code, which is strange. This will cause problems 'cause ICAO code is necessary and must be unique, `\N` is not something suitable as an id. // Example from your file; KGKY,\N,Arlington Municipal Airport,Arlington,United States,America/Chicago,,32.66389847,-97.09429932,,,,, // Proper csv format (with null iata and ISO country code) KGKY,,Arlington Municipal Airport,Arlington,US,America/Chicago,,32.66389847,-97.09429932,,,,, // This is not right too; \N,\N,Sun Island Resort and SPA,South Aari Atoll,Maldives,America/Sao_Paulo,,3.488334,72.862989,,,,, Additionally having countries with ISO 2 Letter codes was the preferred / standard way, having them imported with full names may cause compatibility issues too. (By default, v7 lookup imports them with ISO codes) Other than above mentioned issues, it looks fine. At least for someone trying to import lots of airports at once instead of having them automatically looked up and added whenever required/necessary. Hope this helps.
  20. Please check readme https://github.com/FatihKoz/DisposableTheme#customizing-va-logo-images-and-menu-items https://github.com/FatihKoz/DisposableTheme#readme
  21. Dear Zabeed, you should contact AVA staff for support, we can not help you to configure their acars software... They will know airline specific details, not us. If they are using vmsAcars, you can find detailed docs here : https://docs.phpvms.net/acars/user-guide Hope you can get support from your airline, safe flights.
  22. Sorry ? What you are trying to achieve and what is the error, could you be a little bit specific... Normally, you download the software from vmsHost.io, it will be under your account and accessible only by you (if you are the user at vmsHost.io who bought the license for the VA)... then you upload that package to your server, somewhere which can be accessed by your pilots publicly. Then you get that new link and insert it to anywhere you need, distribute via your discord or use that link in vmsAcars module as the download link, or you can add it as a file/link for your VA's downloads etc. No need to define redirects etc. Hope this helps
  23. Which part you need help with? Maybe we can guide you... Docs are pretty clear, we had some step by step instruction with screenshots at Discord too (needs some search). Also you can check Paid Services section to find someone if you are willing to pay of course. Good luck
  24. How ? By editing the files you bought or by requesting the change from the provider ? Either way, glad to hear the result
×
×
  • Create New...