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 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90
| <?
include "../../config.php";
$resultt = mysql_query("select journee from jj");
$journee = mysql_result($resultt, 0);
$result = mysql_query("SELECT pseudo, team, teamid, division, rating, etoile, pass from membre m, rating r where r.membre = m.id and journee = $journee and news = 0 and teamid = 192707 order by teamid");
while($row = mysql_fetch_array($result))
{
//$team = $htclient->getTeamDetails($row[teamid]);
//$email = $team['EMAIL'];
$resultt = mysql_query("SELECT avg(rating) from rating r, membre m where r.membre = m.id and division = $row[division]");
$ratingdiv = round(mysql_result($resultt, 0), 1);
$resultt = mysql_query("SELECT avg(etoile) from rating r, membre m where r.membre = m.id and division = $row[division]");
$etoilediv = round(mysql_result($resultt, 0), 1);
$message = "
<body bgcolor=\"#FFFFFF\" topmargin=\"0\" leftmargin=\"0\" bottommargin=\"0\" text=\"#000000\" link=\"#3268B1\" vlink=\"#3268B1\" background=\"backgr.gif\">
<table width=\"600\" border=\"0\" cellspacing=\"0\" cellpadding=\"15\" bgcolor=\"#999999\" align=\"center\">
<tr>
<td height=\"438\" background=\"backgr.gif\" bgcolor=\"#BDBABD\">
<table width=\"99%\" border=\"0\" cellspacing=\"0\" cellpadding=\"10\" bgcolor=\"#FFFFFF\">
<tr>
<td><table width=\"600\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td width=\"591\" bgcolor=\"#29A2DB\" colspan=2><img src=\"haut.gif\" alt=\"wallistrix\" width=\"591\" height=\"50\"></td>
</td>
<td width=\"9\" align=\"right\"><img src=\"hn_022006_topright.gif\" width=\"9\" height=\"50\"></td>
</tr>
<tr>
<td colspan=\"3\"><table width=\"600\" height=\"316\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td background=\"milieu.gif\"><table width=\"600\" height=\"450\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" background=\"freedns_jun06_visual_fr.gif\">
<tr>
<td width=\"53%\" valign=\"top\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"5\">
<tr>
<td valign=\"top\"> </td>
</tr>
</table></td>
<td width=\"47%\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"13\">
<tr>
<td>Bonjour,<br>
<br>
Voici les données pour votre équipe pour cette \" . $journee . \"ème journée : <br><br>
<u>Rating</u> :<br>
$row[team] : $row[rating]<br> Division : $ratingdiv<br>
<u>Etoile</u> :<br>
$row[team] : $row[etoile]\nDivision : $etoilediv<br>
Pour en savoir plus sur votre équipe : <a href=\"http://www.wallistrix.be/info.php?teamid=$row[teamid]\">http://www.wallistrix.be/info.php?teamid=$row[teamid]</a>\<br><br><br>
<div align=\"center><font size=\"-1\">Si vous ne désirez plus recevoir ce mail, cliquer sur ce lien : <a href=\"http://www.wallistrix.be/mail.php?delete=$row[teamid]&pass=$row[pass]\">se désinscire</a></font></div>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan=\"3\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td colspan=\"3\" bgcolor=\"#F1EAC7\"><div align=\"center\"><span class=\"style76\"> <br>
</span><span class=\"style89\">Copyright © 2005 wallistrix.be. Tous droits réservés.</span></div></td>
</tr>
<tr>
<td width=\"2%\" height=\"18\" align=\"left\" valign=\"bottom\" bgcolor=\"#F1EAC7\"><img src=\"freedns_jun06_lo.gif\" width=\"9\" height=\"9\" /></td>
<td width=\"96%\" bgcolor=\"#F1EAC7\"> </td>
<td width=\"2%\" align=\"right\" valign=\"bottom\" bgcolor=\"#F1EAC7\"><img src=\"freedns_jun06_ro.gif\" width=\"9\" height=\"9\" /></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>";
}
mail("kriekbellevue@xxx.xx", "Info wallistrix.be", $message, "FROM: kriekbellevue@xxx.xx"); |
Partager