127 lines
3.6 KiB
PHP
127 lines
3.6 KiB
PHP
<?php
|
|
|
|
require("function.php");
|
|
require("layout.php");
|
|
|
|
//Eww, this is gross.
|
|
$perms=mysqli_query($con,"SELECT users.id,users.name,permissions.user,permissions.permission FROM users INNER JOIN permissions ON users.id=permissions.user");
|
|
$logperms=mysqli_query($con,"SELECT users.id,users.name,permissions.user,permissions.permission FROM users INNER JOIN permissions ON users.id=permissions.user AND users.id=$loguserid");
|
|
$modperms=mysqli_query($con,"SELECT users.id,users.name,permissions.user,permissions.permission FROM users INNER JOIN permissions ON users.id=permissions.user AND users.id=$loguserid AND permissions.permission='Moderator'");
|
|
$adminperms=mysqli_query($con,"SELECT users.id,users.name,permissions.user,permissions.permission FROM users INNER JOIN permissions ON users.id=permissions.user AND users.id=$loguserid AND permissions.permission='Admin'");
|
|
$dummyperms=mysqli_query($con,"SELECT users.id,users.name,permissions.user,permissions.permission FROM users INNER JOIN permissions ON users.id=permissions.user AND users.id=$loguserid AND permissions.permission='Dummy'");
|
|
|
|
|
|
print $header;
|
|
|
|
//Used to test handling of id/password mismatch. Currently works for old login system
|
|
if($_GET['blankpassword']){
|
|
print "<br>$tblstart
|
|
$tccell1 Your password has been blanked while your userid has been retained. If you are logged in, attempting to click another page should result in an authentication fail.
|
|
$tblend";
|
|
setcookie ("logpassword","");
|
|
}
|
|
|
|
//Begin debug menu
|
|
print"$smallfont Logged-in user info.
|
|
$tblstart
|
|
$tccellh </td>
|
|
$tccellh </td></tr><tr>
|
|
$tccell1 Your user id</td>
|
|
$tccell2 $loguserid</td></tr>
|
|
$tblend<br><br>
|
|
|
|
$smallfont List of permissions and their respective users.
|
|
$tblstart
|
|
$tccellh User</td>
|
|
$tccellh Permission</td></tr>";
|
|
|
|
//Permissions aren't finished
|
|
while($row = mysqli_fetch_array($perms)) {
|
|
print "<tr>
|
|
$tccell1"."$row[name]</td>
|
|
$tccell2"."$row[permission]</td></tr>
|
|
";
|
|
}
|
|
print "$tblend<br>$tblstart
|
|
$tccellh"."Logged in user has these permissions</td></tr>";
|
|
|
|
//Only show logged in user's permissions if they are actually /logged in/
|
|
if($loguserid) {
|
|
while($row = mysqli_fetch_array($logperms)) {
|
|
print"<tr>
|
|
$tccell1 $row[permission]</td></tr>";
|
|
}
|
|
}
|
|
|
|
print "</table></td></table><br>
|
|
<table border=0 bgcolor=$tableborder width=$tablewidth align=center cellpadding=0 cellspacing=0>
|
|
<td>
|
|
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=$tableborder>
|
|
$tccellh"."Logged in user is Moderator</td></tr>
|
|
";
|
|
if($loguserid && mysqli_num_rows($modperms)) {
|
|
print"<tr>
|
|
$tccell1"."Yes</td>
|
|
</tr>
|
|
|
|
";
|
|
|
|
} else {
|
|
print"<tr>
|
|
$tccell1"."No</td>
|
|
</tr>
|
|
|
|
";
|
|
|
|
}
|
|
|
|
print "</table></td></table><br>
|
|
<table border=0 bgcolor=$tableborder width=$tablewidth align=center cellpadding=0 cellspacing=0>
|
|
<td>
|
|
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=$tableborder>
|
|
$tccellh"."Logged in user is Admin</td></tr>
|
|
";
|
|
if($loguserid && mysqli_num_rows($adminperms)) {
|
|
print"<tr>
|
|
$tccell1"."Yes</td>
|
|
</tr>
|
|
|
|
";
|
|
|
|
} else {
|
|
print"<tr>
|
|
$tccell1"."No</td>
|
|
</tr>
|
|
|
|
";
|
|
|
|
}
|
|
print "</table></td></table><br>
|
|
<table border=0 bgcolor=$tableborder width=$tablewidth align=center cellpadding=0 cellspacing=0>
|
|
<td>
|
|
<table border=0 cellpadding=2 cellspacing=1 width=100% bgcolor=$tableborder>
|
|
$tccellh"."Logged in user is a mere pawn used for testing</td></tr>
|
|
";
|
|
if($loguserid && mysqli_num_rows($dummyperms)) {
|
|
print"<tr>
|
|
$tccell1"."Yes</td>
|
|
</tr>
|
|
|
|
";
|
|
|
|
} else {
|
|
print"<tr>
|
|
$tccell1"."No</td>
|
|
</tr>
|
|
|
|
";
|
|
|
|
}
|
|
|
|
print "</table></td></table><br><center>$fonttag<a href=debug.php?blankpassword=1>Set logpassword blank</a></center>";
|
|
|
|
|
|
|
|
print "$footer <br>";
|
|
rendertime();
|
|
?>
|