Головна сторінка Огляд Довідка
Реєстрація Увійти
URBANMS
/
EXCELIA_DBARR
2
0
Відгалуження 0
Файли Проблеми 0 Запити на злиття 0 Wiki
Дерево: 03306ebc0e
Гілки Теги
EXCELIA_DBARR
/
install
/
doctemplates
/
websites
/
website_template-stellar
/
website_pages.sql

website_pages.sql 17 KB
Історія Запис

123456789101112131415161718 
  1. -- Page ID 20 -> 1__+MAX_llx_website_page__ - Aliases credits --;
    2. 

  2. INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(1__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'credits', '', 'Credits', 'Credits and legal notices', 'en', '', '', '1', '2019-08-15 16:39:56', '2020-02-21 10:27:17', null, '', 'page', '', '	__N__		<!-- Wrapper -->__N__			<div id=\"wrapper\">__N____N__				<!-- Header -->__N__					<header id=\"header\">__N__						<h1>Mentions légales</h1>__N__						<p>Curriculum Vitae</p>__N__					</header>__N____N__                <!-- Menu -->__N__                <?php includeContainer(\'menu\'); ?>__N____N__				<!-- Main -->__N__					<div id=\"main\">__N____N__						<!-- Content -->__N__							<section id=\"content\" class=\"main\">__N____N__								<div class=\"chapo\"><p>__N__								    __N__This site is edited by <?php echo $mysoc->name; ?>__N____N__								    __N__								</div>__N____N__							</section>__N____N__					</div>__N____N__				<!-- Footer -->__N__				<?php includeContainer(\'footer\'); ?>__N____N__			</div>__N____N__', '', '0');
    3. 

  3. -- Page ID 21 -> 2__+MAX_llx_website_page__ - Aliases footer --;
    4. 

  4. INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(2__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'footer', '', 'Footer', '', 'fr', '', '', '1', '2019-08-15 16:42:44', '2020-06-19 10:18:14', null, '', 'page', '', '				<!-- Footer -->__N__                    <footer id=\"footer\">__N__						<section contenteditable=\"true\">__N__							<h2>Aliquam sed mauris</h2>__N__							<p>Sed lorem ipsum dolor sit amet et nullam consequat feugiat consequat magna adipiscing tempus etiam dolore veroeros. eget dapibus mauris. Cras aliquet, nisl ut viverra sollicitudin, ligula erat egestas velit, vitae tincidunt odio.</p>__N__							<ul class=\"actions\">__N__								<li><a href=\"generic.php\" class=\"buttonwebsite\">Learn More</a></li>__N__							</ul>__N__						</section>__N__						<section contenteditable=\"true\">__N__							<h2>Etiam feugiat</h2>__N__							<dl class=\"alt\">__N__								<dt>Address</dt>__N__								<dd><?php echo $mysoc->getFullAddress(1, \'<br>\'); ?></dd>__N__								<dt>Phone</dt>__N__								<dd><?php echo $mysoc->phone; ?></dd>__N__								<dt>Email</dt>__N__								<dd><a href=\"mailto:<?php echo $mysoc->email; ?>\"><?php echo $mysoc->email; ?></a></dd>__N__							</dl>__N__							<ul class=\"icons\">__N__	                          <ul class=\"list-inline\">__N__                              <?php foreach($mysoc->socialnetworks as $key => $value) {__N__                                print \'<li><a target=\"_blank\" class=\"icon alt fab fa-\'.$key.\'\" href=\"\'.(preg_match(\'/^http/\', $value) ? $value : \'https://www.\'.$key.\'.com/\'.$value).\'\"><span class=\"label\">\'.ucfirst($key).\'</span></a></li>\';__N__                              } ?>__N__                            </ul>__N__						</section>__N__						<div class=\"copyright\">&copy; Untitled. Design: <a href=\"https://html5up.net\">HTML5 UP</a> adapted for <a href=\"https://www.dolibarr.org\">Dolibarr</a> by <a href=\"https://www.dolicloud.com\">DoliCloud</a>.</div>__N__					</footer>__N____N____N__<script>__N__// When the user scrolls down 20px from the top of the document, show the button__N__window.onscroll = function() {scrollFunction()};__N____N__function scrollFunction() {__N__  console.log(\"Execute code for scroll Top button\");__N__  if (document.body.scrollTop > 20 || document.documentElement.scrollTop > 20) {__N__    document.getElementById(\"myBtnToTop\").style.display = \"block\";__N__  } else {__N__    document.getElementById(\"myBtnToTop\").style.display = \"none\";__N__  }__N__}__N____N__// When the user clicks on the button, scroll to the top of the document__N__function topFunction() {__N__  document.body.scrollTop = 0; // For Safari__N__  document.documentElement.scrollTop = 0; // For Chrome, Firefox, IE and Opera__N__}__N__</script>__N____N__<button onclick=\"topFunction()\" id=\"myBtnToTop\" title=\"Go to top\">Top</button>__N__', '', '0');
    5. 

  5. -- Page ID 22 -> 3__+MAX_llx_website_page__ - Aliases generic --;
    6. 

  6. INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(3__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'generic', '', 'Generic page', 'Generic page or my personal Blog', 'en', '', 'My generic page', '1', '2019-08-15 00:03:43', '2020-05-14 18:48:34', null, '', 'page', '', '	__N__<!-- Wrapper -->__N__<div id=\"wrapper\">__N____N__	<!-- Header -->__N__		<header id=\"header\">__N__			<h1>Another page</h1>__N__			<p>Ipsum dolor sit amet nullam</p>__N__		</header>__N____N__    <!-- Menu -->__N__    <?php includeContainer(\'menu\'); ?>__N____N__	<!-- Main -->__N__	<div id=\"main\">__N____N__		<!-- Content -->__N__		<section id=\"content\" class=\"main\" contenteditable=\"true\">__N__			<span class=\"image main\"><img src=\"medias/image/__WEBSITE_KEY__/pic01.jpg\" alt=\"\" /></span>__N__			<h2>Magna feugiat lorem</h2>__N__			<p>Donec eget ex magna. Interdum et malesuada fames ac ante ipsum primis in faucibus. Pellentesque venenatis dolor imperdiet dolor mattis sagittis. Praesent rutrum sem diam, vitae egestas enim auctor sit amet. Pellentesque leo mauris, consectetur id ipsum sit amet, fergiat. Pellentesque in mi eu massa lacinia malesuada et a elit. Donec urna ex, lacinia in purus ac, pretium pulvinar mauris. Curabitur sapien risus, commodo eget turpis at, elementum convallis fames ac ante ipsum primis in faucibus.</p>__N__			<p>Pellentesque venenatis dolor imperdiet dolor mattis sagittis. Praesent rutrum sem diam, vitae egestas enim auctor sit amet.</p>__N__			<h2>Tempus veroeros</h2>__N__			<p>Cep risus aliquam gravida cep ut lacus amet. Adipiscing faucibus nunc placerat. Tempus adipiscing turpis non blandit accumsan eget lacinia nunc integer interdum amet aliquam ut orci non col ut ut praesent.</p>__N__		</section>__N____N__        <!-- Blog list -->__N__        <section id=\"sectionnews\" contenteditable=\"true\" class=\"main section-50 section-md-50 section-md-bottom-50\">__N__			<h2>Latest Blog posts</h2>__N__            <div class=\"center\">__N__            <?php __N__            $keyword = \'\';__N__            $weblangs->loadLangs(array(\"main\",\"website\"));__N__            $fuser = new User($db);__N__            $arrayofblogs = $websitepage->fetchAll($website->id, \'DESC\', \'date_creation\', 5, 0, array(\'type_container\'=>\'blogpost\', \'status\'=>1, \'lang\'=>\'null,\'.$websitepage->lang));  // , \'keywords\'=>$keyword__N__            if (is_numeric($arrayofblogs) && $arrayofblogs < 0)__N__            {__N__                print \'<div class=\"error\">\'.$weblangs->trans($websitepage->error).\'</div>\';__N__            }__N__            elseif (is_array($arrayofblogs) && ! empty($arrayofblogs))__N__            {__N__                foreach($arrayofblogs as $blog)__N__                {__N__                    print \'<div class=\"row justify-content-sm-center row-40\">\';__N__                    print \'<div class=\"container blog-box centpercent\" style=\"padding: 20px; transition: .3s all ease;\">\';__N__                                print \'<a href=\"\'.$blog->pageurl.\'.php\">\';__N__                                print \'<div class=\"post-boxed-img-wrap\"><img src=\"\'.($blog->image ? \'viewimage.php?modulepart=medias&file=\'.$blog->image : \'medias/image/\'.$website->ref.\'/calendar.svg\"\').\'\" alt=\"\" width=\"120\"></div>\';__N__                                print \'<div class=\"post-boxed-caption\">\';__N__                                print \'<div class=\"post-boxed-title font-weight-bold\">\'.$blog->title.\'</div>\';__N__                                print \'<ul class=\"list-inline list-inline-dashed text-uppercase\">\';__N__                                print \'<li>\'.dol_print_date($blog->date_creation, \'daytext\', \'tzserver\', $weblangs).\'</li>\';__N__                                $fuser->fetch($blog->fk_user_creat);__N__                                print \'<li><span>by<span> <span class=\"text-primary\">\'.($fuser->firstname?$fuser->firstname:$fuser->login).\'</span></span></li>\';__N__                                print \'</ul>\';__N__                                print \'</div>\';__N__                                //includeContainer($blog->pageurl);__N__                                print \'<span class=\"nohover\">\'.$blog->description.\'</span>\';__N__                                print \'</a>\';__N__                    print \'</div>\';__N__                    print \'</div>\';__N__                }__N__            }__N__            else__N__            {__N__                    print \'<div class=\"row justify-content-sm-center row-40\">\';__N__                    print \'<div class=\"container blog-box centpercent\" style=\"padding: 20px; transition: .3s all ease;\">\';__N__                    //print $weblangs->trans(\"NoArticlesFoundForTheKeyword\", $keyword);__N__                    print $weblangs->trans(\"NoArticlesFound\");__N__                    print \'</div>\';__N__                    print \'</div>\';__N__                __N__            }__N__            ?>__N__            </div>__N__        </section>__N____N__	</div>__N____N____N____N__	<!-- Footer -->__N__	<?php includeContainer(\'footer\'); ?>__N__	__N__	__N__</div>__N____N__', '', '0');
    7. 

  7. -- Page ID 23 -> 4__+MAX_llx_website_page__ - Aliases home --;
    8. 

  8. INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(4__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'home', '', 'My personal blog', 'Home page or my personal Blog', 'en', '', 'My personal blog', '1', '2019-08-15 00:03:43', '2022-07-06 23:50:25', null, '', 'page', '', '<!-- Wrapper -->__N__<div id=\"wrapper\">__N____N__	<!-- Header -->__N__		<header id=\"header\">__N__			<section id=\"sectionheader\" contenteditable=\"true\">__N__			<h1>David Doe</h1>__N__			<p>Welcome on my website<br />__N__			</p>__N__			</section>__N__		</header>__N____N__	<!-- Nav -->__N__    <?php includeContainer(\'menu\'); ?>__N____N__	<!-- Main -->__N__		<div id=\"main\">__N____N__			<!-- Introduction -->__N__				<section id=\"sectionintro\" class=\"main\" contenteditable=\"true\">__N__					<div class=\"spotlight\">__N__						<div class=\"content\">__N__							<header class=\"major\">__N__								<h2>Ipsum sed adipiscing</h2>__N__							</header>__N__							<p>Sed lorem ipsum dolor sit amet nullam consequat feugiat consequat magna__N__							adipiscing magna etiam amet veroeros. Lorem ipsum dolor tempus sit cursus.__N__							Tempus nisl et nullam lorem ipsum dolor sit amet aliquam.</p>__N__							<ul class=\"actions\">__N__								<li><a href=\"generic.php\" class=\"buttonwebsite\">Learn More</a></li>__N__							</ul>__N__						</div>__N__						<span class=\"image\"><img class=\"logowebsite\" src=\"medias/image/__WEBSITE_KEY__/daviddoe.png\" alt=\"\" /></span>__N__					</div>__N__				</section>__N____N__			<!-- First Section -->__N__				<section id=\"sectionfirst\" id=\"first\" class=\"main special\" contenteditable=\"true\">__N__					<header class=\"major\">__N__						<h2>Magna veroeros</h2>__N__					</header>__N__					<ul class=\"features\">__N__						<li>__N__							<span class=\"icon solid major style1 fa-code\"><!-- keep this comment --></span>__N__							<h3>Ipsum consequat</h3>__N__							<p>Sed lorem amet ipsum dolor et amet nullam consequat a feugiat consequat tempus veroeros sed consequat.</p>__N__						</li>__N__						<li>__N__							<span class=\"icon major style3 fa-copy\"><!-- keep this comment  --></span>__N__							<h3>Amed sed feugiat</h3>__N__							<p>Sed lorem amet ipsum dolor et amet nullam consequat a feugiat consequat tempus veroeros sed consequat.</p>__N__						</li>__N__						<li>__N__							<span class=\"icon major style5 fa-at\"><!-- keep this comment  --></span>__N__							<h3>Dolor nullam</h3>__N__							<p>Sed lorem amet ipsum dolor et amet nullam consequat a feugiat consequat tempus veroeros sed consequat.</p>__N__						</li>__N__					</ul>__N__					<footer class=\"major\">__N__						<ul class=\"actions special\">__N__							<li><a href=\"generic.php\" class=\"buttonwebsite\">Learn More</a></li>__N__						</ul>__N__					</footer>__N__				</section>__N____N__			<!-- Second Section -->__N__				<section id=\"sectionsecond\" class=\"main special\" contenteditable=\"true\">__N__					<header class=\"major\">__N__						<h2>Ipsum consequat</h2>__N__						<p>Donec imperdiet consequat consequat. Suspendisse feugiat congue<br />__N__						posuere. Nulla massa urna, fermentum eget quam aliquet.</p>__N__					</header>__N__					<ul class=\"statistics\">__N__						<li class=\"style1\">__N__							<span class=\"icon solid fa-code-branch\"><!-- keep this comment  --></span>__N__							<strong>5,120</strong> Etiam__N__						</li>__N__						<li class=\"style2\">__N__							<span class=\"icon fa-folder-open\"><!-- keep this comment  --></span>__N__							<strong>8,192</strong> Magna__N__						</li>__N__						<li class=\"style3\">__N__							<span class=\"icon solid fa-signal\"><!-- keep this comment  --></span>__N__							<strong>2,048</strong> Tempus__N__						</li>__N__						<li class=\"style4\">__N__							<span class=\"icon solid fa-laptop\"><!-- keep this comment  --></span>__N__							<strong>4,096</strong> Aliquam__N__						</li>__N__						<li class=\"style5\">__N__							<span class=\"icon fa-gem\"><!-- keep this comment  --></span>__N__							<strong>1,024</strong> Nullam__N__						</li>__N__					</ul>__N__					<p class=\"content\">Nam elementum nisl et mi a commodo porttitor. Morbi sit amet nisl eu arcu faucibus hendrerit vel a risus. Nam a orci mi, elementum ac arcu sit amet, fermentum pellentesque et purus. Integer maximus varius lorem, sed convallis diam accumsan sed. Etiam porttitor placerat sapien, sed eleifend a enim pulvinar faucibus semper quis ut arcu. Ut non nisl a mollis est efficitur vestibulum. Integer eget purus nec nulla mattis et accumsan ut magna libero. Morbi auctor iaculis porttitor. Sed ut magna ac risus et hendrerit scelerisque. Praesent eleifend lacus in lectus aliquam porta. Cras eu ornare dui curabitur lacinia.</p>__N__					<footer class=\"major\">__N__						<ul class=\"actions special\">__N__							<li><a href=\"generic.php\" class=\"buttonwebsite\">Learn More</a></li>__N__						</ul>__N__					</footer>__N__				</section>__N____N__			<!-- Get Started -->__N__				<section id=\"sectioncta\" class=\"main special\" contenteditable=\"true\">__N__					<header class=\"major\">__N__						<h2>Congue imperdiet</h2>__N__						<p>Donec imperdiet consequat consequat. Suspendisse feugiat congue<br />__N__						posuere. Nulla massa urna, fermentum eget quam aliquet.</p>__N__					</header>__N__					<footer class=\"major\">__N__						<ul class=\"actions special\">__N__							<li><a href=\"generic.php\" class=\"buttonwebsite primary\">Get Started</a></li>__N__							<li><a href=\"generic.php\" class=\"buttonwebsite\">Learn More</a></li>__N__						</ul>__N__					</footer>__N__				</section>__N____N__		</div>__N____N__    <?php includeContainer(\'footer\'); ?>__N____N__</div>__N____N__', '', '0');
    9. 

  9. UPDATE llx_website SET fk_default_home = 4__+MAX_llx_website_page__ WHERE rowid = __WEBSITE_ID__;
    10. 

  10. -- Page ID 24 -> 5__+MAX_llx_website_page__ - Aliases menu --;
    11. 

  11. INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(5__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'menu', '', 'Menu', 'Menu common to all pages', 'fr', '', '', '1', '2019-08-15 00:03:43', '2020-02-21 10:27:17', null, '', 'menu', '', '<nav id=\"nav\">__N__	<ul>__N__		<li><a href=\"home.php\">Introduction</a></li>__N__		<li><a href=\"home.php#sectionfirst\">Section on home page</a></li>__N__		<li><a href=\"home.php#sectionsecond\">Another section on home page</a></li>__N__		<li><a href=\"generic.php\">Another page</a></li>__N__	</ul>__N__</nav>__N__', '', '0');
    12. 

  12. -- Page ID 25 -> 6__+MAX_llx_website_page__ - Aliases this-is-a-blog-post --;
    13. 

  13. INSERT INTO llx_website_page(rowid, fk_page, fk_website, pageurl, aliasalt, title, description, lang, image, keywords, status, date_creation, tms, import_key, grabbed_from, type_container, htmlheader, content, author_alias, allowed_in_frames) VALUES(6__+MAX_llx_website_page__, null, __WEBSITE_ID__, 'this-is-a-blog-post', '', 'This is a Blog post', 'This is a full meta description of the article', '', '', 'blog', '1', '2019-08-17 17:18:45', '2022-07-06 23:50:25', null, '', 'blogpost', '', '<!-- Enter here your HTML content. Add a section with an id tag and tag contenteditable=\"true\" if you want to use the inline editor for the content  -->__N__<section id=\"mysection1\" contenteditable=\"true\" style=\"background: #fff; color: #000;\">__N__    This is a blog post article...__N__</section>__N__', 'webmaster', '0');
    14. 

  14. 

  15. -- For Dolibarr v14+ --;
    16. 

  16. UPDATE llx_website SET lang = 'en' WHERE rowid = __WEBSITE_ID__;
    17. 

  17. UPDATE llx_website SET otherlang = '' WHERE rowid = __WEBSITE_ID__;
    18. 

  18.