function setSubscriptionKey($key, $email)
{
global $application;
$tables = Subscriptions::getTables();
$table = 'subscription_guest';
$columns =& $tables[$table]['columns'];
$query = new DB_Replace($table);
$query->addReplaceValue($key, $columns['subscription_key']);
$query->addReplaceValue($email, $columns['email']);
$query->addReplaceValue(time(), $columns['updated']);
$application->db->getDB_Result($query);
}
function initQuery($params)
{
$tables = Subscriptions::getTables();
$table = 'subscription_email';
$columns =& $tables[$table]['columns'];
$atable = 'email_address';
$acolumns =& $tables[$atable]['columns'];
$this->addUsingTable($table);
$this->addUsingTable($atable);
$this->WhereField($columns['email_id'], DB_EQ, $acolumns['email_id']);
$this->WhereAND();
$this->WhereValue($acolumns['email'], DB_EQ, $params['email']);
}
