Custom Badges

So I'm taking a stab at Custom Badges because well... I kinda need them... :-\

Anyways I wanna know if I'm doing it right... There is a DB ID called plan_id for OS Membership Pro component, when someone purchases a membership they go into this table with the selected membership plan ID

	require_once( JPATH_ROOT . '/administrator/components/com_easysocial/includes/foundry.php' );

	public function assignBadge( $rule , $message , $creatorId = null )

	{

		$planId = JRequest::getInt('plan_id');



		if ($planId => 1)

		{

			Foundry::badges()->log( 'com_osmembership' , 'loose_cannon.donation' , $userId , JText::_( 'Obtained Loose Cannon Donation' ) );

		}

	}

and this would be the .badge file code I'm guessing..

[

	{

		"title" 		: "Loose Cannon",

		"alias"			: "loose-cannon",

		"description"	: "Getting the sheer enjoyment helping .Org",

		"howto" 		: "To unlock this badge, you need to donate $10.00 or more.",

		"command"		: "loose_cannon.donation",

		"extension"		: "com_osmembership",

		"avatar"		: "media/badges/loose_cannon.png",

		"frequency"		: 1

	}

]

So am I doing this right? I haven't tried it yet but I'm just looking for a little direction. I got the php stuff from one of the OS Membership Pros subscribers.php file which looks like this

class OSMembershipControllerSubscribers extends OSController

{



	function export()

	{

		$config = OSMembershipHelper::getConfig();

		$db = JFactory::getDbo();

		$planId = JRequest::getInt('plan_id');

		$published = JRequest::getInt('published', -1);

		$where = array();

		if ($planId > 0)

		{

			$where[] = ' a.plan_id=' . $planId;

		}

		if ($published != -1)

		{

			$where[] = ' a.published=' . $published;

		}

		$sql = 'SELECT a.*, b.username, c.title FROM #__osmembership_subscribers AS a

				LEFT JOIN #__users AS b

				ON a.user_id = b.id

				LEFT JOIN #__osmembership_plans AS c

				ON a.plan_id = c.id 							

			';

		if (count($where))

		{

			$sql .= ' WHERE ' . implode(' AND ', $where);

		}

		$db->setQuery($sql);

		$rows = $db->loadObjectList();

		for ($i = 0, $n = count($rows); $i < $n; $i++)

		{

			$row = $rows[$i];

			switch ($row->published)

			{

				case 0:

					$row->subscription_status = JText::_('OSM_PENDING');

					break;

				case 1:

					$row->subscription_status = JText::_('OSM_ACTIVE');

					break;

				case 2:

					$row->subscription_status = JText::_('OSM_EXPIRED');

					break;

				case 3:

					$row->subscription_status = JText::_('OSM_CANCELLED_PENDING');

					break;

				case 4:

					$row->subscription_status = JText::_('OSM_CANCELLED_REFUNDED');

					break;

				default:

					$row->subscription_status = '';

					break;

			}

		}

		

		$sql = 'SELECT name, title FROM #__osmembership_plugins';

		$db->setQuery($sql);

		$plugins = $db->loadObjectList();

		$pluginTitles = array();

		foreach ($plugins as $plugin)

		{

			$pluginTitles[$plugin->name] = $plugin->title;

		}

		//Get list of custom fields

		$sql = 'SELECT id, name, title, is_core FROM #__osmembership_fields WHERE published=1 ORDER BY ordering';

		$db->setQuery($sql);

		$rowFields = $db->loadObjectList();

		

		$customFieldDatas = array();

		if (count($where))

		{

			$sql = 'SELECT * FROM #__osmembership_field_value WHERE subscriber_id IN (SELECT id FROM #__osmembership_subscribers AS a WHERE ' .

				 implode(' AND ', $where) . ')';

			}

			else

			{

				$sql = 'SELECT * FROM #__osmembership_field_value';

			}

			$db->setQuery($sql);

			$fieldDatas = $db->loadObjectList();

			if (count($fieldDatas))

			{

				foreach ($fieldDatas as $fieldData)

				{

					$customFieldDatas[$fieldData->subscriber_id][$fieldData->field_id] = $fieldData->field_value;

				}

			}

			if (count($rows))

			{

				$results_arr = array();

				$results_arr[] = JText::_('OSM_PLAN');

				$results_arr[] = JText::_('Username');

				foreach ($rowFields as $rowField)

				{

					$results_arr[] = $rowField->title;

				}

				$results_arr[] = JText::_('OSM_SUBSCRIPTION_START_DATE');

				$results_arr[] = JText::_('OSM_SUBSCRIPTION_END_DATE');

				$results_arr[] = JText::_('OSM_SUBSCRIPTION_STATUS');

				$results_arr[] = JText::_('OSM_DISCOUNT_AMOUNT');

				$results_arr[] = JText::_('OSM_TAX_AMOUNT');

				$results_arr[] = JText::_('OSM_GROSS_AMOUNT');

				$results_arr[] = JText::_('OSM_PAYMENT_METHOD');

				$results_arr[] = JText::_('OSM_TRANSACTION_ID');

				

				$csv_output = "\"" . implode("\",\"", $results_arr) . "\"";

				

				foreach ($rows as $r)

				{

					$results_arr = array();

					$results_arr[] = $r->title;

					$results_arr[] = $r->username;

					foreach ($rowFields as $rowField)

					{

						if ($rowField->is_core)

						{

							$fieldName = $rowField->name;

							$results_arr[] = $r->{$fieldName};

						}

						else

						{

							$fieldId = $rowField->id;

							$results_arr[] = @$customFieldDatas[$r->id][$fieldId];

						}

					}

					$results_arr[] = JHtml::_('date', $r->from_date, $config->date_format);

					$results_arr[] = JHtml::_('date', $r->to_date, $config->date_format);

					$results_arr[] = $r->subscription_status;

					$results_arr[] = round($r->discount_amount, 2);

					$results_arr[] = round($r->tax_amount, 2);

					$results_arr[] = round($r->gross_amount, 2);

					$results_arr[] = $pluginTitles[$r->payment_method];

					$results_arr[] = $r->transaction_id;

					$csv_output .= "\n\"" . implode("\",\"", $results_arr) . "\"";

				}

				$csv_output .= "\n";

				if (ereg('Opera(/| )([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT']))

				{

					$UserBrowser = "Opera";

				}

				elseif (ereg('MSIE ([0-9].[0-9]{1,2})', $_SERVER['HTTP_USER_AGENT']))

				{

					$UserBrowser = "IE";

				}

				else

				{

					$UserBrowser = '';

				}

				$mime_type = ($UserBrowser == 'IE' || $UserBrowser == 'Opera') ? 'application/octetstream' : 'application/octet-stream';

				$filename = "order_list";

				@ob_end_clean();

				ob_start();

				header('Content-Type: ' . $mime_type);

				header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');

				if ($UserBrowser == 'IE')

				{

					header('Content-Disposition: attachment; filename="' . $filename . '.csv"');

					header('Cache-Control: must-revalidate, post-check=0, pre-check=0');

					header('Pragma: public');

				}

				else

				{

					header('Content-Disposition: attachment; filename="' . $filename . '.csv"');

					header('Pragma: no-cache');

				}

				print $csv_output;

				exit();

			}

		}

	}