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";