8 – Is the path_alias table queried for all URLs?

I'm trying to generate SEO-optimized URLs for a set of exposed filters. For example:

/analyst-relations/firm?related_firm=5072 would look like

/analyst-relations/firm/forrester

I imagined doing this by adding / updating / deleting this path programmatically to the path_alias table when creating / modifying / deleting the term or the relevant entity. However, I seem to have misunderstood how path_alias works. I managed to add the path /analyst-relations/firm?related_firm=5072 and alias /analyst-relations/firm/forrester, but the exposed filter links always load like the first ones. Is the path_alias table not queried for all URLs? If not, is it possible to somehow “link” this path and this alias to an entity?

EDIT:
I use better exposed filters to expose the filters as links, so afaik there is no form submission

Display the queried publications in a custom publication type and taxonomy loop model

I have two types of personalized messages (& # 39; services & # 39; and & # 39; case_studies & # 39;) one of which (services) is a taxonomy for the other (case_studies) . My goal is to display a list at the bottom of & # 39; single-services.php & # 39; to display / get all messages (case_studies) on which & # 39; this service & # 39; was tagged.

Here's what I've gotten so far:

    'case_studies', 'posts_per_page' => 1, 'orderby' => 'rand', 'tax_query' => array( array( 'taxonomy' => 'services', 'field' => 'id', 'terms' => $qobj->term_id, // 'field' => 'slug', // 'terms' => $qobj->name ) ) ); $random_query = new WP_Query( $args ); // var_dump($random_query); // debugging only if ($random_query->have_posts()) { while ($random_query->have_posts()) { $random_query->the_post(); ?>

post meta – Saving repeated option values ​​when queried in Published, Draft, and All

I have a custom query that has some repeat option values. I have three tabs that query published, draft and all When you are under the Published tab and you save a value, all the values ​​under drafts are removed, and vice versa. I must be able to save the current values ​​entered and keep the others. Below, my current code. No suggestion?

    & # 39; Active & # 39; inactive & # 39; => "Inactive", all "#"; => & # 39; All & # 39;);
// echo & # 39;

& # 39 ;; echo & # 39;& # 39 ;; } $ tab = (! empty ($ _GET (& # 39; tab)))? esc_attr ($ _GET (& # 39; tab)): & # 39; active & # 39 ;; property_status_tabs ($ tab); if (isset ($ _ POST (& # 39; searchProp & # 39;)))) { $ propTitle = $ _POST (& # 39; searchProp & # 39;); } other { $ propTitle = & # 39; } if (isset ($ _ POST (& # 39; searchOwner & # 39;)))) { $ searchOwner = $ _POST (& # 39; searchOwner & # 39;); } other { $ searchOwner = & # 39 ;; } remove_all_filters (& # 39; posts_orderby & # 39;); if ($ tab == & active & # 39; && isset ($ _ POST (& # 39; searchOwner & # 39;)))) { $ args = array ( & # 39; post_type & # 39; => & # 39; properties & # 39 ;, & # 39; posts_per_page & # 39; => -1, & # 39; order & # 39; => & # 39; DESC & # 39; & # 39; orderby & # 39; => & # 39; title & # 39; & # 39; post_status & # 39; => & Quot; publish & quot; & # 39; s & # 39; => $ propTitle, & # 39; tax_query & # 39; => table (// NOTE: table of tables! board ( & # 39; taxonomy & # 39; => & # 39; owners & # 39 ;, & # 39; field & # 39; => & # 39; slug & # 39; & # 39; terms & # 39; => $ searchOwner, & # 39; operartor & # 39; => IN & # 39; ) ) ) } else if ($ tab == & # 39; active) $ args = array ( & # 39; post_type & # 39; => & # 39; properties & # 39 ;, & # 39; posts_per_page & # 39; => -1, & # 39; orderby & # 39; => & # 39; title & # 39; & # 39; order & # 39; => & # 39; DESC & # 39; & # 39; post_status & # 39; => & Quot; publish & quot; & # 39; s & # 39; => $ propTitle, ) } // Inactive search by address if ($ tab == & # 39; inactive && isset ($ _ POST (& # 39; searchProp & # 39;)))) { $ args = array ( & # 39; post_type & # 39; => & # 39; properties & # 39 ;, & # 39; posts_per_page & # 39; => -1, & # 39; orderby & # 39; => & # 39; title & # 39; & # 39; order & # 39; => & # 39; DESC & # 39; & # 39; post_status & # 39; => "Draft", & # 39; s & # 39; => $ propTitle, ) } if ($ tab = inactive && isset ($ _ POST (& # 39; searchOwner & # 39;)))) { $ args = array ( & # 39; post_type & # 39; => & # 39; properties & # 39 ;, & # 39; posts_per_page & # 39; => -1, & # 39; orderby & # 39; => & # 39; title & # 39; & # 39; order & # 39; => & # 39; DESC & # 39; & # 39; post_status & # 39; => "Draft", & # 39; s & # 39; => $ propTitle, & # 39; tax_query & # 39; => table (// NOTE: table of tables! board ( & # 39; taxonomy & # 39; => & # 39; owners & # 39 ;, & # 39; field & # 39; => & # 39; slug & # 39; & # 39; terms & # 39; => $ searchOwner, & # 39; operartor & # 39; => IN & # 39; ) ) ) } else if ($ tab == inactive & # 39;) { $ args = array ( & # 39; post_type & # 39; => & # 39; properties & # 39 ;, & # 39; posts_per_page & # 39; => -1, & # 39; orderby & # 39; => & # 39; title & # 39; & # 39; order & # 39; => & # 39; DESC & # 39; & # 39; post_status & # 39; => "Draft", & # 39; s & # 39; => $ propTitle ) } if ($ tab == & # 39; && isset ($ _ POST (& # 39; searchOwner & # 39;)))) { $ args = array ( & # 39; post_type & # 39; => & # 39; properties & # 39 ;, & # 39; posts_per_page & # 39; => -1, & # 39; orderby & # 39; => & # 39; title & # 39; & # 39; order & # 39; => & # 39; DESC & # 39; & # 39; post_status & # 39; => array ( & # 39; post & # 39 ;, & quot; draft & quot; ) & # 39; s & # 39; => $ propTitle, ) } else if ($ tab == all #) { $ args = array ( & # 39; post_type & # 39; => & # 39; properties & # 39 ;, & # 39; posts_per_page & # 39; => -1, & # 39; orderby & # 39; => & # 39; title & # 39; & # 39; order & # 39; => & # 39; DESC & # 39; & # 39; post_status & # 39; => array ( & # 39; post & # 39 ;, & quot; draft & quot; ) & # 39; s & # 39; => $ propTitle); } if (isset ($ _POST (& # 39; p_status_update & # 39;)))) { $ renewal = $ _POST (& # 39; renewal); $ frent = $ _POST (& # 39; future-rent & # 39;); $ available = $ _POST (& # 39; deposit $ = $ _POST (& # 39; deposit & # 39;); $ lastShowing = $ _POST ('last-throw'); $ status = $ _POST (& # 39; status & # 39;); $ date = $ _POST (& # 39; date); $ initials = $ _POST (initials & # 39;); $ notes = $ _POST (& # 39; notes & # 39;); update_option (& # 39; renewal & # 39 ;, $ renewal); update_option (& # 39; future-rent & # 39 ;, $ frent); update_option (& # 39; available, $ available); update_option (& # 39; deposit & # 39 ;, deposit); update_option (& # 39; last-displayed & # 39 ;, lastShowing); update_option (& # 39; status & # 39 ;, status); update_option (& date, $ date); update_option ('initials', $ initials); update_option (& # 39; notes, $ notes); } ?>

Status:

request); while ($ propQuery-> have_posts ()): $ propQuery-> the_post (); $ PID = $ post-> ID; $ count ++; $ bedrooms = wp_get_post_terms ($ PID, & # 39; bedrooms & # 39 ;, array ("fields" => "all")); foreach ($ rooms as $ room) { $ bedSlug = $ room-> slug; } if ($ bedSlug! = "individual lease") { $ bedStripped = preg_replace (& # 39; / (^ 0-9) / & # 39;; & # 39;; $ bedSlug); }other{ $ bedStripped = 1 & # 39 ;; } $ unitrent = wp_get_post_terms ($ post-> ID, & # 39; rent & # 39 ;, array ("fields" => "all")); foreach ($ unit as $ rent) { Rent price = $ rent-> name; $ rentprice Slug = $ rent-> slug; } $ dateAvailable = get_cfc_field (& # 39; propertysettings & # 39 ;, date-available & # 39;); ?> <? php waiting; wp_reset_postdata (); echo & # 39;
Total: & # 39; $ Account. & # 39;
& # 39 ;; ?>
Beds Address Renewal Future rent availability date Deposit Last posting Status Date initials Remarks
<a href = ""target =" _ blank "> <select name = "renewal () "id =" renewal () "> <option value = "0" > Choose <option value = "No" > No <option value = "Yes" > Yes <! - <textarea name = "future-rent () "id =" future-rent () ">-> <type of entry = "text" value deactivated = ""/> <! - <textarea name = "available () "id =" available () ">-> <type of entry = "text" value deactivated = ""/> <! - <textarea name = "deposit () "id =" deposit () ">-> <type of entry = "text" value deactivated = ""/> <textarea name = "last-show () "id =" last-showing () "> <select name = "status () "id =" status () "> <option value = "0" > - <option value = "nf" > Fees required <option value = "bgi" > BGI <option value = "fa" > Final approval <option value = "a" > Approved <option value = "nd" > Need to deposit <option value = "dp" > Deposit paid <option value = "ats" > Appt to Sign <option value = "rnl" > Renew the lease <option value = "ls" > Signed lease $ PID, & post_status & # 39; => & # 39; draft & # 39;)); } } ?> <textarea name = "date () "id =" date () "> <textarea name = "initials () "id =" initials () "> <textarea name = "notes () "id =" notes () ">

security – How to secure my queried data from my local MySQL server on a remote machine with a shared root with an untrusted entity?

I have a remote client computer placed in a server center belonging to an entity that must also own the root of the client computer in accordance with industry regulations. The client machine runs a C ++ program that uses libmysqlclient.so and periodically polls a MySQL server in my office via the Internet.

Because the data is extremely sensitive, I need to protect this data from disclosure during the data transfer process. Nobody is trusted in the host, including its owner who owns the root of the client machine.

At first, the JSON The format of the C ++ program configuration database contains an explicit IP address, port, user, and password. Anyone with the root can read them and use them to connect to our server from the client machine. As the IP address and the port must be disclosed to the host owner who manages the intranet, gateway and firewall in accordance with the regulations, I replace the user and the password by encrypted strings in the configuration and the C ++ program will decrypt them at startup to get the desired result. real user and password to connect to the server.

However, the root user can replace libmysqlclient.so in the system with a modified version so that the user and the password are printed when establishing a connection. Then I change the C ++ program to static link to libmysqlclient.a at the time of compilation.

However, the transferred data is still in the clear. I'm therefore activating SSL on the MySQL server and modifying the user as REQUIRE SSL. So, the attack by the middle man is not supposed to be easy.

For SSL to work, I also need to put ca, client-cert, and client-key files on the client machine. I am wondering if the host owner can capture the encrypted traffic transferred and use these files to decrypt the data without knowing the user name and password of the database.

In addition, is there an obvious vulnerability on the client side after all these configurations? Suppose the network structure and the use of MySQL are not changed.