[Phphelpdesk-help] PHPHelpDesk Script Add Job Error...

[Michael L. S. <ms...@su...>]

PHPHelpDesk is great! I have a question about the mailing option. When 
assigning a ticket to a person an e-mail is suppose to be sent, correct?
 But for some reason I doesn't send for me. The error is in 
addjop.scp.php.

Since the product is being used on an intranet the outside world cannot 
view it.

I get this error:

Warning: Failed to Connect in
 c:\apache\htdocs\helpdesk\scripts\addjob.scp.php on line 98

The code for that line is:

mail($mailto, $mailsubject, $mailbody, $mailheader);

The functions mailto, mailsubject, mailbody, and mailheader is:

      $mailto = "row[0]";
      $mailsubject = "$g_title - $l_summary: $txtSummary - $l_priority: 
$optPriority";
      $mailbody = "$txtSummary";
      $mailbody .= "\n\n";
      $mailbody .= "$txtDetail";
      $mailbody .= "\n\n";
      $mailbody .= "$l_senton $current_date $l_from $user";
      $mailheader = "From: $user@$g_mailservername";

One of the thoughts of reason for not working was that our mail server 
requires a SMTP username inorder to send mail.

In the general.conf.php file:
$g_mailservername = sultan.k12.wa.us

I see the MySQL Query commands in the earlier part of the code. (Before 
row[0])

    if ($optMailuser == "yes") {

      $queryemail = "SELECT s_email FROM security ";
      $queryemail .= "WHERE s_user='$lstAssignedto';";
      $mysql_result = query($queryemail);
      $row = mysql_fetch_row($mysql_result);

Since I am still new to PHP and MySQL Databasing and my knowledge on 
MySQL query commands is very limited I can only imagine what SELECT and 
FROM are. I viewed the database and found that s_email is a row in the 
security table. I also figured that "s" identifies it as "security." 

Anyway, PHPHelpDesk is an awesome product and will help the Sultan 
School District's Tech department answer problems throughout the 
district and I would really appreciate the help. Thank you.

Sincerely,
Michael Segle