<?
The code below is supposed to send either a .jpg file, a .zip or a link acording to what the client chooses.
A e-mail is sent but with nothing in it for the dailyoic, the rest works, I don't know what could be wrong? Any ideas? if you have a idea, please re-write it in comments. Thank for the help, I'm new to this!
-Newman
// Required files
require(\"gp_mailfunction.php\");
// Set time limit of script to 0 so that we do not time out.
set_time_limit(0);
// Set new class Mail Function
$mf = new mf;
$db_slist = new DB_mydbase;
$query = \"SELECT * FROM subscribe_list ORDER BY id\";
$db_slist->query($query);
while ($db_slist->next_record()) {
$daysent = $db_slist->Record[\"daysent\"] - 1;
// for daily mailings
if ($db_slist->Record[\"typeID\"] == 1) {
unset($rawtext);
unset($title);
unset($email2);
unset($mailsent2);
unset($send);
unset($table);
// Set what number $maillist gets later
$maillistnum = $db_slist->Record[\"id\"];
// Name of whats being sent
$typename = $db_slist->Record[\"name\"];
// This part gets the date to send for that day
$date = date(\"j-n-Y\");
$today = date(\"z\");
// Filename
$filename = $gp_sitepath . $db_slist->Record[\"data_dir\"] . $today . \".txt\";
// Main text
$content = $mf->getdata($filename);
// Get what databases are needed
$table = $mf->gettable_names($db_slist->Record[\"table_names\"]);
if ($table[0]) {
$dbinfo = new DB_mydbase;
$query = \"SELECT * FROM $table[0] WHERE id = \'\" . $today . \"\'\";
$dbinfo->query($query);
$dbinfo->next_record();
$title = $dbinfo->Record[\"title\"];
}
$rawtext = $title . \"\n\n\" . $content;
// Subject
$subject = $typename . \": \" . $date . \" -- http://www.mysite.com\";
$dbusers = new DB_mydb;
$query = \"SELECT * FROM subscription WHERE confirm = 1 ORDER BY id\";
$dbusers->query($query);
while ($dbusers->next_record()) {
if ($typename == \"mydailypic\") {
unset($rawtext);
$maillistnum2 = $dbusers->Record[\"maillist\"] - 1;
if (substr($dbusers->Record[\"maillist\"], $maillistnum2, 1) == 1) {
if ($dbusers->Record[\"dptype\"] == 111) {
$rawtext = $mf->dailypic($db_slist->Record[\"data_dir\"], $gp_sitepath, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $ot = 1, $dp = \"jpg\");
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $mf->headers($from), $nosubjectinbody = 1);
$rawtext = $mf->dailypic($db_slist->Record[\"data_dir\"], $gp_sitepath, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $ot = 1, $dp = \"zip\");
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $mf->headers($from), $nosubjectinbody = 1);
} elseif ($dbusers->Record[\"dptype\"] == 110) {
$rawtext = $mf->dailypic($db_slist->Record[\"data_dir\"], $gp_sitepath, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $ot = 2, $dp = \"zip\");
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $mf->headers($from), $nosubjectinbody = 1);
$rawtext = $mf->dailypic($db_slist->Record[\"data_dir\"], $gp_sitepath, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $ot = 2, $dp = \"jpg\");
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $mf->headers($from), $nosubjectinbody = 1);
} elseif ($dbusers->Record[\"dptype\"] == 101) {
$rawtext = $mf->dailypic($db_slist->Record[\"data_dir\"], $gp_sitepath, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $ot = 1, $dp = \"zip\");
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $mf->headers($from), $nosubjectinbody = 1);
} elseif ($dbusers->Record[\"dptype\"] == 100) {
$rawtext = $mf->dailypic($db_slist->Record[\"data_dir\"], $gp_sitepath, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $ot = 2, $dp = \"zip\");
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $mf->headers($from), $nosubjectinbody = 1);
} elseif ($dbusers->Record[\"dptype\"] == 010) {
$rawtext = $mf->dailypic($db_slist->Record[\"data_dir\"], $gp_sitepath, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $ot = 2, $dp = \"jpg\");
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $mf->headers($from), $nosubjectinbody = 1);
} elseif ($dbusers->Record[\"dptype\"] == 011) {
$rawtext = $mf->dailypic($db_slist->Record[\"data_dir\"], $gp_sitepath, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $ot = 1, $dp = \"jpg\");
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $mf->headers($from), $nosubjectinbody = 1);
} elseif ($dbusers->Record[\"dptype\"] == 001) {
$rawtext = $mf->dailypic($db_slist->Record[\"data_dir\"], $gp_sitepath, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $ot = 1, $dp = \"link\");
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $mf->headers($from), $nosubjectinbody = 1);
}
} else {
$mailsent = 0;
}
} else {
$rawtext = $mf->replace_all($rawtext);
$mailsent = $mf->sendto($maillistnum, $rawtext, $dbusers->Record[\"id\"], $dbusers->Record[\"email\"], $dbusers->Record[\"maillist\"], $subject, $from, $typename, $headers, $nosubjectinbody);
}
$mailsent2[] = $mailsent;
$email2[] = $dbusers->Record[\"email\"];
}
if ($mailsent2) {
$mf->send_comfirm($mailsent2, $email2, $typename);
$mf->update_subscribe_log($mailsent2, $db_slist->Record[\"id\"], $db_slist->Record[\"typeID\"]);
}
}
?>