[mtha]

Originally Posted by Boofo

But that never showed up in the regular product listing. This is the first time I have seen it.

well, because it doesnt have a real product. it's like when you add a plugin, or phrase, or something to database, and just give it some product name. This name doesnt actually exist in product table, => not listed in product listing.

Is there a way to do the product listing alphabetically like it was originally?

Query fixed and sorted. Updated on the attachment

I modify alitle bit on KirbyDE code, adding the product list to counting queries.

PHP Code:

    $productq = $db->query_read("
        SELECT * 
        FROM " . TABLE_PREFIX . "product
        ORDER BY title");

   while ($product = $db->fetch_array($productq))
    {
        $products["$product[productid]"] = $product;
        $products["$product[productid]"]['plugin'] = 0;
        $products["$product[productid]"]['phrase'] = 0;
        $products["$product[productid]"]['template'] = 0;
        $products["$product[productid]"]['setting'] = 0;
    }
    ksort($products);
    $productlist = "'". implode('\',\'',array_keys($products)) ."'";

 $pluginq = $db->query_read("SELECT product, COUNT(pluginid) AS plugin FROM " . TABLE_PREFIX . "plugin WHERE product IN ($productlist) GROUP BY product");
    while ($plugin = $db->fetch_array($pluginq))
    {
        $products["$plugin[product]"]['plugin'] = $plugin['plugin'];
    }

 $phraseq = $db->query_read("SELECT product, COUNT(phraseid) AS phrase FROM " . TABLE_PREFIX . "phrase WHERE languageid=-1 AND product IN ($productlist) GROUP BY product");
    while ($phrase = $db->fetch_array($phraseq))
    {
        $products["$phrase[product]"]['phrase'] = $phrase['phrase'];
    }

 $templateq = $db->query_read("SELECT product, COUNT(templateid) AS template FROM " . TABLE_PREFIX . "template WHERE styleid=-1 AND product IN ($productlist) GROUP BY product");
    while ($template = $db->fetch_array($templateq))
    {
        $products["$template[product]"]['template'] = $template['template'];
    }
    
$settingq = $db->query_read("SELECT product, COUNT(varname) AS setting FROM " . TABLE_PREFIX . "setting WHERE product IN ($productlist) GROUP BY product");
    while ($setting = $db->fetch_array($settingq))
    {
        $products["$setting[product]"]['setting'] = $setting['setting'];
    }