view profile 2

<style type="text/css">
.max {
	max-width: 598px;
	/* Resize the image for IE6 */
	width: expression(this.width > 598 ? 598: true);
}
</style>
<?php




$a = mysql_fetch_assoc(mysql_query("SELECT * FROM location")) or die(mysql_error());
$a1 = mysql_fetch_assoc(mysql_query("SELECT * FROM location WHERE id=2")) or die(mysql_error());
$a2 = mysql_fetch_assoc(mysql_query("SELECT * FROM location WHERE id=4")) or die(mysql_error());
$a4 = mysql_fetch_assoc(mysql_query("SELECT * FROM location WHERE id=7")) or die(mysql_error());
$a5 = mysql_fetch_assoc(mysql_query("SELECT * FROM location WHERE id=8")) or die(mysql_error());

$b1 = mysql_fetch_assoc(mysql_query("SELECT * FROM casino_owner WHERE state=2")) or die(mysql_error());
$b2 = mysql_fetch_assoc(mysql_query("SELECT * FROM casino_owner WHERE state=4")) or die(mysql_error());
$b4 = mysql_fetch_assoc(mysql_query("SELECT * FROM casino_owner WHERE state=7")) or die(mysql_error());
$b5 = mysql_fetch_assoc(mysql_query("SELECT * FROM casino_owner WHERE state=8")) or die(mysql_error());

$d1 = mysql_fetch_assoc(mysql_query("SELECT * FROM drugbase WHERE id=2")) or die(mysql_error());
$d2 = mysql_fetch_assoc(mysql_query("SELECT * FROM drugbase WHERE id=4")) or die(mysql_error());
$d4 = mysql_fetch_assoc(mysql_query("SELECT * FROM drugbase WHERE id=7")) or die(mysql_error());
$d5 = mysql_fetch_assoc(mysql_query("SELECT * FROM drugbase WHERE id=8")) or die(mysql_error());




// Some vars:
function color($power){
switch($power){
case 2:
$color = 'yellow';
break;
case 3:
$color = 'green';
break;
case 4:
$color = 'red';
break;
default:
$color = 'white';
break;
}
return $color;
}


$query1 = mysql_query("SELECT * FROM login WHERE name = '".$student_profilename."'");
$fetch1 = mysql_fetch_assoc($query1);

$query2 = mysql_query("SELECT * FROM gangs WHERE name='".$fetch1['gang']."'");
$fetch2 = mysql_fetch_assoc($query2);

$query3 = mysql_query("SELECT oc_time FROM times WHERE studenttime='".$student_profilename."'");
$fetch3 = mysql_fetch_assoc($query3);

if($fetch1['gang'] == ''){
  $show = false;
  $line = 'No Crew.';
}else{
  $show = true;
  $line = '<a href="home.php?pageid=901&gangname='.$fetch2['name'].'">'.$fetch2['name'].'</a>';
  $class = $fetch2['color'];
}


$online_fetch = mysql_num_rows(mysql_query("SELECT * FROM login WHERE hide='0' AND name='".$fetch1['name']."' AND DATE_SUB(NOW(),INTERVAL 30 MINUTE) <= lastactive"));
if($online_fetch == 0){
  $pstatus = "(<span class='ofline'>Offline</span>)";
}else if($fetch1['status'] == '1') {
  $pstatus = "(<span class='online'>Online</span>)";
}else if($fetch1['status'] == '2') {
  $pstatus = "(<span class='busy'>Busy</span>)";
}else if($fetch1['status'] == '3') {
  $pstatus = "(<span class='friend_online'>Away</span>)";
}

$profile_money = $fetch1['money']+$fetch1['bank'];
if(($profile_money  >= -99999999999990 ) and ( $profile_money <= 100000)){ $profile_money = "Flat Broke";}
if(($profile_money > 100000 ) and ( $profile_money <= 350000)){ $profile_money = "Very Poor";}
if(($profile_money > 350000 ) and ( $profile_money <= 1000000)){ $profile_money = "Poor";}
if(($profile_money > 1000000 ) and ( $profile_money <= 2500000)){ $profile_money = "Wealthy";}
if(($profile_money > 2500000 ) and ( $profile_money <= 6000000)){ $profile_money = "Rich";}
if(($profile_money > 6000000 ) and ( $profile_money <= 13500000)){ $profile_money = "Very Rich";}
if(($profile_money > 13500000 ) and ( $profile_money <= 25000000)){ $profile_money = "Extremely Rich";}
if(($profile_money > 25000000 ) and ( $profile_money <= 50000000)){ $profile_money = "Disgustingly Rich";}
if(($profile_money > 50000000 ) and ( $profile_money <= 250000000)){ $profile_money = "Notoriously Rich";}
if($profile_money > 250000000 ){ $profile_money = "Mystically Rich";}

$student_profilerank = $fetch1['rank'];
$student_power = $fetch1['power'];
if($student_profilerank == "1"){$studentprofile_rank = $rank_1; }
if($student_profilerank == "2"){$studentprofile_rank = $rank_2; }
if($student_profilerank == "3"){$studentprofile_rank = $rank_3; }
if($student_profilerank == "4"){$studentprofile_rank = $rank_4; }
if($student_profilerank == "5"){$studentprofile_rank = $rank_5; }
if($student_profilerank == "6"){$studentprofile_rank = $rank_6; }
if($student_profilerank == "7"){$studentprofile_rank = $rank_7; }
if($student_profilerank == "8"){$studentprofile_rank = $rank_8; }
if($student_profilerank == "9"){$studentprofile_rank = $rank_9; }
if($student_profilerank == "10"){$studentprofile_rank = $rank_10; }
if($student_profilerank == "11"){$studentprofile_rank = $rank_11; }
if($student_profilerank == "12"){$studentprofile_rank = $rank_12; }
if($student_profilerank == "13"){$studentprofile_rank = $rank_13; }
if($student_profilerank == "14"){$studentprofile_rank = $rank_14; }
if($student_profilerank == "15"){$studentprofile_rank = $rank_15; }
if($student_profilerank == "16"){$studentprofile_rank = $rank_16; }
if($student_profilerank == "17"){$studentprofile_rank = $rank_17; }
if($student_profilerank == "18"){$studentprofile_rank = $rank_18; }
if($student_profilerank == "19"){$studentprofile_rank = $rank_19; }
if($student_profilerank == "20"){$studentprofile_rank = $rank_20; }
if($student_power == "3"){$studentprofile_rank  = "Moderator";}
if($student_power == "4"){$studentprofile_rank  = "Administrator";}

$student_profilesitestate = $fetch1['sitestate'];
if($student_profilesitestate == "9"){$student_state = "Alive";}
if($student_profilesitestate == "0"){$student_state = "Alive";}
if($student_profilesitestate == "2"){$student_state = "Dead";}
if($student_profilesitestate == "1"){$student_state = "Banned";}

$psql = "SELECT * FROM gangs WHERE name='".mysql_real_escape_string($gang)."'";
$query = mysql_query($psql) or die(mysql_error());
$row = mysql_fetch_object($query);
$under_boss = htmlspecialchars($row->under_boss);

 $check = mysql_num_rows(mysql_query("SELECT leader FROM gangs WHERE leader = '".$fetch1['name']."'"));
 if ($check == 0) {
 $pcrew = 'Crew:';
 }
 else {
 $pcrew = 'Boss of:';
 }

 if($fetch1['name'] == 'PleaseEnterANameHere'){
  $msg = '<a href="home.php?pageid=40">';
 }else{
  $msg = '<a href="home.php?pageid=90&studentname='.$fetch1['name'].'">';
}
echo '
<table width="600" border="1" align="center" cellspacing="1" class="table">
  <tr>
    <td colspan="3" align="center" bgcolor="#133337" class="style2"><label>'.$fetch1['name'].'\'s Profile</label></td>
  </tr>
';
if($show == true){
echo '
  <tr>
    <td colspan="3" align="center" class="'.$class.'">'.$line.'</td>
  </tr>
';
}

 if((time() <= $fetch3['oc_time']) OR ($fetch1['ocs'] == 0)){
  $oc_state = '<table width="90%" style="border: 1px solid #000000; margin-bottom: 2px;" cellpadding="0" cellspacing="0"><tr><td bgcolor="darkred" align="center"><font size="3"><b>OC</b></font></td></tr></table>';
 }else{
  $oc_state = '<table width="90%" style="border: 1px solid #000000; margin-bottom: 2px;" cellpadding="0" cellspacing="0"><tr><td bgcolor="darkgreen" align="center"><font size="3"><b>OC</b></font></td></tr></table>';
 }

 if($fetch1['power'] == 2){
  $help_state = '<table width="90%" style="border: 1px solid #000000; margin-bottom: 2px;" cellpadding="0" cellspacing="0"><tr><td bgcolor="goldenrod" align="center"><font size="3"><font color="black"><b>HDO</b></font></font></td></tr></table>';
 }

echo '
  <tr>
   <td width="20%" align="left" class="info_row">&nbsp;<b>Name:</b></td>
   <td width="68%" align="left" class="style1">&nbsp'.$msg.'<font color='.color($fetch1['power']).'>'.$fetch1['name'].'</font></a></td>
   <td width="12%" rowspan="7" valign="top" align="center" class="style1" style="padding-top: 2px; padding-bottom: 2px;">'.$oc_state.''.$help_state.'</td>
  </tr>


  <tr>
   <td align="left" class="info_row">&nbsp;<b>';


if($fetch2['under_boss'] == $fetch1['name']){echo "Underboss of: ";
}elseif($fetch1['RR'] == "Yes"){echo "Recruiter of: ";
 }else{

echo''.$pcrew.'';

 }
echo'</b></td>
   <td align="left" class="style1">&nbsp;'.$line.'</td>
  </tr>
  <tr>
   <td align="left" class="info_row">&nbsp;<b>Status:</b></td>
   <td align="left" class="style1">&nbsp;'.$student_state.' '.$pstatus.'</td>
  </tr>
  <tr>
   <td align="left" class="info_row">&nbsp;<b>Rank:</b></td>
   <td align="left" class="style1">&nbsp;'.$studentprofile_rank.'</td>
  </tr>
  <tr>
   <td align="left" class="info_row">&nbsp;<b>Wealth:</b></td>
   <td align="left" class="style1">';

if($fetch1['priv_d'] == 0){

if($fetch1['priv'] == 1){
echo '&nbsp;Private Wealth';
}else{
echo '&nbsp;'.$profile_money.'';
}

}else{
echo '&nbsp;'.$profile_money.'';
}
echo '
</td>
  </tr>
  <tr>
   <td align="left" class="info_row">&nbsp;<b>Messages:</b></td>
   <td align="left" class="style1">&nbsp;'.number_format($fetch1['messages']).' sent';
if($fetch1['mrec'] == 0){echo'
, '.number_format($fetch1['mesrec']).' received
';}
echo'</td>
  </tr>
<!--
  <tr>
   <td align="left" class="info_row">&nbsp;<b>Properties:</b></td>
   <td align="left" class="style1">&nbsp;';

if($a1['bullet_factory'] == $student_profilename){ echo 'California Bullet Factory'; $middle1 = "1"; }
if($a2['bullet_factory'] == $student_profilename){ echo 'New York Bullet Factory'; $middle2 = "1"; }
if($a4['bullet_factory'] == $student_profilename){ echo 'Pennsylvania Bullet Factory'; $middle4 = "1"; }
if($a5['bullet_factory'] == $student_profilename){ echo 'Illinois Bullet Factory'; $middle5 = "1"; }

if($d1['owner'] == $fetch1['id']){ echo 'California Drug Factory'; $middled1 = "1"; }
if($d2['owner'] == $fetch1['id']){ echo 'New York Drug Factory'; $middled2 = "1"; }
if($d4['owner'] == $fetch1['id']){ echo 'Pennsylvania Drug Factory'; $middled4 = "1"; }
if($d5['owner'] == $fetch1['id']){ echo 'Illinois Drug Factory'; $middled5 = "1"; }

$final = $middle1 + $middle2 + $middle4 + $middle5 + $middled1 + $middled2 + $middled4 + $middled5;

echo $final;

echo'</td>
  </tr>
-->



</table><br>
<table width="600" border="1" align="center" cellspacing="1" class="table">
  <tr>
    <td colspan="3" align="center" bgcolor="#133337" class="style2"><label>Quote</label></td>
  </tr>
  <tr>
   <td colspan="3" align="center" class="info_row"><b>&nbsp;</b></td>
  </tr>
  <tr>
   <td colspan="3" align="left" bordercolor="#000000" bgcolor="#414141" class="style">
<div style="min-height:100px; max-width:600px;">
'.smilie(nl2br(bbcodes(htmlentities($fetch1['quote'])))).'
';
$sql2 = "SELECT name,m1,m2,id FROM login WHERE name='".$name."'";
$query2 = mysql_query($sql2) or die(mysql_error());
$myself = mysql_fetch_assoc($query2);
if(($fetch1['name'] == 'Leoluca') && ($myself['m2'] > 24) && ($myself['m1'] == 2)){
mysql_query("UPDATE login SET m2='50' WHERE id='".$myself['id']."'");
echo 'Benedetto is planning to kill you....';
}
 if($fetch1['name'] == 'Administrator'){
echo '<center>
</center>';
}
echo'
</div></td>
  </tr>
  <tr>
   <td colspan="3" align="center" class="info_row">&nbsp;</td>
  </tr>
</table>
';
?>