Вопросы Разработчикам Скриптов с SQL, вопросы по скриптам (мелкие вопросы)

function OnError(sMsg)
    local sRusMsg = ""
    local tRusError = {
        ["bad argument"] = "плохой аргумент",
        ["string expected"] = "ожидается строка",
    }
    for i,v in pairs(tRusError) do
        sRusMsg = string.gsub(sMsg, i, v)
    end
    Core.SendToAll(sRusMsg)
    db:exec("CREATE TABLE le"..os.date("%d%m%Y").." (id INTEGER PRIMARY KEY, Time TEXT, Error TEXT)")
    db:exec("INSERT INTO le"..os.date("%d%m%Y").." (Time,Error) VALUES ('"..os.date("%H:%M:%S").."', '"..sRusMsg.."')")
end

function CheckBans(tUser)
    if tUsers[tUser.sIP].Ban then
        if tUsers[tUser.sIP].Ban.Time == "full" then
            Core.SendToUser(tUser, "<"..sBot.."> \r\n\r\n\t\t\tВы навсегда забанены на этом хабе \r\n\t\t\tПо причине: "..tUsers[tUser.sIP].Ban.Reason.."\r\n\t\t\tНаказал:"..tUsers[tUser.sIP].Ban.Punished.."\r\n")
            db:exec("CREATE TABLE ldu"..os.date("%d%m%Y").." (id INTEGER PRIMARY KEY, Time TEXT, Nick TEXT, IP TEXT, Reason TEXT)")
            db:exec("INSERT INTO ldu"..os.date("%d%m%Y").." (Time,Nick,IP,Msg) VALUES ('"..os.date("%H:%M:%S").."', '"..tUser.sNick.."', '"..tUser.sIP.."', 'Навсегда забанен')")            
            Core.Disconnect(tUser)

    if tCfg.MainLogs == 1 then
        local _,_,sData = string.find(sData, "%b<>%s+(.*)")
        db:exec("CREATE TABLE lmc"..os.date("%d%m%Y").." (id INTEGER PRIMARY KEY, Time TEXT, Nick TEXT, IP TEXT, Msg TEXT)")
        db:exec("INSERT INTO lmc"..os.date("%d%m%Y").." (Time,Nick,IP,Msg) VALUES ('"..os.date("%H:%M:%S").."', '"..tUser.sNick.."', '"..tUser.sIP.."', '"..sData.."')")
    end

function UserDisconnected(tUser)
    db:exec("UPDATE Users SET Offdate='"..os.date("%d.%m.%Y в %H:%M").."' WHERE IP='"..tUser.sIP.."'")
end

    db:exec("CREATE TABLE Users (id INTEGER PRIMARY KEY, Nick TEXT, IP TEXT, Shara NUMERIC, Msg NUMERIC, Time NUMERIC, Enterdate TEXT, Offdate TEXT, Bantime TEXT, Banreason TEXT,"..
    "Banpunished TEXT, Gagtime TEXT, Gagreason TEXT, Gagpunished TEXT, Gagtype TEXT, Downloadtime TEXT, Downloadreason TEXT, Downloadpunished TEXT, Seachtime TEXT, Seachreason TEXT,"..
    "Seachpunished TEXT)")

"UPDATE Users SET Offdate='"..os.date("%d.%m.%Y в %H:%M").."' WHERE id='"..id.."'"

"CREATE TABLE Users (id INTEGER PRIMARY KEY, Nick TEXT, IP TEXT UNIQUE, ...

    db:exec("CREATE TABLE Users (id INTEGER PRIMARY KEY, Nick TEXT, IP TEXT UNIQUE, Shara NUMERIC, Msg NUMERIC, Time NUMERIC, Enterdate TEXT, Offdate TEXT, Bantime TEXT, Banreason TEXT,"..
    "Banpunished TEXT, Gagtime TEXT, Gagreason TEXT, Gagpunished TEXT, Gagtype TEXT, Downloadtime TEXT, Downloadreason TEXT, Downloadpunished TEXT, Seachtime TEXT, Seachreason TEXT,"..
    "Seachpunished TEXT)")

SELECT msg FROM table WHERE ip = 'ip2'