function rss_getItems($local = '') { $xml = ''; srand(time()); db_connect(); if (!db_isConnected()) { return xml; } $mails = db_getMailsOf($local . '@pookmail.com', $false); while ($e = array_pop($mails)) { $xml .= "<item>\n"; $xml .= "<title>" . $e['subject'] . "</title>\n"; $xml .= "<guid>" . $e['subject'] . "</guid>\n"; $xml .= "<link>http://www.pookmail.com/mailbox.php?email=" . $local . "&sid=" . md5(rand()) . "</link>\n"; $xml .= "<description>" . $e['from'] . "</description>\n"; //$xml .= "<pubDate>".date("D, j M Y H:i:s Z" , $e['date'])."</pubDate>\n"; $xml .= "<pubDate>" . date("r", $e['date']) . "</pubDate>\n"; $xml .= "</item>\n"; } db_close(); return $xml; }
function db_getEmailAddressByID($mid) { global $__db; $email = ""; if ($mid == "" || is_null($mid)) { return $email; } // porsi las moscas .... hay q mejorar esta proteccion ... $mid = trim($mid); //if ( strlen($mid) != 32 ) { $mid = "no existe fijo"; } if (strlen($mid) != 32) { return $email; } if (!db_isConnected()) { db_connect(); } if (!db_isConnected()) { return $email; } $sql = "select rcpt FROM mail WHERE filename_md5 = '" . $mid . "';"; // echo $sql . "<br>"; $res = mysql_query($sql, $__db); if ($e = mysql_fetch_row($res)) { $email = $e[0]; // echo "EMAIL: ". $email ."]"; } return $email; }