FUNCTION Query($query) {
$result = MySQL_Query($query, $this->DB) OR Die(VA_Message("MySQL Error #".MySQL_ErrNo()." :\n".MySQL_Error()."\n".$query, "bug"));
$this->affected_rows = MySQL_Affected_Rows($this->DB);
$this->mysql_queries++;
RETURN NEW result($result);
}
$lang = Explode("|", $file[$i]);
$lang[1] = MySQL_Escape_String($lang[1]);
Query("INSERT delayed ignore INTO va_languages VALUES ('lv', '".$lang[0]."', '".$lang[1]."', '".$lang[2]."')") OR Die("#".MySQL_ErrNo()." : ".MySQL_Error());
}
FOR($i = 0; $i < Count($file_en); $i++) {
$file_en[$i] = Ereg_Replace("([\$\"\;\t])", "", $file_en[$i]);
$file_en[$i] = Str_Replace("( =)|(\\\\)", "|", $file_en[$i]);
$lang = Explode("|", $file_en[$i]);
$lang[1] = MySQL_Escape_String($lang[1]);
Query("INSERT delayed ignore INTO va_languages VALUES ('lv', '".$lang[0]."', '".$lang[1]."', '".$lang[2]."')") OR Die("#".MySQL_ErrNo()." : ".MySQL_Error());
}
UnSet($file);
$file = File("scripts/languages/it.php");
FOR($i = 0; $i < Count($file); $i++) {
$file[$i] = Ereg_Replace("([\$\"\;\t])", "", $file[$i]);
$file[$i] = Str_Replace(" =", "|", $file[$i]);
$lang = Explode("|", $file[$i]);
$lang[1] = MySQL_Escape_String($lang[1]);
Query("INSERT delayed ignore INTO va_languages VALUES ('it', '".$lang[0]."', '".$lang[1]."', '".$lang[2]."')") OR Die("#".MySQL_ErrNo()." : ".MySQL_Error());
}
FOR($i = 0; $i < Count($file_en); $i++) {
$file_en[$i] = Ereg_Replace("([\$\"\;\t])", "", $file_en[$i]);
$file_en[$i] = Str_Replace("( =)|(\\\\)", "|", $file_en[$i]);
$lang = Explode("|", $file_en[$i]);
$lang[1] = MySQL_Escape_String($lang[1]);
Query("INSERT delayed ignore INTO va_languages VALUES ('it', '".$lang[0]."', '".$lang[1]."', '".$lang[2]."')") OR Die("#".MySQL_ErrNo()." : ".MySQL_Error());
}
?>
MySQL_Query($query) or die("nepovedlo se založit tabulku oddily");
echo date("H:i:s")." tabulka oddíly úspěšně založena<br>\n";
break;
case "oddily_import":
MySQL_Query("INSERT INTO oddily SET id='1000', nazev='individuální členové'"); // individualni clenove
$count=1;
$res=MySQL_Query("SELECT * FROM fox2_regoddil");
while ($oddil=MySQL_Fetch_Assoc($res)):
$count++;
if ($oddil[oddil]<>AddSlashes($oddil[oddil])) echo "záznam #$oddil[id] obsahuje neplatné znaky v názvu oddílu<br>";
do {
$unique=mt_rand(1001,9999);
$query="INSERT INTO oddily SET id='$unique', nazev='$oddil[oddil]', doplnek='$oddil[o_dopadr]', ulice='$oddil[o_ulice]', obec='$oddil[o_obec]', psc='$oddil[o_psc]', mobil='$oddil[o_tel1]', telefon='$oddil[o_tel2]', email='$oddil[o_email1]', web='$oddil[o_www]', ic='$oddil[ic]', banka='$oddil[banka]', vs='$oddil[var_sym]', regmv='$oddil[regmv]', fox_id='$oddil[id]', fox_kod='$oddil[kod]'";
$result=MySQL_Query($query);
if (!$result) echo "záznam #$oddil[id] se nevložil SQL: ".MySQL_Error()."<br>\n";
} while (!$result);
endwhile;
MySQL_Free_Result($res);
echo date("H:i:s")." tabulka oddíly úspěšně naplněna ($count záznamů)<br>\n";
break;
case "oddily_check":
$res=MySQL_Query("SELECT nazev,count(*) as count FROM oddily WHERE platne='A' GROUP BY nazev HAVING count>1");
while ($record=MySQL_Fetch_Assoc($res)) echo "DUPLICITY nazev=$record[nazev] $record[count]<br>\n";
MySQL_Free_Result($res);
$res=MySQL_Query("SELECT fox_id,count(*) as count FROM oddily WHERE fox_id<>'' GROUP BY fox_id HAVING count>1");
while ($record=MySQL_Fetch_Assoc($res)) echo "DUPLICITY fox_id=$record[fox_id] $record[count]<br>\n";
MySQL_Free_Result($res);
$res=MySQL_Query("SELECT ic,count(*) as count FROM oddily WHERE ic<>00000000 GROUP BY ic HAVING count>1");
while ($record=MySQL_Fetch_Assoc($res)) echo "DUPLICITY ic=$record[ic] $record[count]<br>\n";
