static function doUpdateConfig()
 {
     global $zdbh;
     global $controller;
     runtime_csfr::Protect();
     $sql = "SELECT * FROM x_settings WHERE so_module_vc=:name AND so_usereditable_en = 'true'";
     //$numrows = $zdbh->query($sql);
     $name = ui_module::GetModuleName();
     $numrows = $zdbh->prepare($sql);
     $numrows->bindParam(':name', $name);
     $numrows->execute();
     if ($numrows->fetchColumn() != 0) {
         $sql = $zdbh->prepare($sql);
         $sql->bindParam(':name', $name);
         $sql->execute();
         while ($row = $sql->fetch()) {
             if (!fs_director::CheckForEmptyValue($controller->GetControllerRequest('FORM', $row['so_name_vc']))) {
                 $updatesql = $zdbh->prepare("UPDATE x_settings SET so_value_tx = :name2 WHERE so_name_vc = :so_name_vc");
                 $name2 = $controller->GetControllerRequest('FORM', $row['so_name_vc']);
                 $updatesql->bindParam(':name2', $name2);
                 $updatesql->bindParam(':so_name_vc', $row['so_name_vc']);
                 $updatesql->execute();
             }
         }
     }
     self::$ok = true;
 }
 static function doUpdateDNSConfig()
 {
     global $zdbh;
     global $controller;
     $sql = "SELECT COUNT(*) FROM x_settings WHERE so_module_vc=:moduleName AND so_usereditable_en = 'true'";
     $numrows = $zdbh->prepare($sql);
     $GetModuleName = ui_module::GetModuleName();
     $numrows->bindParam(':moduleName', $GetModuleName);
     if ($numrows->execute()) {
         if ($numrows->fetchColumn() != 0) {
             $sql = $zdbh->prepare("SELECT * FROM x_settings WHERE so_module_vc=:moduleName AND so_usereditable_en = 'true'");
             $GetModuleName = ui_module::GetModuleName();
             $sql->bindParam(':moduleName', $GetModuleName);
             $sql->execute();
             while ($row = $sql->fetch()) {
                 if (!fs_director::CheckForEmptyValue($controller->GetControllerRequest('FORM', $row['so_name_vc']))) {
                     $name = $controller->GetControllerRequest('FORM', $row['so_name_vc']);
                     $name2 = $row['so_name_vc'];
                     $updatesql = $zdbh->prepare("UPDATE x_settings SET so_value_tx = :name WHERE so_name_vc = :name2");
                     $updatesql->bindParam(':name', $name);
                     $updatesql->bindParam(':name2', $name2);
                     $updatesql->execute();
                     self::TriggerDNSUpdate("0");
                 }
             }
         }
     }
 }
 static function getModuleName()
 {
     $module_name = ui_module::GetModuleName();
     return $module_name;
 }
    static function getCopyright()
    {
        $message = '<font face="ariel" size="2">' . ui_module::GetModuleName() . ' v20.2.0.0 &copy; 2013-' . date("Y") . ' by <a target="_blank" href="http://forums.sentora.org/member.php?action=profile&uid=2">TGates</a> for <a target="_blank" href="http://sentora.org">Sentora Control Panel</a>&nbsp;&#8212;&nbsp;Help support future development of this module and donate today!</font>
<form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_blank">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="DW8QTHWW4FMBY">
<input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_donate_SM.gif" width="70" height="21" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>';
        return $message;
    }
 static function doUpdateConfig()
 {
     global $zdbh;
     global $controller;
     runtime_csfr::Protect();
     $sql = "SELECT * FROM x_settings WHERE so_module_vc=:module AND so_usereditable_en = 'true'";
     $module = ui_module::GetModuleName();
     $numrows = $zdbh->prepare($sql);
     $numrows->bindParam(':module', $module);
     $numrows->execute();
     if ($numrows->fetchColumn() <> 0) {
         $sql = $zdbh->prepare($sql);
         $sql->bindParam(':module', $module);
         $sql->execute();
         while ($row = $sql->fetch()) {
             if (!fs_director::CheckForEmptyValue($controller->GetControllerRequest('FORM', $row['so_name_vc']))) {
                 $updatesql = $zdbh->prepare("UPDATE x_settings SET so_value_tx = :value WHERE so_name_vc = :so_name_vc");
                 $value = $controller->GetControllerRequest('FORM', $row['so_name_vc']);
                 $updatesql->bindParam(':value', $value);
                 $updatesql->bindParam(':so_name_vc', $row['so_name_vc']);
                 $updatesql->execute();
             }
         }
         self::SetWriteApacheConfigTrue(); #sentora apache port changed require rewrite of vhosts
     }
     self::$ok = true;
 }
 static function getModuleName()
 {
     $module_name = ui_language::translate(ui_module::GetModuleName());
     return $module_name;
 }
 static function doUpdateApacheConfig()
 {
     global $zdbh;
     global $controller;
     runtime_csfr::Protect();
     $sql = "SELECT COUNT(*) FROM x_settings WHERE so_module_vc=:module AND so_usereditable_en = 'true'";
     $moduleName = ui_module::GetModuleName();
     $numrows = $zdbh->prepare($sql);
     $numrows->bindParam(':module', $moduleName);
     $numrows->execute();
     if ($numrows) {
         if ($numrows->fetchColumn() != 0) {
             $moduleName2 = ui_module::GetModuleName();
             $sql = $zdbh->prepare("SELECT * FROM x_settings WHERE so_module_vc=:module AND so_usereditable_en = 'true'");
             $sql->bindParam(':module', $moduleName2);
             $sql->execute();
             while ($row = $sql->fetch()) {
                 //if (!fs_director::CheckForEmptyValue($controller->GetControllerRequest('FORM', $row['so_name_vc']))) {
                 $value = $controller->GetControllerRequest('FORM', $row['so_name_vc']);
                 $name = $row['so_name_vc'];
                 $updatesql = $zdbh->prepare("UPDATE x_settings SET so_value_tx = :value WHERE so_name_vc = :name");
                 $updatesql->bindParam(':value', $value);
                 $updatesql->bindParam(':name', $name);
                 $updatesql->execute();
                 self::SetWriteApacheConfigTrue();
                 //}
             }
         }
     }
 }