PHP FDB::numRows方法代码示例

function bindCacheIpbanned()
{
    FDB::query("DELETE FROM " . FDB::table('ip_banned') . " WHERE expiration<'" . TIME_UTC . "'");
    $data = array();
    $query = FDB::query("SELECT ip1, ip2, ip3, ip4, expiration FROM " . FDB::table('ip_banned'));
    if (FDB::numRows($query)) {
        $data['expiration'] = 0;
        $data['regexp'] = $separator = '';
    }
    while ($banned = FDB::fetch($query)) {
        $data['expiration'] = !$data['expiration'] || $banned['expiration'] < $data['expiration'] ? $banned['expiration'] : $data['expiration'];
        $data['regexp'] .= $separator . ($banned['ip1'] == '-1' ? '\\d+\\.' : $banned['ip1'] . '\\.') . ($banned['ip2'] == '-1' ? '\\d+\\.' : $banned['ip2'] . '\\.') . ($banned['ip3'] == '-1' ? '\\d+\\.' : $banned['ip3'] . '\\.') . ($banned['ip4'] == '-1' ? '\\d+' : $banned['ip4']);
        $separator = '|';
    }
    FanweService::instance()->cache->saveCache('ipbanned', $data);
}

 /**
  * Queue Message for Delivery
  *
  * <code>
  * <?php
  * $db = new DbConnect('localhost','dbuser','dbpass','dbname');
  * $db->show_errors();
  * $apns = new APNS($db);
  * $apns->newMessage(1, '2010-01-01 00:00:00');
  * $apns->addMessageAlert('You got your emails.');
  * $apns->addMessageBadge(9);
  * $apns->addMessageSound('bingbong.aiff');
  * $apns->queueMessage(); // ADD THE MESSAGE TO QUEUE
  * ?>
  * </code>
  *
  * @access public
  */
 public function queueMessage()
 {
     // check to make sure a message was created
     if (!isset($this->message)) {
         $this->_triggerError('You cannot Queue a message that has not been created. Use newMessage() to create a new message.');
     }
     // loop through possible users
     $to = $this->message['send']['to'];
     $when = $this->message['send']['when'];
     $clientId = is_null($this->message['aps']['clientid']) ? null : $this->prepare($this->message['aps']['clientid']);
     $list = is_array($to) ? $to : array($to);
     unset($this->message['send']);
     // Lets make sure that the recipients are integers. If not then just remove
     foreach ($list as $key => $val) {
         if (!is_numeric($val)) {
             $this->_triggerError("TO id was not an integer: {$val}.");
             unset($list[$key]);
         }
     }
     // No recipients left?
     if (empty($list)) {
         $this->_triggerError('No valid recipient was provided.');
     }
     // Get the devices.
     // fetch the users id and check to make sure they have certain notifications enabled before trying to send anything to them.
     $sql = "\r\n\t\t\tSELECT `pid`, `pushbadge`, `pushalert`, `pushsound`, `clientid`\r\n\t\t\tFROM " . FDB::table('apns_devices') . " \r\n\t\t\tWHERE `pid` IN (" . implode(', ', $list) . ")\r\n\t\t\t\tAND `status`='active'" . (is_null($clientId) ? '' : "\r\n\t\t\t\tAND `clientid` = '{$clientId}'");
     //echo $sql; exit;
     $res = FDB::query($sql);
     if (FDB::numRows($res) == 0) {
         $this->_triggerError('This user does not exist in the database. Message will not be delivered.');
     }
     while ($row = FDB::fetch($res)) {
         $deliver = true;
         // Device id.
         $deviceid = $row['pid'];
         // Get the push settings.
         $pushbadge = $this->prepare($row['pushbadge']);
         $pushalert = $this->prepare($row['pushalert']);
         $pushsound = $this->prepare($row['pushsound']);
         $clientId = $this->prepare($row['clientid']);
         // has user disabled messages?
         if ($pushbadge == 'disabled' && $pushalert == 'disabled' && $pushsound == 'disabled') {
             $deliver = false;
         }
         if ($deliver === false && FDB::numRows($res) > 0) {
             $this->_triggerError('This user has disabled all push notifications. Message will not be delivered.');
         } else {
             if ($deliver === true) {
                 // make temp copy of message so we can cut out stuff this user may not get
                 $usermessage = $this->message;
                 // only send badge if user will get it
                 if ($pushbadge == 'disabled') {
                     $this->_triggerError('This user has disabled Push Badge Notifications, Badge will not be delivered.');
                     unset($usermessage['aps']['badge']);
                 }
                 // only send alert if user will get it
                 if ($pushalert == 'disabled') {
                     $this->_triggerError('This user has disabled Push Alert Notifications, Alert will not be delivered.');
                     unset($usermessage['aps']['alert']);
                 }
                 // only send sound if user will get it
                 if ($pushsound == 'disabled') {
                     $this->_triggerError('This user has disabled Push Sound Notifications, Sound will not be delivered.');
                     unset($usermessage['aps']['sound']);
                 }
                 //echo $usermessage;
                 $fk_device = $this->prepare($deviceid);
                 $message = $this->_jsonEncode($usermessage);
                 $message = $this->prepare($message);
                 $delivery = !empty($when) ? "'{$when}'" : 'NOW()';
                 //echo $message."<br>";
                 $sql = "INSERT INTO " . FDB::table('apns_messages') . " \r\n\t\t\t\t\t\tVALUES (\r\n\t\t\t\t\t\t\tNULL,\r\n\t\t\t\t\t\t\t'{$clientId}',\r\n\t\t\t\t\t\t\t'{$fk_device}',\r\n\t\t\t\t\t\t\t'{$message}',\r\n\t\t\t\t\t\t\t{$delivery},\r\n\t\t\t\t\t\t\t'queued',\r\n\t\t\t\t\t\t\tNOW(),\r\n\t\t\t\t\t\t\tNOW()\r\n\t\t\t\t\t\t);";
                 //echo $sql."<br>";exit;
                 FDB::query($sql);
                 unset($usermessage);
             }
         }
     }
     unset($this->message);
 }