Adding Author URL to Nav Menu via Shortcode

I’m looking to add the Author URL to the Nav Menu via a shortcode.

Here’s the shortcode I registered:

add_shortcode( 'author_url', function() {     return get_author_posts_url( get_current_user_id() ); } ); 

After registering the shortcode, I tried using this plugin to add it to the nav menu: https://wordpress.org/plugins/shortcode-in-menus/

However, the shortcode output is https//mysite.local on my localhost

Notice how it’s lacking the ‘:’ after the https.

What’s going on, and how can I fix this?

Thanks!

How to model inheritance in MySQL for adding and deleting users?

I currently have a MySQL database and our ERD has inheritance for various tables. One is User which has as children: administrators, students and professors. The tables look as follow:

CREATE TABLE `Users` (   `id_number` int DEFAULT NULL,   `First_name` varchar(50) DEFAULT NULL,   `Last_name` varchar(50) DEFAULT NULL,   `User_Type` varchar(14) DEFAULT NULL ) ENGINE=InnoDB CREATE TABLE `Advisor` (   `Faculty_id` varchar(2) DEFAULT NULL,   `Student_id` varchar(5) DEFAULT NULL,   `Date_Assigned` date DEFAULT NULL ) ENGINE=InnoDB  CREATE TABLE `Faculty` (   `Faculty_id` varchar(13) DEFAULT NULL,   `Room_id` varchar(2) DEFAULT NULL,   `Faculty_Speciality` varchar(16) DEFAULT NULL,   `Faculty_Rank` int DEFAULT NULL,   `Faculty_Type` varchar(9) DEFAULT NULL,   `user_type` varchar(13) DEFAULT NULL ) ENGINE=InnoDB 

I’m aware that things such as PRIMARY KEY are missing for the ids and REFERENCES for foreign keys. Similar is found on this post How to model inheritance of two tables MySQL. However, what I want to know is when adding users how to populate both tables (parent and children)? Meaning that both tables user and student get the same information? How would this work on data that gets over 3000 students?

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