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>