Mercurial > hg > ywww

comparison newsletter/newsletter_110418.php @ 6:077b0a0a3e6d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
remaining originals according to dependency walk
author Robert Boland <robert@markup.co.uk>
date Thu, 16 Feb 2017 22:29:02 +0000
parents
children 385ddd7c4b55 a67bf725e87b
comparison
equal deleted inserted replaced
5:55445b456ad0 6:077b0a0a3e6d
1 <?PHP
2
3 include "../../private/db.php";
4
5 $myFile = "newsletterOutput";
6 $fh = fopen($myFile, 'w') or die("can't open file");
7
8 for ( $counter = 0; $counter <= 6700; $counter += 50) {
9
10 $upper = $counter+51;
11
12 $query1 = "select distinct Email from user u, userpref up where u.UserID = up.UserID and ReceiveEmail = 1 and u.UserID > $counter and u.UserID < $upper";
13 //echo $query1;
14
15 $data = mysqli_query($link, $query1);
16
17 fwrite($fh, date("d/m/y : H:i:s", time()));
18 fwrite($fh, " Sent mail to:\n");
19
20 while($line = mysqli_fetch_assoc($data))
21 {
22 $email=$line["Email"];
23
24 if (substr($email,0,1) != "@")
25 {
26
27 $message = "<html>
28 <head>
29 <title>YourNextRead Newsletter</title>
30 </head>
31 <table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" bgcolor=\"#232323\" align=\"center\">
32 <tbody><tr><td>
33 <table width=\"600\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" bgcolor=\"#ffffff\" align=\"center\">
34
35 <tbody>
36 <tr></tr>
37 <tr>
38 <td bgcolor=\"#232323\" width=\"15\"></td>
39 <td bgcolor=\"#232323\">
40 <center><font face=\"verdana, sans-serif, arial\" color=\"#ffffff\" style=\"font-size:10px;\" size=\"1\">
41 Discover and share with YourNextRead. Having trouble viewing this email? See it <a rel=\"nofollow\" target=\"_blank\" href=\"http://www.yournextread.com/newsletter/apr1811.html\" style=\"color:#ffffff;\">online<font face=\"verdana, sans-serif, arial\" color=\"#ffffff\" style=\"font-size:10px;\" size=\"1\"></font></a>. To help stop our emails being seen as spam, please add <strong><span style=\"border-bottom-style: dashed; border-bottom-width: 1px; border-bottom-color: rgb(0, 102, 204); cursor: pointer; \">newsletter@YourNextRead.com</span></strong> to your address book.
42 <br><br>
43 </font></center>
44 </td>
45 <td bgcolor=\"#232323\" width=\"15\"></td>
46 </tr>
47
48 <tr>
49 <td colspan=\"3\" bgcolor=\"#232323\" ><A HREF=\"http://www.yournextread.com/\"><img src=\"http://www.yournextread.com/images/read/top_email.jpg\" style=\"border:0px;display:block;\" width=\"600\" height=\"63\" alt=\"\"></a></td>
50 </tr>
51
52 <tr>
53 <td bgcolor=\"#ffffff\" colspan=\"2\">
54 <table width=\"600\" cellpadding=\"5\" cellspacing=\"0\" border=\"0\" bgcolor=\"#ffffff\">
55 <tbody>
56 <tr>
57 <td bgcolor=\"#594f43\"> <font face=\"verdana, sans-serif, arial\" color=\"#ffffff\" style=\"font-size:12px;\">
58 18th April 2011
59 </font> </td>
60 </tr>
61 <tr>
62 <td bgcolor=\"#f2b234\">
63 <font face=\"verdana, sans-serif, arial\" color=\"#232323\" style=\"font-size:20px; font-weight:bold;\">
64 Presenting MyMap...
65 </font>
66 <br>
67 </td>
68 </tr>
69 </tbody>
70 </table>
71 </td>
72 </tr>
73 <tr></tr>
74 <tr>
75 <td bgcolor=\"#ffffff\" colspan=\"3\">
76 <table width=\"570\" cellpadding=\"10\" cellspacing=\"0\" border=\"0\" bgcolor=\"#ffffff\">
77 <tbody>
78 <tr>
79 <td>
80 <font face=\"verdana, sans-serif, arial\" color=\"#0000000\" style=\"font-size:12px;\"></font>
81 <p style=\"font-family:verdana, sans-serif, arial;font-weight:100;color:#0000000;font-size:13px;line-height:14px;\">
82 The YourNextRead team is proud to present its latest addition: <b>MyMap</b></p><p style=\"font-family:verdana, sans-serif, arial;font-weight:100;color:#0000000;font-size:13px;line-height:14px;\">MyMap is another way to find great recommendations from YourNextRead. You can get personalised recommendations over any collection of books you add to your MyMap list. </p><p style=\"font-family:verdana, sans-serif, arial;font-weight:100;color:#0000000;font-size:13px;line-height:14px;\">Your MyMap allows you to discover new books and see the connections between the recommendations, your collection and also within your collection. We have created some sample maps for you to browse through:
83 </p>
84
85 <p style=\"text-align:center;\">
86 <a href=\"http://www.yournextread.com/us/#!map=FictionMap\"><img src=\"http://www.yournextread.com/images/map/myMap1.gif\" height =\"80px\" width=\"130px\"/></a>
87 <a href=\"http://www.yournextread.com/us/#!map=YoungReadsMap\"><img src=\"http://www.yournextread.com/images/map/myMap2.gif\" height =\"80px\" width=\"130px\"/></a>
88 <a href=\"http://www.yournextread.com/us/#!map=CultureMap\"><img src=\"http://www.yournextread.com/images/map/myMap3.gif\" height =\"80px\" width=\"130px\"/></a>
89 <a href=\"http://www.yournextread.com/us/#!map=ProfessionalMap\"><img src=\"http://www.yournextread.com/images/map/myMap4.gif\" height =\"80px\" width=\"130px\"/></a>
90 </p>
91
92 <p style=\"font-family:verdana, sans-serif, arial;font-weight:100;color:#0000000;font-size:13px;line-height:14px;\">
93 You can share your MyMap collection and recommendations with friends and family through email, facebook and twitter.
94 </p>
95 <p style=\"font-family:verdana, sans-serif, arial;font-weight:100;color:#0000000;font-size:13px;line-height:14px;\"><a href=\"http://www.yournextread.com/us/#!map=FictionMap\">
96 Try it out</a> and <a href=\"mailto:feedback@yournextread.com\">let us know what you think!</a>
97 </p>
98
99 </p>
100
101 <div style=\"border-bottom:solid;border-bottom-width:2px;border-bottom-color:#f2b234;height:1px;width:570px;margin-top:8px;margin-bottom:10px;\"></div>
102 <p style=\"font-family:verdana, sans-serif, arial;font-weight:bold;color:#0000000;text-align:center;font-size:13px;line-height:14px;\">
103 Check out the YourNextRead recommendations for these bestsellers:
104 </p>
105 <p style=\"text-align:center;\">
106 <a href=\"http://www.yournextread.com/us/#!isbn=0849946158\"><img src=\"http://ecx.images-amazon.com/images/I/41xMBhaLedL._SL160_.jpg\" height =\"100px\" width=\"70px\"/></a>
107 <a href=\"http://www.yournextread.com/us/#!isbn=1605292885\"><img src=\"http://ecx.images-amazon.com/images/I/51C6Dkw59SL._SL160_.jpg\" height =\"100px\" width=\"70px\"/></a>
108 <a href=\"http://www.yournextread.com/us/#!isbn=0525422943\"><img src=\"http://ecx.images-amazon.com/images/I/51ngrZddGvL._SL160_.jpg\" height =\"100px\" width=\"70px\"/></a>
109 <a href=\"http://www.yournextread.com/us/#!isbn=0307593916\"><img src=\"http://ecx.images-amazon.com/images/I/41S0R2hthjL._SL160_.jpg\" height =\"100px\" width=\"70px\"/></a>
110 <a href=\"http://www.yournextread.com/us/#!isbn=0316056863\"><img src=\"http://ecx.images-amazon.com/images/I/416bks3J1JL._SL160_.jpg\" height =\"100px\" width=\"70px\"/></a>
111 </p>
112 <div style=\"border-bottom:solid;border-bottom-width:2px;border-bottom-color:#f2b234;height:1px;width:570px;margin-top:8px;margin-bottom:10px;\"></div>
113 <p>
114 <a href=\"http://www.facebook.com/YourNextRead/\"><img src=\"http://www.buttonshut.com/Facebook-Buttons/Facebook-Buttons-42-32-.gif\" border=\"0\"/></a> <a href=\"http://www.twitter.com/YourNextRead\" ><img src=\"http://www.twitterbuttons.com/upload/badges/02bb9f0627follow-us-1.gif\" border=\"0\"/></a><a style=\"float:right;margin-top:20px;\" href=\"http://www.amazon.com/?tag=bookwhack-20\" ><img src=\"http://g-ecx.images-amazon.com/images/G/01/gno/images/general/navAmazonLogoFooter._V169459313_.gif\" border=\"0\"/></a>
115 <br/>
116 </p>
117 </td>
118 </tr>
119 </tbody>
120 </table>
121 </td>
122 </tr>
123
124 <tr>
125 <td colspan=\"3\" bgcolor=\"#232323\"><br>
126 <font face=\"arial, verdana, sans-serif\" color=\"#ffffff\" size=\"1\" style=\"font-size:10px;\">
127 Terms and Conditions
128 <br><br>
129 This is a genuine email from <span style=\"border-bottom-style: dashed; border-bottom-width: 1px; border-bottom-color: rgb(0, 102, 204); cursor: pointer; \">YourNextRead</span>. However, if you receive an email which you are concerned does not legitimately originate from us, you can report it via <a rel=\"nofollow\" target=\"_blank\" href=\"mailto:feedback@yournextread.com\" style=\"color:#ffffff;\"><span class=\"yshortcuts\">emailing us</span></a> before deleting it.
130 <br><br>
131 You have received this email because you have opted in to receive news, updates and offers from YourNextRead
132 <br><br>
133 You can <a rel=\"nofollow\" target=\"_blank\" href=\"http://www.yournextread.com/user/unsubscribe.php?email=$email\" style=\"color:#ffffff;\"><span>unsubscribe here</span></a>, however as the majority of our communications are via email, you'll be missing out.
134 <br>
135 </font>
136 </td>
137 </tr>
138
139 </tbody></table>
140
141
142 </td></tr></tbody></table></html>";
143
144 $header="from: YourNextRead <newsletter@yournextread.com>\nContent-Type: text/html; charset=iso-8859-1";
145 $to=$email;
146 $subject="YourNextRead Presents MyMap";
147 $sentmail = mail($to,$subject,$message,$header);
148 fwrite($fh, "$email\n");
149 }
150
151 }
152
153 sleep(60);
154 }
155 fwrite($fh, "COMPLETE");
156 fclose($fh);