SK
dúvida

Erro Sql Tfs 0.4

Por sk8maleski, 25 de jan. de 2012 em Resolvidos

4
1.3k
sk8maleskiS
25 de janeiro de 2012 às 21:31

Estou com o seguinte problema no meu mysql

 

 

errohs.png

Apos esse erro ninguem consegue loga no server ;S

 

Help me

Editado Janeiro 25 por maleskiii

ZmovirZ
27 de janeiro de 2012 às 01:54

esse erro começou a aparecer depois que voce adcionou alguma coisa no servidor,

 

pelo oq eu vi falta voce executar uma query na database

27 de janeiro de 2012 às 09:11

Essa query é do script data/talkactions/scripts/frags.lua, tente algum desses dois:

local config = {
   useFragHandler = getBooleanFromString(getConfigValue('useFragHandler')),
   advancedFragList = getBooleanFromString(getConfigValue('advancedFragList'))
}

function onSay(cid, words, param, channel)
   if(not config.useFragHandler) then
       return false
   end

   local time = os.time()
   local times = {today = (time - 86400), week = (time - (7 * 86400))}

   local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")
   if(result:getID() ~= -1) then
       repeat
           local content = {
               name = result:getDataString("name"),
               level = result:getDataInt("level"),
               date = result:getDataInt("date")
           }
           if(content.date > times.today) then
               table.insert(contents.day, content)
           elseif(content.date > times.week) then
               table.insert(contents.week, content)
           else
               table.insert(contents.month, content)
           end
       until not result:next()
       result:free()
   end

   local size = {
       day = table.maxn(contents.day),
       week = table.maxn(contents.week),
       month = table.maxn(contents.month)
   }
   if(config.advancedFragList) then
       local result = "Frags gained today: " .. size.day .. "."
       if(size.day > 0) then
           for _, content in ipairs(contents.day) do
               result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level
           end

           result = result .. "\n"
       end

       result = result .. "\nFrags gained this week: " .. (size.day + size.week) .. "."
       if(size.week > 0) then
           for _, content in ipairs(contents.week) do
               result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level
           end

           result = result .. "\n"
       end

       result = result .. "\nFrags gained this month: " .. (size.day + size.week + size.month) .. "."
       if(size.month > 0) then
           for _, content in ipairs(contents.month) do
               result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level
           end

           result = result .. "\n"
       end

       local skullEnd = getPlayerSkullEnd(cid)
       if(skullEnd > 0) then
           result = result .. "\nYour " .. (getCreatureSkullType(cid) == SKULL_RED and "red" or "black") .. " skull will expire at " .. os.date("%d %B %Y %X", skullEnd)
       end

       doPlayerPopupFYI(cid, result)
   else
       doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You currently have " .. size.day .. " frags today, " .. (size.day + size.week) .. " this week and " .. (size.day + size.week + size.month) .. " this month.")
       if(size.day > 0) then
           doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Last frag at " .. os.date("%d %B %Y %X", contents.day[1].date) .. " on level " .. contents.day[1].level .. " (" .. contents.day[1].name .. ").")
       end

       local skullEnd = getPlayerSkullEnd(cid)
       if(skullEnd > 0) then
           doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Your " .. (getCreatureSkullType(cid) == SKULL_RED and "red" or "black") .. " skull will expire at " .. os.date("%d %B %Y %X", skullEnd))
       end
   end

   return true
end

 

ou:

 

local config = {
   useFragHandler = getBooleanFromString(getConfigValue('useFragHandler')),
   advancedFragList = getBooleanFromString(getConfigValue('advancedFragList'))
}

function onSay(cid, words, param, channel)
   if(not config.useFragHandler) then
       return false
   end

   local time = os.time()
   local times = {today = (time - 86400), week = (time - (7 * 86400))}

   local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")
   if(result:getID() ~= -1) then
       repeat
           local content = {
               name = result:getDataString("name"),
               level = result:getDataInt("level"),
               date = result:getDataInt("date")
           }
           if(content.date > times.today) then
               table.insert(contents.day, content)
           elseif(content.date > times.week) then
               table.insert(contents.week, content)
           else
               table.insert(contents.month, content)
           end
       until not result:next()
       result:free()
   end

   local size = {
       day = table.maxn(contents.day),
       week = table.maxn(contents.week),
       month = table.maxn(contents.month)
   }
   if(config.advancedFragList) then
       local result = "Frags gained today: " .. size.day .. "."
       if(size.day > 0) then
           for _, content in ipairs(contents.day) do
               result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level
           end

           result = result .. "\n"
       end

       result = result .. "\nFrags gained this week: " .. (size.day + size.week) .. "."
       if(size.week > 0) then
           for _, content in ipairs(contents.week) do
               result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level
           end

           result = result .. "\n"
       end

       result = result .. "\nFrags gained this month: " .. (size.day + size.week + size.month) .. "."
       if(size.month > 0) then
           for _, content in ipairs(contents.month) do
               result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level
           end

           result = result .. "\n"
       end

       local skullEnd = getPlayerSkullEnd(cid)
       if(skullEnd > 0) then
           result = result .. "\nYour " .. (getCreatureSkullType(cid) == SKULL_RED and "red" or "black") .. " skull will expire at " .. os.date("%d %B %Y %X", skullEnd)
       end

       doPlayerPopupFYI(cid, result)
   else
       doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You currently have " .. size.day .. " frags today, " .. (size.day + size.week) .. " this week and " .. (size.day + size.week + size.month) .. " this month.")
       if(size.day > 0) then
           doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Last frag at " .. os.date("%d %B %Y %X", contents.day[1].date) .. " on level " .. contents.day[1].level .. " (" .. contents.day[1].name .. ").")
       end

       local skullEnd = getPlayerSkullEnd(cid)
       if(skullEnd > 0) then
           doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Your " .. (getCreatureSkullType(cid) == SKULL_RED and "red" or "black") .. " skull will expire at " .. os.date("%d %B %Y %X", skullEnd))
       end
   end

   return true
end

sk8maleskiS
28 de janeiro de 2012 às 16:21

consegui resolver apenas fui na confi.lua

e aumentei o tempo do timeout do mysql

 

e resolveu meu problema!