LampWin Contest-End Of Chapter

Finally, the contest is over. Time given is not suffient for me to do all the conversion from mysql to mssql. Furthermore, the database was down about 2 times and costing me a lot of time. The admin of this hosting did not respond as quick as I expected. The usage of Plesk was not a good choice in this competition. Almost all the time it having problem with mssql. Maybe the orgeniser was not well prepared for this competition. I was assigned Wakka Wikki and I have tried my best to do the job. These are the chances that I have made to make the Wakka Wiki running on mssql backend. You can visit my application at this link: http://azmipelah.dev.lamp2win.com/wikka/wikka.php?wakka=HomePage

The process is not completed yet. I managed to make creation of tables in Mssql and make the default page loading. Some other functions are not fully working yet. The only thing you can do is to post a comment in the frontpage.

The files that are involved in the process are:

install.php (Setup directory)
wikka.class.php (Libs)
All files in Actions Directory
All files in Handlers Directory

Some other mysql functions that are not supported n mssql need to be changed. The functions are:

md5
mysql_real_escape_string is replaced by str_replace (Refer http://osdir.com/ml/php.tcphp/2005-06/msg00056.html)
Now() is replaced by getdate()

LAMP2WIN PHP Programming Contest

I just enrolled in the competition. I hope I can apply my knowledge of 7 years of PHP programming. There are about 20 applications and I need to choose one application to be converted to MsSql Enabled Application. I need some sort of driver or converter that can convert the Mysql Database into Mssql. I am positively thinking that this is the the key factor to succeed in the competition.