Jump to content

Ausgirl

Members
  • Content count

    922
  • Joined

  • Last visited

Everything posted by Ausgirl

  1. Ausgirl

    Blacklist

    G'day, When I try and login, I get this error. 1146 - Table 'savestra_osc1.TABLE_BLACKLIST' doesn't exist SELECT c.customers_id, b.customers_id, b.ban_customer, b.description FROM customers c, TABLE_BLACKLIST b WHERE b.customers_id = '2' [TEP STOP] I know this means that the table doesnt exists but it does, I double checked it. here what have I missed? CREATE TABLE blacklist ( customers_id int(13) NOT NULL default '0', ban_customer tinyint(1) NOT NULL default '0', attempted_use tinyint(1) NOT NULL default '0', description varchar(255) default NULL, entry_street_address varchar(64) NOT NULL, entry_suburb varchar(32), entry_postcode varchar(10) NOT NULL, entry_city varchar(32) NOT NULL, entry_state varchar(32), date_added datetime NOT NULL default '0000-00-00 00:00:00' ) TYPE=MyISAM;
  2. Ausgirl

    Information Pages Unlimited v1.0

    Hello, I was just wondering if you could place IPU in its own box instead of the information box and if so, could someone please tell me how to do it. Thanks
  3. Ausgirl

    SEO Assistant

    This one did the trick $data = @implode("", file($path)); Thanks Jack
  4. Ausgirl

    SEO Assistant

    G'Day, Ive been searching this thread and found that most people have my problem either with Google or MSN. Mine is with Zeal. Although it seems to work fine, I get this at the top of the page. I also updated from .7 to .9 Warning: file(http://www.zeal.com/search/results.jhtml?k...scope=directory) [function.file]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in admin/includes/functions/seo_link_popularity.php on line 127 Warning: implode() [function.implode]: Bad arguments. in admin/includes/functions/seo_link_popularity.php on line 127 Warning: file(http://www.zeal.com/search/results.jhtml?k...scope=directory) [function.file]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in admin/includes/functions/seo_link_popularity.php on line 127 Warning: implode() [function.implode]: Bad arguments. in admin/includes/functions/seo_link_popularity.php on line 127 It was working fine, then I suddenly got the error, then I updated thinking it would disappear but its still there. :blink: Thanks
  5. This contribution does not work for everyone. Before adding little extras to this contribution, I think it would serve everyone better if it could be updated first. If someone could be kind enough to do so, it would be much appreciated :)
  6. Hello, Need a BIG FAVOUR PLEASE!!! :) Can someone update this so it will work with Mysql 5. I really need this mod for my customers to upload there photos. I cant do it as I have no idea when it comes to writing php. Please someone, pretty please. Thanks
  7. Ausgirl

    OSC-Affiliate

    Lol, your right, it does sound a bit confusing. Thanks for explaining that Rhea, I thought it had something to do with that but had no idea exactly how it worked. I shall copy this to my file so that I refer back to it later. Thank you Much Appreciated :)
  8. Ausgirl

    OSC-Affiliate

    They have instructions on how to install, just no instructions on how it works. Im still waiting for a reply to my last post. What is the teir level and how does it work. Im assuming its if someone signs up then they get someone else to sign up ect... Some simple instructions wouldnt go astray if someone whom already knows how this works could include them in the file or post it here. This mod is a bit tricky to understand. I think this is a bit of a ghost thread :ph34r: I downloaded and am using the oscaffiliate v2.6
  9. Ausgirl

    Graphical Borders on RSS News

    <?php /* $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <?php // BOF: Header Tag Controller v2.6.0 if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE; ?></title> <?php } // EOF: Header Tag Controller v2.6.0 ?> <meta name="description" content="<?php echo $product_info['products_name']; ?>"> <meta name="keywords" content="<?php echo $product_info['products_name']; ?>"> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <?php include ('includes/ssl_provider.js.php'); ?> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le ft=150') } //--></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <a name="<?php echo $tags_array['title']; ?>"></a> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <?php $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); $products_name = $product_info['products_name']; ?> <?php echo mws_header (''); ?> <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <?php if ($product_check['total'] < 1) { ?> <tr> <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <?php } else { tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><h1><?php echo $products_name; ?></h1></td> <td align="right" valign="top"><h1><?php echo $products_price; ?></h1></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"> <?php if (tep_not_null($product_info['products_image'])) { ?> <table border="0" cellspacing="0" cellpadding="2" align="right"> <tr> <td align="center" class="smallText"> <script language="javascript"><!-- document.write('<?php echo '<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> </noscript> <br><br> <?php //affiliate build a link begin if (tep_session_is_registered('affiliate_id')) { ?> <?php echo '<a href="' . tep_href_link(FILENAME_AFFILIATE_BANNERS_BUILD, 'individual_banner_id=' . $product_info['products_id']) .'" target="_self">' . tep_image('includes/languages/english/images/buttons/button_affiliate_build_a_link.gif', 'Make a link') . ' </a>'; ?> <?php } //affiliate build a link begin ?> </td> </tr> </table> <?php } ?> <p><?php echo stripslashes($product_info['products_description']); ?></p> <?php $products_attributes_query = tep_db_query("select count(*) as total 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 . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td> </tr> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name 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(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix 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)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td> </tr> <?php } ?> </table> <?php } ?> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); if ($reviews['count'] > 0) { ?> <tr> <td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if (tep_not_null($product_info['products_url'])) { ?> <tr> <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td> </tr> <?php } else { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="smallText" align="center"><?php echo TEXT_VIEWING; ?> <?php echo '<a title="' . $tags_array['title'] . '" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $tags_array['title'] . '">' . $tags_array['title']; ?></a></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td> <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } } ?> </td> </tr> </table></form></td> <?php echo mws_footer (''); ?> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  10. Ausgirl

    Graphical Borders on RSS News

    Nope, it didnt work! I think its because the HTC takes over the headings but thats ok.
  11. Ausgirl

    Graphical Borders on RSS News

    Just wing it you reckon! LOL, The reason I asked was because the HTC makes your heading H1 priority. I just wondered if it would call on the header your little hack shows as it would be better that way, I think. Dont want it calling on a header that is no longer there. One can only have a go!
  12. Ausgirl

    Graphical Borders on RSS News

    G'day John, How nifty, do you think this would effect a site using HTC? Thanks
  13. Prices for Logged-In Users Only Can this be turned on & off? Can it be set for individual products only and not the entire store? If not, does anyone know of a contribution that is like Prices for Logged-In Users Only but can do the above? Thanks
  14. Ausgirl

    Graphical Borders on RSS News

    Thanks for that John, I am sooooooo blind sometimes, I already had all that code done. I left out one little noborderbox. :blush: As for replacing the lets see what we have here, you can change that in the english file but im not sure how you would make it call on the catagory titles. Have you tried Header Tag Controller, thats really good it will fill in all the headings for you. If you dont think that is what you are needing, maybe you should post that topic in the general thread as its nothing to do with GB so you will have more luck in finding an answer there. Hope that helps you a little. Thanks
  15. Ausgirl

    Graphical Borders on RSS News

    I know its in this thread, I have already done all that, thought you had found something else.
  16. Ausgirl

    Graphical Borders on RSS News

    If you found the fix could you please repost it so as I can fix mine. Thanks
  17. Ausgirl

    Graphical Borders on RSS News

    Hello John, Mine does that, hehehe, If you can post the fix here that you found, (I was looking but couldnt find it) I might be able to help you with it.
  18. Ausgirl

    OSC-Affiliate

    Could someone please explain to me what the Affiliate Tier Multilevel Affiliate provisions, is, please. Is this a referal from an affiliate? How exactly does it work? What is this % rate? Is that the % they are paid?
  19. Ausgirl

    Graphical Borders on RSS News

    No worries, I dont have the featured product mod installed, but Im sure it will help all those that do. :) Thanks for all your help, much appreciated.
  20. Ausgirl

    Graphical Borders on RSS News

    What! No more lessons? :) Thanks for the tips, mate :thumbsup:
  21. Ausgirl

    OSC-Affiliate

    Im not quite understanding how the "Payment" side of it works, if someone could please explain? I signed up as an affiliate, bought some products ect... I then went into the "Payment" Section on the Admin side, but none of this information is there so how do I start billing in order to pay? Affiliate Payment (excl.) Payment (incl.) Date Billed Status Action. I assume the start billing is so I can pay the affiliates. Where do I find the payment options? Paid by Paypal, Bank deposit ect...
  22. Ausgirl

    Graphical Borders on RSS News

    Ahhhh! Thats why I wasnt all lined up properly. Now Im all neat & lined up nicely, Thanks again, your a gem :)
×