At third-level, are rangers allowed to select a drake as their animal companion?

I wasn’t able to find anything about this in 5th Edition. A drake seems that it would exceed the 1/4 challenge rating stated in the PHB.

In this specific campaign, our Dungeon Master allows anything that is accessible on D&D Beyond not including Homebrew content.

I did find the Drake Warden Ranger archetype, which I assume is for Pathfinder, and thought it might be possible that I’d overlooked a similar variant in D&D 5E.

Select count date from multiple where conditions for each day

I have lot of coupons. I would like to learn for each day how many coupons from each campaign have been received by users. But I cannot write something like assigned_date for each select row

SELECT count(id)                                                  as number_of_coupons,        DATE_FORMAT(assigned_date, '%d-%m-%Y')                     as date,        (SELECT COUNT(id) FROM coupon WHERE campaign_id = 1 AND assigned_date=THIS MUST BE SOMETHING) as campaign_1,        (SELECT COUNT(id) FROM coupon WHERE campaign_id = 2 AND assigned_date=THIS MUST BE SOMETHING) as campaign_2 FROM coupon GROUP BY DATE_FORMAT(assigned_date, '%d-%m-%Y') order by STR_TO_DATE(date, '%d-%m-%Y') DESC 

So the result will be something like. How can I achieve this result?

+-------------------+------------+-------------+-----------+ | number of coupons |    date    |  campaign_1 | campaign2 | +-------------------+------------+-------------+-----------+ |               156 | 12-10-2019 |        6980 |       100 | |               177 | 11-10-2019 |        6980 |       100 | |                44 | 10-10-2019 |        6980 |       100 | |                94 | 09-10-2019 |        6980 |       100 | |                93 | 08-10-2019 |        6980 |       100 | +-------------------+------------+-------------+-----------+ 

Ubuntu 19.04 No Audio Input Devices to Select

I’m unable to use my Thinkpad’s microphone with Ubuntu 19.04. When I attempt to choose an audio input device, none are available. When taking a look in pavucontrol, it lists my microphone as unplugged.

I’ve seen a number of similar questions but none of the answers have worked to help fix this problem.

Thanks in advance for any advice.

sound settings screenshot pavucontrol screenshot

How do you create or select an icon for a feature?

How do you work out what icon type or image you need for a feature?

There’s been quite a lot of very small questions here in the form of “What is a good icon for feature X?”.

Instead we should be looking for a general guide in creating or brainstorming for an icon, that can be applied in a lot of situations and applications.

This could possibly be done by looking an intermediary step:

Feature / Semantics

  1. Terms that represent this feature
  2. Icon for that term

E.g.

Level of anger for client

  1. heat map
  2. Icon for heat map

This question is about step 1, the step you use to create a list, ideas or resource for possible icons that will be applied to the feature.

Using rows from one table as fields in SELECT

I have three tables in my MySQL database – company, extra_fields and extra_fields_info:

mysql> describe company; +-----------------------------+------------------+------+-----+---------+-------+ | Field                       | Type             | Null | Key | Default | Extra | +-----------------------------+------------------+------+-----+---------+-------+ | company_id                  | varchar(64)      | NO   | PRI | NULL    |       | | company_name                | varchar(80)      | YES  |     | NULL    |       | | other_stuff                 | varchar(1)       | YES  |     | n       |       | +-----------------------------+------------------+------+-----+---------+-------+  mysql> describe extra_fields; +-----------------------------+------------------+------+-----+---------+-------+ | Field                       | Type             | Null | Key | Default | Extra | +-----------------------------+------------------+------+-----+---------+-------+ | extra_field_id              | varchar(64)      | NO   | PRI | NULL    |       | | field_name                  | varchar(80)      | YES  |     | NULL    |       | | field_required              | varchar(1)       | YES  |     | n       |       | | field_comment               | varchar(255)     | YES  |     | NULL    |       | +-----------------------------+------------------+------+-----+---------+-------+   mysql> describe extra_fields_info; +--------------------------+-------------+------+-----+---------+-------+ | Field                    | Type        | Null | Key | Default | Extra | +--------------------------+-------------+------+-----+---------+-------+ | extra_info_id            | varchar(64) | NO   | PRI | NULL    |       | | company_id               | varchar(64) | YES  | MUL | NULL    |       | | extra_field_id           | varchar(64) | YES  |     | NULL    |       | | field_value              | text        | YES  |     | NULL    |       | +--------------------------+-------------+------+-----+---------+-------+ 

Here’s an example of some of the data from these fields:

mysql> select efi.extra_field_id, ef.field_name, efi.field_value, efi.company_id from extra_fields_info left join extra_fields ef on efi.extra_field_id = ef.extra_field_id; +----------------+-------------------+--------------------------------+------------+ | extra_field_id | field_name        | field_value                    | company_id | +----------------+-------------------+--------------------------------+------------+ | 1              | is_affiliate_user | y                              | 1          | | 2              | contact_email     | email@gmail.com                | 1          | | 3              | default_currency  | MYR                            | 1          | | 4              | vertical          | 33                             | 1          | | 5              | contact_locale    | en                             | 1          | | 6              | operating_country | MY                             | 1          | | 7              | company_name      | SomeCompanyName1               | 1          | | 1              | is_affiliate_user | y                              | 2          | | 2              | contact_email     | email2@gmail.com               | 2          | | 3              | default_currency  | EUR                            | 2          | | 4              | vertical          | 3                              | 2          | | 5              | contact_locale    | en                             | 2          | | 7              | contact_name      | ContactName                    | 2          | | 6              | operating_country | FR                             | 2          | +----------------+-------------------+--------------------------------+------------+ 

What I’d like to do is use some of the rows in the above output as fields in a SELECT. I’d like to visualise my data like this:

+------------+------------------+------------------+-------------------+----------+ | company_id | company_name     | contact_email    | operating_country | vertical | +------------+------------------+------------------+-------------------+----------+ | 2          | SomeCompanyName1 | email2@gmail.com | EUR               | 3        | | 1          |                  | email@gmail.com  | MY                | 33       | +------------+------------------+------------------+-------------------+----------+ 

As you can see, I’m using some of the extra_fields as field names. I only need to select a few of these fields as depicted above – I don’t need all of them.

I’m not even sure where to start with this, so any guidance would be appreciated.

VPSFortune – New Resource Pool Added! Sale Prices on select plans, with custom links!

VPSFortune is back with a new offer for the LowEndBox community. They are offering a 2X VPS Pool and 4X VPS Pool at sale prices, out of New York.
We were told that these are custom, exclusive plans created exclusively for LEB, so you won’t find these plans on their website except with the ordering links below.

You can find their ToS/Legal Docs here. They accept PayPal, Amazon Pay, Alipay, Credit Cards, Debit Cards, and Cryptocurrency as available payment methods.
As always, if you do decide to buy one, we’d love to hear about your experience below in the comments section!

Here’s what they had to say: 

“We have built our brand to fill the gap of flexibility in terms of VPS hosting. Since the beginning of VPSFortune, our architecture was designed to deliver high performance but also provide you with the most control and flexibility possible. Our services are reliable in a way that you don’t need to worry about scalability issues.

For us performance and security are the two pillars of reliability. Our maintenance standards have set us apart from other service providers. We also do not just provide VPS hosting – we provide VPS pools using our resource pool control panel. This allows our users to be in charge of where and how they want their resources allocated, and allows for multiple VPS’s to be deployed all under one provider and one bill!

Here are the offers: 

2x VPS Pool Special

  • Create 2 VPS’s! Resource Pool Contains The Following Resources:
  • 2GB RAM
  • 2 CPU Cores
  • 50GB SSD Storage
  • 2TB Monthly Transfer
  • 100Mbps Port
  • 2 IPv4 Address
  • $ 78/yr
  • [ORDER HERE]

4x VPS Pool Special

  • Create 4 VPS’s! Resource Pool Contains The Following Resources:
  • 4GB RAM
  • 4 CPU Cores
  • 60GB SSD Storage
  • 4TB Monthly Transfer
  • 100Mbps Port
  • 4 IPv4 Address
  • $ 120/yr
  • [ORDER HERE]

NETWORK INFO:

New York, USA Datacentre (City of Buffalo)

Test IPv4: 192.3.180.103

Test file: http://192.3.180.103/1000MB.test


VPS Host Node Specificaitons:

– Intel Xeon E3-1240 Series

– 32GB to 64GB RAM

– 4x 2TB Samsung Enterprise SSD’s

– Redundant Power

– 1Gbps Network Uplinks

Please let us know if you have any questions/comments and enjoy!

The post VPSFortune – New Resource Pool Added! Sale Prices on select plans, with custom links! appeared first on Low End Box.

How do I grant a SELECT permission to an individual user who’s part of a large group that is explicitly denied?

I have a table SuperSecretData which is currently setup to deny SELECT to everyone in the company by the standard Active Directory account “Domain Users”. But a couple of specific individual users do need to be able to SELECT from it. What’s the proper way to achieve this?

Table Properties - Permissions

Resaltar Primer registro obtenido de un SELECT (PHP Y MYSQL)

Quisiera resaltar de otro color el primer elemento obtenido de una consulta SQL. los datos los muestro a través de un While y mysqli_fetch_array.

Acá parte del código.

$  rr = $  bd->query("SELECT * FROM moduloscurso where idCurso = $  idCurso ORDER BY idModulo ASC LIMIT $  iniciar,$  regXpagina");   while ($  row = mysqli_fetch_array($  rr, MYSQLI_ASSOC)) {      echo '          <div class="card" style="width: 200px; background-color:#9eedb4;">         <img class="card-img-top" src="'.$  row['moduloimg'].'">         <div class="card-body">         <h6 class="card-title">'.$  row['nombreModulo'].'</h6>         </div>         <ul class="list-group list-group-flush>          <li class="list-group-item" id="countdown"></li>         <li class="list-group-item">             <a class="btn btn-outline-success btn-sm" id="caption"              href="empezarCurso.php?idCurso='.$  row['idCurso'].'&idModulo='.$  row['idModulo'].'">Empezar Módulo             </a>         </li>         </ul>         </div>    '; 

Sólo quiero poner en otro color el background del primer card generado todos los demás no.