Monthly Archives: March 2007

DTV transition coupon info.

Posted on by

I was trying to find some information about the DTV transition coupons. Here’s what I found in a govt pdf information sheet. At the beginning of 2008 you will have the opportunity to request a coupon. After February 17, 2009 you will need the converter box to watch over the air DTV. (Also if you want to learn more about the 700 MHz band aka. the reason we need these new boxes. Om wrote a very good article on it.) There is other stuff you could find interesting, but I doubt it. Here’s the meat;

Coupon requests

  • Households must request coupons from NTIA between January 1, 2008 and March 31, 2009.
  • Consumer coupon requests will be taken via a toll-free customer support center, a Web site, fax, and through the mail.
  • Upon request, a maximum of up to two coupons will be sent to households via the United States Postal Service and will expire three months after they are mailed.
  • Each coupon will be worth $40 towards the purchase of an eligible converter box from a certified consumer electronics retailer. Coupons have no cash value and may not be resold.
  • Coupons will be electronically trackable and uniquely numbered, similar to gift cards, so that transactions will be verified at the point of sale.

Coupon redemption

  • Once consumers begin receiving their coupon(s) in 2008, they will be able to use them toward the purchase of eligible converter boxes through certified retailers.
  • Only one coupon can be redeemed per converter box. It is unlawful for consumers to combine coupons toward the purchase of a single converter box.
  • It is unlawful for consumers to redeem coupons to purchase consumer electronics items other than eligible converter boxes.

[tags]DTV, transition, 2008, 2009, $40, coupons, vouchers, converter, box, consumers, information, reference, time line[/tags]

wordpress url change mysql code

Posted on by

I changed the url of my blog again recently here is some helpful mysql code to renaming a wordpress blog url. YMMV. You’ll need to find all the other fields which containd the old information. I’d like this to be a plugin, it’s more or less a set of simple database commands, but for now cut and paste code will work ok.

update `wp_postmeta` set `meta_value` = replace(`meta_value`,'blog.blog.px.ns1.net','blog.px.ns1.net');# MySQL returned an empty result set (i.e. zero rows).
 
update `wp_comments` set `comment_author_url` = replace(`comment_author_url`,'blog.blog.px.ns1.net','blog.px.ns1.net');# MySQL returned an empty result set (i.e. zero rows).
 
update `wp_options` set `option_value` = replace(`option_value`,'blog.blog.px.ns1.net','blog.px.ns1.net');# MySQL returned an empty result set (i.e. zero rows).
 
update `wp_posts` set `post_content` = replace(`post_content`,'https://px.ns1.net','http://blog.playerx.net:81');
 
update `wp_posts` set `post_content` = replace(`post_content`,'http://px.ns1.net:81','http://blog.playerx.net:81');
update `wp_posts` set `post_content` = replace(`post_content`,'/wordpress','/');
update `wp_posts` set `post_content` = replace(`post_content`,':81//',':81/');
update `wp_xspf_player` set `url` = replace(`url`,'https://px.ns1.net','http://blog.playerx.net:81');
 
update `wp_posts` set `guid` = replace(`guid`,'https://px.ns1.net/','http://blog.playerx.net:81/');
 
update `wp_posts` set `guid` = replace(`guid`,'http://px.ns1.net:81/','http://blog.playerx.net:81/');
 
UPDATE `wp_posts` SET `guid` = REPLACE(`guid`,'/wordpress/wordpress/','/');
update `wp_posts` set `post_content` = replace(`post_content`,"[php]","<pre lang=\"php\">");
 
 update `wp_posts` set `post_content` = replace(`post_content`,"[/php]","</pre>");

update:

update `wp_posts` set `post_content` = replace(`post_content`,'/wordpress/wordpress/','/');
update `wp_posts` set `post_content` = replace(`post_content`,'/wordpress/','/');
update `wp_posts` set `post_content` = replace(`post_content`,'http://px.ns1.net:81/','http://blog.playerx.net/');
update `wp_posts` set `post_content` = replace(`post_content`,'http://blog.playerx.net:81/','http://blog.playerx.net/');
update `wp_posts` set `pinged` = replace(`pinged`,'ns1.net/wordpress/','ns1.net/');
update `wp_posts` set `pinged` = replace(`pinged`,'http://px.ns1.net:81/','http://blog.playerx.net/');
update `wp_posts` set `pinged` = replace(`pinged`,'/wordpress/wordpress/','/');
 
update `wp_posts` set `guid` = replace(`guid`,'http://blog.playerx.net:81/','http://blog.playerx.net/');
 
update `wp_postmeta` set `meta_value` = replace(`meta_value`,'http://px.ns1.net:81/','http://blog.playerx.net/');
update `wp_postmeta` set `meta_value` = replace(`meta_value`,'http://blog.playerx.net:81//','http://blog.playerx.net/');
update `wp_postmeta` set `meta_value` = replace(`meta_value`,'http://blog.playerx.net:81/','http://blog.playerx.net/');
update `wp_postmeta` set `meta_value` = replace(`meta_value`,'/wordpress','/');
 
update `wp_options` set `option_value` = replace(`option_value`,':81','');
# fix /tag/ urls
update `wp_posts` set `post_content` = replace(`post_content`,'/tag/%23','/tag/')

[tags]mysql, wordpress, wordpress database, mysql code, code, examples, URL, change, tables, fields, rename, replace, blog, mysql code,cut and paste, database commands [/tags]