static function change_database_pre() { // 0.730 $status = array("{t}completed{/t}" => "completed", "{t}confirmed{/t}" => "confirmed", "{t}booked{/t}" => "booked", "{t}canceled{/t}" => "canceled"); sgsml_parser::table_column_translate("simple_timesheets", "status", $status); sgsml_parser::table_column_translate("simple_expenses", "status", $status); // completed=0 && status=unconfirmed -> status=open // completed=1 && status=unconfirmed -> status=completed if (sgsml_parser::table_column_exists("simple_timesheets", "completed")) { db_update("simple_timesheets", array("status" => "open"), array("completed=0", "status=@status@"), array("status" => "{t}unconfirmed{/t}"), array("no_defaults" => 1)); db_update("simple_timesheets", array("status" => "completed"), array("completed=1", "status=@status@"), array("status" => "{t}unconfirmed{/t}"), array("no_defaults" => 1)); } if (sgsml_parser::table_column_exists("simple_expenses", "completed")) { db_update("simple_expenses", array("status" => "open"), array("completed=0", "status=@status@"), array("status" => "{t}unconfirmed{/t}"), array("no_defaults" => 1)); db_update("simple_expenses", array("status" => "completed"), array("completed=1", "status=@status@"), array("status" => "{t}unconfirmed{/t}"), array("no_defaults" => 1)); } // 0.662 $priority = array("{t}lowest{/t}" => "1", "{t}low{/t}" => "2", "{t}normal{/t}" => "3", "{t}urgent{/t}" => "4", "{t}immediate{/t}" => "5"); sgsml_parser::table_column_translate("simple_calendar", "priority", $priority); sgsml_parser::table_column_translate("simple_tasks", "priority", $priority); sgsml_parser::table_column_translate("simple_helpdesk", "priority", $priority); sgsml_parser::table_column_translate("simple_projects", "priority", $priority); // 0.658 if (!sgsml_parser::table_column_rename("simple_emails", "attachments", "attachment")) { setup::error_add("rename[10]: " . sql_error(), 1152); } if (!sgsml_parser::table_column_rename("simple_helpdesk", "attachments", "attachment")) { setup::error_add("rename[9]: " . sql_error(), 1153); } // 0.400 if (!sgsml_parser::table_column_rename("simple_projects", "started", "begin")) { setup::error_add("rename[8]: " . sql_error(), 152); } if (!sgsml_parser::table_column_rename("simple_projects", "finished", "ending")) { setup::error_add("rename[7]: " . sql_error(), 153); } // 0.220 if (!sgsml_parser::table_column_rename("simple_gallery", "title", "filename")) { setup::error_add("rename[5]: " . sql_error(), 52); } if (!sgsml_parser::table_column_rename("simple_gallery", "attachment", "filedata")) { setup::error_add("rename[6]: " . sql_error(), 53); } // 0.219 if (!sgsml_parser::table_column_rename("simple_calendar", "end", "ending")) { setup::error_add("rename[1]: " . sql_error(), 54); } if (!sgsml_parser::table_column_rename("simple_contactactivities", "end", "ending")) { setup::error_add("rename[2]: " . sql_error(), 55); } if (!sgsml_parser::table_column_rename("simple_tasks", "end", "ending")) { setup::error_add("rename[3]: " . sql_error(), 56); } // process funambol schema views on sgs update if (self::get_config_old("SYNC4J", false, 0) == "1") { setup::out(sprintf("{t}Processing %s ...{/t}", "Funambol schema")); if (SETUP_DB_TYPE == "mysqli") { $data = preg_replace("!/\\*.+?\\*/!s", "", file_get_contents("tools/funambolv7_syncML/mysql/funambol.sql")); if ($msg = db_query(explode(";", $data))) { setup::error_add("funambol.sql [mysql]: " . $msg . " " . sql_error(), 100); } } else { if (SETUP_DB_TYPE == "pgsql") { $data = file_get_contents("tools/funambolv7_syncML/postgresql/funambol.sql"); if ($msg = db_query($data)) { setup::error_add("funambol.sql [pgsql]: " . $msg . " " . sql_error(), 101); } } } } // 0.720 if (sgsml_parser::table_column_exists("simple_sys_custom_fields", "id")) { setup::out(sprintf("{t}Processing %s ...{/t}", "customization fields")); $rows = db_select("simple_sys_custom_fields", "*", "activated=1", "", ""); if (is_array($rows) and count($rows) > 0) { foreach ($rows as $row) { sgsml_customizer::trigger_build_field($row["id"], $row, null, "simple_sys_custom_fields"); } } } setup::errors_show(); }