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', 1752060414.176, '[35.238.203.213][-][-]', 'yii\\base\\InvalidRouteException: Unable to resolve the request \"xmlrpc.php\". 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', 1752060414.161, '[35.238.203.213][-][-]', '$_GET = []\n\n$_POST = []\n\n$_FILES = []\n\n$_COOKIE = []\n\n$_SERVER = [\n \'USER\' => \'sportshubsoccer\'\n \'HOME\' => \'/var/www/vhosts/sportshub.com\'\n \'SCRIPT_NAME\' => \'/index.php\'\n \'REQUEST_URI\' => \'/xmlrpc.php\'\n \'QUERY_STRING\' => \'\'\n \'REQUEST_METHOD\' => \'GET\'\n \'SERVER_PROTOCOL\' => \'HTTP/1.0\'\n \'GATEWAY_INTERFACE\' => \'CGI/1.1\'\n \'REDIRECT_URL\' => \'/xmlrpc.php\'\n \'REMOTE_PORT\' => \'55632\'\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\' => \'35.238.203.213\'\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_ACCEPT_LANGUAGE\' => \'el-GR,el;q=0.9\'\n \'HTTP_ACCEPT\' => \'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.9\'\n \'HTTP_USER_AGENT\' => \'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.5672.93 Safari/537.36\'\n \'CONTENT_TYPE\' => \'application/xml\'\n \'HTTP_REFERER\' => \'http://devfront.sportshubsoccer.com\'\n \'HTTP_ACCEPT_ENCODING\' => \'gzip, deflate, zstd, br\'\n \'HTTP_CONNECTION\' => \'close\'\n \'HTTP_X_ACCEL_INTERNAL\' => \'/internal-nginx-static-location\'\n \'HTTP_X_REAL_IP\' => \'35.238.203.213\'\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\' => \'aG5R-vEPffDrOay2oCZc9wAAAAU\'\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\' => \'aG5R-vEPffDrOay2oCZc9wAAAAU\'\n \'FCGI_ROLE\' => \'RESPONDER\'\n \'PHP_SELF\' => \'/index.php\'\n \'REQUEST_TIME_FLOAT\' => 1752060414.1534\n \'REQUEST_TIME\' => 1752060414\n]')