$rs=$db->getAll($sql);
return $rs[0]["id"];
}
-
+/**
+ * TODO: short description.
+ *
+ * @param mixed $tab
+ * @param object $own
+ * @param mixed $fld
+ * @param mixed $val
+ *
+ * @return TODO
+ */
+function insertExtra($tab,$own,$fld,$val) {
+ global $db;
+ $sql = "insert into extra_felder (fkey,fval,tab,owner) ";
+ $sql.= "values ('$fld','$val','$tab','$own')";
+ $rc = $db->query($sql);
+ return $rc;
+}
function suchFirma($tab,$data) {
// gibt die Firma ?
global $db;
if (!$rs) {
$org=$data;
while(strpos($data," ")>0) {
- $data=ereg_replace(" "," ",$data);
+ $data=str_replace(" "," ",$data);
}
$data=preg_replace("/[^A-Z0-9]/ ",".*",trim($data));
$sql="select * from $tab where upper(name) ~ '$data'";
$sql="select id from $tabelle where upper(".$tabelle."number) = '$nummer'";
$rs=$db->getAll($sql);
if (!$rs) {
- $nr=ereg_replace(" ","%",$nummer);
+ $nr=str_replace(" ","%",$nummer);
$sql="select id,".$tabelle."number from $tabelle where upper(".$tabelle."number) like '$nr'";
$rs=$db->getAll($sql);
if ($rs) {
- $nr=ereg_replace(" ","",$nummer);
+ $nr=str_replace(" ","",$nummer);
foreach ($rs as $row) {
- $tmp=ereg_replace(" ","",$row[$tabelle."number"]);
+ $tmp=str_replace(" ","",$row[$tabelle."number"]);
if ($tmp==$nr) return $row["id"];
}
} else {