From 5ca959fa688255a8de61f89fe2751eb4d24a6912 Mon Sep 17 00:00:00 2001
From: Florian Schaal <florian@schaal-24.de>
Date: Tue, 22 Mar 2016 09:22:07 -0400
Subject: [PATCH] fixed typo

---
 server/plugins-available/xmpp_plugin.inc.php |   47 ++++++++++++++++++++++++-----------------------
 1 files changed, 24 insertions(+), 23 deletions(-)

diff --git a/server/plugins-available/xmpp_plugin.inc.php b/server/plugins-available/xmpp_plugin.inc.php
index 2176cc5..128a88e 100644
--- a/server/plugins-available/xmpp_plugin.inc.php
+++ b/server/plugins-available/xmpp_plugin.inc.php
@@ -1,9 +1,7 @@
 <?php
 
-
-// TODO Plugin bei Installation symlinken in plugins-enabled!
 /*
-Copyright (c) 2007, Till Brehm, projektfarm Gmbh
+Copyright (c) 2015 Michael Fürmann, Spicy Web (spicyweb.de)
 All rights reserved.
 
 Redistribution and use in source and binary forms, with or without modification,
@@ -34,7 +32,6 @@
 
     var $plugin_name = 'xmpp_server_plugin';
     var $class_name = 'xmpp_server_plugin';
-
 
     var $xmpp_config_dir = '/etc/metronome';
 
@@ -100,20 +97,22 @@
         $old_ini_data = $app->ini_parser->parse_ini_string($data['old']['config']);
         $xmpp_config = $app->getconf->get_server_config($conf['server_id'], 'xmpp');
 
+        // Global server config
         $tpl = new tpl();
         $tpl->newTemplate('metronome_conf_global.master');
-
         $tpl->setVar('ipv6', $xmpp_config['xmpp_use_ipv6']=='y'?'true':'false');
         $tpl->setVar('bosh_timeout', intval($xmpp_config['xmpp_bosh_max_inactivity']));
         $tpl->setVar('port_http', intval($xmpp_config['xmpp_port_http']));
         $tpl->setVar('port_https', intval($xmpp_config['xmpp_port_https']));
         $tpl->setVar('port_pastebin', intval($xmpp_config['xmpp_port_pastebin']));
         $tpl->setVar('port_bosh', intval($xmpp_config['xmpp_port_bosh']));
+        // Global server admins (for all hosted domains)
         $admins = '';
         foreach(explode(',', $xmpp_config['xmpp_server_admins']) AS $a)
             $admins.= "\t\"".trim($a)."\",\n";
         $tpl->setVar('server_admins', $admins);
         unset($admins);
+        // enabled modules, so own modules or simmilar prosody-modules can easily be added
         $modules = '';
         foreach(explode(',', $xmpp_config['xmpp_modules_enabled']) AS $m)
             $modules.= "\t\"".trim($m)."\",\n";
@@ -149,13 +148,14 @@
         $tpl->setVar('domain', $data['new']['domain']);
         $tpl->setVar('active', $data['new']['active'] == 'y' ? 'true' : 'false');
         $tpl->setVar('public_registration', $data['new']['public_registration'] == 'y' ? 'true' : 'false');
-
+        // Domain admins
         $admins = array();
         foreach(explode(',',$data['new']['domain_admins']) AS $adm){
             $admins[] = trim($adm);
         }
         $tpl->setVar('domain_admins', "\t\t\"".implode("\",\n\t\t\"",$admins)."\"\n");
 
+        // Enable / Disable features
         if($data['new']['use_pubsub']=='y'){
             $tpl->setVar('use_pubsub', 'true');
             $status_comps[] = 'pubsub.'.$data['new']['domain'];
@@ -188,6 +188,7 @@
             $status_comps[] = 'muc.'.$data['new']['domain'];
             $tpl->setVar('muc_restrict_room_creation', $data['new']['muc_restrict_room_creation']);
             $tpl->setVar('muc_name', strlen($data['new']['muc_name']) ? $data['new']['muc_name'] : $data['new']['domain'].' Chatrooms');
+            // Admins for MUC channels
             $admins = array();
             foreach(explode(',',$data['new']['muc_admins']) AS $adm){
                 $admins[] = trim($adm);
@@ -242,7 +243,7 @@
         exec('rm -rf /var/lib/metronome/'.$folder);
         exec('rm -rf /var/lib/metronome/*%2e'.$folder);
 
-        $app->services->restartServiceDelayed('metronome', 'restart');
+        $app->services->restartServiceDelayed('metronome', 'reload');
     }
 
     function userInsert($event_name, $data){
@@ -314,17 +315,17 @@
             exec("(cd /etc/metronome/certs && make $domain.csr)");
             exec("(cd /etc/metronome/certs && make $domain.cert)");
 
-            $ssl_key = $app->db->quote($app->system->file_get_contents($key_file));
+            $ssl_key = $app->system->file_get_contents($key_file);
             $app->system->chmod($key_file, 0400);
             $app->system->chown($key_file, 'metronome');
-            $ssl_request = $app->db->quote($app->system->file_get_contents($csr_file));
-            $ssl_cert = $app->db->quote($app->system->file_get_contents($crt_file));
+            $ssl_request = $app->system->file_get_contents($csr_file);
+            $ssl_cert = $app->system->file_get_contents($crt_file);
             /* Update the DB of the (local) Server */
-            $app->db->query("UPDATE xmpp_domain SET ssl_request = '$ssl_request', ssl_cert = '$ssl_cert', ssl_key = '$ssl_key' WHERE domain = '".$data['new']['domain']."'");
-            $app->db->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = '".$data['new']['domain']."'");
+            $app->db->query("UPDATE xmpp_domain SET ssl_request = ?, ssl_cert = ?, ssl_key = ? WHERE domain = ?", $ssl_request, $ssl_cert, $ssl_key, $data['new']['domain']);
+            $app->db->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = ?", $data['new']['domain']);
             /* Update also the master-DB of the Server-Farm */
-            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_request = '$ssl_request', ssl_cert = '$ssl_cert', ssl_key = '$ssl_key' WHERE domain = '".$data['new']['domain']."'");
-            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = '".$data['new']['domain']."'");
+            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_request = ?, ssl_cert = ?, ssl_key = ? WHERE domain = ?", $ssl_request, $ssl_cert, $ssl_key, $data['new']['domain']);
+            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = ?", $data['new']['domain']);
             $app->log('Creating XMPP SSL Cert for: '.$domain, LOGLEVEL_DEBUG);
         }
 
@@ -354,18 +355,18 @@
                 $app->system->chmod($key_file, 0400);
                 $app->system->chown($key_file, 'metronome');
             } else {
-                $ssl_key = $app->db->quote($app->system->file_get_contents($key_file));
+                $ssl_key = $app->system->file_get_contents($key_file);
                 /* Update the DB of the (local) Server */
-                $app->db->query("UPDATE xmpp_domain SET ssl_key = '$ssl_key' WHERE domain = '".$data['new']['domain']."'");
+                $app->db->query("UPDATE xmpp_domain SET ssl_key = ? WHERE domain = ?", $ssl_key, $data['new']['domain']);
                 /* Update also the master-DB of the Server-Farm */
-                $app->dbmaster->query("UPDATE xmpp_domain SET ssl_key = '$ssl_key' WHERE domain = '".$data['new']['domain']."'");
+                $app->dbmaster->query("UPDATE xmpp_domain SET ssl_key = '$ssl_key' WHERE domain = ?", $data['new']['domain']);
             }
 
             /* Update the DB of the (local) Server */
-            $app->db->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = '".$data['new']['domain']."'");
+            $app->db->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = ?", $data['new']['domain']);
 
             /* Update also the master-DB of the Server-Farm */
-            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = '".$data['new']['domain']."'");
+            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = ?", $data['new']['domain']);
             $app->log('Saving XMPP SSL Cert for: '.$domain, LOGLEVEL_DEBUG);
         }
 
@@ -381,11 +382,11 @@
             $app->system->unlink($key_file.'.bak');
             $app->system->unlink($cnf_file.'.bak');
             /* Update the DB of the (local) Server */
-            $app->db->query("UPDATE xmpp_domain SET ssl_request = '', ssl_cert = '', ssl_key = '' WHERE domain = '".$data['new']['domain']."'");
-            $app->db->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = '".$data['new']['domain']."'");
+            $app->db->query("UPDATE xmpp_domain SET ssl_request = '', ssl_cert = '', ssl_key = '' WHERE domain = ?", $data['new']['domain']);
+            $app->db->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = ?", $data['new']['domain']);
             /* Update also the master-DB of the Server-Farm */
-            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_request = '', ssl_cert = '', ssl_key = '' WHERE domain = '".$data['new']['domain']."'");
-            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = '".$data['new']['domain']."'");
+            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_request = '', ssl_cert = '', ssl_key = '' WHERE domain = ?", $data['new']['domain']);
+            $app->dbmaster->query("UPDATE xmpp_domain SET ssl_action = '' WHERE domain = ?", $data['new']['domain']);
             $app->log('Deleting SSL Cert for: '.$domain, LOGLEVEL_DEBUG);
         }
 

--
Gitblit v1.9.1