[Help Soon] Player Stats Function...

[Dethman]

Hey guys I have this player stats function I had made with some help with a friend but for some reason it only shows the information of your own player and when you click a different player where the information should be is just blank.

 

Function:

<?php
function getStats($user_id){
$q= "SELECT * FROM `user_users` WHERE `userid`='$user_id'";
$v=mysql_query($q) or die("Error: ".mysql_error());

$player2=mysql_fetch_array($v);

//LETS MAKE A RETURN ARRAY, SO WE CAN ADD STUFF AS WE GO...
$returnArray = array();

$username=$player2['username'];
$rank=$player2['overallRank'];
$realm=$player2['tag'];
    $AEP=$player2['PPT'];
    $coid=$player2['commander'];
    $rid=$player2['raceID'];
    $l=$player2['loyalty'];

//Let's add what we have so far.
$returnArray[] = $username;
$returnArray[] = $rank;
$returnArray[] = $realm;

$q2= "SELECT * FROM `user_users` WHERE `userid`='$coid'";
$v2=mysql_query($q2) or die("Error: ".mysql_error());
$co=mysql_fetch_array($v2);
    
if($co['username']==""){
	$commander="None";
}
else{
$commander=$co['username'];	
}
    
//Add the players commander to the array...
$returnArray[] = $commander;

    $CovertStrength1 = $player['covertLVL']*$player['covertTroops'];
    $finalCovStrength = $CovertStrength1*1.20;

    $cov2 = $player2['covertLVL']*$player2['covertTroops'];

  if($cov2 <= $finalCovStrength){
    $treasury=$player2['credits'];
    $total_army=($player2['attackTroops']+$player2['defenseTroops']+$player['untrainedTroops']+$player2['covertTroops']+$player2['atkTroops']+$player2['defTroops']+$player2['farmer']+$player2['psicreator']);
    $trained_army=($player2['attackTroops']+$player2['defenseTroops']+$player2['covertTroops']+$player2['atkTroops']+$player2['defTroops']+$player2['farmer']+$player2['psicreator']);
    $def_rate=getSpellStatus($user_id);
   
   } else{
$treasury="?????";
   }

 //Add treasuary
	$returnArray[] = $treasury;
	$returnArray[] = $total_army;
	$returnArray[] = $trained_army;
	$returnArray[] = $def_rate;

 switch($rid){
	case 1:
		$race = "Fire";
	break;
	case 2:
		$race = "Water";
	break;
	case 3:
		$race = "Earth";
	break;
	case 4:
		$race = "Air";
	break;
 }

 switch($l){
	case 0:
		$loyalty = "Rogue Scum";
	break;
	case 1:
		$loyalty = "Chaotic";
	break;
	case 2:
		$loyalty = "Lawful";
	break;
	case 3:
		$loyalty = "Healing";
	break;
	case 4:
		$loyalty = "Deadly";
	break;
}
   if($AEP==1){
	$AEP_1="{Under Ancient's Enchantment Protection}";
   }else{
	$AEP_1="";
   }

 //LETS ADD THOSE NOW...
 $returnArray[] = $race;
 $returnArray[] = $loyalty;
 $returnArray[] = $AEP_1;
   	
$q3="SELECT * FROM `user_users` WHERE `commander` = '$user_id' ORDER BY `overallRank` ASC";
$v3=mysql_query($q3);
$count=mysql_num_rows($v3);
if($count<1){
	$apprentice_page="<TD colspan=3><center>No Additional Apprentices</center></TD>
";
}else{
while($row=mysql_fetch_array($v3)){
 switch($row['raceID']){
 case 1:
	$app_race="Fire";
break;
case 2:
	$app_race="Water";
break;
case 3:
	$app_race="Earth";
break;
case 4:
	$app_race="Air";
break;
}
$apprentice_page.="
<tr>
<td align='left'><a href='stats.php?id=".$row['userid']."'>".$row['username']."</a></td>
<td align='left'>".$app_race."</td>
<td align='right'>".$row['overallRank']."</td>
</tr>";
}

//NOW ADD THAT...
$returnArray[] = $apprentice_page;

$sql = "SELECT * FROM `plan` WHERE `userid` = '$user_id' ORDER BY `Plan_size` DESC";

$result = mysql_query($sql) or die('Query failed.' . mysql_error());


$ammout_plan=mysql_num_rows($result);
if($ammout_plan == 0){
$planet_stats = "<TD colspan=3><center>No Additional Villages</center></TD>";
}else{

for ($i = 0; $i < mysql_num_rows($result);$i++) {  
  $plan_Name = mysql_result($result,$i,"plan_name");
  $plan_Size = mysql_result($result,$i,"plan_size");
  $plan_Type = mysql_result($result,$i,"plan_attribute");
  $plan_Prod = mysql_result($result,$i,"plan_product");
  $plan_Defe = mysql_result($result,$i,"plan_defense");
  switch($plan_Type){
	case 1:
    $attribute = number_format(ceil(125000 * $plan_Prod * pow(3.5,$plan_Size)));
    $type = " Defence";
    $defamt = number_format(300000 * $plan_Defe);
	break;
  case 2:
    $attribute = number_format(ceil(135000 * $plan_Prod * pow(3.5,$plan_Size)));
    $type = " Attack";
    $defamt = number_format(300000 * $plan_Defe);
	break;
  case 3:
    $attribute = number_format(ceil(500000 * $plan_Prod * pow(1.85,$plan_Size)));
    $type = " Spy";
    $defamt = number_format(300000 * $plan_Defe);
	break;
  case 4:
    $attribute = number_format(ceil(480000 * $plan_Prod * pow(1.3,$plan_Size)));
    $type = " Income";
    $defamt = number_format(300000 * $plan_Defe);
	break;
  case 5:
    $attribute = number_format(ceil($plan_Prod * pow(1.1,$plan_Size)));
    $type = " Up";
    $defamt = number_format(300000 * $plan_Defe);
	break;
  }
switch ($plan_Size) {
  case 0:
    $Size = "Tiny";
    break;
  case 1:
    $Size = "Very Small";
    break;
  case 2:
    $Size = "Small";
    break;
  case 3:
    $Size = "Normal";
    break;
  case 4:
    $Size = "Large";
    break;
  case 5:
    $Size = "Big";
    break;
  case 6:
    $Size = "Massive";
    break;
  case 7:
    $Size = "On verg of a blackhole";
    break;
}

$planet_stats .= "
<TR>
<TD align=left>".$plan_Name."</TD>
<TD align=left>".$Size."</TD>
<TD align=right>".$type."</TD>
</TR>
";
}	    
  }

$returnArray[] = $planet_stats;

return $returnArray;
}
}

//When calling, it'll look like this:
//list($username, $rank, $realm, $commander, $treasury, $total_army, $trained_army, $def_rate,$race, $loyalty, $AEP_1,$apprentice_page,$planet_stats);
?>

 

Call Code:

<?php
$p2id=$_GET['id'];
list($username, $rank, $realm, $commander, $treasury, $total_army, $trained_army, $def_rate,$race, $loyalty, $AEP_1,$apprentice_page,$planet_stats) = getStats($p2id);
?>

 

If you could help with this I have a schedual to maintain on this game,

Thank you for your Replies

Brian Flores, CEO

NimbusGames,llc

[Dethman]

Bump!

[teynon]

Do you know that the user ID is correct? Are those variables returning anything or you just don't see anything print out. Please include the code from the list() to the display.

[discomatt]

Also, if you need something done in a time frame, please check the PHP Freelance forum. This is a forum of volunteers... you should appreciate getting any help at all, not requesting us to adapt to your schedule.