void
FetchAccounts::RefreshPendingList()
{
String sSQL;
sSQL.Format(_T("select * from hm_fetchaccounts where fanexttry <= %s and falocked = 0 and faactive = 1 order by faid asc"), SQLStatement::GetCurrentTimestamp().c_str());
DBLoad_(sSQL);
}
void
RuleActions::Refresh()
{
String sSQL;
sSQL.Format(_T("select * from hm_rule_actions where actionruleid = %I64d order by actionsortorder asc"), rule_id_);
DBLoad_(sSQL);
}
void
RuleCriterias::Refresh()
{
String sSQL;
sSQL.Format(_T("select * from hm_rule_criterias where criteriaruleid = %I64d order by criteriaid asc"), rule_id_);
DBLoad_(sSQL);
}
void
FetchAccounts::Refresh()
{
String sSQL;
sSQL.Format(_T("select * from hm_fetchaccounts where faaccountid = %I64d")
_T(" order by faid asc"), account_id_);
DBLoad_(sSQL);
}
void
Domains::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reads all domains from the database
//---------------------------------------------------------------------------()
{
String sSQL = "select * from hm_domains order by domainname asc";
DBLoad_(sSQL);
}
void
ServerMessages::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reads all SURBL servers from the database.
//---------------------------------------------------------------------------()
{
String sSQL = "select * from hm_servermessages order by smname asc";
DBLoad_(sSQL);
}
void
Domains::Refresh(__int64 iDomainID)
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reads a specific domain from the database.
//---------------------------------------------------------------------------()
{
String sSQL;
sSQL.Format(_T("select * from hm_domains where domainid = %I64d"), iDomainID);
DBLoad_(sSQL);
}
void
GroupMembers::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reads all group members from the database
//---------------------------------------------------------------------------()
{
String sSQL;
sSQL.Format(_T("select * from hm_group_members where membergroupid = %I64d order by memberid asc"), group_id_);
DBLoad_(sSQL);
}
void
ACLPermissions::Refresh()
//---------------------------------------------------------------------------()
// DESCRIPTION:
// Reads all groups form the database
//---------------------------------------------------------------------------()
{
String sSQL;
sSQL.Format(_T("select * from hm_acl where aclsharefolderid = %I64d"), folder_id_);
DBLoad_(sSQL);
}