Jeg lægger lige hele koden for den administrations side hvor man kan skifte adgangs nr. for diverse brugere.
Det hele virker perfekt, bortset fra at man kun kan tildele hver bruger et adgangs nr. Jeg ville gerne at der kunne tildeles mere end et adgangs nr. for hver bruger.
Hvilke adgangs nummer diverse brugere bliver tildelt, bestemmes af administrator.
Håber denne forklaring var lidt bedre.
<?php require_once('../Connections/cms.php'); ?>
<?php
mysql_select_db($database_cms, $cms);
$query_rsBrugere1 = "SELECT * FROM brugere WHERE id = 1 ORDER BY id ASC";
$rsBrugere1 = mysql_query($query_rsBrugere1, $cms) or die(mysql_error());
$row_rsBrugere1 = mysql_fetch_assoc($rsBrugere1);
$totalRows_rsBrugere1 = mysql_num_rows($rsBrugere1);
mysql_select_db($database_cms, $cms);
$query_rsBrugere2 = "SELECT * FROM brugere WHERE id = 2 ORDER BY id ASC";
$rsBrugere2 = mysql_query($query_rsBrugere2, $cms) or die(mysql_error());
$row_rsBrugere2 = mysql_fetch_assoc($rsBrugere2);
$totalRows_rsBrugere2 = mysql_num_rows($rsBrugere2);
mysql_select_db($database_cms, $cms);
$query_rsBrugere4 = "SELECT * FROM brugere WHERE id = 4 ORDER BY id ASC";
$rsBrugere4 = mysql_query($query_rsBrugere4, $cms) or die(mysql_error());
$row_rsBrugere4 = mysql_fetch_assoc($rsBrugere4);
$totalRows_rsBrugere4 = mysql_num_rows($rsBrugere4);
mysql_select_db($database_cms, $cms);
$query_rsBrugere5 = "SELECT * FROM brugere WHERE id = 5 ORDER BY id ASC";
$rsBrugere5 = mysql_query($query_rsBrugere5, $cms) or die(mysql_error());
$row_rsBrugere5 = mysql_fetch_assoc($rsBrugere5);
$totalRows_rsBrugere5 = mysql_num_rows($rsBrugere5);
mysql_select_db($database_cms, $cms);
$query_rsBrugere6 = "SELECT * FROM brugere WHERE id = 6 ORDER BY id ASC";
$rsBrugere6 = mysql_query($query_rsBrugere6, $cms) or die(mysql_error());
$row_rsBrugere6 = mysql_fetch_assoc($rsBrugere6);
$totalRows_rsBrugere6 = mysql_num_rows($rsBrugere6);
mysql_select_db($database_cms, $cms);
$query_rsBrugere7 = "SELECT * FROM brugere WHERE id = 7 ORDER BY id ASC";
$rsBrugere7 = mysql_query($query_rsBrugere7, $cms) or die(mysql_error());
$row_rsBrugere7 = mysql_fetch_assoc($rsBrugere7);
$totalRows_rsBrugere7 = mysql_num_rows($rsBrugere7);
mysql_select_db($database_cms, $cms);
$query_rsBrugere3 = "SELECT * FROM brugere WHERE id = 3 ORDER BY id ASC";
$rsBrugere3 = mysql_query($query_rsBrugere3, $cms) or die(mysql_error());
$row_rsBrugere3 = mysql_fetch_assoc($rsBrugere3);
$totalRows_rsBrugere3 = mysql_num_rows($rsBrugere3);
session_start();
require_once('../Connections/cms.php');
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<title>Adm. Brugere</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
background-image: url(../img/baggrund.jpg);
margin-left:0px;
margin-top:0px;
margin-right:0px;
margin-bottom:0px;
height:100%;
}
.style3 {
color: #666666;
font-weight: bold;
}
.style7 {
font-size: 12px;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-weight: bold;
color: #000099;
}
.style9 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 18px;
font-weight: bold;
color: #000066;
}
.style14 {
color: #000099;
font-weight: bold;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function mmLoadMenus() {
if (window.mm_menu_1114220122_0) return;
window.mm_menu_1114220122_0 = new Menu("root",70,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1114220122_0.addMenuItem("Forside","location='index.php'");
mm_menu_1114220122_0.hideOnMouseOut=true;
mm_menu_1114220122_0.bgColor='#555555';
mm_menu_1114220122_0.menuBorder=1;
mm_menu_1114220122_0.menuLiteBgColor='#FFFFFF';
mm_menu_1114220122_0.menuBorderBgColor='#777777';
window.mm_menu_1114221213_0 = new Menu("root",71,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1114221213_0.addMenuItem("Menu 1","location='menu_1.php'");
mm_menu_1114221213_0.addMenuItem("Menu 2","location='menu_2.php'");
mm_menu_1114221213_0.addMenuItem("Menu 3","location='menu_3.php'");
mm_menu_1114221213_0.addMenuItem("Menu 4","location='menu_4.php'");
mm_menu_1114221213_0.addMenuItem("Menu 5","location='menu_5.php'");
mm_menu_1114221213_0.hideOnMouseOut=true;
mm_menu_1114221213_0.bgColor='#555555';
mm_menu_1114221213_0.menuBorder=1;
mm_menu_1114221213_0.menuLiteBgColor='#FFFFFF';
mm_menu_1114221213_0.menuBorderBgColor='#777777';
window.mm_menu_1114221611_0 = new Menu("root",79,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1114221611_0.addMenuItem("Menu 6","location='menu_6.php'");
mm_menu_1114221611_0.addMenuItem("Menu 7","location='menu_7.php'");
mm_menu_1114221611_0.addMenuItem("Menu 8","location='menu_8.php'");
mm_menu_1114221611_0.addMenuItem("Menu 9","location='menu_9.php'");
mm_menu_1114221611_0.addMenuItem("Menu 10","location='menu_10.php'");
mm_menu_1114221611_0.hideOnMouseOut=true;
mm_menu_1114221611_0.bgColor='#555555';
mm_menu_1114221611_0.menuBorder=1;
mm_menu_1114221611_0.menuLiteBgColor='#FFFFFF';
mm_menu_1114221611_0.menuBorderBgColor='#777777';
window.mm_menu_1114222112_0 = new Menu("root",89,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1114222112_0.addMenuItem("Nye ting","location='nye_ting.php'");
mm_menu_1114222112_0.addMenuItem("Brugte ting","location='brugte_ting.php'");
mm_menu_1114222112_0.hideOnMouseOut=true;
mm_menu_1114222112_0.bgColor='#555555';
mm_menu_1114222112_0.menuBorder=1;
mm_menu_1114222112_0.menuLiteBgColor='#FFFFFF';
mm_menu_1114222112_0.menuBorderBgColor='#777777';
window.mm_menu_1114222414_0 = new Menu("root",82,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1114222414_0.addMenuItem("Billeder 1","location='billeder_1.php'");
mm_menu_1114222414_0.hideOnMouseOut=true;
mm_menu_1114222414_0.bgColor='#555555';
mm_menu_1114222414_0.menuBorder=1;
mm_menu_1114222414_0.menuLiteBgColor='#FFFFFF';
mm_menu_1114222414_0.menuBorderBgColor='#777777';
window.mm_menu_1114222456_0 = new Menu("root",56,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1114222456_0.addMenuItem("2006","location='2006.php'");
mm_menu_1114222456_0.hideOnMouseOut=true;
mm_menu_1114222456_0.bgColor='#555555';
mm_menu_1114222456_0.menuBorder=1;
mm_menu_1114222456_0.menuLiteBgColor='#FFFFFF';
mm_menu_1114222456_0.menuBorderBgColor='#777777';
window.mm_menu_1114222604_0 = new Menu("root",48,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1114222604_0.addMenuItem("Info","location='info.php'");
mm_menu_1114222604_0.hideOnMouseOut=true;
mm_menu_1114222604_0.bgColor='#555555';
mm_menu_1114222604_0.menuBorder=1;
mm_menu_1114222604_0.menuLiteBgColor='#FFFFFF';
mm_menu_1114222604_0.menuBorderBgColor='#777777';
window.mm_menu_1115155146_0 = new Menu("root",71,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1115155146_0.addMenuItem("Menu 1","location='menu_1.php'");
mm_menu_1115155146_0.addMenuItem("Menu 2","location='menu_2.php'");
mm_menu_1115155146_0.addMenuItem("Menu 3","location='menu_3.php'");
mm_menu_1115155146_0.addMenuItem("Menu 4","location='menu_4.php'");
mm_menu_1115155146_0.addMenuItem("Menu 5","location='menu_5.php'");
mm_menu_1115155146_0.hideOnMouseOut=true;
mm_menu_1115155146_0.bgColor='#555555';
mm_menu_1115155146_0.menuBorder=1;
mm_menu_1115155146_0.menuLiteBgColor='#FFFFFF';
mm_menu_1115155146_0.menuBorderBgColor='#777777';
window.mm_menu_1115155347_0 = new Menu("root",79,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1115155347_0.addMenuItem("Menu 6","location='menu_6.php'");
mm_menu_1115155347_0.addMenuItem("Menu 7","location='menu_7.php'");
mm_menu_1115155347_0.addMenuItem("Menu 8","location='menu_8.php'");
mm_menu_1115155347_0.addMenuItem("Menu 9","location='menu_9.php'");
mm_menu_1115155347_0.addMenuItem("Menu 10","location='menu_10.php'");
mm_menu_1115155347_0.hideOnMouseOut=true;
mm_menu_1115155347_0.bgColor='#555555';
mm_menu_1115155347_0.menuBorder=1;
mm_menu_1115155347_0.menuLiteBgColor='#FFFFFF';
mm_menu_1115155347_0.menuBorderBgColor='#777777';
window.mm_menu_1115155613_0 = new Menu("root",89,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1115155613_0.addMenuItem("Nye ting","location='nye_ting.php'");
mm_menu_1115155613_0.addMenuItem("Brugte ting","location='brugte_ting.php'");
mm_menu_1115155613_0.hideOnMouseOut=true;
mm_menu_1115155613_0.bgColor='#555555';
mm_menu_1115155613_0.menuBorder=1;
mm_menu_1115155613_0.menuLiteBgColor='#FFFFFF';
mm_menu_1115155613_0.menuBorderBgColor='#777777';
window.mm_menu_1115155728_0 = new Menu("root",76,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1115155728_0.addMenuItem("Album 1","location='album_1.php'");
mm_menu_1115155728_0.hideOnMouseOut=true;
mm_menu_1115155728_0.bgColor='#555555';
mm_menu_1115155728_0.menuBorder=1;
mm_menu_1115155728_0.menuLiteBgColor='#FFFFFF';
mm_menu_1115155728_0.menuBorderBgColor='#777777';
window.mm_menu_1115155827_0 = new Menu("root",56,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1115155827_0.addMenuItem("2006","location='2006.php'");
mm_menu_1115155827_0.hideOnMouseOut=true;
mm_menu_1115155827_0.bgColor='#555555';
mm_menu_1115155827_0.menuBorder=1;
mm_menu_1115155827_0.menuLiteBgColor='#FFFFFF';
mm_menu_1115155827_0.menuBorderBgColor='#777777';
window.mm_menu_1115155915_0 = new Menu("root",93,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1115155915_0.addMenuItem("Information","location='information.php'");
mm_menu_1115155915_0.hideOnMouseOut=true;
mm_menu_1115155915_0.bgColor='#555555';
mm_menu_1115155915_0.menuBorder=1;
mm_menu_1115155915_0.menuLiteBgColor='#FFFFFF';
mm_menu_1115155915_0.menuBorderBgColor='#777777';
window.mm_menu_1115160126_0 = new Menu("root",88,18,"",12,"#000000","#FFFFFF","#CCCCCC","#666666","left","middle",3,0,1000,-5,7,true,true,true,0,true,true);
mm_menu_1115160126_0.addMenuItem("Opret mail","location='opret_mail'");
mm_menu_1115160126_0.hideOnMouseOut=true;
mm_menu_1115160126_0.bgColor='#555555';
mm_menu_1115160126_0.menuBorder=1;
mm_menu_1115160126_0.menuLiteBgColor='#FFFFFF';
mm_menu_1115160126_0.menuBorderBgColor='#777777';
mm_menu_1115160126_0.writeMenus();
} // mmLoadMenus()
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<script language="JavaScript" src="../mm_menu.js"></script>
</head>
<body onLoad="MM_preloadImages('../img/rod_01_over.gif','../img/rod_03_over.gif','../img/rod_04_over.gif','../img/rod_05_over.gif','../img/rod_08_over.gif','../img/rod_02_over.gif','../img/rod_07_over.gif','../img/rod_06_over.gif')">
<script language="JavaScript1.2">mmLoadMenus();</script>
<table width="722" height="100%" border="0" align="center" cellpadding="1" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="60" bgcolor="#CCCCCC"><div align="center">
<h1 class="style3">Ændring af adgang for brugere </h1>
</div></td>
</tr>
<tr>
<td bgcolor="#999999"><div align="left">
<table width="722" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="130"><a href="adm_administrator.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','img/adm_09_over.gif',0)"><img src="img/adm_09.gif" name="Image1" width="130" height="22" border="0"></a></td>
<td> </td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td height="19"><table width="722" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="116"> </td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
<tr>
<td><form action="" method="POST">
<table width="631" border="0" cellpadding="2">
<tr>
<td width="174" class="style7"><div align="right">Brugernavn:</div></td>
<td width="144"><input type="text" name="navn"></td>
<td width="117"><div align="right"><span class="style7">Adgang:</span> </div></td>
<td width="170"><input name="tal" type="text" size="10"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td><input type="submit" name="ok" value="Adgang"></td>
</tr>
</table>
<?php
$user = $_SESSION['MM_Username'];
$query = mysql_query("select * from brugere WHERE brugernavn = '$user'") or die (mysql_error());
$row=mysql_fetch_array($query);
if ($row['adgang'] == "1") {
echo "<center>";
echo "<br><br><br>";
echo "<table border=\"1\" width=\"600\">";
$navn = $_POST['navn'];
$tal = $_POST['tal'];
$foresp = mysql_query("SELECT * FROM brugere WHERE LOWER(brugernavn) LIKE '%".strtolower($navn)."%' LIMIT 1");
WHILE($udtraek = mysql_fetch_array($foresp)) {
$soegresultat = $udtraek[brugernavn];
}
if(isset($navn)) {
if(isset($tal)) {
mysql_query("UPDATE brugere SET `adgang`='$tal' WHERE brugernavn = '$soegresultat'") or die(mysql_error());
}
}
echo "</table>";
echo "</center>";
}else{
echo "Du har ikke adgang hertil.";
}
?>
<p align="center" class="style9">Oversigt over brugere</p>
</form>
<table width="526" border="1" align="center" cellpadding="3" cellspacing="0">
<tr>
<td width="100"><div align="center"><span class="style7">Fornavn</span></div></td>
<td width="100"><div align="center"><span class="style7">Efternavn</span></div></td>
<td width="80"><span class="style7">Brugernavn</span></td>
<td width="80"><div align="center"><span class="style7">Password</span></div></td>
<td width="80"><div align="center"><span class="style7">Adgang</span></div></td>
</tr>
<tr>
<td><input name="textfield32" type="text" size="15"></td>
<td><input name="textfield33" type="text" size="15"></td>
<td><?php echo $row_rsBrugere1['brugernavn']; ?></td>
<td><?php echo $row_rsBrugere1['password']; ?></td>
<td><?php echo $row_rsBrugere1['adgang']; ?></td>
</tr>
<tr>
<td><input name="textfield3" type="text" size="15"></td>
<td><input name="textfield9" type="text" size="15"></td>
<td><?php echo $row_rsBrugere2['brugernavn']; ?></td>
<td><?php echo $row_rsBrugere2['password']; ?></td>
<td><?php echo $row_rsBrugere2['adgang']; ?></td>
</tr>
<tr>
<td><input name="textfield4" type="text" size="15"></td>
<td><input name="textfield10" type="text" size="15"></td>
<td><?php echo $row_rsBrugere3['brugernavn']; ?></td>
<td><?php echo $row_rsBrugere3['password']; ?></td>
<td><?php echo $row_rsBrugere3['adgang']; ?></td>
</tr>
<tr>
<td height="31"><input name="textfield5" type="text" size="15"></td>
<td><input name="textfield11" type="text" size="15"></td>
<td><?php echo $row_rsBrugere4['brugernavn']; ?></td>
<td><?php echo $row_rsBrugere4['password']; ?></td>
<td><?php echo $row_rsBrugere4['adgang']; ?></td>
</tr>
<tr>
<td><input name="textfield6" type="text" size="15"></td>
<td><input name="textfield12" type="text" size="15"></td>
<td><?php echo $row_rsBrugere5['brugernavn']; ?></td>
<td><?php echo $row_rsBrugere5['password']; ?></td>
<td><?php echo $row_rsBrugere5['adgang']; ?></td>
</tr>
<tr>
<td><input name="textfield7" type="text" size="15"></td>
<td><input name="textfield13" type="text" size="15"></td>
<td><?php echo $row_rsBrugere6['brugernavn']; ?></td>
<td><?php echo $row_rsBrugere6['password']; ?></td>
<td><?php echo $row_rsBrugere6['adgang']; ?></td>
</tr>
<tr>
<td><input name="textfield8" type="text" size="15"></td>
<td><input name="textfield14" type="text" size="15"></td>
<td><?php echo $row_rsBrugere7['brugernavn']; ?></td>
<td><?php echo $row_rsBrugere7['password']; ?></td>
<td><?php echo $row_rsBrugere7['adgang']; ?></td>
</tr>
</table>
<p align="center" class="style9">Oversigt over sideadgang </p>
<table width="191" border="1" align="center" cellpadding="3" cellspacing="0">
<tr>
<td width="126"><span class="style7">Administrator</span></td>
<td width="53"><span class="style14">1</span></td>
</tr>
<tr>
<td><span class="style7">Forside</span></td>
<td><span class="style14">2</span></td>
</tr>
<tr>
<td><span class="style7">Menu A </span></td>
<td><span class="style14">3</span></td>
</tr>
<tr>
<td><span class="style7">Menu B </span></td>
<td><span class="style14">4</span></td>
</tr>
<tr>
<td><span class="style7">Ting til salg </span></td>
<td><span class="style14">5</span></td>
</tr>
<tr>
<td><span class="style7">Billeder</span></td>
<td><span class="style14">6</span></td>
</tr>
<tr>
<td><span class="style7">Nyheder</span></td>
<td><span class="style14">7</span></td>
</tr>
</table> <p align="center" class="style9"> </p></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="80"> </td>
</tr>
</table></td>
</tr>
</table>
<p align="center"> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rsBrugere1);
mysql_free_result($rsBrugere2);
mysql_free_result($rsBrugere4);
mysql_free_result($rsBrugere5);
mysql_free_result($rsBrugere6);
mysql_free_result($rsBrugere7);
mysql_free_result($rsBrugere3);
?>