jelenacvijic

<p>Looking for the <strong>easiest way to manage your data</strong>?<br />
We are here to help. 😉</p>
<p>Black-Desk is a comprehensive WordPress plugin that helps you <strong>create and manage custom database tables and data</strong> directly from your WordPress dashboard.</p>
<p>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.</p>
<p>Save queries and reuse them quickly.</p>
<p>Black-Desk plugin <strong>shortcodes</strong> let you display selected data on your WordPress pages or posts, as well as easily create input forms directly connected to your tables.</p>
<p><strong>Key Features:</strong></p>
<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>
<p>After installation, look for the <strong>‘Tables’</strong> menu item in your WordPress dashboard/admin panel.</p>
<h4>Creating Tables</h4>
<ol>
<li>Go to <em>Tables</em> > <strong>Add Table</strong></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>
<p>Available Column Types:</p>
<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 <em>Tables</em> > <strong>All Tables</strong></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 <em>Tables</em> > <em>All Queries</em> > <strong>Select</strong></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>
<p>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).</p>
<p><strong>Example</strong> of such query condition:<br />
[<code>review.product_id</code>] [equal to] [FIELD] [<code>product.id</code>]</p>
<h4>View Query Results</h4>
<ol>
<li>Go to <em>Tables</em> > <strong>All Queries</strong></li>
<li>View specific query</li>
</ol>
<h4>Deleting Data</h4>
<p>There are three options for deleting data:</p>
<ol>
<li>Deleting rows while viewing a table, one by one or in bulk; soft delete, <strong>reversible</strong></li>
<li>Truncate – delete all data in a table; <strong>irreversible</strong></li>
<li>Delete the whole table; <strong>irreversible</strong></li>
</ol>
<h4>Shortcodes</h4>
<p>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:</p>
<ul>
<li>Display data from your tables directly on your page or post;</li>
<li>Create custom data entry <strong>forms</strong> to store user input directly into your data tables.</li>
</ul>
<p>Using shortcodes, you can easily:</p>
<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 <strong>for each</strong> row of your table or query result – <code>[bdds-view-repeat]</code></li>
<li>Create an input form using shortcodes:<br />
- <code>[bdds-form-start]</code> – to start a form<br />
- <code>[bdds-form-field]</code> – to add form field<br />
- <code>[bdds-form-stop]</code> – to end a form</li>
</ul>
<p><strong>Detailed shortcodes usage instructions</strong> are provided in dashboard > <em>Tables</em> > <strong>Shortcodes</strong>.</p>


Black-Desk

WordPress plugin for easier data management.

_ck_

<p>Caches multiple users automatically on post and comment pages to radically reduce mysql queries for plugins that get_userdata.<br />
If you find that your query count has become excessive (25+) on your post or comment pages, this plugin may help.<br />
Tested up to WordPress 3.2 (might be compatibile with newer versions). Feedback requested.</p>
<h3>License</h3>
<ul>
<li>CC-GNU-GPL http://creativecommons.org/licenses/GPL/2.0/</li>
</ul>
<h3>Donate</h3>
<ul>
<li>http://bbshowcase.org/donate/</li>
</ul>


WP Cache Users

Caches multiple users automatically on post and comment pages to radically reduce mysql queries for plugins that get_userdata.

Black-Desk vs WP Cache Users