Esempio n. 1
0
 public function set($key, $value, $process = 'from_admin_interface', $app = 'system')
 {
     $datetime = get_instance()->date->datetime();
     $key = strtolower($key);
     if ($process == 'from_install_interface') {
         $config = $_SESSION['db_datas'];
         $this->db = DB($config, TRUE);
     } else {
         if ($process == "form_admin_interface") {
             $this->db = get_db();
             // Refreshing
         }
     }
     $query = $this->db->where('KEY', $key)->where('USER', '')->get('tendoo_meta');
     // Convert value
     if (is_array($value)) {
         $value = json_encode($value, JSON_FORCE_OBJECT);
     } else {
         if (is_bool($value)) {
             $value = $value === true ? 'true' : 'false';
         }
     }
     // ELSE $value keep his form
     // Conversion ended
     if (count($query->result_array()) > 0) {
         return $this->db->where('KEY', $key)->where('USER', '')->update('tendoo_meta', array('VALUE' => $value, 'APP' => $app, 'DATE' => $datetime));
     } else {
         return $this->db->insert('tendoo_meta', array('KEY' => $key, 'VALUE' => $value, 'APP' => $app, 'DATE' => $datetime));
     }
 }
    function postback($VAR)
    {
        # needed for return
        $ret['invoice_id'] = $VAR['option1'];
        $ret['transaction_id'] = $VAR['order_id'];
        $ret['amount'] = $VAR['amount'];
        $ret['currency'] = DEFAULT_CURRENCY;
        # get the processor details:
        $db =& DB();
        $q = "SELECT id,active,plugin_data FROM " . AGILE_DB_PREFIX . "checkout WHERE\n\t\t\t        site_id \t\t= " . $db->qstr(DEFAULT_SITE) . " AND\n\t\t\t        checkout_plugin\t= " . $db->qstr($this->name);
        $rs = $db->Execute($q);
        while (!$rs->EOF) {
            $ret['checkout_id'] = $rs->fields["id"];
            $do = true;
            $this->cfg = unserialize($rs->fields["plugin_data"]);
            if ($do) {
                include_once PATH_MODULES . 'checkout/checkout.inc.php';
                $checkout = new checkout();
                $checkout->postback($ret);
                echo '<SCRIPT LANGUAGE="JavaScript">
							window.location="' . $this->success_url . $ret['invoice_id'] . '";
						  </script>';
                return true;
            }
            $rs->MoveNext();
        }
        echo '<SCRIPT LANGUAGE="JavaScript">
					window.location="' . $this->decline_url . $ret['invoice_id'] . '";
				  </script>';
    }
Esempio n. 3
0
File: DbLog.php Progetto: gtyd/jira
 private function getLogDb()
 {
     if (empty($this->logDb)) {
         $this->logDb = DB('log');
     }
     return $this->logDb;
 }
Esempio n. 4
0
function update_user_feed($user_id, $username)
{
    global $bb_cfg;
    $file_path = $bb_cfg['atom']['path'] . '/u/' . floor($user_id / 5000) . '/' . $user_id % 100 . '/' . $user_id . '.atom';
    $sql = "\n\t\tSELECT\n\t\t\tt.topic_id, t.topic_title, t.topic_status,\n\t\t\tu1.username AS first_username,\n\t\t\tp1.post_time AS topic_first_post_time, p1.post_edit_time AS topic_first_post_edit_time,\n\t\t\tp2.post_time AS topic_last_post_time, p2.post_edit_time AS topic_last_post_edit_time,\n\t\t\ttor.size AS tor_size, tor.tor_status\n\t\tFROM      " . BB_TOPICS . " t\n\t\tLEFT JOIN " . BB_USERS . " u1  ON(t.topic_poster = u1.user_id)\n\t\tLEFT JOIN " . BB_POSTS . " p1  ON(t.topic_first_post_id = p1.post_id)\n\t\tLEFT JOIN " . BB_POSTS . " p2  ON(t.topic_last_post_id = p2.post_id)\n\t\tLEFT JOIN " . BB_BT_TORRENTS . " tor ON(t.topic_id = tor.topic_id)\n\t\tWHERE t.topic_poster = {$user_id}\n\t\tORDER BY t.topic_last_post_time DESC\n\t\tLIMIT 50\n\t";
    $topics_tmp = DB()->fetch_rowset($sql);
    $topics = array();
    foreach ($topics_tmp as $topic) {
        if (isset($topic['topic_status'])) {
            if ($topic['topic_status'] == TOPIC_MOVED) {
                continue;
            }
        }
        if (isset($topic['tor_status'])) {
            if (isset($bb_cfg['tor_frozen'][$topic['tor_status']])) {
                continue;
            }
        }
        $topics[] = $topic;
    }
    if (!count($topics)) {
        @unlink($file_path);
        return false;
    }
    if (create_atom($file_path, 'u', $user_id, wbr($username), $topics)) {
        return true;
    } else {
        return false;
    }
}
Esempio n. 5
0
 private static function getLogDb()
 {
     if (!isset(self::$logDb)) {
         self::$logDb = DB('log');
     }
     return self::$logDb;
 }
/**
 * AgileBill - Open Billing Software
 *
 * This body of work is free software; you can redistribute it and/or
 * modify it under the terms of the Open AgileBill License
 * License as published at http://www.agileco.com/agilebill/license1-4.txt
 * 
 * For questions, help, comments, discussion, etc., please join the
 * Agileco community forums at http://forum.agileco.com/ 
 *
 * @link http://www.agileco.com/
 * @copyright 2004-2008 Agileco, LLC.
 * @license http://www.agileco.com/agilebill/license1-4.txt
 * @author Tony Landis <*****@*****.**> 
 * @package AgileBill
 * @version 1.4.93
 */
function CORE_database_delete($VAR, &$construct, $type)
{
    global $C_debug, $C_translate;
    # set the id
    $id = $construct->table . '_id';
    # generate the full query
    $q = "DELETE FROM\n\t\t\t" . AGILE_DB_PREFIX . "{$construct->table}\n\t\t\tWHERE\n\t\t\tid \t\t= '" . $db->qstr($VAR["id"], get_magic_quotes_gpc()) . "'\n\t\t\tAND\n\t\t\tsite_id = '" . DEFAULT_SITE . "'";
    # execute the query
    $db =& DB();
    $result = $db->Execute($q);
    # Alert
    $C_debug->value["id"] = $VAR[$id];
    $C_debug->value["module_name"] = $C_translate->translate('menu', $construct->module, "");
    $alert = $C_translate->translate('alert_delete_id', "", "");
    $C_debug->alert($alert);
    # error reporting
    if ($result === false) {
        global $C_debug;
        $C_debug->error('database.inc.php', 'delete', $db->ErrorMsg());
        if (isset($construct->trigger["{$type}"])) {
            include_once PATH_CORE . 'trigger.inc.php';
            $trigger = new CORE_trigger();
            $trigger->trigger($construct->trigger["{$type}"], 0, $VAR);
        }
    } else {
        if (isset($construct->trigger["{$type}"])) {
            include_once PATH_CORE . 'trigger.inc.php';
            $trigger = new CORE_trigger();
            $trigger->trigger($construct->trigger["{$type}"], 0, $VAR);
        }
    }
}
Esempio n. 7
0
function smarty_block_group($params, $resource, &$smarty)
{
    if (empty($resource)) {
        return;
    }
    @($id = $params["id"]);
    $do = false;
    $db =& DB();
    $sql = 'SELECT status,group_avail FROM ' . AGILE_DB_PREFIX . 'htaccess WHERE
            site_id     = ' . $db->qstr(DEFAULT_SITE) . ' AND
            status      = ' . $db->qstr('1') . ' AND
            id          = ' . $db->qstr($id);
    @($result = $db->Execute($sql));
    $do = false;
    if (@$result->RecordCount() > 0) {
        global $C_auth;
        @($arr = unserialize($result->fields['group_avail']));
        for ($i = 0; $i < count($arr); $i++) {
            if ($do == false && $C_auth->auth_group_by_id($arr[$i])) {
                $do = true;
            }
        }
    }
    if ($do) {
        echo $resource;
    } else {
        echo @$params["msg"];
    }
}
/**
 * AgileBill - Open Billing Software
 *
 * This body of work is free software; you can redistribute it and/or
 * modify it under the terms of the Open AgileBill License
 * License as published at http://www.agileco.com/agilebill/license1-4.txt
 * 
 * For questions, help, comments, discussion, etc., please join the
 * Agileco community forums at http://forum.agileco.com/ 
 *
 * @link http://www.agileco.com/
 * @copyright 2004-2008 Agileco, LLC.
 * @license http://www.agileco.com/agilebill/license1-4.txt
 * @author Tony Landis <*****@*****.**> 
 * @package AgileBill
 * @version 1.4.93
 */
function list_radio($input_id, $name, $table, $field, $id, $class)
{
    global $C_translate;
    $db =& DB();
    $sql = "SELECT id, {$field} FROM " . AGILE_DB_PREFIX . "{$table} WHERE site_id = '" . DEFAULT_SITE . "' ORDER BY {$field}";
    $result = $db->Execute($sql);
    if ($result === false) {
        global $C_debug;
        $C_debug->error('list.inc.php', 'radio', $db->ErrorMsg());
    }
    if ($result->RecordCount() >= 5) {
        $count = 5;
    } else {
        $count = $result->RecordCount();
    }
    if ($id == "all") {
        $return .= '<input id="' . $input_id . '" type="radio" name="' . $name . '" class="' . $class . '" value=""> All <BR>';
    }
    $i = 0;
    while (!$result->EOF) {
        if ($id == $result->fields["id"]) {
            $return .= '<input id="' . $input_id . '" type="radio" name="' . $name . '" class="' . $class . '" value="' . $result->fields["id"] . '" checked> ' . $result->fields["{$field}"] . '<BR>';
        } else {
            $return .= '<input id="' . $input_id . '" type="radio" name="' . $name . '" class="' . $class . '" value="' . $result->fields["id"] . '"> ' . $result->fields["{$field}"] . '<BR>';
        }
        $i++;
        $result->MoveNext();
    }
    if ($i == 0) {
        $return .= '<input id="' . $input_id . '" type="radio" name="' . $name . '" class="' . $class . '" value="">' . $C_translate->translate('lists_none_defined', 'CORE', '');
    }
    return $return;
}
Esempio n. 9
0
 public function database($params = '', $return = FALSE, $active_record = NULL)
 {
     // Grab the super object
     $CI =& get_instance();
     // Do we even need to load the database class?
     if (class_exists('CI_DB') and $return == FALSE and $active_record == NULL and isset($CI->db) and is_object($CI->db)) {
         return FALSE;
     }
     require_once BASEPATH . 'database/DB.php';
     $db = DB($params, $active_record);
     // Load extended DB driver
     $custom_db_driver = config_item('subclass_prefix') . 'DB_' . $db->dbdriver . '_driver';
     $custom_db_driver_file = APPPATH . 'core/' . $custom_db_driver . '.php';
     if (file_exists($custom_db_driver_file)) {
         require_once $custom_db_driver_file;
         $db = new $custom_db_driver(get_object_vars($db));
     }
     // Return DB instance
     if ($return === TRUE) {
         return $db;
     }
     // Initialize the db variable. Needed to prevent reference errors with some configurations
     $CI->db = '';
     $CI->db =& $db;
 }
Esempio n. 10
0
 /**
  * Function for right load database
  *
  * @access    public
  * @param    string    the DB credentials
  * @param    bool    whether to return the DB object
  * @param    bool    whether to enable active record (this allows us to override the config setting)
  * @return    object
  */
 function database($params = '', $return = FALSE, $query_builder = NULL)
 {
     // Do we even need to load the database class?
     if (class_exists('CI_DB') and $return == FALSE and $query_builder == NULL) {
         return FALSE;
     }
     require_once BASEPATH . 'database/DB' . '.php';
     // Load the DB class
     $db =& DB($params, $query_builder);
     $my_driver = config_item('subclass_prefix') . 'DB_' . $db->dbdriver . '_driver';
     $my_driver_file = APPPATH . 'libraries/System/' . $my_driver . '.php';
     if (file_exists($my_driver_file)) {
         log_message('debug', 'Extended DB driver class instantiated!');
         require_once $my_driver_file;
         $db_obj = new $my_driver(get_object_vars($db));
         $db =& $db_obj;
     }
     if ($return === TRUE) {
         return DB($params, $query_builder);
     }
     // Grab the super object
     $CI =& get_instance();
     // Initialize the db variable.  Needed to prevent
     // reference errors with some configurations
     $CI->db = '';
     $CI->db = $db;
     return $this;
     // Assign the DB object to any existing models
     //$this->_ci_assign_to_models();
 }
Esempio n. 11
0
 public function __construct($orgcode, $enableSlaves = 'false')
 {
     $this->orgcode = $orgcode == null ? 'config' : $orgcode;
     $this->_current_date = date("Y-m-d H:i:s");
     $this->db = DB($this->orgcode);
     $this->db->enableSlaves = $enableSlaves;
 }
function smarty_function_html_select_affiliate($params, &$smarty)
{
    $id = $params['id'];
    $name = $params['name'];
    $default = $params['default'];
    $type = $params['type'];
    if (empty($id)) {
        $id = $name . "_id";
    }
    if (!empty($default)) {
        $db =& DB();
        $p = AGILE_DB_PREFIX;
        $q = "SELECT DISTINCT\n\t          {$p}affiliate.id,\n\t          {$p}account.first_name,\n\t          {$p}account.last_name,\n\t          {$p}account.username\n\t          FROM \n\t          {$p}account\n\t          LEFT JOIN\n\t          {$p}affiliate              \t\n\t          ON\n\t          {$p}account.id = {$p}affiliate.account_id\n\t          WHERE  \n\t          {$p}affiliate.id = '{$default}' AND\n\t          {$p}affiliate.site_id = " . DEFAULT_SITE . " AND\n\t          {$p}account.site_id = " . DEFAULT_SITE;
        $result = $db->Execute($q);
        if ($result != false && $result->RecordCount() > 0) {
            $val = $result->fields['first_name'] . ' ' . $result->fields['last_name'];
        }
    } else {
        $val = '';
    }
    echo '   	
	<input type="hidden" id="' . $id . '_hidden" name="' . $name . '" value="' . $default . '" />
	<input type="text" autocomplete="off" id="' . $id . '" name="affiliate_search" size="35" value="' . $val . '" /> 
	<div class="auto_complete" id="' . $id . '_auto_complete"></div>  
	<script type="text/javascript">new Ajax.Autocompleter("' . $id . '", "' . $id . '_auto_complete", "ajax.php?do[]=affiliate:autoselect", { })</script>
	';
    if (!empty($val)) {
        // display unselect option
        echo '<a href="#" OnClick="document.getElementById(\'' . $id . '\').value=\'\'; document.getElementById(\'' . $id . '_hidden\').value=\'\'"> - </a>';
    }
}
Esempio n. 13
0
 /**
  * Logs the sesson variables.
  * 
  * @return 	void
  * @since 	Version 1.0
  */
 function CORE_weblog()
 {
     global $current_module, $VAR;
     if ($current_module == '') {
         $module = '';
     } else {
         $module = $current_module;
     }
     if (!isset($VAR['_page']) || $VAR['_page'] == '') {
         $page = '';
     } else {
         @($pagearr = explode(':', $VAR['_page']));
         @($page = $pagearr["1"]);
     }
     ### browser type:
     $arr_browser = $this->get_browser();
     $browser = $arr_browser["type"] . ' ' . $arr_browser["ver"];
     ### product:
     if (isset($VAR['prid'])) {
         $product = $VAR['prid'];
     } else {
         $product = '';
     }
     ### log the current hit to the database
     $db =& DB();
     $id = $db->GenID(AGILE_DB_PREFIX . "" . 'weblog_id');
     $sql = "INSERT INTO " . AGILE_DB_PREFIX . "weblog SET\n\t\t\t\tid      \t= " . $db->qstr($id) . ",\n\t\t\t\tdate_orig   = " . $db->qstr(time()) . ",\n\t\t\t\tsite_id\t\t= " . $db->qstr(DEFAULT_SITE) . ",\n\t\t\t\tsession_id\t= " . $db->qstr(SESS) . ",\n\t\t\t\taccount_id\t= " . $db->qstr(SESS_ACCOUNT) . ",\n\t\t\t\taffiliate_id= " . $db->qstr(SESS_AFFILIATE) . ",\n\t\t\t\treseller_id\t= " . $db->qstr(SESS_RESELLER) . ",\n\t\t\t\tcampaign_id\t= " . $db->qstr(SESS_CAMPAIGN) . ",\n\t\t\t\tproduct_id\t= " . $db->qstr($product) . ",\n\t\t\t\tmodule\t\t= " . $db->qstr($module) . ",\n\t\t\t\tpage\t\t= " . $db->qstr($page) . ",\n\t\t\t\treferrer\t= " . $db->qstr($this->get_referrer()) . ",\n\t\t\t\tbrowser\t\t= " . $db->qstr($browser) . ",\n\t\t\t\tos\t\t\t= " . $db->qstr($this->get_os());
     $result = $db->Execute($sql);
     # error reporting:
     if ($result === false) {
         global $C_debug;
         $C_debug->error('weblog.inc.php', 'weblog', $db->ErrorMsg());
     }
     return;
 }
 function database_s($params = '', $return = FALSE, $active_record = NULL)
 {
     // Do we even need to load the database class?
     if (class_exists('CI_DB') and $return == FALSE and $active_record == NULL and isset($CI->db) and is_object($CI->db)) {
         return FALSE;
     }
     require_once BASEPATH . 'database/DB' . EXT;
     // Load the DB class
     $db =& DB($params, $active_record);
     $my_driver = config_item('subclass_prefix') . 'DB_' . $db->dbdriver . '_driver';
     $my_driver_file = APPPATH . 'libraries/' . $my_driver . EXT;
     if (file_exists($my_driver_file)) {
         require_once $my_driver_file;
         $db = new $my_driver(get_object_vars($db));
     }
     if ($return === TRUE) {
         return $db;
     }
     // Grab the super object
     $CI =& get_instance();
     // Initialize the db variable.  Needed to prevent
     // reference errors with some configurations
     $CI->db = '';
     // Load the DB class
     $CI->db = $db;
     if (!empty($_REQUEST['MemFlush']) && $_REQUEST['MemFlush'] == 1) {
         $CI->db->MemFlush = TRUE;
     }
 }
Esempio n. 15
0
 function import($VAR)
 {
     global $C_debug;
     if (empty($VAR['asset_pool_id'])) {
         $C_debug->alert("No asset pool specified");
         return;
     }
     $db =& DB();
     if (is_uploaded_file($_FILES['datafile']['tmp_name'])) {
         # Got a file to import
         $fp = fopen($_FILES['datafile']['tmp_name'], "r");
         if ($fp) {
             $counter = 0;
             $skipped = 0;
             while (!feof($fp)) {
                 $line = fgets($fp, 128);
                 $cols = explode(",", $line);
                 if (!empty($cols[0])) {
                     $fields = array('date_orig' => time(), 'date_last' => time(), 'status' => 0, 'service_id' => 0, 'pool_id' => $VAR['asset_pool_id'], 'asset' => @$cols[0], 'misc' => @$cols[1]);
                     $db->Execute(sqlInsert($db, "asset", $fields));
                     $counter++;
                 } else {
                     $skipped++;
                 }
             }
             $C_debug->alert("Imported {$counter} new Asset(s) and skipped {$skipped} Asset(s)!");
         } else {
             $C_debug->alert('Unable to fopen the file sent.');
         }
     } else {
         $C_debug->alert('Unable to process the uploaded file.');
     }
 }
Esempio n. 16
0
 function check($domain, $tld, $tld_array)
 {
     // check the domain validity:
     if (!preg_match('/^[a-zA-Z0-9\\-]{1,}$/i', $domain)) {
         return false;
     }
     if (preg_match('/[-]{2,}/', $domain)) {
         return false;
     }
     if (preg_match('/^[-]{1,}/', $domain)) {
         return false;
     }
     if (preg_match('/[-]{1,}$/', $domain)) {
         return false;
     }
     $db =& DB();
     $dbm = new CORE_database();
     $sql = $dbm->sql_select('service', 'id', "domain_name = ::{$domain}:: AND domain_tld = ::{$tld}::", "", $db);
     $rs = $db->Execute($sql);
     if ($rs == false || $rs->RecordCount() > 0) {
         return false;
     } else {
         return true;
     }
 }
Esempio n. 17
0
    function duplicate_attachment_pm($switch_attachment, $original_privmsg_id, $new_privmsg_id)
    {
        global $privmsg, $folder;
        if (($privmsg['privmsgs_type'] == PRIVMSGS_NEW_MAIL || $privmsg['privmsgs_type'] == PRIVMSGS_UNREAD_MAIL) && $folder == 'inbox' && intval($switch_attachment) == 1) {
            $sql = 'SELECT *
			FROM ' . ATTACHMENTS_TABLE . '
			WHERE privmsgs_id = ' . $original_privmsg_id;
            if (!($result = DB()->sql_query($sql))) {
                message_die(GENERAL_ERROR, 'Couldn\'t query Attachment Table', '', __LINE__, __FILE__, $sql);
            }
            if (DB()->num_rows($result) > 0) {
                $rows = DB()->sql_fetchrowset($result);
                $num_rows = DB()->num_rows($result);
                for ($i = 0; $i < $num_rows; $i++) {
                    $sql = 'INSERT INTO ' . ATTACHMENTS_TABLE . ' (attach_id, post_id, privmsgs_id, user_id_1, user_id_2) 
					VALUES ( ' . $rows[$i]['attach_id'] . ', ' . $rows[$i]['post_id'] . ', ' . $new_privmsg_id . ', ' . $rows[$i]['user_id_1'] . ', ' . $rows[$i]['user_id_2'] . ')';
                    if (!($result = DB()->sql_query($sql))) {
                        message_die(GENERAL_ERROR, 'Couldn\'t store Attachment for sent Private Message', '', __LINE__, __FILE__, $sql);
                    }
                }
                $sql = "UPDATE " . PRIVMSGS_TABLE . "\n\t\t\t\tSET privmsgs_attachment = 1\n\t\t\t\tWHERE privmsgs_id = " . $new_privmsg_id;
                if (!DB()->sql_query($sql)) {
                    message_die(GENERAL_ERROR, 'Unable to update Private Message Table.', '', __LINE__, __FILE__, $sql);
                }
            }
        }
    }
function smarty_function_html_menu_product_host($params, &$smarty)
{
    $id = $params['id'];
    $name = $params['name'];
    $default = unserialize($params['default']);
    $size = $params['size'];
    $exclude = $params['exclude'];
    if (empty($id)) {
        $id = $name;
    }
    $db =& DB();
    $p = AGILE_DB_PREFIX;
    $q = "SELECT id,sku FROM {$p}product\n\t          WHERE host = 1\n\t          AND active = 1  \n\t          AND price_type = 1\n\t          AND id != {$exclude}\n\t          AND site_id = " . DEFAULT_SITE;
    $result = $db->Execute($q);
    if ($result && $result->RecordCount() > 0) {
        echo "<select id=\"{$id}\" name=\"{$name}[]\" size=\"{$size}\"  multiple>";
        while (!$result->EOF) {
            $sel = '';
            foreach ($default as $cur) {
                if ($cur == $result->fields['id']) {
                    $sel = "selected";
                }
            }
            echo "<option value=\"{$result->fields['id']}\"{$sel}>{$result->fields['sku']}</option>";
            $result->MoveNext();
        }
        echo "</select>";
    }
}
function _get_dbconfig($orgcode, $type = "master")
{
    $connstr_cachekey = "ConnectionString_" . $orgcode;
    $connstr = Yii::$app->cache->get($connstr_cachekey);
    if (empty($connstr)) {
        $db = DB("config");
        $command = $db->createCommand("select ConnectionString from myscrm_organization where UniqueName=:orgcode", [':orgcode' => $orgcode]);
        $connstr = $command->queryScalar();
        if (empty($connstr)) {
            throw new Exception("租户库链接为空!", "110001");
        }
        Yii::$app->cache->set($connstr_cachekey, $connstr);
    }
    $myconnection = array();
    foreach (explode(';', $connstr) as $conn) {
        $connPara = explode('=', $conn);
        if (count($connPara) > 1) {
            $myconnection[$connPara[0]] = $connPara[1];
        }
    }
    $connect_host = $myconnection["server"];
    if ($type == 'slave') {
        //slave实例切换
        //获取主从实例对照参数表
        $m2s_instance_params = isset(\Yii::$app->params['master_slave_instance']) && is_array(\Yii::$app->params['master_slave_instance']) ? \Yii::$app->params['master_slave_instance'] : [];
        /**
         * 如果存在主从映射关系,则替换,否则主从实例为同一实例
         */
        if (isset($m2s_instance_params[$connect_host]) && $m2s_instance_params[$connect_host]) {
            $connect_host = $m2s_instance_params[$connect_host];
        }
    }
    return ["host" => $connect_host, "database" => $myconnection["database"], "uid" => $myconnection["uid"], "pwd" => $myconnection["pwd"]];
}
Esempio n. 20
0
 /**
  * Delete a radius account 
  */
 function p_delete()
 {
     $db =& DB();
     $db->Execute(sqlDelete($db, "radius", "service_id={$this->service['id']}"));
     $db->Execute(sqlDelete($db, "radius_service", "service_id={$this->service['id']}"));
     return true;
 }
    function graph($start, $end, $constraint, $default)
    {
        global $C_translate;
        $db =& DB();
        $sql = 'SELECT date_orig FROM ' . AGILE_DB_PREFIX . 'ticket WHERE
					site_id     =  ' . $db->qstr(DEFAULT_SITE) . ' AND
					date_orig   >= ' . $db->qstr($start) . ' AND
					date_orig   <= ' . $db->qstr($end);
        $result = $db->Execute($sql);
        if ($result->RecordCount() == 0) {
            $arr['title'] = $C_translate->translate('search_no_results', '', '');
            $arr['results'] = $default;
            return $arr;
        }
        $ii = 0;
        while (!$result->EOF) {
            $d = $result->fields['date_orig'];
            for ($i = 0; $i < count($constraint); $i++) {
                if ($d >= $constraint[$i]["start"] && $d < $constraint[$i]["end"]) {
                    $default[$i]++;
                }
                $ii++;
            }
            $result->MoveNext();
        }
        $C_translate->value['ticket_message']['count'] = $result->RecordCount();
        $title = $C_translate->translate('statistics', 'ticket_message', '');
        $arr['title'] = $title;
        $arr['results'] = $default;
        return $arr;
    }
Esempio n. 22
0
 /**
  * Database Loader
  *
  * @param mixed $params   Database configuration options
  * @param bool  $return   Whether to return the database object
  * @param bool  $query_builder  Whether to enable Query Builder
  *          (overrides the configuration setting)
  *
  * @return  object|bool Database object if $return is set to TRUE,
  *          FALSE on failure, CI_Loader instance in any other case
  */
 public function database($params = '', $return = FALSE, $query_builder = NULL)
 {
     // Grab the super object
     $CI =& get_instance();
     // Do we even need to load the database class?
     if ($return === FALSE && $query_builder === NULL && isset($CI->db) && is_object($CI->db) && !empty($CI->db->conn_id)) {
         return FALSE;
     }
     require_once BASEPATH . 'database/DB.php';
     $db = DB($params, $query_builder);
     // Load extended DB driver
     $custom_driver = config_item('subclass_prefix') . 'DB_' . $db->dbdriver . '_driver';
     $custom_driver_file = APPPATH . 'core/' . $custom_driver . '.php';
     if (file_exists($custom_driver_file)) {
         require_once $custom_driver_file;
         $db = new $custom_driver(get_object_vars($db));
     }
     if ($return === TRUE) {
         return $db;
     }
     // Initialize the db variable. Needed to prevent
     // reference errors with some configurations
     $CI->db = '';
     $CI->db = $db;
     // Load the DB class
     // $CI->db =& DB($params, $query_builder);
     return $this;
 }
Esempio n. 23
0
 /**
  * Database Loader
  *
  * @access    public
  * @param    string    the DB credentials
  * @param    bool    whether to return the DB object
  * @param    bool    whether to enable active record (this allows us to override the config setting)
  * @return    object
  */
 function database($params = '', $return = FALSE, $active_record = NULL)
 {
     /* if ( ! class_exists('CI_DB_active_record'))
             {
                 @include(APPPATH.'libraries/My_DB_active_rec'.EXT);
             }
             // call the parent method to retain the CI functionality
             parent::database($params, $return, $active_record);
     */
     // Do we even need to load the database class?
     if (class_exists('CI_DB') and $return == FALSE and $active_record == FALSE) {
         return FALSE;
     }
     require_once BASEPATH . 'database/DB' . EXT;
     // Load the DB class
     $db =& DB($params, $active_record);
     $my_driver = config_item('subclass_prefix') . 'DB_' . $db->dbdriver . '_driver';
     $my_driver_file = APPPATH . 'libraries/' . $my_driver . EXT;
     if (file_exists($my_driver_file)) {
         require_once $my_driver_file;
         $db = new $my_driver(get_object_vars($db));
     }
     if ($return === TRUE) {
         return $db;
     }
     // Grab the super object
     $CI =& get_instance();
     // Initialize the db variable.  Needed to prevent
     // reference errors with some configurations
     $CI->db = '';
     $CI->db = $db;
     // Assign the DB object to any existing models
     $this->_ci_assign_to_models();
 }
function smarty_function_html_menu($params, &$smarty)
{
    $conditions = '';
    extract($params);
    if (empty($field)) {
        $field = $name;
    }
    if (empty($id)) {
        $id = $field;
    }
    $db =& DB();
    $rs =& $db->Execute($sql = sqlSelect($db, $assoc_table, "id," . $assoc_field, $conditions, $assoc_field));
    #echo $sql;
    $return = '<select id="' . $id . '" name="' . $field . '">';
    if ($default == "all" || $blank) {
        $return .= '<option value="" selected></option>';
    }
    if ($rs && $rs->RecordCount() > 0) {
        while (!$rs->EOF) {
            $return .= '<option value="' . $rs->fields['id'] . '"';
            if ($default == $rs->fields['id']) {
                $return .= "selected";
            }
            $return .= '>' . $rs->fields["{$assoc_field}"] . '</option>';
            $rs->MoveNext();
        }
    } else {
        if ($default != "all") {
            $return .= '<option value=""></option>';
        }
    }
    $return .= '</select>';
    echo $return;
}
Esempio n. 25
0
function validate_email($email, $check_ban_and_taken = true)
{
    global $lang, $userdata;
    if (!$email || !filter_var($email, FILTER_VALIDATE_EMAIL)) {
        return $lang['EMAIL_INVALID'];
    }
    if (strlen($email) > USEREMAIL_MAX_LENGTH) {
        return $lang['EMAIL_TOO_LONG'];
    }
    if ($check_ban_and_taken) {
        $banned_emails = array();
        foreach (DB()->fetch_rowset("SELECT ban_email FROM " . BB_BANLIST . " ORDER BY NULL") as $row) {
            $banned_emails[] = str_replace('\\*', '.*?', preg_quote($row['ban_email'], '#'));
        }
        if ($banned_emails_exp = join('|', $banned_emails)) {
            if (preg_match("#^({$banned_emails_exp})\$#i", $email)) {
                return sprintf($lang['EMAIL_BANNED'], $email);
            }
        }
        $email_sql = DB()->escape($email);
        if ($row = DB()->fetch_row("SELECT `user_email` FROM " . BB_USERS . " WHERE user_email = '{$email_sql}' LIMIT 1")) {
            if ($row['user_email'] == $userdata['user_email']) {
                return false;
            } else {
                return $lang['EMAIL_TAKEN'];
            }
        }
    }
    return false;
}
Esempio n. 26
0
function getZone($zoneID)
{
    $db = DB();
    $sql = $db->get_where('tb_zone', 'zone_id =' . $zoneID);
    $rs = $sql->row_array();
    return $rs['zone_name'];
}
 function download($VAR)
 {
     if (empty($VAR['id'])) {
         return false;
     }
     $id = $VAR['id'];
     // get ticket id
     $db =& DB();
     $rs = $db->Execute(sqlSelect($db, array("ticket_attachment", "ticket"), "A.ticket_id,B.department_id,B.account_id", "A.id=::{$id}:: AND A.ticket_id=B.id"));
     if (!$rs || $rs->RecordCount() == 0) {
         return false;
     }
     // is this an admin?
     global $C_auth;
     if ($C_auth->auth_method_by_name("ticket", "view")) {
         // get the data & type
         $rs = $db->Execute(sqlSelect($db, "ticket_attachment", "*", "id=::{$id}::"));
         // set the header
         require_once PATH_CORE . 'file_extensions.inc.php';
         $ft = new file_extensions();
         $type = $ft->set_headers_ext($rs->fields['type'], $rs->fields['name']);
         if (empty($type)) {
             echo imap_qprint($rs->fields['content']);
         } elseif (preg_match("/^text/i", $type)) {
             echo imap_base64($rs->fields['content']);
         } else {
             echo imap_base64($rs->fields['content']);
         }
         exit;
     }
 }
/**
 * AgileBill - Open Billing Software
 *
 * This body of work is free software; you can redistribute it and/or
 * modify it under the terms of the Open AgileBill License
 * License as published at http://www.agileco.com/agilebill/license1-4.txt
 * 
 * For questions, help, comments, discussion, etc., please join the
 * Agileco community forums at http://forum.agileco.com/ 
 *
 * @link http://www.agileco.com/
 * @copyright 2004-2008 Agileco, LLC.
 * @license http://www.agileco.com/agilebill/license1-4.txt
 * @author Tony Landis <*****@*****.**> 
 * @package AgileBill
 * @version 1.4.93
 */
function list_card_type_menu($default_selected, $checkout_id, $field, $class)
{
    // define default list of accepted CC types
    $def_accepted_arr = array(0 => 'visa', 1 => 'mc', 2 => 'amex', 3 => 'discover', 4 => 'delta', 5 => 'solo', 6 => 'switch', 7 => 'jcb', 8 => 'diners', 9 => 'carteblanche', 10 => 'enroute');
    $db =& DB();
    $q = "SELECT * FROM " . AGILE_DB_PREFIX . "checkout WHERE\n\t\t\t\tsite_id = " . $db->qstr(DEFAULT_SITE) . " AND\n\t\t\t\tid\t\t= " . $db->qstr($checkout_id);
    $rs = $db->Execute($q);
    if ($rs == false || $rs->RecordCount() == 0) {
        $accepted_arr = $def_accepted_arr;
    }
    @($cfg = unserialize($rs->fields["plugin_data"]));
    $accepted_arr = $cfg['card_type'];
    if (count($accepted_arr) <= 0) {
        $accepted_arr = $def_accepted_arr;
    }
    global $C_translate;
    $data = '<select id="' . $field . '" name="' . $field . '" value="' . $default . '">';
    for ($i = 0; $i < count($accepted_arr); $i++) {
        $data .= '<option value="' . $accepted_arr[$i] . '"';
        if ($default_selected == $accepted_arr[$i]) {
            $data .= ' selected';
        }
        $data .= '">' . $C_translate->translate('card_type_' . $accepted_arr[$i], 'checkout', '');
        '</option>
				   ';
    }
    $data .= '</select>';
    return $data;
}
Esempio n. 29
0
 /** Get the plugin settings from the database */
 function config()
 {
     $db =& DB();
     $rs =& $db->Execute(sqlSelect($db, "voip_did_plugin", "*", "id = {$this->id}"));
     $this->release_minutes = $rs->fields['release_minutes'];
     $this->avail_countries = $rs->fields['avail_countries'];
 }
function smarty_function_html_select_account($params, &$smarty)
{
    $id = $params['id'];
    $name = $params['name'];
    $default = $params['default'];
    $type = $params['type'];
    if (empty($id)) {
        $id = $name . "_id";
    }
    if (!empty($default)) {
        $db =& DB();
        $p = AGILE_DB_PREFIX;
        $q = "SELECT id,first_name,middle_name,last_name  FROM  {$p}account  \n\t          WHERE id = {$default} \n\t          AND site_id = " . DEFAULT_SITE;
        $result = $db->Execute($q);
        if ($result->RecordCount() > 0) {
            $val = $result->fields['first_name'] . ' ' . $result->fields['last_name'];
        }
        if (!empty($val)) {
            # Get
        }
    } else {
        $val = '';
    }
    if (empty($val)) {
        echo '   	
		<input type="hidden" id="' . $id . '_hidden" name="' . $name . '" value="' . $default . '" />
		<input type="text" autocomplete="off" id="' . $id . '" name="account_search" size="35" value="' . $val . '" /> 
		<div class="auto_complete" id="' . $id . '_auto_complete"></div>  
		<script type="text/javascript">new Ajax.Autocompleter("' . $id . '", "' . $id . '_auto_complete", "ajax.php?do[]=account_admin:autoselect", { })</script>
		';
    } else {
        echo "<a href=\"#\" onClick=\"window.open('?_page=account_admin:view&id={$default}', 'mainFrame', '')\"><u>{$val}</u></a>";
        echo "<input value=\"{$default}\" id=\"{$id}\" name=\"{$name}\" type=\"hidden\">";
    }
}