ProFTP писал(а):ящеги он не создает автоматом после того как данные будут в таблице?
или руками надо?
Создаёт , у меня все юзеры вида
belfigor@stopxaker.ru
Код: Выделить всё
Aktion ID Domain User
DEL / CHG 42 stopxaker.ru 666
DEL / CHG 25 stopxaker.ru ali
DEL / CHG 24 stopxaker.ru anet
DEL / CHG 17 stopxaker.ru AnyKey
DEL / CHG 1 stopxaker.ru belfigor
Я конечно не кодер , но я его по ламерски отредактиовал , что у меня теперь юзеры сами регинятся в локалке
вот скрипт, сильно не пинайте
_________________________________________________________________________________________________________
Код: Выделить всё
<style type="text/css">
<!--
.стиль2 {color: #00FF00}
body,td,th {
font-family: Times New Roman, Times, serif;
font-size: 24px;
color: #000066;
}
body {
background-color: #00FF99;
background-image: url();
}
a {
font-size: 24px;
font-family: Times New Roman, Times, serif;
}
a:link {
color: #000066;
}
a:visited {
color: #996633;
}
a:hover {
color: #0066CC;
}
.стиль6 {color: #004000}
.стиль7 {color: #800000}
-->
</style>
<h2><a href="index.php"><img src="logo.gif" width="340" height="86" border="0" /></a><a href="http://10.159.42.58" target="_top"></a><strong><cite>Регистрация почты на Stopxaker.ru</cite></strong></h2>
<p class="стиль2"><a href="http://10.159.42.58/index.php?module=News&do=View&id=57"><font face="Times New Roman, Times, serif"> (Начать пользоваться почтой </font></a></p>
<p class="стиль2"><a href="http://10.159.42.58/userreg.php">Вернуться назад</a></p>
<p class="стиль2">
<a href="http://10.159.42.58/forum/">Forum</a>
<a href="http://10.159.42.58/">Stop }{aKeR</a>
<span class="стиль7">
<?PHP
/* #### +NFOs+ ####
Postfix-Mail-Account Management Script (with MySQL+PHP)
Coder: R.T. @ preisroboter.de (tiebel@preisroboter.de)
Codestyle: Quick & Dirty (but still works fine ;)
"Copyrights": GNU / GPL
Just change the VARs to yout environment (DB) and
restrict the access on this file with e.g. htaccess
DOWNLOAD: http://ronnytiebel.de/download.php?id=5
#### -NFOs- #### */
/* #### +Var-Setup+ #### */
define('db_server','localhost');
define('db_name','mailserver');
define('db_user','mailuser');
define('db_pwd','mailuser2006');
$tbl[1] = "virtual_aliases";
$tbl[2] = "virtual_domains";
$tbl[3] = "virtual_users";
/* #### -Var-Setup- #### */
/* #### +Functions+ #### */
function query($sql)
{
global $cid;
if($sql) return mysql_query($sql,$cid);
//else die(mysql_error());
}
function fetch($res)
{
if($res) return mysql_fetch_array($res);
else return false;
}
function connect()
{
global $cid,$db;
$cid = mysql_connect(db_server,db_user,db_pwd);
If($cid) $db = mysql_select_db(db_name,$cid);
else die(mysql_error());
}
function disconnect()
{
global $cid;
if(!(mysql_close($cid))) die("Fehler beim trennen der Verbindung!");
}
/* #### -Functions- #### */
/* #### +Initialize+ #### */
connect();
$do = $_REQUEST['do'];
$id = $_REQUEST['id'];
$new = $_REQUEST['new'];
$del = $_REQUEST['del'];
$chg = $_REQUEST['chg'];
$ack = $_REQUEST['ack'];
$domain = $_REQUEST['domain'];
$source = $_REQUEST['src'];
$usr = $_REQUEST['usr'];
$pwd = $_REQUEST['pwd'];
$dest = $_REQUEST['dest'];
$ndomain = $_REQUEST['new_domain'];
$sql[1] = "SELECT virtual_aliases.id, virtual_domains.name, virtual_aliases.source, virtual_aliases.destination FROM virtual_aliases, virtual_domains WHERE virtual_aliases.domain_id = virtual_domains.id;";
$sql[2] = "SELECT * FROM virtual_domains;";
$sql[3] = "SELECT virtual_users.id, virtual_domains.name, virtual_users.user FROM virtual_users, virtual_domains WHERE virtual_users.domain_id = virtual_domains.id;";
if(($domain <> "") && ($source <> "") && ($dest <> "")) $sql[4] = "INSERT INTO virtual_aliases VALUES (NULL,'$domain','$source','$dest');";
if($ndomain <> "")
{
$sql0 = "SELECT name FROM virtual_domains WHERE name = '$ndomain';";
$qr = query($sql0);
if(mysql_num_rows($qr) < 1) $sql[5] = "INSERT INTO virtual_domains VALUES(NULL,'$ndomain');";
}
if(($domain <> "") && ($usr <> "") && ($pwd <> ""))
{
$sql1 = "SELECT domain_id, user, password FROM virtual_users WHERE domain_id = $domain AND user = '$usr' AND password = '".md5($pwd)."';";
$qr = query($sql1);
if(mysql_num_rows($qr) < 1) $sql[6] = "INSERT INTO virtual_users VALUES(NULL,'$domain','$usr','".md5($pwd)."');";
}
if(($del <> "") && ($id <> "") && ($ack == "JA"))
{
$sql = "DELETE FROM ".$tbl[$del]." WHERE id = $id;";
query($sql);
}
if(($chg == 1) && ($id <> "") && ($domain <> "") && ($source <> "") && ($dest <> "") && ($ack == "Speichern"))
{
$sql = "UPDATE ".$tbl[$chg]." SET domain_id = '".$domain."', source = '".$source."', destination = '".$dest."' WHERE id = ".$id.";";
query($sql);
}
if(($chg == 2) && ($id <> "") && ($domain <> "") && ($ack == "Speichern"))
{
$sql = "UPDATE ".$tbl[$chg]." SET name='".$domain."' WHERE id = ".$id.";";
query($sql);
}
if(($chg == 3) && ($id <> "") && ($domain <> "") && ($usr <> "") && ($pwd <> "") && ($ack == "Speichern"))
{
$sql = "UPDATE ".$tbl[$chg]." SET domain_id ='".$domain."', user ='".$usr."', password = '".md5($pwd)."' WHERE id = ".$id.";";
query($sql);
}
if($do) $qry = query($sql[$do]);
if($qry) $result = true;
else $result = false;
/* #### -Initialize- #### */
/* #### +Code+ #### */
echo<<<html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Mail-Control</title>
<meta name="AUTHOR" content="RT">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<center>
<h2></h2>
<a href=""></a> <a href="?do=2"></a> <a href="?new=3">Регистрация</a>
</center>
<hr>
html;
switch($new) {
case 1:
$sql = "SELECT id,name FROM virtual_domains;";
$qry = query($sql);
$out = 'Neuer Alias<center><form action="?do=4" method="post">';
$out.= '<table width="50%" align="center"><tr><td align="right">Domain:</td>';
$out.= '<td align="left"><select name="domain" size=1>';
while($row = fetch($qry))
{
$out.= '<option value="'.$row[0].'">'.$row[1].'</option>';
}
$out.= '</select></td></tr>';
$out.= '<tr><td align="right">Source:</td><td align="left"><input type="text" name="src" size=20></input></td></tr>';
$out.= '<tr><td align="right">Destination:</td align="left"><td><input type="text" name="dest" size=20></input></td></tr>';
$out.= '<tr><td align="right"><input type="reset" value="Reset"></td><td align="left"><input type="submit" value="Ok"></td></tr>';
$out.= '</form></table></center>';
break;
case 2:
$out = 'Neue Домен<center><form action="?do=5" method="post">';
$out.= '<table width="50%" align="center"><tr><td align="right">Name:</td><td align="left"><input type="text" name="new_domain" size=20></input></td></tr>';
$out.= '<tr><td align="right"><input type="reset" value="Reset"></td><td align="left"><input type="submit" value="Ok"></td></tr>';
$out.= '</form></table></center>';
break;
case 3:
$sql = "SELECT id,name FROM virtual_domains;";
$qry = query($sql);
$out = 'Новый пользователь<center><form action="?do=6" method="post">';
$out.= '<table width="50%" align="center"><tr><td align="right">Домен:</td>';
$out.= '<td align="left"><select name="domain" size=1>';
while($row = fetch($qry))
{
$out.= '<option value="'.$row[0].'">'.$row[1].'</option>';
}
$out.= '</select></td></tr>';
$out.= '<tr><td align="right">Логин (латиница):</td><td align="left"><input type="text" name="usr" size=20></input></td></tr>';
$out.= '<tr><td align="right">Ваш пароль:</td align="left"><td><input type="text" name="pwd" size=20></input></td></tr>';
$out.= '<tr><td align="right"><input type="reset" value="Reset"></td><td align="left"><input type="submit" value="Ok"></td></tr>';
$out.= '</form></table></center>';
break;
}
switch($do) {
case 1:
$out ="Alias-Verwaltung";
$out.='<center><a href="?new=1">Alias hinzu</a></center><br><br>';
$out.='<table width="80%" align="center" border=1 rules="all">';
$out.='<tr align=center><td><b></b></td><td><b>ID</b></td><td><b>Домен</b></td><td><b>Quelle</b></td><td><b>Ziel</b></td><tr>';
while($row = fetch($qry))
{
$out.='<tr align=center><td><a href="?del=1&id='.$row[0].'" title="Diesen Datensatz löschen"></a> / <a href="?chg=1&id='.$row[0].'" title="Diesen Datensatz ändern"></a></td><td>'.$row[0].'</td><td>'.$row[1].'</td><td>'.$row[2].'</td><td>'.$row[3].'</td></tr>';
}
$out.='</table>';
break;
case 2:
$out = "Domain-Verwaltung";
$out.='<center><a href="?new=2">Domain hinzu</a></center><br><br>';
$out.='<table width="40%" align="center" border=1 rules="all">';
$out.='<tr align=center><td><b></b></td><td><b>ID</b></td><td><b>Name</b></td><tr>';
while($row = fetch($qry))
{
$out.='<tr align=center><td><a href="?del=2&id='.$row[0].'" title="Diesen Datensatz löschen"></a> / <a href="?chg=2&id='.$row[0].'" title="Diesen Datensatz ändern"></a></td><td>'.$row[0].'</td><td>'.$row[1].'</td></tr>';
}
$out.='</table>';
break;
case 3:
$out = "Добро пожаловать в регистрационную форму почтового ящика !!!";
$out.='<center><a href="?new=3">Зарегистрироваться</a></center><br><br>';
$out.='<table width="60%" align="center" border=1 rules="all">';
$out.='<tr align=center><td><b></b></td><td><b>ID</b></td><td><b>Domain</b></td><td><b>User</b></td><tr>';
while($row = fetch($qry))
{
$out.='<tr align=center><td><a href="?del=3&id='.$row[0].'" title="Diesen Datensatz löschen"></a> / <a href="?chg=3&id='.$row[0].'" title="Diesen Datensatz ändern"></a></td><td>'.$row[0].'</td><td>'.$row[1].'</td><td>'.$row[2].'</td></tr>';
}
$out.='</table>';
break;
case 4:
if($result == true) $out = "<center><b>Alias wurde hinzugefügt...</b></center>";
else $out = "<center><h3>Спамер ???Всё твой ip уже в базе !</h3></center>";
break;
case 5:
if($result == true) $out = "<center><b>Domain wurde hinzugefügt...</b></center>";
else $out = "<center><h3>Спамер??? Всё твой ip уже в базе</h3></center>";
break;
case 6:
if($result == true) $out = "<center><b>Поздравляем, вы успешно зарегистрированны!!!</b></center>";
else $out = "<center><h3>Спамер??? Всё твой ip уже в базе!</h3></center>";
break;
}
switch($del) {
case 1:
if($ack == "")
{
$out = '<center><h3>Diesen Alias wirklich löschen?</h3><form action = "?del='.$del.'&id='.$id.'" method="post">';
$out.= '<input type="submit" name="ack" value="NEIN"> | <input type="submit" name="ack" value="JA"></form>';
}
else if($ack == "JA")
{
$out = '<center><b>Alias wurde gelöscht...</b><br><a href="?do=1">Zurück</a></center>';
}
else $out = '<center><a href="?do=1">Zurück</a></center>';
break;
case 2:
if($ack == "")
{
$out = '<center><h3>Diese Domain wirklich löschen?</h3><form action = "?del='.$del.'&id='.$id.'" method="post">';
$out.= '<input type="submit" name="ack" value="NEIN"> | <input type="submit" name="ack" value="JA"></form>';
}
else if($ack == "JA")
{
$out = '<center><b>Domain wurde gelöscht...</b><br><a href="?do=2">Zurück</a></center>';
}
else $out = '<center><a href="?do=2">Zurück</a></center>';
break;
case 3:
if($ack == "")
{
$out = '<center><h3>Diesen User wirklich löschen?</h3><form action = "?del='.$del.'&id='.$id.'" method="post">';
$out.= '<input type="submit" name="ack" value="NEIN"> | <input type="submit" name="ack" value="JA"></form>';
}
else if($ack == "JA")
{
$out = '<center><b>User wurde gelöscht...</b><br><a href="?do=3">Zurück</a></center>';
}
else $out = '<center><a href="?do=3">Zurück</a></center>';
break;
}
switch($chg) {
case 1:
$sql = "SELECT id,name FROM virtual_domains;";
$qry = query($sql);
$sql = "SELECT * FROM virtual_aliases WHERE id=".$id.";";
$qry2 = query($sql);
$details = fetch($qry2);
if($ack == "")
{
$out = '<center>Alias bearbeiten:<form action = "?chg='.$chg.'&id='.$id.'" method="post">';
$out.= '<table width="50%">';
$out.= '<tr><td align="right">Domain:</td><td align="left"><select name="domain" size=1>';
while($row = fetch($qry))
{
$sel = "";
if($row[0] == $details['domain_id']) $sel = "selected";
$out.= '<option value="'.$row[0].'" '.$sel.'>'.$row[1].'</option>';
}
$out.= '</td></tr>';
$out.= '<tr><td align="right">Quelle:</td><td align="left"><input type="text" name="src" size=20 value="'.$details['source'].'"></input></td></tr>';
$out.= '<tr><td align="right">Ziel:</td><td align="left"><input type="text" name="dest" size=20 value="'.$details['destination'].'"></input></td></tr>';
$out.= '<tr><td align="right"><input type="submit" name="ack" value="Abbrechen"></td><td align="left"><input type="submit" name="ack" value="Speichern"></td></tr></table></form>';
}
else if($ack == "Speichern")
{
$out = '<center><b>Alias wurde geändert...</b><br><a href="?do=1">Zurück</a></center>';
}
else $out = '<center><a href="?do=1">Zurück </a></center>';
break;
case 2:
$sql = "SELECT name FROM virtual_domains WHERE id=".$id.";";
$qry = query($sql);
if($ack == "")
{
$dom = fetch($qry);
$out = '<center>Domain bearbeiten:<form action = "?chg='.$chg.'&id='.$id.'" method="post">';
$out.= '<table width="50%">';
$out.= '<tr><td align="right">Domain:</td><td align="left"><input type="text" name="domain" size=20 value="'.$dom['name'].'"></input>';
$out.= '</td></tr>';
$out.= '<tr><td align="right"><input type="submit" name="ack" value="Abbrechen"></td><td align="left"><input type="submit" name="ack" value="Speichern"></td></tr></table></form>';
}
else if($ack == "Speichern")
{
$out = '<center><b>Domain wurde geändert...</b><br><a href="?do=2">Zurück</a></center>';
}
else $out = '<center><a href="?do=2">Zurück </a></center>';
break;
case 3:
$sql = "SELECT id,name FROM virtual_domains;";
$qry = query($sql);
$sql = "SELECT * FROM virtual_users WHERE id=".$id.";";
$qry2 = query($sql);
$details = fetch($qry2);
if($ack == "")
{
$out = '<center>User bearbeiten:<form action = "?chg='.$chg.'&id='.$id.'" method="post">';
$out.= '<table width="50%">';
$out.= '<tr><td align="right">Domain:</td><td align="left"><select name="domain" size=1>';
while($row = fetch($qry))
{
$sel = "";
if($details['domain_id'] == $row[0]) $sel = "selected";
$out.= '<option value="'.$row[0].'" '.$sel.'>'.$row[1].'</option>';
}
$out.= '</td></tr>';
$out.= '<tr><td align="right">Name:</td><td align="left"><input type="text" name="usr" size=20 value="'.$details['user'].'"></input></td></tr>';
$out.= '<tr><td align="right">Password:</td><td align="left"><input type="text" name="pwd" size=20 value=""></input></td></tr>';
$out.= '<tr><td align="right"><input type="submit" name="ack" value="Abbrechen"></td><td align="left"><input type="submit" name="ack" value="Speichern"></td></tr></table></form>';
}
else if($ack == "Speichern")
{
$out = '<center><b>Вы успешно зарегистрированны geändert...</b><br><a href="?do=3">Zurück</a></center>';
}
else $out = '<center><a href="?do=3">Zurück </a></center>';
break;
}
echo $out;
echo<<<html
</body>
</html>
html;
/* #### -Code- #### */
?>
</span></p>
<p>Зарегистрированные
пользователи :
ali ,
anet,
AnyKey,
belfigor,
coolmc,
evgs,
fox71ru,
GOBLIN,
grom,
kostik,
nadejda,
punisher,
raymond,
Vadim,
Erma4ok.</p>
<p>Для проверки работы почты вы можете прислать письмо мне , belfigor@stopxaker.ru </p>
<p>C уважением Администрация (<span class="стиль6">Belfigor</span>) </p>