Jump to content

Need help with PHP and MySQL


Wankness123

Recommended Posts

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:

 

JaCYXd.png

 

So can you tell me why my other things are not poping up?

Link to comment
https://forums.phpfreaks.com/topic/256413-need-help-with-php-and-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.