Jin Kazuya
Archived-
Posts
12 -
Joined
-
Last visited
About Jin Kazuya
- Birthday 08/24/1960
Profile Information
-
Real Name
Steve Hanson
- Website
Jin Kazuya's Achievements
-
[Contribution] QTpro - Quantity Tracking Professional
Jin Kazuya replied to zonetown's topic in General Add-Ons Support
Sorry, but cut and paste... Please read : line 23 : tep_db_query("delete from " . TABLE_PRODUCTS_STOCK . " where products_stock_attributes = '" . (int)$options_id" . "-" . (int)$values_id . "'"); instead of line 23 : tep_db_query("delete from " . TABLE_PRODUCTS_STOCK . " where products_stock_attributes = '" . (int)$options_id . "', options_values_id = '" . (int)$values_id . "'"); -
[Contribution] QTpro - Quantity Tracking Professional
Jin Kazuya replied to zonetown's topic in General Add-Ons Support
:lol: :lol: :'( I am not bad in logical search, but really newbies in coding... The solution should be in product_attribute.php, case : delete attribute : [...] anymore [...] line 10 : case 'delete_attribute': line 20 : $attribute_id = tep_db_prepare_input($HTTP_GET_VARS['attribute_id']); line 30 : tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_attributes_id = '" . (int)$attribute_id . "'"); line 40 : // added for DOWNLOAD_ENABLED. Always try to remove attributes, even if downloads are no longer enabled line 50 : tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . (int)$attribute_id . "'"); line 60 : tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); line 70 : break; [...] anymore [...] When you delete an attribute (line 30) you must before delete this attribute in product_stock table. But product_stock table do not have an array attribute_id... BUT, there is an array product_stock_attributes who is make of : options_id . "-" . option_values_id from the product_attributes table. Normaly, a simply adding like : line 21 : $options_id = tep_db_prepare_input($HTTP_POST_VARS['options_id']); line 22 : $values_id = tep_db_prepare_input($HTTP_POST_VARS['values_id']); line 23 : tep_db_query("delete from " . TABLE_PRODUCTS_STOCK . " where products_stock_attributes = '" . (int)$options_id . "', options_values_id = '" . (int)$values_id . "'"); would be fine, but $options_id and $values_id are always empty... I really don't kwon why, because there is no problem with $attribute_id, and everything is similar... I will try do some select before, assembling this select, etc, etc... Anyway, as soon I find something clean and really fonctional, I update the contribution. If someone find the SQL solution before me, just update the contribution... -
[Contribution] QTpro - Quantity Tracking Professional
Jin Kazuya replied to zonetown's topic in General Add-Ons Support
Exactly same problem that Alley Kat in deleting case !! Have you fix it ? That seem it is a bug, author had forget to delete value product_stock in product_attribute.php for the 3 cases : delete options, attibute or value. -
I have got the same problem : No PayPal Transaction Information Available (a4be0f262d47444e165f641e637ee7a5) in every case. But the problem is that my primary paypal adress, my sandbox primary adress, my paypal adresses configuration (E-Mail Address, Business ID, Debug Email Notification Address) are ALL PRIMARY and the same... Check modification and replace twice with winmerge : everything ok. charset set is enabled. Everything seem correct, so I really need help at this time... Thank a lot.
-
Je parle mieux en français si tu préfères... Si quieres puedo hablar Castellano... If you are looking for something like we see at the bottom at this page http://jinkazuya.creezvotreboutique.com/in...php?cPath=21_22 use the following : <div style="OVERFLOW: auto; WIDTH: 575px; HEIGHT: 207px"> Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! Here your text ! </div> Of course, customize WIDTH and HEIGHT at your resquest.
-
[Contribution] Show Sub-categories
Jin Kazuya replied to Andrew J's topic in General Add-Ons Support
And now, if you click a product without pass by categories searching (click on special or new for this month or also purchached...) it corresponding catégoris and sub, and subsub etc... is automatily highlighted. -
Your solution is here : http://www.richinstyle.com/test/dynamic/overflowscroll.html
-
[Contribution] Show Sub-categories
Jin Kazuya replied to Andrew J's topic in General Add-Ons Support
Hi ! :lol: I 'm using this contribution and I have make a modification for using 3 levels (Catégorie, Sub-Catégorie and SubSubcatégorie ). :thumbsup: Do you think it is obsolete to update the contribution for this ? If someone want my code, I think we can use an infinite level possibilities :thumbsup: :lol: by using a while loop and array vars instead of solid vars like I have do. <_< Let me know... :-" -
Note :The bug is only in "install.txt" NOT in "instalacion.txt"
-
FIXED ! The problem come from the contribution !! Please correct contribution in install.txt : * * 6.1. Open File and Find: * <!-- new_products //--> * * ADD AFTER: * <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <?php $titulo = sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')); echo mws_header_main($titulo); ?> <td> * * INCLUDE FIX: fix to display the month in the title of module. Fix by OSdave * (http://oscommerce.qadram.com/modules.php?name=Forums&file=profile&mode=viewprofile&u=5673) * * * 6.2. FIND: * <!-- new_products_eof //--> * * ADD BEFORE: * </td> <?php echo mws_footer(''); ?> </tr> </table> Correct : <?php echo mws_footer(''); ?> by <?php echo mws_footer_main(''); ?>
-
Hi All. Here a new bug with with contribution. Of course, there is 99,9% chance the problem come from me, but because I have install 3 times the contribution, check it 8 times manually et 14 times automaticaly (winmerge, notepad++...) And I have always the same problème, I really need help. This is not a problem for using OSCommerce, this is question of honor after this time. Well, Let see : I have border problem... Of course, modification #7 and any other are done. Normaly, the great border use infobox folder pictures and the border "new for the month" use infobox_main folder. The contribution say : infobox for box and infox_main for the center boxes. After playing this color the problem is that : _ the rigth internal border use "right.gif" from infobox folder instead of "right.gif" of infobox_main _ The left bottom internal border use "lower_left.gif" from infobox folder instead of "lower_left.gif" of infobox_main CSS is OK, Code is OK, gif are OK... If it was all a borders (internal) or all similars names or sides, I can unterstand but There is no logic at all here in the bug !!! One corner on a side and one side on other side out ? I really need help, just to unterstand... Sorry for my english. Thank you to Nicko of course et every body who make this forum the more helpful side.