Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

WendyM

Pioneers
  • Posts

    61
  • Joined

  • Last visited

Profile Information

  • Real Name
    Wendy Mitchell
  • Location
    Shelby, NC USA

WendyM's Achievements

  1. I am having some problems with the admin/stats_keywords.php file First I get this: Somehow I got that fixed, but got this error: Am using PHP version 4.3.5 Here is the out of the box file for admin/stats_keywords.php <?php /* $Id: stats_keywords.php,v 0.90 10/03/2002 03:15:00 Exp $ by Cheng osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if(isset($_GET['txtWord']) && $_GET['txtWord'] != '' && isset($_GET['txtReplacement']) && $_GET['txtReplacement'] != '' && !isset($_GET['updateword'])){ $newword_sql = "INSERT INTO searchword_swap (sws_word, sws_replacement)VALUES('" . addslashes($_GET['txtWord']) . "', '" . addslashes($_GET['txtReplacement']) . "' )"; $result = tep_db_query($newword_sql); header('location: ' . tep_href_link('stats_keywords.php', 'action=' . BUTTON_VIEW_WORD_LIST . '')); exit; } if(isset($_GET['removeword']) && isset($_GET['delete'])){ $word_delete_sql = "DELETE FROM searchword_swap WHERE sws_id = " . $_GET['delete']; $result = tep_db_query($word_delete_sql); header('location: ' . tep_href_link('stats_keywords.php', 'action=' . BUTTON_VIEW_WORD_LIST . '')); } if(isset($_GET['editword']) && isset($_GET['link'])){ $word_select_sql = "SELECT * FROM searchword_swap WHERE sws_id = " . $_GET['edit']; $result = tep_db_query($word_select_sql); $word_select_result = tep_db_fetch_array($result); } if(isset($_GET['editword']) && isset($_GET['updateword'])){ $word_update_sql = "UPDATE searchword_swap SET sws_word= '" . addslashes($_GET['txtWord']) . "', sws_replacement = '" . addslashes($_GET['txtReplacement']) . "' WHERE sws_id = " . $_GET['id']; $result = tep_db_query($word_update_sql); header('location: ' . tep_href_link('stats_keywords.php', 'action=' . BUTTON_VIEW_WORD_LIST . '')); } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"> <table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td valign="top"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr><tr> <td class="main" colspan="2"> <?php if ($_GET['action'] == 'Delete') { tep_db_query("delete from search_queries_sorted"); } // delete db if ($_GET['update'] == BUTTON_UPDATE_WORD_LIST) { $sql_q = tep_db_query("SELECT DISTINCT search_text, COUNT(*) AS ct FROM search_queries GROUP BY search_text"); while ($sql_q_result = tep_db_fetch_array($sql_q)) { $update_q = tep_db_query("select search_text, search_count from search_queries_sorted where search_text = '" . $sql_q_result['search_text'] . "'"); $update_q_result = tep_db_fetch_array($update_q); $count = $sql_q_result['ct'] + $update_q_result['search_count']; if ($update_q_result['search_count'] != '') { tep_db_query("update search_queries_sorted set search_count = '" . $count . "' where search_text = '" . $sql_q_result['search_text'] . "'"); } else { tep_db_query("insert into search_queries_sorted (search_text, search_count) values ('" . $sql_q_result['search_text'] . "'," . $count . ")"); } // search_count tep_db_query("delete from search_queries"); } // while } // updatedb ?> <?php if(isset($_GET['action']) && $_GET['action']== BUTTON_VIEW_WORD_LIST) //switch for view word list { echo tep_draw_form('addwords', 'stats_keywords.php', '', 'get'); ?> <table border="0" cellpadding="2" cellspacing="0" width="100%"> <?php if(isset($_GET['add'])) { ?> <tr><td colspan="4"> <table border="1" cellpadding="0" cellspacing="1" width="100%" bgcolour="gray"><tr><td> <table border="0" cellpadding="2" cellspacing="0" width="100%"><tr class="dataTableRow"> <td class="main" nowrap><br><?php echo WORD_ENTRY_ORIGINAL ?> <input type="text" name="txtWord" value="<?php if(isset($word_select_result['sws_word'])){echo stripslashes($word_select_result['sws_word']);} ?>" size="12"> <?php echo WORD_ENTRY_REPLACEMENT ?> <input type="text" name="txtReplacement" value="<?php if(isset($word_select_result['sws_replacement'])){echo stripslashes($word_select_result['sws_replacement']);} ?>" size="12"></td> <?php if(isset($word_select_result['sws_id'])){echo '<input type="hidden" name="id" value="' . $word_select_result['sws_id'] . '">';} ?> </tr> <tr class="dataTableRow"> <td class="main"><?php if(isset($_GET['editword']) && isset($_GET['link'])){ ?> <input type="submit" name="editword" value="<?php echo BUTTON_EDIT_WORD ?>"> <input type="hidden" name="updateword" value="1"> <br><br><?php } else { ?> <input type="submit" name="newword" value="<?php echo BUTTON_ADD_WORD ?>"><br><br> <?php } ?> </td> </tr> </table></td></tr></table> </d></tr> <?php } ?> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" width="40%"><?php echo WORD_ENTRY_ORIGINAL ?></td> <td class="dataTableHeadingContent" colspan="3"><?php echo WORD_ENTRY_REPLACEMENT ?></td> </tr> <?php $pw_word_sql = "SELECT * FROM searchword_swap ORDER BY sws_word ASC"; $pw_words = tep_db_query($pw_word_sql); while ($pw_words_result = tep_db_fetch_array($pw_words)) { ?> <tr class="dataTableRow"> <td class="dataTableContent"><?php echo stripslashes($pw_words_result['sws_word']); ?></td> <td class="dataTableContent"><?php echo stripslashes($pw_words_result['sws_replacement']); ?></td> <td class="dataTableHeadingContent"><a href="<?php echo tep_href_link('stats_keywords.php', 'editword=1&link=1&add=1&action=' . BUTTON_VIEW_WORD_LIST . '&edit=' . $pw_words_result['sws_id']); ?>"><u><?php echo LINK_EDIT ?></u></a></td> <td class="dataTableHeadingContent"><a href="<?php echo tep_href_link('stats_keywords.php', 'removeword=1&delete=' . $pw_words_result['sws_id']); ?>"><u><?php echo LINK_DELETE ?></u></a></td> </tr> <?php } // while ?> <tr> <td colspan="4" class="main" align="right"><br><input type="submit" value="New Entry" name="add" method="post" /> <input type="hidden" name="action" value="<?php echo BUTTON_VIEW_WORD_LIST ?>"></td> </tr> </table></form> <?php } //end 'if' switch for view word list if(!isset($_GET['action']) && $_GET['action'] != BUTTON_VIEW_WORD_LIST){ ?> <table border="0" cellpadding="2" cellspacing="0" width="100%"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" width="40%"><?php echo KEYWORD_TITLE ?></td> <td class="dataTableHeadingContent"><?php echo KEYWORD_TITLE2 ?></td> </tr> <?php switch($_GET['sortorder']){ case BUTTON_SORT_NAME: $pw_sql = "SELECT search_text, search_count FROM search_queries_sorted ORDER BY search_text ASC"; break; case BUTTON_SORT_TOTAL: $pw_sql = "SELECT search_text, search_count FROM search_queries_sorted ORDER BY search_count DESC"; break; default: $pw_sql = "SELECT search_text, search_count FROM search_queries_sorted ORDER BY search_text ASC"; break; } $sql_q = tep_db_query($pw_sql); while ($sql_q_result = tep_db_fetch_array($sql_q)) { ?> <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="document.location.href='<?php echo tep_catalog_href_link( 'advanced_search_result.php', 'keywords=' . urlencode($sql_q_result['search_text']). '&search_in_description=1' ); ?>'" > <td class="dataTableContent"><a target="_blank" href="<?php echo tep_catalog_href_link( 'advanced_search_result.php', 'keywords=' . urlencode($sql_q_result['search_text']). '&search_in_description=1' ); ?>"><?php echo $sql_q_result['search_text']; ?></a></td> <td class="dataTableContent"><?php echo $sql_q_result['search_count']; ?></td> </tr> <?php } // while ?> </td></tr></table> <?php } ?> </td> </tr> </table> </td> <!-- body_eof //--> <!-- right_column_bof //--> <td valign="top" width="25%"> <?php echo tep_draw_form('delete', 'stats_keywords.php', '', 'get'); ?> <table border="0" cellspacing="0" cellpadding="2" width="100%"> <tr> <td class="pageHeading" align="right"> </td> </tr><tr> <td> <?php $heading = array(); $contents = array(); $heading[] = array('text' => '<b>' . SIDEBAR_HEADING . '</b>'); $contents[] = array('text' => '<br>' . SIDEBAR_INFO_1); $contents[] = array('text' => '<input type="submit" name="update" value="' . BUTTON_UPDATE_WORD_LIST . '">'); $contents[] = array('text' => tep_draw_separator()); $contents[] = array('text' => '<br><input type="submit" name="sortorder" value="' . BUTTON_SORT_NAME . '"><br><input type="submit" name="sortorder" value="' . BUTTON_SORT_TOTAL . '">'); $contents[] = array('text' => tep_draw_separator()); $contents[] = array('text' => '<br>' . SIDEBAR_INFO_2); $contents[] = array('text' => '<input type="submit" value="' . BUTTON_DELETE . '" name="action">'); $contents[] = array('text' => tep_draw_separator()); $contents[] = array('text' => SIDEBAR_INFO_3); $contents[] = array('text' => '<input type="submit" name="action" value="' . BUTTON_VIEW_WORD_LIST . '">'); if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) { $box = new box; echo $box->infoBox($heading, $contents); } ?> </td></tr></table></form> </td> </tr> </table> <!-- right_column_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Thanks in advance! Wendy
  2. I just installed this contribution and it is great! I do have a slight problem tho. When I set the image size using admin-->images and click on update, it turns off the contribution. I then have to go in thru admin-->all products and turn it back on. Any idea how I messed this up? Thanks in advance. Wendy
  3. Could still use some help with this, if anyone has the time. At one point I got pictures to show, but they were very big. Thanks again!
  4. I'm using All Prods v2.61 and using "allprods_without_model.php", does not currently show pictures. I'd like to have pictures show, but just small ones...say, using the "small_height" and "small_width" parameters.(the ones I set up through admin...used for thumbnails?) I do not know how to do this, as my knowledge of PHP is still quite limited. (I looked at the code from the "new products" php file since it shows those small pictures I would like to see, but still couldn't quite "get" it) Could anyone please post the code that I should add to accomplish this? Much thanks in advance. :) The actual file I'm using is shown below: ========================== <?php /* $Id: allprods.php,v 1.5 2002/09/29 1 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ALLPRODS); // Set number of columns in listing define ('NR_COLUMNS', 1); // $breadcrumb->add(HEADING_TITLE, tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL')); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <?php // BOF: WebMakers.com Changed: Header Tag Controller v1.0 // Replaced by header_tags.php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE ?></title> <?php } // EOF: WebMakers.com Changed: Header Tag Controller v1.0 ?> <base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- 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="8"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td align="right"></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="productListing-heading"> <td align="left" class="productListing-heading">Product Name</td> <td align="center" class="productListing-heading">Manufacturer</td> <td align="right" class="productListing-heading">Price </td> </tr> <?php $languages_query = tep_db_query("select languages_id, name, code, image, directory from " . TABLE_LANGUAGES . " order by sort_order"); while ($languages = tep_db_fetch_array($languages_query)) { $languages_array[] = array('id' => $languages['languages_id'], 'name' => $languages['name'], 'code' => $languages['code'], 'image' => $languages['image'], 'directory' => $languages['directory']); } for ($i=0; $i<sizeof($languages_array); $i++) { $this_language_id = $languages_array[$i]['id']; $this_language_name = $languages_array[$i]['name']; $this_language_code = $languages_array[$i]['code']; $this_language_image = $languages_array[$i]['image']; $this_language_directory = $languages_array[$i]['directory']; echo " <tr>\n"; $products_query = tep_db_query("select p.products_id, p.products_model ,pd.products_name, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name"); $products_array = array(); while($products = tep_db_fetch_array($products_query)) { $products_array[] = array('id'=> $products['products_id'], 'name' => $products['products_name'], 'manufacturer' => $products['manufacturers_name'], 'price' => $products['products_price'], 'tax' => $products['products_tax_class_id'], 'special' => $products['specials_new_products_price']); } $num_prods = sizeof($products_array); // This optimizes that slow FOR loop... for ($i = 0; $i < $num_prods; $i++) // Traverse Rows { // Rotate Row Colors if ($i % 2) // Odd Row { $row_col = 'class="productListing-odd"'; } else // Guess... { $row_col = 'class="productListing-even"'; } $this_id = $products_array[$i]['id']; $this_name = $products_array[$i]['name']; $this_manufacturer = $products_array[$i]['manufacturer']; $this_price = $products_array[$i]['price']; $this_special = $products_array[$i]['special']; $this_tax = $products_array[$i]['tax']; $this_url = tep_href_link(FILENAME_PRODUCT_INFO, 'store=' . str_replace(" ", "_", $this_name). '&products_id=' . $this_id . (($this_language_code == DEFAULT_LANGUAGE) ? '' : ('&language=' . $this_language_code)), 'NONSSL', false); echo "<tr $row_col>"; echo "<td class='productListing-data' align='left'><a href='$this_url'>$this_name</a></td>"; echo "<td class='productListing-data' align='center'><a href='$this_url'>$this_manufacturer</a></td>"; if (tep_not_null($this_special)) { echo "<td class='productListing-data' align='right'><a href='$this_url'><span class='productSpecialPrice'>".$currencies->display_price($this_special, tep_get_tax_rate($this_tax))."</span></a></td>"; } else { echo "<td class='productListing-data' align='right'><a href='$this_url'>".$currencies->display_price($this_price, tep_get_tax_rate($this_tax))."</a></td>"; } echo "</tr>\n"; } } ?> </td> </tr> </table></td> </tr> <tr> <td align="right" class="main"><br><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT, '', 'NONSSL') . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="8"> <!-- 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 //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> =============================
  5. Osc 2.2MS2 English--only language Quite a few mods/contribs 1.6 appears to be working correctly; no problems--no typos--no errors showing up anywhere that I can find. ===== (I have implemented all your updates...heh heh) I feel kinda like raijen in an earlier post. :P But seriously, it has been worth every change....each one was an improvement over the previous one. And it paid off. Looks great and works great for me. Thanks for all your work and patience. Wendy
  6. Aalst: Thanks are not enough.....BRAVO!!! :D Works terrific and on the first try too! :lol: :) Wendy :)
  7. Hi all, I'm with catgirl.........I just want the report tool. I followed instructions found in "11/04/2003 - 1.3 Unsold Carts Report" I get "parse error on line 93 of unsold_carts.php" Any help would be appreciated. Here is the general area of line 93: // echo " ~~ ".$curcus." == ".$inrec['cid']." ~~ " .$inrec['fname']." ~~ "; if ($curcus != $inrec['cid']) { // output line $cline .= "<tr><td><b>Final Price: </b>".$tprice."</td></tr></table></td></tr>" ; if ($curcus != "") echo $cline; // set new cline and curcus $curcus = $inrec['cid']; $tprice = 0; $cline = "<tr><td valign=top colspan=2><hr size=1 color=000080></td></tr><tr><td valign=top>".$inrec['fname']." ".$inrec['lname']." <br><font size=2 color=000080><a href='" . tep_href_link('mail.php', 'selected_box=tools&customer=' $inrec['email'], '') . "'>" .$inrec['email']."</a><br> ".$inrec['phone']."</td><td><table>"; } // empty the shopping cart Thanks in advance! Wendy PS....I did not install any of the earlier entries to that contribution, just the one download called "11/04/2003 - 1.3 Unsold Carts Report" edited to add a link to the contribution: http://www.oscommerce.com/community/contributions,1598
  8. put your site name there....I put "Its2cheap"(without the .com)
  9. works on the links categories page, but when I click on a category, it gives me a syntax error: Thank you so much for helping me with this. I appreciate it very very much. :D Wendy
  10. In links manager, I'd like to show how many links are in each category. I have the links.php from a site which does this....but cannot seem to extract the needed info. So far, I've made a complete mess and broke the contrib a couple different times. :o lol (it's back together, of course, cuz I copied my original "links.php") I'm not much of a programmer, in any language. But I'm sure trying to learn 'em. Thanks in advance! Wendy :P
  11. ALSO: Is there a way to "only" show manufacturer(in customers drop-down box) if a product is available by that manufacturer? If not, customer has to view a lot of pages that show "There are no products to list in this category."
  12. When adding product thru admin, there is a drop-down to choose a manufacturer.... BUT...if manufacturer isnt already on the list, have to go back and add the manufacturer, then go back to product and choose the manufacturer that I just added Very tiring....list is always changing, cuz I only sell (1) of each item---vintage collectibles :blink: Is there a contribution that allows you to ADD manufacturer (if not on list) at time of adding product, thru admin? Any help is always appreciated! :D Wendy
  13. I finally removed it today....couldn't figger out how to make a customer a "member". When posting an order, it never deducted anything for me. Kept removing and adding it in again, thinking I must have made an error. I'm with Heliosquare.....my eyes, my eyes! :blink: But tomorrow is another day.......
  14. Hi Farrukh! No problem at all....I actually thought it might be needed for Google, like to maybe appear the page was from another site or something. Heh heh :lol: I know....I am such the knucklehead! :blink: I thank you bunchies and bunchies for this contrib. I love it! Most items I sell are one-only-available and this is a terrific way for the customers to see it all on one page. Inventory is always changing, sometimes more than once a day. ugh! But I DO enjoy it. :) Wendy
×
×
  • Create New...