Battlefield Players.com - Player Search

Seach for: in

Logging ALL players since 7th June 2007
"; echo "", $num_rows_guids , " Unique players tracked.
"; echo "", $num_rows_aliases , " Aliases tracked.
"; echo "", $num_rows_servers , " Servers monitored.
"; echo "And counting...
"; // END General Statistics ?>

" .$hash; if ($_REQUEST['searchstring'] == "") { echo "

You haven't entered a search term yet"; exit; } //if ($_REQUEST['field'] !="") if ($_REQUEST['field'] == 'guid') { echo "You searched for: " .$searchstring , " in the " .$field ," database"; echo "

"; echo "

Results

"; echo "

"; Print ""; Print ""; Print ""; Print ""; Print ""; Print ""; { echo $row['val'] . '
'; } $res = mysql_query(" SELECT DISTINCT a.alias_string, g.guid_string, MIN(s.time_first) AS time_first, MAX(IF(s.time_last IS NULL, sv.last_update, s.time_last)) AS time_last FROM aliases AS a, guids AS g, sessions AS s, servers AS sv WHERE s.alias_key=a.alias_key AND s.guid_key=g.guid_key AND s.server_key=sv.server_key AND g.guid_string LIKE '%${_REQUEST['searchstring']}%' GROUP BY alias_string ORDER BY alias_string ASC", $db) or die(mysql_error()); while ($row = mysql_fetch_assoc($res)) { //print_r($row); Print ""; echo ""; echo ""; Print ""; Print ""; } Print "
Alias:CD Hash:First Seen:Last Seen:
".$row['alias_string']."".$row['guid_string']."${row['time_first']}${row['time_last']}
"; $anymatches=mysql_num_rows($res); if ($anymatches == 0) { echo "Sorry, but we can not find a CD-hash to match your search criteria

"; } else echo "

Total number of matching records: " .$anymatches , ""; } elseif ($_REQUEST['field'] == 'alias') { echo "You searched for: " .$searchstring , " in the " .$field ," database"; echo "

"; echo "

Results

"; echo "

"; Print ""; Print ""; Print ""; Print ""; Print ""; Print ""; { echo $row['val'] . '
'; } $res = mysql_query(" SELECT DISTINCT a.alias_string, g.guid_string, MIN(s.time_first) AS time_first, MAX(IF(s.time_last IS NULL, sv.last_update, s.time_last)) AS time_last FROM aliases AS a, guids AS g, sessions AS s, servers AS sv WHERE s.alias_key=a.alias_key AND s.guid_key=g.guid_key AND s.server_key=sv.server_key AND a.alias_string LIKE '%${_REQUEST['searchstring']}%' GROUP BY alias_string ORDER BY alias_string ASC", $db) or die(mysql_error()); while ($row = mysql_fetch_assoc($res)) { //print_r($row); Print ""; echo ""; echo ""; Print ""; Print ""; } Print "
Alias:CD Hash:First Seen:Last Seen:
".$row['alias_string']."".$row['guid_string']."${row['time_first']}${row['time_last']}
"; $anymatches=mysql_num_rows($res); if ($anymatches == 0) { echo "Sorry, but we can not find a CD-hash to match your search criteria

"; } else echo "

Total number of matching records: " .$anymatches , ""; } mysql_close($db); ?>