File: /home/asjudine/www/chatasjudinet/script.php
<?php
// Archivo para enviar los mensajes nuevos a la
// capa de mensajes
include 'configuracion.php';
include 'conexion.php';
$ahora = time();
$usuario = '';
$borra = "SELECT * FROM c_usuarios WHERE time < ".($ahora-segundos*10);
$borra = mysql_query($borra,$db);
if(@ mysql_num_rows($borra))while ($borrado=mysql_fetch_array($borra)){
$sql = "INSERT INTO c_mensajes (de,texto,time,color,para) VALUES ('','/logout ".$borrado['nombre']." conexion rota',".time().",'#000000','*')";
echo "<script>prompt('k','$sql')</script>";
mysql_query($sql,$db);
}
$sql = "DELETE FROM c_usuarios WHERE time < ".($ahora-segundos*10);
mysql_query($sql,$db);
$sql = "DELETE FROM c_mensajes WHERE time < ".($ahora-segundos*10);
mysql_query($sql,$db);
if(isset($_COOKIE["ident"])){
$sql = "SELECT nombre FROM c_usuarios WHERE cookie = ".$_COOKIE["ident"];
$result = mysql_query($sql,$db);
if(mysql_num_rows($result))$usuario = mysql_result($result,0);
if($usuario == ''){
setcookie ("ident","");
} else {
$sql = "UPDATE c_usuarios SET time = $ahora WHERE nombre = '$usuario'";
mysql_query($sql, $db);
}
}
?><html>
<head>
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
<script languaje="javascript"><!--
<?php
if(!isset($_GET['t'])){
$_GET['t'] = time();
};
if(!isset($_GET['l']))$sql="SELECT * FROM c_mensajes WHERE time > ".$_GET['t']." AND ( para = '*' OR para = '$usuario' ) ORDER BY id";
else {
$last = $_GET['l'];
$sql="SELECT * FROM c_mensajes WHERE id > ".$_GET['l']." AND ( para = '*' OR para = '$usuario') ORDER BY id";
}
$result=mysql_query($sql, $db);
$haymensaje = 0;
if( mysql_num_rows($result))while($row=mysql_fetch_array($result)){
if(substr($row['texto'],0,1) == '/'){
$comandos = split(' ',substr($row['texto'],1,strlen($row['texto'])));
}
if($row['id']){
$last = $row['id'];
$haymensaje = 1;
}
if(!isset($comandos)){
$row['texto'] = addslashes ( $row['texto'] );
$row['texto'] = str_replace (':)','<img src="images/smilies/smile.gif" align="middle">',$row['texto']);
$row['texto'] = str_replace (':(','<img src="images/smilies/triste.gif" align="middle">',$row['texto']);
$row['texto'] = str_replace (':O','<img src="images/smilies/sorpresa.gif" align="middle">',$row['texto']);
$row['texto'] = str_replace (':P','<img src="images/smilies/lengua.gif" align="middle">',$row['texto']);
$row['texto'] = str_replace (':\\\'(','<img src="images/smilies/llora.gif" align="middle">',$row['texto']);
$row['texto'] = str_replace (':D','<img src="images/smilies/risa.gif" align="middle">',$row['texto']);
if($row['para'] != $usuario)echo " parent.ms('".$row['de']."','".$row['color']."','".$row['texto']."');\n";
else echo " parent.mp('".$row['de']."','".$row['color']."','".$row['texto']."');\n";
}
else {
switch ($comandos[0]){
case 'logout':
$texto = '';
for($i=2;$i<count($comandos);$i++)$texto .= $comandos[$i].' ';
echo " parent.am('".$comandos[1]." acaba de abandonar el chat ( $texto)');\n";
echo " u = new Array(";
$sql="SELECT * FROM c_usuarios ORDER BY nombre";
$result=mysql_query($sql,$db);
$temp = 0;
if(mysql_num_rows($result))while ($row=mysql_fetch_array($result)){
if($temp++)echo ",";
echo "'".$row['nombre']."'";
}
echo ");\n";
echo " parent.ul(u);\n";
break;
case 'login':
if($comandos[1] != $usuario)echo " parent.am('".$comandos[1]." acaba de entrar en el chat');\n";
echo " u = new Array(";
$sql="SELECT * FROM c_usuarios ORDER BY nombre";
$result=mysql_query($sql,$db);
$temp = 0;
if(mysql_num_rows($result))while ($row=mysql_fetch_array($result)){
if($temp++)echo ",";
echo "'".$row['nombre']."'";
}
echo ");\n";
echo " parent.ul(u);\n";
break;
}
}
}
if($haymensaje)echo " window.focus();\n";
echo " window.setTimeout(\"document.location='script.php?t=";
echo $ahora;
if(isset($last))echo '&l='.$last;
echo '\'",'.segundos."000);\n";
?>
--></script>
</head>
</html>