How To Change The Apple ID On Your iPod Touch/iPhone

An Apple ID is used to get iTunes downloads, apps and many other items. In case you own iPod Touch or iPhone, you must need an Apple ID. A wide range of items is available on App store which should be used.

You might have faced certain problems with the Apple ID while purchasing certain apps. It may happen that the app you like is not available in your country. In such a case, you can create aniTunes account for the country in which the app is available. You do not require any credit card. This makes the items accessible from another country.

However, the Apple ID can be changed. You can do it by switching to a different ID or changing the current one.

Change the ID On Your Own Device

This can apply to your iPad too. The first step is to verify your account that is used for App Store and iTunes purchases. Open App Store or iTunes in the iPod. When you open the page, go to its bottom. In case you are on the product page of App Store, go to the main screen. You can also tap on Top 25 or Categories. When you tap on Top 25, you will see Top Grossing, Top Free and Top Paid apps. You must have created an Apple ID while purchasing a free or paid app.

In case the Apple ID has already been created, you can see at the bottom of App Store or iTunes.

Once you have opened the account, search for ‘Home’ button. Press it. Launch ‘Settings’. Scroll down and search for ‘Store’. Tap it.

It will give you two choices: ‘View Apple ID’ & ‘Sign Out’.

Hit ‘View Apple ID‘. The payment details related to your account will be displayed such as phone number, billing address and credit card details. It will also display the country name from where you are buying the items. In case you want to change the information about your region or country, follow the instructions given on screen. You need to accept certain terms and conditions. You can also change the billing details.

The Apple ID email can also be changed by tapping the existing Apple ID. This will display your email and password with some security questions.

In case you want to switch over to another Apple ID, you only need to tap ‘Sign Out’ button.

You will be asked to log in when you purchase the iTunes or App Store items.

Change The ID On iTunes Desktop

If you are using your computer, iTunes can be launched on the desktop to change the Apple ID billing details, email ID and password. Go to ‘Store’ and click on ‘View My Account’.

You are required to submit your password details for verification. Apple will give you all the detailsrelated to your account. You can edit this information easily.

Your account details can also be modified by visiting the website of Apple.

Continue Read

How To Change The Apple ID On Your iPod Touch/iPhone

An Apple ID is used to get iTunes downloads, apps and many other items. In case you own iPod Touch or iPhone, you must need an Apple ID. A wide range of items is available on App store which should be used.

You might have faced certain problems with the Apple ID while purchasing certain apps. It may happen that the app you like is not available in your country. In such a case, you can create aniTunes account for the country in which the app is available. You do not require any credit card. This makes the items accessible from another country.

However, the Apple ID can be changed. You can do it by switching to a different ID or changing the current one.

Change the ID On Your Own Device

This can apply to your iPad too. The first step is to verify your account that is used for App Store and iTunes purchases. Open App Store or iTunes in the iPod. When you open the page, go to its bottom. In case you are on the product page of App Store, go to the main screen. You can also tap on Top 25 or Categories. When you tap on Top 25, you will see Top Grossing, Top Free and Top Paid apps. You must have created an Apple ID while purchasing a free or paid app.

In case the Apple ID has already been created, you can see at the bottom of App Store or iTunes.

Once you have opened the account, search for ‘Home’ button. Press it. Launch ‘Settings’. Scroll down and search for ‘Store’. Tap it.

It will give you two choices: ‘View Apple ID’ & ‘Sign Out’.

Hit ‘View Apple ID‘. The payment details related to your account will be displayed such as phone number, billing address and credit card details. It will also display the country name from where you are buying the items. In case you want to change the information about your region or country, follow the instructions given on screen. You need to accept certain terms and conditions. You can also change the billing details.

The Apple ID email can also be changed by tapping the existing Apple ID. This will display your email and password with some security questions.

In case you want to switch over to another Apple ID, you only need to tap ‘Sign Out’ button.

You will be asked to log in when you purchase the iTunes or App Store items.

Change The ID On iTunes Desktop

If you are using your computer, iTunes can be launched on the desktop to change the Apple ID billing details, email ID and password. Go to ‘Store’ and click on ‘View My Account’.

You are required to submit your password details for verification. Apple will give you all the detailsrelated to your account. You can edit this information easily.

Your account details can also be modified by visiting the website of Apple.

Continue Read

How To Edit Thousands of WordPress Posts With Just One SQL Command

It is very interesting to maintain a WordPress blog. You have to perform a number of tasks such as getting the website designed, choosing a relevant theme and writing unique and appropriate posts to attract more traffic. But with time you realize that visitor flow to your blog is less and your web host has less bandwidth.

It takes a lot of time and effort to enhance the presence of your blog. Sometimes, there are certain major changes that need to be done.

Modifying Posts With One SQL Command

There are thousands of posts in your blog in which Google adverts are inserted manually. If you want a minor editing, you have to make changes in all these posts. This is a tedious task.

However, certain tools are available which can make this process simpler. Here we discuss how you can edit a large number of posts with a SQL command. You need a phpMyAdmin to start this process. Go to the menu on the left. Select your blog’s database.

There is a code in SQL tag. This code will be used to remove various sections of the content. It will delete the content you have selected on any number of blog posts. But the condition is that the start text and end text should be common in all the content. For example, there is a common start and end tag in Google advert.

The screenshot below displays the blog entries in which the ad is manually inserted on each page after ‘more’ tag.

The code will make your page appear like the following screenshot.

There is a ‘script type’ start tag which can be used before every advert. The end of the advert has a‘script src’ tag.

If you want to remove an entire block of a page, you have to use the ‘update’ command of SQL. You must understand three functions of MySQL: locate, replace and substr.

LOCATE is used to inform the SQL command about the start & end points location. Here, strings are used before and after the section. Following is the command for the location of the start point on a  page:

LOCATE (‘<script type=”text/javascript”>’, post_content)

The end point location is little complicated. You get a start for a string. In order to get the end point location, the total characters have to be added. Check out the following command.

LOCATE(‘<script src=’http://pagead2.googlesyndication.com/pagead/show_ads.js” type=”text/javascript”>’, post_content) + 93

Use REPLACE to remove the text you do not require. You need to tell the function which text is no longer required. Use SUBSTR to take out the string from your post content. You need to give details of your starting location and length.

When the code is inserted to SUBSTR function, it looks like the following:

substr(post_content, locate(‘<script type=”text/javascript”>’, post_content), ((locate(‘<script src=”http://pagead2.googlesyndication.com/pagead/show_ads.js” type=”text/javascript”>’, post_content) + 93) – (locate(‘<script type=”text/javascript”>’, post_content))))

It includes three sections: post content, length and start location.

This defines the text you wish to wipe from the posts. Now simply use REPLACE to remove it. Add the code in the command below:

UPDATE wp_posts SET post_content = replace(post_content, string_to_replace, replacement_string);

It will appear like the following:

UPDATE wp_posts SET post_content = REPLACE(post_content, substr(post_content, locate(‘<script type=”text/javascript”>’, post_content), ((locate(‘<script src=”http://pagead2.googlesyndication.com/pagead/show_ads.js” type=”text/javascript”>’, post_content) + 93) – (locate(‘<script type=”text/javascript”>’, post_content)))), ‘ ‘);

If there is proper alignment of the syntax, your phpAdmin will show successful results as shown in the screenshot below.

When the posts are reloaded in the browser, the ad will not be displayed.

However, there are certain ads that have different formatting like the page below.

In such a case, change precise tags at the start and end. Use the SQL command again and remove the tags.

You can delete any content in the WordPress post by using this technique. You can easily use the SQL commands for editing a large number of posts. This saves you from working manually. You must remember that a proper backup of your database has to be maintained before you begin with the process.

Continue Read

How To Edit Thousands of WordPress Posts With Just One SQL Command

It is very interesting to maintain a WordPress blog. You have to perform a number of tasks such as getting the website designed, choosing a relevant theme and writing unique and appropriate posts to attract more traffic. But with time you realize that visitor flow to your blog is less and your web host has less bandwidth.

It takes a lot of time and effort to enhance the presence of your blog. Sometimes, there are certain major changes that need to be done.

Modifying Posts With One SQL Command

There are thousands of posts in your blog in which Google adverts are inserted manually. If you want a minor editing, you have to make changes in all these posts. This is a tedious task.

However, certain tools are available which can make this process simpler. Here we discuss how you can edit a large number of posts with a SQL command. You need a phpMyAdmin to start this process. Go to the menu on the left. Select your blog’s database.

There is a code in SQL tag. This code will be used to remove various sections of the content. It will delete the content you have selected on any number of blog posts. But the condition is that the start text and end text should be common in all the content. For example, there is a common start and end tag in Google advert.

The screenshot below displays the blog entries in which the ad is manually inserted on each page after ‘more’ tag.

The code will make your page appear like the following screenshot.

There is a ‘script type’ start tag which can be used before every advert. The end of the advert has a‘script src’ tag.

If you want to remove an entire block of a page, you have to use the ‘update’ command of SQL. You must understand three functions of MySQL: locate, replace and substr.

LOCATE is used to inform the SQL command about the start & end points location. Here, strings are used before and after the section. Following is the command for the location of the start point on a  page:

LOCATE (‘<script type=”text/javascript”>’, post_content)

The end point location is little complicated. You get a start for a string. In order to get the end point location, the total characters have to be added. Check out the following command.

LOCATE(‘<script src=’http://pagead2.googlesyndication.com/pagead/show_ads.js” type=”text/javascript”>’, post_content) + 93

Use REPLACE to remove the text you do not require. You need to tell the function which text is no longer required. Use SUBSTR to take out the string from your post content. You need to give details of your starting location and length.

When the code is inserted to SUBSTR function, it looks like the following:

substr(post_content, locate(‘<script type=”text/javascript”>’, post_content), ((locate(‘<script src=”http://pagead2.googlesyndication.com/pagead/show_ads.js” type=”text/javascript”>’, post_content) + 93) – (locate(‘<script type=”text/javascript”>’, post_content))))

It includes three sections: post content, length and start location.

This defines the text you wish to wipe from the posts. Now simply use REPLACE to remove it. Add the code in the command below:

UPDATE wp_posts SET post_content = replace(post_content, string_to_replace, replacement_string);

It will appear like the following:

UPDATE wp_posts SET post_content = REPLACE(post_content, substr(post_content, locate(‘<script type=”text/javascript”>’, post_content), ((locate(‘<script src=”http://pagead2.googlesyndication.com/pagead/show_ads.js” type=”text/javascript”>’, post_content) + 93) – (locate(‘<script type=”text/javascript”>’, post_content)))), ‘ ‘);

If there is proper alignment of the syntax, your phpAdmin will show successful results as shown in the screenshot below.

When the posts are reloaded in the browser, the ad will not be displayed.

However, there are certain ads that have different formatting like the page below.

In such a case, change precise tags at the start and end. Use the SQL command again and remove the tags.

You can delete any content in the WordPress post by using this technique. You can easily use the SQL commands for editing a large number of posts. This saves you from working manually. You must remember that a proper backup of your database has to be maintained before you begin with the process.

Continue Read

5 Firefox Add-On Management: 5 Add-Ons For The User Who Installs A Lot Of Add-Ons

Do you regularly install add-ons in the Firefox browser? If you have installed many add-ons and you use most of them, this means you are a Firefox Add-ons Power User.

Add-ons are installed to perform various tasks such as search and security. They are an essential item in web browsing. Certain tools are required through which the add-on management can be done automatically rather than manually.

5 Useful Add-ons for Firefox users

Restartless Restart

You have to start your browser again whenever an extension is installed. You do not have to face this restarting trouble in Chrome. There are certain add-ons available for Firefox using which you do not need to restart your browser. You must install Restartless Restart.

It is a 12KB add-on that is very simple to use. A restart feature is added in your right-click menu. To start Seamonkey or Firefox again, a CTRL/CMD+Alt+R hotkey is added. There is no need to search for the start icon of Firefox if you are using this add-on.

Is It Compatible?

This add-on is simple to use. Compatibility versions of all the add-ons are displayed in the Manager window of the Add-on.

It helps you in taking decisions about the immediate upgradation of the browser  or deletion of some add-ons with any new upgrade.

Add-on Compatibility Reporter

Sometimes, you do not want to wait for the launch of the latest version of a browser and you try its releases in alpha or beta stage. This leads to certain compatibility issues of the browser with the add-ons.

The Add-on Compatibility Reporter lets you test the compatibility between your add-ons and the browser. In case they do not function properly, the problem should be immediately reported toMozilla. Mozilla can also be informed if the add-on is working.

CLEO (Compact Library Extension Organizer)

It is similar to an extension packager. In case you have a large number of add-ons, CLEO is quite useful in organizing them.

These add-ons are combined in an installable file. You can keep this file in the form of a backup that can be exported to a specific location. This can also be used in various computers.

FEBE (Firefox Environment Backup Extension)

It is a very easy solution for your backup & restore needs. You can use this add-on to back up your themes, preferences, extensions, cookies, passwords, bookmarks and any folder or file. You get an option to restore the items you want.

Your backups can be scheduled and stored in folders stamped with a date. You can also upload thebackups to box.net account. This can be done automatically. FEBE maintains back ups for the extensions which are saved in an installable file.

Continue Read