CMS Made Simple Forums

Code: Select all

<?php
require_once("include.php");
// Quick and dirty script
// It trunctes table content and content_props and write new contents

$template_id = 18;

$content ='
<h1>Fusce tincidunt. Sed ultrices massa vitae tellus. Curabitur molestie aliquam.</h1>
  <p> Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Quisque  sagittis tincidunt elit. Donec porta volutpat ante. Donec gravida quam  et diam. Aenean molestie. Suspendisse potenti. Nam nonummy sagittis  quam. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices  posuere cubilia Curae; Etiam id elit vitae pede condimentum feugiat.  Integer libero mauris, convallis quis, auctor vel, aliquam eget, lorem.  Fusce vitae tellus ac justo pellentesque imperdiet. Maecenas interdum  commodo augue. Sed quis nunc vitae orci convallis suscipit. Cras dolor  massa, ornare sed, accumsan sodales, egestas non, dui. Suspendisse ut  lorem. Praesent porttitor lobortis metus. Fusce dolor nulla, egestas  vel, pulvinar vel, vulputate pretium, dui. Nulla venenatis rhoncus  purus. Donec in nisl. Fusce congue. </p>
  <img src="images/placeholder" />
  <h2>Fusce tincidunt. Sed ultrices massa vitae tellus. Curabitur molestie aliquam.</h2>
  <p>Ut elementum convallis mauris. Curabitur mattis enim sed mauris.  Curabitur felis. Nullam dictum, urna in pharetra pharetra, diam dui  facilisis nulla, at gravida arcu arcu quis nunc. Pellentesque sed nibh  non metus scelerisque aliquam. Cras ac felis. Ut hendrerit est. Aenean  laoreet sollicitudin eros. Aenean hendrerit quam nec massa. Sed eu  nunc. Duis vitae tortor faucibus neque elementum sodales. Sed hendrerit  tincidunt velit. Sed dolor metus, vulputate non, aliquam eu, viverra  id, arcu. Fusce interdum tellus sit amet lorem. Morbi eget lacus.  Curabitur in turpis. </p>
  <h3>Fusce tincidunt. Sed ultrices massa vitae tellus. Curabitur molestie aliquam.</h3>
  <p>Proin pretium suscipit mauris. Aliquam sapien justo, aliquet nec,  dignissim a, dignissim vitae, ligula. Nunc tincidunt. Donec facilisis.  Ut vitae nulla. Ut in lacus. Proin egestas justo et felis. Proin magna  quam, tincidunt vitae, rhoncus semper, aliquet vitae, justo. Duis est  ligula, tincidunt at, porta eu, egestas et, arcu. Donec mattis  convallis lectus. Ut purus justo, ultricies sollicitudin, gravida ac,  euismod in, diam. Curabitur risus. Etiam purus. Sed in eros. Donec arcu  ipsum, tincidunt sed, euismod eget, interdum ac, augue. Etiam massa  elit, sodales auctor, posuere vitae, euismod eget, dui. Aliquam  scelerisque nisi a felis. </p>
  <h4>Fusce tincidunt. Sed ultrices massa vitae tellus. Curabitur molestie aliquam.</h4>
  <ul>
    <li>Lorem ipsum dolor sit amet, consectetuer adipiscing elit.</li>
    <li>In suscipit elementum nulla.</li>
    <li>In et est ac quam mollis venenatis.</li>
    <li>Fusce viverra risus non dolor.</li>
    <li>Ut et justo sagittis dolor convallis vehicula.</li>
  </ul>
  
  <ul>
    <li>Phasellus ultrices pellentesque lorem.</li>
    <li>In tristique massa bibendum mauris.</li>
    <li>Sed interdum scelerisque nunc.</li>
    <li>Mauris eu nulla ut ipsum cursus auctor.</li>
    <li>Donec mollis massa dignissim sem.</li>
  </ul>
  <h5>Sample Link List</h5>
  <ul>
    <li><a href="#">Sed non odio in nisl pretium bibendum.</a></li>
    <li><a href="#">Morbi tincidunt enim vel neque elementum dictum.</a></li>
    <li><a href="#">Morbi dictum est in erat.</a></li>
    <li><a href="#">Integer quis dolor vulputate eros ultricies elementum.</a></li>
    <li><a href="#">Praesent euismod condimentum odio.</a></li>
    <li><a href="#">Mauris hendrerit nisl in odio.</a></li>
  </ul>
 <blockquote>Aenean nisi leo, ullamcorper ut, placerat et, iaculis vel, metus. Praesent malesuada. Sed quis diam. Pellentesque mi. Suspendisse ac magna.</blockquote>
 <p>This is a sample <a href="#">inline link</a></p>';

// Make the first contents
// This is the counter to create pages until $each is arrived - change it to what you want.
// Writes at standard 1300 Contents with Sublevels.
$end=50;


$i=0;
$xi=0;
$all=0;
$dbresult = $db->Execute('TRUNCATE TABLE '.cms_db_prefix()."content");
while ($i<$end)
{
 $xi++;
 $iii=$i+1;
 if ($i<1) {$h='00001';}else{$h=str_repeat('0',5-strlen($iii)).$iii;}
 $menu='Content '.$xi;$alias='content'.$xi;
 
 $today=date("y-m-d h:m:s");
$ii=$i-1;
$pi=-1;
if ($iii == 1) {$df=1;}else{$df=0;}
$all++;
$query ="INSERT INTO ".cms_db_prefix()."content ( CONTENT_ID, CONTENT_NAME, TYPE, OWNER_ID, PARENT_ID, TEMPLATE_ID, ITEM_ORDER, HIERARCHY, DEFAULT_CONTENT, MENU_TEXT, CONTENT_ALIAS, COLLAPSED, SHOW_IN_MENU, MARKUP, ACTIVE, CACHABLE, LAST_MODIFIED_BY, CREATE_DATE, MODIFIED_DATE ) VALUES (".$xi.",'".$alias."', 'content', 1, -1, $template_id,".$xi.",'".$h."',".$df.",'".$menu."','".$alias."', null, 1, 'html', 1, 1, 1,'".$today."','".$today."' )";
$dbresult = $db->Execute($query);
 
$query ="INSERT INTO ".cms_db_prefix()."content_props ( CONTENT_ID, TYPE, PROP_NAME, PARAM1, PARAM2, PARAM3, CONTENT, CREATE_DATE, MODIFIED_DATE ) VALUES ( ".$xi.", 'string', 'content_en', null, null, null, '".$content."','".$today."','".$today."')";
$dbresult = $db->Execute($query);
 
$si=0;
$ssi=0;
$oldxi = $xi;
while ($si < 3)
{
  // make sublevel 1
  $si++;
  $hh=$h.'.'.str_repeat('0',5-strlen($si)).$si;
  $xi++;
  $all++;
  $menu='Content '.$xi;$alias='content'.$xi;
  $query ="INSERT INTO ".cms_db_prefix()."content ( CONTENT_ID, CONTENT_NAME, TYPE, OWNER_ID, PARENT_ID, TEMPLATE_ID, ITEM_ORDER, HIERARCHY, DEFAULT_CONTENT, MENU_TEXT, CONTENT_ALIAS, COLLAPSED, SHOW_IN_MENU, MARKUP, ACTIVE, CACHABLE, LAST_MODIFIED_BY, CREATE_DATE, MODIFIED_DATE ) VALUES (".$xi.",'".$alias."', 'content', 1,".$oldxi.", $template_id,1,'".$hh."',".$df.",'".$menu."','".$alias."', null, 1, 'html', 1, 1, 1,'".$today."','".$today."' )";
  $dbresult = $db->Execute($query);
  $query ="INSERT INTO ".cms_db_prefix()."content_props ( CONTENT_ID, TYPE, PROP_NAME, PARAM1, PARAM2, PARAM3, CONTENT, CREATE_DATE, MODIFIED_DATE ) VALUES ( ".$xi.", 'string', 'content_en', null, null, null, '".$content."','".$today."','".$today."')";
  $dbresult = $db->Execute($query);
  // make sublevel 2
  $ssi=0;
  $oldxi = $xi;
  while ($ssi <3)
  {
  $ssi++;
  $hhh=$hh.'.'.str_repeat('0',5-strlen($ssi)).$ssi;
  $xi++;
  $all++;
  $menu='Content '.$xi;$alias='content'.$xi;
  $query ="INSERT INTO ".cms_db_prefix()."content ( CONTENT_ID, CONTENT_NAME, TYPE, OWNER_ID, PARENT_ID, TEMPLATE_ID, ITEM_ORDER, HIERARCHY, DEFAULT_CONTENT, MENU_TEXT, CONTENT_ALIAS, COLLAPSED, SHOW_IN_MENU, MARKUP, ACTIVE, CACHABLE, LAST_MODIFIED_BY, CREATE_DATE, MODIFIED_DATE ) VALUES (".$xi.",'".$alias."', 'content', 1,".$oldxi.", 1,1,'".$hhh."',".$df.",'".$menu."','".$alias."', null, 1, 'html', 1, 1, 1,'".$today."','".$today."' )";  $dbresult = $db->Execute($query);
  $query ="INSERT INTO ".cms_db_prefix()."content_props ( CONTENT_ID, TYPE, PROP_NAME, PARAM1, PARAM2, PARAM3, CONTENT, CREATE_DATE, MODIFIED_DATE ) VALUES ( ".$xi.", 'string', 'content_en', null, null, null, '".$content."','".$today."','".$today."')";
  $dbresult = $db->Execute($query);
  }

}


$i++;
}
$query="UPDATE ".cms_db_prefix()."content_seq SET id=".$all;
$dbresult = $db->Execute($query);
$query="UPDATE ".cms_db_prefix()."content_props_seq SET id=".$all;
$dbresult = $db->Execute($query);


echo 'done ! '.$all.' contents written.';

Code: Select all

$dbresult = $db->Execute('TRUNCATE TABLE '.cms_db_prefix()."content");

Code: Select all

<?php

ini_set('display_errors', true);
error_reporting(E_ALL);

require_once("include.php");
// Quick and dirty script
// It trunctes table content and content_props and write new contents

$template_id = 18;

$content ='

Code: Select all

// This is the counter to create pages until $each is arrived - change it to what you want.

Code: Select all

$end=50;
while ($i<$end)
{
  INSERT
  $si=0;
  $ssi=0;
  while ($si < 3)
  {
    INSERT
    $ssi=0;
    while ($ssi <3)
    {
      INSERT
    }
  }
}