<div style="background-color:#ccc; padding:20px; border-radius:8px">
<p style="color: #000">Pages in Edit Mode:</p>
<p style="color: red; font-weight:bold">
              <?php 
                Loader::model('page_list'); 
                $pl = new PageList(); 
                $pl->filter('p1.cIsCheckedOut', '1', '='); 
                $pages = $pl->get();
                foreach($pages as $page)
                {
                echo $page->getCollectionName();
                echo "<br>";
                } ?>
</p>
<br>
<p style="color: #000">There must be NO pages in edit mode to proceed!</p>
</div>
<br>
<div style="background-color:#ccc; padding:20px; border-radius:8px">
<p style="color: #000">Pages Requiring Approval:</p>
<ol>
<?php
   foreach($files as $f) {
      print '<li><a href="'.$f[1].'">'.$f[0].'</a> - '.$f[2].'</li>';
   }
?>
</ol>
<p style="color: #000">There must be NO pages requiring approval to proceed!</p> 
</div>
<br>
<div style="background-color: #ccc; padding:20px; border-radius:8px">
<p style="color: #000">Total page versions before: <span style="color:#006; font-weight:bold; background-color:#c90; padding:2px 5px">
  <?php   Loader::model('page_statistics');
  echo PageStatistics::getTotalPageVersions();
  ?></span></p>
<br>
<p style="color: #000">Clicking the button below will delete all versions except: The current version + one (2 in total).<br></p>
<p style="color: #000">From the following database tables:</p>   
<p style="color: #606; font-weight:bold"><em>CollectionVersions, CollectionVersionsBlocks, CollectionVersionBlockStyles, CollectionAttributeValues.</em></p>
 
 
 
<form style="background-color: #fff; border:1px #000 solid; color: #000; padding:5px" id="versions" action='' method='POST'>
<input  id="versions" type="submit" name="submit1" value="Clear Versions">
<?php
echo "<br>";
if( isset( $_POST['submit1'] ) )
{
 
$db= Loader::db();
 
// Create a temp table to compare repeated Collection ID's (cID), remove all except the two with the highest numbers (latest) and then delete the temp table
 
// NOTE >> To increase the number of versions remaining change "the number required" element of this query to "t1.cvID>t0.cvID+(the number required);" (Currently set at +1)
// NOTE >> To have only the latest version remaining (Delete all old versions) remove the "+1" like this  "t1.cvID>t0.cvID;"
 
$db->Execute('DELETE t0 FROM CollectionVersions AS t0 JOIN CollectionVersions AS t1 ON t1.cID=t0.cID WHERE t1.cvIsApproved=1 AND t1.cvID>t0.cvID+1;');
echo "Table 'CollectionVersions' - Updated <br><br>";
 
// Now we have cleaned up the CollectionVersions table we can find cvID's in the CollectionVersionBlocks table
// If they are NOT in the CollectionVersions table we delete them
// We do the same for the CollectionVersionBlockStyles table and the CollectionAttributeValues table
$db->Execute('DELETE FROM CollectionVersionBlocks WHERE cvID NOT IN (SELECT cvID FROM CollectionVersions WHERE cvID is NOT NULL);');
echo "Table 'CollectionVersionBlocks' - Updated <br><br>";
 
$db->Execute('DELETE FROM CollectionVersionBlockStyles WHERE cvID NOT IN (SELECT cvID FROM CollectionVersions WHERE cvID is NOT NULL);');
echo "Table 'CollectionVersionBlockStyles' - Updated <br><br>";
 
$db->Execute('DELETE FROM CollectionAttributeValues WHERE cvID NOT IN (SELECT cvID FROM CollectionVersions WHERE cvID is NOT NULL);');
echo "Table 'CollectionAttributeValues' - Updated <br><br>";?>
<p style="color: #000">Total page versions now: <span style="color:#006; font-weight:bold; background-color:#c90; padding:2px 5px">
         <?php Loader::model('page_statistics');
         echo PageStatistics::getTotalPageVersions();
         ?>
</span></p>
<?php } ?>
</form>
<p style="font-weight:bold; color:red; margin-top:10px">Before proceeding make a backup of your database!</p>
</div>
<br>
<div style="background-color:#ccc; padding:20px; border-radius:8px">
<p style="color: #000">Clicking the button below will truncate the following database tables:</p><br>
<p style="color: #606; font-weight:bold"><em>PageStatistics, <!--btFormAnswers, btFormAnswerSet,--> WorkFlowProgress.</em></p>
 
<form style="background-color: #fff; border:1px #000 solid; color: #000; padding:5px" id="truncate" action='' method='POST'>
<input  id="truncate" type="submit" name="submit" value="Truncate Tables">
<?php
echo "<br>";
if( isset( $_POST['submit'] ) )
{
$db= Loader::db();
// Just for good measure we truncate the following tables
$db->Execute('truncate table PageStatistics;');
echo "Table 'PageStatistics' - Truncated <br><br>";
 
$db->Execute('truncate table WorkflowProgressHistory;');
echo "Table 'WorkflowProgressHistory' - Truncated <br><br>";
}
?>
</form>
<p style="font-weight:bold; color:red; margin-top:10px">Before proceeding make a backup of your database!</p>
</div>