Getting Drupal to stream video using PHP and the FlashVideo module to manage video uploads is not easy. It involves 5 distinct pieces of software, which means 5 places where things could go wrong with little error logging.

Here's what you need:
1. FlashVideo http://drupal.org/project/flashvideo
2. ffmpeg
3. flvtool2
4. xmoov-php
5. JW Player

Attachments: 

656-2178-legoshay_656.flv

stream.php_.txt

flashvideo_streaming.patch

There's been a lot of talk about the decrease in quality of Google search results over the years due to spammers / content farms with strong SEO skills. I'm glad I'm not the one who's been annoyed by this.

Google should know which sites are spam, content farms, or duplicated content. That they aren't properly filtering or demoting them could be due to a conflict of interest - they make money from the ads on those crap sites.

But we, as individuals, can easily distinguish the spam results from the quality ones and we do so everyday. If only there were a way to stop duplicating this effort.

If Google won't do this for us, then we can do this ourselves.

Here's what I want:
1. When I've been tricked into opening an ad-filled page without meaningful content, I want to go back to Google and mark that link as "spam", have that noted somewhere in the cloud so I can access it from any computer, and have future search queries filter out that link.

2. I probably don't want to see any pages from that domain show up on any other queries.

3. I probably don't want to see any pages that my friends have also marked as spam.

4. I probably don't want to see any pages that friends of my friends have also marked as spam.

5. I may even want to befriend / "follow" strangers just because they're good at marking spam.

If, after upgrading from an old version of Pligg to 1.1.2, you notice that the front page is sorted completely backwards and you can't change the sorting even by fiddling with the sort-query code in index.php, it may be because of the new Groups feature. A new groups table has been added and all queries join this table but the Pligg upgrader only creates the table and sets the new link_group_id to 0 for all rows in links. The solution is to populate the groups table. An easy way is to head to groups/submit/ and create a generic catchall group. Then in your database, change the group_id for the newly created row in groups to 0 (if it's 1).

If the Pligg group submitter is broken (as Pligg is prone to be buggy) then just:
INSERT INTO groups (group_id) VALUES (1);

Now those queries like:

SELECT link_id FROM links LEFT JOIN groups ON links.link_group_id = groups.group_id WHERE link_status='published' AND (groups.group_privacy!='private' OR ISNULL(groups.group_privacy) OR groups.group_id IN(1)) GROUP BY link_id ORDER BY link_published_date DESC, link_date DESC LIMIT 0,10

will work again!

For some time now, ISPs in Vietnam have been blocking a small number of websites, particularly Facebook. Fortunately, the number of blocked sites was really small (in China hundreds of sites are blocked) and the method of blocking traffic to Facebook was very weak. The Vietnamese ISPs simply stopped returning DNS queries for the Facebook domain. So everyone soon figured out they could simply change their computer's DNS settings to use a non-blocking DNS server, such as Google's (8.8.8.8).

I'm hearing rumors now, while I'm traveling in Europe, that Vietnamese ISPs have really cracked down on access to Facebook and that the DNS trick no longer works.

So here are some more foolproof ways to get around the Facebook block in Vietnam which will also work for any website that is blocked in any country. For example, the Great Firewall of China blocks access to an ever-changing list of sites by more than just DNS. But these methods should work there too.

An added advantage is that you may also be able to access US sites that block all non-US computers like Hulu and certain YouTube videos.

1. Pay for VPN access outside of Vietnam. This is essentially what I do by renting a server in the US, but I only tunnel my web traffic over an ssh connection. If anyone wants a shell on my server for tunneling purposes (and not downloading porn) contact me.

Setting up SSH is a bit quirky so most people are better off with a true VPN solution.

One that comes recommended is StrongVPN. By going with them you'll get full support and they show you how to set it all up.

2. Install free but ad-supported Hotspot Shield

From their site:

Secure your web session, data, online shopping, and personal information online with HTTPS encryption.
Protect yourself from identity theft online.
Hide your IP address for your privacy online.
Access all content privately without censorship; bypass firewalls.
Protect yourself from snoopers at Wi-Fi hotspots, hotels, airports, corporate offices.

You may want to install ad blockers if you go this route. They will also track information about you to sell to advertisers.

3. Proxy servers.

Pick a proxy server from http://www.xroxy.com/ and set your browser to use it without needing to buy or install anything. You don't need to use a proxy server in Vietnam, in fact it's probably better not to.

In a pinch you can browse through a "CGI proxy" like http://12345proxy.com/ without having to set up anything.

Using a proxy server could slow down access to some websites, especially ones in Vietnam. You can install some browser add-ons so that you only go through a proxy for the sites that are blocked, like Facebook.

For Google Chrome:
Proxy Switchy: https://chrome.google.com/extensions/detail/caehdcpeofiiigpdhbabniblemipncjj

For FireFox:
FoxyProxy: https://addons.mozilla.org/en-US/firefox/addon/2464/

4. Just for watching videos on sites like Hulu, Amazon Video on Demand, Pandora, or YouTube, you can try http://www.usvideo.ca/ although it costs $5.25/month.