aboutsummaryrefslogtreecommitdiffstats
path: root/admin
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--admin/include/functions.php2
-rw-r--r--admin/include/functions_permalinks.php4
-rw-r--r--admin/permalinks.php2
3 files changed, 4 insertions, 4 deletions
diff --git a/admin/include/functions.php b/admin/include/functions.php
index 881a87e5b..d77b2cb81 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -948,7 +948,7 @@ SELECT DISTINCT(storage_category_id)
{
$query = '
UPDATE '.IMAGES_TABLE.'
- SET path = CONCAT(\''.$fulldirs[$cat_id].'\',\'/\',file)
+ SET path = '.pwg_db_concat(array($fulldirs[$cat_id],'\'/\'','file')).'
WHERE storage_category_id = '.$cat_id.'
;';
pwg_query($query);
diff --git a/admin/include/functions_permalinks.php b/admin/include/functions_permalinks.php
index f619e3b08..94c13be31 100644
--- a/admin/include/functions_permalinks.php
+++ b/admin/include/functions_permalinks.php
@@ -192,8 +192,8 @@ DELETE FROM '.OLD_PERMALINKS_TABLE.'
$query = '
UPDATE '.CATEGORIES_TABLE.'
SET permalink="'.$permalink.'"
- WHERE id='.$cat_id.'
- LIMIT 1';
+ WHERE id='.$cat_id;
+ // LIMIT 1';
pwg_query($query);
unset( $cache['cat_names'] ); //force regeneration
diff --git a/admin/permalinks.php b/admin/permalinks.php
index b937a8016..bb9dc4934 100644
--- a/admin/permalinks.php
+++ b/admin/permalinks.php
@@ -109,7 +109,7 @@ $template->set_filename('permalinks', 'permalinks.tpl' );
$query = '
SELECT
id,
- CONCAT(id, " - ", name, IF(permalink IS NULL, "", " √") ) AS name,
+ '.pwg_db_concat(array('id', '\' - \'', 'name', 'IF(permalink IS NULL, \'\', \' √\')')).' AS name,
uppercats, global_rank
FROM '.CATEGORIES_TABLE;