status won't enable using squirrelmail

[NetAxiz]

I have gold fish working
but am having problems setting an auto responder through my squirrel
mail interface

the autoreply page displays but when I try to enable an autoresponder,
when i click on enable , put in the dates , subject and message and
click on configure button , it simply waits a short while and then
resorts back to disabled with a message ontop saying liunkconnect
I changed the following lines in the autoreply.php to reflect my
database information


$conf['mysql_host'] = "localhost";
$conf['mysql_user'] = "mail_admin";
$conf['mysql_password'] = "mypasswordhere";
$conf['mysql_database'] = "mail";

any ideas or tips on what to check would be muchly appreciated
thanks

[John Ray Abamonga]

hi Netaxis,

i experience your error try to separate the date i think it would help


global $ddf, $mmf, $yyf, $dde, $mme, $yye, $subject, $message;
$ddf = date("d");
$mmf = date("m");
$yyf = date("Y");

and at this line

$result = mysql_query("insert into autoresponder values('$username','Auto Responder','$df','$de','$mes',$stat,'$sub')");

Thanks,
JR

[John Ray Abamonga]

Sorry for not so clear replay here is the 

code.. Hope it can help

global $username, $data_dir, $testusername;

global $ddf, $mmf, $yyf, $dde, $mme, $yye, $subject, $message;

$ddf = date("d");

$mmf = date("m");

$yyf = date("Y");

$conf['mysql_host'] = "localhost";

$conf['mysql_user'] = "mail_admin";

$conf['mysql_password'] = "mypass";

$conf['mysql_database'] = "mail";

$link = @mysql_connect($conf['mysql_host'], $conf['mysql_user'], $conf['mysql_password']);

if ($link) {

echo "Linking... ";

  if (mysql_select_db($conf['mysql_database'])) {

     //

   echo "Connected to Server!";

        }

}

if ($_POST['azione'] == "UPDATE") {

   $result = mysql_query("delete from autoresponder where email = '" . $testusername . "'");

   $df = $_POST['yyf'] . "-" . $_POST['mmf'] . "-" . $_POST['ddf'];

   $de = $_POST['yye'] . "-" . $_POST['mme'] . "-" . $_POST['dde'];

   $mes = str_replace("'","''",$_POST['message']);

   $stat = $_POST['enabled'];

   $sub =  str_replace("'","''",$_POST['subject']);

  #$result = mysql_query("insert into autoresponder values ('" . $testusername . "', '" . $df . "','" . $de . "','" .  str_replace("'","''",$_POST['message']) . "'," . $_POST['enabled'] . ", '" . str_replace("'","''",$_POST['subject']) . "');");

$result = mysql_query("insert into autoresponder values('$testusername','Auto Responder','$df','$de','$mes',$stat,'$sub')");

On Thu, Jul 23, 2009 at 8:47 PM, Clive Gerada <cge...@gmail.com> wrote:

Thanks for the Help JR

I'm Not sure i understand what you mean by seperate the date
my autoreply.php around the date area looks like so

global $username, $data_dir;

global $ddf, $mmf, $yyf, $dde, $mme, $yye, $subject, $message;
$ddf = date("d");
$mmf = date("m");
$yyf = date("Y");

$conf['mysql_host'] = "localhost";
$conf['mysql_user'] = "mail_admin";

$conf['mysql_password'] = "123scuba";
$conf['mysql_database'] = "mail";

$link = @mysql_connect($conf['mysql_host'], $conf['mysql_user'],
$conf['mysql_password']);
if ($link) {
echo "Liunk";
 if (mysql_select_db($conf['mysql_database'])) {
    //
  echo "Connect";
 }
}
if ($_POST['azione'] == "UPDATE") {
  $result = mysql_query("delete from autoresponder where email = '" .
$username . "'");
  $df = $_POST['yyf'] . "-" . $_POST['mmf'] . "-" . $_POST['ddf'];
  $de = $_POST['yye'] . "-" . $_POST['mme'] . "-" . $_POST['dde'];

  $result = mysql_query("insert into autoresponder values ('" .

$username . "', '" . $df . "','" . $de . "','" .
str_replace("'","''",$_POST['message']) . "'," . $_POST['enabled'] . ",
'" . str_replace("'","''",$_POST['subject']) . "');");
}
$result = mysql_query("select subject from autoresponder where email =
'" . $username . "'");
$subject = mysql_result($result, 0, 'subject');
$result = mysql_query("select message from autoresponder where email =
'" . $username . "'");
$message = mysql_result($result, 0, 'message');
$result = mysql_query("select enabled from autoresponder where email =
'" . $username . "'");
$enabled = mysql_result($result, 0, 'enabled');
$result = mysql_query("select `from` from autoresponder where email = '"
. $username . "'");
$data = explode("-",mysql_result($result, 0, 'from'));

On Thu, Jul 23, 2009 at 05:54:27PM +0800, John Ray Abamonga wrote:
>    hi Netaxis,
>
>    i experience your error try to separate the date i think it would help
>
>    global $ddf, $mmf, $yyf, $dde, $mme, $yye, $subject, $message;
>    $ddf = date("d");
>    $mmf = date("m");
>    $yyf = date("Y");
>
>    and at this line
>
>    $result = mysql_query("insert into autoresponder values('$username','Auto
>    Responder','$df','$de','$mes',$stat,'$sub')");
>
>    Thanks,
>    JR
>

>    On Wed, Jul 22, 2009 at 7:31 PM, NetAxiz <[1]cge...@gmail.com> wrote:
>
>      I have gold fish working
>      �but am having problems setting an auto responder through my squirrel
>      mail interface
>
>      the autoreply page displays but when I try to enable an autoresponder,
>      when i click on enable , put in the dates , subject and message and
>      click on configure button , it simply waits a short while and then
>      resorts back to disabled �with a message ontop saying �liunkconnect
>      �I changed the following lines in the autoreply.php to reflect my
>      database information
>
>      $conf['mysql_host'] = "localhost";
>      $conf['mysql_user'] = "mail_admin";
>      $conf['mysql_password'] = "mypasswordhere";
>      $conf['mysql_database'] = "mail";
>
>      any ideas or tips on what to check would be muchly appreciated
>      thanks
>
>    >

> References
>
>    Visible links
>    1. mailto:cge...@gmail.com

--
Clive