Jump to content

ColorsbyLiza

Members
  • Content count

    50
  • Joined

  • Last visited

Profile Information

  • Real Name
    Liza
  • Location
    San Diego, CA
  1. ColorsbyLiza

    Header Tags and More Pics

    Never mind... I fixed it and it worked! Just in case somebody else needs to know how... For the overlapping mods in both files (as given above), I just added the missing codes into the More Pics Mod from the Header Tags Mod. example: Insert.........pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, (from Header Tags) between......pd.products_description, and pd.products_url, (in More Pics). :thumbsup:
  2. ColorsbyLiza

    Header Tags and More Pics

    Hello All, I have been trying to merge the 2 files together and am having a really hard time. I am using Beyond Compare, and have a difficult time deciphering how to integrate files that call out for changes that's within the more pics mod. Or maybe someone can post their merged admin/categories.php file? :-" Need someone's experties please .:) Thank you in advance. Liza For example: this is the header tags mod //HTC BOC if (isset ($HTTP_GET_VARS['pID']) && (!$HTTP_POST_VARS) ) { $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); //HTC EOC this is the more pics mode: if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) { // BOF: More Pics 6 Added: , p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6 $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); // EOF: More Pics 6 $product = tep_db_fetch_array($product_query); this is the header tags mod: <!-- HTC BOC //--> <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag']; $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag']; $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); // HTC EOC this is the more pics mod: <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } else { // BOF: More Pics 6 Added: , p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6 $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); // EOF: More Pics 6 $product = tep_db_fetch_array($product_query);
  3. ColorsbyLiza

    [CONTRIBUTION] CCGV (trad)

    Oh, and during checkout, after the checkout shipping page, when I click continue I get a blank page. Also, all the tables are present in the phpmyadmin, but when I go to the osCommerce admin and click on the coupon/voucher tab, I get a 404 error. I am going to try the 5.18 packet now, hopefully this works. Thanks, liza
  4. ColorsbyLiza

    [CONTRIBUTION] CCGV (trad)

    I have uninstalled and installed everything twice. The sql file 3 times. I am now in the process of uninstalling EVERYTHING for the 3rd time and sql 4th time. Am I using the wrong package? it's CCGV 5.19 by Hiremat. :'( Just 1 more try, since I really like this contribution and really want it to work. Thanks, Liza
  5. ColorsbyLiza

    [CONTRIBUTION] CCGV (trad)

    Hello! Has anyone figured out what heppened here? I have same issue. Did intall/re-install 2x and same result. Just want to know where to look for the problem. Thanks, Liza P.S. Great contribution!
  6. Hello everyone, I am on my 3rd day and still having the same problem as the post below. Did anybody find a solution for it? I just get a blank white page in check-out.php page. Please....need your help. Thanks, Liza
  7. :'( Having sort of the same problem. I Installed this great mod to 2 shops and have the same issue, when checking out, on the checkout_confirmation.php I get a BLANK white screen. Any Ideas? Thanks! Liza
  8. Hi Surfalot, Thanks for the response, I guess you responded at the same time I posted a Thank You note. :) Wanted to know if your contribution will work with "lightbox" contribution, and if so, which one? Many Thanks, Liza
  9. Hello! Just wanted to thank you all for this great contribution. :thumbsup: Also a special mention to Spax/Peter, who helped me through completing this wonderful addition. :D Keep it up! Liza ;)
  10. ColorsbyLiza

    'On the Fly' Auto Thumbnailer using GD Library

    :thumbsup: Wanted to thank the contributers! Works great!!! :thumbsup: Liza
  11. ColorsbyLiza

    Error 1146 and sql Error 1060

    I have the same question. Please, somebody..... Liza
  12. een trying to work this out for the past 3 days. :'( I recently installed (first) "more pics V1.3b" and since I got errors I then installed "more pics V1.2c". Both versions gave me the same outcome. The issues are as follows... 1. MYSQL gave me this error: Error SQL query: ALTER TABLE `products` ADD `products_subimage1` VARCHAR( 64 ) AFTER `products_image` ; MySQL said: Documentation #1060 - Duplicate column name 'products_subimage1' 2. The Catalog page shows the thumbnail image, but when I click on it I go to product_info.php page with the product desription, no image appering here. But when I click the "review button" on the bottom, I get the thumbnail image and the "click to enlarge" button which opens the popup window with the arrows and images. :'( 3. In the admin area there is a "More Pics" tab, but no pics displayed. 4. The "remove image" function in admin, product update doesnt work. Please,please,please....I need your help. :'(
  13. ColorsbyLiza

    Sppc Does Not Display More Pics 6

    Whoops! Sent without my post...take 2... Hi! I am experiencing a problem as well. The thumnail image shows up in the main category and nothing in the product_info.php page. Also when I click on the review button, I see the thumbnail image that accesses the popup window. I just installed it last night and I have spent the whole day trying to figure out what the heck is happening. Other concerns are the mysql is giving me this error code, about adding: Error SQL query: ALTER TABLE `products` ADD `products_subimage1` VARCHAR( 64 ) AFTER `products_image` ; MySQL said: Documentation #1060 - Duplicate column name 'products_subimage1' And the other is in my admin there is a more pics section that is empty. Lots of issues. :'(
×