Home

Find and replace text in MySQL E-mail
Thursday, 27 May 2010 00:10

Say you're moving a site from the development server to the production server, and the client has been making updates (adding content, etc.) while the site's been under development.  The problem is that they've been using absolute URLs (http://www.somesite.com/some/somepage.htm) instead of relative ones (some/somepage.htm), so you have to go in and change anywhere from several to several thousand links to either the new site's full URL, or make all the URLs relative.  What do you do?

You can do a simple find-and-replace in MySQL using the following statement:

UPDATE TABLE_NAME SET field_name = REPLACE(field_name, 'text being replaced', 'replacement text');



 
Useful websites and tools - 5/12 E-mail
Wednesday, 12 May 2010 02:00

Other

  • PDF-Xchange Viewer - Need to comment and annotate a PDF document?  Adobe Reader can do it but it's a 30+ MB download, and makes you download Adobe Download Manager.  Foxit Reader's free version adds a red stamp to the top of your document.  PDF-Xchange viewer is a free download that doesn't install extra crap and doesn't mark up your document.


 
"Microsite/Splash Page Designer" E-mail
Sunday, 25 April 2010 22:02

“Microsite/ Splash Page Designer”


Date: 2010-04-25, 3:16PM MDT
Reply to: This e-mail address is being protected from spambots. You need JavaScript enabled to view it [Errors when replying to ads?]



COACTION MEDIA – Marketing Company with emphasize on Health and Beauty Products based on Pearl St in Boulder. We manufacture and distribute health, beauty and nutrition products globally through direct marketing channels and manage several websites including anti-agingstore.com, spatown.com, coationmedia.com, mensnutrition.com, faceserum-pcs.com, collagen-pcs.com, skinnypatch.com
“Microsite/ Splash Page Designer”
Your primary responsibilities would be to take product content from our direct mail catalog and other sources and rolling out offers like these would be the primary activity for the position. However there would be various other design projects like emails, banners, etc.
Here are some examples of sites that we currently operate and need to produce more of
skinnypatch.com; faceserum-pcs.com; acai-pb.com; zen-cleanse.com; collagen-pcs.com
www.anti-agingstore.com
• Responsibilities would Include but not limited to
• Landing Page Design
• Landing Page Content Creating
• Landing Page Optimization
• Content Management on word press and Magento
• Website conversion optimization
• Product Descriptions and Messaging on the websites
• Email Design
• Banner Design
• Helping with SEO
•Other areas might be some help with sales and service activities. Also helping to be create a consistent branding and sales message across all channels including product descriptions, catalog, packaging, social media, affiliate programs and the websites.
Expert in Photoshop and HTML web design required. Knowledge of Flash, PHP and XML a plus.
Compensation: $12-15 per hour
plus bonuses. Part time/full time
Please contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it with design portfolio, resume and cover letter for more details.

  • Compensation: Compensation: $12-15 per hour plus bonuses. Part time/full time
  • Principals only. Recruiters, please don't contact this job poster.
  • Please, no phone calls about this job!
  • Please do not contact job poster about other services, products or commercial interests.
PostingID: 1709818027


 
Useful websites and tools - 4/5 E-mail
Saturday, 27 March 2010 02:00

Web

  • Ipadpeek.com - Want to see what your site looks like on the iPad?  Here's the site to do it.
  • Wakoopa - create a free profile and track all the software you use: what you use most, what you use least, and get recommendations for other software based on what you currently use.  It tracks the websites you visit as well, which makes sense since many websites are more like applications these days (Facebook for example).  I went over their privacy policy and they seem like decent folk who aren't out to collect your data to misuse (sell) later.  My own profile is here.


 
Useful websites and tools - 3/31 E-mail
Saturday, 27 March 2010 02:00

E-mail

  • Whoreadme.com - A free service that lets you know when someone has opened the e-mail you sent them.  You can send the e-mail from their website or from Outlook or whatever other e-mail program you use.  Simply add 'whoreadme.com' to the end of the recipient's email address.  Caveats: it uses an image for tracking, so programs like Outlook, which block images by default, might thwart its normal operation; make sure you use the reply-to e-mail address when signing-up for the service.


Tags: Whoreadme.com  
 
Useful websites and tools - 3/27 E-mail
Saturday, 27 March 2010 02:00

Web

  • Yuarel - URL shortening sites are a dime a dozen, but this one actually lets you "masquerade" the URL, so that the original URL is not displayed in the browser's URL box.  Instead, what's displayed is the http://yuarel.com/ URL you've created. 


Tags: Yuarel  
 
Yoast Breadcrumbs: Displaying slugs instead of titles E-mail
Sunday, 14 March 2010 11:24

I was asked recently how I modified the Yoast Breadcrumbs WordPress plugin to display page slugs instead of page titles.  I won't explain what I did here but only show what modifications I made to the breadcrumbs.php file.  I was working with v. 0.8.4 of the plugin.  Before making any modifications to newer versions, make sure the code looks similar to the original I've pasted here.

 

 

Original:

  // If this is a top level Page, it's simple to output the breadcrumb
  if ( 0 == $post->post_parent ) {
  
 
 
 
 
  $output = $homelink." ".$opt['sep']." ".bold_or_not(get_the_title());
  } else {
   if (isset($post->ancestors)) {

 

Modified code:

// If this is a top level Page, it's simple to output the breadcrumb
  if ( 0 == $post->post_parent ) {
   $temp = get_permalink();
   $temp = explode("/",$temp);
   $temp = array_reverse($temp);
   $temp = $temp[0];
 
   $output = $homelink." ".$opt['sep']." ".bold_or_not($temp);
  } else {
   if (isset($post->ancestors)) {

 

 

Original:

$links = array();   
   foreach ( $ancestors as $ancestor ) {
    $tmp  = array();
    $tmp['title']  = strip_tags( get_the_title( $ancestor ) );
    $tmp['url']  = get_permalink($ancestor);
    $tmp['cur'] = false;
    if ($ancestor == $post->ID) {
     $tmp['cur'] = true;
    }
    $links[] = $tmp;
   }
 
   
 
 
   $output = $homelink;
   foreach ( $links as $link ) {

 

Modified:

$links = array();   
   foreach ( $ancestors as $ancestor ) {
    $tmp  = array();
    $tmp['title']  = strip_tags( get_the_title( $ancestor ) );
    $tmp['url']  = get_permalink($ancestor);
    $temp = explode("/",$tmp['url']);
    $temp = array_reverse($temp);
    $tmp['title'] = $temp[0];
    $tmp['cur'] = false;
    if ($ancestor == $post->ID) {
     $tmp['cur'] = true;
    }
    $links[] = $tmp;
   }
 
   $output = $homelink;
   foreach ( $links as $link ) {



 
«StartPrev12345678910NextEnd»

Page 6 of 18