if (checkMailbox($user, $host, $_REQUEST["email_addr"], $_REQUEST["mailbox_type"], $_REQUEST["server_addr"], $_REQUEST["login"], $_REQUEST["pass"])) {
$q = "INSERT INTO {$pro_mysql_fetchmail_table} (id,domain_user,domain_name,\n\t\tpop3_email,mailbox_type,pop3_server,pop3_login,pop3_pass)\n\t\tVALUES ('','{$user}','{$host}',\n\t\t'" . $_REQUEST["email_addr"] . "','" . $_REQUEST["mailbox_type"] . "','" . $_REQUEST["server_addr"] . "','" . $_REQUEST["login"] . "','" . $_REQUEST["pass"] . "');";
$r = mysql_query($q) or die("Cannot execute query \"{$q}\" ! line: " . __LINE__ . " file: " . __FILE__ . " sql said: " . mysql_error());
}
break;
// $q = " WHERE id='$user' AND mbox_host='$host';";
// action=modify_fetchmail&boxid=5&email_addr=zigo%40pplchat.com&mailbox_type=POP3&server_addr=gplhost.com&login=zigo%40pplchat.com&server_addr=master
// action=dtcemail_change_pass&newpass1=&newpass2=&submit=Ok
// $q = " WHERE id='$user' AND mbox_host='$host';";
// action=modify_fetchmail&boxid=5&email_addr=zigo%40pplchat.com&mailbox_type=POP3&server_addr=gplhost.com&login=zigo%40pplchat.com&server_addr=master
// action=dtcemail_change_pass&newpass1=&newpass2=&submit=Ok
case "modify_fetchmail":
if (!isRandomNum($_REQUEST["boxid"])) {
die("Box id is not a number!");
}
if (checkMailbox($user, $host, $_REQUEST["email_addr"], $_REQUEST["mailbox_type"], $_REQUEST["server_addr"], $_REQUEST["login"], $_REQUEST["pass"])) {
$q = "UPDATE {$pro_mysql_fetchmail_table} SET pop3_email='" . $_REQUEST["email_addr"] . "',\n\t\tpop3_server='" . $_REQUEST["server_addr"] . "',pop3_login='******',pop3_pass='******' WHERE domain_user='******' AND domain_name='{$host}' AND id='" . $_REQUEST["boxid"] . "';";
$r = mysql_query($q) or die("Cannot execute query \"{$q}\" ! line: " . __LINE__ . " file: " . __FILE__ . " sql said: " . mysql_error());
}
break;
case "del_fetchmail":
if (!isRandomNum($_REQUEST["boxid"])) {
die("Box id is not a number!");
}
$q = "DELETE FROM {$pro_mysql_fetchmail_table} WHERE domain_user='******' AND domain_name='{$host}' AND id='" . $_REQUEST["boxid"] . "';";
$r = mysql_query($q) or die("Cannot execute query \"{$q}\" ! line: " . __LINE__ . " file: " . __FILE__ . " sql said: " . mysql_error());
break;
case "dtcemail_change_pass":
if (!isDTCPassword($_REQUEST["newpass1"])) {
die("Incorrect password format!");
}
function checkPOP3()
{
global $pro_mysql_pop_table;
$q = "SELECT * FROM {$pro_mysql_pop_table} WHERE id NOT LIKE 'cyr%' LIMIT 1";
$r = mysql_query($q) or die("Cannot query {$q} in " . __FILE__ . " line " . __LINE__ . " sql said " . mysql_error());
$a = mysql_fetch_array($r);
if (checkMailbox($a["id"], $a["mbox_host"], $a["id"] . '@' . $a["mbox_host"], "POP3", "localhost", $a["id"] . '@' . $a["mbox_host"], $a["passwd"])) {
return true;
} else {
return false;
}
}
