/read_full_email_from_db.php

https://github.com/suhastech/pushmail · PHP · 160 lines · 102 code · 36 blank · 22 comment · 13 complexity · 10148ca19110657f7fc071eff7b5000a MD5 · raw file 

    

  1. <?php 
    2. 

  2. include ('common.php');
    3. 

  3. ?>
    4. 

  4. <html>
    5. 

  5.             <head>
    6. 

  6.             <meta name="txtweb-appkey" content="<?php echo $txtwebappkey; ?>" />
    7. 

  7.             </head>
    8. 

  8.             <body>
    9. 

  9. 			<?php
    10. 

  10. 			function callback($buffer)
    11. 

  11. {
    12. 

  12.   // Replace the next line character "\n" with "<br />". The txtweb parses pages as HTML. So, this is needed.
    13. 

  13.   return (str_replace("\n", "<br />", $buffer));
    14. 

  14. }
    15. 

  15. 

  16. ob_start("callback");
    17. 

  17. 			
    18. 

  18. 		if(isset($_GET['id']))
    19. 

  19. {
    20. 

  20. // mysql connect		
    21. 

  21. mysql_connect($dbhost, $dbuser, $dbpassword) or die(mysql_error());
    22. 

  22. 

  23. mysql_select_db($dbname) or die(mysql_error());
    24. 

  24. 

  25. $id = $_GET['id'];
    26. 

  26. 

  27. $result = mysql_query("SELECT * FROM db WHERE id='$id'");
    28. 

  28. // If the required email exists in the table
    29. 

  29. if (mysql_num_rows($result) > 0)
    30. 

  30. {
    31. 

  31. // Gives a "To reply to this email" intent.
    32. 

  32. echo "To reply to this message: <br />";
    33. 

  33. ?>
    34. 

  34. <form class="txtweb-form" action="<?php echo $scriptpath; ?>reply_to_email.php?id=<?php echo $id;?>" method="GET">
    35. 

  35. your-reply-message<input name="reply" type="text" />
    36. 

  36. <input type="submit" value="Submit" />
    37. 

  37. </form>
    38. 

  38. <?php
    39. 

  39. 

  40. $row=mysql_fetch_array($result);
    41. 

  41. 

  42. $mobile = $_GET['txtweb-mobile'];
    43. 

  43. // fetch the Unique identifier to decrypt
    44. 

  44. $togetui = mysql_query("SELECT * FROM users WHERE mobile='$mobile'");
    45. 

  45. $arraytable=mysql_fetch_array($togetui);
    46. 

  46. // Decrypts the email with the Unique Identifier as the key.
    47. 

  47. $email = mysql_aes_decrypt($row['body'],intval($arraytable['ui'] ));
    48. 

  48. 

  49. require_once('class/rfc822_addresses.php');  
    50. 

  50. require_once('class/mime_parser.php');  
    51. 

  51. //create the email parser class  
    52. 

  52. $mime=new mime_parser_class;  
    53. 

  53. $mime->ignore_syntax_errors = 1;  
    54. 

  54. $parameters=array(  
    55. 

  55.     'Data'=>$email,  
    56. 

  56. );  
    57. 

  57.   
    58. 

  58. $mime->Decode($parameters, $decoded);  
    59. 

  59.   
    60. 

  60.   
    61. 

  61. //get the name and email of the sender  
    62. 

  62. $fromName = $decoded[0]['ExtractedAddresses']['from:'][0]['name'];  
    63. 

  63. $fromEmail = $decoded[0]['ExtractedAddresses']['from:'][0]['address'];  
    64. 

  64.   
    65. 

  65. //get the name and email of the recipient  
    66. 

  66. $toEmail = $decoded[0]['ExtractedAddresses']['to:'][0]['address'];  
    67. 

  67. $toName = $decoded[0]['ExtractedAddresses']['to:'][0]['name'];  
    68. 

  68.   
    69. 

  69. //get the subject  
    70. 

  70. $subject = $decoded[0]['Headers']['subject:'];  
    71. 

  71.   
    72. 

  72. $removeChars = array('<','>');  
    73. 

  73.   
    74. 

  74.     
    75. 

  75. //get the message body  
    76. 

  76. if(substr($decoded[0]['Headers']['content-type:'],0,strlen('text/plain')) == 'text/plain' && isset($decoded[0]['Body'])){  
    77. 

  77.   
    78. 

  78.     $body = $decoded[0]['Body'];  
    79. 

  79.   
    80. 

  80. } elseif(substr($decoded[0]['Parts'][0]['Headers']['content-type:'],0,strlen('text/plain')) == 'text/plain' && isset($decoded[0]['Parts'][0]['Body'])) {  
    81. 

  81.   
    82. 

  82.     $body = $decoded[0]['Parts'][0]['Body'];  
    83. 

  83.   
    84. 

  84. } elseif(substr($decoded[0]['Parts'][0]['Parts'][0]['Headers']['content-type:'],0,strlen('text/plain')) == 'text/plain' && isset($decoded[0]['Parts'][0]['Parts'][0]['Body'])) {  
    85. 

  85.   
    86. 

  86.     $body = $decoded[0]['Parts'][0]['Parts'][0]['Body'];  
    87. 

  87.   
    88. 

  88. }  
    89. 

  89. if (isset($body))
    90. 

  90. {
    91. 

  91. //get rid of any quoted text in the email body  
    92. 

  92. $body_array = explode("\n",$body);  
    93. 

  93. $message = "";  
    94. 

  94. foreach($body_array as $key => $value){  
    95. 

  95.   
    96. 

  96.     //remove hotmail sig  
    97. 

  97.     if($value == "_________________________________________________________________"){  
    98. 

  98.         break;  
    99. 

  99.   
    100. 

  100.     //original message quote  
    101. 

  101.     } elseif(preg_match("/^-*(.*)Original Message(.*)-*/i",$value,$matches)){  
    102. 

  102.         break;  
    103. 

  103.   
    104. 

  104.     //check for date wrote string  
    105. 

  105.     } elseif(preg_match("/^On(.*)wrote:(.*)/i",$value,$matches)) {  
    106. 

  106.         break;  
    107. 

  107.   
    108. 

  108.     //check for From Name email section  
    109. 

  109.     } elseif(preg_match("/^On(.*)$fromName(.*)/i",$value,$matches)) {  
    110. 

  110.         break;  
    111. 

  111.   
    112. 

  112.     //check for To Name email section  
    113. 

  113.     } elseif(preg_match("/^On(.*)$toName(.*)/i",$value,$matches)) {  
    114. 

  114.         break;  
    115. 

  115.   
    116. 

  116.     //check for To Email email section  
    117. 

  117.     } elseif(preg_match("/^(.*)$toEmail(.*)wrote:(.*)/i",$value,$matches)) {  
    118. 

  118.         break;  
    119. 

  119.   
    120. 

  120.     //check for From Email email section  
    121. 

  121.     } elseif(preg_match("/^(.*)$fromEmail(.*)wrote:(.*)/i",$value,$matches)) {  
    122. 

  122.         break;  
    123. 

  123.   
    124. 

  124.     //check for quoted ">" section  
    125. 

  125.     } elseif(preg_match("/^>(.*)/i",$value,$matches)){  
    126. 

  126.         break;  
    127. 

  127.   
    128. 

  128.     //check for date wrote string with dashes  
    129. 

  129.     } elseif(preg_match("/^---(.*)On(.*)wrote:(.*)/i",$value,$matches)){  
    130. 

  130.         break;  
    131. 

  131.   
    132. 

  132.     //add line to body  
    133. 

  133.     } else {  
    134. 

  134.         $message .= "$value\n";  
    135. 

  135.     }  
    136. 

  136.   
    137. 

  137. }  
    138. 

  138.   
    139. 

  139. echo "$message";  
    140. 

  140. }
    141. 

  141. 

  142. else
    143. 

  143. {
    144. 

  144. echo "Sorry, no plain text part, here.";
    145. 

  145. }
    146. 

  146. }
    147. 

  147. else
    148. 

  148. 

  149. {
    150. 

  150. echo "Sorry, email couldn't be found. Emails will be pruned after 24 hours from our database.";
    151. 

  151. }
    152. 

  152. }
    153. 

  153. 

  154. ob_end_flush();
    155. 

  155. 

  156. 			
    157. 

  157. 			?>
    158. 

  158. 			
    159. 

  159. </body>
    160. 

  160. </html>
    161.