Beiträge von irrtum1

irrtum1

so,
habe das Feld datensg in der Datenbank eingetragen, nu komme ich aber nicht mehr in den Admin?

Logge mich ein und komme nur auf die Persönliche Seite, weiteres funzt nicht??

Mfg

irrtum1

Ich bin' schon wieder,:D

wird per PayPal Express eine Bestellung bezahlt, werden in der Bestellbearbeitung die Status Änderungen als Nicht bestätigt eingetragen, somit wird dem Kunden auch keine Mail versendet!

Bei PayPal habe ich bei solchen Bestellungen immer einen Warnhinweis (rote Flagge) in der Zahlungsbestätigungsseite.

schon mal danke
Mfg

irrtum1

ja super, jetzt funzt dad.

Danke Danke

irrtum1

Hallo,
ich habe gerade bemerkt dass bei einer Kundenanmeldung die Tel. Nr. nicht mit übergeben wird.
Habe dann mal eine eigene Reg. durchlaufen lassen und siehe da ich bekomme folgenden Fheler.

Code

1054 - Unknown column 'datensg' in 'field list'


insert into customers (customers_vat_id, customers_vat_id_status, customers_status, customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password, customers_date_added, customers_last_modified, datensg, customers_gender, customers_cid) values ('', '', '2', 'Ralph', 'dgsdgdg', 'xxxxxxx@unitybox.de', '123', '', '0', 'd7f6039a3303d1726f0d3xxxxxxxxx', now(), now(), now(), 'm', '180210-2048')


[XT SQL Error]

was fehlt in der Datenbank und was muss ich einfühgen.

schon mal danke
mfg

irrtum1

2. Teil Gambio Modul

PHP

if ($_POST['shippingcosts'] != MODULE_PREISWUNDER24_SHIPPING_COST) {
			xtc_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . xtc_db_input($_POST['shippingcosts']) . "' where configuration_key = 'MODULE_PREISWUNDER24_SHIPPING_COST'");
		} 

	if ($products['products_image'] != ''){
	    $image = HTTP_CATALOG_SERVER . DIR_WS_CATALOG_THUMBNAIL_IMAGES .$products['products_image'];
	}else{
	    $image = '';
	}
	if ($products['products_weight'] != '0.00'){
				$weight = number_format($products['products_weight'],2,'.','');
			} else {
				$weight = '';
			}
			$versand = '0.00';
			if ($products_price < MODULE_ORDER_TOTAL_LOWORDERFEE_ORDER_UNDER && MODULE_ORDER_TOTAL_LOWORDERFEE_STATUS == 'true') {
				$customers_tax_query = xtc_db_query("SELECT customers_status_show_price_tax, customers_status_add_tax_ot FROM " . TABLE_CUSTOMERS_STATUS . " WHERE customers_status_id = '" . (int)$_POST['status'] . "' AND language_id = '" . (int)$_SESSION['languages_id'] . "'");
				$customers_tax_value = xtc_db_fetch_array($customers_tax_query);
				$tax = xtc_get_tax_rate(MODULE_ORDER_TOTAL_LOWORDERFEE_TAX_CLASS);
				if ($customers_tax_value['customers_status_show_price_tax'] == 1) {
					$low_order_fee = xtc_add_tax(MODULE_ORDER_TOTAL_LOWORDERFEE_FEE, $tax);
				}
				if ($customers_tax_value['customers_status_show_price_tax'] == 0 && $customers_tax_value['customers_status_add_tax_ot'] == 1) {
					$low_order_fee = MODULE_ORDER_TOTAL_LOWORDERFEE_FEE;
				}
				if ($customers_tax_value['customers_status_show_price_tax'] == 0 && $customers_tax_value['customers_status_add_tax_ot'] != 1) {
					$low_order_fee = MODULE_ORDER_TOTAL_LOWORDERFEE_FEE;
				}
				$versand = $versand + $low_order_fee;
			}
            if ($products_price > MODULE_SHIPPING_FREEAMOUNT_AMOUNT && MODULE_SHIPPING_FREEAMOUNT_STATUS == 'True') {
				$versand = $versand;
			} else if ($products_price > MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER && MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING == 'true') {
				$versand = $versand;
			} else {
				$shipping = -1;
				$shippinglist = split("[:,]" , $_POST['shippingcosts']);
				for ($i=0; $i<sizeof($shippinglist); $i+=2) {
					if ($_POST['shippingart'] == 'weight') {
				  		if ($products['products_weight'] <= $shippinglist[$i]) {
							$shipping = $shippinglist[$i+1];
							break;
				  		}
					} else if ($_POST['shippingart'] == 'price') {
						if ($products_price <= $shippinglist[$i]) {
							$shipping = $shippinglist[$i+1];
							break;
				  		}
					}
				}	
				if ($shipping == -1) {
				  $shipping_cost = 0;
				} else {
				  $shipping_cost = $shipping;
				}
				$versand = $versand + $shipping_cost;
			}


            $schema .=  $products_name.";".
			            number_format($products_price,2,',','') .';'.
            			$products_short_description.";".
						$products_description.";".
                        HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'product_info.php?'.$_POST['campaign'].xtc_product_link($products['products_id'], $products['products_name']) . ";" .
						$products['products_ean'] .';'.  
						$image.";".                 
                        number_format($versand,2,',','').";".
						$_POST['heandlernummer'] ."\n";
						}


          $fp = fopen(DIR_FS_DOCUMENT_ROOT.'export/' . $file, "w+");
          fputs($fp, $schema);
          fclose($fp);




      switch ($_POST['export']) {
        case 'yes':
            // send File to Browser
            $extension = substr($file, -3);
            $fp = fopen(DIR_FS_DOCUMENT_ROOT.'export/' . $file,"rb");
            $buffer = fread($fp, filesize(DIR_FS_DOCUMENT_ROOT.'export/' . $file));
            fclose($fp);
            header('Content-type: application/x-octet-stream');
            header('Content-disposition: attachment; filename=' . $file);
            echo $buffer;
            exit;


        break;
        }


    }

    function buildCAT($catID)
    {


        if (isset($this->CAT[$catID]))
        {
         return  $this->CAT[$catID];
        } else {
           $cat=array();
           $tmpID=$catID;


               while ($this->getParent($catID)!=0 || $catID!=0)
               {
                    $cat_select=xtc_db_query("SELECT categories_name FROM ".TABLE_CATEGORIES_DESCRIPTION." WHERE categories_id='".$catID."' and language_id='".$_SESSION['languages_id']."'");
                    $cat_data=xtc_db_fetch_array($cat_select);
                    $catID=$this->getParent($catID);
                    $cat[]=$cat_data['categories_name'];


               }
               $catStr='';
               for ($i=count($cat);$i>0;$i--)
               {
                  $catStr.=$cat[$i-1].' > ';
               }
               $this->CAT[$tmpID]=$catStr;
        return $this->CAT[$tmpID];
        }
    }

   function getParent($catID)
    {
      if (isset($this->PARENT[$catID]))
      {
       return $this->PARENT[$catID];
      } else {
       $parent_query=xtc_db_query("SELECT parent_id FROM ".TABLE_CATEGORIES." WHERE categories_id='".$catID."'");
       $parent_data=xtc_db_fetch_array($parent_query);
       $this->PARENT[$catID]=$parent_data['parent_id'];
       return  $parent_data['parent_id'];
      }
    }


    function display() {


    $customers_statuses_array = xtc_get_customers_statuses();


    $curr='';
		$currencies=xtc_db_query("SELECT code FROM ".TABLE_CURRENCIES);
		while ($currencies_data=xtc_db_fetch_array($currencies)) {
			$curr.=xtc_draw_radio_field('currencies', $currencies_data['code'],true).$currencies_data['code'].'<br />';
		}
		$campaign_array = array(array('id' => '', 'text' => TEXT_NONE));
		$campaign_query = xtc_db_query("select campaigns_name, campaigns_refID from ".TABLE_CAMPAIGNS." order by campaigns_id");
		while ($campaign = xtc_db_fetch_array($campaign_query)) {
			$campaign_array[] = array ('id' => 'refID='.$campaign['campaigns_refID'], 'text' => $campaign['campaigns_name'],);
		}
		$shipping_country_array = array(array('id' => '', 'text' => TEXT_NONE));
		$shipping_country_query = xtc_db_query("SELECT countries_iso_code_2 FROM ".TABLE_COUNTRIES." ORDER BY countries_iso_code_2");
		while ($shipping_country = xtc_db_fetch_array($shipping_country_query)) {
			$shipping_country_array[] = array('id' => strtoupper($shipping_country['countries_iso_code_2']), 'text' => strtoupper($shipping_country['countries_iso_code_2']),);
		}
    return array('text' =>  EXPORT_STATUS_TYPE.'<br>'.
                          	EXPORT_STATUS.'<br>'.
                          	xtc_draw_pull_down_menu('status',$customers_statuses_array, '1').'<br>'.
                            CURRENCY.'<br>'.
                            CURRENCY_DESC.'<br>'.
                            $curr.'<b>'.
							MODULE_PREISWUNDER24_HEANDLERNUMMER_TITLE.'</b><br />'.
							MODULE_PREISWUNDER24_HEANDLERNUMMER_DESC.'<br />'.
							xtc_draw_input_field('heandlernummer',MODULE_HEANDLER_NUMMER).'<br />'.'<b>'.
							MODULE_PREISWUNDER24_SHIPPING_COST_TITLE.'</b><br />'.
							MODULE_PREISWUNDER24_SHIPPING_COST_DESC.'<br />'.
							xtc_draw_input_field('shippingcosts',MODULE_PREISWUNDER24_SHIPPING_COST).'<br />'.'<b>'.
							MODULE_PREISWUNDER24_SHIPPING_ART_TITLE.'</b><br />'.
							MODULE_PREISWUNDER24_SHIPPING_ART_DESC.'<br />'.
							xtc_draw_radio_field('shippingart', 'weight',true).'Versandksten nach Gewicht<br />'.
							xtc_draw_radio_field('shippingart', 'price',false).'Versandkosten nach Preis<br />'.
                            CAMPAIGNS.'<br>'.
                            CAMPAIGNS_DESC.'<br>'.
                          	xtc_draw_pull_down_menu('campaign',$campaign_array).'<br>'.                            
                            EXPORT_TYPE.'<br>'.
                            EXPORT.'<br>'.
                          	xtc_draw_radio_field('export', 'no',false).EXPORT_NO.'<br>'.
                            xtc_draw_radio_field('export', 'yes',true).EXPORT_YES.'<br>'.
                            '<br>' . xtc_button(BUTTON_EXPORT) .
                            xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_MODULE_EXPORT, 'set=' . $_GET['set'] . '&module=preiswunder24')));




    }


    function check() {
      if (!isset($this->_check)) {
        $check_query = xtc_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PREISWUNDER24_STATUS'");
        $this->_check = xtc_db_num_rows($check_query);
      }
      return $this->_check;
    }


    function install() {
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, set_function, date_added) values ('MODULE_PREISWUNDER24_FILE', 'preiswunder24.csv', '6', '1', '', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, set_function, date_added) values ('MODULE_PREISWUNDER24_STATUS', 'True',  '6', '1', 'xtc_cfg_select_option(array(\'True\', \'False\'), ', now())");
	  xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_PREISWUNDER24_SHIPPING_COST', '25:6.90,50:9.90,10000:0.00', '6', '1', '', '', now())");
	  xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_HEANDLER_NUMMER', '00000', '6', '1', '', '', now())");
	}

	function remove() {
      xtc_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
	  xtc_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PREISWUNDER24_SHIPPING_COST'");
	  xtc_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_HEANDLER_NUMMER'");
    }


    function keys() {
      return array('MODULE_PREISWUNDER24_STATUS','MODULE_PREISWUNDER24_FILE');
    }


  }
?>

Alles anzeigen

mfg

irrtum1

1. Teil, da länger als 2000 Zeichen

Gambio Modul

PHP

<?php
/* -----------------------------------------------------------------------------------------
   $Id: preiswunder25.php 2009-10-15 $


   XT-Commerce - community made shopping
   http://www.xt-commerce.com

   LexService - Die wahrscheinlich günstigste Versuchung
   http://www.lexservice.de

   Copyright (c) 2003 XT-Commerce
   Copyright (c) 2008 LexService
   -----------------------------------------------------------------------------------------
   based on: 
   (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
   (c) 2002-2003 osCommerce(cod.php,v 1.28 2003/02/14); www.oscommerce.com 
   (c) 2003	 nextcommerce (invoice.php,v 1.6 2003/08/24); www.nextcommerce.org


   Released under the GNU General Public License
   ---------------------------------------------------------------------------------------*/
defined( '_VALID_XTC' ) or die( 'Direct Access to this location is not allowed.' );


define('MODULE_PREISWUNDER24_TEXT_DESCRIPTION', '<hr noshade="noshade"><br><center><a href="http://www.lexservice.de/" target="_blank" title="LexService"><img src="http://www.lexservice.de/img/lexservice_modul.gif" width="100" border="0" alt="LexService" /></a></center><br><br>
<b>Export</b><br>PreisWunder24.de<br><br>
<b>Trennzeichen</b><br>getrennt durch (; getrennt)<br><br>
<b>Format</b><br>- Artikelbezeichnung<br>- Preis<br>- Artikelbeschreibung<br>- Deeplink<br>- EAN Nummer<br>- Produktbild URL<br>- Versandkosten<br>- Händlernummer<br><br>
<b>Modulversion</b><br>PreisWunder24.de - <i>Januar 2010 - v2.0</i><br><br>
<b>Fragen</b><br>LexService<br><br>Tel: 01805/909555<br>E-Mail:<a href="mailto:info@lexservice.de?SUBJECT=Fragen zum PreisWunder24-Modul v2.0 (Gambio)"><u>info@lexservice.de</u></a>');
define('MODULE_PREISWUNDER24_TEXT_TITLE', 'PreisWunder24.de - CSV');
define('MODULE_PREISWUNDER24_FILE_TITLE' , '<hr noshade>Dateiname');
define('MODULE_PREISWUNDER24_FILE_DESC' , 'Geben Sie einen Dateinamen ein, falls die Exportadatei am Server gespeichert werden soll.<br>(Verzeichnis export/)');
define('MODULE_PREISWUNDER24_STATUS_DESC','Modulstatus');
define('MODULE_PREISWUNDER24_STATUS_TITLE','Status');
define('MODULE_PREISWUNDER24_CURRENCY_TITLE','W&auml;hrung');
define('MODULE_PREISWUNDER24_CURRENCY_DESC','Welche W&auml;hrung soll exportiert werden?');
define('MODULE_PREISWUNDER24_HEANDLERNUMMER_TITLE','<hr noshade><b>Ihre Händlernummer</b>');
define('MODULE_PREISWUNDER24_HEANDLERNUMMER_DESC','Tragen Sie hier Ihre Händlernummer ein die Sie von PreisWunder24 erhalten haben.');
define('MODULE_PREISWUNDER24_SHIPPING_COST_TITLE','<hr noshade><b>Versandkosten</b>');
define('MODULE_PREISWUNDER24_SHIPPING_COST_DESC','Die Versandkosten basieren auf dem Artikelpreis oder dem Artikelgewicht. Beispiel: 25:4.90,50:9.90,etc.. Bis 25 werden 4.90 verrechnet, dar&uuml;ber bis 50 werden 9.90 verrechnet, etc.');
define('MODULE_PREISWUNDER24_SHIPPING_ART_TITLE','<hr noshade><b>Versandkosten-Methode</b>');
define('MODULE_PREISWUNDER24_SHIPPING_ART_DESC','Die Versandkosten basieren auf dem Artikelpreis oder dem Artikelgewicht.');
define('EXPORT_YES','Nur Herunterladen');
define('EXPORT_NO','Am Server Speichern');
define('CURRENCY','<hr noshade><b>W&auml;hrung:</b>');
define('CURRENCY_DESC','W&auml;hrung in der Exportdatei');
define('EXPORT','Bitte den Sicherungsprozess AUF KEINEN FALL unterbrechen. Dieser kann einige Minuten in Anspruch nehmen.');
define('EXPORT_TYPE','<hr noshade><b>Speicherart:</b>');
define('EXPORT_STATUS_TYPE','<hr noshade><b>Kundengruppe:</b>');
define('EXPORT_STATUS','Bitte w&auml;hlen Sie die Kundengruppe, die Basis f&uuml;r den Exportierten Preis bildet. (Falls Sie keine Kundengruppenpreise haben, w&auml;hlen Sie <i>Gast</i>):</b>');
define('CAMPAIGNS','<hr noshade><b>Kampagnen:</b>');
define('CAMPAIGNS_DESC','Mit Kampagne zur Nachverfolgung verbinden.');
define('DATE_FORMAT_EXPORT', '%d.%m.%Y');


  class preiswunder24 {
    var $code, $title, $description, $enabled;


    function preiswunder24() {
      global $order;


      $this->code = 'preiswunder24';
      $this->title = MODULE_PREISWUNDER24_TEXT_TITLE;
      $this->description = MODULE_PREISWUNDER24_TEXT_DESCRIPTION;
      $this->sort_order = MODULE_PREISWUNDER24_SORT_ORDER;
      $this->enabled = ((MODULE_PREISWUNDER24_STATUS == 'True') ? true : false);
      $this->CAT=array();
      $this->PARENT=array();
    }


    function process($file) {


        @xtc_set_time_limit(0);
        require(DIR_FS_CATALOG.DIR_WS_CLASSES . 'xtcPrice.php');
        $xtPrice = new xtcPrice($_POST['currencies'],$_POST['status']);


        if ($_POST['shippingcosts'] != MODULE_PREISWUNDER24_SHIPPING_COST) {
			xtc_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . xtc_db_input($_POST['shippingcosts']) . "' where configuration_key = 'MODULE_PREISWUNDER24_SHIPPING_COST'");
		}

		if ($_POST['heandlernummer'] != MODULE_HEANDLER_NUMMER) {
			xtc_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . xtc_db_input($_POST['heandlernummer']) . "' where configuration_key = 'MODULE_HEANDLER_NUMMER'");
		}

        $export_query =xtc_db_query("SELECT
                             p.products_id,
                             pd.products_name,
                             pd.products_short_description,
							 pd.products_description,
							 p.products_ean,
                             p.products_image,
                             p.products_price,
                             p.products_status,
                             p.products_weight,
                             p.products_tax_class_id,
                             p.products_date_added,
                             m.manufacturers_name
                         FROM
                             " . TABLE_PRODUCTS . " p LEFT JOIN
                             " . TABLE_MANUFACTURERS . " m
                           ON p.manufacturers_id = m.manufacturers_id LEFT JOIN
                             " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           ON p.products_id = pd.products_id AND
                            pd.language_id = '".$_SESSION['languages_id']."' LEFT JOIN
                             " . TABLE_SPECIALS . " s
                           ON p.products_id = s.products_id
                         WHERE
                           p.products_status = 1
                         ORDER BY
                            p.products_date_added DESC,
                            pd.products_name");




        while ($products = xtc_db_fetch_array($export_query)) {


            $products_price = $xtPrice->xtcGetPrice($products['products_id'],
                                        $format=false,
                                        1,
                                        $products['products_tax_class_id'],
                                        '');

            $categorie_query=xtc_db_query("SELECT
                                            categories_id
                                            FROM ".TABLE_PRODUCTS_TO_CATEGORIES."
                                            WHERE products_id='".$products['products_id']."'");
             while ($categorie_data=xtc_db_fetch_array($categorie_query)) {
                    $categories=$categorie_data['categories_id'];
             }


		    $products_name = strip_tags($products['products_name']);         
            $products_name = str_replace("<br>"," ",$products_name);
            $products_name = str_replace("<br />"," ",$products_name);
            $products_name = str_replace(";",", ",$products_name);
            $products_name = str_replace("'",", ",$products_name);
			$products_name = str_replace("|",", ",$products_name);
            $products_name = str_replace("\n"," ",$products_name);
            $products_name = str_replace("\r"," ",$products_name);
            $products_name = str_replace("\t"," ",$products_name);
            $products_name = str_replace("\v"," ",$products_name);
            $products_name = str_replace("&quot,"," \"",$products_name);
            $products_name = str_replace("&qout,"," \"",$products_name);
            $products_name = str_replace(chr(13)," ",$products_name);

            $products_short_description = strip_tags($products['products_short_description']);         
            $products_short_description = str_replace("<br>"," ",$products_short_description);
            $products_short_description = str_replace("<br />"," ",$products_short_description);
            $products_short_description = str_replace(";",", ",$products_short_description);
            $products_short_description = str_replace("'",", ",$products_short_description);
			$products_short_description = str_replace("|",", ",$products_short_description);
            $products_short_description = str_replace("\n"," ",$products_short_description);
            $products_short_description = str_replace("\r"," ",$products_short_description);
            $products_short_description = str_replace("\t"," ",$products_short_description);
            $products_short_description = str_replace("\v"," ",$products_short_description);
            $products_short_description = str_replace("&quot,"," \"",$products_short_description);
            $products_short_description = str_replace("&qout,"," \"",$products_short_description);
            $products_short_description = str_replace(chr(13)," ",$products_short_description);
            $products_short_description = substr($products_short_description, 0, 255);

			$products_description = strip_tags($products['products_description']);         
            $products_description = str_replace("<br>"," ",$products_description);
            $products_description = str_replace("<br />"," ",$products_description);
            $products_description = str_replace(";",", ",$products_description);
            $products_description = str_replace("'",", ",$products_description);
			$products_description = str_replace("|",", ",$products_description);
            $products_description = str_replace("\n"," ",$products_description);
            $products_description = str_replace("\r"," ",$products_description);
            $products_description = str_replace("\t"," ",$products_description);
            $products_description = str_replace("\v"," ",$products_description);
            $products_description = str_replace("&quot,"," \"",$products_description);
            $products_description = str_replace("&qout,"," \"",$products_description);
            $products_description = str_replace(chr(13)," ",$products_description);
            $products_description = substr($products_description, 0, 255);

Alles anzeigen

irrtum1

so, da es noch ein Modul des Anbieters für Gambio Shops gibt, habe ich das doch einfach mal hochgeladen.

Dieses Modul liest die Artikelbeschreibungen aus ohne ein Prob

um Fragen vorzubeugen, ich habe den commerce:Seo V1.1.1 CE Shop Installiert!!!

mfg

irrtum1

ja ja, auch das habe ich schon versucht!

irrtum1

Hallo,
ja so schlau war ich aber auch schon, doch auch nach der Änderung werden die Beschreibungen nicht ausgelesen.
Habe halt mal das Org. Modul hier veröffentlicht.

mfg

irrtum1

@
Nu werden aber die Artikelbeschreibungen nicht eingelesen

irrtum1

Hallo,
ich habe für die Preissuchmaschiene preiswunder24.de ein Modul welches für den xtc 3.0.4 SP2.1 funktionieren soll.
Nu werden aber die Artikelbeschreibungen nicht eingelesen, laut Anbieter soll alles funktionieren, vielleicht kann mal jemand über das Modul schauen.

schon mal danke
irrtum1

PHP

<?php
/* -----------------------------------------------------------------------------------------

   ---------------------------------------------------------------------------------------*/
defined( '_VALID_XTC' ) or die( 'Direct Access to this location is not allowed.' );


define('MODULE_PREISWUNDER24_TEXT_DESCRIPTION', '<hr noshade="noshade"><br><center><a href="http://www.lexservice.de/" target="_blank" title="LexService"><img src="http://www.lexservice.de/img/lexservice_modul.gif" width="100" border="0" alt="LexService" /></a></center><br><br>
<b>Export</b><br>PreisWunder24.de<br><br>
<b>Trennzeichen</b><br>getrennt durch (; getrennt)<br><br>
<b>Format</b><br>- Artikelbezeichnung<br>- Preis<br>- Artikelbeschreibung<br>- Deeplink<br>- EAN Nummer<br>- Produktbild URL<br>- Versandkosten<br>- Händlernummer<br><br>
<b>Modulversion</b><br>PreisWunder24.de - <i>Oktober 2009 - v1.0</i><br><br>
<b>Fragen</b><br>LexService<br><br>Tel: 01805/909555<br>E-Mail:<a href="mailto:info@lexservice.de?SUBJECT=Fragen zum PreisWunder24-Modul v1.0 (xtCommerce)"><u>info@lexservice.de</u></a>');
define('MODULE_PREISWUNDER24_TEXT_TITLE', 'PreisWunder24.de - CSV');
define('MODULE_PREISWUNDER24_FILE_TITLE' , '<hr noshade>Dateiname');
define('MODULE_PREISWUNDER24_FILE_DESC' , 'Geben Sie einen Dateinamen ein, falls die Exportadatei am Server gespeichert werden soll.<br>(Verzeichnis export/)');
define('MODULE_PREISWUNDER24_STATUS_DESC','Modulstatus');
define('MODULE_PREISWUNDER24_STATUS_TITLE','Status');
define('MODULE_PREISWUNDER24_CURRENCY_TITLE','W&auml;hrung');
define('MODULE_PREISWUNDER24_CURRENCY_DESC','Welche W&auml;hrung soll exportiert werden?');
define('MODULE_PREISWUNDER24_HEANDLERNUMMER_TITLE','<hr noshade><b>Ihre Händlernummer</b>');
define('MODULE_PREISWUNDER24_HEANDLERNUMMER_DESC','Tragen Sie hier Ihre Händlernummer ein die Sie von PreisWunder24 erhalten haben.');
define('MODULE_PREISWUNDER24_SHIPPING_COST_TITLE','<hr noshade><b>Versandkosten</b>');
define('MODULE_PREISWUNDER24_SHIPPING_COST_DESC','Die Versandkosten basieren auf dem Artikelpreis oder dem Artikelgewicht. Beispiel: 25:4.90,50:9.90,etc.. Bis 25 werden 4.90 verrechnet, dar&uuml;ber bis 50 werden 9.90 verrechnet, etc.');
define('MODULE_PREISWUNDER24_SHIPPING_ART_TITLE','<hr noshade><b>Versandkosten-Methode</b>');
define('MODULE_PREISWUNDER24_SHIPPING_ART_DESC','Die Versandkosten basieren auf dem Artikelpreis oder dem Artikelgewicht.');
define('EXPORT_YES','Nur Herunterladen');
define('EXPORT_NO','Am Server Speichern');
define('CURRENCY','<hr noshade><b>W&auml;hrung:</b>');
define('CURRENCY_DESC','W&auml;hrung in der Exportdatei');
define('EXPORT','Bitte den Sicherungsprozess AUF KEINEN FALL unterbrechen. Dieser kann einige Minuten in Anspruch nehmen.');
define('EXPORT_TYPE','<hr noshade><b>Speicherart:</b>');
define('EXPORT_STATUS_TYPE','<hr noshade><b>Kundengruppe:</b>');
define('EXPORT_STATUS','Bitte w&auml;hlen Sie die Kundengruppe, die Basis f&uuml;r den Exportierten Preis bildet. (Falls Sie keine Kundengruppenpreise haben, w&auml;hlen Sie <i>Gast</i>):</b>');
define('CAMPAIGNS','<hr noshade><b>Kampagnen:</b>');
define('CAMPAIGNS_DESC','Mit Kampagne zur Nachverfolgung verbinden.');
define('DATE_FORMAT_EXPORT', '%d.%m.%Y');


  class preiswunder24 {
    var $code, $title, $description, $enabled;


    function preiswunder24() {
      global $order;


      $this->code = 'preiswunder24';
      $this->title = MODULE_PREISWUNDER24_TEXT_TITLE;
      $this->description = MODULE_PREISWUNDER24_TEXT_DESCRIPTION;
      $this->sort_order = MODULE_PREISWUNDER24_SORT_ORDER;
      $this->enabled = ((MODULE_PREISWUNDER24_STATUS == 'True') ? true : false);
      $this->CAT=array();
      $this->PARENT=array();
    }


    function process($file) {


        @xtc_set_time_limit(0);
        require(DIR_FS_CATALOG.DIR_WS_CLASSES . 'xtcPrice.php');
        $xtPrice = new xtcPrice($_POST['currencies'],$_POST['status']);


        if ($_POST['shippingcosts'] != MODULE_PREISWUNDER24_SHIPPING_COST) {
			xtc_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . xtc_db_input($_POST['shippingcosts']) . "' where configuration_key = 'MODULE_PREISWUNDER24_SHIPPING_COST'");
		}

		if ($_POST['heandlernummer'] != MODULE_HEANDLER_NUMMER) {
			xtc_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . xtc_db_input($_POST['heandlernummer']) . "' where configuration_key = 'MODULE_HEANDLER_NUMMER'");
		}

        $export_query =xtc_db_query("SELECT
                             p.products_id,
                             pd.products_name,
                             pd.products_short_description,
							 p.products_ean,
                             p.products_image,
                             p.products_price,
                             p.products_status,
                             p.products_weight,
                             p.products_tax_class_id,
                             p.products_date_added,
                             m.manufacturers_name
                         FROM
                             " . TABLE_PRODUCTS . " p LEFT JOIN
                             " . TABLE_MANUFACTURERS . " m
                           ON p.manufacturers_id = m.manufacturers_id LEFT JOIN
                             " . TABLE_PRODUCTS_DESCRIPTION . " pd
                           ON p.products_id = pd.products_id AND
                            pd.language_id = '".$_SESSION['languages_id']."' LEFT JOIN
                             " . TABLE_SPECIALS . " s
                           ON p.products_id = s.products_id
                         WHERE
                           p.products_status = 1
                         ORDER BY
                            p.products_date_added DESC,
                            pd.products_name");




        while ($products = xtc_db_fetch_array($export_query)) {


            $products_price = $xtPrice->xtcGetPrice($products['products_id'],
                                        $format=false,
                                        1,
                                        $products['products_tax_class_id'],
                                        '');

            $categorie_query=xtc_db_query("SELECT
                                            categories_id
                                            FROM ".TABLE_PRODUCTS_TO_CATEGORIES."
                                            WHERE products_id='".$products['products_id']."'");
             while ($categorie_data=xtc_db_fetch_array($categorie_query)) {
                    $categories=$categorie_data['categories_id'];
             }


		    $products_name = strip_tags($products['products_name']);         
            $products_name = str_replace("<br>"," ",$products_name);
            $products_name = str_replace("<br />"," ",$products_name);
            $products_name = str_replace(";",", ",$products_name);
            $products_name = str_replace("'",", ",$products_name);
			$products_name = str_replace("|",", ",$products_name);
            $products_name = str_replace("\n"," ",$products_name);
            $products_name = str_replace("\r"," ",$products_name);
            $products_name = str_replace("\t"," ",$products_name);
            $products_name = str_replace("\v"," ",$products_name);
            $products_name = str_replace("&quot,"," \"",$products_name);
            $products_name = str_replace("&qout,"," \"",$products_name);
            $products_name = str_replace(chr(13)," ",$products_name);

            $products_short_description = strip_tags($products['products_short_description']);         
            $products_short_description = str_replace("<br>"," ",$products_short_description);
            $products_short_description = str_replace("<br />"," ",$products_short_description);
            $products_short_description = str_replace(";",", ",$products_short_description);
            $products_short_description = str_replace("'",", ",$products_short_description);
			$products_short_description = str_replace("|",", ",$products_short_description);
            $products_short_description = str_replace("\n"," ",$products_short_description);
            $products_short_description = str_replace("\r"," ",$products_short_description);
            $products_short_description = str_replace("\t"," ",$products_short_description);
            $products_short_description = str_replace("\v"," ",$products_short_description);
            $products_short_description = str_replace("&quot,"," \"",$products_short_description);
            $products_short_description = str_replace("&qout,"," \"",$products_short_description);
            $products_short_description = str_replace(chr(13)," ",$products_short_description);
            $products_short_description = substr($products_short_description, 0, 255);
			$products_description = substr($products_description, 0, 65536);

	if ($_POST['shippingcosts'] != MODULE_PREISWUNDER24_SHIPPING_COST) {
			xtc_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . xtc_db_input($_POST['shippingcosts']) . "' where configuration_key = 'MODULE_PREISWUNDER24_SHIPPING_COST'");
		} 

	if ($products['products_image'] != ''){
	    $image = HTTP_CATALOG_SERVER . DIR_WS_CATALOG_ORIGINAL_IMAGES .$products['products_image'];
	}else{
	    $image = '';
	}
	if ($products['products_weight'] != '0.00'){
				$weight = number_format($products['products_weight'],2,'.','');
			} else {
				$weight = '';
			}
			$versand = '0.00';
			if ($products_price < MODULE_ORDER_TOTAL_LOWORDERFEE_ORDER_UNDER && MODULE_ORDER_TOTAL_LOWORDERFEE_STATUS == 'true') {
				$customers_tax_query = xtc_db_query("SELECT customers_status_show_price_tax, customers_status_add_tax_ot FROM " . TABLE_CUSTOMERS_STATUS . " WHERE customers_status_id = '" . (int)$_POST['status'] . "' AND language_id = '" . (int)$_SESSION['languages_id'] . "'");
				$customers_tax_value = xtc_db_fetch_array($customers_tax_query);
				$tax = xtc_get_tax_rate(MODULE_ORDER_TOTAL_LOWORDERFEE_TAX_CLASS);
				if ($customers_tax_value['customers_status_show_price_tax'] == 1) {
					$low_order_fee = xtc_add_tax(MODULE_ORDER_TOTAL_LOWORDERFEE_FEE, $tax);
				}
				if ($customers_tax_value['customers_status_show_price_tax'] == 0 && $customers_tax_value['customers_status_add_tax_ot'] == 1) {
					$low_order_fee = MODULE_ORDER_TOTAL_LOWORDERFEE_FEE;
				}
				if ($customers_tax_value['customers_status_show_price_tax'] == 0 && $customers_tax_value['customers_status_add_tax_ot'] != 1) {
					$low_order_fee = MODULE_ORDER_TOTAL_LOWORDERFEE_FEE;
				}
				$versand = $versand + $low_order_fee;
			}
            if ($products_price > MODULE_SHIPPING_FREEAMOUNT_AMOUNT && MODULE_SHIPPING_FREEAMOUNT_STATUS == 'True') {
				$versand = $versand;
			} else if ($products_price > MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER && MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING == 'true') {
				$versand = $versand;
			} else {
				$shipping = -1;
				$shippinglist = split("[:,]" , $_POST['shippingcosts']);
				for ($i=0; $i<sizeof($shippinglist); $i+=2) {
					if ($_POST['shippingart'] == 'weight') {
				  		if ($products['products_weight'] <= $shippinglist[$i]) {
							$shipping = $shippinglist[$i+1];
							break;
				  		}
					} else if ($_POST['shippingart'] == 'price') {
						if ($products_price <= $shippinglist[$i]) {
							$shipping = $shippinglist[$i+1];
							break;
				  		}
					}
				}	
				if ($shipping == -1) {
				  $shipping_cost = 0;
				} else {
				  $shipping_cost = $shipping;
				}
				$versand = $versand + $shipping_cost;
			}


            $schema .=  $products_name.";".
            			number_format($products_price,2,',','') .';'.
            			$products_short_description.";".
                        HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'product_info.php?'.$_POST['campaign'].xtc_product_link($products['products_id'], $products['products_name']) . ";" .
						$products['products_ean'] .';'.  
						$image.";".                 
                        number_format($versand,2,',','').";".
						$_POST['heandlernummer'] ."\n";
						}


          $fp = fopen(DIR_FS_DOCUMENT_ROOT.'export/' . $file, "w+");
          fputs($fp, $schema);
          fclose($fp);




      switch ($_POST['export']) {
        case 'yes':
            // send File to Browser
            $extension = substr($file, -3);
            $fp = fopen(DIR_FS_DOCUMENT_ROOT.'export/' . $file,"rb");
            $buffer = fread($fp, filesize(DIR_FS_DOCUMENT_ROOT.'export/' . $file));
            fclose($fp);
            header('Content-type: application/x-octet-stream');
            header('Content-disposition: attachment; filename=' . $file);
            echo $buffer;
            exit;


        break;
        }


    }

    function buildCAT($catID)
    {


        if (isset($this->CAT[$catID]))
        {
         return  $this->CAT[$catID];
        } else {
           $cat=array();
           $tmpID=$catID;


               while ($this->getParent($catID)!=0 || $catID!=0)
               {
                    $cat_select=xtc_db_query("SELECT categories_name FROM ".TABLE_CATEGORIES_DESCRIPTION." WHERE categories_id='".$catID."' and language_id='".$_SESSION['languages_id']."'");
                    $cat_data=xtc_db_fetch_array($cat_select);
                    $catID=$this->getParent($catID);
                    $cat[]=$cat_data['categories_name'];


               }
               $catStr='';
               for ($i=count($cat);$i>0;$i--)
               {
                  $catStr.=$cat[$i-1].' > ';
               }
               $this->CAT[$tmpID]=$catStr;
        return $this->CAT[$tmpID];
        }
    }

   function getParent($catID)
    {
      if (isset($this->PARENT[$catID]))
      {
       return $this->PARENT[$catID];
      } else {
       $parent_query=xtc_db_query("SELECT parent_id FROM ".TABLE_CATEGORIES." WHERE categories_id='".$catID."'");
       $parent_data=xtc_db_fetch_array($parent_query);
       $this->PARENT[$catID]=$parent_data['parent_id'];
       return  $parent_data['parent_id'];
      }
    }


    function display() {


    $customers_statuses_array = xtc_get_customers_statuses();


    $curr='';
		$currencies=xtc_db_query("SELECT code FROM ".TABLE_CURRENCIES);
		while ($currencies_data=xtc_db_fetch_array($currencies)) {
			$curr.=xtc_draw_radio_field('currencies', $currencies_data['code'],true).$currencies_data['code'].'<br />';
		}
		$campaign_array = array(array('id' => '', 'text' => TEXT_NONE));
		$campaign_query = xtc_db_query("select campaigns_name, campaigns_refID from ".TABLE_CAMPAIGNS." order by campaigns_id");
		while ($campaign = xtc_db_fetch_array($campaign_query)) {
			$campaign_array[] = array ('id' => 'refID='.$campaign['campaigns_refID'], 'text' => $campaign['campaigns_name'],);
		}
		$shipping_country_array = array(array('id' => '', 'text' => TEXT_NONE));
		$shipping_country_query = xtc_db_query("SELECT countries_iso_code_2 FROM ".TABLE_COUNTRIES." ORDER BY countries_iso_code_2");
		while ($shipping_country = xtc_db_fetch_array($shipping_country_query)) {
			$shipping_country_array[] = array('id' => strtoupper($shipping_country['countries_iso_code_2']), 'text' => strtoupper($shipping_country['countries_iso_code_2']),);
		}
    return array('text' =>  EXPORT_STATUS_TYPE.'<br>'.
                          	EXPORT_STATUS.'<br>'.
                          	xtc_draw_pull_down_menu('status',$customers_statuses_array, '1').'<br>'.
                            CURRENCY.'<br>'.
                            CURRENCY_DESC.'<br>'.
                            $curr.'<b>'.
							MODULE_PREISWUNDER24_HEANDLERNUMMER_TITLE.'</b><br />'.
							MODULE_PREISWUNDER24_HEANDLERNUMMER_DESC.'<br />'.
							xtc_draw_input_field('heandlernummer',MODULE_HEANDLER_NUMMER).'<br />'.'<b>'.
							MODULE_PREISWUNDER24_SHIPPING_COST_TITLE.'</b><br />'.
							MODULE_PREISWUNDER24_SHIPPING_COST_DESC.'<br />'.
							xtc_draw_input_field('shippingcosts',MODULE_PREISWUNDER24_SHIPPING_COST).'<br />'.'<b>'.
							MODULE_PREISWUNDER24_SHIPPING_ART_TITLE.'</b><br />'.
							MODULE_PREISWUNDER24_SHIPPING_ART_DESC.'<br />'.
							xtc_draw_radio_field('shippingart', 'weight',true).'Versandksten nach Gewicht<br />'.
							xtc_draw_radio_field('shippingart', 'price',false).'Versandkosten nach Preis<br />'.
                            CAMPAIGNS.'<br>'.
                            CAMPAIGNS_DESC.'<br>'.
                          	xtc_draw_pull_down_menu('campaign',$campaign_array).'<br>'.                            
                            EXPORT_TYPE.'<br>'.
                            EXPORT.'<br>'.
                          	xtc_draw_radio_field('export', 'no',false).EXPORT_NO.'<br>'.
                            xtc_draw_radio_field('export', 'yes',true).EXPORT_YES.'<br>'.
                            '<br>' . xtc_button(BUTTON_EXPORT) .
                            xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_MODULE_EXPORT, 'set=' . $_GET['set'] . '&module=preiswunder24')));




    }


    function check() {
      if (!isset($this->_check)) {
        $check_query = xtc_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PREISWUNDER24_STATUS'");
        $this->_check = xtc_db_num_rows($check_query);
      }
      return $this->_check;
    }


    function install() {
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, set_function, date_added) values ('MODULE_PREISWUNDER24_FILE', 'preiswunder24.csv', '6', '1', '', now())");
      xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, set_function, date_added) values ('MODULE_PREISWUNDER24_STATUS', 'True',  '6', '1', 'xtc_cfg_select_option(array(\'True\', \'False\'), ', now())");
	  xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_PREISWUNDER24_SHIPPING_COST', '25:6.90,50:9.90,10000:0.00', '6', '1', '', '', now())");
	  xtc_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_key, configuration_value,  configuration_group_id, sort_order, use_function, set_function, date_added) values ('MODULE_HEANDLER_NUMMER', '00000', '6', '1', '', '', now())");
	}

	function remove() {
      xtc_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
	  xtc_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PREISWUNDER24_SHIPPING_COST'");
	  xtc_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_HEANDLER_NUMMER'");
    }


    function keys() {
      return array('MODULE_PREISWUNDER24_STATUS','MODULE_PREISWUNDER24_FILE');
    }


  }
?>

Alles anzeigen

irrtum1

mh,
lag wohl an meinem Hoster (HE), nu gibt es keine Fehlermeldung mehr.

irrtum1

Hallo,
bekomme seit heute in wer ist Online folgenden Fehler. Habe nix an Dateien derzeit geändert. Datenbank habe ich auch schon zurückgesetzt (repariert)

PHP

Warning: Variable passed to each() is not an array or object in /is/htdocs/wpXXXXXX_XXXXXXX/cseo/admin/whos_online.php  on line 31

ist in der .php Datei Zeile 31 folgendes:

PHP

while (list($products_id, ) = each($session['cart']->contents)) {
        $products_query = xtc_db_query("select p.products_id, pd.products_name,p.products_image, p.products_model, p.products_price, p.products_discount_allowed, p.products_weight, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id='" . xtc_get_prid($products_id) . "' and pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "'");
        if ($products = xtc_db_fetch_array($products_query)) {
          $prid = $products['products_id'];

schon mal danke für Eure Hilfe.

Gruß
irrtum1

irrtum1

jeb, da waren versteckt noch 3 Bilder eingebunden, nu funzt alles wie es soll.

Dankee

irrtum1

so, aber jetzt.
Ich hab's gefunden, das Tag Cloud Modul ist es.

Muss jetzt nur noch raus finden, wie ich den so umbaue, das er die SSL Verschlüsselung nicht stört
oder weis jemand der das Modul auch hat, wo der Fehler liegt?

Gruß

irrtum1

habe jetzt so die Vermutung, dass es am RSS Feed liegen könnte.
Mit der alten xt Commerce Version hatte ich dieses Prob nicht, da kein RSS-Feed eingebunden war.

Bräuchte dahingehend wirklich eure Hilfe, da es schon weniger Bestellungen gibt.

Danke

irrtum1

Hallo,
ich habe im Shop SSL aktiviert, jetzt ist es so, dass im IE alles wunderbar funzt. Das Schloss bleibt sichtbar und geschlossen.
Im Firefox 3.6 springt die Farbige-Anzeige für das SSL aber immer wieder zurück, so das es keine 100% Verschlüsselung darstellt.

Das ganze wenn man den Warenkorb aufruft oder sich einloggt.
Logge ich mich in den Admin ist alles wunderbar, da das RSS Feed nicht in der Adresszeile erscheint!

Gehostet bei Host Europe, Webpack

Kann mir jemand helfen.

Vielen Dank

http://www.rl-technikshop.de

irrtum1

im Safari Browser bekomme ich keine Meldung.

Sorry

irrtum1

ich kann mich schon mal nicht einloggen, bekomme die Fehlermeldung

Zitat

demov2.xt-seo.de verwendet ein ungültiges Sicherheitszertifikat.

Dem Zertifikat wird nicht vertraut, weil es vom Aussteller selbst signiert wurde.
Das Zertifikat gilt nur für <a id="cert_domain_link" title="plesk">plesk</a>.

(Fehlercode: sec_error_untrusted_issuer)

Gruß

irrtum1

Ja das habe ich mir schon gedacht, das nix passiert.
Wollte aber nur auf nummer sicher gehen mit meiner Frage.

Datenbanken wurden logischerweise schon gesichert.

Danke

Beiträge von irrtum1

keine übernahme der Tel: nr. bei Anmeldung und Datenbank-Fehler.

Statusänderung in Bestellbearbeitung Fehler bei PayPal Express Zahlung !!!!

Modul preiswunder24 funzt nicht richtig.

keine übernahme der Tel: nr. bei Anmeldung und Datenbank-Fehler.

Modul preiswunder24 funzt nicht richtig.

Modul preiswunder24 funzt nicht richtig.

Modul preiswunder24 funzt nicht richtig.

Modul preiswunder24 funzt nicht richtig.

Modul preiswunder24 funzt nicht richtig.

Modul preiswunder24 funzt nicht richtig.

Modul preiswunder24 funzt nicht richtig.

Fehler in Wer ist Online!

Fehler in Wer ist Online!

SSL im Firefox funzt nicht???

SSL im Firefox funzt nicht???

SSL im Firefox funzt nicht???

SSL im Firefox funzt nicht???

commerce:SEO v2 DEMO

commerce:SEO v2 DEMO

Datenbank Update bei Hosteurope!!!