ATDB How to use ATDB     Preferences     Subscribe     Tips & Q&A 
You're not logged on
Username:
Password:

34.232.63.94
Visitor - restrictions apply[ AeroFinder ] [ QueryBuilder ] [ QueryEvents ] [ QueryNews ] [ Help ]

Session limits exceeded for this week
Please subscribe for immediate access

TRACES:


timeline.php
get: operatorID value: 53919
any_sql: set names 'utf8'
->

Entering cookie2php for ATDB5logon: no cookie exists
ATDB5logon cookie values:
env[]=
Entering racf_check memory=2497048
racf 1: ATDB5logon cookie not found
getIP found IP=34.232.63.94
racf 2: Current IP is 34.232.63.94
racf 2.1: currentIP=34.232.63.94, currentIPmask=34.232.63, previousIP=unknown
racf 3: No logon cookie could be used for this session: First visit, cookie erased or previous logon failed
any_sql: select ifnull(max(logon),'') from atdb5_sessions where ip_address='34.232.63.94' and (to_days(current_date) - to_days(logon) < 7) union all select ifnull(max(logon),'') from atdb5_sessions where ip_address like '34.232.63%' and (date_add(logon, interval 1 hour) > '2023-03-27 06:59:16') order by 1 desc limit 1
-> 2023-03-27 05:12:11

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
int(3)string(57)string(192)string(30)string(12288)string(192)string(12288)string(6144)string(192)string(765)
1 PRIMARY atdb5_sessions ref atdb5_sessions_ip_address atdb5_sessions_ip_address 137 const 4 Using index condition; Using where
2 UNION atdb5_sessions range atdb5_sessions_ip_address atdb5_sessions_ip_address 137   4 Using index condition; Using where
  UNION RESULT ALL           Using filesort


racf 3.3: A record was found in session_table for IP=34.232.63.94 within last 7 days or last hour
any_sql: select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address='34.232.63.94' and logon='2023-03-27 05:12:11' union all select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address like '34.232.63%' and logon='2023-03-27 05:12:11' order by 1 desc limit 1
-> 1679893041232034&V00000000

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
int(3)string(57)string(192)string(30)string(12288)string(192)string(12288)string(6144)string(192)string(765)
1 PRIMARY atdb5_sessions ref|filter atdb5_sessions_ip_address,atdb5_sessions_logon atdb5_sessions_logon|atdb5_sessions_ip_address 8|137 const 2 (0%) Using where; Using rowid filter
2 UNION atdb5_sessions ref|filter atdb5_sessions_ip_address,atdb5_sessions_logon atdb5_sessions_logon|atdb5_sessions_ip_address 8|137 const 2 (0%) Using where; Using rowid filter
  UNION RESULT ALL           Using filesort


writeLogonInfo entered - fcode=c,currentIP=34.232.63.94,customerID=none
writeLogonInfo - Generated keys: IP=34.232.63.94 -> New SessionID=1679893156232034
writeLogonInfo - now=1679893156 , now2=2023-03-27 06:59:16 , cookieExpiry=1680152356
writeLogonInfo - writing cookie:
sid=1679893156232034&custID=none&logon=1679893156&profile=V00000000&ip1=034&ip2=232&userIP=34.232.63.94&racf=4108050209
ccdomain=.aerotransport.org
racf 3.3.1: Wrote new cookie, new SID=1679893156232034 profile=V00000000
any_sql: update atdb5_sessions /* s12 */ set session_id='1679893156232034' where session_id='1679893041232034'
-> 1

racf 3.3.2: Session table updated old SID=1679893041232034 -> new SID=1679893156232034 for IP 34.232.63.94
racf 3 completed
checkCPU entered: IP=34.232.63.94,SID=1679893156232034,userid=,profile=V00000000
any_sql: select concat(sum(queries),'&',sum(requests),'&',sum(sql_cpu),'&',sum(sql_rows),'&',min(substring(profile,1,1))) from atdb5_sessions where ip_address='34.232.63.94' /* and customer_id='none' */ and (to_days(current_date) - to_days(logon) < 7) limit 1
-> 10&24&0.26&191&V

idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
int(3)string(57)string(192)string(30)string(12288)string(192)string(12288)string(6144)string(192)string(765)
1 SIMPLE atdb5_sessions ref atdb5_sessions_ip_address atdb5_sessions_ip_address 137 const 4 Using index condition; Using where


checkCPU for this visitor: used_queries=10, used_requests=24, used_cpu=0.26, used_rows=191, profile=V

Entering htmlHeader, HTML length=90
getIP found IP=34.232.63.94
htmlTopBanner: ID=, username=, profile=V00000000
Entering racf_account - SID=1679893156232034, query=
Used for this page: Query=1 Requests=0, Rows=0, CPU=0
No request issued, no resources used
racf_account completed

END TRACES
ENV:
Array
(
    [debug] => 1
    [trace] => 
    [maxDebugMinutes] => 45
    [V] => 6
    [charset] => UTF-8
    [serverURL] => Array
        (
            [0] => aerotransport.org
            [1] => atdb.aero
            [2] => aerotran.o2switch.net
            [3] => aavrane.free.fr
        )

    [root] => https://www.aerotransport.org/
    [home] => https://www.aerotransport.org
    [base] => https://www.aerotransport.org/php/go.php
    [spooled] => ../spooled/
    [DBAemail] => aerotransport@gmail.com
    [DBAdomain] => *.o2switch.net
    [emergencyMirror] => www2.aerotransport.org
    [allowVisitors] => 1
    [DBAonly] => 0
    [server_archive] => 1
    [archiveURL] => http://aavrane.free.fr/aerotransport/V5/
    [maxMemory] => 400000000
    [price_U12] => 99
    [price_E12] => 140
    [price_P1] => 158
    [price_P12] => 1580
    [price_R12] => 2040
    [blackFriday] => 
    [price_U12_regular] => 99
    [price_E12_regular] => 140
    [price_P1_regular] => 158
    [price_P12_regular] => 1580
    [price_R12_regular] => 2040
    [u] => 
    [p] => 
    [profile] => V00000000
    [userid] => 
    [username] => 
    [sid] => 1679893156232034
    [userIP] => unknown
    [lang] => EN
    [client_os] => 
    [client_cpu] => 
    [client_browser] => CCBot/2.0 (https://commoncrawl.org/faq/)
    [maxHTMLrows] => 35
    [maxXLSrows] => 10000
    [maxpictures] => 50
    [partners] => *AJPEHFCSDNMBRX
    [maxSessionHours] => 72
    [maxSessionQueries] => 400
    [maxSessionRequests] => 900
    [maxSessionRows] => 9000
    [thisQueryRequests] => 0
    [thisQueryRows] => 0
    [thisQueryCPU] => 0
    [maxSavedQueries] => 40
    [thisUserQueries] => 0
    [maxTrialQueries] => 3500
    [maxTrialRequests] => 6000
    [maxTrialRows] => 30000
    [maxTrialThreshold] => 0.7
    [maxQuotaU] => 25000
    [maxQuotaE] => 40000
    [maxWeeklyQueries] => 9
    [maxWeeklyRequests] => 50
    [maxWeeklyRows] => 300
    [old2news] => 150
    [warningExpiry] => 12
    [graceDays] => 1
    [logonRetryCount] => 0
    [logonRetryMax] => 5
    [logonRetrySleep] => 20
    [logonRetryLast] => 0
    [maxDomainsWarning] => 3
    [maxDomainsReset] => 5
    [allowHotlinks] => 1
    [allowForeignFrames] => 0
    [automaticPasswordReset] => 1
    [automaticRevoke] => 1
    [enableLogs] => 1
    [enableEncryption] => 1
    [savedQueries] => 300
    [savedVisitorsQueries] => 30
    [blacklist] => erased
    [blackdomains] => Array
        (
            [0] => flightglobal.com
            [1] => rbi.co.uk
            [2] => rbinet.co.uk
            [3] => airclaims
            [4] => impots.gouv.fr
            [5] => cirium.com
            [6] => hwclouds-dns.com
            [7] => petalsearch.com
            [8] => mts-internet.net
        )

    [sampleSpreadsheet] => extant MD-11 in Europe
    [dd_maxFleetSize] => 30
    [] => 
    [pref_bgcolor] => #ffffff
    [pref_fsize] => x-small
    [pref_dateformat] => d/m/y
    [pref_xpl_built] => 0
    [pref_target] => target=_self
    [pref_maxrecords] => 35
    [pref_partners] => 1
    [pref_no2pict] => 0
    [pref_no2regs] => 0
    [pref_no2safe] => 0
    [pref_unit] => kg
    [ru00_mode] => 21
    [ru10_x_forwarded_for] => 
    [ru20_remote_addr] => 34.232.63.94
    [ru30_http_client_ip] => 
    [ru40_x_forwarded_for] => 
    [ru50_remote_addr] => 
    [ru60_http_client_ip] => 34.232.63.94
    [default_fsize] => x-small
    [phone] => 0
)

memory at end: 2514080

V6 © 1997-2023 AeroTransport Data Bank