@@ -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()); |
@@ -1,7 +1,5 @@ |
||
1 | 1 | <?php |
2 | 2 | |
3 | -use Xoopsmodules\instruction; |
|
4 | - |
|
5 | 3 | // Автор: andrey3761 |
6 | 4 | $moduleDirName = basename(dirname(__DIR__)); |
7 | 5 | require_once __DIR__ . '/../../../include/cp_header.php'; |
@@ -1,6 +1,5 @@ |
||
1 | 1 | <?php namespace Xoopsmodules\instruction; |
2 | 2 | |
3 | -use Xmf\Request; |
|
4 | 3 | use Xoopsmodules\instruction\common; |
5 | 4 | |
6 | 5 | require_once __DIR__ . '/common/VersionChecks.php'; |