## Does mysql “order by” guarantees to give the same order for the same query every time if the sort key is equal?

I’m planning to write a query that sorts the result by a value `s` and then paginate the result. Let’s say I have ten items that match the query and all the items have the same `s`. In the first query, I sort the value by `s` and get the first five items. Then in the next query, I sort the value by `s` and get the sixth to tenth items. Is it possible that the items that appear on my first query will appear again in my second query, and that some items will not show up in either query?

## Is there a resource anywhere that lists every spell and the classes that can use them?

There are now a number of resources that provide lists of spells, the PHB, Tashas Cauldron, XGTE etc. As well as spells that are included in specific adventure or campaign books.

There are also new classes that come with new spell rules, artificer is one.

Is there a single resource anywhere that lists all the spells currently published for 5th edition, the classes they can be used by and the level? I am not looking for the spell rules just an updated list as per the PHB that includes every published spell by class.

Or a list that lists out every spell and the classes that can use them.

## Godot / GDscript label text not updating every frame like intended

I am very new to Godot and coding in general, so I apologize in advance for any simple mistakes. I am trying to have my text display the variable "ammodisplay" on my object "Marine." When I launch the game, the text sets to 7 (the correct value) but as I play the game and the variable changes, the text does not update with it. Any insight as to how I can fix this? Thanks in advance!

``extends Label  var NODE = load("Marine.tscn") var ammo = NODE.instance() var ammod = ammo.ammodisplay   func _process(delta):     text = (str(ammod)) $$```$$ ``

## Does Hexblade’s Curse extra damage affect every die rolled? [duplicate]

The relevant part of Hexblade’s Curse states (XGtE p.55):

Starting at 1st level, you gain the ability to place a baleful curse on someone. As a bonus action, choose one creature you can see within 30 feet of you. The target is cursed for 1 minute. The curse ends early if the target dies, you die, or you are incapacitated. Until the curse ends, you gain the following benefits:

• You gain a bonus to damage rolls against the cursed target. The bonus equals your proficiency bonus.
• […]

Typically when features add extra damage they clarify that the extra damage only applies to one damage roll, or the added damage just applies to the damage as a whole, like the various cleric subclasses’ Potent Spellcasting:

Starting at 8th level, you add your wisdom modifier to the damage you deal with any cleric cantrip.

Or the Evocation Wizard’s Empowered Evocation (PHB p.117):

…you can add your Intelligence modifier to one damage roll of any wizard evocation spell you cast.

Does this mean the wording of the Hexblade’s Curse would apply to all of the dice rolled for the attack? If when the warlock gains Pact of the Blade at 3rd level, could they pick a great sword as there pact weapon, which deals 2d6 damage, and add their proficiency bonus twice to the damage?

## Casting Guidance cantrip for every roll?

What prevents a cleric from casting the Guidance spell every single turn and having everyone have 1D4 extra for their rolls, especially since you can combo it with this:

It seems like every skill check should always be made with advantage due to the 'Working Together' rules. Is this accurate?

This can end with almost all the checks being a D20+1D4 plus advantage. Seems a bit broken mechanic without some houseruling that prevents the same spell on the same target for some time, or I am missing some rule that prevents this?

The same would affect Resistance, but since you probably are in the middle of a combat, the Touch range could prevent it effectively, but for normal skill rolls where the touch of the cleric is possible and the situation is not stressing?

## When you learn True Polymorph, do you learn about every creature in existence?

When a wizard learns true polymorph, do they also learn about every creature in existence? Since the spell says the new form can be a creature of any kind you choose, it seems to me that this would mean they must have gained some knowledge about every creature in existence.

Or can you only turn into creatures that you have encountered "in your lifetime"?

## What are the consequences of giving an ASI or feat every 4 character levels instead of every 4 class levels?

I’m trying to figure out why Dungeons & Dragons 5th edition designers decided that ASI or feats would be given every 4 class levels and not every 4 character levels.

If I allowed my players to get an ASI or feat at character levels 4, 8, 12, 16 and 19, how would the game balance be concretely impacted? How could the players abuse this?

The peculiarities of some classes such as the fighter and the rogue would be kept: a rogue would still gain an ASI at rogue level 10 and a fighter at fighter levels 6 and 14.

## how to display count of total posts and for every category and having possibility to filter between dates and user

Hello i use simple plugin that count numbers of posts for every category and total but i was stuck in how to display count of posts between to dates and with authors.

``<div class="wrap posts-and-users-stats">      <nav class="nav-tab-wrapper">         <?php echo "<h2> Nombres des articles </h2>" ?>      </nav>      <section>         <?php     \$  categories = get_categories( array(     'orderby' => 'name',     'order'   => 'ASC' ) );           <table id="table-<?php echo esc_attr(\$  taxonomy); ?>" class="wp-list-table widefat">                         <tbody>                 <?php foreach (\$  categories as \$  category) { ?>                     <tr>                         <td><?php echo esc_html(\$  category->name ); ?></td>                         <td class="number"><?php echo esc_html(\$  category->count); ?></td>                     <?php } ?>                     </tr>             </tbody>                  </table>     </section>   </div> ``

this the code i used for filter

``<form method="post">             From : <input type="date" name="from">             To : <input type="date" name="to">             User :<?php wp_dropdown_users(\$  args); ?>             Catégories :<?php wp_dropdown_categories(\$  args); ?>             <input type="submit" name="submitbtn">         </form>     <?php          \$  from = \$  _POST['from'];     \$  to = \$  _POST['to'];     \$  user = \$  _POST['user'];     \$  category = \$  _POST['categories'];     print "From" . \$  from . "\n";     print "To" . \$  to . "\n";     print "User" . \$  user . "\n"; ``

## Does Ocular spell make every eligible damage spells have a critical chance since it becomes a ranged touch attack (ray)?

Ocular spell states:

(…)When you release an ocular spell, its effect changes to a ray with a range of up to 60 feet. If the spell previously would have affected multiple creatures, it now affects only the creature struck by the ray. You must succeed on a ranged touch attack to strike your target with an ocular spell, and the target is still permitted any saving throw allowed by the spell.(…)

Every spell that has a touch attack (melee/range) Do have a critical hit chance (20X2)

So If I was to release an Ocular Fireball (only affects 1 creature now and it still gets the Reflex Half saving throw though). It could indeed be a critical hit.

Correct?

### Sidenote:

I know fireball might not be the best spell for this combination, it was just for the sake of the question.