Newsletter Creator

#1 / Dec 06, 2013 4:09pm
zavio
11 posts
Hi All,

Ive done a lot of searching on google for a expression engine newsletter creator but cant seem to find any. We had a custom newsletter creator made for us for expression engine years ago but after we transferred to a new web server it stopped working. I dont understand why it would stop, the new server does have the latest SQL and PHP, it seems like its not saving to SQL, maybe the syntax has changed from different versions.

So I was wondering if there is a plugin out there that we can use or if someone can tell me why a script would stop working when moved form one server to another.

If there isn’t any plugin for this then I would like to try and fix what we already have.

I have attached our newsletter form that’s shows our newsletters and our news articles in the last 2 posts since i couldn’t fit it all in.

Here is a delete code that we used to use when the delete button is clicked but doesn’t work anymore:
```
<?php
 $id=$_POST['Id'];
 $sql="delete FROM exp_newsletter_title where id=''".$id;
 $results=$this->EE->db->query($sql);
 $sql="delete FROM exp_newsletter_form where title_id=''".$id;
 $results1 = $this->EE->db->query($sql);
 return $results1;
?>
```
Thanks.

#2 / Dec 06, 2013 4:12pm

zavio

11 posts

{if logged_in}
 {embed="includes_/head"}
 {embed="includes_/header"}
 <?php
  $login_member_id='{member_id}';
 ?>
 [removed][removed]
 [removed]
  function saveForm(obj,siteurl,entryId,memberId) {
   var Title=$("#newsletter_title").val();
   if (Title != "" && Title != "Enter Newsletter Title") {
    if ($(obj).is(':checked')) {
     $.post(siteurl+'newsletter_/newsletter_save', {actionType:'insert',entryid: entryId, memberid: memberId,title:Title},function(data) {});
    }
    else {
     var r=confirm("Are you sure you want to delete this entry?");
     if (r==true) {
      $.post(siteurl+'newsletter_/newsletter_save', {actionType:'delete',entryid: entryId, memberid: memberId,title:Title},function(data) {});
     }
     else {
      $(obj).attr("checked","checked");
     }
    }
   }
   else {
    alert("Please enter a newsletter title.");
   $(obj).attr("checked","");
   }
  }

  function SaveWithMail(siteurl,memberId) {
   var Title=$("#newsletter_title").val();
   if (Title != "" && Title != "Enter Newsletter Title") {
    $.post(site_global_url+'newsletter_/newsletter_save', {actionType:'saveandmail', memberid: memberId,title:Title},function(data) {
     alert(data);
    });
   }
   else {
    alert("Please enter a newsletter title.");
   }
  }

  function previewCall(site_global_url) {
   if ($("#newsletter_title").val()!="" && $("#newsletter_title").val()!="Enter Newsletter Title") {
    window.open(site_global_url+'newsletter_/newsletter_preview/','Domain Newsletter Preview','height=700,width=800,status=yes,scrollbars=yes');
   }
   else {
    alert("Please enter a newsletter title.");
   }
  }

  function newsletterShow(site_global_url,id) {
   window.open(site_global_url+'newsletter_/newsletter_previous/\''+id+'\'/','Domain Newsletter Preview','height=700,width=800,status=yes,scrollbars=yes');
   return false;
  }

  function newsletterDelete(site_global_url,id) {
   var r=confirm("Are you sure you want to delete this entry?");
   if (r==true) {
    $.post(site_global_url+'newsletter_/newsletter_delete', {Id: id},function(data) {
     location.reload();
    });
   }
   else {
    return false;
   }
   return false;
  }

  $(document).ready(function() {
   $("#newsletter_title").focus(function() {
    $(this).val("");
   });

   $("#newsletter_title").blur(function() {
    if ($(this).val()=="") {
     $(this).val("Enter Newsletter Title");
    }
   });

   $("#category").slideUp("slow");
   catetemp=0;

   $("#categoryheading").click(function() {
    if (catetemp==0) {
     $("#category").slideDown("slow");
     $("#categoryheading").find("img").attr("src","http://www.domain.com/assets/images/beta/dropup.png");
     catetemp=1;
    }
    else {
     $("#category").slideUp("slow");
     $("#categoryheading").find("img").attr("src","http://www.domain.com/assets/images/beta/dropdown.png");
     catetemp=0;
    }
    return false;
   });
  });
 [removed]
 <div id="news_nav"></div>
 <div id="content-top">
  <div id="content-news-left">
   <table class="sub" cellspacing="0" cellpadding="4" >
    <tr>
     <td>
      Newsletters<a href="http://" class="drop_down">http://www.domain.com/assets/images/beta/dropdown.png</a>
      <div ></div>
      <div id="category">
       <div class="cate1_desc">
        <ul >
         {exp:query sql="SELECT * FROM exp_newsletter_title"}
          <li>
           <div  0px 5px 0px;">
            <a href="http://">{title}</a>
            <span> </span>
           </div>
          </li>
         {/exp:query}
        </ul>
       </div>
      </div>
     </td>
    </tr>
   </table>
  </div>
  <div id="content-news-right"  10px!important;">
   <input type="text"  value="<?php if(isset($_SESSION['data'])){echo $_SESSION['title'];}else{echo "Enter Newsletter Title";}?>" id="newsletter_title" name="newsletter_title"  none repeat scroll 0% 0% rgb(0, 0, 0); border: 1px solid grey; color: rgb(136, 136, 136);" />
   <input type="button" name="preview" id="preview" value="Preview"   />
   <input type="button" name="Send" id="Send" value="Save"   echo $login_member_id;?>')" />
   <?php $i=0;?>
   {exp:channel:entries channel="news" orderby="date" limit="10" paginate="bottom"}
    <?php $i++;
     $ischecked="";
     if (isset($_SESSION['data'])) {
      if (in_array('{entry_id}', $_SESSION['data'])) {
       $ischecked="checked='checked'";
      }
     }
    ?>

#3 / Dec 06, 2013 4:12pm

zavio

11 posts

<div class="info_info">
     <div class="board_head" id="header_<?php echo $i?>">
      {title}<input type="checkbox"  name="newsletterchk"  echo $login_member_id;?>')" <?php echo $ischecked ?> /></p>
      <span>{exp:channel:month_links channel="news" limit="1"}{entry_date format='%F %d'},{year}{/exp:channel:month_links}</span>
     </div>
     {if segment_3 == url_title}
      <div class="board_image_N" id="body_<?php echo $i?>">
       <div class="image_image_N">
     {if:else}
      <div class="board_image" id="body_<?php echo $i?>" {if segment_2 == url_title}>
       <div class="image_image">
     {/if}
     {if segment_3 != url_title OR segment_3== ""}
      {news_image}
       {if {row_count} == 1}
        <a href="http://www.domain.com/index.php/news_/{url_title}"><span>{news_img}</span></a>
       {/if}
      {/news_image}
     {if:else}
      <?php $videoid=1;?>
      {news_videos}
       <div id="videocode_<?php echo $videoid;?>" >
        <object id="film" classid='clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B' z-index="-99999" width="596" height="440" codebase='http://www.apple.com/qtactivex/qtplugin.cab'>
         
         
         
         
         
         
         
         <embed type="video/quicktime" src="{news_video}" wmode="opaque" postdomevents="true" scale="tofit" autoplay="true" c loop="true" width="596" height="440" bgcolor="#000000" pluginspage='http://www.apple.com/quicktime/download/'></embed>
        </object>
       </div>
       <?php $videoid++; ?>
      {/news_videos}
      {news_image}
       <a href="http://www.domain.com/index.php/news_/{url_title}"><span>{news_img}</span></a>
       <div class="clear"></div>
       

      {/news_image}
     {/if}
</div>
     {if segment_3 == url_title}
      <div class="image_desc_N">
     {if:else}
      <div class="image_desc">
     {/if}
     {if segment_3 != url_title OR segment_3 == ""}
      
       <?php
        $news_content = '{news_dec}';
        $news_content=strip_tags($news_content);
        echo substr($news_content, 0, 200) . "...";
       ?>
       

       <a href="http://www.domain.com/index.php/news_/{url_title}">READ MORE</a>
      
     {if:else}
      {news_dec}
     {/if}
</div></div></div>
     {paginate}
      
       {if previous_page}
        <a href="http://{auto_path}">NEWER POSTS</a> 
       {/if}
       {if next_page}
        <a href="http://{auto_path}">OLDER POSTS</a>
       {/if}
      
     {/paginate}
   {/exp:channel:entries}
</div></div>
{embed="includes_/footer"}
{if:else}
 {redirect='site_'}
{/if}

#4 / Dec 10, 2013 1:14pm

zavio
11 posts

Any idea why this script would stop working after a transfer to a new server?

Thanks
#5 / Dec 10, 2013 3:08pm

zavio
11 posts

Expression Engine needs a simple newsletter creator module that can let you select yours newsletters and make it for in HTML format and save it to database.
#6 / Dec 20, 2013 12:59am

Rob Allen
3114 posts

There are a few newsletter addons listed at http://devot-ee.com/search/results?keywords=newsletter&addon_version_support=ee2 - worth a look!

Thread

zavio

zavio

zavio

zavio

zavio

Rob Allen

Username

Password

Thread

Newsletter Creator

zavio

zavio

zavio

zavio

zavio

Rob Allen

ExpressionEngine News!

Username

Password

Email Address

Display Name

Password