So I had a text file for channels with over 400 entries, many I new were unrelated to my interests.
I could have manually removed any channels I did not like but then what about when I refreshed the data?
No I needed to keep all the channels and mark which ones were interesting.
First time; import all the channels into the database, then unselect the ones I was not interested in.
All further imports; import into channels into a comparison table, figure out any new or deleted channels then add/delete new/obsolete channels.
I then topped and tailed the c.html file to include a FORM BODY HTML tags.
Ran it in a browser and had a looong list of checkbox and channel names.
What I knew from the Computer-O quiz was that submitting the form using the GET method would put all the form data (i.e. selected channels) in the query string.
Where QUERYSTRING is the query string from submitting my form to itself.
This sets the selected flag for included values and clears it (second command) where the are not included.
I love bash and sqlite scripting !
I have a number of projects on the go at any one time and some seem to have been going on forever. One such project involves DVDs and when running the carefully considered memcoder command line X crashed.
X crashing is not a common occurrence and as I just wanted to be up and running email etc I forgot the issue and moved on. Then a few days later tried the same thing and it crashed X again, no obvious log messages, again forgot about it then the other day I tried to use Xine to watch a DVD and ... yep crashed again.
This time I decided to look into the problem a bit more deeply. It was my own fault for not updating the linux kernel and the video drivers. So I rebuilt the kernel using .config and meld, surprisingly no issues and rebooted and started X.
Something was wrong. The XFCE desktop seemed to be there(the panels were appearing) and my last running apps were loading but none of them had any window decoration, so no close/minimise etc. The mouse would not click on things and had the classic monochrome cursor.
Then everything worked flawlessly again!