| 1 |
6daefa8c
|
Petr Lukašík
|
<?php
|
| 2 |
|
|
|
| 3 |
|
|
$language = 1;
|
| 4 |
|
|
$source = 5;
|
| 5 |
|
|
$lection = 7;
|
| 6 |
|
|
$cesta_ke_zvukum = "./voices/novy_adresar_pro_zvuky/Slov_7_lekce/";
|
| 7 |
|
|
|
| 8 |
|
|
function seznam_souboru($cesta) {
|
| 9 |
|
|
$p_dir = opendir($cesta);
|
| 10 |
|
|
if (Empty($p_dir)) {
|
| 11 |
|
|
|
| 12 |
|
|
return NULL;
|
| 13 |
|
|
}
|
| 14 |
|
|
while (($p = readdir($p_dir)) != NULL) {
|
| 15 |
|
|
if ($p == "." || $p == "..") {
|
| 16 |
|
|
continue;
|
| 17 |
|
|
}
|
| 18 |
|
|
$pole[] = $p;
|
| 19 |
|
|
}
|
| 20 |
|
|
|
| 21 |
|
|
sort($pole);
|
| 22 |
|
|
return $pole;
|
| 23 |
|
|
} // end function seznam_souboru
|
| 24 |
|
|
|
| 25 |
|
|
//print_r ( seznam_souboru($cesta_ke_zvukum) );
|
| 26 |
|
|
|
| 27 |
|
|
|
| 28 |
|
|
require_once("./classes/db.php");
|
| 29 |
|
|
$spojeni = new DB_Sql();
|
| 30 |
|
|
$dotaz = "SELECT * FROM dict
|
| 31 |
|
|
WHERE language LIKE '$language'
|
| 32 |
|
|
AND source LIKE '$source'
|
| 33 |
|
|
AND lection LIKE '$lection'
|
| 34 |
|
|
ORDER BY \"IDdict\"";
|
| 35 |
|
|
$spojeni->query($dotaz);
|
| 36 |
|
|
|
| 37 |
|
|
|
| 38 |
|
|
$seznam_souboru = seznam_souboru($cesta_ke_zvukum);
|
| 39 |
|
|
if ($seznam_souboru == NULL) {
|
| 40 |
|
|
echo "Chyba $cesta neexistuje.\n";
|
| 41 |
|
|
exit();
|
| 42 |
|
|
}
|
| 43 |
|
|
/* if (Count($seznam_souboru) != $spojeni->num_rows()) {
|
| 44 |
|
|
echo "Chyba. Pocet souboru neodpovida poctu zaznamu v db. ".Count($seznam_souboru)." ".$spojeni->num_rows()."\n";
|
| 45 |
|
|
exit();
|
| 46 |
|
|
}
|
| 47 |
|
|
*/
|
| 48 |
|
|
$i = 0;
|
| 49 |
|
|
$pocitadlo = 1;
|
| 50 |
|
|
while ($spojeni->next_record()) {
|
| 51 |
|
|
if ($pocitadlo != 0 + substr($seznam_souboru[$i], 4, 3) ) {
|
| 52 |
|
|
echo "Soubor $pocitadlo chybi - bude preskocen";
|
| 53 |
|
|
$pocitadlo++;
|
| 54 |
|
|
continue;
|
| 55 |
|
|
}
|
| 56 |
|
|
$translations[$spojeni->Record["idf"]] = $spojeni->Record["translation"];
|
| 57 |
|
|
$zdroj = $cesta_ke_zvukum.$seznam_souboru[$i];
|
| 58 |
|
|
$cil = "./voices/word/".$spojeni->Record["IDdict"].".mp3";
|
| 59 |
|
|
if (File_Exists($cil)) {
|
| 60 |
|
|
echo "Chyba $cil jiz neexistuje.\n";
|
| 61 |
|
|
continue;
|
| 62 |
|
|
}
|
| 63 |
|
|
rename($zdroj, $cil);
|
| 64 |
|
|
echo "Kopiruji $zdroj na $cil.\n";
|
| 65 |
|
|
|
| 66 |
|
|
$spojeni_up = new DB_Sql();
|
| 67 |
|
|
$dotaz_up = "UPDATE dict SET word_voice = 1
|
| 68 |
|
|
WHERE \"IDdict\" = ".$spojeni->Record["IDdict"];
|
| 69 |
|
|
$spojeni_up->query($dotaz_up);
|
| 70 |
|
|
$i++;
|
| 71 |
|
|
$pocitadlo++;
|
| 72 |
|
|
}
|
| 73 |
|
|
|
| 74 |
|
|
?>
|