Silverstripe - Interesting Stuff

Silverstripe - Interesting Stuff

click here for the original website

Magento - sorting of the Layered JavaScript top.html menum, Alpha Sorting

Magento - sorting of the Layered JavaScript top.html menu
click here for the original website


Alpha Sorting

SET @i=0;

SET @j=0;

DROP TABLE IF EXISTS AAA_NEW_POSITION;

CREATE TABLE AAA_NEW_POSITION

SELECT e.entity_id AS 'entity_id',

vn.value AS 'name',

e.position AS 'old_position', @i:=@i+1 AS 'new_position'

FROM

catalog_category_entity e

LEFT JOIN catalog_category_entity_varchar vn

ON e.entity_id = vn.entity_id AND

vn.attribute_id = 33

ORDER BY vn.value;

ALTER TABLE AAA_NEW_POSITION ORDER BY name;

UPDATE AAA_NEW_POSITION SET new_position= @j:=@j+1 ORDER BY name;

UPDATE

catalog_category_entity e

LEFT JOIN AAA_NEW_POSITION np

ON e.entity_id = np.entity_id

SET

e.position = np.new_position;

DROP TABLE IF EXISTS AAA_NEW_POSITION;

Silverstripe - Activating Widgets

Silverstripe - Activating Widgets

click here for the original website

Magento - Layout Files, References, Elements, Attributes and XML

Magento - Layout Files, References, Elements, Attributes and XML

click here for the original website

Silverstripe - Swap Menu Order

Silverstripe - Swap Menu Order

click here for the original website

How to print the files in a directory

How to print the files in a directory

click here for the original website

@fontface fontkit generator

http://www.fontsquirrel.com/fontface/generator

Css Stuff

looky here!!

Magento - How to remove 'Orders and Returns' from the footer?

Magento - How to remove 'Orders and Returns' from the footer?

click here for the original website

Silverstripe - Customise TinyMCE

Silverstripe - Customise TinyMCE

click here for a list of buttons
click here for information of how to insert the syntax
click here for the initial post that led me to these above answers