search

PygmalionOfCyprus / cmo-db-requests

Public issue/request tracking for the Command: Modern Operations database
51 stars 17 forks source link

CA LAV I Grizzly APC #975

Open cdnice55 opened 2 years ago

cdnice55 commented 2 years ago

DB Selector

Both

Hypothetical

No

Name

LAV I Grizzly APC x4

Facility Type

Mech

Country

Canada

Service

Canadian Army

In Commission

1974-

Crew

2+6

Dispersion Radius (m)

80

Sensors

Mounts

Magazines

For above

Aircraft & Docking Facilities

No response

Comments

No response

Sources

grizzly-1 Grizzly_Piranha_1_wheeled_armoured_vehicle_personnel_carrier_Canada_Canadian_Army_640

claudejdev commented 2 years ago

Hey there, just a quick question if you don't mind : should the type of armor be mentioned too, or it's not relevant ?

cdnice55 commented 2 years ago

The entries that I looked at did not have any armour values listed in the details. The only thing I see in there that might be it is the Missile Defence line, where it says Harpoon/SLAM/maverick equivalents. If I remember correctly that says how many of those it would take to kill the unit(s). Hope that helps!

claudejdev commented 2 years ago

Hey there, I'm not sure it's displayed in the dB viewer, ingame. In the DB, the armor is set in the armor column of the dataMount table. I really should be asking to Ethan though.

Great work on the Canadian entries by the way cdn55.

Cheers, Claude

Le mer. 27 avr. 2022 à 08:16, cdnice55 @.***> a écrit :

The entries that I looked at did not have any armour values listed in the details. I am not sure how the game decides how a tank is more protected than a jeep actually. The only think I see in there that might be it is the Missile Defence line, where it says Harpoon/SLAM/maverick equivalents. If I remember correctly that says how many of one of those it would take to kill the unit. Hope that helps!

— Reply to this email directly, view it on GitHub https://github.com/PygmalionOfCyprus/cmo-db-requests/issues/975#issuecomment-1110585934, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIQT2XJKLQQQUSDO7R5HELLVHDLSBANCNFSM5UEAAKNQ . You are receiving this because you commented.Message ID: @.***>

cdnice55 commented 2 years ago

I have not actually looked into the DB itself for values. Do you have any suggestions for a program to use to view the db3 file? Is that where you are seeing those values?

Thank you, I enjoy the research and helping to expand the db for everyone. Your entries as well are great additions!

dl

claudejdev commented 2 years ago

I'm using DB Browser for SQLite, it's free and allows me to have a look at the tables, and sort the values. To make sure I don't break anything, I've copied the DB file to a distinct folder. I've been exporting the table in csv and have been using Excel a lot to link the table (VLookup function mostly). However, I'm getting back into the marvelous world of SQL request to build "views" more efficiently. Feel free to hook me up here, on Discord or even on the forum if anything ain't quite clear.

cdnice55 commented 2 years ago

Thanks, downloaded that and it works perfectly. Will do, have a good night!