Jump to content

Jonojamesmac

Members
  • Content count

    145
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by Jonojamesmac

  1. Jonojamesmac

    Problem in catalog/article_info.php

    has TABLE_HEADERTAGS been defined in include/database_tables.php? like so define('TABLE_HEADERTAGS_DEFAULT', 'headertags_default'); define('TABLE_HEADERTAGS', 'headertags');
  2. Jonojamesmac

    Newsletter images problem

    use a full link i.e http://www.website.com/images/image.ext so it should be your code like.. <a href="http://www.website.com"><img src="http://www.website.com/images/image.gif" width="width" height ="height" /></a>
  3. try CREATE TABLE seo_to_products( seo_types_id int( 11 ) NOT NULL , products_id int( 11 ) NOT NULL , seo_name VARCHAR( 255 ) NOT NULL , PRIMARY KEY ( seo_types_id, products_id ) ) TYPE = MYISAM
  4. Jonojamesmac

    Move the extra fields

    Can't see what you mean in the link, looking at the extra field code, its clearly marked in product_info.php, paste it here including a few lines above and below..
  5. Jonojamesmac

    iPhone/iPod Touch Web App

    What is the admin table called?
  6. Jonojamesmac

    calling the manufacturer image into play

    change tep_image(DIR_EXT_HTTP . $man['manufacturers_image'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) to this tep_image(DIR_EXT_HTTP . $man['manufacturers_image'], $man['manufacturers_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)
  7. Jonojamesmac

    calling the manufacturer image into play

    <td align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_EXT_HTTP . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br> <a href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS). '">' . tep_image(DIR_WS_IMAGES . '/buttons/featured.gif', IMAGE_FEATUREDPRODUCT). '</a> </td> <td class="smallText">'. strip_tags($description['products_description']) . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $featured_products["products_id"]). '">' . DESCR_READ_MORE . '</a><br><br><a href="' . tep_href_link(FILENAME_DEFAULT, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $featured_products['products_id']) . '">' . tep_image_button('cart_buy.gif', IMAGE_BUTTON_IN_CART) . '</a> ' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $featured_products['manufacturers_id']) . '">' . tep_image(DIR_EXT_HTTP . $man['manufacturers_image'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td> <td background="images/infobox/right.gif" class="smallText"><img src="images/infobox/right.gif" width="14" height="100" /></td> Try this...
  8. Jonojamesmac

    iPhone/iPod Touch Web App

    Do you have access to your database at all? via the likes of phpmyadmin etc?
  9. Jonojamesmac

    'Add to cart' showing empty shopping cart

    make sure that you are including it within the loop for that specific product, after something along these lines.. while ($products_new = tep_db_fetch_array($products_new_query)) {
  10. Jonojamesmac

    'Add to cart' showing empty shopping cart

    Replace if($product_info['products_quantity'] <= 0 || $product_info['products_status']==0) $linkbutton = tep_image_button('button_out_of_stock.gif'); else $linkbutton = tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart1.gif', IMAGE_BUTTON_IN_CART); with if($product_info['products_quantity'] <= 0 || $product_info['products_status']==0) { $linkbutton = tep_image_button('button_out_of_stock.gif'); } else { $linkbutton = '<a href="'.tep_href_link("products_new.php","action=buy_now&products_id=".$p_id).'">'.tep_image_button('button_add_to_cart1.gif').'</a>'; } and replace <a href="'.tep_href_link("products_new.php","action=buy_now&products_id=".$p_id).'">'.$linkbutton.'</a> with ' . $linkbutton . '
  11. Jonojamesmac

    iPhone/iPod Touch Web App

    On your database server. At your database
  12. Jonojamesmac

    iPhone/iPod Touch Web App

    Whats the database table called where your administrators info is?
  13. Jonojamesmac

    Title Tag

    I don't really understand your question... If you mean rearrange the title you have quoted, thats easy. Like.. <title><?php echo (strlen($title_tag) > 1) ? TITLE . ' - ' . $title_tag : TITLE . ' - ' . $title_home_default; ?></title>
  14. Jonojamesmac

    iPhone/iPod Touch Web App

    When you added the password for your new user did you encrypt it using md5 encryption first? If not there are plenty of tools on the net, just search :) Make sure when you type your username in, it matches including case.
  15. Jonojamesmac

    'Add to cart' showing empty shopping cart

    Same for all instances in the non working listings just replace <td width="100%"><a href="'.tep_href_link("products_new.php","action=buy_now&products_id=".$p_id).'">'.tep_image_button('button_add_to_cart1.gif').'</a>'.tep_image(DIR_WS_IMAGES.'z6.gif').'<a href="' . tep_href_link('product_info.php?products_id='.$p_id) . '">'.tep_image_button("button_details.gif").'</a></td><td>'.tep_draw_separator('spacer.gif', '5', '1').'</td> with <td width="100%"><a href="'.tep_href_link("products_new.php","action=buy_now&products_id=".$p_id).'">'.$linkbutton.'</a>'.tep_image(DIR_WS_IMAGES.'z6.gif').'<a href="' . tep_href_link('product_info.php?products_id='.$p_id) . '">'.tep_image_button("button_details.gif").'</a></td><td>'.tep_draw_separator('spacer.gif', '5', '1').'</td> add above out of the table if($product_info['products_quantity'] <= 0 || $product_info['products_status']==0) $linkbutton = tep_image_button('button_out_of_stock.gif'); else $linkbutton = tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart1.gif', IMAGE_BUTTON_IN_CART);
  16. Jonojamesmac

    calling the manufacturer image into play

    Your missing a comma after p.manufacturers_id My fault though as i missed it out initially :)
  17. Jonojamesmac

    calling the manufacturer image into play

    oops was late last night :P $mansql = "select manufacturers_image from manufacturers where manufacturers_id = $featured_products['manufacturers_id']"; change to $mansql = "select manufacturers_image from manufacturers where manufacturers_id = '" . $featured_products['manufacturers_id']."'";
  18. Jonojamesmac

    calling the manufacturer image into play

    include manufacturers_id in the sql query like so.. $featured_products_query = tep_db_query("select p.manufacturers_id p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } else { $info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name)); $featured_products_query = tep_db_query("select distinct p.manufacturers_id, p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $featured_products_category_id . "' and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } and before both instances of $sql = 'SELECT `products_description` FROM `products_description` WHERE products_id ='.$featured_products['products_id'].' && language_id='.(int)$languages_id; add $mansql = "select manufacturers_image from manufacturers where manufacturers_id = $featured_products['manufacturers_id']"; $manresult = mysql_query($mansql) or die(mysql_error()); $man = mysql_fetch_array($manresult); then in both tables place the code to grab the image wherever you like something along these lines <a href="index.php?manufacturers_id=' . $featured_products['manufacturers_id']. '"><img src="images/'.$man['manufacturers_image'].'"/></a>
  19. Jonojamesmac

    CONTRIB- FCKeditor

    Anything wrong with this? /home/content/t/e/c/.........html/catalog/
  20. Jonojamesmac

    'Add to cart' showing empty shopping cart

    in application_top.php find the line case 'buy_now' : if (isset($HTTP_GET_VARS['products_id'])) { from that line down to the line above case'notify' replace with: case 'buy_now' : if (isset($HTTP_GET_VARS['products_id'])) { if (tep_has_product_attributes($HTTP_GET_VARS['products_id'])) { tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $HTTP_GET_VARS['products_id'])); } else { $cart->add_cart($HTTP_GET_VARS['products_id'], $cart->get_quantity($HTTP_GET_VARS['products_id'])+1); } } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break;
  21. Jonojamesmac

    [CONTRIBUTION] Customers list improved

    Steve's code is almost right i think, just missing a tiny piece. Replace <td class="dataTableContent" align="center"><?php echo htmlspecialchars($customers['entry_referral']); With <?php if ($entry_referral != 0) { $source_query = tep_db_query("select customers_firstname, customers_lastname from " . TABLE_CUSTOMERS . " where customers_id = " . $customers['entry_referral']); $source = tep_db_fetch_array($source_query); $referrer_name = $source['customers_firstname'] . " " . $source['customers_lastname']; ?> <td class="dataTableContent" align="center"><?php echo htmlspecialchars($referrer_name); ?></td> <?php } else { ?> <td class="dataTableContent" align="center"> </td> <?php } ?>
  22. Jonojamesmac

    additional images module

    Example
  23. Jonojamesmac

    'Add to cart' showing empty shopping cart

    Replace: <a href="'.tep_href_link("products_new.php","action=buy_now&products_id=".$p_id).'">'.tep_image_button('button_add_to_cart1.gif').'</a> With: <a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $products_new['products_id']) . '">' . tep_image_button('button_add_to_cart1.gif', IMAGE_BUTTON_BUY_NOW) . '</a> The reason you may not get a response is mainly because your code is heavily modded from the orginal oscommerce.
  24. Jonojamesmac

    iPhone/iPod Touch Web App

    Working on next update to include products information. I will work on the status update as well.
  25. Jonojamesmac

    iPhone/iPod Touch Web App

    Replace where user_name too with whatever you use to log in with, aka admin_firstname ?
×