jelenacvijic

Looking for the easiest way to manage your data? 
We are here to help. 😉
Black-Desk is a comprehensive WordPress plugin that helps you create and manage custom database tables and data directly from your WordPress dashboard.
The plugin provides an intuitive interface that lets you create, update, and query your data in the simplest way possible, without requiring deep technical knowledge.
Save queries and reuse them quickly.
Black-Desk plugin shortcodes let you display selected data on your WordPress pages or posts, as well as easily create input forms directly connected to your tables.
Key Features:
<ul>
<li>Create custom tables with various column types</li>
<li>Manage table data with an easy-to-use interface</li>
<li>View and edit table data</li>
<li>Create and save custom queries, including joins (across multiple related tables)</li>
<li>Soft delete support with trash management</li>
<li>Shortcodes for data display</li>
<li>Shortcodes for input form generation</li>
</ul>
<h3>Usage</h3>
After installation, look for the ‘Tables’ menu item in your WordPress dashboard/admin panel.
<h4>Creating Tables</h4>
<ol>
<li>Go to Tables > Add Table</li>
<li>Enter table name and description</li>
<li>Add columns with their respective names, types and properties</li>
<li>Preview and save your table structure</li>
</ol>
Available Column Types:
<ul>
<li>Short text – varchar(255)</li>
<li>Number – int(11)</li>
<li>Big number – bigint(20)</li>
<li>Currency – decimal(15,2)</li>
<li>Date time – datetime</li>
<li>Yes no – bit(1)</li>
<li>Lookup – varchar(100)</li>
<li>Rich text – mediumtext</li>
<li>Long text – longtext</li>
<li>Attachment – longblob</li>
<li>Hyperlink – varchar(1024)</li>
<li>ENUM – ENUM (your list of options)</li>
</ul>
<h4>Managing Data</h4>
<ol>
<li>Navigate to Tables > All Tables</li>
<li>Click on a table to view/edit its data or its structure</li>
<li>Add, edit, or delete records (edit by clicking the field itself)</li>
<li>Use bulk actions for multiple records</li>
<li>Restore deleted records from trash</li>
<li>Display data in your WordPress page or post using shortcodes</li>
</ol>
<h4>Creating Queries</h4>
<ol>
<li>Go to Tables > All Queries > Select</li>
<li>Choose tables and fields to include</li>
<li>Add conditions and aliases</li>
<li>Preview and save your query</li>
<li>Display the query results in your WordPress page or post using shortcodes</li>
</ol>
If you want to view data from related, joined tables you can create and save a query by setting one of its conditions so that the value from the first table column is equal to the second table column/field (effectively indicating a foreign key column and pointing it to another table’s primary key).
Example of such query condition: 
[<code>review.product_id</code>] [equal to] [FIELD] [<code>product.id</code>]
<h4>View Query Results</h4>
<ol>
<li>Go to Tables > All Queries</li>
<li>View specific query</li>
</ol>
<h4>Deleting Data</h4>
There are three options for deleting data:
<ol>
<li>Deleting rows while viewing a table, one by one or in bulk; soft delete, reversible</li>
<li>Truncate – delete all data in a table; irreversible</li>
<li>Delete the whole table; irreversible</li>
</ol>
<h4>Shortcodes</h4>
Shortcodes are a powerful feature of Black-Desk that let you seamlessly connect your data tables to any of your WordPress pages or posts, in one of the two directions:
<ul>
<li>Display data from your tables directly on your page or post;</li>
<li>Create custom data entry forms to store user input directly into your data tables.</li>
</ul>
Using shortcodes, you can easily:
<ul>
<li>Display data from your table or query result – <code>[bdds-view-table]</code></li>
<li>Display specific field – <code>[bdds-view-field]</code></li>
<li>Display specific field data for each row of your table or query result – <code>[bdds-view-repeat]</code></li>
<li>Create an input form using shortcodes: 
- <code>[bdds-form-start]</code> – to start a form 
- <code>[bdds-form-field]</code> – to add form field 
- <code>[bdds-form-stop]</code> – to end a form</li>
</ul>
Detailed shortcodes usage instructions are provided in dashboard > Tables > Shortcodes.

Black-Desk

WordPress plugin for easier data management.

Silkalns

WP Chill

Brian Fegter

Chris Dillon

Razvan Aldea

For admins, developers, and support staff, Debug This provides a ton of information about your WordPress installation, all from the front-end admin bar.
<ul>
<li>The current WP_Query object</li>
<li>Blog info and options</li>
<li>Embed providers</li>
<li>Files in rendered HTML (CSS, images, JavaScript)</li>
<li>Filters and actions</li>
<li>Images sizes</li>
<li>Globals and constants</li>
<li>Menus</li>
<li>Object cache stats</li>
<li>Plugins, must-use plugins, and dropins</li>
<li>Rewrite rules</li>
<li>Queries</li>
<li>PHP and server information</li>
<li>Post attachments</li>
<li>Post types</li>
<li>Scripts and styles enqueued</li>
<li>Shortcodes</li>
<li>Sidebars and widgets</li>
<li>Taxonomies and terms</li>
<li>Themes</li>
<li>Users</li>
<li>WP cron schedules and jobs</li>
<li>WP debug log</li>
</ul>
Debug This helps you save time and effort when trying to figure out what’s going on. Instead of hardcoding debug snippets or writing complex unit 
tests for small functionality, you can simply bring to the surface what you need right from the admin bar.
For example, when viewing a single post, you can see:
<ul>
<li>a list of post attachments,</li>
<li>which menus and sidebars are being displayed,</li>
<li>the post type, post fields, and meta data,</li>
<li>the current query variables and query string,</li>
<li>the rewrite rules applied,</li>
<li>the author,</li>
<li>the terms,</li>
<li>and much more.</li>
</ul>
<h3>Extend</h3>
<h4>Debug This Functions</h4>
New debug modes can be created easily:
<pre><code>add_debug_extension(
 $mode,
 $menu_label,
 $description,
 $callback,
 $group = 'General'
);
</code></pre>
Example
<pre><code>add_debug_extension(
 'actions',
 __('Actions', 'debug-this'),
 __('$wp_actions contains all active registered actions', 'debug-this'),
 'foo_callback',
 'Filters And Actions'
);
function foo_callback($buffer, $template){
 global $wp_actions;
 $debug = print_r($wp_actions, true);
 return $debug;
}
</code></pre>
You can add links to the header of a debug mode page. Place this code within your debug callback function.
<pre><code>add_debug_header_link('http://urltolink', 'Link Label');
</code></pre>
Extensions can be removed as well using <code>remove_debug_extension($mode);</code>
No PRE Tags
If you don’t want your debug output to be enclosed in PRE tags, simply set the following in your extension:
<pre><code>Debug_This::$no_pre = true;
</code></pre>
Saved Queries and Execution Time
Retrieve saved queries and execution time by using the following static properties:
<ul>
<li><code>Debug_This::$execution_time</code></li>
<li><code>Debug_This::$queries</code> – SAVEQUERIES must defined as true</li>
</ul>
URL Helpers
<ul>
<li><code>Debug_This::get_current_debug_url()</code> – current URL with the debug query</li>
<li><code>Debug_This::get_escape_url()</code> – used for the debug escape link that links to original page URL</li>
</ul>
<h4>WP Actions</h4>
<ul>
<li><code>debug_this</code> – receives the $mode arg – outputs the debug code sent from the extension modes. The default action is set to priority 5. This allows you to prepend or append any output without conflict using less or greater priorities.</li>
</ul>
<h4>WP Filters</h4>
There are a few filters you can use to customize Debug This to your needs:
<ul>
<li><code>debug_this_template</code> – receives $template arg – Use your own template</li>
<li><code>debug_this_default_mode</code> – receives $mode arg – Alters the mode for the parent DT admin bar button link.</li>
<li><code>debug_this_output</code> – receives $output, $mode args – Filter debug content before it’s rendered</li>
</ul>
<h4>JavaScript</h4>
To access the built-in Debug This JS functionality, enqueue your custom script with the dependency set to <code>debug-this</code>. Your script will inherit a jQuery dependency.
Object: debugThis
<ul>
<li><code>debugThis.mode</code> – current mode</li>
<li><code>debugThis.defaultMode</code></li>
<li><code>debugThis.template</code> – current included template</li>
<li><code>debugThis.queryVar</code> – the defined query string variable</li>
</ul>
Functions:
<ul>
<li><code>isDebug()</code></li>
<li><code>getDebugMode()</code> – uses <code>isDebug()</code></li>
</ul>
Events:
A jQuery <code>debug-this</code> event is fired from the footer. You can hook into this event with the following;
<pre><code>jQuery(document).bind('debug-this', function(event, debugThis){
 console.log(debugThis);
});
</code></pre>
<h4>Helper Functions</h4>
There are three included functions to help you work with files.
<ul>
<li><code>debug_this_get_file_ownership($file)</code> – returns <code>array('name' => $name, 'group' => $group)</code></li>
<li><code>debug_this_get_file_perms($file)</code> – returns string – Example: 0775</li>
<li><code>debug_this_convert_perms_to_rwx($perms)</code> – returns string – converts permission number to RWX format – Example: 0755 folder becomes drwxr-xr-x</li>
</ul>

Debug This

Very nice, even the phpinfo() colors are displayed correctly.

Great plugin

Peek under the hood with sixty debugging reports just one click away.

Black-Desk vs Debug This