PageRenderTime 46ms CodeModel.GetById 23ms RepoModel.GetById 1ms app.codeStats 0ms

/functions/players.php

https://bitbucket.org/verax/to-ladder
PHP | 236 lines | 211 code | 23 blank | 2 comment | 20 complexity | b6c8628e569b4ba0074d6fd7afc2a53a MD5 | raw file
  1. <?
  2. $indexloaded=1;
  3. include("config/config.php");
  4. include("$dir[func]/global.php");
  5. $altcolora="#000033";
  6. $altcolorb="#000020";
  7. $altcolora="' class='altcolora";
  8. $altcolorb="' class='altcolorb";
  9. if(!$playerid){
  10. include("$dir[func]/error.php");
  11. display_error("Unknown Player ID.<br>");
  12. }
  13. $playerinfo=mysql_query("SELECT * FROM users WHERE id='$playerid'");
  14. $myinfo=mysql_fetch_array($playerinfo);
  15. if(!$myinfo[alias]){
  16. include("$dir[func]/error.php");
  17. display_error("Unknown User.<br>");
  18. }
  19. $playerinfo=mysql_query("SELECT *,DATE_FORMAT(joindate, '%M %d, %Y') FROM users WHERE id='$playerid'");
  20. $myinfo=mysql_fetch_array($playerinfo);
  21. if(!$myinfo[alias]){
  22. include("$dir[func]/error.php");
  23. display_error("Unknown Player.<br>");
  24. }
  25. $tablehead=table_head("show","100%","","left");
  26. $tablefoot=table_foot("show");
  27. $bannerhead=table_head("show","488","80","center");
  28. $bannerfoot=table_foot("show");
  29. $out[body]=$out[body]."
  30. <center>
  31. $bannerhead
  32. $out[banner]
  33. $bannerfoot
  34. </center>
  35. <br>
  36. $tablehead
  37. &nbsp; &nbsp;<strong><font class='catfont'>Player Information</font></strong><br>
  38. <hr class='catfont' size='1'>
  39. <table width='100%' border='0' bordercolor='#000000' cellspacing='0' cellpadding='0'>
  40. <tr>
  41. <td width='50%' valign='top' align='left'>
  42. <!-- PLAYER INFO -->
  43. <table width='100%' border='0' bordercolor='#000000' cellspacing='1' cellpadding='1'>
  44. <tr class='altcolor'>
  45. <td width='100%' valign='center' align='center' colspan='2'>
  46. <strong>Player Information</font></strong>
  47. </tr>
  48. <tr class='altcolorb'>
  49. <td width='40%' valign='center' align='left'>ID</td>
  50. <td width='60%' valign='center' align='right'>$playerid</td>
  51. </tr>
  52. <tr class='altcolorb'>
  53. <td width='40%' valign='center' align='left'>Name</td>
  54. <td width='60%' valign='center' align='right'>$myinfo[alias]</td>
  55. </tr>
  56. <tr class='altcolorb'>
  57. <td width='40%' valign='center' align='left'>Joindate</td>
  58. <td width='60%' valign='center' align='right'>$myinfo[joindate]</td>
  59. </tr>
  60. <tr class='altcolorb'>
  61. <td width='40%' valign='center' align='left'>Icq Number</td>
  62. <td width='60%' valign='center' align='right'>$myinfo[icq]</td>
  63. </tr>
  64. <tr class='altcolorb'>
  65. <td width='40%' valign='center' align='left'>Aim Name</td>
  66. <td width='60%' valign='center' align='right'>$myinfo[aim]</td>
  67. </tr>
  68. <tr class='altcolorb'>
  69. <td width='40%' valign='center' align='left'>MSN Messenger</td>
  70. <td width='60%' valign='center' align='right'>$myinfo[msn]</td>
  71. </tr>
  72. <tr class='altcolorb'>
  73. <td width='40%' valign='center' align='left'>Yahoo Messenger</td>
  74. <td width='60%' valign='center' align='right'>$myinfo[yahoo]</td>
  75. </tr>
  76. <tr class='altcolorb'>
  77. <td width='40%' valign='center' align='left'>Total Wins</td>
  78. <td width='60%' valign='center' align='right'>$myinfo[matcheswon]</td>
  79. </tr>
  80. <tr class='altcolorb'>
  81. <td width='40%' valign='center' align='left'>Total Losses</td>
  82. <td width='60%' valign='center' align='right'>$myinfo[matcheslost]</td>
  83. </tr>
  84. <tr class='altcolorb'>
  85. <td width='100%' valign='bottom' align='center' colspan='2'>
  86. Email Player <a href='mailto:$myinfo[email]'><img src='$url[themes]/images/email.gif' border='0'></a></td>
  87. </tr>
  88. <tr class='altcolorb'>
  89. <td width='100%' valign='bottom' align='center' colspan='2'><a href='$myinfo[website]' target='up'>Launch Player Website</a></td>
  90. </tr>
  91. </table>
  92. <!-- END PLAYER INFO -->
  93. </td>
  94. <td width='50%' height='100%' valign='top' align='right'>
  95. <!-- PLAYER LOGO -->
  96. <table width='100%' height='100%' border='0' bordercolor='#000000' cellspacing='1' cellpadding='1'>
  97. <tr class='altcolor'>
  98. <td width='100%' valign='top' align='center'>
  99. <strong>Player Logo</strong></td>
  100. </tr>
  101. <tr>
  102. <td width='100%' height='100%' valign='center' align='center'>";
  103. if(($myinfo[logo]) && ($myinfo[logo]!="http://")){
  104. $out[body]=$out[body]."<a href='$myinfo[website]' target='up'><img src='$myinfo[logo]' border='0'></a>";
  105. }else{
  106. $out[body]=$out[body]."<a href='$myinfo[website]' target='up'><img src='$misc[playerlogo]' border='0'></a>";
  107. }
  108. $out[body]=$out[body]."</td>
  109. </tr>
  110. </table>
  111. <!-- END PLAYER LOGO -->
  112. </td>
  113. </tr>
  114. </table>
  115. $tablefoot
  116. <br>
  117. $tablehead
  118. &nbsp; &nbsp;<strong><font class='catfont'>Team Information</font></strong><br>
  119. <hr class='catfont' size='1'>
  120. <table width='100%' border='0' bordercolor='#000000' cellspacing='0' cellpadding='0'>
  121. <table width='100%' border='0' bordercolor='#000000' cellspacing='1' cellpadding='2' bgcolor=''>
  122. <tr class='altcolor'>
  123. <td width='30%' valign='center' align='left'><strong>Team Name</strong></td>
  124. <td width='20%' valign='center' align='center'><strong>Team Type</strong></td>
  125. <td width='20%' valign='center' align='center'><strong>Status</strong></td>
  126. <td width='20%' valign='center' align='center'><strong>Joindate</strong></td>
  127. </tr>";
  128. $teamson=mysql_query("SELECT teamid,status,DATE_FORMAT(joindate, '%M %d, %Y') FROM teammembers WHERE playerid='$playerid' ORDER by joindate");
  129. while(list($team,$status,$joindate)=mysql_fetch_row($teamson)){
  130. $teaminfo=mysql_query("SELECT teamname,type FROM teams WHERE id='$team'");
  131. $tinfo=mysql_fetch_array($teaminfo);
  132. if($tinfo[type] == '1'){
  133. $teamtype = "Singles";
  134. }else if($tinfo[type] == '3'){
  135. $teamtype = "Team";
  136. }else{
  137. $teamtype = "";
  138. }
  139. $status=member_status($status);
  140. $out[body]=$out[body]."
  141. <tr class='altcolorb'><a name='$teamid'></a>
  142. <td width='30%' valign='center' align='left'><a href='$url[base]/$file[teams]?teamid=$team'>$tinfo[teamname]</a></td>
  143. <td width='20%' valign='center' align='center'>$teamtype</td>
  144. <td width='20%' valign='center' align='center'>$status</td>
  145. <td width='20%' valign='center' align='center'>$joindate</td>
  146. </tr>";
  147. $onteam=1;
  148. }
  149. if(!$onteam){
  150. $out[body]=$out[body]."
  151. <tr class='altcolorb'>
  152. <td width='100%' valign='center' align='center' colspan='4'>Not currently on any teams</td>
  153. </tr>";
  154. }
  155. $out[body]=$out[body]."</table>
  156. $tablefoot
  157. <br>
  158. $tablehead
  159. &nbsp; &nbsp;<strong><font class='catfont'>Admin Comments</font></strong><br>
  160. <hr class='catfont' size='1'>
  161. <table width='100%' border='0' bordercolor='#000000' cellspacing='1' cellpadding='2' bgcolor=''>
  162. <tr class='altcolor'>
  163. <td width='' valign='center' align='left'><strong>Comment</strong></td>
  164. <td width='150' valign='center' align='center'><strong>Added</strong></td>
  165. <td width='150' valign='center' align='center'><strong>By</strong></td>
  166. </tr>";
  167. //GET COMMENTS
  168. $getcomments=mysql_query("SELECT comment,addedby,DATE_FORMAT(added, '%M %d, %l:%i %p') FROM staffcomments WHERE id='$playerid' AND isateam='0' AND display='1' ORDER by added");
  169. while(list($comment,$addedby,$added)=mysql_fetch_row($getcomments)){
  170. $staffmember=mysql_query("SELECT displayname FROM staff WHERE id='$addedby'");
  171. $staff=mysql_fetch_array($staffmember);
  172. if($altladrow=="$altcolora"){
  173. $altladrow="$altcolorb";
  174. }else{
  175. $altladrow="$altcolora";
  176. }
  177. $out[body]=$out[body]."
  178. <tr bgcolor='$altladrow'>
  179. <td width='' valign='center' align='left'>$comment</td>
  180. <td width='150' valign='center' align='center'>$added</td>
  181. <td width='150' valign='center' align='center'>$staff[displayname]</td>
  182. </tr>";
  183. //Show Admin Comments Only Visible To Staff
  184. if ($admn[id]){
  185. $getcomments=mysql_query("SELECT comment,addedby,DATE_FORMAT(added, '%M %d, %l:%i %p') FROM staffcomments WHERE id='$playerid' AND isateam='0' AND display='0' ORDER by added");
  186. while(list($comment,$addedby,$added)=mysql_fetch_row($getcomments)){
  187. $staffmember=mysql_query("SELECT displayname FROM staff WHERE id='$addedby'");
  188. $staff=mysql_fetch_array($staffmember);
  189. $out[body]=$out[body]."
  190. <tr bgcolor='$altladrow'>
  191. <td width='' valign='center' align='left'>[Admin Visible Comment] $comment</td>
  192. <td width='150' valign='center' align='center'>$added</td>
  193. <td width='150' valign='center' align='center'>$staff[displayname]</td>
  194. </tr>
  195. ";
  196. }}
  197. }
  198. $out[body]=$out[body]."
  199. </table>
  200. $tablefoot";
  201. include("$dir[curtheme]");
  202. function member_status($status){
  203. if($status=="1"){ $status="Leader"; }
  204. if($status=="2"){ $status="Co-Leader"; }
  205. if($status=="3"){ $status="Captain"; }
  206. if($status=="4"){ $status="Co-Captain"; }
  207. if($status=="5"){ $status="Member"; }
  208. if($status=="6"){ $status="Training"; }
  209. if($status=="7"){ $status="Inactive"; }
  210. if($status=="8"){ $status="Suspended"; }
  211. return($status);
  212. }
  213. ?>