1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
<?PHP
echo "Sending GRID TIP email reminders";
$headers .="MIME-Version: 1.0 \n";
$headers .="From: admin.gridtip@gridtip.net \n";
$headers .="X-Mailer: WebMailer \n";
$headers .="X-Priority:3 \n";
$headers .="Content-Type: text/html; charset=iso-8859-1 \n";
require("dbconnect.php");
dbconnect();
$gp=mysql_query("SELECT g_id, g_name, g_datetime_ss, g_datetime_q, g_datetime_s, g_datetime_r FROM gps WHERE g_id < 100 AND timediff(g_datetime_r,now())<time('72:00:00') and timediff(g_datetime_r,now()) > 0");
if ($erg_gp=mysql_fetch_array($gp)) {
echo "erg_gp";
$gp_name=$erg_gp['g_name'];
$gp_datetime_ss=$erg_gp['g_datetime_ss'];
if ($gp_datetime_ss=="") {
$gp_datetime_ss= "none";
}
$gp_datetime_s=$erg_gp['g_datetime_s'];
if ($gp_datetime_s=="") {
$gp_datetime_s= "none";
}
$gp_datetime_q=$erg_gp['g_datetime_q'];
$gp_datetime_r=$erg_gp['g_datetime_r'];
$users=mysql_query("SELECT u_id, u_name, u_email FROM users;");
while ($erg_user=mysql_fetch_array($users)) {
echo "erg_user";
$message="
<html><head><meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'></head>
<body>
<p><font face='Verdana, Arial, Helvetica, sans-serif' size='2'>Hello ".$erg_user['u_name'].",<BR><BR>
remember to place your tips at <a href='http://gridtip.net'><b>GRID TIP</b></a> for the upcoming grand prix of: <b>".$gp_name." [start times in CE(S)T]</b></font>
<BR>
<table cellpadding='5px'>
<tr><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><i>Sprint Qualifying:</i></font></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$gp_datetime_ss."</b></font></td></tr>
<tr><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><i>Sprint:</i></font></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$gp_datetime_s."</b></font></td></tr>
<tr><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><i>Qualifying:</i></font></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$gp_datetime_q."</b></font></td></tr>
<tr><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><i>Race:</i></font></td><td><font face='Verdana, Arial, Helvetica, sans-serif' size='2'><b>".$gp_datetime_r."</b></font></td></tr>
</table>
<BR>
<font face='Verdana, Arial, Helvetica, sans-serif' size='2'>Keep in mind that your tip has to be placed at latest until the beginning of the corresponding event.<BR><BR>
Cheers,<BR><BR>
Your <b>GRID TIP</b> Admin<BR><BR></font>
<font size='1'>this is a no-reply address - do not reply to this email</font></p>";
$status= mail($erg_user['u_email'],"GRID TIP - email reminder",$message,$headers);
echo "status:".$status;
}
}
?>
|