0, "B" => 0, "F" => 0, "I" => 1, "R" => 0, "S" => 3, "T" => 3);
$arrStatistikFelderNummer = array(5); // default: Ort
$arrDefinitionenNummer = array(5,10,16,22,24); // Ort, Status, Gruppe, Anrede, Land
$arrSuchenFelderNummer = array( 0, 1, 2, 3, 4, 5, 6, 7, 8, 9,10,16,17,18,19,20,21,22,23,24);
$arrVorgabeSuchtext = array(1, 5, 4); // Name, Ort, PLZ
$arrSortierFelderNummer = array( 0, 1, 2, 3, 4, 5, 6, 7, 8, 9,10,16,17,18,19,20,21,22,23,24);
$arrVorgabeSortierkriterien = array(1, 5, 4); // Name, Ort, PLZ
$arrFeldbeschriftungenNachWert=array(
"" // "ID" // 0
,"" // ,"Name" // 1
,"" // ,"Vorname" // 2
,"" // ,"Adresse" // 3
,"" // ,"PLZ" // 4
,"" // ,"Ort" // 5
,"" // ,"TelNr" // 6
,"" // ,"MobNr" // 7
,"" // ,"EMail" // 8
,"" // ,"Weiteres" // 9
,"" // ,"Status" // 10
,"" // ,"ReserveB" // 11
,"" // ,"ReserveI" // 12
,"" // ,"ReserveT" // 13
," JJJJ-MM-TT" // ,"GDatum" // 14
," JJJJ-MM-TT" // ,"ADatum" // 15
,"" // ,"Gruppe" // 16
,"" // ,"Aufgaben" // 17
,"" // ,"Kommentar" // 18
,"" // ,"Web" // 19
,"" // ,"Bilder" // 20
,"" // ,"Dateien" // 21
,"" // ,"Anrede" // 22
,"" // ,"Firma" // 23
,"" // ,"Land" // 24
);
$arrFeldbeschriftungenVorWert=array(
"" // "ID" // 0
,"" // ,"Name" // 1
,"" // ,"Vorname" // 2
,"" // ,"Adresse" // 3
,"" // ,"PLZ" // 4
,"" // ,"Ort" // 5
,"" // ,"TelNr" // 6
,"" // ,"MobNr" // 7
,"" // ,"EMail" // 8
,"" // ,"Weiteres" // 9
,"" // ,"Status" // 10
,"" // ,"ReserveB" // 11
,"" // ,"ReserveI" // 12
,"" // ,"ReserveT" // 13
,"" // ,"GDatum" // 14
,"" // ,"ADatum" // 15
,"" // ,"Gruppe" // 16
,"" // ,"Aufgaben" // 17
,"" // ,"Kommentar" // 18
,"" // ,"Web" // 19
,"" // ,"Bilder" // 20
,"" // ,"Dateien" // 21
,"" // ,"Anrede" // 22
,"" // ,"Firma" // 23
,"" // ,"Land" // 24
);
$TableStructureEmpty = "("
."`ID` int(16) NOT NULL auto_increment,"
."`Name` text collate utf8_general_ci NOT NULL,"
."`Vorname` text collate utf8_general_ci NOT NULL,"
."`Adresse` text collate utf8_general_ci NOT NULL,"
."`PLZ` text collate utf8_general_ci NOT NULL,"
."`Ort` text collate utf8_general_ci NOT NULL,"
."`TelNr` text collate utf8_general_ci NOT NULL,"
."`MobNr` text collate utf8_general_ci NOT NULL,"
."`EMail` text collate utf8_general_ci NOT NULL,"
."`Weiteres` text collate utf8_general_ci NOT NULL,"
."`Status` text collate utf8_general_ci NOT NULL,"
."`ReserveB` int(1) NOT NULL,"
."`ReserveI` int(16) NOT NULL,"
."`ReserveT` text collate utf8_general_ci NOT NULL,"
."`GDatum` varchar(10) collate utf8_general_ci NOT NULL,"
."`ADatum` varchar(10) collate utf8_general_ci NOT NULL,"
."`Gruppe` text collate utf8_general_ci NOT NULL,"
."`Aufgaben` text collate utf8_general_ci NOT NULL,"
."`Kommentar` text collate utf8_general_ci NOT NULL,"
."`Web` text collate utf8_general_ci NOT NULL,"
."`Bilder` text collate utf8_general_ci NOT NULL,"
."`Dateien` text collate utf8_general_ci NOT NULL,"
."`Anrede` text collate utf8_general_ci NOT NULL,"
."`Firma` text collate utf8_general_ci NOT NULL,"
."`Land` text collate utf8_general_ci NOT NULL,"
." PRIMARY KEY (`ID`)"
." ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;";
$tmpOptions="M=" . $sprach_text[70] . "[ID]";
$tmpOptions.=",A1=frmDaten.php,M1=get,B1=ID,I1=[ID],T1=" . $sprach_text[61];
$tmpOptions.=",A2=lstDaten.php,M2=get,B2=ID,I2=[ID],T2=" . $sprach_text[60];
$tmpOptions.=",B11=Aktion,I11=D";
$DetailsBefehle=array(
"frmHochladen.php|" . $sprach_text[74] . "|ID=[ID],T=P,K=20", // picture
"frmHochladen.php|" . $sprach_text[229] . "|ID=[ID],T=F,K=21", // file
"frmDaten.php|" . $sprach_text[67] . "|ID=[ID],Aktion=N", // enter new data
"frmDaten.php|" . $sprach_text[68] . "|ID=[ID],Aktion=U", // update data
"frmDaten.php|" . $sprach_text[69] . "|ID=[ID],Aktion=K", // copy data
"lstExportieren.php|" . $sprach_text[77] . "|ID=[ID],Aktion=E,Dateiname=$DB_Tabelle,Alle=N", // export data
"frmAbfragen.php|" . $sprach_text[71] . "|$tmpOptions" // delete data
);
function adressen_calculation_doc() {
global $arrFeldbeschriftungenEng;
$R="";
return $R;
}
function SpecialTextConvert($T) {
// sometimes SQL error with Delta character: cannot update
$S=str_replace("\xCE" . "\x94","[Delta]",trim($T));
$S=str_replace("\xE2" . "\x80" . "\x93","-",trim($S)); // long dash
return $S;
}
?>