IOS 10 Video not playing with PHP streaming

IOS 10 came with a bug that hinders AppleCoreMedia to read session cookies. Because of that, any video that needs to be streamed through PHP won’t load on iPads and iPhones running IOS 10.

Untill we get a fix from apple, you can fix it by putting following header (PHP) in case your script detects an unauthorized access:

header('HTTP/1.0 403 Forbidden');

Delete test orders in Magento 1.4.x

hay Friends,

Many of you must have noticed that Magento has brought much changes in it’s EAV based database structure in version Magento 1.4.x. Like they did for changes in order data storage, perhaps this decision is to reduce the over complex structrue.

When we are developing some Magento based project, we oftenly try to add test data to check whether everything is fine or not. Though we can delete this test data using delte option but if you added some test order then you are stucked as Magento don’t give any option to delete a record from Magento prompt. So solution in such cases is to go at database prompt and run queries to reset Magento. Following are few queries for the same purpose:

– Reset Magento TEST Data
SET FOREIGN_KEY_CHECKS=0;

– Reset dashboard search queries
TRUNCATE `catalogsearch_query`;
ALTER TABLE `catalogsearch_query` AUTO_INCREMENT=1;

– Reset sales order info
TRUNCATE `sales_flat_creditmemo`;
TRUNCATE `sales_flat_creditmemo_comment`;
TRUNCATE `sales_flat_creditmemo_grid`;
TRUNCATE `sales_flat_creditmemo_item`;
TRUNCATE `sales_flat_invoice`;
TRUNCATE `sales_flat_invoice_comment`;
TRUNCATE `sales_flat_invoice_grid`;
TRUNCATE `sales_flat_invoice_item`;
TRUNCATE `sales_flat_order`;
TRUNCATE `sales_flat_order_address`;
TRUNCATE `sales_flat_order_grid`;
TRUNCATE `sales_flat_order_item`;
TRUNCATE `sales_flat_order_payment`;
TRUNCATE `sales_flat_order_status_history`;
TRUNCATE `sales_flat_quote`;
TRUNCATE `sales_flat_quote_address`;
TRUNCATE `sales_flat_quote_address_item`;
TRUNCATE `sales_flat_quote_item`;
TRUNCATE `sales_flat_quote_item_option`;
TRUNCATE `sales_flat_quote_payment`;
TRUNCATE `sales_flat_quote_shipping_rate`;
TRUNCATE `sales_flat_shipment`;
TRUNCATE `sales_flat_shipment_comment`;
TRUNCATE `sales_flat_shipment_grid`;
TRUNCATE `sales_flat_shipment_item`;
TRUNCATE `sales_flat_shipment_track`;
TRUNCATE `sales_invoiced_aggregated`;
TRUNCATE `sales_invoiced_aggregated_order`;
TRUNCATE `sales_order_aggregated_created`;
TRUNCATE `sendfriend_log`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `wishlist`;
TRUNCATE `log_quote`;
TRUNCATE `report_event`;
ALTER TABLE `sales_flat_creditmemo` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_track` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_aggregated_created` AUTO_INCREMENT=1;
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;
ALTER TABLE `tag` AUTO_INCREMENT=1;
ALTER TABLE `tag_relation` AUTO_INCREMENT=1;
ALTER TABLE `tag_summary` AUTO_INCREMENT=1;
ALTER TABLE `wishlist` AUTO_INCREMENT=1;
ALTER TABLE `log_quote` AUTO_INCREMENT=1;
ALTER TABLE `report_event` AUTO_INCREMENT=1;
SET FOREIGN_KEY_CHECKS=1;

Hope this information was helping!

Magento :: get URL paths for skin, media, Js OR base URL

hello friends,

If anyone of you facing problems to fetch the Magento URL paths of  skin, media, Js or simple base URL of Magento while customization/programming, then following lines should be helpful for you:

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_JS);
//http://magento.demo/js/

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_LINK);
//http://magento.demo/index.php/

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_MEDIA);
//http://magento.demo/media/

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_SKIN);
//http://magento.demo/skin/

Mage::getBaseUrl(Mage_Core_Model_Store::URL_TYPE_WEB);
//http://magento.demo/

Enjoy!

Magento :: add or remove javascript files to your template

Following  lines will be helping for you if you’r trying to add some javascript file to your custom theme. As per your requirements, you’ll need to see in which layout file you want to call your js file and simply put this line there:
<action method=”addItem”><type>skin_js</type><name>js/product.js</name></action>

Above line will try to find the product.js file under /skin/frontend/default/Your_Theme/js /product.js

Similarly you can remove a default javascript file by putting this line in your layout file:

<action method=”removeItem”>   <type>js</type>   <name>varien/product.js</name>   <params />   </action>

Hope this will be helping someone for fighting against Magento.

J2T Points & Rewards :: Step by step configurations

hello,

“J2T Points & Rewards” is a big and FREe extension for Magento based e-commerce stores where Discounts are rewarded to customers on the basis of amount that they spent to buy from the store. In short, this is a Points and Reward system for a magento based store.

I really faced hard time to see some step by step manual to configure this extension but got no luck. Eventually i was able to configure it successfully with the help of some community mates (thanks to them) so thought to share. Here it is:

Step1: Disable your Cache.
Step2: Make sure you have copied the template and layout files of this extension under the active template of store.

Step3: Go in Reward points > Configurations and make following settings (you may set it according to your business logic too):
money to obtain: 1
points to obtain 1: 100
apply points by step: no
leave step value blank
use max points: no
round up points: no
coupon code restriction: yes
apply store scope: yes

Step4: Go Promotions –> Shopping cart price rules and add a shopping cart price rule with following settings:
rule name: points
customer group: general
coupon code: points
under action tab have the “fixed amount discount for entire cart”

Step4: Go catalog –> attributes –> manage attribute
create ‘reward_points’
scope: global
apply to: all product types
Use for Price Rule Conditions: yes
Allow HTML-tags on Front-end: yes

That’s it! After these settings are done, you’ll be able to see these effects:

— Reward points section is being shown in Customer Account area.
— Logged in User is given an option to redeem the points on shopping cart page.
— discount is applied on shopping cart

Hope it will be helping for someone.