Q-Stone

You should just be able to use a program such as winzip to extract the zip file directly into your S3 installation directory. The zip file should create a sub-folder called cNoPKs/ and put all the files in there. That's all you need to do. If you're using a zip program that isn't preserving directory structure, figure out how to extract with directories or try something like winzip.com.

The game ships with SQL Sever Desktop Edition, which you'll need, but this doesn't really let you view/change the data and run queries, which is what you'll have to do in order to review and edit the game stats. This is why you'll need a program (such as Blueshell or MS Access) to provide a front-end to SQL Server. Also, I wouldn't suggest you try to change the core game file. I mean, you probably could compile a mod full game.db and replace the original with it, but this isn't a good idea and I'm not sure it would work. Why not just use the mods as intended?

Hi, the stats for the weapons are stored in an sql server database. Read the instructions posted in the sticky thread "How to MOD SS2 - compiled instructions" for a step-by-step process for accessing this information.

Hmm, I'm not sure, though my guess is that it would be. The bulk of changes are simply text adjustments in the string table. There are a few updates to the ammo type that some clips use, and some changes in the clips carried by enemies.

Thanks! Though I noticed that the "more information <here>" link seems to be broken on that page?

Hey, guys! Sorry it took so long. Here's the update of AmmoFixes for S2, now built and tested with the 1.2 patch. If a couple of you could test the zipfile and make sure everything's good, it'll be ready to add to the file archive. AmmoFixesS2.zip

I don't really hate them, though I think there were very poorly designed for this game. They're all but indestructable except for a few weapons. They cause real problems on many levels because the game won't let them get close to one another, so this cause some pathing issues.

Thanks, this got it. I fixed a couple of weapon/magazine mismatches.

Huh. Okay, I'll check this out. I don't want to delete anything, I just want to change them to the correct magazine for the gun they're carrying.

I've noticed that there are instances of enemies carrying the Luger P08 (ItemID #3, ammo is ItemID #76) but carrying ammunition for the British Luger (ItemID #2, ammo is ItemID #75) which is incompatible. So I'm trying to fix this but I can't seem to get it right. Specifically, I'm looking at German Town (I believe this is scenario GTwn) and the Germ_officerLugerP08 (RPGPers ID #306). He carries a Luger P08 but drops 3 clips of ammo for .38 "British Service". I just can't figure out how I determine what equipment an enemy carries in their inventory and how I would change it. I've been looking at RPGLootInstances, but if this is what I need to change, I haven't been able to find the link between a person and his backpack. Has anyone gotten this kind of change to work in S2?

I'll see what I can do.

Since most of the work was already done, I've gone and ported my mod to the original S2 as well. It's nearly identical except that it doesn't include some weapons in S3 that aren't in S2. This was built and tested using the U.S. Silent Storm Gold Edition, v1.1. http://www.rps.net/QS/FILES/AmmoFixesS2.zip

Yeah, you need to set up an ODBC connection first. Check out the pinned post called "How to mod S2 - compiled instructions" http://www.strategycore.co.uk/forums/index...?showtopic=3244

Excellent! And thanks.

Really? Is it the zip file you're having a problem with? I can still open it without issue. Or is it the db file itself? Edit: I rezipped it with a different compression. Let me know if that made any difference.

This is the mod I was discussing in a previous thread, that fixes some of the ammunition issues. It also fixes some item names and Americanizes others, plus changes some things for the sake of consistency. I'd appreciate your thoughts and feedback! http://www.rps.net/QS/FILES/AmmoFixes.zip FIXES ----- Replaced the .38 "British Service" ammo type with the .30 Mauser, for use in the Mauser Broomhandle pistols. Replaced the DeLizl .45 ammo type with the .38 Special, for use in the S&W Colt Detective Special. Both Thompson SMGs and their magazines now use .45 ACP ammo. The Bren LMG magazine now holds 30 rounds. The Johnson LMG and its magazine now use .30-06 ammo. The Colt Detective Special now uses .38 Special ammo. The Luger (British) has been replaced with the prototype Luger .45 and uses .45 ACP ammo. The 1926 and M712 Mauser C-96s now use .30 Mauser ammo. NAME CHANGES ------------ ** Ammo and Clips ** .38 Parabellum --> 9mm Parabellum 12.7 Vickers --> 12.7mm Vickers 13.0 Mauser --> 13.0mm Mauser 13.2 French --> 13.2mm French 20.0 Erlicon --> 20.0mm Erlicon 20.0 Mauser --> 20.0mm Mauser 6.5 Manlicher-Carcano --> 6.5mm Manlicher-Carcano 7.5 MAS --> 7.5mm MAS 7.62 Garand --> .30 Carbine 7.62 Nagant --> 7.62mm Nagant 7.62 Springfield --> .30-06 Springfield 7.62x23 USSR --> 7.62x25mm Tokarev 7.62x39R USSR --> 7.62x39Rmm USSR 7.62x53R USSR --> 7.62x54Rmm USSR 7.65 Sauer --> .32 ACP 7.92 MSS-41 AP Clip. --> 7.92mm MSS-41 AP Clip 7.92x33 Mauser --> 7.92mm Kurz 7.92x57 Mauser --> 7.92mm Mauser AK47 Magazine --> AK-47 Magazine Bazooka Rocket (Armor Piercing) --> M1 "Bazooka" Rocket (Armor Piercing) Bazooka Rocket Propelled Grenade --> M1 "Bazooka" Rocket Browning M1922 Magazine --> BAR Magazine Colt Detective Special .38 S&W rounds --> .38 Special Speedloader Colt M1911 BigJoe Arrow --> Colt M1911 "Big Joe" Arrow Colt M1911 Pistol Clip. --> Colt M1911 Pistol Clip DShK Machine Gun --> Panzerklein DShK Machine Gun Flak38 Magazine. --> Flak38 Magazine Garand M1 Rifle Clip --> M1 Garand Clip JHP 7.62x23 USSR --> 7.62x25mm Tokarev JHP Johnson Light Gun --> Bren LMG Magazine Johnson Light Gun --> Johnson Light Machine Gun Johnson Light Gun Magazine --> Johnson LMG Magazine Lee-Enfiled 10-round Rifle Clip --> Lee-Enfield 10-round Rifle Clip Little Joe Arrow --> "Little Joe" Arrow Little Joe Arrow --> "Little Joe" Arrow M-1 Carbine Clip --> M1 Carbine Clip M20 Bazooka Shell --> M20 "Super Bazooka" Rocket M20 Bazooka rocket (Armor Piercing) --> M20 "Super Bazooka" Rocket (Armor Piercing) MG34 Boxed Cartridge Belt --> MG34 Drum Magazine Mauser 1912 Pistol Clip --> Mauser C-96 1912 9mm Clip Mauser M.712 Pistol Clip --> Mauser C-96 M712 .30 Mauser Magazine Mosin Rifle Clip --> Mosin-Nagant Rifle Clip Nagant 1896 Cartridges --> 7.62mm Nagant Revolver Cartridges Panzershrek Rocket Propelled Grenade --> Panzerschrek Rocket Panzerschrek Rocket Armor Piercing --> Panzerschrek Rocket (Armor Piercing) Parabellum Pistol Clip --> 9mm Pistol Magazine PIAT rocket. --> PIAT Rocket PIAT Rocket Armor Piercing --> PIAT Rocket (Armor Piercing) PTR "Boys" --> .55 Boys PTR Boys Magazine --> Boys Anti-tank Rifle Magazine STG43 SMG Magazine --> STG44 SMG Magazine SVT- 40 Rifle Clip --> SVT40 Rifle Clip Sauer 38X Pistol Clip --> Sauer 38 Pistol Clip Speedloader for Six .38 rounds --> .455 Webley Speedloader Sterling Patchett Clip --> Sterling SMG Clip Stuning Dart --> Tranquilizer Dart TKB408 Clip --> TKB-408 Clip TT Pistol Clip --> TT-33 Pistol Clip Thompson 1928 SMG Magazine --> Thompson M1 Magazine Thompson M1 SMG Drum Magazine --> Thompson 1928 Drum Magazine Vickers 12.7 Boxed Cartridge Belt. --> Vickers 12.7mm Boxed Cartridge Belt ** Weapons ** AK47 --> AK-47 Bazooka M1 --> M1 "Bazooka" Beretta M38-42 --> Beretta M38/42 Beretta M38-42 Silenced --> Beretta M38/42 Silenced Black Jack Club --> Blackjack Bren --> Bren Mk1 Light Machine Gun Browning M1922 --> Browning Automatic Rifle M1922 Carbine 1938 --> Mosin-Nagant Carbine 1938 Carbine 98K Scoped --> Mauser Carbine 98K Scoped Carbine 98K Scoped, Silenced --> Mauser Carbine 98K Scoped, Silenced Carbine DeLizl Silenced --> DeLisle Carbine Silenced Carbine M1 1936 --> M1 Carbine 1936 Chakra --> Chakram Chatellerault M1924/1929 --> Chatellerault M1924/29 DP --> Degtyarev DP-27 FG 42 --> FG42 G-41 W --> G41(W) G-41 W Scoped --> G41(W) Scoped Garand M1 --> M1 Garand Garand M1 Scoped --> M1 Garand Scoped Johnson Light Gun --> Johnson Light Machine Gun Khukuri Knife --> Khukri Knife Luger British --> Luger .45 M20 Bazooka --> M20 "Super Bazooka" M3A1 --> M3A1 "Grease Gun" M3A1 Silenced --> M3A1 "Grease Gun" Silenced MG 34 --> MG34 MG-34 Tripod Mounted --> MG34 Tripod Mounted MP 28 - Bergmann --> Bergmann MP 28 MP 38 --> MP38 MP 40 --> MP40 MP 40-II --> MP40/II Mauser K96 1912 --> Mauser C-96 1912 Mauser K96 1912 Silenced --> Mauser C-96 1912 Silenced Mauser K96 1926 --> Mauser C-96 1926 Mauser M.712 --> Mauser C-96 M712 Mosin 1891-1930 --> Mosin-Nagant 1891/30 Mosin 1891-1930 Scoped --> Mosin-Nagant 1891/30 Scoped Nagant 1910 --> Nagant 1895 Revolver Nagant 1910 Silenced --> Nagant 1895 Revolver Silenced PIAT --> PIAT Rocket Launcher PIAT Rocket Launcher --> Panzerklein PIAT Rocket Launcher PTR Boys Gun --> Boys Anti-tank Rifle Pukke Knife --> Puukko Knife Rifle 33-40 --> CZ 33/40 Carbine Rifle 33-40 Scoped --> CZ 33/40 Carbine Scoped STG 43 --> STG44 SVT 40 --> SVT40 SVT 40 Scoped --> SVT40 Scoped Sauer 38X --> Sauer 38 Sten Mk II --> Sten MkII Sten Mk IV --> Sten MkIV Sten Mk V --> Sten MkV Sterling Patchett --> Sterling L2A3 Sterling Patchett Para --> Sterling Mk7 Para Sterling Patchett Silencer --> Sterling L34A1 Silenced Stun Air-Rifle Silenced --> Tranquilizer Rifle Silenced Stun Pistol Silenced --> Tranquilizer Pistol Silenced Suomi --> Suomi M1931 TKB408 --> TKB-408 TT 1933 --> Tokarev TT-33 Thompson 1923 --> Thompson 1928 Thompson 1928 --> Thompson M1 Vickers 12.7 --> Vickers Machine Gun Vickers Machine Gun --> Panzerklein Vickers Machine Gun Volksgewehr45 --> Volksgewehr VG1-5 Wood Chopping Axe --> Hatchet ZB 26-30 --> ZB 26/30 ** Other Equipment ** Advanced Picklock --> Advanced Lockpick Bullet Extractor. --> Bullet Extractor Decyphering Book --> Deciphering Book Forceps, Abbey --> Kelly Forceps Hecsogen Charge --> Hexogen Charge Meduim --> Medium Metal Scissors --> Bolt cutters Nytroglycerin Charge --> Nitroglycerin Charge Picklock --> Lockpick Picklock Set --> Lockpick Set

Err, yeah, I can't read Russian though.

Cartridges of the World (8th Edition) lists it as the 7.62x53Rmm Russian and states that it is sometimes called the 7.62x54Rmm. In addition, S3 lists it as 7.62x53Rmm, so I simply left the length unchanged. You're right about me forgetting the "R" however. Jane's Guns Recognition Guide states that it was adopted in 1928 "after two years of trials". "Designed by John Browning for his first successful automatic pistol, this cartridge was first manufactured by FN in Belgium, and introduced in 1899. It was marketed in the U.S. when Colt turned out a pocket automatic on another Browning patent in 1903. The 32 Automatic is one of the more popular pistol cartridges ever developed... In Europe, every company that made automatic pistols chambered the 32 ACP (Automatic Colt Pistol).... In Europe, it is known as the 7.65mm Browning, while in the U.S. it is designated as the 32 Auto or 32 ACP."

I'd be interested. Mind you, the mod I'm currently working is just to straighten out errors in the game as is. I'm not yet at a point where I want to start messing with weapon stats and balance. After that I'm going to start looking at adding some content, so perhaps that can be the possibility of collaboration.

I'd rather not introduce another ammo type if I can help it. The 7.65mm Parabellum isn't in the game or used by any other weapon, and I'd prefer that at least a couple of guns use any particular cartridge. Another possibility would be to chamber it for the Sauer 38's 7.65mm Browning (.32 ACP), as there were also experimental Lugers in this caliber as well. My main concern now is making sure that with all my changes, enemies spawn with the correct magazines for their weapon. Here's a list of what I've done so far: Replaced the .38 "British Service" ammo type with the .30 Mauser, for use in the Mauser Broomhandle pistols. Replaced the DeLizl .45 ammo type with the .38 Special, for use in the S&W Colt Detective Special. Replaced one of the Luger clips with the .30 Mauser clip for use in the Mauser Broomhandle pistols. Both Thompson SMGs and their magazines now use .45 ACP ammo. The Bren LMG magazine now holds 30 rounds. The Johnson LMG and its magazine now use .30-06 ammo. The Colt Detective Special now uses .38 Special ammo. The Luger (British) has been replaced with the prototype Luger .45 and uses .45 ACP ammo. The 1926 and M712 Mauser C-96s now use .30 Mauser ammo. NAME CHANGES ** Ammo and Clips ** .38 Parabellum --> 9mm Parabellum 12.7 Vickers --> 12.7mm Vickers 13.0 Mauser --> 13.0mm Mauser 13.2 French --> 13.2mm French 20.0 Erlicon --> 20.0mm Erlicon 20.0 Mauser --> 20.0mm Mauser 6.5 Manlicher-Carcano --> 6.5mm Manlicher-Carcano 7.5 MAS --> 7.5mm MAS 7.62 Garand --> .30 Carbine 7.62 Nagant --> 7.62mm Nagant 7.62 Springfield --> .30-06 Springfield 7.62x23 USSR --> 7.62x25mm Tokarev 7.62x39R USSR --> 7.62x39mm USSR 7.62x53R USSR --> 7.62x53mm USSR 7.65 Sauer --> .32 ACP 7.92 MSS-41 AP Clip. --> 7.92mm MSS-41 AP Clip 7.92x33 Mauser --> 7.92mm Kurz 7.92x57 Mauser --> 7.92mm Mauser AK47 Magazine --> AK-47 Magazine Bazooka Rocket (Armor Piercing) --> M1 "Bazooka Rocket" (Armor Piercing) Bazooka Rocket Propelled Grenade --> M1 "Bazooka" Shell Browning M1922 Magazine --> BAR Magazine Colt Detective Special .38 S&W rounds --> .38 Special rounds Colt M1911 BigJoe Arrow --> Colt M1911 "Big Joe" Arrow Colt M1911 Pistol Clip. --> Colt M1911 Pistol Clip Flak38 Magazine. --> Flak38 Magazine Garand M1 Rifle Clip --> M1 Garand Clip JHP 7.62x23 USSR --> 7.62x25mm Tokarev JHP Johnson Light Gun --> Bren Machine Gun Magazine Lee-Enfiled 10-round Rifle Clip --> Lee-Enfield 10-round Rifle Clip Little Joe Arrow --> "Little Joe" Arrow Little Joe Arrow --> "Little Joe" Arrow M-1 Carbine Clip --> M1 Carbine Clip M20 Bazooka Shell --> M20 "Super Bazooka" Shell M20 Bazooka rocket (Armor Piercing) --> M20 "Super Bazooka" Shell (Armor Piercing) MG34 Boxed Cartridge Belt --> MG34 Drum Magazine Mauser 1912 Pistol Clip --> Mauser C-96 1912 Pistol Clip Mauser M.712 Pistol Clip --> Mauser C-96 M712 Pistol Clip Mosin Rifle Clip --> Mosin-Nagant Rifle Clip Nagant 1896 Cartridges --> 7.62mm Nagant Revolver Cartridges PIAT rocket. --> PIAT rocket PTR "Boys" --> .55 Boys PTR Boys Magazine --> Boys Anti-tank Rifle Magazine Panzershrek Rocket Propelled Grenade --> Panzerschrek Rocket Propelled Grenade STG43 SMG Magazine --> STG44 SMG Magazine SVT- 40 Rifle Clip --> SVT40 Rifle Clip Sauer 38X Pistol Clip --> Sauer 38 Pistol Clip Speedloader for Six .38 rounds --> Speedloader for Six .455 rounds Sterling Patchett Clip --> Sterling SMG Clip Stuning Dart --> Tranquilizer Dart TKB408 Clip --> TKB-408 Clip TT Pistol Clip --> TT-33 Pistol Clip Thompson 1928 SMG Magazine --> Thompson M1 Magazine Thompson M1 SMG Drum Magazine --> Thompson 1928 Drum Magazine Vickers 12.7 Boxed Cartridge Belt. --> Vickers 12.7mm Boxed Cartridge Belt ** Weapons ** AK47 --> AK-47 Bazooka M1 --> M1 "Bazooka" Beretta M38-42 --> Beretta M38/42 Beretta M38-42 Silenced --> Beretta M38/42 Silenced Black Jack Club --> Blackjack Bren --> Bren Mk1 Light Machine Gun Browning M1922 --> Browning Automatic Rifle M1922 Carbine 1938 --> Mosin-Nagant Carbine 1938 Carbine 98K Scoped --> Mauser Carbine 98K Scoped Carbine 98K Scoped, Silenced --> Mauser Carbine 98K Scoped, Silenced Carbine DeLizl Silenced --> DeLisle Carbine Silenced Carbine M1 1936 --> M1 Carbine 1936 Chakra --> Chakram Chatellerault M1924/1929 --> Chatellerault M1924/29 DP --> Degtyarev DP-28 FG 42 --> FG42 G-41 W --> G41(W) G-41 W Scoped --> G41(W) Scoped Garand M1 --> M1 Garand Garand M1 Scoped --> M1 Garand Scoped Johnson Light Gun --> Johnson Light Machine Gun Khukuri Knife --> Khukri Knife Luger British --> Luger .45 M20 Bazooka --> M20 "Super Bazooka" M3A1 --> M3A1 "Grease Gun" M3A1 Silenced --> M3A1 "Grease Gun" Silenced MG 34 --> MG34 MG-34 Tripod Mounted --> MG34 Tripod Mounted MP 28 - Bergmann --> Bergmann MP 28 MP 38 --> MP38 MP 40 --> MP40 MP 40-II --> MP40/II Mauser K96 1912 --> Mauser C-96 1912 Mauser K96 1912 Silenced --> Mauser C-96 1912 Silenced Mauser K96 1926 --> Mauser C-96 1926 Mauser M.712 --> Mauser C-96 M712 Mosin 1891-1930 --> Mosin-Nagant 1891/30 Mosin 1891-1930 Scoped --> Mosin-Nagant 1891/30 Scoped Nagant 1910 --> Nagant Revolver 1910 Nagant 1910 Silenced --> Nagant Revolver 1910 Silenced PIAT --> PIAT Rocket Launcher PIAT Rocket Launcher --> Panzerklein PIAT Rocket Launcher PTR Boys Gun --> Boys Anti-tank Rifle Pukke Knife --> Puukko Knife Rifle 33-40 --> CZ 33/40 Carbine Rifle 33-40 Scoped --> CZ 33/40 Carbine Scoped STG 43 --> STG44 SVT 40 --> SVT40 SVT 40 Scoped --> SVT40 Scoped Sauer 38X --> Sauer 38 Sten Mk II --> Sten MkII Sten Mk IV --> Sten MkIV Sten Mk V --> Sten MkV Sterling Patchett --> Sterling L2A3 Sterling Patchett Para --> Sterling Mk7 Para Sterling Patchett Silencer --> Sterling L34A1 Silenced Stun Air-Rifle Silenced --> Tranquilizer Rifle Silenced Stun Pistol Silenced --> Tranquilizer Pistol Silenced Suomi --> Suomi M1931 TKB408 --> TKB-408 TT 1933 --> Tokarev TT-33 Thompson 1923 --> Thompson 1928 Thompson 1928 --> Thompson M1 Vickers 12.7 --> Vickers Machine Gun Vickers Machine Gun --> Panzerklein Vickers Machine Gun Volksgewehr45 --> Volksgewehr VG1-5 Wood Chopping Axe --> Hatchet ZB 26-30 --> ZB 26/30 ** Other Equipment ** Advanced Picklock --> Advanced Lockpick Bullet Extractor. --> Bullet Extractor Decyphering Book --> Deciphering Book Forceps, Abbey --> Kelly Forceps Hecsogen Charge --> Hexogen Charge Meduim --> Medium Metal Scissors --> Bolt cutters Nytroglycerin Charge --> Nitroglycerin Charge Picklock --> Lockpick Picklock Set --> Lockpick Set

I'm trying to figure out what to do with the British Luger. I honestly have no idea what this ".38 British Service" is and can't find any record of it. I've just made it a 9mm for now, which from what I can tell is what the British versions used. But now it's not really any different from the standard P08, so what's the point? I'm considering changing it to a .45 Luger, which was a very rare .45 ACP variant that was made as a submission for US Army testing in 1906. It wouldn't make any sense at all for it to show up on the front lines, but then S3 seems to revel in making test and experimental weapons available to soldiers.

You know what? It seems to have worked after all. I was testing this in an existing S3 game that I added the mod to using S3AddMod.exe. The Johnson LMG I carried still listed ".30 Carbine" as its ammo type, but when I unloaded it, the ammo clip correctly said ".30-06 Springfield". I sold the Johnson back to the store then bought it again. Voila! It now lists its ammo as .30-06 and so do the clips he sells. Hooray!

I'm trying to correct a few ammo issues (the Johnson LMG should use .30-06 and the Thompsons should both use .45 ACP). However, my changes to clips seem to have no effect on the game, even though my changes to weapon, ammo, and clip names are all working fine. What I've done is go into RPGClips and change the AmmoGroup for #103 (Johnson LMG clip) to "5", so that it uses the same ammo as the Browning BAR and M1 Garand. But this doesn't seem to change anything. So I assume I'm looking at the wrong column. I have no idea where else to look though. Has anyone had any success with this? P.S. This is for S3.

I'm working on a weapons mod myself. It fixes a lot of the problems you describe with regard to ammo and weapons. For instance, both Thompson SMGs will use .45 ACP ammo, and their names have been swapped. Also, the .38 Parabellum is changed to 9mm Parabellum, the 7.62mm Springfield is renamed to .30-06, and the 7.62mm Garand is changed to .30 Carbine. This is just a few examples; the whole list is too long for me to remember fully right now. Mainly it corrects strange errors and Americanizes ammo names where appropriate (what can I say, I'm American). After that's done, I'm going to look at adding new weapons.