Revision 1760
Added by Luisehahne over 12 years ago
upgrade-script.php | ||
---|---|---|
489 | 489 |
$sql .= 'WHERE `name`=\'no_results\''; |
490 | 490 |
echo ($database->query($sql)) ? ' $OK<br />' : ' $FAIL<br />'; |
491 | 491 |
} |
492 |
|
|
492 | 493 |
/********************************************************** |
493 |
* - Add field "redirect_type" to table "mod_menu_link" |
|
494 |
* has to be moved later to upgrade.php in modul menu_link, because modul can be removed |
|
495 |
*/ |
|
494 |
* - Add field "redirect_type" to table "mod_menu_link"
|
|
495 |
* has to be moved later to upgrade.php in modul menu_link, because modul can be removed
|
|
496 |
*/
|
|
496 | 497 |
$table_name = TABLE_PREFIX.'mod_menu_link'; |
497 | 498 |
$field_name = 'redirect_type'; |
498 | 499 |
$description = "INT NOT NULL DEFAULT '301' AFTER `target_page_id`"; |
... | ... | |
514 | 515 |
echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />"); |
515 | 516 |
|
516 | 517 |
/********************************************************** |
517 |
* - Add field "page_icon" to table "pages" |
|
518 |
*/ |
|
518 |
* - Add field "page_icon" to table "pages"
|
|
519 |
*/
|
|
519 | 520 |
$table_name = TABLE_PREFIX.'pages'; |
520 | 521 |
$field_name = 'page_icon'; |
521 | 522 |
$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `page_title`"; |
... | ... | |
528 | 529 |
} |
529 | 530 |
|
530 | 531 |
/********************************************************** |
531 |
* - Add field "tooltip" to table "pages" |
|
532 |
*/ |
|
533 |
$table_name = TABLE_PREFIX.'pages'; |
|
534 |
$field_name = 'tooltip'; |
|
535 |
$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `page_icon`"; |
|
536 |
if(!$database->field_exists($table_name,$field_name)) { |
|
537 |
echo "Adding field tooltip to pages table"; |
|
538 |
echo ($database->field_add($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />"); |
|
539 |
} else { |
|
540 |
echo "Modify field tooltip to pages table"; |
|
541 |
echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />"); |
|
542 |
} |
|
543 |
|
|
544 |
/********************************************************** |
|
545 | 532 |
* - Add field "page_code" to table "pages" |
546 | 533 |
*/ |
547 | 534 |
$table_name = TABLE_PREFIX.'pages'; |
... | ... | |
556 | 543 |
} |
557 | 544 |
|
558 | 545 |
/********************************************************** |
559 |
* - Add field "menu_icon_0" to table "pages" |
|
560 |
*/ |
|
546 |
* - Add field "menu_icon_0" to table "pages"
|
|
547 |
*/
|
|
561 | 548 |
$table_name = TABLE_PREFIX.'pages'; |
562 | 549 |
$field_name = 'menu_icon_0'; |
563 | 550 |
$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_title`"; |
... | ... | |
571 | 558 |
|
572 | 559 |
/********************************************************** |
573 | 560 |
* - Add field "menu_icon_1" to table "pages" |
574 |
*/ |
|
561 |
*/
|
|
575 | 562 |
$table_name = TABLE_PREFIX.'pages'; |
576 | 563 |
$field_name = 'menu_icon_1'; |
577 | 564 |
$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_0`"; |
... | ... | |
585 | 572 |
|
586 | 573 |
/********************************************************** |
587 | 574 |
* - Add field "tooltip" to table "pages" |
588 |
*/ |
|
575 |
*/
|
|
589 | 576 |
$table_name = TABLE_PREFIX.'pages'; |
590 | 577 |
$field_name = 'tooltip'; |
591 | 578 |
$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_1`"; |
... | ... | |
599 | 586 |
|
600 | 587 |
/********************************************************** |
601 | 588 |
* - Add field "admin_groups" to table "pages" |
602 |
*/ |
|
589 |
*/
|
|
603 | 590 |
$table_name = TABLE_PREFIX.'pages'; |
604 | 591 |
$field_name = 'admin_groups'; |
605 | 592 |
$description = "VARCHAR( 512 ) NOT NULL DEFAULT '1'"; |
... | ... | |
633 | 620 |
echo "Modify field viewing_users to pages table"; |
634 | 621 |
echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />"); |
635 | 622 |
|
623 |
|
|
624 |
/** |
|
625 |
* This part with changing in mod_wysiwyg will be removed in the final version |
|
626 |
* special workout for the tester |
|
627 |
*/ |
|
636 | 628 |
/********************************************************** |
637 | 629 |
* - Remove/add PRIMARY KEY from/to "section_id" from table "mod_wysiwygs" |
638 | 630 |
*/ |
639 | 631 |
$sTable = TABLE_PREFIX.'mod_wysiwyg'; |
640 | 632 |
$field_name = 'wysiwyg_id'; |
641 |
if(!$database->field_exists($sTable,$field_name)) {
|
|
633 |
if($database->field_exists($sTable,$field_name)) { |
|
642 | 634 |
echo "Remove PRIMARY KEY from table mod_wysiwygs"; |
643 |
$sql = 'ALTER TABLE `'.DB_NAME.'`.`'.$sTable.'` DROP PRIMARY KEY'; |
|
635 |
//ALTER TABLE `wb283_mod_wysiwyg` DROP `wysiwyg_id` |
|
636 |
$sql = 'ALTER TABLE `'.DB_NAME.'`.`'.$sTable.'` DROP `wysiwyg_id`'; |
|
644 | 637 |
echo ($database->query($sql) ? " $OK<br />" : " $FAIL!<br />"); |
645 | 638 |
|
646 |
echo "add new PRIMARY KEY to table mod_wysiwygs"; |
|
647 |
$sql = 'ALTER TABLE `'.$sTable.'` ADD `wysiwyg_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST';
|
|
648 |
echo ($database->query($sql) ? " $OK<br />" : " $FAIL!<br />"); |
|
639 |
// echo "add new PRIMARY KEY to table mod_wysiwygs";
|
|
640 |
// $sql = 'ALTER TABLE `'.$sTable.'` DROP `wysiwyg_id`';
|
|
641 |
// echo ($database->query($sql) ? " $OK<br />" : " $FAIL!<br />");
|
|
649 | 642 |
} |
643 |
echo "Change PRIMARY KEY from table mod_wysiwygs"; |
|
644 |
$sql = 'ALTER TABLE `'.DB_NAME.'`.`'.$sTable.'` ADD PRIMARY KEY (`section_id`)'; |
|
645 |
echo ($database->query($sql) ? " $OK<br />" : " $FAIL!<br />"); |
|
646 |
|
|
647 |
|
|
650 | 648 |
} |
651 | 649 |
|
652 | 650 |
/********************************************************** |
... | ... | |
683 | 681 |
///********************************************************** |
684 | 682 |
// * - Reformat/rebuild all existing access files |
685 | 683 |
// */ |
686 |
$msg[] = "All existing access files anew format";
|
|
684 |
$msg[] = "Refresh all existing access files ";
|
|
687 | 685 |
$sql = 'SELECT `page_id`,`root_parent`,`link`, `level` FROM `'.TABLE_PREFIX.'pages` ORDER BY `link`'; |
688 | 686 |
if (($oPage = $database->query($sql))) |
689 | 687 |
{ |
690 | 688 |
$x = 0; |
691 | 689 |
while (($page = $oPage->fetchRow(MYSQL_ASSOC))) |
692 | 690 |
{ |
693 |
$sql = 'UPDATE `'.TABLE_PREFIX.'pages` ' |
|
694 |
. 'SET `root_parent`='.$page['page_id'].' WHERE page_id = '.$page['page_id']; |
|
691 |
// Work out level |
|
692 |
$level = level_count($page['page_id']); |
|
693 |
// Work out root parent |
|
694 |
$root_parent = root_parent($page['page_id']); |
|
695 |
// Work out page trail |
|
696 |
$page_trail = get_page_trail($page['page_id']); |
|
697 |
// Update page with new level and link |
|
698 |
$sql = 'UPDATE `'.TABLE_PREFIX.'pages` SET '; |
|
699 |
$sql .= '`root_parent` = '.$root_parent.', '; |
|
700 |
$sql .= '`level` = '.$level.', '; |
|
701 |
$sql .= '`page_trail` = "'.$page_trail.'" '; |
|
702 |
$sql .= 'WHERE `page_id` = '.$page['page_id']; |
|
703 |
|
|
695 | 704 |
if(!$database->query($sql)) {} |
696 | 705 |
$filename = WB_PATH.PAGES_DIRECTORY.$page['link'].PAGE_EXTENSION; |
697 | 706 |
$msg = create_access_file($filename, $page['page_id'], $page['level']); |
Also available in: Unified diff
! fallback changes in wysiwyg Revision 1754
because it's required that section_id is the PRIMARY KEY
Fallback will be done in upgrade-script until the final version
! build in extra input seo title in page settings
! beginning rebranding wb_theme