Branding ILIAS 4

August 2nd, 2010

This is document for Branding ILIAS 4 for reference

Branding ILIAS 4

Getting Math Quest on top at Search Engine

July 19th, 2010

Salam.

Today i am setting a target, to see whether my seo techniques still useful and can be applied :D

So the mission is simple, to get math quest to be place at top search engine result. Below are screenshot taken for few keywords that i have targeted for our Math Quest game.

Math Quest

Math Game

Math Education Game

These will be the proof of current positon. Let see how much time it takes to ranked up to the top..

How to include a user define class file in zend controller file

July 12th, 2010

Disclaimer: This tutorial was taken from linked in, just for the sake of my reference.

Ramesh Chetipalli • To add user define class (or custom library) u can use zend framework’s autoloader namespaces.

Add the below line in application.ini file

autoloaderNamespaces.custom = “Custom_”

All the user defined classes will start ‘Custom_’ as prefix (e.g. Custom_Abc). The path for the file will be – /library/Custom/Abc.php

In the controller u can use – $abc = new Custom_Abc();

Warning: require_once(Spreadsheet/Excel/Reader/OLERead.php)

May 12th, 2010

I am now developing web application that requires to read and write to excel file. So my first milestone is to read it.  I have choosen PHP Excel Reader to read the excel.

I have encounter the problem:

Warning: require_once(Spreadsheet/Excel/Reader/OLERead.php) [function.require-once]: failed to open stream: No such file or directory in D:\xampp\htdocs\phpexcel\Excel\reader.php on line 31

Fatal error: require_once() [function.require]: Failed opening required ‘Spreadsheet/Excel/Reader/OLERead.php’ (include_path=’.;\xampp\php\PEAR’) in D:\xampp\htdocs\phpexcel\Excel\reader.php on line 31

Solving:

1) Open the reader.php file from the Excel folder. Remove the below code from the top of the line.
require_once ‘Spreadsheet/Excel/Reader/OLERead.php’;

2) And add the below code after remove that.
require_once ‘Excel/oleread.inc’;

Source:  http://icfun.blogspot.com/2009/09/php-warning-requireoncespreadsheetexcel.html

Flash/Flex Tutorial

May 6th, 2010

Using External Call from HTML to Flash

http://blog.circlecube.com/2008/02/tutorial/actionscript-javascript-communication/

Property Tactics

May 4th, 2010

Got a Tips to calculate ROI for property for rental:

http://www.horlic.com/how-to-calculate-return-on-investment-roi-for-property-rental-yields/

R&D part 1

April 9th, 2010

My R&D for next few weeks are:

  1. Explore how to import excel and save into database using php
  2. Make a simplest way for php to called a functions at url (http://www.mohdramzan.com?actions=’start’). May consider cakephp style approach (/users/starts) etc. This would be great development for FLASH and Wordpress plugin  as they are action based. ;)

Flash MMO Server

March 19th, 2010

These was some of my research on how to create Flash MMO Server:

MMO Server

http://www.smartfoxserver.com/products/basic.php

MMO Server with Flash Component/Editor

http://www.openspace-engine.com

MMO Flash API

http://www.nonoba.com/developers/multiplayerapi/overview

http://playerio.com/pricing/

Chat room kind of flash

http://palabre.gavroche.net/content/view/19/38/

Optimizing MySQL

March 18th, 2010

Today i have encounter a problem where mysql used by our clients got hang.

And after 2 days of searching, i finally know that using too many left join (joining mysql table) while NOT INDEXING it would make database queries too long that can cause database hang.

The solution this situation is by using mysql index.

To retrieve rows from other tables when performing joins. MySQL can use indexes on columns more efficiently if they are declared as the same type and size. In this context, VARCHAR and CHAR are considered the same if they are declared as the same size. For example, VARCHAR(10) and CHAR(10) are the same size, but VARCHAR(10)and CHAR(15) are not.

Comparison of dissimilar columns may prevent use of indexes if values cannot be compared directly without conversion. Suppose that a numeric column is compared to a string column. For a given value such as 1 in the numeric column, it might compare equal to any number of values in the string column such as '1'' 1','00001', or '01.e1'. This rules out use of any indexes for the string column.

from http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html

You can read more about this and how to create indexes as below:

http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html

http://dev.mysql.com/doc/refman/5.0/en/create-index.html

Problem Solving: JQuery Pagination not working for next page

March 17th, 2010

Problem Statement

I have used the jquery pagination that i have posted before. It was great tool but i have encounter some problem when deploying it to one of our client

Causes & How to solve it

1. You must ensure that you have followed the table structure by using <thead></thead> and <tbody><\tbody>

2. Remove Limit option in pager.

Jquery Problem cause at LIMIT

Jquery Pagination Solving

Jquery Pagination Solving: Remove LIMIT