What is wrong with this code, HELP!

[Anon]

The code below is supposed to send either a .jpg file, a .zip or a link acording to what the client choose.

A e-mail is sent but with nothing in it, 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

<?
//get the needed dbases
$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_mydbase;
		$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"]);
		}
	}

?>

[tinuviel]

Newman, may we see your sendto() function? It may be in there...
Tin

[Anon]

<?

// Required files
require(\"gp_mailfunction.php\");//this file
// 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;

// *********************************************************************************************************************************************************
// Type 1 = Daily mailing
// *********************************************************************************************************************************************************
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_afamilia;
		$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\"]);
		}
	}

?>

[tinuviel]

I'm sorry Newman, I think you misunderstood me, I wanted to see the actual functions sendto and send_confirm. It looks like they are housed in gp_mailfunction.php.

Angie