Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

rusty1001

Pioneers
  • Posts

    397
  • Joined

  • Last visited

Everything posted by rusty1001

  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
  15. Hi would it be possible to include extra fields (contribution) info in this export?? thanks
  16. Hi I have created a hrid file, copy of cat tab, to repeat on the page, but cant seem to remove the formatting, and the whole tad as all I want is the active name working, I have echoed the result using sts tempalt by creating anothet $link all i need to show is the active main category, think that this will make a a nice addition, cheers
  17. Hi here are two pieces of code from the menu tab contribution, 2.0, top is the main tab top and the second is subtab in the sub tab I have added a <br> to make it into a column and made it text left... what I am trying to do is where the sub tab is showing I want to add a copy of the main tab heading above sub tab ie as that sub tab opens there is a name of the category it is in, I am using sts templates so the column is showing up some where different , as it would normal be right under the main tab, I also want to keep the the main tab name as well, i will just make the text smaller or match the css for the other tab headng that is being duplicted, i think that this will also a make a addtition to an already great contrbution, , I have tried a few things but did not work, basically I just need the main heading cat to reapeat in the sub tab page (codes below)....thanks regards Russell :) <?php /* $Id: categories.php,v 2.0 2004/11/16 02:59:49 ChBu Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2004 osCommerce Released under the GNU General Public License Modified for single image tabs with subtabs by Tim Hanekamp because single tabs by amanda are really beautiful and subtabs by Carine Bruyndoncx are really usefull original author Chuck Burgess. * v2.0 by Christophe Buchi: * - No need to edit the file to change the last tab ID * - Option to show the Home page on first tab * - Option to not show categories having sort_order=0 * - Images sizes are now in DEFINE, easier to change them. * - Sub-categories moved to categories_subtab.php, so it's now like an option. */ // START CONFIGURATION define (CAT_TABS_SHOW_HOME,false); // Set to true to display the Home define (CAT_TABS_HEIGHT,'30'); // Height of the tabs define (CAT_TABS_WIDTH_LEFT,'5'); // Width of the left part of the first tab define (CAT_TABS_WIDTH_MIDDLE,'5'); // Width of the image between tabs define (CAT_TABS_WIDTH_RIGHT,'5'); // Width of right part of the last tab define (CAT_TABS_SHOW_ALL,true); // Display or not categories having sort order=0 (true=>display) // END CONFIGURATION $cfg_query_and = (CAT_TABS_SHOW_ALL==true ? ' and sort_order >0 ':''); // $counter = category id $start = first tab $last_on = if the previous tab was selected function show_category_tabs($counter, $last_element, $start = 1, $last_on = false) { global $foo, $categories_string, $id, $HTTP_GET_VARS; $onpage = false; // Prepares new cPath if not home page if (($foo[$counter]['parent'] == 0) and ($counter!=0)) { $cPath_new = 'cPath=' . $counter; } // We are on the home page if (!isset($HTTP_GET_VARS['cPath'])) { if ($counter==0) $onpage = true; } elseif (($HTTP_GET_VARS['cPath'] != 0) and ($counter!=0)){ $base = substr($HTTP_GET_VARS['cPath'], 0, strpos($HTTP_GET_VARS['cPath'], '_')); if ($counter == $HTTP_GET_VARS['cPath']) { $onpage = true; } elseif ($counter == $base) { $onpage = true; } } if ($counter == $last_element) { $last_tab = true; } else { $last_tab = false; } if ($onpage) { //Tab is on if ($start) {//1st tab on $categories_string .= '<td class="tabsNavigation" valign="top" height="'.CAT_TABS_HEIGHT.'" width="'.CAT_TABS_WIDTH_LEFT.'" nowrap background="images/curve/left_on.gif">'."\n"; } else { //middle or last on $categories_string .= '<td class="tabsNavigation" valign="top" height="'.CAT_TABS_HEIGHT.'" width="'.CAT_TABS_WIDTH_MIDDLE.'" nowrap background="images/curve/middle_on_left.gif">'."\n"; } } else { //Tab is off if ($start) { //1st tab off $categories_string .= '<td class="tabsNavigation" valign="top" height="'.CAT_TABS_HEIGHT.'" width="'.CAT_TABS_WIDTH_LEFT.'" nowrap background="images/curve/left_off.gif">'."\n"; } else { if ($last_on) { //Middle or last tab, previous tab was on $categories_string .= '<td class="tabsNavigation" valign="top" height="'.CAT_TABS_HEIGHT.'" width="'.CAT_TABS_WIDTH_MIDDLE.'" nowrap background="images/curve/middle_on_right.gif">'."\n"; } else { //Middle or last tab, previous tab not on $categories_string .= '<td class="tabsNavigation" valign="top" height="'.CAT_TABS_HEIGHT.'" width="'.CAT_TABS_WIDTH_MIDDLE.'" nowrap background="images/curve/middle_off.gif">'."\n"; } } } $categories_string .= '</td>'."\n"; if ($onpage) { $categories_string .= '<td class="tabsNavigation" valign="middle" height="'.CAT_TABS_HEIGHT.'" nowrap background="images/curve/menu0_on.gif">'."\n"; } else { $categories_string .= '<td class="tabsNavigation" valign="middle" height="'.CAT_TABS_HEIGHT.'" nowrap background="images/curve/menu0_off.gif">'."\n"; } // if tab selected we dont need a link if (!$onpage) { $categories_string .= '<a class="tabsNavigation" href="'; $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new); $categories_string .= '"> |'; } // display category name $categories_string .= $foo[$counter]['name']; if (!$onpage) { $categories_string .= '</a>'; } $categories_string .= '</td>'; if ($last_tab) { if ($onpage) { $categories_string .= '<td class="tabsNavigation" valign="top" height="'.CAT_TABS_HEIGHT.'" width="'.CAT_TABS_WIDTH_RIGHT.'" nowrap background="images/curve/right_on.gif">'."\n"; } else { $categories_string .= '<td class="tabsNavigation" valign="top" height="'.CAT_TABS_HEIGHT.'" width="'.CAT_TABS_WIDTH_RIGHT.'" nowrap background="images/curve/right_off.gif">'."\n"; } } $categories_string .= '</td>'."\n"; if ($foo[$counter]['next_id']) { if ($onpage) { show_category_tabs($foo[$counter]['next_id'],$last_element, 0, true); } else { show_category_tabs($foo[$counter]['next_id'], $last_element, 0); } } } // start the tabs ?> <table border="0" cellspacing="0" cellpadding="0" > <tr> <?php // needed in case other part of site use same variable. $categories_string=''; unset ($first_element); unset ($prev_id); if (CAT_TABS_SHOW_HOME) { $foo[0]=array( 'name' => HEADER_TITLE_TOP, 'parent' => '', 'level' => 0, 'path' => '', 'next_id' => false ); $prev_id=0; $first_element=0; } $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' ".$cfg_query_and." order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { $foo[$categories['categories_id']] = array( 'name' => $categories['categories_name'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false ); if (isset($prev_id)) { $foo[$prev_id]['next_id'] = $categories['categories_id']; } $prev_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } $last_element=$categories['categories_id']; } show_category_tabs($first_element, $last_element); echo $categories_string; ?> </tr> </table> <!-- categories_eof //--> SUBTAB page code <?php /* $Id: categories_subtab.php,v 2.0 2004/11/16 02:59:49 ChBu Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2004 osCommerce Released under the GNU General Public License * This file displays a row with links to sub-categories of the selected category. * Use this file together with categories_tab.php. */ function show_subcategories($counter) { global $fooa, $subcategories_string, $id, $HTTP_GET_VARS; $cPath_new = 'cPath=' . $fooa[$counter]['path']; $subcategories_string .= '<a href="'; $subcategories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new); $subcategories_string .= '" class="Navigation_left"><br>'; // display category name $subcategories_string .= $fooa[$counter]['name']; $subcategories_string .= '</a> '; if ($fooa[$counter]['next_id']) { $subcategories_string .= ' '; show_subcategories($fooa[$counter]['next_id']); }else{ $subcategories_string .= ' '; } } ?> <!-- subcategories //--> <table border="0" cellspacing="0" cellpadding="4" WIDTH="100%"> <tr class="headerNavigation"><td ALIGN="left" class="headerNavigation"> <?php if ($cPath) { $subcategories_string = ''; $new_path = ''; $id = split('_', $cPath); reset($id); while (list($key, $value) = each($id)) { unset($prev_id); unset($first_id); $subcategories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $value . "' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name"); $subcategory_check = tep_db_num_rows($subcategories_query); if ($subcategory_check > 0) { $new_path .= $value; while ($row = tep_db_fetch_array($subcategories_query)) { $fooa[$row['categories_id']] = array( 'name' => $row['categories_name'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false ); if (isset($prev_id)) { $fooa[$prev_id]['next_id'] = $row['categories_id']; } $prev_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } $fooa[$last_id]['next_id'] = $fooa[$value]['next_id']; $fooa[$value]['next_id'] = $first_id; $new_path .= '_'; } else { break; } } } if ($id[0] != ''){ show_subcategories($id[0]); echo $subcategories_string; }else{ echo " "; } ?> </td> </tr> </table> <!-- subcategories_eof //-->
  18. solved this....... copied the format of other in the file user code..... use this it seems to work....folllows the format of the version sts 4.3 $sts->start_capture(); include_once(DIR_WS_INCLUDES . 'categories_subtab.php'); $sts->stop_capture('categories_subtab','box'); // 'box' makes the system remove some html code before and after the box. Otherwise big mess! $sts->start_capture(); include_once(DIR_WS_INCLUDES . 'categories_tab.php'); $sts->stop_capture('categories_tab','box'); // 'box' makes the system remove some html code before and after the box. Otherwise big mess! $categories_tab $categories_subtab sts format in template cheers
  19. Hi Iam trying the same thing and having the same problem, seems to be working with sts template, but not with as soon as I add the code above does not work eeven if I dont have the $link in place. thanks
  20. Hi No luck so far, I did look at the source code, and it is pulling the info from one .dll so I guess it may be a ebay thing, anyone got any ideas? thanks R
  21. I am using current_auctions v2.1 also i just looked in the graphics files and there is only a buy now gif not a placee bid, so something I think is the wrong way around , thanks
  22. Hi I wondered if anyelse has had this problem? I am trying one item from my ebay - the item is avaliable but the test site(my site) it is saying auction ended, could just be a small thing, but this is a relisted not sold item and it may be taking some info from the product from the wrong place , other wise great contibution, thanks regards russell :-)
  23. yes that is what I have to use \ before each text symbol that you want to use that might confuse php...
  24. edit tmport with text - heading Anyone ? I need to keep the text formatting in easypopulate as in " marks and ' - I know you need a \ with \'s for eg. day\'s in the html but not sure how it would work in easy pop import file - would it be the same?? thanks russell
×
×
  • Create New...