marretjeca Posted November 3, 2008 Share Posted November 3, 2008 Hi after several days searching everywhere, I give up. I installed MVS1.1 and it is working fine except for the Vendors Products Report page and the Orders by Vendor Page. Nothing happens: the drop down falls back to none, and no vendors are being shown.Because the shop is heavenly modified I installed a new fresh clean instance from oscommerce and installed just MVS1.1. To my great surprise the same thing happened. After reading this post I tried to turn on and off register global in php.ini, but that did not help either. Who can help me out here? Thanks, Marja :) blafrogMar 14 2007, 04:54 AM I have the same problems, no orders in order list, no products in Vendors Products Report, no emails sent etc.. because I installed register global patch (cause mine is set "OFF"). I finally got it working, just set register global on in php.ini. Some contributions not working, now they seem all working fine like, anti robot reg, super contact us enhancement.. <?php /* $ID: prods_by_vendor.php (for use with MVS) by Craig Garrison Sr, BluCollar Sales for MVS V1.0 2006/03/25 JCK/CWG osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2006 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); $sort_by_filter2 = $sort_by_filter; if (!isset($sort_by_filter)) { $sort_by_filter = 'p.products_price'; } if ($sort_by_filter == 'prod') { $sort_by_filter = 'pd.products_name'; } elseif ($sort_by_filter == 'vpid'){ $sort_by_filter = 'p.vendors_prod_id'; } elseif ($sort_by_filter == 'pid'){ $sort_by_filter = 'p.products_id'; } elseif ($sort_by_filter == 'qty'){ $sort_by_filter = 'p.products_quantity'; } elseif ($sort_by_filter == 'vprice'){ $sort_by_filter = 'p.vendors_product_price'; } elseif ($sort_by_filter == 'price'){ $sort_by_filter = 'p.products_price'; } ?> <!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> <?php //vendors_email start $vendors_array = array(array('id' => '1', 'text' => 'NONE')); $vendors_query = tep_db_query("select vendors_id, vendors_name from " . TABLE_VENDORS . " order by vendors_name"); while ($vendors = tep_db_fetch_array($vendors_query)) { $vendors_array[] = array('id' => $vendors['vendors_id'], 'text' => $vendors['vendors_name']); } ?> <td class="main" align="left"><?php echo TABLE_HEADING_VENDOR_CHOOSE . ' '; ?><?php echo tep_draw_form('vendors_report', FILENAME_PRODS_VENDORS) . tep_draw_pull_down_menu('vendors_id', $vendors_array,'','onChange="this.form.submit()";');?></form></td> <td class="main" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS) . '"><b>Go To Vendors List</a>';?> <td></tr> <tr> <td class="main" align="left"><br> <?php if ($show_order == 'desc') { echo 'Click for <a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=' . $sort_by_filter . '&show_order=asc') . '"><b>ascending order</b></a>'; } else { echo 'Click for <a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=' . $sort_by_filter . '&show_order=desc') . '"><b>descending order</b></a>'; } ?> </div></td> </tr> </table><?php if (isset($vendors_id)) { ?> <?php // $vendors_id = $HTTP_POST_VARS['vendors_id']; $vend_query_raw = "select vendors_name as name from " . TABLE_VENDORS . " where vendors_id = '" . $vendors_id . "'"; $vend_query = tep_db_query($vend_query_raw); $vendors = tep_db_fetch_array($vend_query); ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="1"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="left"><?php echo TABLE_HEADING_VENDOR; ?></td> <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=prod') . '">' . TABLE_HEADING_PRODUCTS_NAME . '</a>'; ?> </td> <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=vpid') . '">' . TABLE_HEADING_VENDORS_PRODUCT_ID . '</a>'; ?></td> <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=pid') . '">' . TABLE_HEADING_PRODUCTS_ID . '</a>'; ?></td> <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=qty') . '">' . TABLE_HEADING_QUANTITY . '</a>'; ?></td> <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=vprice') . '">' . TABLE_HEADING_VENDOR_PRICE . '</a>'; ?></td> <td class="dataTableHeadingContent" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODS_VENDORS, '&vendors_id=' . $vendors_id . '&line=price') . '">' . TABLE_HEADING_PRICE . '</a>'; ?></td> </tr> <tr class="dataTableRow"> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_VENDORS, '&vendors_id=' . $vendors_id . '&action=edit') . '" TARGET="_blank"><b>' . $vendors['name'] . '</a></b>'; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo ''; ?></td> <?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; $rows = 0; if($show_order == 'desc') { $products_query_raw = "select p.products_id, p.vendors_id, pd.products_name, p.products_quantity , p.products_price, p.vendors_product_price, p.vendors_prod_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.vendors_id = " . $vendors_id . " and pd.language_id = " . $languages_id . " order by " . $sort_by_filter . " desc"; } elseif ($show_order == 'asc') { $products_query_raw = "select p.products_id, p.vendors_id, pd.products_name, p.products_quantity , p.products_price, p.vendors_product_price, p.vendors_prod_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.vendors_id = " . $vendors_id . " and pd.language_id = " . $languages_id . " order by " . $sort_by_filter . " asc"; } else { $products_query_raw = "select p.products_id, p.vendors_id, pd.products_name, p.products_quantity , p.products_price, p.vendors_product_price, p.vendors_prod_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.vendors_id = " . $vendors_id . " and pd.language_id = " . $languages_id . " order by " . $sort_by_filter . ""; } /* $products_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows); Decide not to use SPLIT pages for the $vendors_id variable not being maintained. */ $products_query = tep_db_query($products_query_raw); while ($products = tep_db_fetch_array($products_query)) { $rows++; if (strlen($rows) < 2) { $rows = '0' . $rows; } ?> <tr class="dataTableRow"> <?php if($products['vendors_prod_id']=='') { $products['vendors_prod_id']= 'None Specified'; } ?> <td class="dataTableContent"><?php echo ''; ?></td> <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=new_product&pID=' . $products['products_id']) . '" TARGET="_blank"><b>' . $products['products_name'] . '</a></b>'; ?></td> <td class="dataTableContent"><?php echo $products['vendors_prod_id']; ?></td> <td class="dataTableContent"><?php echo $products['products_id']; ?></td> <td class="dataTableContent" align="left"><?php echo $products['products_quantity']; ?> </td> <td class="dataTableContent"><?php echo $products['vendors_product_price']; ?></td> <td class="dataTableContent"><?php echo $products['products_price']; ?></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 $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td> <td class="smallText" align="right"><?php // echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'].$vendors_id); ?></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'); ?> Quote Link to comment Share on other sites More sharing options...
♥kymation Posted November 4, 2008 Share Posted November 4, 2008 Did you use the MVS 1.1 from 1 Apr 2006? If not, back off and start over. If you did, take a look at the /admin/vendors.php fix on the MVS distribution page. If you're still having problems, try searching the MVS forum thread for "Vendors Products Report". Regards Jim Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
marretjeca Posted November 12, 2008 Author Share Posted November 12, 2008 Did you use the MVS 1.1 from 1 Apr 2006? If not, back off and start over. If you did, take a look at the /admin/vendors.php fix on the MVS distribution page. If you're still having problems, try searching the MVS forum thread for "Vendors Products Report". Regards Jim Thanks for the response, Yes i did use the mvs from 1 april 2006, and yes I did replace the /admin/vendors.php fix from the MVS distribution page. The strange thing is that it is happening on both a heavenly modified install an d a brand new sqeaky clean install of OsCommerce. Regards, Marja Quote Link to comment Share on other sites More sharing options...
♥kymation Posted November 13, 2008 Share Posted November 13, 2008 I seem to remeber a patch for this problem, and I thought it was in one of the patch files on the distribution page. I could be wrong about that; it may have only been posted in the MVS thread. A search through that thread should pick up the discussion of the fix at least. Regards Jim Quote See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
zdavatz Posted November 27, 2008 Share Posted November 27, 2008 I am having the same problem here as well! No Vendor Reports. I also can not find anything in the forum. Best Zeno Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.