PHP cache::destroy方法代码示例

                     }
                 }
                 closedir($dir);
             }
         }
     }
 }
 if ($recache) {
     include_once $phpbb_root_path . 'includes/acp/acp_styles.' . $phpEx;
     $theme['theme_data'] = acp_styles::db_theme_data($theme);
     $theme['theme_mtime'] = $update_time;
     // Save CSS contents
     $sql_ary = array('theme_mtime' => $theme['theme_mtime'], 'theme_data' => $theme['theme_data']);
     $sql = 'UPDATE ' . STYLES_THEME_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "\n\t\t\tWHERE theme_id = {$theme['theme_id']}";
     $db->sql_query($sql);
     $cache->destroy('sql', STYLES_THEME_TABLE);
 }
 // Only set the expire time if the theme changed data is older than 30 minutes - to cope with changes from the ACP
 if ($recache || $theme['theme_mtime'] > time() - 1800) {
     header('Expires: 0');
 } else {
     header('Expires: ' . gmdate('D, d M Y H:i:s \\G\\M\\T', time() + $expire_time));
 }
 header('Content-type: text/css; charset=UTF-8');
 // Parse Theme Data
 $replace = array('{T_THEME_PATH}' => "{$phpbb_root_path}styles/" . $theme['theme_path'] . '/theme', '{T_TEMPLATE_PATH}' => "{$phpbb_root_path}styles/" . $theme['template_path'] . '/template', '{T_IMAGESET_PATH}' => "{$phpbb_root_path}styles/" . $theme['imageset_path'] . '/imageset', '{T_IMAGESET_LANG_PATH}' => "{$phpbb_root_path}styles/" . $theme['imageset_path'] . '/imageset/' . $user_image_lang, '{T_STYLESHEET_NAME}' => $theme['theme_name'], '{S_USER_LANG}' => $user['user_lang']);
 $theme['theme_data'] = str_replace(array_keys($replace), array_values($replace), $theme['theme_data']);
 $matches = array();
 preg_match_all('#\\{IMG_([A-Za-z0-9_]*?)_(WIDTH|HEIGHT|SRC)\\}#', $theme['theme_data'], $matches);
 $imgs = $find = $replace = array();
 if (isset($matches[0]) && sizeof($matches[0])) {

            $cache = new cache();
            $query = "SELECT post_id FROM {$comment_table} where id='{$rid}'";
            $result = $db->query($query);
            $row = $result->fetch_assoc();
            $cache->destroy_page_cache("cache/" . $row['post_id']);
            $cache->create_page_cache("cache/" . $row['post_id']);
            print "pass";
        } else {
            print "fail";
        }
    } else {
        if ($type == "post") {
            $user = new user();
            if (!$user->check_log()) {
                header("Location: ../index.php?page=post&s=view&id={$rid}");
                exit;
            }
            $reason = $db->real_escape_string(htmlentities($_POST['reason'], ENT_QUOTES, 'UTF-8'));
            if (strlen($reason) > 0) {
                $query = "UPDATE {$post_table} SET spam=TRUE, reason='{$reason}' WHERE id='{$rid}'";
                $db->query($query);
            }
            $cache = new cache();
            $cache->destroy("cache/" . $rid . "/post.cache");
            header("Location:../index.php?page=post&s=view&id={$rid}");
        } else {
            header("Location:../index.php");
        }
    }
    exit;
}

        $query = "SELECT x, y, width, height, x, y, body, created_at, updated_at, ip,  version, user_id FROM {$note_table} WHERE id='{$id}' AND post_id='{$post_id}' LIMIT 1";
        $result = $db->query($query);
        $row = $result->fetch_assoc();
        $query = "INSERT INTO {$note_history_table}(x, y, width, height, body, created_at, updated_at, ip, user_id, version, id, post_id) VALUES('" . $row['x'] . "', '" . $row['y'] . "', '" . $row['width'] . "', '" . $row['height'] . "', '" . $row['body'] . "', '" . $row['created_at'] . "', '" . $row['updated_at'] . "', '" . $row['ip'] . "', '" . $checked_user_id . "', '" . $row['version'] . "', '{$id}', '{$post_id}')";
        $result->free_result();
        $db->query($query);
        $query = "UPDATE {$note_table} SET x='{$x}', y='{$y}', width='{$width}', height='{$height}', body='{$body}', updated_at=NOW(), user_id='" . $checked_user_id . "', ip='{$ip}', version=version+1 WHERE post_id='{$post_id}' AND id='{$id}'";
        $db->query($query);
    } else {
        $result->free_result();
        $date = date("Y-m-d H:i:s");
        $query = "SELECT COUNT(*) FROM {$note_table} WHERE post_id='{$post_id}'";
        $result = $db->query($query);
        $row = $result->fetch_assoc();
        if ($row['COUNT(*)'] < 1) {
            $result->free_result();
            $query = "INSERT INTO {$note_table}(x, y, width, height, body, post_id, id, ip, user_id, created_at, updated_at) VALUES('{$x}', '{$y}', '{$width}', '{$height}', '{$body}', '{$post_id}', '1', '{$ip}', '{$checked_user_id}', '{$date}', '{$date}')";
        } else {
            $result->free_result();
            $query = "INSERT INTO {$note_table}(x, y, width, height, body, post_id, id, ip, user_id, created_at, updated_at) VALUES('{$x}', '{$y}', '{$width}', '{$height}', '{$body}', '{$post_id}', notes_next_id({$post_id}), '{$ip}', '{$checked_user_id}', '{$date}', '{$date}')";
        }
        $db->query($query);
        $query = "SELECT id FROM {$note_table} WHERE post_id='{$post_id}' AND body='{$body}' AND ip='{$ip}' AND created_at='{$date}'";
        $result = $db->query($query);
        $row = $result->fetch_assoc();
        print $row['id'] . ":" . $id;
        $result->free_result();
    }
    $cache = new cache();
    $cache->destroy("../cache/" . $post_id . "/post.cache");
}

        exit;
    }
    $query = "SELECT COUNT(*) FROM {$post_vote_table} WHERE post_id='{$id}' AND ip='{$ip}'" . $query_part;
    $result = $db->query($query);
    $row = $result->fetch_assoc();
    if ($row['COUNT(*)'] < 1) {
        $result->free_result();
        if ($type == "up") {
            $query = "UPDATE {$post_table} SET score=score+1 WHERE id='{$id}'";
            $db->query($query);
        } else {
            if ($type == "down") {
                $query = "UPDATE {$post_table} SET score=score-1 WHERE id='{$id}'";
                $db->query($query);
            } else {
                exit;
            }
        }
        $query = "INSERT INTO {$post_vote_table}(rated, ip, post_id, user_id) VALUES('{$type}', '{$ip}', '{$id}', '{$user_id}')";
        $db->query($query);
        $cache = new cache();
        $cache->destroy("cache/{$id}/post.cache");
    } else {
        $result->free_result();
    }
    $query = "SELECT score FROM {$post_table} WHERE id='{$id}'";
    $result = $db->query($query);
    $row = $result->fetch_assoc();
    echo $row['score'];
    $result->free_result();
}

 function removeimage($id)
 {
     global $db, $post_table, $note_table, $note_history_table, $user_table, $group_table, $favorites_table, $favorites_count_table, $comment_table, $comment_vote_table, $deleted_image_table;
     $can_delete = false;
     $id = $db->real_escape_string($id);
     $query = "SELECT directory, image, owner, tags, hash FROM {$post_table} WHERE id='{$id}'";
     $result = $db->query($query);
     $row = $result->fetch_assoc();
     $image = $row['image'];
     $dir = $row['directory'];
     $owner = $row['owner'];
     $tags = $row['tags'];
     $hash = $row['hash'];
     if (isset($_COOKIE['user_id']) && is_numeric($_COOKIE['user_id']) && isset($_COOKIE['pass_hash'])) {
         $user_id = $db->real_escape_string($_COOKIE['user_id']);
         $pass_hash = $db->real_escape_string($_COOKIE['pass_hash']);
         $query = "SELECT user FROM {$user_table} WHERE id='{$user_id}' AND pass='{$pass_hash}'";
         $result = $db->query($query);
         $row = $result->fetch_assoc();
         $user = $row['user'];
         $query = "SELECT t2.delete_posts FROM {$user_table} AS t1 JOIN {$group_table} AS t2 ON t2.id=t1.ugroup WHERE t1.id='{$user_id}' AND t1.pass='{$pass_hash}'";
         $result = $db->query($query);
         $row = $result->fetch_assoc();
         if (strtolower($user) == strtolower($owner) && $user != "Anonymous" || $row['delete_posts'] == true) {
             $can_delete = true;
         }
     }
     if ($can_delete == true) {
         $cache = new cache();
         $query = "SELECT parent FROM {$post_table} WHERE id='{$id}'";
         $result = $db->query($query);
         $row = $result->fetch_assoc();
         if ($row['parent'] != "" && $row['parent'] != 0) {
             $cache->destroy("../cache/" . $row['parent'] . "/post.cache");
         }
         $query = "DELETE FROM {$post_table} WHERE id='{$id}'";
         $db->query($query);
         $query = "DELETE FROM {$note_table} WHERE post_id='{$id}'";
         $db->query($query);
         $query = "DELETE FROM {$note_history_table} WHERE post_id='{$id}'";
         $db->query($query);
         $query = "DELETE FROM {$comment_table} WHERE post_id='{$id}'";
         $db->query($query);
         $query = "DELETE FROM {$comment_vote_table} WHERE post_id='{$id}'";
         $db->query($query);
         $query = "SELECT user_id FROM {$favorites_table} WHERE favorite='{$id}' ORDER BY user_id";
         $result = $db->query($query);
         while ($row = $result->fetch_assoc()) {
             $ret = "UPDATE {$favorites_count_table} SET fcount=fcount-1 WHERE user_id='" . $row['user_id'] . "'";
             $db->query($ret);
         }
         $query = "DELETE FROM {$favorites_table} WHERE favorite='{$id}'";
         $db->query($query);
         $query = "DELETE FROM {$parent_child_table} WHERE parent='{$id}'";
         $db->query($query);
         $query = "SELECT id FROM {$post_table} WHERE parent='{$id}'";
         $result = $db->query($query);
         while ($row = $result->fetch_assoc()) {
             $cache->destroy("../cache/" . $id . "/post.cache");
         }
         $query = "UPDATE {$post_table} SET parent='' WHERE parent='{$id}'";
         $db->query($query);
         unlink("../images/" . $dir . "/" . $image);
         $thumb = explode($image);
         array_pop($thumb);
         $thumb = implode($thumb) . ".jpg";
         unlink("../thumbnails/" . $dir . "/thumbnail_" . $thumb);
         $this->folder_index_decrement($dir);
         $itag = new tag();
         $tags = explode(" ", $tags);
         $misc = new misc();
         foreach ($tags as $tag) {
             if ($tag != "") {
                 $itag->deleteindextag($tag);
                 if (is_dir("../search_cache/" . $misc->windows_filename_fix($tag) . "/")) {
                     $cache->destroy_page_cache("../search_cache/" . $misc->windows_filename_fix($tag) . "/");
                 }
             }
         }
         $query = "UPDATE {$post_count_table} SET last_update='20060101' WHERE access_key='posts'";
         $db->query($query);
         $query = "INSERT INTO {$deleted_image_table}(hash) VALUES('{$hash}')";
         $db->query($query);
         return true;
     }
     return false;
 }

     $row = $result->fetch_assoc();
     $tags = $db->real_escape_string($row['tags']);
     $date = date("Y-m-d H:i:s");
     $query = "INSERT INTO {$tag_history_table}(id,tags,user_id,updated_at,ip) VALUES('" . $row['id'] . "','{$tags}','{$checked_user_id}','{$date}','{$ip}')";
     $db->query($query) or die($db->error);
     $cache = new cache();
     if ($parent != '' && is_numeric($parent)) {
         $parent_check = "SELECT COUNT(*) FROM {$post_table} WHERE id='{$parent}'";
         $pres = $db->query($parent_check);
         $prow = $pres->fetch_assoc();
         if ($prow['COUNT(*)'] > 0) {
             $temp = "INSERT INTO {$parent_child_table}(parent,child) VALUES('{$parent}','" . $row['id'] . "')";
             $db->query($temp);
             $temp = "UPDATE {$post_table} SET parent='{$parent}' WHERE id='" . $row['id'] . "'";
             $db->query($temp);
             $cache->destroy("cache/" . $parent . "/post.cache");
         }
     }
     if (is_dir("{$main_cache_dir}" . "" . "cache/" . $row['id'])) {
         $cache->destroy_page_cache("cache/" . $row['id']);
     }
     $query = "SELECT id FROM {$post_table} WHERE id < " . $row['id'] . " ORDER BY id DESC LIMIT 1";
     $result = $db->query($query);
     $row = $result->fetch_assoc();
     $cache->destroy_page_cache("cache/" . $row['id']);
     $query = "UPDATE {$post_count_table} SET last_update='20060101' WHERE access_key='posts'";
     $db->query($query);
     $query = "UPDATE {$user_table} SET post_count = post_count+1 WHERE id='{$checked_user_id}'";
     $db->query($query);
     print '<script>alert("Image added!")</script>';
 }