Debug:/home/j9v8ap4mgedd/migrated_webspace/www/i-mon-it.de/server/index.php (#150 00.00.074 15.08.2026 /home/j9v8ap4mgedd/migrated_webspace/www/i-mon-it.de/server/index.php) Jetzt wird gleich als nächstes die Klasse imoniitsql instanziert.
Debug:/home/j9v8ap4mgedd/migrated_webspace/www/i-mon-it.de/server/index.php(#156 00.00.074 15.08.2026 /home/j9v8ap4mgedd/migrated_webspace/www/i-mon-it.de/server/index.php)
Debug:imonitsql::gettemplateInfo ( #453 00.01.198 21.08.2026) Nun beginnt die Darstellung der einzelnen Templates (Datei: "/home/j9v8ap4mgedd/migrated_webspace/www/i-mon-it.de/server/imonitsql.php"
Debug:imonitsql::gettemplateInfo (#477 00.01.198 21.08.2026) 423 Templates sind geladen.
| # | Bereich | Templatesname | Template SQL Statement |
| #498 1 | analytics | file | SELECT * FROM files where fileid=%d; |
| #498 2 | analytics | minfileid | select min(fileid) as minfileid from files where tokenid =%d and istdatei=%d; |
| #498 3 | analytics | updatecount | UPDATE files SET Zeilen = %d WHERE (fileid = %d); |
| #498 4 | analytics | fileversion | SELECT * FROM files where fileid=%d AND version="%s"; |
| #498 5 | analytics | filemittoken | SELECT * FROM files where fileid=%d and tokenid=%d; |
| #498 6 | analytics | fileusedintable | select count(fileid) as Anzahl from %s where fileid=%d; |
| #498 7 | analytics | getanalyseentry | select *from analyse where id = %d |
| #498 8 | analytics | getanalyserange | select *from analyse where id>= %d and id<=%d |
| #498 9 | analytics | eindeutig | Select * from filesunique where fileUid = %d; |
| #498 10 | analytics | getabfuid | SELECT * FROM filesunique where fileUid> %d; |
| #498 11 | analytics | rohdaten_per_app | select * from rohdaten where id>%d AND Tokenid = %d And Appnr=%d order by id; |
| #498 12 | analytics | dateientryexists | select fileid as id, ufileid as uid from files where tokenid=%d AND Webseite=%d AND Pfadt = '%s' AND Datei = '%s' AND version= '%s'; |
| #498 13 | analytics | dateiuniqueexists | select fileUid as uid,Titel, Bemerkung,public from filesunique where Pfadt='%s' AND Datei = '%s'; |
| #498 14 | analytics | methodentryexists | select fileid as id, ufileid as uid from files where tokenid=%d AND Webseite=%d AND Klasse='%s' AND Methode = '%s' AND version ='%s'; |
| #498 15 | analytics | methoduniqueexists | select fileUid as uid, Titel, Bemerkung from filesunique where Klasse='%s' AND Methode = '%s' And Webseite=%d; |
| #498 16 | analytics | missinguniquefileid | select * from files where ufileid =-1; |
| #498 17 | analytics | adddatei | INSERT INTO `files` (tokenid, istDatei, Pfadt, Datei,Titel,Bemerkung,Webseite, version,ufileid,rohdatenid,public) VALUES (%d, 1,'%s', '%s','%s','%s', %d, '%s',%d,%d,%d); |
| #498 18 | analytics | addudatei | INSERT INTO `filesunique` (istDatei, Pfadt, Datei,Titel,Webseite,rohdatenid,public) VALUES ( 1,'%s', '%s','%s', %d,%d,%d); |
| #498 19 | analytics | addmethode | INSERT INTO `files` (`tokenid`, `istDatei`, Klasse, Methode, Webseite,version,ufileid,rohdatenid) VALUES ( %d,%d, '%s', '%s', '%d','%s',%d,%d); |
| #498 20 | analytics | addumethode | INSERT INTO `filesunique` (istDatei, Klasse, Methode, Webseite, rohdatenid) VALUES ( 0, '%s', '%s', %d, %d); |
| #498 21 | analytics | statusanalytics | select max(rohdatenid) as rohdatenid from files where tokenid=%d and Webseite= %d; |
| #498 22 | analytics | missingstartid | select * from rohdaten where (BeginEnde='Endpage' or BeginEnde='End' or BeginEnde='mid') and StartId=0 and id>%d; |
| #498 23 | analytics | suchestartid | select max(id) as maxid from rohdaten where BeginEnde='%s' and Methodeoderdatei='%s' and id< %d; |
| #498 24 | analytics | addmapping | INSERT INTO analyticsmapping (fileid,fuid,tokenid, startid, endid, Dauer, ReportMonat, ReportJahr, ReportTag, anzahlZeilen, Sekunden,Sekundenaktualisiert,aktion,paid) VALUES (%d, %d, %d, %d, %d, '%s', '%s', %d, '%s',%d,%d,%d,'%s', %d); |
| #498 25 | analytics | addanalyse | INSERT INTO analyse (fuid,fileid, tokenid, startid, endid, Dauer, ReportMonat, ReportJahr, ReportTag, anzahlzeilen, gesamtzeilen,Zeit,sekundenaktualisiert,aktion, paid) VALUES (%d,%d, %d, %d, %d, '%s', '%s', %d, '%s', %d, %d,%d,%d,'%s', %d); |
| #498 26 | analytics | rohdatenrange | select * from rohdaten WHERE id>=%d AND id<=%d; |
| #498 27 | analytics | rohdatenrangeApp | select * from rohdaten where Appnr = %d and id>= %d and id <= %d order by fileid, BeginEnde; |
| #498 28 | analytics | addappkontrolpunkt | INSERT INTO analytikcheck (Kontrollpunkt, app) VALUES ('%s', %d); |
| #498 29 | analytics | correctstartid | UPDATE `rohdaten` SET `StartID` = '%d' WHERE (`id` = '%d'); |
| #498 30 | analytics | getufileids | Select ufileid from files where fileid = %d; |
| #498 31 | analytics | getfileidfürversion | Select fileid from files where ufileid = %d and version='%s'; |
| #498 32 | analytics | getufileid | Select * from files where fileid = %d and Webseite =%d; |
| #498 33 | analytics | getfileidversion | Select fileid from files where ufileid = %d and version ='%s'; |
| #498 34 | analytics | updateufileid | UPDATE rohdaten SET uniqueFileid = %d,fileid =%d WHERE (id = %d); |
| #498 35 | analytics | listfiles | select * from files where istDatei=1 group by Pfadt, datei; |
| #498 36 | analytics | correctfuid | UPDATE `files` SET `ufileid` = '%d' WHERE (`fileid` = '%d'); |
| #498 37 | analytics | Dateimitversion | select * from files where angelegt BETWEEN '%s' and '%s' and Webseite = %d; |
| #498 38 | analytics | fuidduplikate | select count(fileUid) as Anzahl, min(fileUid) as erstefuid, max(fileUid) as letztefuid,Klasse,istDatei, Methode, Pfadt, Datei from filesunique where Webseite=%d group by Klasse, Methode, Pfadt, Datei order by Anzahl desc; |
| #498 39 | analytics | getfuids | select fileUid as id from filesunique where Klasse ='%s' and Methode ='%s' and Pfadt ='%s' and Datei ='%s' and Webseite=%d order by id; |
| #498 40 | analytics | getfuidmethode | select fileUid as id from filesunique where Klasse ='%s' and Methode =' %s' and Webseite= %d order by id; |
| #498 41 | analytics | fuidduplikateDatei | select fileUid, Klasse,istDatei, Methode, Pfadt, Datei from filesunique where Webseite=%d and Pfadt ='%s' and Datei='%s' order by fileUid; |
| #498 42 | analytics | fuidduplikateMethode | select fileUid, Klasse,istDatei, Methode from filesunique where Webseite=%d Klasse='%s' and Methode ='%s' order by fileUid; |
| #498 43 | analytics | fuidduplicateMethodeNull | select fileUid, Klasse,istDatei, Methode from filesunique where Webseite=%d and isnull(Klasse) and isnull(Methode) order by fileUid; |
| #498 44 | analytics | fuidduplicateDateiNull | select fileUid, Klasse,istDatei, Methode from filesunique where Webseite=%d and isnull(Pfadt) and isnull(Datei) order by fileUid; |
| #498 45 | analytics | updatefuidanalyticsmapping | UPDATE Analyticsmapping SET `fuid` = '%d' WHERE (`anaid` = '%d'); |
| #498 46 | analytics | minmaxids | select min(id) as minid,max(id) as maxid from rohdaten where Appnr=%d; |
| #498 47 | analytics | analyticsmappingexists | Select* from analyticsmapping where startid=%d and endid= %d order by anaid desc; |
| #498 48 | analytics | analyticsmappingrange | select *from analyticsmapping where tokenid = %d and anaid>=%d and anaid>%d; |
| #498 49 | analytics | analyticsmappingab | select *from analyticsmapping where tokenid = %d and anaid>=%d; |
| #498 50 | analytics | Analysemonat | select fileid,fuid,ReportTag,id, paid, Dauer, min(startid) as startid, max(endid) as endid, count(id) as Anzahl, sum(Zeit) as Zeit,sum(anzahlZeilen) as anzahlZeilen, sum(gesamtzeilen) as gesamtzeilen ,ReportMonat,ReportJahr, aktion from analyse where tokenid = %d and ReportMonat= '%s' group by fuid order by ReportTag asc; |
| #498 51 | analytics | Analysemonatstats | Select count(id) as anzids, sum(gesamtzeilen) as gesamtzeilen, sum(Zeit) as Sekunden from analyse where tokenid= %d and ReportMonat =%s and Sekundenaktualisiert=1; |
| #498 52 | analytics | hatmapping | select * from analyticsmapping where startid<= %d and endid>= %d; |
| #498 53 | analytics | Zeitistzuaktualisieren | Select * from analyse where tokenid= %d and Sekundenaktualisiert =0; |
| #498 54 | analytics | analysesekundenaktualisieren | UPDATE analyse SET `Zeit` = '%d', `Sekundenaktualisiert` = '1' WHERE (`id` = ' %d'); |
| #498 55 | analytics | fileupdatefuid | update files set ufileid =%d where ufileid=%d and Webseite=%d; |
| #498 56 | analytics | updateistdateifilesunique | update filesunique set istDatei =%d where fileUid=%d; |
| #498 57 | analytics | updateistdateifiles | update files set istDatei =%d where ufileid=%d; |
| #498 58 | analytics | markerste | UPDATE filesunique SET `first` = 1 WHERE (fileUid = %d); |
| #498 59 | analytics | hasanalyse | select * from analyse where startid=%d and endid =%d; |
| #498 60 | analytics | updateanalysefuid | update analyse set fuid =%d where id=%d ; |
| #498 61 | analytics | updateanalysecheck | UPDATE analytikcheck SET RohdatenID = %d, letzteUeberpruefung=CURRENT_TIMESTAMP() WHERE (app = %d and Kontrollpunkt = 'Analysecheck'); |
| #498 62 | analytics | analysecheck | select RohdatenID from analytikcheck where Kontrollpunkt='Analysecheck' AND app=%d; |
| #498 63 | analytics | deleteanalyserecord | Delete from analyticsmapping where anaid=%d; |
| #498 64 | analytics | deleteanalyse | DELETE FROM analyse WHERE (`id` = %d); |
| #498 65 | analytics | correctanayticsmapping | Select analyticsmappingid from analytikcheck where Kontrollpunkt='Analyticsmappingcheck'and app=%d; |
| #498 66 | analytics | correctAnalyse | delete from Analyse where id>%d and startid=%d and endid= %d |
| #498 67 | analytics | updateanalytikcheckmapping | UPDATE analytikcheck SET letzteueberpruefung=CURRENT_TIMESTAMP(),RohdatenID=%d,analyticsmappingid = %d WHERE (App= %d and Kontrollpunkt = 'Analyticsmappingcheck'); |
| #498 68 | analytics | updateanalytikcheckmappingrohdaten | UPDATE analytikcheck SET letzteUeberpruefung=CURRENT_TIMESTAMP(), RohdatenID = %d WHERE (App= %d and Kontrollpunkt = 'Analyticsmappingcheck'); |
| #498 69 | analytics | updateanalytikcheckmappingAnalysefuid | UPDATE analytikcheck SET letzteUeberpruefung=CURRENT_TIMESTAMP(), analyseid = %d WHERE (App= %d and Kontrollpunkt = 'updatefuid'); |
| #498 70 | analytics | getanalyticsmapping | select * from analytikcheck where Kontrollpunkt='Analyticsmappingcheck' AND app=%d; |
| #498 71 | analytics | lastmapping | select max(anaid) as maxid, max(fileid) as lastfileid from analyticsmapping; |
| #498 72 | analytics | resetanalyticscheck | UPDATE analytikcheck SET letzteUeberpruefung = 0,analyseid=0,RohdatenID=0, analyticsmappingid=0 WHERE (app = %d); |
| #498 73 | analytics | countmissingrowcount | select count(id) as anzahl from analyse where tokenid=%d and (anzahlZeilen=0 or gesamtzeilen=0); |
| #498 74 | analytics | missingrowcount | select * from analyse where tokenid=%d and (anzahlZeilen=0 or gesamtzeilen=0); |
| #498 75 | analytics | updateanalyserows | UPDATE analyse SET anzahlZeilen = %d, gesamtzeilen = %d WHERE (id = %d); |
| #498 76 | analytics | getanalyseab | select * from analyse where id>= %d and tokenid=%d; |
| #498 77 | analytics | getanalyseabundfalschefuid | select * from analyse where id>= %d and tokenid=%d and fuid<1; |
| #498 78 | analytics | monatswertefuid | select count(id) as Anzahl, sum(gesamtzeilen) as Summezeilen, sum(Zeit) as SummeSekunden,ReportMonat from analyse where fuid=%d group by ReportMonat; |
| #498 79 | analytics | ersetzeanalysefuid | update analyse set fuid= %d where fuid = %d |
| #498 80 | analytics | ersetzeanalyticsmappingfuid | update analyticsmapping set fuid= %d where fuid = %d |
| #498 81 | analytics | ersetzerohdatenfuid | update rohdaten set uniqueFileid= %d where uniqueFileid = %d |
| #498 82 | analytics | ersetzefilesfuid | update files set ufileid= %d where ufileid = %d |
| #498 83 | analytics | versionenfuid | select Titel, Bemerkung, count(fileid) as anzahlfiles, version, ufileid from files where ufileid= %d group by version ; |
| #498 84 | analytics | aktuelleversionfuid | select max(version) as aktuelleversion from files where ufileid= %d; |
| #498 85 | analytics | anzahlversionenfuid | Select version, min(fileid) as minfileid,max(fileid) as maxfileid,count(fileid) as anzahlgleicheversion FROM files where ufileid=%d group by version; |
| #498 86 | analytics | checkanalyticsnewapp | INSERT INTO analytikcheck (Kontrollpunkt, app, RohdatenID, analyseid, analyticsmappingid) VALUES ('%s', '%d', '0', '0', '0'); |
| #498 87 | analytics | checkanalyticskontrollpunkte | select Kontrollpunkt from analytikcheck group by Kontrollpunkt; |
| #498 88 | analytics | checkkontrollpunktefürapp | select Kontrollpunkt from analytikcheck where app=%d order by Kontrollpunkt; |
| #498 89 | analytics | insert_clientperformance | INSERT INTO clientperformance (token,service,paid,zeilen,Sekunden,version) VALUES ( %d, '%s', %d, %d, %d, ' %s'); |
| #498 90 | analytics | AnzahlcheckanalyticsfürUniqueDatei | select * from analytikcheck where app=%d and fuid>=%d; |
| #498 91 | analytics | updatefilesbemerkung | UPDATE files SET Bemerkung = '%s' WHERE (`fileid` = '%d'); |
| #498 92 | berichte | filesperfuid | select * from files where ufileid=%d order by angelegt asc; |
| #498 93 | berichte | oeffentlich | select * from analyse where fuid in (%s) and tokenid =%d and ReportTag='%s'; |
| #498 94 | berichte | berichte | select * from berichte where Eintragart ="Bericht"; |
| #498 95 | berichte | bericht | select * from berichte where Eintragart ="Bericht" AND id=%d; |
| #498 96 | berichte | berichtbyname | select * from berichte where Eintragart ="Bericht" AND Bericht="%s"; |
| #498 97 | berichte | filterarten | select * from filterarten; |
| #498 98 | berichte | getfilter | select * from filter where filterid =%d; |
| #498 99 | berichte | getfilterbyname | select * from filter where filtername = '%s'; |
| #498 100 | berichte | getfilterbyapp | select * from filter where appid =%d; |
| #498 101 | berichte | sessionfilter | select filterid, phpsessionid from filter where appid = %d and filterartid=1 and phpsessionid !="%s" order by phpsessionid; |
| #498 102 | berichte | createfilter | INSERT INTO filter (filtername, appid, filterartid, phpsessionid, tabelle,Kunde,Benutzer,Protokoll,sqlstmt) VALUES ('%s' , %d, %d, '%s', '%s',%d,%d,%d,''); |
| #498 103 | berichte | createfirstfilterpartrow | INSERT INTO filterparts (filterid, phpsessionid, nurFehler,Reihenfolge) VALUES ('%d','%s',0, %d); |
| #498 104 | berichte | hatsessionfilter | select filterid from filter where filterartid=1 and phpsessionid="%s" and appid=%d and Protokoll =%d; |
| #498 105 | berichte | getoldsessionfilter | select filterid from filter where filterartid=1 and appid = %d and benutzer=%d and phpsessionid !='%s'; |
| #498 106 | berichte | deletefilterparts | delete from filterparts where filterid=%d; |
| #498 107 | berichte | deleteinkonsistentfilterparts | delete from filterparts where filterid=0; |
| #498 108 | berichte | deletefilterpartbyid | delete from filterparts where fpartid=%d; |
| #498 109 | berichte | deletefilter | delete from filter where filterid =%d |
| #498 110 | berichte | getfilterparts | select* from filterparts where filterid=%d order by Reihenfolge; |
| #498 111 | berichte | getdaterange_analyse | select min(ReportTag) as ersterTag, max(ReportTag) as letztertag from analyse where tokenid = %d; |
| #498 112 | berichte | getdaterange_rohdaten | select min(Zeitpunkt) as ersterTag, max(Zeitpunkt) as letztertag from rohdaten where Tokenid = %d; |
| #498 113 | berichte | getreportmonate_analyse | select reportmonat from analyse where tokenid =%d group by reportmonat order by reportmonat asc; |
| #498 114 | berichte | setfiltername | UPDATE filter SET `filtername` = '%s' WHERE (filterid = %d); |
| #498 115 | berichte | setsessionflter | UPDATE filter SET `filterartid` = %d WHERE (filterid = %d); |
| #498 116 | berichte | updateDatumfilterpart | UPDATE filterparts SET `istdatumsfilter` = 1, von='%s', bis ='%s' WHERE (filterid = %d); |
| #498 117 | berichte | updatefuidmethode | UPDATE filterparts SET `fuid` = %d, isuniquefile=1, istdatei =0 WHERE (fpartid = %d); |
| #498 118 | berichte | getfuidreportmonat | select fileuid,Titel, concat(Pfadt,'/',datei) as dateilang, Pfadt from filesunique where Webseite=%d and angelegt>='%s'and istDatei=1; |
| #498 119 | berichte | getmethodefuidreportmonat | select fileuid,Titel, concat(Klasse,'::',Methode) as methodelang, Pfadt from filesunique where Webseite=%d and angelegt>='%s'and istDatei=0; |
| #498 120 | berichte | getfiltertabellen | SELECT * FROM filter_tabellen where tabelle!= 'protokoll' order by Tabelle; |
| #498 121 | berichte | validfiltertabelle | select* from filter_tabellen where tabelle='%s'; |
| #498 122 | berichte | setfiltertabelle | UPDATE filter SET Tabelle = '%s' WHERE (`filterid` = %d); |
| #498 123 | berichte | setpaidfilter | UPDATE filterparts SET ispaid = %d,paid= %d WHERE (filterid = %d); |
| #498 124 | berichte | setpaidfilterwert | UPDATE filterparts SET ispaid = %d,paid= %d WHERE (filterid = %d); |
| #498 125 | berichte | resetDatumfilterpart | UPDATE filterparts SET istdatumsfilter = 0, von=NULL, bis =NULL WHERE (filterid = %d); |
| #498 126 | berichte | resetfuidfilter | UPDATE filterparts SET isuniquefile = 0, fuid=0 WHERE (filterid = %d); |
| #498 127 | berichte | setprotokollfilterparts | UPDATE filterparts SET nurFehler = %d, istprotokoll = %d WHERE (fpartid = %d); |
| #498 128 | berichte | setsortierung | UPDATE filter SET sortierung ='%s', absteigend = %d WHERE (filterid = %d); |
| #498 129 | berichte | setgruppierung | UPDATE filter SET gruppierung ='%s' WHERE (filterid = %d); |
| #498 130 | berichte | setundoder | UPDATE filterparts SET undoder =%d WHERE (fpartid = %d); |
| #498 131 | berichte | setreportmonat | UPDATE filterparts SET istmonatsfilter =%d,istdatumsfilter=0, reportmonat='%s' WHERE (fpartid = %d); |
| #498 132 | berichte | AnzahlfilterpartsfürUniqueDatei | select* from filterparts where fuid=%d order by filterid; |
| #498 133 | berichte | Langlaeufer | select * from analyse where Zeit>%d and tokenid=%d and ReportTag=curdate() order by Zeit desc; |
| #498 134 | berichte | LanglauferReporttag | select * , (endid-startid+1) as anz, (endid-startid+1)/Zeit as ids, gesamtzeilen/Zeit as lps from analyse where tokenid=%d and ReportTag='%s' order by lps desc; |
| #498 135 | berichte | LanglauferletzteTage | select * from analyse where Zeit>%d and tokenid=%d and ReportTag>=curdate()-%d order by Reporttag,Zeit desc; |
| #498 136 | berichte | fuidreport | Select * from analyse where fuid = %d order by id desc; |
| #498 137 | berichte | filterart | select * from filterarten where filterartid=%d; |
| #498 138 | berichte | setfilterart | UPDATE filter SET filterartid = %d WHERE filterid = %d; |
| #498 139 | berichte | Filterartbyname | select *from filterarten where name='%s'; |
| #498 140 | berichte | Benutzerfilter | SELECT * FROM filter where filterartid=2 and Benutzer = %d; |
| #498 141 | berichte | kundenfilter | SELECT * FROM filter where filterartid=3 and kunde = %d; |
| #498 142 | berichte | benutzerfilter | SELECT * FROM filter where benutzer = %d; |
| #498 143 | berichte | appfilter | SELECT * FROM filter where appid = %d; |
| #498 144 | berichte | maxfilterid | select max(filterid) as maxid from filter; |
| #498 145 | berichte | hatklasse | select* from filesunique where Klasse>'%s' and Webseite=%d; |
| #498 146 | berichte | updatefilterpartsklasse | UPDATE filterparts SET Klasse = '%s' WHERE (filteridid = %d and istklasse=1); |
| #498 147 | berichte | file_analyse | select * from analyse where fileid=%d; |
| #498 148 | berichte | file_rohdaten | select * from rohdaten where fileid=%d; |
| #498 149 | berichte | updatefiltersql | UPDATE filter SET sqlstmt = '%s' WHERE (filterid = %d); |
| #498 150 | berichte | getklassen | SELECT Klasse FROM filesunique where Webseite=%d and istDatei=0 group by klasse; |
| #498 151 | berichte | getpfade | SELECT Pfadt FROM filesunique where Webseite=%d and istDatei=1 group by Pfadt; |
| #498 152 | berichte | hatKlasse | SELECT * FROM filesunique where Klasse = '%s' and Webseite=%d and istDatei=0; |
| #498 153 | berichte | setKlassenfilter | UPDATE filterparts SET isKlasse=%d Klasse='%s' WHERE (filterid = %d) |
| #498 154 | berichte | resetklasseBereich | UPDATE filterparts SET aktion='', Klasse='',Methode='',Pfadt = '', Datei='' WHERE (fpartid = %d); |
| #498 155 | berichte | setpfadt | UPDATE filterparts SET isPath= 1,Pfadt='%s' WHERE (fpartid = %d); |
| #498 156 | berichte | getbereich | select * from filesunique where Pfadt='%s' and Webseite=%d; |
| #498 157 | berichte | setprotokollfilter | UPDATE filter SET Tabelle='Protokoll',Protokoll = %d WHERE (filterid = %d); |
| #498 158 | intern | fuidstats | select aktion, count(id) as Anzahl, sum(gesamtzeilen) as zeilen,sum(Zeit) as gesamtZeit, avg(Zeit) as dzeit from analyse where fuid=%d and id>=%d and id<=%d and aktion='%s'; |
| #498 159 | intern | findmethode | select fileuid,Titel, concat(Klasse,'::',Methode) as methodelang, Pfadt from filesunique where Klasse='%s' and Methode='%s' and Webseite=%d and istDatei=0; |
| #498 160 | intern | getfehler | select * from protokoll where protokollid=%d and istFehler=1; |
| #498 161 | intern | Fehlerhistorie | SELECT * FROM protokoll_log where protokollid = %d order by Zeitpunkt; |
| #498 162 | intern | addFehlerhistorie | INSERT INTO protokoll_log (protokollid, Benutzer, Bemerkung, geschlossen) VALUES (%d, %d, '%s', %d); |
| #498 163 | intern | fixprotokoll | UPDATE protokoll SET istkorrigiert = 1, programclosed=%d,korrigiertam=CURRENT_TIMESTAMP() WHERE (protokollid = %d); |
| #498 164 | intern | nextfehler | select* from protokoll where protokollid>%d and istFehler=1 And istkorrigiert =0; |
| #498 165 | intern | fehlerstandbydatei | select count(protokollid) as anzahlfehler,max(Zeitpunkt) as letztereintrag, Kundennummer,DateioderMethode, istkorrigiert, korrigiertam from protokoll where istFehler=1 and token=%d group by Kundennummer, DateioderMethode order by anzahlfehler desc; |
| #498 166 | intern | protokollrange | select * from protokoll where token=%d and protokollid>=%d and protokollid<=%d order by protokollid asc; |
| #498 167 | intern | fehlerstand | select count(protokollid) as anzahlfehler,max(Zeitpunkt) as letztereintrag, Kundennummer, prioritaet,istkorrigiert, korrigiertam, avg(Zeitpunkt-korrigiertam) as durchfixdauer from protokoll where istFehler=1 and istkorrigiert =0 and token=%d group by Kundennummer, prioritaet; |
| #498 168 | intern | fehlerrange | select count(protokollid) as anzahlfehler,max(Zeitpunkt) as letztereintrag, Kundennummer, max(Prioritaet) as Prioritaet,istkorrigiert, korrigiertam, avg(Zeitpunkt-korrigiertam) as durchfixdauer from protokoll where istFehler=1 and istkorrigiert =0 and token=%d and protokollid>=%d and protokollid<=%d order by protokollid asc; |
| #498 169 | intern | nextoffenfehler | select min(protokollid) as minid from Protokoll where istFehler=1 and istkorrigiert=0 and token= %d; |
| #498 170 | intern | offenefehlerbytag | select count(protokollid) as anzahl, Zeitpunkt, date(Zeitpunkt) as Tag, Prioritaet, now()-Zeitpunkt as Daueroffen from protokoll where istFehler=1 And istkorrigiert =0 and token=%d group by Tag order by Tag asc; |
| #498 171 | intern | offenefehlerseit | select count(protokollid) as anzahl, Zeitpunkt, date(Zeitpunkt) as Tag, Prioritaet, now()-Zeitpunkt as Daueroffen from protokoll where istFehler=1 And istkorrigiert =0 and token=%d and Tag>='%s' group by Tag order by Tag asc; |
| #498 172 | intern | offenefehlerbyDatei | select min(protokollid) as ersteid, max(protokollid) as letzteid, count(protokollid) as anzahl, max(version) as letzteversion,DateioderMethode, min(Zeitpunkt) as ersterfehler, max(Zeitpunkt) as letzterEintrag from protokoll where istFehler=1 And istkorrigiert =0 and token=%d group by DateioderMethode order by letzterEintrag desc, DateioderMethode asc; |
| #498 173 | intern | offenefehlerbytagrange | select count(protokollid) as anzahl, Zeitpunkt, date(Zeitpunkt) as Tag, Prioritaet, now()-Zeitpunkt as Daueroffen from protokoll where istFehler=1 And istkorrigiert =0 and protokollid>=%d and protokollid<=%d and token=%d group by Tag order by tag asc; |
| #498 174 | intern | fehlerbytoken | select * from protokoll where istfehler =1 and token = %d; |
| #498 175 | intern | fehlerbydateioderMethode | select * from Protokoll where DateioderMethode='%s' and istkorrigiert=0 order by Zeitpunkt desc; |
| #498 176 | intern | letzteroffenerfelherbydateioderMethode | select max(protokollid) as letzteid,Zeitpunkt from Protokoll where DateioderMethode='%s' and istkorrigiert=0 order by Zeitpunkt desc; |
| #498 177 | intern | fehlerheute | select * from protokoll where istfehler =1 and token = %d and date(Zeitpunkt)=curdate(); |
| #498 178 | intern | fehlergestern | select * from protokoll where istfehler =1 and token = %d and date(Zeitpunkt)=curdate()-1; |
| #498 179 | intern | fixprotokolltext | UPDATE protokoll SET istkorrigiert = 1, programclosed=false,korrigiertam=CURRENT_TIMESTAMP() WHERE istfehler=1 AND istkorrigiert=0 AND (protokolltext = '%s'); |
| #498 180 | intern | Neuseitoffset | select * from files where date(angelegt) = curdate()-%d group by ufileid, version ; |
| #498 181 | intern | fehlerhaftefuid | select* from rohdaten where uniqueFileid =0 and date(Zeitpunkt)=curdate(); |
| #498 182 | intern | fehlerrohdatenheute | select count(id) as Anzahl,min(id) as minid, max(id) as maxid,sum(anzahlzeilen) as Zeilen, BeginEnde, date(Zeitpunkt) as Tag, max(Zeitpunkt) as letzterEintrag from rohdaten where date(zeitpunkt)=curdate() group by BeginEnde; |
| #498 183 | intern | sql_nutzung | SELECT *,date(letztenutzung) as tag FROM sql_nutzung order by letztenutzung desc; |
| #498 184 | intern | serviceperformanceseitvorgestern | select date(Zeitpunkt) as Datum,service ,count(id) as Anzahl , sum(dauer) as Millisekunden from performanceservice where date(Zeitpunkt)>curdate()-2 group by Datum,service; |
| #498 185 | kunde | kunden | select * from kunden; |
| #498 186 | kunde | lizensexists | SELECT * FROM lizenzenteile WHERE Lizensname='%s'; |
| #498 187 | kunde | lizensbyid | SELECT * FROM lizenzenteile WHERE Lizensid=%d; |
| #498 188 | kunde | hatLizens | SELECT Lizensid, Sum(Anzahl) as Anzahl FROM kundenlizenzen where Kundennummer= %d and Lizensid =%d and Anzahl>0; |
| #498 189 | kunde | Lizensbestellen | INSERT INTO `kundenlizenzen` (`Kundennummer`, `Lizensid`, `Anzahl`, `Besteller`, `paketid`,`Bereich`) VALUES (%d, %d, %d, %d, %d,'%s'); |
| #498 190 | kunde | Lizensteile | SELECT * FROM lizenzenteile Where Partner =%d; |
| #498 191 | kunde | updatetokenkunde | UPDATE token SET `customerid` = %d, 'letzteÄnderung' = CURRENT_TIMESTAMP() WHERE `tokenid` = %d; |
| #498 192 | kunde | updatetokenwebsiteid | UPDATE token SET `websiteid` = %d, 'letzteÄnderung'= CURRENT_TIMESTAMP()= WHERE `tokenid` = %d; |
| #498 193 | kunde | kundennummer_exists | SELECT Kundennummer FROM kunden where Kundennummer = %d; |
| #498 194 | kunde | kundenlizensen | SELECT * FROM kundenlizenzen WHERE Kundennummer=%d order by id; |
| #498 195 | kunde | allekundenlizenshistorie | SELECT * FROM kundenlizenzen WHERE Kundennummer=%d order by Paketid,Lizensid,id; |
| #498 196 | kunde | kundenlizenshistorie | SELECT * FROM kundenlizenzen WHERE Kundennummer=%d AND Lizensid=%d order by Paketid,Lizensid; |
| #498 197 | kunde | kunde | SELECT * FROM kunden where Kundennummer = %d; |
| #498 198 | kunde | benutzerupdateKundennummer | UPDATE `benutzer` SET `Kundennummer` = '%d' WHERE (`loginid` = '%d') |
| #498 199 | kunde | kunde_emailused | SELECT * FROM kunden where email = '%s'; |
| #498 200 | kunde | neuer_kunde | INSERT INTO `kunden` (`Kundenname`, `ist aktiv`, `firma`, `Land`, `email`, `hauptbenutzer`,Aktivierungscode) VALUES ('%s', 1, '%s', '%s', '%s', %d,'%s'); |
| #498 201 | kunde | tokendeskunde | SELECT * FROM token where customerid =%d; |
| #498 202 | kunde | benutzerKunde | SELECT * FROM benutzer WHERE Kundennummer = %d; |
| #498 203 | kunde | anzahlbenutzer | SELECT count(loginID) as anzahl FROM benutzer WHERE Kundennummer = %d; |
| #498 204 | kunde | kunde_aktivieren | UPDATE kunde SET `ist aktiv` = '1', `Aktivierungscode` = '' WHERE (`Kundennummer` = '%d'); |
| #498 205 | kunde | kundebyname | SELECT * FROM kunden where Kundenname = '%s'; |
| #498 206 | kunde | kundenlogincount | SELECT count(loginid) as anzlogin FROM benutzer where Kundennummer = '%d'; |
| #498 207 | kunde | kundenapps | SELECT * FROM apps where Kundennummer = %d; |
| #498 208 | kunde | setdefaultApp | UPDATE Kunden SET `defaultApp` = %d WHERE `Kundennummer` = %d; |
| #498 209 | kunde | sethauptbenutzer | UPDATE Kunde SET hauptbenutzer = %d WHERE `Kundennummer` = %d; |
| #498 210 | kunde | Kundenupdate | UPDATE `kunden` SET `%s` = '%s' WHERE (`Kundennummer` = %d); |
| #498 211 | kunde | rolleexists | SELECT * FROM rollen where Rollenname = '%s'; |
| #498 212 | kunde | rollenfürkunden | SELECT * FROM rollen WHERE Kundenrolle =1; |
| #498 213 | kunde | listerechte | SELECT * FROM rechte; |
| #498 214 | kunde | AGBszustimmen | UPDATE kunden SET 'AGBs zugestimmt' =CURRENT_TIMESTAMP() WHERE ('Kundennummer' = %d); |
| #498 215 | kunde | kundenprotokoll | select * from protokoll Where Kundennummer = %d |
| #498 216 | kunde | landesnamen_deutsch | SELECT Landesname_de FROM Länder order by Landesname_de; |
| #498 217 | kunde | Bestellungkündigen | UPDATE `kundenlizenzen` SET `gekündigt am` = CURRENT_TIMESTAMP(), `gekündigt durch` = '%d' WHERE `id` ='%d'; |
| #498 218 | App | landesnamen_englisch | SELECT Landesname_en FROM Länder order by Landesname_en; |
| #498 219 | App | token | Select * FROM token where token = "%s" |
| #498 220 | App | tokenbyid | Select * FROM token where tokenid = %d; |
| #498 221 | App | updatetokenhash | UPDATE token SET `crypt` = %s, 'letzteÄnderung' = CURRENT_TIMESTAMP() WHERE `tokenid` = %d; |
| #498 222 | App | appdeaktivieren | UPDATE `apps` SET `deaktiviert` = '%s', `deaktiviertam` = CURRENT_TIMESTAMP() WHERE appid=%d; |
| #498 223 | App | appreaktivieren | UPDATE `apps` SET `deaktiviert` = '', `deaktiviertam` = NULL WHERE appid=%d; |
| #498 224 | App | appexists | SELECT appid FROM apps where appid = %d; |
| #498 225 | App | tokenapps | SELECT * FROM apps where appid = %d; |
| #498 226 | App | countapps | SELECT count(*) as anzApps FROM apps; |
| #498 227 | App | getapp | SELECT * FROM apps where appid = %d; |
| #498 228 | App | gettoken | Select * from token where websiteid = %d; |
| #498 229 | App | getkundenapp | SELECT * FROM apps where Kundennummer=%d AND appid = %d; |
| #498 230 | App | appbyname | SELECT * FROM apps where Webseitenname = '%s'; |
| #498 231 | App | updateappname | UPDATE apps SET `Webseitenname` = '%s' WHERE `appid` = %d; |
| #498 232 | App | updateappurl | UPDATE apps SET `URL` = '%s' WHERE `appid` = %d; |
| #498 233 | App | updaterootdir | UPDATE apps SET `rootdirectory` = '%s' WHERE `appid` = %d; |
| #498 234 | App | LänderIDexists | select * from Laender where laender_id=%d; |
| #498 235 | App | land_de | select * from Laender where Landesname_de='%s'; |
| #498 236 | App | landid | SELECT * from Laender where Laender_id=%d; |
| #498 237 | App | länder | SELECT * FROM Laender ORDER BY Landesname_de; |
| #498 238 | App | updateland | UPDATE apps SET Laenderid = %d WHERE `appid` = %d; |
| #498 239 | App | programiersprachen | SELECT * FROM programmiersprachen; |
| #498 240 | App | sprache | SELECT * FROM programmiersprachen WHERE Sprachname= '%s'; |
| #498 241 | App | programiersprache | SELECT * FROM programmiersprachen WHERE Spracheid= %d; |
| #498 242 | App | updatesprache | UPDATE apps SET Programmiersprache = %d WHERE `appid` = %d; |
| #498 243 | App | approhdatenlimits | select max(id) as maxid,min(id) as minid from rohdaten where appnr=%d; |
| #498 244 | App | newapp | INSERT INTO apps (Webseitenname, Kundennummer, URL, deaktiviert, Programmiersprache,LAenderid, rootdirectory) VALUES ('%s', %d, '%s', 0, '', %d, '%s'); |
| #498 245 | App | reportmonate | select distinct ReportMonat from analyse where tokenid =%d order by ReportMonat |
| #498 246 | App | ZeilenApp | select fileid, ufileid,angelegt,Zeilen, last_value(version) as lastversion from files where Webseite=%d group by lastversion order by Zeilen desc; |
| #498 247 | benutzer | appfuids | SELECT * FROM filesunique where Webseite=%d and istDatei=1 and public =0; |
| #498 248 | benutzer | alleBenutzer | SELECT * FROM benutzer; |
| #498 249 | benutzer | login | SELECT * FROM benutzer WHERE Loginname = '%s'; |
| #498 250 | benutzer | getrolle | select rolle from benutzer where loginid=%d; |
| #498 251 | benutzer | rolle | SELECT * FROM rollen WHERE RollenZeile = %d; |
| #498 252 | benutzer | Benutzerberechtigung | Select * from rollenrechte where Rolle = %d and Berechtigung = %d; |
| #498 253 | benutzer | Berechtigung | SELECT RechteID FROM rechte where Berechtigung='%s'; |
| #498 254 | benutzer | rollenrechte | SELECT * FROM rollenrechte where rolle=%d; |
| #498 255 | benutzer | Benutzer_exisiert | SELECT * FROM benutzer WHERE loginname = '%s'; |
| #498 256 | benutzer | Benutzer_emailused | SELECT count(email) anzused FROM benutzer WHERE email = '%s' |
| #498 257 | benutzer | Benutzer_by_id | SELECT * FROM benutzer WHERE loginid = '%d' |
| #498 258 | benutzer | Benutzer_eines_Kunden | SELECT * FROM benutzer WHERE Kundennummer = '%d' |
| #498 259 | benutzer | Benutzer_aktivieren | UPDATE benutzer SET `aktiv` = '1', `Aktivierungscode` = '' WHERE (`loginid` = '%d'); |
| #498 260 | benutzer | Benutzer_aktivändern | UPDATE benutzer SET aktiv = %d WHERE (`loginid` = %d); |
| #498 261 | benutzer | Benutzer_setAttribut | UPDATE benutzer SET %s = %s WHERE (`loginid` = %d); |
| #498 262 | benutzer | Benutzer_by_login | SELECT * FROM benutzer WHERE loginname = '%s' |
| #498 263 | benutzer | Benutzer_anlegen | INSERT INTO benutzer (`Loginname`, `Passwort`, `Kundennummer`, `imonitmitarbeiter`, `email`, `defaultApp`, `Rolle`, `Aktivierungscode`,newsletter,hashed) VALUES ('%s', '%s', '%d', '%d', '%s', '%d', '%d', '%s',%d, %d); |
| #498 264 | benutzer | updatenewsletter | UPDATE benutzer SET `newsletter` = %d WHERE `loginid` = %d; |
| #498 265 | benutzer | updatedefaultapp | UPDATE benutzer SET `defaultApp` = %d WHERE `loginid` = %d; |
| #498 266 | benutzer | updatedauerlogin | UPDATE benutzer SET `Dauerlogin` = %d WHERE `loginid` = %d; |
| #498 267 | benutzer | updatebenutzeremail | UPDATE benutzer SET email` = %s WHERE `loginid` = %d; |
| #498 268 | benutzer | updatebenutzerrolle | UPDATE benutzer SET Rolle = %d WHERE `loginid` = %d; |
| #498 269 | benutzer | updateBenutzerbemerkung | UPDATE benutzer SET Bemerkung = '%s' WHERE `loginid` = %d; |
| #498 270 | benutzer | updateloginname | UPDATE benutzer SET loginname = '%s' WHERE `loginid` = %d; |
| #498 271 | benutzer | updatepasswort | UPDATE benutzer SET `passwort` = %s,hashed= %d WHERE `loginid` = %d; |
| #498 272 | benutzer | updatelastlogin | UPDATE benutzer SET letzteslogin = CURRENT_TIMESTAMP() , WHERE (loginid = %d); |
| #498 273 | benutzer | deactivateUser | UPDATE `benutzer` SET `aktiv` = '0' WHERE (`loginid` = %d); |
| #498 274 | benutzer | reactivateUser | UPDATE `benutzer` SET `aktiv` = '1' WHERE (`loginid` = %d); |
| #498 275 | benutzer | updateletzteslogin | update benutzer set letzteslogin=CURRENT_TIMESTAMP() where loginid=%d; |
| #498 276 | protokoll | hashpasswort | UPDATE benutzer SET Passwort = '%s', hashed = 1 WHERE (`loginid` = %d); |
| #498 277 | protokoll | protokollfehler | INSERT INTO protokoll (token,Zeitpunkt,DateioderMethode,Zeile,Protokolltext,Version,istFehler,Kundennummer, Prioritaet) VALUES (%d,current_timestamp(),'%s',%d,'%s','%s',1,%d, %d); |
| #498 278 | protokoll | protokollentry | INSERT INTO protokoll (token,Zeitpunkt,DateioderMethode,Zeile,Protokolltext,Version,istFehler,Kundennummer,Prioritaet) VALUES (%d,current_timestamp(),'%s',%d,'%s','%s',0,%d, %d); |
| #498 279 | protokoll | protokollmaxid | SELECT max(protokollid) as maxid, max(Zeitpunkt) as letzterEintrag FROM protokoll; |
| #498 280 | protokoll | letzterProtokolleintrag | SELECT * from protokoll Where protokollid = %d and token =%d; |
| #498 281 | protokoll | getprotokollrange | select * from protokoll where protokollid>=%d and protokollid<=%d and Token =%d; |
| #498 282 | protokoll | getprotokollrangefehler | select * from protokoll where protokollid>=%d and protokollid<=%d and Token =%d and istFehler=1; |
| #498 283 | protokoll | protokollstats | select min(protokollid) as minid,min(Zeitpunkt) as erstereintrag, max(protokollid) as maxid ,max(Zeitpunkt) as letztereintrag ,Kundennummer, token from protokoll where istFehler =0 and Kundennummer=%d and token=%d; |
| #498 284 | protokoll | protokollstatsbyday | select date(Zeitpunkt) as tag,count(protokollid) as anzahl, DateioderMethode, Kundennummer, token from protokoll where date(Zeitpunkt)>=curdate()-2 and Kundennummer=%d and token=%d group by tag order by tag asc; |
| #498 285 | protokoll | doppeltefehlervongesternoffen | select min(protokollid) as minid,max(protokollid) as maxid,date(Zeitpunkt) as tag, count(protokollid) as Anzahl, istkorrigiert, Protokolltext from protokoll where istfehler=1 and token=%d and istkorrigiert=0 and date(Zeitpunkt) |
| #498 286 | protokoll | offenefehlerbytagundtext | select * from protokoll where istfehler=1 and istkorrigiert=0 and date(zeitpunkt)='%s' and Protokolltext='%s'and token=%d; |
| #498 287 | rohdaten | anzahloffenprotokolltext | select count(protokollid) as anzahl, token from protokoll where protokolltext='%s' and istkorrigiert=0 and token= %d; |
| #498 288 | rohdaten | delete_rohdatensatz | DELETE FROM rohdaten WHERE (id = %d); |
| #498 289 | rohdaten | update_rohdatencheck | UPDATE analytikcheck SET RohdatenID = %d, letzteUeberpruefung=CURRENT_TIMESTAMP() WHERE (app = %d and Kontrollpunkt = 'Rohdaten'); |
| #498 290 | rohdaten | rohdatenupdateistDatei | SELECT * FROM rohdaten where Kundennummer= %d and Istdatei=1; |
| #498 291 | rohdaten | RohdatenMaxid | select max(id) as maxid, max(Zeitpunkt) as LetzterEintrag from rohdaten WHERE Methodeoderdatei='%s' AND Aktion='%s' AND Tokenid = %d; |
| #498 292 | rohdaten | RohdatenMaxidBeginEnde | select max(id) as maxid, max(Zeitpunkt) as LetzterEintrag from rohdaten WHERE Methodeoderdatei='%s' AND BeginEnde='%s' AND Tokenid = %d; |
| #498 293 | rohdaten | rohdatenlastentry | select max(id) as maxid, max(Zeitpunkt) as LetzterEintrag from rohdaten; |
| #498 294 | rohdaten | updaterohdaten_file | UPDATE rohdaten SET Pfad = '%s', Dateiname = '%s' WHERE (id = '%d'); |
| #498 295 | rohdaten | updaterohdaten_fileid | UPDATE rohdaten SET fileid = %d WHERE (id = %d); |
| #498 296 | rohdaten | rohdatenupdateistKlasse | SELECT * FROM rohdaten where Kundennummer= %d and Istdatei=0; |
| #498 297 | rohdaten | addrohdaten | INSERT INTO rohdaten (Zeitpunkt, Sessionid, Useragent, useragentid, BeginEnde, Methodeoderdatei, Programmzeile, Kundennummer, Appnr, Tokenid, StartID, Paid,istDatei,aktion,Version,anzahlzeilen,uniqueFileid,fileid) VALUES (CURRENT_TIMESTAMP(),"%s","%s",%d,"%s","%s","%s",%d,%d, %d, %d,%d,%d,"%s","%s", %d,%d, %d); |
| #498 298 | rohdaten | addrohdaten_Datei | INSERT INTO rohdaten (Zeitpunkt, Sessionid, Useragent, useragentid, BeginEnde, Methodeoderdatei, Programmzeile, Kundennummer, Appnr, Tokenid, StartID, Paid,istDatei,aktion,Version,Pfad,Dateiname,fileid,uniqueFileid,anzahlzeilen) VALUES (CURRENT_TIMESTAMP(),"%s","%s",%d,"%s","%s","%s",%d,%d, %d, %d,%d,%d,"%s","%s","%s","%s",%d,%d,%d); |
| #498 299 | rohdaten | addrohdaten_Methode | INSERT INTO rohdaten (Zeitpunkt, Sessionid, Useragent, useragentid, BeginEnde, Methodeoderdatei, Programmzeile, Kundennummer, Appnr, Tokenid, StartID, Paid,istDatei,aktion,Version,Klasse,Methode,fileid,uniqueFileid,anzahlzeilen) VALUES (CURRENT_TIMESTAMP(),"%s","%s",%d,"%s","%s","%s",%d,%d, %d, %d,%d,%d,"%s","%s","%s","%s", %d, %d,%d); |
| #498 300 | rohdaten | rohdatenstats | select max(id) as maxid, max(Zeitpunkt) as LetzterEintrag from rohdaten; |
| #498 301 | rohdaten | rohdatenstats2 | select BeginEnde,Methodeoderdatei,Aktion from rohdaten WHERE id=%d; |
| #498 302 | rohdaten | rohdatenstats3 | select count(id) as Anzahl, min(id) as minid, max(id) as maxid, max(Zeitpunkt) as Letztereintrag from rohdaten where Appnr=%d; |
| #498 303 | rohdaten | rohdatenstats4 | select count(id) as Anzahl, min(id) as minid, max(id) as maxid, max(Zeitpunkt) as Letztereintrag, BeginEnde from rohdaten where Appnr=%d group by BeginEnde; |
| #498 304 | rohdaten | rohdatenvonidbisid | select * from rohdaten WHERE id>=%d and id<=%d and Appnr=%d; |
| #498 305 | rohdaten | rohdatenvonbis | select * from rohdaten WHERE Zeitpunkt>='%s' and Zeitpunkt<='%s' AND Appnr=%d; |
| #498 306 | rohdaten | rohdatenvonid | select * from rohdaten WHERE id>=%d AND Appnr=%d; |
| #498 307 | rohdaten | rohdatenvonidfehlendezeilen | select * from rohdaten WHERE id>=%d AND BeginEnde in('end','endPage','mid','midPage') and Appnr=%d and anzahlzeilen<1; |
| #498 308 | rohdaten | updaterohdaten_datei | UPDATE rohdaten SET Istdatei=1, Pfad = '%s', Dateiname = '%s' WHERE (id = %d); |
| #498 309 | rohdaten | updaterohdaten_klasse | UPDATE rohdaten SET Klasse = '%s', Methode = '%s' WHERE (id = %d); |
| #498 310 | rohdaten | updaterohdaten_fileids | UPDATE rohdaten SET uniqueFileid= %d, fileid = %d WHERE (id = %d); |
| #498 311 | rohdaten | updaterohdaten_anzzeilen | UPDATE rohdaten SET startid= %d, anzahlzeilen = %d WHERE (id = %d); |
| #498 312 | rohdaten | updaterohdaten_Istdatei | UPDATE `rohdaten` SET `Istdatei` = ' %d' WHERE (id = '%d'); |
| #498 313 | rohdaten | updaterohdaten_startid | UPDATE rohdaten SET StartID = %d WHERE (id = '%d'); |
| #498 314 | rohdaten | findlastStartpage | select max(id) as Startid from rohdaten where BeginEnde='StartPage' and Appnr=%d and Fileid =%d and id <%d; |
| #498 315 | rohdaten | useragent | SELECT * FROM useragents WHERE agentid = '%d'; |
| #498 316 | rohdaten | useragentbyname | SELECT * FROM useragents WHERE useragent = '%s'; |
| #498 317 | rohdaten | addUseragent | INSERT INTO `useragents` (`useragent`) VALUES ('%s'); |
| #498 318 | rohdaten | maxid | select max(id) as maxid, max(Zeitpunkt) as LetzterEintrag from rohdaten; |
| #498 319 | rohdaten | maxidbyapp | select max(id) as maxid, max(Zeitpunkt) as LetzterEintrag from rohdaten where Appnr= %d; |
| #498 320 | rohdaten | getzeitpunkt | select Zeitpunkt, fileid from rohdaten WHERE id = %d; |
| #498 321 | rohdaten | getentry | Select * from rohdaten where id = %d; |
| #498 322 | rohdaten | getapprohdaten | Select * from rohdaten where Appnr = %d; |
| #498 323 | rohdaten | anzahlfehlendeufid | Select count(id) as anzahlfuidfehlt from rohdaten where uniqueFileid=-1; |
| #498 324 | rohdaten | anzahlfehlendefileid | Select count(id) as anzahlfuidfehlt from rohdaten where uniqueFileid=-1 or fileid =-1; |
| #498 325 | rohdaten | updatablerohdaten | select * from rohdaten where uniqueFileid=-1 and BeginEnde in ( 'EndPage','end'); |
| #498 326 | rohdaten | ErsterMonat | select min(Zeitpunkt) as ersterEintrag, month(zeitpunkt) as Monat, year(Zeitpunkt) as Jahr from rohdaten; |
| #498 327 | rohdaten | RohdatenMonate | select Tokenid,count(id) as anzahl,month(zeitpunkt) as Monat, year(Zeitpunkt) as Jahr from rohdaten WHERE Appnr='%d' AND Tokenid='%d'group by Monat, Jahr ; |
| #498 328 | rohdaten | RohdatenJahre | select Tokenid,count(id) as anzahl,year(Zeitpunkt) as Jahr from rohdaten WHERE Appnr='%d' AND Tokenid='%d'group by Jahr ; |
| #498 329 | rohdaten | RohdatenDateien | select Methodeoderdatei,Dateiname,Pfad, Klasse, Methode, Version from rohdaten group by Methodeoderdatei,Version; |
| #498 330 | rohdaten | FindStartid | select max(id) as startid, Programmzeile from rohdaten where BeginEnde='%s' AND fileid=%d and id<=%d; |
| #498 331 | rohdaten | ufileid_null | select * from rohdaten where uniqueFileid=-1 and Appnr=%d; |
| #498 332 | rohdaten | fileid_null | select * from rohdaten where fileid=-1 and Appnr=%d; |
| #498 333 | rohdaten | minmaxbyapp | select min(id) as minid, max(id) as maxid, count(id) as Anzahl from rohdaten where Appnr=%d; |
| #498 334 | rohdaten | rohdatenupdatefuid | update rohdaten set uniqueFileid =%d where uniqueFileid=%d and Appnr=%d; |
| #498 335 | rohdaten | rohdatenupdateistdatei | update rohdaten set Istdatei =%d where id=%d; |
| #498 336 | rohdaten | Anzahlunkorrigiert | select count(id) as anzahl from rohdaten where fileid=-1 and Appnr =%d; |
| #498 337 | rohdaten | Rohdatenweisen | select RohdatenID from analytikcheck where Kontrollpunkt='Rohdatenweisen' AND app=%d; |
| #498 338 | rohdaten | Rohdatenfürweisen | Select * from rohdaten where BeginEnde in ('start','startPage') and Id>%d and Appnr=%d; |
| #498 339 | rohdaten | StatsRohdatenfehlendestartid | Select count(id) as Anzahl, max(id) as maxid, min(id) as minid , min(Zeitpunkt) as ersterEintrag, max(Zeitpunkt) as Letztereintrag from rohdaten where BeginEnde in ('end','endPage', 'mid', 'midPage') and startId<=0 and Appnr=%d order by id asc; |
| #498 340 | rohdaten | updateRohdatenweisen | UPDATE analytikcheck SET RohdatenID = %d, analyseid = %d,analyticsmappingid= %d,letzteUeberpruefung=CURRENT_TIMESTAMP() WHERE (Kontrollpunkt='Rohdatenweisen' and app= %d); |
| #498 341 | rohdaten | updateRohdatenseitenid | UPDATE analytikcheck SET RohdatenID = %d,letzteUeberpruefung=CURRENT_TIMESTAMP() WHERE (Kontrollpunkt='updateSeitenID' and app= %d); |
| #498 342 | rohdaten | getRohdatenseitenid | SELECT RohdatenID,analyseid from analytikcheck WHERE (Kontrollpunkt='updateSeitenID' and app= %d); |
| #498 343 | rohdaten | deleterohdatenentry | Delete from rohdaten where Id=%d; |
| #498 344 | rohdaten | hasEndid | select * from rohdaten where StartID=%d; |
| #498 345 | rohdaten | getanaid | Select id, endid from analyse where tokenid = %d and startid = %d; |
| #498 346 | rohdaten | resetstartid | UPDATE rohdaten SET StartID = 0 WHERE (Appnr = %d and StartID=id); |
| #498 347 | rohdaten | anzresetable | select * from rohdaten where id = StartID And Appnr=%d; |
| #498 348 | rohdaten | findStartentry | select * from rohdaten Where ID>%d and fileid=%d and beginende='%s' and appnr = %d; |
| #498 349 | rohdaten | findStartentry2 | select max(id) as newstartid from rohdaten Where ID<%d and beginende='%s' and appnr = %d and uniqueFileid=%d; |
| #498 350 | rohdaten | updatezeilen | UPDATE rohdaten SET anzahlzeilen = %d WHERE (id = %d); |
| #498 351 | rohdaten | Anzahlzeilen | select sum(anzahlzeilen) as anzahlzeilen from Rohdaten where id>=%d and id<=%d and Appnr=%d; |
| #498 352 | rohdaten | rohdatenannäherung | select id, fileid,Zeitpunkt,uniqueFileid from rohdaten where Zeitpunkt >='%s' and fileid =%d; |
| #498 353 | rohdaten | generellrohdatenupdate | update rohdaten set %s='%s' where id = %d; |
| #498 354 | rohdaten | countfuidperapp | select count(id) as anzahl, max(version) as letzteversion, uniqueFileid ,Appnr from Rohdaten where uniqueFileid=%d and Appnr=%d group by version order by anzahl desc; |
| #498 355 | rohdaten | countfuidanalyseperapp | select count(id) as anzahl, reportmonat,fuid from analyse where fuid=%d and tokenid=%d group by reportmonat order by anzahl desc; |
| #498 356 | rohdaten | StatsRohdatenFehlerbyservice | select count(id) as anzahl, min(id) as minid,max(id) as maxid, BeginEnde,min(Zeitpunkt) as erstereintrag,max(Zeitpunkt) as letztereintrag from rohdaten where BeginEnde in('end','endPage') and anzahlzeilen<=0 and Appnr=%d group by BeginEnde; |
| #498 357 | rohdaten | Rohdatenohnefileid | select count(id) as Anzahl,BeginEnde,IstDatei,Pfad,Klasse from rohdaten where uniqueFileid =0 group by BeginEnde; |
| #498 358 | rohdaten | rohdatenfehlermethode | select * from rohdaten where fileid=0 or uniqueFileid=0 and Appnr=%d. and Methodeoderdatei='%s'order by id; |
| #498 359 | rohdaten | rohdatenfehlendestartid | select * from rohdaten where Appnr=%d and startid=0 and BeginEnde in ('mid','midPage','end','endPage'); |
| #498 360 | resourcen | countRohdaten | select count(id) as Anzahl from rohdaten where AppNr=%d; |
| #498 361 | resourcen | Veranstaltungen | SELECT * FROM veranstaltungen WHERE bis>curdate() AND öffentlich=1; |
| #498 362 | resourcen | Veranstaltungsdetails | SELECT * FROM veranstaltungen WHERE Eventid=%d |
| #498 363 | admin | Neue Veranstaltung | INSERT INTO veranstaltungen (Name,Veranstaltungsort,von,bis,URL,Beschreibung,öffentlich) VALUES ('%s', '%s', '%s', '%s', '%s','%s',0); |
| #498 364 | admin | getanalyse | Select * from analyse where id> %d and tokenid = %d; |
| #498 365 | admin | analyseohnesekunden | Select * From analyse where Zeit=0; |
| #498 366 | admin | Sekundenaktualisieren | UPDATE analyse SET Zeit = %d WHERE (`id` = %d) |
| #498 367 | admin | statuschecking_updatzeile | select * from analytikcheck where Kontrollpunkt='updateZeilen' and app=%d; |
| #498 368 | admin | statuschecking_restorefuid | select * from analytikcheck where Kontrollpunkt='restorefuid' and app=%d; |
| #498 369 | admin | checkfilesunique | select count(fileUid) as Anzahl,min(fileUid) as minfuid ,max(fileUid) as maxuid, Klasse,istDatei, Methode, Pfadt, Datei from filesunique where Webseite=%d group by Klasse, Methode, Pfadt, Datei, istDatei order by Anzahl desc; |
| #498 370 | admin | checkfiles | select count(fileid) as Anzahl,min(fileid) as ersteid,Klasse, Methode, Pfadt, Datei, Webseite, version from files where Webseite=%d group by Klasse, Methode,Pfadt,Datei,version order by Anzahl desc; |
| #498 371 | admin | checkfileuid | select ufileid, fileid from files where fileid=%d; |
| #498 372 | admin | getuid | Select * from filesunique where fileUID =%d |
| #498 373 | admin | updateuidtitel | UPDATE filesunique SET Titel = '%s' WHERE (fileUid = %d); |
| #498 374 | admin | updatefilesfuidtitel | UPDATE files SET Titel = '%s' WHERE (ufileid = %d); |
| #498 375 | admin | updateuidfilesbemerkung | UPDATE files SET Bemerkung = '%s' WHERE (ufileid = %d); |
| #498 376 | admin | updateuidbemerkung | UPDATE filesunique SET Bemerkung = '%s' WHERE (fileUid = %d); |
| #498 377 | admin | updatefidrohdaten | UPDATE rohdaten set fileid=%d where fileid=%d; |
| #498 378 | admin | updatefidanalyse | UPDATE analyse set fileid=%d where fileid=%d; |
| #498 379 | admin | updatefidanalyticsmapping | UPDATE analyticsmapping set fileid=%d where fileid=%d; |
| #498 380 | admin | deletefid | delete from files where fileid=%d |
| #498 381 | admin | deletefuid | delete from filesunique where fileUid=%d |
| #498 382 | admin | updatefuidrohdaten | UPDATE rohdaten set uniqueFileid=%d where uniqueFileid=%d; |
| #498 383 | admin | updatefuidfiles | UPDATE files set ufileid=%d where fileid=%d; |
| #498 384 | admin | updatefuidanalyse | UPDATE Analyse set fuid=%d where id=%d; |
| #498 385 | admin | updatefuidfilesidinanalyse | UPDATE analyse SET fileid = %d, fuid = %d WHERE (id = %d); |
| #498 386 | admin | updatefileidanalyse | UPDATE Analyse set fileid=%d where id=%d; |
| #498 387 | admin | getanalyticscheck | select * from analytikcheck where app=%d; |
| #498 388 | admin | checkupdateZeilen | select * from analytikcheck where Kontrollpunkt='updateZeilen' and app=%d; |
| #498 389 | admin | getupdatefuidcheck | select id as id, analyseid as analyseid, analyticsmappingid as analyticsmappingid from analytikcheck where kontrollpunkt = '%s' and app= %d; |
| #498 390 | admin | getupdateduplicateanalyse | select id as id, analyseid as analyseid from analytikcheck where kontrollpunkt = 'duplicateanalyse' and app= %d; |
| #498 391 | admin | updatecheckZeilenrohdaten | update analytikcheck set letzteUeberpruefung=CURRENT_TIMESTAMP(), RohdatenID =%d where Kontrollpunkt='updatefuid' and app=%d; |
| #498 392 | admin | updateanalyticcheckduplicateanalyse | update analytikcheck set analyseid =%d where Kontrollpunkt='duplicateanalyse' and app=%d; |
| #498 393 | admin | updatecheckanalysefuidupdate | update analytikcheck set =CURRENT_TIMESTAMP(), analyseid =%d where Kontrollpunkt='updatefuid' and app=%d; |
| #498 394 | admin | setstartid | Update Rohdaten set StartID=%d, anzahlzeilen=%d where id = %d; |
| #498 395 | admin | uniquefiles | select * from filesunique where Webseite=%d; |
| #498 396 | admin | Anzahlversionen | Select count(fileid) as anzahl, max(version) as aktuelleversion from files where ufileid = %d; |
| #498 397 | admin | getversionen | Select version from files where ufileid = %d; |
| #498 398 | admin | AnzahlRohdatenfürUniqueDatei | Select count(id) as anzahl from rohdaten where uniqueFileid= %d; |
| #498 399 | admin | AnzahlanalysefürUniqueDatei | Select count(id) as anzahl from analyse where fuid= %d; |
| #498 400 | admin | AnzahlanalyticsmappingfürUniqueDatei | Select count(anaid) as anzahl from analyticsmapping where fuid= %d; |
| #498 401 | admin | getanalysepaar | select id from analyse where startid = %d and endid = %d and id> %d; |
| #498 402 | admin | getanalyseduplikate | select tokenid,startid, endid, count(id) as anzahl, min(id) as minid, max(id) as maxid from analyse where tokenid=%d and id >%d group by startid, endid order by anzahl desc; |
| #498 403 | admin | statfilesunique | Select min(fileUid) as minid, count(fileUid) as anzahl, max(fileUID) as maxuid, max(angelegt) as letztereintrag from filesunique where Webseite=%d; |
| #498 404 | admin | filesmissingfuid | select ufileid,fileid, version, angelegt, rohdatenid from files where ufileid=0 and Webseite=%d and fileid>%d order by Rohdatenid asc; |
| #498 405 | admin | checkrestorefuidupdate | update analytikcheck set fuid =%d, filesid= %d, RohdatenID=%d where Kontrollpunkt='restorefuid' and app=%d; |
| #498 406 | admin | checkrestorefuidfiles | update analytikcheck set =CURRENT_TIMESTAMP(), filesid =%d where Kontrollpunkt='restorefuid' and app=%d; |
| #498 407 | admin | getReportmonateanalse | select ReportTag, ReportMonat, count(id) as Anzahl from analyse where id>=%d and tokenid=%d group by ReportMonat, ReportTag; |
| #498 408 | admin | getreportmonatanalyse | select id, ReportMonat from analyse where tokenid=%d and id>=%d and ReportMonat='%s'; |
| #498 409 | admin | getreporttaganalyse | select id, ReportMonat from analyse where tokenid=%d and id>=%d and ReportMonat='%s' and ReportTag='%s'; |
| #498 410 | admin | updatereportmonatanalyse | UPDATE analyse SET ReportMonat = '%s' WHERE (id = %d); |
| #498 411 | admin | getReportmonateAnalyticsmapping | select ReportTag, ReportMonat, count(anaid) as Anzahl from analyticsmapping where tokenid=%d and anaid>=%d group by ReportMonat, ReportTag; |
| #498 412 | admin | getreportmonatanalyticsmapping | select anaid as id, ReportMonat from analyticsmapping where tokenid=%d and ReportMonat='%s'; |
| #498 413 | admin | updatereportmontanalyticsmapping | UPDATE analyticsmapping SET ReportMonat = '%s' WHERE (anaid = %d); |
| #498 414 | admin | countfilesunique | select count(fileUid) as Anzahl from filesunique; |
| #498 415 | admin | countdoppelstrichefileunique | select fileuid,Pfadt, POSITION('\\' in Pfadt) as firstdoppelstrich from filesunique where Webseite=%d; |
| #498 416 | admin | updatecheckanalytickcheckupdatezeilen | update analytikcheck set lezteUeberpruefung=CURRENT_TIMESTAMP(), RohdatenID =%d where Kontrollpunkt='updateZeilen' and app=%d; |
| #498 417 | admin | updatefilestitel | UPDATE files set titel='%s' where fileid=%d; |
| #498 418 | admin | uidbyPfadt | select *from filesunique where istDatei=1 andPfadt='%s' and Webseite=%d ; |
| #498 419 | admin | uidbyklasse | select * from filesunique where Klasse='%s' and istDatei=0 and Webseite=%d ; |
| #498 420 | admin | uidbyPfadt2 | select *from filesunique where istDatei=1 and Pfadt!='%s' and Webseite=%d ; |
| #498 421 | admin | uidbyklasse2 | select * from filesunique where Klasse!='%s' and istDatei=0 and Webseite=%d ; |
| #498 422 | performanceservice | unbekantes Template | |
| #498 423 | performanceservice | insert_service | INSERT INTO performanceservice (Service, Dauer,Version,token) VALUES ('%s', '%d', '%s', '%d');
|
This program makes use of the Zend Scripting Language Engine: