Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

store admin emails


Guest

Recommended Posts

Posted

Hi

 

I got asked a good question just now, is it possible to store emails sent from the admin area somehow, I am using 2.3.1

 

Kind regards

 

Ian

Posted

sure ... save them in a new table in your database. you can then get the info from the database directly if you need to look up something or create a nice frontend for it similar to the newsletter manager tool ....

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Posted

Hi Monika

 

Thank you for the reply, would you be able to help me and guide me through setting up a new database table and them getting the info from the database table to display in the admin area

 

Sorry only as not as confident to do it by myself

Posted

Hi Monika

 

I think I have found another way of doing it rather than storing the emails, I have done it this way and hopefully will work

 

I added the following to admin/mail.php

 

# simple mod to send CC
	 $mimemessage->send('Your Name Here', 'address_where_you_want_it_to_go', '', $from, $subject);

 

I found it in another post here - http://www.oscommerce.com/forums/topic/192419-save-copy-of-sent-email/

Posted

sure - that's another solution to keep the information, it just will not be listed with your customer in admin... definitely faster though!

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Posted

would of been good to keep it in the admin area but not 100% on how to create the database and the coding to do that

Posted

Ian

 

Here is a guide as to what you need to do, as you can see it is a few hours work.

 

Create table using phpmyadmin, needs at least 3 fields

email_id (auto increment)

customer_id

Email_text

 

maybe 2 more

 

sent_to

copied to

 

Add an entry in /admin/includes/datbase_tables.php

 

Add a line to each script/php file that writes an email that insert a record containing the data

 

Write a script to enable emails sent to be displayed and link it to customers page in admin.

 

Cheers

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...