Jump to content

Catman

Members
  • Content count

    22
  • Joined

  • Last visited

1 Follower

About Catman

  • Birthday 02/19/1965

Profile Information

  1. Catman

    UPS Module

    I have looked everywhere, but no luck finding. Is there a UPS module for the new version 3.0? I understand OSC 3.0 is still Alpha, but I thought I'd ask anyway... Thanks!!!
  2. Catman

    New task for order editor

    I am just a little confused. What is the latest version? I download the 5 Jan 2005 - Order Editor 1.6a and thought I'd ask if there is a newer version with some bug fixes. Everything seems to work fine, but I haven't had the chance to test as everyone else has. Thanks for any help I can get... Great add-on!!! Kelly
  3. Catman

    Cancelled Orders Contribution Support

    I am not sure if anyone has found the problem, but I fell upon this request today and hope my assistance isn't too late. I think this is a simple fix or it was in my case. All you need to do is make sure your fields in the "orders" table match the fields in the "cancelled_orders" table. Maybe look at each table and compare, if you see any differences, change the "cancelled_orders" table to match. Remember to back up first!!!!
  4. First off I need to say that Quick Price Updates is a great contribution and it has saved me many hours of updating. I would just like to add one thing to the list of options. I need to update the "Date Available" and am stuck with the code. I am hoping that someone other than I thinks this is a great idea and could assist in the problem. So far everything works great, but I can't get it to update my new date. What I get is if there is anything in the date available field ie. 0000-00-00 00:00:00, it will count this and update ie. "8 Item(s) Updated! 8 Value(s) changed". But it remains the same ie. "0000-00-00 00:00:00", even if I make a change like "2004-12-31" and it remains as "0000-00-00 00:00:00". I am sure I am only missing one thing, but I can't seem to locate the problem. Please ask any questions, if I have left something out. Thank you in advance for any assistance that anyone can provide. Here is what I have done so far with the admin/quick_updates.php. I have also made one or two additions in the language file, but I want go there at this time; I think it is working as expected. Around line 106 I added: if($HTTP_POST_VARS['product_new_date_available']){ foreach($HTTP_POST_VARS['product_new_date_available'] as $id => $new_date_available) { if ($HTTP_POST_VARS['product_new_date_available'][$id] != $HTTP_POST_VARS['product_old_date_available'][$id]) { $count_update++; $item_updated[$id] = 'updated'; mysql_query("UPDATE " . TABLE_PRODUCTS . " SET products_date_available=$new_date_available WHERE products_id=$id"); } } } Around line 391 I added: </td> <td class="dataTableHeadingContent" align="left" valign="middle"> <table border="0" cellspacing="0" cellpadding="0"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" align="left" valign="middle"> <?php if(DISPLAY_DATE_AVAILABLE == 'true')echo " <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_date_available ASC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_up.gif', TEXT_SORT_ALL . TABLE_HEADING_IMAGE . ' ' . TEXT_ASCENDINGLY)."</a> <a href=\"" . tep_href_link( FILENAME_QUICK_UPDATES, 'cPath='. $current_category_id .'&sort_by=p.products_date_available DESC&page=' . $page.'&row_by_page=' . $row_by_page . '&manufacturer=' . $manufacturer)."\" >".tep_image(DIR_WS_IMAGES . 'icon_down.gif', TEXT_SORT_ALL . TABLE_HEADING_IMAGE . ' ' . TEXT_DESCENDINGLY)."</a> <br>" . TABLE_HEADING_DATE_AVAILABLE . "</td>"; ?> </tr> </table> Around line 450 I update this code: //// select categories if ($current_category_id == 0){ if($manufacturer){ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '$languages_id' $sort_by "; } } else { if($manufacturer){ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by "; } } To this: //// select categories if ($current_category_id == 0){ if($manufacturer){ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.products_date_available, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.products_date_available, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '$languages_id' $sort_by "; } } else { if($manufacturer){ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.products_date_available, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.products_date_available, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by "; } } Around line 511 I added: if(DISPLAY_DATE_AVAILABLE == 'true')echo "<td class=\"smallText\" align=\"left\"><input type=\"DATE\" size=\"18\" name=\"product_new_date_available[".$products['products_id']."]\" value=\"".$products['products_date_available']."\"></td>\n";else echo "<td class=\"smallText\" align=\"center\"></td>"; Around line 537 I added: if(MODIFY_DATE_AVAILABLE == 'true') echo tep_draw_hidden_field('product_old_date_available['.$products['products_id'].']',$products['products_date_available']); I also added in my Database - Table configuration $sql = 'INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) ' . 'VALUES ( \'1019\', \'Display the date available.\', \'DISPLAY_DATE_AVAILABLE\', \'true\', \'Do you want just display the date available ?\', \'300\', \'8\', \'2004-09-30 18:49:30\', \'2003-06-04 05:17:05\', NULL , \'tep_cfg_select_option(array(\\\'true\\\', \\\'false\\\'),\' );' . '';
  5. Catman

    [Contribution] Ship In Cart

    Can anyone please help with some updates for a great and needed contibution? I got the Shipping Estimate contribution to work for users not logged on. :D But :( Now the shipping cost seems to calculate from my zip-code and this is ok I guess if you just want to estimate. When I add the country, zip and update button I can't get it to recalculate. What I do get is: Query was empty - Query was empty Query was empty [TEP STOP] If I just add zip-code and update buttom the screen just will refresh on click, but no updated shipping cost. Thanks for any help that you have to offer. Kelly
  6. Catman

    [Contribution] Ship In Cart

    I am in search for the same as David. Can anyone help.
  7. Catman

    Cancelled Orders Contribution Support

    OK!!! I figured it out!!!! Someone kick me!!!! :ph34r: I forgot I deleted a column ID the other day. :lol: FYI: for those trying to find the same answer I bet if you check the two Column Header IDs you will see that they do not match. Have a great day all!!!! B)
  8. Catman

    Cancelled Orders Contribution Support

    Great contribution. Worked great until today. Can someone please help point me into the right direction or help me figure out what this error is trying to tell me? 1136 - Column count doesn't match value count at row 1 insert into cancelled_orders select * from orders where orders_id = '442' [TEP STOP] I have looked at the two tables and everything looks to be the same. Thanks for any help you have to offer. Kelly
  9. Catman

    Poll problem

    Found the problem... http://forums.oscommerce.com/index.php?sho...ic=43568&st=100
  10. Catman

    Poll problem

    I have the same problem. Have you or anyone else found a fix.
  11. Well, If I had only looked at this I wouldn't have asked the other queston. It works!!! Thanks
  12. Great Mod!!! :D Just installed and it works great...Well almost. :( I am also using visitors_v1.6a... Is this why I get the below error? I have User Tracking with Admin 1.35 and am wondering if anyone has gotten this same error. Is there a fix? Thanks for the help in advance.
×