WordPress Database Schema

While working on Nulis and while attempting to solve some other problems I began to need to document the contents of wordpress databases. The first problem I sought to solve was to build a visual map of the site. This needs the schema to be understood and the table contents to be extracted. This needs the login parameters and a connection route. The second problem involves creating a new template and will need it’s SQL designed and encapsulated in PHP. Continue reading “WordPress Database Schema”

Testing Interactive World Map

Hmm, there is only one map per dashboard, that’s not so good and it seems based on the Risk Map. It doesn’t seem as flexible as I hoped. It’s called Interactive World Map and is available as a plugin here. The plugin comes from a company Fla-shop and is  an on-ramp to chargeable content. Their sales and marketing page for wordpress is here. It works quite nicely as a sales portal entry point, but doesn’t do what I need.

div2 div5 div6 div3 div7 div4

I question whether this is functional enough to genuinely act as a try-before-buy. It’s a good looking widget though. Haven’t quite got it working on wptouch.

There’s probably the opportunity to rehash the jokes about US political geography, particularly over the widget’s treatment of the Russian Federation and maybe even Turkey.

I wonder if the HTML usermap feature would work with this.

In August 2015, the vendor upgraded the plugin, significantly. The map above is the new one.

Featured images in wordpress

My current theme for the blog is not so good when the included text is not as deep as the featured picture. While not having a featured picture is OK for a screen based reader, it’s not so good for those using the wptouch interface. Maybe it’s not so good for deep pictures either.

A google search brings up the codex and these two, similarly named links, together with the codex pages,

With zbench the image and entry text are contained in a single <DIV> with a class name of “entry”. The text is contained in a <P> tag. The image class is “attachment-extra-featured-image wp-post-image”.

  1. Would it look better within a table? This would need to be developed in index & archive pages
  2. Should I use the thumbnail feature?
  3. Can I use the CSS? NB The <P> does not have a class name.

The deep pictures would be solved by by the thumbnail features.

Maybe I should consider the HTML recognition within the excerpt functions.

ooOOOoo

Also the facebook feed does not use the featured picture, but finds the first picture within the post, maybe even the post page since it often uses the up arrow on the vote this up widget.

Rendering RSS on my blog or wiki

I have today installed JP’s Get RSS Feed, a wordpress plugin. I shall be using this to replace my delicious linkrolls using the delicious rss location. See also my snip on Delicious Linkrolls.

It requires a shortcode/codesnip to invoke it’s parameters e.g

 
[jp-rss-feed 
    url="http://feeds.del.icio.us/v2/rss/davelevy/convoyswharf" 
    numitems="7" getdesc="50" ] 

I should document this differently, but the snip must be on one line, and no space between the [ & the ‘jp’.

There’s a few more parameters which are documented on their home page

Another widgit

and now we have another RSS rendering widget

This was found to be broken on 17th October 2016.

Bar chart archive widget for wordpress

A friend showed me the blog at http://tatiyants.com/ which has an awesome archive widget. I want one. Fortunately Alex has documented how to build one, in an article called “How to create a bar chart archive widget in wordpress“.

wp-barchart-2

This leaves me with how to install a widget, a quick google, takes me to here, “How to create a custom wordpress widget”.

While looking for this I also found, this at 3do labs, which points at the collapsing archives plugin.

 

Related Posts Plugin

I have been using the Related Posts plugin. I just took an update, and it rewrote the parameters, the default is to have two copies of related posts inserted because the default is to have “Auto Insert Related Posts (or add <?php wp_related_posts()?> to your single post template)” set to yes.

I have also selected the Modern theme, with Display thumbnails off.