Moving to the new domain

admin    Tips    

We finally managed to move the site from WordPressReady.com to WPGetReady.com.

We were reading How to move your content to a new location and we expect the site traffic will go down. Try to make a traffic is a process, so domain changing always has its problems. But after reading a bit, we decided to shortcut the process. These were the final steps:

• Backup the site and database
• Copy backup to new domain & database
• modify records siteurl & home from wp_options table to point the new domain
• modify config.php to point to the new database.
• Access site control panel, but don’t browse the site yet
• Install plugin Search & Replace
• Replace any ocurrence of the old domain in the new database.

With these steps we are cloning the entire site and updating any possible link. To finalize:

• Go back to the old site and modify .htaccess with:

Options +FollowSymLinks
RewriteEngine on
RewriteRule (.*) http://www.newdomain.com/$1 [R=301,L]

(Reference: How to redirect Old domain to New domain)

This force any link on the older site to redirect to the new one.

Finally some additional work will be needed, for example ,adjusting Google Analytics, Twitter account and so on. And the forum too.

What are you looking for? Statpress has an answer

admin    Code Snippet, Tips    

The interesting part for a plugin like Statpress is the chance to play with the data stored to see how the traffic is flowing on your site.

For one side, you can explore what the visitors want and where they go. For other part, it allows to detect potential problems (like a incorrect title o find a way to enhance the post content/title) and allow us to think a correct way to create posts. It is SEO on the run.

read more

Flock

admin    Tips    

Flock , the browser built around Gecko engine has suprising characteristics. It has a nice integration with social networks  (Facebook, YouTube, Twitter, Flickr, Blogger, Gmail, Yahoo Mail) , light and with many integrated tools.

Y was surprised when I found that it already has a integrated tool similar to Firebug right out of the box  (Ctrl-Shift-I).

It worth to take a look specially when Flock launched its 3.5 version. Cool.

Poor man’s message broadcast

admin    Tips    

Problem:

A client organizes a long duration sport event (8-10 hours or more) and he wishes to have a page where he sends the news while the event goes on. The page has to auto-refresh itself.

A good example could be IronmanLive.com when a event is running.

¿Do you have a simple solution? I found two ideas about it:

1. Live blogging for wordpress. Outstanding plugin, also allowing Meteor technology. It can work alone too.
2. Other solution: A page using  javascript, and then to use Twitter as broadcast system.

This solution could be used in every site (different than WordPress). I will use  a small javascript library with jQuery to get Twitter messages from an account.

Integrating the above solution with WordPress.

This is another quick & dirty solution to integrate to a WordPress page:

Broadcast demo: here

Instructions:

1-Download the template page

2-Install the template over the WordPress theme

3-Change the page code and select the account you desire. You can select more than one account.

3-Create a simple page on WordPress. Select the new template (Broadcast-demo)

4-Test the page.

By the way, the qTranslate – Twitter combination sucks. All the messages merge together in one twit. This is something what I will work in the next posts.

Quick & dirty: total visitors in Statpress by period

admin    Tips    

What is bother me in Statpress is to find out a way to know the site’s traffic in a period.

This query does exactly, calculating unique visitors, rss and views:

Set @ini='20101108';
Set @fin='20101110';

Select @uniquevisitors:= count(distinct ip,date) as visitors from wp_statpress where feed='' and spider='' and
date between @ini and @fin;

Select @rss:=count(date) as feeds from wp_statpress where feed<>''
and spider='' and date between @ini and @fin;

Select @views:=count(ip) as visitors from wp_statpress where feed='' and spider='' and
date between @ini and @fin;

Select @uniquevisitors,@views,@rss;

This is a start to a nice addition a this plugin… a sub-plugin.

If you want to make queries against WP databases , you should try WP-phpMyAdmin.

Is there is a better plugin for queries? I hear you.

Instructions: rotate your head clockwise…  :)