Retour à Forum d'hébergement

Base de données Web Hosting Driven questions

  • johnlynches
  • Novice
  • Novice
  • No Avatar
  • Inscription: Déc 20, 2010
  • Messages: 15
  • Status: Offline

Message Avril 28th, 2011, 4:31 pm

J'ai un site web qui est entraînée base de données mySQL (www_coinsupplyzone_com), mais il est si lent à charger la plupart du temps. Certaines pages prennent plus de 30 secondes à charger, tandis que d'autres fois la même page se charge en moins d'une seconde.

Je suis actuellement en utilisant "inmotionhosting" que ma compagnie d'hébergement. J'ai fait beaucoup de recherche avant de tirer sur la gâchette, mais je me demandais s'il y avait quelque chose comme une société d'hébergement qui se spécialise dans les sites par base de données? Ou s'il y avait un moyen d'aider à accélérer mon temps d'accès de base de données? Je connais un montant assez bonne sur le langage HTML et CSS, mais quand il s'agit de bases de données Im un débutant.

Toute aide sera appréciée, merci....... John
  • Anonymous
  • Bot
  • No Avatar
  • Inscription: 25 Feb 2008
  • Messages: ?
  • Loc: Ozzuland
  • Status: Online

Message Avril 28th, 2011, 4:31 pm

  • Bigwebmaster
  • Site Admin
  • Site Admin
  • Avatar de l’utilisateur
  • Inscription: Déc 20, 2002
  • Messages: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Message Avril 28th, 2011, 5:52 pm

Vous pouvez demander à votre hébergeur si ils savent de toute raison de votre site Web est la lenteur de chargement parfois. Il pourrait y avoir beaucoup de choses qui cause votre problème, et je vais énumérer quelques-uns d'entre eux.

La première pourrait être votre hébergeur est en faute. Il est possible que votre hébergeur a trop grand nombre d'utilisateurs sur leurs serveurs qui l'amène à s'enliser parfois faisant grief. Il se peut aussi que votre hébergeur n'a pas configuré votre base de données MySQL optimale, ce qui pourrait l'amener à avoir mauvaise performance à des moments.

Le second pourrait être que vous êtes en faute. Êtes-vous créer vos propres requêtes MySQL en écrivant le code vous-même? Ou êtes-vous utiliser un logiciel qui a déjà été écrit par quelqu'un d'autre? La raison pour laquelle je demande, c'est parce que si vous n'avez pas soin d'artisanat vos requêtes SQL, vous pouvez facilement exécuter des requêtes très peu performants que des millions de documents de recherche qui prennent beaucoup de temps à exécuter. Si vous avez écrit vos propres requêtes SQL vous pouvez passer par chacun et de les exécuter dans phpMyAdmin ou quel que soit votre méthode préférée est, et de mettre le mot EXPLIQUER en face de la requête. Cela peut vous dire toutes sortes de choses du type de recherche la requête utilise, pour le nombre d'enregistrements qu'il est d'avoir à chercher partout pour vous donner ses résultats. Il peut également vous indiquer si vous n'avez pas configuré votre index correctement ce qui pourrait accélérer vos requêtes de beaucoup. Ainsi, par exemple si j'avais une requête de ce genre qui me donne un seul résultat:

SQL Code: [ Select ]
SELECT *
FROM `phpbb_posts`
WHERE `post_id` =123456
  1. SELECT *
  2. FROM `phpbb_posts`
  3. WHERE `post_id` =123456


vous pouvez trouver des informations à ce sujet en plaçant le mot expliquer à l'avant:

SQL Code: [ Select ]
EXPLAIN SELECT *
FROM `phpbb_posts`
WHERE `post_id` =123456
  1. EXPLAIN SELECT *
  2. FROM `phpbb_posts`
  3. WHERE `post_id` =123456


Votre hébergeur peut travailler avec vous pour vous aider à diagnostiquer votre problème, ou si elles ne semblent pas comme beaucoup d'aide, vous pouvez toujours passer à un hébergeur de nouveaux, tels que Ozzu gif "title =";)" alt =" Wink ">

A quelques fils à Ozzu qui peuvent être utiles:

Limites MySQL

Quels sont beaucoup de requêtes MySQL par page?

Tableau MySQL avec des millions de Plats
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • johnlynches
  • Novice
  • Novice
  • No Avatar
  • Inscription: Déc 20, 2010
  • Messages: 15
  • Status: Offline

Message Avril 28th, 2011, 6:50 pm

J'ai contacté mon hôte en ce qui concerne cette question, ils n'arrêtent pas de dire qu'il est plus probable d'un problème avec mon internet et mes charges site amende à leur fin. Qu'est-ce qui n'a pas de sens cependant, c'est que pendant le jour les pages prennent une éternité à charger, mais la nuit, ils chargent en moins d'une seconde ou deux.

J'ai fait ce qui suit dans mon panneau de contrôle d'hébergement: «Comprimer les types MIME spécifié" (text / html texte / texte / xml), mais c'est à peu près tout ce que je sais comment faire.

Je n'ai pas écrit le code moi-même, il est de mon ViArt panier qui a fait cela pour moi. Ill vérifier ces autres fils, merci.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • Avatar de l’utilisateur
  • Inscription: Déc 20, 2002
  • Messages: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Message Avril 28th, 2011, 10:57 pm

Juste curieux, votre site Web obtenir beaucoup de trafic?

Typiquement les serveurs web ne obtenir plus occupés pendant la journée, mais si votre site ne reçoit pas une grande quantité de trafic, cela ne signifie pas quelqu'un d'autre sur votre serveur n'est pas ce qui est enlisement choses. Il est vraiment difficile de deviner sans se faire sur leur serveur et le diagnostic de ce qui se passe, il pourrait y avoir de nombreuses raisons l'origine de cette.

Comme la mesure où il est de votre connexion locale, qui est toujours aussi possible. Disons par exemple vous avez une connexion par câble, de sa possible que pendant la journée vous avez quelques personnes dans votre région qui sont utiliser en totalité la bande passante disponible ce qui rend les choses apparaissent plus lentement pour vous. Là encore, c'est toute spéculation juste, il pourrait très bien être votre hôte trop. Un bon moyen de tester cela, essayez de visiter certains sites Web d'autres lorsque votre site apparaît lente et voir si l'Internet est lent pour vous, ou tout simplement votre site Web. Si vous n'avez que votre site web, il est plus probable que votre hébergeur, ou quelque chose de mal avec votre site web.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • johnlynches
  • Novice
  • Novice
  • No Avatar
  • Inscription: Déc 20, 2010
  • Messages: 15
  • Status: Offline

Message Avril 29th, 2011, 8:34 am

Mon site ne reçoit pas plus de 20 visiteurs par jour en ce moment, il faut donc la charge du serveur pendant la journée de jouer avec moi.

Je vais voir si je peux créer des pages HTML statiques avec ma base de données qui peuvent accélérer les choses pour moi. Je n'ai que trop de requêtes en cours d'exécution par page.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • Avatar de l’utilisateur
  • Inscription: Déc 20, 2002
  • Messages: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Message Avril 29th, 2011, 5:15 pm

Ayant trop de requêtes en cours d'exécution par page peut vraiment lent chargement d'une page vers le bas. Plusieurs fois, simplement en train de refaire vos requêtes SQL et d'essayer de rendre les choses plus efficaces, vous pouvez réduire le nombre sont en cours d'exécution par page. Par exemple, il ya longtemps Ozzu avait environ 30 appels SQL par page, et par tout refaire et plus intelligent sur la façon dont chaque requête a été appelé, je me souviens que j'étais capable de descendre à environ 10 par page, et tous de la même l'information était encore récupérées.

Spots à surveiller sont des boucles qui appellent la même requête à plusieurs reprises. Ainsi, par exemple si vous aviez un tableau de 10 valeurs dont vous voulez récupérer les résultats via SQL pour chaque valeur, vous pouvez exécuter une boucle et course de 10 des états SQL, ou vous pouvez exécuter une instruction SQL et la recherche de tous les identifiants dans cette déclaration et les mêmes résultats. Habituellement, la seconde manière est beaucoup plus efficace.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • johnlynches
  • Novice
  • Novice
  • No Avatar
  • Inscription: Déc 20, 2010
  • Messages: 15
  • Status: Offline

Message Avril 29th, 2011, 5:42 pm

Je pense que c'est exactement mon problème, mon programmeurs m'a dit que mon site a jusqu'à quelques centaines de requêtes par page. Je ne sais pas si c'est possible pour moi de "non-loop" ma base de données de raccourcir les requêtes, ou même par où commencer.

J'ai placé un exemple de la base de données que j'utilise pour mon panier sur mon ftp:

www_coinsupplyzone_com / database_example.sql

Si l'un de vous pourrait regarder et me dire si il est possible de «condenser» il, je serais très reconnaissant. Alors je peux me renseigner en détail sur la façon d'espérer réduire certains de ces requêtes.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • Avatar de l’utilisateur
  • Inscription: Déc 20, 2002
  • Messages: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Message Avril 30th, 2011, 9:55 am

Une partie du problème pourrait être la structure de votre base de données, merci pour l'affichage que. Toutefois, en général le problème pour combien de requêtes SQL que vous exécutez n'est pas dû à votre base de données elle-même, mais comment vous êtes la création de requêtes dans votre code de programmation d'accès et de récupérer les résultats de votre base de données. Avez-vous un exemple de partie du code qui s'exécute une de vos pages lente qui comprend certaines requêtes SQL?
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • johnlynches
  • Novice
  • Novice
  • No Avatar
  • Inscription: Déc 20, 2010
  • Messages: 15
  • Status: Offline

Message Avril 30th, 2011, 3:02 pm

Voici deux morceaux de code à partir de mon site. La première est d'appeler les désignations des catégories et l'autre pour appeler la liste des catégories:

Code: [ Select ]
<?php

    $desc_image = get_setting_value($vars, "category_description_image", 3);
    $desc_type = get_setting_value($vars, "category_description_type", 2);

    $sql = " SELECT * ";
    $sql .= " FROM " . $table_prefix . "categories ";
    $sql .= " WHERE category_id = " . $db->tosql($category_id, INTEGER);
    $db->query($sql);
    if ($db->next_record())
    {
        $category_name = get_translation($db->f("category_name"));
        $description = "";
        if ($desc_type == 2) {
            $description = get_translation($db->f("full_description"));
        } elseif ($desc_type == "full_description_2" || $desc_type == "full_description2") {
            $description = get_translation($db->f("full_description_2"));
        } elseif ($desc_type == 1) {
            $description = get_translation($db->f("short_description"));
        } elseif ($desc_type == "feature_1" || $desc_type == "feature1") {
            $description = get_translation($db->f("feature_1"));
        } elseif ($desc_type == "feature_2" || $desc_type == "feature2") {
            $description = get_translation($db->f("feature_2"));
        } elseif ($desc_type == "feature_3" || $desc_type == "feature3") {
            $description = get_translation($db->f("feature_3"));
        } elseif ($desc_type == "feature_4" || $desc_type == "feature4") {
            $description = get_translation($db->f("feature_4"));
        } elseif ($desc_type == "feature_5" || $desc_type == "feature5") {
            $description = get_translation($db->f("feature_5"));
        } elseif ($desc_type == "feature_6" || $desc_type == "feature6") {
            $description = get_translation($db->f("feature_6"));
        } elseif ($desc_type == "feature_7" || $desc_type == "feature7") {
            $description = get_translation($db->f("feature_7"));
        }
        $image = ""; $image_alt = "";
        if ($desc_image == 3) {
            $image   = $db->f("image_large");
            $image_alt = get_translation($db->f("image_large_alt"));
        } elseif ($desc_image == 2) {
            $image   = $db->f("image");
            $image_alt = get_translation($db->f("image_alt"));
        }

        if (!strlen($image)) {
            $image_exists = false;
        } elseif (!image_exists($image)) {
            $image_exists = false;
        } else {
            $image_exists = true;
        }

        if (strlen($description) || $image_exists)
        {
            $html_template = get_setting_value($block, "html_template", "block_category_description.html");
         $t->set_file("block_body", $html_template);

            if ($image_exists) {
                if (preg_match("/^http\:\/\//", $image)) {
                    $image_size = "";
                } else {
                    $image_size = @GetImageSize($image);
                    if (isset($restrict_categories_images) && $restrict_categories_images) { $image = "image_show.php?category_id=".$category_id."&type=large"; }
                }
                if (!strlen($image_alt)) { $image_alt = $category_name; }
                $t->set_var("alt", htmlspecialchars($image_alt));
                $t->set_var("src", htmlspecialchars($image));
                if (is_array($image_size)) {
                    $t->set_var("width", "width=\"" . $image_size[0] . "\"");
                    $t->set_var("height", "height=\"" . $image_size[1] . "\"");
                } else {
                    $t->set_var("width", "");
                    $t->set_var("height", "");
                }
                $t->sparse("image_large_block", false);
            } else {
                $t->set_var("image_large_block", "");
            }
     
            $t->set_var("category_name", $category_name);
            $t->set_var("full_description", $description);

            $block_parsed = true;
            $t->parse("block_body", false);
        }
    }

?>
  1. <?php
  3.     $desc_image = get_setting_value($vars, "category_description_image", 3);
  4.     $desc_type = get_setting_value($vars, "category_description_type", 2);
  6.     $sql = " SELECT * ";
  7.     $sql .= " FROM " . $table_prefix . "categories ";
  8.     $sql .= " WHERE category_id = " . $db->tosql($category_id, INTEGER);
  9.     $db->query($sql);
  10.     if ($db->next_record())
  11.     {
  12.         $category_name = get_translation($db->f("category_name"));
  13.         $description = "";
  14.         if ($desc_type == 2) {
  15.             $description = get_translation($db->f("full_description"));
  16.         } elseif ($desc_type == "full_description_2" || $desc_type == "full_description2") {
  17.             $description = get_translation($db->f("full_description_2"));
  18.         } elseif ($desc_type == 1) {
  19.             $description = get_translation($db->f("short_description"));
  20.         } elseif ($desc_type == "feature_1" || $desc_type == "feature1") {
  21.             $description = get_translation($db->f("feature_1"));
  22.         } elseif ($desc_type == "feature_2" || $desc_type == "feature2") {
  23.             $description = get_translation($db->f("feature_2"));
  24.         } elseif ($desc_type == "feature_3" || $desc_type == "feature3") {
  25.             $description = get_translation($db->f("feature_3"));
  26.         } elseif ($desc_type == "feature_4" || $desc_type == "feature4") {
  27.             $description = get_translation($db->f("feature_4"));
  28.         } elseif ($desc_type == "feature_5" || $desc_type == "feature5") {
  29.             $description = get_translation($db->f("feature_5"));
  30.         } elseif ($desc_type == "feature_6" || $desc_type == "feature6") {
  31.             $description = get_translation($db->f("feature_6"));
  32.         } elseif ($desc_type == "feature_7" || $desc_type == "feature7") {
  33.             $description = get_translation($db->f("feature_7"));
  34.         }
  35.         $image = ""; $image_alt = "";
  36.         if ($desc_image == 3) {
  37.             $image   = $db->f("image_large");
  38.             $image_alt = get_translation($db->f("image_large_alt"));
  39.         } elseif ($desc_image == 2) {
  40.             $image   = $db->f("image");
  41.             $image_alt = get_translation($db->f("image_alt"));
  42.         }
  44.         if (!strlen($image)) {
  45.             $image_exists = false;
  46.         } elseif (!image_exists($image)) {
  47.             $image_exists = false;
  48.         } else {
  49.             $image_exists = true;
  50.         }
  52.         if (strlen($description) || $image_exists)
  53.         {
  54.             $html_template = get_setting_value($block, "html_template", "block_category_description.html");
  55.          $t->set_file("block_body", $html_template);
  57.             if ($image_exists) {
  58.                 if (preg_match("/^http\:\/\//", $image)) {
  59.                     $image_size = "";
  60.                 } else {
  61.                     $image_size = @GetImageSize($image);
  62.                     if (isset($restrict_categories_images) && $restrict_categories_images) { $image = "image_show.php?category_id=".$category_id."&type=large"; }
  63.                 }
  64.                 if (!strlen($image_alt)) { $image_alt = $category_name; }
  65.                 $t->set_var("alt", htmlspecialchars($image_alt));
  66.                 $t->set_var("src", htmlspecialchars($image));
  67.                 if (is_array($image_size)) {
  68.                     $t->set_var("width", "width=\"" . $image_size[0] . "\"");
  69.                     $t->set_var("height", "height=\"" . $image_size[1] . "\"");
  70.                 } else {
  71.                     $t->set_var("width", "");
  72.                     $t->set_var("height", "");
  73.                 }
  74.                 $t->sparse("image_large_block", false);
  75.             } else {
  76.                 $t->set_var("image_large_block", "");
  77.             }
  78.      
  79.             $t->set_var("category_name", $category_name);
  80.             $t->set_var("full_description", $description);
  82.             $block_parsed = true;
  83.             $t->parse("block_body", false);
  84.         }
  85.     }
  87. ?>


Code: [ Select ]
<?php

    include_once("./includes/products_functions.php");

    include_once("./messages/" . $language_code . "/cart_messages.php");
    include_once("./messages/" . $language_code . "/reviews_messages.php");
    include_once("./messages/" . $language_code . "/download_messages.php");

    $user_id = get_session("session_user_id");        
    $user_info = get_session("session_user_info");
    $user_type_id = get_setting_value($user_info, "user_type_id", "");

    $friendly_urls = get_setting_value($settings, "friendly_urls", 0);
    $friendly_extension = get_setting_value($settings, "friendly_extension", "");
    $columns = get_setting_value($vars, "categories_columns", 1);
    $categories_type = get_setting_value($vars, "categories_type");

    $category_id = get_param("category_id");
    $search_category_id = get_param("search_category_id");
    $search_string = get_param("search_string");
    $is_search = strlen($search_string);

    if ($is_search && $search_category_id) { $category_id = $search_category_id; }

    $item_id = get_param("item_id");
    if (!strlen($category_id)) {
        if (strlen($item_id)) {
            $category_id = get_db_value("SELECT category_id FROM " . $table_prefix . "items_categories where item_id=".$db->tosql($item_id, INTEGER));
        } else {
            $category_id = "0";
        }
    }

    $category_id = intval($category_id);
    
    $t->set_var("products_href",  get_custom_friendly_url("products.php"));
    $t->set_var("list_href",    get_custom_friendly_url("products.php"));
    $t->set_var("details_href",   get_custom_friendly_url("product_details.php"));
    $t->set_var("top_category_name",PRODUCTS_TITLE);
    $t->set_var("category_rss", "");

    $list_page = get_custom_friendly_url("products.php");
    $list_url = new VA_URL($list_page);

    $categories_image = get_setting_value($vars, "categories_image");
    
    if ($categories_type == 1 || $categories_type == 2) {
        if (file_exists("images/".$settings["style_name"]."/category_image.gif")) {
            $image_tree_top = "images/".$settings["style_name"]."/category_image.gif";
        } else {
            $image_tree_top = "images/category_image.gif";
        }
        $html_template = get_setting_value($block, "html_template", "block_categories_catalog.html");
     $t->set_file("block_body", $html_template);
        $t->set_var("catalog_sub",     "");
        $t->set_var("catalog_sub_more",  "");
        $t->set_var("catalog_rows",    "");
        $t->set_var("catalog_top",     "");
        $t->set_var("catalog_description", "");

        $categories_ids = VA_Categories::find_all_ids("c.parent_category_id=" . $db->tosql($category_id, INTEGER), VIEW_CATEGORIES_PERM);
        if (!$categories_ids) return;
        $allowed_categories_ids = VA_Categories::find_all_ids("c.parent_category_id=" . $db->tosql($category_id, INTEGER), VIEW_CATEGORIES_ITEMS_PERM);
                
        if ($categories_type == 2) {
            $sub_categories_ids = VA_Categories::find_all_ids("c.parent_category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")", VIEW_CATEGORIES_PERM);
            if (!$sub_categories_ids)
                $categories_type = 1;
        }

        if ($categories_type == 1) {
            $sql = " SELECT category_id AS top_category_id, category_name AS top_category_name, a_title AS top_a_title, ";
            $sql .= " short_description, friendly_url AS top_friendly_url, ";
            $sql .= " image, image_alt, image_large, image_large_alt ";
            $sql .= " FROM " . $table_prefix . "categories ";
            $sql .= " WHERE category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")";    
            $sql .= " ORDER BY category_order, category_name ";
        } else {
            // show categories as catalog
            $allowed_sub_categories_ids = VA_Categories::find_all_ids("c.parent_category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")", VIEW_CATEGORIES_ITEMS_PERM);                        
            $sql = " SELECT c.category_id AS top_category_id,c.category_name AS top_category_name, ";
            $sql .= " c.friendly_url AS top_friendly_url, c.a_title AS top_a_title, ";
            $sql .= " c.image, c.image_alt, c.image_large, c.image_large_alt, ";
            $sql .= " s.category_id AS sub_category_id,s.category_name AS sub_category_name, ";
            $sql .= " s.friendly_url AS sub_friendly_url, s.a_title AS sub_a_title ";
            $sql .= " FROM (" . $table_prefix . "categories c ";
            $sql .= " LEFT JOIN " . $table_prefix . "categories s ";            
            if ($sub_categories_ids) {
                $sql .= " ON (c.category_id=s.parent_category_id ";            
                $sql .= " AND s.category_id IN (" . $db->tosql($sub_categories_ids, INTEGERS_LIST) . ")))";
            } else {
                $sql .= " ON c.category_id=s.parent_category_id) ";            
            }
            $sql .= " WHERE c.category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")";
            $sql .= " ORDER BY c.category_order, c.category_name, c.category_id, s.category_order, s.category_name ";
        }
        $db->query($sql);
        if ($db->next_record()) {
            $category_number = 0;
            $is_subcategories = true;
            $shown_sub_categories = get_setting_value($vars, "categories_subs");
            $catalog_top_number = 0;
            $catalog_sub_number = 0;
            $column_width = intval(100 / $columns);
            $t->set_var("column_width", $column_width . "%");
            do {
                $category_number++;
                $catalog_sub_number++;
                $top_category_id = $db->f("top_category_id");
                $top_category_name = get_translation($db->f("top_category_name"));
                $top_a_title = get_translation($db->f("top_a_title"));
                $top_friendly_url = $db->f("top_friendly_url");
                $sub_category_id = $db->f("sub_category_id");
                $sub_category_name = get_translation($db->f("sub_category_name"));
                $sub_a_title = get_translation($db->f("sub_a_title"));
                $sub_friendly_url = $db->f("sub_friendly_url");
                if ($categories_image == 2) {
                    $category_image = $db->f("image");
                    $image_alt = get_translation($db->f("image_alt"));
                } else if ($categories_image == 3) {
                    $category_image = $db->f("image_large");
                    $image_alt = get_translation($db->f("image_large_alt"));
                } else {
                    $category_image = $image_tree_top;
                    $image_alt = get_translation($db->f("image_alt"));
                }
    
                $t->set_var("catalog_top_id", $top_category_id);
                $t->set_var("catalog_top_name", htmlspecialchars($top_category_name));
                $t->set_var("top_a_title", htmlspecialchars($top_a_title));
                if ($categories_type == 2){
                    $t->set_var("catalog_sub_id",  $sub_category_id);
                    $t->set_var("catalog_sub_name", htmlspecialchars($sub_category_name));
                    $t->set_var("sub_a_title", htmlspecialchars($sub_a_title));
                } else {
                     if (strlen($db->f("short_description"))) {
                        $t->set_var("short_description", get_translation($db->f("short_description")));
                        $t->parse("catalog_description", false);
                    } else {
                        $t->set_var("catalog_description", "");
                    }
                }
    
                $is_next_record = $db->next_record();
                $is_new_top = ($top_category_id != $db->f("top_category_id"));
    
                if ($categories_type == 2){
                    if (intval($shown_sub_categories) >= $catalog_sub_number || $shown_sub_categories == 0)
                    {
                        if ($sub_category_id && (!$allowed_sub_categories_ids || !in_array($sub_category_id, $allowed_sub_categories_ids))) {
                            $t->set_var("restricted_sub_class", " restrictedSubCategory");
                            $t->sparse("restricted_sub_image", false);
                        } else {
                            $t->set_var("restricted_sub_class", "");
                            $t->set_var("restricted_sub_image", "");
                        }
                        if ($friendly_urls && $sub_friendly_url) {
                            $list_url->remove_parameter("category_id");
                            $t->set_var("list_url", htmlspecialchars($list_url->get_url($sub_friendly_url. $friendly_extension)));
                        } else {
                            $list_url->add_parameter("category_id", CONSTANT, $sub_category_id);
                            $t->set_var("list_url", htmlspecialchars($list_url->get_url($list_page)));
                        }
    
                        if ($category_id == $sub_category_id) {
                            $t->set_var("class_sub_selected", "selectedsubCategory");
                        } else {
                            $t->set_var("class_sub_selected", "subCategory");
                        }
                            
                        if ($is_next_record && !$is_new_top) {
                            $t->parse("catalog_sub_separator", false);
                        } else {
                            $t->set_var("catalog_sub_separator", "");
                        }
                        $t->parse("catalog_sub", true);
                    } elseif (($shown_sub_categories + 1) == $catalog_sub_number) {
                        if ($friendly_urls && $top_friendly_url) {
                            $list_url->remove_parameter("category_id");
                            $t->set_var("list_url", htmlspecialchars($list_url->get_url($top_friendly_url . $friendly_extension)));
                        } else {
                            $list_url->add_parameter("category_id", CONSTANT, $top_category_id);
                            $t->set_var("list_url", htmlspecialchars($list_url->get_url($list_page)));
                        }
    
                        $t->parse("catalog_sub_more", false);
                    }
                }
    
                if ($is_new_top) {
                    $catalog_top_number++;
    
                    if ($friendly_urls && $top_friendly_url) {
                        $list_url->remove_parameter("category_id");
                        $t->set_var("list_url", htmlspecialchars($list_url->get_url($top_friendly_url . $friendly_extension)));
                    } else {
                        $list_url->add_parameter("category_id", CONSTANT, $top_category_id);
                        $t->set_var("list_url", htmlspecialchars($list_url->get_url($list_page)));
                    }
    
                    if ($category_image)
                    {
                        if (preg_match("/^http\:\/\//", $category_image)) {
                            $image_size = "";
                        } else {
                            $image_size = @GetImageSize($category_image);
                            if (isset($restrict_categories_images) && $restrict_categories_images) {
                                $category_image = "image_show.php?category_id=".$top_category_id;
                            }
                        }
                        if (!strlen($image_alt)) { $image_alt = $top_category_name; }
                            $t->set_var("alt", htmlspecialchars($image_alt));
                            $t->set_var("src", htmlspecialchars($category_image));
                        if (is_array($image_size)) {
                            $t->set_var("width", "width=\"" . $image_size[0] . "\"");
                            $t->set_var("height", "height=\"" . $image_size[1] . "\"");
                        } else {
                            $t->set_var("width", "");
                            $t->set_var("height", "");
                        }
                        $t->parse("catalog_image", false);
                    } else {
                        $t->set_var("catalog_image", "");
                    }
    
                    if (!$allowed_categories_ids || !in_array($top_category_id, $allowed_categories_ids)) {
                        $t->set_var("restricted_class", " restrictedCategory");
                        $t->sparse("restricted_image", false);
                    } else {
                        $t->set_var("restricted_class", "");
                        $t->set_var("restricted_image", "");
                    }
                    
                    if ($category_id == $top_category_id) {
                        $t->set_var("class_top_selected", "selectedtopCategory");
                    } else {
                        $t->set_var("class_top_selected", "topCategory");
                    }                        
                        
                    $t->parse("catalog_top");
                    $t->set_var("catalog_sub", "");
                    $t->set_var("catalog_sub_more", "");
                    if ($catalog_top_number % $columns == 0) {
                        $t->parse("catalog_rows");
                        $t->set_var("catalog_top", "");
                    }
                    $catalog_sub_number = 0;
                }
    
            } while ($is_next_record);
    
            if ($catalog_top_number % $columns != 0) {
                $t->parse("catalog_rows");
            }
    
            $block_parsed = true;
            $t->parse("block_body", false);
        }
    } else if ($categories_type == 5) {
        // chained list type
        $is_ajax = get_param("is_ajax");
        $level = get_param("level");
        $pcategory = get_param("pcategory");
        if (!$pcategory) { $pcategory = 0; }

        $categories = array();

        $sql = " SELECT category_id, category_name FROM " . $table_prefix . "categories ";
        $sql .= " WHERE parent_category_id=" . $db->tosql($pcategory, INTEGER);
        $sql .= " ORDER BY category_order ";
        $db->query($sql);
        if ($db->next_record())    {
            do {
                $category_id = $db->f("category_id");
                $categories[$category_id] = get_translation($db->f("category_name"));
            } while ($db->next_record());
        }
        
        if ($is_ajax) {
            // json_encode for PHP4
            if (sizeof($categories) > 0) {
                echo "{";
                foreach($categories as $category_id => $category_name) {
                    echo '"' . $category_id . '":';
                    echo '"' . str_replace('"', '\"', $category_name) . '",';
                }
                echo "}";
            }
            exit;
        } else {
        
            $html_template = get_setting_value($block, "html_template", "block_categories_chained_menu.html");
         $t->set_file("block_body", $html_template);
            $t->set_var("products_href", get_custom_friendly_url("products.php"));
        
            foreach($categories as $category_id => $category_name) {
                $t->set_var("category_id", $category_id);    
                $t->set_var("category_name", htmlspecialchars($category_name));
                $t->parse("category_option");
            }
 
            $block_parsed = true;
            $t->parse("block_body", false);
        }

    } else {// list type
        $html_template = get_setting_value($block, "html_template", "block_categories_list.html");
     $t->set_file("block_body", $html_template);
        $t->set_var("categories_rows", "");
        $t->set_var("categories",   "");

        $active_category_path = "0";
        $not = false;
        if ($categories_type == 4) { // Tree-type structure
            $sql = " SELECT category_path ";
            $sql .= " FROM " . $table_prefix . "categories ";
            $sql .= " WHERE category_id=" . $db->tosql($category_id, INTEGER);
            $db->query($sql);
            if ($db->next_record()) {
                $active_category_path = $db->f("category_path");
                $active_category_path .= $category_id;
            }
            $categories_ids = VA_Categories::find_all_ids("c.parent_category_id IN (" . $db->tosql($active_category_path, INTEGERS_LIST) . ")", VIEW_CATEGORIES_PERM);
            $allowed_categories_ids = VA_Categories::find_all_ids("c.parent_category_id IN (" . $db->tosql($active_category_path, INTEGERS_LIST) . ")", VIEW_CATEGORIES_ITEMS_PERM);
        } else {
            $not = true;
            $categories_ids     = VA_Categories::find_all_ids(array('not' => 1), VIEW_CATEGORIES_PERM);
            $allowed_categories_ids = VA_Categories::find_all_ids(array('not' => 1), VIEW_CATEGORIES_ITEMS_PERM);
        }

        if (!$not && !$categories_ids) return;
        
        $categories = array();
        $sql = " SELECT category_id, category_name, a_title, friendly_url, ";
        $sql .= " short_description, image, image_alt, image_large, image_large_alt, parent_category_id ";        
        $sql .= " FROM " . $table_prefix . "categories ";
        if ($not) {
            if ($categories_ids) {
                $sql .= " WHERE category_id NOT IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ") ";
            }
            $sql .= " ORDER BY parent_category_id, category_order, category_name ";
            $db->RecordsPerPage = 1000;
        } else {
            $sql .= " WHERE category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ") ";
            $sql .= " ORDER BY category_order, category_name ";
        }
        $db->query($sql);
        while ($db->next_record()) {
            $cur_category_id = $db->f("category_id");
            $category_name = get_translation($db->f("category_name"));
            $a_title = get_translation($db->f("a_title"));
            $friendly_url = $db->f("friendly_url");
            $short_description = get_translation($db->f("short_description"));

            $image = $db->f("image");
            $image_alt = get_translation($db->f("image_alt"));
            $parent_category_id = $db->f("parent_category_id");
            $categories[$cur_category_id]["parent_id"] = $parent_category_id;
            $categories[$cur_category_id]["category_name"] = $category_name;
            $categories[$cur_category_id]["a_title"] = $a_title;
            $categories[$cur_category_id]["friendly_url"] = $friendly_url;
            $categories[$cur_category_id]["short_description"] = $short_description;
            $categories[$cur_category_id]["image"] = $image;
            $categories[$cur_category_id]["image_alt"] = $image_alt;
            $categories[$cur_category_id]["image_large"] = $db->f("image_large");
            $categories[$cur_category_id]["image_large_alt"] = get_translation($db->f("image_large_alt"));
            if ($not) {
                if ($allowed_categories_ids && in_array($cur_category_id, $allowed_categories_ids)) {
                    $categories[$cur_category_id]["allowed"] = false;
                } else {
                    $categories[$cur_category_id]["allowed"] = true;
                }
            } else {
                if (!$allowed_categories_ids || !in_array($cur_category_id, $allowed_categories_ids)) {
                    $categories[$cur_category_id]["allowed"] = false;
                } else {
                    $categories[$cur_category_id]["allowed"] = true;
                }
            }
            $categories[$parent_category_id]["subs"][] = $cur_category_id;
        }

        if (sizeof($categories) > 0 && isset($categories[0]))
        {
            $category_number = 0;
            $column_width = intval(100 / $columns);
            $t->set_var("column_width", $column_width . "%");

            set_categories(0, 0, $columns, 0, $categories_image);

            if ($category_number % $columns != 0) {
                $t->parse("categories_rows");
            }

            $block_parsed = true;
            $t->parse("block_body", false);
        }
    }


?>
  1. <?php
  3.     include_once("./includes/products_functions.php");
  5.     include_once("./messages/" . $language_code . "/cart_messages.php");
  6.     include_once("./messages/" . $language_code . "/reviews_messages.php");
  7.     include_once("./messages/" . $language_code . "/download_messages.php");
  9.     $user_id = get_session("session_user_id");        
  10.     $user_info = get_session("session_user_info");
  11.     $user_type_id = get_setting_value($user_info, "user_type_id", "");
  13.     $friendly_urls = get_setting_value($settings, "friendly_urls", 0);
  14.     $friendly_extension = get_setting_value($settings, "friendly_extension", "");
  15.     $columns = get_setting_value($vars, "categories_columns", 1);
  16.     $categories_type = get_setting_value($vars, "categories_type");
  18.     $category_id = get_param("category_id");
  19.     $search_category_id = get_param("search_category_id");
  20.     $search_string = get_param("search_string");
  21.     $is_search = strlen($search_string);
  23.     if ($is_search && $search_category_id) { $category_id = $search_category_id; }
  25.     $item_id = get_param("item_id");
  26.     if (!strlen($category_id)) {
  27.         if (strlen($item_id)) {
  28.             $category_id = get_db_value("SELECT category_id FROM " . $table_prefix . "items_categories where item_id=".$db->tosql($item_id, INTEGER));
  29.         } else {
  30.             $category_id = "0";
  31.         }
  32.     }
  34.     $category_id = intval($category_id);
  35.     
  36.     $t->set_var("products_href",  get_custom_friendly_url("products.php"));
  37.     $t->set_var("list_href",    get_custom_friendly_url("products.php"));
  38.     $t->set_var("details_href",   get_custom_friendly_url("product_details.php"));
  39.     $t->set_var("top_category_name",PRODUCTS_TITLE);
  40.     $t->set_var("category_rss", "");
  42.     $list_page = get_custom_friendly_url("products.php");
  43.     $list_url = new VA_URL($list_page);
  45.     $categories_image = get_setting_value($vars, "categories_image");
  46.     
  47.     if ($categories_type == 1 || $categories_type == 2) {
  48.         if (file_exists("images/".$settings["style_name"]."/category_image.gif")) {
  49.             $image_tree_top = "images/".$settings["style_name"]."/category_image.gif";
  50.         } else {
  51.             $image_tree_top = "images/category_image.gif";
  52.         }
  53.         $html_template = get_setting_value($block, "html_template", "block_categories_catalog.html");
  54.      $t->set_file("block_body", $html_template);
  55.         $t->set_var("catalog_sub",     "");
  56.         $t->set_var("catalog_sub_more",  "");
  57.         $t->set_var("catalog_rows",    "");
  58.         $t->set_var("catalog_top",     "");
  59.         $t->set_var("catalog_description", "");
  61.         $categories_ids = VA_Categories::find_all_ids("c.parent_category_id=" . $db->tosql($category_id, INTEGER), VIEW_CATEGORIES_PERM);
  62.         if (!$categories_ids) return;
  63.         $allowed_categories_ids = VA_Categories::find_all_ids("c.parent_category_id=" . $db->tosql($category_id, INTEGER), VIEW_CATEGORIES_ITEMS_PERM);
  64.                 
  65.         if ($categories_type == 2) {
  66.             $sub_categories_ids = VA_Categories::find_all_ids("c.parent_category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")", VIEW_CATEGORIES_PERM);
  67.             if (!$sub_categories_ids)
  68.                 $categories_type = 1;
  69.         }
  71.         if ($categories_type == 1) {
  72.             $sql = " SELECT category_id AS top_category_id, category_name AS top_category_name, a_title AS top_a_title, ";
  73.             $sql .= " short_description, friendly_url AS top_friendly_url, ";
  74.             $sql .= " image, image_alt, image_large, image_large_alt ";
  75.             $sql .= " FROM " . $table_prefix . "categories ";
  76.             $sql .= " WHERE category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")";    
  77.             $sql .= " ORDER BY category_order, category_name ";
  78.         } else {
  79.             // show categories as catalog
  80.             $allowed_sub_categories_ids = VA_Categories::find_all_ids("c.parent_category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")", VIEW_CATEGORIES_ITEMS_PERM);                        
  81.             $sql = " SELECT c.category_id AS top_category_id,c.category_name AS top_category_name, ";
  82.             $sql .= " c.friendly_url AS top_friendly_url, c.a_title AS top_a_title, ";
  83.             $sql .= " c.image, c.image_alt, c.image_large, c.image_large_alt, ";
  84.             $sql .= " s.category_id AS sub_category_id,s.category_name AS sub_category_name, ";
  85.             $sql .= " s.friendly_url AS sub_friendly_url, s.a_title AS sub_a_title ";
  86.             $sql .= " FROM (" . $table_prefix . "categories c ";
  87.             $sql .= " LEFT JOIN " . $table_prefix . "categories s ";            
  88.             if ($sub_categories_ids) {
  89.                 $sql .= " ON (c.category_id=s.parent_category_id ";            
  90.                 $sql .= " AND s.category_id IN (" . $db->tosql($sub_categories_ids, INTEGERS_LIST) . ")))";
  91.             } else {
  92.                 $sql .= " ON c.category_id=s.parent_category_id) ";            
  93.             }
  94.             $sql .= " WHERE c.category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ")";
  95.             $sql .= " ORDER BY c.category_order, c.category_name, c.category_id, s.category_order, s.category_name ";
  96.         }
  97.         $db->query($sql);
  98.         if ($db->next_record()) {
  99.             $category_number = 0;
  100.             $is_subcategories = true;
  101.             $shown_sub_categories = get_setting_value($vars, "categories_subs");
  102.             $catalog_top_number = 0;
  103.             $catalog_sub_number = 0;
  104.             $column_width = intval(100 / $columns);
  105.             $t->set_var("column_width", $column_width . "%");
  106.             do {
  107.                 $category_number++;
  108.                 $catalog_sub_number++;
  109.                 $top_category_id = $db->f("top_category_id");
  110.                 $top_category_name = get_translation($db->f("top_category_name"));
  111.                 $top_a_title = get_translation($db->f("top_a_title"));
  112.                 $top_friendly_url = $db->f("top_friendly_url");
  113.                 $sub_category_id = $db->f("sub_category_id");
  114.                 $sub_category_name = get_translation($db->f("sub_category_name"));
  115.                 $sub_a_title = get_translation($db->f("sub_a_title"));
  116.                 $sub_friendly_url = $db->f("sub_friendly_url");
  117.                 if ($categories_image == 2) {
  118.                     $category_image = $db->f("image");
  119.                     $image_alt = get_translation($db->f("image_alt"));
  120.                 } else if ($categories_image == 3) {
  121.                     $category_image = $db->f("image_large");
  122.                     $image_alt = get_translation($db->f("image_large_alt"));
  123.                 } else {
  124.                     $category_image = $image_tree_top;
  125.                     $image_alt = get_translation($db->f("image_alt"));
  126.                 }
  127.     
  128.                 $t->set_var("catalog_top_id", $top_category_id);
  129.                 $t->set_var("catalog_top_name", htmlspecialchars($top_category_name));
  130.                 $t->set_var("top_a_title", htmlspecialchars($top_a_title));
  131.                 if ($categories_type == 2){
  132.                     $t->set_var("catalog_sub_id",  $sub_category_id);
  133.                     $t->set_var("catalog_sub_name", htmlspecialchars($sub_category_name));
  134.                     $t->set_var("sub_a_title", htmlspecialchars($sub_a_title));
  135.                 } else {
  136.                      if (strlen($db->f("short_description"))) {
  137.                         $t->set_var("short_description", get_translation($db->f("short_description")));
  138.                         $t->parse("catalog_description", false);
  139.                     } else {
  140.                         $t->set_var("catalog_description", "");
  141.                     }
  142.                 }
  143.     
  144.                 $is_next_record = $db->next_record();
  145.                 $is_new_top = ($top_category_id != $db->f("top_category_id"));
  146.     
  147.                 if ($categories_type == 2){
  148.                     if (intval($shown_sub_categories) >= $catalog_sub_number || $shown_sub_categories == 0)
  149.                     {
  150.                         if ($sub_category_id && (!$allowed_sub_categories_ids || !in_array($sub_category_id, $allowed_sub_categories_ids))) {
  151.                             $t->set_var("restricted_sub_class", " restrictedSubCategory");
  152.                             $t->sparse("restricted_sub_image", false);
  153.                         } else {
  154.                             $t->set_var("restricted_sub_class", "");
  155.                             $t->set_var("restricted_sub_image", "");
  156.                         }
  157.                         if ($friendly_urls && $sub_friendly_url) {
  158.                             $list_url->remove_parameter("category_id");
  159.                             $t->set_var("list_url", htmlspecialchars($list_url->get_url($sub_friendly_url. $friendly_extension)));
  160.                         } else {
  161.                             $list_url->add_parameter("category_id", CONSTANT, $sub_category_id);
  162.                             $t->set_var("list_url", htmlspecialchars($list_url->get_url($list_page)));
  163.                         }
  164.     
  165.                         if ($category_id == $sub_category_id) {
  166.                             $t->set_var("class_sub_selected", "selectedsubCategory");
  167.                         } else {
  168.                             $t->set_var("class_sub_selected", "subCategory");
  169.                         }
  170.                             
  171.                         if ($is_next_record && !$is_new_top) {
  172.                             $t->parse("catalog_sub_separator", false);
  173.                         } else {
  174.                             $t->set_var("catalog_sub_separator", "");
  175.                         }
  176.                         $t->parse("catalog_sub", true);
  177.                     } elseif (($shown_sub_categories + 1) == $catalog_sub_number) {
  178.                         if ($friendly_urls && $top_friendly_url) {
  179.                             $list_url->remove_parameter("category_id");
  180.                             $t->set_var("list_url", htmlspecialchars($list_url->get_url($top_friendly_url . $friendly_extension)));
  181.                         } else {
  182.                             $list_url->add_parameter("category_id", CONSTANT, $top_category_id);
  183.                             $t->set_var("list_url", htmlspecialchars($list_url->get_url($list_page)));
  184.                         }
  185.     
  186.                         $t->parse("catalog_sub_more", false);
  187.                     }
  188.                 }
  189.     
  190.                 if ($is_new_top) {
  191.                     $catalog_top_number++;
  192.     
  193.                     if ($friendly_urls && $top_friendly_url) {
  194.                         $list_url->remove_parameter("category_id");
  195.                         $t->set_var("list_url", htmlspecialchars($list_url->get_url($top_friendly_url . $friendly_extension)));
  196.                     } else {
  197.                         $list_url->add_parameter("category_id", CONSTANT, $top_category_id);
  198.                         $t->set_var("list_url", htmlspecialchars($list_url->get_url($list_page)));
  199.                     }
  200.     
  201.                     if ($category_image)
  202.                     {
  203.                         if (preg_match("/^http\:\/\//", $category_image)) {
  204.                             $image_size = "";
  205.                         } else {
  206.                             $image_size = @GetImageSize($category_image);
  207.                             if (isset($restrict_categories_images) && $restrict_categories_images) {
  208.                                 $category_image = "image_show.php?category_id=".$top_category_id;
  209.                             }
  210.                         }
  211.                         if (!strlen($image_alt)) { $image_alt = $top_category_name; }
  212.                             $t->set_var("alt", htmlspecialchars($image_alt));
  213.                             $t->set_var("src", htmlspecialchars($category_image));
  214.                         if (is_array($image_size)) {
  215.                             $t->set_var("width", "width=\"" . $image_size[0] . "\"");
  216.                             $t->set_var("height", "height=\"" . $image_size[1] . "\"");
  217.                         } else {
  218.                             $t->set_var("width", "");
  219.                             $t->set_var("height", "");
  220.                         }
  221.                         $t->parse("catalog_image", false);
  222.                     } else {
  223.                         $t->set_var("catalog_image", "");
  224.                     }
  225.     
  226.                     if (!$allowed_categories_ids || !in_array($top_category_id, $allowed_categories_ids)) {
  227.                         $t->set_var("restricted_class", " restrictedCategory");
  228.                         $t->sparse("restricted_image", false);
  229.                     } else {
  230.                         $t->set_var("restricted_class", "");
  231.                         $t->set_var("restricted_image", "");
  232.                     }
  233.                     
  234.                     if ($category_id == $top_category_id) {
  235.                         $t->set_var("class_top_selected", "selectedtopCategory");
  236.                     } else {
  237.                         $t->set_var("class_top_selected", "topCategory");
  238.                     }                        
  239.                         
  240.                     $t->parse("catalog_top");
  241.                     $t->set_var("catalog_sub", "");
  242.                     $t->set_var("catalog_sub_more", "");
  243.                     if ($catalog_top_number % $columns == 0) {
  244.                         $t->parse("catalog_rows");
  245.                         $t->set_var("catalog_top", "");
  246.                     }
  247.                     $catalog_sub_number = 0;
  248.                 }
  249.     
  250.             } while ($is_next_record);
  251.     
  252.             if ($catalog_top_number % $columns != 0) {
  253.                 $t->parse("catalog_rows");
  254.             }
  255.     
  256.             $block_parsed = true;
  257.             $t->parse("block_body", false);
  258.         }
  259.     } else if ($categories_type == 5) {
  260.         // chained list type
  261.         $is_ajax = get_param("is_ajax");
  262.         $level = get_param("level");
  263.         $pcategory = get_param("pcategory");
  264.         if (!$pcategory) { $pcategory = 0; }
  266.         $categories = array();
  268.         $sql = " SELECT category_id, category_name FROM " . $table_prefix . "categories ";
  269.         $sql .= " WHERE parent_category_id=" . $db->tosql($pcategory, INTEGER);
  270.         $sql .= " ORDER BY category_order ";
  271.         $db->query($sql);
  272.         if ($db->next_record())    {
  273.             do {
  274.                 $category_id = $db->f("category_id");
  275.                 $categories[$category_id] = get_translation($db->f("category_name"));
  276.             } while ($db->next_record());
  277.         }
  278.         
  279.         if ($is_ajax) {
  280.             // json_encode for PHP4
  281.             if (sizeof($categories) > 0) {
  282.                 echo "{";
  283.                 foreach($categories as $category_id => $category_name) {
  284.                     echo '"' . $category_id . '":';
  285.                     echo '"' . str_replace('"', '\"', $category_name) . '",';
  286.                 }
  287.                 echo "}";
  288.             }
  289.             exit;
  290.         } else {
  291.         
  292.             $html_template = get_setting_value($block, "html_template", "block_categories_chained_menu.html");
  293.          $t->set_file("block_body", $html_template);
  294.             $t->set_var("products_href", get_custom_friendly_url("products.php"));
  295.         
  296.             foreach($categories as $category_id => $category_name) {
  297.                 $t->set_var("category_id", $category_id);    
  298.                 $t->set_var("category_name", htmlspecialchars($category_name));
  299.                 $t->parse("category_option");
  300.             }
  301.  
  302.             $block_parsed = true;
  303.             $t->parse("block_body", false);
  304.         }
  306.     } else {// list type
  307.         $html_template = get_setting_value($block, "html_template", "block_categories_list.html");
  308.      $t->set_file("block_body", $html_template);
  309.         $t->set_var("categories_rows", "");
  310.         $t->set_var("categories",   "");
  312.         $active_category_path = "0";
  313.         $not = false;
  314.         if ($categories_type == 4) { // Tree-type structure
  315.             $sql = " SELECT category_path ";
  316.             $sql .= " FROM " . $table_prefix . "categories ";
  317.             $sql .= " WHERE category_id=" . $db->tosql($category_id, INTEGER);
  318.             $db->query($sql);
  319.             if ($db->next_record()) {
  320.                 $active_category_path = $db->f("category_path");
  321.                 $active_category_path .= $category_id;
  322.             }
  323.             $categories_ids = VA_Categories::find_all_ids("c.parent_category_id IN (" . $db->tosql($active_category_path, INTEGERS_LIST) . ")", VIEW_CATEGORIES_PERM);
  324.             $allowed_categories_ids = VA_Categories::find_all_ids("c.parent_category_id IN (" . $db->tosql($active_category_path, INTEGERS_LIST) . ")", VIEW_CATEGORIES_ITEMS_PERM);
  325.         } else {
  326.             $not = true;
  327.             $categories_ids     = VA_Categories::find_all_ids(array('not' => 1), VIEW_CATEGORIES_PERM);
  328.             $allowed_categories_ids = VA_Categories::find_all_ids(array('not' => 1), VIEW_CATEGORIES_ITEMS_PERM);
  329.         }
  331.         if (!$not && !$categories_ids) return;
  332.         
  333.         $categories = array();
  334.         $sql = " SELECT category_id, category_name, a_title, friendly_url, ";
  335.         $sql .= " short_description, image, image_alt, image_large, image_large_alt, parent_category_id ";        
  336.         $sql .= " FROM " . $table_prefix . "categories ";
  337.         if ($not) {
  338.             if ($categories_ids) {
  339.                 $sql .= " WHERE category_id NOT IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ") ";
  340.             }
  341.             $sql .= " ORDER BY parent_category_id, category_order, category_name ";
  342.             $db->RecordsPerPage = 1000;
  343.         } else {
  344.             $sql .= " WHERE category_id IN (" . $db->tosql($categories_ids, INTEGERS_LIST) . ") ";
  345.             $sql .= " ORDER BY category_order, category_name ";
  346.         }
  347.         $db->query($sql);
  348.         while ($db->next_record()) {
  349.             $cur_category_id = $db->f("category_id");
  350.             $category_name = get_translation($db->f("category_name"));
  351.             $a_title = get_translation($db->f("a_title"));
  352.             $friendly_url = $db->f("friendly_url");
  353.             $short_description = get_translation($db->f("short_description"));
  355.             $image = $db->f("image");
  356.             $image_alt = get_translation($db->f("image_alt"));
  357.             $parent_category_id = $db->f("parent_category_id");
  358.             $categories[$cur_category_id]["parent_id"] = $parent_category_id;
  359.             $categories[$cur_category_id]["category_name"] = $category_name;
  360.             $categories[$cur_category_id]["a_title"] = $a_title;
  361.             $categories[$cur_category_id]["friendly_url"] = $friendly_url;
  362.             $categories[$cur_category_id]["short_description"] = $short_description;
  363.             $categories[$cur_category_id]["image"] = $image;
  364.             $categories[$cur_category_id]["image_alt"] = $image_alt;
  365.             $categories[$cur_category_id]["image_large"] = $db->f("image_large");
  366.             $categories[$cur_category_id]["image_large_alt"] = get_translation($db->f("image_large_alt"));
  367.             if ($not) {
  368.                 if ($allowed_categories_ids && in_array($cur_category_id, $allowed_categories_ids)) {
  369.                     $categories[$cur_category_id]["allowed"] = false;
  370.                 } else {
  371.                     $categories[$cur_category_id]["allowed"] = true;
  372.                 }
  373.             } else {
  374.                 if (!$allowed_categories_ids || !in_array($cur_category_id, $allowed_categories_ids)) {
  375.                     $categories[$cur_category_id]["allowed"] = false;
  376.                 } else {
  377.                     $categories[$cur_category_id]["allowed"] = true;
  378.                 }
  379.             }
  380.             $categories[$parent_category_id]["subs"][] = $cur_category_id;
  381.         }
  383.         if (sizeof($categories) > 0 && isset($categories[0]))
  384.         {
  385.             $category_number = 0;
  386.             $column_width = intval(100 / $columns);
  387.             $t->set_var("column_width", $column_width . "%");
  389.             set_categories(0, 0, $columns, 0, $categories_image);
  391.             if ($category_number % $columns != 0) {
  392.                 $t->parse("categories_rows");
  393.             }
  395.             $block_parsed = true;
  396.             $t->parse("block_body", false);
  397.         }
  398.     }
  401. ?>


S'il vous plaît laissez-moi savoir si ce n'est pas ce que vous faisiez allusion. Merci.
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • Avatar de l’utilisateur
  • Inscription: Déc 20, 2002
  • Messages: 8925
  • Loc: Seattle, WA & Phoenix, AZ
  • Status: Offline

Message Mai 1st, 2011, 6:22 pm

Sont les deux ci-dessus pages PHP séparés? ou tout ce qui pourrait être appelé sur un chargement de la page unique?

À première vue, il est difficile de dire que je ne pense pas que ceux-ci sont en aucune façon la création de 200 requêtes par page. Ils ne semblent pas être en boucles ni quoi que ce soit. Il est possible que quelques-uns d'entre eux pourraient être combinés encore, mais une autre optimisation qui pourrait aider serait de vérifier les indices sur eux pour faire en sorte que les recherches sont rapides.

Voyez-vous un code qui a des requêtes SQL dans une sorte de boucle while, ou pour la boucle sur une de vos pages? Je pense que quelque part sur votre page que vous avez une sorte de boucle avec des requêtes SQL à l'intérieur qui est vraiment votre requêtes SQL pour accéder à la haute portée de 200.
Ozzu Hosting - Want your website on a fast server like Ozzu?
  • johnlynches
  • Novice
  • Novice
  • No Avatar
  • Inscription: Déc 20, 2010
  • Messages: 15
  • Status: Offline

Message Mai 2nd, 2011, 9:21 am

pages Theyre se séparent pas, mais des morceaux d'une page qui se charge. Chaque page que j'ai a beaucoup de «sections» de ces derniers qui doit charger. Je ne vois pas de boucles dans les pages, mais là encore je ne sais pas vraiment ce qu'est une boucle ressemblerait si elle m'a giflé au visage.

Page 1 sur 1

Afficher de l'information

  • Total des messages de ce sujet: 11 messages
  • Utilisateurs parcourant ce forum: Aucun utilisateur enregistré et 54 invités
  • Vous ne pouvez pas poster de nouveaux sujets
  • Vous ne pouvez pas répondre aux sujets
  • Vous ne pouvez pas éditer vos messages
  • Vous ne pouvez pas supprimer vos messages
  • Vous ne pouvez pas joindre des fichiers
 
 

© 2011 Unmelted, LLC. Ozzu® est une marque déposée de Unmelted, LLC