<%@ language="jscript" %>
<%
if (String(Request.querystring("action")) == "add")
{
var sql = "INSERT INTO chat ([time], message, userid) VALUES (";
sql += "'" + getDate() + "', ";
sql += "'" + String(Request.Querystring("message")).replace(/'/g, "''").replace(/
Chat window
<%
function getAge(dbtime)
{
var timeNow = new Date();
var timeM = new Date();
timeM.setDate(dbtime.substr(8,2));
timeM.setMonth(dbtime.substr(5,2) - 1);
timeM.setFullYear(dbtime.substr(0,4));
timeM.setHours(dbtime.substr(11,2));
timeM.setMinutes(dbtime.substr(14,2));
var diff = timeNow.valueOf() - timeM.valueOf();
result = "";
var minutes = Math.floor(Number(diff)/1000/60);
var hours = Math.floor(minutes/60);
var days = Math.floor(hours/24);
if (days > 0)
{
minutes -= days * 24 * 60;
hours -= days * 24;
result += days + " d. ";
}
if (hours > 0)
{
minutes -= hours * 60;
result += hours + " h. ";
}
result += minutes + " min.";
/*
if (time.getHours() > 0)
result += time.getHours() + " h. ";
result += time.getMinutes() + " min.";
*/
return result;
}
var sql = "SELECT top 100 message, [time], username, user.id as id FROM chat ";
sql += "INNER JOIN [user] ON user.id = chat.userid ORDER BY [time] desc, chat.id desc";
var rs = Server.CreateObject("adodb.recordset");
rs.Open(sql, conn);
if (!(rs.eof || rs.bof))
{
while (!(rs.eof || rs.bof))
{
Response.write(" (" + getAge(String(rs("time"))) + " ago) ");
Response.write("" + rs("username") + ": ");
Response.write(rs("message") + "
");
rs.Movenext();
}
}
else
{
Response.write("No messages!");
}
rs.Close();
%>