Exemplo n.º 1
0
 /**
  * Generate a unqiue text-identifier for a given table and column from any input string.
  *
  * Will generate a text identifier from the string (lowercase, alphanum-only), search for the value in the given table/column,
  * and keep incrementing a suffixed counter until the value is unique.
  *
  * @param \pdyn\database\DbDriverInterface $DB An active database connection.
  * @param string $input Any input text.
  * @param string $table The table in which to ensure uniqueness.
  * @param string $field The column in which to ensure uniqueness.
  * @param array $restriction_list Array of values the text-identifier cannot match.
  * @return string The generated, unique text identifier.
  */
 public static function generate_slug(\pdyn\database\DbDriverInterface $DB, $input, $table, $field, array $restriction_list = array())
 {
     $i = 0;
     while (true) {
         $slug = \pdyn\datatype\Text::make_slug($input);
         $slug .= $i != 0 ? '_' . $i : '';
         // This is so we don't add the increment on the first loop.
         if (!empty($restriction_list) && in_array($slug, $restriction_list, true)) {
             $i++;
             continue;
         }
         $found = $DB->get_record($table, [$field => $slug]);
         if (empty($found)) {
             break;
         }
         $i++;
     }
     return $slug;
 }
Exemplo n.º 2
0
 /**
  * Get a list of active sessions.
  *
  * @param  \pdyn\database\DbDriverInterface $DB An active database connection.
  * @return array Array of records of active sessions.
  */
 public static function get_online_users(\pdyn\database\DbDriverInterface &$DB)
 {
     return $DB->get_records('online_users', ['sess_invalid' => '0'], ['sess_created' => 'DESC']);
 }
Exemplo n.º 3
0
Arquivo: User.php Projeto: pdyn/user
 /**
  * Get an array of user objects based on multiple user IDs.
  *
  * @param \pdyn\database\DbDriverInterface $DB A database connection.
  * @param array $ids Array of user IDs.
  * @param int $opts Bitmask of options.
  * @return array Array of user objects for each passed ID, indexed by user id.
  */
 public static function get_by_ids(\pdyn\database\DbDriverInterface $DB, $ids, $opts = self::NO_OPTS)
 {
     if (empty($ids)) {
         return [];
     }
     $filters = [];
     if ($ids !== 'all' && !in_array('*', $ids, true)) {
         $filters['id'] = $ids;
     }
     if (static::opts_contains($opts, self::INCLUDE_DELETED) === false) {
         $filters['deleted'] = 0;
     }
     $order = ['id' => 'DESC'];
     $retopts = ['idindexed' => 'id'];
     $users = $DB->get_records(static::DB_TABLE, $filters, $order, '*', 0, null, $retopts);
     foreach ($users as $userid => $user) {
         $userid = (int) $userid;
         $users[$userid] = static::instance_from_record($DB, $user);
     }
     return $users;
 }
Exemplo n.º 4
0
 /**
  * Get an array of objects by object IDs.
  *
  * @param \pdyn\database\DbDriverInterface $DB A database connection.
  * @param array|string $ids An array of object IDs to get, if 'all', will get all albums.
  * @return array An array of found objects.
  */
 public static function get_by_ids(\pdyn\database\DbDriverInterface $DB, $ids, $additionalfilters = [])
 {
     if (empty($ids)) {
         return [];
     }
     $filters = [];
     if ($ids !== 'all' && !in_array('*', $ids, true)) {
         $filters[static::DB_ID_FIELDNAME] = $ids;
     }
     if (!empty($additionalfilters)) {
         $filters = array_merge($filters, $additionalfilters);
     }
     $order = ['timeupdated' => 'DESC'];
     $retopts = ['idindexed' => static::DB_ID_FIELDNAME];
     $items = $DB->get_records(static::DB_TABLE, $filters, $order, '*', 0, null, $retopts);
     foreach ($items as $itemid => $item) {
         $items[$itemid] = static::instance_from_record($DB, $item);
     }
     return $items;
 }