<?php
/* ... */

function refresh_cache() {
/* ... */
        $db->query("DELETE FROM cache");

        for ($i=0; $i<$num_languages; $i++) {
/* ... */
                $mid->setTableName("categories");
                $mid->setTableFields(array(
                        "id"            => "id",
                        "parent_id"     => "parent_id",
                        "text"          => "name",
                        "link"          => "id",
                        // "title"              => "description",
                        "title"         => "",
                        "icon"          => "",
                        "target"        => "",
                        "orderfield"    => "special_level",
                        "expanded"      => ""
                ));
                $mid->setTableName_i18n("categories_i18n");
                $mid->setTableFields_i18n(array(
                        "language"      => "lang",
                        "id"            => "category_id",
                        "text"          => "name",
                        "title"         => ""
                ));
                $mid->setPrependedUrl($CFG["wwwroot"] . "shopping/index.php?id=");
                $mid->scanTableForMenu("vermenu", $languages[$i]);
                $mid->newVerticalMenu("vermenu");
                $mid->scanTableForMenu("treemenu", $languages[$i]);
                $mid->newTreeMenu("treemenu");
                $db->query("
                        INSERT INTO cache (
                                 lang
                                ,layersmenu_header
                                ,layersmenu_vermenu
                                ,layersmenu_footer
                                ,treemenu
                        )
                        VALUES (
                                 '" . $languages[$i] . "'
                                ,'" . addslashes($mid->makeHeader()) . "'
                                ,'" . addslashes($mid->getMenu("vermenu")) . "'
                                ,'" . addslashes($mid->makeFooter()) . "'
                                ,'" . addslashes($mid->getTreeMenu("treemenu")) . "'
                        )
                ");
        }
}

/* ... */
?>