Loading...
FC Neustadt - Platzbelegung
Platzbelegung - Spielfelder

[main:: 60 ] CGI-Version= 4.51

[main:: 61 ] DBI-Version= 1.643

my $Param={

'datum'=>'2024-05-25',

'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-05-25 DateCookie:

[ funktionen_login::day_config :: 2150 ] DateISO:2024-05-25

[main:: 324 ] TagesDaten->{DateISO}:2024-05-25

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-05-25'

[ belegung_rmod_ms::reservation_hash5 :: 208 ] SQL=SELECT CONCAT('S',ID,'-',Datum) AS ReservationKey,ID,WEEKDAY(Datum) AS mainWeekdayID,'25.05.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 ,GeaendertDurch,GeaendertDurch AS mainModifyComment,RequestorName,LockerReservation,LockerReservation AS mainLockerReservation,ErzeugtDurch,Gegner,PrePostAuto,RequestorTag,VorherZeit,VorherZeit AS mainPreparationTime,RequestInfoShow,RequestInfoShow AS mainRequestInfoShow,Bemerkung,Bemerkung AS mainComment,Status,Status AS mainStatus,ResourceSubID,ResourceSubID AS mainResourceSubID,Ort,StartZeit,StartZeit AS mainStartTime,ResourceID,ResourceID AS mainResourceID,NachherZeit,NachherZeit AS PostTime,GeaendertAm,GeaendertAm AS mainModifyDate,RequestInfo,RequestInfo AS mainRequestInfo,ErzeugtAm,RequestorEMail,LockerReservationSR,LockerReservationSR AS mainLockerReservationSR,TeamID,TeamID AS mainTeamID,Datum,Datum AS mainDate,Gueltig,VorherZeit,VorherZeit AS PreparationTime,Belegungsart,Belegungsart AS mainTypeName,SRStatus,MatchKey,NachherZeit,NachherZeit AS mainPostTime,DatumEnde,DatumEnde AS mainEndDate,EndZeit,EndZeit AS mainEndTime, 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-05-25' AND DatumEnde >= '2024-05-25' AND PBID=2 AND ( ResourceID=1893 OR ResourceID=1847 OR ResourceID=1774 OR ResourceID=1782 OR ResourceID=1787 OR ResourceID=9999998 OR ResourceID=1777 OR ResourceID=0)

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=CommentField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TypeNameField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceSubFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StatusField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPostTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerSubIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekFrequencyField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerReservationField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPrePostAutoField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekdayIdField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TeamIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPreparationTimeField

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

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

[ 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-05-25' AS mainDate,'25.05.2024' AS mainDateDE ,Bemerkung,Bemerkung AS mainComment,Belegungsart,Belegungsart AS mainTypeName,DatumVon,ResourceSubID,ResourceSubID AS mainResourceSubID,Status,Status AS mainStatus,LockerMainID,ResourceID,ResourceID AS mainResourceID,ZeitVon,ZeitVon AS mainStartTime,LockerTimeAfter,LockerSubID,WiederholungWoche,WiederholungWoche AS mainWeekFrequency,ZeitBis,ZeitBis AS mainEndTime,LockerReservation,LockerReservation AS mainLockerReservation,LockerTimeAuto,WochentagID,WochentagID AS mainWeekdayID,DatumBis,TeamID,TeamID AS mainTeamID,LockerTimeBefore,DatumVon AS mainStartDate,DatumBis AS mainEndDate,WiederholungWoche AS mainWeekFrequency, 0 AS HiddenDisplay FROM trainingsplan WHERE DatumVon <= '2024-05-25' AND DatumBis >= '2024-05-25' AND WochentagID = WEEKDAY('2024-05-25') AND PBID=2 AND ( ResourceID=1893 OR ResourceID=1847 OR ResourceID=1774 OR ResourceID=1782 OR ResourceID=1787 OR ResourceID=9999998 OR ResourceID=1777 OR ResourceID=0) AND (Status='freigabe')

[ 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-05-25') AS mainWeekdayID,'M' AS mainTypeKey ,ResourceSubID,ResourceSubID AS mainResourceSubID,Bemerkung,Bemerkung AS mainComment,GeaendertAm,ZeitBis,ZeitBis AS mainEndTime,Geloescht,LockerMainID,LockerTimeAfter,LockerSubID,ZeitVon,ZeitVon AS mainStartTime,ResourceID,ResourceID AS mainResourceID,TPID,LockerTimeAuto,LockerReservation,LockerReservation AS mainLockerReservation,GeaendertDurch,LockerTimeBefore,Datum,Datum AS mainDate, 0 AS DisplayHidden FROM trainingsplan_ausnahmen WHERE Datum <= '2024-05-25' AND Datum >= '2024-05-25' 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-05-25') AS mainWeekdayID,'M' AS mainTypeKey ,ResourceSubID,ResourceSubID AS mainResourceSubID,Bemerkung,Bemerkung AS mainComment,GeaendertAm,ZeitBis,ZeitBis AS mainEndTime,Geloescht,LockerMainID,LockerTimeAfter,LockerSubID,ZeitVon,ZeitVon AS mainStartTime,ResourceID,ResourceID AS mainResourceID,TPID,LockerTimeAuto,LockerReservation,LockerReservation AS mainLockerReservation,GeaendertDurch,LockerTimeBefore,Datum,Datum AS mainDate, 0 AS HiddenDisplay FROM trainingsplan_ausnahmen WHERE Datum <= '2024-05-25' AND Datum >= '2024-05-25' AND PBID=2 AND (Geloescht=0 OR Geloescht=2)

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

[ 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-05-25' AS mainDate,'25.05.2024' AS mainDateDE ,EndDate,ResourceID,ResourceID AS mainResourceID,Comment,Comment AS mainComment,StartDate,ResourceSubID,ResourceSubID AS mainResourceSubID,ReservationHandling,StartDate AS mainStartDate,EndDate AS mainEndDate,DATE_FORMAT(EndDate,GET_FORMAT(DATE,'EUR')) AS mainEndDateDE FROM sperrungen WHERE StartDate <= '2024-05-25' AND EndDate >= '2024-05-25' AND PBID=2 AND ( ResourceID=1893 OR ResourceID=1847 OR ResourceID=1774 OR ResourceID=1782 OR ResourceID=1787 OR ResourceID=9999998 OR ResourceID=1777 OR ResourceID=0)

[ 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-05-25

[ 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

REMOTE_ADDR = 18.97.9.173

SERVER_NAME = belegung.org

GATEWAY_INTERFACE = CGI/1.1

SCRIPT_URL = /cgi-bin/belegung.pl

RZ_path = web103/c2/07/51885607

UNIQUE_ID = Z6ZVdN5lAsDXwCFyho02SwAADTM

HTTP_HOST = belegung.org

REQUEST_METHOD = GET

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

SERVER_ADMIN = service@webmailer.de

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

HTTP_ACCEPT_LANGUAGE = en-US,en;q=0.5

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

QUERY_STRING = datum=2024-05-25&sclid=1&pbid=2&scrid=11

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

RZ_n = 51885607

SERVER_PORT = 443

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

RZ_php = 81

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

SERVER_PROTOCOL = HTTP/1.1

HTTPS = on

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

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

REMOTE_PORT = 57766

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

HTTP_CONNECTION = close

HTTP_ACCEPT_ENCODING = br,gzip

SCRIPT_NAME = /cgi-bin/belegung.pl

SERVER_SOFTWARE = Apache/2.4.62 (Unix)