EasyPaisa Pakistan website showing SQL query

Go to EasyPaisa Pakistan and go to EasyPaisa Shop –> Find an Easypaisa Merchant and once you are there, search for something and hit “Submit”

Telenor EasyPaisa "Find an Easypaisa Merchant" search form

Telenor EasyPaisa "Find an Easypaisa Merchant" search form

On the new page with listing, select Control+A or highlight the page with a mouse to see a “debug info” SQL query right there in white text. I really do wish someone does not use the info to plan an SQL injunction

Telenor EasyPaisa "Find an Easypaisa Merchant" search results with SQL query shown on page

Telenor EasyPaisa "Find an Easypaisa Merchant" search results with SQL query shown on page

FULL VIEW - Telenor EasyPaisa "Find an Easypaisa Merchant" search results with SQL query shown on page

FULL VIEW - Telenor EasyPaisa "Find an Easypaisa Merchant" search results with SQL query shown on page

Wateen’s Initial Public Offering

I got this in my mailbox today (since I am a Wateen consumer since Dec 2007)

Dear Valued Customer,

Wateen Telecom is a group company of Abu Dhabi group. Abu Dhabi Group is one of the largest business groups in the Middle East and the one of the largest foreign investor in Pakistan. Abu Dhabi group owns Wateen through Warid Telecom International and Bank Alfalah Limited which hold 79.8% and 20.0% shares respectively.

Wateen’s successful four years of operations in the telecom industry of Pakistan speak for itself, as it successfully deployed the largest commercial and first nationwide 3.5 GHz WiMax network rollout in the world covering 22 cities and 1,100 sites with over 160,000 wireless broadband customers (60% of wireless Broadband market), 12,000 Broadband customers over fiber and 2,700 corporate links (including 26 commercial banks) as well as major GSM and telecom operators as its customers. Wateen Telecom is also the largest operator of satellite services in the country and now offering services to a few telecom operators in Afghanistan. Additionally, optic fiber network spanning over 10,000 KM (7,000 KM deployed and 3,000 KM under deployment) across Pakistan and in all major cities provides a solid backbone for Wateen’s offerings. Wateen also has been acknowledged as the largest alternative LDI operator in Pakistan (with over 1 billion minutes of traffic volume) duly acknowledged by the regulating authority PTA.

Wateen Telecom Limited is now offering 110m shares with an additional Green-shoe option of 90m shares amounting to PKR 2 bn. The IPO will be offered to institutional investors and general public at par value of PKR 10 per share and subscription will be open on 20th & 21st April 2010.

To subscribe, fill the IPO form and submit it to designated banks along with Cheque/PO/Demand Draft in favor of “Initial Public Offering of Wateen Telecom Limited”. Subscription can be made in PKR 5,000 or multiples of it.

Forms and details are available at www.wateen.com, all Wateen Business Centers and Franchise in addition to designated banks or call us at 111-365-365

Best Regards,

Wateen Telecom Limited

The first thought that comes to my mind is … is Wateen really wrapping up?

HashPakistan needs an admin panel

Well, my initial estimates were wrong. I thought I could retweet the posts and Twitter would give me accurate results. The problem is with twitter results. They are giving me wrong and irrelevant results.

Also, when I ask Twitter to only send me “positive” tweets, it sometimes does not mark most of the positive tweets as “positive”, in fact they are not marked at all. So there are the “positive” tweets, “negative” tweets, “questions” and “unknown” (or “unrated”) tweets. A quick look at these tweets and I can see many of them as good ones that should have been retweeted but they were not.

To get over this situation, I need to have an admin panel where I can see statistics and possibly “approve” the negative / unrated tweets.

Having previous experience working in Zend Framework, CakePHP and CodeIgniter, I would prefer to build it in Code Igniter. I will keep this page updated with more info.

Twitter Search gone mad!

Yes, I know what I just said that … its true because my new project HashPakistan is using Twitter Search API to get all posts with hashtag #Pakistan and last night twitter gave it results containing #ashes (and has nothing to do with Pakistan).

I noticed it today and removed those updates from the twitter timeline. Hopefully it does not happen again.

P.S. There are no official words on the Twitter Blog regarding this

Cash Deposit Machine (CDM) or Can’t Deposit Machine? Weird experience

My salary account is HBL (I hate this bank) and I use Dubai Islamic Bank’s services which I am very satisfied with. So last night after work, I thought to move balance from HBL to DIB, tried the inter-bank transfer (which should be great if it is working) but invain. So I went straight to DIB Main Bulevard, Guberg branch.

I took out the cash from one ATM and tried to deposit it via DIB’s CDM (Cash Deposit Machine) into my DIB account. Either the machine was acting weird or the time-waste was inevitable. The machine deposited half my cash and reject the other half. I took a look at the other half that was rejected, the bills were clean and new. I could not find anything with the naked eye so I tried again and the machine rejected all the bills again.

Hmm, what could be wrong, I was asking myself. Then I tried again but this time with different counts, some upside down, some backwards and to my surprize all of the cash was deposited. So next time, if your CDM says Can’t deposit, try straightening the bills and submitting them again using different ways, It will hopefully work. It worked for me 😉

Warid Postpaid Issues – had to MNP my cell number

I moved from Warid to Ufone in April, I forgot to mention that. Thanks to MNP the move was smooth and easy.

Now let me tell you why I moved. First of all, there are billing issues in Postpaid. They have two SMS packages

  • Zoom Limited SMS Package offering 750 messages per month and
  • Zoom Unlimited SMS Package offering 7,500 messages per month

When you activate any of these packages (for the first time) the package is charged double. So e.g. you activate Zoom Unlimited and it costs approx Rs. 300 per month so it will be charged twice, once as ACTIVATION CHARGES and second as monthly charges (WTF!!)

Continue reading