Was I right to leave my rp group after feeling like my player agency was violated?

Everyone. I was apart of a discord RP group but I recently left after this incident. To give some background. I was being repeatedly belittled OOC by other members and was being made to walk on egg shells around everyone. I was already Abit on edge the whole time I had been apart of this group which was for around six months. So this event starts and we find this group of nineteen children who had survived a horrific attack. They end up being affected by some unknown disease so we are all in quarantine with them.

This whole time my Character gravitates to this one little girl and makes sure to dote on her. Several of the children including her are confirmed to be orphans. My character is in her 30’s and I thought I would be given the chance to adopt her. Well the GM barely rped as her because they could not handle dealing with multiple players and scenes very well. They give us permission to just npc the children to an extent because they can’t keep up. So I am just writting scene after scene the whole time of cuteness. I am ignored by most the players and the GM even when I try to interact with others but I just play it off and try not to let it bother me.

So after the event ends the GM announces that the particular little girl I was taking care of was adopted by another player who hadn’t even met her. Needless to say I was very livid. I ended up leaving because I felt like no one was taking me into consideration or even allowing me to really interact with the events. Two players reached out to me to try and get me to come back even though in there own words the mods were "Cold hearted." I didn’t talk to the GMs about it because I was so mad and hurt to be stepped on like that, nor did they ever try to reach out to me. Am I just being childish here or am I in the right?

What is the right way to add PHP code to a certain part of a page

I know I can add PHP to the functions file. And I know I can make a plugin.

I basically need to make a calculator of sorts and send the values to an email signup.

What is the best way to achieve this. I think a plugin, but then how would I position the plugin at a place on an already existing page?

Sorry if this is a noob question, I really want to understand the correct way to achieve this before starting.

Does the distinction between left and right hand matter when making an off-hand attack? [duplicate]

Clara the Fighter finds herself facing a huge undead, the Frost Giant Skeleton. She attacks twice with her scimitar, and again with her light hammer! The undead reels back as it takes bludgeoning damage, which it is vulnerable to!
On her next turn, can Clara make the Attack Action using her light hammer instead of her scimitar without switching hands?
Here’s the breakdown (assuming all attacks hit):

Turn 1
Action: Attack (scimitar, right hand) = 2 x (1d6 + Str) slashing
Bonus: Off-hand attack (light hammer, left hand) = 1d4 bludgeoning, x2 because of vunlerability

Turn 2
Action: Attack (light hammer, left hand) = 2 x (1d4 + Str) bludgeoning, x2 because of vulnerability
Bonus: Off-hand attack (scimitar, right hand) = 1d6 slashing

Is the above allowed?

Is the DM Always Right?

I recently got into a disagreement with my DM for a DND 5E game regarding a use of Prestidigitation.

The argument was that since it could create a Non-Magical Trinket, and Music Boxes are specifically listed in the Trinket section of the book, I should be able to make one, even if it is only temporary.

Her argument was that a music box did not fall under her definition of a trinket.

I’ve asked about the D&D 5e rules for that situation already, but now I’m asking whether the DM has the authority to change that rule in our game if she wants.

Evaluate the limit of a subsequence: Compute the limit $ \lim_{n\to\infty} \cos\left( \pi \sqrt{4n^2 + 5n + 1} \right) $ Integer $n$ on Mathematica

I want to compute the limit $ $ \lim \limits_{n\to\infty} \cos\left( \pi \sqrt{4n^2 + 5n + 1} \right) $ $ for integer $ n$ . By completing the square, we can determine that this limit is equal to $ – \tfrac1{\sqrt2} \approx -0.7071 $ .

But if we don’t restrict $ n$ to an integer, then the limit is indeterminate / does not exist. And can be easily found by typing it on WolframAlpha. Or in Mathematica:

However, I do not know how to compute the limit (on Mathematica) with the original constraint that $ n$ must be an integer.

I know that we can plot a graph on Mathematica:

But what is the exact value of the limit?

The graph suggests that the limit is equal to $ -\tfrac1{\sqrt2} $ . However, this doesn’t look like a convincing result because we can’t know that the limit is exactly equal to $ -\tfrac1{\sqrt2} $ .

Question: Is there a way to compute this limit in Mathematica where it spits out a single numerical value (of $ -1/{\sqrt2}$ )?

Is my Burning Ears spell the right level?

I have designed this spell:

Burning Ears

8th level divination

Casting Time: 1 minute

Range: Self

Components: S M (an earwig or a hollowed out animal horn)

Duration: 1 hour, concentration

Classes: Bard, Wizard, Warlock, Sorcerer

For the next hour, you listen very closely for the sound of your name. If any creature on the same plane as you uses your name to refer to you, you are able to eavesdrop on their conversation. For one minute, you can hear what takes place as if your ears are in the room. If another creature on the same plane as you uses your name to refer to you within the hour, you can choose to turn your attention to that one, or continue listening to the current one.

I currently have it listed as 8th level. Is this appropriate? On one hand, there is no save, and no way to detect that it is happening. It has no limit on how far the spell reaches. However on the other hand, it only lets you hear, not see, it can be blocked by Nondetection, and if your enemies find out you use this spell, they can simply stop using your name to refer to you.

Some changes I am considering:

  • Duration: 8 hours concentration instead of 1 hour
  • Duration of eavesdropping 5 minutes instead of 1 minute
  • Text that specifies that you feel momentary sharp pain in your ears when you key in. Maybe it could even deal 1 psychic damage?
  • An invisible ear-shaped sensor that could be detected

How can I get better at identifying the “right time” to use my spell slots?

I’ve played a bunch of DnD 5e, but my current campaign is my first time playing a Warlock outside of a one-shot; right now I’m almost to level 5. I’m playing more of a face/roleplay-focused role, so my invocations (Aspect of the Moon and Devil’s Sight) are generally more useful out of combat, but I made sure to take several combat-oriented cantrips, as well as shatter, to have at least one good damage-focused spell.

In general, I’m having a lot of fun, but I’m having some trouble getting used to having only two spell slots to play with beyond the very early levels.

A couple of sessions ago, I eagerly fired off both my spell slots at what looked like pretty juicy targets. I did plenty of damage… but when enemy reinforcements showed up, I was out of ammo – and in hindsight, I would have had even better targets to use my spells on if I had kept them in reserve.

In response, the next session, I resolved to try to keep a shorter leash on my spells. I played through a combat encounter trying to keep my spell slots in reserve, but I felt like limiting myself to cantrips, weapon attacks, and "utility actions" like shoving kept me from pulling my weight. I then felt silly for being so cautious when we decided to take a short rest at the end of the encounter anyway. I felt especially silly when the same entire story repeated itself later in the session.

Of course, I can (and do) encourage my party to take short rests when we have the opportunity to do so (as long as people could use the HP and it’s not just because I’m out of spell slots), but in general I feel like I’m doing a poor job of identifying the "right" times to pull from my limited resource pool.

Of course, this problem isn’t limited to Warlock – every spellcasting class has to make these judgment calls – but with such a low number of slots to work with, playing Warlock is definitely testing my resource management. I recognize that adeptly managing my limited spell slots is just part of the game, but is there anything in particular I can do that would help to pick out the best times to bust out a spell?

SQL: CASE WHEN having AVG() as condition not giving right output

I have a table of unique users that each has a "rating" column (it’s an average rating they give out of all their ratings given in a different table of reviews). I want to add another column to my table, which specifies either them giving a rating that is above the average of all ratings of all users (hence I use the AVG() function), below or at average (I call it "bias"). In other words, I want to see whether each user gives on average higher or lower ratings than the total average. I understand the limitedness of this query, and ideally I would include an interval (i.e. within 0.5 points below or above average still counts as average) but I can’t seem to make even the simplest query work.

I’ve been using the Yelp dataset from a Coursera course, but I tried to create a sample that produces the same result that I do not want – just one row. I want to have this categorization for each row, hence it should return 3 rows in this example, "below average" in the first two and "above average" in the third. However, the code below produces just one row. I have been working with R and this seems like I am using incorrect syntax, but after 30 minutes of searching the web I cannot find a solution.

I am working in and want to use SQLite syntax as part of the course in Coursera

CREATE TABLE test      (      id integer primary key,       rating integer     );  INSERT INTO test (id, rating) VALUES (1, 1);  INSERT INTO test (id, rating) VALUES (2, 3);  INSERT INTO test (id, rating) VALUES (3, 8);  SELECT id, rating,   CASE     WHEN rating > AVG(rating) THEN "above average"     WHEN rating < AVG(rating) THEN "below average"     ELSE "no bias"    END AS "bias" FROM test 

How to make multiple right joins in one single command for different child tables?

On the followin image you see 3 tables: A, B , C. A: Is the table that holds the foreign keys from B and C

enter image description here

enter image description here

If I do a right join between A and B on that foreign key, it works, meaning I get the data from column fooB. Same between A and C with fooC.

But If I put both right joins under the same command it fails with null

+-------------+---------------+ | fooB        | fooC          | +-------------+---------------+ | NULL        | abc           | | NULL        | xyz           | 

*This is slightly different as the image with the commands posted below, as this comes straight from the real deployment, however cmds below still show that both columns do not show up.

I’ve tried mixin up left joins, right joins , outer joins all with same result. I have googled about this, but the way my question is formulated is awkard and the hits I get return the traditional right joins for just one table.

How do I get this to work in one command? CMDS Below:

enter image description here

Same commands as above but in text, as comments are asking for text rather than images:

MariaDB [joinPOC]> select fooB from tableA right join tableB on tableB_idtableB=tableB.idtableB; +------+ | fooB | +------+ | b1   | | b2   | | b3   | +------+ 3 rows in set (0.001 sec)  MariaDB [joinPOC]> select fooC from tableA right join tableC on tableC_idtableC=tableC.idtableC; +------+ | fooC | +------+ | c1   | | c2   | | c3   | +------+ 3 rows in set (0.001 sec)  MariaDB [joinPOC]> select fooB from tableA right join tableB on tableB_idtableB=tableB.idtableB right join tableC on tableC_idtableC=tableC.idtableC; +------+ | fooB | +------+ | b1   | | b2   | | b3   | +------+ 


-- MySQL Workbench Forward Engineering  SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';  -- ----------------------------------------------------- -- Schema joinPOC -- ----------------------------------------------------- DROP SCHEMA IF EXISTS `joinPOC` ;  -- ----------------------------------------------------- -- Schema joinPOC -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `joinPOC` ; USE `joinPOC` ;  -- ----------------------------------------------------- -- Table `joinPOC`.`tableB` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `joinPOC`.`tableB` (   `idtableB` INT NOT NULL,   `fooB` VARCHAR(10) NOT NULL,   PRIMARY KEY (`idtableB`)) ENGINE = InnoDB;   -- ----------------------------------------------------- -- Table `joinPOC`.`tableC` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `joinPOC`.`tableC` (   `idtableC` INT NOT NULL,   `fooC` VARCHAR(10) NOT NULL,   PRIMARY KEY (`idtableC`)) ENGINE = InnoDB;   -- ----------------------------------------------------- -- Table `joinPOC`.`tableA` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `joinPOC`.`tableA` (   `idtableA` INT NOT NULL,   `fooA` VARCHAR(10) NOT NULL,   `tableB_idtableB` INT NOT NULL,   `tableC_idtableC` INT NOT NULL,   PRIMARY KEY (`idtableA`),   INDEX `fk_tableA_tableB_idx` (`tableB_idtableB` ASC),   INDEX `fk_tableA_tableC1_idx` (`tableC_idtableC` ASC),   CONSTRAINT `fk_tableA_tableB`     FOREIGN KEY (`tableB_idtableB`)     REFERENCES `joinPOC`.`tableB` (`idtableB`)     ON DELETE NO ACTION     ON UPDATE NO ACTION,   CONSTRAINT `fk_tableA_tableC1`     FOREIGN KEY (`tableC_idtableC`)     REFERENCES `joinPOC`.`tableC` (`idtableC`)     ON DELETE NO ACTION     ON UPDATE NO ACTION) ENGINE = InnoDB;   SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;  -- ----------------------------------------------------- -- Data for table `joinPOC`.`tableB` -- ----------------------------------------------------- START TRANSACTION; USE `joinPOC`; INSERT INTO `joinPOC`.`tableB` (`idtableB`, `fooB`) VALUES (1, 'b1'); INSERT INTO `joinPOC`.`tableB` (`idtableB`, `fooB`) VALUES (2, 'b2'); INSERT INTO `joinPOC`.`tableB` (`idtableB`, `fooB`) VALUES (3, 'b3');  COMMIT;   -- ----------------------------------------------------- -- Data for table `joinPOC`.`tableC` -- ----------------------------------------------------- START TRANSACTION; USE `joinPOC`; INSERT INTO `joinPOC`.`tableC` (`idtableC`, `fooC`) VALUES (1, 'c1'); INSERT INTO `joinPOC`.`tableC` (`idtableC`, `fooC`) VALUES (2, 'c2'); INSERT INTO `joinPOC`.`tableC` (`idtableC`, `fooC`) VALUES (3, 'c3');  COMMIT;   -- ----------------------------------------------------- -- Data for table `joinPOC`.`tableA` -- ----------------------------------------------------- START TRANSACTION; USE `joinPOC`; INSERT INTO `joinPOC`.`tableA` (`idtableA`, `fooA`, `tableB_idtableB`, `tableC_idtableC`) VALUES (1, 'a1', 1, 1); INSERT INTO `joinPOC`.`tableA` (`idtableA`, `fooA`, `tableB_idtableB`, `tableC_idtableC`) VALUES (2, 'a2', 2, 2); INSERT INTO `joinPOC`.`tableA` (`idtableA`, `fooA`, `tableB_idtableB`, `tableC_idtableC`) VALUES (3, 'a3', 3, 3);  COMMIT; 

Desired output in a single command:

+-------------+---------------+ | fooB        | fooC          | +-------------+---------------+ | b1          | c1            | | b2          | c2            |