PageRenderTime 49ms CodeModel.GetById 24ms RepoModel.GetById 1ms app.codeStats 0ms

/html/pages/admin/editgames.php

https://github.com/graywh/utstats
PHP | 74 lines | 66 code | 8 blank | 0 comment | 8 complexity | 71dcdac23765444559353fe3b758c1db MD5 | raw file
  1. <?php
  2. if (empty($import_adminkey) or isset($_REQUEST['import_adminkey']) or $import_adminkey != $adminkey) die('bla');
  3. if (isset($_REQUEST['submit'])) {
  4. foreach($_REQUEST['name'] as $id => $bla) {
  5. if ($id == 0) {
  6. if (empty($_REQUEST['name'][$id])) continue;
  7. mysql_query(" INSERT INTO uts_games
  8. SET name = '". my_addslashes($_REQUEST['name'][$id]) ."',
  9. gamename = '(user defined)';") or die(mysql_error());
  10. } else {
  11. mysql_query(" UPDATE uts_games
  12. SET name = '". my_addslashes($_REQUEST['name'][$id]) ."'
  13. WHERE id = '$id';") or die(mysql_error());
  14. }
  15. }
  16. }
  17. echo'<br><table border="0" cellpadding="1" cellspacing="2" width="600">
  18. <tr>
  19. <td class="medheading" align="center" colspan="2">Edit games</td>
  20. </tr>
  21. <tr>
  22. <td class="smheading">GameName</td>
  23. <td class="smheading">DisplayName</td>
  24. </tr>
  25. <form action="'.$_SERVER['PHP_SELF'].'" method="POST">
  26. <input type="hidden" name="key" value="'.$adminkey.'">
  27. <input type="hidden" name="action" value="'.$action.'">
  28. ';
  29. $sql_games = "SELECT id, gamename, name FROM uts_games ORDER BY gamename ASC;";
  30. $q_games = mysql_query($sql_games) or die(mysql_error());
  31. $i = 0;
  32. while ($r_games = mysql_fetch_array($q_games)) {
  33. $i++;
  34. $class = ($i%2) ? 'grey' : 'grey2';
  35. echo '<tr>';
  36. echo '<td class="'.$class.'">'.htmlentities($r_games['gamename']).'</td>';
  37. echo '<td class="'.$class.'"><input class="searchform" type="text" name="name['.$r_games['id'].']" value="'.$r_games['name'].'"></td>';
  38. echo '</tr>';
  39. }
  40. echo'
  41. <tr>
  42. <td colspan="2">&nbsp;</td>
  43. </tr>
  44. <tr>
  45. <td class="smheading" colspan="2" align="center">Add new</td>
  46. </tr>
  47. <tr>
  48. <td class="grey">(n/a)</td>
  49. <td class="grey"><input class="searchform" type="text" name="name[0]" value=""></td></td>
  50. </tr>
  51. <tr>
  52. <td colspan="2">&nbsp;</td>
  53. </tr>
  54. <tr>
  55. <td class="smheading" colspan="2" align="center">Submit</td>
  56. </tr>
  57. ';
  58. echo '<tr>';
  59. echo '<td class="darkgrey" colspan="4" align="center"><input class="searchformb" type="Submit" name="submit" value="Save"></td>';
  60. echo '</tr>';
  61. echo'</form>
  62. <tr>
  63. <td class="smheading" align="center" colspan="4"><a class="grey" href="./admin.php?key='.$_REQUEST[key].'">Go Back To Admin Page</a></td>
  64. </tr>
  65. </table>';
  66. ?>