Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

rusty1001

Pioneers
  • Posts

    397
  • Joined

  • Last visited

Profile Information

  • Real Name
    Rusty
  • Gender
    Male

rusty1001's Achievements

  1. Hi Just wondering - a client wants to install an osc shop as part of a website instead of a intergrated cart system. There is a module for the clients bank - ANZ directone. Do I need anything else to make that run .... like payment gateway processer? In the module there are dummy card numbers to test - so I assume would work, but I see there are payment gateway processors that are expensive to use - so why would this be free? Unless the bank has all the processer stuff as part of their service? ..in other words if I set up a site to take credit cards what do I need? cheers
  2. SMALL_IMAGE_WIDTH*2, SMALL_IMAGE_HEIGHT*2 multiply *2 * 3 * 1.5..what ever you want best way I think, set the proportion increase on what you want, little else to do, cheers
  3. sorry ran without register globals which I think was the problem but turned it on via htacess file, cheers
  4. solved ..ran the contrib with register globals fix and used htacess to enable, ok,
  5. thanks , I thought the multi srores needed the older version but thanks may be ok, cheers will also solve the register issue as well ,cheers
  6. Hi I have tested this on and off line but I have a problem with log in, it seems to ages to and never gets there, as though the db is working over time, any ideas, v2 php5 and php4 osc 2.2 060817 added register globals patch...no other contribs. thanks Russell
  7. Hi Think the issue is with not installing all files correctly, did it again no problems and that side,,
  8. Hi having the same issue, think it is a php4 v php5 probelm, php5 not working, does anyone have a general idea on php5 issue with tables for this probelm? thanks
  9. http://www.oscommerce.com/community/contributions,1730 Hi I would like to use the multistore add on, but was written for 061812 MSC2.2 , where can I down load the older version, or use the rc4 canidate with this addon. It does not seem to work... How can this be done? thanks Russell
  10. Hi I need to make sure that part of this code works in a drop list to make it refresh, How can do this and where is in sts templates - a require or in the code directly?? <?php // +Country-State Selector ?> function refresh_form(form_name) { form_name.action.value = 'refresh'; form_name.submit(); return true; } <?php // -Country-State Selector ?> thanks Russell
  11. Hi I am using a template system, but I am seeng the refresh in the source code - but is not refreshing...where is the form check in sts template ?? Any other ideas why this wont refresh?? thanks R
  12. http://www.oscommerce.com/community/contributions,5167 Hi the support for this great work seems to have gone off air but this is not exporting the state fields,, any ideas? Thanks Russell <?php require('includes/application_top.php'); if (!$_POST['submit']) { ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//DE"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body id="customers"> <!-- header //--> <?php require(DIR_WS_INCLUDES.'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES.'column_left.php'); ?> <script> new Rico.Accordion( $('accordionDiv'), {panelHeight:210, collapsedBg:'#B3BAC5', expandedBg:'#C9C9C9', hoverBg: '#C9C9C9', borderColor:'#C9C9C9', expandedTextColor:'#616060', onLoadShowTab:'5'} ); </script> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> </tr> <tr> <td><?php echo tep_draw_form(BOX_CUSTOMER_EXPORT, FILENAME_CUSTOMERS_EXPORT, '', 'post'); ?> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="main"><?php echo TABLE_HEADING_CUSTOMER_EXPORT; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td> </td> </tr> <tr> <td class="main"><p><?php echo TEXT_CUSTOMER_EXPORT_ALL; ?></p> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent">cID</td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_FIRSTNAME; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_LASTNAME; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_EMAIL; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_GENDER; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_DOB; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_COMPANY; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_STREET; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ZIP; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CITY; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_LOCATION; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_SUBURB; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_COUNTRY; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_TELEPHONE; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_FAX; ?></td> </tr> <?php $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_gender, c.customers_dob, c.customers_telephone, c.customers_fax, a.entry_company, a.entry_street_address, a.entry_postcode, a.entry_city, a.entry_state, a.entry_suburb, co.countries_name from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join " . TABLE_COUNTRIES . " co on co.countries_id = a.entry_country_id order by c.customers_lastname, c.customers_firstname"; // $customers_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS * 4, $customers_query_raw, $customers_query_numrows); $customers_query = tep_db_query($customers_query_raw); while ($customers = tep_db_fetch_array($customers_query)) { ?> <tr class="dataTableRow"> <td class="dataTableContent"><b><?php echo $customers['customers_id']; ?></b></td> <td class="dataTableContent"><?php echo $customers['customers_firstname']; ?></td> <td class="dataTableContent"><?php echo $customers['customers_lastname']; ?></td> <td class="dataTableContent"><?php echo $customers['customers_email_address']; ?></td> <td class="dataTableContent"><?php echo $customers['customers_gender']; ?></td> <td class="dataTableContent"><?php echo tep_date_short($customers['customers_dob']); ?></td> <td class="dataTableContent"><?php echo $customers['entry_company']; ?></td> <td class="dataTableContent"><?php echo $customers['entry_street_address']; ?></td> <td class="dataTableContent"><?php echo $customers['entry_postcode']; ?></td> <td class="dataTableContent"><?php echo $customers['entry_city']; ?></td> <td class="dataTableContent"><?php echo $customers['entry_state']; ?></td> <td class="dataTableContent"><?php echo $customers['entry_suburb']; ?></td> <td class="dataTableContent"><?php echo $customers['countries_name']; ?></td> <td class="dataTableContent"><?php echo $customers['customers_telephone']; ?></td> <td class="dataTableContent"><?php echo $customers['customers_fax']; ?></td> </tr> <?php } ?> </table> </td> </tr> <tr> <td colspan="4"><table border="0" width="100%" cellspacing="0" cellpadding="2"> </td> </tr> <tr> <td> </td> </tr> <tr> <td class="smallText" ><?php echo TEXT_CUSTOMER_EXPORT_SEPARATOR; ?>: <input name="separator" type="text" value="\t" size="3"> <input type="submit" value="<?php echo TEXT_CUSTOMER_EXPORT; ?>" name="submit"></td> </tr> </table> </form> </td> </tr> </table></td> </tr> </table> <!-- footer //--> <center> <font color="#666666" size="2"></font> </center> <!-- footer_eof //--> <br> </body> </html> <?php } else { if($HTTP_POST_VARS['separator']!="") $sep=stripcslashes($HTTP_POST_VARS['separator']); else $sep="\t"; $sep= str_replace('\t', "11", $sep); $contents="customers_id".$sep."customers_lastname".$sep."customers_firstname".$sep."customers_email_address".$sep."customers_gender".$sep."customers_dob".$sep."entry_company".$sep."entry_street_address".$sep."entry_postcode".$sep."entry_city".$sep."entry_state".$sep."entry_suburb".$sep."countries_name".$sep."customers_telephone".$sep."customers_fax\n"; $customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_gender, c.customers_dob, c.customers_telephone, c.customers_fax, a.entry_company, a.entry_street_address, a.entry_postcode, a.entry_city, a.entry_state, a.entry_suburb, co.countries_name from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join " . TABLE_COUNTRIES . " co on co.countries_id = a.entry_country_id order by c.customers_lastname, c.customers_firstname"; $customers_query = tep_db_query($customers_query_raw); while ($row = tep_db_fetch_array($customers_query)) { $contents.=$row['customers_id'].$sep; $contents.=$row['customers_lastname'].$sep; $contents.=$row['customers_firstname'].$sep; $contents.=$row['customers_email_address'].$sep; $contents.=$row['customers_gender'].$sep; $contents.=tep_date_short($row['customers_dob']).$sep; $contents.=$row['entry_company'].$sep; $contents.=$row['entry_street_address'].$sep; $contents.=$row['entry_postcode'].$sep; $contents.=$row['entry_city'].$sep; $contents.=$row['entry_state'].$sep; $contents.=$row['entry_suburb'].$sep; $contents.=$row['countries_name'].$sep; $contents.=$row['customers_telephone'].$sep; $contents.=$row['customers_fax']."\n"; } /*Header("Content-Disposition: attachment; filename=export.txt"); print $contents;*/ header("Content-Type: application/force-download\n"); header("Content-disposition: attachment; filename=customers_export_" . date("Ymd") . ".txt"); header("Pragma: no-cache"); header("Expires: 0"); echo $contents; die(); } require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  13. 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='32' order by pd.products_name, p.products_date_added DESC sql problem but I dont remember doing anything with mysql?? thanks :thumbsup:
  14. Hi I am using login box 5.4 with sts templates.. all good but I want we someone registers to stay on the same page, but this is login.php line 60 } else { tep_redirect(tep_href_link(FILENAME_DEFAULT)); I am assuming when if cart is empty... how do set default to the the same page and/or where is default defined... thanks in advance
×
×
  • Create New...