Jump to content

driven22

Members
  • Content count

    30
  • Joined

  • Last visited

Profile Information

  • Real Name
    Grzesiek

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Maybe someone will be useful , about 630 line in general php: //// // Parse search string into indivual objects // function tep_parse_search_string($search_str = '', &$objects) { // $search_str = trim(strtolower($search_str)); //wyniki wyszukiwania z polskimi literami function tep_parse_search_string($search_str = '', &$objects) { $search_str = trim($search_str); $search_str = mb_convert_case($search_str, MB_CASE_LOWER, "utf-8"); Best regards Grzesiek
  2. Solved by add code in general.php
  3. I have a problem with searching in the store. When I type a word with a special letter, e.g. łopian, it shows that there is no such product. If I type opian finds the product. This is probably a SQL encoding problem: My sql : Variable_name Value character_set_client utf8mb4 character_set_connection utf8 character_set_database latin2 character_set_filesystem binary character_set_results utf8mb4 character_set_server latin2 character_set_system utf8 character_sets_dir /home/mysql101/share/mysql/charsets/ Variable_name Value collation_connection utf8_unicode_ci collation_database latin2_general_ci collation_server latin2_general_ci
  4. After 4 hours it suddenly started working as it should on all computers. Thank you very much for your help :)
  5. I moved 301 before: RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} and redirections that have the same id as before redirecting, works fine. Unfortunately, the redirection from the product ex. ID 41 to ex. ID 52 does not work yet. Here it still adds ?product_id=.. ..../przywrotnik-250ml-ze-swiezego-ziela-p-52.html?products_id=41
  6. Unfortunately it is the same. In the case of a link: https://www.kuzdrowiu.com.pl/przywrotnik-pospolity-sok-100-ml-p-41.html it shows something like this: https://www.kuzdrowiu.com.pl/-p-41.html in other cases, when the product has the same id but only the address has changed, it adds at the end ?product_id= ... example: redirect from .... /sok-z-pokrzywy-250ml-niepasteryzowany-na-anemie-zelazo-p-39.html it shows: https://www.kuzdrowiu.com.pl/sok-z-pokrzywy-250ml-niepasteryzowany-p-39.html?products_id=39 Maybe it's the seo urls module's fault?
  7. <IfModule mod_rewrite.c> # Begin Ultimate SEO V2.2d Options +FollowSymLinks RewriteEngine On RewriteBase / RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING} RewriteRule ^(.*)-by-(.*).html$ all-products.php?fl=$2&%{QUERY_STRING} RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-au-(.*).html$ articles.php?authors_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-f-(.*).html$ faqdesk_info.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-fc-(.*).html$ faqdesk_index.php?faqPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-fri-(.*).html$ faqdesk_reviews_info.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-fra-(.*).html$ faqdesk_reviews_article.php?faqdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-links-(.*).html$ links.php?lPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-pm-([0-9]+).html$ info_pages.php?pages_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-n-(.*).html$ newsdesk_info.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-nc-(.*).html$ newsdesk_index.php?newsPath=$2&%{QUERY_STRING} RewriteRule ^(.*)-nri-(.*).html$ newsdesk_reviews_info.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-nra-(.*).html$ newsdesk_reviews_article.php?newsdesk_id=$2&%{QUERY_STRING} RewriteRule ^(.*)-po-([0-9]+).html$ pollbooth.php?pollid=$2&%{QUERY_STRING} RewriteEngine On RewriteCond %{HTTP_HOST} !^www.mypage.com.pl$ RewriteRule ^(.*)$ https://www.mypage.com.pl/$1 [R=301,L] RewriteCond %{HTTPS} off RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] RewriteCond %{THE_REQUEST} ^[A-Z]{3,9}\ /index\.php [NC] RewriteRule ^index\.php$ https://www.mypage.com.pl/ [R=301,L] AddDefaultCharset UTF-8 Redirect 301 /contact_us.php https://www.mypage.com.pl/kontakt.php Redirect 301 /sok-z-pokrzywy-250ml-niepasteryzowany-na-anemie-zelazo-p-39.html https://www.mypage.com.pl/sok-z-pokrzywy-250ml-niepasteryzowany-p-39.html Redirect 301 /sok-z-przywrotnika-250ml-p-57.html https://www.mypage.com.pl/przywrotnik-250ml-ze-swiezego-ziela-p-57.html Redirect 301 /arcydziegiel-nalewka-na-kaszel-p-52.html https://www.mypage.com.pl/arcydziegiel-korzen-250ml-p-52.html Redirect 301 /przywrotnik-pospolity-sok-100-ml-p-41.html https://www.mypage.com.pl/przywrotnik-250ml-ze-swiezego-ziela-p-57.html </IfModule> <IfModule mod_headers.c> # Set XSS Protection header Header set X-XSS-Protection "1; mode=block" </IfModule> <IfModule mod_headers.c> Header unset ETag </IfModule> FileETag None ## EXPIRES CACHING ## ## https://gtmetrix.com/leverage-browser-caching.html ## <IfModule mod_expires.c> ExpiresActive On ExpiresByType image/jpg "access plus 1 year" ExpiresByType image/jpeg "access plus 1 year" ExpiresByType image/gif "access plus 1 year" ExpiresByType image/png "access plus 1 year" ExpiresByType text/css "access plus 1 month" ExpiresByType application/pdf "access plus 1 month" ExpiresByType text/x-javascript "access plus 1 month" ExpiresByType application/x-shockwave-flash "access plus 1 month" ExpiresByType image/x-icon "access plus 1 year" ExpiresByType application/javascript "access plus 1 year" ExpiresDefault "access plus 2 days" </IfModule> ## EXPIRES CACHING ## My htaccess looks like this. It always adds ?product=xx for 301 redirection
  8. Hi, I have problem with redirect 301 in my shop (frozen version). In htaacess i was add ex. Redirect 301 /sok-z-pokrzywy-250ml-niepasteryzowany-na-anemie-zelazo-p-39.html https://www.kuzdrowiu.com.pl/sok-z-pokrzywy-250ml-niepasteryzowany-p-39.html When i click on link (or write) https://www.kuzdrowiu.com.pl/sok-z-pokrzywy-250ml-niepasteryzowany-na-anemie-zelazo-p-39.html he adds on the and ?products_id=39&products_id=39 After redirect the link should look like this: https://www.kuzdrowiu.com.pl/sok-z-pokrzywy-250ml-niepasteryzowany-p-39.html (wihout any ?product=... after link) Where is the problem ? Please, help me.
  9. driven22

    Export orders into csv

    I would like csv to export the order amount when the shipping payment is higher or equal to 19$ (My cod is 19$) and show e.g. in the $cod field in exportordes.php It is needed for cash on delivery COD when importing to DHL or other courier. I've been trying to enter the rule for a few days - but I'm too weak in php to do this. Currently, order_total ($Order_Grand_Total) shows regardless of the chosen payment method or payment amount: Can I count on your help?
  10. driven22

    Export orders into csv

    I still have a small problem (Frozen version): When the client has a name and two-membered surname after the second space it cuts off all the words Example: Johnny Bravo Scott after export to csv I only have Johnny Bravo Truncates only when a space after the second word is used Where can I correct it so that it doesn't cut?
  11. driven22

    Export orders into csv

    1. add a field in table "orders" via phpMyAdmin called "weight" immediately after "payment_method", the field is DECIMAL (5,2) NOT NULL, 2. in catalog/checkout_process.php after: $shipping_modules = new shipping($shipping); add $total_weight = $cart->show_weight(); same file - after: 'payment_method' => $order->info['payment_method'], add 'weight' => $total_weight, in catalog/admin/includes/classes/order.php in line 38 add 'weight' $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, weight, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); same file line 56 add after: 'payment_method' => $order['payment_method'], this: 'weight' => $order['weight'], Aftert this "solution" i have in sql table weight and i can export to csv orders with weight. In exportordes.php in line 199-217 added word weight: // Patch dlan // if both fields are empty we select all orders if ($start=="" && $end=="") { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, customers_id, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires, weight FROM orders ORDER BY orders_id"); // if $start is empty we select all orders up to $end } else if($start=="" && $end!="") { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, customers_id, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires, weight FROM orders WHERE orders_id <= $end ORDER BY orders_id"); // if $end is empty we select all orders from $start } else if($start!="" && $end=="") { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, customers_id, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires, weight FROM orders WHERE orders_id >= $start ORDER BY orders_id"); // if both fields are filed in we select orders betwenn $start and $end } else { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, customers_id, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires, weight FROM orders WHERE orders_id >= $start AND orders_id <= $end ORDER BY orders_id"); } //patch in line 261: $weight = $row_orders ['weight']; in line 428: $csv_output .= $weight . "^" ; It's work for me.
  12. driven22

    Export orders into csv

    ok- problem solved.
  13. driven22

    Export orders into csv

    Hi, I need to export CSV file with total weight order but i don't know how do that. Osc 2.3.4 - my exportorders.php is: <?php /* $Id: exportorders.php,v 1.1 April 21, 2006 Harris Ahmed $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2004 Oscommerce Use this module on your own risk. I will be updating a new one soon. This template is used to create the csv export for Ideal Computer Systems Accounting Software */ define('FILENAME_EXPORTORDERS_DPD', 'exportorders_dpd.php'); require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_EXPORTORDERS); // Check if the form is submitted if (!$_GET['submitted']) { require(DIR_WS_INCLUDES . 'template_top.php'); ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo "Export pliku do CSV" ?></td> <td class="pageHeading" align="left"></td> </tr> </table> </td> </tr> <!-- first ends // --> <tr> <td><table border="0" style="font-family:tahoma;font-size:11px;" width="100%" cellspacing="2" cellpadding="2"> <tr> <td> <form method="GET" action="<?php echo $PHP_SELF; ?>"> <table border="0" style="font-family:tahoma;font-size:11px;" cellpadding="3"> <tr> <td><?php echo "Od numeru zamówienia:"; ?></td> <td><input name="start" size="5" value="<?php echo $start; ?>"> </tr> <tr> <td><?php echo "Do numeru zamówienia:" ; ?></td> <td><input name="end" size="5" value="<?php echo $end; ?>"> </tr> <tr> <td><?php echo "Status Zamówienia"; ?></td> <?php $orders_statuses = array(); $orders_status_array = array(); $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'"); while ($orders_status = tep_db_fetch_array($orders_status_query)) { $orders_statuses[] = array('id' => $orders_status['orders_status_id'], 'text' => $orders_status['orders_status_name']); $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name']; } ?> <td><?php echo tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => 'Wszystkie zamówienia')), $orders_statuses), $status); ?> </tr> <tr> <td><?php echo "Sposób Wyświetlania:"; ?></td> <td> <select name="submitted"> <option value="1">Utwórz plik CSV</option> <option value="2">Pokaż plik na ekranie</option> </select> </td></tr> <tr> <td>&nbsp;</td> <td><input type="submit" value="<?php echo "Export pliku DPD CSV"; ?>"></td> </tr> </table></form> </td></tr></table> </td></tr></table> </td></tr> </table></td> </tr> </table></td> </tr> </table <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> <?php } // submitted so generate csv if the form is submitted else { generatecsv($_GET['start'], $_GET['end']); } // generates csv file from $start order to $end order, inclusive function generatecsv($start, $end) { //Placing columns names in first row $delim = '^' ; //$csv_output .= "Orders_id".$delim; //$csv_output .= "Date".$delim; //$csv_output .= "Time".$delim; //$csv_output .= "First_Name".$delim; //$csv_output .= "Last_Name".$delim; //$csv_output .= "Name_On_Card".$delim; //$csv_output .= "Company".$delim; //$csv_output .= "email".$delim; //$csv_output .= "Billing_Address_1".$delim; //$csv_output .= "Billing_Address_2".$delim; //$csv_output .= "Billing_City".$delim; //$csv_output .= "Billing_State".$delim; //$csv_output .= "Billing_Zip".$delim; //$csv_output .= "Billing_Country".$delim; //$csv_output .= "Billing_Phone".$delim; $csv_output .= "Imie Nazwisko".$delim; //$csv_output .= "Nazwisko".$delim; //$csv_output .= "ShipTo_Name".$delim; $csv_output .= "Nazwa Firmy".$delim; $csv_output .= "Address_1".$delim; //$csv_output .= "Address_2".$delim; $csv_output .= "kod pocztowy".$delim; $csv_output .= "Miejscowosc".$delim; //$csv_output .= "ShipTo_State".$delim; //$csv_output .= "ShipTo_Country".$delim; $csv_output .= "telefon".$delim; //$csv_output .= "Card_Type".$delim; //$csv_output .= "Card_Number".$delim; //$csv_output .= "Exp_Date".$delim; //$csv_output .= "Bank_Name".$delim; //$csv_output .= "Gateway".$delim; //$csv_output .= "AVS_Code".$delim; //$csv_output .= "Transaction_ID".$delim; ///$csv_output .= "Order_Special_Notes".$delim; //$csv_output .= "Comments".$delim; //$csv_output .= "Order_Subtotal".$delim; //$csv_output .= "Order_Tax".$delim; //$csv_output .= "Order_Insurance".$delim; //$csv_output .= "Tax_Exempt_Message".$delim; //$csv_output .= "Order_Shipping_Total".$delim; //$csv_output .= "Small_Order_Fee".$delim; //$csv_output .= "Discount_Rate".$delim; //$csv_output .= "Discount_Message".$delim; $csv_output .= "email".$delim; //$csv_output .= "Order_Grand_Total".$delim; //$csv_output .= "Number_of_Items".$delim; //$csv_output .= "Sposob wysylki".$delim; $csv_output .= "Numer Zamowienia".$delim; $csv_output .= "Waga wysylki".$delim; $csv_output .= "Waga wysylki2".$delim; //$csv_output .= "Coupon_Code".$delim; //$csv_output .= "Order_security_msg.".$delim; //$csv_output .= "Order_Surcharge_Amount".$delim; //$csv_output .= "Order_Surcharge_Something".$delim; //$csv_output .= "Affiliate_code".$delim; //$csv_output .= "Sentiment_message".$delim; //$csv_output .= "Checkout_form_type".$delim; //$csv_output .= "Card_CVV_value".$delim; //$csv_output .= "future1".$delim; //$csv_output .= "future2".$delim; //$csv_output .= "future3".$delim; //$csv_output .= "future4".$delim; //$csv_output .= "future5".$delim; //$csv_output .= "future6".$delim; //$csv_output .= "future7".$delim; //$csv_output .= "future8".$delim; //$csv_output .= "future9".$delim; //$csv_output .= "Remarks".$delim; //$csv_output .= "ProductId".$delim; //$csv_output .= "Product_Price".$delim; //$csv_output .= "Number".$delim; //$csv_output .= "Product".$delim; //$csv_output .= "Attribute".$delim; //$csv_output .= "Attribute_Value".$delim; $csv_output .= "\n"; //End Placing columns in first row // Patch dlan // if both fields are empty we select all orders if ($start=="" && $end=="") { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, customers_id, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders ORDER BY orders_id"); // if $start is empty we select all orders up to $end } else if($start=="" && $end!="") { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, customers_id, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders WHERE orders_id <= $end ORDER BY orders_id"); // if $end is empty we select all orders from $start } else if($start!="" && $end=="") { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, customers_id, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders WHERE orders_id >= $start ORDER BY orders_id"); // if both fields are filed in we select orders betwenn $start and $end } else { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, customers_id, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders WHERE orders_id >= $start AND orders_id <= $end ORDER BY orders_id"); } //patch //$csv_output ="\n"; while ($row_orders = mysqli_fetch_array($orders)) { //start one loop $csv_output_ordersbefore = $csv_output; $Orders_id = $row_orders["orders_id"]; $customers_id = $row_orders["customers_id"]; $Date1 = $row_orders["date_purchased"]; //list($Date, $Time) = explode (' ',$Date1); $Date = date('mdY', strtotime($Date1)); $Time= date('H:i:s', strtotime($Date1)); $Name_On_Card1 = $row_orders["customers_name"]; $Name_On_Card = filter_text($Name_On_Card1);// order changed list($First_Name,$Last_Name) = explode(' ',$Name_On_Card1); // order changed $Company = filter_text($row_orders["customers_company"]); $email = filter_text($row_orders["customers_email_address"]); $Billing_Address_1 = filter_text($row_orders["billing_street_address"]); $Billing_Address_2 = ""; $Billing_City = filter_text($row_orders["billing_city"]); $Billing_State = filter_text($row_orders["billing_state"]); $Billing_Zip = filter_text($row_orders["billing_postcode"]); $Billing_Country = str_replace("(48 Contiguous Sta", "", $row_orders["billing_country"]); $Billing_Phone = filter_text($row_orders["customers_telephone"]); $ShipTo_Name1 = $row_orders["delivery_name"]; $ShipTo_Name = filter_text($ShipTo_Name1); // order changed list($ShipTo_First_Name,$ShipTo_Last_Name) = explode(' ',$ShipTo_Name1); // order changed $ShipTo_Company = filter_text($row_orders["delivery_company"]); $ShipTo_Address_1 = filter_text($row_orders["delivery_street_address"]); $ShipTo_Address_2 = ""; $ShipTo_City = filter_text($row_orders["delivery_city"]); $ShipTo_State = filter_text($row_orders["delivery_state"]); $ShipTo_Zip = filter_text($row_orders["delivery_postcode"]); $ShipTo_Country = str_replace("(48 Contiguous Sta", "", $row_orders["delivery_country"]); $ShipTo_Phone = ""; $Card_Type = $row_orders["cc_type"]; $Card_Number = $row_orders["cc_number"]; $Exp_Date = $row_orders["cc_expires"]; $Bank_Name = ""; $Gateway = ""; $AVS_Code = ""; $Transaction_ID = ""; $Order_Special_Notes = ""; // -------------------- QUERIES 1 ------------------------------------// //Orders_status_history for comments $orders_status_history = tep_db_query("select comments from orders_status_history where orders_id = " . $Orders_id); //$row_orders_status_history = tep_db_fetch_array($comments); while($row_orders_status_history = mysqli_fetch_array($orders_status_history)) { // end // $Comments = filter_text($row_orders_status_history["comments"]); } // -------------------- QUERIES 2 ------------------------------------// //Orders_subtotal $orders_subtotal = tep_db_query("select value from orders_total where class = 'ot_subtotal' and orders_id = " . $Orders_id); //$row_orders_subtotal = tep_db_fetch_array($orders_subtotal); while($row_orders_subtotal = mysqli_fetch_array($orders_subtotal)) { // end // $Order_Subtotal = filter_text($row_orders_subtotal["value"]); } // -------------------- QUERIES 3 ------------------------------------// //Orders_tax $orders_tax = tep_db_query("select value from orders_total where class = 'ot_tax' and orders_id = " . $Orders_id); //$row_orders_tax = tep_db_fetch_array($orders_tax); while($row_orders_tax = mysqli_fetch_array($orders_tax)) { // end // $Order_Tax = filter_text($row_orders_tax["value"]); } // -------------------- QUERIES 4 ------------------------------------// //Orders_Insurance $orders_insurance = tep_db_query("select value from orders_total where class = 'ot_insurance' and orders_id = " . $Orders_id); //$row_orders_insurance = tep_db_fetch_array($orders_insurance); while($row_orders_insurance = mysqli_fetch_array($orders_insurance)) { // end // $Order_Insurance = filter_text($row_orders_insurance["value"]); } $Tax_Exempt_Message = ""; // -------------------- QUERIES 5 ------------------------------------// //Orders_Shipping $orders_shipping = tep_db_query("select title, value from orders_total where class = 'ot_shipping' and orders_id = " . $Orders_id); //$row_orders_shipping = tep_db_fetch_array($orders_shipping); while($row_orders_shipping = mysqli_fetch_array($orders_shipping)) { // end // $Order_Shipping_Total = $row_orders_shipping["value"]; $Shipping_Method = filter_text($row_orders_shipping["title"]); // Shipping method from query 5 } // -------------------- QUERIES 6 ------------------------------------// //Orders_Residential Del Fee (Giftwrap) $orders_residential_fee = tep_db_query("select value from orders_total where class = 'ot_giftwrap' and orders_id = " . $Orders_id); //$row_orders_residential_fee = tep_db_fetch_array($orders_residential_fee); while($row_orders_residential_fee = mysqli_fetch_array($orders_residential_fee)) { // end // $Small_Order_Fee = $row_orders_residential_fee["value"]; } //////////////////////////////////// $Discount_Rate = ""; $Discount_Message = ""; $CODAmount = ""; // -------------------- QUERIES 7 ------------------------------------// //Orders_Total $orders_total = tep_db_query("select value from orders_total where class = 'ot_total' and orders_id = " . $Orders_id); //$row_orders_total = tep_db_fetch_array($orders_total); while($row_orders_total = mysqli_fetch_array($orders_total)) { // end // $Order_Grand_Total = $row_orders_total["value"]; } // -------------------- QUERIES 8 ------------------------------------// //Products COunt $orders_count = tep_db_query("select count(products_quantity) as o_count from orders_products where orders_id = " . $Orders_id); //$row_orders_total = tep_db_fetch_array($orders_total); while($row_orders_count = mysqli_fetch_array($orders_count)) { // end // $Number_of_Items = $row_orders_count[0]; // used array to show the number of items ordered } // $shipping_weight = ""; //$Coupon_Code = ""; //$Order_security_msg = ""; //$Order_Surcharge_Amount = ""; //$Order_Surcharge_Something = ""; //$Affiliate_code = ""; //$Sentiment_message = ""; //$Checkout_form_type = ""; //$Card_CVV_value = $row_orders["cvvnumber"]; //$future1 = ""; //$future2 = ""; //$future3 = ""; //$future4 = ""; //$future5 = ""; //$future6 = ""; //$future7 = ""; //$future8 = ""; //$future9 = ""; // csv settings $CSV_SEPARATOR = "^"; $CSV_NEWLINE = "\r\n"; //$csv_output .= "". "^" ; $csv_output .= $ShipTo_First_Name . " " ; $csv_output .= $ShipTo_Last_Name . "^" ; $csv_output .= $ShipTo_Company . "^" ; $csv_output .= $ShipTo_Address_1 . "^" ; //$csv_output .= "PL" . "^" ; $csv_output .= $ShipTo_Zip . "^" ; $csv_output .= $ShipTo_City . "^" ; //$csv_output .= $Time . "," ; //$csv_output .= $First_Name . "," ; //$csv_output .= $Last_Name . "," ; //$csv_output .= $Name_On_Card . "," ; //$csv_output .= $Company . "," ; //$csv_output .= $email . "," ; //$csv_output .= $Billing_Address_1 . "," ; //$csv_output .= $Billing_Address_2 . "," ; //$csv_output .= $Billing_City . "," ; //$csv_output .= $Billing_State . "," ; //$csv_output .= $Billing_Zip . "," ; //$csv_output .= $Billing_Country . "," ; $csv_output .= $Billing_Phone . "^" ; $csv_output .= $email . "^" ; $csv_output .= $Orders_id . "^" ; //$csv_output .= $Date . "^" ; //$csv_output .= "2000^^N^N^N^N^N^N^N^N^N". "" ; //$csv_output .= $ShipTo_Name . "," ; //$csv_output .= $ShipTo_Company . "," ; //$csv_output .= $ShipTo_Address_1 . "," ; //$csv_output .= $ShipTo_Address_2 . "," ; //$csv_output .= $ShipTo_State . "," ; //$csv_output .= $ShipTo_Zip . "," ; //$csv_output .= $ShipTo_Country . "," ; //$csv_output .= $ShipTo_Phone . "," ; //$csv_output .= $Card_Type . "," ; //$csv_output .= $Card_Number . "," ; //$csv_output .= $Exp_Date . "," ; //$csv_output .= $Bank_Name . "," ; //$csv_output .= $Gateway . "," ; //$csv_output .= $AVS_Code . "," ; //$csv_output .= $Transaction_ID . "," ; //$csv_output .= $Order_Special_Notes . "," ; //$csv_output .= $Comments . "," ; //$csv_output .= $Order_Subtotal . "," ; //$csv_output .= $Order_Tax . "," ; //$csv_output .= $Order_Insurance . "," ; //$csv_output .= $Tax_Exempt_Message . "," ; //$csv_output .= $Order_Shipping_Total . "," ; //$csv_output .= $Small_Order_Fee . "," ; //$csv_output .= $Discount_Rate . "," ; //$csv_output .= $Discount_Message . "," ; //$csv_output .= $CODAmount . "^" ; //$csv_output .= $Order_Grand_Total . "," ; //$csv_output .= $Number_of_Items . "," ; //$csv_output .= $Shipping_Method . "," ; //$csv_output .= $total_weight . "^" ; $csv_output .= $shipping_weight . "2^" ; //$csv_output .= $Coupon_Code . "," ; //$csv_output .= $Order_security_msg . "," ; //$csv_output .= $Order_Surcharge_Amount . "," ; //$csv_output .= $Order_Surcharge_Something . "," ; //$csv_output .= $Affiliate_code . "," ; //$csv_output .= $Sentiment_message . "," ; //$csv_output .= $Checkout_form_type . "," ; //$csv_output .= $Card_CVV_value . "," ; //$csv_output .= $future1 . "," ; //$csv_output .= $future2 . "," ; //$csv_output .= $future3 . "," ; //$csv_output .= $future4 . "," ; //$csv_output .= $future5 . "," ; //$csv_output .= $future6 . "," ; //$csv_output .= $future7 . "," ; //$csv_output .= $future8 . "," ; //$csv_output .= $future9 ; // -------------------- QUERIES 9 ------------------------------------// //Get list of products ordered //$orders_products = tep_db_query("select products_model, products_price, products_quantity, products_name, orders_products_id from orders_products //where orders_id = " . $Orders_id); // While loop to list the item //$countproducts = 0; //$csv_output_item = ""; //$csv_output_order = str_replace($csv_output_ordersbefore, "", $csv_output); //while($row_orders_products = mysql_fetch_array($orders_products)) { // loop through orders // More than one product per order, new line // if ($countproducts>0){ // $csv_output .= "\n"; // $csv_output .= $csv_output_order; // $csv_output_item = ""; // } // $csv_output_item .= "," . "BEGIN_ITEM". "," ; // $csv_output_item .= ","; // $csv_output_item .= filter_text($row_orders_products[0]) . "," ; // $csv_output_item .= $row_orders_products[1] . "," ; // $csv_output_item .= $row_orders_products[2] . "," ; // $csv_output_item .= filter_text($row_orders_products[3]) . "," ; // $Products_id = $row_orders_products[4]; // // $orders_products_attributes = tep_db_query("select products_options, products_options_values from orders_products_attributes // where orders_id = " . $Orders_id . " and orders_products_id = " . $Products_id); // // while($row_orders_products_attributes = mysql_fetch_array($orders_products_attributes)) { // $csv_output_item .= filter_text($row_orders_products_attributes[0]) . "," ; // $csv_output_item .= filter_text($row_orders_products_attributes[1]) . "," ; // } // $csv_output_item .= "END_ITEM"; // $csv_output .= $csv_output_item; // $countproducts += 1; //} // end while loop for products // --------------------------------------------------------------------------// $csv_output .= "\n"; } // while loop main first //print header("Content-Type: application/force-download\n"); header("Cache-Control: cache, must-revalidate"); header("Pragma: public"); header("Content-Disposition: attachment; filename=ordersexports_" . date("Ymd") . ".csv"); print $csv_output; exit; }//function main function filter_text($text) { $filter_array = array(",","\r","\n","\t"); return str_replace($filter_array,"",$text); } // function for the filter ?> Please help me :)
  14. driven22

    [Addon] Generic Box

    You're right, but without this change there is always a broken link to the image and thrown "\ into the description. How does it differently change?
  15. driven22

    [Addon] Generic Box

    I just do this in admin/modules.php tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . $value . "' where configuration_key = '" . $key . "'"); // Generic Box // tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . addslashes( addslashes( $value ) ) . "' where configuration_key = '" . $key . "'"); and than disappeared slashes \" and fixed links to images.
×