<?php
include "includes/config.php";
include "includes/config_db.php";
include "includes/header.php";
$datei_url = "register";
include "includes/lang/index.php";

$sql = "SELECT * FROM online";
$result = mysql_query($sql);
while ($row = mysql_fetch_object($result)){
$Spalten_Text = $row->registrierung;
if( $Spalten_Text == 'offline') {
echo $row->r_off_text;
}else{
?>
<?php


$do = $_GET['do'];
$username = $_POST["username"];

if ($do == "pruefen"){
if ($username){
$data = mysql_query("SELECT * FROM `users` WHERE `name` = '$username'");
$data_num = mysql_num_rows($data);
if ($data_num != 0) {
?>
<?php
echo "<font color='red'>$lang_vor_username</font></br>";
$error = 1;
}
}else{
echo "<font color='red'>$lang_fehl_username</font><br>";
$error = 1;
}
if ($error){
$ok = "cross.png";
}else{
$ok = "accept.png";
}
}else{
$error = 1;
}


if (isset($_REQUEST['save'])) {
$passwort = $_POST["passwort"];
$passwort2 = $_POST["passwort2"];
$email = $_POST["email"];
$newsletter = $_POST["newsletter"];
$username = $_GET['un'];
if($newsletter == 1)
{
$newsletter = 'Ja';
}
else
{
$newsletter = "Nein";
}



if($_POST['agb'] == 1){
if($passwort != $passwort2)
{
echo "$lang_fehl_pw_w<br>";
exit;
}
if(!preg_match( '/^([a-zA-Z0-9])+([\.a-zA-Z0-9_-])*@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+/' , $email)){
echo "$lang_fehl_mail<br>";
exit;
}
if($username == "" OR $passwort == "")
{
echo "$lang_fehl_felder<br>";
exit;
}
$passwort = md5($passwort);

$result = mysql_query("SELECT id FROM users WHERE name LIKE '$username'") OR die(mysql_error());
$menge = mysql_num_rows($result);

if($menge == 0)
{
$datum = date("d.m.y - H:i");
$eintrag = "INSERT INTO users (name,pass,email,admin,newsletter,lastconnect) VALUES ('$username', '$passwort','$email','Nein','$newsletter','$datum')";
$eintragen = mysql_query($eintrag) OR die(mysql_error());
?>

<?php
if($eintragen == true)
{
echo "$lang_beg";
exit;
}
else
{
echo "$lang_error<br>";
}
}
else
{
echo "$lang_vor_username<br>";
}
}
else
{
echo "$lang_fehl_regel<br>";
}
}
?>
<script language="javascript">
function oeffnefenster (url) {
fenster=window.open(url, "_blank", "width=600,height=400,status=yes,scrollbars=yes,resizable=yes");
fenster.focus();
return false;
}
</script>
<form action="?do=pruefen" method="post">
<b><?php echo "$lang_gewu_name"; ?></b><br>
<input type="text" size="24" maxlength="30" name="username" value="<?php echo "$username"; ?>">
<?php if ($ok){ ?>
<img style="width: 16px; height: 16px;" src="img/<?php echo "$ok"; ?>">
<?php } ?>
<p><br>
<input type="image" src="img/puefen.png" alt="Pruefen" title="<?php echo "$lang_pru_username"; ?> " border="0">
<br>
<?php
if ($error == ""){
?>
</form>
<form action="?un=<?php echo"$username"; ?>" method="post">
<input type="hidden" name="do" value="register" />
<input type="hidden" name="save" value="1" />
<b><?php echo "$lang_gewu_pass"; ?></b><br>
<input type="password" size="24" maxlength="50" name="passwort"><br>
<?php echo "$lang_wieder_pass"; ?><br>
<input type="password" size="24" maxlength="50" name="passwort2"></p>
<p><br>
<b><?php echo "$lang_email"; ?></b><br>
<input type="text" size="24" maxlength="50" name="email"></p>
<p>&nbsp;</p>
<p><?php echo "$lang_newsletter_ep"; ?>
<input type="checkbox" name="newsletter" value="1" checked></p>
<p><br>
<?php echo "$lang_ich_habe"; ?> <a href="regel.php" target="_blank" onclick="oeffnefenster(this.href); return false"><?php echo "$lang_regeln"; ?></a> <?php echo "$lang_gelesen_stimme_zu"; ?><input type="checkbox" name="agb" value="1"></p>
<p>&nbsp;</p>
<p>&nbsp;<input type="submit" value="<?php echo "$lang_reg"; ?>"> </p>
</form>
<?php
}
}
}

include "includes/footer.php";
?>
 

<?php
$result = mysql_query($sql); 

<?php
if ( !$result ) die('MySQL-Fehler:' . mysql_error()); 

MySQL-Fehler:Table 'meinetestseite1.online' doesn't exist