if (is_null($ladderTeamRight)) { $flagRight = '<img title="'.$nationalityRight.'" style="opacity:0.4;" src="'.$directory.'/flags/'.$nationalityRight.'.bmp" width="18" height="15" border="1">'; } else { $flagRight = getImgForTeam($ladderTeamRight); } $rowspan = ""; ?> <tr style='height:<?php echo $rowheight; ?> px;'> <td nowrap style="padding-right: 5px;"><?php echo getImgForVersion('H'); ?> </td> <td <?php echo $idtooltip; ?> nowrap style="padding-right: 15px;"><span class="darkgrey-small"><?php echo $gamedate; ?> </span></td> <td nowrap align="right"><?php echo $winnerdisplay; ?> </td> <td><?php echo $flagLeft;
} ?> <tr<? if ($deleted == "yes") { echo " class='row_deleted'"; } else if (!empty($gameId) && strcmp($gameId, $gameid) == 0) { echo " class='row_active'"; } else { echo " class='row'"; } ?>> <td width="4%" style="text-align:center;"><?= $gameid ?></td> <td width="4%" style="text-align:center;" title="season"><?= $gameseason ?></td> <td width="4%" style="text-align:center;" nowrap><?= getImgForVersion($version) ?></td> <td width="10%" nowrap><?= formatDate($date) ?></td> <td width="5%" class="grey-small" style="text-align:center;"><?= $winpointsDisplay ?></td> <td width="10%" style="text-align:right;" <?= $wintd ?>><?= $winnerlink ?></td> <td wdith="4%" style="text-align:center;"><?= $flagLeft; ?></td> <td width="5% "style="text-align:center;" nowrap><?= $winnerresult." - ".$loserresult ?></td> <td wdith="4%" style="text-align:center;"><?= $flagRight; ?></td> <td width="10%" <?= $losetd ?>><?= $loserlink ?></td> <td width="5%" class="grey-small" style="text-align:center;"><?= $losepoints ?></td> <td width="35%"><?= $comment ?></td> </tr> <?php $cur++; } echo getRankBoxBottom(); } // end else nogames
$row2 = mysql_fetch_array(mysql_query($sql2)); $nationalityRight = $row2['nationality']; $flagRight = '<img title="'.$nationalityRight.'" style="opacity:0.4;" src="'.$directory.'/flags/'.$nationalityRight.'.bmp" width="18" height="15" border="1">'; } ?> <tr style='height:<?php echo $rowheight; ?> px;'> <td <?php echo $tooltip; ?> nowrap style="padding-right: 5px;"><?php echo getImgForVersion($version); ?> </td> <td <?php echo $idtooltip; ?> nowrap style="padding-right: 15px;"><span class="darkgrey-small"><?php echo $gamedate; ?> </span></td> <td <?php echo $wintooltip; ?> nowrap align="right"><?php echo $winnerdisplay;
$sql = "SELECT userId FROM $playerstatustable WHERE userId='".$player_id."' AND type='B' AND active='Y'"; $status = mysql_num_rows(mysql_query($sql)); if ($status == 0) { $name = $row['name']; $nameLink = '<a href="'.$directory.'/profile.php?name='.$name.'">'.$name.'</a>'; $country = $row['country']; $join = $row['joindate']; $joindate = date('m/d h:i', $join); $ip = $row['ip']; $pwd = $row['pwd']; $mail = $row['mail']; $msn = $row['msn']; $defaultVersion = $row['defaultversion']; $versionImg = getImgForVersion($defaultVersion); echo "<tr class='row_approve'>"; echo "<td><p>$player_id</p><p>$versionImg</p></td>"; echo "<td><b>$nameLink</b> ($country)<br>$mail<br>$joindate<br>$ip"; echo "</td>"; $count++; // pwd echo "<td>"; $pwd_sql = "SELECT name,pwd from $playerstable where pwd like '%$pwd%' and name != '$name' limit 0,5"; $pwd_result = mysql_query($pwd_sql); if (mysql_num_rows($pwd_result) > 0) { echo "<b>$pwd</b><br>password matches player(s):<br>"; } while($pwd_row = mysql_fetch_array($pwd_result)) {
printRow($cur, $col2, $points, $highlight); $cur++; } } else if ($gamesPerVersion) { while ($row = mysql_fetch_array($result)) { $color = $row['color']; $version = $row['version']; $gameName = $row['name']; $sql2 = "SELECT count(*) as cnt FROM $gamestable WHERE deleted = 'no' AND version = '$version'"; $result2 = mysql_query($sql2); $row2 = mysql_fetch_array($result2); $count = $row2['cnt']; $displayWidth = ceil($count/100); // echo "count:$count displayWidth:$displayWidth gameName: $gameName<br>"; $col2 = getImgForVersion($version)." ".$gameName; $col3 = "<img border='1' style='cursor:help;vertical-align:middle;background-color:#$color' ". "src='gfx/1px_transparent.gif' title='$gameName games' alt='$gameName games' height='4' width='$displayWidth' /> ".$count; printRow($cur, $col2, $col3, false); $cur++; } } else if ($gamesPerMonth) { $startDate = 1099288800; // 01.11.2004 $baseDate = new DateTime(); $baseDate->setTime(0,0,0); $cur = 1;