MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?

Usingthe following shortcode function, I have the code building a table by querying the DB. That all works fine. BUT when I add any type of formatting to the TimeStamp column such as DATE_FORMAT or TIME the output for that column only goes blank. No errors are in the console to look at. I am trying to extract only the time and put it in a 12 hour format instead of the typical TIMESTAMP format of date and time in the 24hr set up.

Is there a conflict with some of the PHP that causes it not to display the timestamp?

 function test2() {         global $  wpdb;     $  results = $  wpdb->get_results("SELECT `name`, `partysize`, `phonenumber`, `emailaddress`, DATE_FORMAT(`Time_stamp`, '%h %i' ), `Wait`, `currentstatus` FROM mytablename m RIGHT JOIN (SELECT wdt_ID, CONCAT(ROUND(Time_to_sec(TIMEDIFF (NOW() ,`Time_stamp`))/60,0), ' Min') AS Wait FROM mytablename) as t on m.wdt_ID = t.wdt_ID WHERE Time_stamp >= date_sub(now(),interval 3 hour)  ");          if(!empty($  results))         {             echo "<table width='100%' border='0' style='display:inline-table'>             <th>Name</th>             <th>Party Size</th>             <th>Phone Number</th>             <th>Email Address</th>             <th>Time Stamp</th>             <th>Status</th>             <th>Wait</th>             <th>Action</th>     ";             echo "<tbody>";                   foreach($  results as $  row){                  echo "<tr>";                 //echo "<td>" . $  row->wdt_ID . "</td>";                 echo "<td>" . $  row->name . "</td>";                 echo "<td>" . $  row->partysize . "</td>";                 echo "<td>" . $  row->phonenumber . "</td>";                 echo "<td>" . $  row->emailaddress . "</td>";                 echo "<td>" . $  row->Time_stamp . "</td>";                 echo "<td id='tdid_".$  row->wdt_ID."'>" . $  row->currentstatus . "</td>";                 echo "<td>" . $  row->Wait . "</td>";                 echo '<td> <a href="javascript:void(0)" class="button seated-btn" onclick="seatclick('.$  row->wdt_ID.')" data-id="'.$  row->wdt_ID.'"></a></td>';                 echo "</tr>";             }             echo "</tbody>";             echo "</table>";          }     }     add_shortcode('test2', 'test2'); 

How much security would s3bubble using AWS DRM Protected Video streaming actually be adding?

As the title says, how much security would s3bubble using AWS DRM Protected Video streaming actually be adding?

I watched s3bubble’s tutorial at https://www.youtube.com/watch?v=bC-tZhlYH8o but I cannot really tell how much safer this makes things. My target audience would be software engineers so assume reasonable technical capability, although the field is not security. Considering the video will still actually play in the browser, how hard is it really to still grab it anyway even if direct download urls will be encrypted. I am not quite getting how this security is applied. Surely they could just reverse engineer the player?

Note simple screen capturing is out of scope.

Just adding basic token by POST parameter for securing the API. It is safe?

Let’s say I have an address for an API like this:

mywebsite.com/api/mydata 

If accessed, a JSON will appear like this:

[   {     "id":"1",     "name":"John"   },   {     "id":"2",     "name":"Smith"   } ] 

The result defaults will be displaying the entire data if a post has no parameters. If you use post "ID" and the ID parameter value is one of the existing data in the API, it will only display objects from the data selected based on the ID. The API can be accessed by anyone. API needs to be accessed using token parameters to secure the data.

Let’s say I add a token parameter to be able to access data like this:

yourtoken="yourtoken"  if (post_param[token]==yourtoken) {   // Displaying JSON } 

so if you want to open the API, you need to add a token parameter.

Is simple security like this worth using? what vulnerabilities will arise if I use this? is there a better way than this?

Adding Google Ad scripts in someone else’s website? [closed]

Recently I got to know about Google Ads and how to earn money by putting Google ads on a website.

I have lots of clients and I have access to their sites. What if I put Google Ads scripts on their websites and earn money from the traffic they got on their websites?

For example, I put a Google Ad script into 10 websites, and after one month, I get some revenue from their sites by traffic without letting them knowing that there is Google Ads in their site.

Might any change if they get to know there is Google Ads script in their site? Maximum chances will be that they remove that script. Is there any chances of serious problems or not?

Adding Ads Under Menu Items (WordPress Site)

Hi All
I hope this is the correct spot to get help for my issue.
I have a wordpress website, and want to add my google text ads directly under my Menu items.
https://growingchillies.net/

I'm not the most experienced with wordpress theme customisation but am hoping someone can quickly explain where i need to modify my theme/css to insert some text adds.

Note, ads to appear directly under Menu Items (Home, Chilli Seeds, Chilli Readers Reports, etc)

What are the security implications of adding an Intermediate Certificate into the Trusted Root Store in Windows?

I have 2 certificates (one root and one intermediate).

In Windows OS, the Root certificate is in the trusted root store (for current user). The other intermediate certificate (signed by the root CA), is to be found (under current user also) under the Intermediate CA store.

I am using SSL verification in one of my client applications (Kafka Confluent) and realized the client only enumerates certificates in the root store. Therefore SSL handshake fails (the intermediate CA is needed).

One solution is to import that certificate into the Trusted Root Certificate Authorities. With that solution, SSL verification at client works. However, is there any concern in doing so?

From security point of view does it make a difference if the intermediate CA exists in the Root store vs the Intermediate store on Windows?

UPDATE If more context is needed as to what exactly I am facing you can check the issue here https://github.com/edenhill/librdkafka/issues/3025

Is a creature’s Innate Spellcasting save DC affected by changing ability scores or adding Spellcasting features from another creature?

I’m creating a Svirfneblin Evil Mage by combining the stat blocks for each Evil Mage and Svirfneblin.

A Svirfneblin’s Innate Spellcasting Save DC is 11 and its INT is +1. An Evil Mage’s Spellcasting Save DC is 13 and its INT is +3.

I’m taking the abilities from Evil Mage and Svirfneblin and taking the higher ability scores (and modifiers), does the increased INT modifier from the Evil Mage’s score affect the Innate Spellcasting spell save DC?

Does adding multiple skills when combining creatures cause balance issues?

I’m creating a Svirfneblin Evil Mage by combining the stat blocks for each Evil Mage and Svirfneblin.

A Svirfneblin has the skills Investigation +3, Perception +2, Stealth +4. An Evil Mage has the skills Arcana +5, History +5 and saving throw proficiencies INT +5, WIS +3.

Does having 5 skills and 2 saving throw proficiencies cause major balance issues?