Renamed key into item

Under MySQL key seems to be a restricted keyword

diff --git a/theme.php b/theme.php
index 576c40f..25a364e 100644 (file)
--- a/theme.php
+++ b/theme.php
@@ -4,8 +4,8 @@ require_once('lib/general.php');
 
 $theme = $_SESSION['sys']['theme'];
 
-$sql = sprintf("SELECT sys_theme_keys.name,value FROM sys_theme_values " .
-              "JOIN sys_theme_keys ON key = sys_theme_keys.id WHERE theme = %d",
+$sql = sprintf("SELECT sys_theme_items.name,value FROM sys_theme_values " .
+              "JOIN sys_theme_items ON item = sys_theme_items.id WHERE theme = %d",
               $theme);
 $sth = $db->query($sql);