Count on multiple columns sql

If you are looking to create a clear and organized editing environment to work in, then Admin Columns Pro is for you. Running a WordPress site means you are constantly dealing with large amounts of content, whether this is blog posts, pages, or other post types. This can become difficult to manage and edit easily. Admin Columns Pro will display powerful columns that allow you to quickly sort, filter and edit content. This will help save you time, keep your content well organized, and enable you to effortlessly access important information. In this Admin Columns Pro review, we will discuss the features and functionalities that this WordPress plugin offers. We will then look at how to get the plugin up and running, and how to use some of its most important tools. Admin Columns Pro Features Admin Columns Pro is a feature-rich plugin that is quick and easy to set up, and will ultimately improve your WordPress admin experience. You can choose from over 160+ columns, catering … [Read more...] about How to Manage WordPress Content with Admin Columns Pro

Learn More

A lot of sites are being hit by a recent SQL attack where codes are being injected to your site. This MySQL injection affects your permalinks by making them ineffective. As a result, your blog posts URLs will not work. Numerous WordPress blogs were targetted in this attack, Thanks to Andy Soward for bringing this to our attention. There was one of the following codes that were added to your permalink structure due to this attack: %&({${eval(base64_decode($_SERVER[HTTP_REFERER]))}}|.+)&% “/%&(%7B$%7Beval(base64_decode($_SERVER%5BHTTP_EXECCODE%5D))%7D%7D|.+)&% These quotes appended all permalinks on your site and it can only be changed if removed manually. To fix this go to: Settings > Permalinks and remove the above code and replace your default code . Next thing you need to do is go to Users. You will see that there are more than one administrator. You won’t see their name listed, but you will see the count increased. So what you need to do is … [Read more...] about WordPress SQL Injection – Latest Attack

Learn More

Managing a WordPress site with lots of content or multiple authors means more tasks for admins to perform. Admins of growing WordPress sites are always looking for tools and plugins to improve their editorial workflow . A lot of the tasks that needs to be performed can be done quicker if you can see all the useful information on one screen. That’s when admin columns come in. In this article, we will show you how to add and customize admin columns in WordPress. By default, WordPress only shows a few built-in columns. Codepress Admin Columns plugin will give you many additional columns. You will have full control over all columns for pages, posts, custom post types, media, links, comments and users. First thing you need to do is install and activate Codepress Admin Columns plugin. After activation, go to Settings » Admin Columns to configure admin columns. You can customize admin columns by simply using the drag and drop interface to arrange items in the order you … [Read more...] about How to Add and Customize Admin Columns in WordPress

Learn More

Do you want to display WordPress photos in columns and rows? By default WordPress adds images in a vertical column on top of each other. However if you are adding multiple photos to a blog post, then this doesn’t look very clean and requires a lot of scrolling for your users. In this article, we will show you how to easily display WordPress photos in columns and rows. Why You Need WordPress Photos in Columns and Rows By default, when you add multiple images to a WordPress post, they would appear right next to each other or on top of each other. This doesn’t look very good, and your users will have to scroll a lot to view multiple images and photos. You can easily solve this problem by displaying photos in rows and columns using a grid-based layout. This way images will appear in a compact layout and improve user experience on your website. Having said that, let’s take a look at how to display WordPress photos in columns and rows. 1. Display Photos in Columns and … [Read more...] about How to Display WordPress Photos in Columns and Rows

Learn More

Sometimes there are more than one WordPress installation is necessary, but your host might have limited MySQL Database allowance. Well the solution to that problem is having multiple WordPress installation in one database. You must install WordPress manually in order for this to work. Most one click programs like Fantastic would not let you choose the prefix. During the installation in your config.php phase, you want to change the prefix “wp_” in order to allow multiple installation. So it can be wpchris_ and the next one can be wpben_ you can use different prefix and use them to create as many installation as you need. That is all you really need to do. This is also a security measure that you can take even if you don’t have to install multiple installation. By having a prefix, you are making the hacker work more to find out what is the SQL Address before he can hack. … [Read more...] about Multiple WordPress Installation Using a Single Database

Learn More