<?xml version="1.0" encoding="UTF-8"?><!-- generator="wordpress/2.3" -->
<rss version="0.92">
<channel>
	<title>H.S.Rai</title>
	<link>http://hs.raiandrai.com/bg</link>
	<description>FOSS: freedom matters!</description>
	<lastBuildDate>Sun, 05 Sep 2010 10:56:56 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>SUP: Text base mail client</title>
		<description><![CDATA[SUP: Text base email client for persons, who handle a bulk of emails. No annoying graphics, advertisements.
]]></description>
		<link>http://hs.raiandrai.com/bg/2010/09/05/sup-text-base-mail-client/</link>
			</item>
	<item>
		<title>FOSS for GOI supported project for Power Sector</title>
		<description><![CDATA[Subject: IT Implementation in Power Sector via 100% grant by MoP GoI
The Problem
Ministry of Power (MoP)/ Power Finance Corporation (PFC) Govt of India under the XI th Plan has allocated around 10000 crore INR for IT implementation all over India in Power Utilities of State Govts by providing 100% grant to Power Utilities under the [...]]]></description>
		<link>http://hs.raiandrai.com/bg/2009/05/06/foss-for-goi-supported-project/</link>
			</item>
	<item>
		<title>Protected: Aman in India</title>
		<description><![CDATA[There is no excerpt because this is a protected post.]]></description>
		<link>http://hs.raiandrai.com/bg/2009/03/31/aman-in-india/</link>
			</item>
	<item>
		<title>Drupal profile table: SQL query</title>
		<description><![CDATA[SELECT dr1_users.name, dr1_users.mail, dr1_profile_values.value,
dr1_users_roles.rid FROM dr1_users, dr1_profile_values, dr1_users_roles
WHERE dr1_users.uid = dr1_profile_values.uid and  dr1_profile_values.fid = 2
and dr1_users_roles.uid = dr1_users.uid and dr1_users_roles.rid = 3
Database drupal
Prefix dr1_
Table: role
rid     name
2       authenticated user
3       student
4       staff
profile_fields
fid     title
1       Class Roll No
2       Mobile
3       Date of Birth
4       Sex
5       Passout year
profile_values
fid     uid     value
(1-5)
users
uid     name    mail
SELECT dr1_users.name, dr1_users.mail, dr1_profile_values.value FROM
dr1_users, dr1_profile_values WHERE dr1_users.uid = dr1_profile_values.uid
and  dr1_profile_values.fid [...]]]></description>
		<link>http://hs.raiandrai.com/bg/2009/02/09/drupal-profile-table-sql-query/</link>
			</item>
</channel>
</rss>
