澳8番摊机器人源码/番摊彩票聊天室源码/28机器人彩票源码/机器人彩票源码/机器人自动控盘/前端html+后端PHP

# 更新系统并安装基础组件
sudo apt update && sudo apt upgrade -y
sudo apt install nginx mysql-server redis-server php7.4-fpm php7.4-mysql php7.4-redis php7.4-gd php7.4-mbstring php7.4-bcmath -y

# 配置MySQL
sudo mysql_secure_installation
# 创建数据库
mysql -u root -p
CREATE DATABASE lottery_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'lottery_user'@'localhost' IDENTIFIED BY 'StrongPass@2024';
GRANT ALL PRIVILEGES ON lottery_db.* TO 'lottery_user'@'localhost';
FLUSH PRIVILEGES;
EXIT;

cd /var/www
sudo git clone [源码仓库地址] lottery
sudo chown -R www-data:www-data lottery

cd lottery
cp .env.example .env
# 编辑.env文件
sudo nano .env
# 修改以下关键配置
DB_DATABASE=lottery_db
DB_USERNAME=lottery_user
DB_PASSWORD=StrongPass@2024
REDIS_HOST=127.0.0.1
REDIS_PASSWORD=null

composer install
php think migrate:run
php think seed:run

server {
    listen 80;
    server_name yourdomain.com;
    root /var/www/lottery/public;
    
    index index.php index.html;
    
    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }
    
    location ~ \.php$ {
        include snippets/fastcgi-php.conf;
        fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
    }
    
    # WebSocket代理配置
    location /ws {
        proxy_pass http://127.0.0.1:8282;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_set_header Host $host;
    }
}

# 使用Workerman启动WebSocket服务
php /var/www/lottery/websocket.php start -d

# 编辑crontab
crontab -e
# 添加以下任务
* * * * * cd /var/www/lottery && php think schedule:run >> /dev/null 2>&1
*/5 * * * * cd /var/www/lottery && php think lottery:collect >> /var/log/lottery_collect.log

// 在数据库中创建代理表
CREATE TABLE `agent` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `agent_code` varchar(50) NOT NULL,
    `commission_rate` decimal(5,2) DEFAULT '0.00',
    `team_count` int(11) DEFAULT '0',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- 为高频查询字段添加索引
ALTER TABLE `bet_records` ADD INDEX `idx_user_time` (`user_id`, `bet_time`);
ALTER TABLE `open_history` ADD INDEX `idx_game_period` (`game_type`, `period`);

// 使用Redis缓存开奖结果
$redis = new Redis();
$redis->connect('127.0.0.1', 6379);
$cacheKey = "lottery:results:{$gameType}:{$period}";
if (!$data = $redis->get($cacheKey)) {
    $data = Db::name('open_history')->where([...])->find();
    $redis->setex($cacheKey, 300, json_encode($data));
}

// 使用ThinkPHP验证器
$validate = new \think\Validate;
$validate->rule([
    'amount' => 'require|float|between:1,10000',
    'bet_content' => 'require|max:100'
]);

# 配置防火墙
sudo ufw allow 22/tcp
sudo ufw allow 80/tcp
sudo ufw allow 443/tcp
sudo ufw enable

# 定期备份
sudo crontab -e
0 2 * * * /usr/bin/mysqldump -u root -p[password] lottery_db > /backup/lottery_$(date +\%Y\%m\%d).sql

# 监控系统资源
htop
# 查看PHP进程
ps aux | grep php
# 监控MySQL查询
sudo mysqladmin processlist