As far as Spell Components are concerned, what do “retrieve”, “manipulate” and “stow” mean?

From Core Rulebook (p. 303):

Focus: A focus is an object that funnels the magical energy of the spell. The spell gains the manipulate trait and requires you to either have a free hand to retrieve the focus listed in the spell or already be holding the focus in your hand. As part of Casting the Spell, you retrieve the focus (if necessary), manipulate it, and can stow it again if you so choose.

And from Compoment Substitution section, on the same page:

If you’re a cleric Casting a Spell from the divine tradition while holding a divine focus (such as a religious symbol or text), you can replace any material component the spell requires by using the divine focus as a focus component instead. Unlike the normal rules for a focus component, you can’t retrieve or stow the focus when making this substitution.

I am having trouble understanding why the “retrieve”, “manipulate” and “stow” verbs are mentioned separately and what do they mean in this specific context. Also, why is it explicitly mentioned that you can’t do those things (“retrieve” and “stow”) if you are a cleric and you use your holy symbol as substitution? Does this somehow affect you, your religious symbol, your spell or anything else?

Could anyone provide some clarification or point me to a related page from the rulebook?

Can Drawmij’s Instant Summons retrieve a lost Leomund’s Secret Chest?

Suppose that I cast leomund’s secret chest and then bind the chest itself with drawmij’s instant summons. I’ll then send it into the Ethereal Plane, and while it’s hidden, I’ll end the spell effect.

Leomund’s secret chest says that this will cause the chest to be irretrievably lost.

Finally, the question is, if I crush the sapphire after all of this, will I be able to get the chest back? Drawmij’s instant summons says the item appears in my hand regardless of physical or planar distances.

Retrieve images from parent site to child site using current shortcodes

I have a WordPress network setup, with a parent site and a few other child sites within it. I have a custom plugin that saves content (images & posts) to a list for each user on my parent site. I also have a custom admin menu that reveals the image list via a user dropdown on my main site. I have shortcode on my parent site that reveals a user’s favorite image list by user_id.

What I’m trying to accomplish is to change the code of this custom plugin so that the lists appear on the child site/subsite via the shortcode used on the parent site. I imagine that the site_id needs to be passed through this shortcode to make it possible. I also have the custom admin menu on my subsite with the user dropdown, however, the images do not appear when I click to see those favorites.

Now I’ll preface this and say I’m not an experienced programmer but my research leads me to believe that I need to modify the code that controls the menu so it can pull the content (i.e. Media library images/attachments/attachment URLs for that post ID) from the main site to the subsites and add a shortcode and function that makes the parameter for site_id possible.

Does anyone know what query/code/function that I would use retrieve this content from the main site to the subsite so that the image lists would appear in a shortcode form and within my admin menu?

I’ve already tried plugins that allow you to sync the Media Library but they don’t work for what I’m trying to accomplishs

If you need examples of what is already established, such as current codes, shortcodes and images, I’d be happy to oblige.

Use SELECT query to retrieve UPDATE information

I am confused about inability of using UPDATE query inside SELECT queries. I got this idea, it would be amazing to use queries like follows for elegant reporting purposes

My non-working code:

SELECT (     UPDATE animals SET status=1 WHERE status=5 ) as 'total_changed_animals', (     UPDATE sports SET status=1 WHERE status=4 ) as 'total_changed_sports'; 

Problem:

In MySQL’s query docs there is written following:

UPDATE returns the number of rows that were actually changed.

That being said, in example above I would expect UPDATE subquery to return number of changed records into SELECT query. However this does not work, and query example mentioned avove will fail.

Can anyone explain why it is not allowed? I believe there may be a reason for this. Is there any workaround?

What kind of local information are desktop applications capable to retrieve (and use) from my computer?

I’d like to explain my question with an example.

I’ve already seen, on Windows, what kind of information the Steam application is sending online: time, place and device of the connection, time passed playing the games, payments, mail, numbers, etc. All this data looks related to the use of that precise application.

However, what is preventing my desktop app to just send any personal file – stored in my computer – to an online server? From my newbie point of view, once you installed an application, there could be a script which just reads all my files and sends them to the servers.

Let’s suppose Steam (but, again, it could be any app) wants to see the time in which I log in into my pc or the range of time I spend connected to the internet. What prevents my apps to just read all the logs locally stored in my pc?

I think you get the point. Thanks for reading.

Retrieve Images Not Working Via REST API

I am trying to retrieve Images using the REST API from iOS/Android.

The issue I’m running into is when the images are stored in the /sites/siteName directory, the REST call does not work. Let me explain further:

My REST call: //tenant/_api/web/GetFileByServerRelativeUrl('/sites/siteName/PublishingImages/image.jpg')/$ value

  • That call does not work. I get a Microsoft.SharePoint.SPException – The file /sites/siteName/PublishingImages/image.jpg does not exist.
  • The file does indeed exist because inside the web browser I can view the image using: //tenant.com/sites/siteName/PublishingImages/image.jpg

The REST call that does work is:

  • //tenant.com/_api/web/GetFileByServerRelativeUrl

    ('/News/PublishingImages/image.jpg')/$ value

    • That returns the image as expected.

I’m not a SharePoint developer so my knowledge is very light. But, I’m confused to as why those calls do not work.

Any help is very appreciated.

Thanks

Retrieve background color in ubuntu mate

I am using Ubuntu mate 18.04.3 LTS.

I am quite fond of my background color and would like to use it on another machine. Where can I find the exact color that is used? When I go into the Control center and get the Appearance Preferences window, and then the Background tab, I see my color, but when I click on my background color next to Color: Solid color, I get a color selector that is positioned on a red color, while I want a blue color, so that is not the current one.