/* chatlog.php */
<?php
session_start();
include "connect.php";
$room = $_SESSION['room'];
$getnummessages="SELECT COUNT(*) as messagecount from tbl_chatmessages";
$getnummessages2=mysql_query($getnummessages) or die("blah");
$getnummessages3=mysql_result($getnummessages2, 0);
if($getnummessages3>21)
{
$startrow=$getmessages3-20;
}
else
{
$startrow=1;
}
date_default_timezone_set ("Asia/Manila");
$date = date("Y-m-d");
$getmsg="SELECT * from tbl_chatmessages a, jcow_accounts b WHERE a.room_number='$room' && b.username=a.user_alias && a.date='$date' ORDER BY postime DESC";
$getmsg2=mysql_query($getmsg) or die(mysql_error());
while($getmsg3=mysql_fetch_array($getmsg2))
{
$message=Smiley($message); //Smiley faces
print "<div id='loaddiv'><div id='tablechatter'><table name='tablechat' id='tablechat' cellspacing='0' cellpadding='0' style='margin-top:10px;margin-left:0px;padding:0px;'>";
print "<tr><td rowspan='2'><a href='index.php?p=u/$getmsg3[user_alias]' target='_blank'><img src='http://www.pinoyarea.com/uploads/avatars/$getmsg3[avatar]' width='50px' height='50px'/></td><td><font color='#333333' style='text-decoration:none;font-size:14px;font-family:tahoma;'><b> $getmsg3[name]</b></font></a> <font color='#666666' style='text-decoration:none;font-size:10px;font-family:tahoma;'>($getmsg3[time]):</font></td></tr><tr><td><font style='font-family:tahoma;font-size:12px;'> $getmsg3[message]</font></td></tr>";
print "</table>";
print "</div>";
}
function Smiley ($texttoreplace)
{
$smilies = array
(
':)' => "<img src='images/smile.gif'>",
':blush' => "<img src='images/blush.gif'>",
':angry' => "<img src='images/angry.gif'>",
':o' => "<img src='images/shocked.gif'>",
'fuck' => "$#$%",
'Fuck' => "&$#@",
'bitch' => "$#%@&"
);
$texttoreplace=str_replace(array_keys($smilies),array_values($smilies),$texttoreplace);
return $texttoreplace;
}
?>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script>
$.ajaxSetup({ datatype: "html" });
var auto_refresh = setInterval(
function()
{
$('#loaddiv').load('chatlog.php?alt=json-in-script&callback=?');
}, 5000);
</script>
/* submit.php */
<?php
//if(isset($_POST['submit'])) //if submit button push has been detected
//{
session_start();
include "connect.php";
$message=$_POST['message'];
$name = $_SESSION['username'];
$room = $_SESSION['room'];
$user = $_SESSION['user'];
$sql_row = mysql_query("SELECT * FROM tbl_chatmessages ORDER BY postime DESC");
$count_row = mysql_num_rows($sql_row);
if(strlen($message)<1)
{
//print "<//script>alert('You did not input a message');<//script>";
}
else if(strlen($name)<1)
{
//print "<script>alert('You did not enter a name, please try again.');<//script>";
}
else if($count_row >= 50)
{
mysql_query("DELETE FROM tbl_chatmessages ORDER BY postime ASC LIMIT 1");
date_default_timezone_set ("Asia/Manila");
$date = date("Y-m-d");
$time = date("H:i:s");
$real_time = DATE("g:i a", STRTOTIME($time));
$message=strip_tags($message);
$IP=$_SERVER["REMOTE_ADDR"]; //grabs poster's IP
$id=rand(11111111111111111111,99999999999999999999);
$thedate=date("U"); //grab date and time of the post
$insertmessage="INSERT into tbl_chatmessages (id,name,ip,postime,date,time,message,room_number,user_alias) VALUES ('$id','$name','$IP','$thedate', '$date' , '$real_time' ,'$message','$room','$user')";
mysql_query($insertmessage) or die("Could not insert message");
}
else
{
date_default_timezone_set ("Asia/Manila");
$date = date("Y-m-d");
$time = date("H:i:s");
$real_time = DATE("g:i a", STRTOTIME($time));
$message=strip_tags($message);
$IP=$_SERVER["REMOTE_ADDR"]; //grabs poster's IP
$id=rand(11111111111111111111,99999999999999999999);
$thedate=date("U"); //grab date and time of the post
$insertmessage="INSERT into tbl_chatmessages (id,name,ip,postime,date,time,message,room_number,user_alias) VALUES ('$id','$name','$IP','$thedate', '$date' , '$real_time' ,'$message','$room','$user')";
mysql_query($insertmessage) or die("Could not insert message");
}
//}
$sql ="SELECT emote, image FROM emoticons";
$result=mysql_query($sql);
print "<link rel=\"stylesheet\" type=\"text/css\" href=\"who-is-online/styles.css\" />";
print "<center><div id='form'>";
print "<div class=\"onlineWidget\"><img class=\"arrow\"><div class=\"panel\"><img class=\"preloader\" src=\"who-is-online/img/preloader.gif\" alt=\"Loading..\" width=\"22\" height=\"22\" /></div></div>";
print "<br/><form method='post' id='form' name='form'>";
print "<input type='text' id='message' name='message' rows='0' width='300px' size='55' style='margin-top:0px;margin-bottom:0px;margin-left:0px;'></textarea>";
print "<input type='submit' class='submit' id='submit' name='submit' value='Send'></form>";
print "<script language=\"Java Script\" type=\"text/javascript\">\n";
print "function addSmiley(textToAdd)\n";
print "{\n";
print "document.form.message.value += textToAdd;";
print "document.form.message.focus();\n";
print "}\n";
print "</script>\n";
print "</div></center>";
?>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script type="text/javascript">
$(function(){
$(".submit").click(function(){
var message = $("#message").val();
var dataString = 'message'+message;
$.ajax({
type: "POST",
url: "submit.php?alt=json-in-script&callback=?",
var dataString = {'message' : message };
});
/*$message=$_POST['message'];
$name = $_SESSION['username'];
$room = $_SESSION['room'];
$user = $_SESSION['user'];*/
});
});
</script>