PageRenderTime 47ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/functions/admin_editteam.php

https://bitbucket.org/verax/to-ladder
PHP | 837 lines | 783 code | 47 blank | 7 comment | 39 complexity | 070bf7a8e79c5d62fd873b75c4fc6fe5 MD5 | raw file
    

  1. <?

    2. 

  2. if(!IsSet($indexloaded)){

    3. 

  3.     header("Location: ./index.php");

    4. 

  4. }

    5. 

  5. 

    6. 

  6. //CHECK ADMIN ACCESS LEVEL

    7. 

  7. if($admn[access] < 15){

    8. 

  8.     include("$dir[func]/error.php");

    9. 

  9.     display_error("You are not allowed to perform this function.<br>");

    10. 

  10. }

    11. 

  11. 

    12. 

  12. function admin_editateam(){

    13. 

  13.     global $dir, $url, $out, $site, $admn;

    14. 

  14.     //GET LADDERS

    15. 

  15.     $ladderslist=mysql_query("SELECT id,laddername  FROM ladders ORDER by laddername");

    16. 

  16.     while(list($id,$name)=mysql_fetch_row($ladderslist)){

    17. 

  17.         $theladders=$theladders."<option value='$id'>$name</option>";

    18. 

  18.         $foundladders=1;

    19. 

  19.     }

    20. 

  20. 

    21. 

  21.     if(!$foundladders){

    22. 

  22.         include("$dir[func]/error.php");

    23. 

  23.         display_error("There are no ladders.<br>");

    24. 

  24.     }

    25. 

  25. 

    26. 

  26.     $tablehead=table_head("show","100%","","center");

    27. 

  27.     $tablefoot=table_foot("show");

    28. 

  28.     $bannerhead=table_head("show","488","80","center");

    29. 

  29.     $bannerfoot=table_foot("show");

    30. 

  30.     $out[body]=$out[body]."

    31. 

  31.     <center>

    32. 

  32.     $bannerhead

    33. 

  33.     $out[banner]

    34. 

  34.     $bannerfoot

    35. 

  35.     </center>

    36. 

  36.     <br>

    37. 

  37.     $tablehead

    38. 

  38.     <table width='100%' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    39. 

  39.     <tr class='altcolor'>

    40. 

  40.     <form method='post'>

    41. 

  41.     <td width='100%' valign='top' align='center'>

    42. 

  42.     <strong>Edit a Team</strong><br>

    43. 

  43.     </td>

    44. 

  44.     </tr>

    45. 

  45.     <tr>

    46. 

  46.     <td width='100%' valign='center' align='center'>

    47. 

  47.     <br>

    48. 

  48.     Select a ladder<br>

    49. 

  49.     <select name='ladderid'>$theladders</select><br>

    50. 

  50.     <br></td>

    51. 

  51.     </tr>

    52. 

  52.     <tr class='altcolor'>

    53. 

  53.     <td width='100%' valign='top' align='center'>

    54. 

  54.     <input type='hidden' name='action' value='editateamb'>

    55. 

  55.     <input type='submit' name='' value='Find Team'>

    56. 

  56.     </td>

    57. 

  57.     </form>

    58. 

  58.     </tr>

    59. 

  59.     </table>

    60. 

  60.     $tablefoot";

    61. 

  61.     include("$dir[curtheme]");

    62. 

  62. }

    63. 

  63. 

    64. 

  64. function admin_editateamb($ladderid){

    65. 

  65.     global $dir, $url, $out, $site, $admn;

    66. 

  66.     if(!$ladderid){

    67. 

  67.         include("$dir[func]/error.php");

    68. 

  68.         display_error("Invalid Ladder ID.<br>");

    69. 

  69.     }

    70. 

  70. 

    71. 

  71.     if($admn[access] < 99){

    72. 

  72.         if (mysql_num_rows(mysql_query("SELECT staffid FROM staffaccess WHERE staffid='$admn[id]' AND ladderid='$ladderid'")) < 1){

    73. 

  73.             include("$dir[func]/error.php");

    74. 

  74.             display_error("You are not allowed to manage teams on this laddder.<br>");

    75. 

  75.         }

    76. 

  76. 

    77. 

  77.     }

    78. 

  78. 

    79. 

  79.     //GET TEAMS

    80. 

  80.     $teamslist=mysql_query("SELECT id FROM ladder_$ladderid");

    81. 

  81.     while(list($id)=mysql_fetch_row($teamslist)){

    82. 

  82.         $name=mysql_fetch_array(mysql_query("SELECT teamname FROM teams WHERE id='$id' ORDER BY teamname"));

    83. 

  83.         $theteams=$theteams."<option value='$id'>$name[teamname]</option>";

    84. 

  84.         $foundladders=1;

    85. 

  85.     }

    86. 

  86. 

    87. 

  87.     if(!$foundladders){

    88. 

  88.         include("$dir[func]/error.php");

    89. 

  89.         display_error("There are no teams on this ladder.<br>");

    90. 

  90.     }

    91. 

  91. 

    92. 

  92.     $tablehead=table_head("show","100%","","center");

    93. 

  93.     $tablefoot=table_foot("show");

    94. 

  94.     $bannerhead=table_head("show","488","80","center");

    95. 

  95.     $bannerfoot=table_foot("show");

    96. 

  96.     $out[body]=$out[body]."

    97. 

  97.     <center>

    98. 

  98.     $bannerhead

    99. 

  99.     $out[banner]

    100. 

  100.     $bannerfoot

    101. 

  101.     </center>

    102. 

  102.     <br>

    103. 

  103.     $tablehead

    104. 

  104.     <table width='100%' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    105. 

  105.     <tr class='altcolor'>

    106. 

  106.     <form method='post'>

    107. 

  107.     <td width='100%' valign='top' align='center'>

    108. 

  108.     <strong>Edit a Team</strong><br>

    109. 

  109.     </td>

    110. 

  110.     </tr>

    111. 

  111.     <tr>

    112. 

  112.     <td width='100%' valign='center' align='center'>

    113. 

  113.     <br>

    114. 

  114.     <select name='teamid'>$theteams</select><br>

    115. 

  115.     <br></td>

    116. 

  116.     </tr>

    117. 

  117.     <script language='javascript'>var confirmdelete='Are you sure you want to DELETE this team';</script>

    118. 

  118.     <script language='javascript'>var confirmleave='Are you sure you want to REMOVE this team from this ladder';</script>

    119. 

  119.     <tr class='altcolor'>

    120. 

  120.     <td width='100%' valign='top' align='center'>

    121. 

  121.     <input type='hidden' name='action' value='editateamc'>

    122. 

  122.     <input type='hidden' name='ladderid' value='$ladderid'>

    123. 

  123.     <input type='submit' name='todo' value='Edit Team'>

    124. 

  124.     <input type='submit' name='todo' value='Manage Members'> ";

    125. 

  125.     if($admn[access] >= 20){

    126. 

  126.         $out[body]=$out[body]."

    127. 

  127.         <input type='submit' name='todo' value='Delete Team' onClick='return confirm(confirmdelete);'>

    128. 

  128.         <input type='submit' name='todo' value='Remove From Ladder' onClick='return confirm(confirmleave);'>";

    129. 

  129.     }

    130. 

  130. 

    131. 

  131.     $out[body]=$out[body]."</td>

    132. 

  132.     </form>

    133. 

  133.     </tr>

    134. 

  134.     </table>

    135. 

  135.     $tablefoot";

    136. 

  136.     include("$dir[curtheme]");

    137. 

  137. }

    138. 

  138. 

    139. 

  139. function admin_editateamc($ladderid,$teamid,$todo){

    140. 

  140.     global $dir, $url, $out, $site, $admn;

    141. 

  141.     if(!$ladderid){

    142. 

  142.         include("$dir[func]/error.php");

    143. 

  143.         display_error("Invalid Ladder ID.<br>");

    144. 

  144.     }

    145. 

  145. 

    146. 

  146.     if(!$teamid){

    147. 

  147.         include("$dir[func]/error.php");

    148. 

  148.         display_error("Invalid Team ID.<br>");

    149. 

  149.     }

    150. 

  150. 

    151. 

  151.     if($todo=="Edit Team"){

    152. 

  152.         edit_team($ladderid,$teamid);

    153. 

  153.     }

    154. 

  154. 

    155. 

  155.     else if($todo=="Manage Members"){

    156. 

  156.         manage_teammembers($ladderid,$teamid);

    157. 

  157.     }

    158. 

  158. 

    159. 

  159.     else if($todo=="Delete Team"){

    160. 

  160.         delete_team($teamid);

    161. 

  161.     }

    162. 

  162. 

    163. 

  163.     else if($todo=="Remove From Ladder"){

    164. 

  164.         leave_ladder($ladderid,$teamid);

    165. 

  165.         include("$dir[func]/admin_finishmessage.php");

    166. 

  166.         display_message("The team was removed from the ladder.<br>");

    167. 

  167.     }

    168. 

  168. 

    169. 

  169.     else{

    170. 

  170.         include("$dir[func]/error.php");

    171. 

  171.         display_error("Unknwon Command.<br>");

    172. 

  172.     }

    173. 

  173. 

    174. 

  174. }

    175. 

  175. 

    176. 

  176. function edit_team($ladderid,$teamid){

    177. 

  177.     global $dir, $url, $out, $site, $admn;

    178. 

  178.     $teaminfo=mysql_query("SELECT * FROM teams WHERE id='$teamid'");

    179. 

  179.     $tinfo=mysql_fetch_array($teaminfo);

    180. 

  180.     if(!$tinfo[teamname]){

    181. 

  181.         include("$dir[func]/error.php");

    182. 

  182.         display_error("Unknown Team.<br>");

    183. 

  183.     }

    184. 

  184. 

    185. 

  185.     $tladderinfo=mysql_query("SELECT * FROM ladder_$ladderid WHERE id='$teamid'");

    186. 

  186.     $tlinfo=mysql_fetch_array($tladderinfo);

    187. 

  187.     if($tlinfo[id]!="$teamid"){

    188. 

  188.         include("$dir[func]/error.php");

    189. 

  189.         display_error("Team is missing from the ladder.<br>Delete the team then restore it.<br>");

    190. 

  190.     }

    191. 

  191. 

    192. 

  192.     //TABLE ATERNATING COLORS

    193. 

  193.     $altcolora="#000033";

    194. 

  194.     $altcolorb="#000020";

    195. 

  195.     if($tinfo[tagplace]=="0"){

    196. 

  196.         $checkeda="CHECKED";

    197. 

  197.         $checkedb="";

    198. 

  198.     }else{

    199. 

  199. 

    200. 

  200.         $checkeda="";

    201. 

  201.         $checkedb="CHECKED";

    202. 

  202.     }

    203. 

  203. 

    204. 

  204.     //CHANGE SPECIAL CHARECTERS BACK

    205. 

  205.     include("$dir[func]/checkdata.php");

    206. 

  206.     $tinfo[teamname]=unchange_charecters($tinfo[teamname]);

    207. 

  207.     $tinfo[tag]=unchange_charecters($tinfo[tag]);

    208. 

  208.     $tablehead=table_head("show","100%","","center");

    209. 

  209.     $tablefoot=table_foot("show");

    210. 

  210.     $bannerhead=table_head("show","488","80","center");

    211. 

  211.     $bannerfoot=table_foot("show");

    212. 

  212.     $out[body]=$out[body]."

    213. 

  213.     <center>

    214. 

  214.     $bannerhead

    215. 

  215.     $out[banner]

    216. 

  216.     $bannerfoot

    217. 

  217.     </center>

    218. 

  218.     <br>

    219. 

  219.     $tablehead

    220. 

  220.     <table width='100%' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    221. 

  221.     <tr class='altcolor'>

    222. 

  222.     <td width='100%' valign='top' align='center'>

    223. 

  223.     <font class='catfont'><strong>Edit a team</strong></font></td>

    224. 

  224.     </tr>

    225. 

  225.     <tr>

    226. 

  226.     <td width='100%' valign='top' align='left'>";

    227. 

  227.     $iconurl="$url[themes]/icons/";

    228. 

  228.     $out[body]=$out[body]."

    229. 

  229.     <SCRIPT type='text/javascript'>

    230. 

  230.     <!--

    231. 

  231.     function changeicon() {

    232. 

  232.         if (!document.images)

    233. 

  233.         return

    234. 

  234.         document.images.iconspot.src='$iconurl' + document.teamedit.t_icon.options[document.teamedit.t_icon.selectedIndex].value

    235. 

  235.     }

    236. 

  236. 

    237. 

  237.     //-->

    238. 

  238.     </SCRIPT>

    239. 

  239.     <form method='post' name='teamedit'>

    240. 

  240.     <table width='100%' border='0' cellspacing='0' cellpadding='0' valign='top' align='center'>

    241. 

  241.     <tr class='altcolora'>

    242. 

  242.     <td width='50%' valign='center' align='left'>

    243. 

  243.     <font face='veradna,arial' size='2' color='#FFFFFF'>* Team Name</font></td>

    244. 

  244.     <td width='50%' valign='center' align='center'>

    245. 

  245.     <input type='text' name='t_alias' value='$tinfo[teamname]' size='30' maxlength='25'></td>

    246. 

  246.     </tr>

    247. 

  247.     <tr class='altcolorb'>

    248. 

  248.     <td width='50%' valign='center' align='left'>

    249. 

  249.     <font face='veradna,arial' size='2' color='#FFFFFF'>* Team Email</font></td>

    250. 

  250.     <td width='50%' valign='center' align='center'>

    251. 

  251.     <input type='text' name='t_email' value='$tinfo[teamemail]' size='30' maxlength='50'></td>

    252. 

  252.     </tr>

    253. 

  253.     <tr class='altcolora'>

    254. 

  254.     <td width='50%' valign='center' align='left'>

    255. 

  255.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    256. 

  256.     Tag</font></td>

    257. 

  257.     <td width='50%' valign='center' align='center'>

    258. 

  258.     <input type='text' name='t_tag' value='$tinfo[tag]' size='30' maxlength='10'></td>

    259. 

  259.     </tr>

    260. 

  260.     <tr class='altcolorb'>

    261. 

  261.     <td width='50%' valign='center' align='left'>

    262. 

  262.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    263. 

  263.     Tag Placement</font></td>

    264. 

  264.     <td width='50%' valign='center' align='center'>

    265. 

  265.     Before Name: <input type='radio' name='t_tagplace' value='0' $checkeda>

    266. 

  266.     After: <input type='radio' name='t_tagplace' value='1' $checkedb></td>

    267. 

  267.     </tr>

    268. 

  268.     <tr class='altcolora'>

    269. 

  269.     <td width='50%' valign='center' align='left'>

    270. 

  270.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    271. 

  271.     Team Website</font></td>

    272. 

  272.     <td width='50%' valign='center' align='center'>

    273. 

  273.     <input type='text' name='t_url' value='$tinfo[website]' size='30' maxlength='100'></td>

    274. 

  274.     </tr>

    275. 

  275.     <tr class='altcolorb'>

    276. 

  276.     <td width='50%' valign='center' align='left'>

    277. 

  277.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    278. 

  278.     Team Logo</font></td>

    279. 

  279.     <td width='50%' valign='center' align='center'>

    280. 

  280.     <input type='text' name='t_logo' value='$tinfo[logo]' size='30' maxlength='100'></td>

    281. 

  281.     </tr>

    282. 

  282.     <tr class='altcolora'>

    283. 

  283.     <td width='50%' valign='center' align='left'>

    284. 

  284.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    285. 

  285.     Contact Method (Irc Channel@Server or Icq)</font></td>

    286. 

  286.     <td width='50%' valign='center' align='center'>

    287. 

  287.     <input type='text' name='t_contact' value='$tinfo[contact]' size='30' maxlength='50'></td>

    288. 

  288.     </tr>

    289. 

  289.     </table>

    290. 

  290.     <table width='100%' border='0' cellspacing='0' cellpadding='2' valign='top' align='center'>

    291. 

  291.     <tr class='altcolor'>

    292. 

  292.     <td width='100%' valign='top' align='center' colspan='2' >

    293. 

  293.     <font class='catfont'><strong>Ladder #$ladderid Stats</strong></font></td>

    294. 

  294.     </tr>

    295. 

  295.     <table width='100%' border='0' cellspacing='0' cellpadding='0' valign='top' align='center'>

    296. 

  296.     <tr class='altcolorb'>

    297. 

  297.     <td width='50%' valign='center' align='left'>

    298. 

  298.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    299. 

  299.     Current Rank</font></td>

    300. 

  300.     <td width='50%' valign='center' align='center'>

    301. 

  301.     <input type='text' name='t_rank' value='$tlinfo[rank]' size='30' maxlength='5'></td>

    302. 

  302.     </tr>

    303. 

  303.     <tr class='altcolora'>

    304. 

  304.     <td width='50%' valign='center' align='left'>

    305. 

  305.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    306. 

  306.     Last Rank</font></td>

    307. 

  307.     <td width='50%' valign='center' align='center'>

    308. 

  308.     <input type='text' name='t_lrank' value='$tlinfo[lastrank]' size='30' maxlength='5'></td>

    309. 

  309.     </tr>

    310. 

  310.     <tr class='altcolorb'>

    311. 

  311.     <td width='50%' valign='center' align='left'>

    312. 

  312.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    313. 

  313.     Best Rank</font></td>

    314. 

  314.     <td width='50%' valign='center' align='center'>

    315. 

  315.     <input type='text' name='t_brank' value='$tlinfo[bestrank]' size='30' maxlength='5'></td>

    316. 

  316.     </tr>

    317. 

  317.     <tr class='altcolora'>

    318. 

  318.     <td width='50%' valign='center' align='left'>

    319. 

  319.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    320. 

  320.     Worst Rank</font></td>

    321. 

  321.     <td width='50%' valign='center' align='center'>

    322. 

  322.     <input type='text' name='t_wrank' value='$tlinfo[worstrank]' size='30' maxlength='5'></td>

    323. 

  323.     </tr>

    324. 

  324.     <tr class='altcolorb'>

    325. 

  325.     <td width='50%' valign='center' align='left'>

    326. 

  326.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    327. 

  327.     Wins</font></td>

    328. 

  328.     <td width='50%' valign='center' align='center'>

    329. 

  329.     <input type='text' name='t_wins' value='$tlinfo[wins]' size='30' maxlength='5'></td>

    330. 

  330.     </tr>

    331. 

  331.     <tr class='altcolora'>

    332. 

  332.     <td width='50%' valign='center' align='left'>

    333. 

  333.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    334. 

  334.     Losses</font></td>

    335. 

  335.     <td width='50%' valign='center' align='center'>

    336. 

  336.     <input type='text' name='t_loss' value='$tlinfo[losses]' size='30' maxlength='5'></td>

    337. 

  337.     </tr>

    338. 

  338.     <tr class='altcolorb'>

    339. 

  339.     <td width='50%' valign='center' align='left'>

    340. 

  340.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    341. 

  341.     Streak</font></td>

    342. 

  342.     <td width='50%' valign='center' align='center'>

    343. 

  343.     <input type='text' name='t_streak' value='$tlinfo[streak]' size='30' maxlength='5'></td>

    344. 

  344.     </tr>

    345. 

  345.     <tr class='altcolora'>

    346. 

  346.     <td width='50%' valign='center' align='left'>

    347. 

  347.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    348. 

  348.     Best Streak</font></td>

    349. 

  349.     <td width='50%' valign='center' align='center'>

    350. 

  350.     <input type='text' name='t_bstreak' value='$tlinfo[beststreak]' size='30' maxlength='5'></td>

    351. 

  351.     </tr>

    352. 

  352.     <tr class='altcolorb'>

    353. 

  353.     <td width='50%' valign='center' align='left'>

    354. 

  354.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    355. 

  355.     Worst Streak</font></td>

    356. 

  356.     <td width='50%' valign='center' align='center'>

    357. 

  357.     <input type='text' name='t_wstreak' value='$tlinfo[worststreak]' size='30' maxlength='5'></td>

    358. 

  358.     </tr>

    359. 

  359.     <tr class='altcolora'>

    360. 

  360.     <td width='50%' valign='center' align='left'>

    361. 

  361.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    362. 

  362.     Icon</font></td>

    363. 

  363.     <td width='50%' valign='center' align='center'>

    364. 

  364.     <select name='t_icon' onChange='changeicon()'>

    365. 

  365.     <option value='blank.gif'>None</option>";

    366. 

  366.     $iconnum="$tlinfo[icon]";

    367. 

  367.     $selected[$iconnum]="SELECTED";

    368. 

  368.     $iconsdir=opendir("$dir[themes]/icons/");

    369. 

  369.     while (($file = readdir($iconsdir))!==false) {

    370. 

  370.         $splitfile=split("\.", $file);

    371. 

  371.         if(($splitfile[1]=="gif") && ($splitfile[0]!="blank")){

    372. 

  372.             $thisiconnum="$splitfile[0]";

    373. 

  373.             $out[body]=$out[body]."

    374. 

  374.             <option value='$file' $selected[$thisiconnum]>$splitfile[0]</option>";

    375. 

  375.         }

    376. 

  376. 

    377. 

  377.     }

    378. 

  378. 

    379. 

  379.     closedir($iconsdir);

    380. 

  380.     if($iconnum){

    381. 

  381.         $thisgif="$iconnum";

    382. 

  382.     }else{

    383. 

  383. 

    384. 

  384.         $thisgif="blank";

    385. 

  385.     }

    386. 

  386. 

    387. 

  387.     $out[body]=$out[body]."

    388. 

  388.     </select>

    389. 

  389.     <img src='$url[themes]/icons/$thisgif.gif' name='iconspot'>

    390. 

  390.     </td>

    391. 

  391.     </tr>

    392. 

  392.     <tr class='altcolorb'>

    393. 

  393.     <td width='50%' valign='center' align='left'>

    394. 

  394.     <font face='veradna,arial' size='2' color='#FFFFFF'>

    395. 

  395.     Lock</font></td>

    396. 

  396.     <td width='50%' valign='center' align='center'>

    397. 

  397.     <img src='$url[themes]/images/lock.gif'>

    398. 

  398.     <select name='t_lock'>";

    399. 

  399.     $tday=date("Y-m-d H:i:s");

    400. 

  400.     if(($tlinfo[status]=="10") && ($tlinfo[statusdate] > $tday)){

    401. 

  401.         $out[body]=$out[body]."<option value='0'>Locked</option>";

    402. 

  402.     }else{

    403. 

  403. 

    404. 

  404.         $out[body]=$out[body]."<option value='0'>None</option>";

    405. 

  405.     }

    406. 

  406. 

    407. 

  407.     $out[body]=$out[body]."

    408. 

  408.     <option value='1'>Unlock</option>

    409. 

  409.     <option value='24'>24 hours</option>

    410. 

  410.     <option value='48'>2 days</option>

    411. 

  411.     <option value='72'>3 days</option>

    412. 

  412.     <option value='96'>4 days</option>

    413. 

  413.     <option value='120'>5 days</option>

    414. 

  414.     <option value='144'>6 days</option>

    415. 

  415.     <option value='168'>1 Week</option>

    416. 

  416.     <option value='336'>2 Weeks</option>

    417. 

  417.     <option value='50000'>Indefinite</option>

    418. 

  418.     </select></td>

    419. 

  419.     </tr>

    420. 

  420.     </table>

    421. 

  421.     </td>

    422. 

  422.     </tr>

    423. 

  423.     <tr class='altcolor'>

    424. 

  424.     <td width='100%' valign='top' align='center'>

    425. 

  425.     <input type='hidden' name='action' value='editateamd'>

    426. 

  426.     <input type='hidden' name='teamid' value='$teamid'>

    427. 

  427.     <input type='hidden' name='ladderid' value='$ladderid'>

    428. 

  428.     <input type='submit' name='' value='Update Team'>

    429. 

  429.     <input type='reset' name='' value='Reset'></td>

    430. 

  430.     </form>

    431. 

  431.     </tr>

    432. 

  432.     </table>

    433. 

  433.     $tablefoot";

    434. 

  434.     include("$dir[curtheme]");

    435. 

  435. }

    436. 

  436. 

    437. 

  437. function admin_editateamd($teamid,$ladderid,$t_alias,$t_email,$t_tag,$t_tagplace,$t_url,$t_logo,$t_contact,$t_rank,$t_lrank,$t_brank,$t_wrank,$t_wins,$t_loss,$t_streak,$t_bstreak,$t_wstreak,$t_points,$t_skill,$t_money,$t_forfeits,$t_icon,$t_lock){

    438. 

  438.     global $dir, $url, $out, $site, $admn;

    439. 

  439.     if(!$teamid){

    440. 

  440.         include("$dir[func]/error.php");

    441. 

  441.         display_error("Invalid Team ID.<br>");

    442. 

  442.     }

    443. 

  443. 

    444. 

  444.     if(!$ladderid){

    445. 

  445.         include("$dir[func]/error.php");

    446. 

  446.         display_error("Invalid Ladder name.<br>");

    447. 

  447.     }

    448. 

  448. 

    449. 

  449.     if(!$t_alias){

    450. 

  450.         include("$dir[func]/error.php");

    451. 

  451.         display_error("Invalid Team name.<br>");

    452. 

  452.     }

    453. 

  453. 

    454. 

  454.     if(!$t_email){

    455. 

  455.         include("$dir[func]/error.php");

    456. 

  456.         display_error("Invalid Team email.<br>");

    457. 

  457.     }

    458. 

  458. 

    459. 

  459.     include("$dir[func]/checkdata.php");

    460. 

  460.     $t_alias=change_charecters($t_alias);

    461. 

  461.     $t_email=change_charecters($t_email);

    462. 

  462.     $t_tag=change_charecters($t_tag);

    463. 

  463.     $t_tagplace=change_numbersonly($t_tagplace);

    464. 

  464.     $t_url=change_url($t_url);

    465. 

  465.     $t_logo=change_url($t_logo);

    466. 

  466.     $t_url=change_charecters($t_url);

    467. 

  467.     $t_logo=change_charecters($t_logo);

    468. 

  468.     $t_contact=change_charecters($t_contact);

    469. 

  469.     $t_icon=change_numbersonly($t_icon);

    470. 

  470.     $errormessage=check_validlength($errormessage, $t_alias, "3", "50", "Your team name be 3-25 Characters");

    471. 

  471.     $errormessage=check_validlength($errormessage, $t_tag, "0", "25", "Your Tag cannot Exceed 10 Characters");

    472. 

  472.     $errormessage=check_validlength($errormessage, $t_email, "5", "100", "Your must include a valid team email.<br>Team Email cannot exceed 50 characters");

    473. 

  473.     error_check($errormessage);

    474. 

  474.     $errormessage=check_emailaddress($t_email);

    475. 

  475.     error_check($errormessage);

    476. 

  476.     $errormessage=check_ban($errormessage, $t_alias, $email, $ip);

    477. 

  477.     error_check($errormessage);

    478. 

  478.     mysql_query("UPDATE teams SET

    479. 

  479.     teamname='$t_alias',

    480. 

  480.     teamemail='$t_email',

    481. 

  481.     tag='$t_tag',

    482. 

  482.     tagplace='$t_tagplace',

    483. 

  483.     website='$t_url',

    484. 

  484.     logo='$t_logo',

    485. 

  485.     contact='$t_contact'

    486. 

  486.     WHERE id='$teamid'");

    487. 

  487.     if($t_lock=="1"){

    488. 

  488.         mysql_query("UPDATE ladder_$ladderid SET status='0' WHERE id='$teamid'");

    489. 

  489.     }

    490. 

  490. 

    491. 

  491.     else if($t_lock >= 24){

    492. 

  492.         $lcokeduntill=date("Y-m-d H:i:s",time()+60*60*$t_lock);

    493. 

  493.         mysql_query("UPDATE ladder_$ladderid SET status='10', statusdate='$lcokeduntill' WHERE id='$teamid'");

    494. 

  494.     }

    495. 

  495. 

    496. 

  496.     if($t_wins > 0){

    497. 

  497.         $games=($t_wins + $t_loss);

    498. 

  498.         $percent=round($t_wins / $games * 100);

    499. 

  499.     }else{

    500. 

  500. 

    501. 

  501.         $games="$t_loss";

    502. 

  502.         $percent="0";

    503. 

  503.     }

    504. 

  504. 

    505. 

  505.     mysql_query("UPDATE ladder_$ladderid SET

    506. 

  506.     lastrank='$t_lrank',

    507. 

  507.     bestrank='$t_brank',

    508. 

  508.     worstrank='$t_wrank',

    509. 

  509.     wins='$t_wins',

    510. 

  510.     losses='$t_loss',

    511. 

  511.     games='$games',

    512. 

  512.     percent='$percent',

    513. 

  513.     streak='$t_streak',

    514. 

  514.     beststreak='$t_bstreak',

    515. 

  515.     worststreak='$t_wstreak',

    516. 

  516.     points='$t_points',

    517. 

  517.     skill='$t_skill',

    518. 

  518.     money='$t_money',

    519. 

  519.     forfeits='$t_forfeits',

    520. 

  520.     icon='$t_icon'

    521. 

  521.     WHERE id='$teamid'");

    522. 

  522.     include("$dir[func]/rankadjust.php");

    523. 

  523.     update_teamranks($ladderid,$teamid,$t_rank);

    524. 

  524.     $ranksadjusted=rank_checkadjust($ladderid);

    525. 

  525.     include("$dir[func]/admin_finishmessage.php");

    526. 

  526.     display_message("The team $t_alias was updated.<br>");

    527. 

  527. }

    528. 

  528. 

    529. 

  529. function manage_teammembers($ladderid,$teamid){

    530. 

  530.     global $dir, $url, $out, $site, $admn;

    531. 

  531.     $tablehead=table_head("show","100%","","center");

    532. 

  532.     $tablefoot=table_foot("show");

    533. 

  533.     $bannerhead=table_head("show","488","80","center");

    534. 

  534.     $bannerfoot=table_foot("show");

    535. 

  535.     $out[body]=$out[body]."

    536. 

  536.     <center>

    537. 

  537.     $bannerhead

    538. 

  538.     $out[banner]

    539. 

  539.     $bannerfoot

    540. 

  540.     </center>

    541. 

  541.     <br>

    542. 

  542.     $tablehead

    543. 

  543.     <table width='100%' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    544. 

  544.     <tr class='altcolor'>

    545. 

  545.     <td width='100%' valign='top' align='center'>

    546. 

  546.     <strong>Manage Team Members</strong><br>

    547. 

  547.     </td>

    548. 

  548.     </tr>

    549. 

  549.     <tr>

    550. 

  550.     <td width='100%' valign='center' align='center'>

    551. 

  551.     <br>

    552. 

  552.     <table width='100%' border='0'  cellspacing='0' cellpadding='0'>

    553. 

  553.     <tr>

    554. 

  554.     <td width='40%' valign='top' align='left'>

    555. 

  555.     <strong>Player Name</strong></td>

    556. 

  556.     <td width='20%' valign='top' align='left'>

    557. 

  557.     <strong>Joined Team</strong></td>

    558. 

  558.     <td width='40%' valign='top' align='center'>

    559. 

  559.     <strong>Member Rank</strong></td>

    560. 

  560.     </tr>

    561. 

  561.     <form method='post'>";

    562. 

  562.     //TABLE ATERNATING COLORS

    563. 

  563.     $altcolora="#000033";

    564. 

  564.     $altcolorb="#000020";

    565. 

  565.     $listmembers=mysql_query("SELECT playerid,status,DATE_FORMAT(joindate, '%M %d, %Y') FROM teammembers WHERE teamid='$teamid' ORDER by joindate");

    566. 

  566.     while(list($playerid,$status,$joindate)=mysql_fetch_row($listmembers)){

    567. 

  567.         $memberinfo=mysql_query("SELECT alias FROM users WHERE id='$playerid'");

    568. 

  568.         $playerinfo=mysql_fetch_array($memberinfo);

    569. 

  569.         if($altladrow=="$altcolora"){

    570. 

  570.             $altladrow="$altcolorb";

    571. 

  571.         }else{

    572. 

  572. 

    573. 

  573.             $altladrow="$altcolora";

    574. 

  574.         }

    575. 

  575. 

    576. 

  576.         $selected[$status]="SELECTED";

    577. 

  577.         $out[body]=$out[body]."

    578. 

  578.         <tr bgcolor='$altladrow'>

    579. 

  579.         <td width='40%' valign='top' align='left'>

    580. 

  580.         $playerinfo[alias]</td>

    581. 

  581.         <td width='20%' valign='top' align='left'>

    582. 

  582.         $joindate</td>

    583. 

  583.         <td width='40%' valign='top' align='center'>

    584. 

  584.         <select name='memberrank[$playerid]'>

    585. 

  585.         <option value='1' $selected[1]>Leader</option>

    586. 

  586.         <option value='2' $selected[2]>Co-Leader</option>

    587. 

  587.         <option value='3' $selected[3]>Captain</option>

    588. 

  588.         <option value='4' $selected[4]>Co-Captain</option>

    589. 

  589.         <option value='5' $selected[5]>Member</option>

    590. 

  590.         <option value='6' $selected[6]>Training</option>

    591. 

  591.         <option value='7' $selected[7]>Inactive</option>

    592. 

  592.         <option value='8' $selected[8]>Suspended</option>

    593. 

  593.         <option value='9' $selected[9]>Kick</option>

    594. 

  594.         </select></td>

    595. 

  595.         </tr>";

    596. 

  596.         $selected[$status]="";

    597. 

  597.     }

    598. 

  598. 

    599. 

  599.     $out[body]=$out[body]."

    600. 

  600.     </table>

    601. 

  601.     <br></td>

    602. 

  602.     </tr>

    603. 

  603.     <tr class='altcolor'>

    604. 

  604.     <td width='100%' valign='top' align='center'>

    605. 

  605.     <input type='hidden' name='action' value='editateame'>

    606. 

  606.     <input type='hidden' name='teamid' value='$teamid'>

    607. 

  607.     <input type='hidden' name='ladderid' value='$ladderid'>

    608. 

  608.     <input type='submit' name='' value='Update'>

    609. 

  609.     <input type='reset' name='todo' value='Reset'>

    610. 

  610.     </td>

    611. 

  611.     </form>

    612. 

  612.     </tr>

    613. 

  613.     <tr>

    614. 

  614.     <form method='post'>

    615. 

  615.     <td width='100%' valign='center' align='center'>

    616. 

  616.     <br>

    617. 

  617.     Place member on this team<br>

    618. 

  618.     Player ID: <input type='text' name='playerid' value=''>

    619. 

  619.     <br><br>

    620. 

  620.     </td>

    621. 

  621.     </tr>

    622. 

  622.     <tr class='altcolor'>

    623. 

  623.     <td width='100%' valign='top' align='center'>

    624. 

  624.     <input type='hidden' name='action' value='editateamf'>

    625. 

  625.     <input type='hidden' name='teamid' value='$teamid'>

    626. 

  626.     <input type='hidden' name='ladderid' value='$ladderid'>

    627. 

  627.     <input type='submit' name='' value='Add Member'>

    628. 

  628.     </td>

    629. 

  629.     </form>

    630. 

  630.     </tr>

    631. 

  631.     <tr>

    632. 

  632.     <td width='100%' valign='center' align='center'>

    633. 

  633.     <table width='100%' border='0'  cellspacing='0' cellpadding='0'>

    634. 

  634.     <tr>

    635. 

  635.     <td width='100%' height='100%' valign='top' align='left' colspan='3'>

    636. 

  636.     <ul>

    637. 

  637.     <li>Leader: Can do everything.<br>

    638. 

  638.     <li>Co-Leader: Invite, Kick and Manage Members, Report Losses<br>

    639. 

  639.     <li>Captain: Make and Accept Challenges, Report Losses<br>

    640. 

  640.     <li>Co-Captain: Report Losses<br>

    641. 

  641.     <li>Member: Regular Member<br>

    642. 

  642.     <li>Training: Cannot play in matches.<br>

    643. 

  643.     <li>Inactive: Cannot play in matches.<br>

    644. 

  644.     <li>Suspended: Cannot play in matches.<br>

    645. 

  645.     <li>Retired: Retired from Play. Cannot play in matches.

    646. 

  646.     </td></ul>

    647. 

  647.     </tr>

    648. 

  648.     </table>

    649. 

  649.     </td>

    650. 

  650.     </tr>

    651. 

  651.     <tr class='altcolor'>

    652. 

  652.     <td width='100%' valign='top' align='center'>

    653. 

  653.     <strong>Member Rights by Rank</strong></td>

    654. 

  654.     </tr>

    655. 

  655.     </table>

    656. 

  656.     $tablefoot";

    657. 

  657.     include("$dir[curtheme]");

    658. 

  658. }

    659. 

  659. 

    660. 

  660. function admin_editateame($teamid,$ladderid,$memberrank){

    661. 

  661.     global $dir, $file, $url, $out, $admn;

    662. 

  662.     if(!$teamid){

    663. 

  663.         include("$dir[func]/error.php");

    664. 

  664.         display_error("Invalid Team ID.<br>");

    665. 

  665.     }

    666. 

  666. 

    667. 

  667.     if(!$ladderid){

    668. 

  668.         include("$dir[func]/error.php");

    669. 

  669.         display_error("Invalid Ladder ID.<br>");

    670. 

  670.     }

    671. 

  671. 

    672. 

  672.     if(!$memberrank){

    673. 

  673.         include("$dir[func]/error.php");

    674. 

  674.         display_error("Invalid Member ID's.<br>");

    675. 

  675.     }

    676. 

  676. 

    677. 

  677.     $leadcheckranks=$memberrank;

    678. 

  678.     while(list($pplayerid,$pmrank)=each($leadcheckranks)){

    679. 

  679.         if($pmrank=="1"){

    680. 

  680.             $leaderfound=1;

    681. 

  681.         }

    682. 

  682. 

    683. 

  683.     }

    684. 

  684. 

    685. 

  685.     if(!$leaderfound){

    686. 

  686.         include("$dir[func]/error.php");

    687. 

  687.         display_error("There must be a team leader.<br>");

    688. 

  688.     }

    689. 

  689. 

    690. 

  690.     while(list($playerid,$mrank)=each($memberrank)){

    691. 

  691.         $ememinfo=mysql_query("SELECT status FROM teammembers WHERE teamid='$teamid' AND playerid='$playerid'");

    692. 

  692.         $eminfo=mysql_fetch_array($ememinfo);

    693. 

  693.         if($mrank=="9"){

    694. 

  694.             mysql_query("DELETE FROM teammembers WHERE teamid='$teamid' AND playerid='$playerid'");

    695. 

  695.         }

    696. 

  696. 

    697. 

  697.         else if($eminfo[status]!=$mrank){

    698. 

  698.             mysql_query("UPDATE teammembers SET status='$mrank' WHERE teamid='$teamid' AND playerid='$playerid'");

    699. 

  699.         }

    700. 

  700. 

    701. 

  701.     }

    702. 

  702. 

    703. 

  703.     include("$dir[func]/admin_finishmessage.php");

    704. 

  704.     display_message("The team members were updated.<br>");

    705. 

  705. }

    706. 

  706. 

    707. 

  707. function admin_editateamf($teamid,$ladderid,$playerid){

    708. 

  708.     global $dir, $file, $url, $out, $admn;

    709. 

  709.     if(!$teamid){

    710. 

  710.         include("$dir[func]/error.php");

    711. 

  711.         display_error("Invalid Team ID.<br>");

    712. 

  712.     }

    713. 

  713. 

    714. 

  714.     if(!$ladderid){

    715. 

  715.         include("$dir[func]/error.php");

    716. 

  716.         display_error("Invalid Ladder ID.<br>");

    717. 

  717.     }

    718. 

  718. 

    719. 

  719.     if(!$playerid){

    720. 

  720.         include("$dir[func]/error.php");

    721. 

  721.         display_error("Invalid Player ID.<br>");

    722. 

  722.     }

    723. 

  723. 

    724. 

  724.     //CHECK IF PLAYER EXISTS

    725. 

  725.     if (mysql_num_rows(mysql_query("SELECT id FROM users WHERE id='$playerid'")) < 1){

    726. 

  726.         include("$dir[func]/error.php");

    727. 

  727.         display_error("Unknown Player ID.<br>");

    728. 

  728.     }

    729. 

  729. 

    730. 

  730.     $ladinfo=mysql_query("SELECT laddername,maxmembers FROM ladders WHERE id='$ladderid'");

    731. 

  731.     $linfo=mysql_fetch_array($ladinfo);

    732. 

  732.     if(!$linfo[laddername]){

    733. 

  733.         include("$dir[func]/error.php");

    734. 

  734.         display_error("Unknown Ladder.<br>");

    735. 

  735.     }

    736. 

  736. 

    737. 

  737.     //MAKE SURE PLAYER IS NOT ALREADY ON LADDER

    738. 

  738.     $pteams=mysql_query("SELECT teamid FROM teammembers WHERE playerid='$playerid'");

    739. 

  739.     while($row = mysql_fetch_array($pteams)){

    740. 

  740.         $check=mysql_query("SELECT id FROM ladder_$ladderid WHERE id='$row[teamid]'");

    741. 

  741.         $checkb=mysql_fetch_array($check);

    742. 

  742.         if($checkb){

    743. 

  743.             include("$dir[func]/error.php");

    744. 

  744.             display_error("This player is already on this ladder.<br>");

    745. 

  745.         }

    746. 

  746. 

    747. 

  747.     }

    748. 

  748. 

    749. 

  749.     //CHECK IF MAX MEMBERS EXISTS

    750. 

  750.     $ladders=mysql_query("SELECT id,laddername,maxmembers FROM ladders");

    751. 

  751.     while($row = mysql_fetch_array($ladders)){

    752. 

  752.         $teams=mysql_query("SELECT id FROM ladder_$row[id] WHERE id='$teamid'");

    753. 

  753.         if(mysql_fetch_array($teams)){

    754. 

  754.             if (mysql_num_rows(mysql_query("SELECT playerid FROM teammembers WHERE teamid='$teamid'")) >= $row[maxmembers]){

    755. 

  755.                 include("$dir[func]/error.php");

    756. 

  756.                 display_error("This team has the maximum allowed team members<br> on the $row[laddername] ladder. <br><br> No new members can be added to this team.");

    757. 

  757.             }

    758. 

  758. 

    759. 

  759.         }

    760. 

  760. 

    761. 

  761.     }

    762. 

  762. 

    763. 

  763.     $tday=date("Y-m-d H:i:s");

    764. 

  764.     mysql_query("INSERT INTO teammembers VALUES (

    765. 

  765.     '$teamid',

    766. 

  766.     '$playerid',

    767. 

  767.     '5',

    768. 

  768.     '$tday');");

    769. 

  769.     include("$dir[func]/admin_finishmessage.php");

    770. 

  770.     display_message("The member was added to the team.<br>");

    771. 

  771. }

    772. 

  772. 

    773. 

  773. function delete_team($teamid){

    774. 

  774.     global $dir;

    775. 

  775.     mysql_query("DELETE FROM teammembers WHERE teamid='$teamid'");

    776. 

  776.     mysql_query("DELETE FROM players2 WHERE pid='$teamid'");

    777. 

  777.     mysql_query("DELETE FROM brackets2 WHERE pid='$teamid'");

    778. 

  778.     mysql_query("DELETE FROM teams WHERE id='$teamid'");

    779. 

  779.     mysql_query("DELETE FROM challenges WHERE challenger='$teamid'");

    780. 

  780.     mysql_query("DELETE FROM challenges WHERE challenged='$teamid'");

    781. 

  781.     mysql_query("DELETE FROM teammembersinv WHERE teamid='$teamid'");

    782. 

  782.     $ladders = mysql_query("SELECT id FROM ladders");

    783. 

  783.     while($row = mysql_fetch_array($ladders)){

    784. 

  784.         $ladder = mysql_query("SELECT id FROM ladder_$row[id] WHERE id ='$teamid'");

    785. 

  785.         if(mysql_fetch_array($ladder)){

    786. 

  786.             mysql_query("DELETE FROM ladder_$row[id] WHERE id='$teamid'");

    787. 

  787.             $getrank=mysql_query("SELECT rank FROM ladder_$row[id] WHERE id='$teamid'");

    788. 

  788.             $getrank2=mysql_fetch_array($getrank);

    789. 

  789.             include("$dir[func]/rankadjust.php");

    790. 

  790.             update_teamranks($row[id],$teamid,$getrank2[rank]);

    791. 

  791.             $ranksadjusted=rank_checkadjust($row[id]);

    792. 

  792.         }

    793. 

  793.    } 

    794. 

  794.    include("$dir[func]/admin_finishmessage.php");

    795. 

  795.    display_message("The team has been deleted.<br>");

    796. 

  796. 

    797. 

  797. }

    798. 

  798. 

    799. 

  799. function leave_ladder($ladderid,$teamid){

    800. 

  800.     global $dir, $url, $out, $plyr, $site, $uinfo, $misc;

    801. 

  801.     if(!$ladderid){

    802. 

  802.         include("$dir[func]/error.php");

    803. 

  803.         display_error("Invalid Ladder ID.<br>");

    804. 

  804.     }

    805. 

  805. 

    806. 

  806.     if(!$teamid){

    807. 

  807.         include("$dir[func]/error.php");

    808. 

  808.         display_error("Invalid Team ID.<br>");

    809. 

  809.     }

    810. 

  810. 

    811. 

  811.     $count = 0;	

    812. 

  812.     $ladders = mysql_query("SELECT id FROM ladders");

    813. 

  813.     while($row = mysql_fetch_array($ladders)){

    814. 

  814.         $ladder = mysql_query("SELECT id FROM ladder_$row[id] WHERE id ='$teamid'");

    815. 

  815.         if(mysql_fetch_array($ladder)){

    816. 

  816. 	    $count++;

    817. 

  817.         }

    818. 

  818. 

    819. 

  819.     }

    820. 

  820. 

    821. 

  821.     if($count < 2){

    822. 

  822.        include("$dir[func]/error.php");

    823. 

  823.        display_error("This team is not on any other ladders.<br>You can delete a team if you wish to remove it completely.<br>");

    824. 

  824.     }

    825. 

  825. 

    826. 

  826. 

    827. 

  827.     $getrank=mysql_query("SELECT rank FROM ladder_$ladderid WHERE id='$teamid'");

    828. 

  828.     $getrank2=mysql_fetch_array($getrank);

    829. 

  829.     mysql_query("DELETE FROM ladder_$ladderid WHERE id='$teamid'");

    830. 

  830.     include("$dir[func]/rankadjust.php");

    831. 

  831.     update_teamranks($ladderid,$teamid,$getrank2[rank]);

    832. 

  832.     $ranksadjusted=rank_checkadjust($ladderid);

    833. 

  833.     include("$dir[func]/admin_finishmessage.php");

    834. 

  834.     display_message("The team was removed from the ladder.<br>");

    835. 

  835. }

    836. 

  836. 

    837. 

  837. ?>

    838. 

  838.