• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Login
FAForever Forums
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Login

Unit Database Discussion Thread

Scheduled Pinned Locked Moved I need help
34 Posts 13 Posters 2.2k Views
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A
    Auriko
    last edited by 8 Sept 2021, 15:30

    Yea @wikingest this database you're using is the old rackover database. Right ? It says it's from 2018 at the bottom of the page.

    Spooky database is updated and functional.

    D W 2 Replies Last reply 8 Sept 2021, 15:34 Reply Quote 0
    • D
      deletethis @Auriko
      last edited by 8 Sept 2021, 15:34

      I had absolutely no clue there was even a newer version of it.

      Why is the site still linking to this old version?

      1 Reply Last reply Reply Quote 0
      • W
        wikingest @Auriko
        last edited by 8 Sept 2021, 15:39

        @auricocorico I am using the database that shows up in the client. And MazorNoob pointid to it also. Also, you yourself sayd that "units" tab in client is linked to database and up to date.

        1 Reply Last reply Reply Quote 0
        • A
          Auriko
          last edited by 8 Sept 2021, 15:45

          Well my client "Units" tab has always led me to the spooky database. I didn't know that in other people's client it could lead to this outdate one ...

          1 Reply Last reply Reply Quote 0
          • D
            Dragun101
            last edited by 8 Sept 2021, 15:46

            Rackover is/was used to be the default one not spooky. Also Rackover's is less CPU heavy/easier to select comparisons in my experience

            I’m a shitty 1k Global. Any balance or gameplay suggestions should be understood or taken as such.

            Project Head and current Owner/Manager of SCTA Project

            1 Reply Last reply Reply Quote 0
            • A
              Auriko
              last edited by 8 Sept 2021, 15:53

              But it spreads misinformation right now, as it's outdated af

              1 Reply Last reply Reply Quote 0
              • S
                Shenmue-is-life @angelofd347h
                last edited by 8 Sept 2021, 16:03

                @angelofd347h said in Excel about all the units:

                You can change the chosen database to spooky which doesn't seem to be having this issue: https://faforever.github.io/spooky-db/#/

                This is still not a table but the comparison feature is welcome, thank you.

                W 1 Reply Last reply 8 Sept 2021, 16:11 Reply Quote 0
                • W
                  wikingest @Shenmue-is-life
                  last edited by 8 Sept 2021, 16:11

                  @shenmue-is-life Maybe you could change your titre, to add problem with actual database? With all discussion going on, I do not know if I should make another thread πŸ™‚

                  S 1 Reply Last reply 8 Sept 2021, 16:20 Reply Quote 0
                  • A
                    angelofd347h Global Moderator
                    last edited by 8 Sept 2021, 16:19

                    376b184d-1bfa-4fe6-ae10-3cb5c40dad75-image.png

                    Both databases are in the client.

                    1 Reply Last reply Reply Quote 1
                    • S
                      Shenmue-is-life @wikingest
                      last edited by 8 Sept 2021, 16:20

                      @wikingest said in Excel about all the units:

                      @shenmue-is-life Maybe you could change your titre, to add problem with actual database? With all discussion going on, I do not know if I should make another thread πŸ™‚

                      Done.

                      1 Reply Last reply Reply Quote 0
                      • K
                        Katharsas
                        last edited by 8 Sept 2021, 18:27

                        Spooky DB is default for new client installations but i don't think the client switched over existing installations. Maybe old DB should be removed until it can be fixed (which will probably never happen but at least we don't have people using broken DB).

                        1 Reply Last reply Reply Quote 0
                        • D
                          deletethis
                          last edited by deletethis 9 Aug 2021, 18:29 8 Sept 2021, 18:28

                          Good to know that it's an option in the client but there should a link somewhere on the site as well, it's still linking to the old version with no mention of this new version anywhere (apart from a spooky mode option).

                          b06d067e-1873-4876-bb18-43b60e20e4bf-image.png

                          I'll admit that you'll learn of it if you eventually go to the bottom of the page and follow the link to github, but I definitely would have never noticed that link or clicked on it normally...

                          1 Reply Last reply Reply Quote 1
                          • A
                            arma473 @deletethis
                            last edited by 8 Sept 2021, 20:22

                            @deletethis Another issue: the Aeon T3 torpedo plane ("Solace") damage/dps is shown as less than the true number

                            It says 500 damage x4, which would be 2k damage per pass.

                            But we know it's around double that because a Solace can one-pass all 4 factions' cruisers

                            I think it has something to do with the way the weapon is coded, that it has 2 "racks" of missiles or something and the unit DB doesn't understand that it needs to double the damage

                            1 Reply Last reply Reply Quote 1
                            • C
                              CheeseBerry
                              last edited by 8 Sept 2021, 21:23

                              Does this mean the database does NOT read the values right from the database files? Were those values entered by hand??

                              1 Reply Last reply Reply Quote 0
                              • F
                                FtXCommando
                                last edited by 8 Sept 2021, 21:38

                                It reads the files but gpg thought it would be really cool if every unit had their own stupid gimmick for how they release 30 dps instead of just giving the unit 30 dps. Every idiosyncrasy they made isn’t accounted for.

                                1 Reply Last reply Reply Quote 2
                                • B
                                  Brutus5000 FAF Server Admin
                                  last edited by 8 Sept 2021, 21:52

                                  The Rackover unitdb is sort of "reset" everytime we restart the server and needs a manual trigger to update to the latest patch. Very annoying. I updated it for now.

                                  He said, "I've been to the year 3000
                                  Not much has changed, but they live underwater
                                  And your great-great-great-granddaughter
                                  Is playin' FAF, playin' FAF"

                                  1 Reply Last reply Reply Quote 2
                                  • W
                                    wikingest
                                    last edited by 9 Sept 2021, 07:17

                                    The DPS=0 problem seems to be gone. Thanks.
                                    But all other problems seem to be still there.

                                    1. There seems to be common problem with "fire cycle = x projectiles/shot". Sometimes you can multiply raw damage, firerate, fire cycle and nombre of weapons( usually 1), to get DPS, and sometimes it does not work. Already mentioned UEF cruiser, but UEF t3 gunship, CYB t3 gunship, even UEF nukesub having Fire cycle 2 projectiles / shot, etc.
                                    2. Galactic Colossus surely does not have a DPS of 1667... And tractor clavs do not fire every secund. Checking from another database(spooki) , GC, Spider and Ythothia are not corresponding in values.
                                    3. SER croiser and mothership missiles are not supposed to cost mass (300).
                                    4. AEO t1 tank (Aurora) DPS seems to be out. Compared to other database.
                                      5.AEO flare DPS seems to be out. Compared to other database.
                                    5. All t1 bombers seems to be out, firerate incorrect I think.
                                      Probably could find some more, some of those had just stayed in my memory from before...
                                      Not always easy to learn a game like that, with no or incorrect data πŸ™‚
                                    1 Reply Last reply Reply Quote 0
                                    • F
                                      FemtoZetta
                                      last edited by 9 Sept 2021, 09:58

                                      You can fix the issues here: https://github.com/FAForever/UnitDB

                                      1 Reply Last reply Reply Quote 0
                                      26 out of 34
                                      • First post
                                        26/34
                                        Last post