extract-texture-names.py

import os

for f in sorted(os.listdir("AllModel")):
    if f.endswith(".mtl"):
        with open(f"AllModel/{f}", "rt") as file:
            for line in file:
                if line.startswith("\tmap_Kd "):
                    texture = line.rstrip()[-6:]
                    print(f"INSERT INTO \"model_texture\" VALUES('Stalker','{f.replace('mtl', 'mbac')}','{texture}');")
                    break
            else:
                raise Exception(f"WTF {f}")