Giving a Pearl of Speech to an Owlbear

What happens if you give a pearl of speech to a creature with low intelligence? Say you give a pearl of speech to an owlbear with an intelligence of 2.

The pearl states that:

While absorbed, the pearl grants you the ability to speak and understand a specific language, such as Dwarven or Draconic. Each pearl is created for a specific language, and you can have only one pearl of speech active at a time.

So is the owlbear magically now able to speak and understand languages even though it’s intelligence score is only a 2? Or does the intelligence score override the magic ability of the item?

XMVector3Project is giving offset values when trying to convert world space coordinates to screen space coordinates

I am trying to convert world space coordinates to screen space coordinates for a 2D game so I can work on collisions with the edges of the window.

enter image description here

The code I am using to convert world space coordinates to screen space is below

float centerX = boundingBox.m_center.x; XMVECTORF32 centerVector = { centerX, 0.0f, 0.0f, 0.0f };   Windows::Foundation::Size screenSize = m_deviceResources->GetLogicalSize(); //the matrices are passed in transposed, so reverse it DirectX::XMMATRIX projection = XMMatrixTranspose(XMLoadFloat4x4(&m_projectionMatrix)); DirectX::XMMATRIX view = XMMatrixTranspose(XMLoadFloat4x4(&m_viewMatrix)); worldMatrix = XMMatrixTranspose(worldMatrix);  XMVECTOR centerProjection = XMVector3Project(centerVector, 0.0f, 0.0f, screenSize.Width, screenSize.Height, 0.0f, 1.0f, projection, view, worldMatrix);  float centerScreenSpace = XMVectorGetX(centerProjection);  std::stringstream ss; ss << "CENTER SCREEN SPACE X: " << centerScreenSpace << std::endl; OutputDebugStringA(ss.str().c_str()); 

I have a window width 1262. The object is positioned at (0.0, 0.0, 0.0) and the current screen space X coordinate for this position is 631 which is correct. However, the problem occurs when I move the object towards the edges of the screen.

enter image description here

When I move the object to the left, the current screen space X coordinate for this position is 0.107788 when realistically it should be well above 0 as the center point is still on the screen and nowhere near the edge. The same happens on when moving the object to the right.

The screen size in pixels is correct, but something thinks that the screen has a premature cut-off like in the image below. It seems that the red dotted lines are the edges of the window when they’re not. I can fix this by adding an additional offset but I don’t believe that is the correct way to fix it and would like to know where I’m going wrong.

enter image description here

Does anyone know why the coordinates are incorrect?

Ubuntu 18.04 live USB is not giving an option to reinstall

When I insert USB with Ubuntu installed into my laptop it boots straight into the 5 dots loading screen then it boot into just the background wallpaper image with no option to install Ubuntu 18.04. This is on a new hard drive with nothing else installed, and I cannot get into the BIOS to change the boot priority.

It just boots straight to Ubuntu before I get to the option to get to the BIOS, but not anymore.

enter image description here

Creating/restoring mdf/ldf to non-default file location giving access denied

Default folder is typical C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA. But C: drive on server is almost full.

So, in restoring an 11gb database from another server, I decided to use the L: drive on the same server.

Tried to restore to L:\SQL\Data (a folder I created). Access Denied.

Some quick Googling later, I see that the SQL Server service is started by NT SERVICE\MSSQLSERVER, so I make MSSQLSERVER the owner of the L:\SQL\Data folder and give it full permission to the folder.

Try to restore again. Access Denied.

Hm. Try to create NEW database in same location. Access Denied.

Create new database in default folder, detach, move mdf/ldf to L:\SQL\Data, making sure all folder and file permissions and ownership are set to MSSQLSERVER, then attach using CREATE DATABASE … FOR ATTACH. Database created in read-only mode.

Try to change to read/write mode. Access Denied.

Create a folder datax in C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL and give it appropriate permissions/ownership. Create a new database there. It worked!

Move back one folder and created a folder data in C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER and give it appropriate permissions/ownership. Create a new database there. Access Denied.

Create a folder C:\temp\data and give it appropriate permissions/ownership. Access Denied.

SQL Server service has been restarted. Server has been restarted. Same results.

This last bit with xp_cmsshell might be a bit of a diversion…

So… tried EXEC xp_cmdshell ‘md l:\data’; Message back is: “An error occurred during the execution of xp_cmdshell. A call to ‘CreatePipe’ failed with error code: ‘5’.”

Changed permissions on root of L:, tried again, same result.

EXEC xp_cmdshell ‘dir c:*.*’; Same result.

EXEC xp_cmdshell ‘whoami /all’; Same result.

Anyway, bottom line is, everything I’ve read out here about getting an “access denied” when restoring/creating db is because of folder permissions. But best I can tell, those are correct. I even tried some differences with permissions being inherited versus explicit.

A couple links I’ve come across would indicate that there is no inherent restriction on putting data/log files anywhere I want, i.e., outside the default location.

I haven’t tried changing the service account for the SQL Server service because I don’t have that level of freedom on this server.

Also, this is from SSMS on both local machine and directly on server, and always connected under the context of an administrator on the domain.

Transactional Emails: Plugins giving issue for any var {{ }}

I may be looking for a plugin override to accomplish what I am looking for. For example, in the order_new.html email template there is this variable:

{{var order.getShippingDescription()}} 

The problem is there is a plugin that is causing it to not be split up and just in a giant line. Is there an easy way to break it up by overriding the plugin to split it up or be more specific? I believe it just shoves it into one giant line into the database or something. I have no idea where it puts this data though, so I am wondering how this happens?

I tried doing this with another plugin, but I couldn’t override the block for the email template but was able to override through to the front end of the store through the theme. It’s a bit confusing! It just completely ignored it, so I have a feeling it’s probably a database thing or xml thing or something?

Is this querying the database when it pulls it to render an email or something else? I feel like I’m missing something about it’s functionality.


applescript claims `missing value` with UI element path it is giving me

My applescript is written as follows:

tell application "System Events"      get every static text of UI element 1 of row 1 of table 1 of scroll area 1 of sheet 1 of window "Settings" of application process "NordVPN IKE" end tell 

it yields

{static text “United States #2632” of UI element “United States #2632” of row 1 of table 1 of scroll area 1 of sheet 1 of window “Settings” of application process “NordVPN IKE” of application “System Events”}

so far so good.

With a little copy-paste magic, my applescript now reads:

tell application "System Events"     click static text "United States #2632" of UI element "United States #2632" of row 1 of table 1 of scroll area 1 of sheet 1 of window "Settings" of application process "NordVPN IKE" end tell 

The Result is missing value. It doesn’t say invalid index or anything like that but it doesn’t click on the text. How do I get it to click on the text?