Thursday 20 October 2011

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;

Tuesday 4 October 2011

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