Jump to content

sonixtwo

Members
  • Content count

    42
  • Joined

  • Last visited

  1. sonixtwo

    need help with easy populate

    Easy Populate is actually one of the easier contributions to install. What problems are you having? If you are having a hard time figuring out which one to use, I suggest surfalot's with the date of March 18.
  2. sonixtwo

    Product entry addon

    The Easy Populate contribution lets you add products from a spreadsheet. http://addons.oscommerce.com/info/500
  3. sonixtwo

    Attribute Sort Order V1.7

    Your SQL table looks fine. Chances are you didn't make all the necessary changes to catalog/admin/products_attributes.php Around line 128 should be: tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set products_id = '" . (int)$products_id . "', options_id = '" . (int)$options_id . "', options_values_id = '" . (int)$values_id . "', options_values_price = '" . (float)tep_db_input($value_price) . "', price_prefix = '" . tep_db_input($price_prefix) . "', attribute_sort = '" . (int)$attributes_sort . "' where products_attributes_id = '" . (int)$attribute_id . "'"); I've got a feeling it's not...
  4. I have tried grouping parenthesis a number of different ways, but cannot get this statement in the correct format. Can anyone offer any idea of how to correct it? Thanks
  5. I know that parenthesis are required in order to prioritize the joins correctly in mySQL5. Can someone please correct these to be compatible with mySQL5? The original link for the contribution is at http://addons.oscommerce.com/info/5014 Thanks $rating_query = tep_db_query("select p.products_id, pd.products_name, p.products_image, p.products_model, p.products_tax_class_id, p.products_price, s.specials_new_products_price, r.* from " . TABLE_PRODUCTS . " p inner join " . TABLE_SPECIALS . " s on p.products_id = s.products_id right join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id inner join rating r on p.products_id = r.id where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' ORDER BY average DESC LIMIT 0, 10"); $rating_query = tep_db_query("select p.products_id, p.products_image, p.products_model, p.products_tax_class_id, p.products_price, s.specials_new_products_price, r.* from " . TABLE_PRODUCTS . " p inner join " . TABLE_SPECIALS . " s on p.products_id = s.products_id right join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id join rating r on p.products_id = r.id, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' ORDER BY average DESC LIMIT 0, 10");
  6. sonixtwo

    What happened to ajax vote system?

    I am having the same problem. I am using php 4.4 and mysql 5.0. It has to do with the following lines not being compatible with mysql 5.0 $rating_query = tep_db_query("select p.products_id, pd.products_name, p.products_image, p.products_model, p.products_tax_class_id, p.products_price, s.specials_new_products_price, r.* from " . TABLE_PRODUCTS . " p inner join " . TABLE_SPECIALS . " s on p.products_id = s.products_id right join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id inner join rating r on p.products_id = r.id where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' ORDER BY average DESC LIMIT 0, 10"); $rating_query = tep_db_query("select p.products_id, p.products_image, p.products_model, p.products_tax_class_id, p.products_price, s.specials_new_products_price, r.* from " . TABLE_PRODUCTS . " p inner join " . TABLE_SPECIALS . " s on p.products_id = s.products_id right join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id join rating r on p.products_id = r.id, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' ORDER BY average DESC LIMIT 0, 10"); I believe the new mysql syntax requires parenthesis to handle the joins correctly, but where they go, I do not know. If someone could post fixes for those 2 lines, it would be greatly appreciated. Thanks
  7. sonixtwo

    Contribution Tracker

    I do not have fopen enable, but curl is. When loading up the admin, I get the 'could not open XML input' error. The rsscache directory has the correct permissions, and the paths in configure.php are all correct. I am using version 1.6.6b of the contribution. Does anything special need to be done for curl to work? Thanks
  8. sonixtwo

    ### POINTS AND REWARDS MODULE V1.00 ###

    Just a quick update, Points & Rewards 2.0 passes the correct total to Paypal when using the Paypal Payments Standard module in 2.2rc2a. It doesn't require any additional modifications. -Mike
  9. sonixtwo

    ### POINTS AND REWARDS MODULE V1.00 ###

    It turns out I had a register_globals issue. I turned it on and everything was fine. Points & Rewards 2.0d works perfectly with 2.2rc2a. -Mike
  10. sonixtwo

    ### POINTS AND REWARDS MODULE V1.00 ###

    Has anyone had tried using this contribution with 2.2rc2a? Everything seems fine until you get past the payment information screen. The order total does not reflect the discount on checkout_confirmation.php. Thanks -Mike
  11. Try copying the image source in the address bar and seeing what happens, (http://www.server.com/catalog/product_thumb.php?img=images/sub/pretty_pic.jpg&w=95&h=100 for example). If the image doesn't show up, you can use firefox with the firebug extension to view the errors that the script is generating. In my case, I upgraded the contribution, and it was trying to recreate the thumbnails that already were created with an earlier version. I deleted the thumbnails and it works fine now. -Mike
  12. sonixtwo

    [Contribution] Adding new fields to Easy Populate

    I have a number of new fields added using this method. What I would like to do now is add a drop down menu in the product listing, like the manufacturer drop down, to filter based on the value of the fields. Has anyone tried to do this before? I was hoping to modify the Sort Products By Dropdown contribution (http://www.oscommerce.com/community/contributions,4312) somehow. If anyone has any input, it would be appreciated. Thanks -Mike
  13. sonixtwo

    Information Pages Unlimited v1.0

    to remove the sql databases, use the following 2 commands DROP TABLE IF EXISTS `information`; DROP TABLE IF EXISTS `information_group`;
  14. sonixtwo

    Information Pages Unlimited v1.0

    I am using Information Pages Unlimited v2.03 with Ultimate SEO URLs - 2.1d. When I upgraded from Info Pages 1.3 to 2.0, it broke the urls for information.php. They all show up as /catalog/-i-1.html?osCsid=df.... The entry in .htaccess is RewriteRule ^(.*)-i-([0-9]+).html$ information.php?info_id=$2&%{QUERY_STRING} does anyone know how to correct the urls? I also have Sitemap 2.2 installed and <?php echo $sitemapString; ?> doesn't work as well as it used to. All the entries are up one level on the list. I can probably fix this one pretty easily when I sit down and take a look at that function. Any help on the seo url would be appreciated. Thanks -Mike
  15. sonixtwo

    Contribution Tracker

    I found some info here: http://www.kofler.cc/forum/forumthread.php?rootID=3184 Using the str_replace function (http://us3.php.net/str_replace), i changed line 63 in admin/contrib_tracker.php to tep_db_query("UPDATE " . TABLE_CONTRIB_TRACKER . " SET status ='0', contr_last_modified = '" . $pubtimestamp . "' , date_status_change = now() where contrib_name = '" . str_replace("'","\'", $thetitle) . "' and last_update < '" . $pubtimestamp . "'"); It just replaces ' with \' in the contribution title. The problem I could forsee would be any contributions that have " in their name won't be entered correctly. It seems to work, but t would be great if someone that actually knows php could verify this is ok. Thanks -Mike
×