Database Queries

SELECT `value` FROM `setting` WHERE `key`='website.cache'

SELECT * FROM `website` WHERE (`isRemoved`=0) AND ((`subdomain`='www') AND (`language`='fa'))

SELECT COUNT(*) FROM `user` WHERE `status`=4

INSERT INTO `log` (`level`, `category`, `log_time`, `prefix`, `message`) VALUES (1, 'yii\\base\\ErrorException:8', 1749518306.6809, '[192.168.4.240][-][-]', 'yii\\base\\ErrorException: Undefined index: id in /home/aca/portal/aca/user/backend/controllers/ManageController.php:88\nStack trace:\n#0 /home/aca/portal/aca/user/backend/controllers/ManageController.php(88): yii\\base\\ErrorHandler->handleError()\n#1 [internal function]: aca\\user\\backend\\controllers\\ManageController->aca\\user\\backend\\controllers\\{closure}()\n#2 /home/aca/portal/vendor/yiisoft/yii2/filters/AccessRule.php(302): call_user_func()\n#3 /home/aca/portal/vendor/yiisoft/yii2/filters/AccessRule.php(177): yii\\filters\\AccessRule->matchCustom()\n#4 /home/aca/portal/vendor/yiisoft/yii2/filters/AccessControl.php(123): yii\\filters\\AccessRule->allows()\n#5 /home/aca/portal/vendor/yiisoft/yii2/base/ActionFilter.php(77): yii\\filters\\AccessControl->beforeAction()\n#6 [internal function]: yii\\base\\ActionFilter->beforeFilter()\n#7 /home/aca/portal/vendor/yiisoft/yii2/base/Component.php(633): call_user_func()\n#8 /home/aca/portal/vendor/yiisoft/yii2/base/Controller.php(297): yii\\base\\Component->trigger()\n#9 /home/aca/portal/vendor/yiisoft/yii2/web/Controller.php(222): yii\\base\\Controller->beforeAction()\n#10 /home/aca/portal/vendor/yiisoft/yii2/base/Controller.php(176): yii\\web\\Controller->beforeAction()\n#11 /home/aca/portal/vendor/yiisoft/yii2/base/Module.php(552): yii\\base\\Controller->runAction()\n#12 /home/aca/portal/vendor/yiisoft/yii2/web/Application.php(103): yii\\base\\Module->runAction()\n#13 /home/aca/portal/vendor/yiisoft/yii2/base/Application.php(384): yii\\web\\Application->handleRequest()\n#14 /home/aca/portal/web/admin/index.php(32): yii\\base\\Application->run()\n#15 {main}')

INSERT INTO `log` (`level`, `category`, `log_time`, `prefix`, `message`) VALUES (4, 'application', 1749518306.662, '[192.168.4.240][-][-]', '$_GET = []\n\n$_POST = []\n\n$_FILES = []\n\n$_COOKIE = []\n\n$_SERVER = [\n \'USER\' => \'www-data\'\n \'HOME\' => \'/var/www\'\n \'HTTP_ACCEPT_ENCODING\' => \'gzip, br, zstd, deflate\'\n \'HTTP_USER_AGENT\' => \'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\'\n \'HTTP_ACCEPT\' => \'*/*\'\n \'HTTP_CONNECTION\' => \'close\'\n \'HTTP_X_FORWARDED_PROTO\' => \'https\'\n \'HTTP_X_FORWARDED_FOR\' => \'216.73.216.37\'\n \'HTTP_X_REAL_IP\' => \'216.73.216.37\'\n \'HTTP_HOST\' => \'www.velayat.ac.ir\'\n \'SCRIPT_FILENAME\' => \'/home/aca/portal/web/admin/index.php\'\n \'REDIRECT_STATUS\' => \'200\'\n \'SERVER_NAME\' => \'www.velayat.ac.ir\'\n \'SERVER_PORT\' => \'443\'\n \'SERVER_ADDR\' => \'192.168.4.24\'\n \'REMOTE_PORT\' => \'48690\'\n \'REMOTE_ADDR\' => \'192.168.4.240\'\n \'SERVER_SOFTWARE\' => \'nginx/1.18.0\'\n \'GATEWAY_INTERFACE\' => \'CGI/1.1\'\n \'HTTPS\' => \'on\'\n \'REQUEST_SCHEME\' => \'https\'\n \'SERVER_PROTOCOL\' => \'HTTP/1.0\'\n \'DOCUMENT_ROOT\' => \'/home/aca/portal/web\'\n \'DOCUMENT_URI\' => \'/admin/index.php\'\n \'REQUEST_URI\' => \'/admin/user/manage/manage-sessions\'\n \'SCRIPT_NAME\' => \'/admin/index.php\'\n \'CONTENT_LENGTH\' => \'\'\n \'CONTENT_TYPE\' => \'\'\n \'REQUEST_METHOD\' => \'GET\'\n \'QUERY_STRING\' => \'\'\n \'FCGI_ROLE\' => \'RESPONDER\'\n \'PHP_SELF\' => \'/admin/index.php\'\n \'REQUEST_TIME_FLOAT\' => 1749518306.6605\n \'REQUEST_TIME\' => 1749518306\n]')

SELECT id FROM `log` ORDER BY id DESC LIMIT 0, 200

DELETE FROM `log` WHERE id NOT IN(926315, 926314, 926313, 926312, 926311, 926310, 926309, 926308, 926307, 926306, 926305, 926304, 926303, 926302, 926301, 926300, 926299, 926298, 926297, 926296, 926295, 926294, 926293, 926292, 926291, 926290, 926289, 926288, 926287, 926286, 926285, 926284, 926283, 926282, 926281, 926280, 926279, 926278, 926277, 926276, 926275, 926274, 926273, 926272, 926271, 926270, 926269, 926268, 926267, 926266, 926265, 926264, 926263, 926262, 926261, 926260, 926259, 926258, 926257, 926256, 926255, 926254, 926253, 926252, 926251, 926250, 926249, 926248, 926247, 926246, 926245, 926244, 926243, 926242, 926241, 926240, 926239, 926238, 926237, 926236, 926235, 926234, 926233, 926232, 926231, 926230, 926229, 926228, 926227, 926226, 926225, 926224, 926223, 926222, 926221, 926220, 926219, 926218, 926217, 926216, 926215, 926214, 926213, 926212, 926211, 926210, 926209, 926208, 926207, 926206, 926205, 926204, 926203, 926202, 926201, 926200, 926199, 926198, 926197, 926196, 926195, 926194, 926193, 926192, 926191, 926190, 926189, 926188, 926187, 926186, 926185, 926184, 926183, 926182, 926181, 926180, 926179, 926178, 926177, 926176, 926175, 926174, 926173, 926172, 926171, 926170, 926169, 926168, 926167, 926166, 926165, 926164, 926163, 926162, 926161, 926160, 926159, 926158, 926157, 926156, 926155, 926154, 926153, 926152, 926151, 926150, 926149, 926148, 926147, 926146, 926145, 926144, 926143, 926142, 926141, 926140, 926139, 926138, 926137, 926136, 926135, 926134, 926133, 926132, 926131, 926130, 926129, 926128, 926127, 926126, 926125, 926124, 926123, 926122, 926121, 926120, 926119, 926118, 926117, 926116)