web-touristPHP Чат система
Автор: Break4y
Това е една чат система която написах преди няколко дни.
config.php
<?php
DEFINE ('DB_USER', 'db user'); // Insert your database username into the quotes.
DEFINE ('DB_PASSWORD', 'db pass'); // Insert your database password into the quotes.
DEFINE ('DB_HOST', 'db host'); // This will most likely stay the same.
DEFINE ('DB_NAME', 'db name'); //Insert your actual database name in the quotes.
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('Could not connect to MySQL: ' . mysql_error());
@mysql_select_db (DB_NAME) OR die('Could not select the database: ' . mysql_error() );
?>adminlogin.php
<?php session_start();
include('pro1.php');
$username = $_POST['username'];
$password = $_POST['password'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>Pr0nto login Admin Panel</title>
<style type="text/css">
<!--
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #000000;
}
a:link {
color: #FF0000;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #FF0000;
}
a:hover {
text-decoration: underline;
color: #FF6600;
}
a:active {
text-decoration: none;
color: #FF6600;
}
a {
font-size: 10px;
}
-->
</style></head>
<body>
<table width="400" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999">
<tr>
<td><table width="400" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"></div></td>
</tr>
<br>
<center>Административен панел</center>
<br>
<tr>
<td height="145">
<?php if($_POST['submit']){
if($username == $username2 && $password == $password2) {
session_register("username");
$_SESSION['username'] = $username;
echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=edit.php\">";
}
} ?>
<form name="form1" method="post" action="">
Username:<br>
<input name="username" type="text" id="username">
<br>
Password: <br>
<input name="password" type="password" id="password">
<br>
<br>
<input name="submit" type="submit" id="submit" value="Login!">
<br>
<br>
</form></td>
</tr>
<tr>
<td><div align="center">Powered by Pr0nto</div></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>allmessages.php
<html>
<head>
<title>Chatbox by break4y</title>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1251">
<link rel='stylesheet' href='style.css' type='text/css' media='all' />
</head>
<body>
<table border="1" width="150" height="1">
<tr><td>
<form action="" method="post">
Nick:
<br><input type="text" name="nick" />
<br />
Съобщение:
<br><input type="text" name="message">
<br />
<input type="submit" name="submit" value="Добави!" />
</form>
<?php
if (isset($_POST["submit"])) {
include('config.php');
if (!empty($_POST["nick"])) $nick = htmlspecialchars($_POST["nick"]);
else $errMsg = "Моля въведете линк!<br />";
if (!empty($_POST["message"])) $message = htmlspecialchars($_POST["message"]);
else $errMsg = "Моля въведете съобщение!<br />";
if (empty($errMsg)) {
$insert = mysql_query("INSERT INTO chatbox(nick, message) VALUES('$nick', '$message')")or die(mysql_error());
echo 'Съобщението е добавено!';
} else echo $errMsg;
mysql_close();
}
?>
<?php
include('config.php');
$select = mysql_query("SELECT * FROM chatbox ")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$nick = mysql_result($select, $i, "nick");
$message = mysql_result($select, $i, "message");
echo '<b>' . $nick . ':</b> ' . $message . ' <a href="edit.php">[X]</a><hr>';
}
mysql_close();
?>
</td></tr>
</body>
</html>delete.php
<?php
session_start();
if(!$_SESSION['username']){
echo "Моля влезте като АДМИН от <a href='adminlogin.php'>ТУК</a>!";
exit;
}
?>
<html>
<head>
<title>Chatbox by break4y</title>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1251">
</head>
<body>
<?PHP
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$connection = mysql_connect($dbhost, $dbuser, $dbpass) or die("Сайтът не може да се свърже към базата данни1");
$db = mysql_select_db($dbname,$connection)or die("Сайтът не може да се свърже към базата данни2");
$id = $_GET['id'];
if(!$id){echo"Изберете съобщението който искате да изтриете!";}else{
$result = mysql_query("DELETE FROM friends WHERE id='$id' ",$connection);
echo "Успешно изтрито съобщение!<br><a href='index.php'>< Върни се към чата </a>";}
?>
</body></html>edit.php
<?php
//настройки за база данни
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());
$select = mysql_query("SELECT * FROM chatbox ORDER BY id DESC")or die(mysql_error());
if (mysql_num_rows($select))
{
while($red = mysql_fetch_array($select))
{
?>
<b><?php echo $red['nick'];?>:</b> <?php echo $red['message'];?> - <a href="delete.php?id=<?php echo $red['id']; ?>">Изтрий</a><br>
<?php
}
}
mysql_close();
?>index.php
<html>
<head>
<title>Chatbox by break4y</title>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1251">
<link rel='stylesheet' href='style.css' type='text/css' media='all' />
</head>
<body>
<form action="" method="post">
Nick:
<br><input type="text" name="nick" />
<br />
Съобщение:
<br><input type="text" name="message">
<br />
<input type="submit" name="submit" value="Добави!" />
</form>
<?php
if (isset($_POST["submit"])) {
include('config.php');
if (!empty($_POST["nick"])) $nick = htmlspecialchars($_POST["nick"]);
else $errMsg = "Моля въведете линк!<br />";
if (!empty($_POST["message"])) $message = htmlspecialchars($_POST["message"]);
else $errMsg = "Моля въведете съобщение!<br />";
if (empty($errMsg)) {
$insert = mysql_query("INSERT INTO chatbox(nick, message) VALUES('$nick', '$message')")or die(mysql_error());
echo 'Съобщението е добавено!';
} else echo $errMsg;
mysql_close();
}
?>
<?php
include('config.php');
$query="SELECT id,nick,message FROM chatbox ORDER BY id DESC limit 10";
$result=mysql_query($query);
echo '<table border="1" width="150" height="1">';
while ($row=@mysql_fetch_row($result)) {
if (strlen($row['1'])>49)
{$points='...';}
else
{$points='';}
$row['1'] = substr($row['1'],0,49);
$row['1']=substr($row['1'],0 , 49);
echo"<tr><td><b>$row[1]$points:</b> $row[2] <hr></td></tr>";
}
echo "</table>";
?>
<a href="allmessages.php">Всички съобщения</a>
</body>
</html>pro1.php
<?php
$username2 = "admin"; // Your Username
$password2 = "admin"; // Your Password
?>
chatbox.sql
CREATE TABLE `chatbox` (
`id` INT(8) NOT NULL auto_increment,
`nick` VARCHAR(255) NOT NULL,
`message` VARCHAR(255) NOT NULL,
PRIMARY KEY(`id`)
);style.css
/* Chatbox by break4y CSS */
/* Links */
a:link {color:black; text-decoration:none}
a:visited {color:black; text-decoration:none}
a:active {color:black; text-decoration:none}
a:hover {color:#EFEFEF; text-decoration:inherit}
body {
/* site and form */
background-image: url(images/bgbg.jpg);
}
body,td,th {
/* Schriftart,GrцЯe u.s.w */
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 9px;
}
TEXTAREA, INPUT, OPTION, SELECT {
/* Form-Attribute */
background-image:url(images/lgn_bg.jpg);
color: #000000;
font-family: Verdana;
font-size: 7pt;
border: 1px solid #000000;
}
/* chat */
#news {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 9px;
color:#CCCCCC;
}
table{
border:0px;
border-spacing:0px;
}
td{
border:5px;}
.news-tab {color: #182030;}
#chatbox{table-layout:fixed;}картинките са 2 може даги свалите от
