Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

dblake

Archived
  • Posts

    841
  • Joined

  • Last visited

Everything posted by dblake

  1. It does work and this has already been fixed. Try reading before you come on here bad mouthing free contributions.
  2. You copied and pasted wrong. Make sure you follow the directions carefully. -Dennis
  3. Well its a problem with using other contributions in conjuction with this one. It's mainly the attributes section. It's the worst part of osc as it causes many problems and doesn't do hardly anything, hence the addition of QTpro and Master Products. I would look at these modifications but I do not have any time to spare, sorry. I dont even have time to do it for money... -Dennis
  4. Yes. Make sure you have followed the directions carefully. Seems your missing the addition the the file application_top.php. Dennis
  5. I have no idea without looking at it. But most likely, cuz the attributes id gets passed via the inputs from product_info.php. The actions are handled in application_top so you probably have to modify the code of what the actual input is, or how its called from the post. -Dennis
  6. Yea QT Pro is messing with you. I would have to take a look at why it is, but I don't have the time right now. Got too many pay projects going on. Use the wishlist 2.3 as example and see if you can figure it out. -Dennis
  7. For those that are inquirying as I have gotten a few, the wishlist_help file is being produced by Adrienne when she has time. -Dennis
  8. Sorry Nathalienature, I havent had time. You need to run the sql file with your favorite mysql program. I use phpmyadmin, and you should be able to find this tool in your cpanel, vdeck, plesk,... w/e admin panel you have. ;) -Dennis
  9. Well you can add a check to the session, but if someone is using a script to spam then it won't start a session. Yea I dunno how to stop that at the moment. I'll think on it. -Dennis EDIT: Actually I think you could add a check to the session and when the wishlist gets sent, it makes it a '1' for example. Then each time it goes to send the wishlist, run it through that check and if its been set to 1 then error out saying wishlist can only be sent once each session. Then to prevent spiders/scripts from using it, run the user browser agent check and if its a spider, don't allow them to use the email function at all.
  10. I dunno, you ruined all chances of anymore help by calling me denise!!!
  11. I can't duplicate this problem. When you add something to the wishlist, (not logged in) it stores that info in the session. When you login, it moves all the session stuff to the database, destroys the wishList session, then re-queries the db and puts it all back in the session. And thats the function restore_wishlist() in the includes/classes/wishlist.php file. I don't see where you would have the this problem unless you missed a step. Did you add this function to login? and create_account? -Dennis
  12. You need to take my wishlist code, then mimick the case 'buy_now'. So basically you add in a new case, say case 'add_to_wishlist' and go from there.
  13. Just change the link in the wishlist from the product_id with attributes, to just the product id. Will be fine. -Dennis
  14. Where id = current. You dont have a where statement. -Dennis
  15. No. This is not a gift registry. Thats how a gift registry would work. -Dennis
  16. It's amazing none else is having this problem cause everyone should. On wishlist_public.php find this <?php echo tep_draw_form('wishlist_form', tep_href_link(FILENAME_WISHLIST_PUBLIC)); ?> Replace that with this: <?php echo tep_draw_form('wishlist_form', tep_href_link(FILENAME_WISHLIST_PUBLIC, 'public_id=' .$public_id)); ?> That should fix you and everyone else. I will include this in my next update when I get around to it. -Dennis
  17. Its more than just a quick fix, if you know nothing of php you won't be able to add it, as you will need to add a new case in application_top.php. But if you want to dive in, just follow the example of the case "buy_now". -Dennis
  18. Here is my test stats_wishlist.php file. <?php /* $Id: stats_wishlists.php,v 1.00 2005/06/15 Aaron Hiatt [email protected] http://www.scaredrabbit.com osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); ?> <!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"> <script language="javascript" src="includes/general.js"></script> </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 width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <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> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_NUMBER; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS_COMPANY; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS_WISHLIST; ?></td> <!--Uncomment if you use the Separate Pricing Contribution <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS_GROUP_NAME; ?></td> --> </tr> <?php if (isset($HTTP_GET_VARS['page']) && ($HTTP_GET_VARS['page'] > 1)) $rows = $HTTP_GET_VARS['page'] * MAX_DISPLAY_SEARCH_RESULTS - MAX_DISPLAY_SEARCH_RESULTS; $customers_query_raw = "select a.entry_company, pd.products_name, w.products_id, c.customers_id, c.customers_firstname, c.customers_lastname from " . TABLE_WISHLIST . " w, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id where c.customers_id = w.customers_id and w.products_id = pd.products_id group by c.customers_firstname, c.customers_lastname order by c.customers_lastname desc"; $customers_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $customers_query_raw, $customers_query_numrows); // fix counted customers $customers_query_numrows = tep_db_query("select customers_id from " . TABLE_WISHLIST . " group by customers_id"); $customers_query_numrows = tep_db_num_rows($customers_query_numrows); $rows = 0; $customers_query = tep_db_query($customers_query_raw); while ($customers = tep_db_fetch_array($customers_query)) { $rows++; if (strlen($rows) < 2) { $rows = '0' . $rows; } ?> <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='<?php echo tep_href_link(FILENAME_CUSTOMERS, 'selected_box=customers&page=1&cID=' . $customers['customers_id'], 'NONSSL'); ?>'"> <td class="dataTableContent" valign="top" align="center"><?php echo $rows; ?>.</td> <td class="dataTableContent" valign="top"><?php echo $customers['customers_firstname'] . ' ' . $customers['customers_lastname']; ?></td> <td class="dataTableContent" valign="top"><?php echo $customers['entry_company']; ?></td> <td valign="top" class="dataTableContent"> <?php $wishlist_query = tep_db_query("select products_id from " . TABLE_WISHLIST . " where customers_id = '" . $customers[customers_id] . "'"); while($wishlist = tep_db_fetch_array($wishlist_query)) { $product_id = tep_get_prid($wishlist[products_id]); $products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $product_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name"); $products = tep_db_fetch_array($products_query); echo $products['products_name'] . ' ' . $currencies->format($products['final_price']) . '<br>'; } ?> </td> <!--Uncomment if you use the Separate Pricing Contribution <td class="dataTableContent" valign="top"><?php echo $customers['customers_group_name']; ?></td> --> </tr> <?php } ?> </table></td> </tr> <tr> <td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText" valign="top"><?php echo $customers_split->display_count($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_CUSTOMERS); ?></td> <td class="smallText" align="right"><?php echo $customers_split->display_links($customers_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']); ?> </td> </tr> </table></td> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> <input type="image" src="includes/languages/english/images/buttons/button_wishlist.gif" border="0" alt="Add to Wishlist" title=" Add to Wishlist " name="wishlist" value="wishlist" /> -Dennis
  19. Ok Carlos, this should get you started and you see where I took this code from and what I did. I took from wishlist.php file so you can add in the attributes by following that code. First thing open up stats_wishlist.php and add this at the top like so: require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); Then here is your query info. I replaced all of his as we needed to get the product_id from the wishlist table and strip off the attributes from it with the function tep_get_prid(); <td valign="top" class="dataTableContent"> <?php $wishlist_query = tep_db_query("select products_id from " . TABLE_WISHLIST . " where customers_id = '" . $customers[customers_id] . "'"); while($wishlist = tep_db_fetch_array($wishlist_query)) { $product_id = tep_get_prid($wishlist[products_id]); $products_query = tep_db_query("select pd.products_id, pd.products_name, pd.products_description, p.products_image, p.products_status, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where pd.products_id = '" . $product_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by products_name"); $products = tep_db_fetch_array($products_query); echo $products['products_name'] . ' ' . $currencies->format($products['final_price']) . '<br>'; } ?> </td> You can add on to that and format it however cuz as it stands right now I hate the format of the admin stats. Make it nice and release it ;) -Dennis
  20. just dont use the tep_image_submit function, just use strait html. -Dennis
×
×
  • Create New...