Ticket #340: LoadPage2.txt

========================= trunk =============================
function LoadPage($tag, $time = "", $cache = 1) {
        // retrieve from cache
        if (!$time && $cache) {
                $page = isset($this->pageCache[$tag]) ? $this->pageCache[$tag] : null;
                if ($page=="cached_nonexistent_page") return null;
        }
        // load page
        if (!isset($page)) $page = $this->LoadSingle("select * from ".$this->config["table_prefix"]."pages where tag = '".mysql_real_escape_string($tag)."' ".($time ? "and time = '".mysql_real_escape_string($time)."'" : "and latest = 'Y'")." limit 1");
        // cache result
        if ($page && !$time) {
                $this->pageCache[$page["tag"]] = $page;
        } elseif (!$page) {
                $this->pageCache[$tag] = "cached_nonexistent_page";
        }
        return $page;
}

========================= proposal =============================
function LoadPage($tag, $time = "", $cache = 1) {
        // retrieve from cache
        if (!$time && $cache) {
                $page = isset($this->pageCache[$tag]) ? $this->pageCache[$tag] : null;
                if ($page=="cached_nonexistent_page") return null;
        }
        // load page
        $db_tag = $tag;
        if ($db_tag == RECENT_CHANGES) { $db_tag = "RecentChanges"; }
        elseif ($db_tag == RECENTLY_COMMENTED) { $db_tag = "RecentlyCommented"; }
        elseif ($db_tag == USER_SETTINGS) { $db_tag = "UserSettings"; }
        elseif ($db_tag == PAGE_INDEX) { $db_tag = "PageIndex"; }
        elseif ($db_tag == WIKKA_RELEASE_NOTES) { $db_tag = "WikkaReleaseNotes"; }
        elseif ($db_tag == WIKKA_DOCUMENTATION) { $db_tag = "WikkaDocumentation"; }
        elseif ($db_tag == WANTED_PAGES) { $db_tag = "WantedPages"; }
        elseif ($db_tag == ORPHANED_PAGES) { $db_tag = "OrphanedPages"; }
        elseif ($db_tag == TEXT_SEARCH) { $db_tag = "TextSearch"; }
        elseif ($db_tag == TEXT_SEARCH_EXPANDED) { $db_tag = "TextSearchExpanded"; }
        elseif ($db_tag == MY_PAGES) { $db_tag = "MyPages"; }
        elseif ($db_tag == MY_CHANGES) { $db_tag = "MyChanges"; }
        elseif ($db_tag == INTER_WIKI) { $db_tag = "InterWiki"; }
        elseif ($db_tag == PASSWORD_FORGOTTEN) { $db_tag = "PasswordForgotten"; }
        elseif ($db_tag == WIKI_CATEGORY) { $db_tag = "WikiCategory"; }
        elseif ($db_tag == CATEGORY_WIKI) { $db_tag = "CategoryWiki"; }
        elseif ($db_tag == CATEGORY_CATEGORY) { $db_tag = "CategoryCategory"; }
        elseif ($db_tag == FORMATTING_RULES) { $db_tag = "FormattingRules"; }
        elseif ($db_tag == HIGH_SCORES) { $db_tag = "HighScores"; }
        elseif ($db_tag == OWNED_PAGES) { $db_tag = "OwnedPages"; }
        elseif ($db_tag == SAND_BOX) { $db_tag = "SandBox"; }
        elseif ($db_tag == SYS_INFO) { $db_tag = "SysInfo"; }
        elseif ($db_tag == USER_SETTINGS) { $db_tag = "UserSettings"; }
        if (!isset($page)) $page = $this->LoadSingle("select * from ".$this->config["table_prefix"]."pages where tag = '".mysql_real_escape_string($db_tag)."' ".($time ? "and time = '".mysql_real_escape_string($time)."'" : "and latest = 'Y'")." limit 1");
        if ($page) { $page["tag"] = $tag; }
        // cache result
        if ($page && !$time) {
                $this->pageCache[$page["tag"]] = $page;
        } elseif (!$page) {
                $this->pageCache[$tag] = "cached_nonexistent_page";
        }
        return $page;
}