function unsubscribeTempEmails($key, $topics_ids) { global $application; if (empty($topics_ids)) { return; } $tables = Subscriptions::getTables(); $etable = 'subscription_email'; $ecolumns =& $tables[$etable]['columns']; $ttable = 'subscription_temp'; $tcolumns =& $tables[$ttable]['columns']; $dquery = new DB_Delete($etable); $dquery->addUsingTable($etable); $dquery->addUsingTable($ttable); $dquery->WhereValue($tcolumns['action_key'], DB_EQ, $key); $dquery->WhereAND(); $dquery->Where($ecolumns['topic_id'], DB_IN, DBQuery::arrayToIn($topics_ids)); $dquery->WhereAND(); $dquery->WhereField($ecolumns['email_id'], DB_EQ, $tcolumns['email_id']); $application->db->getDB_Result($dquery); }