public function updateAddonSettings($addonId, $settings, $type)
{
$addon = monitisSqlHelper::objQuery('SELECT * FROM mod_monitis_addon WHERE addon_id=' . $addonId);
if ($addon && count($addon) > 0) {
$value = array('settings' => $settings, 'type' => $type);
$where = array('addon_id' => $addonId);
update_query('mod_monitis_addon', $value, $where);
return 'update';
} else {
$value = array('addon_id' => $addonId, 'type' => $type, 'settings' => $settings, 'status' => 'active');
insert_query('mod_monitis_addon', $value);
return 'create';
}
}
static function checkAdminName()
{
$admin = monitisSqlHelper::objQuery('SELECT value, tbladmins.id, tbladmins.firstname, tbladmins.lastname
FROM tbladdonmodules
LEFT JOIN tbladmins ON (tbladmins.username = tbladdonmodules.value AND tbladmins.username=tbladdonmodules.value)
WHERE tbladdonmodules.module="monitis_addon" AND tbladdonmodules.setting="adminuser" && tbladmins.id > 0 ');
$username = '';
if (!$admin) {
$vals = monitisSqlHelper::objQuery('SELECT tbladmins.username FROM tbladmins
LEFT JOIN tbladminroles on (tbladminroles.id=tbladmins.roleid) ORDER BY tbladmins.id');
$username = $vals['username'];
} else {
$username = $admin['value'];
}
return $username;
}
static function setupDB()
{
$row = monitisSqlHelper::objQuery('SELECT * FROM ' . MONITIS_SETTING_TABLE . ' WHERE client_id=' . MONITIS_CLIENT_ID);
if (!$row) {
$default_settings = json_decode(self::$default_settings, true);
$default_settings["order_behavior"] = self::setupBehavior(MONITIS_ORDER_BEHAVIOR);
$default_settings["user_behavior"] = self::setupBehavior(MONITIS_USER_STATUS_BEHAVIOR);
$values = array('client_id' => MONITIS_CLIENT_ID, 'apiKey' => self::$apiKey, 'secretKey' => self::$secretKey, 'settings' => json_encode($default_settings));
self::$settings = $default_settings;
insert_query(MONITIS_SETTING_TABLE, $values);
} else {
}
//return true;
}
static function configOptionProduct($optionid, $configid, $serviceid)
{
$sql = 'SELECT tblhostingconfigoptions.configid as productid, tblhostingconfigoptions.optionid as option_id,
mod_monitis_options.type as monitor_type, mod_monitis_options.settings,
tblhosting.id as serviceid, tblhosting.userid, tblhosting.orderid, tblhosting.domain, tblhosting.dedicatedip, tblhosting.domainstatus,
tblhosting.server as serverid, tblorders.ordernum, tblorders.status,
tblclients.firstname as firstName, tblclients.lastname as lastName, tblclients.email,
CONCAT( tblclients.firstname, " ", tblclients.lastname) as username,
CONCAT("option") as producttype
FROM tblhostingconfigoptions
RIGHT JOIN mod_monitis_options
ON mod_monitis_options.option_id = tblhostingconfigoptions.optionid
LEFT JOIN tblhosting
ON tblhosting.id = tblhostingconfigoptions.relid
LEFT JOIN tblorders
ON tblorders.id = tblhosting.orderid
LEFT JOIN tblclients
ON tblclients.id = tblhosting.userid
WHERE tblhostingconfigoptions.optionid=' . $optionid . ' AND tblhostingconfigoptions.configid=' . $configid . ' AND tblhostingconfigoptions.relid=' . $serviceid;
$product = monitisSqlHelper::objQuery($sql);
if ($product) {
$product['web_site'] = self::url_IP($product, $product['monitor_type']);
}
return $product;
}
static function serverInfo($server_id)
{
return monitisSqlHelper::objQuery('SELECT id, name, ipaddress, hostname FROM tblservers WHERE disabled=0 AND id=' . $server_id);
}
static function whmcsLinkUser($userid)
{
return monitisSqlHelper::objQuery('SELECT * FROM ' . MONITIS_USER_TABLE . ' WHERE user_id=' . $userid);
}
private function userById($userid)
{
return monitisSqlHelper::objQuery('SELECT id as user_id, firstname, lastname, email
FROM tblclients
WHERE id=' . $userid);
}
private function whmcsInfo(&$info, $monitorId, $type)
{
$table = MONITIS_INTERNAL_TABLE;
if ($type == 'external') {
$table = MONITIS_EXTERNAL_TABLE;
}
$mon = monitisSqlHelper::objQuery('SELECT available, publickey FROM ' . $table . ' WHERE monitor_id=' . $monitorId);
$info['available'] = $mon['available'];
$info['publickey'] = $mon['publickey'];
return $info;
}
