• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

PHP gs_db_master_connect函数代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了PHP中gs_db_master_connect函数的典型用法代码示例。如果您正苦于以下问题:PHP gs_db_master_connect函数的具体用法?PHP gs_db_master_connect怎么用?PHP gs_db_master_connect使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。



在下文中一共展示了gs_db_master_connect函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: gs_huntgroups_get

function gs_huntgroups_get()
{
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get queues
    #
    $rs = $db->execute('SELECT
	`number`
FROM
	`huntgroups`
GROUP BY `number`
ORDER BY `number`');
    if (!$rs) {
        return new GsError('Error.');
    }
    $huntgroups = array();
    while ($r = $rs->fetchRow()) {
        $huntgroups[] = $r;
    }
    return $huntgroups;
}
开发者ID:hehol,项目名称:GemeinschaftPBX,代码行数:25,代码来源:gs_huntgroups_get.php


示例2: gs_clir_get

function gs_clir_get($user)
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
        return new GsError('User must be alphanumeric.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
    if (!$user_id) {
        return new GsError('Unknown user.');
    }
    # get state
    #
    $rs = $db->execute('SELECT `internal_restrict`, `external_restrict` FROM `clir` WHERE `user_id`=' . $user_id);
    if ($r = $rs->fetchRow()) {
        if (!in_array($r['internal_restrict'], array('no', 'yes', 'once'), true)) {
            $r['internal_restrict'] = 'no';
        }
        if (!in_array($r['external_restrict'], array('no', 'yes', 'once'), true)) {
            $r['external_restrict'] = 'no';
        }
        return $r;
    }
    return array('internal_restrict' => 'no', 'external_restrict' => 'no');
}
开发者ID:rkania,项目名称:GS3,代码行数:31,代码来源:gs_clir_get.php


示例3: gs_vm_activate

function gs_vm_activate($user, $source, $active)
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
        return new GsError('User must be alphanumeric.');
    }
    if (!in_array($source, array('internal', 'external'), true)) {
        return new GsError('Source must be internal|external.');
    }
    $active = (bool) $active;
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
    if (!$user_id) {
        return new GsError('Unknown user.');
    }
    # check if has mailbox
    #
    $num = $db->executeGetOne('SELECT COUNT(*) FROM `vm` WHERE `user_id`=' . $user_id);
    if ($num < 1) {
        return new GsError('User does not have a mailbox.');
    }
    # (de)activate
    #
    $ok = $db->execute('UPDATE `vm` SET `' . $source . '_active`=' . (int) $active . ' WHERE `user_id`=' . $user_id);
    if (!$ok) {
        return new GsError('Failed to set state.');
    }
    return true;
}
开发者ID:rkania,项目名称:GS3,代码行数:35,代码来源:gs_vm_activate.php


示例4: gs_agents_get

function gs_agents_get()
{
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get users
    #
    $rs = $db->execute('SELECT
	`id`, `name`, `firstname`, `number`,`pin`,`user_id`
FROM
	`agents`
ORDER BY
	`name`');
    if (!$rs) {
        return new GsError('Error.');
    }
    $agents = array();
    while ($r = $rs->fetchRow()) {
        $agents[] = $r;
    }
    return $agents;
}
开发者ID:hehol,项目名称:GemeinschaftPBX,代码行数:25,代码来源:gs_agents_get.php


示例5: gs_callwaiting_get

function gs_callwaiting_get($user)
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
        return new GsError('User must be alphanumeric.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
    if (!$user_id) {
        return new GsError('Unknown user.');
    }
    # get state
    #
    $rs = $db->execute('SELECT `active` FROM `callwaiting` WHERE `user_id`=' . $user_id);
    if ($r = $rs->fetchRow()) {
        return (bool) $r['active'];
    }
    return false;
}
开发者ID:rkania,项目名称:GS3,代码行数:25,代码来源:gs_callwaiting_get.php


示例6: gs_hosts_get

function gs_hosts_get($foreign = false, $group_id = null)
{
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get hosts
    #
    $where = array();
    if ($foreign !== null) {
        $where[] = '`is_foreign`=' . ($foreign ? '1' : '0');
    }
    if ($group_id !== null) {
        $where[] = '`group_id`=' . (int) $group_id;
    }
    $query = 'SELECT `id`, `host`, `comment`, `is_foreign`, `group_id`
FROM `hosts`
' . (count($where) === 0 ? '' : 'WHERE ' . implode(' AND ', $where)) . '
ORDER BY `is_foreign`,`host`';
    $rs = $db->execute($query);
    if (!$rs) {
        return new GsError('Error.');
    }
    $hosts = array();
    while ($r = $rs->fetchRow()) {
        $hosts[] = $r;
    }
    return $hosts;
}
开发者ID:rkania,项目名称:GS3,代码行数:31,代码来源:gs_hosts_get.php


示例7: gs_queues_get

function gs_queues_get()
{
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get queues
    #
    $rs = $db->execute('SELECT
	`q`.`_id` `id`, `q`.`name`, `q`.`_title` `title`, `q`.`maxlen`,
	COUNT(`m`.`_user_id`) `num_members`
FROM
	`ast_queues` `q` LEFT JOIN
	`ast_queue_members` `m` ON (m._queue_id=q._id)
GROUP BY `q`.`_id`
ORDER BY `q`.`name`');
    if (!$rs) {
        return new GsError('Error.');
    }
    $queues = array();
    while ($r = $rs->fetchRow()) {
        $queues[] = $r;
    }
    return $queues;
}
开发者ID:rkania,项目名称:GS3,代码行数:27,代码来源:gs_queues_get.php


示例8: gs_host_del

function gs_host_del($host, $force = FALSE)
{
    if (!preg_match('/^[0-9\\.]+$/', $host)) {
        return new GsError('Host must be a numeric ID or IP address.');
    }
    $host = gs_host_by_id_or_ip($host);
    if (isGsError($host)) {
        return new GsError($host->getMsg());
    }
    if (!is_array($host)) {
        return new GsError('Cannot retrieve host ID.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    $count_users = $db->executeGetOne('SELECT COUNT(`id`) FROM `users` WHERE `host_id`=\'' . $db->escape($host['id']) . '\'');
    if ($count_users > 0) {
        return new GsError('Cannot delete host. Delete ' . $count_users . ' user(s) on this host first.');
    }
    #delete host from all groups
    #
    gs_group_members_purge_by_type('host', array($host['id']));
    # delete host
    #
    $rs = $db->execute('DELETE from `hosts` WHERE `id`=\'' . $db->escape($host['id']) . '\'');
    if (!$rs) {
        return new GsError('Could not delete host ' . $host['id']);
    }
    return true;
}
开发者ID:rkania,项目名称:GS3,代码行数:33,代码来源:gs_host_del.php


示例9: gs_screensaver_get

function gs_screensaver_get($user)
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
        return new GsError('User must be alphanumeric.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
    if (!$user_id) {
        return new GsError('Unknown user.');
    }
    $screensaver = array();
    # get screensaver picture's
    #
    $rs = $db->execute('SELECT `pic_nr`, `file` FROM `screensaver` WHERE `user_id`=' . $user_id . ' ORDER BY `pic_nr` ASC');
    if (!$rs) {
        return new GsError('Failed to get screensaver pictures.');
    }
    while ($r = $rs->fetchRow()) {
        $pic_nr = (int) $r['pic_nr'];
        $screensaver[$pic_nr] = $r['file'];
    }
    return $screensaver;
}
开发者ID:sebastianertz,项目名称:gemeinschaft-grandstream,代码行数:30,代码来源:gs_screensaver_get.php


示例10: gs_queue_agent_del

function gs_queue_agent_del($queue_id, $agent)
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $agent)) {
        return new GsError('User must be alphanumeric.');
    }
    $queue_id = (int) $queue_id;
    if ($queue_id < 1) {
        return new GsError('Bad queue ID.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # check queue id
    #
    $num = (int) $db->executeGetOne('SELECT COUNT(*) FROM `ast_queues` WHERE `_id`=' . $queue_id);
    if ($num < 1) {
        return new GsError('Unknown queue ID.');
    }
    # get agent_id
    #
    $agent_id = (int) $db->executeGetOne('SELECT `id` FROM `agents` WHERE `number`=\'' . $db->escape($agent) . '\'');
    if (!$agent_id) {
        return new GsError('Unknown agent.');
    }
    # delete agent to the queue
    #
    $ok = $db->execute('DELETE FROM `agent_queues` WHERE `agent_id`=' . $agent_id . ' AND `queue_id`= ' . $queue_id);
    if (!$ok) {
        return new GsError('Failed to delete agent from queue.');
    }
    return true;
}
开发者ID:hehol,项目名称:GemeinschaftPBX,代码行数:35,代码来源:gs_queue_agent_del.php


示例11: gs_user_comment_set

function gs_user_comment_set($user, $comment = '')
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
        return new GsError('User must be alphanumeric.');
    }
    $comment = mb_subStr($comment, 0, 200);
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
    if (!$user_id) {
        return new GsError('Unknown user.');
    }
    # set comment
    #
    $ok = $db->execute('UPDATE `users` SET `user_comment`=\'' . $db->escape($comment) . '\' WHERE `id`=' . $user_id);
    if (!$ok) {
        return new GsError('Failed to set comment.');
    }
    return true;
}
开发者ID:rkania,项目名称:GS3,代码行数:26,代码来源:gs_user_comment_set.php


示例12: gs_user_phonemodel_get

function gs_user_phonemodel_get($user)
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
        return new GsError('User must be alphanumeric.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = (int) $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
    if ($user_id < 1) {
        return new GsError('Unknown user.');
    }
    # get phone-model
    #
    $type = $db->executeGetOne('SELECT `type` FROM `phones` WHERE `user_id`=' . $user_id);
    if (!$type) {
        return 'none';
    }
    return $type;
}
开发者ID:rkania,项目名称:GS3,代码行数:25,代码来源:gs_user_phonemodel_get.php


示例13: gs_huntgroup_del

function gs_huntgroup_del($hgroup_number)
{
    $hgroup_number = (int) $hgroup_number;
    if ($hgroup_number < 1) {
        return new GsError('Bad group ID.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # check group id
    #
    $num = (int) $db->executeGetOne('SELECT COUNT(*) FROM `huntgroups` WHERE `number`=' . $hgroup_number);
    if ($num < 1) {
        return new GsError('Unknown hunt group.');
    }
    # delete hun group
    #
    $ok = $db->execute('DELETE FROM `huntgroups` WHERE `number`=' . $hgroup_number);
    if (!$ok) {
        return new GsError('Failed to remove hunt group.');
    }
    return true;
}
开发者ID:hehol,项目名称:GemeinschaftPBX,代码行数:26,代码来源:gs_huntgroup_del.php


示例14: gs_agent_del

function gs_agent_del($agent)
{
    if (!preg_match('/^\\d+$/', $agent)) {
        return new GsError('Agent-number must be numeric.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $agent_id = (int) $db->executeGetOne('SELECT `id` FROM `agents` WHERE `number`=\'' . $db->escape($agent) . '\'');
    if (!$agent_id) {
        return new GsError('Unknown agent.');
    }
    # delete agent_queues
    #
    $ok = $db->execute('DELETE FROM `agent_queues` WHERE `agent_id`=' . $agent_id);
    # delete user
    #
    $ok = $db->execute('DELETE FROM `agents` WHERE `id`=' . $agent_id);
    return true;
}
开发者ID:hehol,项目名称:GemeinschaftPBX,代码行数:25,代码来源:gs_agent_del.php


示例15: gs_agent_pause_unpause

function gs_agent_pause_unpause($agent_id, $pause, $reason = '')
{
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = $db->executeGetOne('SELECT `user_id` FROM `agents` WHERE `id`=\'' . $db->escape($agent_id) . '\'');
    if (!$user_id || $user_id <= 0) {
        return new GsError('Unknown agent.');
    }
    # get sip user
    #
    $user_name = $db->executeGetOne('SELECT `name` FROM `ast_sipfriends` WHERE `_user_id`=\'' . $db->escape($user_id) . '\'');
    if (!$user_name) {
        return new GsError('Unknown user.');
    }
    # switch pause state
    #
    gs_queuepause_unpause($user_name, $pause, $reason);
    return true;
}
开发者ID:hehol,项目名称:GemeinschaftPBX,代码行数:25,代码来源:gs_agent_pause_unpause.php


示例16: gs_vm_get

function gs_vm_get($user)
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
        return new GsError('User must be alphanumeric.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
    if (!$user_id) {
        return new GsError('Unknown user.');
    }
    # get state
    #
    $rs = $db->execute('SELECT `internal_active`, `external_active` FROM `vm` WHERE `user_id`=' . $user_id);
    if ($r = $rs->fetchRow()) {
        $r['internal_active'] = (bool) $r['internal_active'];
        $r['external_active'] = (bool) $r['external_active'];
        return $r;
    }
    return array('internal_active' => false, 'external_active' => false);
}
开发者ID:rkania,项目名称:GS3,代码行数:27,代码来源:gs_vm_get.php


示例17: gs_user_callerid_add

function gs_user_callerid_add($user, $number, $dest)
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
        return new GsError('User must be alphanumeric.');
    }
    if (!preg_match('/^[\\d]+$/', $number)) {
        return new GsError('Number must be numeric.');
    }
    if ($dest != 'internal' && $dest != 'external') {
        return new GsError('No destination.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
    if ($user_id < 1) {
        return new GsError('Unknown user.');
    }
    # add number
    #
    $ok = $db->execute('REPLACE INTO `users_callerids` (`user_id`, `number`, `dest`) VALUES (' . $user_id . ', \'' . $db->escape($number) . '\', \'' . $db->escape($dest) . '\')');
    if (!$ok) {
        return new GsError('Failed to add callerid.');
    }
    return true;
}
开发者ID:hehol,项目名称:GemeinschaftPBX,代码行数:31,代码来源:gs_user_callerid_add.php


示例18: gs_users_get

function gs_users_get()
{
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get users
    #
    $rs = $db->execute('SELECT
	`u`.`id`, `u`.`user`, `u`.`pin`,
	`u`.`lastname`, `u`.`firstname`, `u`.`honorific`, `u`.`email`,
	`s`.`name` `ext`, `s`.`callerid`, `s`.`mailbox`,
	`h`.`host`,
	`ug`.`name` `group`
FROM
	`users` `u` JOIN
	`ast_sipfriends` `s` ON (`s`.`_user_id`=`u`.`id`) LEFT JOIN
	`hosts` `h` ON (`h`.`id`=`u`.`host_id`) LEFT JOIN
	`user_groups` `ug` ON (`ug`.`id`=`u`.`group_id`)
ORDER BY
	`u`.`lastname`, `u`.`firstname`, `u`.`honorific`, `u`.`id`');
    if (!$rs) {
        return new GsError('Error.');
    }
    $users = array();
    while ($r = $rs->fetchRow()) {
        $users[] = $r;
    }
    return $users;
}
开发者ID:philipp-kempgen,项目名称:amooma-gemeinschaft-pbx,代码行数:32,代码来源:gs_users_get.php


示例19: gs_callblocking_get

function gs_callblocking_get($user)
{
    if (!preg_match('/^[a-z0-9\\-_.]+$/', $user)) {
        return new GsError('User must be alphanumeric.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get user_id
    #
    $user_id = $db->executeGetOne('SELECT `id` FROM `users` WHERE `user`=\'' . $db->escape($user) . '\'');
    if ($user_id < 1) {
        return new GsError('Unknown user.');
    }
    # get call blocking
    #
    $rs = $db->execute('SELECT `regexp`, `pin` FROM `callblocking` WHERE `user_id`=' . $user_id . ' ORDER BY LENGTH(`regexp`) DESC');
    if (!$rs) {
        return new GsError('Failed to get outgoing call blocking entry.');
    }
    $callblocking = array();
    while ($r = $rs->fetchRow()) {
        $callblocking[] = $r;
    }
    return $callblocking;
}
开发者ID:rkania,项目名称:GS3,代码行数:29,代码来源:gs_callblocking_get.php


示例20: gs_huntgroup_callforward_get

function gs_huntgroup_callforward_get($huntgroup)
{
    if (!preg_match('/^[\\d]+$/', $huntgroup)) {
        return new GsError('Hunt group must be numeric.');
    }
    # connect to db
    #
    $db = gs_db_master_connect();
    if (!$db) {
        return new GsError('Could not connect to database.');
    }
    # get states
    #
    $sources = array('internal', 'external');
    $cases = array('always', 'full', 'timeout', 'empty');
    $forwards = array();
    foreach ($sources as $source) {
        foreach ($cases as $case) {
            $rs = $db->execute('SELECT `active`, `number_std`, `number_var`, `timeout` FROM `huntgroups_callforwards` WHERE `huntgroup`=' . $huntgroup . ' AND `source`=\'' . $source . '\' AND `case`=\'' . $case . '\'');
            if ($r = $rs->fetchRow()) {
                if (!in_array($r['active'], array('no', 'std', 'var'), true)) {
                    $r['active'] = 'no';
                }
                $forwards[$source][$case] = $r;
            } else {
                $forwards[$source][$case] = array('active' => 'no', 'number_std' => '', 'number_var' => '', 'timeout' => 20);
            }
            if ($case != 'timeout') {
                $forwards[$source][$case]['timeout'] = null;
            }
        }
    }
    return $forwards;
}
开发者ID:hehol,项目名称:GemeinschaftPBX,代码行数:34,代码来源:gs_huntgroup_callforward_get.php



注:本文中的gs_db_master_connect函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP gs_db_slave_connect函数代码示例发布时间:2022-05-15
下一篇:
PHP grr_sql_row函数代码示例发布时间:2022-05-15
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap