Changeset 28086


Ignore:
Timestamp:
Apr 5, 2014, 8:18:47 PM (10 years ago)
Author:
mistic100
Message:

messed up the upgrade task

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/SmartAlbums/maintain.inc.php

    r28063 r28086  
    120120    pwg_query('ALTER TABLE `' . $this->table . '` CHANGE `cond` `cond` VARCHAR(32) NULL ;');
    121121   
     122    // add recursive marker for album filter (2.2.2)
    122123    $result = pwg_query('SELECT COUNT(*) FROM `' . $this->table . '` WHERE type="album" AND (value NOT LIKE "true,%" OR value NOT LIKE "false,%");');
    123     if (pwg_db_num_rows(pwg_query($query)))
     124    list($count) = pwg_db_fetch_row($result);
     125    if ($count>0)
    124126    {
    125127      pwg_query('UPDATE `' . $this->table . '` SET value = CONCAT("false,", value) WHERE type="album";');
Note: See TracChangeset for help on using the changeset viewer.