AjaxChat w plikach ZeusXP

[radzioneqq]

Jak Dodać do AjaxChatu Zeusa że jak jest wiadomość to oprócz godziny pisze jaki kto ma lvl?

[ZeuSXP]

Zmień wszystko w pliku ajax_chat.php na to:
 

<?php
		ini_set("default_charset", 'utf-8');

		ini_set('display_errors', '0'); 
		
		
		include("connect.php");

		
		$uid = 0;
		$uid = (int)$_COOKIE['uid'];
		$sql= $db->prepare ( "SELECT * FROM user_data WHERE user_id= :id LIMIT 1" );
		$sql->bindParam ( ':id', $uid );
		$sql->execute ();
		$arr = $sql->fetchAll();
		$arr = $arr[0];
		$sql->closeCursor();

		if(isset($_POST["message"])) 
			{
								if(isset($uid) AND $uid > 0)
								{
				
										if($arr['enabled'] == "yes")
											{

														 $message = addslashes($_POST["message"]);
															
															  if($message != "") 
																{
																	
																	$username = "";
																	
																	if($arr['usysclass'] == 3)
																	{
																		$username = "<font color='red' >".$arr['user_name']."</font>";
																	}
																	else if($arr['usysclass'] == 2)
																	{
																		$username = "<font color='gold' >".$arr['user_name']."</font>";
																	}
																	else
																	{
																		$username = $arr['user_name'];
																	}
																		
																		$sql = $db->prepare("INSERT INTO ajaxchat (`id`, `user`, `message`, `time`, `user_id`) VALUES (NULL, :name, :message, :time, :id)");
																		$sql->bindValue(':name', $username, PDO::PARAM_STR);
																		$sql->bindValue(':message', $message, PDO::PARAM_STR);
																		$sql->bindValue(':time', time(), PDO::PARAM_INT);
																		$sql->bindValue(':id', $uid, PDO::PARAM_INT);
																		$sql->execute();
																		$sql->closeCursor();
																}
											
											}
										else
										{
											echo"<script type='text/javascript' >alert('Twoje konto zostało zablokowane.'); </script>";
										}
									}
									else
									{
										echo"<script type='text/javascript' >alert('Zaloguj się by pisać na czacie.'); </script>";
									}
					
								}
								
			
						$sql = $db->query("SELECT * FROM ajaxchat ORDER BY time DESC");
						$out ="";
						
						while($czat = $sql->fetch())
						{
							
								$qry = $db->query("SELECT `lvl` FROM `user_data` WEHRE `user_id` = ".$czat['user_Id']."");
								$lvl = $qry->fetch();
								
									$wiadomosci = 
									"<div>
										<div style=\"float:left;color:white;padding-right:10px;\">[".strftime("%H:%M", $czat["time"])."]</div>
										<div style='float:left;padding-right:10px;' >[". $lvl['lvl'] ."] ".$czat['user']."</div>
										<div><b>".$czat["message"]."</b></div>
									</div>";
										
								 $out.= $wiadomosci;
                        }
						$sql->closeCursor();
                        print($out);
				  
?>

[radzioneqq]

wgrałem i chat nie działa

[ZeuSXP]

Ten będzie działał:

 

<?php
/*
ZZZZZZZZZZZZZZ        EEEEEEEEEEEEEE       	UUU				UUU       		SSSSSSS            	XXX					XXX       	PPPPPPPPP
			ZZZZZZZZ		EEEEE							UUU				UUU		  SSSS		  SSSSS				XXX			XXX				PPP			PPP
					ZZZZ		EEEEE							UUU				UUU		SSS										XXX	XXX					PPP				PPP
				ZZZZ			EEEEEEEEEEEEEE        		UUU				UUU		SSS											XXX						PPP				PPP
			ZZZZ				EEEEEEEEEEEEEE				UUU				UUU			SSSSSS								XXX	XXX					PPP			PPP
		ZZZZ					EEEEE                          	UUU				UUU					SSSSS					XXX			XXX				PPPPPPPPP
	ZZZZ						EEEEE							UUU				UUU							SSS			XXX					XXX			PPP
ZZZZZZZZ					EEEEE								UUU		UUU							SSSSSS		XXX							XXX		PPP
ZZZZZZZZZZZZZZ		EEEEEEEEEEEEEE						UUUUU					SSSSSSSSSSS			XX								XX	PPP
*/
		
		ini_set("default_charset", 'utf-8');

		ini_set('display_errors', '0'); 
		
		
		include("connect.php");

		
		$uid = 0;
		$uid = (int)$_COOKIE['uid'];
		$sql= $db->prepare ( "SELECT * FROM user_data WHERE user_id= :id LIMIT 1" );
		$sql->bindParam ( ':id', $uid );
		$sql->execute ();
		$arr = $sql->fetchAll();
		$arr = $arr[0];
		$sql->closeCursor();

		if(isset($_POST["message"])) 
			{
								if(isset($uid) AND $uid > 0)
								{
				
										if($arr['enabled'] == "yes")
											{

														 $message = addslashes($_POST["message"]);
															
															  if($message != "") 
																{
																	
																	$username = "";
																	
																	if($arr['usysclass'] == 3)
																	{
																		$username = "<font color='red' >".$arr['user_name']."</font>";
																	}
																	else if($arr['usysclass'] == 2)
																	{
																		$username = "<font color='gold' >".$arr['user_name']."</font>";
																	}
																	else
																	{
																		$username = $arr['user_name'];
																	}
																		
																		$sql = $db->prepare("INSERT INTO ajaxchat (`id`, `user`, `message`, `time`, `user_id`) VALUES (NULL, :name, :message, :time, :id)");
																		$sql->bindValue(':name', $username, PDO::PARAM_STR);
																		$sql->bindValue(':message', $message, PDO::PARAM_STR);
																		$sql->bindValue(':time', time(), PDO::PARAM_INT);
																		$sql->bindValue(':id', $uid, PDO::PARAM_INT);
																		$sql->execute();
																		$sql->closeCursor();
																}
											
											}
										else
										{
											echo"<script type='text/javascript' >alert('Twoje konto zostało zablokowane.'); </script>";
										}
									}
									else
									{
										echo"<script type='text/javascript' >alert('Zaloguj się by pisać na czacie.'); </script>";
									}
					
								}
								
			
						$sql = $db->query("SELECT * FROM ajaxchat ORDER BY time DESC");
						$out ="";
						
						while($czat = $sql->fetch())
						{
							$qry = $db->query("SELECT lvl FROM `user_data` WHERE `user_id` = ".$czat['user_id']."");
							$qry = $qry->fetch();
							
									$wiadomosci = 
									"<div>
										<div style=\"float:left;color:white;padding-right:10px;\">[".strftime("%H:%M", $czat["time"])."]</div>
										<div style='float:left;padding-right:10px;' >[".$qry['lvl']."] " . $czat['user']."</div>
										<div><b>".$czat["message"]."</b></div>
									</div>";
										
								 $out.= $wiadomosci;
                        }
						$sql->closeCursor();
                        print($out);
				  
?>

[radzioneqq]

dzieki

[radzioneqq]

a wiesz może jak zrobić żeby można było pisać od określonego lvla np.50?