PageRenderTime 110ms CodeModel.GetById 32ms RepoModel.GetById 1ms app.codeStats 0ms

/functions/admin_ladders.php

https://bitbucket.org/verax/to-ladder
PHP | 2069 lines | 2017 code | 47 blank | 5 comment | 45 complexity | 06bc4a49d8a54a9d1ffe070a42528d04 MD5 | raw file

Large files files are truncated, but you can click here to view the full file

  1. <?PHP
  2. if(!IsSet($indexloaded)){
  3. header("Location: ./index.php");
  4. }
  5. if($admn[access] < 90){
  6. include("$dir[func]/error.php");
  7. display_error("You are not allowed to perform this function.<br>");
  8. }
  9. function admin_editladders(){
  10. global $dir, $url, $out, $site, $admn;
  11. $ladderslist=mysql_query("SELECT id,laddername FROM ladders ORDER by laddername");
  12. while(list($id,$name)=mysql_fetch_row($ladderslist)){
  13. $theladders=$theladders."<option value='$id'>$name</option>";
  14. }
  15. $tablehead=table_head("show","100%","","center");
  16. $tablefoot=table_foot("show");
  17. $bannerhead=table_head("show","488","80","center");
  18. $bannerfoot=table_foot("show");
  19. $out[body]=$out[body]."
  20. <center>
  21. $bannerhead
  22. $out[banner]
  23. $bannerfoot
  24. </center>
  25. <br>
  26. <table width='100%' border='1' bordercolor='#000000' cellspacing='0' cellpadding='2'>
  27. <tr class='altcolor'>
  28. <form method='post'>
  29. <td width='100%' valign='top' align='center'>
  30. <strong>Manage Ladders</strong><br>
  31. </td>
  32. </tr>
  33. <tr>
  34. <td width='100%' valign='center' align='center'>
  35. <br>
  36. Select a ladder<br>
  37. <select name='ladderid'>
  38. <option value=''>Select a ladder or create a new one</option>
  39. $theladders</select><br>
  40. <br></td>
  41. </tr>
  42. <tr class='altcolor'>
  43. <script language='javascript'>var confirmdelete='Are you 100% sure you want to DELETE this LADDER - This will delete all teams on this ladder and remove all members from those teams. All tournaments on this ladder will be deleted also.';</script>
  44. <td width='100%' valign='top' align='center'>
  45. <input type='hidden' name='action' value='editladdersb'>
  46. <input type='submit' name='todo' value='Create Ladder'>
  47. <input type='submit' name='todo' value='Edit Ladder'>
  48. <input type='submit' name='todo' value='Delete Ladder' onClick='return confirm(confirmdelete);'>
  49. </td>
  50. </form>
  51. </tr>
  52. </table>";
  53. include("$dir[curtheme]");
  54. }
  55. function admin_editladdersb($ladderid,$todo){
  56. global $dir, $url, $out, $site, $admn;
  57. if((!$ladderid) && ($todo!="Create Ladder")){
  58. include("$dir[func]/error.php");
  59. display_error("Invalid Ladder ID.<br>");
  60. }
  61. if($todo=="Create Ladder"){
  62. create_ladder();
  63. }
  64. else if($todo=="Edit Ladder"){
  65. edit_ladder($ladderid);
  66. }
  67. else if($todo=="Delete Ladder"){
  68. delete_ladder($ladderid);
  69. include("$dir[func]/admin_finishmessage.php");
  70. display_message("The ladder was deleted.<br>");
  71. }
  72. else{
  73. include("$dir[func]/error.php");
  74. display_error("Unknown Command.<br>");
  75. }
  76. }
  77. function create_ladder(){
  78. global $dir, $url, $out, $site, $admn;
  79. $curgames=mysql_query("SELECT id,gamename FROM games ORDER by gamename");
  80. while(list($id, $name)=mysql_fetch_row($curgames)){
  81. $thegames=$thegames."<option value='$id'>$name</option>";
  82. $howmanyeditable=1;
  83. }
  84. if(!$howmanyeditable){
  85. include("$dir[func]/error.php");
  86. display_error("You must create games before ladders.<br>");
  87. }
  88. //TABLE ATERNATING COLORS
  89. $altcolora="#000033";
  90. $altcolorb="#000020";
  91. $tablehead=table_head("show","100%","","center");
  92. $tablefoot=table_foot("show");
  93. $bannerhead=table_head("show","488","80","center");
  94. $bannerfoot=table_foot("show");
  95. $out[body]=$out[body]."
  96. <center>
  97. $bannerhead
  98. $out[banner]
  99. $bannerfoot
  100. </center>
  101. <br>
  102. <table width='100%' border='1' bordercolor='#000000' cellspacing='1' cellpadding='4'>
  103. <tr class='altcolor'>
  104. <td width='100%' valign='top' align='center'>
  105. <strong>Create Ladder</strong></td>
  106. </tr>
  107. <tr>
  108. <td width='100%' valign='top' align='left'>
  109. <form method='post'>
  110. <table width='100%' border='0' cellspacing='1' cellpadding='1' valign='top' align='center'>
  111. <tr class='altcolora'>
  112. <td width='50%' valign='center' align='left'>
  113. *Ladders Game Category</td>
  114. <td width='50%' valign='center' align='left'>
  115. <select name='ld_gameid'>
  116. $thegames
  117. </select></td>
  118. </tr>
  119. <tr class='altcolorb'>
  120. <td width='50%' valign='center' align='left'>
  121. *Ladders Full Name [e.g. Rainbow Six 3 Teams]</td>
  122. <td width='50%' valign='center' align='left'>
  123. <input type='text' name='ld_name' value='$ladderinfo[laddername]' size='30' maxlength='30'></td>
  124. </tr>
  125. <tr class='altcolora'>
  126. <td width='50%' valign='center' align='left'>
  127. *Ladder Abbreviation [RST]</td>
  128. <td width='50%' valign='center' align='left'>
  129. <input type='text' name='ld_abrv' value='$ladderinfo[abbreviation]' size='30' maxlength='10'></td>
  130. </tr>
  131. <tr class='altcolorb'>
  132. <td width='50%' valign='top' align='left'>
  133. Ladder Description<br>200 Characters max</td>
  134. <td width='50%' valign='center' align='left'><textarea name='ld_desc' rows='3' cols='25' maxlength='200'>$ladderinfo[description]</textarea></td>
  135. </tr>
  136. ";
  137. $selected="";
  138. $value="";
  139. $value=$ladderinfo[type];
  140. $selected[$value]="SELECTED";
  141. $out[body]=$out[body]."
  142. <tr class='altcolora'>
  143. <td width='50%' valign='center' align='left'>
  144. Ladder Type</td>
  145. <td width='50%' valign='center' align='left'>
  146. <select name='ld_type'>
  147. <option value='1' $selected[1]>Singles 1v1</option>
  148. <option value='3' $selected[3]>Teams/Clans</option>
  149. </select></td>
  150. </tr>
  151. ";
  152. $selected="";
  153. $value="";
  154. $value=$ladderinfo[openplay];
  155. $selected[$value]="SELECTED";
  156. $out[body]=$out[body]."
  157. <tr class='altcolorb'>
  158. <td width='50%' valign='center' align='left'>
  159. Ladder Play</td>
  160. <td width='50%' valign='center' align='left'>
  161. <select name='ld_openreport'>
  162. <option value='1' $selected[1]>1: Challenges and Open Play - Teams/Players Unranked On Signup</option>
  163. <option value='0' $selected[0]>2: Challenges Only - Teams/Players Ranked On Signup</option>
  164. <option value='2' $selected[2]>3: Open Play Only - Teams/Players Unranked On Signup</option>
  165. </select></td>
  166. </tr>
  167. ";
  168. $selected="";
  169. $value="";
  170. $value=$ladderinfo[minmembers];
  171. $selected[$value]="SELECTED";
  172. $out[body]=$out[body]."
  173. <tr class='altcolora'>
  174. <td width='50%' valign='center' align='left'>
  175. Min/Max Team Members [Set both to One for 1v1 ladders]</td>
  176. <td width='50%' valign='center' align='left'>
  177. <select name='ld_plyrmin'>
  178. <option value='1' $selected[1]>Min 1</option>
  179. <option value='2' $selected[2]>2</option>
  180. <option value='3' $selected[3]>3</option>
  181. <option value='4' $selected[4]>4</option>
  182. <option value='5' $selected[5]>5</option>
  183. <option value='6' $selected[6]>6</option>
  184. <option value='7' $selected[7]>7</option>
  185. <option value='8' $selected[8]>8</option>
  186. <option value='9' $selected[9]>9</option>
  187. <option value='10' $selected[10]>10</option>
  188. <option value='11' $selected[11]>11</option>
  189. <option value='12' $selected[12]>12</option>
  190. <option value='13' $selected[13]>13</option>
  191. <option value='14' $selected[14]>14</option>
  192. <option value='15' $selected[15]>15</option>
  193. <option value='16' $selected[16]>16</option>
  194. <option value='17' $selected[17]>17</option>
  195. <option value='18' $selected[18]>18</option>
  196. <option value='19' $selected[19]>19</option>
  197. <option value='20' $selected[20]>20</option>
  198. <option value='21' $selected[21]>21</option>
  199. <option value='22' $selected[22]>22</option>
  200. <option value='23' $selected[23]>23</option>
  201. <option value='24' $selected[24]>24</option>
  202. <option value='25' $selected[25]>25</option>
  203. <option value='26' $selected[26]>26</option>
  204. <option value='27' $selected[27]>27</option>
  205. <option value='28' $selected[28]>28</option>
  206. <option value='29' $selected[29]>29</option>
  207. <option value='30' $selected[30]>30</option>
  208. <option value='31' $selected[31]>31</option>
  209. <option value='32' $selected[32]>32</option>
  210. <option value='33' $selected[33]>33</option>
  211. <option value='34' $selected[34]>34</option>
  212. <option value='35' $selected[35]>35</option>
  213. <option value='36' $selected[36]>36</option>
  214. <option value='37' $selected[37]>37</option>
  215. <option value='38' $selected[38]>38</option>
  216. <option value='39' $selected[39]>39</option>
  217. <option value='40' $selected[40]>40</option>
  218. <option value='41' $selected[41]>41</option>
  219. <option value='42' $selected[42]>42</option>
  220. <option value='43' $selected[43]>43</option>
  221. <option value='44' $selected[44]>44</option>
  222. <option value='45' $selected[45]>45</option>
  223. <option value='46' $selected[46]>46</option>
  224. <option value='47' $selected[47]>47</option>
  225. <option value='48' $selected[48]>48</option>
  226. <option value='49' $selected[49]>49</option>
  227. <option value='50' $selected[50]>50</option>
  228. <option value='60' $selected[60]>60</option>
  229. <option value='70' $selected[70]>70</option>
  230. <option value='80' $selected[80]>80</option>
  231. <option value='90' $selected[90]>90</option>
  232. <option value='100' $selected[100]>100</option>
  233. </select> /
  234. ";
  235. $selected="";
  236. $value="";
  237. $value=$ladderinfo[maxmembers];
  238. $selected[$value]="SELECTED";
  239. $out[body]=$out[body]."
  240. <select name='ld_plyrmax'>
  241. <option value='1' $selected[1]>Max 1</option>
  242. <option value='2' $selected[2]>2</option>
  243. <option value='3' $selected[3]>3</option>
  244. <option value='4' $selected[4]>4</option>
  245. <option value='5' $selected[5]>5</option>
  246. <option value='6' $selected[6]>6</option>
  247. <option value='7' $selected[7]>7</option>
  248. <option value='8' $selected[8]>8</option>
  249. <option value='9' $selected[9]>9</option>
  250. <option value='10' $selected[10]>10</option>
  251. <option value='11' $selected[11]>11</option>
  252. <option value='12' $selected[12]>12</option>
  253. <option value='13' $selected[13]>13</option>
  254. <option value='14' $selected[14]>14</option>
  255. <option value='15' $selected[15]>15</option>
  256. <option value='16' $selected[16]>16</option>
  257. <option value='17' $selected[17]>17</option>
  258. <option value='18' $selected[18]>18</option>
  259. <option value='19' $selected[19]>19</option>
  260. <option value='20' $selected[20]>20</option>
  261. <option value='21' $selected[21]>21</option>
  262. <option value='22' $selected[22]>22</option>
  263. <option value='23' $selected[23]>23</option>
  264. <option value='24' $selected[24]>24</option>
  265. <option value='25' $selected[25]>25</option>
  266. <option value='26' $selected[26]>26</option>
  267. <option value='27' $selected[27]>27</option>
  268. <option value='28' $selected[28]>28</option>
  269. <option value='29' $selected[29]>29</option>
  270. <option value='30' $selected[30]>30</option>
  271. <option value='31' $selected[31]>31</option>
  272. <option value='32' $selected[32]>32</option>
  273. <option value='33' $selected[33]>33</option>
  274. <option value='34' $selected[34]>34</option>
  275. <option value='35' $selected[35]>35</option>
  276. <option value='36' $selected[36]>36</option>
  277. <option value='37' $selected[37]>37</option>
  278. <option value='38' $selected[38]>38</option>
  279. <option value='39' $selected[39]>39</option>
  280. <option value='40' $selected[40]>40</option>
  281. <option value='41' $selected[41]>41</option>
  282. <option value='42' $selected[42]>42</option>
  283. <option value='43' $selected[43]>43</option>
  284. <option value='44' $selected[44]>44</option>
  285. <option value='45' $selected[45]>45</option>
  286. <option value='46' $selected[46]>46</option>
  287. <option value='47' $selected[47]>47</option>
  288. <option value='48' $selected[48]>48</option>
  289. <option value='49' $selected[49]>49</option>
  290. <option value='50' $selected[50]>50</option>
  291. <option value='60' $selected[60]>60</option>
  292. <option value='70' $selected[70]>70</option>
  293. <option value='80' $selected[80]>80</option>
  294. <option value='90' $selected[90]>90</option>
  295. <option value='100' $selected[100]>100</option>
  296. </select></td>
  297. </tr>
  298. ";
  299. $selected="";
  300. $value="";
  301. $value=$ladderinfo[minmaps];
  302. $selected[$value]="SELECTED";
  303. $out[body]=$out[body]."
  304. <tr class='altcolorb'>
  305. <td width='50%' valign='center' align='left'>
  306. Minimum Maps Played each match</td>
  307. <td width='50%' valign='center' align='left'>
  308. <select name='ld_minmaps'>
  309. <option value='0' $selected[1]>No Maps</option>
  310. <option value='1' $selected[1]>1</option>
  311. <option value='2' $selected[2]>2</option>
  312. <option value='3' $selected[3]>3</option>
  313. <option value='4' $selected[4]>4</option>
  314. <option value='5' $selected[5]>5</option>
  315. <option value='6' $selected[6]>6</option>
  316. <option value='7' $selected[7]>7</option>
  317. <option value='8' $selected[8]>8</option>
  318. <option value='9' $selected[9]>9</option>
  319. <option value='10' $selected[10]>10</option>
  320. </select></td>
  321. </tr>
  322. ";
  323. $selected="";
  324. $value="";
  325. $value=$ladderinfo[maxmaps];
  326. $selected[$value]="SELECTED";
  327. $out[body]=$out[body]."
  328. <tr class='altcolora'>
  329. <td width='50%' valign='center' align='left'>
  330. Maximum Maps Played each match</td>
  331. <td width='50%' valign='center' align='left'>
  332. <select name='ld_maxmaps'>
  333. <option value='0' $selected[0]>No Maps</option>
  334. <option value='1' $selected[1]>1</option>
  335. <option value='2' $selected[2]>2</option>
  336. <option value='3' $selected[3]>3</option>
  337. <option value='4' $selected[4]>4</option>
  338. <option value='5' $selected[5]>5</option>
  339. <option value='6' $selected[6]>6</option>
  340. <option value='7' $selected[7]>7</option>
  341. <option value='8' $selected[8]>8</option>
  342. <option value='9' $selected[9]>9</option>
  343. <option value='10' $selected[10]>10</option>
  344. </select></td>
  345. </tr>
  346. ";
  347. $selected="";
  348. $value="";
  349. $value=$ladderinfo[inactivedaysa];
  350. $selected[$value]="SELECTED";
  351. $out[body]=$out[body]."
  352. <tr class='altcolorb'>
  353. <td width='50%' valign='center' align='left'>
  354. Inactive Days until drop [Repeats]</td>
  355. <td width='50%' valign='center' align='left'>
  356. <select name='ld_inactvdaysa'>
  357. <option value='500000' $selected[500000]>Disabled</option>
  358. <option value='1' $selected[1]>1 day</option>
  359. <option value='2' $selected[2]>2 days</option>
  360. <option value='3' $selected[3]>3</option>
  361. <option value='4' $selected[4]>4</option>
  362. <option value='5' $selected[5]>5</option>
  363. <option value='6' $selected[6]>6</option>
  364. <option value='7' $selected[7]>7 - 1 week</option>
  365. <option value='8' $selected[8]>8</option>
  366. <option value='9' $selected[9]>9</option>
  367. <option value='10' $selected[10]>10</option>
  368. <option value='11' $selected[11]>11</option>
  369. <option value='12' $selected[12]>12</option>
  370. <option value='13' $selected[13]>13</option>
  371. <option value='14' $selected[14]>14 - 2 weeks</option>
  372. <option value='15' $selected[15]>15</option>
  373. <option value='16' $selected[16]>16</option>
  374. <option value='17' $selected[17]>17</option>
  375. <option value='18' $selected[18]>18</option>
  376. <option value='19' $selected[19]>19</option>
  377. <option value='20' $selected[20]>20</option>
  378. <option value='21' $selected[21]>21 - 3 weeks</option>
  379. <option value='22' $selected[22]>22</option>
  380. <option value='23' $selected[23]>23</option>
  381. <option value='24' $selected[24]>24</option>
  382. <option value='25' $selected[25]>25</option>
  383. <option value='26' $selected[26]>26</option>
  384. <option value='27' $selected[27]>27</option>
  385. <option value='28' $selected[28]>28 - 4 weeks</option>
  386. <option value='29' $selected[29]>29</option>
  387. <option value='30' $selected[30]>30 days</option>
  388. </select></td>
  389. </tr>
  390. ";
  391. $selected="";
  392. $value="";
  393. $value=$ladderinfo[inactivedrop];
  394. $selected[$value]="SELECTED";
  395. $out[body]=$out[body]."
  396. <tr class='altcolora'>
  397. <td width='50%' valign='center' align='left'>
  398. Inactive drop rank amount [If drops enabled above]</td>
  399. <td width='50%' valign='center' align='left'>
  400. <select name='ld_inactvdrop'>
  401. <option value='1' $selected[1]>1 rank</option>
  402. <option value='2' $selected[2]>2 ranks</option>
  403. <option value='3' $selected[3]>3</option>
  404. <option value='4' $selected[4]>4</option>
  405. <option value='5' $selected[5]>5</option>
  406. <option value='6' $selected[6]>6</option>
  407. <option value='7' $selected[7]>7</option>
  408. <option value='8' $selected[8]>8</option>
  409. <option value='9' $selected[9]>9</option>
  410. <option value='10' $selected[10]>10</option>
  411. <option value='11' $selected[11]>11</option>
  412. <option value='12' $selected[12]>12</option>
  413. <option value='13' $selected[13]>13</option>
  414. <option value='14' $selected[14]>14</option>
  415. <option value='15' $selected[15]>15</option>
  416. <option value='16' $selected[16]>16</option>
  417. <option value='17' $selected[17]>17</option>
  418. <option value='18' $selected[18]>18</option>
  419. <option value='19' $selected[19]>19</option>
  420. <option value='20' $selected[20]>20</option>
  421. <option value='21' $selected[21]>21</option>
  422. <option value='22' $selected[22]>22</option>
  423. <option value='23' $selected[23]>23</option>
  424. <option value='24' $selected[24]>24</option>
  425. <option value='25' $selected[25]>25 ranks</option>
  426. </select></td>
  427. </tr>
  428. ";
  429. $selected="";
  430. $value="";
  431. $value=$ladderinfo[inactivedaysb];
  432. $selected[$value]="SELECTED";
  433. $out[body]=$out[body]."
  434. <tr class='altcolorb'>
  435. <td width='50%' valign='center' align='left'>
  436. Inactive Days until teams deleted</td>
  437. <td width='50%' valign='center' align='left'>
  438. <select name='ld_inactvdaysb'>
  439. <option value='500000' $selected[500000]>Disabled</option>
  440. <option value='1' $selected[1]>1 day</option>
  441. <option value='2' $selected[2]>2 days</option>
  442. <option value='3' $selected[3]>3</option>
  443. <option value='4' $selected[4]>4</option>
  444. <option value='5' $selected[5]>5</option>
  445. <option value='6' $selected[6]>6</option>
  446. <option value='7' $selected[7]>7 - 1 week</option>
  447. <option value='8' $selected[8]>8</option>
  448. <option value='9' $selected[9]>9</option>
  449. <option value='10' $selected[10]>10</option>
  450. <option value='11' $selected[11]>11</option>
  451. <option value='12' $selected[12]>12</option>
  452. <option value='13' $selected[13]>13</option>
  453. <option value='14' $selected[14]>14 - 2 weeks</option>
  454. <option value='15' $selected[15]>15</option>
  455. <option value='16' $selected[16]>16</option>
  456. <option value='17' $selected[17]>17</option>
  457. <option value='18' $selected[18]>18</option>
  458. <option value='19' $selected[19]>19</option>
  459. <option value='20' $selected[20]>20</option>
  460. <option value='21' $selected[21]>21 - 3 weeks</option>
  461. <option value='22' $selected[22]>22</option>
  462. <option value='23' $selected[23]>23</option>
  463. <option value='24' $selected[24]>24</option>
  464. <option value='25' $selected[25]>25</option>
  465. <option value='26' $selected[26]>26</option>
  466. <option value='27' $selected[27]>27</option>
  467. <option value='28' $selected[28]>28 - 4 weeks</option>
  468. <option value='29' $selected[29]>29</option>
  469. <option value='30' $selected[30]>30 days</option>
  470. <option value='35' $selected[35]>35 - 5 weeks</option>
  471. <option value='42' $selected[42]>42 - 6 weeks</option>
  472. <option value='49' $selected[49]>49 - 7 weeks</option>
  473. <option value='56' $selected[56]>56 - 8 weeks</option>
  474. <option value='63' $selected[63]>63 - 9 weeks</option>
  475. </select></td>
  476. </tr>
  477. </table>
  478. </td>
  479. </tr>
  480. <tr class='altcolor'>
  481. <td width='100%' valign='top' align='center'>
  482. <strong>Challenging Information</strong></td>
  483. </tr>
  484. <tr>
  485. <td width='100%' valign='top' align='left'>
  486. <table width='100%' border='0' cellspacing='1' cellpadding='1' valign='top' align='center'>
  487. ";
  488. $selected="";
  489. $value="";
  490. $value=$ladderinfo[challenge];
  491. $selected[$value]="SELECTED";
  492. $out[body]=$out[body]."
  493. <tr class='altcolora'>
  494. <td width='50%' valign='center' align='left'>
  495. Allow Challenging</td>
  496. <td width='50%' valign='center' align='left'>
  497. <select name='ld_chal'>
  498. <option value='0' $selected[0]>No</option>
  499. <option value='1' $selected[1]>Yes</option>
  500. </select></td>
  501. </tr>
  502. ";
  503. $selected="";
  504. $value="";
  505. $value=$ladderinfo[challranks];
  506. $selected[$value]="SELECTED";
  507. $out[body]=$out[body]."
  508. <tr class='altcolorb'>
  509. <td width='50%' valign='center' align='left'>
  510. Maximum Ranks Teams Can Challenge Above Their Rank</td>
  511. <td width='50%' valign='center' align='left'>
  512. <select name='ld_chalranks'>
  513. <option value='1000' $selected[1000]>Anyone</option>
  514. <option value='1' $selected[1]>1</option>
  515. <option value='2' $selected[2]>2</option>
  516. <option value='3' $selected[3]>3</option>
  517. <option value='4' $selected[4]>4</option>
  518. <option value='5' $selected[5]>5</option>
  519. <option value='6' $selected[6]>6</option>
  520. <option value='7' $selected[7]>7</option>
  521. <option value='8' $selected[8]>8</option>
  522. <option value='9' $selected[9]>9</option>
  523. <option value='10' $selected[10]>10</option>
  524. <option value='11' $selected[11]>11</option>
  525. <option value='12' $selected[12]>12</option>
  526. <option value='13' $selected[13]>13</option>
  527. <option value='14' $selected[14]>14</option>
  528. <option value='15' $selected[15]>15</option>
  529. <option value='16' $selected[16]>16</option>
  530. <option value='17' $selected[17]>17</option>
  531. <option value='18' $selected[18]>18</option>
  532. <option value='19' $selected[19]>19</option>
  533. <option value='20' $selected[20]>20</option>
  534. <option value='21' $selected[21]>21</option>
  535. <option value='22' $selected[22]>22</option>
  536. <option value='23' $selected[23]>23</option>
  537. <option value='24' $selected[24]>24</option>
  538. <option value='25' $selected[25]>25</option>
  539. <option value='26' $selected[26]>26</option>
  540. <option value='27' $selected[27]>27</option>
  541. <option value='28' $selected[28]>28</option>
  542. <option value='29' $selected[29]>29</option>
  543. <option value='30' $selected[30]>30</option>
  544. <option value='31' $selected[31]>31</option>
  545. <option value='32' $selected[32]>32</option>
  546. <option value='33' $selected[33]>33</option>
  547. <option value='34' $selected[34]>34</option>
  548. <option value='35' $selected[35]>35</option>
  549. <option value='36' $selected[36]>36</option>
  550. <option value='37' $selected[37]>37</option>
  551. <option value='38' $selected[38]>38</option>
  552. <option value='39' $selected[39]>39</option>
  553. <option value='40' $selected[40]>40</option>
  554. <option value='41' $selected[41]>41</option>
  555. <option value='42' $selected[42]>42</option>
  556. <option value='43' $selected[43]>43</option>
  557. <option value='44' $selected[44]>44</option>
  558. <option value='45' $selected[45]>45</option>
  559. <option value='46' $selected[46]>46</option>
  560. <option value='47' $selected[47]>47</option>
  561. <option value='48' $selected[48]>48</option>
  562. <option value='49' $selected[49]>49</option>
  563. <option value='50' $selected[50]>50</option>
  564. <option value='60' $selected[60]>60</option>
  565. <option value='70' $selected[70]>70</option>
  566. <option value='80' $selected[80]>80</option>
  567. <option value='90' $selected[90]>90</option>
  568. <option value='100' $selected[100]>100</option>
  569. </select></td>
  570. </tr>
  571. ";
  572. $selected="";
  573. $value="";
  574. $value=$ladderinfo[respondhours];
  575. $selected[$value]="SELECTED";
  576. $out[body]=$out[body]."
  577. <tr class='altcolora'>
  578. <td width='50%' valign='center' align='left'>
  579. Hours to respond to challenges [Before forfeit awarded]</td>
  580. <td width='50%' valign='center' align='left '>
  581. <select name='ld_chalrespnd'>
  582. <option value='1' $selected[1]>1 Hour</option>
  583. <option value='2' $selected[2]>2</option>
  584. <option value='3' $selected[3]>3</option>
  585. <option value='4' $selected[4]>4</option>
  586. <option value='5' $selected[5]>5</option>
  587. <option value='6' $selected[6]>6</option>
  588. <option value='7' $selected[7]>7</option>
  589. <option value='8' $selected[8]>8</option>
  590. <option value='9' $selected[9]>9</option>
  591. <option value='10' $selected[10]>10</option>
  592. <option value='11' $selected[11]>11</option>
  593. <option value='12' $selected[12]>12 - 1/2 day</option>
  594. <option value='13' $selected[13]>13</option>
  595. <option value='14' $selected[14]>14</option>
  596. <option value='15' $selected[15]>15</option>
  597. <option value='16' $selected[16]>16</option>
  598. <option value='17' $selected[17]>17</option>
  599. <option value='18' $selected[18]>18</option>
  600. <option value='19' $selected[19]>19</option>
  601. <option value='20' $selected[20]>20</option>
  602. <option value='21' $selected[21]>21</option>
  603. <option value='22' $selected[22]>22</option>
  604. <option value='23' $selected[23]>23</option>
  605. <option value='24' $selected[24]>24 - 1 day</option>
  606. <option value='25' $selected[25]>25</option>
  607. <option value='26' $selected[26]>26</option>
  608. <option value='27' $selected[27]>27</option>
  609. <option value='28' $selected[28]>28</option>
  610. <option value='29' $selected[29]>29</option>
  611. <option value='30' $selected[30]>30</option>
  612. <option value='31' $selected[31]>31</option>
  613. <option value='32' $selected[32]>32</option>
  614. <option value='33' $selected[33]>33</option>
  615. <option value='34' $selected[34]>34</option>
  616. <option value='35' $selected[35]>35</option>
  617. <option value='36' $selected[36]>36 - 1 1/2 day</option>
  618. <option value='37' $selected[37]>37</option>
  619. <option value='38' $selected[38]>38</option>
  620. <option value='39' $selected[39]>39</option>
  621. <option value='40' $selected[40]>40</option>
  622. <option value='41' $selected[41]>41</option>
  623. <option value='42' $selected[42]>42</option>
  624. <option value='43' $selected[43]>43</option>
  625. <option value='44' $selected[44]>44</option>
  626. <option value='45' $selected[45]>45</option>
  627. <option value='46' $selected[46]>46</option>
  628. <option value='47' $selected[47]>47</option>
  629. <option value='48' $selected[48]>48 - 2 days</option>
  630. <option value='60' $selected[60]>60 - 2 1/2 days</option>
  631. <option value='72' $selected[72]>72 - 3 days</option>
  632. <option value='84' $selected[84]>84 - 3 1/2 days</option>
  633. <option value='96' $selected[96]>96 - 4 days</option>
  634. <option value='108' $selected[108]>108 - 4 1/2 days</option>
  635. <option value='120' $selected[120]>120 - 5 days</option>
  636. <option value='144' $selected[144]>144 - 6 days</option>
  637. <option value='168' $selected[168]>168 - 7 days</option>
  638. <option value='500000' $selected[500000]>Anytime- Not Recommended</option>
  639. </select></td>
  640. </tr>
  641. ";
  642. $selected="";
  643. $value="";
  644. $value=$ladderinfo[playdays];
  645. $selected[$value]="SELECTED";
  646. $out[body]=$out[body]."
  647. <tr class='altcolorb'>
  648. <td width='50%' valign='center' align='left'>
  649. Maximum Days to play match</td>
  650. <td width='50%' valign='center' align='left'>
  651. <select name='ld_chalplydays'>
  652. <option value='1' $selected[1]>1 day</option>
  653. <option value='2' $selected[2]>2 days</option>
  654. <option value='3' $selected[3]>3 days</option>
  655. <option value='4' $selected[4]>4 days</option>
  656. <option value='5' $selected[5]>5 days</option>
  657. <option value='6' $selected[6]>6 days</option>
  658. <option value='7' $selected[7]>7 days</option>
  659. <option value='8' $selected[8]>8 days</option>
  660. <option value='9' $selected[9]>9 days</option>
  661. <option value='10' $selected[10]>10 days</option>
  662. <option value='11' $selected[11]>11 days</option>
  663. <option value='12' $selected[12]>12 days</option>
  664. <option value='13' $selected[13]>13 days</option>
  665. <option value='14' $selected[14]>14 days</option>
  666. <option value='15' $selected[15]>15 days</option>
  667. <option value='16' $selected[16]>16 days</option>
  668. <option value='17' $selected[17]>17 days</option>
  669. <option value='18' $selected[18]>18 days</option>
  670. <option value='19' $selected[19]>19 days</option>
  671. <option value='20' $selected[20]>20 days</option>
  672. </select></td>
  673. </tr>
  674. ";
  675. $selected="";
  676. $value="";
  677. $value=$ladderinfo[timescangive];
  678. $selected[$value]="SELECTED";
  679. $out[body]=$out[body]."
  680. <tr class='altcolora'>
  681. <td width='50%' valign='center' align='left'>
  682. Amount of date/times challenged suggests</td>
  683. <td width='50%' valign='center' align='left'>
  684. <select name='ld_chaltimea'>
  685. <option value='1' $selected[1]>1</option>
  686. <option value='2' $selected[2]>2</option>
  687. <option value='3' $selected[3]>3</option>
  688. <option value='4' $selected[4]>4</option>
  689. <option value='5' $selected[5]>5</option>
  690. <option value='6' $selected[6]>6</option>
  691. <option value='7' $selected[7]>7</option>
  692. <option value='8' $selected[8]>8</option>
  693. <option value='9' $selected[9]>9</option>
  694. <option value='10' $selected[10]>10</option>
  695. </select></td>
  696. </tr>
  697. ";
  698. $selected="";
  699. $value="";
  700. $value=$ladderinfo[starthour];
  701. $selected[$value]="SELECTED";
  702. $out[body]=$out[body]."
  703. <tr class='altcolorb'>
  704. <td width='50%' valign='center' align='left'>
  705. Earliest Match Start Time</td>
  706. <td width='50%' valign='center' align='left'>
  707. <select name='ld_chalmstart'>
  708. <option value='1' $selected[1]>1am</option>
  709. <option value='2' $selected[2]>2am</option>
  710. <option value='3' $selected[3]>3am</option>
  711. <option value='4' $selected[4]>4am</option>
  712. <option value='5' $selected[5]>5am</option>
  713. <option value='6' $selected[6]>6am</option>
  714. <option value='7' $selected[7]>7am</option>
  715. <option value='8' $selected[8]>8am</option>
  716. <option value='9' $selected[9]>9am</option>
  717. <option value='10' $selected[10]>10am</option>
  718. <option value='11' $selected[11]>11am</option>
  719. <option value='12' $selected[12]>Midday</option>
  720. <option value='13' $selected[13]>1pm</option>
  721. <option value='14' $selected[14]>2pm</option>
  722. <option value='15' $selected[15]>3pm</option>
  723. <option value='16' $selected[16]>4pm</option>
  724. <option value='17' $selected[17]>5pm</option>
  725. <option value='18' $selected[18]>6pm</option>
  726. <option value='19' $selected[19]>7pm</option>
  727. <option value='20' $selected[20]>8pm</option>
  728. <option value='21' $selected[21]>9pm</option>
  729. <option value='22' $selected[22]>10pm</option>
  730. <option value='23' $selected[23]>11pm</option>
  731. <option value='24' $selected[24]>Midnight</option>
  732. </select></td>
  733. </tr>
  734. ";
  735. $selected="";
  736. $value="";
  737. $value=$ladderinfo[endhour];
  738. $selected[$value]="SELECTED";
  739. $out[body]=$out[body]."
  740. <tr class='altcolora'>
  741. <td width='50%' valign='center' align='left'>
  742. Latest Match Start Time</td>
  743. <td width='50%' valign='center' align='left'>
  744. <select name='ld_chalmend'>
  745. <option value='1' $selected[1]>1am</option>
  746. <option value='2' $selected[2]>2am</option>
  747. <option value='3' $selected[3]>3am</option>
  748. <option value='4' $selected[4]>4am</option>
  749. <option value='5' $selected[5]>5am</option>
  750. <option value='6' $selected[6]>6am</option>
  751. <option value='7' $selected[7]>7am</option>
  752. <option value='8' $selected[8]>8am</option>
  753. <option value='9' $selected[9]>9am</option>
  754. <option value='10' $selected[10]>10am</option>
  755. <option value='11' $selected[11]>11am</option>
  756. <option value='12' $selected[12]>Midday</option>
  757. <option value='13' $selected[13]>1pm</option>
  758. <option value='14' $selected[14]>2pm</option>
  759. <option value='15' $selected[15]>3pm</option>
  760. <option value='16' $selected[16]>4pm</option>
  761. <option value='17' $selected[17]>5pm</option>
  762. <option value='18' $selected[18]>6pm</option>
  763. <option value='19' $selected[19]>7pm</option>
  764. <option value='20' $selected[20]>8pm</option>
  765. <option value='21' $selected[21]>9pm</option>
  766. <option value='22' $selected[22]>10pm</option>
  767. <option value='23' $selected[23]>11pm</option>
  768. <option value='24' $selected[24]>Midnight</option>
  769. </select></td>
  770. </tr>
  771. <tr class='altcolorb'>
  772. <td width='50%' valign='center' align='left'>
  773. Displayed Timezone</td>
  774. <td width='50%' valign='center' align='left'>
  775. <input type='text' name='ld_chalmtzone' value='$ladderinfo[timezone]' size='30' maxlength='25'></td>
  776. </tr>
  777. ";
  778. $selected="";
  779. $value="";
  780. $value=$ladderinfo[mapscangive];
  781. $selected[$value]="SELECTED";
  782. $out[body]=$out[body]."
  783. <tr class='altcolora'>
  784. <td width='50%' valign='center' align='left'>
  785. Amount of maps challenged suggests [If maps enabled above]</td>
  786. <td width='50%' valign='center' align='left'>
  787. <select name='ld_chalmapsa'>
  788. <option value='1' $selected[1]>1</option>
  789. <option value='2' $selected[2]>2</option>
  790. <option value='3' $selected[3]>3</option>
  791. <option value='4' $selected[4]>4</option>
  792. <option value='5' $selected[5]>5</option>
  793. <option value='6' $selected[6]>6</option>
  794. <option value='7' $selected[7]>7</option>
  795. <option value='8' $selected[8]>8</option>
  796. <option value='9' $selected[9]>9</option>
  797. <option value='10' $selected[10]>10</option>
  798. </select></td>
  799. </tr>
  800. ";
  801. $selected="";
  802. $value="";
  803. $value=$ladderinfo[finalizehours];
  804. $selected[$value]="SELECTED";
  805. $out[body]=$out[body]."
  806. <tr class='altcolorb'>
  807. <td width='50%' valign='center' align='left'>
  808. Hours to finalize before forfeit awarded<br></td>
  809. <td width='50%' valign='center' align='left'>
  810. <select name='ld_chalfinal'>
  811. <option value='1' $selected[1]>1 Hour</option>
  812. <option value='2' $selected[2]>2</option>
  813. <option value='3' $selected[3]>3</option>
  814. <option value='4' $selected[4]>4</option>
  815. <option value='5' $selected[5]>5</option>
  816. <option value='6' $selected[6]>6</option>
  817. <option value='7' $selected[7]>7</option>
  818. <option value='8' $selected[8]>8</option>
  819. <option value='9' $selected[9]>9</option>
  820. <option value='10' $selected[10]>10</option>
  821. <option value='11' $selected[11]>11</option>
  822. <option value='12' $selected[12]>12 - 1/2 day</option>
  823. <option value='13' $selected[13]>13</option>
  824. <option value='14' $selected[14]>14</option>
  825. <option value='15' $selected[15]>15</option>
  826. <option value='16' $selected[16]>16</option>
  827. <option value='17' $selected[17]>17</option>
  828. <option value='18' $selected[18]>18</option>
  829. <option value='19' $selected[19]>19</option>
  830. <option value='20' $selected[20]>20</option>
  831. <option value='21' $selected[21]>21</option>
  832. <option value='22' $selected[22]>22</option>
  833. <option value='23' $selected[23]>23</option>
  834. <option value='24' $selected[24]>24 - 1 day</option>
  835. <option value='25' $selected[25]>25</option>
  836. <option value='26' $selected[26]>26</option>
  837. <option value='27' $selected[27]>27</option>
  838. <option value='28' $selected[28]>28</option>
  839. <option value='29' $selected[29]>29</option>
  840. <option value='30' $selected[30]>30</option>
  841. <option value='31' $selected[31]>31</option>
  842. <option value='32' $selected[32]>32</option>
  843. <option value='33' $selected[33]>33</option>
  844. <option value='34' $selected[34]>34</option>
  845. <option value='35' $selected[35]>35</option>
  846. <option value='36' $selected[36]>36 - 1 1/2 day</option>
  847. <option value='37' $selected[37]>37</option>
  848. <option value='38' $selected[38]>38</option>
  849. <option value='39' $selected[39]>39</option>
  850. <option value='40' $selected[40]>40</option>
  851. <option value='41' $selected[41]>41</option>
  852. <option value='42' $selected[42]>42</option>
  853. <option value='43' $selected[43]>43</option>
  854. <option value='44' $selected[44]>44</option>
  855. <option value='45' $selected[45]>45</option>
  856. <option value='46' $selected[46]>46</option>
  857. <option value='47' $selected[47]>47</option>
  858. <option value='48' $selected[48]>48 - 2 days</option>
  859. <option value='60' $selected[60]>60 - 2 1/2 days</option>
  860. <option value='72' $selected[72]>72 - 3 days</option>
  861. <option value='84' $selected[84]>84 - 3 1/2 days</option>
  862. <option value='96' $selected[96]>96 - 4 days</option>
  863. <option value='108' $selected[108]>108 - 4 1/2 days</option>
  864. <option value='120' $selected[120]>120 - 5 days</option>
  865. <option value='144' $selected[144]>144 - 6 days</option>
  866. <option value='168' $selected[168]>168 - 7 days</option>
  867. <option value='500000' $selected[500000]>Anytime- Not Recommended</option>
  868. </select></td>
  869. </tr>
  870. ";
  871. $selected="";
  872. $value="";
  873. $value=$ladderinfo[mapscanaccept];
  874. $selected[$value]="SELECTED";
  875. $out[body]=$out[body]."
  876. <tr class='altcolora'>
  877. <td width='50%' valign='center' align='left'>
  878. Amount of maps challenger chooses [If maps enabled above]</td>
  879. <td width='50%' valign='center' align='left'>
  880. <select name='ld_chalmapsb'>
  881. <option value='1' $selected[1]>1</option>
  882. <option value='2' $selected[2]>2</option>
  883. <option value='3' $selected[3]>3</option>
  884. <option value='4' $selected[4]>4</option>
  885. <option value='5' $selected[5]>5</option>
  886. <option value='6' $selected[6]>6</option>
  887. <option value='7' $selected[7]>7</option>
  888. <option value='8' $selected[8]>8</option>
  889. <option value='9' $selected[9]>9</option>
  890. <option value='10' $selected[10]>10</option>
  891. </select></td>
  892. </tr>
  893. </table>
  894. </td>
  895. </tr>
  896. <tr>
  897. <td width='100%' valign='top' align='left'>
  898. <table width='100%' border='0' cellspacing='0' cellpadding='0' valign='top' align='center'>
  899. </table>
  900. </td>
  901. </tr>
  902. <tr class='altcolor'>
  903. <td width='100%' valign='top' align='center'>
  904. <input type='hidden' name='action' value='editladdersc'>
  905. <input type='submit' name='' value='Create the Ladder'></td>
  906. </form>
  907. </tr>
  908. </table>";
  909. include("$dir[curtheme]");
  910. }
  911. function admin_editladdersc($ld_gameid,$ld_name,$ld_abrv,$ld_desc,$ld_type,$ld_openreport,$ld_plyrmin,$ld_plyrmax,$ld_minmaps,$ld_maxmaps,$ld_inactvdaysa,$ld_inactvdrop,$ld_inactvdaysb,$ld_chal,$ld_chalranks,$ld_chalrespnd,$ld_chalplydays,$ld_chaltimea,$ld_chalmstart,$ld_chalmend,$ld_chalmtzone,$ld_chalmapsa,$ld_chalfinal,$ld_chalmapsb,$ld_skill){
  912. global $dir, $url, $out, $site, $admn;
  913. include("$dir[func]/checkdata.php");
  914. $ld_gameid=change_numbersonly($ld_gameid);
  915. if (mysql_num_rows(mysql_query("select gamename from games where id='$ld_gameid'")) < 1){
  916. $errormessage=$errormessage."That game is invalid.<br>";
  917. error_check($errormessage);
  918. }
  919. if ((($ld_plyrmin > 1)||($ld_plyrmax > 1))&&($ld_type < 2)){
  920. $errormessage=$errormessage."Minimum and Maximum players must be set to one for 1v1 ladders.<br>";
  921. error_check($errormessage);
  922. }
  923. if ($ld_plyrmin > $ld_plyrmax){
  924. $errormessage=$errormessage."Maximum players must be equal to or greater than minimum players.<br>";
  925. error_check($errormessage);
  926. }
  927. if (($ld_minmaps < 1)&&($ld_maxmaps > 0)){
  928. $errormessage=$errormessage."Maps must be set to 'No Maps' for both fields.<br>";
  929. error_check($errormessage);
  930. }
  931. if ($ld_minmaps > $ld_maxmaps){
  932. $errormessage=$errormessage."Maximum maps must be equal to or greater than minimum maps.<br>";
  933. error_check($errormessage);
  934. }
  935. if (($ld_openreport < 1)&&($ld_chal < 1)){
  936. $errormessage=$errormessage."Challenges must be set to YES on 'Challenge Only' ladders..<br>";
  937. error_check($errormessage);
  938. }
  939. if (($ld_openreport > 0)&&($ld_openreport < 2)){
  940. if($ld_chal < 1) {
  941. $errormessage=$errormessage."Challenges must be set to yes on 'Challenges and Open Play' ladders.<br>";
  942. error_check($errormessage);
  943. }
  944. }
  945. if ($ld_openreport >1){
  946. if($ld_chal > 0) {
  947. $errormessage=$errormessage."Challenges must be set to NO on 'Open Play Only' ladders.<br>";
  948. error_check($errormessage);
  949. }else{
  950. $ld_openreport = 1;
  951. }
  952. }
  953. if (($ld_chalmend <= $ld_chalmstart)&&($ld_chal)){
  954. $errormessage=$errormessage."The latest match start time must come after <br>the earliest match start time in the list.<br><br>For 24 hour challenging, set start time to 1am and end time to Midnight.<br>";
  955. error_check($errormessage);
  956. }
  957. if (($ld_chalmapsa < $ld_chalmapsb)&&($ld_chal)&&($ld_maxmaps >0)){
  958. $errormessage=$errormessage."Number of maps suggested must exceed or equal number of maps to be chosen by challenger when finalizing.<br>";
  959. error_check($errormessage);
  960. }
  961. $ld_name=change_charecters($ld_name);
  962. $ld_abrv=change_charecters($ld_abrv);
  963. $ld_desc=change_charecters($ld_desc);
  964. $ld_type=change_numbersonly($ld_type);
  965. $ld_openreport=change_numbersonly($ld_openreport);
  966. $ld_plyrmin=change_numbersonly($ld_plyrmin);
  967. $ld_plyrmax=change_numbersonly($ld_plyrmax);
  968. $ld_minmaps=change_numbersonly($ld_minmaps);
  969. $ld_maxmaps=change_numbersonly($ld_maxmaps);
  970. $ld_inactvdaysa=change_numbersonly($ld_inactvdaysa);
  971. $ld_inactvdrop=change_numbersonly($ld_inactvdrop);
  972. $ld_inactvdaysb=change_numbersonly($ld_inactvdaysb);
  973. $ld_chal=change_numbersonly($ld_chal);
  974. $ld_chalranks=change_numbersonly($ld_chalranks);
  975. $ld_chalrespnd=change_numbersonly($ld_chalrespnd);
  976. $ld_chalplydays=change_numbersonly($ld_chalplydays);
  977. $ld_chaltimea=change_numbersonly($ld_chaltimea);
  978. $ld_chalmstart=change_numbersonly($ld_chalmstart);
  979. $ld_chalmend=change_numbersonly($ld_chalmend);
  980. $ld_chalmtzone=change_charecters($ld_chalmtzone);
  981. $ld_chalmapsa=change_numbersonly($ld_chalmapsa);
  982. $ld_chalfinal=change_numbersonly($ld_chalfinal);
  983. $ld_chalmapsb=change_numbersonly($ld_chalmapsb);
  984. $ld_skill=change_numbersonly($ld_skill);
  985. $errormessage=check_validlength($errormessage, $ld_name, "2", "50", "Your Ladders Name Must be 2-25 Characters Long.");
  986. $errormessage=check_validlength($errormessage, $ld_abrv, "2", "25", "Your Ladders Abbreviation Must be 2-10 Characters Long.");
  987. $errormessage=check_validlength($errormessage, $ld_desc, "0", "250", "Your Ladders Description Must not Exceed 200 Characters.");
  988. $errormessage=check_validlength($errormessage, $ld_type, "1", "2", "Your Ladder Type is Invalid.");
  989. error_check($errormessage);
  990. //CHECK IF LADDER/ABBREVIATION EXIST HERE
  991. $errormessage=check_ladderexist($errormessage, $ld_name, $ld_abrv);
  992. error_check($errormessage);
  993. $tday=date("Y-m-d H:i:s");
  994. mysql_query("INSERT INTO ladders VALUES (NULL,
  995. '$ld_gameid',
  996. '$ld_name',
  997. '$ld_abrv',
  998. '$ld_type',
  999. '$ld_desc',
  1000. '$ld_openreport',
  1001. '$ld_plyrmin',
  1002. '$ld_plyrmax',
  1003. '$ld_minmaps',
  1004. '$ld_maxmaps',
  1005. '$ld_inactvdaysa',
  1006. '$ld_inactvdrop',
  1007. '$ld_inactvdaysb',
  1008. '$ld_chal',
  1009. '$ld_chalranks',
  1010. '$ld_chalrespnd',
  1011. '$ld_chalplydays',
  1012. '$ld_chaltimea',
  1013. '$ld_chalmstart',
  1014. '$ld_chalmend',
  1015. '$ld_chalmtzone',
  1016. '$ld_chalmapsa',
  1017. '$ld_chalfinal',
  1018. '$ld_chalmapsb',
  1019. '$ld_skill',
  1020. '$admn[id]',
  1021. '$tday',
  1022. '0',
  1023. '0');");
  1024. $getid=mysql_query("SELECT id FROM ladders WHERE laddername='$ld_name'");
  1025. $ldid=mysql_fetch_array($getid);
  1026. if($ldid[id]){
  1027. //DROP LADDER IF EXISTS
  1028. mysql_query("DROP TABLE IF EXISTS ladder_$ldid[id]");
  1029. //CREATE LADDER TABLE
  1030. mysql_query("CREATE TABLE ladder_$ldid[id] (
  1031. id int(10) DEFAULT '0' NOT NULL,
  1032. joindate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  1033. lastmatch datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  1034. lastplayed int(10) DEFAULT '0' NOT NULL,
  1035. status int(10) DEFAULT '0' NOT NULL,
  1036. statusdate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
  1037. statusdisplay varchar(250) NOT NULL,
  1038. rank int(10) DEFAULT '0' NOT NULL,
  1039. lastrank int(10) DEFAULT '0' NOT NULL,
  1040. bestrank int(10) DEFAULT '0' NOT NULL,
  1041. worstrank int(10) DEFAULT '0' NOT NULL,
  1042. wins int(10) DEFAULT '0' NOT NULL,
  1043. losses int(10) DEFAULT '0' NOT NULL,
  1044. games int(10) DEFAULT '0' NOT NULL,
  1045. percent int(10) DEFAULT '0' NOT NULL,
  1046. streak int(10) DEFAULT '0' NOT NULL,
  1047. beststreak int(10) DEFAULT '0' NOT NULL,
  1048. worststreak int(10) DEFAULT '0' NOT NULL,
  1049. points int(10) DEFAULT '0' NOT NULL,
  1050. skill int(10) DEFAULT '0' NOT NULL,
  1051. money int(10) DEFAULT '0' NOT NULL,
  1052. forfeits int(10) DEFAULT '0' NOT NULL,
  1053. icon tinyint(2) DEFAULT '0' NOT NULL,
  1054. PRIMARY KEY (id)
  1055. )");
  1056. }
  1057. include("$dir[func]/admin_finishmessage.php");
  1058. display_message("The ladder has been added.<br>");
  1059. }
  1060. function edit_ladder($ladderid){
  1061. global $dir, $url, $out, $admn, $site;
  1062. $thisladder=mysql_query("SELECT * FROM ladders WHERE id='$ladderid'");
  1063. $ladderinfo=mysql_fetch_array($thisladder);
  1064. if((!$ladderid) || (!$ladderinfo[id])){
  1065. include("$dir[func]/error.php");
  1066. display_error("Invalid Ladder ID");
  1067. }
  1068. $curgames=mysql_query("SELECT id,gamename FROM games ORDER by gamename");
  1069. while(list($id, $name)=mysql_fetch_row($curgames)){
  1070. if($ladderinfo[gameon]=="$id"){
  1071. $thegames=$thegames."<option value='$id' SELECTED>$name</option>";
  1072. }else{
  1073. $thegames=$thegames."<option value='$id'>$name</option>";
  1074. }
  1075. }
  1076. //TABLE ATERNATING COLORS
  1077. $altcolora="#000033";
  1078. $altcolorb="#000020";
  1079. $tablehead=table_head("show","100%","","center");
  1080. $tablefoot=table_foot("show");
  1081. $bannerhead=table_head("show","488","80","center");
  1082. $bannerfoot=table_foot("show");
  1083. $out[body]=$out[body]."
  1084. <center>
  1085. $bannerhead
  1086. $out[banner]
  1087. $bannerfoot
  1088. </center>
  1089. <br>
  1090. <table width='100%' border='1' bordercolor='#000000' cellspacing='4' cellpadding='2'>
  1091. <tr class='altcolor'>
  1092. <td width='100%' valign='top' align='center'>
  1093. <strong>Edit Ladder</strong></td>
  1094. </tr>
  1095. <tr>
  1096. <td width='100%' valign='top' align='left'>
  1097. <form method='post'>
  1098. <table width='100%' border='0' cellspacing='1' cellpadding='1' valign='top' align='center'>
  1099. <tr class='altcolora'>
  1100. <td width='50%' valign='center' align='left'>
  1101. Ladders Game Category</td>
  1102. <td width='50%' valign='center' align='left'>
  1103. <select name='ld_gameid'>
  1104. $thegames
  1105. </select></td>
  1106. </tr>
  1107. <tr class='altcolorb'>
  1108. <td width='50%' valign='center' align='left'>
  1109. Ladders Full Name [e.g. Rainbow Six 3 Teams]</td>
  1110. <td width='50%' valign='center' align='left'>
  1111. <input type='text' name='ld_name' value='$ladderinfo[laddername]' size='30' maxlength='30'></td>
  1112. </tr>
  1113. <tr class='altcolora'>
  1114. <td width='50%' valign='center' align='left'>
  1115. Ladder Abbreviation [e.g RST]</td>
  1116. <td width='50%' valign='center' align='left'>
  1117. <input type='text' name='ld_abrv' value='$ladderinfo[abbreviation]' size='30' maxlength='10'></td>
  1118. </tr>
  1119. <tr class='altcolorb'>
  1120. <td width='50%' valign='top' align='left'>
  1121. Ladder Description<br>200 Characters max</td>
  1122. <td width='50%' valign='center' align='left'><textarea name='ld_desc' rows='3' cols='25' maxlength='200'>
  1123. $ladderinfo[description]</textarea></td>
  1124. </tr>
  1125. ";
  1126. $selected="";
  1127. $value="";
  1128. $value=$ladderinfo[openplay];
  1129. $selected[$value]="SELECTED";
  1130. $out[body]=$out[body]."
  1131. <tr class='altcolora'>
  1132. <td width='50%' valign='center' align='left'>
  1133. Ladder Play</td>
  1134. <td width='50%' valign='center' align='left'>
  1135. <select name='ld_openreport'>
  1136. <option value='1' $selected[1]>1: Challenges and Open Play - Teams/Players Unranked On Signup</option>
  1137. <option value='0' $selected[0]>2: Challenges Only - Teams/Players Ranked On Signup</option>
  1138. <option value='2' $selected[2]>3: Open Play Only - Teams/Players Unranked On Signup</option>
  1139. </select></td>
  1140. </tr>
  1141. ";
  1142. $selected="";
  1143. $value="";
  1144. $value=$ladderinfo[minmembers];
  1145. $selected[$value]="SELECTED";
  1146. $out[body]=$out[body]."
  1147. <tr class='altcolorb'>
  1148. <td width='50%' valign='center' align='left'>
  1149. Min/Max Team Members [Set both to One for 1v1 ladders]</td>
  1150. <td width='50%' valign='center' align='left'>
  1151. <select name='ld_plyrmin'>
  1152. <option value='1' $selected[1]>Min 1</option>
  1153. <option value='2' $selected[2]>2</option>
  1154. <option value='3' $selected[3]>3</option>
  1155. <option value='4' $selected[4]>4</option>
  1156. <option value='5' $selected[5]>5</option>
  1157. <option value='6' $selected[6]>6</option>
  1158. <option value='7' $selected[7]>7</option>
  1159. <option value='8' $selected[8]>8</option>
  1160. <option value='9' $selected[9]>9</option>
  1161. <option value='10' $selected[10]>10</option>
  1162. <option value='11' $selected[11]>11</option>
  1163. <option value='12' $se

Large files files are truncated, but you can click here to view the full file