Request - Users list in frontend

[Taajuus]

I have a code request, that I think is quite simple to create for those who are more into WB code than me.

I want to have frontend page that shows list of all users that have created user account to my WB site. Simple vertical list with user names.

Also, under each user name I would like to display image. This image link would be in form of http//www.exampleurl.com/username.png. "Username" should be replaced with users login name, for each user.

Help, please!

[JC]

Hi Taajuus

I'm no programmer but here is some code to get you started. Of course you have to change group_id to which group you want to display.

Code: [Select]

// gets information from table
$result = mysql_query("SELECT * FROM ".TABLE_PREFIX."users WHERE group_id=7 ORDER BY user_id ASC") or die(mysql_error());


echo "<table border='1' bordercolor='#cccccc' cellspacing='0' cellpadding='3'>";
echo "<tr bgcolor='#cccccc'>
         <td>ID</td><td>Name</td><td>Username</td><td>E-mail</td></tr>";


// gets results from table
while($row = mysql_fetch_array( $result ))

{
     // prints content row by row
echo "<tr><td>";   
echo $row['user_id'];
echo "</td><td>";     
      echo "<b>"; 
echo $row['display_name'];
      echo "</b>";
echo "</td><td>";
echo $row['username'];
echo "</td><td>";
      echo "<b>";
echo $row['email'];
      echo "</b>";
echo "</td></tr>";
   
}

echo "</table>";
I hope it can be of any help!

/JC

[pcwacht]

made a droplet for eliteforcemars.nl a while ago

Code: [Select]

global $database, $wb;
$return = " ";
$query = "SELECT * FROM ".TABLE_PREFIX."users WHERE display_name<>'Admin' ORDER BY group_id";
$result = $database->query($query);

$return .= "<ul>";
while($row = $result->fetchRow())   {
          $return .= "<li>".$row["display_name"]."</li>";
#          $return .= "<br>";
     }
$return .= "</ul>";
return $return;


Create some image there.

Have fun,
John

[Taajuus]

made a droplet for eliteforcemars.nl a while ago
[

This seems to work nice as droplet, thanks!

But small problem still. This code gives output as text to image url I want, but how do i change it so it shows it as image, rather than text output?

Code: [Select]

global $database, $wb;
$return = " ";
$query = "SELECT * FROM ".TABLE_PREFIX."users WHERE display_name<>'Admin' ORDER BY group_id";
$result = $database->query($query);

$return .= "";
while($row = $result->fetchRow())   {
          $return .= "http://bfbc2.statsverse.com/sig/detail1/ps3/".$row["display_name"].".png"."<br>";
#          $return .= "<br>";
     }
$return .= "";
return $return;

I tried this, but something wrong with my php coding

Code: [Select]

global $database, $wb;
$return = " ";
$query = "SELECT * FROM ".TABLE_PREFIX."users WHERE display_name<>'Admin' ORDER BY group_id";
$result = $database->query($query);

$return .= "";
while($row = $result->fetchRow())   {
          $return .= "<img src="http://bfbc2.statsverse.com/sig/detail1/ps3/".$row["display_name"].".png">"."<br>";
#          $return .= "<br>";
     }
$return .= "";
return $return;

[aldus]

hm ...

Some typos and incorrect use of quotes ... that's all

Code: [Select]

<?php // not this line ;-)
global $database, $wb;

$return = " ";

$query = "SELECT * FROM `".TABLE_PREFIX."users` WHERE `display_name`<>&#39;Admin&#39; ORDER BY group_id";
$result = $database->query($query);

while( true == ($row = $result->fetchRow())) {
$return .= "<img src=\"http://bfbc2.statsverse.com/sig/detail1/ps3/".$row["display_name"].".png\" alt=&#39;&#39; /><br />";
} 
return $return;


Regards
Aldus

[Taajuus]

Ok, I need some more help  This is more php related... Since I'm not expert.

Now I have script that pulls out WB users from database, something like this:

Code: [Select]

// gets information from table
$result = mysql_query("SELECT * FROM ".TABLE_PREFIX."users WHERE group_id=7 ORDER BY user_id ASC") or die(mysql_error());

// gets results from table
while($row = mysql_fetch_array( $result ))

echo $row['username'];

Then I have another script, that wants variable of usernames like this:

Code: [Select]

//prep the members
$members = "user1,user2,user3";

How could I combine so that usernames first code pulls out from database would be inserted to this other scripts as $members data? Since this other script is designed so you insert $members data manually (comma separated), but I want it to use usernames straight from WB database automaticly...

I can show whole script, if needed.

[Taajuus]

Ok, heres the full code.
 
How should I modify this, so that instead of  $members = "user1,user2,user3"; I could pull out these users (comma separated) from WB database?

Please help, this is the last piece of puzzle for my site

Code: [Select]

<?php


//prep the members

// The most important piece.  Add all your friends separated by commas.
$members = "user1,user2,user3";



$rankpoints=array(
1 => 0,
2 => 11000,
3 => 18500,
4 => 28000,
5 => 40000,
6 => 53000,
7 => 68000,
8 => 84000,
9 => 100000,
10 => 120000,
11 => 138000,
12 => 158000,
13 => 179000,
14 => 200000,
15 => 224000,
16 => 247000,
17 => 272000,
18 => 297000,
19 => 323000,
20 => 350000,
21 => 377000,
22 => 405000,
23 => 437000,
24 => 472000,
25 => 537000,
26 => 620000,
27 => 720000,
28 => 832000,
29 => 956000,
30 => 1092000,
31 => 1240000,
32 => 1400000,
33 => 1572000,
34 => 1756000,
35 => 1952000,
36 => 2160000,
37 => 2380000,
38 => 2612000,
39 => 2856000,
40 => 3112000,
41 => 3380000,
42 => 3660000,
43 => 3952000,
44 => 4256000,
45 => 4572000,
46 => 4900000,
47 => 5240000,
48 => 5592000,
49 => 5956000,
50 => 6332000); 

//grab the stats!
$url = &#39;http://api.bfbcs.com/api/ps3&#39;;
$postdata = &#39;players=&#39;.$members.&#39;&fields=general&#39;;
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $postdata);
$data = curl_exec($ch);
curl_close($ch);
$data = json_decode($data,true);

if(isset($_GET[&#39;debug&#39;]))
{
var_dump($data);
echo &#39;<br /><br />&#39;;
}
//loop through the data and store stats in an array
$stats = array();

for($x=0;$x<count($data[&#39;players&#39;]);$x++)
{
$name = $data[&#39;players&#39;][$x][&#39;name&#39;];
$rank = $data[&#39;players&#39;][$x][&#39;rank&#39;];
$score = $data[&#39;players&#39;][$x][&#39;score&#39;];
$kills = $data[&#39;players&#39;][$x][&#39;kills&#39;];
$deaths = $data[&#39;players&#39;][$x][&#39;deaths&#39;];
$raw_time = sec2hms($data[&#39;players&#39;][$x][&#39;time&#39;]);

$ratio = number_format($kills/$deaths, 2, &#39;.&#39;, &#39;&#39;);

$dogtags = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;dogt&#39;];
$total_time=$data[&#39;players&#39;][$x][&#39;time&#39;];
$SPM=number_format($score/($total_time/60), 2, &#39;.&#39;, &#39;&#39;);
$KPM=number_format($kills/($total_time/60), 2, &#39;.&#39;, &#39;&#39;);
$DPM=number_format($deaths/($total_time/60), 2, &#39;.&#39;, &#39;&#39;);

$score_general = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;sc_general&#39;];
$score_award = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;sc_award&#39;];
$score_bonus = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;sc_bonus&#39;];
$score_team = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;sc_team&#39;];
$score_squad = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;sc_squad&#39;];

//calculate which class they use
$assault = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;sc_assault&#39;];
$recon = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;sc_recon&#39;];
$demo = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;sc_demo&#39;];
$support = $data[&#39;players&#39;][$x][&#39;general&#39;][&#39;sc_support&#39;];

$the_classes = array();
$the_classes[0] = array(&#39;name&#39;=>&#39;assault&#39;,&#39;score&#39;=>$assault);
$the_classes[1] = array(&#39;name&#39;=>&#39;recon&#39;,&#39;score&#39;=>$recon);
$the_classes[2] = array(&#39;name&#39;=>&#39;demo&#39;,&#39;score&#39;=>$demo);
$the_classes[3] = array(&#39;name&#39;=>&#39;support&#39;,&#39;score&#39;=>$support);

//sort the classes array by score
usort($the_classes,&#39;compare_stats&#39;);

$most_used = $the_classes[0][&#39;name&#39;];

$NextRank=intval($rank+1);

// Search next rank
if( empty($NextRank) )
$nextRankID = $rank;
else {
if($rankpoints[$rank] == $rankpoints[($rank + 1)])
{
$nextRankID = 0;
for ($m=($rank + 1);$m<(count($rankpoints)-1);$m++)
{
if( ($rankpoints[$m] > $rankpoints[$rank]) && ($nextRankID == 0) ) $nextRankID = $m;
}
}
else $nextRankID = ($rank + 1);
    }

if($rank < 10) { $rank = "0".$rank; }

$stats[$x] = array(&#39;name&#39;=>$name,&#39;rank&#39;=>$rank,&#39;score&#39;=>$score,&#39;kills&#39;=>$kills,&#39;deaths&#39;=>$deaths,&#39;ratio&#39;=>$ratio,&#39;time&#39;=>$raw_time,&#39;most_used&#39;=>$most_used,&#39;dogtags&#39;=>$dogtags,&#39;SPM&#39;=>$SPM,&#39;KPM&#39;=>$KPM,&#39;DPM&#39;=>$DPM,&#39;sc_general&#39;=>$score_general,&#39;sc_award&#39;=>$score_award,&#39;sc_bonus&#39;=>$score_bonus,&#39;sc_team&#39;=>$score_team,&#39;sc_squad&#39;=>$score_squad,&#39;score_rank&#39;=> $score - $rankpoints[$nextRankID-1],&#39;diff_score&#39;=> $rankpoints[$nextRankID] - $rankpoints[$nextRankID-1],&#39;nextrankid&#39;=> $nextRankID,&#39;nextrankscore&#39; => $rankpoints[$nextRankID]);

}

function sec2hms ($sec, $padHours = false) 
{
$hms = "";
$hours = intval(intval($sec) / 3600); 
$hms .= ($padHours) 
  ? str_pad($hours, 2, "0", STR_PAD_LEFT). &#39;:&#39;
  : $hours. &#39;h &#39;; 
$minutes = intval(($sec / 60) % 60); 
$hms .= str_pad($minutes, 2, "0", STR_PAD_LEFT). &#39;m &#39;;
$seconds = intval($sec % 60); 
$hms .= str_pad($seconds, 2, "0", STR_PAD_LEFT).&#39;s&#39;;
return $hms;
}


function compare_stats($x,$y)
{
if($x[&#39;score&#39;] == $y[&#39;score&#39;])
{
return 0;
}
elseif($x[&#39;score&#39;] < $y[&#39;score&#39;])
{
return 1;
}
else
{
return -1;
}
}

//sort the stats array by score
usort($stats,&#39;compare_stats&#39;);


?>

<div align="center">
<table border="0" width="100%" id="table1">

<tr>
<td align="center">&nbsp;</td>

<td><b>Player</b></td>

<td align="center"><b>Kills</b></td>
<td align="center"><b>Deaths</b></td>
<td align="center"><b>KDR</b></td>
<td align="center"><b>Total Time</b></td>
</tr>

    <?php
for($out=0;$out<count($stats);$out++)
{
$pos = $out + 1;
?>

<tr><td width="29" align="center"><img src="http://battlefieldbadcompany2.com/files/gui/img/stats/ranks/tiny/R0<?php echo &#39;&#39;.$stats[$out][&#39;rank&#39;].&#39;&#39; ?>.png" alt="<?php echo &#39;&#39;.$stats[$out][&#39;rank&#39;].&#39;&#39; ?>" /></td>



<td><a href="http://bfbcs.com/stats_ps3/<?php echo &#39;&#39;.$stats[$out][&#39;name&#39;].&#39;&#39; ?>" target="_blank"><?php echo &#39;&#39;.$stats[$out][&#39;name&#39;].&#39;&#39; ?></a></td>






<td align="center"><?php echo &#39;&#39;.$stats[$out][&#39;kills&#39;].&#39;&#39; ?></td>
<td align="center"><?php echo &#39;&#39;.$stats[$out][&#39;deaths&#39;].&#39;&#39; ?></td>
<td align="center"><?php echo &#39;&#39;.$stats[$out][&#39;ratio&#39;].&#39;&#39; ?></td>
<td align="center"><?php echo &#39;&#39;.$stats[$out][&#39;time&#39;].&#39;&#39; ?></td>
</tr>
    <?php
}
?>
</table>
</div>

<?php
if(!empty($data[&#39;players_nodata&#39;]))
{
echo &#39;<br><div align="center" id="stats_waiting">&#39;.count($data[&#39;players_nodata&#39;]).&#39; playerststs waiting in que.</div>&#39;;
}
?>
<br>
<div align="center">Stats updated every six hours.</div>

<br>
<p align="center">Powered by: <a target="_blank" href="http://bfbcs.com/ps3">bfbcs.com</a></p>



[Taajuus]

Anyone? Please

[pcwacht]

combine the two

To get comma separated users:

$members = '';
$query = "SELECT * FROM `".TABLE_PREFIX."users` WHERE `display_name`<>'Admin' ORDER BY group_id";
$result = $database->query($query);

while( true == ($row = $result->fetchRow())) {
   $members .= $row["display_name"].",";
}


Past your other code here..

Have fun,
John

[Taajuus]

Works like a charm! THANKS!