Jump to content

dhotter

Members
  • Content count

    20
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Daniel
  1. dhotter

    [CONTRIBUTION] Subcategory textboxes

    Hey, thanx! That was the mistake! :-) Daniel
  2. dhotter

    [CONTRIBUTION] Subcategory textboxes

    Hi Chris! Yes the table extra_cat_info is there. The file was imported correctly, no mistakes. But i don't know, why there is the 1064!? Daniel
  3. dhotter

    [CONTRIBUTION] Subcategory textboxes

    Hi Chris! I think, it's a great contribution, but i've a little problem with the 2.0 Version: I get an error in /admin/products_extra_category.php, when i try to use: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-8, 8' at line 1 select extra_cat_info.categories_id, categories_description, categories_name from extra_cat_info LEFT JOIN categories_description USING (categories_id) where extra_cat_info.language_id=categories_description.language_id and extra_cat_info.language_id=2 limit -8, 8 Do you know where my mistake could be? Thanx! Kind regards, Daniel
  4. dhotter

    Customer Add Product

    @empo Would it be possible, to send the customer-data, who add a product, to the customer who bought the customers product via mail, in the confirmation-email? For example: If I bought a product a computer from bill gates, i want to submit the personal-data of Bill Gates (eg. Adress, eMail) to me, after the product I bought. You you please tell me, how to include this personal Data to the eMail? Thanx a lot! Greeting from Europe! Dan
  5. dhotter

    Customer Add Product

    @empo Well, I tried to code a function in order to inform the customer, if his account is approved. I modified the admin/customers_app.inc.php in this way: <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td class="formAreaTitle"><?php echo CATEGORY_CUSTOMER_APP; ?></td> </tr> <tr> <td class="formArea"><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_CUSTOMER_APP; ?></td> <td class="main"> <? echo tep_draw_radio_field('customers_app', '1', false, $cInfo->customers_ap) . ' ' . YES . ' ' . tep_draw_radio_field('customers_app', '0', false, $cInfo->customers_ap) . ' ' . NO; // TEST for E-Mail to customer if approved: define(EMAIL_TEXT_SUBJECT,'New Product was added'); $category_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$category_id . "' and language_id = '" . (int)$language_id ."'"); $category = tep_db_fetch_array($category_query); $email = "Hallo Kunde!"; $email .= "TEST : ".$category['categories_name']."\n\n"; $email .= "Testnachricht : ". $customer['customers_firstname'].' '.$customer['customers_lastname'] ."\n\n"; $email .= "Text 2 \n\n"; tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_TEXT_SUBJECT, $email,$customer['customers_firstname'].' '.$customer['customers_lastname'],$customer['customers_email_address']); //end ?> </td> </tr> </table></td> </tr> But this mail is only send to admin, instead of sending it to the customer... Do you kno, where my mistake is? And the second: I postet a txt on this following LINK with my mistake in the customer_add.php: I really don't find it. Thanx for your help! Greeting, Daniel
  6. dhotter

    Customer Add Product

    Uh, I have a problem with the form-check in customer_add.php: The form won't be checked if the fields are filled out. Is there any mistake? Code: <?php echo tep_draw_hidden_field('products_date_added', (tep_not_null($pInfo->products_date_added) ? $pInfo->products_date_added : date('Y-m-d'))) . tep_image_submit('button_preview.gif', IMAGE_PREVIEW) . ' <a href="' . tep_href_link('account_add.php', 'osCsid=' . $osCsid . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?> An the code of the sending: if ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); $pInfo = new objectInfo($product); $products_image_name = $pInfo->products_image; } $form_action = (isset($HTTP_GET_VARS['pID'])) ? 'update_product' : 'insert_product'; echo tep_draw_form($form_action, 'account_add.php?osCsid=' . $osCsid . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"'); $languages = tep_get_languages(); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { if (isset($HTTP_GET_VARS['read']) && ($HTTP_GET_VARS['read'] == 'only')) { $pInfo->products_name = tep_get_products_name($pInfo->products_id, $languages[$i]['id']); $pInfo->products_description = tep_get_products_description($pInfo->products_id, $languages[$i]['id']); $pInfo->products_url = tep_get_products_url($pInfo->products_id, $languages[$i]['id']); } else { $pInfo->products_name = tep_db_prepare_input($products_name[$languages[$i]['id']]); $pInfo->products_description = tep_db_prepare_input($products_description[$languages[$i]['id']]); $pInfo->products_url = tep_db_prepare_input($products_url[$languages[$i]['id']]); } ?> Thanx for your help, again! Daniel
  7. dhotter

    Customer Add Product

    @empo Is it possible to set an new customer to the approved status even when his account is created? I don't want to approve every new customer in the admin. An the second question I have: Would it be possible, to send an email to the customer, if his product is sold? Thanx for your help! Greeting, Daniel
  8. dhotter

    Customer Add Product

    @empo: It's a really great contribution! I've 3 questions/ suggestions for your Contrib: 1. Would it be possible to inform the user who added the product, if this added product was selled? 2. The form with the details the user should add, with a form-check, if everything is filled in? 3. The Admin-Section should have a box or information, in which category the new Product is set. Or the Mail should have the hole category with sub-categories That would be very nice. Thanks from Dan!
  9. dhotter

    Customer Add Product

    Hi folks! I have the same problem like p_angel0! The Problem may cause of the .htaccess protection and the connection between the catalog/account_add.php an the admin/customers.php, i think. Because of the folling instructions: Please correct me, if i am wrong!
×