<?php $fecha = date("d/m/Y"); include "classes/class_general_db.php"; $query = "SELECT member_name, email_address FROM elforodeltenis_members WHERE id_member = '{$_GET['us']}'"; $po = new conexionBD(); $po->doQuery("{$query}"); while ($po->setWhile()) { $member_name = $po->getDataSQL("member_name"); $email_address = $po->getDataSQL("email_address"); } $po->setClose(); $query = "INSERT INTO elforodeltenis_descarga_powerplay ( id_usuario, fecha, version) VALUES ('{$_GET['us']}', '{$fecha}', '1')"; $po = new conexionBD(); $po->doQuery("{$query}"); include "classes/class.phpmailer.php"; //Envía email $mail = new PHPMailer(); $mail->Host = "localhost"; $mail->From = "*****@*****.**"; $mail->FromName = "Descarga Powerplay | Elforodeltenis.com"; $mail->Subject = "Nueva descarga de la revista N.1 de Powerplay"; $mail->AddAddress('dcolja@elforodeltenis.com; pacoalmendros@ono.com'); $body = "<strong>El usuario {$member_name} se acaba de descargar el número 1 de la revista Powerplay.<br><br>"; $body .= "<i>Mensaje enviado desde la web de elforodeltenis.com</i><br>"; $body .= "<a href=\"http://www.elforodeltenis.com\"><img src=\"http://www.elforodeltenis.com/Themes/BeCool_2/images/elforodeltenis.gif\"></a>"; $mail->Body = $body; $mail->IsHTML(true); $mail->Send(); $mail = new PHPMailer(); $mail->Host = "localhost";
$gt = new conexionBD(); $gt->doQuery("{$query}"); while ($gt->setWhile()) { $email9 = $gt->getDataSQL("email_amigo"); } if ($email9 != "") { $query = "SELECT email_address FROM elforodeltenis_members WHERE email_address = '{$email9}'"; $gt = new conexionBD(); $gt->doQuery("{$query}"); $email9_registrado = $gt->getNumRows(); } $gt->setClose(); $query = "SELECT email_amigo FROM elforodeltenis_recomendaciones WHERE id_member = '{$_GET['m']}' AND numero = '10'"; $gt = new conexionBD(); $gt->doQuery("{$query}"); while ($gt->setWhile()) { $email10 = $gt->getDataSQL("email_amigo"); } if ($email10 != "") { $query = "SELECT email_address FROM elforodeltenis_members WHERE email_address = '{$email10}'"; $gt = new conexionBD(); $gt->doQuery("{$query}"); $email10_registrado = $gt->getNumRows(); } $gt->setClose(); ?> <div class="row space-up"> <div class="col-md-3"><img src="http://www.elforodeltenis.com/Themes/BeCool_2/images/elforodeltenis.gif" alt="el foro del tenis"></div> <div class="col-md-6"></div> <div class="col-md-3"> <a href="http://www.elforodeltenis.com">
<table> <?php include "classes/class_general_db.php"; $query = "SELECT id_usuario FROM elforodeltenis_descarga_powerplay WHERE id_usuario<>'' group by id_usuario"; $po = new conexionBD(); $po->doQuery("{$query}"); while ($po->setWhile()) { $id_usuario = $po->getDataSQL("id_usuario"); $query = "SELECT email_address, member_name FROM elforodeltenis_members WHERE id_member = '{$id_usuario}'"; $op = new conexionBD(); $op->doQuery("{$query}"); while ($op->setWhile()) { $email_address = $op->getDataSQL("email_address"); $member_name = $op->getDataSQL("member_name"); ?> <tr> <td><?php echo $email_address; ?> </td> <td><?php echo $member_name; ?> </td> </tr> <?php } } ?> </table>