PHP DB_Select函数代码示例

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

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

示例1: Select

 public function Select($ServerID)
 {
     /******************************************************************************/
     $__args_types = array('integer');
     #-------------------------------------------------------------------------------
     $__args__ = Func_Get_Args();
     eval(FUNCTION_INIT);
     /******************************************************************************/
     $Settings = DB_Select('Servers', '*', array('UNIQ', 'ID' => $ServerID));
     #-------------------------------------------------------------------------------
     switch (ValueOf($Settings)) {
         case 'error':
             return ERROR | @Trigger_Error('[HostingServer->Select]: не удалось выбрать сервер');
         case 'exception':
             return new gException('SERVER_NOT_FOUND', 'Указаный сервер не найден');
         case 'array':
             #-------------------------------------------------------------------------------
             $this->SystemID = $Settings['Params']['SystemID'];
             #-------------------------------------------------------------------------------
             $this->Settings = $Settings;
             #-------------------------------------------------------------------------------
             if (Is_Error(System_Load(SPrintF('libs/%s.php', $this->SystemID)))) {
                 @Trigger_Error('[HostingServer->Select]: не удалось загрузить целевую библиотеку');
             }
             #-------------------------------------------------------------------------------
             return TRUE;
             #-------------------------------------------------------------------------------
         #-------------------------------------------------------------------------------
         default:
             return ERROR | @Trigger_Error(101);
     }
     #-------------------------------------------------------------------------------
 }

开发者ID:carriercomm，项目名称:jbs，代码行数:33，代码来源:HostingServer.class.php

示例2: smarty_function_copyright

function smarty_function_copyright($params, $smarty)
{
    $Copyright = DB_Select('Config', 'Value', array('UNIQ', 'Where' => "`Param` = 'Copyright'"));
    if (!Is_Array($Copyright)) {
        return ERROR | @Trigger_Error(500);
    }
    return $Copyright['Value'];
}

开发者ID:carriercomm，项目名称:jbs，代码行数:8，代码来源:function.copyright.php

示例3: getParams

 public function getParams()
 {
     $Server = DB_Select('Servers', array('Address', 'Params'), array('UNIQ', 'Where' => SPrintF('(SELECT `ServerID` FROM `OrdersOwners` WHERE `OrdersOwners`.`ID` = %u) = `Servers`.`ID`', $this->params['OrderID'])));
     if (!Is_Array($Server)) {
         return ERROR | @Trigger_Error(500);
     }
     $this->params['Server'] = $Server;
     return $this->params;
 }

开发者ID:carriercomm，项目名称:jbs，代码行数:9，代码来源:VPSPasswordChangeMsg.class.php

示例4: getParams

 public function getParams()
 {
     Debug(print_r($this->params, true));
     $Service = DB_Select('Services', array('ID', 'Code', 'Name', 'NameShort'), array('UNIQ', 'ID' => $this->params['ServiceID']));
     if (!Is_Array($Service)) {
         return ERROR | @Trigger_Error(500);
     }
     $this->params['Service'] = $Service;
     return $this->params;
 }

开发者ID:carriercomm，项目名称:jbs，代码行数:10，代码来源:OrdersSuspendedMsg.class.php

示例5: FindSystem

 public function FindSystem($ExtraIPOrderID, $OrderType, $DependOrderID)
 {
     /****************************************************************************/
     $__args_types = array('integer', 'string', 'integer');
     $__args__ = Func_Get_Args();
     eval(FUNCTION_INIT);
     /****************************************************************************/
     /* find server */
     Debug(SPrintF('[system/classes/ExtraIPServer]: OrderType = %s', $OrderType));
     #-------------------------------------------------------------------------------
     $Columns = array(SPrintF('(SELECT `ServerID` FROM `OrdersOwners` WHERE `OrdersOwners`.`ID` = `%sOrdersOwners`.`OrderID`) AS `ServerID`', $OrderType), 'Login');
     #-------------------------------------------------------------------------------
     #-------------------------------------------------------------------------------
     $OrderServer = DB_Select(SPrintF('%sOrdersOwners', $OrderType), $Columns, array('UNIQ', 'ID' => $DependOrderID));
     switch (ValueOf($OrderServer)) {
         case 'error':
             return ERROR | @Trigger_Error('[Server->Select]: ошибка поиска зависимого заказа');
         case 'exception':
             return new gException('DEPEND_ORDER_NOT_FOUND', 'Не найден заказ к которому необходимо добавить/удалить IP адрес');
         case 'array':
             #-------------------------------------------------------------------------------
             $SysInfo = DB_Select('Servers', '*', array('UNIQ', 'ID' => $OrderServer['ServerID']));
             switch (ValueOf($SysInfo)) {
                 case 'error':
                     return ERROR | @Trigger_Error('[Server->Select]: не удалось выбрать сервер');
                 case 'exception':
                     return new gException('SERVER_NOT_FOUND', 'Указаный сервер не найден');
                 case 'array':
                     /* find server info */
                     #-------------------------------------------------------------------------
                     # add User Login on server
                     $SysInfo['UserLogin'] = $OrderServer['Login'];
                     Debug(SPrintF('[system/classes/ExtraIPServer]: OrderType = %s', $OrderType));
                     Debug(SPrintF('[system/classes/ExtraIPServer]: found ICS: %s', $SysInfo['Params']['SystemID']));
                     $this->SystemID = $SysInfo['Params']['SystemID'];
                     $this->Settings = $SysInfo;
                     if (Is_Error(System_Load(SPrintF('libs/%s.php', $this->SystemID)))) {
                         @Trigger_Error('[Server->Select]: не удалось загрузить целевую библиотеку');
                     }
                     // + надо загрузить собсно либу для работы с IP адресами
                     #-------------------------------------------------------------------------------
                     return TRUE;
                     #-------------------------------------------------------------------------------
                 #-------------------------------------------------------------------------------
                 default:
                     return ERROR | @Trigger_Error(101);
             }
         default:
             return ERROR | @Trigger_Error(101);
     }
 }

开发者ID:carriercomm，项目名称:jbs，代码行数:51，代码来源:ExtraIPServer.class.php

示例6: getParams

 public function getParams()
 {
     #-------------------------------------------------------------------------------
     #$Server = DB_Select('HostingServers', Array('Address', 'Url', 'Ns1Name', 'Ns2Name', 'MySQL'), Array('UNIQ', 'ID' => $this->params['ServerID']));
     $Server = DB_Select('Servers', array('Address', 'Params'), array('UNIQ', 'Where' => SPrintF('(SELECT `ServerID` FROM `OrdersOwners` WHERE `OrdersOwners`.`ID` = %u) = `Servers`.`ID`', $this->params['OrderID'])));
     if (!Is_Array($Server)) {
         return ERROR | @Trigger_Error(500);
     }
     #-------------------------------------------------------------------------------
     $this->params['Server'] = $Server;
     #-------------------------------------------------------------------------------
     return $this->params;
     #-------------------------------------------------------------------------------
 }

开发者ID:carriercomm，项目名称:jbs，代码行数:14，代码来源:HostingPasswordChangeMsg.class.php

示例7: CreateMap

function CreateMap($ID, &$ParentNode)
{
    #-----------------------------------------------------------------------------
    $Group = DB_Select('Groups', '*', array('UNIQ', 'ID' => $ID));
    #-----------------------------------------------------------------------------
    switch (ValueOf($Group)) {
        case 'error':
            return ERROR | @Trigger_Error(500);
        case 'exception':
            return ERROR | @Trigger_Error(400);
        case 'array':
            #-------------------------------------------------------------------------
            $Node = new Tag('node', array('TEXT' => $Group['Name'], 'STYLE' => 'bubble', 'BACKGROUND_COLOR' => $Group['IsDepartment'] ? '#F07D00' : '#F9E47D'), new Tag('edge', array('STYLE' => 'sharp_bezier', 'COLOR' => '#D5F66C', 'WIDTH' => 5)), new Tag('font', array('BOLD' => 'true', 'NAME' => 'SansSerif', 'SIZE' => 14)), new Tag('icon', array('BUILTIN' => 'none')));
            #-------------------------------------------------------------------------
            $Childs = DB_Select('Groups', '*', array('Where' => SPrintF('`ParentID` = %u AND `ParentID` != `ID`', $Group['ID'])));
            #-------------------------------------------------------------------------
            switch (ValueOf($Childs)) {
                case 'error':
                    return ERROR | @Trigger_Error(500);
                case 'exception':
                    # No more...
                    break;
                case 'array':
                    #---------------------------------------------------------------------
                    foreach ($Childs as $Child) {
                        CreateMap($Child['ID'], $Node);
                    }
                    break;
                default:
                    return ERROR | @Trigger_Error(101);
            }
            #-------------------------------------------------------------------------
            $ParentNode->AddChild($Node);
            #-------------------------------------------------------------------------
            return TRUE;
        default:
            return ERROR | @Trigger_Error(101);
    }
}

开发者ID:carriercomm，项目名称:jbs，代码行数:39，代码来源:GroupsMap.xml.comp.php

示例8: Select

 public function Select($ServerID)
 {
     /******************************************************************************/
     $__args_types = array('integer');
     #-------------------------------------------------------------------------------
     $__args__ = Func_Get_Args();
     eval(FUNCTION_INIT);
     /******************************************************************************/
     Debug('[system/classes/DomainServer.class.php]: function Select');
     #-------------------------------------------------------------------------------
     $Settings = DB_Select('Servers', '*', array('UNIQ', 'ID' => $ServerID));
     #-------------------------------------------------------------------------------
     switch (ValueOf($Settings)) {
         case 'error':
             return ERROR | @Trigger_Error('[DomainServer->Select]: не удалось выбрать регистратора');
         case 'exception':
             return new gException('REGISTRATOR_NOT_FOUND', 'Указаный регистратор не найден');
         case 'array':
             break;
         default:
             return ERROR | @Trigger_Error(101);
     }
     #-------------------------------------------------------------------------------
     $this->SystemID = $Settings['Params']['SystemID'];
     #-------------------------------------------------------------------------------
     $this->Settings = $Settings;
     #-------------------------------------------------------------------------------
     if (Is_Error(System_Load(SPrintF('libs/%s.php', $this->Settings['Params']['SystemID'])))) {
         return ERROR | @Trigger_Error(500);
     }
     #-------------------------------------------------------------------------------
     #-------------------------------------------------------------------------------
     return TRUE;
     #-------------------------------------------------------------------------------
     #-------------------------------------------------------------------------------
 }

开发者ID:carriercomm，项目名称:jbs，代码行数:36，代码来源:DomainServer.class.php

示例9: Is_Array

 $DomainScheme = Is_Array($DomainScheme) ? $DomainScheme : array();
 #-------------------------------------------------------------------
 $dDomainScheme = DB_Select('DomainsSchemes', 'ID', array('Where' => SPrintF("`Name` = '%s'", $DomainScheme['DomainZone'])));
 #-------------------------------------------------------------------
 switch (ValueOf($dDomainScheme)) {
     case 'error':
         return ERROR | @Trigger_Error(500);
     case 'exception':
         #---------------------------------------------------------------
         $IDomainScheme = array('GroupID' => 2000000, 'UserID' => 100, 'Name' => $DomainScheme['DomainZone'], 'CostOrder' => $DomainScheme['CostOrder'], 'CostProlong' => $DomainScheme['CostProlong'], 'MinOrderYears' => 1, 'MaxActionYears' => 1, 'DaysToProlong' => 31);
         #---------------------------------------------------------------
         $Registrator = $DomainScheme['Registrator'];
         #---------------------------------------------------------------
         $Registrator = Is_Array($Registrator) ? $Registrator : array();
         #---------------------------------------------------------------
         $dRegistrator = DB_Select('Registrators', 'ID', array('UNIQ', 'Where' => SPrintF("`Name` = '%s'", $Registrator['Name'])));
         #---------------------------------------------------------------
         switch (ValueOf($dRegistrator)) {
             case 'error':
                 return ERROR | @Trigger_Error(500);
             case 'exception':
                 #-----------------------------------------------------------
                 $IRegistrator = array('Name' => $Registrator['Name'], 'TypeID' => $Registrator['TypeID'], 'Address' => $Registrator['Address'], 'Port' => $Registrator['Port'], 'Protocol' => $Registrator['Protocol'], 'Login' => $Registrator['Login'], 'Password' => 'Default');
                 #-----------------------------------------------------------
                 $RegistratorID = DB_Insert('Registrators', $IRegistrator);
                 if (Is_Error($RegistratorID)) {
                     return ERROR | @Trigger_Error(500);
                 }
                 #-----------------------------------------------------------
                 $IDomainScheme['RegistratorID'] = $RegistratorID;
                 break;

开发者ID:carriercomm，项目名称:jbs，代码行数:31，代码来源:Import.comp.php

示例10: array

#-------------------------------------------------------------------------------
/** @author Alex Keda, for www.host-food.ru */
/******************************************************************************/
/******************************************************************************/
$__args_list = array('Task', 'DNSmanagerOrderID');
/******************************************************************************/
eval(COMP_INIT);
/******************************************************************************/
/******************************************************************************/
if (Is_Error(System_Load('classes/DNSmanagerServer.class.php'))) {
    return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
$Columns = array('ID', 'UserID', 'Login', '(SELECT `ServerID` FROM `OrdersOwners` WHERE `OrdersOwners`.`ID` = `DNSmanagerOrdersOwners`.`OrderID`) AS `ServerID`', '(SELECT `IsReselling` FROM `DNSmanagerSchemes` WHERE `DNSmanagerSchemes`.`ID` = `DNSmanagerOrdersOwners`.`SchemeID`) as `IsReselling`', '(SELECT `Name` FROM `DNSmanagerSchemes` WHERE `DNSmanagerSchemes`.`ID` = `DNSmanagerOrdersOwners`.`SchemeID`) as `SchemeName`');
$DNSmanagerOrder = DB_Select('DNSmanagerOrdersOwners', $Columns, array('UNIQ', 'ID' => $DNSmanagerOrderID));
#-------------------------------------------------------------------------------
switch (ValueOf($DNSmanagerOrder)) {
    case 'error':
        return ERROR | @Trigger_Error(500);
    case 'exception':
        return ERROR | @Trigger_Error(400);
    case 'array':
        #-------------------------------------------------------------------------------
        $ClassDNSmanagerServer = new DNSmanagerServer();
        #-------------------------------------------------------------------------------
        $IsSelected = $ClassDNSmanagerServer->Select((int) $DNSmanagerOrder['ServerID']);
        #-------------------------------------------------------------------------------
        switch (ValueOf($IsSelected)) {
            case 'error':
                return ERROR | @Trigger_Error(500);

开发者ID:carriercomm，项目名称:jbs，代码行数:30，代码来源:DNSmanagerActive.comp.php

示例11: foreach

#-------------------------------------------------------------------------------
// перебираем полученных пользователей.
foreach ($Users as $User) {
    #-------------------------------------------------------------------------------
    # выбираем меньшую из дат, т.к. мог не входить никогда
    $EnterDate = $User['EnterDate'] > $User['RegisterDate'] ? $User['EnterDate'] : $User['RegisterDate'];
    Debug(SPrintF('[comp/Tasks/GC/WithdrawalOldUsers]: автоматическое списание денег с балланса юзера (%s) не заходившего в биллинг %s дней', $User['Email'], Ceil((Time() - $EnterDate) / (24 * 3600))));
    #-------------------------------------------------------------------------------
    #if($User['Email'] != 'mgolub@moskb.ru')
    #	continue;
    #-------------------------------------------------------------------------------
    #-------------------------------------------------------------------------------
    # выбираем договора юзера с баллансом больше нуля
    $Where = array(SPrintF('`UserID` = %u', $User['ID']), '`Balance` > 0');
    #-------------------------------------------------------------------------------
    $Contract = DB_Select('Contracts', array('ID', 'TypeID', 'Customer', 'Balance'), array('UNIQ', 'Where' => $Where, 'Limits' => array(0, 1)));
    #-------------------------------------------------------------------------------
    switch (ValueOf($Contract)) {
        case 'error':
            return ERROR | @Trigger_Error(500);
        case 'exception':
            return new gException('CONTRACT_NOT_FOUND', 'Договора не найдены');
        case 'array':
            break;
        default:
            return ERROR | @Trigger_Error(101);
    }
    #-------------------------------------------------------------------------------
    Debug(SPrintF('[comp/Tasks/GC/WithdrawalOldUsers]: юзер (%s), договор #%u, балланс %s', $User['Email'], $Contract['ID'], $Contract['Balance']));
    #-------------------------------------------------------------------------------
    #-------------------------------------------------------------------------------

开发者ID:carriercomm，项目名称:jbs，代码行数:31，代码来源:WithdrawalOldUsers.comp.php

示例12: DB_Insert

     default:
         return ERROR | @Trigger_Error(101);
 }
 #---------------------------------------------------------------------------
 $MessageID = DB_Insert('EdesksMessages', $IEdeskMessage);
 if (Is_Error($MessageID)) {
     return ERROR | @Trigger_Error(500);
 }
 #---------------------------------------------------------------------------
 if (isset($IEdeskMessage['FileName'])) {
     if (!SaveUploadedFile('EdesksMessages', $MessageID, $Upload['Data'])) {
         return new gException('CANNOT_SAVE_UPLOADED_FILE', 'Не удалось сохранить загруженный файл');
     }
 }
 #---------------------------------------------------------------------------
 $Users = DB_Select('Users', 'ID', array('Where' => SPrintF('`ID` != %u AND `ID` > 50', $__USER['ID'])));
 #---------------------------------------------------------------------------
 switch (ValueOf($Users)) {
     case 'error':
         return ERROR | @Trigger_Error(500);
     case 'exception':
         return ERROR | @Trigger_Error(400);
     case 'array':
         #-----------------------------------------------------------------------
         foreach ($Users as $User) {
             #---------------------------------------------------------------------
             $IsSend = NotificationManager::sendMsg('EdeskCreate', (int) $User['ID'], array('EdeskID' => $EdeskID, 'Theme' => $Theme, 'Message' => $Message));
             #---------------------------------------------------------------------
             switch (ValueOf($IsSend)) {
                 case 'error':
                     return ERROR | @Trigger_Error(500);

开发者ID:carriercomm，项目名称:jbs，代码行数:31，代码来源:EdeskEdit.comp.php

示例13: DB_Select

$DependService = DB_Select(array('Servers', 'ServersGroups'), array('(SELECT `Code` FROM `Services` WHERE `Services`.`ID` = `ServersGroups`.`ServiceID`) AS `Code`', '(SELECT `NameShort` FROM `Services` WHERE `Services`.`ID` = `ServersGroups`.`ServiceID`)'), array('UNIQ', 'Where' => array('`Servers`.`ServersGroupID` = `ServersGroups`.`ID`', SPrintF('`Servers`.`ID` = %u', $ExtraIPOrder['ServerID']))));
#-------------------------------------------------------------------------------
switch (ValueOf($DependService)) {
    case 'error':
        return ERROR | @Trigger_Error(500);
    case 'exception':
        return new gException('DESTINATION_SERVER_NOT_FOUND', 'Сервер размещения не найден');
    case 'array':
        break;
    default:
        return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
# находим данные для этого заказа Хостинга/ВПС
$DependOrder = DB_Select(SPrintF('%sOrdersOwners', $DependService['Code']), array('ID', 'UserID', 'Login', 'Password', 'Domain', 'SchemeID'), array('UNIQ', 'Where' => SPrintF('`OrderID` = %u', $ExtraIPOrder['DependOrderID'])));
switch (ValueOf($DependOrder)) {
    case 'error':
        return ERROR | @Trigger_Error(500);
    case 'exception':
        return ERROR | @Trigger_Error(400);
    case 'array':
        break;
    default:
        return ERROR | @Trigger_Error(101);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$ExtraIPServer = new ExtraIPServer();
#-------------------------------------------------------------------------------
$IsSelected = $ExtraIPServer->FindSystem((int) $ExtraIPOrderID, (string) $DependService['Code'], (int) $DependOrder['ID']);

开发者ID:carriercomm，项目名称:jbs，代码行数:31，代码来源:ExtraIPDelete.comp.php

示例14: eval

/******************************************************************************/
eval(COMP_INIT);
/******************************************************************************/
/******************************************************************************/
$Args = Args();
#-------------------------------------------------------------------------------
$TableID = (string) @$Args['TableID'];
$RowID = (int) @$Args['RowID'];
$UserNotice = (string) @$Args['UserNotice'];
#-------------------------------------------------------------------------------
if (Is_Error(System_Load('modules/Authorisation.mod'))) {
    return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
$Notice = DB_Select(SPrintF('%sOwners', $TableID), array('ID', 'UserNotice', 'UserID'), array('UNIQ', 'ID' => $RowID));
#-------------------------------------------------------------------------------
switch (ValueOf($Notice)) {
    case 'error':
        return ERROR | @Trigger_Error(500);
    case 'exception':
        return ERROR | @Trigger_Error(400);
    case 'array':
        #-------------------------------------------------------------------------------
        if ($GLOBALS['__USER']['ID'] != $Notice['UserID']) {
            if (!$GLOBALS['__USER']['IsAdmin']) {
                return ERROR | @Trigger_Error(700);
            }
        }
        #-------------------------------------------------------------------------------
        break;

开发者ID:carriercomm，项目名称:jbs，代码行数:31，代码来源:NoticeEdit.comp.php

示例15: DB_Select

/******************************************************************************/
# Ищем максимальный UserID
$MaxUserID = DB_Select('Users', 'MAX(`ID`) AS `ID`', array('UNIQ'));
switch (ValueOf($MaxUserID)) {
    case 'error':
        return ERROR | @Trigger_Error(500);
    case 'exception':
        return ERROR | @Trigger_Error(400);
    case 'array':
        break;
    default:
        return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
# перебираем все идентификаторы котоыре > 300 и < 2001
$OldUserIDs = DB_Select('Users', '`ID`', array('Where' => SPrintF('`ID` > 300 AND `ID` < 2001')));
switch (ValueOf($OldUserIDs)) {
    case 'error':
        return ERROR | @Trigger_Error(500);
    case 'exception':
        return TRUE;
    case 'array':
        break;
    default:
        return ERROR | @Trigger_Error(500);
}
#-------------------------------------------------------------------------------
if ($MaxUserID['ID'] < 2001) {
    $NewUserID = 2001;
} else {
    $NewUserID = $MaxUserID['ID'];

开发者ID:carriercomm，项目名称:jbs，代码行数:31，代码来源:1000009.php

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