<?php defined('C5_EXECUTE') or die("Access Denied.");
 
$sbh = Loader::helper('concrete/scrapbook');
 
$scrapbookPage = $sbh->getGlobalScrapbookPage();
if (!$scrapbookPage->getCollectionID()) {
   die('ERROR: NO SCRAPBOOK PAGE FOUND');
}
 
$scrapbooks = $sbh->getAvailableScrapbooks();
foreach ($scrapbooks as $sb) {
   $arHandle = $sb['arHandle'];
   $scrapbookArea = new Area($arHandle);
   $scrapbookBlocks = $scrapbookArea->getAreaBlocksArray($scrapbookPage);
   $success = addBlocksToNewStack($arHandle, $scrapbookBlocks, $scrapbookPage);
   echo "Scrapbook: {$arHandle} - " . ($success ? 'successfully converted to stack' : 'failed (stack already exists with that name)') . ".\n";
}
 
echo "done.";
 
//////////////////////
 
function addBlocksToNewStack($arHandle, $blocksArray, $scrapbookPage) {
   Loader::model('stack');
   $stackName = 'Scrapbook: ' . $arHandle;
   $stack = Stack::getByName($arHandle);
   if ($stack) {
      //This already exists, so don't overwrite it.
      return false;
   } else {
      $stack = Stack::addStack($stackName, Stack::ST_TYPE_USER_ADDED);
   }
 
 
   foreach ($blocksArray as $b) {
      $b->duplicate($scrapbookPage);
   }
 
   return true;
}
 

<?php defined('C5_EXECUTE') or die("Access Denied."); ?>
 
<h1>Migrating Scrapbook Content to Stacks.</h1>
<p>START</p>
 
<?php
// Config. Delete the original blocks in the scrapbook?
$deleteOriginals = true;
 
// Empty the cache so we don't get any weird errors
Cache::flush();
 
$db = Loader::db();
Loader::model('stack/model');
 
$scrapbookHelper = Loader::helper('concrete/scrapbook');
$globalScrapbookPage = $scrapbookHelper->getGlobalScrapbookPage();
if (!$globalScrapbookPage->getCollectionID()) {
   die('Error: No scrapbook page found.');
}
 
// Find all scrapbooks
$availableScrapbooks = $scrapbookHelper->getAvailableScrapbooks();
 
// For each scrapbook... (each scrapbook is an Area on the global scrapbook page)
foreach($availableScrapbooks as $scrapbook) {
 
   // Find all blocks in that scrapbook
   $scrapbookArea = new Area($scrapbook['arHandle']);
   $scrapbookBlocks = $scrapbookArea->getAreaBlocksArray($globalScrapbookPage);
 
   // For each block...
   foreach($scrapbookBlocks as $ix => $block) {
 
      // Get or create stack
      $stack = Stack::getByName($block->bName);
      if (!$stack) { $stack = Stack::addStack($block->bName); }
      $stackArea = Area::get($stack, STACKS_AREA_NAME);
 
      // Duplicate the block & move it over to the stack
      $newBlock = $block->duplicate($stack);
      $newBlock->move($stack, $stackArea);
 
      // Duplicating the block creates a relation to the original. Break this connection?
   /*   $query = 'DELETE FROM BlockRelations WHERE originalBID = ?';
      $res = $db->prepare($query);
      $db->Execute($res, array($newBlock->bID));*/
 
      // Find all instances of the original block
      $query = "SELECT cvb.* FROM CollectionVersionBlocks AS cvb " .
            "LEFT JOIN CollectionVersions AS cv ON cvb.cvID = cv.cvID && cvb.cID = cv.cID " .
            "WHERE cvb.bID = '{$block->bID}' && cv.cvIsApproved = 1";
      $r = $db->query($query);
      $originalBlockInstances = array();
      while($row = $r->fetchRow()) {
         $originalBlockInstances[] = $row;
      }
 
      // For each instance of the block...
      foreach($originalBlockInstances as $originalBlockInstance) {
 
         // Create a proxy block pointing to the stack
         $query = "INSERT INTO Blocks (bID, bName, bDateAdded, bDateModified, bFilename, bIsActive, btID, uID) " .
               "VALUES (NULL, NULL, NOW(), NOW(), NULL, 1, (SELECT bt.btID FROM BlockTypes AS bt WHERE bt.btHandle = '" . BLOCK_HANDLE_STACK_PROXY . "'), 1)";
         $res = $db->prepare($query);
         $db->Execute($res);
         $proxyBlockID = $db->Insert_ID();
 
         // Add in proxy block content
         $query = 'INSERT INTO btCoreStackDisplay (bID, stID) VALUES (?, ?)';
         $res = $db->prepare($query);
         $db->Execute($res, array($proxyBlockID, $stack->getCollectionID()));
 
         // Replace the original with the proxy
         // Note: This will update the current version of the Collection, it will not create a new version.
         $query = 'UPDATE CollectionVersionBlocks AS cvb SET bID = ?, isOriginal = 1, cbOverrideAreaPermissions = 0 WHERE ' .
               'cID = ? && cvID = ? && bID = ? && arHandle = ?';
         $res = $db->prepare($query);
         $db->Execute($res, array($proxyBlockID, $originalBlockInstance['cID'], $originalBlockInstance['cvID'], $originalBlockInstance['bID'], $originalBlockInstance['arHandle']));
 
         $query = 'UPDATE CollectionVersionBlockStyles AS cvbs SET bID = ? WHERE ' .
               'cID = ? && cvID = ? && bID = ? && arHandle = ?';
         $db->Execute($query, array($proxyBlockID, $originalBlockInstance['cID'], $originalBlockInstance['cvID'], $originalBlockInstance['bID'], $originalBlockInstance['arHandle']));
      /*   $query = 'UPDATE BlockRelations AS br SET originalBID = ? WHERE originalBID = ?';
         $db->Execute($query, array($proxyBlockID, $originalBlockInstance['bID']));*/
         // CollectionVersionBlockPermissions
         // ComposerContentLayout
 
      } // end foreach($originalBlockInstances)
 
      // Delete block from scrapbook?
      if ($deleteOriginals) {
         $block->delete();
      }
 
   } // end foreach($scrapbookBlocks)
 
} // end foreach($availableScrapbooks)
?>
<p>END</p>