Jump to content

webmasterpitoyo

Members
  • Content count

    30
  • Joined

  • Last visited

2 Followers

About webmasterpitoyo

  • Rank
    Pitoyo

Profile Information

  1. webmasterpitoyo

    [Contribution] Option Types v2

    Helo @@Tsimi kindly ask your opinion.. is this addon somehow can work together with the modular product page addon http://addons.oscommerce.com/info/9453 ? or is it too long way to go? rgds, pit
  2. @@Tsimi oh OK... I saw that at the expires_date row... Null column is set to Yes I think its OK then thanks, rgds pit
  3. @@Tsimi actually I dont really understand what your question mean .. this attached I show you the dump sgl file for featured table.. -- phpMyAdmin SQL Dump -- version 4.0.10.14 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Jul 13, 2016 at 09:32 PM -- Server version: 5.6.30 -- PHP Version: 5.4.31 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; CREATE TABLE IF NOT EXISTS `featured` ( `featured_id` int(11) NOT NULL AUTO_INCREMENT, `products_id` int(11) NOT NULL DEFAULT '0', `featured_date_added` datetime DEFAULT NULL, `featured_last_modified` datetime DEFAULT NULL, `expires_date` datetime DEFAULT NULL, `date_status_change` datetime DEFAULT NULL, `status` int(1) DEFAULT '1', PRIMARY KEY (`featured_id`), KEY `idx_products_id` (`products_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ; INSERT INTO `featured` (`featured_id`, `products_id`, `featured_date_added`, `featured_last_modified`, `expires_date`, `date_status_change`, `status`) VALUES (9, 51, '2016-07-13 14:37:16', '2016-07-13 21:13:01', NULL, NULL, 1), (10, 54, '2016-07-13 16:52:11', NULL, NULL, NULL, 1), (11, 61, '2016-07-13 21:12:51', NULL, NULL, NULL, 1); rgds, pit
  4. I check the database for last success simulaton resulting NULL in field expres_date
  5. Dear @@Tsimi I tried your suggestion above changing line 36 and 53.. but both not work.. still error coming whether it is a new featured product or updating the expiry date.. I just try my way (only I dont now if this changing is a good solution or not), with: on line 42 tep_db_query("insert into featured (products_id, featured_date_added, expires_date, status) values ('" . $_POST['products_id'] . "', now(), '" . $expires_date . "', '1')"); change with tep_db_query("insert into featured (products_id, featured_date_added, expires_date, status) values ('" . $_POST['products_id'] . "', now(), " . (tep_not_null($expires_date) ? "'" . tep_db_input($expires_date) . "'" : 'null') . ", '1')"); and for updating on line 54 tep_db_query("update featured set featured_last_modified = now(), expires_date = '" . $expires_date . "' where featured_id = '" . $_POST['featured_id'] . "'"); change with tep_db_query("update featured set featured_last_modified = now(), expires_date = " . (tep_not_null($expires_date) ? "'" . tep_db_input($expires_date) . "'" : 'null') . " where featured_id = '" . $_POST['featured_id'] . "'"); with this changing.. I try to simulate for a new featured product or an updating with an empty expiry date, both is working fine.. pls comment for this, thanks, rgds, pit
  6. sorry.. I am not try yet this change.. I have something to do first.. back maybe in some hours.. rgds, pit
  7. dear @@Tsimi yes! for a new featured product.. this solution is solve.. but I try for an updating one featured product and revise expiry date with an empty fill, there is an error: ---- 1292 - Incorrect datetime value: '' for column 'expires_date' at row 1 update featured set featured_last_modified = now(), expires_date = '' where featured_id = '9' [TEP STOP] ------ thanks, rgds, pit
  8. dear @@Tsimi Im sorry maybe Im still in 'elementery school' for this php things :) , but I just comparing the file between catalog/admin/featured.php (from this add on) and catalog/admin/specials.php (from native osc2.3.4 BS edge).. there is a different script for handling inserting value to the db table for expiry date (I put it on bold): in featured.php: tep_db_query("insert into featured (products_id, featured_date_added, expires_date, status) values ('" . $_POST['products_id'] . "', now(), '" . $expires_date . "', '1')"); in specials.php: tep_db_query("insert into " . TABLE_SPECIALS . " (products_id, specials_new_products_price, specials_date_added, expires_date, status) values ('" . (int)$products_id . "', '" . tep_db_input($specials_price) . "', now(), " . (tep_not_null($expires_date) ? "'" . tep_db_input($expires_date) . "'" : 'null') . ", '1')"); does it have any correlation with the error I get? kindly advise, thanks, rgds, pit
  9. @@Tsimi .. tx for the info.. I try to uninstall v1.1 and install the new v1.2... still everythin ok when I put some expiry date for assign featured product.. but when I leave it empty still the error message coming... maybe its not about this addon.. still try to figure it out.. maybe conflicting with other addon.. anyway, thanks for your kind support.. rgds, pit
  10. @@Tsimi , tx for the respons If I leave the expiry date empty, then the whole admin page become blank and get the error: --------------- 1292 - Incorrect datetime value: '' for column 'expires_date' at row 1 insert into featured (products_id, featured_date_added, expires_date, status) values ('39', now(), '', '1') [TEP STOP] ------------------ I use the OSC 2.3.4 BS Edge download at jun 2016. thanks, rgds, pit
  11. hello @@Tsimi what am I supposed to fill in Expiry date for Featured Product if I want to make some product will featured forever. I try to put it blank like we use to do in special product but some error message coming.. rgds, pit
  12. webmasterpitoyo

    [Addon] Modular Product Page (Bootstrap)

    thanks Jim, I just try this addon also at the GOLD version, but the same thing happen... product title not showing at the browser tag, and also I just found out that the product name also not shows at the breadcrumb trail regards, pit
  13. webmasterpitoyo

    [Addon] Modular Product Page (Bootstrap)

    the special price seems OK using @@katapofatico 's suggestion at the first place .. thanks.. one thing that still missing is the product tittle.. seems like these module make the Product Tittle module on header tags does not works... so when I show product page we cannot see product name on a tittle at a browser tag Is there any solution for this? rgds pit
  14. helo @@auzStar, Im installing this addon v1.1.. only if the product has a special price,.. it is only shows the new price... I think put the original price with strikethrough above new price like it used to be is more attractive for costumer. rgds, pit
  15. webmasterpitoyo

    [Addon] Modular Product Page (Bootstrap)

    Dear @@kymation @@katapofatico just asking is there any fix solution about special price bug above? I just installed this addon ver1.1 but resulting 0,- price for a product with a specials price thanks, rgds. pit
×