mambax7 /
gwiki
| @@ 62-87 (lines=26) @@ | ||
| 59 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('gwiki_pages') . " WHERE keyword like '{$keywordpattern}' AND lastmodified< $lastmodifiedbefore"; |
|
| 60 | $result = $xoopsDB->queryF($sql); |
|
| 61 | $cnt = $xoopsDB->getAffectedRows(); |
|
| 62 | if ($cnt > 0) { |
|
| 63 | $sql = 'SELECT image_file FROM ' . $xoopsDB->prefix('gwiki_page_images'); |
|
| 64 | $sql .= ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 65 | $result = $xoopsDB->query($sql); |
|
| 66 | while ($f = $xoopsDB->fetchArray($result)) { |
|
| 67 | unlink(XOOPS_ROOT_PATH . '/uploads/' . $dir . '/' . $f['image_file']); |
|
| 68 | } |
|
| 69 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('gwiki_page_images'); |
|
| 70 | $sql .= ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 71 | $result = $xoopsDB->queryF($sql); |
|
| 72 | ||
| 73 | $sql = 'SELECT file_path FROM ' . $xoopsDB->prefix('gwiki_page_files'); |
|
| 74 | $sql .= ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 75 | $result = $xoopsDB->query($sql); |
|
| 76 | while ($f = $xoopsDB->fetchArray($result)) { |
|
| 77 | unlink(XOOPS_ROOT_PATH . '/uploads/' . $dir . '/' . $f['file_path']); |
|
| 78 | } |
|
| 79 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('gwiki_page_files'); |
|
| 80 | $sql .= ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 81 | $result = $xoopsDB->queryF($sql); |
|
| 82 | ||
| 83 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('gwiki_pageids') . ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 84 | $result = $xoopsDB->queryF($sql); |
|
| 85 | $sql = 'OPTIMIZE TABLE ' . $xoopsDB->prefix('gwiki_pages'); |
|
| 86 | $result = $xoopsDB->queryF($sql); |
|
| 87 | } |
|
| 88 | } |
|
| 89 | ||
| @@ 40-65 (lines=26) @@ | ||
| 37 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('gwiki_pages') . " WHERE active = 0 AND lastmodified< $lastmodifiedbefore"; |
|
| 38 | $result = $xoopsDB->queryF($sql); |
|
| 39 | $cnt = $xoopsDB->getAffectedRows(); |
|
| 40 | if ($cnt > 0) { |
|
| 41 | $sql = 'SELECT image_file FROM ' . $xoopsDB->prefix('gwiki_page_images'); |
|
| 42 | $sql .= ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 43 | $result = $xoopsDB->query($sql); |
|
| 44 | while ($f = $xoopsDB->fetchArray($result)) { |
|
| 45 | unlink(XOOPS_ROOT_PATH . '/uploads/' . $dir . '/' . $f['image_file']); |
|
| 46 | } |
|
| 47 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('gwiki_page_images'); |
|
| 48 | $sql .= ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 49 | $result = $xoopsDB->queryF($sql); |
|
| 50 | ||
| 51 | $sql = 'SELECT file_path FROM ' . $xoopsDB->prefix('gwiki_page_files'); |
|
| 52 | $sql .= ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 53 | $result = $xoopsDB->query($sql); |
|
| 54 | while ($f = $xoopsDB->fetchArray($result)) { |
|
| 55 | unlink(XOOPS_ROOT_PATH . '/uploads/' . $dir . '/' . $f['file_path']); |
|
| 56 | } |
|
| 57 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('gwiki_page_files'); |
|
| 58 | $sql .= ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 59 | $result = $xoopsDB->queryF($sql); |
|
| 60 | ||
| 61 | $sql = 'DELETE FROM ' . $xoopsDB->prefix('gwiki_pageids') . ' WHERE keyword NOT IN (SELECT keyword from ' . $xoopsDB->prefix('gwiki_pages') . ')'; |
|
| 62 | $result = $xoopsDB->queryF($sql); |
|
| 63 | $sql = 'OPTIMIZE TABLE ' . $xoopsDB->prefix('gwiki_pages'); |
|
| 64 | $result = $xoopsDB->queryF($sql); |
|
| 65 | } |
|
| 66 | } |
|
| 67 | ||
