tdsskiller Is your website browsing hijacked/redirected?

short answer: tdsskiller You've tried Malwarebytes, and your antivirus and it says you're clean, but it's obvious you're not, as every time you try to use windows update or try to go to a Microsoft site, you get redirected to another search engine.

http://support.kaspersky.com/faq/?qid=208283363

OpenOffice Base MySQL ALTER table structure

I may have missed it, but it's likely that you will have trouble refreshing table structure in OpenOffice Base if you connect to MySQL and ALTER a table.

Basically, the answer is to add the fields in the Edit of the table(s) in Base to match the new columns. If you don't know what they are, create a new table connecting to the ODBC of MySQL and edit the appropriate table.

It's a real pain, but there you are.

YUI3 accordion

I had the hardest time trying to override the label color in YUI3-accordion.
It turns out that !important was used in the default style, so I had to !important again to overwrite it. (I didn't want/need black on a dark background).

Increase the number of entries in Media Library of Wordpress

Have lots of images? Don't want to paginate? Using Faster Image Inserter?

Change from 10 to whatever:

back up wp-admin/includes/media.php

find this:

$start = ( $_GET['paged'] - 1 ) * 10;
if ( $start < 1 )
$start = 0;
add_filter( 'post_limits', create_function( '$a', "return 'LIMIT $start, 10';" ) )

and this:

$page_links = paginate_links( array(
'base' => add_query_arg( 'paged', '%#%' ),
'format' => '',
'prev_text' => __('«'),
'next_text' => __('»'),
'total' => ceil($wp_query->found_posts / 10),
'current' => $_GET['paged']
));


and change 10 to 50 or 100 or ...

MySQL fix some phone numbers

This is long and convoluted, but basically, it takes unknown inputs of phone numbers from a table:

5551212

555-1212

212555-1212

212-555-1212

and makes them all

2125551212

select Concat(if(length(PhoneNumber)< 10, "212", ""), replace(PhoneNumber, "-","")) FROM AddressBook;

update addressbook set PhoneNumber=Concat(if(length(PhoneNumber)< 10, "212", ""), replace(PhoneNumber, "-",""));

Evernote works well with WINE

Installed Evernote on WINE, and it seems so far to be pretty stable and works well enough to grab my information.

Serial Port access from OpenOffice.org

This is my post in the forum.

http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=682#p168678