Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
<?php
include 'conf.php';
$id = (int)$_GET['id'];
$sql = mysql_query('SELECT * FROM users WHERE id='.$id.'');
$row = mysql_fetch_assoc($sql);
?>
<center>
<form method="POST" action="index.php?m=users&ext=edit&id=<?php echo $id; ?>" />
<font color="White">Пол:</font> <br />
<select name="pol">
<option value='МОМЧЕ'>Момче</option><option value='МОМИЧЕ'>Момиче</option>
</select><br />
<font color="White">Скайп:</font> <br />
<input type="text" name="skype" value="<?php echo $row['skype']; ?>"/><br />
<font color="White">Клан:</font> <br />
<input type="text" name="clan" value="<?php echo $row['clan']; ?>"/><br />
Аватар URL: <br />
<input type="text" name="avatar" value="<?php echo $row['avatar']; ?>"/><br />
<font color="White">Представяне:</font> <br />
<textarea name="desc"><?php echo $row['desc']; ?></textarea><br />
<input type="submit" name="submit" value="Редактирай"><br />
</form>
<?php
if(isset($_POST['submit']))
{
$pol = $_POST['pol'];
$skype = trim($_POST['skype']);
$desc = trim(nl2br($_POST['desc']));
$klan = trim($_POST['clan']);
$avatar = trim($_POST['avatar']);
if(strlen($pol)<4)
{
echo '<font color="White">Моля изберете пол!</font>';
}
if(strlen($skype)<4)
{
echo '<font color="White">Скайпа е по кратък от 4 символа!</font>';
}
if(strlen($desc)<4)
{
echo '<font color="White">Представянето е по кратко от 4 символа!</font>';
}
if(strlen($klan)<4)
{
echo '<font color="White">Кланът е по клатък от 4 символа!</font>';
}
else
{
mysql_query('UPDATE users SET pol="'.addslashes($pol).'", skype="'.addslashes($skype).'",
`desc`="'.addslashes($desc).'", clan="'.addslashes($klan).'", avatar="'.addslashes($avatar).'" WHERE id='.$id.'');
echo mysql_error();
$vreme = "3";
$url = 'index.php?m=users&ext=profile&id='.$_SESSION['user_info']['id'].'';
echo "<meta http-equiv='refresh' content='$vreme;URL=$url'>";
echo '<center><font color="White">Успешна редакция пренасочване към профила след '.$vreme.' секунди</font>';
}
}
?>
</center>
<center>
<?php
$id = (int)$_GET['id'];
include 'conf.php';
$sql = mysql_query('SELECT * FROM users WHERE id='.$id.'');
$row = mysql_fetch_assoc($sql);
?>
Вие разглеждате профила на: <b><?php echo $row['user']; ?></b>
<br />
<br />
<img src="<?php echo $row['avatar']; ?>"><br /><br />
Той е: <b><?php echo $row['pol']; ?></b><br />
Скайп: <b><?php echo $row['skype']; ?></b><br />
Клан: <b><?php echo $row['clan']; ?></b><br />
<?php
if($row['type']=="admin")
{
echo 'Ранг: <b>Администратор</b><br />';
}
if($row['type']=="moderator")
{
echo 'Ранг: <b>Модератор:</b><br />';
}
if($row['type']=="vip")
{
echo 'Ранг: <b>Вип потребител:</b>';
}
if($row['type']=="user")
{
echo 'Ранг: <b>Потребител</b>';
}
?>
<hr color="#ccc" size="1">
<?php echo $row['desc']; ?>
<br />
</center>
<center>
<form method="POST" action="" />
<font color="White">Потребител:</font> <br />
<input type="text" name="user" /><br />
<font color="White">Парола:</font> <br />
<input type="password" name="pass" /><br />
<font color="White">Повтори парола:</font> <br />
<input type="password" name="pass2" /><br />
<font color="White">Пол:</font> <br />
<select name="pol">
<option value='МОМЧЕ'>Момче</option><option value='МОМИЧЕ'>Момиче</option>
</select><br />
<font color="White">Скайп:</font> <br />
<input type="text" name="skype" /><br />
<font color="White">Клан:</font> <br />
<input type="text" name="clan" /><br />
<font color="White">Представяне:</font> <br />
<textarea name="desc"></textarea><br />
<input type="submit" name="submit" value="Регистрация"><br />
</form>
<?php
mysql_connect('localhost', 'no-servers.info', 'bobi97');
mysql_select_db('no_servers_info_ns');
if(isset($_POST['submit']))
{
$user = trim($_POST['user']);
$pass = trim($_POST['pass']);
$pass2 = trim($_POST['pass2']);
$pol = $_POST['pol'];
$skype = trim($_POST['skype']);
$desc = trim(nl2br($_POST['desc']));
$klan = trim($_POST['clan']);
if($pass != $pass2)
{
echo '<font color="White">Паролите не съвпадат!</font>';
}
if(strlen($user)<4)
{
echo '<font color="White">Потребителското име е по кратко от 4 символа!</font>';
}
if(strlen($pol)<4)
{
echo '<font color="White">Моля изберете пол!</font>';
}
if(strlen($skype)<4)
{
echo '<font color="White">Скайпа е по кратък от 4 символа!</font>';
}
if(strlen($desc)<4)
{
echo '<font color="White">Представянето е по кратко от 4 символа!</font>';
}
if(strlen($klan)<4)
{
echo '<font color="White">Кланът е по клатък от 4 символа!</font>';
}
else
{
mysql_query('INSERT INTO users (`user`,`pass`,`pol`,`skype`,`desc`, `clan`) VALUES ("'.addslashes($user).'",
"'.md5($pass).'", "'.addslashes($pol).'", "'.addslashes($skype).'", "'.addslashes($desc).'", "'.addslashes($klan).'")');
$vreme = "3";
$url = "index.php";
echo "<meta http-equiv='refresh' content='$vreme;URL=$url'>";
echo '<center><font color="White">Успешна регистрация пренасочване към '.$url.' след '.$vreme.'</font>';
}
}
?>
</center>
<?php
include("constants.php");
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Login Script</title>
</head>
<body>
<div id="main" class="container_12">
<h1>User Message System</h1>
<form method="post" action="mail.php">
<input type="submit" name="mailAction" value="Compose" /><input type="submit" name="mailAction" value="Inbox" />
</form>
<?php
if(!empty($_POST['mailAction']) && isset($_POST['mailAction'])){
$action = $_POST['mailAction'];
} else {
$action = 'Inbox';
}
if(($action == 'Compose') || ($action == 'Reply')) {
if(isset($_POST['mailSubject']) && !empty($_POST['mailSubject'])){
$mailSubject = 'Re: '.$_POST['mailSubject'];
} else {
$mailSubject = "";
}
if(isset($_POST['mailFrom']) && !empty($_POST['mailFrom'])){
$mailTo = $_POST['mailFrom'];
} else {
$mailTo = "";
}
?>
<form action="mail.php" method='post'>
<div id="compose">
<p class="textinput">To:</p><p class="grid_2"><input type='text' name='mailTo' size='20' value='<?php echo $mailTo; ?>'></p>
<div class="clear"></div>
<p class="textinput">Subject:</p><p class="grid_2"><input type='text' name='mailSubject' size='20' value='<?php echo $mailSubject; ?>'></p>
<div class="clear"></div>
<p class="textinput">Message:</p><p class="grid_4"><textarea rows='16' cols='45' name='mailMessage'></textarea></p>
<div class="clear"></div>
<p class="grid_1"><input type="submit" name="mailAction" value="Send" /></p>
</div>
</form>
<?php
}
if($action == 'Send') {
if(empty($_POST['mailSubject']) || !isset($_POST['mailSubject'])){
echo "Subject Blank";
} else {
$subject = $_POST['mailSubject'];
}
if(empty($_POST['mailTo']) || !isset($_POST['mailTo'])){
echo "To Blank";
} else {
$mailTo = $_POST['mailTo'];
}
if(empty($_POST['mailMessage']) || !isset($_POST['mailMessage'])){
echo "Message Blank";
} else {
$message = $_POST['mailMessage'];
}
$date = date('m/d/Y')." at ".date('g:i.s')." ".date('a');
$q = "INSERT INTO mail (UserTo, UserFrom, Subject, Message, SentDate, status)
VALUES ('$mailTo','$session->username','$subject','$message','$date','unread')";
if(!($send = $database->query($q))){
echo "A letter could not be sent to ".$mailTo."!";
} else {
echo "Message Sent to ".$mailTo."!";
}
}
if($action == "Inbox") {
$user = $session->username;
$q = "SELECT * FROM mail WHERE UserTo = '$user' ORDER BY SentDate DESC";
$getMail = $database->query($q) or die(mysql_error());
echo "<div id='inbox'>";
if(mysql_num_rows($getMail) == 0){
echo "<p>you have no mail</p><br /><br />";
} else {
?>
<table>
<tr class="title">
<td colspan="2" align="center">Action</td>
<td>Status</td>
<td>From</td>
<td>Subject</td>
<td>Time</td>
</tr>
</div>
<?php
echo "<form action='mail.php' method='post'>";
while($mail = mysql_fetch_array($getMail)){
?>
<tr>
<input type="hidden" name="mail_id" value="<?php echo $mail['mail_id']; ?>" />
<td align="center"><input type="submit" name="mailAction" value='View' /></td>
<td align="center"><input type="submit" name="mailAction" value="Delete" /></td>
<td><?php echo $mail['status']; ?></td>
<td><?php echo $mail['UserFrom']; ?></td>
<td><?php echo $mail['Subject']; ?></td>
<td><?php echo $mail['SentDate']; ?></td>
</tr>
<?php
}
echo "</form>";
}
echo "</table>";
}
if($action == "View") {
$mail_id = $_POST['mail_id'];
$user = $session->username;
$result = $database->query("SELECT * FROM mail WHERE UserTo = '$user' AND mail_id = '$mail_id'") or die ("cant do it");
$row = mysql_fetch_array($result);
if($row['UserTo'] != $session->username) {
echo "<font face=verdana><b>This isn't your mail!";
exit;
}
$q = "UPDATE mail SET status='read' WHERE UserTo='$session->username' AND mail_id='$row[mail_id]'";
$database->query($q) or die("An error occurred resulting that this message has not been marked read.");
?>
<form method="post" action="mail.php">
<div id="single">
<p class="grid_1">From: </p><p class="grid_2"><?php echo $row['UserFrom']; ?><input type="hidden" name="mailFrom" value="<?php echo $row['UserFrom']; ?>" /></p>
<p class="grid_1 clear">Subject: </p><p class="grid_2"><?php echo $row['Subject']; ?><input type="hidden" name="mailSubject" value="<?php echo$row['Subject']; ?>" /></p>
<p class="grid_4 clear">body: <br /><?php echo $row['Message']; ?><br /></p>
<p class="grid_4 clear" align="right"><input type="submit" name="mailAction" value="Reply" /></p>
</div>
</form>
<?php
}
if($action == 'Delete') {
$id = $_POST['mail_id'];
$query = $database->query("DELETE FROM mail WHERE mail_id='$id' LIMIT 1");
if(!$query) {
echo "The message wasn\'t deleted";
} else {
header("Location: mail.php");
}
}
echo "<div class='clear'>";
?>
</div>
CREATE TABLE IF NOT EXISTS `mail` (
`UserTo` tinytext NOT NULL,
`UserFrom` tinytext NOT NULL,
`Subject` mediumtext NOT NULL,
`Message` longtext NOT NULL,
`status` text NOT NULL,
`SentDate` text NOT NULL,
`mail_id` int(80) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;