Jack_mcs Posted January 29, 2006 Author Share Posted January 29, 2006 As I mentioned, it has to do with the email class I used. Changing over to the built-in oscommerce email functions is needed for some hosts for some reason. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
100asa Posted January 29, 2006 Share Posted January 29, 2006 Please, more clear! Sorry, I don't understand. Please, if you want, help me step by step. Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 30, 2006 Author Share Posted January 30, 2006 You need to start reading around post 41 and follow the instructions there. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valley Posted January 30, 2006 Share Posted January 30, 2006 I'm not sure what effect having 4,000 customers will have. Maybe that is part of the problem. If your problem is like the other I mentioned, then you will need to change the email functions in the contribution. If you have a Links Manger question, it should be asked it in the Links Manager support thread. Jack Hello Jack, What I meant was, unlike the orders report which collects only the orders up to certain number of previous days, the CUSTOMERS reprt collects the data of entire customers in the database. If you select all the columns by checking in the admin, it is going to be a long process and the server may time out. (this happens with some of the sales report contribution) Anyway is that how it is supposed to work ? Which is the E Mail function mod you are suggesting ? Could you please clarify ? Quote Link to comment Share on other sites More sharing options...
valley Posted January 30, 2006 Share Posted January 30, 2006 If you have a Links Manger question, it should be asked it in the Links Manager support thread. Jack Searched high and low for a Links Manager Support thread Couldn't find it. Could anyone please post it it here or PM me ? Cheers Shred Quote Link to comment Share on other sites More sharing options...
100asa Posted January 30, 2006 Share Posted January 30, 2006 I've just read from post #41 to end, and I have made the change in auto_announce, but the result is always the same. Please, post complete .php auto_announce working now! Quote Skype: centoasa Skype: remigioruberto Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 30, 2006 Author Share Posted January 30, 2006 Searched high and low for a Links Manager Support threadCouldn't find it. Could anyone please post it it here or PM me ? Cheers Shred It's here. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Guest Posted January 31, 2006 Share Posted January 31, 2006 Hi friends, thanks for your contribution! Is there any way to announce the new products, including text link for each one ? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 31, 2006 Author Share Posted January 31, 2006 There is already a new products module. Adding links is planned. I don't know what you mean about each one. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valley Posted February 3, 2006 Share Posted February 3, 2006 It's here. Jack Hello Jack , Many thanks for the link. How can I get rid of the Message field which is defaulting to in both admin/announce and admin/new products. Many thaanks in advance Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 4, 2006 Author Share Posted February 4, 2006 I don't understand what you mean with the image. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valley Posted February 4, 2006 Share Posted February 4, 2006 I don't understand what you mean with the image. Jack Hello Jack, When I click on the Announce menu in the admin the page that opens (http://www.affiliatesexcel.com/catalog/admin/auto_emailer_announce.php) has this picture with a web page in the "Message" field. Ipresume it is there from your instructions /// // Output a form textarea field w/ fckeditor function tep_draw_fckeditor($name, $width, $height, $text) { $oFCKeditor = new FCKeditor($name); $oFCKeditor -> Width = $width; $oFCKeditor -> Height = $height; $oFCKeditor -> BasePath = 'http://www.yoursite.com/FCKeditor/'; $oFCKeditor -> Value = $text; $field = $oFCKeditor->Create($name); return $field; } How can I empty it to fill in new info ? Quote Link to comment Share on other sites More sharing options...
valley Posted February 4, 2006 Share Posted February 4, 2006 Hello Jack, Ipresume it is there from your instructions /// // Output a form textarea field w/ fckeditor function tep_draw_fckeditor($name, $width, $height, $text) { $oFCKeditor = new FCKeditor($name); $oFCKeditor -> Width = $width; $oFCKeditor -> Height = $height; $oFCKeditor -> BasePath = 'http://www.yoursite.com/FCKeditor/'; $oFCKeditor -> Value = $text; $field = $oFCKeditor->Create($name); return $field; } I have now changed to a correct path $oFCKeditor -> BasePath = 'http://affiliatesexcel.com/catalog/admin/FCKeditor/FCKeditor'; but I still get the default html in the field Quote Link to comment Share on other sites More sharing options...
valley Posted February 4, 2006 Share Posted February 4, 2006 I have now changed to a correct path$oFCKeditor -> BasePath = 'http://affiliatesexcel.com/catalog/admin/FCKeditor/FCKeditor'; but I still get the default html in the field HELLO Jack, I have finally got the FCK editor in the Announce and Product info pages in the admin. Here is what I had to do. Your instructions asked to upload the FCKeditor directory to the admin directory. As this was a password protected directory I had to move the FCKediror directory up to the Catalog directory. I had to change the require statement on line 12 in the admin/include/functions/html_output.php as below require(DIR_FS_CATALOG .'FCKeditor/fckeditor.php'); I had to change the base path as below / Output a form textarea field w/ fckeditor function tep_draw_fckeditor($name, $width, $height, $text) { $oFCKeditor = new FCKeditor($name); $oFCKeditor -> Width = $width; $oFCKeditor -> Height = $height; $oFCKeditor -> BasePath = '/catalog/FCKeditor/'; $oFCKeditor -> Value = $text; $field = $oFCKeditor->Create($name); return $field; } However all this seems to be enough as the FCK editor removes and change the formatting of any html you place in the message field. Any idea why the editor behaves badly ? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 4, 2006 Author Share Posted February 4, 2006 No, it works fine here, and I assume for others that use it since no one has mentioned this before. The instructions mention that you may need to change the path so that is expected. You shouldn't have to move it out of admin though. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valley Posted February 4, 2006 Share Posted February 4, 2006 No, it works fine here, and I assume for others that use it since no one has mentioned this before. The instructions mention that you may need to change the path so that is expected. You shouldn't have to move it out of admin though. Jack Hello Jack, Many thanks for the reply. Just one question about the editor. function tep_draw_fckeditor($name, $width, $height, $text) Is it supposed to work only as a text editor or also as an HTML editor ? Can you cut and paste HTML pages which is what I try to do by selecting the source menu first. However the output is getting distoted and truncated. Cheers Shred Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 4, 2006 Author Share Posted February 4, 2006 Yes, it should work at an html editor. There is a support thread for it here somewhere. You might want to ask questions about it there since they would have more experience with it. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valley Posted February 4, 2006 Share Posted February 4, 2006 Yes, it should work at an html editor. There is a support thread for it here somewhere. You might want to ask questions about it there since they would have more experience with it. Jack Hello Jack, Many thanks for the reply. I will Check it out. I use MAVDs WYSIWYG addon in admin catogories which work quite well for cut and paste. FCK seems more adapted for creating new pages. However, on further tests it seems that the server stops after sending a couple of hundred messages. As the script can be called by CRON, is it possible to incremently select perhaps 100 messages from the list If this can be done then the CRON can be set up for every 15 minutes or so to send the messages to a different group of people.without creating any SPAM issues (for big lists) As it is it looks like the script can't send the mail to the whole customer list due to the server limitations. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 5, 2006 Author Share Posted February 5, 2006 Most servers have a limit on emails so as not to lock out other sites. I think that addng a call to sleep() every so often will prevent this from happening. I will try to get test this but it could be a while. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valley Posted February 5, 2006 Share Posted February 5, 2006 I've uploaded a new version. I added a new products module which will inform your customers of new products added since an entered date, or from todays date if one is not entered. Also corrected a few minor coding problems. Jack On testing Aut_customers.php I get the following error PHP Warning: mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_customers.php on line 46 [sun Feb 5 10:48:00 2006] [error] PHP Warning: mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_customers.php on line 46 [sun Feb 5 10:48:00 2006] [error] PHP Warning: mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_customers.php on line 46 Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 5, 2006 Author Share Posted February 5, 2006 Those errors are most likely caused by your database or your servers resources. Try repairing your database first using phpmyadmin. If that doesn't do it, contact your host and ask them so check it. The usual cause of that message is that you are out of memory. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valley Posted February 11, 2006 Share Posted February 11, 2006 Those errors are most likely caused by your database or your servers resources. Try repairing your database first using phpmyadmin. If that doesn't do it, contact your host and ask them so check it. The usual cause of that message is that you are out of memory. Jack Hello Jack, Many thanks for your reply. I got my host to check out and it seems everything was OK> Any way I haven't made more trials. I have a problem with adsmin/auto_emailer_announce.php. It looks like it is not writing the number of days field to the auto_emailer/auto_announce.php file when you update after filling in a number for example 2. All the other fields seems to be writing new data. When I simply update the fild carry the number inserted but if you change menu and come back later it disapperars. I think due to this the auto_announce.php do not out put when you make a trial. Could you please let me know how this can be fixed ? Cheers Shred Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 12, 2006 Author Share Posted February 12, 2006 If the permissions on the file are correct then your host is blocking it somehow. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
valley Posted February 12, 2006 Share Posted February 12, 2006 If the permissions on the file are correct then your host is blocking it somehow. Jack Hello Jack, I have rechecked the permissions which are set to 777 both for the autoemailer directory and the files. I did a trial changing the subject in the subject field which has been updated in the file also with new time stamp. When I change the number of days the time stamp is changed showing the file has been accessed but the ield returns empty during next refresh of the admin file. Could you please let me know the line number or statement that is re written to take the nunber of days ? (I couln't find an obvious one . ) I can check if this is re written. Quote Link to comment Share on other sites More sharing options...
valley Posted February 12, 2006 Share Posted February 12, 2006 Hello Jack, Could you please let me know the line number or statement that is re written to take the nunber of days ? (I couln't find an obvious one . ) I can check if this is re written. On checking the admin file I see a code section else if ($pos_start = strpos($fp[$idx], "// Start Date Difference") !== FALSE) { for ($idy = $idx; $idy < count($fp); ++$idy) { if ($pos_stop = strpos($fp[$idy], "// Stop Date Difference") !== FALSE) { $new_text[0] = " if (\$diff >= 0 && \$diff < ". $ae_array['days'] . ")"; $new_text[1] = "\n"; array_splice($fp, $idx + 1, $idy - $idx - 1, $new_text); break; } } } However I can't see a corresponding statement in the auto_announce.php between the Date Selection and Subject . Have I got the latest file or am I missing something ? // Start Date Selection $adjDate = sprintf("%s-%s-%s", $adjYr, substr($customer['customers_dob'], 5, 2),substr($customer['customers_dob'], 8, 2)); // Stop Date Selection $diff = DifferenceBetween($currentDate, $adjDate); if ($diff >= 0 && $diff < 18) { // Start Subject $Subject = 'test' . ' ' . $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; // Stop Subject 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.