Changeset 1564325

Timestamp:

12/29/2016 01:39:08 PM (9 years ago)

Author:

RPG84

Message:

and now with the updated file

Location:

tradetracker-store

Files:

• tags/4.6.33/front.php (modified) (2 diffs)
• trunk/front.php (modified) (2 diffs)

tradetracker-store/tags/4.6.33/front.php

@@ -344 +344 @@
     global $ttstoretable;
     global $ttstorecattable;
-    $multi=$wpdb->get_results("SELECT multiamount, multiitems, multipageamount, categories, multixmlfeed, multimaxprice, multiminprice, count(".$ttstoreitemtable.".id) as totalitems FROM ".$ttstoremultitable." left join ".$ttstoreitemtable." on ".$ttstoremultitable.".id = ".$ttstoreitemtable.".storeID where ".$ttstoremultitable.".id=".$winkelvol." group by storeID, multiname");
+    $multi=$wpdb->get_results("SELECT multiamount, multiitems, multipageamount, categories, multixmlfeed, multimaxprice, multiminprice, count(".$ttstoreitemtable.".id) as totalitems FROM ".$ttstoremultitable." left join ".$ttstoreitemtable." on ".$ttstoremultitable.".id = ".$ttstoreitemtable.".storeID where ".$ttstoremultitable.".id='".$winkelvol."' group by storeID, multiname");
     foreach ($multi as $multi_val){ 
         $Tradetracker_productid = $multi_val->totalitems;
@@ -498 +498 @@
     $wpdb->show_errors();
     if ($searching == "1") {
-        $multi_val=$wpdb->get_row("SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM ".$ttstoremultitable.",".$ttstorelayouttable." where ".$ttstoremultitable.".multilayout=".$ttstorelayouttable.".id and ".$ttstoremultitable.".id=".get_option("Tradetracker_searchlayout")."");
+        $multi_val=$wpdb->get_row("SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM ".$ttstoremultitable.",".$ttstorelayouttable." where ".$ttstoremultitable.".multilayout=".$ttstorelayouttable.".id and ".$ttstoremultitable.".id='".get_option("Tradetracker_searchlayout")."'");
     } else {
-        $multi_val=$wpdb->get_row("SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM ".$ttstoremultitable.",".$ttstorelayouttable." where ".$ttstoremultitable.".multilayout=".$ttstorelayouttable.".id and ".$ttstoremultitable.".id=".$winkelvol."");
+        $multi_val=$wpdb->get_row("SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM ".$ttstoremultitable.",".$ttstorelayouttable." where ".$ttstoremultitable.".multilayout=".$ttstorelayouttable.".id and ".$ttstoremultitable.".id='".$winkelvol."'");
     }
         $Tradetracker_amount = $multi_val->multiamount;

tradetracker-store/trunk/front.php

@@ -344 +344 @@
     global $ttstoretable;
     global $ttstorecattable;
-    $multi=$wpdb->get_results("SELECT multiamount, multiitems, multipageamount, categories, multixmlfeed, multimaxprice, multiminprice, count(".$ttstoreitemtable.".id) as totalitems FROM ".$ttstoremultitable." left join ".$ttstoreitemtable." on ".$ttstoremultitable.".id = ".$ttstoreitemtable.".storeID where ".$ttstoremultitable.".id=".$winkelvol." group by storeID, multiname");
+    $multi=$wpdb->get_results("SELECT multiamount, multiitems, multipageamount, categories, multixmlfeed, multimaxprice, multiminprice, count(".$ttstoreitemtable.".id) as totalitems FROM ".$ttstoremultitable." left join ".$ttstoreitemtable." on ".$ttstoremultitable.".id = ".$ttstoreitemtable.".storeID where ".$ttstoremultitable.".id='".$winkelvol."' group by storeID, multiname");
     foreach ($multi as $multi_val){ 
         $Tradetracker_productid = $multi_val->totalitems;
@@ -498 +498 @@
     $wpdb->show_errors();
     if ($searching == "1") {
-        $multi_val=$wpdb->get_row("SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM ".$ttstoremultitable.",".$ttstorelayouttable." where ".$ttstoremultitable.".multilayout=".$ttstorelayouttable.".id and ".$ttstoremultitable.".id=".get_option("Tradetracker_searchlayout")."");
+        $multi_val=$wpdb->get_row("SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM ".$ttstoremultitable.",".$ttstorelayouttable." where ".$ttstoremultitable.".multilayout=".$ttstorelayouttable.".id and ".$ttstoremultitable.".id='".get_option("Tradetracker_searchlayout")."'");
     } else {
-        $multi_val=$wpdb->get_row("SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM ".$ttstoremultitable.",".$ttstorelayouttable." where ".$ttstoremultitable.".multilayout=".$ttstorelayouttable.".id and ".$ttstoremultitable.".id=".$winkelvol."");
+        $multi_val=$wpdb->get_row("SELECT buynow, multimaxprice, multiminprice, multisorting, multiorder, categories, multixmlfeed, multiproductpage, multiname, laywidth, multiamount, multipageamount, multilightbox FROM ".$ttstoremultitable.",".$ttstorelayouttable." where ".$ttstoremultitable.".multilayout=".$ttstorelayouttable.".id and ".$ttstoremultitable.".id='".$winkelvol."'");
     }
         $Tradetracker_amount = $multi_val->multiamount;