he1ix' blog

currently just the commands:

SELECT id,name FROM projects;
SELECT * FROM wikis;
SELECT * FROM wiki_pages limit 10;
SELECT * FROM wiki_pages WHERE wiki_id = '1' AND title = 'Howtos';
SELECT * FROM wiki_pages WHERE parent_id = '34';
SELECT * FROM wiki_pages WHERE parent_id in (SELECT id FROM wiki_pages WHERE parent_id = '34');
UPDATE wiki_pages SET wiki_id = '12' WHERE wiki_id = '1' AND title = 'Howtos';
UPDATE wiki_pages SET wiki_id = '12' WHERE parent_id = '34';
-- UPDATE wiki_pages SET wiki_id = '12' WHERE parent_id in (SELECT id FROM wiki_pages WHERE parent_id = '34');
UPDATE wiki_pages SET wiki_id = '12' WHERE parent_id = '35';
UPDATE wiki_pages SET wiki_id = '12' WHERE parent_id = '87';

if you happen to use the NoScript addon for Firefox or sth. similar, sueddeutsche.de has a great new feature since the last design update: they pester you with an annoying panel covering (and hiding!) the rear part of the main headline…

to fight this obtrusive usage of jscript (the panel gets hidden if you enable jscript), use Firefox’ ability to include custom CSS:

echo '#weiterepanel { display: none; }' >> ~/.mozilla/firefox/*.default/chrome/userContent.css

finally, restart Firefox.
(yes, restart. see Bug 208641 for details.)

my way to conveniently convert an MPEG “Transport Stream” (TS) to a DVD:

1. open the TS-file with avidemux
2. choose “yes” to index the MPEG
3. select “Auto” -> “Optical Disc” -> “DVD”
4. click “save” to demux the MPEG-TS into an MPEG-PS

1. open “DVDStyler”
2. select “MP2” as audio format in the project wizard
3. add the new MPEG file
4. hit “burn”

done. demuxing and creating the iso takes usually less than 15 minutes.