@@ -52,7 +52,8 @@ discard block |
||
52 | 52 | . " FROM {$itemHandler->table} " |
53 | 53 | . " WHERE {$itemHandler->table}.status > 0" |
54 | 54 | . ' ) ' |
55 | - . ' )'; else: |
|
55 | + . ' )'; else { |
|
56 | + : |
|
56 | 57 | $sql = " DELETE {$linkHandler->table} FROM {$linkHandler->table}" |
57 | 58 | . " LEFT JOIN {$itemHandler->table} AS aa ON {$linkHandler->table}.tag_itemid = aa.{$itemHandler->keyName} " |
58 | 59 | . ' WHERE ' |
@@ -60,7 +61,8 @@ discard block |
||
60 | 61 | . ' AND ' |
61 | 62 | . " ( aa.{$itemHandler->keyName} IS NULL" |
62 | 63 | . ' OR aa.status < 1' |
63 | - . ' )'; |
|
64 | + . ' )'; |
|
65 | + } |
|
64 | 66 | endif; |
65 | 67 | if (!$result = $linkHandler->db->queryF($sql)) { |
66 | 68 | //xoops_error($linkHandler->db->error()); |