Loading...
FC Neustadt - Platzbelegung
Platzbelegung - Spielfelder

[main:: 60 ] CGI-Version= 4.51

[main:: 61 ] DBI-Version= 1.643

my $Param={

'datum'=>'2024-06-26',

'sclid'=>'1',

'pbid'=>'2',

'scrid'=>'11',

}

[main:: 184 ] Server-PBID: 2

[main:: 185 ] ImportCookie: pb_import=

[main:: 187 ] Cookies: session_id=0;called_from=;pb_datum=;pb_id=;pb_reskey=;pb_scrid=

[main:: 198 ] UserLevel: Projekt-ID= ScreenParam=11

[main:: 213 ] ResSelectedKey:

main ( 225 ):ScheduleName=Platzbelegung DefaultSchedule=Platzbelegung

[ funktionen_login::project_data :: 1351 ] ProjectID=2 selectecd by param pbid

[ funktionen_login::addScreenResourceOrganization :: 1629 ] ProjectSpecificAccess: 1

[ funktionen_login::addScreenResourceOrganization :: 1686 ] Screen selected by param

[main:: 266 ] UserLevel=1

[main:: 270 ] ProjectID=2 ProjectStatus=publish PageAccess=1

[ belegung_rmod_ms::resource_hash 1180 ] SQL=SELECT resource_list.ID AS PitchID,resource_list.Name AS ResourceName,LPAD(DisplayOrder,4,'0') AS DisplayOrder,NameShort,ChildOf,ShowOnEmpty,Width,ResourceOwner,resource_list.PBID AS PBID,resource_list.SelectBoxDefault AS SelectBoxDefault,resource_list.SectionID AS SectionID, resource_list.SpielstaetteSpielplan AS SpielstaetteSpielplan FROM resource_list LEFT JOIN schedules ON resource_list.ScheduleID = schedules.ID WHERE schedules.ScheduleName='Platzbelegung' AND PBID=2

[ belegung_rmod_ms::resource_hash 1199 ] SQL=SELECT ResourceID, LPAD(OrderNo,4,'0') AS OrderNo FROM screen_resource_map WHERE PBID=2 AND ScreenID=11 AND ScheduleID=1 AND ShowResource=1

[main:: 285 )] FieldCount:16

[ funktionen_login::day_config :: 2106 ] ParamDate:2024-06-26 DateCookie:

[ funktionen_login::day_config :: 2150 ] DateISO:2024-06-26

[main:: 324 ] TagesDaten->{DateISO}:2024-06-26

main [ 325 ] Access: DBID: TerminKey= ReservationType=

[main:: 413 ] FormError: Action=

[ belegung_rmod_ms::team_liga_update :: 1698 ] SQL=SELECT ID,MatchKey,TeamID FROM belegung WHERE MatchKey <>'' AND PBID=2 AND Datum='2024-06-26'

[ belegung_rmod_ms::reservation_hash5 :: 208 ] SQL=SELECT CONCAT('S',ID,'-',Datum) AS ReservationKey,ID,WEEKDAY(Datum) AS mainWeekdayID,'26.06.2024' AS mainDateDE,TIME_FORMAT(StartZeit,'%H:%i') AS mainStartTimeHHMM,FLOOR(TIME_TO_SEC(StartZeit)/60) AS mainStartTimeMMM,TIME_FORMAT(EndZeit,'%H:%i') AS mainEndTimeHHMM,FLOOR(TIME_TO_SEC(EndZeit)/60) AS mainEndTimeMMM,FLOOR(TIME_TO_SEC(VorherZeit)/60) AS mainPreparationTimeMMM,FLOOR(TIME_TO_SEC(NachherZeit)/60) AS mainPostTimeMMM,'S' AS mainTypeKey ,RequestorName,RequestorEMail,Bemerkung,Bemerkung AS mainComment,LockerReservationSR,LockerReservationSR AS mainLockerReservationSR,ResourceSubID,ResourceSubID AS mainResourceSubID,Ort,NachherZeit,NachherZeit AS PostTime,VorherZeit,VorherZeit AS PreparationTime,EndZeit,EndZeit AS mainEndTime,DatumEnde,DatumEnde AS mainEndDate,RequestInfo,RequestInfo AS mainRequestInfo,TeamID,TeamID AS mainTeamID,ErzeugtAm,Gegner,ErzeugtDurch,GeaendertDurch,GeaendertDurch AS mainModifyComment,SRStatus,MatchKey,RequestInfoShow,RequestInfoShow AS mainRequestInfoShow,Status,Status AS mainStatus,PrePostAuto,RequestorTag,Gueltig,NachherZeit,NachherZeit AS mainPostTime,LockerReservation,LockerReservation AS mainLockerReservation,GeaendertAm,GeaendertAm AS mainModifyDate,Datum,Datum AS mainDate,StartZeit,StartZeit AS mainStartTime,VorherZeit,VorherZeit AS mainPreparationTime,ResourceID,ResourceID AS mainResourceID,Belegungsart,Belegungsart AS mainTypeName, 0 AS HiddenDisplay,DATE_FORMAT(DatumEnde,GET_FORMAT(DATE,'EUR')) AS mainEndDateDE,DATE_FORMAT(Datum,GET_FORMAT(DATE,'EUR')) AS mainStartDateDE, DATEDIFF(DatumEnde,Datum) AS MultiDayReservation FROM belegung WHERE Datum <= '2024-06-26' AND DatumEnde >= '2024-06-26' AND PBID=2 AND ( ResourceID=1787 OR ResourceID=1777 OR ResourceID=1847 OR ResourceID=1782 OR ResourceID=1774 OR ResourceID=1893 OR ResourceID=9999998 OR ResourceID=0)

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceSubFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StatusField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=CommentField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekdayIdField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPreparationTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPostTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TypeNameField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TeamIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerReservationField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPrePostAutoField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekFrequencyField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerSubIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartTimeField

[ belegung_rmod_ms::reservation_hash5 320 ] SelectFields=,ResourceSubID,ResourceSubID AS mainResourceSubID,Status,Status AS mainStatus,DatumVon,Bemerkung,Bemerkung AS mainComment,WochentagID,WochentagID AS mainWeekdayID,DatumBis,LockerTimeBefore,LockerTimeAfter,ResourceID,ResourceID AS mainResourceID,LockerMainID,Belegungsart,Belegungsart AS mainTypeName,TeamID,TeamID AS mainTeamID,LockerReservation,LockerReservation AS mainLockerReservation,LockerTimeAuto,WiederholungWoche,WiederholungWoche AS mainWeekFrequency,LockerSubID,ZeitBis,ZeitBis AS mainEndTime,ZeitVon,ZeitVon AS mainStartTime

[ belegung_rmod_ms::reservation_hash5 :: 333 ] SelectFields=,ResourceSubID,ResourceSubID AS mainResourceSubID,Status,Status AS mainStatus,DatumVon,Bemerkung,Bemerkung AS mainComment,WochentagID,WochentagID AS mainWeekdayID,DatumBis,LockerTimeBefore,LockerTimeAfter,ResourceID,ResourceID AS mainResourceID,LockerMainID,Belegungsart,Belegungsart AS mainTypeName,TeamID,TeamID AS mainTeamID,LockerReservation,LockerReservation AS mainLockerReservation,LockerTimeAuto,WiederholungWoche,WiederholungWoche AS mainWeekFrequency,LockerSubID,ZeitBis,ZeitBis AS mainEndTime,ZeitVon,ZeitVon AS mainStartTime

[ belegung_rmod_ms::reservation_hash5 :: 335 ] SQL=SELECT CONCAT('T',ID) AS ReservationKey,ID,TIME_FORMAT(ZeitVon,'%H:%i') AS mainStartTimeHHMM,FLOOR(TIME_TO_SEC(ZeitVon)/60) AS mainStartTimeMMM,TIME_FORMAT(ZeitBis,'%H:%i') AS mainEndTimeHHMM,FLOOR(TIME_TO_SEC(ZeitBis)/60) AS mainEndTimeMMM,'T' AS mainTypeKey,'2024-06-26' AS mainDate,'26.06.2024' AS mainDateDE ,ResourceSubID,ResourceSubID AS mainResourceSubID,Status,Status AS mainStatus,DatumVon,Bemerkung,Bemerkung AS mainComment,WochentagID,WochentagID AS mainWeekdayID,DatumBis,LockerTimeBefore,LockerTimeAfter,ResourceID,ResourceID AS mainResourceID,LockerMainID,Belegungsart,Belegungsart AS mainTypeName,TeamID,TeamID AS mainTeamID,LockerReservation,LockerReservation AS mainLockerReservation,LockerTimeAuto,WiederholungWoche,WiederholungWoche AS mainWeekFrequency,LockerSubID,ZeitBis,ZeitBis AS mainEndTime,ZeitVon,ZeitVon AS mainStartTime,DatumVon AS mainStartDate,DatumBis AS mainEndDate,WiederholungWoche AS mainWeekFrequency, 0 AS HiddenDisplay FROM trainingsplan WHERE DatumVon <= '2024-06-26' AND DatumBis >= '2024-06-26' AND WochentagID = WEEKDAY('2024-06-26') AND PBID=2 AND ( ResourceID=1787 OR ResourceID=1777 OR ResourceID=1847 OR ResourceID=1782 OR ResourceID=1774 OR ResourceID=1893 OR ResourceID=9999998 OR ResourceID=0) AND (Status='freigabe')

[ belegung_rmod_ms::reservation_hash5 382 ] 2 2 2024-06-26 2

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T31078-2024-06-26

[ belegung_rmod_ms::reservation_hash5 382 ] 2 2 2024-06-26 2

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T31074-2024-06-26

[ belegung_rmod_ms::reservation_hash5 382 ] 2 2 2024-06-26 2

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T31344-2024-06-26

[ belegung_rmod_ms::reservation_hash5 382 ] 3 3 2024-06-27 2

[ belegung_rmod_ms::reservation_hash5 382 ] 3 3 2024-06-27 2

[ belegung_rmod_ms::reservation_hash5 382 ] 3 3 2024-06-27 2

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2024-06-28 2

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2024-06-28 2

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2024-06-28 2

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2024-06-29 2

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2024-06-29 2

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2024-06-29 2

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2024-06-30 2

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2024-06-30 2

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2024-06-30 2

[ belegung_rmod_ms::reservation_hash5 382 ] 7 0 2024-07-01 2

[ belegung_rmod_ms::reservation_hash5 382 ] 7 0 2024-07-01 2

[ belegung_rmod_ms::reservation_hash5 382 ] 7 0 2024-07-01 2

[ belegung_rmod_ms::reservation_hash5 382 ] 8 1 2024-07-02 2

[ belegung_rmod_ms::reservation_hash5 382 ] 8 1 2024-07-02 2

[ belegung_rmod_ms::reservation_hash5 382 ] 8 1 2024-07-02 2

[ belegung_rmod_ms::reservation_hash5 :: 436 ] SQL=SELECT CONCAT('M',ID,'-',Datum) AS ReservationKey,ID,TIME_FORMAT(ZeitVon,'%H:%i') AS mainStartTimeHHMM,FLOOR(TIME_TO_SEC(ZeitVon)/60) AS mainStartTimeMMM,TIME_FORMAT(ZeitBis,'%H:%i') AS mainEndTimeHHMM,FLOOR(TIME_TO_SEC(ZeitBis)/60) AS mainEndTimeMMM,TIME_FORMAT(ADDTIME(ZeitVon,'01:00:00'),'%H:%i') AS mainEndTimeCorrectHHMM,FLOOR(TIME_TO_SEC(ADDTIME(ZeitVon,'01:00:00'))/60) AS mainEndTimeCorrectMMM,WEEKDAY('2024-06-26') AS mainWeekdayID,'M' AS mainTypeKey ,Bemerkung,Bemerkung AS mainComment,TPID,GeaendertDurch,Geloescht,ResourceSubID,ResourceSubID AS mainResourceSubID,GeaendertAm,LockerReservation,LockerReservation AS mainLockerReservation,Datum,Datum AS mainDate,LockerTimeAuto,LockerSubID,ZeitBis,ZeitBis AS mainEndTime,ZeitVon,ZeitVon AS mainStartTime,LockerTimeBefore,LockerTimeAfter,ResourceID,ResourceID AS mainResourceID,LockerMainID, 0 AS DisplayHidden FROM trainingsplan_ausnahmen WHERE Datum <= '2024-06-26' AND Datum >= '2024-06-26' AND PBID=2

[ belegung_rmod_ms::reservation_hash5 :: 450 ] SQL=SELECT CONCAT('M',ID,'-',Datum) AS ReservationKey,ID,TIME_FORMAT(ZeitVon,'%H:%i') AS mainStartTimeHHMM,FLOOR(TIME_TO_SEC(ZeitVon)/60) AS mainStartTimeMMM,TIME_FORMAT(ZeitBis,'%H:%i') AS mainEndTimeHHMM,FLOOR(TIME_TO_SEC(ZeitBis)/60) AS mainEndTimeMMM,TIME_FORMAT(ADDTIME(ZeitVon,'01:00:00'),'%H:%i') AS mainEndTimeCorrectHHMM,FLOOR(TIME_TO_SEC(ADDTIME(ZeitVon,'01:00:00'))/60) AS mainEndTimeCorrectMMM,WEEKDAY('2024-06-26') AS mainWeekdayID,'M' AS mainTypeKey ,Bemerkung,Bemerkung AS mainComment,TPID,GeaendertDurch,Geloescht,ResourceSubID,ResourceSubID AS mainResourceSubID,GeaendertAm,LockerReservation,LockerReservation AS mainLockerReservation,Datum,Datum AS mainDate,LockerTimeAuto,LockerSubID,ZeitBis,ZeitBis AS mainEndTime,ZeitVon,ZeitVon AS mainStartTime,LockerTimeBefore,LockerTimeAfter,ResourceID,ResourceID AS mainResourceID,LockerMainID, 0 AS HiddenDisplay FROM trainingsplan_ausnahmen WHERE Datum <= '2024-06-26' AND Datum >= '2024-06-26' AND PBID=2 AND (Geloescht=0 OR Geloescht=2)

[ belegung_rmod_ms::reservation_hash5 527 ] T31078-2024-06-26 18:00:00

[ belegung_rmod_ms::reservation_hash5 527 ] T31344-2024-06-26 18:30:00

[ belegung_rmod_ms::reservation_hash5 527 ] T31074-2024-06-26 18:00:00

[ belegung_rmod_ms::reservation_hash5 545 ] SelectFields=,ResourceID,ResourceID AS mainResourceID,Comment,Comment AS mainComment,ReservationHandling,EndDate,StartDate,ResourceSubID,ResourceSubID AS mainResourceSubID

[ belegung_rmod_ms::reservation_hash5 :: 553 ] SQL=SELECT CONCAT('X',ID) AS ReservationKey,ID,'00:00' AS mainStartTimeHHMM,0 AS mainStartTimeMMM,'23:55' AS mainEndTimeHHMM,1435 AS mainEndTimeMMM,'Gesperrt' AS mainTypeName,'X' AS mainTypeKey,'2024-06-26' AS mainDate,'26.06.2024' AS mainDateDE ,ResourceID,ResourceID AS mainResourceID,Comment,Comment AS mainComment,ReservationHandling,EndDate,StartDate,ResourceSubID,ResourceSubID AS mainResourceSubID,StartDate AS mainStartDate,EndDate AS mainEndDate,DATE_FORMAT(EndDate,GET_FORMAT(DATE,'EUR')) AS mainEndDateDE FROM sperrungen WHERE StartDate <= '2024-06-26' AND EndDate >= '2024-06-26' AND PBID=2 AND ( ResourceID=1787 OR ResourceID=1777 OR ResourceID=1847 OR ResourceID=1782 OR ResourceID=1774 OR ResourceID=1893 OR ResourceID=9999998 OR ResourceID=0)

[ belegung_rmod_ms::reservation_hash5 :: 640 ] SQL=SELECT teams.ID AS ID,Saison,VereinKurz AS Verein,VereinKurzDisplay,vereine.ID AS VereinID,Team,TeamLang,StdFarbeTraining,InBelegungAusblenden,KabineZeitVorher,KabineZeitNachher,KabineZeitVorherTraining,KabineZeitNachherTraining,BelegungVorher,BelegungNachher FROM teams INNER JOIN vereine ON teams.VereinID=vereine.ID WHERE teams.ID=14181

[ belegung_rmod_ms::reservation_hash5 :: 640 ] SQL=SELECT teams.ID AS ID,Saison,VereinKurz AS Verein,VereinKurzDisplay,vereine.ID AS VereinID,Team,TeamLang,StdFarbeTraining,InBelegungAusblenden,KabineZeitVorher,KabineZeitNachher,KabineZeitVorherTraining,KabineZeitNachherTraining,BelegungVorher,BelegungNachher FROM teams INNER JOIN vereine ON teams.VereinID=vereine.ID WHERE teams.ID=14581

[ belegung_rmod_ms::reservation_hash5 :: 640 ] SQL=SELECT teams.ID AS ID,Saison,VereinKurz AS Verein,VereinKurzDisplay,vereine.ID AS VereinID,Team,TeamLang,StdFarbeTraining,InBelegungAusblenden,KabineZeitVorher,KabineZeitNachher,KabineZeitVorherTraining,KabineZeitNachherTraining,BelegungVorher,BelegungNachher FROM teams INNER JOIN vereine ON teams.VereinID=vereine.ID WHERE teams.ID=14207

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: T31078-2024-06-26

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: T31344-2024-06-26

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: T31074-2024-06-26

[ funktionen_login::pb_header :: 96 ] CookieConfirmedPostCall: 1

[ funktionen_login::pb_header :: 108 ] Environment: PROD Version:18b1b

[ funktionen_login::pb_header :: 109 ] CookieConfirmed: 1 CookieConfirmedPostCall: 1

[ funktionen_login::pb_header :: 110 ] CookieConfirmed: 1 CookieConfirmedPostCall: 1

[ funktionen_login::pb_header :: 111 ] UserID=0

[ funktionen_login::pb_header :: 149 ] Cookie Type: Samesite=Strict Secure=1

[ funktionen_login::pb_header :: 185 ] args-date_cookie: 2024-06-26

[ funktionen_login::pb_header :: 206 ] ProjectChanged=

[ funktionen_login::pb_header :: 403 ] CssFile: pb_18b1b.css

[main:: 631 ] ReservationSelected=

[ main::top_menu 804 ] top_menu function start. ProjectID=2 UserLevel=1

[ display_frame2::main_frame_start :: 66 ] ProjectID=2) ProjectStatus=publish

[ display_frame2::main_frame_start_m5 154 ] MenuStyle:display:table-cell; Mobile:0

[ display_frame2::main_frame_start_m5 292 ] TopMenu defined: length(16)

[ belegung_cmod_ms::show_desktop 1951 ] ResourceOrderKey=-

[ belegung_cmod_ms::show_desktop 1951 ] ResourceOrderKey=1000-Stadion

[ belegung_cmod_ms::show_desktop 1951 ] ResourceOrderKey=1004-Platz 1 (KR)

[ belegung_cmod_ms::show_desktop 1951 ] ResourceOrderKey=1005-Platz 2

[ belegung_cmod_ms::show_desktop 1951 ] ResourceOrderKey=1006-Platz 3 (KR)

[ belegung_cmod_ms::show_desktop 1951 ] ResourceOrderKey=1021-Trainingsplatz

[ belegung_cmod_ms::show_desktop 1951 ] ResourceOrderKey=1022-Mannschaftsbusse

[ belegung_cmod_ms::show_desktop 1951 ] ResourceOrderKey=9999-ohne

[ belegung_cmod_ms::show_reservation_block :: 2338 ] TextBlock= 18:00 - 19:30 Training ( FCN ) Bwbl      Resource= -

[ belegung_cmod_ms::show_reservation_block :: 2338 ] TextBlock= 18:00 - 19:30 Training ( FCN ) Cwbl      Resource= -

[ belegung_cmod_ms::show_reservation_block :: 2338 ] TextBlock= 18:30 - 20:00 Training ( FCN ) B1      Resource= -

RZ_a = :Rhttp-301:Cpremium:quota=153600MB:plain=y:scgi=2:php=81:fcgi=1:spam=0:crt=22183385:tpl=strato-standard-emig:

REQUEST_URI = /cgi-bin/belegung.pl?datum=2024-06-26&sclid=1&pbid=2&scrid=11

UNIQUE_ID = Z6ZG19zIgG-KRux5euDuVAAAB9c

SERVER_PORT = 80

REMOTE_ADDR = 18.97.9.173

SERVER_SOFTWARE = Apache/2.4.62 (Unix)

SERVER_NAME = belegung.org

PHPRC = /home/strato/http/premium/rid/56/07/51885607/htdocs/pb_releases/18b1b/

DOCUMENT_ROOT = /home/strato/http/premium/rid/56/07/51885607/htdocs/pb_releases/18b1b/

RZ_path = web103/c2/07/51885607

SCRIPT_URI = http://belegung.org/cgi-bin/belegung.pl

REMOTE_PORT = 55558

RZ_php = 81

HTTP_CONNECTION = close

SERVER_PROTOCOL = HTTP/1.1

SERVER_ADMIN = service@webmailer.de

HTTP_ACCEPT = text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

QUERY_STRING = datum=2024-06-26&sclid=1&pbid=2&scrid=11

PATH = /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin

SCRIPT_FILENAME = /home/strato/http/premium/rid/56/07/51885607/htdocs/pb_releases/18b1b/cgi-bin/belegung.pl

HTTP_ACCEPT_ENCODING = br,gzip

HTTP_ACCEPT_LANGUAGE = en-US,en;q=0.5

SCRIPT_NAME = /cgi-bin/belegung.pl

RZ_n = 51885607

HTTP_HOST = belegung.org

GATEWAY_INTERFACE = CGI/1.1

HTTP_USER_AGENT = CCBot/2.0 (https://commoncrawl.org/faq/)

SCRIPT_URL = /cgi-bin/belegung.pl

REQUEST_METHOD = GET