81 Billion

Websites in Singapore that are highly effective and visually appealing

Technical Matter

Remove “mystart by incredibar.com” on opening new tab in Firefox

  1. Search for IncrediBar* toolbar and Web Assistant in add/remove programs and remove it.
  2. Go to Tools >> Add-ons and remove it
  3. Type “about:config” in the address bar of firefox
  4. Ignore the warning that pop-up
  5. Type “browser.newtab.url” at the Search Bar
  6. Right click and click reset
  7. Remove all lines of extensions.incredibar
  8. Where incredibar.com is mentioned, change it to google.com.sg
  9. Scan your computer with Malwarebytes Anti Malware

Installing WordPress

  1. Download the latest release of WordPress to your computer.
  2. Create a database via your cPanel:
    cPanel  >>  MySQL Database Wizard
    –  Create a Database
    –  Create Database User
    –  Add User to Database
    * Note the hostname, username, databasename and password
  3. Upload file to website
  4. Run the install script at your browser by typing www.yoursite.com/wp-admin/install.php
  5. Login to the backend (wp-admin)
  6. Edit the General Setting
  7. Goto Appearance  >>  Install Themes to install a better looking theme.

Converting your HTML to WordPress

  1. Create a folder at /wp-content/themes
  2. Create a new file, index.php, into the folder
  3. Copy your style.css into the folder
  4. Create header.php, sidebar.php and footer.php in the folder
  5. Copy your header into the header.php file (Copy files link to css and js into this folder)
  6. Copy content into the index.php file
  7. Copy the footer into the footer.php file
  8. Check that there’s a code:  <?php get_header(); ?> in the index.php file
  9. Add <?php get_sidebar(); ?> and <?php get_footer(); ?> to the bottom of the index.php file
  10. Insert following codes to loop the posts:
    <?php if ( have_posts() ) : ?> <?php while ( have_posts() ) : the_post(); ?> <div id="post-<?php the_ID(); ?>" <?php post_class(); ?>> <div> <div><?php the_time( 'M j y' ); ?></div> <h2><a href="<?php the_permalink(); ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></h2> <div><?php the_author(); ?></div> </div><!--end post header--> <div> <?php if ( function_exists( 'add_theme_support' ) ) the_post_thumbnail(); ?> <?php the_content(); ?> <?php edit_post_link(); ?> <?php wp_link_pages(); ?> </div><!--end entry--> <div> <div><?php comments_popup_link( 'Leave a Comment', '1 Comment', '% Comments' ); ?></div> </div><!--end post footer--> </div><!--end post--> <?php endwhile; /* rewind or continue if all posts have been fetched */ ?> <div> <div><?php next_posts_link( 'Older Entries' ); ?></div> <div><?php previous_posts_link( 'Newer Entries' ); ?></div> </div><!--end navigation--> <?php else : ?> <?php endif; ?>

Display Title and Excerpt on the Htome Page

$page_id = 2;
$page_data = get_page( $page_id );
$content = $page_data->post_content;
$title = $page_data->post_title;
echo $page_data->post_content;

 Count No. of Pages in a Categories

function wt_get_category_count($input = ”) {
global $wpdb;
if($input == ”)
$category = get_the_category();
return $category[0]->category_count;
$SQL = “SELECT $wpdb->term_taxonomy.count FROM $wpdb->terms, $wpdb->term_taxonomy WHERE $wpdb->terms.term_id=$wpdb->term_taxonomy.term_id AND $wpdb->term_taxonomy.term_id=$input”;
return $wpdb->get_var($SQL);
$SQL = “SELECT $wpdb->term_taxonomy.count FROM $wpdb->terms, $wpdb->term_taxonomy WHERE $wpdb->terms.term_id=$wpdb->term_taxonomy.term_id AND $wpdb->terms.slug=’$input'”;
return $wpdb->get_var($SQL);

// Count Post by Category: echo wt_get_category_count(1);
// Count Post by Slug/Nicename: echo wt_get_category_count(‘hello-world’);


Get Rid of “Hello world” in wordpress:

  1. Delete the post from the post manager
  2. Post something in the main page so that you don’t get “Sorry, but you are looking for something that isn’t here” message

Enable/Disable Password Manager in Firefox

  1. Goto  >>  Tools  >>  Options  >>  Security Tab
  2. Check/uncheck the option “Remember Password for sites”

Moving Emails from cPanel to cPanel

  1. Setup email accounts with new password in new server
  2. Copy /home/user/etc from old server to new server
  3. Copy /home/user/mail from old server to new server
  4. New password will be reset to Old password

Moving Prestashop to another server

  1. Download all files to PC and upload to new server
  2. Export database to PC and import to new server
  3. Verify the _db_name,  _db_user_,  _db_prefix_, _db_passwd_ in the  /config/settings.inc.php file
  4. Go to db table “ps_configuration” and change the “PS_SHOP_DOMAIN” and “PS_SHOP_COMAIN_SSL” value to the new domain.

Transferring account from one webhosting company to another webhosting company

  1. Do a full backup of database, files, emails via cpanel
  2. FTP backup to your PC
  3. Access your WHM using SCP
  4. Copy backup to either /home, /home2, /home3, /root, /usr, /usr/home, /web
  5. Go to your “Restore a Full Backup/CPmove file”
  6. Enter username

Reset CS5 Trial

  1. Delete “pcd” in C:\Program Files\Common Files\Adobe\Adobe PCD
  2. delete “cache” in the “cache” folder
  3. Add following to host at  Windows -> System32 -> Drivers -> etc -> hosts
    ~         activate.adobe.com
    ~         practivate.adobe.com
  4. You may or may not need to delete the folder C:\Documents and Settings\All Users\Application Data\Adobe
  5. Use RunAsDate to pin the date



    This is an area on your website where you can add text. This will serve as an informative location on your website, where you can talk about your site.

    Subscribe to our feed