PageRenderTime 55ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/html/pages/players.php

https://github.com/graywh/utstats
PHP | 141 lines | 116 code | 22 blank | 3 comment | 17 complexity | 92159ba42416d7dbf048c095d7be1117 MD5 | raw file
    

  1. <?php

    2. 

  2. function InvertSort($curr_field, $filter, $sort)

    3. 

  3. {

    4. 

  4. 	if ($curr_field != $filter) return(($curr_field == "name") ? "ASC" : "DESC");

    5. 

  5. 	if ($sort == 'ASC') return('DESC');

    6. 

  6. 	return('ASC');

    7. 

  7. }

    8. 

  8. 

    9. 

  9. function SortPic($curr_field, $filter, $sort)

    10. 

  10. {

    11. 

  11. 	if ($curr_field != $filter) return;

    12. 

  12. 	$fname = 'images/s_'. strtolower($sort) .'.png';

    13. 

  13. 	if (!file_exists($fname)) return;

    14. 

  14. 	return('&nbsp;<img src="'. $fname .'" border="0" width="11" height="9" alt="" title="('.strtolower($sort).'ending)">');

    15. 

  15. }

    16. 

  16. 

    17. 

  17. 

    18. 

  18. // Get filter and set sorting

    19. 

  19. $filter = my_addslashes($_GET['filter']);

    20. 

  20. $sort = my_addslashes($_GET['sort']);

    21. 

  21. 

    22. 

  22. IF (empty($filter))

    23. 

  23. {

    24. 

  24. 	$filter = "name";

    25. 

  25. }

    26. 

  26. 

    27. 

  27. if (empty($sort) or ($sort != 'ASC' and $sort != 'DESC')) $sort = ($filter == "name") ? "ASC" : "DESC";

    28. 

  28. 

    29. 

  29. 

    30. 

  30. // Work out Prev, Next, First, Last Stuff

    31. 

  31. 

    32. 

  32. $r_pcount = small_query("SELECT COUNT(*) AS pcount FROM uts_pinfo");

    33. 

  33. $pcount = $r_pcount['pcount'];

    34. 

  34. 

    35. 

  35. $ecount = $pcount/50;

    36. 

  36. $ecount2 = number_format($ecount, 0, '.', '');

    37. 

  37. 

    38. 

  38. IF($ecount > $ecount2)

    39. 

  39. {

    40. 

  40. 	$ecount2 = $ecount2+1;

    41. 

  41. }

    42. 

  42. 

    43. 

  43. $fpage = 0;

    44. 

  44. IF($ecount < 1) { $lpage = 0; }

    45. 

  45. else { $lpage = $ecount2-1; }

    46. 

  46. 

    47. 

  47. $cpage = $_GET["page"];

    48. 

  48. IF ($cpage == "") { $cpage = "0"; }

    49. 

  49. $qpage = $cpage*50;

    50. 

  50. 

    51. 

  51. $tfpage = $cpage+1;

    52. 

  52. $tlpage = $lpage+1;

    53. 

  53. 

    54. 

  54. $ppage = $cpage-1;

    55. 

  55. $ppageurl = "<a class=\"pages\" href=\"./?p=players&amp;filter=$filter&amp;sort=$sort&amp;page=$ppage\">[Previous]</a>";

    56. 

  56. IF ($ppage < "0") { $ppageurl = "[Previous]"; }

    57. 

  57. 

    58. 

  58. $npage = $cpage+1;

    59. 

  59. $npageurl = "<a class=\"pages\" href=\"./?p=players&amp;filter=$filter&amp;sort=$sort&amp;page=$npage\">[Next]</a>";

    60. 

  60. IF ($npage >= "$ecount") { $npageurl = "[Next]"; }

    61. 

  61. 

    62. 

  62. $fpageurl = "<a class=\"pages\" href=\"./?p=players&amp;filter=$filter&amp;sort=$sort&amp;page=$fpage\">[First]</a>";

    63. 

  63. IF ($cpage == "0") { $fpageurl = "[First]"; }

    64. 

  64. 

    65. 

  65. $lpageurl = "<a class=\"pages\" href=\"./?p=players&amp;filter=$filter&amp;sort=$sort&amp;page=$lpage\">[Last]</a>";

    66. 

  66. IF ($cpage == "$lpage") { $lpageurl = "[Last]"; }

    67. 

  67. 

    68. 

  68. // Show information

    69. 

  69. echo'

    70. 

  70. <form NAME="playersearch" METHOD="post" ACTION="./?p=psearch">

    71. 

  71.   <table CLASS="searchformb">

    72. 

  72.     <tr>

    73. 

  73.       <td WIDTH="100" ALIGN="right">Name Search:</td>

    74. 

  74.       <td WIDTH="155" ALIGN="left"><input TYPE="text" NAME="name" MAXLENGTH="35" SIZE="20" CLASS="searchform"></td>

    75. 

  75.       <td WIDTH="80" ALIGN="left"><input TYPE="submit" NAME="Default" VALUE="Search" CLASS="searchformb"></td>

    76. 

  76.     </tr>

    77. 

  77.   </table>

    78. 

  78. <div class="opnote">* Enter a Partial Name *</div>

    79. 

  79. </form>

    80. 

  80. <div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>

    81. 

  81. <div class="opnote">* Click headings to change Sorting *</div>

    82. 

  82. <table class="box" border="0" cellpadding="1" cellspacing="1">

    83. 

  83.   <tbody><tr>

    84. 

  84.     <td class="heading" colspan="14" align="center">Unreal Tournament Player List</td>

    85. 

  85.   </tr>

    86. 

  86.   <tr>

    87. 

  87.     <td class="smheading" align="center" width="150"><a class="smheading" href="./?p=players&amp;filter=name&amp;sort='.InvertSort('name', $filter, $sort).'">Player Name</a>'.SortPic('name', $filter, $sort).'</td>

    88. 

  88.     <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&amp;filter=matches&amp;sort='.InvertSort('matches', $filter, $sort).'">Matches</a>'.SortPic('matches', $filter, $sort).'</td>

    89. 

  89.     <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&amp;filter=gamescore&amp;sort='.InvertSort('gamescore', $filter, $sort).'">Score</a>'.SortPic('gamescore', $filter, $sort).'</td>

    90. 

  90.     <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&amp;filter=frags&amp;sort='.InvertSort('frags', $filter, $sort).'">Frags</a>'.SortPic('frags', $filter, $sort).'</td>

    91. 

  91.     <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&amp;filter=kills&amp;sort='.InvertSort('kills', $filter, $sort).'">Kills</a>'.SortPic('kills', $filter, $sort).'</td>

    92. 

  92.     <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&amp;filter=deaths&amp;sort='.InvertSort('deaths', $filter, $sort).'">Deaths</a>'.SortPic('deaths', $filter, $sort).'</td>

    93. 

  93.     <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&amp;filter=suicides&amp;sort='.InvertSort('suicides', $filter, $sort).'">Suicides</a>'.SortPic('suicides', $filter, $sort).'</td>

    94. 

  94.     <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&amp;filter=teamkills&amp;sort='.InvertSort('teamkills', $filter, $sort).'">Team Kills</a>'.SortPic('teamkills', $filter, $sort).'</td>

    95. 

  95.     <td class="smheading" align="center" width="50"><a class="smheading" href="./?p=players&amp;filter=headshots&amp;sort='.InvertSort('headshots', $filter, $sort).'">Head Shots</a>'.SortPic('headshots', $filter, $sort).'</td>

    96. 

  96.     <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&amp;filter=eff&amp;sort='.InvertSort('eff', $filter, $sort).'">Eff.</a>'.SortPic('eff', $filter, $sort).'</td>

    97. 

  97.     <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&amp;filter=fph&amp;sort='.InvertSort('fph', $filter, $sort).'">FPH</a>'.SortPic('fph', $filter, $sort).'</td>

    98. 

  98.     <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&amp;filter=accuracy&amp;sort='.InvertSort('accuracy', $filter, $sort).'">Acc.</a>'.SortPic('accuracy', $filter, $sort).'</td>

    99. 

  99.     <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&amp;filter=ttl&amp;sort='.InvertSort('ttl', $filter, $sort).'">TTL</a>'.SortPic('ttl', $filter, $sort).'</td>

    100. 

  100.     <td class="smheading" align="center" width="45"><a class="smheading" href="./?p=players&amp;filter=gametime&amp;sort='.InvertSort('gametime', $filter, $sort).'">Hours</a>'.SortPic('gametime', $filter, $sort).'</td>

    101. 

  101.   </tr>';

    102. 

  102. 

    103. 

  103. $sql_plist = "SELECT    *

    104. 

  104.                 FROM    uts_career

    105. 

  105. 				ORDER BY    $filter $sort

    106. 

  106. 				LIMIT   $qpage,50";

    107. 

  107. 

    108. 

  108. $q_plist = mysql_query($sql_plist) or die(mysql_error());

    109. 

  109. while ($r_plist = mysql_fetch_array($q_plist))

    110. 

  110. {

    111. 

  111. 	  $gametime = sec2hour($r_plist['gametime']);

    112. 

  112. 	  $fph = get_dp($r_plist['fph']);

    113. 

  113. 	  $eff = get_dp($r_plist['eff']);

    114. 

  114. 	  $acc = get_dp($r_plist['accuracy']);

    115. 

  115. 	  $ttl = GetMinutes($r_plist['ttl']);

    116. 

  116. 	  $myurl = urlencode($r_pname);

    117. 

  117. 

    118. 

  118. 	  echo'

    119. 

  119. 	  <tr>

    120. 

  120. 		<td nowrap class="dark" align="left"><a class="darkhuman" href="./?p=pinfo&amp;pid='.$r_plist['id'].'">'.FormatPlayerName($r_plist['country'], $r_plist['id'], $r_plist['name']).'</a></td>

    121. 

  121. 		<td class="grey" align="center">'.$r_plist['matches'].'</td>

    122. 

  122. 		<td class="grey" align="center">'.$r_plist['gamescore'].'</td>

    123. 

  123. 		<td class="grey" align="center">'.$r_plist['frags'].'</td>

    124. 

  124. 		<td class="grey" align="center">'.$r_plist['kills'].'</td>

    125. 

  125. 		<td class="grey" align="center">'.$r_plist['deaths'].'</td>

    126. 

  126. 		<td class="grey" align="center">'.$r_plist['suicides'].'</td>

    127. 

  127. 		<td class="grey" align="center">'.$r_plist['teamkills'].'</td>

    128. 

  128. 		<td class="grey" align="center">'.$r_plist['headshots'].'</td>

    129. 

  129. 		<td class="grey" align="center">'.$eff.'</td>

    130. 

  130. 		<td class="grey" align="center">'.$fph.'</td>

    131. 

  131. 		<td class="grey" align="center">'.$acc.'</td>

    132. 

  132. 		<td class="grey" align="center">'.$ttl.'</td>

    133. 

  133. 		<td class="grey" align="center">'.$gametime.'</td>

    134. 

  134. 	  </tr>';

    135. 

  135. }

    136. 

  136. 

    137. 

  137. echo'

    138. 

  138. </tbody></table>

    139. 

  139. <div class="pages"><b>Page ['.$tfpage.'/'.$tlpage.'] Selection: '.$fpageurl.' / '.$ppageurl.' / '.$npageurl.' / '.$lpageurl.'</b></div>

    140. 

  140. ';

    141. 

  141. ?>

    142. 

  142.