Jump to content
Latest News: (loading..)

Search the Community

Showing results for tags 'php'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • News and Announcements
    • News and Announcements
    • Partner Announcements
    • Ambassadors
  • Commercial Support
    • Developer Feedback
  • osCommerce Online Merchant v2.x
    • General Support
    • Installation and Configuration
    • Upgrading from Earlier Versions (v2.x to v2.x)
    • Add-Ons
    • Tips and Tricks
    • Security
  • Development
    • osCommerce Online Merchant v2.4
    • osCommerce Online Merchant Community Bootstrap Edition
    • osCommerce Online Merchant v3.x
    • Development Proposals
  • General
    • OSCOMMERCE.TV
    • Next Steps / Optimizations / Marketing
    • Live Shop Reviews
    • E-Commerce Laws
    • General Discussions
    • PHP / SQL / Web Design
  • oscBooks and oscTemplates's Announcements
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein
  • German Community's OSCOM v3.x

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Real Name


Location


Interests


Website


Skype

Found 11 results

  1. Please help me #1812 - Tablespace is missing for table '(null)' mysql osCommerce `usu_cache` problem
  2. zetap

    Developer guide

    I am a programmer and I have to do a development on an existing oscommerce site, as it is the first time I work on this platform, I am looking for, if it exists, some kind of developer guide on oscommerce, on the official site, I have not been able to find any. If anyone has information about it, I thank you from now on Regards !
  3. Hello, I have installed osCommerce many times on a local Ubuntu 16.04 LTS server. After a default installation - admin folder not renamed - I cannot login to the admin portal. Also, the layout of the catalog is not right. I have attached a print screen of the catalog. I have checked the settings in both configure.php files. There are no references to unknows folders and the DB settings are correct. Any suggestions are appreciated. With kind regards, Willem-Jan
  4. Hi guys and girls, enthusiasts, I'd like to know how to insert data from a tep_input_field into the mysql database I'm currently using the AJAX Attribute Manager Addon and added another input field to it for EAN/GTIN input. How can I submit the entered ean to my database ? See the Code and attached screenshot below I've already added a column for ean and tried to add ean as input value. The Field is being shown, but inserting doesn't work. Thanks for any help in advance. Have a nice day. <?php echo tep_draw_input_field("ean_$optionValueId",$optionValueInfo['ean'],' style="margin:3px 0px 3px 0px;" id="ean_'.$optionValueId.'" size="7" onfocus="amF(this)" onblur="amB(this)" onChange="return amUpdate(\''.$optionId.'\',\''.$optionValueId.'\',\'ean\');"'); ?>
  5. Hello all, I'm using All Manufacturers for BS by @reflex-ocasion https://apps.oscommerce.com/clER0&all-manufacturers-bs. It's a great module to have for search engine crawling and user experience. A step further (for large stores with hundreds or thousands of brands) would be to arrange on the All Manufacturers page alphabetically like: A Animal Apple B Bakery Box It has been done by @amseek here: https://apps.oscommerce.com/00fKs&all-manufacturers but not adapted to BS version nor the Community Edition by @burt. I have the instructions and code for the All Manufacturers from 6 years ago OSC version 2.3.1: All Manufacturers Contribution v.1 for osCommerce 2.2 - Alpha-Split Layout Option (March 2012) -------------------------------- Created by Art Main OSC:amseek www.goldcoastdesign.org http://addons.oscommerce.com/profile/253123 Overview -------- This contribution adds an alphabetized list layout option to the all-manufacturers contribution. You can choose to control the number of columns to show (or let the program choose), the width of each column and the alignment (CSS text-align values) for each column. Please note: There are still a couple CSS quirks with regards to the borders and overall layout. I don't have the time to track these down, but just so you are aware. The Alpa-Split php and html are sound though. Thanks ------ Alex Kaiser (alex@pooliestudios.com) - original mod Installation ------------ 1. Install the All Manufacturers Contribution v.1 for osCommerce 2.2 (contrib page: http://addons.oscommerce.com/info/1685/v,22) if you don't already have it installed. 2. Apply the following changes below. 3. To enable, change the COLUMN_LISTING value to 'alpha-list'. ==================================== allmanufacturers.php: ------------------- find (app line 30): define('COLUMN_LISTING', 'false'); // added by azer change to false for columns listing ------------------- add after: //+CSS/Alpha-Split Layout Option $num_cols = 'auto'; //number of columns (int) or 'auto' (default is 'auto') $list_align = 'left'; //CSS 'text-align' values (default is 'left' for Alpha-Split layout, otherwise default is 'center') $col_width = 'auto'; //CSS 'width' values (if just a number, 'px' will be assumed). Default is '150px' //set to 'auto' for no set CSS width (Alpha-Split layout only) //-CSS/Alpha-Split Layout Option ------------------- find (app line 97 [line 186 if you have CSS Layout Option installed]): } else { // column ------------------- before add: //+Alpha-Split Layout Option } else if (COLUMN_LISTING=='alpha-split') { $manufacturer_name_query_start = "select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_name"; $manufacturer_name_query_end = " order by manufacturers_name"; $manufacturers_query = tep_db_query('select count(*) as count from ' . TABLE_MANUFACTURERS . ' order by manufacturers_name'); $item = tep_db_fetch_array($manufacturers_query); $num_manufacturers = $item["count"]; if (!(tep_not_null($num_cols) && is_int($num_cols))) { $num_cols = 5; } if ($num_manufacturers > 0) { $num_headings = 0; foreach (range('A', 'Z') as $letter) { $manufacturer_name_query = $manufacturer_name_query_start . " like '" . $letter . "%'" . $manufacturer_name_query_end; $manufacturer_name = tep_db_query($manufacturer_name_query); if (tep_db_num_rows($manufacturer_name) > 0) { $num_headings++; //adjust for letter headings while ($manufacturer = tep_db_fetch_array($manufacturer_name)) { $manufacturers_result[$letter][] = $manufacturer; } } } } if (tep_not_null($manufacturers_result)) { $column_itor = 0; $itor = 0; $num_per = ceil(($num_manufacturers + $num_headings) / $num_cols); foreach ($manufacturers_result as $letter => $manulist) { $itor++; foreach ($manulist as $index => $manuitem) { if ($letter == $curr_letter) { $itor++; $curr_letter = null; } if ($itor >= $num_per) { $curr_letter = $letter; $column_itor++; $itor = 0; } $manufacturers_list[$column_itor][$letter][] = $manuitem; $itor++; } } //set up user chosen params $pattern = '/^(\d+)(in|cm|mm|px|em|ex|pt|pc|px)?$/'; if (preg_match($pattern,$col_width,$matches)) { if (empty($matches[2])) { $col_width_text = 'width:' . $matches[1] . 'px;'; } } else if ($col_width != 'auto') { $col_width_text = 'width:150px;'; } if ($list_align != "center" && $list_align != "right") { $list_align = "left"; } ?> <style type="text/css"> <!-- div.alpha_list_container ul { text-align:<?php echo $list_align; ?>; } div.alpha_list_container ul li { <?php echo $col_width_text; ?> overflow:hidden; } --> </style> <div id="manufacturers_list_container" class="alpha_list_container"> <?php foreach ($manufacturers_list as $column) { ?> <div class="multicolumn_list"> <?php foreach ($column as $letter => $manu_list) { ?> <ul class="alpha_list"> <li class="manufacturer_letter"><?php echo $letter; ?></li> <?php foreach ($manu_list as $manufacturers) { echo '<li>' . "\n" . '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id'] . '=' . $manufacturers['manufacturers_name']) . '">'. $manufacturers['manufacturers_name'] . "<br />\n"; echo "</a>\n </li>\n"; } ?> </ul> <?php } ?> </div> <?php } ?> <div style="clear:left;"></div> </div> <?php } //-Alpha-Split Layout Option ==================================== stylesheet.css: ------------------- if you do not have the CSS Layout Option installed add: /* multicolumn_list */ div#manufacturers_list_container { float:left; } div#manufacturers_list_container ul { margin:0; padding:0; list-style:none; } div.multicolumn_list { float:left; } ------------------- find (within the CSS Layout Option css shown above): div.multicolumn_list { float:left; } ------------------- change to: div.multicolumn_list { border: 0px solid #d9d9da; float:left; } ------------------- add: div.alpha_list_container { border: 0px solid #d9d9da; border-right-width: 1px; border-bottom-width: 1px; } ul.alpha_list { font-size: .7em; border: 0px solid #d9d9da; border-left-width: 1px; } ul.alpha_list li a { display:block; border: 0px solid #ffffff; border-top-width: 1px; border-bottom-width: 1px; } ul.alpha_list li a:hover { border-color:#d9d9da; text-decoration:none; } li.manufacturer_letter { font-weight:bold; background:#D7E9F7; border: 0px solid #d9d9da; border-top-width: 1px; border-bottom-width: 1px; } I know page splitting is probably done much differently in BS. So I've included the code for reflex-ocasion's All Manufacturer's page: <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2017 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require('includes/languages/' . $language . '/allmanufacturers.php'); $breadcrumb->add(NAVBAR_TITLE, tep_href_link('allmanufacturers.php')); require('includes/template_top.php'); ?> <div class="page-header"> <h1><?php echo HEADING_TITLE; ?></h1> </div> <div class="contentContainer"> <div class="contentText"> <?php $manufacturers_query = tep_db_query("select manufacturers_name, manufacturers_id, manufacturers_image from manufacturers order by manufacturers_name" ); $manufacturers = tep_db_num_rows($manufacturers_query); while ($manufacturers = tep_db_fetch_array($manufacturers_query)) { ?> <div class="col-sm-6 col-md-4" itemprop="itemListElement" itemscope="" itemtype="http://schema.org/Product"> <div class="thumbnail equal-height"> <?php echo ' <p class="text-center"><a href="' . tep_href_link('index.php', 'manufacturers_id=' . $manufacturers['manufacturers_id'] . '=' . $manufacturers['manufacturers_name']) . '">'. $manufacturers['manufacturers_name']; echo ' <br /> '; echo tep_image('images/' . $manufacturers['manufacturers_image'], $manufacturers['manufacturers_name']) . '</a></p>'; ?> </div> </div> <?php } ?> </div> <p>&nbsp;</p> <div class="buttonSet"> <div class="text-right"><?php echo tep_draw_button(IMAGE_BUTTON_CONTINUE, 'fa fa-angle-right', tep_href_link('index.php')); ?></div> </div> </div> <?php require('includes/template_bottom.php'); require('includes/application_bottom.php'); ?> I'm not a coder so I have no clue where to begin. Any input/advice @MrPhil @kymation @frankl @wHiTeHaT will be appreciated. Do you think this would be ideal for core code?
  6. Hi all, I am working on modifying a discount coupon add-on to allow two coupons for one order. The class discount_coupon looks like this: <?php /* * discount_coupon.php * August 4, 2006 * author: Kristen G. Thorson * ot_discount_coupon_codes version 3.0 * * * Released under the GNU General Public License * */ class discount_coupon { var $messages, $coupon, $applied_discount, $cart_info; function discount_coupon( $code, $delivery ) { $this->messages = array(); $this->coupon = array(); $this->applied_discount = array(); $this->cart_info = array( 'valid_products' => array( 'count' => 0, 'line_items' => 0, 'total' => 0 ), 'total_products' => array( 'count' => 0, 'line_items' => 0, 'total' => 0 ), 'exclusions' => array() ); $this->get_coupon( $code, $delivery ); I have already made some modifications to this file to bypass the exclusions if necessary. Does anyone have any ideas on a method to allow multiple codes? Thanks
  7. Good day, I have installed and configured Simple Photo Gallery by Raju Rajpurohit - Codoffer Infotech I believe that I have done everything according to the instructions but being a bit 'very new' to php I don'y know where to place the line: <a href="<?php echo tep_href_link(FILENAME_PHOTO_GALLERY);?>">Photo Gallery</a> that I assume will execute the gallery add on. Would appreciate some help rgs
  8. carpesitus

    Need PHP help, please

    I'm trying to add an additional condition to a per item shipping module. It is processing the zone properly but I can't get it to calculate the shipping correctly. It returns a $0.00 shipping total. Here is the code: if ($dest_zone == 0) { $groups_cost = constant('MODULE_SHIPPING_PIPC_COST_DEFAULT'); $handle_cost = constant('MODULE_SHIPPING_PIPC_HANDLING_DEFAULT'); } elseif ($dest_zone == 1 && $total_count > 2) { $shipping_cost = $groups_cost + $groups_cost; } else { $groups_cost = constant('MODULE_SHIPPING_PIPC_COST_' . $dest_zone); $handle_cost = constant('MODULE_SHIPPING_PIPC_HANDLING_' . $dest_zone); } $shipping_method = MODULE_SHIPPING_PIPC_TEXT_WAY . ' ' . $dest_country . ' : ' . $shipping_weight . ' ' . MODULE_SHIPPING_PIPC_TEXT_UNITS; $shipping_cost = $groups_cost * $total_count + $handle_cost; $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_PIPC_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => $shipping_method, 'cost' => $shipping_cost)));
  9. FantasyArt

    Creating Return in PHP

    I am trying to create a return at the end of a line in the Flat.php I start off with this below and want to put a return after the Local to SHEPPARTON, VICTORIA REGION ONLY!! <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ define('MODULE_SHIPPING_FLAT_TEXT_TITLE', 'Local to SHEPPARTON, VICTORIA REGION ONLY!!'); define('MODULE_SHIPPING_FLAT_TEXT_DESCRIPTION', 'Local to SHEPPARTON, VICTORIA REGION ONLY!!'); define('MODULE_SHIPPING_FLAT_TEXT_WAY', 'LOCAL PICKUP OPTION'); ?> Below is the code I enter but keep on getting it wrong. New to editing PHP files so need some help as to know what I am doing wrong. <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ define('MODULE_SHIPPING_FLAT_TEXT_TITLE', 'Local to SHEPPARTON, VICTORIA REGION ONLY!!'); define('MODULE_SHIPPING_FLAT_TEXT_DESCRIPTION', 'Local to SHEPPARTON, VICTORIA REGION ONLY!!'\rWe reserve the right to cancel any orders outside the PICKUP AREA stated above that don't include shipping.); define('MODULE_SHIPPING_FLAT_TEXT_WAY', 'LOCAL PICKUP OPTION'); ?> Keep on getting an error for this so I know I am doing something wrong but don't know what. PLEASE HELP I am also trying to get help on another post I have in the forum as to which module is the best and easiest to install for Guest Checkout. Would like some help on both these matters please.
  10. I am looking to create a google feed for my instance of osCommerce. However, I have the ultimate SEO URL's 5 installed on my 2.3.1 instance. How do I get the product URL's for each product at they are not stored in the database in the products table? Any help would be appreciated.
  11. I know there have been a few posts on this topic before, but without prevail. It seems that there has not been an answer to this question. Header Tags SEO and Enable/Disable Categories have a conflict in includes/application_top.php. I am an intermediate at PHP, yet I can't seem to figure this one out. I have tried multipe variations, the closest results, stretched the products, distorting the index page, and also showing top category images. I know that there has to be a way to merge the two conflicting queries, either with one MySQL query or a PHP array that merges the two querys. To make it a little easier to read, basically I need to merge the red with the green. Thank you, Brandon ************************************************************************************************************************ // add category names or the manufacturer name to the breadcrumb trail if (isset($cPath_array)) { for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) { // BOF Enable & Disable Categories $categories_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd left join " . TABLE_CATEGORIES . " c on cd.categories_id = c.categories_id where c.categories_status = '1' and cd.categories_id = '" . (int)$cPath_array[$i] . "' and cd.language_id = '" . (int)$languages_id . "'"); // EOF Enable & Disable Categories if (tep_db_num_rows($categories_query) > 0) { $categories = tep_db_fetch_array($categories_query); $breadcrumb->add($categories['categories_name'], tep_href_link(FILENAME_DEFAULT, 'cPath=' . implode('_', array_slice($cPath_array, 0, ($i+1))))); } else { break; } } *************** /*** Begin Header Tags SEO ***/ // add category names or the manufacturer name to the breadcrumb trail if (isset($cPath_array)) { for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) { $categories_query = tep_db_query("select categories_htc_title_tag from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$cPath_array[$i] . "' and language_id = '" . (int)$languages_id . "' LIMIT 1"); if (tep_db_num_rows($categories_query) > 0) { $categories = tep_db_fetch_array($categories_query); $breadcrumb->add($categories['categories_htc_title_tag'], tep_href_link(FILENAME_DEFAULT, 'cPath=' . implode('_', array_slice($cPath_array, 0, ($i+1))))); } else { break; } } ************************************************************************************************************************** } elseif (isset($HTTP_GET_VARS['manufacturers_id'])) { $manufacturers_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); if (tep_db_num_rows($manufacturers_query)) { $manufacturers = tep_db_fetch_array($manufacturers_query); $breadcrumb->add($manufacturers['manufacturers_name'], tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'])); } } *************** } elseif (isset($_GET['manufacturers_id'])) { $manufacturers_query = tep_db_query("select manufacturers_htc_title_tag from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' AND languages_id = '" . (int)$languages_id . "' LIMIT 1"); if (tep_db_num_rows($manufacturers_query)) { $manufacturers = tep_db_fetch_array($manufacturers_query); $breadcrumb->add($manufacturers['manufacturers_htc_title_tag'], tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $_GET['manufacturers_id'])); } } *************************************************************************************************************************** // add the products model to the breadcrumb trail if (isset($HTTP_GET_VARS['products_id'])) { // BOF Enable & Disable Categories $model_query = tep_db_query("select p.products_model from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where c.categories_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.products_id = pd.products_id"); // EOF Enable & Disable Categories if (tep_db_num_rows($model_query)) { $model = tep_db_fetch_array($model_query); $breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); } } **************** // add the products name to the breadcrumb trail if (isset($_GET['products_id'])) { $products_query = tep_db_query("select pd.products_head_title_tag from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_id = '" . (int)$_GET['products_id'] . "' and pd.language_id ='" . (int)$languages_id . "' LIMIT 1"); if (tep_db_num_rows($products_query)) { $products = tep_db_fetch_array($products_query); $breadcrumb->add($products['products_head_title_tag'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $_GET['products_id'])); } } /*** End Header Tags SEO ***/
×