Jump to content

GreenMamba

Members
  • Content count

    32
  • Joined

  • Last visited

  1. GreenMamba

    Forum for oscommerce

    Shouldn't be too difficult, but since I'm a PHP newbie, it would probaly take me a few days through trial and error. Any experts out there who can slap something together to incorporate categories into this contribution... please? http://www.oscommerce.com/community/contributions,980/
  2. GreenMamba

    Contribution Request: Manual Order Entry

    Does anybody know how to apply the Split Page Results Class to the admin_list_products.php file for the contribution? I tried a few variations, but I just can't get it to work.
  3. Hi all Can anybody help me to modify this file so that it displays only specified, but multiple categories. I have two categories on my site that I would like to exclude from the results for this page and three that I would like to include, which at this moment displays all in-stock items on one page. <?php /* Attitude Simple Manual Order Entry for osCommerce v0.3 by Geoff Ford - Attitude Group Ltd - 28 February 2004 http://www.oscommerce.co.nz/ Contact Details available on website Copyright © 2004 Attitude Group Ltd Released under the GNU General Public License */ require('includes/application_top.php'); require('includes/configure_simple_order_entry.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LIST_PRODUCTS); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_LIST_PRODUCTS, '', 'SSL')); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_specials.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo TEXT_INFORMATION; ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td> <!-- customer_orders //--> <?php unset($info_box_contents); $customer_orders_string = '<table border="0" width="100%" cellspacing="0" cellpadding="1"><tr><td align="left"><font face="Verdana" size="1"><b>Description</b></td><td align="left"><font face="Verdana" size="1"><b>Price</b></td><td align="right"><font face="Verdana" size="1"><b>Quantity</b></td></tr>' . "\n" .' <form name="cart_quantity" method="post" action="'.tep_href_link(FILENAME_SHOPPING_CART, 'action=update_product', 'NONSSL').'">'; $products_query = tep_db_query("select pd.products_id, pd.products_name, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and language_id = '" . $languages_id . "' and p.products_status = '1' order by products_name"); while ($products = tep_db_fetch_array($products_query)) { $customer_orders_string .= ' <tr>' . "\n" . //' <td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">' . $products['products_name'] . '</a></td>' . "\n" . ' <td style="border-top: 1px solid #CC0000;" class="infoBoxContents">' . $products['products_name'] . '</td>' . "\n" . ' <td style="border-top: 1px solid #CC0000;" class="infoBoxContents">' . $currencies->display_price($products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '</td>' . "\n" . ' <input type="hidden" name="products_id[]" value="' . $products['products_id'] . '">'. ' <td class="infoBoxContents" align="right" valign="top"><input type="text" name="cart_quantity[]" value="' . $products_quantity[$products['products_id']] . '" size="4"></td>' . "\n" . //' <td class="infoBoxContents" align="right" valign="top"><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=cust_order&pid=' . $products['products_id'], 'NONSSL') . '">' . tep_image(DIR_WS_ICONS . 'cart.gif', ICON_CART) . '</a></td>' . "\n" . ' </tr>' . "\n"; } $customer_orders_string .= '<tr><td style="border-top: 1px solid #CC0000;" colspan="3" align="center"><br>'.tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART).'</td></form></table>'; $info_box_contents[] = array('align' => 'left', 'text' => $customer_orders_string); new infoBox($info_box_contents); ?> <!-- customer_orders_eof //--> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  4. GreenMamba

    Credit Card Number Mask

    Is anybody using this contribution? Am I right in assuming that it applies to the Standard OSC Credit Card Module, that it stores a masked version of the CC Number in the database and sends the un-masked CC Number in the Order Confirmation Email?
  5. Tried that already. I removed the password from my admin folder, reset the attributes for the temp directory to 777 and still got the same error. The funny thing is everything else in easypopulate works. It writes to the temp directory just fine, but as soon as I try and insert a file into the db either via upload or directly from the temp directory it gives me the Internal Server Error. So either it cant read the file in the temp directory or it can't write to the db. I'll give it another try tonight. I got my host looking into the problem, but so far they haven't managed to fix it either. Thanks for all your input.
  6. Hi John Thanks, I already tried that. I went into my cpanel error log last night. It's coming up with "Forbidden", so I guess you're right about my host changing something.
  7. That's what I'm thinking, but why would it only affect EasyPopulate?
  8. Everything else works perfectly (as far as I have tested). I can backup, add products manually and with Quick Product Adder, download the text files with easypopulate and even split files into the temp directory. As soon as I hit Add to Database it gives me the Internal Server Error.
  9. I'm having the same problem. The starngest thing is that I have been using it for months now and uploaded products successfully just a few days ago. Now suddenly it's giving me this error. Any solutions anybody?
  10. GreenMamba

    Contribution Request: Manual Order Entry

    I used the Simple Manual Order Contribution for a while and it worked OK, except that I kept getting an error message when I hit add to cart. Not too serious, I found a way around it and kept using it. We have an online shop and an actual store, so I was using it mostly for quickly creating an order for what we call "Direct Sales" (instead of searching through all the Product Categories) Anyways, I figured out a way to integrate the Simple Manual Order Contribution with my online store, so that customers can list all the products and simply enter the quantities for each product to place an order. Simply link directly to admin_list_products.php from your main page. You can use any of the left or right navigation boxes. I added this to my Categories box (includes/boxes/categories.php) at the end of the file right above [new infoBox($info_box_contents);] $info_box_contents[] = array('text' => '<a href="' . tep_href_link('admin_list_products.php') . '">' . 'List Everything!' . '</a><br>'); If you click on the link it will list your entire online catalog (if you set LARGE PRODUCT CATALOG to false in configure_simple_order_entry.php) NB: If you have a large number of product in your catalog then this page could take a while to load.
  11. GreenMamba

    DB Manipulation from Admin

    Before I install this contribution... Would I be able to add data into the Database i.e. can it insert data into the orders and orders_products tables?
  12. GreenMamba

    Wishlist 2.0 Support Thread

    Never thought of doing that ... here you go NOTE: I'm still looking for a way to display "Qty" or "Product Status" in the wishlist. Anybody??? <?php /* $Id: wishlist.php,v 2.0 2003/11/22 Jesse Labrocca osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if (tep_session_is_registered('customer_id')) { $account = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'"); $account_values = tep_db_fetch_array($account); } elseif (ALLOW_GUEST_TO_TELL_A_FRIEND == 'false') { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_WISHLIST_SEND); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_WISHLIST_SEND, 'send_to=' . $HTTP_GET_VARS['send_to'] . '&products_id=' . $HTTP_GET_VARS['products_id'])); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <script LANGUAGE="JavaScript1.2" SRC="includes/menu_animation.js"></SCRIPT> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <? $wishliststring = "My Wishlist is: \n\n"; $wishlist_query_raw = "select tab2.products_id, tab1.products_name from " . TABLE_WISHLIST . " as tab2, products_description as tab1 WHERE tab2.customers_id=$customer_id and tab1.products_id = tab2.products_id order by products_name"; $wishlist_query = tep_db_query($wishlist_query_raw); while ($resultarray=mysql_fetch_row($wishlist_query)) { $wishliststring .= $resultarray[1]."\n" . HTTP_SERVER ."/product_info.php/products_id/".$resultarray[0] . "\n\n"; } ?> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo sprintf(HEADING_TITLE, $product_info['products_name']); ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_contact_us.gif', sprintf(HEADING_TITLE, $product_info['products_name']), HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php $error = false; if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process') && !tep_validate_email(trim($HTTP_POST_VARS['friendemail']))) { $friendemail_error = true; $error = true; } else { $friendemail_error = false; } if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process') && empty($HTTP_POST_VARS['friendname'])) { $friendname_error = true; $error = true; } else { $friendname_error = false; } if (tep_session_is_registered('customer_id')) { $from_name = $account_values['customers_firstname'] . ' ' . $account_values['customers_lastname']; $from_email_address = $account_values['customers_email_address']; } else { $from_name = $HTTP_POST_VARS['yourname']; $from_email_address = $HTTP_POST_VARS['from']; } if (!tep_session_is_registered('customer_id')) { if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process') && !tep_validate_email(trim($from_email_address))) { $fromemail_error = true; $error = true; } else { $fromemail_error = false; } } if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process') && empty($from_name)) { $fromname_error = true; $error = true; } else { $fromname_error = false; } if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process') && ($error == false)) { $email_subject = sprintf(TEXT_EMAIL_SUBJECT, $from_name, STORE_NAME); $email_body = sprintf(TEXT_EMAIL_INTRO, $HTTP_POST_VARS['friendname'], $from_name, $HTTP_POST_VARS['products_name'], STORE_NAME) . "\n\n"; if (tep_not_null($HTTP_POST_VARS['yourmessage'])) { $email_body .= $HTTP_POST_VARS['yourmessage'] . "\n\n"; } $email_body .= sprintf(TEXT_EMAIL_SIGNATURE, STORE_NAME . "\n"). "<A HREF=\"". HTTP_SERVER . DIR_WS_CATALOG ."\"><h3><i>".STORE_NAME."</A> "."\n"; "\n\n" . $mywishlist .= $wishlist_query_array[1] ."\n"; tep_mail($HTTP_POST_VARS['friendname'], $HTTP_POST_VARS['friendemail'], $email_subject, stripslashes($email_body), '', $from_email_address); ?> <tr> <td><br><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo sprintf(TEXT_EMAIL_SUCCESSFUL_SENT, stripslashes($HTTP_POST_VARS['products_name']), $HTTP_POST_VARS['friendemail']); ?></td> </tr> </table></td> </tr> <tr> <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_WISHLIST) . '">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'; ?></td> </tr> <?php } else { if (tep_session_is_registered('customer_id')) { $your_name_prompt = $account_values['customers_firstname'] . ' ' . $account_values['customers_lastname']; $your_email_address_prompt = $account_values['customers_email_address']; } else { $your_name_prompt = tep_draw_input_field('yourname', (($fromname_error == true) ? $HTTP_POST_VARS['yourname'] : $HTTP_GET_VARS['yourname'])); if ($fromname_error == true) $your_name_prompt .= ' ' . TEXT_REQUIRED; $your_email_address_prompt = tep_draw_input_field('from', (($fromemail_error == true) ? $HTTP_POST_VARS['from'] : $HTTP_GET_VARS['from'])); if ($fromemail_error == true) $your_email_address_prompt .= ENTRY_EMAIL_ADDRESS_CHECK_ERROR; } ?> <tr> <td><?php echo tep_draw_form('email_friend', tep_href_link(FILENAME_WISHLIST_SEND, 'action=process&products_id=' . $HTTP_GET_VARS['products_id'])) . tep_draw_hidden_field('products_name', $product_info['products_name']); ?><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="formAreaTitle"><?php echo FORM_TITLE_CUSTOMER_DETAILS; ?></td> </tr> <tr> <td class="main"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="formArea"> <tr> <td class="main"><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo FORM_FIELD_CUSTOMER_NAME; ?></td> <td class="main"><?php echo $your_name_prompt; ?></td> </tr> <tr> <td class="main"><?php echo FORM_FIELD_CUSTOMER_EMAIL; ?></td> <td class="main"><?php echo $your_email_address_prompt; ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td class="formAreaTitle"><br><?php echo FORM_TITLE_FRIEND_DETAILS; ?></td> </tr> <tr> <td class="main"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="formArea"> <tr> <td class="main"><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo FORM_FIELD_FRIEND_NAME; ?></td> <td class="main"><?php echo tep_draw_input_field('friendname', (($friendname_error == true) ? $HTTP_POST_VARS['friendname'] : $HTTP_GET_VARS['friendname'])); if ($friendname_error == true) echo ' ' . TEXT_REQUIRED;?></td> </tr> <tr> <td class="main"><?php echo FORM_FIELD_FRIEND_EMAIL; ?></td> <td class="main"><?php echo tep_draw_input_field('friendemail', (($friendemail_error == true) ? $HTTP_POST_VARS['friendemail'] : $HTTP_GET_VARS['send_to'])); if ($friendemail_error == true) echo ENTRY_EMAIL_ADDRESS_CHECK_ERROR; ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td class="formAreaTitle"><br><?php echo FORM_TITLE_FRIEND_MESSAGE; ?></td> </tr> <tr> <td class="main"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="formArea"> <tr> <!-- hacked by chuck <td><?php echo tep_draw_textarea_field('yourmessage', 'soft', 40, 8);?></td> --> <td><textarea name="yourmessage" cols=40 rows=8><?=$wishliststring;?></textarea></td> </tr> </table></td> </tr> <tr> <td><br><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_WISHLIST) . '">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'; ?></td> <td align="right" class="main"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td> </tr> </table></td> </tr> </table></form></td> </tr> <?php } ?> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  13. GreenMamba

    Wishlist 2.0 Support Thread

    Ok, I finally solved the "no wishlist in email" problem by using the wishlist_email.php file from v2.01 and modifying it slightly. If anybody wants the file just email me. Now, one last question. I would like to display "product quantity in stock" or "product status" in the wishlist. Can anybody help?
  14. GreenMamba

    Wishlist 2.0 Support Thread

    Thanks, tried that, but it still doesn't work.
  15. GreenMamba

    Wishlist 2.0 Support Thread

    Ok, I figured it all out, but please please don't ask me how since I've lost track of all the changes that I made. The good news is that the problem was in the changes I made to product_info.php and not Wish List. Now the only problem I still have is that when I try to email my wishlist, the list doesn't appear in the email (or links or anything except for Hello, blablabla, thank you). Also, I would still like to make the send to a friend a submit to a fixed email button. Anybody ... please
×