Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement