<?php
/* 
* Theme: PREMIUMPRESS CORE FRAMEWORK FILE
* Url: www.premiumpress.com
* Author: Mark Fail
*
* THIS FILE WILL BE UPDATED WITH EVERY UPDATE
* IF YOU WANT TO MODIFY THIS FILE, CREATE A CHILD THEME
*
* http://codex.wordpress.org/Child_Themes
*/
if (!defined('THEME_VERSION')) {	header('HTTP/1.0 403 Forbidden'); exit; }


global $settings, $wpdb;
 
   $g = get_post_types();
   
   ?>

<p>Here are a list of tables and table values used by the theme.</p>

<div class="card card-admin">
  <div class="card-body">
    <table class="table table-bordered bg-white  mb-4">
      <thead>
        <tr>
          <th scope="col">Name</th>
          <th scope="col">Description</th>
          <th scope="col">Used By Theme</th>
        </tr>
      </thead>
      <tbody>
        <?php foreach($g as $k => $h){ ?>
        <tr>
          <td><?php echo $k; ?> </td>
          <td><div class="p-2"><?php echo $h; ?></div></td>
          <td style="text-align:center;"><div class="p-2">
              <?php if( strpos($h ,"ppt_") === false && $h != "listing_type" ){ ?>
              
              <div class="opacity-5">No</div>
              
              <?php }else{  
			   
			  
			  	$total = 0;
			  	$SQL = "select count(*) AS total FROM ".$wpdb->posts." WHERE ".$wpdb->posts.".post_type='".$h."'";
			 
			  
			  	$result = $wpdb->get_results($SQL);
				$total = $result[0]->total;		 
			  
			  ?>
              
               
                <div class="small text-uppercase"><?php echo number_format( $total); ?> entries</div>
                
                <a href="admin.php?page=docs&deletedb=<?php echo $h; ?>" class="btn btn-system btn-sm mt-2">delete all</a>
              
              <?php } ?>
              
              
              
            </div></td>
        </tr>
        <?php } ?>
      </tbody>
    </table>
  </div>
</div>