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; } }