What is the correct interpretation of the Gambling Results table in Xanathar’s Guide to Everything?

In Xanathar’s Guide to Everything, one of the downtime options provided in “Downtime, Revised” allows a character to gamble during their downtime to earn extra money.

Gambling

Games of chance are a way to make a fortune—and perhaps a better way to lose one.

[…]

Gambling Results
\begin{array}{|l|l|} \hline \text{Result} & \text{Value} \ \hline \text{0 Successes} & \text{Lose all the money you bet, and accrue a debt equal to that amount.} \ \hline \text{1 Success} & \text{Lose half the money you bet.} \ \hline \text{2 Successes} & \text{Gain the amount you bet plus half again more.} \ \hline \text{3 Successes} & \text{Gain double the amount you bet.} \ \hline \end{array}

—Xanathar’s Guide to Everything, pg. 130

So if I place a bet of 100gp and make my checks against this table, how much would I have, for each category?

Hint: There is a column named “pma_timestamp” in table “table_a”, but it cannot be referenced from this part of the query

hi i want to use a user defined function so that while inserting values in column i want to insert last_day of the month in one column by referencing other column in same table.

my code is-

insert into table_A (id,pma_timestamp,monthend) values (103,’2017-08-15′,last_day(pma_timestamp));

but getting error. how to resolve this

How do I introduce my co-workers to RPGs via a Virtual Table Top (VTT)?

I am fortunate enough to work at a company that twice a year budgets time and expense so we may have a "team-building" activity. I am on a team of ten people total. There is a stipend to pay for expenses. We’ve gone go-karting one afternoon then out for dinner on the company coin, that kind of thing. Another time we have had lunch at the office followed by an afternoon of table top games like Citadels and there was enthusiasm for that. Currently everyone is working from home in the same timezone, meeting over Slack, Zoom, Microsoft Teams, etc.

Since (a) I am a big fan of tabletop RPGs where the players work together as a team to take down BBEG, and (b) there’s enthusiasm for trying new things, and (c) team building always helps morale, I want to float our next "team building" activity as "I run an afternoon RPG adventure on Roll20.net" as a one-off session; something four hours max.

I have played D&D since 1983. I am quite comfortable as Gamemaster/ DM for six players. I believe I can stretch to nine players for an afternoon. One of my co-workers has also been gaming since the Eighties, knows the concepts very well, and has expressed enthusiasm for the idea. I have not sounded out the rest of my team for their enthusiasm and experience with RPGs; I suspect it is all over the map with at least three novices.

I am looking for specific examples from people who have tried this, such as, "I tried Game Foo and it did not work for reason X," or "I introduced my friends to VTT with Game Bar and the following things worked really well:…"

I’ve used Roll20.net four times with my gaming group. I have the hang of it. I’m not wedded to it, but it seems like it would be a solid fit with some preparation on my part which I’m willing to do. Roll20.net has some good introductory videos.

There’s no negative stigma about Role Playing Games at my employer. I am comfortable enough there that I can float the idea and if my co-workers say "Nope, not at this time," that’d be fine.

I’m flexible as to which game we play. My criteria are:

  1. It’s easy for a novice to pick up the basics
  2. My co-workers work together (no stabbing each other in the back)
  3. My co-workers have fun for the afternoon

My favourite game is Pathfinder 1e; I fear that is WAY too deep for novices, unless I strip it down as suggested here. I don’t want to overwhelm/scare off my co-workers with the PFSRD.

I am familiar with DnD 5e. I don’t have a DnDBeyond account. Since I imagine everyone would need a Roll20.net account to start, I’d rather not require everyone to create two accounts.

I have an idea of how I’d make this work in person: I’d provide nine copies of the Universal Table from TSR’s Marvel Super Heroes, I’d draw a large rough map of the downtown core of our city on the whiteboard, and my co-workers would each pick an Avenger from a set I’ve prepared in advance. Those MSH rules are pretty basic (one table! One!) and I’m sure even those co-workers who have never heard of RPGs have heard of the Marvel movies. Each Avenger would have a token the player could stick to the whiteboard. However, I suspect that super heroes don’t scale into Roll20.net; put another way, my first thought was that it’d be easier on the novice players if they were constrained to the walls of a castle and could not fly.

While I would like to offer my team the choice of game genre, I suspect that with nine people I’d get nine different responses.

I have read this question about introducing kids and this question about introducing novices to Pathfinder 1e in a short session. I believe my question is distinct enough from those two and is not a duplicate.


Match two distinct values from a single column in a joined table

I have three tables:

class: class_id class_name  student: student_id student_name  class_schedule: class_id student_id 

I want to select all the classes where studentA and studentB are in the same class using the student names. I can use a subquery to pull all the classes studentA is in, and then from that subset the classes that studentB is in and that works. That being said, it is terribly inefficient. I have tried a number of solutions including joining the same table twice, once for each value I want to find, but always get an empty result set.

For testing and prototyping purposes I am using sqlite, but will reside on DB2 long term.

Why Are Table Scans Bad?

At my work, I am often told that I shouldn’t do a table scan because it could negatively impact the database and the app using the database. What exactly do they mean by "negatively impact"? One negative impact I can think of is that a table scan would use up a lot of the disk’s time, blocking other requests from using the disk.

Is there a way to do a table scan without any negative impacts? Sometimes I need to do a table scan for one off checks (for routine things, I would of course make an index).

Where can I find experiential-based resources for West Marches/Open Table games?

I’m currently getting ready to run an Open Party/West Marches style game with a pool of about 16 players. We’ll be using 5e, but my question is system-agnostic.

I of course started with Ben Robbins’ "Grand Experiments: West Marches" blog posts (here: http://arsludi.lamemage.com/index.php/78/grand-experiments-west-marches/ ), but after reading those and Justin Alexander’s "Open Table Manifesto" https://thealexandrian.net/wordpress/38643/roleplaying-games/open-table-manifesto I’m having a tough time finding anything else experiential. Pretty much every other resource I find references one of those two to define the playstyle, says they think it’s a neat idea they’d like to try, and stops there.

I can’t say I’m shocked; building a sandbox like this is a lot of work and I don’t know that I’d want to go to the trouble of annotating it for strangers on the internet. It’s almost shocking that it’s happened twice.

That being said, I’m specifically looking for things similar to Ben’s West Marches: Running Your Own http://arsludi.lamemage.com/index.php/94/west-marches-running-your-own/ where a GM who has actually run an Open Party/West March style game for some time gives experience-based advice.

Of highest import is anything that gives insight on managing in-game vs. real-world time with multiple parties.

Reformatting a table to save vertical space

To save vertical space, how can I convert a $ c$ column $ r=kn$ row table to a $ ck$ column $ n$ row table? E.g., a $ 6=3\cdot2$ row $ 3$ column table to a $ 3\cdot3=9$ column $ 2$ row table;

a11 a12 a13 a21 a22 a23 a31 a32 a33 a41 a42 a43 a51 a52 a53 a61 a62 a63 

to

a11 a12 a13 a31 a32 a33 a51 a52 a53 a21 a22 a23 a41 a42 a43 a61 a62 a63 

TIA.

MySQL Query Fetch Time increases when LEFT JOIN with big table

I am fetching the same amount of data with 2 different queries. However, one of them have a fetching time of ~x130 compared to the other. Being the only difference between the two queries a LEFT JOIN with a big table (4M rows).

Especifically, my problem goes like this:
I have table_a with 200K rows. table_b with 100 rows and table_c with 4M rows. The fields involved are indexed. table_a and table_c have a one to many cardinality.

My query looks something like this:

       SELECT           a.id        FROM           table_a a           LEFT JOIN table_b b ON b.id = a.b_id           LEFT JOIN table_c c ON c.id = b.c_id        GROUP BY a.id; 

MySQL Workbench tells me that this query takes ~4s of Duration and 130 seconds of Fetch Time. However, when I remove the second LEFT JOIN with the big table, the query takes <1s of Duration and <1s Fetch Time.

I clearly understand why the query duration is increased. I am doing a kinda heavy left join. But, my question is: Why the fetching time is so much higher, if the fetched data is the same?

I have already increased innodb_buffer_pool_size with no success.

I am working in MySQL 8.0.19, with innodb as tables engine.

Is there something I am missing here? Thanks in advance for the help!

UPDATE:
Removing the GROUP BY also improves the performance <1s of Duration and ~1s Fetch Time

How to massively change authors table capitalized valors?

Good day.

I have a WordPress project from a client which every 256 authors have been inserted with capital valors (ex. JOHN KRAUS, LEONARD MILES, NAOMI DAWSON). Right now my client wants those author valors in normal text (ex. John Kraus, Leonard Miles, Naomi Dawson) but I have no idea how to achieve that.

Can anyone tell me?

Huge thanks in advance.

Warm regards.