-- PtokaX > AJAX Chat script
-- version 2
-- by deseven, 2010

-- settings
BadChars = {".","?","!","+","-",}
MysqlHost = "localhost"
MysqlUser = "ajaxchat"
MysqlPass = "ajaxchatpwd"
MysqlDB = "ajaxchat"
UseIconv = true
IconvFrom = "cp1251"
IconvTo = "utf8//TRANSLIT"

function ChatArrival(user,data)
    Core.GetUserAllData(user)
    if string.sub(data,1,1) ~= "<" then end
    local s,e,chat = string.find(data,"^%b<>%s(.*)$")
    local when = os.date("%Y-%m-%d %H:%M:%S")
    local nick = user.sNick

    -- checking for BadChars
    for k,v in pairs(BadChars) do
        if chat == v then
            return
        end
    end

    -- preparing strings for bash
    -- welcome to the quotes' hell
    chat = string.sub(chat, 1, -2)
    nick = string.gsub(nick,"\\","\\\\")
    nick = string.gsub(nick,"'","'\"\\'\"'")
    chat = string.gsub(chat,"\\","\\\\")
    chat = string.gsub(chat,"'","'\"\\'\"'")

    -- sending message to AJAX chat
    SendMsg = "echo 'SET NAMES utf8; INSERT INTO ajax_chat_messages (userName,dateTime,text,userID) VALUES ('\"'\"'"..nick.."'\"','\"'"..when.."'\"','\"'"..chat.."'\"','50000');\" "
    if UseIconv == true then
        SendMsg = SendMsg.."| iconv -f "..IconvFrom.." -t "..IconvTo.." | mysql -B -N -h "..MysqlHost.." -u"..MysqlUser.." -p"..MysqlPass.." "..MysqlDB
    else
        SendMsg = SendMsg.."| mysql -B -N -h "..MysqlHost.." -u"..MysqlUser.." -p"..MysqlPass.." "..MysqlDB
    end
    os.execute(SendMsg)
end