function emailUser($to, $subject, $message)
{
$to = is_array($to) ? array_unique($to) : array($to);
//dev limiting
if ($limit = getOption('email_limit')) {
$to = array_intersect($limit, $to);
}
//do a little maintenance
if (!($tocount = count($to))) {
return false;
}
for ($i = 0; $i < $tocount; $i++) {
if (empty($to[$i])) {
unset($to[$i]);
} elseif (url_tld() == 'site' && !in_array($to[$i], array('*****@*****.**', '*****@*****.**', '*****@*****.**', '*****@*****.**'))) {
unset($to[$i]);
}
}
if (!($tocount = count($to))) {
return false;
}
//repeat subject and basic formatting
$message = '<div style="font-family:Verdana;font-size:11px;line-height:17px;"><h1 style="font-weight:normal;font-size:20px;margin:0px 0px 10px 0px">' . $subject . '</h1>' . $message . '</div>';
//send
$result = email($to, $message, $subject);
//keep a record
foreach ($to as $t) {
db_query('INSERT INTO emails ( address, subject, message, created_date, created_user, was_sent ) VALUES (
\'' . $t . '\',
\'' . format_quotes($subject) . '\',
\'' . format_quotes($message) . '\',
GETDATE(),
' . user('NULL') . ',
' . format_boolean($result, '1|0') . '
)');
}
return $result;
}
<Cell ss:StyleID="s34"><Data ss:Type="Number">' . $r["tagcount"] . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagAsset"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagComFin"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagEconDev"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagFunders"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagTech"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagWorkforce"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagHigherEd"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagForProfit"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagGovt"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagMedia"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagNonProfit"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagVendor"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagSeedcoBoard"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagSFSBoard"]) . '</Data></Cell>
<Cell ss:StyleID="s36"><Data ss:Type="String">' . format_boolean($r["tagImported"]) . '</Data></Cell>
</Row>
';
}
$return .= '
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<Print>
<ValidPrinterInfo/>
<HorizontalResolution>600</HorizontalResolution>
<VerticalResolution>600</VerticalResolution>
</Print>
<Selected/>
<FreezePanes/>
<FrozenNoSplit/>
<SplitHorizontal>1</SplitHorizontal>
