Viewing file:  phpbb3_a_phplist.php (1.19 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include ("../frames/conn.php");
$sql="select distinct(user_email) from papyr225_phpb1.phpbb_users where user_email>'' order by user_id desc";
$res=mysql_query($sql,$conn);
if (mysql_error())die(mysql_error());
$fecha=date('Y-m-d H-i-s');
while ($row=mysql_fetch_array($res)){
// echo "<pre>";
// print_r($row);
echo "<br>++++++++nuevo+++++++++++++++<br>";
$sql2="insert into phplist.phplist_user_user
(email,
htmlemail,
confirmed,
entered,
modified,
passwordchanged)
values
('{$row['user_email']}',
1,
1,
'$fecha',
'$fecha',
'$fecha')";
echo $sql2."<br>";
mysql_query($sql2,$conn);
if (mysql_error())die(mysql_error());
$ultimo_id = mysql_insert_id();
echo "<br>----------$ultimo_id<br>";
if (mysql_error())echo(mysql_error());
$sql3="insert into phplist.phplist_listuser
(userid,listid ,modified)
values
($ultimo_id,2,'$fecha')";
echo $sql3."<br>";
mysql_query($sql3,$conn);
if (mysql_error())echo (mysql_error());
}
?>
|