PageRenderTime 712ms CodeModel.GetById 25ms RepoModel.GetById 1ms app.codeStats 0ms

/functions/admin_tournament.php

https://bitbucket.org/verax/to-ladder
PHP | 1319 lines | 1149 code | 133 blank | 37 comment | 88 complexity | 9709d816e16f51bbc4dc005b1adad281 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] < 63){

    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. $admin=mysql_query("SELECT tid FROM tourneys WHERE tid='$tid'");

    13. 

  13. $admin=mysql_fetch_array($admin);

    14. 

  14. if($admin[tid]){

    15. 

  15.     $tinfo=mysql_query("SELECT * FROM tourneys WHERE tid='$admin[tid]'");

    16. 

  16.     $tinfo=mysql_fetch_array($tinfo);

    17. 

  17. }else{

    18. 

  18. 

    19. 

  19.     $defaultz=mysql_query("SELECT * FROM defaults2 WHERE line='1'");

    20. 

  20.     $tinfo=mysql_fetch_array($defaultz);

    21. 

  21.     $tinfo[name]="Tournament Admin";

    22. 

  22. }

    23. 

  23. 

    24. 

  24. function characters($text){

    25. 

  25.     $text=str_replace(";", "", $text);

    26. 

  26.     $text=htmlspecialchars("$text");

    27. 

  27.     $text=str_replace("#", "", $text);

    28. 

  28.     $text=str_replace("|", "", $text);

    29. 

  29.     $text=str_replace("'", "&acute;", $text);

    30. 

  30.     $text=eregi_replace("( ){2,}", " ", $text);

    31. 

  31. 

    32. 

  32.     $text=trim($text);

    33. 

  33.     return($text);

    34. 

  34. }

    35. 

  35. 

    36. 

  36. function madmin_manage($edit){

    37. 

  37.     global $config, $tinfo, $dir, $url, $out, $site, $misc;

    38. 

  38.     $tourneylist=mysql_query("SELECT tid,name FROM tourneys ORDER by name");

    39. 

  39.     while(list($tid,$name)=mysql_fetch_row($tourneylist)){

    40. 

  40.         $tourneylistid.="<option value='$tid'>$name</option>\n";

    41. 

  41.     }

    42. 

  42. 

    43. 

  43.     if($edit[tid]){

    44. 

  44.         $tourneyinfo=mysql_query("SELECT * FROM tourneys WHERE tid='$edit[tid]'");

    45. 

  45.         $adedt=mysql_fetch_array($tourneyinfo);

    46. 

  46.     }

    47. 

  47. 

    48. 

  48.     if($adedt[tid]){

    49. 

  49.         $actiontype="

    50. 

  50.         <input type='hidden' name='action' value='madmin_manage_update'>

    51. 

  51.         <input type='hidden' name='adedt[tid]' value='$adedt[tid]'>";

    52. 

  52.         $addeditword="Edit";

    53. 

  53.         $size="$adedt[size]";

    54. 

  54.         $selected_size[$size]="SELECTED";

    55. 

  55.         $active="$adedt[active]";

    56. 

  56.         $selected_active[$active]="SELECTED";

    57. 

  57.         $open="$adedt[open]";

    58. 

  58.         $selected_open[$open]="SELECTED";

    59. 

  59.         $adedt[password]=$adedt[password];

    60. 

  60.     }else{

    61. 

  61. 

    62. 

  62.         $defaultz=mysql_query("SELECT logo,bgcolor,tdcolor,fontcolor FROM defaults2 WHERE line='1'");

    63. 

  63.         $adedt=mysql_fetch_array($defaultz);

    64. 

  64.         $actiontype="

    65. 

  65.         <input type='hidden' name='action' value='madmin_manage_add'>";

    66. 

  66.         $addeditword="Create";

    67. 

  67.     }

    68. 

  68. 

    69. 

  69.     $tablehead=table_head("show","80%","","center");

    70. 

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

    71. 

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

    72. 

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

    73. 

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

    74. 

  74.     <center>

    75. 

  75.     $bannerhead

    76. 

  76.     $out[banner]

    77. 

  77.     $bannerfoot

    78. 

  78.     </center>

    79. 

  79.     <br><center>

    80. 

  80.     $tablehead

    81. 

  81.     

    82. 

  82.     ";

    83. 

  83.     if(!$adedt[tid]){

    84. 

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

    85. 

  85.         <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    86. 

  86.     	<tr class='altcolor'>

    87. 

  87.     	<form method='post'>

    88. 

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

    89. 

  89.     	<strong>Edit a Tournament</strong><br>

    90. 

  90.     	</td></tr>

    91. 

  91.         <tr>

    92. 

  92.         <form method='post'>

    93. 

  93.         <td align='center' width='600'><br>

    94. 

  94.         <select name='edit[tid]'>

    95. 

  95.         $tourneylistid</select><br><br>

    96. 

  96. 	</td></tr>

    97. 

  97.         <tr class='altcolor'><td width='100%' valign='top' align='center'><input type='hidden' name='action' value='madmin_manage'>

    98. 

  98.         <input type='submit' value='Edit Tournament'>

    99. 

  99.         </td></form>

    100. 

  100.         </tr>

    101. 

  101.         </table><br>

    102. 

  102. 

    103. 

  103.         <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    104. 

  104.         <tr class='altcolor'>

    105. 

  105.     	<form method='post'>

    106. 

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

    107. 

  107.     	<strong>Delete a Tournament</strong><br>

    108. 

  108.     	</td></tr>

    109. 

  109.         <tr><form method='post'>

    110. 

  110.         <td align='center' width='600'><br>

    111. 

  111.         <select name='delete[tid]'>

    112. 

  112.         $tourneylistid</select><br><br></td></tr>

    113. 

  113.         <tr class='altcolor'><td width='100%' valign='top' align='center'>

    114. 

  114.         <script language='javascript'>var confirmdelete='Are you 100% sure you want to DELETE this Tournament';</script>

    115. 

  115.         <input type='hidden' name='action' value='madmin_manage_delete'>

    116. 

  116.         <input type='submit' value='Delete Tournament' onClick='return confirm(confirmdelete);'>

    117. 

  117.         </td></form>

    118. 

  118.         </tr>

    119. 

  119.         </table><br>

    120. 

  120. 

    121. 

  121.         <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    122. 

  122.         <tr class='altcolor'>

    123. 

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

    124. 

  124.         <b>Reset a Tournament</b><br>

    125. 

  125.         </td></tr>

    126. 

  126.         <form method='post'>

    127. 

  127.         <tr bgcolor='$tinfo[tdcolor]'>

    128. 

  128.         <td align='center' width='600'><br>

    129. 

  129. 	<select name='reset[tid]'>

    130. 

  130.         $tourneylistid</select><br><br>

    131. 

  131.         Brackets: <input type='radio' name='reset[players]' value='0' CHECKED>

    132. 

  132.         Brackets and Players: <input type='radio' name='reset[players]' value='1'><br></td></tr>

    133. 

  133.         <tr class='altcolor'><td width='100%' valign='top' align='center'>

    134. 

  134.         <script language='javascript'>var confirmreset='Are you 100% sure you want to RESET this Tournament? All tournament data WILL be lost!';</script>

    135. 

  135.         <input type='hidden' name='action' value='madmin_manage_reset'>

    136. 

  136.         <input type='submit' value='Reset Tournament' onClick='return confirm(confirmreset);'>

    137. 

  137.         </td></form>

    138. 

  138.         </tr>

    139. 

  139.         </table>

    140. 

  140.         <br>

    141. 

  141.         ";

    142. 

  142.     }

    143. 

  143. 

    144. 

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

    145. 

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

    146. 

  146.         $selectedladder="";

    147. 

  147.         if($ladderid=="$id"){

    148. 

  148.             $selectedladder="SELECTED";

    149. 

  149.         }

    150. 

  150. 

    151. 

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

    152. 

  152.     }

    153. 

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

    154. 

  154.     

    155. 

  155.     <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    156. 

  156.     <tr class='altcolor'>

    157. 

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

    158. 

  158.     <b>$addeditword a Tournament</b><br>

    159. 

  159.     Required fields are marked with *

    160. 

  160.     </td></tr>

    161. 

  161.     <form method='post'>

    162. 

  162.     <tr class='altcolora'>

    163. 

  163.     <td align='left' width='300'>Tournament Name *</td>

    164. 

  164.     <td align='right'><input type='text' name='adedt[name]' value='$adedt[name]' maxlength='50'></td>

    165. 

  165.     </tr>";

    166. 

  166.     if($adedt[tid]){

    167. 

  167.         $ladname=mysql_fetch_array(mysql_query("SELECT laddername FROM ladders WHERE id='$adedt[ladderid]'"));

    168. 

  168.     	$out[body]=$out[body]."<tr class='altcolorb'>

    169. 

  169.     	<td align='left' width='300'>Ladder On</td>

    170. 

  170.     	<td align='right'>$ladname[laddername]</td>

    171. 

  171.         </tr><input type='hidden' name='adedt[ladderid]' value='$adedt[ladderid]'>";

    172. 

  172.     }else{

    173. 

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

    174. 

  174.     	<tr class='altcolorb'>

    175. 

  175.     	<td align='left' width='300'>Ladder On *</td>

    176. 

  176.     	<td align='right'><select name='adedt[ladderid]'><option value='$adedt[ladderid]'>Select a Ladder</option>$theladders</select></td>

    177. 

  177.     </tr>";

    178. 

  178.     }

    179. 

  179.     

    180. 

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

    181. 

  181.     <tr class='altcolora'>

    182. 

  182.     <td align='left' width='250'>Tourney Size *</td>

    183. 

  183.     <td align='right'><select name='adedt[size]'>

    184. 

  184.     <option value='4' $selected_size[4]>4 Player/Team</option>

    185. 

  185.     <option value='8' $selected_size[8]>8 Player/Team</option>

    186. 

  186.     <option value='16' $selected_size[16]>16 Player/Team</option>

    187. 

  187.     <option value='32' $selected_size[32]>32 Player/Team</option>

    188. 

  188.     <option value='64' $selected_size[64]>64 Player/Team</option>

    189. 

  189.     <option value='128' $selected_size[128]>128Player/Team</option>

    190. 

  190.     <option value='256' $selected_size[256]>256Player/Team</option>

    191. 

  191.     <option value='512' $selected_size[512]>512Player/Team</option>

    192. 

  192.     </select></td>

    193. 

  193.     </tr>

    194. 

  194.     <tr class='altcolorb'>

    195. 

  195.     <td align='left' width='250'>Tourney Active *</td>

    196. 

  196.     <td align='right'><select name='adedt[active]'>

    197. 

  197.     <option value='1' $selected_active[1]>New Signups On</option>

    198. 

  198.     <option value='0' $selected_active[0]>New Signups Off</option>

    199. 

  199.     </select></td>

    200. 

  200.     </tr>";

    201. 

  201.     if($adedt[tid]){

    202. 

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

    203. 

  203.     	<tr class='altcolora'>

    204. 

  204.     	<td align='left' width='250'>Tourney Open *</td>

    205. 

  205.     	<td align='right'><select name='adedt[open]'>

    206. 

  206.     	<option value='1' $selected_open[1]>Tourney Open</option>

    207. 

  207.     	<option value='0' $selected_open[0]>Tourney Closed</option>

    208. 

  208.     	</select></td>

    209. 

  209.     	</tr>";

    210. 

  210.     }else{

    211. 

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

    212. 

  212.     	<input type='hidden' name='adedt[open]' value='1'>";

    213. 

  213.     }

    214. 

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

    215. 

  215.     <tr class='altcolora'>

    216. 

  216.     <td align='left' width='300'>Custom Signup Form Field 1</td>

    217. 

  217.     <td align='right'><input type='text' name='adedt[field1]' value='$adedt[field1]' maxlength='50'></td>

    218. 

  218.     </tr>

    219. 

  219.     <tr class='altcolorb'>

    220. 

  220.     <td align='left' width='300'>Custom Signup Form Field 2</td>

    221. 

  221.     <td align='right'><input type='text' name='adedt[field2]' value='$adedt[field2]' maxlength='50'></td>

    222. 

  222.     </tr>

    223. 

  223.     <tr class='altcolora'>

    224. 

  224.     <td align='left' width='300'>Custom Signup Form Field 3</td>

    225. 

  225.     <td align='right'><input type='text' name='adedt[field3]' value='$adedt[field3]' maxlength='50'></td>

    226. 

  226.     </tr>

    227. 

  227.     <tr class='altcolorb'>

    228. 

  228.     <td align='left' width='300'>Tournament Admins (Directors)</td>

    229. 

  229.     <td align='right'><input type='text' name='adedt[directors]' value='$adedt[directors]' maxlength='250'></td>

    230. 

  230.     </tr>

    231. 

  231.     <input type='hidden' name='adedt[password]' value='notneeded'>

    232. 

  232.     <input type='hidden' name='adedt[logo]' value='$adedt[logo]' maxlength='100'>

    233. 

  233.     <input type='hidden' name='adedt[bgcolor]' value='#000000'>

    234. 

  234.     <input type='hidden' name='adedt[tdcolor]' value='#808080'>

    235. 

  235.     <input type='hidden' name='adedt[fontcolor]' value='#ffffff'>

    236. 

  236.     <tr class='altcolora'>

    237. 

  237.     <td align='center' width='100%' colspan='2'>Tournament Description, Rules, etc.</td>

    238. 

  238.     </tr>

    239. 

  239.     <tr class='altcolorb'>

    240. 

  240.     <td align='center' width='100%' colspan='2'><textarea name='adedt[details]' rows='25' cols='90'>$adedt[details]</textarea></td>

    241. 

  241.     </tr>

    242. 

  242.     <tr class='altcolor'>

    243. 

  243.     <td align='center' width='600' colspan='2'>

    244. 

  244.     $actiontype

    245. 

  245.     <input type='submit' value='$addeditword Tournament'>

    246. 

  246.     </td></form>

    247. 

  247.     </tr>

    248. 

  248.     </table>

    249. 

  249.     </ul>

    250. 

  250.     $tablefoot";

    251. 

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

    252. 

  252. }

    253. 

  253. 

    254. 

  254. function madmin_manage_add($adedt){

    255. 

  255.     global $config, $out, $site, $misc, $dir, $url, $file;

    256. 

  256.     while(list($varib,$value)=each($adedt)){

    257. 

  257.         $adedt[$varib]=characters($value);

    258. 

  258.     }

    259. 

  259. 

    260. 

  260.     if(!$adedt[name]){

    261. 

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

    262. 

  262.         display_error("Your tourney must have a name!");

    263. 

  263.     }

    264. 

  264. 

    265. 

  265.     if(!$adedt[size]){

    266. 

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

    267. 

  267.         display_error("Your tourney size is unknown");

    268. 

  268.     }

    269. 

  269. 

    270. 

  270.     if($adedt[ladderid] == ''){

    271. 

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

    272. 

  272.         display_error("You did not select a ladder.");

    273. 

  273.     }

    274. 

  274. 

    275. 

  275.     if((!$adedt[bgcolor])||(!$adedt[tdcolor])||(!$adedt[fontcolor])){

    276. 

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

    277. 

  277.         display_error("Your tourney must have a color scheme");

    278. 

  278.     }

    279. 

  279. 

    280. 

  280.     //TEMP

    281. 

  281.     $adedt[type]=1;

    282. 

  282.     mysql_query("INSERT INTO tourneys VALUES (

    283. 

  283.     'NULL',

    284. 

  284.     '$adedt[size]',

    285. 

  285.     '$adedt[type]',

    286. 

  286.     '$adedt[active]',

    287. 

  287.     '$adedt[name]',

    288. 

  288.     '$adedt[details]',

    289. 

  289.     '$adedt[field1]',

    290. 

  290.     '$adedt[field2]',

    291. 

  291.     '$adedt[field3]',

    292. 

  292.     '$adedt[directors]',

    293. 

  293.     '$adedt[password]',

    294. 

  294.     '$adedt[logo]',

    295. 

  295.     '$adedt[bgcolor]',

    296. 

  296.     '$adedt[tdcolor]',

    297. 

  297.     '$adedt[fontcolor]',

    298. 

  298.     '$adedt[ladderid]',

    299. 

  299.     '$adedt[open]');");

    300. 

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

    301. 

  301.      display_message("The tournament has been created.<br>");

    302. 

  302. }

    303. 

  303. 

    304. 

  304. function madmin_manage_update($adedt){

    305. 

  305.     global $config, $out, $site, $misc, $dir, $url, $file;

    306. 

  306.     while(list($varib,$value)=each($adedt)){

    307. 

  307.         $adedt[$varib]=characters($value);

    308. 

  308.     }

    309. 

  309. 

    310. 

  310.     $adedt[password]=$adedt[password];

    311. 

  311.     if((!$adedt[name])||(!$adedt[password])){

    312. 

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

    313. 

  313.         display_error("<center>Your tourney must have a name and admin password");

    314. 

  314.     }

    315. 

  315. 

    316. 

  316.     if(!$adedt[size]){

    317. 

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

    318. 

  318.         display_error("<center>Your tourney size is unknown");

    319. 

  319.     }

    320. 

  320. 

    321. 

  321.     if($adedt[ladderid] == ''){

    322. 

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

    323. 

  323.         display_error("You did not select a ladder option");

    324. 

  324.     }

    325. 

  325. 

    326. 

  326.     if((!$adedt[bgcolor])||(!$adedt[tdcolor])||(!$adedt[fontcolor])){

    327. 

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

    328. 

  328.         display_error("<center>Your tourney must have a color scheme");

    329. 

  329.     }

    330. 

  330. 

    331. 

  331.     //TEMP

    332. 

  332.     $adedt[type]=1;

    333. 

  333.     mysql_query("UPDATE tourneys SET

    334. 

  334.     size='$adedt[size]',

    335. 

  335.     type='$adedt[type]',

    336. 

  336.     active='$adedt[active]',

    337. 

  337.     name='$adedt[name]',

    338. 

  338.     details='$adedt[details]',

    339. 

  339.     field1='$adedt[field1]',

    340. 

  340.     field2='$adedt[field2]',

    341. 

  341.     field3='$adedt[field3]',

    342. 

  342.     directors='$adedt[directors]',

    343. 

  343.     password='$adedt[password]',

    344. 

  344.     open='$adedt[open]',

    345. 

  345.     logo='$adedt[logo]',

    346. 

  346.     bgcolor='$adedt[bgcolor]',

    347. 

  347.     tdcolor='$adedt[tdcolor]',

    348. 

  348.     fontcolor='$adedt[fontcolor]'

    349. 

  349.     WHERE tid='$adedt[tid]'");

    350. 

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

    351. 

  351.     display_message("The tournament has been updated.<br>");

    352. 

  352. }

    353. 

  353. 

    354. 

  354. function madmin_manage_delete($delete){

    355. 

  355.     global $config, $out, $site, $misc, $dir, $url, $file;

    356. 

  356.     mysql_query("DELETE FROM tourneys WHERE tid='$delete[tid]'");

    357. 

  357.     mysql_query("DELETE FROM players2 WHERE tid='$delete[tid]'");

    358. 

  358.     mysql_query("DELETE FROM brackets2 WHERE tid='$delete[tid]'");

    359. 

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

    360. 

  360.     display_message("The tournament has been deleted.<br>");

    361. 

  361. }

    362. 

  362. 

    363. 

  363. function madmin_manage_reset($reset){

    364. 

  364.     global $config, $out, $site, $misc, $dir, $url, $file;

    365. 

  365.     if($reset[players]){

    366. 

  366.         mysql_query("DELETE FROM players2 WHERE tid='$reset[tid]'");

    367. 

  367.     }

    368. 

  368. 

    369. 

  369.     mysql_query("DELETE FROM brackets2 WHERE tid='$reset[tid]'");

    370. 

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

    371. 

  371.     display_message("The tournament has been reset.<br>");

    372. 

  372. }

    373. 

  373. 

    374. 

  374. //START TOURNEY ADMIN FUNTIONS

    375. 

  375. //////////////////////////////////////////////////////////////////////

    376. 

  376. //////////////////////////////////////////////////////////////////////

    377. 

  377. function select_tournament(){

    378. 

  378.     global $config, $out, $site, $misc, $dir, $url;

    379. 

  379.     $tourneylist=mysql_query("SELECT tid,name FROM tourneys ORDER by name");

    380. 

  380.     while(list($tid,$name)=mysql_fetch_row($tourneylist)){

    381. 

  381.         $tourneylistid.="<option value='$tid'>$name</option>\n";

    382. 

  382.     }

    383. 

  383. 

    384. 

  384.     $tablehead=table_head("show","70%","","left");

    385. 

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

    386. 

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

    387. 

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

    388. 

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

    389. 

  389.     <center>

    390. 

  390.     $bannerhead

    391. 

  391.     $out[banner]

    392. 

  392.     $bannerfoot  <br>

    393. 

  393.     $tablehead &nbsp; &nbsp;<strong>

    394. 

  394.     <center>

    395. 

  395.     <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    396. 

  396.     <tr class='altcolor'>

    397. 

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

    398. 

  398.     <b>Select a Tournament</b><br>

    399. 

  399.     </td></tr>

    400. 

  400.     <tr><td align='center'>

    401. 

  401.     <form method='post'><br>

    402. 

  402.     <select name='tid'>$tourneylistid</select>

    403. 

  403.     <input type='hidden' name='action' value='edit_tournament'><br><br>

    404. 

  404.     <input type='submit' value='Submit'><br>

    405. 

  405.     </form></td></tr>

    406. 

  406.     <tr class='altcolor'><td><br></td></tr></table>

    407. 

  407.     $tablefoot";

    408. 

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

    409. 

  409. }

    410. 

  410. 

    411. 

  411. function TourneyAdminHome($tid){

    412. 

  412.     global $config,$tinfo,$out,$url,$dir,$site;

    413. 

  413.     $check = mysql_fetch_array(mysql_query("SELECT open FROM tourneys WHERE tid='$tid'"));

    414. 

  414.     if($check[open] == '0'){

    415. 

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

    416. 

  416.         display_error("Tournament is closed.<br><br>It can only be re-opened via the admin control panel.");

    417. 

  417.     }

    418. 

  418. 

    419. 

  419.     $tablehead=table_head("show","70%","","left");

    420. 

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

    421. 

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

    422. 

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

    423. 

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

    424. 

  424.     <script language='javascript'>var confirmdelete='This will delete all brackets details! Are you sure you wish to continue?';</script>

    425. 

  425.     <center>

    426. 

  426.     $bannerhead

    427. 

  427.     $out[banner]

    428. 

  428.     $bannerfoot  <br>

    429. 

  429.     $tablehead &nbsp; &nbsp;<strong>

    430. 

  430.     <center>

    431. 

  431.     <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    432. 

  432.     <tr class ='altcolor'>

    433. 

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

    434. 

  434.     <b>$tinfo[name]</b><br>

    435. 

  435.     </td></tr>

    436. 

  436.     <tr class='altcolorb'>

    437. 

  437.     <td align='left' width='300'><b>Manage Player Signups</b></td>

    438. 

  438.     <td align='center'><form method='post'>

    439. 

  439.     <input type='hidden' name='tid' value='$tid'>

    440. 

  440.     <input type='hidden' name='action' value='admin_players'>

    441. 

  441.     <input type='submit' value='Update'>

    442. 

  442.     </td></form>

    443. 

  443.     </tr>

    444. 

  444.     <tr class='altcolora'>

    445. 

  445.     <td align='left' width='300'><b>Manage Brackets with Drop Menus</b></td>

    446. 

  446.     <td align='center'><form method='post'>

    447. 

  447.     <input type='hidden' name='tid' value='$tid'>

    448. 

  448.     <input type='hidden' name='action' value='admin_brackets'>

    449. 

  449.     <input type='submit' value='Update'>

    450. 

  450.     </td></form>

    451. 

  451.     </tr>

    452. 

  452.     <tr class='altcolorb'>

    453. 

  453.     <td align='left' width='300'><b>Add Players to Brackets by Signup Order</b></td>

    454. 

  454.     <td align='center'><form method='post'>

    455. 

  455.     <input type='hidden' name='action' value='admin_autobracket'>

    456. 

  456.     <input type='hidden' name='tid' value='$tid'>

    457. 

  457.     <input type='submit' value='Update' onClick='return confirmdelete;'>

    458. 

  458.     </td></form>

    459. 

  459.     </tr>

    460. 

  460.     <tr class='altcolor'><td colspan='2'><br></td></tr>

    461. 

  461.     </table><br><br><br>

    462. 

  462.     </ul>

    463. 

  463.     $tablefoot";

    464. 

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

    465. 

  465. }

    466. 

  466. 

    467. 

  467. function admin_players($edit,$tid){

    468. 

  468.     global $config,$tinfo,$admin,$out,$url,$dir;

    469. 

  469.     if($edit[pid]){

    470. 

  470.         $tourneyinfo=mysql_query("SELECT * FROM players2 WHERE pid='$edit[pid]' AND tid='$admin[tid]'");

    471. 

  471.         $adedt=mysql_fetch_array($tourneyinfo);

    472. 

  472.     }

    473. 

  473. 

    474. 

  474.     if($adedt[tid]){

    475. 

  475.         $actiontype="

    476. 

  476.         <input type='hidden' name='action' value='admin_players_update'>

    477. 

  477.         <input type='hidden' name='adedt[pid]' value='$adedt[pid]'>";

    478. 

  478.         $addeditword="Edit";

    479. 

  479.     }else{

    480. 

  480. 

    481. 

  481.         $actiontype="

    482. 

  482.         <input type='hidden' name='action' value='admin_players_add'>";

    483. 

  483.         $addeditword="Add";

    484. 

  484.     }

    485. 

  485. 

    486. 

  486.     $tablehead=table_head("show","70%","","left");

    487. 

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

    488. 

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

    489. 

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

    490. 

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

    491. 

  491.     <center>

    492. 

  492.     $bannerhead

    493. 

  493.     $out[banner]

    494. 

  494.     $bannerfoot  <br>

    495. 

  495.     $tablehead<strong>

    496. 

  496.     <br>

    497. 

  497.     ";

    498. 

  498.     if(!$adedt[pid]){

    499. 

  499.         $playerlist=mysql_query("SELECT pid,name FROM players2 WHERE tid='$admin[tid]' ORDER BY name");

    500. 

  500.         while(list($pid,$name)=mysql_fetch_row($playerlist)){

    501. 

  501.             $playerlistid.="<option value='$pid'>$name</option>\n";

    502. 

  502.         }

    503. 

  503. 

    504. 

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

    505. 

  505.         <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    506. 

  506.         <tr class ='altcolor'>

    507. 

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

    508. 

  508.         <b>Delete a Team/Player</b>

    509. 

  509.         </td></tr>

    510. 

  510.         <tr class='altcolora'><td align='left' width='300'>

    511. 

  511.         <form method='post'>

    512. 

  512.         <b>Name</b></td>

    513. 

  513.         <td align='center' width='300'><select name='delete[pid]'>

    514. 

  514.         $playerlistid</select></td>

    515. 

  515.         </tr>

    516. 

  516.         <tr class='altcolor'>

    517. 

  517.         <td align='center' colspan='2' width='100%'>

    518. 

  518.         <script language='javascript'>var confirmdelete='Are you 100% sure you want to DELETE this Player';</script>

    519. 

  519.         <input type='hidden' name='action' value='admin_players_delete'>

    520. 

  520.         <input type='hidden' name='tid' value='$tid'>

    521. 

  521.         <input type='submit' value='Delete Team/Player' onClick='return confirm(confirmdelete);'>

    522. 

  522.         </td></form>

    523. 

  523.         </tr>

    524. 

  524.         </table>

    525. 

  525.         <br>

    526. 

  526.         ";

    527. 

  527.     }

    528. 

  528. 

    529. 

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

    530. 

  530.     <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    531. 

  531.     <tr class ='altcolor'>

    532. 

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

    533. 

  533.     <b>$addeditword a Team/Player</b>

    534. 

  534.     </td></tr>

    535. 

  535.     <tr class='altcolora'>

    536. 

  536.     <form method='post'>

    537. 

  537.     ";

    538. 

  538.     $ladderteams = mysql_query("SELECT id FROM ladder_$tinfo[ladderid]");

    539. 

  539.     while($ladderteam = mysql_fetch_array($ladderteams)){

    540. 

  540.         $teams = mysql_query("SELECT id,teamname FROM teams WHERE id ='$ladderteam[id]' ORDER by teamname");

    541. 

  541.         if($row=mysql_fetch_array($teams)){

    542. 

  542.             $theteams.="<option value='$row[teamname]' $selectedteam>$row[teamname]</option>";

    543. 

  543.         }

    544. 

  544. 

    545. 

  545.     }

    546. 

  546. 

    547. 

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

    548. 

  548.     

    549. 

  549.     <form method='post'>

    550. 

  550.     <td align='left' width='300'><b>Name</b></td>

    551. 

  551.     <td align='center' width='300'><select name='adedt[name]'>$theteams</select></td>

    552. 

  552.     </tr>

    553. 

  553.     ";

    554. 

  554.     if($tinfo[field1]){

    555. 

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

    556. 

  556.         <tr class='altcolorb'>

    557. 

  557.         <td align='left' width='300'>$tinfo[field1]</td>

    558. 

  558.         <td align='right'><input type='text' name='adedt[field1]' value='$adedt[field1]' maxlength='100'></td>

    559. 

  559.         </tr>

    560. 

  560.         ";

    561. 

  561.     }

    562. 

  562. 

    563. 

  563.     if($tinfo[field2]){

    564. 

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

    565. 

  565.         <tr class='altcolora'>

    566. 

  566.         <td align='left' width='300'>$tinfo[field2]</td>

    567. 

  567.         <td align='right'><input type='text' name='adedt[field2]' value='$adedt[field2]' maxlength='100'></td>

    568. 

  568.         </tr>

    569. 

  569.         ";

    570. 

  570.     }

    571. 

  571. 

    572. 

  572.     if($tinfo[field1]){

    573. 

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

    574. 

  574.         <tr class='altcolorb'>

    575. 

  575.         <td align='left' width='300'>$tinfo[field3]</td>

    576. 

  576.         <td align='right'><input type='text' name='adedt[field3]' value='$adedt[field3]' maxlength='100'></td>

    577. 

  577.         </tr>

    578. 

  578.         ";

    579. 

  579.     }

    580. 

  580. 

    581. 

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

    582. 

  582.     <tr class='altcolor'>

    583. 

  583.     <td align='center' width='100%' colspan='2'>

    584. 

  584.     $actiontype

    585. 

  585.     <input type='hidden' name='tid' value='$tid'>

    586. 

  586.     <input type='submit' value='Add Team/Player'>

    587. 

  587.     </td></form>

    588. 

  588.     </tr>

    589. 

  589.     </table>

    590. 

  590.     </ul>

    591. 

  591.     $tablefoot";

    592. 

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

    593. 

  593. }

    594. 

  594. 

    595. 

  595. function admin_players_add($adedt){

    596. 

  596.     global $config,$admin,$out,$dir,$url,$site,$file;

    597. 

  597.     while(list($varib,$value)=each($adedt)){

    598. 

  598.         $adedt[$varib]=characters($value);

    599. 

  599.         if(!$adedt[$varib]){

    600. 

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

    601. 

  601.             display_error("All fields are required");

    602. 

  602.         }

    603. 

  603. 

    604. 

  604.     }

    605. 

  605. 

    606. 

  606.     if(mysql_num_rows(mysql_query("SELECT pid FROM players2 WHERE tid='$admin[tid]' AND name='$adedt[name]'"))){

    607. 

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

    608. 

  608.         display_error("That Team Name is already in use on this tournament");

    609. 

  609.     }

    610. 

  610. 

    611. 

  611.     $teamid=mysql_query("SELECT id,teamemail FROM teams WHERE teamname='$adedt[name]'");

    612. 

  612.     $team=mysql_fetch_array($teamid);

    613. 

  613.     if(mysql_num_rows(mysql_query("SELECT pid FROM players2 WHERE tid='$admin[tid]' AND pid='$team[id]'"))){

    614. 

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

    615. 

  615.         display_error("That Team is already in use on this tournament");

    616. 

  616.     }

    617. 

  617. 

    618. 

  618.     mysql_query("INSERT INTO players2 VALUES (

    619. 

  619.     '$team[id]',

    620. 

  620.     '$admin[tid]',

    621. 

  621.     'Admin Add',

    622. 

  622.     '$config[stamp]',

    623. 

  623.     '$adedt[name]',

    624. 

  624.     '$team[teamemail]',

    625. 

  625.     '$adedt[field1]',

    626. 

  626.     '$adedt[field2]',

    627. 

  627.     '$adedt[field3]');");

    628. 

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

    629. 

  629.      display_message("The player has been added.<br>");

    630. 

  630. }

    631. 

  631. 

    632. 

  632. function admin_players_update($adedt){

    633. 

  633.     global $config,$admin,$out,$url,$dir,$site,$file;

    634. 

  634.     while(list($varib,$value)=each($adedt)){

    635. 

  635.         $adedt[$varib]=characters($value);

    636. 

  636.         if(!$adedt[$varib]){

    637. 

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

    638. 

  638.             display_error("All fields are required");

    639. 

  639.         }

    640. 

  640. 

    641. 

  641.     }

    642. 

  642. 

    643. 

  643.     mysql_query("UPDATE players2 SET

    644. 

  644.     name='$adedt[name]',

    645. 

  645.     email='$adedt[email]',

    646. 

  646.     field1='$adedt[field1]',

    647. 

  647.     field2='$adedt[field2]',

    648. 

  648.     field3='$adedt[field3]'

    649. 

  649.     WHERE pid='$adedt[pid]' AND tid='$admin[tid]'");

    650. 

  650.     mysql_query("UPDATE brackets2 SET

    651. 

  651.     name='$adedt[name]'

    652. 

  652.     WHERE pid='$adedt[pid]' AND tid='$admin[tid]'");

    653. 

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

    654. 

  654.     display_message("The player has been updated.<br>");

    655. 

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

    656. 

  656. }

    657. 

  657. 

    658. 

  658. function admin_players_delete($delete){

    659. 

  659.     global $config,$admin,$out,$url,$dir,$site,$file;

    660. 

  660.     mysql_query("DELETE FROM players2 WHERE pid='$delete[pid]' AND tid='$admin[tid]'");

    661. 

  661.     mysql_query("DELETE FROM brackets2 WHERE pid='$delete[pid]' AND tid='$admin[tid]'");

    662. 

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

    663. 

  663.     display_message("The player has been deleted.<br>");

    664. 

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

    665. 

  665. }

    666. 

  666. 

    667. 

  667. function admin_brackets($btype,$tid){

    668. 

  668.     global $config,$tinfo,$admin,$out,$dir,$url;

    669. 

  669.     if($btype[text]){

    670. 

  670.         $brackets=mysql_query("SELECT bid,pid,name FROM brackets2 WHERE tid='$admin[tid]' ORDER BY bid");

    671. 

  671.         while(list($bid,$pid,$name)=mysql_fetch_row($brackets)){

    672. 

  672.             $bracket[$bid]="$name";

    673. 

  673.         }

    674. 

  674. 

    675. 

  675.     }else{

    676. 

  676. 

    677. 

  677.         $textedited=mysql_query("SELECT name FROM brackets2 WHERE pid='0' AND tid='$admin[tid]'ORDER BY name");

    678. 

  678.         while(list($name)=mysql_fetch_row($textedited)){

    679. 

  679.             $textplayers.="<option value='0|$name'>$name</option>";

    680. 

  680.         }

    681. 

  681. 

    682. 

  682.         if($textplayers){

    683. 

  683.             $textplayers="<option value=''>-TEXT FIELD ADDS-</option> $textplayers";

    684. 

  684.         }

    685. 

  685. 

    686. 

  686.         $players=mysql_query("SELECT pid,name FROM players2 WHERE tid='$admin[tid]' ORDER BY name");

    687. 

  687.         while(list($pid,$name)=mysql_fetch_row($players)){

    688. 

  688.             $playerlist.="<option value='$pid|$name'>$name</option>";

    689. 

  689.         }

    690. 

  690. 

    691. 

  691.         if($playerlist){

    692. 

  692.             $playerlist="<option value=''>-PLAYER SIGNUPS-</option> $playerlist";

    693. 

  693.         }

    694. 

  694. 

    695. 

  695.         $brackets=mysql_query("SELECT bid,pid,name FROM brackets2 WHERE tid='$admin[tid]' ORDER BY bid");

    696. 

  696.         while(list($bid,$pid,$name)=mysql_fetch_row($brackets)){

    697. 

  697.             $bracket[$bid]="<option value='$pid|$name' SELECTED>$name</option>";

    698. 

  698.         }

    699. 

  699. 

    700. 

  700.     }

    701. 

  701. 

    702. 

  702.     ////////////////////////////////

    703. 

  703.     $brackets="$tinfo[size]";

    704. 

  704.     //TEMP

    705. 

  705.     //$brackets="64";

    706. 

  706.     $spots=($brackets * 2 - 1);

    707. 

  707.     $temp_rows="$brackets";

    708. 

  708.     while($temp_rows > 1){

    709. 

  709.         $rowcount++;

    710. 

  710.         if($rowcount > 1){

    711. 

  711.             $temp_rows=($temp_rows / 2);

    712. 

  712.         }

    713. 

  713. 

    714. 

  714.         $listrows.="-> $temp_rows";

    715. 

  715.         $rows="$rowcount";

    716. 

  716.     }

    717. 

  717. 

    718. 

  718.     $rowwidths=round(100 / $rows - 0.5);

    719. 

  719.     $actualrows=($rows * 2);

    720. 

  720.     /*

    721. 

  721.     //UNCOMMENT SECTION FOR DEBUGGING

    722. 

  722.     echo"

    723. 

  723.     [Bracket Stats]<br>

    724. 

  724.     Brackets: $brackets<br>

    725. 

  725.     Spots: $spots<br>

    726. 

  726.     Game Rows: $rows<br>

    727. 

  727.     Actual Rows: $actualrows<br>

    728. 

  728.     Row Widths: $rowwidths<br>

    729. 

  729.     Pattern: $listrows<br>

    730. 

  730.     <hr>";

    731. 

  731.     */

    732. 

  732.     ////////////////////////////////

    733. 

  733.     $tablehead=table_head("show","70%","","left");

    734. 

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

    735. 

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

    736. 

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

    737. 

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

    738. 

  738.     <center>

    739. 

  739.     $bannerhead

    740. 

  740.     $out[banner]

    741. 

  741.     $bannerfoot  <br>

    742. 

  742.     $tablehead &nbsp; &nbsp;<strong>

    743. 

  743.     <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    744. 

  744.     <tr class ='altcolor'>

    745. 

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

    746. 

  746.     <b>$tinfo[name] Brackets</b><br>

    747. 

  747.     </td></tr></table>

    748. 

  748.     <br>

    749. 

  749.     

    750. 

  750.     <br>

    751. 

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

    752. 

  752.     <tr>

    753. 

  753.     <form method='post'>

    754. 

  754.     ";

    755. 

  755.     $counter="$brackets";

    756. 

  756.     while($counter > 1){

    757. 

  757.         if($round){

    758. 

  758.             $counter=($counter / 2);

    759. 

  759.         }

    760. 

  760. 

    761. 

  761.         $lastcb="$countbrackets";

    762. 

  762.         $countbrackets="";

    763. 

  763.         $game="";

    764. 

  764.         $round++;

    765. 

  765.         $finals=($rows - 1);

    766. 

  766.         $winner=($rows);

    767. 

  767.         $roundgamesay="Round $round Games";

    768. 

  768.         if($round=="$winner"){

    769. 

  769.             $roundgamesay="Winner!";

    770. 

  770.         }

    771. 

  771. 

    772. 

  772.         if($round=="$finals"){

    773. 

  773.             $roundgamesay="Finals";

    774. 

  774.         }

    775. 

  775. 

    776. 

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

    777. 

  777.         <td align='center' valign='center' width='$rowwidths%' colspan='2'><b>$roundgamesay</b><br>

    778. 

  778.         <table border='0' width='100%' bordercolor='#FF0000' cellspacing='0' cellpadding='0'>

    779. 

  779.         ";

    780. 

  780.         $spacesetcount="";

    781. 

  781.         while($countbrackets < $counter){

    782. 

  782.             $countbrackets++;

    783. 

  783.             $spot++;

    784. 

  784.             $spacesetcount++;

    785. 

  785.             if($spacesetcount=="4"){

    786. 

  786.                 $spacesetcount="";

    787. 

  787.             }

    788. 

  788. 

    789. 

  789.             $bracketid="$round"."_"."$countbrackets";

    790. 

  790.             if($btype[text]){

    791. 

  791.                 $inputtype="<input type='text' name='brackets[$bracketid]' value='$bracket[$bracketid]' maxlength='20'>";

    792. 

  792.             }else{

    793. 

  793. 

    794. 

  794.                 $inputtype="<select name='brackets[$bracketid]'>$bracket[$bracketid] $textplayers $playerlist</select>";

    795. 

  795.             }

    796. 

  796. 

    797. 

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

    798. 

  798.             <tr class='altcolor'>

    799. 

  799.             <td align='left' valign='center' width='100%'>$inputtype</td>

    800. 

  800.             <td align='left' valign='center' width='100%'>&nbsp;</td>

    801. 

  801.             </tr>

    802. 

  802.             ";

    803. 

  803.             if($countbrackets < $counter){

    804. 

  804.                 $spacecounter++;

    805. 

  805.                 $spacecounter=($spacecounter + 1);

    806. 

  806.                 if($spacecounter==2){

    807. 

  807.                     $roundx2p1=($lastroundx2p1 * 2 + 1);

    808. 

  808.                     if($round==1){

    809. 

  809.                         $roundx2p1="1";

    810. 

  810.                     }

    811. 

  811. 

    812. 

  812.                     while($countspaces < $roundx2p1){

    813. 

  813.                         $countspaces++;

    814. 

  814.                         $spacesetbgcolor="#$altcolor";

    815. 

  815.                         if((!$spacesetcount)||($spacesetcount=="2")){

    816. 

  816.                             $spacesetbgcolor="";

    817. 

  817.                         }

    818. 

  818. 

    819. 

  819.                         $spacecentercount++;

    820. 

  820.                         $spacecenterword="";

    821. 

  821.                         $alignspacer1="left";

    822. 

  822.                         $spacecentercountcheck=($lastroundx2p1 + 1);

    823. 

  823.                         if($spacecentercount=="$spacecentercountcheck"){

    824. 

  824.                             $spacecenterwordcount++;

    825. 

  825.                             if(($spacecenterwordcount==1)||($spacecenterwordcount==3)){

    826. 

  826.                                 $actualgamecount++;

    827. 

  827.                                 $spacecenterword="<b>Game $actualgamecount</b>";

    828. 

  828.                                 $alignspacer1="center";

    829. 

  829.                                 if($spacecenterwordcount==3){

    830. 

  830.                                     $spacecenterwordcount="";

    831. 

  831.                                     $spacecenterwordcount++;

    832. 

  832.                                 }

    833. 

  833. 

    834. 

  834.                             }

    835. 

  835. 

    836. 

  836.                         }

    837. 

  837. 

    838. 

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

    839. 

  839.                         <tr>

    840. 

  840.                         <td align='$alignspacer1' valign='center'>&nbsp; $spacecenterword</td>

    841. 

  841.                         <td align='left' valign='center' bgcolor='$spacesetbgcolor'>&nbsp;</td>

    842. 

  842.                         </tr>

    843. 

  843.                         ";

    844. 

  844.                     }

    845. 

  845. 

    846. 

  846.                     $spacecounter="";

    847. 

  847.                     $countspaces="";

    848. 

  848.                     $spacecentercount="";

    849. 

  849.                 }

    850. 

  850. 

    851. 

  851.             }

    852. 

  852. 

    853. 

  853.         }

    854. 

  854. 

    855. 

  855.         $spacecenterwordcount="";

    856. 

  856.         $actualgamecount="";

    857. 

  857.         $lastroundx2p1="$roundx2p1";

    858. 

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

    859. 

  859.         </table>

    860. 

  860.         </td>

    861. 

  861.         ";

    862. 

  862.     }

    863. 

  863. 

    864. 

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

    865. 

  865.     </tr>

    866. 

  866.     </table>

    867. 

  867.     <br>

    868. 

  868.     <br><br><br>

    869. 

  869.     <table width='600' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>

    870. 

  870.     <input type='hidden' name='brackets[text]' value='$btype[text]'>

    871. 

  871.     <input type='hidden' name='action' value='admin_brackets_update'>

    872. 

  872.     <input type='hidden' name='tid' value='$tid'>

    873. 

  873.     <tr class ='altcolor'>

    874. 

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

    875. 

  875.     <input type='submit' value='Update Brackets'>

    876. 

  876.     </td></tr></table></form>

    877. 

  877.     <br><br>

    878. 

  878.     $tablefoot";

    879. 

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

    880. 

  880. }

    881. 

  881. 

    882. 

  882. function admin_brackets_update($brackets,$tid){

    883. 

  883.     global $config,$tinfo,$admin,$out,$url,$dir;

    884. 

  884.     mysql_query("DELETE FROM brackets2 WHERE tid='$admin[tid]'");

    885. 

  885.     while(list($bracketid,$playerinfo)=each($brackets)){

    886. 

  886.         if($brackets[text]){

    887. 

  887.             $nameid[1]="$playerinfo";

    888. 

  888.         }else{

    889. 

  889. 

    890. 

  890.             $nameid=split("\|",$playerinfo);

    891. 

  891.         }

    892. 

  892. 

    893. 

  893.         if(($nameid[1])&&($bracketid!="text")){

    894. 

  894.             mysql_query("INSERT INTO brackets2 VALUES (

    895. 

  895.             '$bracketid',

    896. 

  896.             '$admin[tid]',

    897. 

  897.             '$nameid[0]',

    898. 

  898.             '$nameid[1]');");

    899. 

  899.         }

    900. 

  900. 

    901. 

  901.     }

    902. 

  902. 

    903. 

  903.     $tablehead=table_head("show","70%","","left");

    904. 

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

    905. 

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

    906. 

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

    907. 

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

    908. 

  908.     <center>

    909. 

  909.     $bannerhead

    910. 

  910.     $out[banner]

    911. 

  911.     $bannerfoot  <br>

    912. 

  912.     $tablehead<strong>

    913. 

  913.     <center><br>

    914. 

  914.     <font class='catfont'><b>The Brackets have been updated!</b><br></font>

    915. 

  915.     </ul><table><tr><td>

    916. 

  916.     <form>

    917. 

  917.     <input type='hidden' name='action' value='admin_brackets'>

    918. 

  918.     <input type='hidden' name='tid' value='$tid'>

    919. 

  919.     <input type='submit' value='Return to Brackets'>

    920. 

  920.     </form></td><td>

    921. 

  921.     <form>

    922. 

  922.     <input type='hidden' name='action' value='admin_brackets_finish'>

    923. 

  923.     <input type='hidden' name='tid' value='$tid'>

    924. 

  924.     <input type='submit' value='Close Tournament'>

    925. 

  925.     </center>

    926. 

  926.     </form></td></tr></table>

    927. 

  927.     $tablefoot";

    928. 

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

    929. 

  929. }

    930. 

  930. 

    931. 

  931. function admin_brackets_finish($tid){

    932. 

  932.     global $config,$tinfo,$admin,$out,$url,$dir;

    933. 

  933.     $i=0;

    934. 

  934.     $j=0;

    935. 

  935.     $p=0;

    936. 

  936.     $k=0;

    937. 

  937.     $winner = array();

    938. 

  938.     $team1 = array();

    939. 

  939.     $team2 = array();

    940. 

  940.     $report = array(id);

    941. 

  941.     $brackets=mysql_query("SELECT bid,pid,name FROM brackets2  WHERE tid='$admin[tid]' ORDER BY (SUBSTRING_INDEX(bid,'_',1)+0), (SUBSTRING_INDEX(bid,'_',-1)+0)");

    942. 

  942.     while($row= mysql_fetch_array($brackets) ){

    943. 

  943.         $bid = $row[bid];

    944. 

  944.         if(($bid[2]%2==0)&&($bid[2] == $game)&&($bid[0] ==$round)){

    945. 

  945.             $bracketid="$round"."_"."$countbrackets";

    946. 

  946.             $winner[$i] = ($round+1)."_".($bid[2]/2);

    947. 

  947.             $team1[$i] = $teama;

    948. 

  948.             $team2[$i] = $row[pid];

    949. 

  949.             $i++;

    950. 

  950.         }

    951. 

  951. 

    952. 

  952.         $teama = $row[pid];

    953. 

  953.         $round = $bid[0];

    954. 

  954.         $game  = $bid[2] + 1;

    955. 

  955.     }

    956. 

  956. 

    957. 

  957.     $tablehead=table_head("show","70%","","left");

    958. 

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

    959. 

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

    960. 

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

    961. 

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

    962. 

  962.     <center>

    963. 

  963.     $bannerhead

    964. 

  964.     $out[banner]

    965. 

  965.     $bannerfoot  <br>

    966. 

  966.     $tablehead<strong>

    967. 

  967.     <center>

    968. 

  968.     

    969. 

  969.     <b>Would you like to report the following matches played in the tournament?</b><br></font>

    970. 

  970.     </ul>

    971. 

  971.     <table width='400' cellspacing='1' cellpadding='1'>

    972. 

  972.     <tr class='altcolor'><td>#</td><td>Winner</td><td>Loser</td></tr>

    973. 

  973.     <form method=post>

    974. 

  974.     ";

    975. 

  975. 

    976. 

  976.     

    977. 

  977.     while($j<$i){

    978. 

  978.         $winningteam=mysql_fetch_array(mysql_query("SELECT pid,name FROM brackets2 WHERE bid='$winner[$j]' AND tid='$admin[tid]'"));

    979. 

  979.         if($winningteam[pid] == $team1[$j]){

    980. 

  980.             $losingteam = $team2[$j];

    981. 

  981.             $losingteamname=mysql_fetch_array(mysql_query("SELECT teamname FROM teams WHERE id='$losingteam'"));

    982. 

  982.             $k = $j + 1;

    983. 

  983. 

    984. 

  984. 	    $out[body]=$out[body]." <tr class=altcolora'><td><b>$k</b></td><td><b>$winningteam[name]</b></td><td><b>$losingteamname[0]</b></td></tr>";

    985. 

  985.         

    986. 

  986. 	}else if($winningteam[pid] == $team2[$j]){

    987. 

  987. 

    988. 

  988.             $losingteam = $team1[$j];

    989. 

  989.             $losingteamname=mysql_fetch_array(mysql_query("SELECT teamname FROM teams WHERE id='$losingteam'"));

    990. 

  990.             $k = $j + 1;

    991. 

  991.             $out[body]=$out[body]." <tr class=altcolora'><td><b>$k</b></td><td><b>$winningteam[name]</b></td><td><b>$losingteamname[0]</b></td></tr>";

    992. 

  992.         }

    993. 

  993. 

    994. 

  994.         $report[$p] = $winningteam[pid];

    995. 

  995.         $out[body]=$out[body]." <input type='hidden' name='report[$p]' value = '$report[$p]'>";

    996. 

  996.         $p++;

    997. 

  997.         $report[$p] = $losingteam;

    998. 

  998.         $out[body]=$out[body]." <input type='hidden' name='report[$p]' value = '$report[$p]'>";

    999. 

  999.         $p++;

    1000. 

  1000.         $j++;

    1001. 

  1001.     }

    1002. 

  1002. 

    1003. 

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

    1004. 

  1004.     </table>

    1005. 

  1005.     <br><br>

    1006. 

  1006.     <input type='hidden' name='action' value='admin_brackets_report'>

    1007. 

  1007.     <input type='hidden' name='tid' value='$tid'>

    1008. 

  1008.     <input type='submit' value='Close Tournament and Report Matches'>

    1009. 

  1009.     </form>

    1010. 

  1010.     <form>

    1011. 

  1011.     <input type='hidden' name='action' value='admin_brackets_close'>

    1012. 

  1012.     <input type='hidden' name='tid' value='$tid'>

    1013. 

  1013.     <input type='submit' value='Close Tournament Without Reporting Matches'>

    1014. 

  1014.     </form>

    1015. 

  1015.     </center>

    1016. 

  1016.     $tablefoot";

    1017. 

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

    1018. 

  1018. }

    1019. 

  1019. 

    1020. 

  1020. function admin_brackets_report($report){

    1021. 

  1021.     global $config,$tinfo,$admin,$out,$url,$dir,$site,$file;

    1022. 

  1022.     $size=count($report);

    1023. 

  1023.     $i=0;

    1024. 

  1024.     $ladderid = $tinfo[ladderid];

    1025. 

  1025.     if(!$ladderid){

    1026. 

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

    1027. 

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

    1028. 

  1028.     }

    1029. 

  1029. 

    1030. 

  1030.     // ERROR CHECK

    1031. 

  1031.     while($i<$size){

    1032. 

  1032.         $wteamid = $report[$i];

    1033. 

  1033.         $i++;

    1034. 

  1034.         $lteamid = $report[$i];

    1035. 

  1035.         $i++;

    1036. 

  1036.         if((!$wteamid) || (!$lteamid)){

    1037. 

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

    1038. 

  1038.             display_error("<b>No Winning/Losing Team For One Of The Matches. <br> All Reports Aborted. Edit Brackets And Try Again.</b><br>");

    1039. 

  1039.         }

    1040. 

  1040. 

    1041. 

  1041.         if($wteamid==$lteamid){

    1042. 

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

    1043. 

  1043.             display_error("<b>Winning Team And Losing Team The Same For One Of The Matches.<br> All Reports Aborted. Edit Brackets And Try Again.</b><br>");

    1044. 

  1044.         }

    1045. 

  1045. 

    1046. 

  1046.     }

    1047. 

  1047. 

    1048. 

  1048.     $i=0;

    1049. 

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

    1050. 

  1050.     //REPORT

    1051. 

  1051.     while($i<$size){

    1052. 

  1052.         $wteamid = $report[$i];

    1053. 

  1053.         $i++;

    1054. 

  1054.         $lteamid = $report[$i];

    1055. 

  1055.         $i++;

    1056. 

  1056.         $ladderinfo=mysql_query("SELECT laddername FROM ladders WHERE id='$ladderid'");

    1057. 

  1057.         $ladder=mysql_fetch_array($ladderinfo);

    1058. 

  1058.         //GET WINNER STATS

    1059. 

  1059.         $winnerteam=mysql_query("SELECT teamname FROM teams WHERE id='$wteamid'");

    1060. 

  1060.         $winner=mysql_fetch_array($winnerteam);

    1061. 

  1061.         $winteaminfo=mysql_query("SELECT status,rank,games,percent FROM ladder_$ladderid WHERE id='$wteamid'");

    1062. 

  1062.         $wtinfo=mysql_fetch_array($winteaminfo);

    1063. 

  1063.         //GET LOSER STATS

    1064. 

  1064.         $loserteam=mysql_query("SELECT teamname FROM teams WHERE id='$lteamid'");

    1065. 

  1065.         $loser=mysql_fetch_array($loserteam);

    1066. 

  1066.         $losteaminfo=mysql_query("SELECT status,rank,games,percent FROM ladder_$ladderid WHERE id='$lteamid'");

    1067. 

  1067.         $ltinfo=mysql_fetch_array($losteaminfo);

    1068. 

  1068.         // GET SKILL INFO

    1069. 

  1069.         if($wtinfo[rank] > $ltinfo[rank]){

    1070. 

  1070.             $rankdifference=($wtinfo[rank] - $ltinfo[rank]);

    1071. 

  1071.         }else{

    1072. 

  1072. 

    1073. 

  1073.             $rankdifference="1";

    1074. 

  1074.         }

    1075. 

  1075. 

    1076. 

  1076.         if($ltinfo[percent]){

    1077. 

  1077.             $percentoratio=($wtinfo[percent] / $ltinfo[percent]);

    1078. 

  1078.         }else{

    1079. 

  1079. 

    1080. 

  1080.             $percentoratio="1";

    1081. 

  1081.         }

    1082. 

  1082. 

    1083. 

  1083.         $skilladjust=($rankdifference * $percentoratio / 10);

    1084. 

  1084.         $skillfactor=($skilladjust + $wtinfo[games] / 100);

    1085. 

  1085.         if($skillfactor > 20){

    1086. 

  1086.             $gainedskill="20";

    1087. 

  1087.         }else{

    1088. 

  1088. 

    1089. 

  1089.             $gainedskill=round($skillfactor);

    1090. 

  1090.         }

    1091. 

  1091. 

    1092. 

  1092.         //IF BOTH RANKED AND LOSER WAS RANKED BETTER THAN WINNER, WINNER GETS EXTRA POINTS

    1093. 

  1093.         if(($wtinfo[rank] > 0) && ($ltinfo[rank] > 0) && ($wtinfo[rank] > $ltinfo[rank])){

    1094. 

  1094.             $trankedplayers=mysql_query("SELECT COUNT(*) FROM ladder_$ladderid WHERE rank > '0'");

    1095. 

  1095.             $trplayers=mysql_fetch_array($trankedplayers);

    1096. 

  1096.             $rankedplayers="$rplayers[0]";

    1097. 

  1097.             $gainedpoints=($rankedplayers - $ltinfo[rank]);

    1098. 

  1098.             if($gainedpoints < 10){

    1099. 

  1099.                 $gainedpoints=($gainedpoints + 10);

    1100. 

  1100.             }

    1101. 

  1101. 

    1102. 

  1102.         }else{

    1103. 

  1103. 

    1104. 

  1104.             //GET FLAT RATE OF 10 POINTS

    1105. 

  1105.             $gainedpoints="10";

    1106. 

  1106.         }

    1107. 

  1107. 

    1108. 

  1108.         //ADD TO UNVALIDATED MATCHES

    1109. 

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

    1110. 

  1110.         $mcode=md5(uniqid(microtime()));

    1111. 

  1111.         $mcode="$mcode";

    1112. 

  1112.         $ip=getenv("REMOTE_ADDR");

    1113. 

  1113.         mysql_query("INSERT INTO matchdb VALUES (

    1114. 

  1114.         '$mcode',

    1115. 

  1115.         '$wteamid',

    1116. 

  1116.         '$lteamid',

    1117. 

  1117.         '$winner[teamname]',

    1118. 

  1118.         '$loser[teamname]',

    1119. 

  1119.         '$ladderid',

    1120. 

  1120.         '$ladder[laddername]',

    1121. 

  1121.         '$wtinfo[rank]',

    1122. 

  1122.         '$ltinfo[rank]',

    1123. 

  1123.         '0',

    1124. 

  1124.         '0',

    1125. 

  1125.         '0',

    1126. 

  1126.         '0',

    1127. 

  1127.         '0',

    1128. 

  1128.         '0',

    1129. 

  1129.         '0',

    1130. 

  1130.         '0',

    1131. 

  1131.         '0',

    1132. 

  1132.         '0',

    1133. 

  1133.         '0',

    1134. 

  1134.         '$tday',

    1135. 

  1135.         '$ip',

    1136. 

  1136.         '0',

    1137. 

  1137.         '$tday',

    1138. 

  1138.         '$ip');");

    1139. 

  1139.         $getcode=mysql_query("SELECT matchid FROM matchdb WHERE winnerid='$wteamid' AND loserid='$lteamid'");

    1140. 

  1140.         $match=mysql_fetch_array($getcode);

    1141. 

  1141.         $matchcode="$match[matchid]";

    1142. 

  1142.         //GET WINNERS LADDER STATS

    1143. 

  1143.         $winnerladder=mysql_query("SELECT * FROM ladder_$ladderid WHERE id='$wteamid'");

    1144. 

  1144.         $wlinfo=mysql_fetch_array($winnerladder);

    1145. 

  1145.         //GET LOSERS LADDER STATS

    1146. 

  1146.         $loserladder=mysql_query("SELECT * FROM ladder_$ladderid WHERE id='$lteamid'");

    1147. 

  1147.         $llinfo=mysql_fetch_array($loserladder);

    1148. 

  1148.         //GET TOTAL RANKERS

    1149. 

  1149.         $totalranked=mysql_query("SELECT COUNT(*) FROM ladder_$ladderid WHERE rank > '0'");

    1150. 

  1150.         $totalranks=mysql_fetch_array($totalranked);

    1151. 

  1151.         $totalranks="$totalranks[0]";

    1152. 

  1152.         //UPDATE LADDER RANKS

    1153. 

  1153.         if(($wtinfo[rank] > 0) && ($ltinfo[rank] > 0)){

    1154. 

  1154.             $wtempnewrank=($wtinfo[rank] + $ltinfo[rank]);

    1155. 

  1155.             $wtempnewrank=($wtempnewrank / 2 - 0.5);

    1156. 

  1156.             if($wtempnewrank > $totalranks){

    1157. 

  1157.                 $wtempnewrank="$totalranks";

    1158. 

  1158.             }

    1159. 

  1159. 

    1160. 

  1160.         }

    1161. 

  1161. 

    1162. 

  1162.         else if(($wtinfo[rank] < 1) && ($ltinfo[rank] > 0)){

    1163. 

  1163.             $wtempnewrank=($totalranks + 1);

    1164. 

  1164.         }

    1165. 

  1165. 

    1166. 

  1166.         else if(($wtinfo[rank] < 1) && ($ltinfo[rank] < 1)){

    1167. 

  1167.             $wtempnewrank=($totalranks + 1);

    1168. 

  1168.         }else{

    1169. 

  1169. 

    1170. 

  1170.             $wtempnewrank="";

    1171. 

  1171.         }

    1172. 

  1172. 

    1173. 

  1173.         $wtempnewrank=round($wtempnewrank);

    1174. 

  1174.         //IF RANK IS BETTER THAN CURRENT RANK UPDATE LADDER

    1175. 

  1175.         if(($wtempnewrank) && ($wtempnewrank > 0)){

    1176. 

  1176.             if(($wtempnewrank < $wlinfo[rank]) || ($wlinfo[rank] < 1)){

    1177. 

  1177.                 update_teamranks($ladderid,$wteamid,$wtempnewrank);

    1178. 

  1178.                 $updatedrank="$wtempnewrank";

    1179. 

  1179.             }

    1180. 

  1180. 

    1181. 

  1181.         }

    1182. 

  1182. 

    1183. 

  1183.         //UPDATE WINNERS LADDER STATS

    1184. 

  1184.         if($updatedrank){

    1185. 

  1185.             $newlastrank="$wlinfo[rank]";

    1186. 

  1186.             if(($updatedrank < $wlinfo[bestrank]) || ($wlinfo[bestrank] < 1)){

    1187. 

  1187.                 $newbestrank="$updatedrank";

    1188. 

  1188.             }else{

    1189. 

  1189. 

    1190. 

  1190.                 $newbestrank="$wlinfo[bestrank]";

    1191. 

  1191.             }

    1192. 

  1192. 

    1193. 

  1193.         }else{

    1194. 

  1194. 

    1195. 

  1195.             $newlastrank="$wlinfo[lastrank]";

    1196. 

  1196.             $newbestrank="$wlinfo[bestrank]";

    1197. 

  1197.         }

    1198. 

  1198. 

    1199. 

  1199.         $newwins=($wlinfo[wins] + 1);

    1200. 

  1200.         $newgames=($newwins + $wlinfo[losses]);

    1201. 

  1201.         $newpercent=round($newwins / $newgames * 100);

    1202. 

  1202.         $newstreak=($wlinfo[streak] + 1);

    1203. 

  1203.         if($newstreak < 1){

    1204. 

  1204.             $newstreak="1";

    1205. 

  1205.         }

    1206. 

  1206. 

    1207. 

  1207.         if($newstreak > $wlinfo[beststreak]){

    1208. 

  1208.             $newbeststreak="$newstreak";

    1209. 

  1209.         }else{

    1210. 

  1210. 

    1211. 

  1211.             $newbeststreak="$wlinfo[beststreak]";

    1212. 

  1212.         }

    1213. 

  1213. 

    1214. 

  1214.         if($llinfo[rank] > 0){

    1215. 

  1215.             $newpoints=($totalranks - $llinfo[rank]);

    1216. 

  1216.             $newpoints=round($newpoints / 10);

    1217. 

  1217.         }

    1218. 

  1218. 

    1219. 

  1219.         if($newpoints < 10){

    1220. 

  1220.             $newpoints="10";

    1221. 

  1221.         }

    1222. 

  1222. 

    1223. 

  1223.         $newskill=($wlinfo[skill] + $totalkills);

    1224. 

  1224.         $newpoints=($newpoints + $wlinfo[points]);

    1225. 

  1225.         mysql_query("UPDATE ladder_$ladderid SET

    1226. 

  1226.         lastmatch='$tday',

    1227. 

  1227.         lastplayed='$lteamid',

    1228. 

  1228.         statusdisplay='',

    1229. 

  1229.         lastrank='$newlastrank',

    1230. 

  1230.         bestrank='$newbestrank',

    1231. 

  1231.         wins='$newwins',

    1232. 

  1232.         games='$newgames',

    1233. 

  1233.         percent='$newpercent',

    1234. 

  1234.         streak='$newstreak',

    1235. 

  1235.         beststreak='$newbeststreak',

    1236. 

  1236.         points='$newpoints',

    1237. 

  1237.         skill='$newskill'

    1238. 

  1238.         WHERE id='$wteamid'");

    1239. 

  1239.         //UPDATE LOSERS LADDER STATS

    1240. 

  1240.         $newlastrank="$llinfo[rank]";

    1241. 

  1241.         if(($llinfo[rank] < $llinfo[bestrank]) || ($llinfo[bestrank]=="0")){

    1242. 

  1242.             $newbestrank="$llinfo[rank]";

    1243. 

  1243.         }else{

    1244. 

  1244. 

    1245. 

  1245.             $newbestrank="$llinfo[bestrank]";

    1246. 

  1246.         }

    1247. 

  1247. 

    1248. 

  1248.         if($llinfo[rank] > $llinfo[worstrank]){

    1249. 

  1249.             $newworstrank="$llinfo[rank]";

    1250. 

  1250.         }else{

    1251. 

  1251. 

    1252. 

  1252.             $newworstrank="$llinfo[worstrank]";

    1253. 

  1253.         }

    1254. 

  1254. 

    1255. 

  1255.         $newlosses=($llinfo[losses] + 1);

    1256. 

  1256.         $newgames=($newlosses + $llinfo[wins]);

    1257. 

  1257.         $newpercent=round($llinfo[wins] / $newgames * 100);

    1258. 

  1258.         $newstreak=($llinfo[streak] - 1);

    1259. 

  1259.         if($newstreak > 0){

    1260. 

  1260.             $newstreak="-1";

    1261. 

  1261.         }

    1262. 

  1262. 

    1263. 

  1263.         if($newstreak < $llinfo[worststreak]){

    1264. 

  1264.             $newworststreak="$newstreak";

    1265. 

  1265.         }else{

    1266. 

  1266. 

    1267. 

  1267.             $newworststreak="$llinfo[worststreak]";

    1268. 

  1268.         }

    1269. 

  1269. 

    1270. 

  1270.         $newskill=($llinfo[skill] + $match[skill]);

    1271. 

  1271.         mysql_query("UPDATE ladder_$ladderid SET

    1272. 

  1272.         lastmatch='$tday',

    1273. 

  1273.         lastplayed='$wteamid',

    1274. 

  1274.         statusdisplay='',

    1275. 

  1275.         lastrank='$newlastrank',

    1276. 

  1276.         bestrank='$newbestrank',

    1277. 

  1277.         worstrank='$newworstrank',

    1278. 

  1278.         losses='$newlosses',

    1279. 

  1279.         games='$newgames',

    1280. 

  1280.         percent='$newpercent',

    1281. 

  1281.         streak='$newstreak',

    1282. 

  1282.         worststreak='$newworststreak',

    1283. 

  1283.         skill='$newskill'

    1284. 

  1284.         WHERE id='$lteamid'");

    1285. 

  1285.         $ranksadjusted=rank_checkadjust($ladderid);

    1286. 

  1286.     }

    1287. 

  1287. 

    1288. 

  1288.     mysql_query("UPDATE tourneys SET open='0' WHERE tid='$admin[tid]'");

    1289. 

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

    1290. 

  1290.     display_message("All Matches Have Been Reported. <br><br>Tournament is now closed and cannot be edited further without re-opening.<br>");

    1291. 

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

    1292. 

  1292. }

    1293. 

  1293. 

    1294. 

  1294. function admin_autobracket(){

    1295. 

  1295.     global $config,$tinfo,$admin,$out,$url,$dir,$site,$file;

    1296. 

  1296.     mysql_query("DELETE FROM brackets2 WHERE tid='$admin[tid]'");

    1297. 

  1297.     $players=mysql_query("SELECT pid,name FROM players2 WHERE tid='$admin[tid]' ORDER BY joined LIMIT $tinfo[size]");

    1298. 

  1298.     while(list($pid,$name)=mysql_fetch_row($players)){

    1299. 

  1299.         $count++;

    1300. 

  1300.         mysql_query("INSERT INTO brackets2 VALUES (

    1301. 

  1301.         '1_$count',

    1302. 

  1302.         '$admin[tid]',

    1303. 

  1303.         '$pid',

    1304. 

  1304.         '$name');");

    1305. 

  1305.     }

    1306. 

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

    1307. 

  1307.     display_message("The brackets have been automatically set.<br>");

    1308. 

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

    1309. 

  1309. }

    1310. 

  1310. 

    1311. 

  1311. function close_tournament(){

    1312. 

  1312.     global $config,$tinfo,$admin,$out,$url,$dir,$site,$file;

    1313. 

  1313.     mysql_query("UPDATE tourneys SET open='0' WHERE tid='$admin[tid]'");

    1314. 

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

    1315. 

  1315.     display_message("Tournament is now closed and cannot be edited further.<br>The results were not reported.<br>");

    1316. 

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

    1317. 

  1317. }

    1318. 

  1318. 

    1319. 

  1319. ?>

    1320. 

  1320.