souzadavi Posted June 30, 2008 Share Posted June 30, 2008 Pessoal aq esta um pedaço da solução para a pessoa cadastrar o complemento e o numero na hora de criar a conta possibilitando o preenchimento automatico no pagseguro. ABAIXO SEGUE INFO::::::::::: Para adicionar número e complemento novo campo, é necessário alterar os arquivos: - catalog/create_account.php - catalog/checkout_process.php - catalog/includes/classes/order.php - catalog/includes/modules/payment/pagseguro.php SQL >>> NO BANCO DE DADOS :::: TABELA address_book crie os campos após - ----- entry_lastname - entry_number_address --- varchar 64 - entry_comple_address --- varchar 64 orders crie os campos após - ----- customers_street_address - customers_number_address --- varchar 64 - customers_comple_address --- varchar 64 crie os campos após ----- delivery_street_address - delivery_number_address --- varchar 64 - delivery_comple_address --- varchar 64 crie os campor após ----- billing_street_address - billing_number_address --- varchar 64 - billing_comple_address --- varchar 64 :::::::::::::::::::::: create_account.php PROCURE POR: $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); SUBSTITUA POR $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); $number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']); $comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']); // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => $street_address, SUBSTITUIA: 'entry_street_address' => $street_address, 'entry_number_address' => $number_address, 'entry_comple_address' => $comple_address, // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: <tr> <td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('street_address') . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> SUBSTITUE POR: <tr> <td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('street_address') . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_NUMBER_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('number_address') . ' ' . (tep_not_null(ENTRY_NUMBER_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_NUMBER_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_COMPLE_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('comple_address') . ' ' . (tep_not_null(ENTRY_COMPLE_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPLE_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ::::::::::::::::::::::: checkout_process.php PROCURE: 'customers_street_address' => $order->customer['street_address'], SUBSTITUA POR: 'customers_street_address' => $order->customer['street_address'], 'customers_number_address' => $order->customer['number_address'], 'customers_comple_address' => $order->customer['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'delivery_street_address' => $order->delivery['street_address'], SUBSTITUA POR: 'delivery_street_address' => $order->delivery['street_address'], 'delivery_number_address' => $order->delivery['number_address'], 'delivery_comple_address' => $order->delivery['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'billing_street_address' => $order->billing['street_address'], SUBSITUIA POR: 'billing_street_address' => $order->billing['street_address'], 'billing_number_address' => $order->billing['number_address'], 'billing_comple_address' => $order->billing['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> :::::::::::::::::::::::::::::: catalog/includes/classes/order.php PROCURE POR: customers_company, customers_street_address, SUBSTITUIA POR: customers_company, customers_street_address, customers_number_address, customers_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: delivery_company, delivery_street_address, SUBSTITUA POR: delivery_company, delivery_street_address, delivery_number_address, delivery_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: billing_company, billing_street_address, SUBSTITUA POR: billing_company, billing_street_address, billing_number_address, billing_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['customers_street_address'], SUBSTITUA POR: 'street_address' => $order['customers_street_address'], 'number_address' => $order['customers_number_address'], 'comple_address' => $order['customers_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['delivery_street_address'], SUBSTITUA POR: 'street_address' => $order['delivery_street_address'], 'number_address' => $order['delivery_number_address'], 'comple_address' => $order['delivery_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['billing_street_address'], SUBSTITUA POR: 'street_address' => $order['billing_street_address'], 'number_address' => $order['billing_number_address'], 'comple_address' => $order['billing_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, SUBSTITUA POR: $customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => $sendto['street_address'], SUBSTITUA POR: 'entry_street_address' => $sendto['street_address'], 'entry_number_address' => $sendto['number_address'], 'entry_comple_address' => $sendto['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, SUBSTITUA POR: $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => null, SUBSTITUA POR: 'entry_street_address' => null, 'entry_number_address' => null, 'entry_comple_address' => null, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => $billto['street_address'], SUBSTITUA POR: 'entry_street_address' => $billto['street_address'], 'entry_number_address' => $billto['number_address'], 'entry_comple_address' => $billto['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, SUBSTITUE POR: $billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $customer_address['entry_street_address'], SUBSTITUE POR: 'street_address' => $customer_address['entry_street_address'], 'number_address' => $customer_address['entry_number_address'], 'street_comple' => $customer_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $shipping_address['entry_street_address'], SUBSTITUE POR: 'street_address' => $shipping_address['entry_street_address'], 'number_address' => $shipping_address['entry_number_address'], 'comple_address' => $shipping_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $billing_address['entry_street_address'], SUBSTITUE POR: 'street_address' => $billing_address['entry_street_address'], 'number_address' => $billing_address['entry_number_address'], 'comple_address' => $billing_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, SUBSTITUE POR: $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_number_address, customers_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ::::::::::::::::::::::::: pagseguro.php PROCURE POR: 'street_address' => $customer_address['entry_street_address'], SUBSTITUIE POR: 'customers_street_address' => $order->customer['street_address'], 'customers_number_address' => $order->customer['number_address'], 'comple_address' => $customer_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'delivery_street_address' => $order->delivery['street_address'], SUBSTITUIR POR: 'delivery_street_address' => $order->delivery['street_address'], 'delivery_number_address' => $order->delivery['number_address'], 'delivery_comple_address' => $order->delivery['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: billing_street_address' => $order->billing['street_address'], SUBSTITUIE POR: 'billing_street_address' => $order->billing['street_address'], 'billing_number_address' => $order->billing['number_address'], 'billing_comple_address' => $order->billing['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $cust_num = "s/n"; $cust_compl = "casa2"; SUBSTITUIE POR: // $cust_num = "s/n"; // $cust_compl = "casa2"; //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: //tep_draw_hidden_field('cliente_num', $cust_num) . "\n" . //tep_draw_hidden_field('cliente_compl', $cust_compl) . "\n" . SUBSTITUIE POR: tep_draw_hidden_field('cliente_num', $order->delivery['number_address']) . "\n" . tep_draw_hidden_field('cliente_compl', $order->delivery['comple_address']) . "\n" . //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Com esta informação o cliente ao se cadastrar adiciona o numero de seu endereço e o complemento, e estas informações são enviadas para o pagseguro.... para contas novas.... qualquer dúvida posta ai.... Quote Davi S Souza Link to comment Share on other sites More sharing options...
cafumbira Posted July 1, 2008 Share Posted July 1, 2008 Não tenho em minha loja espaço para o preenchimento de número e nem complemento, como que eu faço pra colocar na loja? Só tenho: Endereço: Bairro: CEP: Cidade: Estado: País: :huh: Quote Link to comment Share on other sites More sharing options...
souzadavi Posted July 1, 2008 Author Share Posted July 1, 2008 Não tenho em minha loja espaço para o preenchimento de número e nem complemento, como que eu faço pra colocar na loja? Só tenho: Endereço: Bairro: CEP: Cidade: Estado: País: :huh: cara le a resposta acima!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Quote Davi S Souza Link to comment Share on other sites More sharing options...
souzadavi Posted July 1, 2008 Author Share Posted July 1, 2008 USEM ESTE CODIGO PARA ADICIONAR NOVO CAMPO: Numero e Complemento para funcionar nos pagseguro. Para adicionar número e complemento novo campo, é necessário alterar os arquivos: - catalog/create_account.php - catalog/checkout_process.php - catalog/includes/classes/order.php - catalog/includes/modules/payment/pagseguro.php - catalog/includes/form_check.js.php SQL >>> NO BANCO DE DADOS :::: TABELA address_book crie os campos após - ----- entry_lastname - entry_number_address --- varchar 64 - entry_comple_address --- varchar 64 orders crie os campos após - ----- customers_street_address - customers_number_address --- varchar 64 - customers_comple_address --- varchar 64 crie os campos após ----- delivery_street_address - delivery_number_address --- varchar 64 - delivery_comple_address --- varchar 64 crie os campor após ----- billing_street_address - billing_number_address --- varchar 64 - billing_comple_address --- varchar 64 :::::::::::::::::::::: create_account.php PROCURE POR: $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); SUBSTITUA POR $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); $number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']); $comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']); // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => $street_address, SUBSTITUIA: 'entry_street_address' => $street_address, 'entry_number_address' => $number_address, 'entry_comple_address' => $comple_address, // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: <tr> <td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('street_address') . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> SUBSTITUE POR: <tr> <td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('street_address') . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_NUMBER_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('number_address') . ' ' . (tep_not_null(ENTRY_NUMBER_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_NUMBER_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_COMPLE_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('comple_address') . ' ' . (tep_not_null(ENTRY_COMPLE_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPLE_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ::::::::::::::::::::::: checkout_process.php PROCURE: 'customers_street_address' => $order->customer['street_address'], SUBSTITUA POR: 'customers_street_address' => $order->customer['street_address'], 'customers_number_address' => $order->customer['number_address'], 'customers_comple_address' => $order->customer['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'delivery_street_address' => $order->delivery['street_address'], SUBSTITUA POR: 'delivery_street_address' => $order->delivery['street_address'], 'delivery_number_address' => $order->delivery['number_address'], 'delivery_comple_address' => $order->delivery['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'billing_street_address' => $order->billing['street_address'], SUBSITUIA POR: 'billing_street_address' => $order->billing['street_address'], 'billing_number_address' => $order->billing['number_address'], 'billing_comple_address' => $order->billing['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> :::::::::::::::::::::::::::::: catalog/includes/classes/order.php PROCURE POR: customers_company, customers_street_address, SUBSTITUIA POR: customers_company, customers_street_address, customers_number_address, customers_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: delivery_company, delivery_street_address, SUBSTITUA POR: delivery_company, delivery_street_address, delivery_number_address, delivery_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: billing_company, billing_street_address, SUBSTITUA POR: billing_company, billing_street_address, billing_number_address, billing_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['customers_street_address'], SUBSTITUA POR: 'street_address' => $order['customers_street_address'], 'number_address' => $order['customers_number_address'], 'comple_address' => $order['customers_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['delivery_street_address'], SUBSTITUA POR: 'street_address' => $order['delivery_street_address'], 'number_address' => $order['delivery_number_address'], 'comple_address' => $order['delivery_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['billing_street_address'], SUBSTITUA POR: 'street_address' => $order['billing_street_address'], 'number_address' => $order['billing_number_address'], 'comple_address' => $order['billing_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, SUBSTITUA POR: $customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => $sendto['street_address'], SUBSTITUA POR: 'entry_street_address' => $sendto['street_address'], 'entry_number_address' => $sendto['number_address'], 'entry_comple_address' => $sendto['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, SUBSTITUA POR: $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => null, SUBSTITUA POR: 'entry_street_address' => null, 'entry_number_address' => null, 'entry_comple_address' => null, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => $billto['street_address'], SUBSTITUA POR: 'entry_street_address' => $billto['street_address'], 'entry_number_address' => $billto['number_address'], 'entry_comple_address' => $billto['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, SUBSTITUE POR: $billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $customer_address['entry_street_address'], SUBSTITUE POR: 'street_address' => $customer_address['entry_street_address'], 'number_address' => $customer_address['entry_number_address'], 'comple_address' => $customer_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $shipping_address['entry_street_address'], SUBSTITUE POR: 'street_address' => $shipping_address['entry_street_address'], 'number_address' => $shipping_address['entry_number_address'], 'comple_address' => $shipping_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $billing_address['entry_street_address'], SUBSTITUE POR: 'street_address' => $billing_address['entry_street_address'], 'number_address' => $billing_address['entry_number_address'], 'comple_address' => $billing_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, SUBSTITUE POR: $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_number_address, customers_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ::::::::::::::::::::::::: pagseguro.php PROCURE POR: 'street_address' => $customer_address['entry_street_address'], SUBSTITUIE POR: 'customers_street_address' => $order->customer['street_address'], 'customers_number_address' => $order->customer['number_address'], 'customers_comple_address' => $order->customer['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'delivery_street_address' => $order->delivery['street_address'], SUBSTITUIR POR: 'delivery_street_address' => $order->delivery['street_address'], 'delivery_number_address' => $order->delivery['number_address'], 'delivery_comple_address' => $order->delivery['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: billing_street_address' => $order->billing['street_address'], SUBSTITUIE POR: 'billing_street_address' => $order->billing['street_address'], 'billing_number_address' => $order->billing['number_address'], 'billing_comple_address' => $order->billing['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $cust_num = "s/n"; $cust_compl = "casa2"; SUBSTITUIE POR: // $cust_num = "s/n"; // $cust_compl = "casa2"; //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: //tep_draw_hidden_field('cliente_num', $cust_num) . "\n" . //tep_draw_hidden_field('cliente_compl', $cust_compl) . "\n" . SUBSTITUIE POR: tep_draw_hidden_field('cliente_num', $order->delivery['number_address']) . "\n" . tep_draw_hidden_field('cliente_compl', $order->delivery['comple_address']) . "\n" . // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> :::::::::::::::::::::::::::::::::: catalog/includes/form_check.js.php PROCURE POR: check_input("street_address", <?php echo ENTRY_STREET_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_STREET_ADDRESS_ERROR; ?>"); SUBSITUA POR: check_input("street_address", <?php echo ENTRY_STREET_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_STREET_ADDRESS_ERROR; ?>"); check_input("number_address", <?php echo ENTRY_NUMBER_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_NUMBER_ADDRESS_ERROR; ?>"); // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Quote Davi S Souza Link to comment Share on other sites More sharing options...
cafumbira Posted July 1, 2008 Share Posted July 1, 2008 (edited) cara le a resposta acima!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :rolleyes: Foi mal nao li direito aqui entre no meu banco de dados e não encontrei customers_street_address nem delivery_street_address nem billing_street_address veja a imagem: Edited July 1, 2008 by cafumbira Quote Link to comment Share on other sites More sharing options...
souzadavi Posted July 2, 2008 Author Share Posted July 2, 2008 :rolleyes: Foi mal nao li direito aqui entre no meu banco de dados e não encontrei customers_street_address nem delivery_street_address nem billing_street_address veja a imagem: por favor leia direito esta escrito leia com calma.... esta escrito o nome das tabela order e address_book veja na explicação acima.... SQL >>> NO BANCO DE DADOS ::::TABELA address_book crie os campos após - ----- entry_lastname - entry_number_address --- varchar 64 - entry_comple_address --- varchar 64 orders crie os campos após - ----- customers_street_address - customers_number_address --- varchar 64 - customers_comple_address --- varchar 64 crie os campos após ----- delivery_street_address - delivery_number_address --- varchar 64 - delivery_comple_address --- varchar 64 crie os campor após ----- billing_street_address - billing_number_address --- varchar 64 - billing_comple_address --- varchar 64 Quote Davi S Souza Link to comment Share on other sites More sharing options...
d3mundo Posted July 7, 2008 Share Posted July 7, 2008 por favor leia direito esta escrito leia com calma.... esta escrito o nome das tabela order e address_book veja na explicação acima.... e como eu coloco estes dados no banco de dados para que fiquem no lugar certo, tem como mostrar para nos? Quote Link to comment Share on other sites More sharing options...
Edison-Nctec Posted August 3, 2008 Share Posted August 3, 2008 Olá Davi, primeiramente gostaria de parabeniza-lo pelo excelente tópico. Para mim funcionou tudo direitnho até a parte de testar a tela de edição do livro de endereços, não consigo de jetio nenhum fazer aparecer os campos de número e complemento na tela address_book, nem na tela address_book_processes. Neste última até mostra, porém quando clico em atualizar :blink: ele apaga as entradas no banco de dados. Coloque algumas informações em address_book_process seguindo sua linha de racionciocinio: $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); $street_address = tep_db_prepare_input($HTTP_POST_VARS['street_address']); $number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']); $comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']); e depois em address_book entry_number_address as number_address, entry_comple_address as comple_address, ... Mas não funcionou! Por favor se puder me ajudar eu agradeço Quote Link to comment Share on other sites More sharing options...
souzadavi Posted August 3, 2008 Author Share Posted August 3, 2008 e como eu coloco estes dados no banco de dados para que fiquem no lugar certo, tem como mostrar para nos? use o phpmyadmin ou qualquer programa de sql.. recomendo o sqlyog... caso não consiga me avise aq q te passo o comando SQL.. vlw davi Quote Davi S Souza Link to comment Share on other sites More sharing options...
souzadavi Posted August 15, 2008 Author Share Posted August 15, 2008 novas informações sobre como inserir o numero e complemento.... Para adicionar número e complemento novo campo, é necessário alterar os arquivos: - catalog/create_account.php - catalog/checkout_process.php - catalog/includes/classes/order.php - catalog/includes/modules/payment/pagseguro.php - catalog/includes/form_check.js.php -admin/includes/classes/order.php -admin/includes/functions/general.php SQL >>> NO BANCO DE DADOS :::: TABELA address_book crie os campos após - ----- entry_lastname - entry_number_address --- varchar 64 - entry_comple_address --- varchar 64 orders crie os campos após - ----- customers_street_address - customers_number_address --- varchar 64 - customers_comple_address --- varchar 64 crie os campos após ----- delivery_street_address - delivery_number_address --- varchar 64 - delivery_comple_address --- varchar 64 crie os campor após ----- billing_street_address - billing_number_address --- varchar 64 - billing_comple_address --- varchar 64 address_format - no address_format_id 1 alterar o address_format para: $firstname $lastname$cr $streets$cr $suburb$cr$city, $postcode$cr$statecomma$country :::::::::::::::::::::: create_account.php PROCURE POR: $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); SUBSTITUA POR $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); $number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']); $comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']); // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => $street_address, SUBSTITUIA: 'entry_street_address' => $street_address, 'entry_number_address' => $number_address, 'entry_comple_address' => $comple_address, // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: <tr> <td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('street_address') . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> SUBSTITUE POR: <tr> <td class="main"><?php echo ENTRY_STREET_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('street_address') . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_NUMBER_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('number_address') . ' ' . (tep_not_null(ENTRY_NUMBER_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_NUMBER_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_COMPLE_ADDRESS; ?></td> <td class="main"><?php echo tep_draw_input_field('comple_address') . ' ' . (tep_not_null(ENTRY_COMPLE_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_COMPLE_ADDRESS_TEXT . '</span>': ''); ?></td> </tr> // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ::::::::::::::::::::::: checkout_process.php PROCURE: 'customers_street_address' => $order->customer['street_address'], SUBSTITUA POR: 'customers_street_address' => $order->customer['street_address'], 'customers_number_address' => $order->customer['number_address'], 'customers_comple_address' => $order->customer['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'delivery_street_address' => $order->delivery['street_address'], SUBSTITUA POR: 'delivery_street_address' => $order->delivery['street_address'], 'delivery_number_address' => $order->delivery['number_address'], 'delivery_comple_address' => $order->delivery['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'billing_street_address' => $order->billing['street_address'], SUBSITUIA POR: 'billing_street_address' => $order->billing['street_address'], 'billing_number_address' => $order->billing['number_address'], 'billing_comple_address' => $order->billing['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> :::::::::::::::::::::::::::::: catalog/includes/classes/order.php PROCURE POR: customers_company, customers_street_address, SUBSTITUIA POR: customers_company, customers_street_address, customers_number_address, customers_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: delivery_company, delivery_street_address, SUBSTITUA POR: delivery_company, delivery_street_address, delivery_number_address, delivery_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: billing_company, billing_street_address, SUBSTITUA POR: billing_company, billing_street_address, billing_number_address, billing_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['customers_street_address'], SUBSTITUA POR: 'street_address' => $order['customers_street_address'], 'number_address' => $order['customers_number_address'], 'comple_address' => $order['customers_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['delivery_street_address'], SUBSTITUA POR: 'street_address' => $order['delivery_street_address'], 'number_address' => $order['delivery_number_address'], 'comple_address' => $order['delivery_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['billing_street_address'], SUBSTITUA POR: 'street_address' => $order['billing_street_address'], 'number_address' => $order['billing_number_address'], 'comple_address' => $order['billing_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, SUBSTITUA POR: $customer_address_query = tep_db_query("select c.customers_firstname, c.customers_lastname, c.customers_telephone, c.customers_email_address, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => $sendto['street_address'], SUBSTITUA POR: 'entry_street_address' => $sendto['street_address'], 'entry_number_address' => $sendto['number_address'], 'entry_comple_address' => $sendto['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, SUBSTITUA POR: $shipping_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => null, SUBSTITUA POR: 'entry_street_address' => null, 'entry_number_address' => null, 'entry_comple_address' => null, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'entry_street_address' => $billto['street_address'], SUBSTITUA POR: 'entry_street_address' => $billto['street_address'], 'entry_number_address' => $billto['number_address'], 'entry_comple_address' => $billto['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, SUBSTITUE POR: $billing_address_query = tep_db_query("select ab.entry_firstname, ab.entry_lastname, ab.entry_company, ab.entry_street_address, ab.entry_number_address, ab.entry_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $customer_address['entry_street_address'], SUBSTITUE POR: 'street_address' => $customer_address['entry_street_address'], 'number_address' => $customer_address['entry_number_address'], 'comple_address' => $customer_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $shipping_address['entry_street_address'], SUBSTITUE POR: 'street_address' => $shipping_address['entry_street_address'], 'number_address' => $shipping_address['entry_number_address'], 'comple_address' => $shipping_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $billing_address['entry_street_address'], SUBSTITUE POR: 'street_address' => $billing_address['entry_street_address'], 'number_address' => $billing_address['entry_number_address'], 'comple_address' => $billing_address['entry_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, SUBSTITUE POR: $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_number_address, customers_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ::::::::::::::::::::::::: pagseguro.php PROCURE POR: 'street_address' => $customer_address['entry_street_address'], SUBSTITUIE POR: 'customers_street_address' => $order->customer['street_address'], 'customers_number_address' => $order->customer['number_address'], 'customers_comple_address' => $order->customer['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'delivery_street_address' => $order->delivery['street_address'], SUBSTITUIR POR: 'delivery_street_address' => $order->delivery['street_address'], 'delivery_number_address' => $order->delivery['number_address'], 'delivery_comple_address' => $order->delivery['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: billing_street_address' => $order->billing['street_address'], SUBSTITUIE POR: 'billing_street_address' => $order->billing['street_address'], 'billing_number_address' => $order->billing['number_address'], 'billing_comple_address' => $order->billing['comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: $cust_num = "s/n"; $cust_compl = "casa2"; SUBSTITUIE POR: // $cust_num = "s/n"; // $cust_compl = "casa2"; //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: //tep_draw_hidden_field('cliente_num', $cust_num) . "\n" . //tep_draw_hidden_field('cliente_compl', $cust_compl) . "\n" . SUBSTITUIE POR: tep_draw_hidden_field('cliente_num', $order->delivery['number_address']) . "\n" . tep_draw_hidden_field('cliente_compl', $order->delivery['comple_address']) . "\n" . // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> :::::::::::::::::::::::::::::::::: catalog/includes/form_check.js.php PROCURE POR: check_input("street_address", <?php echo ENTRY_STREET_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_STREET_ADDRESS_ERROR; ?>"); SUBSITUA POR: check_input("street_address", <?php echo ENTRY_STREET_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_STREET_ADDRESS_ERROR; ?>"); check_input("number_address", <?php echo ENTRY_NUMBER_ADDRESS_MIN_LENGTH; ?>, "<?php echo ENTRY_NUMBER_ADDRESS_ERROR; ?>"); // >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> :::::::::::::::::::::::::::::: admin/includes/classes/order.php PROCURE POR: customers_company, customers_street_address, SUBSTITUIA POR: customers_company, customers_street_address, customers_number_address, customers_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: billing_company, billing_street_address, SUBSTITUA POR: billing_company, billing_street_address, billing_number_address, billing_comple_address, //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> PROCURE POR: 'street_address' => $order['customers_street_address'], SUBSTITUA POR: 'street_address' => $order['customers_street_address'], 'number_address' => $order['customers_number_address'], 'comple_address' => $order['customers_comple_address'], //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> :::::::::::::::::::::::::::::: admin/includes/functions/general.php PROCURE POR: $street = tep_output_string_protected($address['street_address']); SUBSTITUA POR: $street = tep_output_string_protected($address['street_address']) .' '. tep_output_string_protected($address['number_address']) . ' '.tep_output_string_protected($address['comple_address']); //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Quote Davi S Souza Link to comment Share on other sites More sharing options...
OGATORJ Posted December 12, 2008 Share Posted December 12, 2008 olá, davi. Poderia me enviar o comando SQL pra eu rodar no meu PHPMyAdmin ? Assim eu só teria que rodá-lo e depois alterar os arquivos PHP, correto ? Obrigado. Abs, Lucci. Quote Link to comment Share on other sites More sharing options...
FGML Posted March 29, 2009 Share Posted March 29, 2009 Hello, sorry my poor english. I installed the version OSCommerceBR RC2.2. But when insert a new product, regardless of value, prices are always 0 (Zero). Somebody help me? Olá, eu instalei a versão OSCommerceBR RC2.2. Porém quando inserimos um novo produto, independente do valor, os preços ficam como 0 (Zero). Alguém pode me ajudar? Fernando Meira Lins Quote Fernando Meira Lins SIP Code: *8839 78910 +558132426582 +558196339633 +552140637234 Station: 78910 Link to comment Share on other sites More sharing options...
angelli007 Posted May 9, 2009 Share Posted May 9, 2009 Olá Davi, primeiramente gostaria de parabeniza-lo pelo excelente tópico.Para mim funcionou tudo direitnho até a parte de testar a tela de edição do livro de endereços, não consigo de jetio nenhum fazer aparecer os campos de número e complemento na tela address_book, nem na tela address_book_processes. Neste última até mostra, porém quando clico em atualizar :blink: ele apaga as entradas no banco de dados. Coloque algumas informações em address_book_process seguindo sua linha de racionciocinio: $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); $street_address = tep_db_prepare_input($HTTP_POST_VARS['street_address']); $number_address = tep_db_prepare_input($HTTP_POST_VARS['number_address']); $comple_address = tep_db_prepare_input($HTTP_POST_VARS['comple_address']); e depois em address_book entry_number_address as number_address, entry_comple_address as comple_address, ... Mas não funcionou! Por favor se puder me ajudar eu agradeço Alguem ja conseguiu colocar os campos do numero e complemento no address_book_processes.php e address_book.php ? Quote Link to comment Share on other sites More sharing options...
Amegalos Posted June 11, 2009 Share Posted June 11, 2009 Amigos, eu instalei uma versão em português do oscommerce 'oscommercebr RC2.2' que traz um módulo de pagamento "cod.php" que habilita as informações para depósito em conta: Quando eu instalo o módulo "cod.php" pelo administrador>ferramentas>modulos>pagamento : aparecem as informações abaixo e não sei como modificar. :( Pagamento por Depósito Bancário ALINE SOUZA REAL FRANCO Banco BRADESCO - Agência 1662-4 Conta Corrente 19717-3 Obviamente esses não são meus dados! Gostaria de saber com posso editar essas informações. Retirar os dados acima e colocar meus dados bancários. Se alguém puder ajudar, eu agradeço muito. É a primeira vez que estalo uma loja virtual, então estou meio perdido. Obrigado! Quote Link to comment Share on other sites More sharing options...
je4423 Posted June 22, 2009 Share Posted June 22, 2009 Boa tarde galera! É o seguinte, não estou conseguindo mandar o ddd para o pagseguro. Alguem poderia me ajudar? Obrigado! Quote Link to comment Share on other sites More sharing options...
digaovr Posted June 24, 2009 Share Posted June 24, 2009 (edited) Olá Pessoal, vou tentar simplificar isto aqui: Adicione o código abaixo em seu banco de dados através do phpmyadmin: ALTER TABLE customers ADD customers_ddd int(2) NOT NULL; No arquivo create_account.php localize: $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); Logo abaixo, adicione: $ddd = tep_db_prepare_input($HTTP_POST_VARS['ddd']); Localize: 'customers_lastname' => $lastname, Logo abaixo adicione: 'customers_ddd' => $ddd, Localize: <tr> <td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td> <td class="main"><?php echo tep_draw_input_field('telephone') . ' ' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td> </tr> Substitua por: <tr> <td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td> <td class="main"><?php echo tep_draw_input_field('ddd','','size="2"'); ?> - <?php echo tep_draw_input_field('telephone') . ' ' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td> </tr> No arquivo account_edit.php, localize: $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); Logo abaixo, adicione: $ddd = tep_db_prepare_input($HTTP_POST_VARS['ddd']); Localize: 'customers_lastname' => $lastname, Logo abaixo adicione: 'customers_ddd' => $ddd, Localize: $account_query = tep_db_query("select customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_fax from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'"); $account = tep_db_fetch_array($account_query); Substitua por: $account_query = tep_db_query("select customers_gender, customers_firstname, customers_lastname, customers_cpf, customers_rg,customers_dob, customers_email_address, customers_ddd, customers_telephone, customers_fax from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'"); $account = tep_db_fetch_array($account_query); Localize: <tr> <td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td> <td class="main"><?php echo tep_draw_input_field('telephone') . ' ' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td> </tr> Substitua por: <tr> <td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td> <td class="main"><?php echo tep_draw_input_field('ddd','','size="2"'); ?> - <?php echo tep_draw_input_field('telephone') . ' ' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td> </tr> Agora no arquivo admin/customers.php, localize: $customers_lastname = tep_db_prepare_input($HTTP_POST_VARS['customers_lastname']); Logo abaixo, adicione: $ddd = tep_db_prepare_input($HTTP_POST_VARS['ddd']); Localize: 'customers_lastname' => $customers_lastname, Abaixo adicione: 'customers_ddd' => $ddd, Localize: $customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'"); Substitua por: $customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_cpf, c.customers_rg, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_ddd, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'"); Localize: <?php if ($error == true) { if ($entry_telephone_error == true) { echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'maxlength="32"') . ' ' . ENTRY_TELEPHONE_NUMBER_ERROR; } else { echo $cInfo->customers_telephone . tep_draw_hidden_field('customers_telephone'); } } else { echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'maxlength="32"', true); } ?> Substitua por: <?php echo tep_draw_input_field('customers_ddd', $cInfo->customers_ddd, 'maxlength="2" size="2"', false) . ' - '; if ($error == true) { if ($entry_telephone_error == true) { echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'maxlength="32"') . ' ' . ENTRY_TELEPHONE_NUMBER_ERROR; } else { echo $cInfo->customers_telephone . tep_draw_hidden_field('customers_telephone'); } } else { echo tep_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'maxlength="32"', true); } ?> Abra o arquivo checkout_process.php e encontre: 'customers_telephone' => $order->customer['telephone'], Abaixo, adicione: 'ddd' => $order->customer['ddd'], Abra o arquivo includes/classes/order.php e ache: $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, 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 . "'"); Substitua por: $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_ddd, 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, 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 . "'"); Encontre: 'telephone' => $order['customers_telephone'], Abaixo, adicione: 'ddd' => $order['customers_ddd'], Rode e veja se está tudo funcionando. "O Coringão voltou B) " Edited June 24, 2009 by digaovr Quote Link to comment Share on other sites More sharing options...
digaovr Posted June 24, 2009 Share Posted June 24, 2009 Amigos, eu instalei uma versão em português do oscommerce 'oscommercebr RC2.2' que traz um módulo de pagamento "cod.php" que habilita as informações para depósito em conta: Quando eu instalo o módulo "cod.php" pelo administrador>ferramentas>modulos>pagamento : aparecem as informações abaixo e não sei como modificar. :( Pagamento por Depósito Bancário ALINE SOUZA REAL FRANCO Banco BRADESCO - Agência 1662-4 Conta Corrente 19717-3 Obviamente esses não são meus dados! Gostaria de saber com posso editar essas informações. Retirar os dados acima e colocar meus dados bancários. Se alguém puder ajudar, eu agradeço muito. É a primeira vez que estalo uma loja virtual, então estou meio perdido. Obrigado! Abra o arquivo includes\languages\portugues\modules\payment\cod.php e edite os textos com os seus devidos dados. Abraços Quote Link to comment Share on other sites More sharing options...
digaovr Posted June 24, 2009 Share Posted June 24, 2009 Desculpem a falha, coloquei o código que postei acima com algumas modificações aqui: http://www.oscommerce.com/forums/index.php?showtopic=339322 Abs Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.