-- PtokaX > AJAX Chat script
-- version 1.0.2
-- by deseven, 2010-2011

-- main settings
MysqlHost = "localhost"
MysqlUser = "ajaxchat"
MysqlPass = "ajaxchatpwd"
MysqlDB = "ajaxchat"

-- codepage and convertion settings
UseIconv = true
IconvFrom = "cp1251"
IconvTo = "utf8//TRANSLIT"
UseSetNames = true
BadChars = {".","?","!","+","-",}

function ChatArrival(user,data)
	Core.GetUserAllData(user)
	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 string.sub(chat,1,1) == 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,"'","'\"\\'\"'")
	chat = string.gsub(chat,"&#124;","|")
	chat = string.gsub(chat,"&#36;","$")

	-- sending message to AJAX chat
	if UseSetNames == true then
		SendMsg = "echo 'SET NAMES utf8; INSERT INTO ajax_chat_messages (userName,dateTime,text,userID) VALUES ('\"'\"'"..nick.."'\"','\"'"..when.."'\"','\"'"..chat.."'\"','50000');\" "
	else
		SendMsg = "echo 'INSERT INTO ajax_chat_messages (userName,dateTime,text,userID) VALUES ('\"'\"'"..nick.."'\"','\"'"..when.."'\"','\"'"..chat.."'\"','50000');\" "
	end
	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