Is there any information on what Bloodroot Grove was before the events of this AL module?

I was looking over the Adventurer’s League module, DDAL09-08 – In the Garden of Evil (Season 9, Descent into Avernus). This adventure concerns a location in Avernus (the first layer of the Nine Hells) called Bloodroot Grove, and the evil unicorn Zhalruban who has been corrupted by the grove.

What I can’t understand is what such a grove was doing in Avernus in the first place. My impression of Avernus is that it’s a blasted wasteland, not somewhere where you would expect to find a grove.

Apparently, it is in some way related to Silvanus, the god of nature:

Clearly Silvanus didn’t decide to put it in Avernus, so how did it get here? Was it “lifted” from somewhere else (such as the Material Plane or the Feywild*), similar to how the town Elturel was taken into Avernus from the Material Plane (from the main adventure)?

* The grove might have once been in the Feywild, since there’s this quote (even though it only explicitly refers to one tree):

I assume it has been corrupted simply because it has been on Avernus for so long, since Silvanus wouldn’t have created it as a corrupted grove initially, so something must have corrupted it, and being on Avernus fits as the cause of the corruption, but that further suggests my theory that it wasn’t located in Avernus to begin with.

Is there any more information whatsoever about Bloodroot Grove and how it came to be on Avernus?

Extended events filter not working

If I remove the filter, I get results, including ones that should match the filter.

The user is a SQL Login.

This query returns nothing:

CREATE EVENT SESSION [p] ON SERVER ADD EVENT sqlserver.rpc_starting(   ACTION(package0.event_sequence,sqlserver.nt_username,sqlserver.server_principal_name,sqlserver.session_id,sqlserver.username)     WHERE ([package0].[equal_boolean]([sqlserver].[is_system],(0)))     AND (([sqlserver].[server_principal_name]=N'MySQLUserName'))), ADD EVENT sqlserver.sql_batch_starting(     ACTION(package0.event_sequence,sqlserver.nt_username,sqlserver.server_principal_name,sqlserver.session_id,sqlserver.username)     WHERE ([package0].[equal_boolean]([sqlserver].[is_system],(0)))     AND (([sqlserver].[server_principal_name]=N'MySQLUserName'))) ADD TARGET package0.ring_buffer WITH (MAX_MEMORY=8192 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=5 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=PER_CPU,TRACK_CAUSALITY=ON,STARTUP_STATE=OFF) GO 

This query returns results that should have been in the original results:

CREATE EVENT SESSION [p] ON SERVER ADD EVENT sqlserver.rpc_starting(     ACTION(package0.event_sequence,sqlserver.nt_username,sqlserver.server_principal_name,sqlserver.session_id,sqlserver.username)     WHERE ([package0].[equal_boolean]([sqlserver].[is_system],(0)))), ADD EVENT sqlserver.sql_batch_starting(     ACTION(package0.event_sequence,sqlserver.nt_username,sqlserver.server_principal_name,sqlserver.session_id,sqlserver.username)     WHERE ([package0].[equal_boolean]([sqlserver].[is_system],(0)))) ADD TARGET package0.ring_buffer WITH (MAX_MEMORY=8192 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=5 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=PER_CPU,TRACK_CAUSALITY=ON,STARTUP_STATE=OFF) GO 

How can I display selected events in the Top Events category screen for Google Analytics?

I am trying to filter several events of my event list. I am trying to do it via a segmentation, but it does’t work. What is the correct way to do this?

Predicting the outcome of sporting events with multiplicative scoring

In the Olympic format for sport climbing, eight athletes compete in three rounds of climbing. Their final score is the multiplication of their rankings in each round. For example, an athlete who comes 1st in the first round, 5th in the second round, and 7th in the third will have a final score of $$1\times5\times7=35$$. The athletes with the lowest final score wins.

Assuming that the competition is already partly underway (possibly even mid-round), is there a computer algorithm to quickly compute the probabilities $$P_{ar}$$ of each athlete $$a$$ achieving a final ranking $$r$$, assuming the performance of the athletes is entirely random from here on? Even with 8 athletes the brute force method seems too computationally intensive.

If this isn’t computationally possible in a reasonable time, is there an algorithm to get “close enough” to those probabilities?

On what date do the events of the Lost Mine of Phandelver adventure happen?

I bought the D&D 5e Starter Set a few weeks ago, and I’m beginning to think about how to drive the scenario as I’ve already read it and I’m at the stage to get familiar with the rules.

Yesterday I created my first character sheet with one of my future players (we’re not going to use pre-generated sheets) and we talked about his character’s lore and background – he will be playing a nobleman, a prince).

I thought that there could be a king in Neverwinter (the closest bigger city to the location of the adventure) , so we could link his background to the scenario. Again, his character would be the son of a king, who, after finishing his Paladin training, wants to go an on an adventure to gain experience and prove his value and that he is adequately trained to potentially govern one day.

However, when I searched for Neverwinter lore, I found out that while there were indeed kings, they didn’t exist towards the end of the timeline.

Given that, I tried to find out at which date the events of LMOP take place, but I didn’t manage to find it anywhere in the books.

So, based on already existing modules or deductions based on facts in existing modules, when do the events of LMOP take place?

If the date is deducted instead of directly stated somewhere, you have to support your answer with official sources, not just a more or less educated guess. The better the answer is supported by sources, the better.

How to map interaction events to game actions

When I port between Desktop games and Mobile games, I find I always make a kludge out of the interaction events.

I typically end up hard-coding event handling for mobile, and event handling for the desktop in completely separate systems.

On mobile, I need to track multiple touches.

On desktop, I only have a single mouse pointer.

But on desktop, there is a concept of “hovering” above something with a mouse. There is no such thing on mobile. Or pressing a modifier key like SHIFT or CTRL while clicking a button or pressing a key.

I want to design an API that I can use on both mobile and desktop that is able to translate an interaction (by user) to an action in my game world.

Are there any design patterns that I can follow, or some abstract model I can use for this? How do people successfully marry the desktop and mobile port of a game?

So in the same code-base, maybe assign Alt+Left-Click to a certain game function, but on mobile have that done via a gesture.

On Desktop, I currently use SDL2’s SDL_Event. On Apple, is use UIEvent, and on Android I use NDK’s AInputEvent.

SQL Server Extended Events purging

How do we purge events older than a day in Extended Events in SQL Server 2012. Stopping and Starting the session is not helping. Target : asynchronous_file_target Trying to create a job which will perform this operation daily.

Custom Permalink Structure for The Events Calendar

I am trying, programmatically, to alter the permalink structure of events created by The Events Calendar plugin. I already have other posts and pages set-up and don’t want to change the permalink settings.

So the plugin currently creates events with structure:

mysite.com/event/some_event_name 

The current site (non-WordPress) currently uses:

mysite.com/events/event_year/some_event_name 

I would like to keep that structure. I have code that creates a permalink, or at least partly:

function my_custom_rewrite() {     global $wp_rewrite;$  wp_rewrite->add_permastruct('tribe_events', '/events/%year%/%name%/', false);     $wp_rewrite->flush_rules(); } add_action('init', 'my_custom_rewrite'); function my_custom_permalinks($  permalink, $post ) { if ($  post->post_type == 'tribe_events') {          $meta = get_post_meta($  post->ID);         $newDate = date("Y", strtotime($  meta['_EventStartDate'][0] ));         return str_replace( array('%year%','%name%'), array($newDate,$  post->post_name), $permalink ); } return$  permalink; } add_filter( 'post_type_link', 'my_custom_permalinks', 10, 2 ); 

I know it is not perfect.

mysite.com/event/some_event_name now redirects to mysite.com/events/event_year/some_event_name. Perfect but mysite.com/events/event_year/some_event_name shows 404. I have tried a number of hooks, pre_post, etc… but can’t seem to get WordPress to show the event on the new URL. Can anyone point me to the correct hooks to use to finish this/get it working?

Thanks.

I am creating a calendar for our EAP to enter when a significant event occurs involving an employee/s. And they want to be able to set reminders to check in with that employee at different intervals, say in 3 days, 2 weeks, 1 month etc. from when the event happened.

The OOTB recurrence setting in the calendar events doesn’t allow for picking random dates, which would work fine if anyone can enlighten me as to how to do that. And I can’t seem to find anywhere that shows how to create reminders that aren’t at regular intervals or that happen after an event took place not before it.

Event listing, filtering events with search

I’m working on UI for an event listing website. I have a dilemma. I want to include filters, without making the user think they have to use the search bar.

I curently have something like this

1. Event listing when search is not being used:

2. Event listing when search is being used

Anyways, the problem is this:

When the user visits the site – the “Today” filter is set as default. There is no “All events” filter button available to the user (too many events to list).

However, when the user uses search – the “All events” filter appears and becomes active.

My logic is – if the user uses search – he is most likely interested in all the instances of the keyword (let’s say the user searches for a band – he most likely wants to know WHEN are they playing and less likely to answer if they are playing “today”).

1. The problem is, would the user get confused because of the sudden apperiance of the “All events filter”.

2. The second problem is: if the user is interested in “this month”. So he changes from “all events” to “this month”, and then wants to search for something else – should the search jump again on “all events” or stay on “this month”.