HomeServer/Server/AllServer/GameServer/Repair.lua

local skynet = require "skynet"
local oo = require "Class"
local pb = require "pb"
local log = require "Log"
local errorInfo = require "ErrorInfo"
local dataType = require "DataType"
local json =require "json"
local Repair = oo.class()

--[[
     GameData->'$.nickName', \
    GameData->'$.coin', \
    GameData->'$.clovers', \
    GameData->'$.volute', \
    GameData->'$.contributeCoin', \
    GameData->'$.level', \
    GameData->'$.exp', \
    GameData->'$.upTime', \
    GameData->'$.unlockFurniture', \
    GameData->'$.unlockSystem', \
    GameData->'$.extraRevenue', \
    GameData->'$.onceSign', \
    GameData->'$.plantCount', \
    GameData->'$.aquaticPlantCount', \
    GameData->'$.ripePlantSeedsCount', \
    GameData->'$.adCountInfo', \
    GameData->'$.todayGain', \
    GameData->'$.finishGuide', \
    GameData->'$.giftBox',\
    GameData->'$.tips', \
    GameData->'$.gashapon', \
    GameData->'$.illustration', \
    GameData->'$.msgTips', \
    GameData->'$.friend', \
    GameData->'$.levelTask', \
    GameData->'$.dailyTask',\
    GameData->'$.achieveTask',\
    GameData->'$.npcTask', \
    GameData->'$.curHouseID', \
    GameData->'$.house', \
    GameData->'$.curUniqueID', \
    GameData->'$.curBagSort', \
    GameData->'$.bag', \
    GameData->'$.bagCount', \
    GameData->'$.putMaxCount', \
    GameData->'$.goodsHistoryMaxCount', \
    GameData->'$.flowerpot', \
    GameData->'$.shop', \
    GameData->'$.activity', \
    GameData->'$.activityManage', \
    GameData->'$.used', \
    GameData->'$.redeem', \
    GameData->'$.mail', \
    GameData->'$.personal', \
    GameData->'$.announcement', \
    GameData->'$.questionnaire', \
    GameData->'$.pet', \
    GameData->'$.map', \
    GameData->'$.visitMapList', \
    GameData->'$.passCheck', \
    GameData->'$.dyeWorkShop', \
    GameData->'$.furnitureWorkShop', \
    GameData->'$.design', \
    GameData->'$.storePack', \
    GameData->'$.signIn', \
    GameData->'$.playerLand', \
    GameData->'$.partner', \
    GameData->'$.group', \
    GameData->'$.doubleSpace', \
    GameData->'$.switches', \
    GameData->'$.houseRent', \
    GameData->'$.matchStuffMap', \
    GameData->'$.NewPlayerRaffleMap' \
]]

function Repair:Start()
    local sql = "select \
    GameData->'$.nickName', \
    GameData->'$.coin', \
    GameData->'$.clovers', \
    GameData->'$.volute', \
    GameData->'$.contributeCoin', \
    GameData->'$.level', \
    GameData->'$.exp', \
    GameData->'$.upTime', \
    GameData->'$.unlockFurniture', \
    GameData->'$.unlockSystem', \
    GameData->'$.extraRevenue', \
    GameData->'$.onceSign', \
    GameData->'$.plantCount', \
    GameData->'$.aquaticPlantCount', \
    GameData->'$.ripePlantSeedsCount', \
    GameData->'$.adCountInfo', \
    GameData->'$.todayGain', \
    GameData->'$.finishGuide', \
    GameData->'$.giftBox',\
    GameData->'$.tips', \
    GameData->'$.gashapon', \
    GameData->'$.illustration', \
    GameData->'$.msgTips', \
    GameData->'$.friend', \
    GameData->'$.levelTask', \
    GameData->'$.dailyTask',\
    GameData->'$.achieveTask',\
    GameData->'$.npcTask', \
    GameData->'$.curHouseID', \
    GameData->'$.house', \
    GameData->'$.curUniqueID', \
    GameData->'$.curBagSort', \
    GameData->'$.bagCount', \
    GameData->'$.putMaxCount', \
    GameData->'$.goodsHistoryMaxCount', \
    GameData->'$.flowerpot', \
    GameData->'$.shop', \
    GameData->'$.activity', \
    GameData->'$.activityManage', \
    GameData->'$.used', \
    GameData->'$.redeem', \
    GameData->'$.mail', \
    GameData->'$.personal', \
    GameData->'$.announcement', \
    GameData->'$.questionnaire', \
    GameData->'$.pet', \
    GameData->'$.map', \
    GameData->'$.visitMapList', \
    GameData->'$.passCheck', \
    GameData->'$.dyeWorkShop', \
    GameData->'$.furnitureWorkShop', \
    GameData->'$.design', \
    GameData->'$.storePack', \
    GameData->'$.signIn', \
    GameData->'$.playerLand', \
    GameData->'$.partner', \
    GameData->'$.group', \
    GameData->'$.doubleSpace', \
    GameData->'$.switches', \
    GameData->'$.houseRent', \
    GameData->'$.matchStuffMap', \
    GameData->'$.NewPlayerRaffleMap' \
    from player where UserID = 20159472"

    local queryData = skynet.server.db:QueryPlayer( 2 , sql )
    queryData = queryData[1]
    local userData = {}
    --[[userData["playerLand"] = {}
    userData["playerLand"].isShow = false
    userData["playerLand"].signCount = 2
    userData["playerLand"].signInInfo = {}
    userData["playerLand"].endTime = 1717211570
    userData["illustration"] = {}
    userData["illustration"].goodsInfo = {}
    userData["illustration"].awardInfo = {}
    ]]

    --userData["flowerpot"] = {}
    userData["bag"] = {}
    local count = 0
    for k, v in pairs(queryData) do
        k = string.sub(k, 14, -1)
        local findPos = string.find(k, "'")
        k = string.sub(k, 0, findPos- 1)

        if k == "mail" then
            userData[k] = 
            {
                curIndex = 1,
                historyMail = {},
                mailList = {}
            }
        else
            userData[k] = json:decode(v)
        end

        count = count + 1
        if count == 5 then
            --break
        end
    end

    local writeSql = string.format("insert into tempData( GameData ) values('%s')" , json:encode(userData) )
    queryData = skynet.server.db:QueryPlayer( 2 , writeSql )
end

skynet.server.repair = Repair
return Repair