Jump to content

DisposableHero

Members
 View Profile  See their activity

  • Posts

    704

  • Joined

  • Last visited

  • Days Won

    113

 Content Type 

Everything posted by DisposableHero

  1. DisposableHero
    Technically speaking adding 40k+ airports or any number should not affect the latest loading system, as it is simply searching live as you type or gets the first 20 or 50 to build the dropdown, then loads more as you scroll. There may be another problem (or problems) affecting live search/load. When it is not working be sure to check your browser console for any errors. And be sure what you are importing, is the file fully compatible with v7 (I remember that file having some problems before, did not checked later for updates) And for your question, answer is "Yes" as long as your settings allow automated lookups and unadded airport usage (in some rare cases lookup may fail, like an airport can not be found in VaCentral database, ICAO code mistyped, ICAO code changed etc) Good luck
  2. DisposableHero
    This is for legacy (v2/v5), not for v7 as far as I know and as you can see it is published under phpVMS Classic section of the forum. Good luck
  3. DisposableHero
    Admin > Ranks
  4. DisposableHero
    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
  5. DisposableHero
    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.
  6. DisposableHero
    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
  7. DisposableHero
    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)
  8. DisposableHero
    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)
  9. DisposableHero
    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.
  10. DisposableHero
    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
  11. DisposableHero
    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
  12. DisposableHero
    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
  13. DisposableHero
    It is auto calculated when creating a new flight via admin interface but not during import as far as I remember.
  14. DisposableHero
    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.
  15. DisposableHero
    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
  16. DisposableHero
    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
  17. DisposableHero
    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
  18. DisposableHero
    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)
  19. DisposableHero
    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.
  20. DisposableHero
    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
  21. DisposableHero
    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.
  22. DisposableHero
    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.
  23. DisposableHero
    Please check readme https://github.com/FatihKoz/DisposableTheme#customizing-va-logo-images-and-menu-items https://github.com/FatihKoz/DisposableTheme#readme
  24. DisposableHero
    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.
  25. DisposableHero
    No, there is not.
×
×
  • Create New...