dmcfull Posted January 13, 2014 Share Posted January 13, 2014 Hi, over the time I´ve had several character issues with my templates, and I´m trying to start over. The emailtemplates.sql from the installation script inserts 25 email templates to the table, but my installation currently has 47. Where are the other 22 templates? Thanks 0 Quote Link to comment Share on other sites More sharing options...
dmcfull Posted January 14, 2014 Author Share Posted January 14, 2014 Never mind, installed fresh whmcs in another directory and fetched schema from new installation. Turns out I had several missing templates 0 Quote Link to comment Share on other sites More sharing options...
pRieStaKos Posted January 14, 2014 Share Posted January 14, 2014 How many your fresh install has ? 0 Quote Link to comment Share on other sites More sharing options...
dmcfull Posted January 14, 2014 Author Share Posted January 14, 2014 Fresh install has 52 email templates. I attach original fresh installed email templates from 5.2.15 + spanish translation Hope it helps. tblemailtemplates.txt 0 Quote Link to comment Share on other sites More sharing options...
pRieStaKos Posted January 14, 2014 Share Posted January 14, 2014 Thank you. I already got Greek and English templates working 0 Quote Link to comment Share on other sites More sharing options...
dmcfull Posted January 14, 2014 Author Share Posted January 14, 2014 One thing I realised is that the default language doesn´t apply to email templates. Despite I have spanish language as default in whmcs, if a new client logs in, the display language is spanish, but the emails are sent in english (it uses the default template from the table where language = '') unless client specifies in their profile spanish language instead of default. A workaround for this, without having to copy/paste all templates over default ones is to run a query like this Update tblemailtemplates as t1 inner join ( select t2.name, t2.subject, t2.message from tblemailtemplates as t2 where language = 'Spanish' ) as A on t1.name = A.name set t1.subject = A.subject, t1.message = A.message where language = ''; 0 Quote Link to comment Share on other sites More sharing options...
mjdj1999 Posted September 25, 2014 Share Posted September 25, 2014 Is there an easy way to revert back to the old templates? I had used an old 3rd party template builder and they are no longer around and this has left my email templates with missing images and text. Thank you 0 Quote Link to comment Share on other sites More sharing options...
pRieStaKos Posted September 25, 2014 Share Posted September 25, 2014 Only if someone exports the tblemailtemplates table from the database or you install a local copy of WHMCS and do it yourself... 0 Quote Link to comment Share on other sites More sharing options...
mjdj1999 Posted September 26, 2014 Share Posted September 26, 2014 Only if someone exports the tblemailtemplates table from the database or you install a local copy of WHMCS and do it yourself... Thank you priestakos 0 Quote Link to comment Share on other sites More sharing options...
sarniahosting Posted September 27, 2014 Share Posted September 27, 2014 Hello, I cant seem to find where to post a new thread. Is someone willing to copy and paste the English version of Dedicated/VPS Server Welcome Email to a word document and send it to me or upload it here? It would be very much appreciated, and very well needed. Thank You 0 Quote Link to comment Share on other sites More sharing options...
mjdj1999 Posted September 27, 2014 Share Posted September 27, 2014 Hello, I cant seem to find where to post a new thread. Is someone willing to copy and paste the English version of Dedicated/VPS Server Welcome Email to a word document and send it to me or upload it here? It would be very much appreciated, and very well needed. Thank You Hope this helps. DED-VPS Welcome.txt 0 Quote Link to comment Share on other sites More sharing options...
sarniahosting Posted September 29, 2014 Share Posted September 29, 2014 Thats perfect!~ Thank you 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.