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; } ?>