function mysql_action_enable_change()
{
$enable = $_GET["changemysqlenable"];
$artica = new artica_general();
$artica->EnableMysqlFeatures = $enable;
if ($enable == 0) {
$main = new main_cf();
$main->save_conf();
$main->save_conf_to_server();
}
$artica->SaveMysqlSettings();
$sock = new sockets();
$datas = $sock->getfile('restartmysql');
$datas = htmlentities($datas);
$tbl = explode("\n", $datas);
$datas = '';
while (list($num, $val) = each($tbl)) {
$datas = $datas . "<div>{$val}</div>";
}
echo "<div style='width:100%;height:500px;overflow:auto'>{$datas}</div>";
}
function SaveSqlSettings()
{
$ar = new artica_general();
writelogs("Save _GET[MysqlMaxEventsLogs]='{$_GET["MysqlMaxEventsLogs"]}'", __FUNCTION__, __FILE__);
$ar->EnableSyslogMysql = $_GET["EnableSyslogMysql"];
$ar->MysqlMaxEventsLogs = $_GET["MysqlMaxEventsLogs"];
$ar->MysqlAdminAccount = "{$_GET["mysqlroot"]}:{$_GET["pwd"]}";
$ar->SaveMysqlSettings();
$sock = new sockets();
$sock->getfile("synchronizeModules");
$datas = $sock->getfile('changemysqlpassword');
$tbl = explode("\n", $datas);
echo "\n";
while (list($num, $ligne) = each($tbl)) {
if (trim($ligne != null)) {
echo "{$ligne}\n";
}
}
}
function testsMysql(){
$_GET["mysqlpass"]=trim(base64_decode($_GET["mysqlpass"]));
writelogs("testing {$_GET["mysqlserver"]}:3306 with user {$_GET["mysql_account"]} and password \"{$_GET["mysqlpass"]}\"",__FUNCTION__,__FILE__,__LINE__);
$bd=@mysql_connect("{$_GET["mysqlserver"]}:3306",$_GET["mysql_account"],$_GET["mysqlpass"]);
$database=md5('Y-m-d H:i:s');
$tpl=new templates();
if(!$bd){
$errnum=mysql_errno();
$des=mysql_error();
echo "<div style='font-size:12px;color:red;font-weight:bold'>
<p>{connection}:ERR N.$errnum</p> $des
</div>";
exit;
}
$results=@mysql_query("CREATE DATABASE $database");
if(!$bd){
$errnum=mysql_errno();
$des=mysql_error();
echo RoundedLightWhite("<div style='font-size:12px;color:red;font-weight:bold'>
<p>{privileges}:ERR N.$errnum</p> $des
</div>");
exit;
}
$results=@mysql_query("DROP DATABASE $database");
$artica=new artica_general();
$artica->MysqlAdminAccount="{$_GET["mysql_account"]}:{$_GET["mysqlpass"]}";
$artica->MysqlServerName=$_GET["mysqlserver"];
$artica->SaveMysqlSettings();
$mysql=new mysql();
$mysql->mysql_server=$_GET["mysqlserver"];
$mysql->mysql_admin=$_GET["mysql_account"];
$mysql->mysql_password=$_GET["mysqlpass"];
$mysql->hostname=$_GET["mysqlserver"];
$mysql->BuildTables();
$tpl=new templates();
echo RoundedLightWhite($tpl->_ENGINE_parse_body('<div>{success} {edit} {mysql_account}</div>'));
}
function testsMysql()
{
$bd = @mysql_connect("{$_GET["mysqlserver"]}:3306", $_GET["mysql_account"], $_GET["mysqlpass"]);
$database = md5('Y-m-d H:i:s');
$tpl = new templates();
if (!$bd) {
$errnum = mysql_errno();
$des = mysql_error();
echo "<div style='font-size:12px;color:red;font-weight:bold'>\n \t\t\t\t<p>ERR N.{$errnum}</p> {$des}\n \t\t\t</div>";
exit;
}
$results = @mysql_query("CREATE DATABASE {$database}");
if (!$bd) {
$errnum = mysql_errno();
$des = mysql_error();
echo RoundedLightWhite("<div style='font-size:12px;color:red;font-weight:bold'>\n \t\t\t\t<p>ERR N.{$errnum}</p> {$des}\n \t\t\t</div>");
exit;
}
$results = @mysql_query("DROP DATABASE {$database}");
$artica = new artica_general();
$artica->MysqlAdminAccount = "{$_GET["mysql_account"]}:{$_GET["mysqlpass"]}";
$artica->MysqlServerName = $_GET["mysqlserver"];
$artica->SaveMysqlSettings();
$sock = new sockets();
$sock->getfile("synchronizeModules");
$sock->getfile("restartmysqldependencies");
$mysql = new mysql();
$mysql->mysql_server = $_GET["mysqlserver"];
$mysql->mysql_admin = $_GET["mysql_account"];
$mysql->mysql_password = $_GET["mysqlpass"];
$mysql->hostname = $_GET["mysqlserver"];
$mysql->BuildTables();
$tpl = new templates();
echo RoundedLightWhite($tpl->_ENGINE_parse_body('<div>{success} {edit} {mysql_account}</div>'));
}
