Loading...
FC Neustadt - Platzbelegung
Platzbelegung - Spielfelder

[main:: 60 ] CGI-Version= 4.51

[main:: 61 ] DBI-Version= 1.643

my $Param={

'datum'=>'2024-07-10',

'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-07-10 DateCookie:

[ funktionen_login::day_config :: 2150 ] DateISO:2024-07-10

[main:: 324 ] TagesDaten->{DateISO}:2024-07-10

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-07-10'

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

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPrePostAutoField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerSubIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerReservationField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=EndTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPreparationTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerPostTimeField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TypeNameField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekdayIdField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StatusField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=TeamIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=LockerIDField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=StartDateField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=ResourceSubFieldID

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=WeekFrequencyField

[ belegung_rmod_ms::reservation_hash5 314 ] DataField=CommentField

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

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

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

[ belegung_rmod_ms::reservation_hash5 382 ] 2 2 2024-07-10 2

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T31344-2024-07-10

[ belegung_rmod_ms::reservation_hash5 382 ] 2 2 2024-07-10 2

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T31078-2024-07-10

[ belegung_rmod_ms::reservation_hash5 382 ] 2 2 2024-07-10 2

[ belegung_rmod_ms::reservation_hash5 387 ] Series Issue Added =T31074-2024-07-10

[ belegung_rmod_ms::reservation_hash5 382 ] 3 3 2024-07-11 2

[ belegung_rmod_ms::reservation_hash5 382 ] 3 3 2024-07-11 2

[ belegung_rmod_ms::reservation_hash5 382 ] 3 3 2024-07-11 2

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2024-07-12 2

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2024-07-12 2

[ belegung_rmod_ms::reservation_hash5 382 ] 4 4 2024-07-12 2

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2024-07-13 2

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2024-07-13 2

[ belegung_rmod_ms::reservation_hash5 382 ] 5 5 2024-07-13 2

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2024-07-14 2

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2024-07-14 2

[ belegung_rmod_ms::reservation_hash5 382 ] 6 6 2024-07-14 2

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

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

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

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

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

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

[ belegung_rmod_ms::reservation_hash5 527 ] T31074-2024-07-10 18:00:00

[ belegung_rmod_ms::reservation_hash5 527 ] T31078-2024-07-10 18:00:00

[ belegung_rmod_ms::reservation_hash5 527 ] T31344-2024-07-10 18:30:00

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

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: T31078-2024-07-10

[ belegung_rmod_ms::reservation_hash5 812 ] ReservationKey: T31344-2024-07-10

[ 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-07-10

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

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

QUERY_STRING = datum=2024-07-10&sclid=1&pbid=2&scrid=11

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

HTTP_ACCEPT_ENCODING = br,gzip

REQUEST_METHOD = GET

HTTP_CONNECTION = close

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

SERVER_ADMIN = service@webmailer.de

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

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

SCRIPT_URL = /cgi-bin/belegung.pl

GATEWAY_INTERFACE = CGI/1.1

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

HTTP_ACCEPT_LANGUAGE = en-US,en;q=0.5

SERVER_NAME = belegung.org

SERVER_PORT = 80

RZ_php = 81

SERVER_SOFTWARE = Apache/2.4.62 (Unix)

UNIQUE_ID = Z6ZRwYUR55TkvGwnx2KbyAAAAec

SCRIPT_NAME = /cgi-bin/belegung.pl

HTTP_IF_MODIFIED_SINCE = Wed, 14 Aug 2024 08:10:43 GMT

REMOTE_PORT = 3588

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

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

RZ_path = web103/c2/07/51885607

REMOTE_ADDR = 18.97.9.173

SERVER_PROTOCOL = HTTP/1.1

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

HTTP_HOST = belegung.org

RZ_n = 51885607