<?php

/**

* This file implements creation of DB tables

*

* b2evolution - {@link http://b2evolution.net/}

* Released under GNU GPL License - {@link http://b2evolution.net/about/gnu-gpl-license}

* @copyright (c)2003-2020 by Francois Planque - {@link http://fplanque.com/}

* Parts of this file are copyright (c)2004 by Vegar BERG GULDAL - {@link http://funky-m.com/}

* Parts of this file are copyright (c)2005 by Jason EDGECOMBE

*

* @package install

*/

if( !defined('EVO_MAIN_INIT') ) die( 'Please, do not access this page directly.' );

load_class( 'users/model/_group.class.php', 'Group' );

load_funcs( 'collections/model/_category.funcs.php' );

load_class( 'users/model/_organization.class.php', 'Organization' );

load_funcs( 'collections/_demo_content.funcs.php' );

/**

* Used for fresh install

*/

function create_tables()

{

global $inc_path;

// Load DB schema from modules

load_db_schema();

// Update the progress bar status

update_install_progress_bar();

load_funcs('_core/model/db/_upgrade.funcs.php');

// Alter DB to match DB schema:

install_make_db_schema_current( true );

}

/**

* Insert all default data:

*/

function create_default_data()

{

global $admins_Group, $moderators_Group, $editors_Group, $users_Group, $suspect_Group, $spam_Group, $blogb_Group;

global $DB, $locales, $current_locale, $baseurl;

// This will install all sorts of additional things... for testing purposes:

global $install_test_features, $create_sample_contents;

// Inserting sample data triggers events: instead of checking if $Plugins is an object there, just use a fake one..

load_class('plugins/model/_plugins_admin_no_db.class.php', 'Plugins_admin_no_DB' );

global $Plugins;

$Plugins = new Plugins_admin_no_DB(); // COPY

// added in 0.8.7

task_begin( 'Creating default blacklist entries... ' );

// This string contains antispam information that is obfuscated because some hosting

// companies prevent uploading PHP files containing "spam" strings.

// pre_dump(get_antispam_query());

$query = get_antispam_query();

$DB->query( $query );

task_end();

task_begin( 'Creating default antispam IP ranges... ' );

$DB->query( '

INSERT INTO T_antispam__iprange ( aipr_IPv4start, aipr_IPv4end, aipr_status )

VALUES ( '.$DB->quote( ip2int( '127.0.0.0' ) ).', '.$DB->quote( ip2int( '127.0.0.255' ) ).', "trusted" ),

( '.$DB->quote( ip2int( '10.0.0.0' ) ).', '.$DB->quote( ip2int( '10.255.255.255' ) ).', "trusted" ),

( '.$DB->quote( ip2int( '172.16.0.0' ) ).', '.$DB->quote( ip2int( '172.31.255.255' ) ).', "trusted" ),

( '.$DB->quote( ip2int( '192.168.0.0' ) ).', '.$DB->quote( ip2int( '192.168.255.255' ) ).', "trusted" )

' );

task_end();

// added in 0.8.9

task_begin( 'Creating default groups... ' );

$admins_Group = new Group(); // COPY !

$admins_Group->set( 'name', 'Administrators' );

$admins_Group->set( 'level', 10 );

$admins_Group->set( 'perm_blogs', 'editall' );

$admins_Group->set( 'perm_stats', 'edit' );

$admins_Group->set( 'perm_xhtml_css_tweaks', 1 );

$admins_Group->dbinsert();

$moderators_Group = new Group(); // COPY !

$moderators_Group->set( 'name', 'Moderators' );

$moderators_Group->set( 'level', 8 );

$moderators_Group->set( 'perm_blogs', 'viewall' );

$moderators_Group->set( 'perm_stats', 'user' );

$moderators_Group->set( 'perm_xhtml_css_tweaks', 1 );

$moderators_Group->dbinsert();

$editors_Group = new Group(); // COPY !

$editors_Group->set( 'name', 'Editors' );

$editors_Group->set( 'level', 6 );

$editors_Group->set( 'perm_blogs', 'user' );

$editors_Group->set( 'perm_stats', 'none' );

$editors_Group->set( 'perm_xhtml_css_tweaks', 1 );

$editors_Group->dbinsert();

$users_Group = new Group(); // COPY !

$users_Group->set( 'name', 'Normal Users' );

$users_Group->set( 'level', 4 );

$users_Group->set( 'perm_blogs', 'user' );

$users_Group->set( 'perm_stats', 'none' );

$users_Group->dbinsert();

$suspect_Group = new Group(); // COPY !

$suspect_Group->set( 'name', 'Misbehaving/Suspect Users' );

$suspect_Group->set( 'level', 2 );

$suspect_Group->set( 'perm_blogs', 'user' );

$suspect_Group->set( 'perm_stats', 'none' );

$suspect_Group->dbinsert();

$spam_Group = new Group(); // COPY !

$spam_Group->set( 'name', 'Spammers/Restricted Users' );

$spam_Group->set( 'level', 1 );

$spam_Group->set( 'perm_blogs', 'user' );

$spam_Group->set( 'perm_stats', 'none' );

$spam_Group->dbinsert();

task_end();

task_begin( 'Creating groups for user field definitions... ' );

$DB->query( "

INSERT INTO T_users__fieldgroups ( ufgp_name, ufgp_order )

VALUES ( 'About me', '1' ),

( 'Instant Messaging', '2' ),

( 'Phone', '3' ),

( 'Web', '4' ),

( 'Address', '5' ),

( 'Administrative', '6' )" );

task_end();

task_begin( 'Creating user field definitions... ' );

// fp> Anyone, please add anything you can think of. It's better to start with a large list that update it progressively.

$DB->query( "

INSERT INTO T_users__fielddefs (ufdf_ufgp_ID, ufdf_type, ufdf_name, ufdf_options, ufdf_required, ufdf_visibility, ufdf_duplicated, ufdf_order, ufdf_suggest, ufdf_code, ufdf_icon_name)

VALUES ( 1, 'text', 'Micro bio', NULL, 'recommended', 'unrestricted', 'forbidden', '1', '0', 'microbio', 'fa fa-info-circle' ),

( 1, 'word', 'I like', NULL, 'recommended', 'unrestricted', 'list', '2', '1', 'ilike', 'fa fa-thumbs-o-up' ),

( 1, 'word', 'I don\'t like', NULL, 'recommended', 'unrestricted', 'list', '3', '1', 'idontlike', 'fa fa-thumbs-o-down' ),

( 1, 'list', 'Industry', 'Energy, Utilities & Resources

Financial Services

Health Services

Hospitality & Tourism

Industrial Manufacturing

Pharma & Life Sciences

Public Sector

Real Estate

Retail & Consumer Goods

Sports Business Advisory

Technology, Media & Telecom', 'recommended', 'unrestricted', 'allowed', '4', '1', 'industry', 'fa fa-industry' ),

( 2, 'email', 'MSN/Live IM', NULL, 'optional', 'unrestricted', 'allowed', '1', '0', 'msnliveim', NULL ),

( 2, 'word', 'Yahoo IM', NULL, 'optional', 'unrestricted', 'allowed', '2', '0', 'yahooim', 'fa fa-yahoo' ),

( 2, 'word', 'AOL AIM', NULL, 'optional', 'unrestricted', 'allowed', '3', '0', 'aolaim', NULL ),

( 2, 'number', 'ICQ ID', NULL, 'optional', 'unrestricted', 'allowed', '4', '0', 'icqid', NULL ),

( 2, 'phone', 'Skype', NULL, 'optional', 'private', 'allowed', '5', '0', 'skype', 'fa fa-skype' ),

( 2, 'phone', 'WhatsApp', NULL, 'optional', 'private', 'allowed', '6', '0', 'whatsapp', 'fa fa-whatsapp' ),

( 3, 'phone', 'Main phone', NULL, 'optional', 'private', 'forbidden', '1', '0', 'mainphone', 'fa fa-phone' ),

( 3, 'phone', 'Cell phone', NULL, 'optional', 'private', 'allowed', '2', '0', 'cellphone', 'fa fa-mobile-phone' ),

( 3, 'phone', 'Office phone', NULL, 'optional', 'private', 'allowed', '3', '0', 'officephone', 'fa fa-phone' ),

( 3, 'phone', 'Home phone', NULL, 'optional', 'private', 'allowed', '4', '0', 'homephone', 'fa fa-phone' ),

( 3, 'phone', 'Office FAX', NULL, 'optional', 'private', 'allowed', '5', '0', 'officefax', 'fa fa-fax' ),

( 3, 'phone', 'Home FAX', NULL, 'optional', 'private', 'allowed', '6', '0', 'homefax', 'fa fa-fax' ),

( 4, 'url', 'Twitter', NULL, 'recommended', 'unrestricted', 'forbidden', '1', '0', 'twitter', 'fa fa-twitter' ),

( 4, 'url', 'Facebook', NULL, 'recommended', 'unrestricted', 'forbidden', '2', '0', 'facebook', 'fa fa-facebook' ),

( 4, 'url', 'Linkedin', NULL, 'optional', 'unrestricted', 'forbidden', '4', '0', 'linkedin', 'fa fa-linkedin fa-x-linkedin--nudge' ),

( 4, 'url', 'GitHub', NULL, 'optional', 'unrestricted', 'forbidden', '5', '0', 'github', 'fa fa-github-alt' ),

( 4, 'url', 'Website', NULL, 'optional', 'unrestricted', 'allowed', '6', '0', 'website', NULL ),

( 4, 'url', 'Blog', NULL, 'optional', 'unrestricted', 'allowed', '7', '0', 'blog', NULL ),

( 4, 'url', 'Myspace', NULL, 'optional', 'unrestricted', 'forbidden', '8', '0', 'myspace', NULL ),

( 4, 'url', 'Flickr', NULL, 'optional', 'unrestricted', 'forbidden', '9', '0', 'flickr', 'fa fa-flickr' ),

( 4, 'url', 'YouTube', NULL, 'optional', 'unrestricted', 'forbidden', '10', '0', 'youtube', 'fa fa-youtube' ),

( 4, 'url', 'Digg', NULL, 'optional', 'unrestricted', 'forbidden', '11', '0', 'digg', 'fa fa-digg' ),

( 4, 'url', 'StumbleUpon', NULL, 'optional', 'unrestricted', 'forbidden', '12', '0', 'stumbleupon', 'fa fa-stumbleupon' ),

( 4, 'url', 'Pinterest', NULL, 'optional', 'unrestricted', 'forbidden', '13', '0', 'pinterest', 'fa fa-pinterest-p' ),

( 4, 'url', 'SoundCloud', NULL, 'optional', 'unrestricted', 'forbidden', '14', '0', 'soundcloud', 'fa fa-soundcloud' ),

( 4, 'url', 'Yelp', NULL, 'optional', 'unrestricted', 'forbidden', '15', '0', 'yelp', 'fa fa-yelp' ),

( 4, 'url', 'PayPal', NULL, 'optional', 'unrestricted', 'forbidden', '16', '0', 'paypal', 'fa fa-paypal' ),

( 4, 'url', '500px', NULL, 'optional', 'unrestricted', 'forbidden', '17', '0', '500px', 'fa fa-500px' ),

( 4, 'url', 'Amazon', NULL, 'optional', 'unrestricted', 'forbidden', '18', '0', 'amazon', 'fa fa-amazon' ),

( 4, 'url', 'Instagram', NULL, 'optional', 'unrestricted', 'forbidden', '19', '0', 'instagram', 'fa fa-instagram' ),

( 4, 'url', 'Vimeo', NULL, 'optional', 'unrestricted', 'forbidden', '20', '0', 'vimeo', 'fa fa-vimeo' ),

( 5, 'text', 'Main address', NULL, 'optional', 'private', 'forbidden', '1', '0', 'mainaddress', 'fa fa-building' ),

( 5, 'text', 'Home address', NULL, 'optional', 'private', 'forbidden', '2', '0', 'homeaddress', 'fa fa-home' ),

( 6, 'text', 'Admin notes', NULL, 'recommended', 'admin', 'forbidden', '1', '0', 'adminnotes', 'fa fa-edit' )" );

if( is_pro() )

{ // Install default user field definitions for PRO version:

load_funcs( '_core/_pro_features.funcs.php' );

pro_install_default_user_fields();

}

task_end();

// don't change order of the following two functions as countries has relations to currencies

create_default_currencies();

create_default_countries();

create_default_regions();

// Do not create organization yet

global $user_org_IDs;

$user_org_IDs = NULL;

task_begin( 'Creating admin user... ' );

global $timestamp, $admin_email, $default_locale, $default_country, $install_login, $install_password;

global $random_password;

// Set default country from locale code

$country_code = explode( '-', $default_locale );

if( isset( $country_code[1] ) )

{

$default_country = $DB->get_var( '

SELECT ctry_ID

FROM T_regional__country

WHERE ctry_code = '.$DB->quote( strtolower( $country_code[1] ) ) );

}

if( !isset( $install_password ) )

{

$random_password = generate_random_passwd(); // no ambiguous chars

}

else

{

$random_password = $install_password;

}

global $admin_user;

$admin_user = create_user( array(

'login' => isset( $install_login ) ? $install_login : 'admin',

'firstname' => 'Johnny',

'lastname' => 'Admin',

'level' => 10,

'gender' => 'M',

'group_ID' => $admins_Group->ID,

'org_IDs' => $user_org_IDs,

'org_roles' => array( 'King of Spades' ),

'org_priorities' => array( 0 ),

'fields' => array(

'microbio' => 'I am the demo administrator of this site.'."\n".'I love having so much power!',

'website' => 'http://b2evolution.net/',

'twitter' => 'https://twitter.com/b2evolution/',

'facebook' => 'https://www.facebook.com/b2evolution',

'linkedin' => 'https://www.linkedin.com/company/b2evolution-net',

'github' => 'https://github.com/b2evolution/b2evolution',

)

) );

task_end();

// Activating multiple sessions and email message form for administrator, and set other user settings

task_begin( 'Set settings for administrator user... ' );

$DB->query( "

INSERT INTO T_users__usersettings ( uset_user_ID, uset_name, uset_value )

VALUES ( 1, 'login_multiple_sessions', '1' ),

( 1, 'enable_email', '1' ),

( 1, 'created_fromIPv4', '".ip2int( '127.0.0.1' )."' ),

( 1, 'user_registered_from_domain', 'localhost' )" );

task_end();

// added in Phoenix-Alpha

task_begin( 'Creating default Post Types... ' );

$post_types = array();

$post_types[] = array(

'name' => 'Post',

'schema' => 'Article',

);

$post_types[] = array(

'name' => 'Recipe',

'template_full' => 'recipe_content_full',

);

$post_types[] = array(

'name' => 'Post with Custom Fields',

);

$post_types[] = array(

'name' => 'Child Post',

'use_parent' => 'required',

);

$post_types[] = array(

'name' => 'Podcast Episode',

'podcast' => 1,

);

$post_types[] = array(

'name' => 'Photo Album',

);

$post_types[] = array(

'name' => 'Manual Page',

'use_short_title'=> 'optional',

'allow_html' => 0,

);

$post_types[] = array(

'name' => 'Forum Topic',

'allow_html' => 0,

);

$post_types[] = array(

'name' => 'Bug Report',

'allow_html' => 0,

);

$post_types[] = array(

'name' => 'Standalone Page',

'usage' => 'page',

'template_name' => 'page',

'perm_level' => 'restricted',

'use_comments' => 0,

'allow_featured' => 0,

);

$post_types[] = array(

'name' => 'Widget Page',

'usage' => 'widget-page',

'template_name' => 'widget_page',

'perm_level' => 'admin',

'use_text' => 'never',

'allow_html' => 0,

'allow_breaks' => 0,

'allow_attachments' => 0,

'allow_featured' => 0,

'use_comments' => 0,

'use_coordinates'=> 'optional',

);

$post_types[] = array(

'name' => 'Intro-Front',

'usage' => 'intro-front',

'template_name' => NULL,

'allow_breaks' => 0,

'allow_featured' => 0,

'perm_level' => 'restricted',

'allow_disabling_comments' => 1,

);

$post_types[] = array(

'name' => 'Intro-Main',

'usage' => 'intro-main',

'template_name' => NULL,

'allow_breaks' => 0,

'allow_featured' => 0,

'perm_level' => 'restricted',

'allow_disabling_comments' => 1,

);

$post_types[] = array(

'name' => 'Intro-Cat',

'usage' => 'intro-cat',

'template_name' => NULL,

'allow_breaks' => 0,

'allow_featured' => 0,

'perm_level' => 'restricted',

'allow_disabling_comments' => 1,

);

$post_types[] = array(

'name' => 'Intro-Tag',

'usage' => 'intro-tag',

'template_name' => NULL,

'allow_breaks' => 0,

'allow_featured' => 0,

'perm_level' => 'restricted',

'allow_disabling_comments' => 1,

);

$post_types[] = array(

'name' => 'Intro-Sub',

'usage' => 'intro-sub',

'template_name' => NULL,

'allow_breaks' => 0,

'allow_featured' => 0,

'perm_level' => 'restricted',

'allow_disabling_comments' => 1,

);

$post_types[] = array(

'name' => 'Intro-All',

'usage' => 'intro-all',

'template_name' => NULL,

'allow_breaks' => 0,

'allow_featured' => 0,

'perm_level' => 'restricted',

'allow_disabling_comments' => 1,

);

$post_types[] = array(

'name' => 'Content Block',

'usage' => 'content-block',

'template_name' => NULL,

'allow_breaks' => 0,

'allow_featured' => 0,

'use_comments' => 0,

);

$post_types[] = array(

'name' => 'Text Ad',

'usage' => 'content-block',

'template_name' => NULL,

'allow_breaks' => 0,

'allow_featured' => 0,

'use_comments' => 0,

);

$post_types[] = array(

'name' => 'Sidebar link',

'usage' => 'special',

'template_name' => NULL,

'perm_level' => 'admin',

'allow_disabling_comments' => 1,

'allow_featured' => 0,

);

$post_types[] = array(

'name' => 'Advertisement',

'usage' => 'special',

'template_name' => NULL,

'perm_level' => 'admin',

'allow_featured' => 0,

);

$post_types[] = array(

'name' => 'Terms & Conditions',

'usage' => 'special',

'template_name' => NULL,

'allow_breaks' => 0,

'allow_featured' => 0,

'perm_level' => 'admin',

'description' => 'Use this post type for terms & conditions of the site.',

'use_text' => 'required',

'use_tags' => 'never',

'use_excerpt' => 'never',

'use_url' => 'never',

'use_parent' => 'never',

'use_title_tag' => 'never',

'use_meta_desc' => 'never',

'use_meta_keywds' => 'never',

'use_comments' => 0,

'allow_closing_comments' => 0,

'use_comment_expiration' => 'never',

);

$post_types[] = array(

'name' => 'Product',

'schema' => 'Product',

);

$post_types[] = array(

'name' => 'Review',

'schema' => 'Review',

);

$post_types[] = array(

'name' => 'Homepage Content Tab',

'usage' => 'post',

'use_short_title' => 'optional',

);

$post_types[] = array(

'name' => 'Task',

'allow_html' => 0,

'front_order_workflow' => 20,

);

// Default settings:

$post_type_default_settings = array(

'name' => '',

'description' => NULL,

'usage' => 'post',

'template_full' => NULL,

'template_name' => 'single',

'perm_level' => 'standard',

'use_short_title' => 'never',

'short_title_maxlen' => 30,

'title_maxlen' => 100,

'allow_html' => 1,

'allow_breaks' => 1,

'allow_attachments' => 1,

'allow_featured' => 1,

'use_text' => 'optional',

'use_tags' => 'optional',

'use_excerpt' => 'optional',

'use_url' => 'optional',

'podcast' => 0,

'use_parent' => 'never',

'use_title_tag' => 'optional',

'use_meta_desc' => 'optional',

'use_meta_keywds' => 'optional',

'use_comments' => 1,

'allow_closing_comments' => 1,

'allow_disabling_comments' => 0,

'use_comment_expiration' => 'optional',

'schema' => NULL,

'use_coordinates' => 'never',

'front_order_title' => 10,

'front_order_attachments' => 30,

'front_order_workflow' => NULL,

'front_order_text' => 80,

'front_order_location' => 90,

);

$post_types_sql = 'INSERT INTO T_items__type ( ityp_'.implode( ', ityp_', array_keys( $post_type_default_settings ) ).' ) VALUES ';

foreach( $post_types as $p => $post_type )

{

$post_type = array_merge( $post_type_default_settings, $post_type );

$post_types_sql .= '( '.$DB->quote( $post_type ).' )';

if( $p != count( $post_types ) - 1 )

{

$post_types_sql .= ',';

}

}

// Insert item types:

$DB->query( $post_types_sql );

// Item type custom fields:

$parent_ityp_ID = 3;

$child_ityp_ID = 4;

$recipe_ityp_ID = 2;

$product_ityp_ID = 21;

$review_ityp_ID = 22;

$forum_topic_ityp_ID = 8;

$custom_fields = array(

// for Item Type "Post with Custom Fields":

array(

'label' => T_('Image 1'),

'name' => 'image_1',

'type' => 'image',

'order' => 110,

'note' => T_('Enter a link ID'),

'format' => 'fit-192x192',

'link' => 'linkpermzoom',

'line_highlight' => 'never',

'green_highlight' => 'never',

),

array(

'label' => T_('First numeric field'),

'name' => 'first_numeric_field',

'type' => 'double',

'order' => 120,

'note' => T_('Enter a number'),

'cell_class' => 'right',

),

array(

'label' => T_('Second numeric field'),

'name' => 'second_numeric_field',

'type' => 'double',

'order' => 140,

'note' => T_('Enter a number'),

'cell_class' => 'right',

),

array(

'label' => T_('USD Price'),

'name' => 'usd_price',

'type' => 'double',

'order' => 180,

'note' => T_('Enter a number'),

'format' => '$ 0 0.00[.green];$ 0 0.00[.red]',

'cell_class' => 'right',

'green_highlight' => 'lowest',

),

array(

'label' => T_('EUR Price'),

'name' => 'eur_price',

'type' => 'double',

'order' => 190,

'note' => T_('Enter a number'),

'format' => '0 0.00 €',

'cell_class' => 'right',

'green_highlight' => 'lowest',

),

array(

'label' => T_('First string field'),

'name' => 'first_string_field',

'type' => 'varchar',

'order' => 130,

'note' => T_('Enter a string'),

),

array(

'label' => T_('Multiline plain text field'),

'name' => 'multiline_plain_text_field',

'type' => 'text',

'order' => 160,

'note' => T_('Enter multiple lines'),

),

array(

'label' => T_('Multiline HTML field'),

'name' => 'multiline_html_field',

'type' => 'html',

'order' => 150,

'note' => T_('Enter HTML code'),

),

array(

'label' => T_('URL field'),

'name' => 'url_field',

'type' => 'url',

'order' => 170,

'note' => T_('Enter an URL (absolute or relative)'),

'link' => 'fieldurl',

),

array(

'label' => T_('Checkmark field'),

'name' => 'checkmark_field',

'type' => 'double',

'order' => 200,

'note' => T_('1 = Yes; 0 = No'),

'format' => '#yes#;;#no#;n/a',

'cell_class' => 'right',

),

array(

'label' => TD_('Numeric Average'),

'name' => 'numeric_average',

'type' => 'computed',

'order' => 210,

'cell_class' => 'right',

'formula' => '($first_numeric_field$+$second_numeric_field$)/2',

),

// for Item Type "Child Post":

array(

'ityp_ID' => $child_ityp_ID,

'label' => T_('Image 1'),

'name' => 'image_1',

'type' => 'image',

'order' => 110,

'note' => T_('Enter a link ID'),

'format' => 'fit-192x192',

'link' => 'linkpermzoom',

'line_highlight' => 'never',

'green_highlight' => 'never',

),

array(

'ityp_ID' => $child_ityp_ID,

'label' => T_('First numeric field'),

'name' => 'first_numeric_field',

'type' => 'double',

'order' => 120,

'note' => T_('Enter a number'),

'cell_class' => 'right',

),

array(

'ityp_ID' => $child_ityp_ID,

'label' => T_('First string field'),

'name' => 'first_string_field',

'type' => 'varchar',

'order' => 130,

'note' => T_('Enter a string'),

),

array(

'ityp_ID' => $child_ityp_ID,

'label' => T_('Checkmark field'),

'name' => 'checkmark_field',

'type' => 'double',

'order' => 140,

'note' => T_('1 = Yes; 0 = No'),

'format' => '#yes#;;#no#;n/a',

'cell_class' => 'right',

),

// for Item Type "Recipe":

array(

'ityp_ID' => $recipe_ityp_ID,

'label' => TD_('Course'),

'name' => 'course',

'type' => 'varchar',

'order' => 110,

'note' => T_('E-g: ').'"'.TD_('Dessert').'"',

'header_class' => '',

'cell_class' => '',

),

array(

'ityp_ID' => $recipe_ityp_ID,

'label' => TD_('Cuisine'),

'name' => 'cuisine',

'type' => 'varchar',

'order' => 120,

'note' => T_('E-g: ').'"'.TD_('Italian').'"',

'header_class' => '',

'cell_class' => '',

),

array(

'ityp_ID' => $recipe_ityp_ID,

'label' => TD_('Servings'),

'name' => 'servings',

'order' => 130,

'note' => TD_('people'),

'format' => sprintf( TD_('%d people'), 0 ),

'header_class' => '',

'cell_class' => '',

),

array(

'ityp_ID' => $recipe_ityp_ID,

'label' => TD_('Prep Time'),

'name' => 'prep_time',

'order' => 140,

'note' => TD_('minutes'),

'format' => sprintf( TD_('%s minutes'), 0 ),

'header_class' => '',

'cell_class' => '',

),

array(

'ityp_ID' => $recipe_ityp_ID,

'label' => TD_('Cook Time'),

'name' => 'cook_time',

'order' => 150,

'note' => TD_('minutes'),

'format' => sprintf( TD_('%s minutes'), 0 ),

'header_class' => '',

'cell_class' => '',

),

array(

'ityp_ID' => $recipe_ityp_ID,

'label' => TD_('Passive Time'),

'name' => 'passive_time',

'order' => 160,

'note' => TD_('minutes'),

'format' => sprintf( TD_('%s minutes'), 0 ),

'header_class' => '',

'cell_class' => '',

),

array(

'ityp_ID' => $recipe_ityp_ID,

'label' => TD_('Total time'),

'name' => 'total_time',

'type' => 'computed',

'order' => 170,

'format' => sprintf( TD_('%s minutes'), 0 ),

'formula' => '$prep_time$ + $cook_time$ + $passive_time$',

'header_class' => '',

'cell_class' => '',

),

array(

'ityp_ID' => $recipe_ityp_ID,

'label' => TD_('Ingredients'),

'name' => 'ingredients',

'type' => 'text',

'order' => 180,

'header_class' => '',

'cell_class' => '',

),

// for Item Type "Product":

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('Brand'),

'name' => 'brand',

'schema_prop' => 'brand',

'type' => 'varchar',

'order' => 110,

),

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('SKU'),

'name' => 'sku',

'schema_prop' => 'sku',

'type' => 'varchar',

'order' => 120,

),

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('Price'),

'name' => 'price',

'schema_prop' => 'offers.price',

'type' => 'double',

'order' => 130,

'format' => '$ 0 0.00',

'cell_class' => 'right',

),

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('Currency'),

'name' => 'currency',

'schema_prop' => 'offers.priceCurrency',

'type' => 'varchar',

'order' => 140,

'note' => T_('in three-letter ISO 4217 format'),

),

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('Availability'),

'name' => 'availability',

'schema_prop' => 'offers.availability',

'type' => 'varchar',

'order' => 150,

),

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('Color'),

'name' => 'item_color',

'schema_prop' => 'color',

'type' => 'varchar',

'order' => 160,

),

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('Package total weight'),

'name' => 'package_total_weight',

'type' => 'double',

'order' => 170,

'note' => T_('Kg'),

'cell_class' => 'right',

),

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('Package length'),

'name' => 'package_length',

'type' => 'double',

'order' => 180,

'note' => T_('cm'),

'cell_class' => 'right',

),

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('Package width'),

'name' => 'package_width',

'type' => 'double',

'order' => 190,

'note' => T_('cm'),

'cell_class' => 'right',

),

array(

'ityp_ID' => $product_ityp_ID,

'label' => T_('Package height'),

'name' => 'package_height',

'type' => 'double',

'order' => 200,

'note' => T_('cm'),

'cell_class' => 'right',

),

// for Item Type "Review":

array(

'ityp_ID' => $review_ityp_ID,

'label' => T_('Item reviewed'),

'name' => 'item_reviewed_name',

'schema_prop' => 'itemReviewed.name',

'type' => 'varchar',

'order' => 110,

),

array(

'ityp_ID' => $review_ityp_ID,

'label' => T_('Rating value'),

'name' => 'review_rating_value',

'schema_prop' => 'reviewRating.ratingValue',

'type' => 'double',

'order' => 120,

'note' => T_('Rating must be a value between 1 and 5 with 5 being the highest.'),

),

);

// Default settings for custom fields:

$custom_field_default_settings = array(

'ityp_ID' => $parent_ityp_ID,

'label' => '',

'name' => '',

'schema_prop' => NULL,

'type' => 'double',

'order' => '',

'note' => NULL,

'format' => NULL,

'formula' => NULL,

'header_class' => 'right nowrap',

'cell_class' => 'center',

'link' => 'nolink',

'line_highlight' => 'differences',

'green_highlight' => 'never',

'red_highlight' => 'never',

);

// Insert item type custom fields:

$custom_fields_sql = 'INSERT INTO T_items__type_custom_field ( itcf_'.implode( ', itcf_', array_keys( $custom_field_default_settings ) ).' ) VALUES ';

foreach( $custom_fields as $c => $custom_field )

{

$custom_field = array_merge( $custom_field_default_settings, $custom_field );

$custom_fields_sql .= '( '.$DB->quote( $custom_field ).' )';

if( $c != count( $custom_fields ) - 1 )

{

$custom_fields_sql .= ',';

}

}

$DB->query( $custom_fields_sql );

task_end();

task_begin( 'Creating default Post Statuses... ' );

$post_status_with_order = array(" ( 'New', 10 ) ", " ( 'In Progress', 20 ) ", " ( 'Duplicate', 30 ) ", " ( 'Not A Bug', 40 ) ", " ( 'In Review', 50 ) ", " ( 'Fixed', 60 ) ", " ( 'Closed', 70 ) ", " ( 'OK', 80 ) ", );

$DB->query( "INSERT INTO T_items__status ( pst_name, pst_order ) VALUES ". implode( ",", $post_status_with_order ) );

task_end();

task_begin( 'Creating default post status and post type associations...' );

// Enable all post statuses for post type Bug Report

$DB->query( 'INSERT INTO T_items__status_type (its_pst_ID, its_ityp_ID)

( SELECT pst_ID, ityp_ID FROM T_items__type, T_items__status WHERE ityp_name = "Bug Report" )' );

// Enable post status 'New', 'Duplicate', 'In Review' and 'OK' for all post types

$DB->query( 'INSERT IGNORE INTO T_items__status_type (its_pst_ID, its_ityp_ID)

( SELECT pst_ID, ityp_ID FROM T_items__type, T_items__status WHERE pst_name IN ( "New", "Duplicate", "In Review", "OK" ) )' );

task_end();

// added in Phoenix-Beta

task_begin( 'Creating default file types... ' );

// Contribs: feel free to add more types here...

// TODO: dh> shouldn't they get localized to the app's default locale? fp> ftyp_name, yes

$DB->query( "INSERT INTO T_filetypes

(ftyp_ID, ftyp_extensions, ftyp_name, ftyp_mimetype, ftyp_icon, ftyp_viewtype, ftyp_allowed)

VALUES

(1, 'gif', 'GIF image', 'image/gif', 'file_image', 'image', 'any'),

(2, 'png', 'PNG image', 'image/png', 'file_image', 'image', 'any'),

(3, 'jpg jpeg', 'JPEG image', 'image/jpeg', 'file_image', 'image', 'any'),

(4, 'txt', 'Text file', 'text/plain', 'file_document', 'text', 'registered'),

(5, 'htm html', 'HTML file', 'text/html', 'file_www', 'browser', 'admin'),

(6, 'pdf', 'PDF file', 'application/pdf', 'file_pdf', 'browser', 'registered'),

(7, 'doc docx', 'Microsoft Word file', 'application/msword', 'file_doc', 'external', 'registered'),

(8, 'xls xlsx', 'Microsoft Excel file', 'application/vnd.ms-excel', 'file_xls', 'external', 'registered'),

(9, 'ppt pptx', 'Powerpoint', 'application/vnd.ms-powerpoint', 'file_ppt', 'external', 'registered'),

(10, 'pps', 'Slideshow', 'pps', 'file_pps', 'external', 'registered'),

(11, 'zip', 'ZIP archive', 'application/zip', 'file_zip', 'external', 'registered'),

(12, 'php php3 php4 php5 php6', 'PHP script', 'application/x-httpd-php', 'file_php', 'text', 'admin'),

(13, 'css', 'Style sheet', 'text/css', 'file_document', 'text', 'registered'),

(14, 'mp3', 'MPEG audio file', 'audio/mpeg', 'file_sound', 'browser', 'registered'),

(15, 'm4a', 'MPEG audio file', 'audio/x-m4a', 'file_sound', 'browser', 'registered'),

(16, 'mp4 f4v', 'MPEG video', 'video/mp4', 'file_video', 'browser', 'registered'),

(17, 'mov', 'Quicktime video', 'video/quicktime', 'file_video', 'browser', 'registered'),

(18, 'm4v', 'MPEG video file', 'video/x-m4v', 'file_video', 'browser', 'registered'),

(19, 'flv', 'Flash video file', 'video/x-flv', 'file_video', 'browser', 'registered'),

(20, 'swf', 'Flash video file', 'application/x-shockwave-flash', 'file_video', 'browser', 'admin'),

(21, 'webm', 'WebM video file', 'video/webm', 'file_video', 'browser', 'registered'),

(22, 'ogv', 'Ogg video file', 'video/ogg', 'file_video', 'browser', 'registered'),

(23, 'm3u8', 'M3U8 video file', 'application/x-mpegurl', 'file_video', 'browser', 'registered'),

(24, 'xml', 'XML file', 'application/xml', 'file_www', 'browser', 'admin'),

(25, 'md', 'Markdown text file', 'text/plain', 'file_document', 'text', 'registered'),

(26, 'csv', 'CSV file', 'text/plain', 'file_document', 'text', 'registered'),

(27, 'svg', 'SVG file', 'image/svg+xml', 'file_document', 'image', 'admin'),

(28, 'ico', 'ICO image', 'image/x-icon', 'file_image', 'image', 'admin')

" );

task_end();

// Insert default locales into T_locales.

create_default_locales();

// Insert default settings into T_settings.

create_default_settings();

// Create default scheduled jobs

create_default_jobs();

// Create default templates

create_default_templates();

task_begin( 'Creating default "help" slug... ' );

$DB->query( '

INSERT INTO T_slug( slug_title, slug_type )

VALUES( "help", "help" )', 'Add "help" slug' );

task_end();

// Create the 'Default' goal category which must always exists and which is not deletable

// The 'Default' category ID will be always 1 because it will be always the first entry in the T_track__goalcat table

task_begin( 'Creating default goal category... ' );

$DB->query( 'INSERT INTO T_track__goalcat ( gcat_name, gcat_color )

VALUES ( '.$DB->quote( 'Default' ).', '.$DB->quote( '#999999' ).' )' );

task_end();

// Update the progress bar status

update_install_progress_bar();

install_basic_skins();

install_basic_plugins();

return true;

}

/**

* Create default currencies

*

*/

function create_default_currencies( $table_name = 'T_regional__currency' )

{

global $DB;

task_begin( 'Creating default currencies... ' );

$DB->query( "

INSERT INTO $table_name (curr_ID, curr_code, curr_shortcut, curr_name)

VALUES

(1, 'AFN', '&#x60b;', 'Afghani'),

(2, 'EUR', '&euro;', 'Euro'),

(3, 'ALL', 'Lek', 'Lek'),

(4, 'DZD', 'DZD', 'Algerian Dinar'),

(5, 'USD', '$', 'US Dollar'),

(6, 'AOA', 'AOA', 'Kwanza'),

(7, 'XCD', '$', 'East Caribbean Dollar'),

(8, 'ARS', '$', 'Argentine Peso'),

(9, 'AMD', 'AMD', 'Armenian Dram'),

(10, 'AWG', '&fnof;', 'Aruban Guilder'),

(11, 'AUD', '$', 'Australian Dollar'),

(12, 'AZN', '&#x43c;&#x430;&#x43d;', 'Azerbaijanian Manat'),

(13, 'BSD', '$', 'Bahamian Dollar'),

(14, 'BHD', 'BHD', 'Bahraini Dinar'),

(15, 'BDT', 'BDT', 'Taka'),

(16, 'BBD', '$', 'Barbados Dollar'),

(17, 'BYR', 'p.', 'Belarussian Ruble'),

(18, 'BZD', 'BZ$', 'Belize Dollar'),

(19, 'XOF', 'XOF', 'CFA Franc BCEAO'),

(20, 'BMD', '$', 'Bermudian Dollar'),

(21, 'BAM', 'KM', 'Convertible Marks'),

(22, 'BWP', 'P', 'Pula'),

(23, 'NOK', 'kr', 'Norwegian Krone'),

(24, 'BRL', 'R$', 'Brazilian Real'),

(25, 'BND', '$', 'Brunei Dollar'),

(26, 'BGN', '&#x43b;&#x432;', 'Bulgarian Lev'),

(27, 'BIF', 'BIF', 'Burundi Franc'),

(28, 'KHR', '&#x17db;', 'Riel'),

(29, 'XAF', 'XAF', 'CFA Franc BEAC'),

(30, 'CAD', '$', 'Canadian Dollar'),

(31, 'CVE', 'CVE', 'Cape Verde Escudo'),

(32, 'KYD', '$', 'Cayman Islands Dollar'),

(33, 'CNY', '&yen;', 'Yuan Renminbi'),

(34, 'KMF', 'KMF', 'Comoro Franc'),

(35, 'CDF', 'CDF', 'Congolese Franc'),

(36, 'NZD', '$', 'New Zealand Dollar'),

(37, 'CRC', '&#x20a1;', 'Costa Rican Colon'),

(38, 'HRK', 'kn', 'Croatian Kuna'),

(39, 'CZK', 'K&#x10d;', 'Czech Koruna'),

(40, 'DKK', 'kr', 'Danish Krone'),

(41, 'DJF', 'DJF', 'Djibouti Franc'),