Tfe

Blog/jokoak_euskaraz/shadow_tactics/csv_to_json_lvl.php

<?php

$file_csv = "levelOK.csv";

$json_files = glob("jsons/lvl_*.json");
if(!is_dir("eus"))
{
    mkdir("eus");
}

$strings= [];
foreach($json_files as $json_file)
{
    if (($handle = fopen($file_csv, "r")) !== FALSE){
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

            $id = $data[2];
            $file = $data[0];
            $strings[$id]  = $data[6];
        }

        $decoded = json_decode(file_get_contents($json_file),true);
        $data = file_get_contents($json_file);
        $lines_m_script = preg_split("/[\r\n]+/", $decoded["m_Script"]);
        $new_lines = "";

        foreach($lines_m_script as $line)
        {
            $data = preg_split("/\t/", $line);
            $id = $data[0];
            if(isset($strings[$id]) && !empty($data[3]))
            {
                $data[3] = $strings[$id];
            }
            $new_lines .= join("\t", $data)."\r\n";
        }
        $decoded["m_Script"] = $new_lines;

        file_put_contents("eus/".basename($json_file), json_encode($decoded, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES));

    }

}