function do_search($name, $search_aliases = false)
{
global $currentconfig;
global $currentconfignumber;
global $coddb;
global $t;
global $text;
$count = 0;
$link = baselink();
$query = "SELECT {$t['b3_clients']}.name, {$t['players']}.id, {$t['players']}.fixed_name,\n {$t['players']}.hide \n FROM {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_clients']}.id = {$t['players']}.client_id)\n AND ( \n ({$t['b3_clients']}.name LIKE \"%{$name}%\")\n OR\n ({$t['players']}.fixed_name LIKE \"%{$name}%\")\n )\n AND {$t['players']}.hide = 0";
$result = $coddb->sql_query($query);
opentablerow('100');
echo "<td>" . $text["currentplnames"] . "<td></tr><tr>";
while ($row = $coddb->sql_fetchrow($result)) {
opentablecell('100');
if ($row['fixed_name'] == "") {
echo "<a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">" . htmlspecialchars(utf2iso($row['name'])) . "</a><br/>";
$count++;
} else {
if (stristr($row['fixed_name'], $name)) {
echo "<a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">" . htmlspecialchars(utf2iso($row['fixed_name'])) . "</a><br/>";
$count++;
}
}
closetablecell();
echo "</tr><tr>";
}
closetablerow();
if ($search_aliases == "true") {
$query = "SELECT {$t['b3_aliases']}.alias, {$t['b3_clients']}.name, {$t['players']}.id\n FROM {$t['b3_aliases']}, {$t['b3_clients']}, {$t['players']}\n WHERE ({$t['b3_aliases']}.alias LIKE \"%{$name}%\")\n AND {$t['b3_aliases']}.client_id = {$t['b3_clients']}.id\n AND {$t['b3_clients']}.id = {$t['players']}.client_id\n AND {$t['players']}.hide = 0\n AND {$t['players']}.fixed_name = '' ";
$result = $coddb->sql_query($query);
if ($coddb->sql_numrows($result) > 0) {
echo "Alias results:<br/>";
}
opentablerow('100');
echo "<td>Search results (aliase -> current playername)<td></tr><tr>";
while ($row = $coddb->sql_fetchrow($result)) {
opentablecell('100');
echo "{$row['alias']} -> <a href=\"{$link}?func=player&playerid={$row['id']}&config={$currentconfignumber}\">{$row['name']}</a><br/>";
$count++;
closetablecell();
echo "</tr><tr>";
}
closetablerow();
}
return $count;
}
function player_compare_item($player1, $player2, $citem = "skill", $cbar = true, $switchwinner = false, $columns = 1)
{
global $separatorline;
global $ccounter1;
global $ccounter2;
global $main_width;
$cwidth = $main_width / $columns - 200;
if (!is_numeric($player1[$citem]) || !is_numeric($player2[$citem])) {
$cbar = false;
$cclass1 = "innertable";
$cclass2 = "innertable";
} else {
if ($player1[$citem] >= $player2[$citem]) {
if (is_numeric($player1[$citem])) {
$player1perc = 1;
$player2perc = $player2[$citem] / $player1[$citem];
}
$cclass1 = "innertable";
$cbarcolor1 = "green";
$cclass2 = "attention";
$cbarcolor2 = "red";
$ccounter2++;
} else {
if (is_numeric($player1[$citem])) {
$player1perc = $player1[$citem] / $player2[$citem];
$player2perc = 1;
}
$cclass1 = "attention";
$cbarcolor1 = "red";
$cclass2 = "innertable";
$cbarcolor2 = "green";
$ccounter1++;
}
if ($switchwinner) {
if ($cclass1 == "attention") {
$cclass1 = "innertable";
$cbarcolor1 = "green";
$cclass2 = "attention";
$cbarcolor2 = "red";
$ccounter2++;
$ccounter1--;
} else {
$cclass1 = "attention";
$cbarcolor1 = "red";
$cclass2 = "innertable";
$cbarcolor2 = "green";
$ccounter1++;
$ccounter2--;
}
}
}
opentablerow(100);
echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" class=\"innertable\">";
if ($cbar) {
$temp1 = sprintf("%.2f", $player1perc) * 100;
$temp2 = sprintf("%.2f", $player2perc) * 100;
echo "<tr height=\"10\" class=\"outertable\"><td align=\"center\" colspan=\"3\">" . ucfirst($citem) . "</td></tr>";
echo "<tr height=\"10\"><td class={$cclass1} width=\"140\" align=\"left\">" . htmlspecialchars(utf2iso($player1['name'])) . "</td><td class={$cclass1} width=\"60\" align=\"left\">" . $player1[$citem] . "</td><td width=\"{$cwidth}\" class={$cclass1} align=\"left\"><img src=\"images/bars/bar-small/" . $cbarcolor1 . "_middle_9.gif\" height=\"9\" width=\"" . $player1perc * $cwidth . "\" title=\"" . $temp1 . "%\"></td></tr>";
if ($separatorline == 1) {
echo "<tr><td colspan=\"3\" class=\"outertable\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\" alt=\"\"></td></tr>";
}
// This draws a one pixel line between rows
echo "<tr height=\"10\"><td class={$cclass2} width=\"140\" align=\"left\">" . htmlspecialchars(utf2iso($player2['name'])) . "</td><td class={$cclass2} width=\"60\" align=\"left\">" . $player2[$citem] . "</td><td width=\"{$cwidth}\" class={$cclass2} align=\"left\"><img src=\"images/bars/bar-small/" . $cbarcolor2 . "_middle_9.gif\" height=\"9\" width=\"" . $player2perc * $cwidth . "\" title=\"" . $temp2 . "%\"></td></tr>";
} elseif ($citem == "country") {
echo "<tr height=\"10\" class=\"outertable\"><td align=\"center\" colspan=\"2\">" . ucfirst($citem) . "</td></tr>";
echo "<tr height=\"10\"><td class={$cclass1} width=\"140\" align=\"left\">" . htmlspecialchars(utf2iso($player1['name'])) . "</td><td class={$cclass1} width=\"60\" align=\"center\">" . $player1['flag'] . "</td></tr>";
if ($separatorline == 1) {
echo "<tr><td colspan=\"2\" class=\"outertable\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\" alt=\"\"></td></tr>";
}
// This draws a one pixel line between rows
echo "<tr height=\"10\"><td class={$cclass2} width=\"140\" align=\"left\">" . htmlspecialchars(utf2iso($player2['name'])) . "</td><td class={$cclass2} width=\"60\" align=\"center\">" . $player2['flag'] . "</td></tr>";
} else {
echo "<tr height=\"10\" class=\"outertable\"><td align=\"center\" colspan=\"2\">" . ucfirst($citem) . "</td></tr>";
echo "<tr height=\"10\"><td class={$cclass1} width=\"140\" align=\"left\">" . htmlspecialchars(utf2iso($player1['name'])) . "</td><td class={$cclass1} width=\"60\" align=\"left\">" . $player1[$citem] . "</td></tr>";
if ($separatorline == 1) {
echo "<tr><td colspan=\"2\" class=\"outertable\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\" alt=\"\"></td></tr>";
}
// This draws a one pixel line between rows
echo "<tr height=\"10\"><td class={$cclass2} width=\"140\" align=\"left\">" . htmlspecialchars(utf2iso($player2['name'])) . "</td><td class={$cclass2} width=\"60\" align=\"left\">" . $player2[$citem] . "</td></tr>";
}
closetablerow();
}
$in_c == 3 ? "selected" : "";
?>
>3</option>
<option value="4" <?php
$in_c == 4 ? "selected" : "";
?>
>4</option>
</select>
</p>
<p><span class="style1">Width-Height: (max 500x200)</span><br>
<input name="w" type="text" id="w" size="6" value="<?php
$in_w;
?>
">
<input name="h" type="text" id="h" size="6" value="<?php
$in_h;
?>
">
</p>
-->
<p>
<input type="submit" name="submit" value="Build">
</p>
</form>
<?php
closetablecell();
closetablerow();
displaysimplefooter(1);
