#
<?php
require "";
if ($b1) {
if (is_user_exits($fromname) and check_user_password($fromname,$password)) {
sendmsg();
echo "Success!<br><form method="POST"><input type="button" value=" Close window " name="B1" onclick="()"></form>";
}
else {
$founderr=1;
echo "Username/password error!";
}
}
else {
?>
<html>
<head>
<title>Send a message</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/">
</head>
<body bgcolor="#eeeeee">
<form method="post" action="<?php echo $php_self;?>">
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr align="center">
<a href="?name=<?php echo $name;?>" target="_blank"><?php echo $name;?></a>
Send a message</td>
</tr>
<tr>
<td align="right" width="27%">Your username:</td>
<td width="73%">
<input type="text" name="fromname" size="17" maxlength="16" value="<?php echo $jl_forum[name];?>">
* </td>
</tr>
<tr>
<td align="right" width="27%">Your password:</td>
<td width="73%">
<input type="password" name="password" size="17" maxlength="16">
* </td>
</tr>
<tr>
<td align="right" width="27%" valign="top">Content:</td>
<td width="73%">
<textarea name="cont" wrap="VIRTUAL" cols="40" rows="3"></textarea>
<input type="hidden" name="toname" value="<?php echo $name;?>">
<br>
<input type="submit" name="b1" value="send">
<input type="button" name="Submit" value="Cancel" onclick="()">
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
}
?>
###############
#
# This is an initializer, which is only executed for the first time after uploading, and must be deleted afterwards to avoid errors
#################
<?php
require "";
echo "<h1>Initialize the database</h1><br><br>";
echo "Create a database connection...ok!<br>";
echo "Create table boardinfo...";
$sql="CREATE TABLE boardinfo (name varchar(50) NOT NULL, chinesename varchar(50) NOT NULL)";
mysql_query($sql) or die("Error");
echo "ok!<br>";
echo "Create table user...";
$sql="CREATE TABLE user (id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL, sex varchar(6), realname varchar(20), password varchar(16) NOT NULL, address varchar(40), oicq varchar(10), homepage varchar(50), score int(11), phone varchar(20), email varchar(50), regtime varchar(20), qm text, slaveboard varchar(50), PRIMARY KEY (id))";
mysql_query($sql) or die("Error");
echo "ok!<br>";
echo "Create table message...";
$sql="create table message (id int(11) NOT NULL auto_increment, name varchar(50), fromname varchar(50), writetime varchar(20), cont longtext, PRIMARY KEY(id))";
mysql_query($sql) or die("Error");
echo "ok!<br>";
echo "Initialization layout "Personal Computer"...";
create_board_table('computer','Personal Computer');
echo "ok!<br><br>";
echo "<h2>set up!</h2>";
echo "<br><br>Cold crazy man (computer crazy man)";
?>
##
<html>
<head>
<title>User Information</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/">
</head>
<body bgcolor="#FFFFFF" background="image/">
<?php include "";
if (!isset($name)) {
?>
<form method="post" action="<?php echo $php_self;?>">
<table width="90%" border="1" cellspacing="0" cellpadding="1" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr align="center">
<td>Please enter the username you want to view</td>
</tr>
<tr align="center">
<td>
<input type="text" name="name" size="18" maxlength="16">
</td>
</tr>
<tr align="center">
<td>
<input type="submit" name="b1" value="View information">
</td>
</tr>
</table>
</form>
<?php
}
else {
require "";
if (is_user_exits($name)) {
$sql="select * from user where name='$name'";
$sql_result=mysql_query($sql);
$row=mysql_fetch_array($sql_result);
?>
<br>
<table width="90%" border="1" cellspacing="0" cellpadding="1" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr>
<td><b>Detailed information</b></td>
</tr>
<tr>
<td>Username: <?php echo $row[name];?></td>
</tr>
<tr>
<td>Real name: <?php echo $row[realname];?></td>
</tr>
<tr>
<td>Gender: <?php echo $row[sex];?></td>
</tr>
<tr>
<td>Address: <?php echo $row[address];?></td>
</tr>
<tr>
<td>Tel: <?php echo $row[phone];?></td>
</tr>
<tr>
<td>OICQ：<?php echo $row[oicq];?></td>
</tr>
<tr>
<td>Email：<a href="mailto:<?php echo $row[email];?>"><?php echo $row[email];?></a></td>
</tr>
<tr>
<a href="<?php echo $row[homepage];?>" target="_blank"><?php echo $row[homepage];?></a></td>
</tr>
<tr>
<td>Registering time: <?php echo $row[regtime];?></td>
</tr>
<tr>
<td>Current points: <?php echo $row[score];?></td>
</tr>
</table>
<br>
<?php
}
else {
echo "Please enter the correct and legal user name";
}
}
include "";?>
</body>
</html>
#
<?php
require "";
if (is_user_exits($jl_forum[name]) and check_user_password($jl_forum[name],$jl_forum[password])) {
if (isset($job)) {
if (is_this_user($id)) {
delmsg($id);
}
}
$name=$jl_forum[name];
$sql="select * from message where name='$name'";
$sql_result=mysql_query($sql);
$sum=mysql_num_rows($sql_result);
?>
<html>
<head>
<title>View Message</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/">
<script language="javascript">
function sendmsg(name){ ("?name="+name,"","height=200,width=500,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
}
</script>
</head>
<body bgcolor="#FFFFFF" background="image/">
<p>You currently have a total of <b><?php echo $sum;?></b> messages</p>
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<?php
while ($sql_row=mysql_fetch_array($sql_result)) {
?>
<tr bgcolor="#eeeeee">
<td><a href="javascript:sendmsg('<?php echo $sql_row[fromname];?>')"><?php echo $sql_row[fromname];?></a>
At <?php echo $sql_row[writetime];?> <a href="<?php echo "$php_self?job=del&id=$sql_row[id]";?>">delete</a></td>
</tr>
<tr>
<td><?php echo $sql_row[cont];?></td>
</tr>
<tr>
<td> </td>
</tr>
<?php
}
?>
</table>
<p> </p>
</body>
</html>
<?php
}
else {
show_error(4);
}
?>
<?php
require "";
if ($b1) {
if (is_user_exits($fromname) and check_user_password($fromname,$password)) {
sendmsg();
echo "Success!<br><form method="POST"><input type="button" value=" Close window " name="B1" onclick="()"></form>";
}
else {
$founderr=1;
echo "Username/password error!";
}
}
else {
?>
<html>
<head>
<title>Send a message</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/">
</head>
<body bgcolor="#eeeeee">
<form method="post" action="<?php echo $php_self;?>">
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr align="center">
<a href="?name=<?php echo $name;?>" target="_blank"><?php echo $name;?></a>
Send a message</td>
</tr>
<tr>
<td align="right" width="27%">Your username:</td>
<td width="73%">
<input type="text" name="fromname" size="17" maxlength="16" value="<?php echo $jl_forum[name];?>">
* </td>
</tr>
<tr>
<td align="right" width="27%">Your password:</td>
<td width="73%">
<input type="password" name="password" size="17" maxlength="16">
* </td>
</tr>
<tr>
<td align="right" width="27%" valign="top">Content:</td>
<td width="73%">
<textarea name="cont" wrap="VIRTUAL" cols="40" rows="3"></textarea>
<input type="hidden" name="toname" value="<?php echo $name;?>">
<br>
<input type="submit" name="b1" value="send">
<input type="button" name="Submit" value="Cancel" onclick="()">
</td>
</tr>
</table>
</form>
</body>
</html>
<?php
}
?>
###############
#
# This is an initializer, which is only executed for the first time after uploading, and must be deleted afterwards to avoid errors
#################
<?php
require "";
echo "<h1>Initialize the database</h1><br><br>";
echo "Create a database connection...ok!<br>";
echo "Create table boardinfo...";
$sql="CREATE TABLE boardinfo (name varchar(50) NOT NULL, chinesename varchar(50) NOT NULL)";
mysql_query($sql) or die("Error");
echo "ok!<br>";
echo "Create table user...";
$sql="CREATE TABLE user (id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL, sex varchar(6), realname varchar(20), password varchar(16) NOT NULL, address varchar(40), oicq varchar(10), homepage varchar(50), score int(11), phone varchar(20), email varchar(50), regtime varchar(20), qm text, slaveboard varchar(50), PRIMARY KEY (id))";
mysql_query($sql) or die("Error");
echo "ok!<br>";
echo "Create table message...";
$sql="create table message (id int(11) NOT NULL auto_increment, name varchar(50), fromname varchar(50), writetime varchar(20), cont longtext, PRIMARY KEY(id))";
mysql_query($sql) or die("Error");
echo "ok!<br>";
echo "Initialization layout "Personal Computer"...";
create_board_table('computer','Personal Computer');
echo "ok!<br><br>";
echo "<h2>set up!</h2>";
echo "<br><br>Cold crazy man (computer crazy man)";
?>
##
<html>
<head>
<title>User Information</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/">
</head>
<body bgcolor="#FFFFFF" background="image/">
<?php include "";
if (!isset($name)) {
?>
<form method="post" action="<?php echo $php_self;?>">
<table width="90%" border="1" cellspacing="0" cellpadding="1" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr align="center">
<td>Please enter the username you want to view</td>
</tr>
<tr align="center">
<td>
<input type="text" name="name" size="18" maxlength="16">
</td>
</tr>
<tr align="center">
<td>
<input type="submit" name="b1" value="View information">
</td>
</tr>
</table>
</form>
<?php
}
else {
require "";
if (is_user_exits($name)) {
$sql="select * from user where name='$name'";
$sql_result=mysql_query($sql);
$row=mysql_fetch_array($sql_result);
?>
<br>
<table width="90%" border="1" cellspacing="0" cellpadding="1" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<tr>
<td><b>Detailed information</b></td>
</tr>
<tr>
<td>Username: <?php echo $row[name];?></td>
</tr>
<tr>
<td>Real name: <?php echo $row[realname];?></td>
</tr>
<tr>
<td>Gender: <?php echo $row[sex];?></td>
</tr>
<tr>
<td>Address: <?php echo $row[address];?></td>
</tr>
<tr>
<td>Tel: <?php echo $row[phone];?></td>
</tr>
<tr>
<td>OICQ：<?php echo $row[oicq];?></td>
</tr>
<tr>
<td>Email：<a href="mailto:<?php echo $row[email];?>"><?php echo $row[email];?></a></td>
</tr>
<tr>
<a href="<?php echo $row[homepage];?>" target="_blank"><?php echo $row[homepage];?></a></td>
</tr>
<tr>
<td>Registering time: <?php echo $row[regtime];?></td>
</tr>
<tr>
<td>Current points: <?php echo $row[score];?></td>
</tr>
</table>
<br>
<?php
}
else {
echo "Please enter the correct and legal user name";
}
}
include "";?>
</body>
</html>
#
<?php
require "";
if (is_user_exits($jl_forum[name]) and check_user_password($jl_forum[name],$jl_forum[password])) {
if (isset($job)) {
if (is_this_user($id)) {
delmsg($id);
}
}
$name=$jl_forum[name];
$sql="select * from message where name='$name'";
$sql_result=mysql_query($sql);
$sum=mysql_num_rows($sql_result);
?>
<html>
<head>
<title>View Message</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css/">
<script language="javascript">
function sendmsg(name){ ("?name="+name,"","height=200,width=500,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");
}
</script>
</head>
<body bgcolor="#FFFFFF" background="image/">
<p>You currently have a total of <b><?php echo $sum;?></b> messages</p>
<table width="98%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF">
<?php
while ($sql_row=mysql_fetch_array($sql_result)) {
?>
<tr bgcolor="#eeeeee">
<td><a href="javascript:sendmsg('<?php echo $sql_row[fromname];?>')"><?php echo $sql_row[fromname];?></a>
At <?php echo $sql_row[writetime];?> <a href="<?php echo "$php_self?job=del&id=$sql_row[id]";?>">delete</a></td>
</tr>
<tr>
<td><?php echo $sql_row[cont];?></td>
</tr>
<tr>
<td> </td>
</tr>
<?php
}
?>
</table>
<p> </p>
</body>
</html>
<?php
}
else {
show_error(4);
}
?>