Sandbox

Just a place to test stuff

Table of Contents

WPDT examples

ABF25 list

This is Table 55 in our WPDT library, generated by SQL query ofย  the new bunker table in the WP Core DB. Note, Bunker_ID is primary key and index key (although not shown on the SQL structure below).

SQL Query is

SELECT
bunkers.`Bunker_ID`,
bunkers.`Bunker_name`,
bunkers.`Bunker_type`,
bunkers.`Bunker_area`,
bunkers.`Bunker_lat`,
bunkers.`Bunker_long`,
bunkers.`Bunker_grid`,
bunkers.`Bunker_WAB`,
bunkers.`Bunker_Pcode`,
bunkers.`Bunker_Locator`
FROM bunkers
WHERE bunkers.`Bunker_AFB25` = 1;

Custom CSS specific to the table is below
– Reposition the artifacts around the table data
– Make wider
– Set to a more readable font than those provided with WPDT (font is ‘Inter’)
– Make all data CAPITALS when displayed in WPDT
– Removing loading animation

/* — 1. Align Show entries and Search side by side at the top — */
.wpDataTablesWrapper .dataTables_wrapper .top {
display: flex !important;
flex-wrap: nowrap !important;
justify-content: space-between;
align-items: center;
gap: 15px;
margin-bottom: 10px;
}

/* Show entries and search get flex sizing */
.wpDataTablesWrapper .dataTables_length,
.wpDataTablesWrapper .dataTables_filter {
flex: 0 0 auto;
}

/* Optional: limit search input width */
.wpDataTablesWrapper .dataTables_filter input {
max-width: 200px;
}

/* — 2. Hide dt-buttons from the top container — */
.wpDataTablesWrapper .dt-buttons {
display: block !important; /* keep buttons visible */
margin: 10px 0 0 0;
/* We’ll reposition them with JS or by moving in DOM */
}

/* — 3. Force buttons below the table using flex order — */
.wpDataTablesWrapper .dataTables_wrapper {
display: flex;
flex-direction: column;
}

/* Move buttons to bottom */
.wpDataTablesWrapper .dt-buttons {
order: 2; /* place buttons after table */
}

/* Table itself order 1 */
.wpDataTablesWrapper .wpDataTable {
order: 1;
}

/* Show entries and search on top container */
.wpDataTablesWrapper .dataTables_wrapper .top {
order: 0;
}

/* — 4. Wrapper full width — */
.wpDataTablesWrapper,
.wpDataTablesWrapper .dataTables_wrapper {
width: 100% !important;
max-width: 100% !important;
overflow-x: auto;
box-sizing: border-box;
}

/* — 5. Wide table styling — */
.wpDataTablesWrapper .wpDataTable {
width: 100% !important;
margin: 0 auto;
}

/* — 6. Font settings — */
table.dataTable,
table.dataTable tbody td,
table.dataTable thead th {
font-family: ‘Inter’, sans-serif !important;
font-size: 13px !important;
font-weight: 200;
}

/* — 7. Hide any SVG icons — */
.wpDataTablesWrapper svg {
display: none !important;
}

/* — 8. Make all table data uppercase — */
.wpDataTablesWrapper .wpDataTable td {
text-transform: uppercase;
}

The WordPress Database tables

The bunkers table

Note Bunker_ID is primary key and index

47310a31-5dca-4f36-8792-94636614d950

The hunterqso table

The activatorqso table

The activatorqso table - full search on database (up to end end c.20 June 2025)

Translate ยป