Ciao,
ho problemi col programma sotto che non funziona a dovere. Non
riportata dati come dovrebbe per poi fare l´´insert query che si
può fare con php su mysql. Credo che sia il flush() che crea buffer che
dovrebbe portare fuori i dati per l´insert mysql ma perché non
funziona? Idee su come posso risolvere?
Sperando in un´aiuto.
Ciao,
Pier
<?
//**VS**//$setting[ptr]//**VE**//
include("config.php");
include("includes/functions.php");
include("includes/mysql.php");
$Db1 = new DB_sql;
$Db1->connect($DBHost, $DBDatabase, $DBUser,
$DBPassword);
include("includes/globals.php");
flush();
//**S**//
function get_users($count, $country) {
global
$Db1;
$sql=$Db1->query("SELECT
username, name, email FROM user WHERE suspended=0 and optin='1'
".iif($country != ""," and country='$country'")."
ORDER BY rand() LIMIT $count");
for($x=0;
$temp=$Db1->fetch_array($sql); $x++) {
$list[$x]=$temp;
}
return
$list;
}
echo "Connected <br/>";
// if($settings[cron_pwd] == $pwd) {
//
$sq1=$Db1->query("DELETE FROM
click_history");
// $sql=$Db1->query("DELETE
FROM email_history");
$sql=$Db1->query("DELETE
FROM pending_emails");
$sql=$Db1->query("SELECT
* FROM emails WHERE credits>=1");
while($mail=$Db1->fetch_array($sql))
{
$mailid=$mail[id];
echo
"<!-- Starting Email Loop -->\n\n"; flush();
$emailsubject
= "$mail[title]";
$emailbody
= "".stripslashes($mail[description])."\n\n";
$users
= get_users($mail[credits], $mail[country]);
$user_index=0;
if ($mail[credits]<=count($list)){
$e='';
for($x=0; $x<=$mail[credits]; $x++) {
flush();
$e.= $users[$user_index][name].":".$users[$user_index][email].":".$users[$user_index][username]."\n";
$user_index++;
}
}
if
($mail[credits]>count($list)){
$e='';
for($x=0; $x<count($list); $x++) {
flush();
$e.= $users[$user_index][name].":".$users[$user_index][email].":".$users[$user_index][username]."\n";
$user_index++;
}
}
echo "<!-- Creating Entry
-->\n\n"; flush();
$Db1->query("INSERT INTO
pending_emails SET
mailid='".$mailid."',
subject='".addslashes($emailsubject)."',
body='".addslashes($emailbody)."',
tolist='".addslashes($e)."'
");
}
echo "<!-- All Done -->\n\n";
flush();
exit;
function sendmail($mail, $user) {
global
$settings;
$subject
= "$settings[site_title] Paid Email: $mail[title]";
$body
= "".stripslashes($mail[description])."\n\n
To receive credit for this email, Please click the
following URL
$settings[base_url]/pemail.php?user=$user[username]&id=$mail[id]
\n
--------------------------------------------------------------
$settings[site_title] Paid Email
You are receiving this email because you are a
member of
$settings[domain_name] and have opted in to
receiving paid emails. If
you want to stop receiving emails, please login
to your account turn
off paid emails in your profile page.
--------------------------------------------------------------";
send_mail($user[email],$user[name],$subject,$body);
echo
"<!- Finished Mailing $user[username] !>\n\n";
flush();
}
function mailgo($mail) {
global
$Db1;
}
// if($settings[cron_pwd] == $pwd) {
$sql=$Db1->query("SELECT
* FROM emails WHERE credits>=1");
while($temp=$Db1->fetch_array($sql))
{
$emails[$x][0]=
$sql=$Db1->query("SELECT
username, email FROM user WHERE optin='1' and username!='$mail[username]' ORDER
BY rand() LIMIT $mail[credits]");
while($user=$Db1->fetch_array($sql))
{
echo
".";
flush();
sendmail($mail,
$user);
}
}
$Db1->sql_close();
while($temp=$Db1->fetch_array($sql))
{
$sql=$Db1->query("SELECT
username, email FROM user WHERE optin='1' and username!='$mail[username]' ORDER
BY rand() LIMIT $mail[credits]");
while($user=$Db1->fetch_array($sql))
{
echo
".";
flush();
sendmail($mail,
$user);
}
}
// }
// else {
// echo
"Invalid Access To Cron!";
// }
//**E**//
?>
Offline 
Invia email