# cpp_online_imp **Repository Path**: hyMit/cpp_online_imp ## Basic Information - **Project Name**: cpp_online_imp - **Description**: No description available - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2025-10-18 - **Last Updated**: 2025-12-31 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # cpp_online_imp 基础镜像使用ubuntu -- 22 hk初始编译机， 完成编译。 制作自定义镜像或拷贝bin文件 # 密码 ssh ubuntu@101.42.117.250 Extend123!T!+20241127 # mysql 'USER': 'wa', "PASSWORD": "Xad@1234", "HOST": "127.0.0.1", "PORT": "3306", # cmd mysql -h 127.0.0.1 -u wa -pXad@1234 -P 3306 use wa show tables; # client test curl "http://127.0.0.1:50054/swim_image/login/?code=12345" curl "http://127.0.0.1:50054/swim_image/loginapp2/?code=1234578" curl "http://127.0.0.1:50054/swim_image/lunbo/?version=1.0.1" curl "http://127.0.0.1:50054/swim_image/latest/?version=1.0.1" curl "http://127.0.0.1:50051/swim_image/paltform/?version=1.0.1" curl "http://127.0.0.1:50051/swim_image/bloggerlist/?version=1.0.1&platid=-1" curl "http://127.0.0.1:50054/swim_image/downimage/?imageid=8" # client online curl https://online.alstockdata.cn:442/swim_image/gif/?version=1.0.1 离线内存池(定时任务): 定期读取mysql, 写入redis 1. gif内存池: image_pool表中is_gif=true所有数据 -- 待完成 2. 最新内存池: image_pool表最后插入的2000图片(排除is_gif=true 、ai类别) 3. 下载离线池: image_pool表下载量最高的500图片 4. 审核离线池: image_pool表所有审核模式的图片 5. Ai离线池: image_pool表所有Ai类别的图片 6. 博主内存池: 所有博主数据 1. 登陆接口 (app.js) -- app启动 -- 暂不实现 https://bg.alstockdata.cn/wechat_login/ post: code: 微信内部wx.login返回res.code 2. 首页获取gif接口 -- (首页推荐) https://bg.alstockdata.cn/gif/ get: version: 客户端版本 在线逻辑: 若为审核模式: 返回空数据 非审核模式: gif内存池随机count条数据 3. 首页获取推荐接口 -- (首页推荐) https://bg.alstockdata.cn/rec/ post: version: 客户端版本 在线逻辑: 若为审核模式: 随机6张审核离线池图片 非审核模式: 随机3张最新内存池图片、随机3张下载离线池数据。 整体数据随机排序。 4. 搜索接口 -- (AISearch) https://bg.alstockdata.cn/aiserach/ post: version 在线逻辑: 随机4张Ai离线池图片 // 下期实现博主。 图片 image_pool id | bigint | NO | PRI | NULL | auto_increment | image_url | varchar(255) | NO | | | | category_id | bigint | NO | MUL | 0 | | modify_time | timestamp | NO | | CURRENT_TIMESTAMP | DEFAULT_GENERATED | description | varchar(255) | NO | | | | image_thumbnail | varchar(255) | NO | | | | download_cnt | bigint | NO | | 0 | | for_review | int | NO | | 0 | | blogger_id | bigint | YES | MUL | NULL | | is_gif | tinyint(1) | NO | | 0 | | need_ad | tinyint(1) | NO | | 0 | | select * from image_pool limit 5; update image_pool set download_cnt = download_cnt + 1 where id = 8; update image_pool set download_cnt = 0 where id = 8; 平台 wa_platform id | bigint | NO | PRI | NULL | auto_increment | name | varchar(128) | YES | | NULL | | 博主 wa_blogger id | bigint | NO | PRI | NULL | auto_increment | name | varchar(128) | YES | | NULL | | funs_cnt | int | NO | | NULL | | platform_id | bigint | NO | MUL | NULL | | blogger_id | varchar(128) | YES | | NULL | | image1 | varchar(100) | NO | | NULL | | image2 | varchar(100) | NO | | NULL | | image3 | varchar(100) | NO | | NULL | | 配置 wa_config id | bigint | NO | PRI | NULL | auto_increment | key | varchar(255) | NO | | NULL | | value | varchar(255) | NO | | NULL | | 下载记录表 wa_down_info id | bigint | NO | PRI | NULL | auto_increment | imageid | bigint | YES | | NULL | | down_time | timestamp | YES | | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 用户表 wa_users id | bigint | NO | PRI | NULL | auto_increment | openid | varchar(64) | NO | UNI | NULL | | username | varchar(64) | YES | | NULL | | sex | smallint | NO | | NULL | | avatar | varchar(50) | YES | | NULL | | unionid | varchar(64) | YES | | NULL | | session_key | varchar(64) | YES | | NULL | | balance | bigint | NO | | NULL | | frozon_balance | bigint | NO | | NULL | | last_login | datetime(6) | YES | | NULL | | password | varchar(128) | NO | | NULL | | points | int | NO | | NULL | | CREATE TABLE wa_down_info ( id BIGINT AUTO_INCREMENT PRIMARY KEY, imageid BIGINT, down_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); select * from wa_down_info; insert into wa_down_info(imageid) values(1); delete from wa_down_info; 安装mysql -- 默认安装 sudo apt update sudo apt install mysql-server sudo systemctl status mysql # root登陆 mysql -h 127.0.0.1 -u root -P 3306 # 创建用户 CREATE USER 'wa'@'localhost' IDENTIFIED BY 'Xad@1234'; mysql -h 127.0.0.1 -u wa -pXad@1234 -P 3306 # 创建数据库 CREATE DATABASE wa; # 授予权限 GRANT ALL PRIVILEGES ON wa.* TO 'wa'@'localhost'; # 导出数据 mysqldump -h 172.21.0.3 -P 3306 -u wa -p wa > backup.sql # 导入数据 mysql -u wa -p wa < backup.sql 云服务器：https://xtcc.cloud.tencent.com/login_cb?tag=VAAHQm4LdlNOLFQS&from=private_area 优惠链接：https://xtcc.cloud.tencent.com/login_cb?tag=S8GEFdjGXSg80YzR&from=private_area 会员专区：https://xtcc.cloud.tencent.com/login_cb?tag=pkfB8rHTMjrhWnPI&from=private_area 续费管理：https://xtcc.cloud.tencent.com/login_cb?tag=AxNR583T36EJLbXM&from=private_area