package config
|
|
import (
|
"fmt"
|
"log"
|
"time"
|
|
"gamebox-server/models"
|
|
"golang.org/x/crypto/bcrypt"
|
"gorm.io/driver/mysql"
|
"gorm.io/gorm"
|
"gorm.io/gorm/logger"
|
)
|
|
var DB *gorm.DB
|
|
func InitDB() {
|
dsn := "root:123qwe@tcp(127.0.0.1:3306)/gamebox?charset=utf8mb4&parseTime=True&loc=Local"
|
db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{
|
Logger: logger.Default.LogMode(logger.Warn),
|
})
|
if err != nil {
|
log.Fatalf("连接数据库失败: %v", err)
|
}
|
DB = db
|
|
err = DB.AutoMigrate(
|
&models.Admin{}, &models.User{}, &models.Category{}, &models.Game{},
|
&models.Tool{}, &models.MemberKey{}, &models.Favorite{},
|
&models.LibraryItem{}, &models.Announcement{},
|
)
|
if err != nil {
|
log.Fatalf("数据库迁移失败: %v", err)
|
}
|
fmt.Println("数据库连接成功")
|
seed()
|
}
|
|
func hashPassword(pwd string) string {
|
b, _ := bcrypt.GenerateFromPassword([]byte(pwd), bcrypt.DefaultCost)
|
return string(b)
|
}
|
|
func seed() {
|
// 管理员账号
|
var adminCount int64
|
DB.Model(&models.Admin{}).Count(&adminCount)
|
if adminCount == 0 {
|
DB.Create(&models.Admin{Username: "admin", Password: hashPassword("123456")})
|
fmt.Println("已创建管理员账号: admin / 123456")
|
}
|
|
// 类别
|
var catCount int64
|
DB.Model(&models.Category{}).Count(&catCount)
|
if catCount == 0 {
|
cats := []models.Category{
|
{Name: "角色扮演", Sort: 1}, {Name: "动作冒险", Sort: 2},
|
{Name: "射击游戏", Sort: 3}, {Name: "格斗游戏", Sort: 4},
|
{Name: "竞速体育", Sort: 5}, {Name: "模拟经营", Sort: 6},
|
{Name: "即时战略", Sort: 7}, {Name: "经典怀旧", Sort: 8},
|
{Name: "常用工具", Sort: 9},
|
}
|
DB.Create(&cats)
|
}
|
|
// 公告
|
var annCount int64
|
DB.Model(&models.Announcement{}).Count(&annCount)
|
if annCount == 0 {
|
DB.Create(&models.Announcement{Content: "平台客服上班时间:早8点到晚10点!\n下载速度慢的,把下载窗口拍照发给客服看下。\n下载好的游戏,下载完直接创建快捷方式!\n打开盒子资源库,右键安装好的游戏图片,创建快捷方式!\n平台客服在线时间:早8点--晚10点。其余时间请留言\n国产游戏不会有,不用问!都是单机游戏,无法联机!"})
|
}
|
|
// 工具
|
var toolCount int64
|
DB.Model(&models.Tool{}).Count(&toolCount)
|
if toolCount == 0 {
|
tools := []models.Tool{
|
{Name: "DX修复", Size: "435.7 MB", Description: "DirectX修复工具增强版", Cover: "/static/covers/tool_dx.png", FileURL: ""},
|
{Name: "Windows 10 21H2", Size: "13.3 GB", Description: "Windows 10 21H2 系统镜像", Cover: "/static/covers/tool_win10.png", FileURL: ""},
|
{Name: "微软常用运行库合集", Size: "158.6 MB", Description: "Microsoft Common Runtime Libraries", Cover: "/static/covers/tool_runtime.png", FileURL: ""},
|
{Name: "一修大师修改器", Size: "85.3 MB", Description: "一修大师修改器", Cover: "/static/covers/tool_master.png", FileURL: ""},
|
{Name: "NTE游戏运行库等工具", Size: "3.3 GB", Description: "NTE游戏运行库合集", Cover: "/static/covers/tool_nte.png", FileURL: ""},
|
{Name: "免费体验", Size: "387.2 MB", Description: " Plants vs. Zombies 免费体验版", Cover: "/static/covers/tool_pvz.png", FileURL: ""},
|
}
|
DB.Create(&tools)
|
}
|
|
// 示例游戏
|
var gameCount int64
|
DB.Model(&models.Game{}).Count(&gameCount)
|
if gameCount == 0 {
|
var catMap = map[string]uint{}
|
var cats []models.Category
|
DB.Find(&cats)
|
for _, c := range cats {
|
catMap[c.Name] = c.ID
|
}
|
games := []models.Game{
|
{
|
Title: "真·三国无双 起源", CategoryID: catMap["动作冒险"], Platform: "pc", Tags: "动作冒险",
|
Size: "82 GB", InstallSize: "131.3 GB", OSReq: "Windows 10 64bit", CPUReq: "Intel i5-4460 / AMD Ryzen 5 1600",
|
GPUReq: "GTX 1060 6GB / RX 580 8GB", RAMReq: "16 GB RAM",
|
VersionNote: "Build 24|豪华中文版|官方简体中文|支持键盘.鼠标.手柄",
|
Cover: "/static/covers/game1.png", Screenshots: "[]", Files: "[]", IsBanner: true,
|
Description: "真·三国无双 起源(Dynasty Warriors: Origins)豪华中文版,包含全部DLC。\n支持键盘、鼠标、手柄操作。",
|
},
|
{
|
Title: "极限竞速:地平线5 v1.685.421顶级版", CategoryID: catMap["竞速体育"], Platform: "pc", Tags: "竞速体育",
|
Size: "232.6 GB", InstallSize: "411.6 GB", OSReq: "Windows 10 64bit (18362.0及以上)", CPUReq: "Intel i5-4460 or AMD Ryzen 3 1200",
|
GPUReq: "NVIDIA GeForce GTX 1050 4GB / AMD Radeon RX 480 4GB", RAMReq: "16 GB RAM",
|
VersionNote: "V1.685.421顶级版|容量175GB|官方简体中文|支持键盘.鼠标.手柄|赠全车辆收藏.原厂调教涂装.剧情故事全三星.DLC全通存档",
|
Cover: "/static/covers/game2.png", Screenshots: "[]", Files: "[]", IsBanner: true,
|
Description: "V1.685.421顶级版|容量175GB|官方简体中文|支持键盘.鼠标.手柄|赠全车辆收藏.原厂调教涂装.剧情故事全三星.DLC全通存档\n\n【存档使用方法→直往下拉即可】\n1.首先在游戏根目录里把steam_emu.ini里的#AccountId的#去掉,\n2.改成 AccountId=2535446289078643\n3.游戏名字可以改:UserName=xxxxxxxx/随意",
|
},
|
{
|
Title: "使命召唤23:现代战争4/Call of Duty: Modern Warfare IV", CategoryID: catMap["射击游戏"], Platform: "pc", Tags: "射击游戏",
|
Size: "173.8 GB", InstallSize: "340.8 GB", OSReq: "Windows 10 64bit", CPUReq: "Intel i5-4460 / AMD Ryzen 3 1200",
|
GPUReq: "GTX 1060 6GB / RX 580 8GB", RAMReq: "16 GB RAM",
|
VersionNote: "V1.0|容量160GB|官方简体中文|支持键盘.鼠标",
|
Cover: "/static/covers/game3.png", Screenshots: "[]", Files: "[]", IsBanner: true,
|
Description: "使命召唤23:现代战争4 精简版系统玩不了!打开系统安全中心,关闭实时防护后再运行游戏。",
|
},
|
{
|
Title: "我独自升级 起立·觉醒豪华中文版v1.1.100", CategoryID: catMap["角色扮演"], Platform: "pc", Tags: "角色扮演",
|
Size: "53.9 GB", InstallSize: "95.3 GB", OSReq: "Windows 10 / 11", CPUReq: "i5 4460 3.2 GHz Or AMD equivalent",
|
GPUReq: "GTX1060 / Radeon RX 580", RAMReq: "16 GB RAM",
|
VersionNote: "V1.1.100|容量44.9GB|官方简体中文|支持键盘.鼠标.手柄",
|
Cover: "/static/covers/game4.png", Screenshots: "[]", Files: "[]", IsBanner: true,
|
Description: "V1.1.100|容量44.9GB|官方简体中文|支持键盘.鼠标.手柄\n含齐州岛攻略队特别篇章+全DLC。",
|
},
|
{
|
Title: "红警2/红色警戒2高清版(游戏菜单界面中文)", CategoryID: catMap["经典怀旧"], Platform: "pc", Tags: "即时战略,经典怀旧",
|
Size: "3.3 GB", InstallSize: "5 GB", OSReq: "Windows 7/10/11", CPUReq: "Intel Core 2 Duo",
|
GPUReq: "集成显卡", RAMReq: "4 GB RAM",
|
VersionNote: "高清版|容量3.3GB|中文|右键打开游戏安装目录,然后按照游戏详情页教程运行",
|
Cover: "/static/covers/game5.png", Screenshots: "[]", Files: "[]",
|
Description: "右键打开游戏安装目录,然后按照游戏详情页的教程运行游戏即可。",
|
},
|
{
|
Title: "女神异闻录5皇家版", CategoryID: catMap["角色扮演"], Platform: "switch", Tags: "角色扮演",
|
Size: "31.6 GB", InstallSize: "40 GB", OSReq: "Windows 10 64bit(需模拟器)", CPUReq: "Intel i5-8400 / AMD Ryzen 5 3600",
|
GPUReq: "GTX 1650 4GB", RAMReq: "16 GB RAM",
|
VersionNote: "皇家版|容量31.6GB|官方简体中文|需Yuzu/Ryujinx模拟器",
|
Cover: "/static/covers/game6.png", Screenshots: "[]", Files: "[]",
|
Description: "设置中文:先打开模拟器,右击游戏图片,选择属性,语言设置为简体中文。",
|
},
|
{
|
Title: "塞尔达传说:旷野之息", CategoryID: catMap["动作冒险"], Platform: "switch", Tags: "动作冒险",
|
Size: "38.9 GB", InstallSize: "45 GB", OSReq: "Windows 10 64bit(需模拟器)", CPUReq: "Intel i5-8400 / AMD Ryzen 5 3600",
|
GPUReq: "GTX 1650 4GB", RAMReq: "16 GB RAM",
|
VersionNote: "Switch版|容量38.9GB|中文|需Yuzu/Ryujinx模拟器",
|
Cover: "/static/covers/game7.png", Screenshots: "[]", Files: "[]",
|
Description: "点击启动运行游戏即可,建议使用YuzuEA最新版模拟器。",
|
},
|
{
|
Title: "精灵宝可梦Let's Go!皮卡丘", CategoryID: catMap["角色扮演"], Platform: "switch", Tags: "角色扮演",
|
Size: "4.1 GB", InstallSize: "6 GB", OSReq: "Windows 10 64bit(需模拟器)", CPUReq: "Intel i5-8400",
|
GPUReq: "GTX 1650 4GB", RAMReq: "16 GB RAM",
|
VersionNote: "Switch版|容量4.1GB|中文|需模拟器",
|
Cover: "/static/covers/game8.png", Screenshots: "[]", Files: "[]",
|
Description: "点击启动运行游戏即可。",
|
},
|
{
|
Title: "鬼武者:剑之道 Build.24769601+预购特典", CategoryID: catMap["动作冒险"], Platform: "pc", Tags: "动作冒险",
|
Size: "131.3 GB", InstallSize: "180 GB", OSReq: "Windows 10 64bit", CPUReq: "Intel i5-4460",
|
GPUReq: "GTX 1060 6GB", RAMReq: "16 GB RAM",
|
VersionNote: "Build.24769601|豪华中文版|支持键盘.鼠标.手柄",
|
Cover: "/static/covers/game9.png", Screenshots: "[]", Files: "[]",
|
Description: "鬼武者:剑之道 豪华中文版,包含预购特典。",
|
},
|
{
|
Title: "使命召唤20:现代战争3/Call of Duty: MW III", CategoryID: catMap["射击游戏"], Platform: "pc", Tags: "射击游戏",
|
Size: "340.8 GB", InstallSize: "500 GB", OSReq: "Windows 10 64bit", CPUReq: "Intel i5-4460",
|
GPUReq: "GTX 1060 6GB", RAMReq: "16 GB RAM",
|
VersionNote: "V1.0|容量300GB|官方简体中文",
|
Cover: "/static/covers/game10.png", Screenshots: "[]", Files: "[]",
|
Description: "使命召唤20:现代战争3 完整版。",
|
},
|
}
|
DB.Create(&games)
|
}
|
|
// 更新时间戳,让"最新更新"排序有区分度
|
DB.Exec("UPDATE games SET updated_at = ? WHERE updated_at = ?", time.Now(), time.Time{})
|
}
|