| Author |
|
AIWEB
Groupie
Joined: 19 October 2010
Location: United States
Online Status: Offline
Posts: 54
|
| Posted: 19 January 2011 at 1:44pm | IP Logged
|
|
|
Hello, I would like to know where, and if, I could change the body_text format for messages stored in the
database.
I refer back to these emails for other areas in my application, and instead of printing the MIME decoded
message file on server, I just print the database records information. Problem is, everything has been
stripped and strtolowered and everything.
Is there a way I can preserve the capital letters and line-breaks? To keep the message looking semi-
original.
I figure this is probably for searching? Or optimization of database calls?
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Online
Posts: 6104
|
| Posted: 20 January 2011 at 1:41am | IP Logged
|
|
|
I can get some guidelines from our dev team on this. For that, I need to know whether you use PHP or ASP.NET edition.
Information on the protocol (IMAP/POP3) and sync.mode mostly used might be helpful as well.
Data stored there is indeed used for search purposes only, so if you modify the way it's stored there, search itself
will be affected, it and would only find exact text occurences considering every whitespace and character case.
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
AIWEB
Groupie
Joined: 19 October 2010
Location: United States
Online Status: Offline
Posts: 54
|
| Posted: 24 January 2011 at 6:55am | IP Logged
|
|
|
That would be great!
I am using PHP and almost always POP3.
If I could change that and utilize MySQL's LIKE function with wildcards it should ignore case at least. I don't
think I would need any more help that ignoring case on search.
Thanks much!
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Online
Posts: 6104
|
| Posted: 25 January 2011 at 3:18am | IP Logged
|
|
|
The code responsible for all this is found in common/class_commandcreator.php file. Method which performs
text purifying is GetPlainLowerCaseBodyText, and if you search for "body_text" in that PHP file you'll find
a number of occurences in SQL queries so you might want to modify those.
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
AIWEB
Groupie
Joined: 19 October 2010
Location: United States
Online Status: Offline
Posts: 54
|
| Posted: 27 January 2011 at 8:12am | IP Logged
|
|
|
FANtastic
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: Database Message Text - body_text
Privacy policy |
Refund policy