Hi

Following on from this post Wordpress SQL query help

Each post 'should' have multiple entries (30--50 on average) in wp_postmeta as a result of running the previous  I've now discovered some where the metadata is missing

using the sample data in  the last post how find all the post which have less than 5 ?

In sudo code

select p.`ID`,p.post_title
from wp_posts p, wp_postmeta m 
where p.post_status ='publish' and 
p.`ID`= m,post_id in (select post_id from wp_postmeta where count(m.meta_key) <=5) 

Select all Open in new window

Hi

MY EDUCON blog is looking better, but I'd prefer it if the blog wasn't on the Home page, but on one of the tabs, and the home page was something I could design.
Is that just bad luck. - Not how blogs are done?

Thanks

I am trying to center text on the 3 widgets (3 circles with icons).  But, when I modify the css, it centers text on all pages!  Somehow I am not specifying the correct css to just modify the text in the widgets.  I tried modifying the below at it had no effect.

entry-content {
  text-align:center;}

Select all Open in new window

http://25a.e58.myftpupload.com/

I am considering making training videos which at some point may have a price attached to them. So, I am not keen on hosting these on YouTube.

What options to do have for private hosting?

Is it logical to consider using my WordPress site, where I already have WuCommerce up and running?

What is involved in video posting? Are there various WordPress plugins I cans use that would make this easy?

This is hosted on AWS. How do you calculate the cost of this kind of service for bandwidth?

What if I have 10 views per day and the video is 30 minutes long?

What might that cost for the month?

Thanks

How do I get the three green icons to center over the 3 individual widgets? I tried a bunch of stuff and it just keeps getting worse and worse.

screen shot
https://screencast.com/t/8qNvi4TbzF

beta site
http://25a.e58.myftpupload.com/

Here is what I tried and it didn't work

a.alignnone img, img.alignnone {
  display: block;
    margin: 0 auto;
}

Select all Open in new window

Hi,

Am newbie to wordpress,I need to Attached image in the portofolio page Show Slider in Single page Content using Nice Portofolio plugin.Is Working good category Wise Once Clicked that category Attached images show slider.Please give me solution for my Problem.
I need to use Slider using Jquery.Is it possible to Show Slider using Js inside Nice Portofolio Plugin.

I have a wordpress site (barcelona theme) I cannot edit category layouts. I to change the layout to delete the category and recreate it with the desired layout and reassign the posts.

When I go to edt categories the layout is there but all options are disabled. It makes no sense

I have googled it as wll as I know but have yet to find a solution

I have a select box called mfr colors which has manufacturer colors. Here is my select box with a couple of options but in general there a lot more options.

<select id="tmcp_select_1" class="tmcp-field tm-epo-field tmcp-select tm-valid" name="tmcp_select_0" data-price="" data-rules="" tabindex="1" aria-required="true" aria-invalid="false">
<option value="Custom_0" class="tc-multiple-option tc-select-option" data-imagep="" data-price="" >Custom</option>
<option value="Black Roof Orange Body_1" class="tc-multiple-option tc-select-option" data-imagep="" data-price="" >Black Roof Orange Body</option>
<option value="Red Body White Roof_2" class="tc-multiple-option tc-select-option" data-imagep="" data-price="" >Red Body White Roof</option>
</select>

Select all Open in new window

Now each mfr color has 4 thread colors namely primary, secondary, third and fourth. I have a custom post type called manu-color and each manu color has all the four thread colors. What I am trying to do is display the four colors based on the mfr color selected above from the select box.

here is my code for the custom post type

function pcfa_create_post_type() {
	// set up labels for Colors
		$labels = array(
 		'name' => 'Manufacturer Colors',
    	'singular_name' => 'Manufacturer Color',
    	'add_new' => 'Add New Manufacturer Color',
    	'add_new_item' => 'Add New Manufacturer Color',
    	'edit_item' => 'Edit Manufacturer Color',
    	'new_item' => 'New Manufacturer Color',
    	'all_items' => 'All 

Select all Open in new window

…

Hi
To my long suffering helpers in this - I finally have a theme that is close to what I hoped for (purchase from themeforest.com)
Some guys in Delhi are helping in Freelancer, but I don't want them to charge me for minor changes.
I have the EDUCON WP theme.
Is there a way for me to change the EDUCON title text to my site's name? It isn't a field in the options page?

Thanks

Hi

The Educon WP them seems to be exactly what I need,
but the documentation "how to" aspect of it is unimpressive. Does anyone know where a great manual for this theme might be?

Thanks

Hi

Has anyone had any experience of exporting entire WordPress blog to html files

each post will have it's own folder named from 2 wp_terms entries
I need to grab the wp_terms associated with  the post and create metadata tags
all images and other post links will need to copied into its folder and the links made local

I suspect I'm going to need to write a custom script to do this

Any help with this greatly appreciated especially the  SQL to link the posts to the wp_terms

Thanx

Hi

I downloaded a purchased Educon Wordpress theme from theme forest, and whenever it downloads on Apple OS X, it unzips itself, even if I select, just download the "wordpress-installable file."

I need the installation file to insert as a new WP theme
How do I do this without unzipping?

Thanks

I have a really strange problem…

I am attempting to extend the backend User search to have visibility of custom user meta fields. I have tried two methods: 1) Plugin Better User Search, 2. Code posted by this developer. Both involve pre_user_query.

It seems to work – I can successfully tell the system to also look in specific meta fields.

The problem is, the User list is now only returning two results two page. In fact, the number of results per paginated page seems linked to the number specified in Screen Options above…

– Was 150: only two displayed
– When 200: only two displayed
– When 400: four are displayed
– When 500: four are displayed
– When 600: five are displayed
– When 700: six are displayed
– When 800: six are displayed

I’ve stripped out other functions that could be causing a conflict and isolated this code. I also switched to the WordPress standard theme and deactivated all plugins.

I am running WordPress 4.8.1 on Multisite, and the site in question is not the primary site, but, rather a subsite.