0000021: impossible de creer une commande if ( isSet($HTTP_GET_VARS['Customer_nr']) ) { $customer_nr = $HTTP_GET_VARS['Customer_nr']; if ( is_int($customer_nr) ) { $query_where = "(a.customers_id = '" . $customer_nr . "')"; } else { $query_where = "(a.customers_firstname like '" . $customer_nr . "%'" . "or a.customers_lastname like '" . $customer_nr . "%'" . "or b.entry_company like '" . $customer_nr . "%')"; } // $query = tep_db_query("select a.customers_id, a.customers_gender, a.customers_firstname, a.customers_lastname, b.entry_company, b.entry_city, c.zone_code from " . TABLE_CUSTOMERS . " AS a, " . TABLE_ADDRESS_BOOK . " AS b LEFT JOIN " . TABLE_ZONES . " as c ON (b.entry_zone_id = c.zone_id) WHERE a.customers_default_address_id = b.address_book_id ORDER BY entry_company,customers_lastname"); $query = tep_db_query("select a.customers_id, a.customers_gender, a.customers_firstname, a.customers_lastname, b.entry_company, b.entry_city, c.zone_code from " . TABLE_CUSTOMERS . " AS a, " . TABLE_ADDRESS_BOOK . " AS b LEFT JOIN " . TABLE_ZONES . " as c ON (b.entry_zone_id = c.zone_id) WHERE a.customers_default_address_id = b.address_book_id AND " . $query_where . " ORDER BY entry_company,customers_lastname"); $result = $query; } $SelectCustomerBox = ""; if ($customer_nr != "" and tep_db_num_rows($result) > 0){ // <- 0000021 // Query Successful $SelectCustomerBox = "" . TEXT_SELECT_CUST . "\n"; while($db_Row = tep_db_fetch_array($result)){ $SelectCustomerBox .= "\n"; }else{ $SelectCustomerBox .= ">" . (empty($db_Row['entry_company']) ? "": strtoupper($db_Row['entry_company']) . " - " ) . $db_Row['customers_lastname'] . " , " . $db_Row['customers_firstname'] . " - " . $db_Row['entry_city'] . ", " . $db_Row['zone_code'] . "\n"; } } // -> 0000021: impossible de creer une commande $SelectCustomerBox .= "\n"; } // <- 0000021 $query = tep_db_query("select code, value from " . TABLE_CURRENCIES . " ORDER BY code"); $result = $query; if (tep_db_num_rows($result) > 0){ // Query Successful $SelectCurrencyBox = "" . TEXT_SELECT_CURRENCY . "\n"; while($db_Row = tep_db_fetch_array($result)){ $SelectCurrencyBox .= "\n"; } $SelectCurrencyBox .= "\n"; } if(isSet($HTTP_GET_VARS['Customer'])){ $account_query = tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $HTTP_GET_VARS['Customer'] . "'"); $account = tep_db_fetch_array($account_query); $customer = $account['customers_id']; $address_query = tep_db_query("select * from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $HTTP_GET_VARS['Customer'] . "'"); $address = tep_db_fetch_array($address_query); }elseif (isSet($HTTP_GET_VARS['Customer_nr'])){ $account_query = tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $HTTP_GET_VARS['Customer_nr'] . "'"); $account = tep_db_fetch_array($account_query); $customer = $account['customers_id']; $address_query = tep_db_query("select * from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $HTTP_GET_VARS['Customer_nr'] . "'"); $address = tep_db_fetch_array($address_query); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ORDER_PROCESS); // #### Generate Page ?> >

\n"; print "\n"; print "\n"; // -> 0000021: problème de création de certaines commandes print "\n"; // <- 0000021 print "\n"; print "\n"; print " " . TEXT_ENTER_CUSTOMER_INFO . " \n"; print "\n"; // -> 0000021: problème de création de certaines commandes if ( $SelectCustomerBox != "" ) { print " \n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print " $SelectCustomerBox \n"; print " \n"; } // <- 0000021 ?> customers_id); ?> ' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . ''; ?>