function hosts_save()
{
$ID = $_POST["ID"];
$ipClass = new IP();
if (!$ipClass->isValid($_POST["ipaddr"])) {
echo "Invalid IP address:{$_POST["ipaddr"]}\n";
return;
}
$ip2Long2 = ip2Long2($_POST["ipaddr"]);
if ($ID > 0) {
$sql = "UPDATE dnsmasq_records SET `hostname`='{$_POST["hostname"]}',`ipaddr`='{$_POST["ipaddr"]}',`ipaddrton`='{$ip2Long2}' WHERE ID='{$ID}'";
} else {
$sql = "INSERT IGNORE INTO dnsmasq_records(`hostname`,`ipaddr`,`ipaddrton`)\n\t\tVALUES ('{$_POST["hostname"]}',\t'{$_POST["ipaddr"]}','{$ip2Long2}');\n\t\t";
}
$q = new mysql_squid_builder();
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error . "\n***{$sql}\n****\n";
}
}
function NewipaddrLink_save()
{
$ADDR = explode(".", $_POST["ipaddr"]);
while (list($a, $b) = each($ADDR)) {
$ADDR[$a] = intval($b);
}
$_POST["ipaddr"] = @implode(".", $ADDR);
$_POST["hostname"] = strtolower($_POST["hostname"]);
$ip2Long2 = ip2Long2($_POST["ipaddr"]);
$q = new mysql_squid_builder();
if (!$q->TABLE_EXISTS('webfilters_ipaddr')) {
$sql = "CREATE TABLE `squidlogs`.`webfilters_ipaddr` (\n\t\t\t`ipaddr` VARCHAR( 90 ) NOT NULL PRIMARY KEY ,\n\t\t\t`uid` VARCHAR( 128 ) NOT NULL ,\n\t\t\t `ip` int(10) unsigned NOT NULL default '0',\n\t\t\t`hostname` VARCHAR( 128 ) NOT NULL,\n\t\t\t INDEX ( `uid`,`hostname`)\n\t\t\t) ENGINE = MYISAM;";
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error;
}
}
if (!$q->FIELD_EXISTS("webfilters_ipaddr", "ip")) {
$q->QUERY_SQL("ALTER TABLE `webfilters_ipaddr` ADD `ip` int(10) unsigned NOT NULL default '0',ADD INDEX ( `ip` )");
}
$q->CheckTables();
$_POST["uid"] = $q->StripBadChars_hostname($_POST["uid"]);
$_POST["hostname"] = $q->StripBadChars_hostname($_POST["hostname"]);
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT ipaddr FROM webfilters_ipaddr WHERE ipaddr='{$_POST["ipaddr"]}'"));
if ($ligne["ipaddr"] != null) {
$sql = "UPDATE webfilters_ipaddr SET uid='{$_POST["uid"]}',hostname='{$_POST["hostname"]}',`ip`='{$ip2Long2}' WHERE ipaddr='{$_POST["ipaddr"]}'";
} else {
$sql = "INSERT IGNORE INTO webfilters_ipaddr (ipaddr,hostname,uid,ip) VALUES ('{$_POST["ipaddr"]}','{$_POST["hostname"]}','{$_POST["uid"]}','{$ip2Long2}');";
}
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error;
}
}
function link_user_save()
{
$ipClass = new IP();
if (!$ipClass->IsvalidMAC($_POST["MAC"])) {
$_POST["MAC"] = null;
}
if (!$ipClass->isValid($_POST["ipaddr"])) {
$_POST["ipaddr"] = null;
}
$_POST["MAC"] = str_replace("-", ":", $_POST["MAC"]);
$_POST["MAC"] = strtolower($_POST["MAC"]);
$q = new mysql_squid_builder();
if (!$q->FIELD_EXISTS("webfilters_ipaddr", "ip")) {
$q->QUERY_SQL("ALTER TABLE `webfilters_ipaddr` ADD `ip` int(10) unsigned NOT NULL default '0',ADD INDEX ( `ip` )");
}
$_POST["uid"] = mysql_escape_string2($_POST["uid"]);
if ($_POST["MAC"] != null) {
$sql = "UPDATE webfilters_nodes SET uid='{$_POST["uid"]}' WHERE MAC='{$_POST["MAC"]}'";
$q = new mysql_squid_builder();
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT MAC FROM webfilters_nodes WHERE MAC='{$_POST["MAC"]}'"));
if ($ligne["MAC"] == null) {
$sql = "INSERT INTO webfilters_nodes (MAC,uid,hostname,nmapreport,nmap) \n\t\t\tVALUES ('{$_POST["MAC"]}','{$_POST["uid"]}','','',0)";
}
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo "Fatal:" . $q->mysql_error;
return;
}
return;
}
if ($_POST["ipaddr"] != null) {
$ip2Long2 = ip2Long2($_POST["ipaddr"]);
$sql = "UPDATE webfilters_ipaddr SET uid='{$_POST["uid"]}',`ip`='{$ip2Long2}' WHERE ipaddr='{$_POST["ipaddr"]}'";
$q = new mysql_squid_builder();
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT ipaddr FROM webfilters_ipaddr WHERE ipaddr='{$_POST["ipaddr"]}'"));
if ($ligne["ipaddr"] == null) {
$sql = "INSERT INTO webfilters_ipaddr (ipaddr,uid,ip,hostname) VALUES ('{$_POST["ipaddr"]}','{$_POST["uid"]}','{$ip2Long2}','')";
}
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo "Fatal:" . $q->mysql_error;
return;
}
return;
}
echo "Cannot associate a Proxy alias without any valid IP address or MAC address";
}
function proxy_alias_add($IPADDR = null, $MAC = null, $UID = null)
{
if ($IPADDR == null) {
if ($MAC == null) {
return;
}
}
$ipClass = new IP();
if (!$ipClass->IsvalidMAC($MAC)) {
$MAC = null;
}
if (!$ipClass->isValid($IPADDR)) {
$IPADDR = null;
}
if (!class_exists("mysql_squid_builder")) {
include_once dirname(__FILE__) . "/ressources/class.mysql.squid.builder.php";
}
$q = new mysql_squid_builder();
if (!$q->FIELD_EXISTS("webfilters_ipaddr", "ip")) {
$q->QUERY_SQL("ALTER TABLE `webfilters_ipaddr` ADD `ip` int(10) unsigned NOT NULL default '0',ADD INDEX ( `ip` )");
}
$UID = mysql_escape_string2($UID);
if ($MAC != null) {
$sql = "UPDATE webfilters_nodes SET uid='{$UID}' WHERE MAC='{$MAC}'";
$q = new mysql_squid_builder();
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT MAC FROM webfilters_nodes WHERE MAC='{$MAC}'"));
if ($ligne["MAC"] == null) {
$sql = "INSERT INTO webfilters_nodes (MAC,uid,hostname,nmapreport,nmap)\n\t\t\tVALUES ('{$MAC}','{$UID}','','',0)";
}
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo "Fatal:" . $q->mysql_error . "\n";
return;
}
return;
}
if ($IPADDR != null) {
$ip2Long2 = ip2Long2($IPADDR);
$sql = "UPDATE webfilters_ipaddr SET uid='{$UID}',`ip`='{$ip2Long2}' WHERE ipaddr='{$IPADDR}'";
$q = new mysql_squid_builder();
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT ipaddr FROM webfilters_ipaddr WHERE ipaddr='{$IPADDR}'"));
if ($ligne["ipaddr"] == null) {
$sql = "INSERT INTO webfilters_ipaddr (ipaddr,uid,ip,hostname) VALUES ('{$IPADDR}','{$UID}','{$ip2Long2}','')";
}
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo "Fatal:" . $q->mysql_error . "\n";
return;
}
return;
}
}
function link_user_save(){
$q=new mysql_squid_builder();
if(!$q->FIELD_EXISTS("webfilters_ipaddr", "ip")){
$q->QUERY_SQL("ALTER TABLE `webfilters_ipaddr` ADD `ip` int(10) unsigned NOT NULL default '0',ADD INDEX ( `ip` )");
}
$_POST["uid"]=mysql_escape_string2($_POST["uid"]);
if($_POST["MAC"]<>null){
$sql="UPDATE webfilters_nodes SET uid='{$_POST["uid"]}' WHERE MAC='{$_POST["MAC"]}'";
$q=new mysql_squid_builder();
$ligne=mysql_fetch_array($q->QUERY_SQL("SELECT MAC FROM webfilters_nodes WHERE MAC='{$_POST["MAC"]}'"));
if($ligne["MAC"]==null){
$sql="INSERT INTO webfilters_nodes (MAC,uid,hostname,nmapreport,nmap)
VALUES ('{$_POST["MAC"]}','{$_POST["uid"]}','','',0)";
}
$q->QUERY_SQL($sql);
if(!$q->ok){
echo "Fatal:".$q->mysql_error;
return;
}
$sock=new sockets();
$macenc=urlencode($_POST["MAC"]);
$uidenc=urlencode($_POST["uid"]);
$sock->getFrameWork("squid.php?user-retranslation-update=yes&MAC=$macenc&uid=$uidenc");
writelogs("squid.php?user-retranslation=yes&update=yes",__FUNCTION__,__FILE__,__LINE__);
$sock->getFrameWork("squid.php?user-retranslation=yes&update=yes");
return;
}
if($_POST["ipaddr"]<>null){
$ip2Long2=ip2Long2($_POST["ipaddr"]);
$sql="UPDATE webfilters_ipaddr SET uid='{$_POST["uid"]}',`ip`='$ip2Long2' WHERE ipaddr='{$_POST["ipaddr"]}'";
$q=new mysql_squid_builder();
$ligne=mysql_fetch_array($q->QUERY_SQL("SELECT ipaddr FROM webfilters_ipaddr WHERE ipaddr='{$_POST["ipaddr"]}'"));
if($ligne["ipaddr"]==null){
$sql="INSERT INTO webfilters_ipaddr (ipaddr,uid,ip,hostname) VALUES ('{$_POST["ipaddr"]}','{$_POST["uid"]}','$ip2Long2','')";
}
$q->QUERY_SQL($sql);
if(!$q->ok){echo $q->mysql_error;return;}
$sock=new sockets();
$sock->getFrameWork("squid.php?user-retranslation=yes&update=yes");
return;
}
$sock=new sockets();
$sock->getFrameWork("squid.php?user-retranslation=yes&update=yes");
}
