editlevels.php

   1 <?php
   2 require ('config.php');
   3 $level_restriction = ADMIN2;
   4 $require_login = true;
   5 $page_name = 'Level Editor';
   6 require ('top.inc.php');
   7
   8 if (isset ($_POST['submit']))
   9 {
  10         $nochange = isset ($_POST['nochange']) ? 1 : 0;
  11         $old_level = intval ($_POST['old_level']);
  12         $new_level = intval ($_POST['new_level']);
  13         if ($_POST['submit'] == 'Edit Level' && $old_level != $new_level)
  14         {
  15                 echo '<div class="alert">';
  16                 if (mysql_result (mysql_query ('SELECT COUNT(*) FROM `levels` WHERE `levnum` = '.$old_level), 0) > 0)
  17                         echo 'Error: Level number already in use.';
  18                 else
  19                 {
  20                         mysql_query ('UPDATE `users` SET `level` = '.$new_level.' WHERE `level` = '.$old_level);
  21                         $users = mysql_affected_rows ();
  22                         $boards = mysql_result (mysql_query ('SELECT COUNT(*) FROM `boards` WHERE
  23 `boardlevel` = '.$old_level.' OR `topiclevel` = '.$old_level.' OR `postlevel` = '.$old_level), 0);
  24                         mysql_query ('UPDATE `boards` SET `boardlevel` = '.$new_level.' WHERE `boardlevel` = '.$old_level);
  25                         mysql_query ('UPDATE `boards` SET `topiclevel` = '.$new_level.' WHERE `topiclevel` = '.$old_level);
  26                         mysql_query ('UPDATE `boards` SET `postlevel` = '.$new_level.' WHERE `postlevel` = '.$old_level);
  27                         mysql_query ('UPDATE `levels` SET
  28 `levdefine` = \''.mysql_real_escape_string ($_POST['levdefine']).'\',
  29 `levnum` = '.intval ($_POST['new_level']).',
  30 `levname` = \''.mysql_real_escape_string ($_POST['levname']).'\',
  31 `caption` = \''.mysql_real_escape_string ($_POST['caption']).'\',
  32 `minaura` = '.intval ($_POST['minaura']).',
  33 `nochange` = '.$nochange.'
  34 WHERE `levnum` = '.$old_level);
  35                         echo 'Level edited: '.$old_level.' to '.$new_level.' ('.$users.' users affected, '.$boards.' boards affected)';
  36                 }
  37                 echo '</div>';
  38         }
  39         elseif ($_POST['submit'] == 'Edit Level')
  40         {
  41                 mysql_query ('UPDATE `levels` SET
  42 `levdefine` = \''.mysql_real_escape_string ($_POST['levdefine']).'\',
  43 `levname` = \''.mysql_real_escape_string ($_POST['levname']).'\',
  44 `caption` = \''.mysql_real_escape_string ($_POST['caption']).'\',
  45 `minaura` = '.intval ($_POST['minaura']).',
  46 `nochange` = '.$nochange.'
  47 WHERE `levnum` = '.$old_level);
  48                 echo '<div class="alert">Level edited.</div>';
  49         }
  50 }
  51
  52 echo '
  53 <div class="c3">Manage Levels</div>
  54 <table>
  55 <tr>
  56 <th>Level #, Name, Caption</th>
  57 <th>Definition</th>
  58 <th>Minimum '.$cfg['bds']['aura'].'</th>
  59 <th>Fixed Level</th>
  60 <th>Edit</th>
  61 </tr>
  62 ';
  63
  64 $result = mysql_query ('SELECT * FROM `levels` ORDER BY `levnum` DESC');
  65 while ($myrow = mysql_fetch_assoc ($result))
  66 {
  67         if (isset ($_GET['editlevel']) && intval ($_GET['lid']) == $myrow['levnum'])
  68         {
  69                 $myrow = mysql_fetch_assoc (mysql_query ('SELECT * FROM `levels` WHERE `levnum` = '.intval ($_GET['lid'])));
  70                 echo '<tr class="alert"><td colspan="5">
  71 <form method="post" action="'.urlpath(2).'">
  72 <input type="hidden" name="old_level" value="'.$myrow['levnum'].'"/>
  73 <fieldset style="display:inline;height:6em">
  74 <legend>Level Number, Name &amp; Caption</legend>
  75 <input type="text" name="new_level" style="width:2em" value="'.$myrow['levnum'].'"/>
  76 <input type="text" name="levname" maxlength="12" value="'.$myrow['levname'].'"/><br />
  77 <textarea name="caption">'.$myrow['caption'].'</textarea>
  78 </fieldset>
  79
  80 <fieldset style="display:inline;height:6em">
  81 <legend>Other</legend>
  82 Level Definition: <input type="text" name="levdefine" maxlength="15" value="'.$myrow['levdefine'].'"/><br/>
  83 Minimum '.$cfg['bds']['aura'].': <input type="text" name="minaura" size="3" value="'.$myrow['minaura'].'"/><br/>
  84 <label for="fixed_level">Fixed Level:</label>
  85 <input type="checkbox" id="fixed_level" name="nochange'.($myrow['nochange'] ? '" checked="checked' : '').'"/><br/>
  86 <input type="submit" name="submit" value="Edit Level"/>
  87 <input type="submit" value="Cancel"/>
  88 </fieldset>
  89 </form>
  90 </td></tr>
  91 ';
  92         }
  93         else
  94                 echo '<tr class='.colour().'><td>
  95 <b>'.$myrow['levnum'].': '.$myrow['levname'].'</b><br/>
  96 <small>'.$myrow['caption'].'</small></td>
  97 <td>'.$myrow['levdefine'].'</td>
  98 <td>'.$myrow['minaura'].'</td>
  99 <td>'.($myrow['nochange'] ? 'Yes' : 'No').'</td>
 100 <td><a href="?editlevel=1;lid='.$myrow['levnum'].urlpath(1).'">Edit</a></td></tr>
 101 ';
 102 }
 103
 104 echo '</table>';
 105
 106 require ('foot.php');
 107 ?>