Link added to database with ID

Enter the http:// link

$otherlevel){ $query2 = "UPDATE users set level='-1' where username='$realuser'"; mysql_query($query2); //check for ban $query3 = "SELECT * from users where username='$realuser' AND level='-1'"; $res2 = mysql_query($query3); $num = mysql_num_rows($res2); if($num == 1){ echo "$realuser has been banned! With reason '$reason'"; $querygood = "INSERT INTO admin_logs (admin, action, member, changed_info, date, reason) VALUES ('$adminuser','Banned','$realuser','Accepted','$time','$reason')"; mysql_query($querygood); } else { error("Invalid information", "User could not be banned"); } } else { $querybad = "INSERT INTO admin_logs (admin, action, member, changed_info, date,reason) VALUES ('$adminuser','Attempted to ban','$realuser','Declined','$time','')"; mysql_query($querybad); error("Invalid information", "You cannot ban this person",true); } } } } ?>

Enter a username to ban:
Reason:

$otherlevel){ $query2 = "UPDATE users set level='0' where username='$realuser'"; mysql_query($query2); //check for ban $query3 = "SELECT * from users where username='$realuser' AND level='0'"; $res2 = mysql_query($query3); $num = mysql_num_rows($res2); if($num == 1){ $querygood = "INSERT INTO admin_logs (admin, action, member, changed_info, date, reason) VALUES ('$adminuser','Unbanned','$realuser','Accepted','$time','')"; mysql_query($querygood); echo "$realuser has been unbanned"; } else { error("Cannot do action", "Could not ban $realuser"); } } else { $querybad = "INSERT INTO admin_logs (admin, action, member, changed_info, date,reason) VALUES ('$adminuser','Tried to unban','$realuser','Declined','$time')"; mysql_query($querybad); error("Incorrect information", "Could not ban user", true); } } } } ?> Username"; if(!isset($_GET["pagenumb"])){ $page = 1; } else { $page = $_GET["pagenumb"]; } $max_results = 10; $from = (($page * $max_results) - $max_results); $query = "SELECT * FROM users ORDER BY date_reg DESC LIMIT $from, $max_results"; $exec = mysql_query($query) or die(mysql_error()); $num = mysql_num_rows($exec); while($row = mysql_fetch_array($exec)){ echo "".$row["username"]."\n"; } $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM users"),0); // Figure out the total number of pages. Always round up using ceil() $total_pages = ceil($total_results / $max_results); echo "

Select A Page

"; if($page > 1) { $prev = ($page - 1); echo "< "; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i) { echo $i." "; } else { echo "$i "; } } if($page < $total_pages) { $next = ($page + 1); echo ">"; } print"

"; echo ""; endpage(); break; case "view_user"; startpage("View user"); $theuser = addslashes($_GET["user"]); if ($theuser != ""){ $query = "SELECT * FROM users WHERE username = '$theuser'"; $exec = mysql_query($query); $rows = mysql_fetch_array($exec); echo "Username: ".$rows["username"]."
"; echo "First name: ".$rows["firstname"]."
"; echo "Last name: ".$rows["lastname"]."
"; echo "Email: ".$rows["email"]."
"; echo "Level: ".$rows["level"]."
"; echo "Date joined: ".date("d-n-Y g:i:s A", $rows["date_reg"])."
"; echo "Last login: ".date("d-n-Y g:i:s A",$rows["last_login"])."
"; echo "IP: ".$rows["ip"]."
"; echo "Points: ".$rows["points"]."

"; $md5pass = $rows["password"]; } ?>

AdminActionUserInfo ChangedDateReason"; //$query = "SELECT * from admin_logs ORDER BY date DESC LIMIT $from, $max_results"; $res = mysql_query("SELECT * from admin_logs ORDER BY date DESC LIMIT $from, $max_results"); //$num = mysql_num_rows($res); while($row = mysql_fetch_array($res)){ echo " ".$row["admin"]."".$row["action"]."".$row["member"]."".$row["changed_info"]."".date("d-n-Y g:i:s A", $row["date"])."".$row["reason"]."\n"; } // Figure out the total number of results in DB: $total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM admin_logs"),0); // Figure out the total number of pages. Always round up using ceil() $total_pages = ceil($total_results / $max_results); echo "

Select A Page

"; echo ""; print ""; endpage(); break; case "make_news"; startpage("Make news"); ?>

OR you can submit a random quote..

"; for($i=1; $i <= $num; $i++){ $row = mysql_fetch_array($res); if ($row["username"] != ""){ echo "".$row["username"]."\n"; } } } echo ""; } ?>

ALL ACTIONS ARE LOGGED!

View all users
\n Ban a user
\n unBan a user
\n Search\n"; if ($adminlevel == 2){ echo "

Level 2 Menu:
Upgrade a User\n
View Admin panel logs\n
Make a news item\n"; } echo "

Home"; endpage(); break; } } ?>

Username:	" />
Firstname:	" />
Lastname:	" />
Email:	" />
Level:
IP:	" />
Date Registered:	" />
Last Login:	" />

News Subject:
News Body: