Suche Hilfe zur Schreibreihenfolge

[micha2003]

hallo

Kann mir jemand helfen, wo wird hier die reihenfolge der daten die geschrieben werden festgelegt

function process($file) {

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

$schema = 'merchantCategory offerID name brand description deeplink imageURL prices'."\n";
$schema = 'offerID Nr.2;brand Nr.4;name Nr.3;merchantCategory Nr.1;description Nr.5;L?SCHEN;imageURL Nr.7;deeplink Nr.6;prices Nr.8;L?SCHEN'."\n";
$export_query =xtc_db_query("SELECT
p.products_id,
pd.products_name,
pd.products_description,pd.products_short_descript ion,
p.products_model,
p.products_ean,
p.products_image,
p.products_price,
p.products_status,
p.products_date_available,
p.products_shippingtime,
p.products_discount_allowed,
pd.products_meta_keywords,
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");



// get product categorie
$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_que ry)) {
$categories=$categorie_data['categories_id'];
}


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

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


// remove trash

$products_description = strip_tags($products['products_description']);
$products_description = str_replace("
"," ",$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_short_description = strip_tags($products['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("'",", ",$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);
$cat = $this->buildCAT($categories);


if ($products['products_image'] != ''){
$image = HTTP_CATALOG_SERVER . DIR_WS_CATALOG_THUMBNAIL_IMAGES .$products['products_image'];
}else{
$image = '';
}

//create content
$schema .= $products['products_id'] .";".
$products['manufacturers_name'].";".
$products['products_name'].";".
substr($cat,0,strlen($cat)-2).";".
$products_short_description.";".
$products_description.";".
$image.";".

HTTP_CATALOG_SERVER . DIR_WS_CATALOG . 'product_info.php?'.$_POST['campaign'].xtc_product_link($products['products_id'], $products['products_name']) . "; EUR" .
number_format($products_price,2,'.',''). ";" .
$products['products_ean'] ."\n";


}
// create File
$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();

// build Currency Select
$curr='';
$currencies=xtc_db_query("SELECT code FROM ".TABLE_CURRENCIES);
while ($currencies_data=xtc_db_fetch_array($currencie s)) {
$curr.=xtc_draw_radio_field('currencies', $currencies_data['code'],true).$currencies_data['code'].'
';
}

$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'],);
}

return array('text' => EXPORT_STATUS_TYPE.'
'.
EXPORT_STATUS.'
'.
xtc_draw_pull_down_menu('status',$customers_status es_array, '1').'
'.
CURRENCY.'
'.
CURRENCY_DESC.'
'.
$curr.
CAMPAIGNS.'
'.
CAMPAIGNS_DESC.'
'.
xtc_draw_pull_down_menu('campaign',$campaign_array ).'
'.
EXPORT_TYPE.'
'.
EXPORT.'
'.
xtc_draw_radio_field('export', 'no',false).EXPORT_NO.'
'.
xtc_draw_radio_field('export', 'yes',true).EXPORT_YES.'
'.
'
' . xtc_button(BUTTON_EXPORT) .
xtc_button_link(BUTTON_CANCEL, xtc_href_link(FILENAME_MODULE_EXPORT, 'set=' . $_GET['set'] . '&module=pangora')));


}

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

[aggrosoft]

Hi,

steht doch hier

create

mfg
aggro