Customizing SMF > Modifications and Packages

Automatic Newsletter for SMF2

<< < (10/31) > >>

Old Fossil:
The newsletter shows the news

Latest members, recent topics and posts etc.

You can choose what the newletter sends to members.

tassie73:
This is the script I am using for the subscription list.

Still need to add a link to it from the admin page, but at the moment it does the job I am after.


--- Code: ---<?php
$con = mysql_connect("db server name","db username","db password");

mysql_select_db("db name", $con);

$result = mysql_query("SELECT * FROM smf_hcb_newsletter");

echo "<table border='1'>
<tr>
<th>Email</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['email'] . "</td>";
  echo"</tr>";
  }
echo "</table>";

mysql_close($con);

?>

--- End code ---

Just save it and add it to your forum root directory and away you go!


Could extend it to add in the members name also by adding in the extra field if you wanted to. Simply add in the extra table data lines. If you want a hand with that too, let me know.

Cheers

Chris

A.SK:
Newsletter from the My Forum Name received in my mailbox only for the first time.

I have installed the mod on 1st july 2012 and selected weekly option for the newsletter.

Received the 1st newsletter only on 7th july 2012.

2nd newsletter not received to any subscribers - 15 july 2012

3rd newsletter not received to any subscribers - 22 july 2012

Now the forum is showing the next newsletter due on 29 july 2012

19 people are subscribed

Preview newsletter button had not showed the preview even once from the day of install.

Kindly assist admin.

HoverClub:
Preview just dumps html to the browser so it has to work?  What do you see?

Have you checked the SMF mail queue?

Do you have new posts (if none and no other options included then no newsletter will get sent as there is no news!)

What was the "next" date after 15/22 July?

Sweetwater:
THank you for your work on this mod, I would find this very useful for my forum, however it doesn't load properly (issue with the boarindextemplate. Did manual override but still couldn't get it to work properly. Am guessing it's a conflict with another mod so will have deleted it.

Thankyou for your efforts however. This mod has alot of potential.  8)

Navigation

[0] Message Index

[#] Next page

[*] Previous page