PageRenderTime 30ms CodeModel.GetById 1ms RepoModel.GetById 0ms app.codeStats 0ms

/functions/reportloss.php

https://bitbucket.org/verax/to-ladder
PHP | 677 lines | 607 code | 65 blank | 5 comment | 47 complexity | 95eec25877d766e55891d0d66a5b9795 MD5 | raw file
  1. <?PHP
  2. function report_loss_init($ladderid){
  3. global $dir, $file, $url, $out, $plyr, $site;
  4. if($ladderid){
  5. $teamslist=mysql_query("SELECT id FROM ladder_$ladderid");
  6. while($row = mysql_fetch_array($teamslist)){
  7. $tlist = mysql_query("SELECT id,teamname FROM teams WHERE id = '$row[id]'");
  8. if(list($teamid,$name)=mysql_fetch_row($tlist)){
  9. $selectedteam="";
  10. if($id=="$teamid"){
  11. $selectedteam="SELECTED";
  12. }
  13. $theteams.="<option value='$teamid' $selectedteam>$name</option>";
  14. }
  15. }
  16. $forminfo="
  17. Select Winner</small><br>
  18. <select name='winnerid'>$theteams</select>
  19. <br><small></small><br><br>
  20. <input type='hidden' name='ladderid' value='$ladderid'>
  21. <input type='hidden' name='action' value='report'>
  22. <button type='submit' name='' value='Report Loss' class='btn btn-mini btn-success'>Reportar derrota</button><br><br><br>";
  23. }else{
  24. $ladderslist=mysql_query("SELECT id,laddername FROM ladders ORDER by laddername");
  25. while(list($id,$name)=mysql_fetch_row($ladderslist)){
  26. $selectedladder="";
  27. if($ladderid=="$id"){
  28. $selectedladder="SELECTED";
  29. }
  30. $theladders.="<option value='$id' $selectedladder>$name</option>";
  31. }
  32. $forminfo="
  33. Seleccionar ladder</small><br>
  34. <select name='ladderid'>$theladders</select>
  35. <br><small></small><br><br>
  36. <input type='hidden' name='action' value='report_init'>
  37. <button type='submit' name='' value='Continue' class='btn btn-mini btn-info'>Continuar</button><br><br><br>";
  38. }
  39. $tablehead=table_head("show","300","","center");
  40. $tablefoot=table_foot("show");
  41. $bannerhead=table_head("show","488","80","center");
  42. $bannerfoot=table_foot("show");
  43. $out[body]=$out[body]."
  44. <center>
  45. $bannerhead
  46. $out[banner]
  47. $bannerfoot
  48. <br>
  49. <center>
  50. $tablehead
  51. <table width='300' border='0' bordercolor='#000000' cellspacing='0' cellpadding='2'>
  52. <tr>
  53. <td width='100%' height='100%' valign='top' align='center'>
  54. <strong>Reportar una derrota</strong>
  55. <form method='post'>
  56. $loserforminfo
  57. $forminfo
  58. </form>
  59. </td>
  60. </tr>
  61. </table>
  62. $tablefoot
  63. </center>";
  64. include("$dir[curtheme]");
  65. }
  66. function report_loss($teamid,$winnerid,$challid,$ladderid){
  67. global $dir, $file, $url, $out, $plyr, $site;
  68. if($teamid){
  69. if($teamid=="$winnerid"){
  70. include("$dir[func]/error.php");
  71. display_error("You cannot report losses to yourself.<br>");
  72. }
  73. }
  74. if($teamid == '0'){
  75. include("$dir[func]/error.php");
  76. display_error("You are not on this ladder.<br>");
  77. }
  78. if($challid){
  79. $thechallenge=mysql_query("SELECT challenger,challenged,ladderid FROM challenges WHERE challid='$challid'");
  80. $chall=mysql_fetch_array($thechallenge);
  81. if(!$chall[ladderid]){
  82. include("$dir[func]/error.php");
  83. display_error("Unknown Challenge ID.<br>");
  84. }
  85. $ladderid = $chall[ladderid];
  86. $teams=mysql_query("SELECT teamid FROM teammembers WHERE playerid='$plyr[id]'");
  87. while($row = mysql_fetch_array($teams)){
  88. $team = mysql_query("SELECT id FROM ladder_$chall[ladderid] WHERE id ='$row[teamid]'");
  89. $tid = mysql_fetch_array($team);
  90. if($tid[id]){
  91. $rptinfo[teamid] = $tid[id];
  92. }
  93. }
  94. $teamid="$rptinfo[teamid]";
  95. if($rptinfo[teamid]=="$chall[challenger]"){
  96. $winnerid="$chall[challenged]";
  97. }else{
  98. $winnerid="$chall[challenger]";
  99. }
  100. }
  101. if($teamid){
  102. $losingteaminfo=mysql_query("SELECT teamname FROM teams WHERE id='$teamid'");
  103. $ltinfo=mysql_fetch_array($losingteaminfo);
  104. if(!$ltinfo[teamname]){
  105. include("$dir[func]/error.php");
  106. display_error("Unknown Losing Team.<br>");
  107. }
  108. $loserforminfo="<b>Losing Team:</b><br> $ltinfo[teamname]<br><input type='hidden' name='teamid' value='$teamid'>";
  109. $teamladder="$ladderid";
  110. }else{
  111. $teamson=mysql_query("SELECT teamid FROM teammembers WHERE playerid='$plyr[id]' AND status <='4' ORDER by joindate");
  112. while(list($team)=mysql_fetch_row($teamson)){
  113. $teaminfo=mysql_query("SELECT teamname FROM teams WHERE id='$team'");
  114. $tinfo=mysql_fetch_array($teaminfo);
  115. $currentmatch=mysql_query("SELECT challid,challenger,challenged FROM challenges WHERE challenger='$team' AND finalizedby > '0' OR challenged='$team' AND finalizedby > '0'");
  116. $cminfo=mysql_fetch_array($currentmatch);
  117. if($cminfo[challid]){
  118. if($team=="$cminfo[challenger]"){
  119. $vsid="$cminfo[challenged]";
  120. }else{
  121. $vsid="$cminfo[challenger]";
  122. }
  123. $challengingteam=mysql_query("SELECT teamname FROM teams WHERE id='$vsid'");
  124. $cmtinfo=mysql_fetch_array($challengingteam);
  125. $scheduledmatches=$scheduledmatches."";
  126. }
  127. $onteam=1;
  128. }
  129. if($onteam){
  130. $loserforminfo="";
  131. }else{
  132. include("$dir[func]/error.php");
  133. display_error("You are not on any teams. <br>You need to join a ladder before you can report losses.<br>");
  134. }
  135. }
  136. if($winnerid){
  137. if($challid){
  138. $wteam[teamid]="$winnerid";
  139. }else{
  140. if (mysql_num_rows(mysql_query("SELECT id FROM teams WHERE id='$winnerid'")) < 1){
  141. include("$dir[func]/error.php");
  142. display_error("Unknown Team ID.<br>");
  143. }
  144. $winnersteam=mysql_query("SELECT id FROM teams WHERE id='$winnerid'");
  145. $wteam=mysql_fetch_array($winnersteam);
  146. }
  147. $winnersteaminfo=mysql_query("SELECT teamname FROM teams WHERE id='$winnerid'");
  148. $wteaminfo=mysql_fetch_array($winnersteaminfo);
  149. if(!$wteaminfo[teamname]){
  150. include("$dir[func]/error.php");
  151. display_error("Unknown Winning Team.<br>");
  152. }
  153. $ldinfo=mysql_query("SELECT laddername FROM ladders WHERE id='$ladderid'");
  154. $lddinfo=mysql_fetch_array($ldinfo);
  155. $forminfo="
  156. <br>
  157. <b>Winning Team:</b><br>
  158. $wteaminfo[teamname]<br><br>
  159. <b>Ladder:</b><br>
  160. $lddinfo[laddername]
  161. <input type='hidden' name='winnerid' value='$winnerid'>
  162. <input type='hidden' name='ladderid' value='$ladderid'>
  163. <br><br><br>
  164. <input type='hidden' name='action' value='reportb'>
  165. <button type='submit' name='' value='Report Loss' class='btn-mini btn-success''>Reportar derrota</button>";
  166. }else{
  167. include("$dir[func]/error.php");
  168. display_error("No se especific&oacute; el equipo ganador.<br>");
  169. }
  170. $tablehead=table_head("show","300","","center");
  171. $tablefoot=table_foot("show");
  172. $bannerhead=table_head("show","488","80","center");
  173. $bannerfoot=table_foot("show");
  174. $out[body]=$out[body]."
  175. <center>
  176. $bannerhead
  177. $out[banner]
  178. $bannerfoot
  179. <br>
  180. <center>
  181. $tablehead
  182. <table width='300' border='0' bordercolor='#000000' cellspacing='0' cellpadding='2'>
  183. <tr>
  184. <td width='100%' height='100%' valign='top' align='center'>
  185. <strong>Reportar una derrota</strong>
  186. <form method='post'>
  187. $loserforminfo
  188. $forminfo
  189. </form>
  190. </td>
  191. </tr>
  192. </table>
  193. $tablefoot
  194. </center>";
  195. include("$dir[curtheme]");
  196. }
  197. function report_lossb($teamid,$winnerid,$ladderid){
  198. global $dir, $file, $url, $out, $plyr;
  199. if (mysql_num_rows(mysql_query("SELECT status FROM teammembers WHERE teamid='$teamid' AND playerid='$plyr[id]' AND status <='4'")) < 1){
  200. include("$dir[func]/error.php");
  201. display_error("You are not allowed to report losses for this team.<br>");
  202. }
  203. $loserinfo=mysql_query("SELECT teamname FROM teams WHERE id='$teamid'");
  204. $ltinfo=mysql_fetch_array($loserinfo);
  205. if(!$ltinfo[teamname]){
  206. include("$dir[func]/error.php");
  207. display_error("Unable to find your team.<br>");
  208. }
  209. $winnerinfo=mysql_query("SELECT teamname FROM teams WHERE id='$winnerid'");
  210. $wtinfo=mysql_fetch_array($winnerinfo);
  211. if(!$wtinfo[teamname]){
  212. include("$dir[func]/error.php");
  213. display_error("Unable to find winning team. $winnerid<br>");
  214. }
  215. //LADDER INFORMATION
  216. $ladderinfo=mysql_query("SELECT type,minmembers,openplay FROM ladders WHERE id='$ladderid'");
  217. $linfo=mysql_fetch_array($ladderinfo);
  218. if(!$linfo[type]){
  219. include("$dir[func]/error.php");
  220. display_error("Unknown ladder.<br>");
  221. }
  222. if (mysql_num_rows(mysql_query("SELECT teamid FROM teammembers WHERE teamid='$teamid'")) < $linfo[minmembers]){
  223. include("$dir[func]/error.php");
  224. display_error("Your team must have at least $linfo[minmembers] members before you can play matches on this ladder.<br>");
  225. }
  226. if (mysql_num_rows(mysql_query("SELECT teamid FROM teammembers WHERE teamid='$winnerid'")) < $linfo[minmembers]){
  227. include("$dir[func]/error.php");
  228. display_error("The winning team must have at least $linfo[minmembers] members before you can play matches on this ladder.<br>");
  229. }
  230. if (mysql_num_rows(mysql_query("SELECT id FROM ladder_$ladderid WHERE id='$teamid'")) < 1){
  231. include("$dir[func]/error.php");
  232. display_error("Your team is missing from the ladder.<br>");
  233. }
  234. if (mysql_num_rows(mysql_query("SELECT id FROM ladder_$ladderid WHERE id='$winnerid'")) < 1){
  235. include("$dir[func]/error.php");
  236. display_error("Winning team is missing from the ladder.<br>");
  237. }
  238. $tday=date("Y-m-d H:i:s");
  239. //CHECK IF LOSING TEAM IS LOCKED
  240. if (mysql_num_rows(mysql_query("SELECT status FROM ladder_$ladderid WHERE id='$teamid' AND status='10' AND statusdate > '$tday'")) > 0){
  241. include("$dir[func]/error.php");
  242. display_error("Your team is locked and cannot report losses.<br>");
  243. }
  244. //CHECK IF WINNING TEAM IS LOCKED
  245. if (mysql_num_rows(mysql_query("SELECT status FROM ladder_$ladderid WHERE id='$winnerid' AND status='10' AND statusdate > '$tday'")) > 0){
  246. include("$dir[func]/error.php");
  247. display_error("The winning team is locked and cannot recieve wins.<br>");
  248. }
  249. get_matchinfo($teamid,$winnerid,$ladderid);
  250. }
  251. function get_matchinfo($loserid,$winnerid,$ladderid){
  252. global $dir, $file, $url, $out, $plyr, $site, $misc;
  253. $ladinfo=mysql_query("SELECT gameon,laddername,minmaps,maxmaps FROM ladders WHERE id='$ladderid'");
  254. $linfo=mysql_fetch_array($ladinfo);
  255. if(!$linfo[laddername]){
  256. include("$dir[func]/error.php");
  257. display_error("Unknown Ladder ID.<br>");
  258. }
  259. //CHECK FOR GAME STATUS
  260. if (mysql_num_rows(mysql_query("SELECT id FROM games WHERE status < '1' AND id='$linfo[gameon]'")) > 0){
  261. include("$dir[func]/error.php");
  262. display_error("This Ladder is temporarily closed.<br>");
  263. }
  264. $color='gray';
  265. $tablehead=table_head("show","100%","","center");
  266. $tablefoot=table_foot("show");
  267. $bannerhead=table_head("show","488","80","center");
  268. $bannerfoot=table_foot("show");
  269. $out[body]=$out[body]."
  270. <center>
  271. $bannerhead
  272. $out[banner]
  273. $bannerfoot
  274. <br>
  275. $tablehead
  276. <table width='60%' border='0' bordercolor='#000000' cellspacing='0' cellpadding='2'>
  277. <tr class='altcolorc'>
  278. <td width='100%' height='100%' valign='top' align='center' colspan='2'>
  279. <strong>Reporting Loss on $linfo[laddername]</strong><br>
  280. </td>
  281. <form method='post'>
  282. </tr>";
  283. $altcolora="#000033";
  284. $altcolorb="#000020";
  285. $losersmembers=mysql_query("SELECT playerid,status FROM teammembers WHERE teamid='$loserid' ORDER by status");
  286. while(list($playerid,$status)=mysql_fetch_row($losersmembers)){
  287. $memberinfo=mysql_query("SELECT alias FROM users WHERE id='$playerid'");
  288. $minfo=mysql_fetch_array($memberinfo);
  289. if($altladrow=="$altcolora"){
  290. $altladrow="$altcolorb";
  291. }else{
  292. $altladrow="$altcolora";
  293. }
  294. $out[body]=$out[body]."
  295. <tr bgcolor='$altladrow'>
  296. <td width='50%' valign='center' align='left'>
  297. <a href='$url[base]/$file[players]?playerid=$playerid' target='new'>
  298. $minfo[alias]</a></td>
  299. <td width='50%' valign='center' align='right'>";
  300. if($status < 6){
  301. $out[body]=$out[body]."Played in Match:
  302. <input type='checkbox' name='member[$playerid]' value='1'>
  303. <input type='hidden' name='kills[$playerid]' value='0' maxlength='2' size='5'>";
  304. }else{
  305. $status=member_status($status);
  306. $out[body]=$out[body]."$status";
  307. }
  308. $out[body]=$out[body]."</td>
  309. </tr>";
  310. }
  311. if(($linfo[minmaps] > '0')&&($linfo[maxmaps] > '0')){
  312. $out[body]=$out[body]."
  313. <tr class='altcolorc'>
  314. <td width='100%' height='100%' valign='top' align='center' colspan='2'>
  315. <strong>Maps Played in match</strong><br>
  316. </td>
  317. </tr>";
  318. $mapsplayed=mysql_query("SELECT id,mapname FROM maps WHERE ladderid='$ladderid' ORDER by mapname");
  319. while(list($mapid,$mapname)=mysql_fetch_row($mapsplayed)){
  320. $maplist=$maplist."<option value='$mapid'>$mapname</option>";
  321. }
  322. $mapnum=1;
  323. while($mapnum <= $linfo[maxmaps]){
  324. $out[body]=$out[body]."
  325. <tr>
  326. <td width='100%' valign='center' align='left'>
  327. #$mapnum Map Played</td>
  328. <td width='100%' valign='center' align='right'>
  329. <select name='map[$mapnum]'>";
  330. if($mapnum > $linfo[minmaps]){
  331. $out[body]=$out[body]."<option value='0'>Not Played</option>";
  332. }
  333. $out[body]=$out[body]."
  334. $maplist
  335. </select>
  336. </td>
  337. </tr>";
  338. $mapnum++;
  339. }
  340. }
  341. if($misc[losercomment]=="yes"){
  342. $out[body]=$out[body]."
  343. <tr class='altcolorc'>
  344. <td width='100%' height='100%' valign='top' align='center' colspan='2'>
  345. <strong>Comment on this match</strong><br>
  346. </td>
  347. </tr>
  348. <tr>
  349. <td width='100%' height='100%' valign='center' align='center' colspan='2'>
  350. <input type='text' name='lcomment' maxlength='50' size='50'><br>
  351. <small>50 Characters Max</small>
  352. </td>
  353. </tr>";
  354. }
  355. $out[body]=$out[body]."
  356. <tr>
  357. <td width='100%' height='100%' valign='top' align='center' colspan='5'>
  358. <br>
  359. <input type='hidden' name='ladderid' value='$ladderid'>
  360. <input type='hidden' name='winnerid' value='$winnerid'>
  361. <input type='hidden' name='loserid' value='$loserid'>
  362. <input type='hidden' name='action' value='reportc'>
  363. <button type='submit' name='' value='Report Loss' class='btn-mini btn-success''>Reportar derrota</button>
  364. <button type='reset' name='' value='Reset' class='btn btn-mini'>Reset</button></td>
  365. </td>
  366. </form>
  367. </tr>
  368. </table>
  369. $tablefoot";
  370. include("$dir[curtheme]");
  371. }
  372. function report_lossc($ladderid,$winnerid,$loserid,$member,$map,$lcomment,$kills){
  373. global $dir, $file, $url, $out, $plyr, $site;
  374. if($winnerid=="$loserid"){
  375. include("$dir[func]/error.php");
  376. display_error("You cannot report losses to yourself.<br>");
  377. }
  378. //CHECK IF CAN REPORT
  379. if (mysql_num_rows(mysql_query("SELECT status FROM teammembers WHERE teamid='$loserid' AND playerid='$plyr[id]' AND status <='4'")) < 1){
  380. include("$dir[func]/error.php");
  381. display_error("You are not allowed to report losses for this team.<br>");
  382. }
  383. $teaminfo=mysql_query("SELECT teamname FROM teams WHERE id='$loserid'");
  384. $tinfo=mysql_fetch_array($teaminfo);
  385. if(!$tinfo[teamname]){
  386. include("$dir[func]/error.php");
  387. display_error("Your team is not on this ladder.<br>");
  388. }
  389. $wteaminfo=mysql_query("SELECT teamname FROM teams WHERE id='$winnerid'");
  390. $wintinfo=mysql_fetch_array($wteaminfo);
  391. if(!$wintinfo[teamname]){
  392. include("$dir[func]/error.php");
  393. display_error("The winning team is not on this ladder.<br>");
  394. }
  395. if (mysql_num_rows(mysql_query("SELECT id FROM ladder_$ladderid WHERE id='$loserid'")) < 1){
  396. include("$dir[func]/error.php");
  397. display_error("Your team is missing from the ladder.<br>");
  398. }
  399. if (mysql_num_rows(mysql_query("SELECT id FROM ladder_$ladderid WHERE id='$winnerid'")) < 1){
  400. include("$dir[func]/error.php");
  401. display_error("The winning team is missing from the ladder.<br>");
  402. }
  403. if(!$member){
  404. include("$dir[func]/error.php");
  405. display_error("You must select the members that played.<br>");
  406. }
  407. $ladinfo=mysql_query("SELECT gameon,laddername,minmaps,maxmaps FROM ladders WHERE id='$ladderid'");
  408. $linfo=mysql_fetch_array($ladinfo);
  409. if(($linfo[minmaps] > '0')&&($linfo[maxmaps] > '0')){
  410. if(!$map){
  411. include("$dir[func]/error.php");
  412. display_error("You must select the maps you played.<br>");
  413. }
  414. }
  415. //CHECK FOR UNCONFIRMED MATCH
  416. if (mysql_num_rows(mysql_query("SELECT matchid FROM matchdbval WHERE winnerid='$winnerid' AND loserid='$loserid'")) > 0){
  417. include("$dir[func]/error.php");
  418. display_error("This match has already been reported but not confirmed by the winner.<br>");
  419. }
  420. //CECK FOR CHALLENGE OR IF OPEN PLAY IS ALLOWED
  421. $thechallenge=mysql_query("SELECT challid FROM challenges WHERE challenger='$winnerid' AND challenged='$loserid' AND finalizedby > '0' OR challenger='$loserid' AND challenged='$winnerid' AND finalizedby > '0'");
  422. $chall=mysql_fetch_array($thechallenge);
  423. if(!$chall[challid]){
  424. if(mysql_num_rows(mysql_query("SELECT openplay FROM ladders WHERE id='$ladderid' AND openplay > '0'")) < 1){
  425. include("$dir[func]/error.php");
  426. display_error("Open play is not allowed on this ladder.<br>All matches must be scheduled challenges.<br>");
  427. }
  428. }
  429. include("$dir[func]/checkdata.php");
  430. if($lcomment){
  431. $lcomment=wordwrap($lcomment,20," ",1);
  432. $lcomment=change_censor($lcomment);
  433. $lcomment=change_charecters($lcomment);
  434. }
  435. while(list($memberid,$played)=each($member)){
  436. if($played){
  437. $memberid=change_numbersonly($memberid);
  438. $kills[$memberid]=change_numbersonly($kills[$memberid]);
  439. $membersplayed=$membersplayed."$memberid|$kills[$memberid],";
  440. $totalkills=($totalkills + $kills[$memberid]);
  441. }
  442. }
  443. if(($linfo[minmaps] > '0')&&($linfo[maxmaps] > '0')){
  444. while(list($mapselid,$mapid)=each($map)){
  445. if($mapid){
  446. $mapid=change_numbersonly($mapid);
  447. $mapsplayed=$mapsplayed."$mapid,";
  448. }
  449. }
  450. }
  451. if(!$membersplayed){
  452. include("$dir[func]/error.php");
  453. display_error("You must select the members that played.<br>");
  454. }
  455. if(($linfo[minmaps] > '0')&&($linfo[maxmaps] > '0')){
  456. if(!$mapsplayed){
  457. include("$dir[func]/error.php");
  458. display_error("You must select the maps you played.<br>");
  459. }
  460. }
  461. //GET WINNER STATS
  462. //IF A STATUS DOESNT ALLOW A REPORT DO IT HERE
  463. $winteaminfo=mysql_query("SELECT status,rank,games,percent FROM ladder_$ladderid WHERE id='$winnerid'");
  464. $wtinfo=mysql_fetch_array($winteaminfo);
  465. //GET LOSER STATS
  466. //IF A STATUS DOESNT ALLOW A REPORT DO IT HERE
  467. $losteaminfo=mysql_query("SELECT status,rank,games,percent FROM ladder_$ladderid WHERE id='$loserid'");
  468. $ltinfo=mysql_fetch_array($losteaminfo);
  469. // GET SKILL INFO
  470. if($wtinfo[rank] > $ltinfo[rank]){
  471. $rankdifference=($wtinfo[rank] - $ltinfo[rank]);
  472. }else{
  473. $rankdifference="1";
  474. }
  475. if($ltinfo[percent]){
  476. $percentoratio=($wtinfo[percent] / $ltinfo[percent]);
  477. }else{
  478. $percentoratio="1";
  479. }
  480. /* CHANGED SKILL TO KILLS
  481. $skilladjust=($rankdifference * $percentoratio / 10);
  482. $skillfactor=($skilladjust + $wtinfo[games] / 100);
  483. if($skillfactor > 20){
  484. $gainedskill="20";
  485. }else{
  486. $gainedskill=round($skillfactor);
  487. }
  488. */
  489. $gainedskill="$totalkills";
  490. //IF BOTH RANKED AND LOSER WAS RANKED BETTER THAN WINNER, WINNER GETS EXTRA POINTS
  491. if(($wtinfo[rank] > 0) && ($ltinfo[rank] > 0) && ($wtinfo[rank] > $ltinfo[rank])){
  492. $trankedplayers=mysql_query("SELECT COUNT(*) FROM ladder_$ladderid WHERE rank > '0'");
  493. $trplayers=mysql_fetch_array($trankedplayers);
  494. $rankedplayers="$rplayers[0]";
  495. $gainedpoints=($rankedplayers - $ltinfo[rank]);
  496. if($gainedpoints < 10){
  497. $gainedpoints=($gainedpoints + 10);
  498. }
  499. }else{
  500. //GET FLAT RATE OF 10 POINTS
  501. $gainedpoints="10";
  502. }
  503. //CLEAN UNCONFIRMED MATCHES
  504. clean_unconfirmedmatches();
  505. //ADD TO UNVALIDATED MATCHES
  506. $tday=date("Y-m-d H:i:s");
  507. $mcode=md5(uniqid(microtime()));
  508. $mcode="$mcode";
  509. $ip=getenv("REMOTE_ADDR");
  510. mysql_query("INSERT INTO matchdbval VALUES (
  511. '$mcode',
  512. '$winnerid',
  513. '$loserid',
  514. '$tinfo[teamname]',
  515. '$ladderid',
  516. '$membersplayed',
  517. '$mapsplayed',
  518. '$lcomment',
  519. '$wtinfo[rank]',
  520. '$ltinfo[rank]',
  521. '$gainedpoints',
  522. '$gainedskill',
  523. '$plyr[id]',
  524. '$tday',
  525. '$ip');");
  526. $getcode=mysql_query("SELECT matchid FROM matchdbval WHERE winnerid='$winnerid' AND loserid='$loserid'");
  527. $match=mysql_fetch_array($getcode);
  528. $matchcode="$match[matchid]";
  529. $tablehead=table_head("show","100%","","center");
  530. $tablefoot=table_foot("show");
  531. $bannerhead=table_head("show","488","80","center");
  532. $bannerfoot=table_foot("show");
  533. $out[body]=$out[body]."
  534. <center>
  535. $bannerhead
  536. $out[banner]
  537. $bannerfoot
  538. <br>
  539. $tablehead
  540. <table width='100%' border='0' bordercolor='#000000' cellspacing='0' cellpadding='2'>
  541. <tr class='altcolor'>
  542. <td width='100%' valign='top' align='center'>
  543. <strong>Your loss has been reported</strong><br>
  544. </td>
  545. </tr>
  546. <tr>
  547. <td width='100%' valign='center' align='left'>
  548. <br><ul>
  549. Winner: <a href='$url[base]/$file[teams]?teamid=$winnerid'>$wintinfo[teamname]</a><br>
  550. Loser: <a href='$url[base]/$file[teams]?teamid=$loserid'>$tinfo[teamname]</a>
  551. <br>
  552. The winner will not recieve the win untill they confirm this result.<br>
  553. </ul></td>
  554. </tr>
  555. <tr class='altcolor'>
  556. <td width='100%' valign='top' align='center'>
  557. <strong><a href='$url[base]/$file[ladder]?ladderid=$ladderid&cid=$loserid'>View the Ladder</a></strong><br>
  558. </td>
  559. </tr>
  560. </table>
  561. $tablefoot";
  562. include("$dir[curtheme]");
  563. }
  564. function clean_unconfirmedmatches(){
  565. $deletedate=date("Y-m-d H:i:s",time()-60*60*24*1);
  566. mysql_query("DELETE FROM matchdbval WHERE reporteddate < '$deletedate'");
  567. }
  568. function member_status($status){
  569. if($status=="1"){ $status="Leader"; }
  570. if($status=="2"){ $status="Co-Leader"; }
  571. if($status=="3"){ $status="Captain"; }
  572. if($status=="4"){ $status="Co-Captain"; }
  573. if($status=="5"){ $status="Member"; }
  574. if($status=="6"){ $status="Training"; }
  575. if($status=="7"){ $status="Inactive"; }
  576. if($status=="8"){ $status="Suspended"; }
  577. return($status);
  578. }
  579. ?>