sql php sms parse

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • maconbot
    New Member
    • Feb 2008
    • 1

    sql php sms parse

    hi all, please exuse my email ">" i am working on location.

    > hey team, thanks for the quick reply.
    >
    > i am trying to parse a pop3 account and populate it into flash.
    >
    > the how to code...
    > http://www.derickrethans.nl/parsing_mail_with_php.php
    >
    > - is this the class? i am really confused how to plug this into my
    > hosting account. i am already using php and sql to dynamically update
    > flash.
    >
    > here is what should be the only 2 php scripts i need, from what i "assume"
    > one is a class property, and the second calls it up and defines it? i
    > just don't know how to plug it in???
    [php]
    > <?php
    > /*
    > Sample File not more !!!
    > Author: Jointy <bestmischmaker @web.de>
    >
    > Please read Readme.txt !!!
    > */
    >
    > require("pop3.c lass.inc");
    >
    > // Constructor
    > // optional
    > $apop_detect = TRUE; // default = FALSE
    > $log = TRUE; // default = FALSE
    > $log_file = "pop3.class.log "; // must be set when $log = TRUE !!!
    > $qmailer = FALSE;
    >
    >
    > // func $pop3->connect()
    > $server = "pop.lycos. de";
    > // optional !!
    > // $port = "110";
    > // $conn_timeout = "25"; // Connection Timeout
    > // $sock_timeout = "10,500"; // Socket Timeout
    >
    > // func $pop3->login()
    > $username = "";
    > $password = "";
    > // optional
    > //$apop = "0";
    >
    > // MySQL Vars for connect to DB Server
    > $db["addr"] = "localhost" ;
    > $db["user"] = "";
    > $db["pass"] = "";
    > $db["link"] = FALSE;
    > $db["use"] = "mail";
    > // optional
    > $db["dir_table"] = "inbox"; // Table for header data
    > $db["msg_table"] = "messages"; // Table for complete Messages (/w
    > header)...
    >
    >
    > // Your own free Vars
    > // Save to MySQL ??
    > $savetomysql = TRUE;
    > $savetofile = TRUE;
    > $delete = FALSE;
    >
    >
    >
    >
    >
    >
    > $pop3 = new POP3($log,$log_ file,$apop_dete ct);
    >
    > if($pop3->connect($serve r)){
    > if($pop3->login($usernam e,$password)){
    > if(!$msg_list = $pop3->get_office_sta tus()){
    > echo $pop3->error;
    > return;
    > }
    > }else{
    > echo $pop3->error;
    > return;
    > }
    > }else{
    > echo $pop3->error;
    > return;
    > }
    >
    > $db["link"] = mysql_connect($ db["addr"],$db["user"],$db["pass"]) or
    > die(mysql_error ());
    > mysql_select_db ($db["use"],$db["link"]) or die(mysql_error ());
    >
    > $noob = TRUE;
    >
    > for($i=1;$i<=$m sg_list["count_mail s"];$i++){
    > if(!$header = $pop3->get_top($i)) {
    > echo $pop3->error;
    > }
    > // Get Message ID and set $unique_id for save2file()
    > $g = 0;
    > while(!ereg("</HEADER>",$heade r[$g])){
    > if(eregi("Messa ge-ID",$header[$g])){
    > $unique_id = md5($header[$g]);
    > }
    > $g++;
    > }
    > unset($g);
    >
    > $query = 'SELECT `unique_id` FROM `'.$msg_table.' ` WHERE 1 AND
    > `unique_id` = \''.$unique_id. '\' LIMIT 0, 1';
    > $result = mysql_query($qu ery,$db["link"]) or die(mysql_error ());
    >
    > if($rows = mysql_fetch_arr ay($result)){
    > $get_msg = FALSE;
    > $savetofile = FALSE;
    > $savetomysql = FALSE;
    >
    > }
    > mysql_free_resu lt($result);
    > unset($rows);
    >
    > if($get_msg){
    > if(!$message = $pop3->get_mail($i, $qmailer)){
    > echo $pop3->error;
    > $savetofile = FALSE;
    > $savetomysql = FALSE;
    > $delete = FALSE;
    > }
    > }
    >> if($savetofile) {
    >
    >
    >
    > $filename = ".//mails//".$unique_id.". txt";
    >
    > if(!is_file($fi lename)){
    > if(!$filesize = $pop3->save2file($mes sage,$filename) ){
    > echo $pop3->error;
    > return;
    > }else{
    > echo "File saved to ".$filename ." (".$filesize ." Bytes written)
    > !! \r\n <br>";
    > }
    > }else{
    > echo "File <b>(".$filename .")</b> already exists. !! \r\n
    > <br>";
    > }
    > }
    >
    > // Save to MySQL
    > if($savetomysql ){
    >
    > if($count_bytes =
    > $pop3->save2mysql($me ssage,$db["link"],$db["dir_table"],$db["msg_table"])){
    > echo "File save to MySQL complete. (".$count_bytes ." Bytes
    > written) !! \r\n <br>";
    > }else{
    > echo $pop3->error;
    > return;
    > }
    > }
    >
    > // Send Noob command !!
    > if($noop){
    > if(!$pop3->noop()){
    > echo $pop3->error;
    > $noob = FALSE;
    > }
    > }
    >
    > // Delete MSG
    > if($delete){
    > if($pop3->delete_mail($i )){
    > echo "Nachricht als gelöscht markiert !!! \r\n <br>";
    > }else{
    > echo $pop3->error;
    > }
    > }
    >
    > }
    > if($msg_list["count_mail s"] == "0"){
    > echo "Keine neuen Nachrichten !!";
    > }
    >
    > mysql_close($db["link"]);
    > $pop3->close();
    >
    > ?>
    > _______________ _______________ __________
    >> <?php
    > require_once "ezc/Base/base.php";
    > function __autoload( $className )
    > {
    > ezcBase::autolo ad( $className );
    > }
    > $pop3 = new ezcMailPop3Tran sport( "pop3.example.c om" );
    > $pop3->authenticate ( "user", "password" );
    > $set = $pop3->fetchAll();
    > $parser = new ezcMailParser() ;
    > $mails = $parser->parseMail( $set );
    > foreach ( $mails as $mail )
    > {
    > echo "From: {$mail->from->email}\n";
    > echo "To: ";
    > foreach ( $mail->to as $to ) {
    > echo "{$to->name} ({$to->email}) ";
    > }
    > echo "\n";
    > echo "Subject: {$mail->subject}\n";
    > switch ( get_class( $mail->body ) )
    > {
    > case 'ezcMailText':
    > echo "Text part, ".
    > "type={$mai l->body->subType}\n--\n";
    > echo $mail->body->text;
    > echo "\n--\n";
    > break;
    > case 'ezcMailMultipa rtMixed':
    > echo "Multipart mail\n";
    > break;
    > }
    > echo "\n";
    > }
    > ?>
    >
    >> flash code:
    >
    >
    > //Create the URLLOader instance
    > var myLoader:URLLoa der = new URLLoader()
    > //the data will come as URL-encoded variables
    > myLoader.dataFo rmat = URLLoaderDataFo rmat.VARIABLES
    > //Load using an URLRequest. If you use some other back-end
    > //language like java or aspx, you just modify the call, i.e
    > // myLoader.load(n ew URLRequest("ana stasio.aspx"))
    > myLoader.load(n ew URLRequest("./scripts/text_10/jg_X_IDs.php"))
    > //onLoad handler listener
    > myLoader.addEve ntListener(Even t.COMPLETE, onDataLoad)
    > //Error handling
    > myLoader.addEve ntListener(IOEr rorEvent.IO_ERR OR, onIOError)
    > myLoader.addEve ntListener(Secu rityErrorEvent. SECURITY_ERROR,
    > onSecurityError )
    > //Could be an error or just a message
    > myLoader.addEve ntListener(HTTP StatusEvent.HTT P_STATUS, onHTTPStatus)
    > //add a listener for the complete event
    > function onDataLoad(evt: Event){
    > for(var i:uint=0; i<evt.target.da ta.cant; i++){
    > this["Title_0"+i]Text = evt.target.data["Title"+i]}
    >
    >
    > //populates it into dynamic text boxes. with instance names.
    >[/php]
    > _______________ _______________ __________
    >>
    > questions:
    > Mail component php? - how do i use this and interact with flash?
    >
    > a simple explination of ez Components would be a great help too...can i
    > plug this stuff into godaddy and reference it the same way i use classes
    > in flash? only with this code php...
    >
    > require("pop3.c lass.inc");
    > - http://ezcomponents.org/docs/api/1.0...tion_Mail.html
    >
    >
    > i would be happy at this point to just get the php to hold my data and
    > have flash pull it and post the whole raw sms code onto the stage.
    >
    > or do i have to install it, and use pearl, or pear in some way - i hope
    > not? because i have no idea what that means.
    >
    > i have two php files. that should be able to pull this off, however i
    > don't understand classes with php and if it can work on my linux shared
    > hosting account or if i need to setup a different account with another
    > hosting company. it should work because it doesn't require root access
    > for this.
    >
    > or if i need to setup a gsm modem, and a whole sms gateway server, blah,
    > blah. I think we can just do this with php parsing a pop3 and flash
    > pulling those values. eventually transfering to a sql database is ideal,
    > but probably out of your teams scope of help.
    >> basically i am trying to read email from flash. any free pop3 account
    > would work, or if you prefer i am hosted with godaddy.
    >
    > more definitive: recieve an sms message, and transfer the body, date, time
    > to a sql server. I know this is php, but i already have most of the
    > research done. please help! and bottom line i am looking to pull into
    > flash. i hope you can help.
    >
    > i believe i have all of the language i need, now just the question of how
    > to make it work.
    Last edited by ronverdonk; Feb 20 '08, 04:15 PM. Reason: enclosing code within code tags
  • ronverdonk
    Recognized Expert Specialist
    • Jul 2006
    • 4259

    #2
    Urgent: please enclose any code within the proper code tags. See the Posting Guidelines on how to do that.

    moderator

    Comment

    Working...