Jump to content
MakeWebGames

two errors on two different page need help

modernmafia

By modernmafia
in PHP

 Share

Recommended Posts

modernmafia Newbie

modernmafia

Posted
Posted

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/sitename/public_html/s4/Notifications.php on line 46

 

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/modernma/public_html/s4/viewprofile.php on line 365

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/modernma/public_html/s4/viewprofile.php on line 367

 

can any one tell me why im getting them and any way of resolving them

modernmafia Newbie

modernmafia

Posted
  • Author
Posted

view profile

 

<?php include"mainmenu.php"; ?>

<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script>
<script type="text/javascript" src="js/lightbox.js"></script>

<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=topleft NOWRAP>
</td>
<td class=leftbar NOWRAP>
</td>
<td class=bar NOWRAP>

</td>
<td class=rightbar NOWRAP>
</td>
<td class=topright NOWRAP>
</td>
</tr>
</tbody>
</table>
<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=left NOWRAP>
</td>
<td class=main>
<div align="left">



<?php
include"bb.php";

// get value of id that sent from address bar 
$user=$_GET['viewuser'];
$id=ucfirst(strtolower(mysql_real_escape_string(htmlentities($user))));

$sql="SELECT * FROM users WHERE username='$id'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);

$online = $rows['online'];
$online5 = $rows['onlinetime2'];
$online6 = $rows['onlinetime3'];


$susername = $rows['username'];
$numtoactivate = $rows['numbertoactivate'];

if($id=="Tyler"){
if( $tylerkilled>=3 ){ $stat="Dead"; }else{ $stat="Alive"; }
}elseif ($id=="David"){
if( $davidkilled>=3 ){ $stat="Dead"; }else{ $stat="Alive"; }
}elseif ($id=="Natasha"){
if( $mission>=5 ){ $stat="Dead"; }else{ $stat="Alive"; }
}else{
$stat=$rows['status'];
}


$post = str_replace("/", "", $post); 


$udjrank=$rows['djrank'];	
$usercrewlevel = $rows['crewlevel'];
$uuserlevel = $rows['userlevel'];
$ustafflevel = $rows['stafflevel'];
$uentertainerlevel = $rows['entertainerlevel'];
$rmessages = $rows['rmessages'];

$ucrew = $rows['crew'];
$umessages = $rows['messages'];
$uquote = $rows['quote'];

$showcars=$rows['showcars'];
$viewstatus=$rows['status'];
$uip = $rows['lastloginip'];

$uapperoffline=$rows['apperoffline'];	
$ucash=$rows['cash'];	
$ucash2=number_format($rows['cash']);		
$urank=$rows['rank'];		
$video=$rows['video'];
$autoplay=$rows['autoplay'];
$ucrewlevel=$rows['crewlevel'];	

$uprestige = $rows['prestige'];

$uippoints = $rows['ippoints'];
$ubank= $rows['bank'];
$uswissbank= $rows['swissbank'];
$uprotection= $rows['protection'];
$ugun = $rows['gun'];
$ubullets = $rows['bullets'];
$ucountry = $rows['country'];
$upoints = $rows['points'];
$uhealth = $rows['health'];
$uonlinetime = $rows['onlinetime'];
$usvest = $rows['specialvest'];
$uhda = number_format($rows['tickets']);
$ushowkills = $rows['showkills'];
$ushowbusts = $rows['showbusts'];
$utkills = number_format($rows['totalkills']);
$utbusts = number_format($rows['totalbusts']);
$aavail=$rows['avail'];

$uactpo = number_format($rows['activitypoints']);


$onlinet = time() - 700; //the current time minus 1 minute


$sql2="SELECT * FROM crews WHERE name='$ucrew'";
$result2=mysql_query($sql2);
while($rows=mysql_fetch_array($result2)){ // Start looping table row  
$crewid = $rows['id'];
}//loop end

$sql3="SELECT * FROM messages WHERE t='$id'";
$result3=mysql_query($sql3);
$nummessages=mysql_num_rows($result3);

?>

<table width="100%" cellspacing="2" cellpadding="2" style=" border-bottom: 0px solid #3D4456; border-left: 0px solid #7885A7; border-right: 0px solid #3D4456; border-top: 0px solid #6F7B9A; ">

<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Name:</b> </font><a href="Send.php?sendto=<?php echo $id; ?>"><font color="#999999"><?php echo"$id"; ?></font></a></td></tr>

<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><?php if($ucrewlevel!=9){ echo "<b>Crew</b>"; }else{ echo "<b>Boss Of</b>"; } ?>: <?php if($ucrew==None){echo "None";}else{echo "<a href='viewcrewprofile.php?id=$crewid'><font color=#999999>$ucrew</font></a>";} ?> </font></td></tr>


<?php
if($uuserlevel>="4" or $ustafflevel>="9" or $uentertainerlevel>="9"){


$sql= mysql_query("SELECT * FROM users WHERE username='$susername' LIMIT 1"); 
$i = mysql_fetch_object($sql);
if($i->userlevel=="16"){
$echo = "<b>Unknown</b>";
}elseif ($i->userlevel>="14"){
$echo = "<b>Administrator</b>";
}elseif ($i->userlevel>="9"){
$echo = "<b>Staff Manager</b>";
}elseif ($i->userlevel>="4"){
$echo = "<b>HDO Manager</b>";
}elseif ($i->entertainerlevel>="9"){
$echo = "<b>Entertainer Manager</b>";
}elseif ($i->stafflevel>="9"){
$echo = "<b>Moderator</b>";
}elseif ($i->djrank>="2"){
$echo = "<b>Semi HDO</b>";
}else{
$echo = "$urank";
}


echo "<tr><td bgcolor='$tabcolor'> <font color='#999999'><b>Rank:</b> 
$echo
";

if($uprestige > "0"){

echo " (<font color=lime><b>$uprestige</b></font>)";

}

echo "</td></tr>";


if($usvest>="1"){
?>

<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Vest:</b> <?php if($usvest=="1"){ echo "Light Military"; }elseif($usvest=="2"){ echo "Medium Military"; }else{ echo "Heavy Military"; }?></font></td></tr>


<?php
}
?>


<?php
if($i->userlevel>="3" && $i->userlevel<="7"){
?>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Helpdesk Tickets Answered:</b> <?php echo "$uhda"; ?></font></td></tr>
<?php
}
?>
<?php
}else{
?>

<?php 
if ($uentertainerlevel >= "4" && $uentertainerlevel <= "7"){ $wealth="£$ucash2"; }
elseif ($ucash < "2"){ $wealth = "Broke"; }
elseif ($ucash >= "2" && $ucash < "500000"){ $wealth = "Very Poor"; }
elseif ($ucash >= "500000" && $ucash < "1000000"){ $wealth = "Poor"; }
elseif ($ucash >= "1000000" && $ucash < "5000000"){ $wealth = "Rich"; }
elseif ($ucash >= "5000000" && $ucash < "10000000"){ $wealth = "Very Rich"; }
elseif ($ucash >= "10000000" && $ucash < "50000000"){ $wealth = "Extremely Rich"; }
elseif ($ucash >= "50000000" && $ucash < "999999999"){ $wealth = "Infamously Rich"; }
elseif ($ucash >= "1000000000"){ $wealth = "Suspected Billionaire"; }

?>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Wealth:</b> <?php echo"$wealth"; ?></font></td></tr>

<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Rank:</b> 
<?php 

if($uentertainerlevel>="3"){
$echo = " $urank / <b>Entertainer</b>";
}
elseif($udjrank>="2"){
$echo = " $urank / <b>Semi HDO</b>";
}
elseif($ustafflevel>="3"){
$echo = " $urank / <b>Help Desk Operator</b>";

}else{
$echo = "$urank";
}
echo "$echo";


if($uprestige > "0"){

echo " (<font color=lime><b>$uprestige</b></font>)";


}

echo "</td></tr>";



if($usvest>="1"){
?>

<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Vest:</b> <?php if($usvest=="1"){ echo "Light Military"; }elseif($usvest=="2"){ echo "Medium Military"; }else{ echo "Heavy Military"; }?></font></td></tr>

<?php
}

?>


</tr><tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Status:</b> <?php echo "$stat"; ?><?php if ($online5 > $onlinet && $uapperoffline!='2')
{echo " (<font color=lime>Online</font>)";}else{echo " (<font color=red>Offline</font>)";} ?> / (<?php
if($aavail == "1"){ ?><font color="lime">Available</font><?php }elseif($aavail == "2"){ ?><font color="Orange"><b>Away</b></font><?php }elseif($aavail == "3"){ ?><font color="Blue"><b>Busy</b></font><?php }elseif($aavail == "4"){ ?><font color="red"><b>Not Available.</b></font><?php }else{ ?>error<?php } ?>
)</font></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Messages sent:</b> <?php echo "$umessages"; ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Messages received:</b> <?php echo "$rmessages"; ?></font></td></tr>


<?php
if($ushowkills=="1"){
?>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Total Kills:</b> <?php echo "$utkills"; ?></font></td></tr>
<?php
}
?>
<?php
if($ushowbusts=="1"){
?>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Total Busts:</b> <?php echo "$utbusts"; ?></font></td></tr>
<?php
}
?>


<?php
if($ustafflevel>="3" && $ustafflevel<="7"){
?>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><b>Helpdesk Tickets Answered:</b> <?php echo "$uhda"; ?></font></td></tr>
<?php
}
?>

<?php
}
?>

<?php
if ($userlevel >= 4 or $entertainerlevel >= 9 or $stafflevel >= 8)
{ ?>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Ip Address: <?php echo "$uip"; ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Penalty Points: <?php echo number_format($uippoints); ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Bank Money: $<?php echo number_format($ubank); ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Swiss Bank Money: $<?php echo number_format($uswissbank); ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Money On Hand: $<?php echo number_format($ucash); ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Points: <?php echo number_format($upoints); ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Bullets: <?php echo number_format($ubullets); ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Protection: <?php echo "$uprotection"; ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Gun: <?php echo "$ugun"; ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Country: <?php echo "$ucountry"; ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Health: <?php echo "$uhealth"; ?>%</font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Last Active: <?php echo "$uonlinetime"; ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Activity Points: <?php echo "$uactpo"; ?></font></td></tr>
<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999">Activation Code: <?php echo "$numtoactivate"; ?></font></td></tr>
<?php
}
?>

    <? 
$result1 = mysql_query("SELECT * FROM ccars WHERE owner='".mysql_real_escape_string($id)."' AND profile='1' ORDER BY id DESC ") or die("ERROr");
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result1 )) {

$id1 = $row['id'];
$carname1 = $row['name'];
$super = $row['super'];
$biggin = $row['biggin'];
?>

<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><a href="viewcustomcar.php?carid=<? echo $id1; ?>"><?php echo "<b>$biggin:</b>"; ?> <?php echo "$carname1"; ?></a></font></td></tr>

  <?php }// while loop ?>




	          <? 
$result = mysql_query("SELECT * FROM cars WHERE owner='".mysql_real_escape_string($id)."' AND profile='1' ORDER BY type ASC ") or die("ERROr");
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {

$id = $row['id'];
$type = $row['type'];
$damage = $row['damage'];

if($type=="1"){$carname = $car_1;}
if($type=="2"){$carname = $car_2;}
if($type=="3"){$carname = $car_3;}
if($type=="4"){$carname = $car_4;}
if($type=="5"){$carname = $car_5;}
if($type=="6"){$carname = $car_6;}
if($type=="7"){$carname = $car_7;}
if($type=="8"){$carname = $car_8;}
if($type=="9"){$carname = $car_9;}
if($type=="10"){$carname = $car_10;}
if($type=="11"){$carname = $car_11;}
if($type=="12"){$carname = $car_12;}
if($type=="13"){$carname = $car_13;}
if($type=="14"){$carname = $car_14;}

$firstcolor="#222222";


?>

<tr><td bgcolor="<?php echo $tabcolor ?>"> <font color="#999999"><a href="viewcar.php?carid=<? echo $id; ?>"><?php echo "<b>$carname</b>"; ?></a></font></td></tr>

  <?php }// while loop ?>
    </table>

<table width="100%">
<br>
<?php echo inboxbb($uquote); ?>

<?php
$kids = mysql_query("SELECT * FROM plikes WHERE user='$susername'");
$numlike = mysql_num_rows($kids);
$kids2 = mysql_query("SELECT * FROM dlikes WHERE user='$susername'");
$numdlike = mysql_num_rows($kids2);
?>
<?php
///////////Kyle don't change none of this :) /////
$com=mysql_real_escape_string(strip_tags($_GET['command']));
if($com == "like"){ 
if($susername == $usernamep){
echo "You can not rate your self!";
}else{
$checkerll = mysql_query("SELECT * FROM plikes WHERE user='$susername' AND liker='$username'");
$checkerl = mysql_affected_rows($checkerll);
if($checkerl > '0'){ 
echo "";
}else{
mysql_query("DELETE FROM dlikes WHERE user='$susername' AND liker='$username'");
mysql_query("INSERT INTO `plikes` ( `id` , `user` , `liker` ) VALUES ('', '$susername', '$username')");	
echo "liked";
}}}
if($com == "dlike"){ 
if($susername == $usernamep){
echo "You can not rate your self!";
}else{
$checkerll = mysql_query("SELECT * FROM dlikes WHERE user='$susername' AND liker='$username'");
$checkerl = mysql_affected_rows($checkerll);
if($checkerl > '0'){ 
echo "";
}else{
mysql_query("DELETE FROM plikes WHERE user='$susername' AND liker='$username'");
mysql_query("INSERT INTO `dlikes` ( `id` , `user` , `liker` ) VALUES ('', '$susername', '$username')");	
echo "Dis Liked";
}}}
?>

<br></table>
<?php
if ($uentertainerlevel >= "4"){
?>
<center>
<br><br>
<table width="35%" cellspacing="2" cellpadding="2" style="border-bottom: 0px solid #3D4456; border-left: 0px solid #7885A7; border-right: 0px solid #3D4456; border-top: 0px solid #6F7B9A;">
		<tr>
			<td>
			<div class=CM></div> 
               <div class=tab>Last 25 Sent:</div> 
               <div class=CM></div> 
			</td>
		</tr>

<?php

//desplay data

$get = mysql_query("SELECT * FROM transfers WHERE sender='$susername'ORDER BY id DESC LIMIT 0 , 25");
while($row = mysql_fetch_assoc($get))
{
//get data
$reciever = $row['reciever'];
$amount = number_format($row['amount']);

?>



<tr>
<td bgcolor="<?php echo "$tabcolor"; ?>" align="center">
<font color="#999999">
<div align="center" class="tab"> You sent £<?php echo $amount ?> to <a href="viewprofile.php?viewuser=<?php echo $reciever ?>"><font color="#999999"><?php echo $reciever ?></font></a>.</font></div>
</td>
</tr>

<?php
}
?>



</table>

<br>	
<table width="35%" cellspacing="2" cellpadding="2">
	<br>
			<td>
			<div class=CM></div> 
               <div class=tab>Last 25 Received:</div> 
               <div class=CM></div> 




	</td>
                                  </tr>


<?php

//desplay data

$get = mysql_query("SELECT * FROM transfers WHERE reciever='$susername'ORDER BY id DESC LIMIT 0 , 25");
while($row = mysql_fetch_assoc($get))
{
//get data
$from = $row['sender'];
$amount = number_format($row['amount']);

?>



<tr>
<td bgcolor="<?php echo "$tabcolor"; ?>" align="center">
<font color="#999999">
<div align="center" class="tab"> You received £<?php echo $amount ?> from <a href="viewprofile.php?viewuser=<?php echo $from ?>"><font color="#999999"><?php echo $from ?></font></a>.</font></div>
</td>
</tr>

</center>

<?php
}
?>

	</table>


<?php
}
?>
<center><br><font color=lime><b><?php echo $numlike ?></b></font> - <font color=red><b><?php echo $numdlike ?></b></font><br><a href="viewprofile.php?viewuser=<?php echo $susername ?>&command=like"><img src="http://suspectedgangsters.com/smiles/tup.gif"></a> - <a href="viewprofile.php?viewuser=<?php echo $susername ?>&command=dlike"><img src="http://suspectedgangsters.com/smiles/tdown.gif"></a></center>

</div>
</td>
<td class=right NOWRAP>
</td>
</tr>
</Tbody>
</table>


<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=bottomleft NOWRAP>
</td>
<td class=bottom NOWRAP>
</td>
<td class=bottomright NOWRAP>
</td>
</tr>
</tbody>
</table>











<?
if ($userlevel >= 4 or $stafflevel >= 4 or $entertainerlevel >= 9)
{
?>



<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=topleft NOWRAP>
</td>
<td class=leftbar NOWRAP>
</td>
<td class=bar NOWRAP>

</td>
<td class=rightbar NOWRAP>
</td>
<td class=topright NOWRAP>
</td>
</tr>
</tbody>
</table>
<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=left NOWRAP>
</td>
<td class=main>
<div align="center">


Staff Tools:
<?php
$id=ucfirst(strtolower(mysql_real_escape_string(htmlentities($user))));
?>

<?
if ($userlevel >= 4 or $stafflevel >= 4 or $entertainerlevel >= 9)
{
?>


<form action="unmute.php" method="post">
<input name="unmute_name" type="hidden" value="<?php echo "$id"; ?>" class="tbox">
<input name="mute" type="submit" value="Mute" class="tbox">
</form>


<form action="messagemute.php" method="post">
<input name="unmute_name" type="hidden" value="<?php echo "$id"; ?>" class="tbox">
<input name="mute" type="submit" value="Mute From Messages" class="tbox">
</form>

<form action="sentmessage.php" method="post">
<input name="readusername" type="hidden" value="<?php echo "$id"; ?>" class="tbox">
<input name="read" type="submit" value="View Sent Messages" class="tbox">
</form>


<form action="usersmessages.php" method="post">
<input name="readusername" type="hidden" value="<?php echo "$id"; ?>" class="tbox">
<input name="read" type="submit" value="View Recieved Messages" class="tbox">
</form>

<?php
}
?>



<?
if ($userlevel >= 4 or $stafflevel >= 8)
{
?>

<br>

<form action="transfers.php" method="post">
<input name="viewusername" type="hidden" value="<?php echo "$id"; ?>" class="tbox">
<input name="View" type="submit" value="View Money transfers" class="tbox">
</form>

<form action="transfers.php" method="post">
<input name="viewusername" type="hidden" value="<?php echo "$id"; ?>" class="tbox">
<input name="View" type="submit" value="View Money transfers" class="tbox">
</form>
<?php
if ($_POST['clear']){
$frog = "<center>Profile has been cleared by $username!</center>";
mysql_query("UPDATE users SET quote='$frog', points='0', cash='0', swissbank='0', bank='0' WHERE username='$susername'");
mysql_query("INSERT INTO `notify` ( `id` , `t` , `f` , `message` ) VALUES ('', 'iVeNoMoUs', 'iVeNoMoUs', '$username has just cleared $susername's profile!')");
mysql_query("INSERT INTO `notify` ( `id` , `t` , `f` , `message` ) VALUES ('', 'CrAcK', 'CrAcK', '$username has just cleared $susername's profile!')");
mysql_query("UPDATE users SET mail='0' WHERE username='iVeNoMoUs'");
mysql_query("UPDATE users SET mail='0' WHERE username='CrAcK'");

echo "You have cleared $susername's profile!";
}
?>
<form action="" method="post">

 <input name="clear" type="submit" class="tbox" id="clear" value="Clear Profile">
</form>

<form action="trackip.php" method="post">
<input name="readusername" type="hidden" value="<?php echo "$id"; ?>" class="tbox">
<input name="read" type="submit" value="IP Track" class="tbox">
</form>



<form action="Ban_user.php" method="post">
<input name="ban_name" type="hidden" value="<?php echo "$id"; ?>" class="tbox">
<input name="ban" type="submit" value="Ban user" class="tbox">
</form>


<br><form action="Modkill.php" method="post">
<input name="kill_name" type="hidden" value="<?php echo "$id"; ?>" class="tbox">
Reason:
<br>
<textarea name="kill_reason" class="tbox">
</textarea>
<br>
<input name="kill" type="submit" value="Modkill user" class="tbox">
</form>


<?php
}
?>



</div>
</td>
<td class=right NOWRAP>
</td>
</tr>
</Tbody>
</table>


<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=bottomleft NOWRAP>
</td>
<td class=bottom NOWRAP>
</td>
<td class=bottomright NOWRAP>
</td>
</tr>
</tbody>
</table>

<?php
}
?>










<?php include"playerstats.php"; ?>
modernmafia Newbie

modernmafia

Posted
  • Author
Posted

Notification

 

<?php include"mainmenu.php"; ?>

<center>
<form action="" method="post">
<input name="clear" class="tbox" type="submit" value="Clear Notifications">
</form>
</center><br><br>


<?php



$clear = $_POST['clear'];
if($clear) {

mysql_query("DELETE FROM notify WHERE t='$username'") 
or die(mysql_error());  


}



$delete = mysql_real_escape_string($_GET['id']);
if($delete) {


$sql = "DELETE FROM notify WHERE id=$delete AND t='$username'";
$result = mysql_query($sql);


}





include("bb.php");


$sql2="SELECT * FROM notify WHERE t='$username' ORDER BY id DESC LIMIT 0,15";


$result2=mysql_query($sql2);
while($rows2=mysql_fetch_array($result2)){ // Start looping table row 

$id2=$rows2['id'];
$name = $rows2['f'];
$message = inboxbb($rows2['message']);
?>
<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=topleft NOWRAP>
</td>
<td class=leftbar NOWRAP>
</td>
<td class=bar NOWRAP>

</td>
<td class=rightbar NOWRAP>
</td>
<td class=topright NOWRAP>
</td>
</tr>
</tbody>
</table>
<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=left NOWRAP>
</td>
<td class=main>
<center>
<?php echo $message ?>
<br>
<hr>
</center>
</div>
</DIV>
<DIV class=smalltext style="TEXT-ALIGN: center">
</DIV>

</td>
<td class=right NOWRAP>
</td>
</tr>
</Tbody>
</table>


<table cellSpacing=0 cellPadding=0 style="WIDTH: 100%">
<Tbody>
<tr>
<td class=bottomleft NOWRAP>
</td>
<td class=bottom NOWRAP>
</td>
<td class=bottomright NOWRAP>
</td>
</tr>
</tbody>
</table>

<br>

<?
}

mysql_query("UPDATE notify SET r='1' WHERE t='$username'");
?>





<?php include"playerstats.php"; ?>

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...