function execute_autconfig()
{
$sock = new sockets();
build_progress("Execute....", 5);
build_progress("Loading settings....", 5);
$SquidAutoconfWizard = unserialize($sock->GET_INFO("SquidAutoconfWizard"));
$DOMAIN = $SquidAutoconfWizard["DOMAIN"];
$LOCALNET = $SquidAutoconfWizard["LOCALNET"];
$PROXY = $SquidAutoconfWizard["PROXY"];
$PORT = $SquidAutoconfWizard["PORT"];
echo "DOMAIN.........: {$DOMAIN}\n";
echo "LOCALNET.......: {$LOCALNET}\n";
echo "PROXY..........: {$PROXY}:{$PORT}\n";
if ($DOMAIN == null) {
build_progress("Missing domain....", 110);
return;
}
if ($LOCALNET == null) {
build_progress("Missing LOCALNET....", 110);
return;
}
if ($PROXY == null) {
build_progress("Missing PROXY....", 110);
return;
}
if (!is_numeric($PORT)) {
build_progress("Missing PROXY PORT....", 110);
return;
}
build_progress("Creating wpad.{$DOMAIN}....", 10);
$webserver = "wpad.{$DOMAIN}";
$sock->SET_INFO("EnableFreeWeb", 1);
build_progress("Creating wpad.{$DOMAIN} (loading class)", 11);
$free = new freeweb($webserver);
$free->servername = $webserver;
$free->groupware = "WPADDYN";
$free->Params["ServerAlias"]["wpad"] = true;
$free->CreateSite();
build_progress("Building wpad.{$DOMAIN} and alias wpad", 15);
build_progress("Creating wpad.{$DOMAIN} (saving configuration)", 12);
build_progress("Creating wpad.{$DOMAIN} (reloading configuration)", 13);
rebuild_vhost($webserver);
build_progress("Creating wpad.{$DOMAIN} (reloading configuration {done})", 14);
build_progress("Building first rule...", 15);
$rulnename = mysql_escape_string2("Wizard - all to {$PROXY}:{$PORT}");
$sql = "INSERT IGNORE INTO `wpad_rules` (`rulename`,`enabled`,`zorder`,`dntlhstname`) VALUES ('{$rulnename}',1,0,1)";
$q = new mysql_squid_builder();
if (!$q->FIELD_EXISTS("wpad_rules", "zorder")) {
$q->QUERY_SQL("ALTER TABLE `wpad_rules` ADD `zorder` smallint( 2 ) DEFAULT '0',ADD INDEX (`zorder`)");
}
if (!$q->FIELD_EXISTS("wpad_sources_link", "zorder")) {
$q->QUERY_SQL("ALTER TABLE `wpad_sources_link` ADD `zorder` smallint( 2 ) DEFAULT '0',ADD INDEX (`zorder`)");
}
if (!$q->FIELD_EXISTS("wpad_rules", "dntlhstname")) {
$q->QUERY_SQL("ALTER TABLE `wpad_rules` ADD `dntlhstname` smallint( 1 ) DEFAULT '0'");
}
if (!$q->FIELD_EXISTS("wpad_destination_rules", "rulename")) {
$q->QUERY_SQL("ALTER TABLE `wpad_destination_rules` ADD `rulename` VARCHAR(255) NOT NULL, ADD INDEX (`rulename`)");
build_progress("Building first rule...MySQL error", 110);
if (!$q->ok) {
echo $q->mysql_error . "\n";
}
return;
}
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error . "\n";
build_progress("Building first rule...MySQL error", 110);
return;
}
$MAIN_RULE_ID = intval($q->last_id);
if ($MAIN_RULE_ID == 0) {
build_progress("Building first rule...MAIN_RULE_ID = 0!", 110);
return;
}
$zmd5 = md5("{$MAIN_RULE_ID}{$PROXY}{$PORT}");
build_progress("Add destination {$PROXY}:{$PORT}", 20);
$q->QUERY_SQL("INSERT IGNORE INTO wpad_destination (zmd5,aclid,proxyserver,proxyport,zorder)\n\t\t\tVALUES ('{$zmd5}','{$MAIN_RULE_ID}','{$PROXY}','{$PORT}',0)");
if (!$q->ok) {
echo $q->mysql_error . "\n";
build_progress("Add destination {$PROXY}:{$PORT} MySQL error", 110);
return;
}
build_progress("Creating Proxy object `Everyone`", 25);
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT ID FROM webfilters_sqgroups WHERE `GroupType`='all'"));
$SourceGroupID = intval($ligne["ID"]);
if ($SourceGroupID == 0) {
$sql = "INSERT IGNORE INTO webfilters_sqgroups (GroupName,GroupType,enabled,`acltpl`,`params`) VALUES ('Everyone','all','1','','');";
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error . "\n";
build_progress("Creating Proxy object `Everyone` MySQL error", 110);
return;
}
$SourceGroupID = intval($q->last_id);
}
if ($SourceGroupID == 0) {
build_progress("Creating Proxy object `Everyone` SourceGroupID = 0!", 110);
return;
}
build_progress("Creating Proxy object `WPAD - Local networks`", 25);
$ligne = mysql_fetch_array($q->QUERY_SQL("SELECT ID FROM webfilters_sqgroups WHERE `GroupName`='WPAD - Local networks'"));
$NetWorkGroupID = intval($ligne["ID"]);
if ($NetWorkGroupID == 0) {
$sql = "INSERT IGNORE INTO webfilters_sqgroups (GroupName,GroupType,enabled,`acltpl`,`params`) \n\t\t\t\tVALUES ('WPAD - Local networks','src','1','','');";
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error . "\n";
build_progress("Creating Proxy object `WPAD - Local networks` MySQL error", 110);
return;
}
$NetWorkGroupID = intval($q->last_id);
}
if ($NetWorkGroupID == 0) {
build_progress("Creating Proxy object `WPAD - Local networks` NetWorkGroupID = 0!", 110);
return;
}
$IP = new IP();
$LOCALNET_ARRAY = array();
if (strpos($LOCALNET, ",") > 0) {
$LOCALNET_ARRAY_TEMP = explode(",", $LOCALNET);
while (list($none, $line) = each($LOCALNET_ARRAY_TEMP)) {
$line = trim($line);
if (!$IP->isIPAddressOrRange($line)) {
continue;
}
$LOCALNET_ARRAY[] = "('{$line}','{$NetWorkGroupID}','1','')";
}
} else {
if ($IP->isIPAddressOrRange(trim($LOCALNET))) {
$LOCALNET_ARRAY[] = "('{$LOCALNET}','{$NetWorkGroupID}','1','')";
}
}
build_progress("Filling Proxy object `WPAD - Local networks`", 30);
$q->QUERY_SQL("DELETE FROM webfilters_sqitems WHERE gpid={$NetWorkGroupID}");
if (!$q->ok) {
echo $q->mysql_error . "\n";
build_progress("Filling Proxy object `WPAD - Local networks` MySQL error", 110);
return;
}
$sql = "INSERT INTO webfilters_sqitems (pattern,gpid,enabled,other)\n\tVALUES " . @implode(",", $LOCALNET_ARRAY);
$q->QUERY_SQL($sql);
if (!$q->ok) {
echo $q->mysql_error . "\n";
build_progress("Filling Proxy object `WPAD - Local networks` MySQL error", 110);
return;
}
build_progress("Linking Everyone - {$SourceGroupID} - to rule {$MAIN_RULE_ID}", 30);
$zmd5 = md5("{$MAIN_RULE_ID}{$SourceGroupID}");
$q->QUERY_SQL("INSERT INTO wpad_sources_link (zmd5,aclid,negation,gpid,zorder) VALUES ('{$zmd5}','{$MAIN_RULE_ID}','0','{$SourceGroupID}',1)");
if (!$q->ok) {
echo $q->mysql_error . "\n";
build_progress("MySQL error", 110);
return;
}
$zmd5 = md5("{$MAIN_RULE_ID}{$NetWorkGroupID}");
build_progress("Linking WPAD - Local networks - {$NetWorkGroupID} - to rule {$MAIN_RULE_ID}", 50);
$q->QUERY_SQL("INSERT INTO wpad_white_link (zmd5,aclid,negation,gpid,zorder) VALUES ('{$zmd5}','{$MAIN_RULE_ID}','0','{$NetWorkGroupID}',1)");
if (!$q->ok) {
echo $q->mysql_error . "\n";
build_progress("MySQL error", 110);
return;
}
build_progress("{success}", 100);
}
exit;
}
if (isset($_GET["reconfigure"])) {
freeweb_reconfigure();
exit;
}
if (isset($_GET["loaded-modules"])) {
freeweb_modules();
exit;
}
if (isset($_GET["force-resolv"])) {
force_resolv();
exit;
}
if (isset($_GET["rebuild-vhost"])) {
rebuild_vhost();
exit;
}
if (isset($_GET["getidof"])) {
getidof();
exit;
}
if (isset($_GET["ApacheAccount"])) {
ApacheAccount();
exit;
}
while (list($num, $line) = each($_GET)) {
$f[] = "{$num}={$line}";
}
writelogs_framework("unable to understand query !!!!!!!!!!!..." . @implode(",", $f), "main()", __FILE__, __LINE__);
die;
function create_articaweb($websitename)
{
if ($websitename == null) {
return;
}
$sock = new sockets();
$sock->SET_INFO("EnableFreeWeb", 1);
restart_artica_status();
restart_apache_src();
include_once dirname(__FILE__) . "/ressources/class.freeweb.inc";
$free = new freeweb($websitename);
$free->servername = $websitename;
$free->groupware = "ARTICA_ADM";
$free->CreateSite();
rebuild_vhost($websitename);
}
