Posted by rey Wed 7th Mar 2007 13:28 - Syntax is PHP - 17 viewsRun this post in the PHP shell
Download | New Post | Modify | Hide line numbers
PHP parser reported no syntax errors in this post!
  2. session_start();
  3. $start_time=microtime(true);
  4. //For AJAX!!
  5.  
  6. $chatpage="chat.xml";
  7. if (isset($_POST['send']))
  8. {
  9.     $send=$_POST['send'];
  10. }
  11. else
  12. {
  13.     $send=3;
  14. }
  15. $post=0;
  16. $showchat=0;
  17. $json= '';
  18. $name = htmlspecialchars($_POST['name'], ENT_QUOTES);
  19.  
  20.  
  21. if ($send=='1')  // If somebody SENT a message
  22. {
  23.     $message= $_POST['message'];
  24.     $post=1;
  25. }
  26. elseif ($send=='2')  // If somebody wants ALL messages
  27. {
  28.     $showchat='all';
  29. }
  30. elseif ($send=='3')  // If somebody wants NEW messaages
  31. {
  32.     if (isset($_SESSION['lastid']))
  33.     {
  34.         $last=$_SESSION['lastid'];
  35.     }
  36.     else //should never happen... but who knows
  37.     {
  38.         $last=$_POST['last_id'];
  39.         $_SESSION['lastid']=$last;
  40.     }
  41.     $showchat='new';
  42. }
  43.  
  44.  
  45. $user="guest";
  46. $password="fottilaetispiezoindue";
  47. $database="naerey";
  48. $server='switch-case.org';
  49. $link=mysql_connect($server,$user,$password);
  50. mysql_select_db($database,$link) or die( "Unable to select database");
  51.  
  52. if ($post)
  53. {
  54.     $message = htmlspecialchars($message, ENT_QUOTES);
  55.     $message = wordwrap($message, 25, " ", 1);
  56.     $smileys = array ('>:)',':(',':D',':/',';)',':|',':)','O_O','>_<',':p',':P',
  57.         'woot','rofl','ouch','lol','love','<3','lmao');
  58.     $smilhtml= array ('','',
  59.         '','',
  60.         '','',
  61.         '','',
  62.         '','',
  63.         '','',
  64.         '','',
  65.         '','',
  66.         '','');
  67.     $message= str_replace($smileys,$smilhtml,$message);
  68.     //Smileys!
  69.    
  70.     $date_=date("d/m/y");
  71.     $time_=date("H:i:s");
  72.     $ip_=$_SERVER['REMOTE_ADDR'];
  73.     $query="INSERT INTO `chat_history` values ( '', '$ip_', '$date_', '$time_', '$name', '$message')";
  74.     $result=mysql_query($query,$link);
  75.    
  76.     $time_=date("His");$date_=date("d/m/y");
  77.     $query ="INSERT INTO chat_users VALUES ('$ip_', '$date_', '$time_', '$name', '1') ";
  78.     $query.="ON DUPLICATE KEY UPDATE date='$date_',time='$time_',posts=posts+1,name='$name' ";
  79.     $result=mysql_query($query,$link);
  80. }
  81.  
  82.  
  83. if ($showchat=='all')
  84. {
  85.     $query="SELECT id,name,message,time FROM ( SELECT id,name,message,time FROM ";
  86.         $query.="chat_history ORDER BY id DESC LIMIT 10 ) AS tmp ORDER BY id";
  87.     $result=mysql_query($query,$link);
  88.     $num=mysql_num_rows($result);
  89.     $i=0;
  90.     while ($i < $num)
  91.     {
  92.         $_name=mysql_result($result,$i,"name");
  93.         $_message=mysql_result($result,$i,"message");
  94.         $_id=mysql_result($result,$i,"id");
  95.         $_time=mysql_result($result,$i,"time");
  96.         $json.= "\n

    $_time $_name: $_message

    "    ;
  97.         ++$i;
  98.     }
  99.    
  100.     $date_=date("d/m/y");
  101.     $time_=date("His");
  102.     $ip_=$_SERVER['REMOTE_ADDR'];
  103.     $query ="INSERT INTO chat_users VALUES ('$ip_', '$date_', '$time_', '$name', '1') ";
  104.     $query.="ON DUPLICATE KEY UPDATE date='$date_',time='$time_',name='$name' ";
  105.     $result=mysql_query($query,$link);
  106. }
  107. elseif($showchat=='new')
  108. {
  109.     $query="SELECT id,name,message,time FROM chat_history WHERE id>$last";
  110.     $result=mysql_query($query,$link);
  111.     $num=mysql_num_rows($result);
  112.     $i=0;
  113.     while ($i < $num)
  114.     {
  115.         $_name=mysql_result($result,$i,"name");
  116.         if ($_name==$name)
  117.         {
  118.             $_name='You';
  119.         }
  120.         $_message=mysql_result($result,$i,"message");
  121.         $_id=mysql_result($result,$i,"id");
  122.         $_time=mysql_result($result,$i,"time");
  123.         $json.= "\n

    $_time $_name: $_message

    "    ;
  124.         ++$i;
  125.     }
  126.    
  127.     $date_=date("d/m/y");
  128.     $time_=date("His");
  129.     $ip_=$_SERVER['REMOTE_ADDR'];
  130.     $query ="INSERT INTO chat_users VALUES ('$ip_', '$date_', '$time_', '$name', '1') ";
  131.     $query.="ON DUPLICATE KEY UPDATE date='$date_',time='$time_'";
  132.     $result=mysql_query($query,$link);
  133. }
  134.  
  135.  
  136. if(!$post){$query="SELECTmax(id)FROMchat_history";$result=mysql_query($query,$link);$id=mysql_result($result,0,"max(id)");$users='';$_date=date("d/m/y");$_time=date("His")-14;$users="
      "
    ;$query="SELECTnameFROMchat_usersWHEREdate='$_date'ANDtime>$_time";$result=mysql_query($query,$link);$num=mysql_num_rows($result);$i=0;while($i<$num){$_user=mysql_result($result,$i,"name");$users.="\n.'"'.$_user.'"'.")'>$_user";++$i;}if(!$num){$users.="\n
  137. none
    138. ";}$users.="\n";$end_time=microtime(true)-$start_time;$total_time=number_format($end_time,4);$jsonObj=array('dowhat'=>$send,'chat'=>$json,'last_id'=>$id,'users'=>$users,'time'=>$total_time);$_SESSION['lastid']=$id;}else{$end_time=microtime(true)-$start_time;$total_time=number_format($end_time,4);$jsonObj=array ('dowhat'=>'1','time'=>$total_time);}mysql_close();echo json_encode($jsonObj);?>

PermaLink to this entry https://pastebin.co.uk/11525
Posted by rey Wed 7th Mar 2007 13:28 - Syntax is PHP - 17 viewsRun this post in the PHP shell
Download | New Post | Modify | Hide line numbers

 

Comments: 0