Wankness123 Posted February 4, 2012 Share Posted February 4, 2012 Okay so im making a user management system, and i want to make it where i can see the users items. this is what i have so far: <?php /* Copyright (C) 2009 Murad <Murawd> Josh L. <Josho192837> This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ // Must rewrite if($_SESSION['id']){ if($_SESSION['admin']){ if(isset($_GET['name, gm, nxc, mp, nxp, wa'])){ $name = mysql_real_escape_string($_GET['name']); $gm = mysql_real_escape_string($_GET['gm']); $nxc = mysql_real_escape_string($_GET['nxCredit']); $mp = mysql_real_escape_string($_GET['maplePoint']); $nxp = mysql_real_escape_string($_GET['nxPrepaid']); $wa = mysql_real_escape_string($_GET['webadmin']); $ga = mysql_query("SELECT * FROM `accounts` WHERE `id` LIKE '%".getInfo('accid', $name, $gm, $nxc, $mp, $nxp, $wa. 'profilename')."%'") or die(mysql_error()); $a = mysql_fetch_array($ga); echo " <table border='0' style=\"height:100%;width:570px;border:solid 1px #BBB\"> <tr class=\"navtitle\" style=\"height:100px\"> <th style=\"width:auto\">Mute A User From Posting - ".$gm."</th> </tr>"; if(!isset($_POST['mute'])){ echo " <tr> <tr> <td align=\"center\" class=\"tdbox\"> <a href=\"?cype=admin&page=muteuser\">Search for another user.</a> </td> </tr> <td align=\"center\"> <form method=\"post\" action=''> <table border=\"0\" width=\"100%\"> <tr> <td align=\"right\" width=\"50%\"> <b>Username:</b> </td> <td>".$a['name']."</td> </tr> <tr> <td align=\"right\"> <b>Profile name:</b> </td> <td>".$name."</td> </tr> <tr> <td align=\"right\"> <b>Is GM?(1=y 0=n):</b> </td> <td>".$gm."</td> </tr> <tr> <td align=\"right\"> <b>NxCredit:</b> </td> <td>".$nxc."</td> </tr> <tr> <td align=\"right\"> <b>MaplePoints:</b> </td> <td>".$mp."</td> </tr> <tr> <td align=\"right\"> <b>NxPrepaid:</b> </td> <td>".$nxp."</td> </tr> <tr> <td align=\"right\"> <b>Is WebAdmin?:</b> </td> <td>".$wa."</td> </tr> <tr> <td align=\"right\"> <b>Mute:</b> </td> <td> <select name=\"dec\"> <option value=\"0\">No</option> <option value=\"1\">Yes</option> </select> </td> </tr> <tr> <td colspan=\"2\" align=\"center\"> <input type=\"submit\" name=\"mute\" value=\"Mute\" /> </td> </tr> </table> </form> </td> </tr>"; }else{ $dec = mysql_real_escape_string($_POST['dec']); if($dec == "0"){ echo " <tr> <td align=\"center\" class=\"tdbox\"> Optioned Selected: <b>No</b>. User was <b>not</b> muted. </td> </tr> <tr> <td align=\"center\"> <a href=\"?cype=admin&page=muteuser&name=".$_GET['name']."\">Back</a> </td> </tr>"; }elseif($a['gm']=="1"){ echo " <tr> <td align=\"center\" class=\"tdbox\"> User is a GameMaster and was <b>not</b> muted. </td> </tr> <tr> <td align=\"center\"> <a href=\"?cype=admin&page=muteuser&name=".$_GET['name']."\">Back</a> </td> </tr>"; }else{ $u = mysql_query("UPDATE `accounts` SET `mute`='1' WHERE `id`='".getInfo('accid', $name, 'profilename')."'") or die(mysql_error()); echo " <tr> <td align=\"center\" class=\"tdbox\"> <b>".$name."</b> has been muted from the community. </td> </tr> <tr> <td align=\"center\"> <a href=\"?cype=admin&page=muteuser\">Mute another user.</a> </td> </tr>"; } } echo " <tr style=\"height:25px\"> <td class=\"tdbox\"> <span style=\"float:left\"> <a href=\"?cype=admin\">Back To Administration Control Panel</a> </span> <span style=\"float:right\"> <a href=\"?cype=admin&page=unmuteuser\">Unmute User</a> </span> </td> </tr> </table>"; }else{ echo " <table border='0' style=\"height:100%;width:570px;border:solid 1px #BBB\"> <tr class=\"navtitle\" style=\"height:25px\"> <th style=\"width:auto\">Mute A User From Posting</th> </tr>"; if(!isset($_POST['search'])){ echo " <tr> <td align=\"center\" class=\"tdbox\"> Search for the profile name you wish to mute. </td> </tr>"; }else{ $search = mysql_real_escape_string($_POST['name']); if($search == ""){ echo " <tr> <td align=\"center\" class=\"tdbox\"> You cannot leave the search field blank. </td> </tr>"; }else{ $ga = mysql_query("SELECT * FROM `cype_profile` WHERE `name` LIKE '%".$search."%' ORDER BY `name` ASC") or die(mysql_error()); while($a = mysql_fetch_array($ga)){ echo " <tr> <td align=\"center\" class=\"tdbox\"> <a href=\"?cype=admin&page=muteuser&name=".$a['name']."\">".$a['name']."</a><br /> </td> </tr>"; } } } echo " <tr> <td align=\"center\"> <form method=\"post\" action=''> <input type=\"text\" name=\"name\" /> <input type=\"submit\" name=\"search\" value=\"Search\" /> </form> </td> </tr>"; echo " <tr style=\"height:25px\"> <td class=\"tdbox\"> <span style=\"float:left\"> <a href=\"?cype=admin\">Back To Administration Control Panel</a> </span> <span style=\"float:right\"> <a href=\"?cype=admin&page=unmuteuser\">Unmute User</a> </span> </td> </tr> </table>"; } }else{ include('sources/public/accessdenied.php'); } }else{ echo "Please log in to use this feature."; } ?> There is no errors, but it wont show the other things, this is all it shows: So can you tell me why my other things are not poping up? Quote Link to comment https://forums.phpfreaks.com/topic/256413-need-help-with-php-and-mysql/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.