Loading...
FC Neustadt - Platzbelegung
Platzbelegung - Spielfelder

[main:: 60 ] CGI-Version= 4.51

[main:: 61 ] DBI-Version= 1.643

my $Param={

'datum'=>'today',

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

[ funktionen_login::day_config 2110 ] UL:1 NewDate:today

[ funktionen_login::day_config :: 2150 ] DateISO:2025-02-07

[main:: 324 ] TagesDaten->{DateISO}:2025-02-07

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='2025-02-07'

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

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StatusField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TeamIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPostTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=CommentField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekdayIdField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPrePostAutoField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceSubFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerReservationField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TypeNameField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPreparationTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerSubIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekFrequencyField

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

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

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

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2025-02-07 4

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T31350-2025-02-07

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2025-02-07 4

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T31347-2025-02-07

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2025-02-08 4

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2025-02-08 4

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2025-02-09 4

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2025-02-09 4

[ belegung_rmod_ms::reservation_hash5 382 ] 7 0 2025-02-10 4

[ belegung_rmod_ms::reservation_hash5 382 ] 7 0 2025-02-10 4

[ belegung_rmod_ms::reservation_hash5 382 ] 8 1 2025-02-11 4

[ belegung_rmod_ms::reservation_hash5 382 ] 8 1 2025-02-11 4

[ belegung_rmod_ms::reservation_hash5 382 ] 9 2 2025-02-12 4

[ belegung_rmod_ms::reservation_hash5 382 ] 9 2 2025-02-12 4

[ belegung_rmod_ms::reservation_hash5 382 ] 10 3 2025-02-13 4

[ belegung_rmod_ms::reservation_hash5 382 ] 10 3 2025-02-13 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('2025-02-07') AS mainWeekdayID,'M' AS mainTypeKey ,Bemerkung,Bemerkung AS mainComment,LockerMainID,LockerTimeAuto,Datum,Datum AS mainDate,LockerTimeBefore,GeaendertDurch,LockerReservation,LockerReservation AS mainLockerReservation,ResourceID,ResourceID AS mainResourceID,ResourceSubID,ResourceSubID AS mainResourceSubID,LockerSubID,ZeitVon,ZeitVon AS mainStartTime,Geloescht,TPID,GeaendertAm,ZeitBis,ZeitBis AS mainEndTime,LockerTimeAfter, 0 AS DisplayHidden FROM trainingsplan_ausnahmen WHERE Datum <= '2025-02-07' AND Datum >= '2025-02-07' 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('2025-02-07') AS mainWeekdayID,'M' AS mainTypeKey ,Bemerkung,Bemerkung AS mainComment,LockerMainID,LockerTimeAuto,Datum,Datum AS mainDate,LockerTimeBefore,GeaendertDurch,LockerReservation,LockerReservation AS mainLockerReservation,ResourceID,ResourceID AS mainResourceID,ResourceSubID,ResourceSubID AS mainResourceSubID,LockerSubID,ZeitVon,ZeitVon AS mainStartTime,Geloescht,TPID,GeaendertAm,ZeitBis,ZeitBis AS mainEndTime,LockerTimeAfter, 0 AS HiddenDisplay FROM trainingsplan_ausnahmen WHERE Datum <= '2025-02-07' AND Datum >= '2025-02-07' AND PBID=2 AND (Geloescht=0 OR Geloescht=2)

[ belegung_rmod_ms::reservation_hash5 527 ] T31350-2025-02-07 17:30:00

[ belegung_rmod_ms::reservation_hash5 527 ] T31347-2025-02-07 17:00:00

[ belegung_rmod_ms::reservation_hash5 527 ] S261552-2025-02-07 19:30:00

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

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

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

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

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: T31350-2025-02-07

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: T31347-2025-02-07

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: S261552-2025-02-07

[ 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: 2025-02-07

[ 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= 17:30 - 19:00 Training ( FCN ) E2      Resource= -

[ belegung_cmod_ms::show_reservation_block :: 2338 ] TextBlock= 19:30 - 21:15 Meisterschaft ( FCN ) 1.HM - TSV Mariental 1897      Resource= -

RZ_path = web103/c2/07/51885607

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

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

GATEWAY_INTERFACE = CGI/1.1

SCRIPT_URL = /cgi-bin/belegung.pl

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

SERVER_SOFTWARE = Apache/2.4.62 (Unix)

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

HTTP_HOST = belegung.org

UNIQUE_ID = Z6ZQUgDF0LtkMrdvgrhCQAAABqw

RZ_php = 81

REMOTE_PORT = 22628

HTTP_CONNECTION = close

QUERY_STRING = datum=today&sclid=1&pbid=2&scrid=11

SERVER_ADMIN = service@webmailer.de

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

SERVER_PORT = 80

SCRIPT_NAME = /cgi-bin/belegung.pl

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

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

SERVER_PROTOCOL = HTTP/1.1

HTTP_ACCEPT_LANGUAGE = en-US,en;q=0.5

REQUEST_METHOD = GET

RZ_n = 51885607

REMOTE_ADDR = 18.97.9.173

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

SERVER_NAME = belegung.org

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

HTTP_IF_MODIFIED_SINCE = Wed, 18 Sep 2024 08:50:31 GMT

HTTP_ACCEPT_ENCODING = br,gzip