INDEX.PHP
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/users/94/jeroen18/www/anticlimax.pandela.org/member/index.php on line 76
<?
require('config.inc.php');
?>
<html>
<head>
<title><?php echo $title ?></title>
</head>
<body bgcolor="<?php echo $bgcolor; ?>" text="<?php echo $textcolor; ?>">
<?
mysql_connect($sqlhost,$sqluser,$sqlpass) OR DIE( "Couldn't connect to MySQL server!");
mysql_select_db($database);
switch($do){
default :
switch($egon){
default : $result = mysql_query("SELECT * FROM $tablename ORDER BY rang"); break;
case $r1 : $result = mysql_query("SELECT * FROM $tablename WHERE rang = '1'"); break;
case $r2 : $result = mysql_query("SELECT * FROM $tablename WHERE rang = '2'"); break;
case $r3 : $result = mysql_query("SELECT * FROM $tablename WHERE rang = '3'"); break;
case $r4 : $result = mysql_query("SELECT * FROM $tablename WHERE rang = '4'"); break;
}
?>
<!--auswahlmenue//-->
<table width="335" border="0" cellpadding="0" cellspacing="0" align="center">
<tr bgcolor="#54617E">
<td><img src="<?php echo $imghead; ?>" width="335" height="30"></td>
</tr>
<tr>
<td>
<table border=0 cellpadding=2 cellspacing=0 width=335 background="<?php echo $imglist; ?>">
<tr>
<td width=20% height=15 align=center>
<? echo"$txt <a href='$pagephp'>$txt$all</a> |
<a href='$indexphp?do=viewall&egon=$r1' target=_self>$txt $r1</a> |
<a href='$indexphp?do=viewall&egon=$r2' target=_self>$txt $r2</a> |
<a href='$indexphp?do=viewall&egon=$r3' target=_self>$txt $r3</a> |
<a href='$indexphp?do=viewall&egon=$r4' target=_self>$txt $r4</a> <br><br>$txt2 *Info: $leader ist Leader von $clan"; ?></font>
</td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#54617E">
<td><img src="<?php echo $imgfoot; ?>" width="335"></td>
</tr>
</table>
<!-- auswahlmenue ENDE //-->
<table width="335" border="0" cellpadding="0" cellspacing="0" align="center">
<tr bgcolor="#54617E">
<td><img src="<?php echo $imghead; ?>" width="335" height="30"></td>
</tr>
<tr>
<td>
<table border=0 cellpadding=2 cellspacing=0 width=335 background="<?php echo $imglist; ?>">
<tr>
<td width=25% height=15 align=center><? echo $txt2; ?>nick</font> </td>
<td width=25% height=15 align=center><? echo $txt2; ?>status</font> </td>
<td width=25% height=15 align=center><? echo $txt2; ?>rang</font> </td>
<td width=25% height=15 align=center><? echo $txt2; ?>details</font></a> </td>
</tr>
<!--Einzelne Member-->
<? while ($data = mysql_fetch_array($result)) { ?>
<tr>
<td width=25% height=15 align=center><? echo $txt; ?><? echo $data[nick]; ?></font></td>
<td width=25% height=15 align=center><? echo $txt; ?>
<? if($data[active] == "active"){ echo "$txt3 $data[active]</font>"; } else { echo "$txt4 $data[active]</font>"; } ?></font></td>
<td width=25% height=15 align=center><? echo $txt; ?>
<?
if($data[rang] == "1")
{ echo "$txt1 $r1</font>"; }
elseif($data[rang] == "2")
{ echo "$txt1 $r2</font>"; }
elseif($data[rang] == "3")
{ echo "$txt1 $r3</font>"; }
elseif($data[rang] == "4")
{ echo "$txt1 $r4</font>"; }
?>
</font></td>
<td width=25% height=15 align=center><a href="javascript:NeuesFenster('<? echo $indexphp; ?>?do=detail&userid=<? echo $data[userid]; ?>',450,450)"><? echo $txt; ?><? echo $info; ?></a></td>
</tr>
<? } ?>
<!--Einzelne Member ENDE-->
</table>
</td>
</tr>
<tr bgcolor="#54617E">
<td><img src="<?php echo $imgfoot; ?>" width="335"></td>
</tr>
</table>
<?
break;
case "detail" :
$query = "SELECT * FROM $tablename WHERE userid='$userid'";
$ergebnis = mysql_query($query);
while ($data = mysql_fetch_array($ergebnis)) {
?>
<!--Details-->
<table width="335" border="0" cellpadding="0" cellspacing="0" align=center>
<tr bgcolor="#54617E">
<td align=left><img src="<?php echo $imghead; ?>" width="335" height="30"></td>
</tr>
<tr>
<td height=15 align=left>
<table border=0 cellpadding=2 cellspacing=0 width=335 background="<?php echo $imglist; ?>">
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> nick:</font> </td>
<td width=50% height=15 align=left><? if($data[pic] == "" || $data[pic] == "n/A"){ echo "$txt $data[nick]"; } else { echo "<a href='http://$data[pic]' target='_blank'>$txt $data[nick]</font></a>"; } ?></TD>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> birthday:</font> </td>
<td width=50% height=15 align=left><? echo $txt; ?><? echo $data[birth]; ?></font></TD>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> name:</font> </td>
<td width=50% height=15 align=left><? echo $txt; ?><? echo $data[name]; ?></font></TD>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> hardware:</font> </td>
<td width=50% height=15 align=left><? echo $txt; ?><? echo $data[hardware]; ?></font></TD>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> connection:</font></td>
<td width=50% height=15 align=left><? echo $txt; ?><? echo $data[con]; ?></font></TD>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> status:</font> </td>
<td width=50% height=15 align=left><? echo $txt; ?><? if($data[active] == "active"){ echo "$txt3 $data[active]</font>"; } else { echo "$txt4 $data[active]</font>"; } ?></font></TD>
</tr>
<TR>
<TD WIDTH=50% HEIGHT=15 align=left><? echo $txt2; ?> rang:</FONT></td>
<td width=50% height=15 align=left><? echo $txt; ?>
<?
if($data[rang] == "1")
{ echo "$txt1 $r1</font>"; }
elseif($data[rang] == "2")
{ echo "$txt1 $r2</font>"; }
elseif($data[rang] == "3")
{ echo "$txt1 $r3</font>"; }
elseif($data[rang] == "4")
{ echo "$txt1 $r4</font>"; }
?>
</font></TD>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> e-mail:</font> </td>
<td width=50% height=15 align=left><a href="mailto: <? echo $data[mail]; ?>"><? echo $txt; ?><? echo $data[mail]; ?></font></a></td>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> homepage:</font> </td>
<td width=50% height=15 align=left><a href="http://<? echo $data[homepage]; ?>" target="_blank"><? echo $txt; ?><? echo $data[homepage]; ?></font></a></td>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> icq:</font></td>
<td width=50% height=15 align=left><a href="http://wwp.mirabilis.com/scripts/Search.dll?to=<? echo $data[icq]; ?>"><? echo $txt; ?><? echo $data[icq]; ?></font></a></td>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> hobbies:</font></td>
<td width=50% height=15 align=left><? echo $txt; ?><? echo $data[hobbies]; ?></font></TD>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> fav. maps:</font></td>
<td width=50% height=15 align=left><? echo $txt; ?><? echo $data[maps]; ?></font></TD>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> fav. weapon:</font></td>
<td width=50% height=15 align=left><? echo $txt; ?><? echo $data[weapons]; ?></font></TD>
</tr>
<tr>
<td width=50% height=15 align=left><? echo $txt2; ?> comment:</font> </td>
<td width=50% height=15 align=left><? echo $txt; ?><? echo $data[comment]; ?></font></TD>
</tr>
<tr>
<td width=50% height=15 align=left><font size=4> </font></td>
<td width=50% height=15 align=left><div align=left><a href="#" onclick='self.close()'><? echo $txt; ?>close</font></a></div></td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#54617E">
<td><img src="<?php echo $imgfoot; ?>" width="335"></td>
</tr>
</table>
<!--Details ENDE-->
<?
}
break;
}
?>
<BR><BR><BR><BR>
<DIV align=center>
<? echo $txt; ?>[<A href="<? echo $adminphp; ?>">admin</A>]</FONT><BR><BR>
<? echo $txt; ?><? echo $copyright; ?></font></DIV>
</body>
</html>
ADMIN.PHP:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/users/94/jeroen18/www/anticlimax.pandela.org/member/admin/admin.php on line 49
<?php
require('../config.inc.php');
mysql_connect($sqlhost,$sqluser,$sqlpass) OR DIE( "Couldn't connect to MySQL server!");
mysql_select_db($database) or DIE( "Keine Datenbank erreichbar!" );
?>
<html>
<head>
<title><? echo $title; ?></title>
</head>
<body bgcolor="<?php echo $bgcolor; ?>" text="<?php echo $textcolor; ?>">
<?php
switch ($action){
default:
?>
<div align="center">
<table width="65%" bordercolor=000000 border="1" cellpadding="0" cellspacing="0" align="center">
<tr bgcolor="223353">
<td>
<div align="center">
<b><font color="ffffff">Member - Administration</font></b><BR>
</div>
</td>
</tr>
<tr bgcolor="223353">
<td><br>
<?
mysql_connect($sqlhost,$sqluser,$sqlpass) OR DIE( "Couldn't connect to MySQL server!");
mysql_select_db($database);
if(isset($delete)) mysql_query("DELETE FROM $tablename WHERE userid='$delete'");
$result = mysql_query("SELECT * FROM $tablename ORDER BY userid");
?>
<table width="65%" bordercolor=000000 border="1" cellpadding="0" cellspacing="0" align="center">
<tr bgcolor="223353">
<td><b><font color=000000 face=tahoma size=2><DIV align=center>- id -</DIV></FONT></b></td>
<td><b><font color=000000 face=tahoma size=2><DIV align=center>- name -</DIV></FONT></b></td>
<td><b><font color=000000 face=tahoma size=2><DIV align=center>- edit -</DIV></FONT></b></td>
<td><b><font color=000000 face=tahoma size=2><DIV align=center>- del -</DIV></FONT></b></td>
</tr>
<? while ($data = mysql_fetch_array($result)) { ?>
<tr bgcolor="223353" onMouseOut="style.backgroundColor='#223353'"onMouseOver="style.backgroundColor='#54617E'">
<td><font color=ffffff face=tahoma size=1><DIV align=center><? echo $data[userid]; ?></DIV></FONT></td>
<td><font color=ffffff face=tahoma size=1><DIV align=center><? echo $data[nick]; ?></DIV></FONT></td>
<td><DIV align=center><a href="admin.php?action=edit&userid=<? echo $data[userid]; ?>">edit</a></DIV></td>
<td><DIV align=center><a href="admin.php?delete=<? echo $data[userid];?>">del</a></DIV></td>
</tr>
<? } ?>
<tr bgcolor="223353">
<td onMouseOut="style.backgroundColor='#223353'"onMouseOver="style.backgroundColor='#54617E'" colspan='2'><DIV align=center><FONT size=2>[<A href="admin.php?action=add">add member</A>]</FONT></td></DIV>
<td onMouseOut="style.backgroundColor='#223353'"onMouseOver="style.backgroundColor='#54617E'" colspan='1'><DIV align=center><FONT size=2>[<A href="<? echo $pagephp; ?>">list member</A>]</FONT></td></DIV>
<td onMouseOut="style.backgroundColor='#223353'"onMouseOver="style.backgroundColor='#54617E'" colspan='2'><DIV align=center><FONT size=2>[<A href="<? echo $adminphp; ?>">aktualisiern</A>]</FONT></td></DIV>
</tr>
</table>
<div align="center"><br>
<br>
</div>
<hr size="1" color="000000">
<font face="Tahoma" size="1"><? echo $copyright; ?></font>
</td>
</tr>
</table>
</div>
<!--Add member-->
<?php
break;
case "add":
?>
<form method='post' action='<? echo $PHP_SELF; ?>?action=write'>
<br>
<table width='40%' bgcolor=223353 bordercolor=000000 border='1' cellpadding='0' cellspacing='0' align='center'>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>nick:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='nick' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>birthday:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='birth' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>name:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='name' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>hardware:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='hardware' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>connection:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='con' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>status:</FONT></DIV>
</td>
<td>
<DIV align=left>
<select name='active' size='' style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;'>
<option value='active'>active
<option value='inactive'>inactive
</select>
</DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>rang:</FONT></DIV>
</td>
<td>
<DIV align=left>
<select name='rang' size='' style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;'>
<option value='1'><? echo $r1; ?>
<option value='2'><? echo $r2; ?>
<option value='3'><? echo $r3; ?>
<option value='4'><? echo $r4; ?>
</select>
</DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>email:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='mail' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>homepage:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='homepage' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>icq#:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='icq' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>hobby`s:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='hobbies' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>fav. maps:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='maps' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>fav. weapons:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='weapons' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>bild (ohne http://):</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='pic' value='' size='<? echo $inpsize; ?>' maxlength='<? echo $max_leng; ?>'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>comment:</FONT></DIV>
</td>
<td>
<DIV align=left><textarea name='comment' cols='49' rows='5' style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;'></textarea></div>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>add member</FONT></DIV>
</td>
<td>
<DIV align=center><input style='font-size: 7pt; color:#000000; background-color:#223353; border-color:#111111; border-style:groove' name='submit' type='Submit' value='add member'></DIV>
</td>
</tr>
</table>
<div align='center'><br>
<font size='1' color='<? echo $textcolor; ?>'><a href='<? echo $adminphp; ?>'>zurück</a></font><br>
</div>
</form>
<?php
break;
case "write":
$sql = "INSERT INTO $tablename
(userid,nick,birth,name,hardware,con,rang,active,mail,homepage,icq,hobbies,maps,weapons,pic,comment)
VALUES('','$nick','$birth','$name','$hardware','$con','$rang','$active','$mail','$homepage','$icq','$hobbies','$maps','$weapons','$pic','$comment')";
$result = @mysql_query($sql);
?>
Member erfolgreich hinzugefügt! <br>
[<A href='<? echo $adminphp; ?>'>aktualisieren!</A>]
<?php
break;
case "edit":
if (!isset($bearbeiten))
{
$wahl = mysql_query("SELECT * FROM $tablename WHERE userid='$userid' LIMIT 1");
while ($data = mysql_fetch_array($wahl)) {
?>
<form method='post' name='edit' action='<?php echo $PHP_SELF ?>?action=edit&userid=<? echo $data[userid]; ?>'>
<br>
<table width='40%' bgcolor=223353 bordercolor=000000 border='1' cellpadding='0' cellspacing='0' align='center'>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>nick:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='nick' value='<?php echo $data[nick]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>birthday:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='birth' value='<?php echo $data[birth]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>name:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='name' value='<?php echo $data[name]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>hardware:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='hardware' value='<?php echo $data[hardware]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>connection:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='con' value='<?php echo $data[con]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>status:</FONT></DIV>
</td>
<td>
<DIV align=left>
<select name='active' size='' style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;'>
<option value='<?php echo $data[active]; ?>'><?php echo $data[active]; ?>
<option value='active'>active
<option value='inactive'>inactive
</select>
</DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>rang:</FONT></DIV>
</td>
<td>
<DIV align=left>
<select name='rang' size='' style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;'>
<option value='<?php echo $data[rang]; ?>'><?php echo $data[rang]; ?>
<option value='1'><? echo $r1; ?>
<option value='2'><? echo $r2; ?>
<option value='3'><? echo $r3; ?>
<option value='4'><? echo $r4; ?>
</select>
</DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>email:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='mail' value='<?php echo $data[mail]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>homepage:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='homepage' value='<?php echo $data[homepage]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>icq#:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='icq' value='<?php echo $data[icq]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>hobby`s:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='hobbies' value='<?php echo $data[hobbies]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>fav. maps:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='maps' value='<?php echo $data[maps]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>fav. weapons:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='weapons' value='<?php echo $data[weapons]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>url zum bild:</FONT></DIV>
</td>
<td>
<DIV align=left><input style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;' type='Text' name='pic' value='<?php echo $data[pic]; ?>' size='$inpsize' maxlength='$max_leng'></DIV>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>comment:</FONT></DIV>
</td>
<td>
<DIV align=left><textarea name='comment' cols='49' rows='5' style='font-family: Tahoma; background-color: #223353; color: #FFFFFF; font-size: 7pt; border: 2 solid #000000;'><?php echo $data[comment]; ?></textarea></div>
</td>
</tr>
<tr>
<td>
<DIV align=center><FONT face='Tahoma' size=2 color=#FFFFFF>edit member</FONT></DIV>
</td>
<td>
<DIV align=center><input style='font-size: 7pt; color:#000000; background-color:#223353; border-color:#111111; border-style:groove' name='bearbeiten' type='Submit' value='edit member'></DIV>
</td>
</tr>
</table>
<div align='center'><br>
<font size='1' color='<? echo $textcolor; ?>'><a href='<? echo $adminphp; ?>'>zurück</a></font><br>
</div>
</form>
<?php
}
}
elseif(isset($bearbeiten))
{
$wahl = mysql_query("UPDATE $tablename SET nick='$nick' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET birth='$birth' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET name='$name' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET hardware='$hardware' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET con='$con' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET rang='$rang' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET active='$active' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET mail='$mail' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET homepage='$homepage' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET icq='$icq' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET hobbies='$hobbies' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET maps='$maps' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET weapons='$weapons' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET pic='$pic' WHERE userid='$userid'");
$wahl = mysql_query("UPDATE $tablename SET comment='$comment' WHERE userid='$userid'");
?>
<BR>
Member erfolgreich bearbeitet! <br>
[<A href='<? echo $adminphp; ?>'>aktualisieren!</A>]
<?php
}
break;
}
?>
</body>
</html>
Iemand een oplossing???
