Loading...
FC Neustadt - Platzbelegung
Platzbelegung - Spielfelder

[main:: 60 ] CGI-Version= 4.51

[main:: 61 ] DBI-Version= 1.643

my $Param={

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

'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-31 DateCookie:

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

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

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-31'

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

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StatusField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekdayIdField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPostTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPreparationTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekFrequencyField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TypeNameField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceSubFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=CommentField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerSubIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPrePostAutoField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerReservationField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TeamIDField

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

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

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

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2024-05-31 4

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T30962-2024-05-31

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2024-05-31 4

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T31073-2024-05-31

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2024-06-01 4

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2024-06-01 4

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2024-06-02 4

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2024-06-02 4

[ belegung_rmod_ms::reservation_hash5 382 ] 7 0 2024-06-03 4

[ belegung_rmod_ms::reservation_hash5 382 ] 7 0 2024-06-03 4

[ belegung_rmod_ms::reservation_hash5 382 ] 8 1 2024-06-04 4

[ belegung_rmod_ms::reservation_hash5 382 ] 8 1 2024-06-04 4

[ belegung_rmod_ms::reservation_hash5 382 ] 9 2 2024-06-05 4

[ belegung_rmod_ms::reservation_hash5 382 ] 9 2 2024-06-05 4

[ belegung_rmod_ms::reservation_hash5 382 ] 10 3 2024-06-06 4

[ belegung_rmod_ms::reservation_hash5 382 ] 10 3 2024-06-06 4

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

[ belegung_rmod_ms::reservation_hash5 527 ] T31073-2024-05-31 18:00:00

[ belegung_rmod_ms::reservation_hash5 527 ] T30962-2024-05-31 17:00:00

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

[ 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=14187

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: T31073-2024-05-31

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: T30962-2024-05-31

[ 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-31

[ 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= 17:00 - 18:00 Training ( FCN ) C1      Resource= -

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

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

SERVER_NAME = belegung.org

RZ_n = 51885607

RZ_php = 81

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

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

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

SCRIPT_NAME = /cgi-bin/belegung.pl

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

SERVER_PROTOCOL = HTTP/1.1

HTTPS = on

HTTP_ACCEPT_LANGUAGE = en-US,en;q=0.5

HTTP_CONNECTION = close

GATEWAY_INTERFACE = CGI/1.1

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/

SERVER_ADMIN = service@webmailer.de

SCRIPT_URL = /cgi-bin/belegung.pl

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

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

HTTP_ACCEPT_ENCODING = br,gzip

REMOTE_ADDR = 18.97.9.173

REMOTE_PORT = 55716

RZ_path = web103/c2/07/51885607

SERVER_SOFTWARE = Apache/2.4.62 (Unix)

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

SERVER_PORT = 443

UNIQUE_ID = Z6ZDqH9BGVr7MPWZJRHXYQAABnE

HTTP_HOST = belegung.org

REQUEST_METHOD = GET