Jump to content

her_unlimited

Members
  • Content count

    36
  • Joined

  • Last visited

  1. Hi, somebody know how to include the table qtpro_stock_table.php in qtpro 3.2 ?? i copy the <?php require in product_info.php but only it shows is the title :huh:
  2. her_unlimited

    cDynamic Meta Tags

    cDynamic MetaTags VS Google Analytics. I have a problem with Analytics, when I search content by title the pages shows as "not set". Anyone have the same problem??
  3. her_unlimited

    Control login problem

    Pleaseeee help Shoul I copy this line: ? require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LOGOFF);
  4. her_unlimited

    Control login problem

    Hello, I installed the control login contribution http://www.oscommerce.com/community/contributions,1154 I were using autologin contribution too. The control login contribution seems to work fine. The users cant login before the account is activated in admin panel. I also have install this patch in the index and product_info so users cant see products unless ther are loged in. // if the customer is not logged on, redirect them to the login page if (!tep_session_is_registered('customer_id')) { tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'NONSSL')); } The users cant see the catalog unless I activate the account, they cant login. But I discover that if they don't close the window when they are in create_account_success.php and if they click in CONTINUE or in HOME, they can see the catalog, it's like they were loged in without the activated account. How can I resolve it? Can I paste some code to create_account_success.php so it works like logoff.php file and logoff the user ? Thanks a lot! Hernán
  5. her_unlimited

    cDynamic Meta Tags

    Hi, I install this contribution, I want to know how to include H1 an H2 tags using the title (H2) and description (h1), can I install it directly in the meta_tags.php file like this? Thanks! define('HEAD_TITLE_TAG_ALL','<h2>Buy Cars</h2>'); # Title define('HEAD_DESC_TAG_ALL','<h1>But Cars surfing on the web</h1>'); # Description
  6. her_unlimited

    cDynamic Meta Tags

    Hello, I installed the version 1.4, it's great, but...i wonder if is posible to it's appear the product_description (first 40 characters) instead of the product_name in product_info.php. I hope anyone can help me. Thanks!! Hernán
  7. Hi, I told you how I update the stock with excel, with no one aditional contribution, using phpmyadmin http://forums.oscommerce.com/index.php?showtopic=278499 I hope it works, but in case BACK UP DATABASE!! ...Question or idea....there is any contribution to show in products a grafic stock like this?? http://www.gap.com/browse/product.do?cid=5228&pid=502190 It shows squares with Available and Not Available sizes and colors. If there is not any contribution, please made it!! I don't know any of php :'( I only know how to copy past codes :-" Thanks!!
  8. Hi, I told you how I update the stock with excel, with no one aditional contribution, using phpmyadmin You need to name the products titles as in your sales software (or use sales soft desctiptions), use the same colors code and size code as in the soft, and name OS colors with * and _ in first caracter, *RED and sizes _Small http://personales.ciudad.com.ar/fancyonline/StockUpdate.rar I hope it will be easy, my english is not good. Question or idea....there is any contribution to show in products a grafic stock like this?? http://www.gap.com/browse/product.do?cid=5228&pid=502190 It shows squares with Available and Not Available sizes and colors. If there is not any contribution, please made it!! I don't know any of php :'( I only know how to copy past codes :-" Thanks!! PD. for Lince Indumentaria users: para usuarios de Lince Indumentaria listar----> Stock, listado de stock, stock valorizado
  9. Hi, I install this great contibution, and it works Excelent!! I'm using version 3.2 (because its were the only with install step by step) and I want to ask you in wick database table can I edit the stock with excel. Also if anyone can look if I pasted correctly the code in product_info.php (because another contribution were in the middle) Thanks a lot!! <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name, popt.special from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); // BOF Linkmatics attributes sets plus $products_options_query = tep_db_query(" SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix , pase.sort_order FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_TO_PRODUCTS . " pas2pa, " . TABLE_PRODUCTS_ATTRIBUTES_SETS . " pas, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov WHERE pa.products_id = '" . (int)$_GET['products_id'] . "' AND pa.options_id = '" . $products_options_name['products_options_id'] . "' AND pas2pa.products_id = pa.products_id AND pas.products_attributes_sets_id = pas2pa.products_attributes_sets_id AND pas.products_options_id = pa.options_id AND pase.products_attributes_sets_id = pas.products_attributes_sets_id AND pase.options_values_id = pa.options_values_id AND pov.products_options_values_id = pa.options_values_id AND pov.language_id = '" . $languages_id . "' ORDER BY pase.sort_order, pa.options_values_id"); // >>>>> BOF Linkmatics attributes sets plus patch v1.01 if (tep_db_num_rows($products_options_query)== 0 ) { $products_options_query = tep_db_query(" SELECT pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix , pa.options_values_id FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov WHERE pa.products_id = '" . (int)$_GET['products_id'] . "' AND pa.options_id = '" . $products_options_name['products_options_id'] . "' AND pov.products_options_values_id = pa.options_values_id AND pov.language_id = '" . $languages_id . "' ORDER BY pa.options_values_id"); } // <<<<< EOF Linkmatics attributes sets plus patch v1.01 // EOF Linkmatics attributes sets plus $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.options_id, pa.options_values_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { //START get attribute stock values/show out of stock if (!$products_options_name['special']) { $attribute_stock_query = tep_db_query("select products_stock_quantity from " . TABLE_PRODUCTS_STOCK . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' AND products_stock_attributes REGEXP '(^|,)" . (int)$products_options['options_id'] . "-" . (int)$products_options['options_values_id'] . "(,|$)' AND products_stock_quantity > 0"); if (tep_db_num_rows($attribute_stock_query)==0) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => 'Sin stock - ' . $products_options['products_options_values_name']); } else { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); } } else { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); } // END get attribute stock values/show out of stock if ($products_options['options_values_price'] != '0') { THANKS A LOT!!!
  10. her_unlimited

    Google Analytics module

    Hello, I have just installed the "Google Analytics module" contribution, it's really great, but I was wondering if can be used another function that I use with the database. I usually search the products that the users have seen in the website, i search it in various tables in the database, so I can email them with special offers. I was wondering if I can use it with Analytics, I search in google help and found only this http://www.google.com/support/googleanalyt...opic=&type= In addition to this, can be use this code to segment the users by the categories than have seen in the site ? I opened a new topic in http://forums.oscommerce.com/index.php?showtopic=275566 Thanks!! Hernan
  11. Hello, I have just installed the "Google Analytics module" contribution, it's really great, but I was wondering if can be used another function that I use with the database. I usually search the products that the users have seen in the website, i search it in various tables in the database, so I can email them with special offers. I was wondering if I can use it with Analytics, I search in google help and found only this http://www.google.com/support/googleanalyt...opic=&type= In addition to this, can be use this code to segment the users by the categories than have seen in the site ? Thanks!! Hernan
  12. her_unlimited

    Easy atribute config

    Hello, I m having my first steps with Oscommce, I've arrived to the moment to create de products (clothes) and create the Atributes por each product is tooooooo tedious. I am searching for a contribution but theres too many for this problem. Anyone had the same problem?? Which contribution do you recomend me? The idea is to have a contribution that alows to create atributes in the same page where it is creating the product, by colour: red, blue, etc and by size: S-M-L-XL or 1-2-3-4. If is any contribution that allows to create the atributes with a excel table (or similar) it will be much better, ejample Atributes on columns: S - M -L -XL - Red - Blue - Green and 0 o 1 (true or false) if the product have this atribute. If is any contribution that allows to manage this problem and either the stock for each product and atribute (excel as well), it will be better. I hope your answer!!, very thanks!! Hernán
×