equipment mod, shield, weapon/bullet and engine data

This forum is the ideal place for all discussion relating to X4. You will also find additional information from developers here.

Moderator: Moderators for English X Forum

Post Reply
pref
Posts: 5541
Joined: Sat, 10. Nov 12, 18:55
x4

equipment mod, shield, weapon/bullet and engine data

Post by pref » Fri, 1. May 20, 18:40

Game data export of

* Mods
* Weapons, Shields, Engines

in excel format


--- OP -----
I got the macro data for weapons and bullets in SQL, joined them on bullet class.
Just have no idea how could this end up on wiki conveniently (without much manual input i mean). Or if it has a place there at all. Probably has way more columns then necessary.
looks like this (just a sample, the link should have everything):
Spoiler
Show

Code: Select all

"weapontype","macro_name","mk","bullet","heat_overheat","heat_cooldelay","heat_coolrate","heat_reenable","rotationspeed","rotationacc","reload","reload_rate","reload_time","hull","hull_treshold","hull_hittable","storage_capacity","ammo","macro_name","speed","lifetime","bullet_range","amount","barrelamount","timediff","angle","maxhits","ricochet","bullet_scale","bullet_attach","selfdestruct","restitution","heat","heat_initial","reload_rate","reload_time","damage","damage_shield","repair","mining_multiplier","surface_multiplier","areadamage","areadamage_range","areadamage_falloff","areadamage_time","areadamage_lifetime","ammunition","ammunition_reload"
standard,turret_arg_l_laser_01_mk1_macro,"1",bullet_arg_turret_l_laser_01_mk1_macro,,,,,"40",,"","0.5","1","2300","0.2",,,,bullet_arg_turret_l_laser_01_mk1_macro,"2041","3.219",,"1","2","0.001","0.02","1","0","0","0",,,,,,"2.4","367",,"0",,,,,,,,"3","0.5"
standard,turret_arg_m_laser_01_mk1_macro,"1",bullet_gen_turret_m_laser_01_mk1_macro,,,,,"210",,"","1","1",,"0.2",,,,bullet_gen_turret_m_laser_01_mk1_macro,"1855","1.844",,"1","2","0.019","0.32","1","0","0","0",,,,,"6",,"12",,"0",,,,,,,,"3","0.5"
standard,weapon_xen_s_laser_01_mk1_macro,"1",bullet_xen_s_laser_01_mk1_macro,"10000","1.13","2000","9500","101.4","50.7","",,,,,,,,bullet_xen_s_laser_01_mk1_macro,"2880","1.25",,"1","1","0.025","0.2","1","0","0","0",,,"54",,"13",,"18",,"0",,,,,,,,"7","0.65"
heavy,turret_arg_l_plasma_01_mk1_macro,"1",bullet_arg_turret_l_plasma_01_mk1_macro,,,,,"40",,"","0.5","1","2300","0.2",,,,bullet_arg_turret_l_plasma_01_mk1_macro,"440","19.474",,"1","2","0","0.01","1","0","0","0",,,,,,"4.7","2420",,"0",,,,,,,,,
heavy,weapon_tel_s_charge_01_mk2_macro,"2",bullet_tel_s_charge_01_mk2_macro,"10000","1.13","2000","7500","58","29","",,,"500",,"0",,,bullet_tel_s_charge_01_mk2_macro,"1571","1.5",,"3","1","0.16","0.13","3","0.3","0","0",,"0.55","75",,"3",,"176",,"0",,,,,,,,,
energy,turret_arg_l_beam_01_mk1_macro,"1",bullet_arg_turret_l_beam_01_mk1_macro,,,,,"40",,"","0.5","1","2300","0.2",,,,bullet_arg_turret_l_beam_01_mk1_macro,"7000","3","5000","1","1",,,"1","0","1","1",,,,,,"5","147",,"0",,,,,,,,,
energy,weapon_gen_s_burst_01_mk1_macro,"1",bullet_gen_s_burst_01_mk1_macro,"10000","1.13","2000","7500","180","180","",,,"500",,"0",,,bullet_gen_s_burst_01_mk1_macro,"96000","0.15","2000","1","1","0.05","2","1","0","1","1",,"1","718",,"6",,"74",,"0","7",,,,,,,"3","1.3"
energy,weapon_gen_s_burst_01_mk2_macro,"2",bullet_gen_s_burst_01_mk2_macro,"10000","1.2","2500","7500","180","180","",,,"500",,"0",,,bullet_gen_s_burst_01_mk2_macro,"96000","0.15","1800","1","1","0.05","2","1","0","1","1",,"1","720",,"6",,"47",,"0","13",,,,,,,"7","0.5"
capital,weapon_arg_l_destroyer_01_mk1_macro,"1",bullet_arg_l_laser_01_mk1_macro,"10000","1.13","2000","9500","32.3","16.15","",,,"8000",,,,,bullet_arg_l_laser_01_mk1_macro,"1659","6.3",,"1","1","0.002","0.03","1","0","0","0",,,"486",,"1.2",,"2588",,"0",,,,,,,,"3","2"
capital,weapon_tel_l_destroyer_01_mk1_macro,"1",bullet_tel_l_laser_01_mk1_macro,"10000","1.13","2000","9500","29.07","14.535","",,,"8000",,,,,bullet_tel_l_laser_01_mk1_macro,"1659","6.3",,"1","1","0.002","0.03","1","0","0","0",,,"475",,"1.44",,"1169",,"0",,,,,,,,"3","2"
mining,turret_arg_l_mining_01_mk1_macro,"1",bullet_arg_turret_l_mining_01_mk1_macro,,,,,"40",,"","0.5","1","2300","0.2",,,,bullet_arg_turret_l_mining_01_mk1_macro,"7000","4","7000","1","1",,,"1","0","1","1",,,,,,"4","2",,"0",,"450",,,,,,,
mining,weapon_xen_m_mining_01_mk1_macro,"1",bullet_gen_m_mining_01_mk1_macro,,,,,"105",,"",,,,,,,,bullet_gen_m_mining_01_mk1_macro,"7000","4","4364","1","1",,,"1","0","1","1",,,,,,"4","2",,"0",,"300",,,,,,,
dumb,turret_arg_l_dumbfire_01_mk1_macro,"1",missile_dumbfire_heavy_mk1_macro,,,,,"40",,"",,,"5000","0.2",,"300",dumbfire,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
dumb,turret_tel_m_dumbfire_02_mk1_macro,"1",missile_dumbfire_light_mk1_macro,,,,,"60",,"",,,"1650","0.2",,"30",dumbfire,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Full file
Last edited by pref on Thu, 7. May 20, 01:20, edited 5 times in total.

pref
Posts: 5541
Joined: Sat, 10. Nov 12, 18:55
x4

Re: weapon/bullet data for wiki?

Post by pref » Mon, 4. May 20, 01:16

I had a little more time, made an excel out of it (shields, weapon+bullet, engines).
Last edited by pref on Wed, 6. May 20, 02:07, edited 1 time in total.

GCU Grey Area
Posts: 5389
Joined: Sun, 15. Feb 04, 00:07
x4

Re: weapon/bullet data for wiki?

Post by GCU Grey Area » Mon, 4. May 20, 01:41

pref wrote:
Mon, 4. May 20, 01:16
I had a little more time, made an excel out of it (shields, weapon+bullet, engines).
Thanks for posting that. Very useful indeed. In particular was wondering if Split shields might have a particularly short Recharge Delay, to make up for their otherwise rather cruddy stats. Seemed a fair bit quicker in use but Recharge Delay is not in the encyclopedia, so couldn't sure that it wasn't just my imagination. Cheers Pref. :thumb_up:

Witzzard
Posts: 27
Joined: Wed, 3. Aug 05, 15:17
x4

Re: weapon/bullet data for wiki?

Post by Witzzard » Mon, 4. May 20, 01:53

Thanks for the info dump.
Didn't realize that the Paranid destroyer main guns differ that much from the others. Though it has been a while since i looked last at them in comparison, so might also just be my memory.

Hm any info on what timediff and maxhits are exactly?

pref
Posts: 5541
Joined: Sat, 10. Nov 12, 18:55
x4

Re: shield, weapon/bullet and engine data for wiki.

Post by pref » Mon, 4. May 20, 13:57

Happy you guys could use it. I was hoping for a high split recharge rate and had enough of looking at the macros.
Some params might be AI only, no clue about timediff or hull threshold for ex.

I want to include mods later, it just needs a bit different query so i couldn't just copypaste it like the rest.
Or if that is already available someplace please let me know then i can skip that part.

GCU Grey Area
Posts: 5389
Joined: Sun, 15. Feb 04, 00:07
x4

Re: shield, weapon/bullet and engine data for wiki.

Post by GCU Grey Area » Mon, 4. May 20, 19:36

pref wrote:
Mon, 4. May 20, 13:57
I was hoping for a high split recharge rate and had enough of looking at the macros.
Was really glad to find that there was at least something positive about Split shields. I mean, really didn't have a choice in the matter - I HAD to install them. Just couldn't face even one more landing in my Tuatara on my Cobra & having to look at those Teladi units. They just looked so out of place, spoiled the entire aesthetic. In hindsight though probably didn't need the Traction mod. +65% Recharge Rate is still quite handy, but -67% Recharge Delay is simply unnecessary with Split shields. Would have been quite useful to know about the Recharge Delay beforehand, sort of thing one might expect to be in the encyclopedia.

pref
Posts: 5541
Joined: Sat, 10. Nov 12, 18:55
x4

Re: shield, weapon/bullet and engine data for wiki.

Post by pref » Tue, 5. May 20, 19:21

GCU Grey Area wrote:
Mon, 4. May 20, 19:36
In hindsight though probably didn't need the Traction mod. +65% Recharge Rate is still quite handy
Is there anything else that gets near 70% extra recharge? I really should export the mod data :D

And yeah i can imagine that ship looks terrible with lizard trash.

GCU Grey Area
Posts: 5389
Joined: Sun, 15. Feb 04, 00:07
x4

Re: shield, weapon/bullet and engine data for wiki.

Post by GCU Grey Area » Tue, 5. May 20, 19:51

pref wrote:
Tue, 5. May 20, 19:21
Is there anything else that gets near 70% extra recharge?
Not that I know of. There's a few others that have Recharge Rate either as their primary function, or one of their potential secondaries, but they're all relatively modest increases (+20% is best I generally expect from green or blue mods, +30% from the purple Targe). Traction's the only real option if increasing Recharge Rate is the primary objective & works well for ludicrously fast ships (such as Cobra) that can easily get out of a fight, but then want to spend the minimum amount of time getting ready to return.

pref
Posts: 5541
Joined: Sat, 10. Nov 12, 18:55
x4

Re: shield, weapon/bullet and engine data for wiki.

Post by pref » Wed, 6. May 20, 02:01

Thanks.

Finished the mods excel too.

GCU Grey Area
Posts: 5389
Joined: Sun, 15. Feb 04, 00:07
x4

Re: shield, weapon/bullet and engine data for wiki.

Post by GCU Grey Area » Wed, 6. May 20, 10:02

pref wrote:
Wed, 6. May 20, 02:01
Finished the mods excel too.
Nice one, thanks Pref. :)

pref
Posts: 5541
Joined: Sat, 10. Nov 12, 18:55
x4

Re: equipment mod, shield, weapon/bullet and engine data

Post by pref » Thu, 7. May 20, 01:32

Have fun :D
The online converter i used for mods left out a couple bonus effects, had to update it.
Also on wiki at equipment/macro data.
Couldn't find a way to make a nice table out of it so just uploaded the excels :(

Post Reply

Return to “X4: Foundations”