cvs: bugtracker /notes gsoc_bugtracker.sql /template/generic/admin/cache alter.php index.php

bcarlyon Fri Aug 15 12:39:02 2008 UTC Modified files: /bugtracker/notes gsoc_bugtracker.sql /bugtracker/template/generic/admin/cache alter.php index.php Log: Added a karma type table and cache, altered the cache alter routines, to allowing adding elements, if the cache has no elements to start with http://cvs.php.net/viewvc.cgi/bugtracker/notes/gsoc_bugtracker.sql?r1=1.2&r2=1.3&diff_format=u Index: bugtracker/notes/gsoc_bugtracker.sql diff -u bugtracker/notes/gsoc_bugtracker.sql:1.2 bugtracker/notes/gsoc_bugtracker.sql:1.3 --- bugtracker/notes/gsoc_bugtracker.sql:1.2 Wed Aug 13 10:59:09 2008 +++ bugtracker/notes/gsoc_bugtracker.sql Fri Aug 15 12:39:02 2008 @@ -314,4 +314,12 @@ -- Dumping data for table user -- +CREATE TABLE IF NOT EXISTS karma_type ( + karma_type_id int(11) NOT NULL AUTO_INCREMENT, + karma_type_text varchar(255) NOT NULL, + ordering int(2) NOT NULL DEFAULT '0', + PRIMARY KEY (karma_type_id), + UNIQUE KEY karma_type_text (karma_type_text), + UNIQUE KEY ordering (ordering) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ; http://cvs.php.net/viewvc.cgi/bugtracker/template/generic/admin/cache/alter.php?r1=1.2&r2=1.3&diff_format=u Index: bugtracker/template/generic/admin/cache/alter.php diff -u bugtracker/template/generic/admin/cache/alter.php:1.2 bugtracker/template/generic/admin/cache/alter.php:1.3 --- bugtracker/template/generic/admin/cache/alter.php:1.2 Thu Aug 14 12:29:42 2008 +++ bugtracker/template/generic/admin/cache/alter.php Fri Aug 15 12:39:02 2008 @@ -37,7 +37,7 @@ * @author Barry Carlyon <bcarlyon@php.net> * @copyright 2008-2008 Barry Carlyon * @license http://www.opensource.org/licenses/bsd-license.php BSD License -* @version CVS: $Id: alter.php,v 1.2 2008/08/14 12:29:42 bcarlyon Exp $ +* @version CVS: $Id: alter.php,v 1.3 2008/08/15 12:39:02 bcarlyon Exp $ * @link http://gsoc.barrycarlyon.servegame.org/ */ @@ -90,11 +90,11 @@ } $db->get_data($basequery); + $content .= 'You seleceted the ' . $resource . ' cache/table<br /><br />'; + $content .= '<form action="/admin/cache/alter/' . $resource . '/" method="post">'; + $content .= '<input type="hidden" name="submitted" value="true" />'; + $content .= '<table>'; if ($db->total_rows) { - $content .= 'You seleceted the ' . $resource . ' cache/table<br /><br />'; - $content .= '<form action="/admin/cache/alter/' . $resource . '/" method="post">'; - $content .= '<input type="hidden" name="submitted" value="true" />'; - $content .= '<table>'; while ($row = $db->fetch_row()) { $content .= '<tr>'; $content .= '<td>' . $row[$resource . '_id'] . '</td>'; @@ -106,12 +106,12 @@ $content .= 'Updated'; $content .= '</td></tr>'; } - $content .= '<tr><td>New</td><td><input type="text" name="new_text" id="new_text" value="" /></td><td><input type="text" name="new_ordering" id="new_ordering" value="'; - $content .= $db->total_rows + 1; - $content .= '" /></td><td><input type="submit" value="Update All" /></td></tr>'; - $content .= '</table>'; - $content .= '</form>'; } + $content .= '<tr><td>New</td><td><input type="text" name="new_text" id="new_text" value="" /></td><td><input type="text" name="new_ordering" id="new_ordering" value="'; + $content .= $db->total_rows + 1; + $content .= '" /></td><td><input type="submit" value="Update All" /></td></tr>'; + $content .= '</table>'; + $content .= '</form>'; } $content .= 'Which cache would you like to edit?<br /><br />'; http://cvs.php.net/viewvc.cgi/bugtracker/template/generic/admin/cache/index.php?r1=1.4&r2=1.5&diff_format=u Index: bugtracker/template/generic/admin/cache/index.php diff -u bugtracker/template/generic/admin/cache/index.php:1.4 bugtracker/template/generic/admin/cache/index.php:1.5 --- bugtracker/template/generic/admin/cache/index.php:1.4 Thu Aug 14 12:30:29 2008 +++ bugtracker/template/generic/admin/cache/index.php Fri Aug 15 12:39:02 2008 @@ -37,7 +37,7 @@ * @author Barry Carlyon <bcarlyon@php.net> * @copyright 2008-2008 Barry Carlyon * @license http://www.opensource.org/licenses/bsd-license.php BSD License -* @version CVS: $Id: index.php,v 1.4 2008/08/14 12:30:29 bcarlyon Exp $ +* @version CVS: $Id: index.php,v 1.5 2008/08/15 12:39:02 bcarlyon Exp $ * @link http://gsoc.barrycarlyon.servegame.org/ */ @@ -48,6 +48,7 @@ $tocache[] = 'os_version'; $tocache[] = 'account_type'; $tocache[] = 'comment_type'; +$tocache[] = 'karma_type'; $method = loadvar('method'); $method = str_replace('/','',$method);