Since they are no SQLite library that direct support Universal Windows Platform (Windows 10 app) currently yet, we are force to use the SQLite for Windows 8.1 instead. For those who use SQLite in Windows 8 / 8.1 app and wanted to upgrade their project to Universal Windows Platform, you may encounter th following message if you try to follow the tutorial of adding SQLite to Windows 8.1 project.

An exception of type ‘System.DllNotFoundException’ occurred but was not handled in user code

Additional information: Unable to load DLL ‘sqlite3’: The specified module could not be found. (Exception from HRESULT: 0x8007007E)

More »

More and more ad providers are starting to provider ad service for Windows Phone platform. As a Windows Phone developer, I find it very difficult to find any blog post or review comparing the ad providers in Windows Phone. (You can find a lot for Android and iOS.) I’m writing this blog post according to my own experience as a Windows Phone developer dealing with the ad providers. Hopefully this can help you select which ad providers to include in your apps without going through too much trouble.

 

Before you continue read this post, you need to understand the following things:

  • The fill-rate, CTR (click through rate), eCPM (pay per thousand impression) and eCPC (pay per click) are vary according to app, category, country and platform.
  • I only used the SDK for Windows Phone 7 version the ad providers given instead of Windows Phone 8 version since I wanted to support as many device as possible.
  • The list below are sorted according to my own preference according to their performance previously.
  • Those are my own experiences, it maybe vary from others.
  • Please don’t compare the eCPM or eCPC with other platform like Android or iOS… just don’t.

More »

Recently I have been trying different advertisement providers for my Windows Phone apps. Inneractive was one of them. It is relative easy to setup and the SDK is well documented. Everything go smooth at first, then I realize my app force close due to running out of memory for a few times which cause me to investigate what actually cause the memory leak in my app.

After spending a lot of time investigate what went wrong, I suspect Inneractive Ad control was causing the memory leak. This because whenever the ad is show in my app, the memory is not release completely after the page is close. In order to prove that, I have created a 2 page Windows Phone project with Inneractive ad control and I was right. The Inneractive ad control is leaking memory. Although the amount is small, it is important in my app because I display at 2 ads in one page and this can really drive up the memory very fast and force the app to terminate.

More »

One day, one of my friends contacted me for a job offer. His company is hiring and he wish to recommend me to the manager. Let’s not mention about the company’s name. Hmm… it is a multi-nation company with M character in front, that’s all. So I think it is a great chances to try something different and it is a big company, why not give it a try, right?

Well, since it is big and well-known company, I assume there will be a lot of submission other than mine. I need a special and attractive resume to impress the manager. Something like infographic to represent my resume will be great. Honestly, I’m not really good with design or photoshop, so I need something simple yet good enough to stand out from others. In the end, I choose to use timeline and map base design to create my own visual resume.

Below are the first 2 pages of my resume. It is a summary of the whole resume in visual format. The first page show my working experiences, education and my own projects in timeline. While the second page show my worldwide achievements in a world map. I also afraid that some one might want to know more detail about my work from the resume, so I included another 6 pages of “boring” text base writeup with detail info after the visual resume.

Ooi_Keng_Siang_Visual_Resume_01

More »

I have received lot of lot of comments regarding MouseHunt Autobot 1.28 no longer work in Facebook MouseHunt app running Google Chome. Actually I’m in a tight schedule developing my own project, but I have received a lot of comments which I no longer can ignore them. So I done some homework on what actually happen.

First of all, the script is still doing great (This surprise me). The MouseHunt game doesn’t change anything that affected the script too (If you run the script through Firefox, they are running smooth). So, the only thing left is the Google Chrome itself. Yes, some how Google Chrome version 27 no longer allow user scripts to run in iframe (MouseHunt in Facebook run in iframe) by default. In order to allow user scripts to run in iframe, an additional manifest need to be included together with the userscript. I find it very troublesome to distribute the user script in two separate files, so I ignored this option.

More »

This post is intended to help the Google Chrome users on how to install or uninstall user script (or Google they call it Content Script) in their browser. Google Chrome rapid updates and changing had cause a lot of problems on how user can install user scripts and how the user script interact with the browser. To make thing simple, I’m going to introduce you all to Tampermonkey extension in Google Chrome which is very similar to Geasemonkey add-on in Firefox. Trust me, this will make your life easier.

 

How to install user scrips in Google Chrome

Step 1: Open Tampermonkey extension and install it. Once you have installed the extension, you should see a Tampermonkey icon button at the top right hand side corner near the Menu button in Google Chrome.
usersciptInChrome_01

More »

In my previous post, I have encounters a problem in Microsoft Word 2013 where the markup area (a huge blank space on the right hand side which is colored in light silver / gray color) keep on pop-up whenever I tries to print my word document or I save my document to PDF format. Instead hiding it every time whenever I tries to print the document, I have found a way to completely remove it.

MarkupArea

More »

If you have encounters an SQLCeException error during a LINQ operation for example Union on a very large data set, check the error message. If the error message shows something like “The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only.“, then congratulation to you, because you just hit the limit.

The Windows Phone team think any application in phone should not use that much memory, but still some of us might hit this limit. For example like me which required to search through 20,000+ data sets with complicated search conditions. The solution to this problem is pretty simple, add a max database size in the connection string to SQL CE. You will need a complete connection string this time instead of just defind the location of your SQL CE database file.

For example, my connection string before this is as follow:

@"isostore:/CardsDatabase.sdf"

Then after adding the max database size parameter and convert it to a complete connection string, it will become like this:

@"Data Source='isostore:/CardsDatabase.sdf';Max Database Size=64;"

The 64 in the connection string mean I wants to increase the max database size to 64 MB instead of the default value. Hope this little information can help.

by Ooi Keng Siang via Ooiks’s Blog

Sorry for the fix delay. Another quick fix for King Reward sound in Google Chrome. I have enable offline king reward sound on Google Chrome in this version. That mean it can play the sound directly from Google Chrome browser instead of streaming through online. Do tell me if any problem pop up again.

Wish everyone merry Christmas and happy new year. 🙂

 

MouseHunt_AutoBot_Ver_1_28

Script Description

MouseHunt AutoBot is an advance user script to automate sounding the hunter horn in MouseHunt application in Facebook, Hi5 and offside MouseHunt page with MouseHunt version 3.0 (Longtail) supported and many other features. In a simple word, bot for MouseHunt. Time of next hunter horn and trap check will show on the web page title. The time of the next hunter horn will automatically detected without refreshing the page again. Users can customize the script according to their need by themselves such as add extra random time delay before sounding the hunter horn. Users can choose to bot safety with many safety check features which act like a human, or bot aggressively. Part of the script is actually base on Facebook MouseHunt Game Auto Horn Blower.

More »

Recently I saw some of my Facebook friends start spreading a rather weird method to check and see the top 10 Facebook friends who viewed or stalk your Facebook profile. Below are the 2 examples of the method share through out the Facebook. I’m very sure it is a hoax when I first know of it.

So what are those ID use in Facebook? Those are the the Facebook users / friends which will appear in your top Facebook chat list especially those who recently chat with your or send you any Facebook message. It is nothing special. Even if you don’t enable Facebook chat, those ID will be there too.

As of today, I never heard of any method where you can actually track who viewed or stalked your Facebook profile. So don’t caught by those silly hoax that are try to attract your attention by telling you how to track your friends. None of them work!

by Ooi Keng Siang via Ooiks’s Blog