Initial Email Templates

[hosted]

As everyone knows, the default package does not include any templates for sending out email messages when links are submitted etc.

So, I put together some templates and have made them available at a

http://www.findimagehost.info/email_templates.sql

This is simply an SQL dump of the table PLD_EMAIL_TPL

The Easiest way to use this is to log into phpMyAdmin on your server, select the database, select SQL, Copy and paste the info from the above URL into phpmyadmin and hit GO!

This will put the 4 templates into your database and give you a reasonable starting point.

( Note: this is probably a worthwhile addition for the next release of PLD Hint hint! )

It took me a little while to come up with some reasonable email templates, and I hope it makes it easier for someone setting up their new Directory, and if anyone has any suggestions for improving these templates, I would love to see them!

[f1gm3nt]

Nice thanks, maybe in future releases they'll include this.

-Joshua

[Hizson]

Thanks, but I was able to get this issue straightened out.

Can anyone help me in this?

I did a search about email templates and found this link that told me to insert this code into my db. But I couldn't figure out how to do this. Can someone clue me in?

--
-- Dumping data for table `PLD_EMAIL_TPL`
--

INSERT INTO `PLD_EMAIL_TPL` (`ID`, `TPL_TYPE`, `TITLE`, `SUBJECT`, `BODY`) VALUES (1, 2, 'Submit', 'Link Added to {MY_SITE_NAME}', 'Hello {LINK_OWNER_NAME}\r\n\r\nThank you for submitting your site {LINK_URL} to our directory at {MY_SITE_URL} We will review this site to ensure it meets the requirements for inclusion in our directory.\r\n\r\nWe endeavour to review all submissions within a few days and when completed you will receive further notification.\r\n\r\nRegards,\r\n{MY_SITE_NAME}\r\ n{MY_SITE_URL}');


INSERT INTO `PLD_EMAIL_TPL` (`ID`, `TPL_TYPE`, `TITLE`, `SUBJECT`, `BODY`) VALUES (2, 2, 'Approval', 'Your listing is approved at {MY_SITE_URL}', 'Hello {LINK_OWNER_NAME}\r\n\r\nWe have reviewed your link request and have added your site, {LINK_URL}- {LINK_TITLE} to our directory at:{MY_SITE_URL}\r\n\r\nFree Listings are reuqired to have a reciprocal link, and we check on a regular basis. To maintain your listing, please ensure that you have the link in place on the nominated page. Sites that remove the reciprical link may be tagged as inactive in our directory.\r\n\r\nRegards,\r\n{MY_SITE_NAME}\r\n{M Y_SITE_URL}');


INSERT INTO `PLD_EMAIL_TPL` (`ID`, `TPL_TYPE`, `TITLE`, `SUBJECT`, `BODY`) VALUES (3, 2, 'Rejected', 'Your link has been rejected', 'Hello {LINK_OWNER_NAME}\r\n\r\nI am sorry to inform you that your link request at {MY_SITE_URL} for {LINK_URL} - {LINK_TITLE} was rejected.\r\n\r\nIt was rejected for one of the following reasons:\r\n\r\nYour site contained inappropriate content\r\nYour request was not in the correct category and we could not identify a suitable category\r\nYou have removed your recipricol link which is required for inclusion in our directory.\r\n\r\nIf you think that this was in error, we invite you to visit our site, select the correct category and re-submit your link.\r\n\r\nThanks!\r\n{MY_SITE_NAME}\r\n{MY_SITE _URL}');


INSERT INTO `PLD_EMAIL_TPL` (`ID`, `TPL_TYPE`, `TITLE`, `SUBJECT`, `BODY`) VALUES (4, 2, 'Payment', 'Your payment has been received', 'Hi {LINK_OWNER_NAME}\r\n\r\nWe have received your payment for your link to be added to our directory at {MY_SITE_URL} - {MY_SITE_NAME}\r\n\r\nThe link to your site {LINK_URL} - {LINK_TITLE} has been added. Please check to ensure that all details are correct, and let us know of any problems.\r\n\r\nRegards\r\n{MY_SITE_NAME}\r\n{MY_ SITE_URL}');




Thanks,

Jere

[LinkReal]

Hey these templates work great, but when the notification emails are sent they are sent from UNKNOWN SENDER.. not all of them just 3 of them.

I searched and searched but I've had no luck.

Any help is appreciated.

thanks-

[pokerbankrolls]

Thanks a lot. Does anyone know why when I do "Send Email and Add Link" the drop down menu is empty?

[FB]

Content visible to registered users only.

Found a bit of a glitch here...

I added the templates to the database and all went as planned. Everything worked.

I then went in to my admin and was creating new emailer templates and they just started replacing the site owner notify templates that you created. Not sure what the issue is or was.
Started out with 4 templates, and still have 4 but the two new templates I created just replaced the top two that you created. Hope this makes sense.

[FB]

hosted?

[hosted]

I have honestly not looked at any of this since I created the templates as a starting point. Basically, the info surrounding email templates was pretty thin. When I worked out the necessary codes etc to create a template, I simply did an SQL dump of them and shared the info with the community.

It seems that it works for some people, and doesn't work too well for others - I do not know why, it all worked fine for me.

[nostrand]

Thanks man

[neverknow1]

Content visible to registered users only.

Can I import this to my SQL if I have an existing email templates? Will it overwrite the old one?

Thanks

[nima]

This was great.

Thanks a lot

[kamal_chandelkar]

when the notification emails are sent they are sent from UNKNOWN SENDER.. not all of them just 3 of them.

How can I fix this error, Please tell me.

Thanks in Advance

[proprod]

Users, please use the search button up there: http://www.phplinkdirectory.com/forum/showthread.php?t=861&highlight=email+unknown

[mneylon]

Thanks for that :)

Saved me a lot of messing about

[dubz]

Thanks alot!

Those are a great starting spot for email messages. Much appreciated.