Database Queries

SELECT `store`.* FROM `store` LEFT JOIN `user` ON `store`.`user_id` = `user`.`id` WHERE `slug` IS NULL

SELECT * FROM `team` WHERE `slug`=''

SELECT `user_theme`.* FROM `user_theme` LEFT JOIN `league` ON `user_theme`.`user_id` = `league`.`user_id` LEFT JOIN `club` ON `user_theme`.`user_id` = `club`.`user_id` LEFT JOIN `team` ON `user_theme`.`team_id` = `team`.`id` WHERE (((league.slug = "") OR (club.slug = "")) OR (team.slug = "")) AND (`user_theme`.`is_active`=1)

SELECT `user_theme`.* FROM `user_theme` LEFT JOIN `user` ON `user_theme`.`user_id` = `user`.`id` WHERE (`user_theme`.`is_active`=1) AND (`user`.`type_id`=1)

SELECT * FROM `user` WHERE `id`=1

SELECT * FROM `club` WHERE `slug`=''

SELECT * FROM `user` WHERE `type_id`=1

SELECT * FROM `user` WHERE `type_id`=1

SELECT * FROM `site_setting` WHERE `option_name`='site_logo'

SELECT * FROM `user` WHERE `type_id`=1

SELECT * FROM `store` WHERE `user_id`=1

SELECT `site_page_type`.* FROM `site_page_type` LEFT JOIN `site_pages` ON `site_page_type`.`id` = `site_pages`.`type_id` WHERE `site_page_type`.`name` IN ('Footer Quick link', 'Footer Contact Us', 'Footer About Us')

SELECT * FROM `site_pages` WHERE `type_id` IN (32, 33, 34)

SELECT * FROM `site_setting` WHERE `option_name`='site_logo'

INSERT INTO `log` (`level`, `category`, `log_time`, `prefix`, `message`) VALUES (1, 'yii\\web\\HttpException:404', 1752111610.1107, '[198.50.163.54][-][-]', 'yii\\base\\InvalidRouteException: Unable to resolve the request \"index.html\". in /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/base/Module.php:537\nStack trace:\n#0 /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/web/Application.php(103): yii\\base\\Module->runAction()\n#1 /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/base/Application.php(386): yii\\web\\Application->handleRequest()\n#2 /var/www/vhosts/sportshub.com/public_html/devsite/frontend/web/index.php(18): yii\\base\\Application->run()\n#3 {main}\n\nNext yii\\web\\NotFoundHttpException: Page not found. in /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/web/Application.php:115\nStack trace:\n#0 /var/www/vhosts/sportshub.com/public_html/devsite/vendor/yiisoft/yii2/base/Application.php(386): yii\\web\\Application->handleRequest()\n#1 /var/www/vhosts/sportshub.com/public_html/devsite/frontend/web/index.php(18): yii\\base\\Application->run()\n#2 {main}')

INSERT INTO `log` (`level`, `category`, `log_time`, `prefix`, `message`) VALUES (4, 'application', 1752111610.0977, '[198.50.163.54][-][-]', '$_GET = []\n\n$_POST = []\n\n$_FILES = []\n\n$_COOKIE = [\n \'_frontend_CSRF\' => \'cdd217c7cbca0a8a7fa0de7bfe5b91e417149ccaa2a4fb00da1a65b71da3a94ca:2:{i:0;s:14:\\\"_frontend_CSRF\\\";i:1;s:32:\\\"5s-8T5KGS4w56aUPvG_xki39hABghD0O\\\";}\'\n \'_ga\' => \'GA1.2.1143356604.1752111609\'\n \'_gid\' => \'GA1.2.667494931.1752111609\'\n \'_gat_UA-150275111-1\' => \'1\'\n \'_ga_MSBQ1JLBR6\' => \'GS2.2.s1752111609$o1$g0$t1752111609$j60$l0$h0\'\n]\n\n$_SERVER = [\n \'USER\' => \'sportshubsoccer\'\n \'HOME\' => \'/var/www/vhosts/sportshub.com\'\n \'SCRIPT_NAME\' => \'/index.php\'\n \'REQUEST_URI\' => \'/index.html\'\n \'QUERY_STRING\' => \'\'\n \'REQUEST_METHOD\' => \'GET\'\n \'SERVER_PROTOCOL\' => \'HTTP/1.0\'\n \'GATEWAY_INTERFACE\' => \'CGI/1.1\'\n \'REDIRECT_URL\' => \'/index.html\'\n \'REMOTE_PORT\' => \'51888\'\n \'SCRIPT_FILENAME\' => \'/var/www/vhosts/sportshub.com/public_html/devsite/frontend/web/index.php\'\n \'SERVER_ADMIN\' => \'[no address given]\'\n \'CONTEXT_DOCUMENT_ROOT\' => \'/var/www/vhosts/sportshub.com/public_html/devsite/frontend/web\'\n \'CONTEXT_PREFIX\' => \'\'\n \'REQUEST_SCHEME\' => \'https\'\n \'DOCUMENT_ROOT\' => \'/var/www/vhosts/sportshub.com/public_html/devsite/frontend/web\'\n \'REMOTE_ADDR\' => \'198.50.163.54\'\n \'SERVER_PORT\' => \'443\'\n \'SERVER_ADDR\' => \'74.208.93.48\'\n \'SERVER_NAME\' => \'devfront.sportshubsoccer.com\'\n \'SERVER_SOFTWARE\' => \'Apache\'\n \'SERVER_SIGNATURE\' => \'<address>Apache Server at devfront.sportshubsoccer.com Port 443</address>\n\'\n \'PATH\' => \'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin\'\n \'HTTP_COOKIE\' => \'_frontend_CSRF=cdd217c7cbca0a8a7fa0de7bfe5b91e417149ccaa2a4fb00da1a65b71da3a94ca%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_frontend_CSRF%22%3Bi%3A1%3Bs%3A32%3A%225s-8T5KGS4w56aUPvG_xki39hABghD0O%22%3B%7D; _ga=GA1.2.1143356604.1752111609; _gid=GA1.2.667494931.1752111609; _gat_UA-150275111-1=1; _ga_MSBQ1JLBR6=GS2.2.s1752111609$o1$g0$t1752111609$j60$l0$h0\'\n \'HTTP_ACCEPT_ENCODING\' => \'gzip, deflate, br\'\n \'HTTP_REFERER\' => \'https://devfront.sportshubsoccer.com/service-worker.js?v=1647540009\'\n \'HTTP_ACCEPT\' => \'*/*\'\n \'HTTP_USER_AGENT\' => \'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/75.0.3765.0 Safari/537.36\'\n \'HTTP_CONNECTION\' => \'close\'\n \'HTTP_X_ACCEL_INTERNAL\' => \'/internal-nginx-static-location\'\n \'HTTP_X_REAL_IP\' => \'198.50.163.54\'\n \'HTTP_HOST\' => \'devfront.sportshubsoccer.com\'\n \'proxy-nokeepalive\' => \'1\'\n \'HTTPS\' => \'on\'\n \'PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY\' => \'0\'\n \'PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY\' => \'0\'\n \'UNIQUE_ID\' => \'aG8Z@hazT8WhpkCdTL4mdwAAAAk\'\n \'REDIRECT_STATUS\' => \'200\'\n \'REDIRECT_HTTPS\' => \'on\'\n \'REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY\' => \'0\'\n \'REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY\' => \'0\'\n \'REDIRECT_UNIQUE_ID\' => \'aG8Z@hazT8WhpkCdTL4mdwAAAAk\'\n \'FCGI_ROLE\' => \'RESPONDER\'\n \'PHP_SELF\' => \'/index.php\'\n \'REQUEST_TIME_FLOAT\' => 1752111610.0901\n \'REQUEST_TIME\' => 1752111610\n]')