function getChannelMessageCount(Channel_id)
local count = db.storeQuery("SELECT `count` FROM `channel_message` WHERE `channel_id` = ".. Channel_id)
if count ~= false then
local value = result.getDataInt (count, "count")
result.free (count)
return value
end
return -1
end
function setChannelMessageCount(Channel_id, value)
if getChannelMessageCount(Channel_id) == -1 then
return db:query("INSERT INTO `channel_message` (`channel_id`,`count`) VALUES (".. Channel_id ..", ".. value .."); ")
else
return db:query("UPDATE `channel_message` SET `count` = " .. value .. " WHERE `channel_id` = ".. Channel_id .."; ")
end
end