editthemes.php

   1 <?php
   2 require ('config.php');
   3 $level_restriction = ADMIN;
   4 $require_login = true;
   5 $page_name = 'Themes Editor';
   6 require ('top.inc.php');
   7
   8 asort ($cfg['logotitles']);
   9 function imglist ($imgsel = 0)
  10 {
  11         global $cfg;
  12         $box = '<select name="imgsel">
  13 ';
  14         foreach ($cfg['logotitles'] as $index => $name)
  15                 $box .= '<option value="'.$index.'"'.($imgsel == $index ? ' selected="selected"' : '').'>'.$name.'</option>
  16 ';
  17         return $box.'</select>
  18 ';
  19 }
  20
  21 $themeid = isset ($_GET['tid']) ? intval ($_GET['tid']) : 'none';
  22
  23 if (isset ($_POST['submit']))
  24 {
  25         if ($_POST['submit'] == 'Delete Theme')
  26         {
  27                 mysql_query ('DELETE FROM `styles` WHERE `styleid` = '.intval ($_POST['styleid']).' LIMIT 1');
  28                 echo '<div class="alert">Theme removed.</div>
  29 ';
  30         }
  31         elseif ($_POST['submit'] == 'Edit Theme')
  32         {
  33                 mysql_query ('UPDATE `styles` SET
  34                         `title` = \''.mysql_real_escape_string ($_POST['title']).'\',
  35                         `filename` = \''.mysql_real_escape_string ($_POST['filename']).'\',
  36                         `logo` = '.intval ($_POST['imgsel']).'
  37                         WHERE `styleid` = '.intval ($_POST['styleid']).' LIMIT 1'
  38                 );
  39                 echo '<div class="alert">Theme modified.</div>
  40 ';
  41         }
  42         elseif ($_POST['submit'] == 'Add Theme')
  43         {
  44                 mysql_query ('INSERT INTO `styles` (`title`, `filename`, `logo`) VALUES (
  45                         \''.mysql_real_escape_string ($_POST['title']).'\',
  46                         \''.mysql_real_escape_string ($_POST['filename']).'\',
  47                         '.intval ($_POST['imgsel']).')'
  48                 );
  49                 echo '<div class="alert">Theme added.</div>
  50 ';
  51         }
  52         elseif ($_POST['submit'] == 'Change Default')
  53         {
  54                 mysql_query ('UPDATE `styles` SET `defaulttheme` = 0');
  55                 mysql_query ('UPDATE `styles` SET `defaulttheme` = 1 WHERE `styleid` = '.intval ($_POST['colorsel']).' LIMIT 1');
  56                 echo '<div class="alert">Default theme modified.</div>
  57 ';
  58         }
  59 }
  60
  61 echo '<div class="c3">Manage Premade Themes</div>
  62 <table>
  63 <tr><th>Name</th><th>Filename</th><th>Logo Image</th><th>Edit</th></tr>
  64 ';
  65
  66 $result = mysql_query ('SELECT * FROM `styles` ORDER BY `title` ASC');
  67 while ($myrow = mysql_fetch_assoc ($result))
  68 {
  69         if ($themeid != $myrow['styleid'])
  70         echo '<tr class='.colour().'>
  71 <td>'.$myrow['title'].' ('.mysql_result (mysql_query('SELECT COUNT(*) FROM `users` WHERE `colorsel` = '.$myrow['styleid'].' AND `themetype` = 0'), 0).' users)</td>
  72 <td>'.$myrow['filename'].(file_exists ('csslib/system/'.$myrow['filename']) ? '' : $cfg['img'][3]).'</td>
  73 <td>'.$cfg['logotitles'][$myrow['logo']].'</td>
  74 <td><a href="?op=delete;tid='.$myrow['styleid'].urlpath(1).'">Delete</a><br />
  75 <a href="?op=edit;tid='.$myrow['styleid'].urlpath(1).'">Edit</a></td>
  76 </tr>
  77 ';
  78         elseif ($_GET['op'] == 'delete')
  79         echo '<tr class="alert">
  80 <td>'.$myrow['title'].'</td>
  81 <td>'.$myrow['filename'].'</td>
  82 <td>'.$cfg['logotitles'][$myrow['logo']].'</td>
  83 <td><form action="'.urlpath(2).'" method="post">
  84 <input type="hidden" name="styleid" value="'.$myrow['styleid'].'"/>
  85 <input type="submit" name="submit" value="Delete Theme"/><br/>
  86 <input type="submit" value="Cancel"/></form></td>
  87 </tr>
  88 ';
  89         elseif ($_GET['op'] == 'edit')
  90         echo '<tr class="alert"><td colspan="5">
  91 <form action="'.urlpath(2).'" method="post">
  92 <input type="hidden" name="styleid" value="'.$myrow['styleid'].'"/>
  93 Title: <input type="text" name="title" value="'.$myrow['title'].'"/><br/>
  94 Filepath: <input type="text" name="filename" value="'.$myrow['filename'].'"/><br/>
  95 Header: '.imglist ($myrow['logo']).'<br/>
  96 <input type="submit" name="submit" value="Edit Theme"/> | <input type="submit" value="Cancel"/>
  97 </form>
  98 </td></tr>
  99 ';
 100 }
 101
 102 echo '</table>
 103
 104 <div class="c3">Add theme</div>
 105 <form action="'.urlpath(2).'" method="post">
 106 <div class="alert">
 107 Title: <input type="text" name="title"/><br/>
 108 Filename: <input type="text" name="filename"/> (base filename only)<br/>
 109 Header: '.imglist().'<br/>
 110 <input type="submit" name="submit" value="Add Theme"/>
 111 </div>
 112 </form>
 113
 114 <form action="'.urlpath(2).'" method="post">
 115 <div class='.colour().'>
 116 Default theme:
 117 <select name="colorsel">
 118 ';
 119
 120 $themes = mysql_query ('SELECT `styleid`, `title`, `defaulttheme` FROM `styles` ORDER BY `title` ASC');
 121 while ($style = mysql_fetch_row ($themes))
 122         echo '<option value="'.$style[0].'"'.($style[2] ? ' selected="selected"' : '').'>'.$style[1].'</option>
 123 ';
 124
 125 echo '</select>
 126 <input type="submit" name="submit" value="Change Default"/>
 127 </div>
 128 </form>';
 129
 130 require ('foot.php');
 131 ?>