vrutika

DB Table Viewer is a simple plugin that allows administrators to: 
– Select any table in the WordPress database. 
– View its data in a clean, paginated HTML table. 
– Navigate through rows using AJAX-based pagination.
This plugin is particularly useful for debugging or managing custom database tables without using SQL queries directly.
<h3>Features</h3>
<ul>
<li>Dropdown to select from available database tables.</li>
<li>Displays table data in a well-formatted HTML table.</li>
<li>AJAX-based pagination for seamless navigation.</li>
<li>Secure implementation with proper sanitization and validation.</li>
<li>Fully translation-ready.</li>
</ul>
<h3>Usage</h3>
<ol>
<li>Go to Tools > DB Table Viewer in the WordPress admin dashboard.</li>
<li>Select a database table from the dropdown menu.</li>
<li>View the table’s data with pagination.</li>
</ol>
<h3>License</h3>
This plugin is licensed under the GPLv2 or later. See the <a href="https://www.gnu.org/licenses/gpl-2.0.html" rel="nofollow ugc">GNU General Public License</a> for details.
Enjoy using DB Table Viewer? Feel free to provide feedback or contribute to its development!

DB Table Viewer

A WordPress plugin to display database table data with pagination in a user-friendly format.

Francesco Martini

After installing this plugin, you will be able to upload various ebook formats as normal media files and to display them on your site using a shortcode.
Every ebook uploaded on your site will have an “ebook slug” (by default it will be the ebook name) that you can view and edit in the Edit Media page of the Admin Panel.
The full source code of the plugin is hosted on <a href="https://github.com/wrCisco/simple-ebook-viewer-for-wp" rel="nofollow ugc">GitHub</a>.
Supported formats 
At the moment, the plugin will let you upload and display the following file types, provided that they are DRM-free:
<ul>
<li>epub</li>
<li>mobi</li>
<li>azw</li>
<li>azw3</li>
<li>fb2</li>
<li>fbz</li>
<li>cbz</li>
</ul>
Usage 
Insert the shortcode <code>[simebv_viewer book="MY_EBOOK_SLUG_HERE"]</code> in any one of your posts.
Styling 
You can add css styles and classes for the viewer container by adding these attributes to the shortcode:
<ul>
<li><code>height</code></li>
<li><code>width</code></li>
<li><code>max-height</code></li>
<li><code>max-width</code></li>
<li><code>border</code></li>
<li><code>style</code></li>
<li><code>class</code></li>
</ul>
Height, width, max-height, max-width and border accept any valid CSS value for those properties. 
Style and class accept any valid value for the respective HTML attributes.
Some examples:
<pre><code>[simebv_viewer book="MY_EBOOK_SLUG_HERE" style="height:30em;border:2px inset black"]

[simebv_viewer book="MY_EBOOK_SLUG_HERE" max-height="100vh" height="40em"]

[simebv_viewer book="MY_EBOOK_SLUG_HERE" class="my-container-class my-container-second-class"]
</code></pre>
Settings
The users of your site will be able to set their preferences about the appearance of the ebook in the Viewer by opening the Viewer menu (the cog icon on the top right) and by selecting the appropriate entries.
The plugin sets some reasonable defaults for these preferences, but if you’re not happy with those defaults, you can change them by adding one or more of the following attributes to the shortcode, with the appropriate values:
<ul>
<li><code>layout</code>
<ul>
<li>accepted values: “paginated” or “scrolled” (default: paginated)</li>
</ul>
</li>
<li><code>max-pages</code>
<ul>
<li>accepted values: 1, 2, 3 or 4 (default: 2)</li>
</ul>
</li>
<li><code>default-font-size</code>
<ul>
<li>accepted values: “small“, “medium“, “large“, “x-large” (default: medium)</li>
</ul>
</li>
<li><code>font-family</code>
<ul>
<li>accepted_values: “auto“, “serif“, “sans-serif“, “monospace“, “opendyslexic” (default: auto)</li>
</ul>
</li>
<li><code>page-margins</code>
<ul>
<li>accepted values: “small“, “medium“, “large” (default: medium)</li>
</ul>
</li>
<li><code>show-annotations</code>
<ul>
<li>accepted values: “true“, “false” (default: false)</li>
</ul>
</li>
<li><code>show-page-delimiters</code>
<ul>
<li>accepted values: “true“, “false” (default: false)</li>
</ul>
</li>
<li><code>zoom</code>
<ul>
<li>accepted values: “fit-page“, “fit-width” or a number in the range 10 – 400 (default: fit-page)</li>
</ul>
</li>
<li><code>color-scheme</code>
<ul>
<li>accepted values: “auto“, “sepia“, “light“, “dark“, “light-forced“, “dark-forced” (default: auto)</li>
</ul>
</li>
<li><code>pagination-style</code>
<ul>
<li>accepted values: “slider“, “pages“, “percent” (default: slider)</li>
</ul>
</li>
</ul>
Layout, max-pages, default-font-size and page-margins are only available for reflowable ebooks, while zoom is only available for fixed layout ones.
Max-pages is the maximum number of pages (in the “paginated” layout) that the user will be able to see in a single view (if there is enough screen space).
Show-annotations and show-page-delimiters let the user see on the pages the Calibre annotations (as highlighted text, if there are Calibre annotations in the ebook) and the page delimiters (as short vertical bars, if the ebook contains a page list).
Color-scheme: “auto” means that the Viewer will adapt to the preferred color-scheme set by the user on their device or browser (light or dark).
For most ebooks these preferences should be enough, but sometimes there are ebooks with style rules that don’t play well with the styles set by the Viewer, so the users also have the option to apply some filters to the Viewer’s colors (with the menu entry “Color filter…”).
You can set the default values for these filters with the following shortcode’s attributes:
<ul>
<li><code>activate-color-filter</code>
<ul>
<li>accepted values: “true“, “false” (default: false)</li>
</ul>
</li>
<li><code>invert-color-filter</code>
<ul>
<li>accepted values: a number in the range 0 – 1 (default: 0)</li>
</ul>
</li>
<li><code>rotate-color-filter</code>
<ul>
<li>accepted values: a number in the range 0 – 360 (default: 0)</li>
</ul>
</li>
<li><code>bg-transparent-filter</code>
<ul>
<li>accepted values: “true“, “false” (default: true)</li>
</ul>
</li>
<li><code>bg-color-filter</code>
<ul>
<li>accepted values: a valid CSS hex color code (default: #FFFFFF)</li>
</ul>
</li>
</ul>
Setting activate-color-filter to “true” is necessary to enable all the other filters, and setting bg-transparent-filter to false is necessary to enable bg-color-filter.
Bg-transparent-filter and bg-color-filter are available for reflowable ebooks only.
Invert-color-filter inverts the lightness of the colors. With a value of 0 it has no effect, with a value of 1, white become black and black become white.
Rotate-color-filter rotates the hues of all the colors in the ebook, like on a <a href="https://developer.mozilla.org/en-US/docs/Glossary/Color_wheel" rel="nofollow ugc">Color Wheel</a> (so, no effect on black and white).
There are some other settings that the users won’t be able to change by themselves. These are:
<ul>
<li><code>always-full-viewport</code>
<ul>
<li>accepted values: “true“, “false” (default: false. If true, return-to-url is also required)</li>
</ul>
</li>
<li><code>return-to-url</code>
<ul>
<li>accepted values: a URL with the same hostname as the page that contains the ebook viewer (default: ”)</li>
</ul>
</li>
<li><code>real-fullscreen</code>
<ul>
<li>accepted values: “true“, “false” (default: false)</li>
</ul>
</li>
<li><code>allow-js</code>
<ul>
<li>accepted values: “true“, “false” (default: false)</li>
</ul>
</li>
<li><code>math-styles</code>
<ul>
<li>accepted values: “fonts“, “styles“, “all” (default: ”)</li>
</ul>
</li>
<li><code>ebook-author</code>
<ul>
<li>accepted values: any string, max 260 characters (default: ”)</li>
</ul>
</li>
<li><code>ebook-title</code>
<ul>
<li>accepted values: any string, max 260 characters (default: ”)</li>
</ul>
</li>
<li><code>popup-notes</code>
<ul>
<li>accepted values: “true“, “false” (default: true)</li>
</ul>
</li>
</ul>
With always-full-viewport set to “true”, the ebook viewer will automatically cover the entire webpage when it is opened, and the “full screen” icon will be replaced by a “close viewer” icon. always-full-viewport=”true” requires that also return-to-url is present, with a valid URL that indicates the destination of the user when they choose to close the viewer. The URL can be relative (e.g., “/” or “/books-gallery”) or absolute. In either case, it must have the same hostname as the webpage containing the ebook viewer (e.g. if the viewer is at https://www.example.com/ebook-viewer, the absolute URL must start with https://www.example.com).
If real-fullscreen is set to “true”, the ebook viewer will cover the entire screen instead of only the viewport of the webpage when the user clicks on the “full screen” icon. With real-fullscreen set to true, always-full-viewport is ignored, since the full screen requires an explicit action by the user.
Allow-js: normally, the plugin forbids, as far as possible, script execution from inside the ebooks. If you set allow-js to true, this restriction is relaxed, and scripts within the ebook can be executed. 
Caveat 1: you need to be absolutely certain that the code inside the ebook is not malicious, since it can harm your entire webpage. 
Caveat 2: the ebook viewer is not strongly equipped to deal with dynamic content created or removed after the ebook opening, so you might encounter errors or inaccuracies when jumping from one ebook location to another in such a circumstance.
Math-styles: in recent years all the major browsers have implemented a good deal of the MathML Core specification, so it is now possible to represent natively many mathematical expressions without the use of third party libraries. However, not all browsers and systems load automatically appropriate fonts. With math-styles set to “fonts” or “all”, all the contents of MathML expression will use the Latin Modern font. 
Another shortcoming in the current support of MathML is that only Gecko based browsers (i.e. Firefox) implement a breaking lines algorithm, so long math expressions within small screens usually don’t fit entirely. With math-styles set to “styles” or “all”, the plugin will use some html+css tricks to try to allow either line breaks or horizontal scrolling.
Ebook-author and ebook-title: you can use these optional values to override the ones that the ebook viewer retrieves from the ebook metadata in order to display them to the users.
Popup-notes: show footnotes and endnotes as popups instead of just links. The notes (and their references) need to be marked with the appropriate epub:type attributes to ensure that they are displayed as popups (the ebook viewer will try to recognize them anyway, but without guarantees).
<h3>Warning</h3>
Ebooks can contain scripted content that might be executed on your webpage. The plugin does its best to forbid script execution from inside the loaded content, but it can’t guarantee 100% safety. Don’t display ebooks from untrusted sources and/or check your ebooks before uploading and displaying them. If you can, provide a strict Content Security Policy for your site.
<h3>Credits</h3>
This plugin embeds a slightly modified version of the foliate-js library 
by John Factotum (https://github.com/johnfactotum/foliate-js), 
which is distributed under the MIT license.
As secondary dependencies of the foliate-js library, the plugin embeds three other libraries:
<ul>
<li>zip.js (https://github.com/gildas-lormeau/zip.js), licensed under the BSD-3-Clause;</li>
<li>fflate (https://github.com/101arrowz/fflate), MIT licensed.</li>
<li>PDF.js (https://github.com/mozilla/pdf.js), licensed under the Apache v2.0 license.</li>
</ul>
PDF.js is present in the repository’s source code, but is not included in the distribution of the current version of the plugin.
Other libraries embedded by the plugin are:
<ul>
<li>vite-for-wp by Dzikri Aziz (https://github.com/kucrut/vite-for-wp), 
licensed under the GPL v2.0 license</li>
<li>Speech Rule Engine (https://github.com/Speech-Rule-Engine/speech-rule-engine), 
licensed under the Apache v2.0 license</li>
</ul>
Embedded fonts:
<ul>
<li>OpenDyslexic (https://opendyslexic.org/) by Abbie Gonzales, licensed under the SIL Open Font License v1.1;</li>
<li>Manrope (https://github.com/sharanda/manrope) by The Manrope Project Authors, licensed under the SIL Open Font License v1.1;</li>
<li>Latin Modern (https://www.gust.org.pl/projects/e-foundry) by the Polish TeX Users Group, licensed under the GUST Font License.</li>
</ul>
OpenDyslexic and Latin Modern fonts have been converted from their original OpenType format to the woff2 format for use on the web, without, to the best of my knowledge, modifying their internal parameters and metadata.

Simple Ebook Viewer

Embed and display Ebooks in your website.

DB Table Viewer vs Simple Ebook Viewer