chamilo / chamilo-lms

     * @param string $event_type

     * @return array|bool

     */

    public static function get_events_by_user_and_type($user_id, $event_type)

    {

        $TABLETRACK_DEFAULT = Database::get_main_table(TABLE_STATISTIC_TRACK_E_DEFAULT);

        $user_id = intval($user_id);

        $event_type = Database::escape_string($event_type);

        $sql = "SELECT * FROM $TABLETRACK_DEFAULT

                WHERE default_value_type = 'user_id' AND

                      default_value = $user_id AND

                      default_event_type = '$event_type'

                ORDER BY default_date ";

        $result = Database::query($sql);

        if ($result) {

            return Database::store_result($result, 'ASSOC');

        }

        return false;

    }

    /**

     * Save the new message for one event and for one language

     * @return int User id

     * @assert ('0','---') === 0

     */

    public static function get_user_id_from_original_id($original_user_id_value, $original_user_id_name)

    {

        $t_uf = Database::get_main_table(TABLE_EXTRA_FIELD);

        $t_ufv = Database::get_main_table(TABLE_EXTRA_FIELD_VALUES);

        $extraFieldType = EntityExtraField::USER_FIELD_TYPE;

        $sql = "SELECT item_id as user_id

                FROM $t_uf uf

                INNER JOIN $t_ufv ufv

                ON ufv.field_id=uf.id

                WHERE

                    variable='$original_user_id_name' AND

                    value='$original_user_id_value' AND

                    extra_field_type = $extraFieldType

                ";

        $res = Database::query($sql);

        $row = Database::fetch_object($res);

        if ($row) {

            return $row->user_id;

        } else {

            return 0;

        }

    }

    /**

     * Check if a username is available

    * @param string $keyword

    * @return array|null

    */

   function searchUserByKeyword($keyword)

   {

       if (empty($keyword)) {

           return null;

       }

       $tableUser = Database::get_main_table(TABLE_MAIN_USER);

       $keyword = Database::escape_string($keyword);

       $sql = "SELECT *

               FROM $tableUser

               WHERE

                   (

                       username LIKE '%$keyword%' OR firstname LIKE '%$keyword%' OR lastname LIKE '%$keyword%'

                   )";

       $result = Database::query($sql);

       return Database::store_result($result, 'ASSOC');

   }

    /**

     * @param int $optionSelected