From b1a6a5a3991cec5cd08873b01376e45d0b247f18 Mon Sep 17 00:00:00 2001
From: Marius Cramer <m.cramer@pixcept.de>
Date: Thu, 14 Nov 2013 09:05:33 -0500
Subject: [PATCH] Cleaning up code to match coding guidelines
---
interface/lib/classes/remote.d/sites.inc.php | 595 +++++++++++++++++++++++++++++-----------------------------
1 files changed, 299 insertions(+), 296 deletions(-)
diff --git a/interface/lib/classes/remote.d/sites.inc.php b/interface/lib/classes/remote.d/sites.inc.php
index 37a79ba..a043ce1 100644
--- a/interface/lib/classes/remote.d/sites.inc.php
+++ b/interface/lib/classes/remote.d/sites.inc.php
@@ -40,12 +40,12 @@
class remoting_sites extends remoting {
// Website functions ---------------------------------------------------------------------------------------
-
+
//* Get cron details
public function sites_cron_get($session_id, $cron_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_cron_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -54,46 +54,46 @@
$app->remoting_lib->loadFormDef('../sites/form/cron.tform.php');
return $app->remoting_lib->getDataRecord($cron_id);
}
-
+
//* Add a cron record
public function sites_cron_add($session_id, $client_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_cron_add')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- return $this->insertQuery('../sites/form/cron.tform.php',$client_id,$params);
+ return $this->insertQuery('../sites/form/cron.tform.php', $client_id, $params);
}
-
+
//* Update cron record
public function sites_cron_update($session_id, $client_id, $cron_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_cron_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->updateQuery('../sites/form/cron.tform.php',$client_id,$cron_id,$params);
+ $affected_rows = $this->updateQuery('../sites/form/cron.tform.php', $client_id, $cron_id, $params);
return $affected_rows;
}
-
+
//* Delete cron record
public function sites_cron_delete($session_id, $cron_id)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_cron_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->deleteQuery('../sites/form/cron.tform.php',$cron_id);
+ $affected_rows = $this->deleteQuery('../sites/form/cron.tform.php', $cron_id);
return $affected_rows;
}
-
+
// ----------------------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_database_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_database_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -102,17 +102,17 @@
$app->remoting_lib->loadFormDef('../sites/form/database.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_database_add($session_id, $client_id, $params)
- {
- global $app;
-
+ {
+ global $app;
+
if(!$this->checkPerm($session_id, 'sites_database_add')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
+
//* Check for duplicates
$tmp = $app->db->queryOneRecord("SELECT count(database_id) as dbnum FROM web_database WHERE database_name = '".$app->db->quote($params['database_name'])."' AND server_id = '".intval($params["server_id"])."'");
if($tmp['dbnum'] > 0) {
@@ -120,66 +120,66 @@
return false;
}
- $sql = $this->insertQueryPrepare('../sites/form/database.tform.php', $client_id, $params);
- if($sql !== false) {
- $app->uses('sites_database_plugin');
-
- $this->id = 0;
- $this->dataRecord = $params;
- $app->sites_database_plugin->processDatabaseInsert($this);
+ $sql = $this->insertQueryPrepare('../sites/form/database.tform.php', $client_id, $params);
+ if($sql !== false) {
+ $app->uses('sites_database_plugin');
- return $this->insertQueryExecute($sql, $params);
- }
-
- return false;
+ $this->id = 0;
+ $this->dataRecord = $params;
+ $app->sites_database_plugin->processDatabaseInsert($this);
+
+ return $this->insertQueryExecute($sql, $params);
+ }
+
+ return false;
}
-
+
//* Update a record
public function sites_database_update($session_id, $client_id, $primary_id, $params)
- {
- global $app;
-
+ {
+ global $app;
+
if(!$this->checkPerm($session_id, 'sites_database_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
+
$sql = $this->updateQueryPrepare('../sites/form/database.tform.php', $client_id, $primary_id, $params);
- if($sql !== false) {
- $app->uses('sites_database_plugin');
-
- $this->id = $primary_id;
- $this->dataRecord = $params;
- $app->sites_database_plugin->processDatabaseUpdate($this);
- return $this->updateQueryExecute($sql, $primary_id, $params);
- }
-
- return false;
+ if($sql !== false) {
+ $app->uses('sites_database_plugin');
+
+ $this->id = $primary_id;
+ $this->dataRecord = $params;
+ $app->sites_database_plugin->processDatabaseUpdate($this);
+ return $this->updateQueryExecute($sql, $primary_id, $params);
+ }
+
+ return false;
}
-
+
//* Delete a record
public function sites_database_delete($session_id, $primary_id)
- {
- global $app;
+ {
+ global $app;
if(!$this->checkPerm($session_id, 'sites_database_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
- $app->uses('sites_database_plugin');
- $app->sites_database_plugin->processDatabaseDelete($primary_id);
-
- $affected_rows = $this->deleteQuery('../sites/form/database.tform.php',$primary_id);
+
+ $app->uses('sites_database_plugin');
+ $app->sites_database_plugin->processDatabaseDelete($primary_id);
+
+ $affected_rows = $this->deleteQuery('../sites/form/database.tform.php', $primary_id);
return $affected_rows;
}
-
+
// ----------------------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_database_user_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_database_user_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -188,81 +188,81 @@
$app->remoting_lib->loadFormDef('../sites/form/database_user.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_database_user_add($session_id, $client_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_database_user_add')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- return $this->insertQuery('../sites/form/database_user.tform.php', $client_id, $params);
+ return $this->insertQuery('../sites/form/database_user.tform.php', $client_id, $params);
}
-
+
//* Update a record
public function sites_database_user_update($session_id, $client_id, $primary_id, $params)
- {
- global $app;
-
+ {
+ global $app;
+
if(!$this->checkPerm($session_id, 'sites_database_user_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
$app->uses('remoting_lib');
$app->remoting_lib->loadFormDef('../sites/form/database_user.tform.php');
- $old_rec = $app->remoting_lib->getDataRecord($primary_id);
-
+ $old_rec = $app->remoting_lib->getDataRecord($primary_id);
+
$result = $this->updateQuery('../sites/form/database_user.tform.php', $client_id, $primary_id, $params);
-
- $new_rec = $app->remoting_lib->getDataRecord($primary_id);
-
- $records = $app->db->queryAllRecords("SELECT DISTINCT server_id FROM web_database WHERE database_user_id = '".$app->functions->intval($primary_id)."' UNION SELECT DISTINCT server_id FROM web_database WHERE database_ro_user_id = '".$app->functions->intval($primary_id)."'");
- foreach($records as $rec) {
- $tmp_rec = $new_rec;
- $tmp_rec['server_id'] = $rec['server_id'];
- $app->remoting_lib->datalogSave('UPDATE', $primary_id, $old_rec, $tmp_rec);
- }
- unset($new_rec);
- unset($old_rec);
- unset($records);
-
- return $result;
- }
-
+
+ $new_rec = $app->remoting_lib->getDataRecord($primary_id);
+
+ $records = $app->db->queryAllRecords("SELECT DISTINCT server_id FROM web_database WHERE database_user_id = '".$app->functions->intval($primary_id)."' UNION SELECT DISTINCT server_id FROM web_database WHERE database_ro_user_id = '".$app->functions->intval($primary_id)."'");
+ foreach($records as $rec) {
+ $tmp_rec = $new_rec;
+ $tmp_rec['server_id'] = $rec['server_id'];
+ $app->remoting_lib->datalogSave('UPDATE', $primary_id, $old_rec, $tmp_rec);
+ }
+ unset($new_rec);
+ unset($old_rec);
+ unset($records);
+
+ return $result;
+ }
+
//* Delete a record
public function sites_database_user_delete($session_id, $primary_id)
- {
- global $app;
-
+ {
+ global $app;
+
if(!$this->checkPerm($session_id, 'sites_database_user_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
- $app->db->datalogDelete('web_database_user', 'database_user_id', $primary_id);
- $affected_rows = $this->deleteQuery('../sites/form/database_user.tform.php',$primary_id);
-
- $records = $app->db->queryAllRecords("SELECT database_id FROM web_database WHERE database_user_id = '".$app->functions->intval($primary_id)."'");
- foreach($records as $rec) {
- $app->db->datalogUpdate('web_database','database_user_id=NULL','database_id', $rec['database_id']);
-
- }
- $records = $app->db->queryAllRecords("SELECT database_id FROM web_database WHERE database_ro_user_id = '".$app->functions->intval($primary_id)."'");
- foreach($records as $rec) {
- $app->db->datalogUpdate('web_database','database_ro_user_id=NULL','database_id', $rec['database_id']);
- }
-
+
+ $app->db->datalogDelete('web_database_user', 'database_user_id', $primary_id);
+ $affected_rows = $this->deleteQuery('../sites/form/database_user.tform.php', $primary_id);
+
+ $records = $app->db->queryAllRecords("SELECT database_id FROM web_database WHERE database_user_id = '".$app->functions->intval($primary_id)."'");
+ foreach($records as $rec) {
+ $app->db->datalogUpdate('web_database', 'database_user_id=NULL', 'database_id', $rec['database_id']);
+
+ }
+ $records = $app->db->queryAllRecords("SELECT database_id FROM web_database WHERE database_ro_user_id = '".$app->functions->intval($primary_id)."'");
+ foreach($records as $rec) {
+ $app->db->datalogUpdate('web_database', 'database_ro_user_id=NULL', 'database_id', $rec['database_id']);
+ }
+
return $affected_rows;
}
-
+
// ----------------------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_ftp_user_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_ftp_user_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -271,66 +271,66 @@
$app->remoting_lib->loadFormDef('../sites/form/ftp_user.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_ftp_user_add($session_id, $client_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_ftp_user_add')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- return $this->insertQuery('../sites/form/ftp_user.tform.php',$client_id,$params);
+ return $this->insertQuery('../sites/form/ftp_user.tform.php', $client_id, $params);
}
-
+
//* Update a record
public function sites_ftp_user_update($session_id, $client_id, $primary_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_ftp_user_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->updateQuery('../sites/form/ftp_user.tform.php',$client_id,$primary_id,$params);
+ $affected_rows = $this->updateQuery('../sites/form/ftp_user.tform.php', $client_id, $primary_id, $params);
return $affected_rows;
}
-
+
//* Delete a record
public function sites_ftp_user_delete($session_id, $primary_id)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_ftp_user_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->deleteQuery('../sites/form/ftp_user.tform.php',$primary_id);
+ $affected_rows = $this->deleteQuery('../sites/form/ftp_user.tform.php', $primary_id);
return $affected_rows;
}
-
+
//* Get server for an ftp user
public function sites_ftp_user_server_get($session_id, $ftp_user)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_ftp_user_server_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
+
$data = $app->db->queryOneRecord("SELECT server_id FROM ftp_user WHERE username = '".$app->db->quote($ftp_user)."'");
//file_put_contents('/tmp/test.txt', serialize($data));
- if(!isset($data['server_id'])) return false;
-
- $server = $this->server_get($session_id, $data['server_id'], 'server');
- //file_put_contents('/tmp/test2.txt', serialize($server));
-
+ if(!isset($data['server_id'])) return false;
+
+ $server = $this->server_get($session_id, $data['server_id'], 'server');
+ //file_put_contents('/tmp/test2.txt', serialize($server));
+
return $server;
}
-
+
// ----------------------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_shell_user_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_shell_user_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -339,46 +339,46 @@
$app->remoting_lib->loadFormDef('../sites/form/shell_user.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_shell_user_add($session_id, $client_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_shell_user_add')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- return $this->insertQuery('../sites/form/shell_user.tform.php',$client_id,$params);
+ return $this->insertQuery('../sites/form/shell_user.tform.php', $client_id, $params);
}
-
+
//* Update a record
public function sites_shell_user_update($session_id, $client_id, $primary_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_shell_user_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->updateQuery('../sites/form/shell_user.tform.php',$client_id,$primary_id,$params);
+ $affected_rows = $this->updateQuery('../sites/form/shell_user.tform.php', $client_id, $primary_id, $params);
return $affected_rows;
}
-
+
//* Delete a record
public function sites_shell_user_delete($session_id, $primary_id)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_shell_user_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->deleteQuery('../sites/form/shell_user.tform.php',$primary_id);
+ $affected_rows = $this->deleteQuery('../sites/form/shell_user.tform.php', $primary_id);
return $affected_rows;
}
-
+
// ----------------------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_web_domain_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_web_domain_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -387,7 +387,7 @@
$app->remoting_lib->loadFormDef('../sites/form/web_domain.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_web_domain_add($session_id, $client_id, $params, $readonly = false)
{
@@ -396,65 +396,65 @@
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
+
if(!isset($params['client_group_id']) or (isset($params['client_group_id']) && empty($params['client_group_id']))) {
$rec = $app->db->queryOneRecord("SELECT groupid FROM sys_group WHERE client_id = ".$app->functions->intval($client_id));
$params['client_group_id'] = $rec['groupid'];
}
-
+
//* Set a few params to "not empty" values which get overwritten by the sites_web_domain_plugin
if($params['document_root'] == '') $params['document_root'] = '-';
if($params['system_user'] == '') $params['system_user'] = '-';
if($params['system_group'] == '') $params['system_group'] = '-';
-
+
//* Set a few defaults for nginx servers
if($params['pm_max_children'] == '') $params['pm_max_children'] = 1;
if($params['pm_start_servers'] == '') $params['pm_start_servers'] = 1;
if($params['pm_min_spare_servers'] == '') $params['pm_min_spare_servers'] = 1;
if($params['pm_max_spare_servers'] == '') $params['pm_max_spare_servers'] = 1;
-
- $domain_id = $this->insertQuery('../sites/form/web_domain.tform.php',$client_id,$params, 'sites:web_domain:on_after_insert');
+
+ $domain_id = $this->insertQuery('../sites/form/web_domain.tform.php', $client_id, $params, 'sites:web_domain:on_after_insert');
if ($readonly === true)
$app->db->query("UPDATE web_domain SET `sys_userid` = '1' WHERE domain_id = ".$domain_id);
- return $domain_id;
- }
-
+ return $domain_id;
+ }
+
//* Update a record
public function sites_web_domain_update($session_id, $client_id, $primary_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_domain_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
+
//* Set a few defaults for nginx servers
if($params['pm_max_children'] == '') $params['pm_max_children'] = 1;
if($params['pm_start_servers'] == '') $params['pm_start_servers'] = 1;
if($params['pm_min_spare_servers'] == '') $params['pm_min_spare_servers'] = 1;
if($params['pm_max_spare_servers'] == '') $params['pm_max_spare_servers'] = 1;
-
- $affected_rows = $this->updateQuery('../sites/form/web_domain.tform.php',$client_id,$primary_id,$params);
+
+ $affected_rows = $this->updateQuery('../sites/form/web_domain.tform.php', $client_id, $primary_id, $params);
return $affected_rows;
}
-
+
//* Delete a record
public function sites_web_domain_delete($session_id, $primary_id)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_domain_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->deleteQuery('../sites/form/web_domain.tform.php',$primary_id);
+ $affected_rows = $this->deleteQuery('../sites/form/web_domain.tform.php', $primary_id);
return $affected_rows;
}
-
+
// ----------------------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_web_vhost_subdomain_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_web_subdomain_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -463,7 +463,7 @@
$app->remoting_lib->loadFormDef('../sites/form/web_vhost_subdomain.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_web_vhost_subdomain_add($session_id, $client_id, $params)
{
@@ -472,58 +472,58 @@
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
+
//* Set a few params to "not empty" values which get overwritten by the sites_web_domain_plugin
if($params['document_root'] == '') $params['document_root'] = '-';
if($params['system_user'] == '') $params['system_user'] = '-';
if($params['system_group'] == '') $params['system_group'] = '-';
-
+
//* Set a few defaults for nginx servers
if($params['pm_max_children'] == '') $params['pm_max_children'] = 1;
if($params['pm_start_servers'] == '') $params['pm_start_servers'] = 1;
if($params['pm_min_spare_servers'] == '') $params['pm_min_spare_servers'] = 1;
if($params['pm_max_spare_servers'] == '') $params['pm_max_spare_servers'] = 1;
-
- $domain_id = $this->insertQuery('../sites/form/web_vhost_subdomain.tform.php',$client_id,$params, 'sites:web_vhost_subdomain:on_after_insert');
- return $domain_id;
- }
-
+
+ $domain_id = $this->insertQuery('../sites/form/web_vhost_subdomain.tform.php', $client_id, $params, 'sites:web_vhost_subdomain:on_after_insert');
+ return $domain_id;
+ }
+
//* Update a record
public function sites_web_vhost_subdomain_update($session_id, $client_id, $primary_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_subdomain_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
+
//* Set a few defaults for nginx servers
if($params['pm_max_children'] == '') $params['pm_max_children'] = 1;
if($params['pm_start_servers'] == '') $params['pm_start_servers'] = 1;
if($params['pm_min_spare_servers'] == '') $params['pm_min_spare_servers'] = 1;
if($params['pm_max_spare_servers'] == '') $params['pm_max_spare_servers'] = 1;
-
- $affected_rows = $this->updateQuery('../sites/form/web_vhost_subdomain.tform.php',$client_id,$primary_id,$params, 'sites:web_vhost_subdomain:on_after_insert');
+
+ $affected_rows = $this->updateQuery('../sites/form/web_vhost_subdomain.tform.php', $client_id, $primary_id, $params, 'sites:web_vhost_subdomain:on_after_insert');
return $affected_rows;
}
-
+
//* Delete a record
public function sites_web_vhost_subdomain_delete($session_id, $primary_id)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_subdomain_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->deleteQuery('../sites/form/web_vhost_subdomain.tform.php',$primary_id);
+ $affected_rows = $this->deleteQuery('../sites/form/web_vhost_subdomain.tform.php', $primary_id);
return $affected_rows;
}
-
+
// -----------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_web_aliasdomain_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_web_aliasdomain_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -532,46 +532,46 @@
$app->remoting_lib->loadFormDef('../sites/form/web_aliasdomain.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_web_aliasdomain_add($session_id, $client_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_aliasdomain_add')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- return $this->insertQuery('../sites/form/web_aliasdomain.tform.php',$client_id,$params);
+ return $this->insertQuery('../sites/form/web_aliasdomain.tform.php', $client_id, $params);
}
-
+
//* Update a record
public function sites_web_aliasdomain_update($session_id, $client_id, $primary_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_aliasdomain_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->updateQuery('../sites/form/web_aliasdomain.tform.php',$client_id,$primary_id,$params);
+ $affected_rows = $this->updateQuery('../sites/form/web_aliasdomain.tform.php', $client_id, $primary_id, $params);
return $affected_rows;
}
-
+
//* Delete a record
public function sites_web_aliasdomain_delete($session_id, $primary_id)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_aliasdomain_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->deleteQuery('../sites/form/web_aliasdomain.tform.php',$primary_id);
+ $affected_rows = $this->deleteQuery('../sites/form/web_aliasdomain.tform.php', $primary_id);
return $affected_rows;
}
-
+
// ----------------------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_web_subdomain_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_web_subdomain_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -580,46 +580,46 @@
$app->remoting_lib->loadFormDef('../sites/form/web_subdomain.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_web_subdomain_add($session_id, $client_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_subdomain_add')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- return $this->insertQuery('../sites/form/web_subdomain.tform.php',$client_id,$params);
+ return $this->insertQuery('../sites/form/web_subdomain.tform.php', $client_id, $params);
}
-
+
//* Update a record
public function sites_web_subdomain_update($session_id, $client_id, $primary_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_subdomain_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->updateQuery('../sites/form/web_subdomain.tform.php',$client_id,$primary_id,$params);
+ $affected_rows = $this->updateQuery('../sites/form/web_subdomain.tform.php', $client_id, $primary_id, $params);
return $affected_rows;
}
-
+
//* Delete a record
public function sites_web_subdomain_delete($session_id, $primary_id)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_subdomain_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->deleteQuery('../sites/form/web_subdomain.tform.php',$primary_id);
+ $affected_rows = $this->deleteQuery('../sites/form/web_subdomain.tform.php', $primary_id);
return $affected_rows;
}
-
+
// ----------------------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_web_folder_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_web_folder_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -628,56 +628,56 @@
$app->remoting_lib->loadFormDef('../sites/form/web_folder.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_web_folder_add($session_id, $client_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_folder_add')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- return $this->insertQuery('../sites/form/web_folder.tform.php',$client_id,$params);
+ return $this->insertQuery('../sites/form/web_folder.tform.php', $client_id, $params);
}
-
+
//* Update a record
public function sites_web_folder_update($session_id, $client_id, $primary_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_folder_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->updateQuery('../sites/form/web_folder.tform.php',$client_id,$primary_id,$params);
+ $affected_rows = $this->updateQuery('../sites/form/web_folder.tform.php', $client_id, $primary_id, $params);
return $affected_rows;
}
-
+
//* Delete a record
public function sites_web_folder_delete($session_id, $primary_id)
- {
+ {
global $app;
if(!$this->checkPerm($session_id, 'sites_web_folder_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
-
- // Delete all users that belong to this folder. - taken from web_folder_delete.php
+
+ // Delete all users that belong to this folder. - taken from web_folder_delete.php
$records = $app->db->queryAllRecords("SELECT web_folder_user_id FROM web_folder_user WHERE web_folder_id = '".$app->functions->intval($primary_id)."'");
foreach($records as $rec) {
- $this->deleteQuery('../sites/form/web_folder_user.tform.php',$rec['web_folder_user_id']);
+ $this->deleteQuery('../sites/form/web_folder_user.tform.php', $rec['web_folder_user_id']);
//$app->db->datalogDelete('web_folder_user','web_folder_user_id',$rec['web_folder_user_id']);
}
unset($records);
-
- $affected_rows = $this->deleteQuery('../sites/form/web_folder.tform.php',$primary_id);
+
+ $affected_rows = $this->deleteQuery('../sites/form/web_folder.tform.php', $primary_id);
return $affected_rows;
}
-
+
// -----------------------------------------------------------------------------------------------
-
+
//* Get record details
public function sites_web_folder_user_get($session_id, $primary_id)
- {
+ {
global $app;
-
+
if(!$this->checkPerm($session_id, 'sites_web_folder_user_get')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
@@ -686,118 +686,121 @@
$app->remoting_lib->loadFormDef('../sites/form/web_folder_user.tform.php');
return $app->remoting_lib->getDataRecord($primary_id);
}
-
+
//* Add a record
public function sites_web_folder_user_add($session_id, $client_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_folder_user_add')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- return $this->insertQuery('../sites/form/web_folder_user.tform.php',$client_id,$params);
+ return $this->insertQuery('../sites/form/web_folder_user.tform.php', $client_id, $params);
}
-
+
//* Update a record
public function sites_web_folder_user_update($session_id, $client_id, $primary_id, $params)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_folder_user_update')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->updateQuery('../sites/form/web_folder_user.tform.php',$client_id,$primary_id,$params);
+ $affected_rows = $this->updateQuery('../sites/form/web_folder_user.tform.php', $client_id, $primary_id, $params);
return $affected_rows;
}
-
+
//* Delete a record
public function sites_web_folder_user_delete($session_id, $primary_id)
- {
+ {
if(!$this->checkPerm($session_id, 'sites_web_folder_user_delete')) {
throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
return false;
}
- $affected_rows = $this->deleteQuery('../sites/form/web_folder_user.tform.php',$primary_id);
+ $affected_rows = $this->deleteQuery('../sites/form/web_folder_user.tform.php', $primary_id);
return $affected_rows;
}
/**
* Gets sites by $sys_userid & $sys_groupid
- * @param int session id
- * @param int user id
- * @param array list of groups
- * @return mixed array with sites by user
- * @author Julio Montoya <gugli100@gmail.com> BeezNest 2010
+ * @param int session id
+ * @param int user id
+ * @param array list of groups
+ * @return mixed array with sites by user
+ * @author Julio Montoya <gugli100@gmail.com> BeezNest 2010
*/
+
+
public function client_get_sites_by_user($session_id, $sys_userid, $sys_groupid) {
- global $app;
- if(!$this->checkPerm($session_id, 'client_get_sites_by_user')) {
- throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
- return false;
- }
- $sys_userid = $app->functions->intval($sys_userid);
- $sys_groupid = explode(',', $sys_groupid);
- $new_group = array();
- foreach($sys_groupid as $group_id) {
+ global $app;
+ if(!$this->checkPerm($session_id, 'client_get_sites_by_user')) {
+ throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
+ return false;
+ }
+ $sys_userid = $app->functions->intval($sys_userid);
+ $sys_groupid = explode(',', $sys_groupid);
+ $new_group = array();
+ foreach($sys_groupid as $group_id) {
$new_group[] = $app->functions->intval( $group_id);
- }
- $group_list = implode(',', $new_group);
+ }
+ $group_list = implode(',', $new_group);
$sql ="SELECT domain, domain_id, document_root, active FROM web_domain WHERE ( (sys_userid = $sys_userid AND sys_perm_user LIKE '%r%') OR (sys_groupid IN ($group_list) AND sys_perm_group LIKE '%r%') OR sys_perm_other LIKE '%r%') AND type = 'vhost'";
- $result = $app->db->queryAllRecords($sql);
- if(isset($result)) {
+ $result = $app->db->queryAllRecords($sql);
+ if(isset($result)) {
return $result;
- } else {
+ } else {
throw new SoapFault('no_client_found', 'There is no site for this user');
return false;
- }
- }
-
- /**
- * Change domains status
- * @param int session id
- * @param int site id
- * @param string active or inactive string
- * @return mixed false if error
- * @author Julio Montoya <gugli100@gmail.com> BeezNest 2010
- */
-
- public function sites_web_domain_set_status($session_id, $primary_id, $status) {
- global $app;
- if(!$this->checkPerm($session_id, 'sites_web_domain_set_status')) {
- throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
- return false;
- }
- if(in_array($status, array('active', 'inactive'))) {
- if ($status == 'active') {
- $status = 'y';
- } else {
- $status = 'n';
- }
- $sql = "UPDATE web_domain SET active = '$status' WHERE domain_id = ".$app->functions->intval($primary_id);
- $app->db->query($sql);
- $result = $app->db->affectedRows();
- return $result;
- } else {
- throw new SoapFault('status_undefined', 'The status is not available');
- return false;
- }
+ }
}
- /**
- * Get all databases by user
- * @author Julio Montoya <gugli100@gmail.com> BeezNest 2010
- */
- public function sites_database_get_all_by_user($session_id, $client_id)
- {
- global $app;
- if(!$this->checkPerm($session_id, 'sites_database_get')) {
- throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
- return false;
+
+
+ /**
+ * Change domains status
+ * @param int session id
+ * @param int site id
+ * @param string active or inactive string
+ * @return mixed false if error
+ * @author Julio Montoya <gugli100@gmail.com> BeezNest 2010
+ */
+ public function sites_web_domain_set_status($session_id, $primary_id, $status) {
+ global $app;
+ if(!$this->checkPerm($session_id, 'sites_web_domain_set_status')) {
+ throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
+ return false;
}
- $client_id = $app->functions->intval($client_id);
- $sql = "SELECT d.database_id, d.database_name, d.database_user_id, d.database_ro_user_id, du.database_user, du.database_password FROM web_database d LEFT JOIN web_database_user du ON (du.database_user_id = d.database_user_id) INNER JOIN sys_user s on(d.sys_groupid = s.default_group) WHERE client_id = $client_id";
+ if(in_array($status, array('active', 'inactive'))) {
+ if ($status == 'active') {
+ $status = 'y';
+ } else {
+ $status = 'n';
+ }
+ $sql = "UPDATE web_domain SET active = '$status' WHERE domain_id = ".$app->functions->intval($primary_id);
+ $app->db->query($sql);
+ $result = $app->db->affectedRows();
+ return $result;
+ } else {
+ throw new SoapFault('status_undefined', 'The status is not available');
+ return false;
+ }
+ }
+
+ /**
+ * Get all databases by user
+ * @author Julio Montoya <gugli100@gmail.com> BeezNest 2010
+ */
+ public function sites_database_get_all_by_user($session_id, $client_id)
+ {
+ global $app;
+ if(!$this->checkPerm($session_id, 'sites_database_get')) {
+ throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.');
+ return false;
+ }
+ $client_id = $app->functions->intval($client_id);
+ $sql = "SELECT d.database_id, d.database_name, d.database_user_id, d.database_ro_user_id, du.database_user, du.database_password FROM web_database d LEFT JOIN web_database_user du ON (du.database_user_id = d.database_user_id) INNER JOIN sys_user s on(d.sys_groupid = s.default_group) WHERE client_id = $client_id";
$all = $app->db->queryAllRecords($sql);
- return $all;
+ return $all;
}
}
-?>
\ No newline at end of file
+?>
--
Gitblit v1.9.1