diff options
author | nikrou <nikrou@piwigo.org> | 2009-11-25 19:02:57 +0000 |
---|---|---|
committer | nikrou <nikrou@piwigo.org> | 2009-11-25 19:02:57 +0000 |
commit | 13ea9d50e35d9dd8cf7235a39d97a344e6091ea0 (patch) | |
tree | a3c6e08df8ea10d0d5f56ffc2f1f14d6cbcfcd67 /admin/site_update.php | |
parent | d30639ec98f8e2929137ab6e00cb2fe3ba295957 (diff) |
Feature 1255: modification in sql queries
- manage random function
- manage regex syntax
- manage quote (single instead of double)
- manage interval
git-svn-id: http://piwigo.org/svn/trunk@4367 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'admin/site_update.php')
-rw-r--r-- | admin/site_update.php | 12 |
1 files changed, 3 insertions, 9 deletions
diff --git a/admin/site_update.php b/admin/site_update.php index 84c6a8f87..b4980595d 100644 --- a/admin/site_update.php +++ b/admin/site_update.php @@ -148,7 +148,7 @@ SELECT id, uppercats, global_rank, status, visible if (isset($_POST['subcats-included']) and $_POST['subcats-included'] == 1) { $query.= ' - AND uppercats REGEXP \'(^|,)'.$_POST['cat'].'(,|$)\' + AND uppercats '.DB_REGEX_OPERATOR.' \'(^|,)'.$_POST['cat'].'(,|$)\' '; } else @@ -207,10 +207,7 @@ SELECT id_uppercat, MAX(rank)+1 AS next_rank } // next category id available - $query = ' -SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1) AS next_id - FROM '.CATEGORIES_TABLE; - list($next_id) = pwg_db_fetch_row(pwg_query($query)); + $next_id = pwg_db_nextval('id', CATEGORIES_TABLE); // retrieve sub-directories fulldirs from the site reader $fs_fulldirs = $site_reader->get_full_directories($basedir); @@ -399,10 +396,7 @@ SELECT file,storage_category_id } // next element id available - $query = ' -SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1) AS next_element_id - FROM '.IMAGES_TABLE; - list($next_element_id) = pwg_db_fetch_row(pwg_query($query)); + $next_element_id = pwg_db_nextval('id', IMAGES_TABLE); $start = get_moment(); |