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

3.239.97.34
Visitor - restrictions applyAeroFinder ] [ QueryBuilder ] [ QueryEvents ] [ QueryNews ] [ Help ]

Session limits exceeded for this week
Please subscribe for immediate access


TRACES:


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


Entering cookie2php for ATDB5logon: no cookie exists
ATDB5logon cookie values:
env[]=

Entering racf_check memory=2511376
racf 1: ATDB5logon cookie not found
getIP found IP=3.239.97.34
racf 2: Current IP is 3.239.97.34
racf 2.1: currentIP=3.239.97.34, currentIPmask=3.239.97, 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='3.239.97.34' and (to_days(current_date) - to_days(logon) < 7) union all select ifnull(max(logon),'') from atdb5_sessions where ip_address like '3.239.97%' and (date_add(logon, interval 1 hour) > '2024-11-13 15:46:29') order by 1 desc limit 1
-> 2024-11-13 14:04:48

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 1 Using index condition; Using where
2 UNION atdb5_sessions range atdb5_sessions_ip_address atdb5_sessions_ip_address 137   1 Using index condition; Using where
  UNION RESULT ALL           Using filesort


racf 3.3: A record was found in session_table for IP=3.239.97.34 within last 7 days or last hour
any_sql: select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address='3.239.97.34' and logon='2024-11-13 14:04:48' union all select concat(session_id,'&',profile) from atdb5_sessions s11 where ip_address like '3.239.97%' and logon='2024-11-13 14:04:48' order by 1 desc limit 1
-> 173151267423903&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 atdb5_sessions_ip_address,atdb5_sessions_logon atdb5_sessions_logon 8 const 1 Using where
2 UNION atdb5_sessions ref atdb5_sessions_ip_address,atdb5_sessions_logon atdb5_sessions_logon 8 const 1 Using where
  UNION RESULT ALL           Using filesort


writeLogonInfo entered - fcode=c,currentIP=3.239.97.34,customerID=none
writeLogonInfo - Generated keys: IP=3.239.97.34 -> New SessionID=173151278923903
writeLogonInfo - now=1731512789 , now2=2024-11-13 15:46:29 , cookieExpiry=1731771989
writeLogonInfo - writing cookie:
sid=173151278923903&custID=none&logon=1731512789&profile=V00000000&ip1=03&ip2=239&userIP=3.239.97.34&racf=4108050209
ccdomain=.aerotransport.org
racf 3.3.1: Wrote new cookie, new SID=173151278923903 profile=V00000000
any_sql: update atdb5_sessions /* s12 */ set session_id='173151278923903' where session_id='173151267423903'
-> 1

racf 3.3.2: Session table updated old SID=173151267423903 -> new SID=173151278923903 for IP 3.239.97.34
racf 3 completed
checkCPU entered: IP=3.239.97.34,SID=173151278923903,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='3.239.97.34' /* and customer_id='none' */ and (to_days(current_date) - to_days(logon) < 7) limit 1
-> 10&17&0.12&131&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 1 Using index condition; Using where


checkCPU for this visitor: used_queries=10, used_requests=17, used_cpu=0.12, used_rows=131, profile=V


Entering htmlHeader, HTML length=90
getIP found IP=3.239.97.34
htmlTopBanner: ID=, username=, profile=V00000000

Entering racf_account - SID=173151278923903, 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] => 104
    [price_E12] => 147
    [price_P1] => 165
    [price_P12] => 1660
    [price_R12] => 2140
    [blackFriday] => 
    [price_U12_regular] => 104
    [price_E12_regular] => 147
    [price_P1_regular] => 165
    [price_P12_regular] => 1660
    [price_R12_regular] => 2140
    [u] => 
    [p] => 
    [profile] => V00000000
    [userid] => 
    [username] => 
    [sid] => 173151278923903
    [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] => Y-m-d
    [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] => 3.239.97.34
    [ru30_http_client_ip] => 
    [ru40_x_forwarded_for] => 
    [ru50_remote_addr] => 
    [ru60_http_client_ip] => 3.239.97.34
    [default_fsize] => x-small
    [phone] => 0
)

memory at end: 2526736

V6 © 1997-2024 AeroTransport Data Bank