Stream publish is one of the vital issue in facebook application or facebook connect base application. If you want to publish stream from your facebook application or facebook page application then you have to call

Facebook.streamPublish();

method with some parameters. If you want to publish from facebook connect base application then you have to call

FB.Connect.streamPublish()

with some parameters. One of the important parameter is the second parameter named attachment. Using this parameter you can add video, flash, text etc. This parameter actually is an object that contains text information, caption and other media like flash, music. But in text information that is called description you couldn’t use html. But suppose you have a quiz application and when user will publish stream you want some questions and answers will publish nicely. like this

Continue

Two months ago, I developed a facebook photo gallery which is FBConnect, php, facebook api and Jquery based. Today I released the full project as open source GPL license. So you can download the full project, modify and create derivative products for your own purpose or commercial usage.

Checkout the demo of the project http://thinkdiff.net/facebook/fblatestphotos

So basically the concept of the project is simple. If you visit this app, you’ll see the latest photos from your friends in facebook. On the left side it shows which albums are recently modified. When you click the album you’ll see all the photos of that album.

Open Source Facebook Photo Gallery

Continue

Sometimes you may need auto suggest feature for your application. And its very easy to implement in facebook application because facebook provides a FBML code for this purpose.

For example, in this post I’ll show how to auto suggest state to your users by your facebook application.

This article is for advanced user who know how to manage hosting either shared hosting or virtual private hosting. Normally if you bought a shared hosting you’ll see a control panel named cpanel in most hosting service provider. cpanel is very popular and user friendly. Now think you want to buy a unmanaged VPS. Why unmanaged because if you bought a managed VPS it will cost almost double than unmanaged VPS. So I prefer unmanaged VPS for myself as cost is almost half. And its not too difficult to manage a VPS.

In this post, I’ll show you how could you easily manage your VPS hosting using Virtualmin and Webmin web server control panel. Virtualmin has 2 types of license one is professional, which you have to buy and another is GPL license which is free.

Continue

Actually this is not a big or complex post. I am a part time ActionScript 3.0 developer and recently in my company i2we, inc. I developed a customized jobs search widget for them. Where one of the criteria was when we include flash object in html, we can provide external parameter. Based on the parameter the flash widget customize its result.

So in this post, I will show how you can pass parameter from html and get them in your flash object. Please keep in mind that my code is based on ActionScript 3.0

Continue

Some days ago one of my senior brother give me the link of this awesome free software. My brother used it to visual design a book, chapters, topics. Its such a wonderful software that you can easily draw and present your thinking as a nice way.

If you’re a project manager you can easily draw your projects so that your developers can easily understand what they need to do. If you’re a web developer you can also design your web applications so that other developers can easily understand about the features and modules.

So lets look at the features of this tool:
Continue

Now a days most popular sites provide api so that we integrate in our site to create mash-up application. Linkedin recently published their own apis. So now we can integrate linkedin apis in our site. So why we should integrate linkedin api:

1. Users can bring linkedin profile and network in your site
2. There are 52 millions users in linkedin so you can engage them in your site
3. You may create authentication through linkedin api so that user don’t need to register in your site
4. You can search profile, connection
5. Users can also update their status from your site using linkedin apis
6. And many more…

Continue

Sometimes short message posting looks far better than a long posting. For this purpose you can use twitter or facebook fan page. Facebook fan page is better than twitter in one sense is that, you can attach video, image and  your message could be long than twitter. Though we use fan page or twitter to inform our friends or connection about our status or some news.

If you want a twitter and facebook fan page like features for your own purpose,  where you can publish full post or short message, attach image/video whatever then you can use wordpress and p2 theme.  P2 theme is excellent. You can also use p2 theme as group blog for short update.

Continue

In my previous article I’ve shown how to get rank using mysql query. Now I’m showing how to retrieve result based on today, week and month using mysql query. Actually I also implemented this in my quiz project so I’m sharing this with you.

For the table structure please look my previous article http://thinkdiff.net/mysql/how-to-get-rank-using-mysql-query/

Task 1: I’ve to retrieve those users rank who played the game today.
Solution: Look at the query

SELECT uid, participated, correct, wrong from quiz_user
    WHERE DAYOFMONTH(CURDATE())=extract(day from updated)
    ORDER BY correct DESC, participated ASC
    limit 30

Continue

Some days ago I was working in a quiz project. Where user will play quiz and for each correct answer they will earn points. One of the task of this quiz application was, to get rank of a particular user. Now I am showing how could I solve this problem using mysql query.

Here is the table structure:

CREATE  TABLE IF NOT EXISTS `quiz_user` (
`uid` BIGINT UNSIGNED NOT NULL ,
`participated` SMALLINT UNSIGNED NULL DEFAULT 0 ,
`correct` SMALLINT UNSIGNED NULL DEFAULT 0 ,
`wrong` SMALLINT UNSIGNED NULL DEFAULT 0 ,
`created` DATETIME NULL ,
`updated` DATETIME NULL ,
PRIMARY KEY (`uid`) )
ENGINE = InnoDB

Continue