This procedure explains how to backup MySql Database through phpMyAdmin.

1. Login in phpMyAdmin.
2. Select the Database you want to backup (click on it). If your version of phpMyAdmin is different from ours, there is a possibility that you have to click on Databases, in order to select the database you want ot backup. *
3. The tables of the databases will appear with some other stuff. Just go straight for the export tab.
4. Under Export, select all tables (if they are not already selected), or just select the tables you want to backup.
5. Choose the format of the file you want to export (right under the tables). SQL is the default and the recommended option for this.
6. On the Options – Structure, select Add DROP TABLE / VIEW / PROCEDURE / FUNCTION, Add AUTO_INCREMENT value and Enclose table and field names with backquotes (If you are familiar with SQL, select the options you want).
7. On the Options – Data, select Complete inserts and Extended inserts.
8. Look for the Save as file checkbox and click on it. You now have the compression options, None, zipped or gzipped. Choose whatever you prefer.
9. You now have an SQL file (compressed ot uncompressed), which is actually a script to create the structure of the database you have just backed up, together with all your data. (Very nice and easy)

* If you are not sure about your database name (in case you have multiple databases), check from your application (a config file), for the database name it is using.

This procedure explains how to backup MySql Database through phpMyAdmin.

1. Login in phpMyAdmin.
2. Select the Database you want to backup (click on it). If your version of phpMyAdmin is different from ours, there is a possibility that you have to click on Databases, in order to select the database you want ot backup. *
3. The tables of the databases will appear with some other stuff. Just go straight for the export tab.
4. Under Export, select all tables (if they are not already selected), or just select the tables you want to backup.
5. Choose the format of the file you want to export (right under the tables). SQL is the default and the recommended option for this.
6. On the Options – Structure, select Add DROP TABLE / VIEW / PROCEDURE / FUNCTION, Add AUTO_INCREMENT value and Enclose table and field names with backquotes (If you are familiar with SQL, select the options you want).
7. On the Options – Data, select Complete inserts and Extended inserts.
8. Look for the Save as file checkbox and click on it. You now have the compression options, None, zipped or gzipped. Choose whatever you prefer.
9. You now have an SQL file (compressed ot uncompressed), which is actually a script to create the structure of the database you have just backed up, together with all your data. (Very nice and easy)

* If you are not sure about your database name (in case you have multiple databases), check from your application (a config file), for the database name it is using.

WP Include FileWP Include File utilizes the WordPress Shortcode API to include the contents and output from PHP code located in an external file within the post content.

DOWNLOAD >>

Features

  • Advanced form security, nonce and whitelist registration of option variable to be written in the database
  • Options stored as one array in the database to minimize database cluster
  • Unregistration of option variable from whitelist on deactivation
  • On uninstall option array is removed from the database. No trail left behind
  • Functional and user-friendly options page
  • Help page build-in

Why do you need WP Include File?

WP Include File is needed because any PHP code you type within the tinyMCE will not be rendered when the post content is displayed. Hence instead of having to create templates for each specific task/post, you can just create localized specific files and just include them in the post content using WP Include File.

WP Include File Implementation in tinyMCE

Furthermore it becomes handy when applying specific styles to certain posts that are not required by the rest of the site. Just enclose the style definitions in the style tags, save it in a file and include it in the specific post using WP Include File. Hence you save on bandwidth and load times by not loading unecessary style definitions where they are not needed.

The WP Include File plugin comes with an intuitive and functional options that will have you up and running in no time.

WP Include File options page

If you want to learn more about the philosophy behind WP Include File you can read this article: Using the WordPress Shortcode API to include an external file in the post content

Invoking WP Include File using the Shortcode within the tinyMCE

WP Include File can be invoked using the Shortcode . The Shortcode accepts three attributes: file, path and masterpath. It will include the contents of the specified file at the location the Shortcode is placed within the post content.

Usage:

  1. [include file=”MyCustomFile.php”]
    This will include the contents of the file MyCustomFile.php located in the directory selected on the WP Include File Options page.
    For example:
    If you selected Site Root Directory on the Options page, the full path to the file to be included will be MyCustomFile.php
    If you selected Theme Root Directory on the Options page, the full path to the file to be included will be /MyCustomFile.php
  2. [include file=”MyCustomFile.php” path=”/MyDirectory/demos”]
    The path attribute will override any path extension specified on the WP Include File Options page. This will include the contents of the file MyCustomFile.php located in the directory /MyDirectory/demos relative to the Root directory selected on the WP Include File Options page.
    For example:
    If you selected Site Root Directory on the Options page, the full path to the file to be included will be MyDirectory/demos/MyCustomFile.php
    If you selected Theme Root Directory on the Options page, the full path to the file to be included will be /MyDirectory/demos/MyCustomFile.php
  3. [include file=”MyCustomFile.php” masterpath=”/home/SomeUser/SomeDirectory/SomeOtherDirectory/MyDirectory/demos”]
    The masterpath attribute will override all the selections on the WP Include File Options page. This will include the contents of the file MyCustomFile.php located in the directory /home/SomeUser/SomeDirectory/SomeOtherDirectory/MyDirectory/demos.
    For example:
    The full path to the file to be included will be /home/SomeUser/SomeDirectory/SomeOtherDirectory/MyDirectory/demos/MyCustomFile.php

FAQ

  1. I am using the path attribute and my file is not included.
    The first forward slash (/) should be included when declaring a path extension using the path attribute. For example path=”/MyIncludeDirectory/Content”

Version History

  • v. 1.9.10.14
    First public release.

If you have any comments or suggestions or bugs to report please leave them below. Alternatively you can use our contact form.

As of today, Monday October 12, 2009 cleanRoar is live and available for free download from the Themes section at WordPress.org. Download cleanRoar…

cleanRoar has been developed by the AmberPanther team and has been released for public use as part of AmberPanther contributions. It is a light and clean theme which is easily customizable.

We are excited to see the theme going live on WordPress.org. We have enjoyed working with WordPress and its flock  of themes all this time, hence we felt it was about time to give something back. cleanRoar was originally developed as our testing ground for custom code and plugin development. It made our development efforts so much easier as we could effortlessly go behind the scenes and make the necessary changes to mold the theme to the needs of the code or plugin being developed. Then we thought… why not to share? After all our ultimate goal is to make the web a better place. And this can only be done by a global team effort.

Read more about the theme and exchange ideas…

View the Live Demo of the here…

Download the theme…

cleanRoar

Stay tuned for more contributions, PantheMation is just around the corner. Another AmberPanther creation…

Alexa, originally an abbreviation for Address Lookup EXperts Authority, is supplying the Internet Archive with web crawls as it was also doing in the past. Alexa (An amazon.com company from 1999) ranks sites, based on tracking information received from users who are using Alexa toolbar (sparky). Last year (April 16th, 2008) Alexa confirmed that, with their new system, they have more data sources for ranking, instead only the data from their toolbar’s users. Now the real questions is: “Is Alexa ranking unbiased considering a random sample internet users of sufficient size? Or is it a biased ranking from a random sample of some groups of internet users such as Webmasters, Publishers and Advertisers?”

Conclusion: Even if Alexa, is only being used by Webmasters, Publishers and Advertisers, then it is a ranking system provided as a measure of comparison between multiple sites.

Their toolbar is useful for showing the ranking for each site (working for Firefox, IE).
Use their widget in order to display Alexa ranking for your site (it is generally believed, that it improves your ranking if you have it)

A sitemap is a list of all your web site’s pages, that you want to be accessible by the crawlers and the users browsing your web site. Search Engine bots use your sitemap to crawl existing, new or modified pages on your web site. A sitemap is a must for your web site, if you want to improve SEO (search engine optimization) for your site, by making sure that all your pages are acessible and can be found.

XML Sitemaps
Some of the major Search Engines, Google, Bing, Yahoo and Ask, support the Sitemaps protocol. The sitemap is an xml file, that lists all the URLs of your web site, with information like:
– when it was last updated
– how often it changes
– importance of each URL

You can read more about the sitemaps protocol at http://www.sitemaps.org.

In WordPress, an easy and efficient way to create your web site’s XML Sitemap, is by using a plugin called Google XML Sitemaps.
This WordPress plugin has been used many times by the AmberPanther team for various WordPress installations. The name of the plugin is “Google XML Sitemaps”, but it actually creates a sitemap.xml file, which is accessible by Google, Bing, Yahoo, MSN and Ask search engines (more about sitemaps). Google XML Sitemaps plugin, automatically updates your sitemap everytime you update or modify a post or a page and notifies the search engines that support the sitemap protocol about the updates on your web site. This is a must for every wordpress installation.

Google XML Sitemaps Plugin’s WebSite

Are you using the jQuery library? Are you trying to use its functions by using the “$” as the shortcut for “jQuery” and it does not work?

This means that somewhere in your javascript code the jQuery.noconflict() function is called. This function overrides the shorthand “$” notation and allows only for the use of “jQuery”. This is done as to avoid conflicts with other libraries that might be being used simultaneously and have the same shorthand notation. The popular WordPress platform, loads jQuery in the no conflict mode when using the build-in function wp_enque_script(‘jquery’) to load the library.

The option then is to use jQuery with the standard calling notation:

jQuery(document).ready(function(){ jQuery(“div”).hide(); });

Alternatively, your preferred new shorthand notation can be assigned:

var $jq = jQuery.noConflict();  $jq(document).ready(function(){ $jq(“div”).hide(); });

Finally if you still insist on using the shorthand “$” notation you can assign it for use only in the document ready are and avoid conflicts with other libraries:

jQuery.noConflict(); //Note “$” assigne at “function($)” jQuery(document).ready(function($){ $(“div”).hide(); });

Options are endless with jQuery…

  1. General Description
  2. Version Information
  3. Styles

General Description

cleanRoar is a WordPress theme developed by the AmberPanther team. The theme is available for download at WordPress.org Themes . This theme is the first in a series of a contributions the team is planning for the web community.

DEMO SITE >>

cleanRoar boasts a clean and light design. It makes the readers experience effortless. It is easily accessible and customizable for your needs.  It features a primary two-column design, the left main content column and the right sidebar. The right sidebar is subdivided into two columns as well. The thin one was originally intended for a banner ad. Both sidebar columns are widget ready. The new version of cleanRoar supports multiple styles/skins also.

cleanRoar has a functional back-end that allows you to enable/disable the ad showing in the sidebar. It can be a single banner image or a javascript from your preferred advertising service.

cleanRoar

We hope you will enjoy this clean and light theme.You can see the theme in action here…

You can download it from WordPress Themes…

If you have any comments or suggestions about improving the theme leave us a note below. Exchange of ideas leads to excellence…

Version Information

v.10.01.xx:

  • Default style back to Legacy with Christmas style as an option
  • Addition of Red style, derived from the Christmas style
  • Addition of Redmad style, courtesy of Redmad

v.9.12.19:

  • Global variable conflict in WordPress theme editor resolved

v.9.12.16:

  • Four (4) layouts to choose from.
  • Option for custom CSS.
  • Control information (site name and description) shown in Header.
  • Display an image/logo in header through a url or Gravatar!
  • Display of Home link on main navigation.
  • Display excerpt or whole post on blog page.
  • Global control of comments on pages.
  • Control default sections to be shown on sidebar.

v.9.12.04:

  • Multiple skins (style) support, Legacy style and Christmas style
  • Snow effect for Christmas style
  • Categories listing on the main menu bar, not just in the sidebar
  • Support for social links, twitter and facebook, and third-party RSS url, to replace the native WordPress one
  • Google Analytics script can be set from the options, no need to edit template files
  • Support for up to four 125 by 125 px Ad boxes, displayed at the top of the sidebar

v.9.10.18:

  • enhanced back-end securities

v.9.10.12:

  • first public release
  • Ad banner and Ad script support in the sidebar

Styles

Legacy:

cleanRoar in Legacy style

cleanRoar in Legacy style

Christmas:

cleanRoar in Christmas style

cleanRoar in Christmas style

Red:

cleanRoar in Red style

Redmad:

cleanRoar in Redmad style