Debug Hag Operating System V1.0 BETA 1

Terminal - Google Analytics Youtube Media Fsk18 ID qpnv3mk6tmil1ianfrvrtnstuc

Step 1 - 1: Kein User gefunden in Cookies. Skippe zu Punkt 2

Step 1 - 1: Keine User ID vorhanden.

Step 1 - 2: Durchsuche Tabelle nach hag_phpsessid

Step 1: SQL: Abrage addon funktioniert - \PDOStatement::__set_state(array( 'queryString' => 'SELECT * FROM sessionlist_addon WHERE hag_phpsessid = ? LIMIT 1', ))

Step 2: Es wird nur eine Bedingung überprüft

Step 2: Base = 2 Rows = one Eine Bedinngung =

Step 2: SQL: Abrage funktioniert - \PDOStatement::__set_state(array( 'queryString' => 'SELECT * FROM sessionlist WHERE hag_phpsessid = ? LIMIT 1', ))

Step 3: Beziehe Informationen aus der Datenbank

Step-X: Inizialisiere Update

Step-X: Update Methode ohne UserID

Step-X: Erfolgreiches Update in Sessionlist \PDOStatement::__set_state(array( 'queryString' => 'UPDATE sessionlist SET hag_cookie = :wert1_neu, hag_os = :wert4_neu, hag_platform = :wert5_neu, hag_browser = :wert6_neu, hag_ip2long = :wert7_neu, hag_useragent = :wert8_neu, hag_hagagent = :wert9_neu, hag_hostaddr = :wert11_neu, hag_latitude = :wert12_neu, hag_longitude = :wert13_neu, hag_countrycode = :wert14_neu, hag_countryname = :wert15_neu, hag_cityname = :wert16_neu, hag_regionname = :wert17_neu, hag_visited = :wert18_neu, hag_identify = :wert19_neu, hag_port = :wert20_neu, hag_tor = :wert21_neu, hag_bot = :wert22_neu, joomla_status = :wert25_neu WHERE hag_phpsessid = :hag_bedingung1_neu', ))

Step 4 - 2: Kein Status Cookie vorhanden. Setzte neuen Cookie aus Tabelle

Step 1: Suche in Sessionlist_addon nach hag_phpsessid

Step Y: Sind gleich. SessionID aus Tabelle = . LocaleID =

Step Y: Erfolgreiches Update in Addon\PDOStatement::__set_state(array( 'queryString' => 'UPDATE sessionlist_addon SET select_login_mode = :wert1_neu, hag_google_analytics = :wert2_neu, hag_youtube_media = :wert3_neu, hag_fsk18 = :wert4_neu, hag_width = :wert5_neu, hag_height = :wert6_neu WHERE hag_phpsessid = :hag_bedingung1_neu', ))

Datenbank

hag_*

width =>

height =>

analytics =>

youtube =>

fsk18 =>

$hag_cookie =>

$hag_sessblock =>

$hag_phpsessid =>

$hag_os =>

'-'

$hag_platform =>

'-'

$hag_browser =>

'-'

$hag_ip2long =>

'59979270'

$hag_useragent =>

'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'

$hag_hagagent =>

'59979270Seattle-ec2-3-147-54-6.us-east-2.compute.amazonaws.com-'

$hag_policy =>

$hag_hostaddr =>

'ec2-3-147-54-6.us-east-2.compute.amazonaws.com'

$hag_latitude =>

'47.6275'

$hag_longitude =>

'-122.3462'

$hag_countrycode =>

'US'

$hag_countryname =>

'America'

$hag_cityname =>

'Seattle'

$hag_regionname =>

'Washington'

$hag_visited =>

'666'

$hag_identified =>

'Base-2 (sessID)'

$hag_port =>

' '

$hag_tor =>

'-'

$hag_bot =>

'Bot'

$hag_user =>

$hag_email =>

$hag_status =>

'Gast'

To:UPDATE ohne UserID

$to_sql_select_login_mode =>

$to_sql_hag_google_analytics =>

$to_sql_hag_youtube_media =>

$to_sql_hag_fsk18 =>

$to_sql_hag_cookie =>

$to_sql_hag_sessblock =>

$to_sql_hag_phpsessid =>

'schon gesetzt'

$to_sql_hag_os =>

'-'

$to_sql_hag_platform =>

'-'

$to_sql_hag_browser =>

'-'

$to_sql_hag_ip2long =>

'59979270'

$to_sql_hag_useragent =>

'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'

$to_sql_hag_hagagent =>

'59979270Seattle-ec2-3-147-54-6.us-east-2.compute.amazonaws.com-'

$to_sql_hag_policy =>

$to_sql_hag_hostaddr =>

$to_sql_hag_latitude =>

'47.6275'

$to_sql_hag_longitude =>

'-122.3462'

$to_sql_hag_countrycode =>

'US'

$to_sql_hag_countryname =>

'America'

$to_sql_hag_cityname =>

'Seattle'

$to_sql_hag_regionname =>

'Washington'

$to_sql_hag_visited =>

'667'

$to_sql_hag_identified =>

'Base-2 (sessID)'

$to_sql_hag_port =>

' '

$to_sql_hag_tor =>

'-'

$to_sql_hag_bot =>

'Bot'

$to_sql_joomla_user =>

$to_sql_joomla_email =>

$to_sql_joomla_status =>

'Gast'

To:UPDATE ohne UserID

$new_select_login_mode =>

$new_google_analytics =>

$new_youtube_media =>

$new_fsk18 =>

$new_cookie =>

$new_sessblock =>

$new_phpsessid =>

$new_os =>

$new_platform =>

$new_browser =>

$new_ip2long =>

$new_useragent =>

$new_hagagent =>

$new_policy =>

$new_hostaddr =>

$new_latitude =>

$new_longitude =>

$new_countrycode =>

$new_countryname =>

$new_cityname =>

$new_regionname =>

$new_visited =>

$new_identified =>

$new_port =>

' '

$new_tor =>

$new_bot =>

$new_user =>

$new_email =>

$new_status =>

From:

$from_sql_select_login_mode =>

$from_sql_hag_google_analytics =>

$from_sql_hag_youtube_media =>

$from_sql_hag_fsk18 =>

$from_sql_hag_cookie =>

$from_sql_hag_sessblock =>

$from_sql_hag_phpsessid =>

$from_sql_hag_os =>

'Windows 7'

$from_sql_hag_platform =>

'64-32 Bit'

$from_sql_hag_browser =>

'Chrome'

$from_sql_hag_ip2long =>

'3112809446'

$from_sql_hag_useragent =>

'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36'

$from_sql_hag_hagagent =>

'3112809446Khabarovsk64-32 Bit185.137.179.230Windows 7'

$from_sql_hag_policy =>

','

$from_sql_hag_hostaddr =>

$from_sql_hag_latitude =>

'48.48083'

$from_sql_hag_longitude =>

'135.09278'

$from_sql_hag_countrycode =>

'RU'

$from_sql_hag_countryname =>

'Russian Federation'

$from_sql_hag_cityname =>

'Khabarovsk'

$from_sql_hag_regionname =>

'Khabarovskiy kray'

$from_sql_hag_visited =>

'666'

$from_sql_hag_identified =>

'Base-2 (sessID)'

$from_sql_hag_port =>

' '

$from_sql_hag_tor =>

'-'

$from_sql_hag_bot =>

'-'

$from_sql_joomla_user =>

$from_sql_joomla_email =>

$from_sql_joomla_status =>

'Gast'

$_SERVER

/data/hagbardc/public_html/htdocs/01_index/super-debup.php:564:
array (size=39)
  'PATH' => string '/usr/local/bin:/usr/bin:/bin' (length=28)
  'TEMP' => string '/tmp' (length=4)
  'TMP' => string '/tmp' (length=4)
  'TMPDIR' => string '/tmp' (length=4)
  'PWD' => string '/' (length=1)
  'HTTP_ACCEPT' => string '*/*' (length=3)
  'CONTENT_LENGTH' => string '0' (length=1)
  'HTTP_HOST' => string 'www.hagbard.ch' (length=14)
  'HTTP_REFERER' => string 'http://www.hagbard.ch/rabbit/index.php/forum-iframe' (length=51)
  'HTTP_USER_AGENT' => string 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' (length=103)
  'HTTP_X_HTTPS' => string '1' (length=1)
  'UNIQUE_ID' => string 'ZjTJbQR_pitCYNqXYOGl9AAAAZE' (length=27)
  'SCRIPT_URL' => string '/rabbit/index.php/forum-iframe' (length=30)
  'SCRIPT_URI' => string 'https://www.hagbard.ch/rabbit/index.php/forum-iframe' (length=52)
  'HTTPS' => string 'on' (length=2)
  'SSL_TLS_SNI' => string 'www.hagbard.ch' (length=14)
  'SERVER_SIGNATURE' => string '' (length=0)
  'SERVER_SOFTWARE' => string 'Apache' (length=6)
  'SERVER_NAME' => string 'www.hagbard.ch' (length=14)
  'SERVER_ADDR' => string '195.191.240.70' (length=14)
  'SERVER_PORT' => string '443' (length=3)
  'REMOTE_ADDR' => string '3.147.54.6' (length=10)
  'DOCUMENT_ROOT' => string '/data/hagbardc/public_html' (length=26)
  'REQUEST_SCHEME' => string 'https' (length=5)
  'CONTEXT_PREFIX' => string '' (length=0)
  'CONTEXT_DOCUMENT_ROOT' => string '/data/hagbardc/public_html' (length=26)
  'SERVER_ADMIN' => string 'webmaster@hagbard.ch' (length=20)
  'SCRIPT_FILENAME' => string '/data/hagbardc/public_html/rabbit/index.php' (length=43)
  'REMOTE_PORT' => string '12683' (length=5)
  'SERVER_PROTOCOL' => string 'HTTP/1.1' (length=8)
  'REQUEST_METHOD' => string 'GET' (length=3)
  'QUERY_STRING' => string '' (length=0)
  'REQUEST_URI' => string '/rabbit/index.php/forum-iframe' (length=30)
  'SCRIPT_NAME' => string '/rabbit/index.php' (length=17)
  'PATH_INFO' => string '/forum-iframe' (length=13)
  'PATH_TRANSLATED' => string '/data/hagbardc/public_html/forum-iframe' (length=39)
  'PHP_SELF' => string '/rabbit/index.php' (length=17)
  'REQUEST_TIME_FLOAT' => float 1714735470.1454
  'REQUEST_TIME' => int 1714735470

$_COOKIE

/data/hagbardc/public_html/htdocs/01_index/super-debup.php:568:
array (size=0)
  empty

$_SESSION

/data/hagbardc/public_html/htdocs/01_index/super-debup.php:572:
array (size=70)
  'hag_user' => null
  'need_user_update' => string 'yes' (length=3)
  'hag_status' => string 'Gast' (length=4)
  'select_login_mode' => null
  'hag_google_analytics' => null
  'hag_youtube_media' => null
  'hag_fsk18' => null
  'hag_width' => null
  'hag_height' => null
  'hag_ip2long' => int 59979270
  'hag_useragent' => string 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' (length=103)
  'hag_sessblock' => null
  'hag_visited' => string '666' (length=3)
  'hag_bot' => string 'Bot' (length=3)
  'hag_identified' => string 'Base-2  (sessID)' (length=16)
  'hag_tor' => string '-' (length=1)
  'hag_cookie' => null
  'hag_policy' => null
  'hag_email' => null
  'hag_os' => string '-' (length=1)
  'hag_browser' => string '-' (length=1)
  'hag_hostname' => string 'cloud70.unaxus.net' (length=18)
  'hag_hostaddr' => string 'ec2-3-147-54-6.us-east-2.compute.amazonaws.com' (length=46)
  'hag_platform' => string '-' (length=1)
  'set_useragent' => string 'includet' (length=8)
  'hag_countryname' => string 'America' (length=7)
  'hag_countrycode' => string 'US' (length=2)
  'hag_regionname' => string 'Washington' (length=10)
  'hag_cityname' => string 'Seattle' (length=7)
  'hag_latitude' => string '47.6275' (length=7)
  'hag_longitude' => string '-122.3462' (length=9)
  'hag_hagagent' => string '59979270Seattle-ec2-3-147-54-6.us-east-2.compute.amazonaws.com-' (length=63)
  'set_ip2location' => string 'includet' (length=8)
  'hag_port' => string '  ' (length=2)
  'new_port' => string '  ' (length=2)
  'port_scanner' => string 'includet' (length=8)
  'from_sql_hag_cookie' => null
  'from_sql_hag_sessblock' => string '' (length=0)
  'from_sql_hag_phpsessid' => string '' (length=0)
  'from_sql_hag_os' => string 'Windows 7' (length=9)
  'from_sql_hag_platform' => string '64-32 Bit' (length=9)
  'from_sql_hag_browser' => string 'Chrome' (length=6)
  'from_sql_hag_user' => string '' (length=0)
  'from_sql_hag_ip2long' => string '3112809446' (length=10)
  'from_sql_hag_useragent' => string 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 Safari/537.36' (length=105)
  'from_sql_hag_hagagent' => string '3112809446Khabarovsk64-32 Bit185.137.179.230Windows 7' (length=53)
  'from_sql_hag_policy' => string ',' (length=1)
  'from_sql_hag_hostaddr' => null
  'from_sql_hag_latitude' => string '48.48083' (length=8)
  'from_sql_hag_longitude' => string '135.09278' (length=9)
  'from_sql_hag_countrycode' => string 'RU' (length=2)
  'from_sql_hag_countryname' => string 'Russian Federation' (length=18)
  'from_sql_hag_cityname' => string 'Khabarovsk' (length=10)
  'from_sql_hag_regionname' => string 'Khabarovskiy kray' (length=17)
  'from_sql_hag_visited' => string '666' (length=3)
  'from_sql_hag_identify' => string 'Base-2  (sessID)' (length=16)
  'from_sql_hag_port' => string '  ' (length=2)
  'from_sql_hag_tor' => string '-' (length=1)
  'from_sql_hag_bot' => string '-' (length=1)
  'from_sql_joomla_user' => string '' (length=0)
  'from_sql_joomla_email' => string '' (length=0)
  'from_sql_joomla_status' => string 'Gast' (length=4)
  'found_in_sessionlist' => string '&check;' (length=7)
  'record' => string 'done-sl-' (length=8)
  'online_check_router' => string 'display: none' (length=13)
  'online_check_yamaha' => string 'display: none' (length=13)
  'online_check_syn1' => string 'display: none' (length=13)
  'online_check_syn2' => string 'display: none' (length=13)
  'online_check_qnap' => string 'display: none' (length=13)
  'sidebar-scanner' => string 'includet' (length=8)

$_POST

/data/hagbardc/public_html/htdocs/01_index/super-debup.php:576:
array (size=0)
  empty

Ergebnis

$msg_from_template_useragent

useragent geladen

$msg_from_template_ip2location

ip2locationt geladen

$msg_from_template_port_scanner

port_scanner geladen

$msg_from_template_sidebar_scanner

sidebar_scanner geladen

UPDATE ohne UserID

Ohne User Erfolgreich

UPDATE Addon

Erfolgreich

$need_user_update

yes

$updateSkipper

notaktive

Step 3: Found in Sessionlist

✓

hag_*

To:UPDATE ohne UserID NEW

To:UPDATE ohne UserID NEW

From:

To:UPDATE ohne UserID

To:UPDATE ohne UserID