data.sql 122 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829
  1. -- After the database schema is created, the database is filled
  2. -- with default values.
  3. INSERT INTO settings_current
  4. (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable)
  5. VALUES
  6. ('Institution',NULL,'textfield','Platform','{ORGANISATIONNAME}','InstitutionTitle','InstitutionComment','platform',NULL, 1),
  7. ('InstitutionUrl',NULL,'textfield','Platform','{ORGANISATIONURL}','InstitutionUrlTitle','InstitutionUrlComment',NULL,NULL, 1),
  8. ('siteName',NULL,'textfield','Platform','{CAMPUSNAME}','SiteNameTitle','SiteNameComment',NULL,NULL, 1),
  9. ('emailAdministrator',NULL,'textfield','Platform','{ADMINEMAIL}','emailAdministratorTitle','emailAdministratorComment',NULL,NULL, 1),
  10. ('administratorSurname',NULL,'textfield','Platform','{ADMINLASTNAME}','administratorSurnameTitle','administratorSurnameComment',NULL,NULL, 1),
  11. ('administratorName',NULL,'textfield','Platform','{ADMINFIRSTNAME}','administratorNameTitle','administratorNameComment',NULL,NULL, 1),
  12. ('show_administrator_data',NULL,'radio','Platform','true','ShowAdministratorDataTitle','ShowAdministratorDataComment',NULL,NULL, 1),
  13. ('show_tutor_data',NULL,'radio','Session','true','ShowTutorDataTitle','ShowTutorDataComment',NULL,NULL, 1),
  14. ('show_teacher_data',NULL,'radio','Platform','true','ShowTeacherDataTitle','ShowTeacherDataComment',NULL,NULL, 1),
  15. ('homepage_view',NULL,'radio','Course','activity_big','HomepageViewTitle','HomepageViewComment',NULL,NULL, 1),
  16. ('show_toolshortcuts',NULL,'radio','Course','false','ShowToolShortcutsTitle','ShowToolShortcutsComment',NULL,NULL, 0),
  17. ('allow_group_categories',NULL,'radio','Course','false','AllowGroupCategories','AllowGroupCategoriesComment',NULL,NULL, 0),
  18. ('server_type',NULL,'radio','Platform','production','ServerStatusTitle','ServerStatusComment',NULL,NULL, 0),
  19. ('platformLanguage',NULL,'link','Languages','{PLATFORMLANGUAGE}','PlatformLanguageTitle','PlatformLanguageComment',NULL,NULL, 0),
  20. ('showonline','world','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineWorld', 0),
  21. ('showonline','users','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineUsers', 0),
  22. ('showonline','course','checkbox','Platform','true','ShowOnlineTitle','ShowOnlineComment',NULL,'ShowOnlineCourse', 0),
  23. ('profile','name','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'name', 0),
  24. ('profile','officialcode','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'officialcode', 0),
  25. ('profile','email','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'Email', 0),
  26. ('profile','picture','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'UserPicture', 0),
  27. ('profile','login','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'Login', 0),
  28. ('profile','password','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'UserPassword', 0),
  29. ('profile','language','checkbox','User','true','ProfileChangesTitle','ProfileChangesComment',NULL,'Language', 0),
  30. ('default_document_quotum',NULL,'textfield','Course','100000000','DefaultDocumentQuotumTitle','DefaultDocumentQuotumComment',NULL,NULL, 0),
  31. ('registration','officialcode','checkbox','User','false','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'OfficialCode', 0),
  32. ('registration','email','checkbox','User','true','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Email', 0),
  33. ('registration','language','checkbox','User','true','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Language', 0),
  34. ('default_group_quotum',NULL,'textfield','Course','5000000','DefaultGroupQuotumTitle','DefaultGroupQuotumComment',NULL,NULL, 0),
  35. ('allow_registration',NULL,'radio','Platform','{ALLOWSELFREGISTRATION}','AllowRegistrationTitle','AllowRegistrationComment',NULL,NULL, 0),
  36. ('allow_registration_as_teacher',NULL,'radio','Platform','{ALLOWTEACHERSELFREGISTRATION}','AllowRegistrationAsTeacherTitle','AllowRegistrationAsTeacherComment',NULL,NULL, 0),
  37. ('allow_lostpassword',NULL,'radio','Platform','true','AllowLostPasswordTitle','AllowLostPasswordComment',NULL,NULL, 0),
  38. ('allow_user_headings',NULL,'radio','Course','false','AllowUserHeadings','AllowUserHeadingsComment',NULL,NULL, 0),
  39. ('course_create_active_tools','course_description','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'CourseDescription', 0),
  40. ('course_create_active_tools','agenda','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Agenda', 0),
  41. ('course_create_active_tools','documents','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Documents', 0),
  42. ('course_create_active_tools','learning_path','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'LearningPath', 0),
  43. ('course_create_active_tools','links','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Links', 0),
  44. ('course_create_active_tools','announcements','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Announcements', 0),
  45. ('course_create_active_tools','forums','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Forums', 0),
  46. ('course_create_active_tools','dropbox','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Dropbox', 0),
  47. ('course_create_active_tools','quiz','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Quiz', 0),
  48. ('course_create_active_tools','users','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Users', 0),
  49. ('course_create_active_tools','groups','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Groups', 0),
  50. ('course_create_active_tools','chat','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Chat', 0),
  51. ('course_create_active_tools','online_conference','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'OnlineConference', 0),
  52. ('course_create_active_tools','student_publications','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'StudentPublications', 0),
  53. ('allow_personal_agenda',NULL,'radio','User','true','AllowPersonalAgendaTitle','AllowPersonalAgendaComment',NULL,NULL, 0),
  54. ('display_coursecode_in_courselist',NULL,'radio','Platform','false','DisplayCourseCodeInCourselistTitle','DisplayCourseCodeInCourselistComment',NULL,NULL, 0),
  55. ('display_teacher_in_courselist',NULL,'radio','Platform','true','DisplayTeacherInCourselistTitle','DisplayTeacherInCourselistComment',NULL,NULL, 0),
  56. ('permanently_remove_deleted_files',NULL,'radio','Tools','false','PermanentlyRemoveFilesTitle','PermanentlyRemoveFilesComment',NULL,NULL, 0),
  57. ('dropbox_allow_overwrite',NULL,'radio','Tools','true','DropboxAllowOverwriteTitle','DropboxAllowOverwriteComment',NULL,NULL, 0),
  58. ('dropbox_max_filesize',NULL,'textfield','Tools','100000000','DropboxMaxFilesizeTitle','DropboxMaxFilesizeComment',NULL,NULL, 0),
  59. ('dropbox_allow_just_upload',NULL,'radio','Tools','true','DropboxAllowJustUploadTitle','DropboxAllowJustUploadComment',NULL,NULL, 0),
  60. ('dropbox_allow_student_to_student',NULL,'radio','Tools','true','DropboxAllowStudentToStudentTitle','DropboxAllowStudentToStudentComment',NULL,NULL, 0),
  61. ('dropbox_allow_group',NULL,'radio','Tools','true','DropboxAllowGroupTitle','DropboxAllowGroupComment',NULL,NULL, 0),
  62. ('dropbox_allow_mailing',NULL,'radio','Tools','false','DropboxAllowMailingTitle','DropboxAllowMailingComment',NULL,NULL, 0),
  63. ('administratorTelephone',NULL,'textfield','Platform','(000) 001 02 03','administratorTelephoneTitle','administratorTelephoneComment',NULL,NULL, 1),
  64. ('extended_profile',NULL,'radio','User','false','ExtendedProfileTitle','ExtendedProfileComment',NULL,NULL, 0),
  65. ('student_view_enabled',NULL,'radio','Platform','true','StudentViewEnabledTitle','StudentViewEnabledComment',NULL,NULL, 0),
  66. ('show_navigation_menu',NULL,'radio','Course','false','ShowNavigationMenuTitle','ShowNavigationMenuComment',NULL,NULL, 0),
  67. ('enable_tool_introduction',NULL,'radio','course','false','EnableToolIntroductionTitle','EnableToolIntroductionComment',NULL,NULL, 0),
  68. ('page_after_login', NULL, 'radio','Platform','user_portal.php', 'PageAfterLoginTitle','PageAfterLoginComment', NULL, NULL, 0),
  69. ('time_limit_whosonline', NULL, 'textfield','Platform','30', 'TimeLimitWhosonlineTitle','TimeLimitWhosonlineComment', NULL, NULL, 0),
  70. ('breadcrumbs_course_homepage', NULL, 'radio','Course','course_title', 'BreadCrumbsCourseHomepageTitle','BreadCrumbsCourseHomepageComment', NULL, NULL, 0),
  71. ('example_material_course_creation', NULL, 'radio','Platform','true', 'ExampleMaterialCourseCreationTitle','ExampleMaterialCourseCreationComment', NULL, NULL, 0),
  72. ('account_valid_duration',NULL, 'textfield','Platform','3660', 'AccountValidDurationTitle','AccountValidDurationComment', NULL, NULL, 0),
  73. ('use_session_mode', NULL, 'radio','Session','true', 'UseSessionModeTitle','UseSessionModeComment', NULL, NULL, 0),
  74. ('allow_email_editor', NULL, 'radio', 'Tools', 'false', 'AllowEmailEditorTitle', 'AllowEmailEditorComment', NULL, NULL, 0),
  75. ('registered', NULL, 'textfield', NULL, 'false', 'registered', NULL, NULL, NULL, 0),
  76. ('donotlistcampus', NULL, 'textfield', NULL, 'false', 'donotlistcampus', NULL, NULL, NULL,0 ),
  77. ('show_email_addresses', NULL,'radio','Platform','false','ShowEmailAddresses','ShowEmailAddressesComment',NULL,NULL, 1),
  78. ('profile','phone','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'phone', 0),
  79. ('service_visio', 'active', 'radio',NULL,'false', 'VisioEnable','', NULL, NULL, 0),
  80. ('service_visio', 'visio_host', 'textfield',NULL,'', 'VisioHost','', NULL, NULL, 0),
  81. ('service_visio', 'visio_port', 'textfield',NULL,'1935', 'VisioPort','', NULL, NULL, 0),
  82. ('service_visio', 'visio_pass', 'textfield',NULL,'', 'VisioPassword','', NULL, NULL, 0),
  83. ('service_ppt2lp', 'active', 'radio',NULL,'false', 'ppt2lp_actived','', NULL, NULL, 0),
  84. ('service_ppt2lp', 'host', 'textfield', NULL, NULL, 'Host', NULL, NULL, NULL, 0),
  85. ('service_ppt2lp', 'port', 'textfield', NULL, 2002, 'Port', NULL, NULL, NULL, 0),
  86. ('service_ppt2lp', 'user', 'textfield', NULL, NULL, 'UserOnHost', NULL, NULL, NULL, 0),
  87. ('service_ppt2lp', 'ftp_password', 'textfield', NULL, NULL, 'FtpPassword', NULL, NULL, NULL, 0),
  88. ('service_ppt2lp', 'path_to_lzx', 'textfield', NULL, NULL, '', NULL, NULL, NULL, 0),
  89. ('service_ppt2lp', 'size', 'radio', NULL, '720x540', '', NULL, NULL, NULL, 0),
  90. ('stylesheets', NULL, 'textfield','stylesheets','chamilo','',NULL, NULL, NULL, 1),
  91. ('upload_extensions_list_type', NULL, 'radio', 'Security', 'blacklist', 'UploadExtensionsListType', 'UploadExtensionsListTypeComment', NULL, NULL, 0),
  92. ('upload_extensions_blacklist', NULL, 'textfield', 'Security', '', 'UploadExtensionsBlacklist', 'UploadExtensionsBlacklistComment', NULL, NULL, 0),
  93. ('upload_extensions_whitelist', NULL, 'textfield', 'Security', 'htm;html;jpg;jpeg;gif;png;swf;avi;mpg;mpeg;mov;flv;doc;docx;xls;xlsx;ppt;pptx;odt;odp;ods;pdf', 'UploadExtensionsWhitelist', 'UploadExtensionsWhitelistComment', NULL, NULL, 0),
  94. ('upload_extensions_skip', NULL, 'radio', 'Security', 'true', 'UploadExtensionsSkip', 'UploadExtensionsSkipComment', NULL, NULL, 0),
  95. ('upload_extensions_replace_by', NULL, 'textfield', 'Security', 'dangerous', 'UploadExtensionsReplaceBy', 'UploadExtensionsReplaceByComment', NULL, NULL, 0),
  96. ('show_number_of_courses', NULL, 'radio','Platform','false', 'ShowNumberOfCourses','ShowNumberOfCoursesComment', NULL, NULL, 0),
  97. ('show_empty_course_categories', NULL, 'radio','Platform','true', 'ShowEmptyCourseCategories','ShowEmptyCourseCategoriesComment', NULL, NULL, 0),
  98. ('show_back_link_on_top_of_tree', NULL, 'radio','Platform','false', 'ShowBackLinkOnTopOfCourseTree','ShowBackLinkOnTopOfCourseTreeComment', NULL, NULL, 0),
  99. ('show_different_course_language', NULL, 'radio','Platform','true', 'ShowDifferentCourseLanguage','ShowDifferentCourseLanguageComment', NULL, NULL, 1),
  100. ('split_users_upload_directory', NULL, 'radio','Tuning','true', 'SplitUsersUploadDirectory','SplitUsersUploadDirectoryComment', NULL, NULL, 0),
  101. ('hide_dltt_markup', NULL, 'radio','Languages','true', 'HideDLTTMarkup','HideDLTTMarkupComment', NULL, NULL, 0),
  102. ('display_categories_on_homepage',NULL,'radio','Platform','false','DisplayCategoriesOnHomepageTitle','DisplayCategoriesOnHomepageComment',NULL,NULL, 1),
  103. ('permissions_for_new_directories', NULL, 'textfield', 'Security', '0777', 'PermissionsForNewDirs', 'PermissionsForNewDirsComment', NULL, NULL, 0),
  104. ('permissions_for_new_files', NULL, 'textfield', 'Security', '0666', 'PermissionsForNewFiles', 'PermissionsForNewFilesComment', NULL, NULL, 0),
  105. ('show_tabs', 'campus_homepage', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsCampusHomepage', 1),
  106. ('show_tabs', 'my_courses', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyCourses', 1),
  107. ('show_tabs', 'reporting', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsReporting', 1),
  108. ('show_tabs', 'platform_administration', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsPlatformAdministration', 1),
  109. ('show_tabs', 'my_agenda', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyAgenda', 1),
  110. ('show_tabs', 'my_profile', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsMyProfile', 1),
  111. ('default_forum_view', NULL, 'radio', 'Course', 'flat', 'DefaultForumViewTitle','DefaultForumViewComment',NULL,NULL, 0),
  112. ('platform_charset',NULL,'textfield','Languages','UTF-8','PlatformCharsetTitle','PlatformCharsetComment','platform',NULL, 0),
  113. ('noreply_email_address', '', 'textfield', 'Platform', '', 'NoReplyEmailAddress', 'NoReplyEmailAddressComment', NULL, NULL, 0),
  114. ('survey_email_sender_noreply', '', 'radio', 'Course', 'coach', 'SurveyEmailSenderNoReply', 'SurveyEmailSenderNoReplyComment', NULL, NULL, 0),
  115. ('openid_authentication',NULL,'radio','Security','false','OpenIdAuthentication','OpenIdAuthenticationComment',NULL,NULL, 0),
  116. ('profile','openid','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'OpenIDURL', 0),
  117. ('gradebook_enable',NULL,'radio','Gradebook','false','GradebookActivation','GradebookActivationComment',NULL,NULL, 0),
  118. ('show_tabs','my_gradebook','checkbox','Platform','true','ShowTabsTitle','ShowTabsComment',NULL,'TabsMyGradebook', 1),
  119. ('gradebook_score_display_coloring','my_display_coloring','checkbox','Gradebook','false','GradebookScoreDisplayColoring','GradebookScoreDisplayColoringComment',NULL,'TabsGradebookEnableColoring', 0),
  120. ('gradebook_score_display_custom','my_display_custom','checkbox','Gradebook','false','GradebookScoreDisplayCustom','GradebookScoreDisplayCustomComment',NULL,'TabsGradebookEnableCustom', 0),
  121. ('gradebook_score_display_colorsplit',NULL,'textfield','Gradebook','50','GradebookScoreDisplayColorSplit','GradebookScoreDisplayColorSplitComment',NULL,NULL, 0),
  122. ('gradebook_score_display_upperlimit','my_display_upperlimit','checkbox','Gradebook','false','GradebookScoreDisplayUpperLimit','GradebookScoreDisplayUpperLimitComment',NULL,'TabsGradebookEnableUpperLimit', 0),
  123. ('gradebook_number_decimals', NULL, 'select', 'Gradebook', '0', 'GradebookNumberDecimals', 'GradebookNumberDecimalsComment', NULL, NULL, 0),
  124. ('user_selected_theme',NULL,'radio','Platform','false','UserThemeSelection','UserThemeSelectionComment',NULL,NULL, 0),
  125. ('profile','theme','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'UserTheme', 0),
  126. ('allow_course_theme',NULL,'radio','Course','true','AllowCourseThemeTitle','AllowCourseThemeComment',NULL,NULL, 0),
  127. ('show_closed_courses',NULL,'radio','Platform','false','ShowClosedCoursesTitle','ShowClosedCoursesComment',NULL,NULL, 0),
  128. ('service_visio', 'visio_use_rtmpt', 'radio',null,'false', 'VisioUseRtmptTitle','VisioUseRtmptComment', NULL, NULL, 0),
  129. ('extendedprofile_registration', 'mycomptetences', 'checkbox','User','false', 'ExtendedProfileRegistrationTitle','ExtendedProfileRegistrationComment', NULL, 'MyCompetences', 0),
  130. ('extendedprofile_registration', 'mydiplomas', 'checkbox','User','false', 'ExtendedProfileRegistrationTitle','ExtendedProfileRegistrationComment', NULL, 'MyDiplomas', 0),
  131. ('extendedprofile_registration', 'myteach', 'checkbox','User','false', 'ExtendedProfileRegistrationTitle','ExtendedProfileRegistrationComment', NULL, 'MyTeach', 0),
  132. ('extendedprofile_registration', 'mypersonalopenarea', 'checkbox','User','false', 'ExtendedProfileRegistrationTitle','ExtendedProfileRegistrationComment', NULL, 'MyPersonalOpenArea', 0),
  133. ('extendedprofile_registrationrequired', 'mycomptetences', 'checkbox','User','false', 'ExtendedProfileRegistrationRequiredTitle','ExtendedProfileRegistrationRequiredComment', NULL, 'MyCompetences', 0),
  134. ('extendedprofile_registrationrequired', 'mydiplomas', 'checkbox','User','false', 'ExtendedProfileRegistrationRequiredTitle','ExtendedProfileRegistrationRequiredComment', NULL, 'MyDiplomas', 0),
  135. ('extendedprofile_registrationrequired', 'myteach', 'checkbox','User','false', 'ExtendedProfileRegistrationRequiredTitle','ExtendedProfileRegistrationRequiredComment', NULL, 'MyTeach', 0),
  136. ('extendedprofile_registrationrequired', 'mypersonalopenarea', 'checkbox','User','false', 'ExtendedProfileRegistrationRequiredTitle','ExtendedProfileRegistrationRequiredComment', NULL, 'MyPersonalOpenArea', 0),
  137. ('registration','phone','checkbox','User','false','RegistrationRequiredFormsTitle','RegistrationRequiredFormsComment',NULL,'Phone', 0),
  138. ('add_users_by_coach',NULL,'radio','Session','false','AddUsersByCoachTitle','AddUsersByCoachComment',NULL,NULL, 0),
  139. ('extend_rights_for_coach',NULL,'radio','Security','false','ExtendRightsForCoachTitle','ExtendRightsForCoachComment',NULL,NULL, 0),
  140. ('extend_rights_for_coach_on_survey',NULL,'radio','Security','true','ExtendRightsForCoachOnSurveyTitle','ExtendRightsForCoachOnSurveyComment',NULL,NULL, 0),
  141. ('course_create_active_tools','wiki','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Wiki', 0),
  142. ('show_session_coach', NULL, 'radio','Session','false', 'ShowSessionCoachTitle','ShowSessionCoachComment', NULL, NULL, 0),
  143. ('course_create_active_tools','gradebook','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Gradebook', 0),
  144. ('allow_users_to_create_courses',NULL,'radio','Platform','true','AllowUsersToCreateCoursesTitle','AllowUsersToCreateCoursesComment',NULL,NULL, 0),
  145. ('course_create_active_tools','survey','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Survey', 0),
  146. ('course_create_active_tools','glossary','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Glossary', 0),
  147. ('course_create_active_tools','notebook','checkbox','Tools','true','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Notebook', 0),
  148. ('course_create_active_tools','attendances','checkbox','Tools','false','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Attendances', 0),
  149. ('course_create_active_tools','course_progress','checkbox','Tools','false','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'CourseProgress', 0),
  150. ('profile','apikeys','checkbox','User','false','ProfileChangesTitle','ProfileChangesComment',NULL,'ApiKeys', 0),
  151. ('allow_message_tool', NULL, 'radio', 'Tools', 'true', 'AllowMessageToolTitle', 'AllowMessageToolComment', NULL, NULL,1),
  152. ('allow_social_tool', NULL, 'radio', 'Tools', 'true', 'AllowSocialToolTitle', 'AllowSocialToolComment', NULL, NULL,1),
  153. ('allow_students_to_browse_courses',NULL,'radio','Platform','true','AllowStudentsToBrowseCoursesTitle','AllowStudentsToBrowseCoursesComment',NULL,NULL, 1),
  154. ('show_session_data', NULL, 'radio', 'Session', 'false', 'ShowSessionDataTitle', 'ShowSessionDataComment', NULL, NULL, 1),
  155. ('allow_use_sub_language', NULL, 'radio', 'Languages', 'false', 'AllowUseSubLanguageTitle', 'AllowUseSubLanguageComment', NULL, NULL,0),
  156. ('show_glossary_in_documents', NULL, 'radio', 'Course', 'none', 'ShowGlossaryInDocumentsTitle', 'ShowGlossaryInDocumentsComment', NULL, NULL,1),
  157. ('allow_terms_conditions', NULL, 'radio', 'Platform', 'false', 'AllowTermsAndConditionsTitle', 'AllowTermsAndConditionsComment', NULL, NULL,0),
  158. ('course_create_active_tools','enable_search','checkbox','Tools','false','CourseCreateActiveToolsTitle','CourseCreateActiveToolsComment',NULL,'Search',0),
  159. ('search_enabled',NULL,'radio','Search','false','EnableSearchTitle','EnableSearchComment',NULL,NULL,1),
  160. ('search_prefilter_prefix',NULL, NULL,'Search','','SearchPrefilterPrefix','SearchPrefilterPrefixComment',NULL,NULL,0),
  161. ('search_show_unlinked_results',NULL,'radio','Search','true','SearchShowUnlinkedResultsTitle','SearchShowUnlinkedResultsComment',NULL,NULL,1),
  162. ('show_courses_descriptions_in_catalog', NULL, 'radio', 'Course', 'true', 'ShowCoursesDescriptionsInCatalogTitle', 'ShowCoursesDescriptionsInCatalogComment', NULL, NULL, 1),
  163. ('allow_coach_to_edit_course_session',NULL,'radio','Session','true','AllowCoachsToEditInsideTrainingSessions','AllowCoachsToEditInsideTrainingSessionsComment',NULL,NULL, 0),
  164. ('show_glossary_in_extra_tools', NULL, 'radio', 'Course', 'none', 'ShowGlossaryInExtraToolsTitle', 'ShowGlossaryInExtraToolsComment', NULL, NULL,1),
  165. ('send_email_to_admin_when_create_course',NULL,'radio','Platform','false','SendEmailToAdminTitle','SendEmailToAdminComment',NULL,NULL, 1),
  166. ('go_to_course_after_login',NULL,'radio','Course','false','GoToCourseAfterLoginTitle','GoToCourseAfterLoginComment',NULL,NULL, 0),
  167. ('math_asciimathML',NULL,'radio','Editor','false','MathASCIImathMLTitle','MathASCIImathMLComment',NULL,NULL, 0),
  168. ('enabled_asciisvg',NULL,'radio','Editor','false','AsciiSvgTitle','AsciiSvgComment',NULL,NULL, 0),
  169. ('include_asciimathml_script',NULL,'radio','Editor','false','IncludeAsciiMathMlTitle','IncludeAsciiMathMlComment',NULL,NULL, 0),
  170. ('youtube_for_students',NULL,'radio','Editor','true','YoutubeForStudentsTitle','YoutubeForStudentsComment',NULL,NULL, 0),
  171. ('block_copy_paste_for_students',NULL,'radio','Editor','false','BlockCopyPasteForStudentsTitle','BlockCopyPasteForStudentsComment',NULL,NULL, 0),
  172. ('more_buttons_maximized_mode',NULL,'radio','Editor','true','MoreButtonsForMaximizedModeTitle','MoreButtonsForMaximizedModeComment',NULL,NULL, 0),
  173. ('students_download_folders',NULL,'radio','Tools','true','AllowStudentsDownloadFoldersTitle','AllowStudentsDownloadFoldersComment',NULL,NULL, 0),
  174. ('users_copy_files',NULL,'radio','Tools','true','AllowUsersCopyFilesTitle','AllowUsersCopyFilesComment',NULL,NULL, 1),
  175. ('show_tabs', 'social', 'checkbox', 'Platform', 'true', 'ShowTabsTitle','ShowTabsComment',NULL,'TabsSocial', 0),
  176. ('allow_students_to_create_groups_in_social',NULL,'radio','Tools','false','AllowStudentsToCreateGroupsInSocialTitle','AllowStudentsToCreateGroupsInSocialComment',NULL,NULL, 0),
  177. ('allow_send_message_to_all_platform_users',NULL,'radio','Tools','true','AllowSendMessageToAllPlatformUsersTitle','AllowSendMessageToAllPlatformUsersComment',NULL,NULL, 0),
  178. ('message_max_upload_filesize',NULL,'textfield','Tools','20971520','MessageMaxUploadFilesizeTitle','MessageMaxUploadFilesizeComment',NULL,NULL, 0),
  179. ('show_tabs', 'dashboard', 'checkbox', 'Platform', 'true', 'ShowTabsTitle', 'ShowTabsComment', NULL, 'TabsDashboard', 1),
  180. ('use_users_timezone', 'timezones', 'radio', 'Timezones', 'true', 'UseUsersTimezoneTitle','UseUsersTimezoneComment',NULL,'Timezones', 1),
  181. ('timezone_value', 'timezones', 'select', 'Timezones', '', 'TimezoneValueTitle','TimezoneValueComment',NULL,'Timezones', 1),
  182. ('allow_user_course_subscription_by_course_admin', NULL, 'radio', 'Security', 'true', 'AllowUserCourseSubscriptionByCourseAdminTitle', 'AllowUserCourseSubscriptionByCourseAdminComment', NULL, NULL, 1),
  183. ('show_link_bug_notification', NULL, 'radio', 'Platform', 'false', 'ShowLinkBugNotificationTitle', 'ShowLinkBugNotificationComment', NULL, NULL, 0),
  184. ('course_validation', NULL, 'radio', 'Platform', 'false', 'EnableCourseValidation', 'EnableCourseValidationComment', NULL, NULL, 1),
  185. ('course_validation_terms_and_conditions_url', NULL, 'textfield', 'Platform', '', 'CourseValidationTermsAndConditionsLink', 'CourseValidationTermsAndConditionsLinkComment', NULL, NULL, 1),
  186. ('sso_authentication',NULL,'radio','Security','false','EnableSSOTitle','EnableSSOComment',NULL,NULL,1),
  187. ('sso_authentication_domain',NULL,'textfield','Security','','SSOServerDomainTitle','SSOServerDomainComment',NULL,NULL,1),
  188. ('sso_authentication_auth_uri',NULL,'textfield','Security','/?q=user','SSOServerAuthURITitle','SSOServerAuthURIComment',NULL,NULL,1),
  189. ('sso_authentication_unauth_uri',NULL,'textfield','Security','/?q=logout','SSOServerUnAuthURITitle','SSOServerUnAuthURIComment',NULL,NULL,1),
  190. ('sso_authentication_protocol',NULL,'radio','Security','http://','SSOServerProtocolTitle','SSOServerProtocolComment',NULL,NULL,1),
  191. ('enabled_wiris',NULL,'radio','Editor','false','EnabledWirisTitle','EnabledWirisComment',NULL,NULL, 0),
  192. ('allow_spellcheck',NULL,'radio','Editor','false','AllowSpellCheckTitle','AllowSpellCheckComment',NULL,NULL, 0),
  193. ('force_wiki_paste_as_plain_text',NULL,'radio','Editor','false','ForceWikiPasteAsPlainTextTitle','ForceWikiPasteAsPlainTextComment',NULL,NULL, 0),
  194. ('enabled_googlemaps',NULL,'radio','Editor','false','EnabledGooglemapsTitle','EnabledGooglemapsComment',NULL,NULL, 0),
  195. ('enabled_imgmap',NULL,'radio','Editor','true','EnabledImageMapsTitle','EnabledImageMapsComment',NULL,NULL, 0),
  196. ('enabled_support_svg', NULL,'radio', 'Tools', 'true', 'EnabledSVGTitle','EnabledSVGComment',NULL,NULL, 0),
  197. ('pdf_export_watermark_enable', NULL,'radio', 'Platform', 'false','PDFExportWatermarkEnableTitle', 'PDFExportWatermarkEnableComment', 'platform',NULL, 1),
  198. ('pdf_export_watermark_by_course', NULL,'radio', 'Platform', 'false','PDFExportWatermarkByCourseTitle', 'PDFExportWatermarkByCourseComment','platform',NULL, 1),
  199. ('pdf_export_watermark_text', NULL,'textfield', 'Platform', '', 'PDFExportWatermarkTextTitle', 'PDFExportWatermarkTextComment', 'platform',NULL, 1),
  200. ('enabled_insertHtml', NULL,'radio', 'Editor', 'true','EnabledInsertHtmlTitle', 'EnabledInsertHtmlComment',NULL,NULL, 0),
  201. ('students_export2pdf', NULL,'radio', 'Tools', 'true', 'EnabledStudentExport2PDFTitle', 'EnabledStudentExport2PDFComment',NULL,NULL, 0),
  202. ('exercise_min_score', NULL,'textfield', 'Course', '', 'ExerciseMinScoreTitle', 'ExerciseMinScoreComment','platform',NULL, 1),
  203. ('exercise_max_score', NULL,'textfield', 'Course', '', 'ExerciseMaxScoreTitle', 'ExerciseMaxScoreComment','platform',NULL, 1),
  204. ('show_users_folders', NULL,'radio', 'Tools', 'true', 'ShowUsersFoldersTitle','ShowUsersFoldersComment',NULL,NULL, 0),
  205. ('show_default_folders', NULL,'radio', 'Tools', 'true', 'ShowDefaultFoldersTitle','ShowDefaultFoldersComment',NULL,NULL, 0),
  206. ('show_chat_folder', NULL,'radio', 'Tools', 'true', 'ShowChatFolderTitle','ShowChatFolderComment',NULL,NULL, 0),
  207. ('enabled_text2audio', NULL,'radio', 'Tools', 'false', 'Text2AudioTitle','Text2AudioComment',NULL,NULL, 0),
  208. ('course_hide_tools','course_description','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'CourseDescription', 1),
  209. ('course_hide_tools','calendar_event','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Agenda', 1),
  210. ('course_hide_tools','document','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Documents', 1),
  211. ('course_hide_tools','learnpath','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'LearningPath', 1),
  212. ('course_hide_tools','link','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Links', 1),
  213. ('course_hide_tools','announcement','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Announcements', 1),
  214. ('course_hide_tools','forum','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Forums', 1),
  215. ('course_hide_tools','dropbox','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Dropbox', 1),
  216. ('course_hide_tools','quiz','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Quiz', 1),
  217. ('course_hide_tools','user','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Users', 1),
  218. ('course_hide_tools','group','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Groups', 1),
  219. ('course_hide_tools','chat','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Chat', 1),
  220. ('course_hide_tools','student_publication','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'StudentPublications', 1),
  221. ('course_hide_tools','wiki','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Wiki', 1),
  222. ('course_hide_tools','gradebook','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Gradebook', 1),
  223. ('course_hide_tools','survey','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Survey', 1),
  224. ('course_hide_tools','glossary','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Glossary', 1),
  225. ('course_hide_tools','notebook','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Notebook', 1),
  226. ('course_hide_tools','attendance','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Attendances', 1),
  227. ('course_hide_tools','course_progress','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'CourseProgress', 1),
  228. ('course_hide_tools','blog_management','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Blog',1),
  229. ('course_hide_tools','tracking','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Stats',1),
  230. ('course_hide_tools','course_maintenance','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'Maintenance',1),
  231. ('course_hide_tools','course_setting','checkbox','Tools','false','CourseHideToolsTitle','CourseHideToolsComment',NULL,'CourseSettings',1),
  232. ('enabled_support_pixlr',NULL,'radio','Tools','false','EnabledPixlrTitle','EnabledPixlrComment',NULL,NULL, 0),
  233. ('show_groups_to_users',NULL,'radio','Session','false','ShowGroupsToUsersTitle','ShowGroupsToUsersComment',NULL,NULL, 0),
  234. ('accessibility_font_resize',NULL,'radio','Platform','false','EnableAccessibilityFontResizeTitle','EnableAccessibilityFontResizeComment',NULL,NULL, 1),
  235. ('hide_courses_in_sessions',NULL,'radio', 'Session','false','HideCoursesInSessionsTitle', 'HideCoursesInSessionsComment','platform',NULL, 1),
  236. ('enable_quiz_scenario', NULL,'radio','Course','true','EnableQuizScenarioTitle','EnableQuizScenarioComment',NULL,NULL, 1),
  237. ('enable_nanogong',NULL,'radio','Tools','false','EnableNanogongTitle','EnableNanogongComment',NULL,NULL, 0),
  238. ('filter_terms',NULL,'textarea','Security','','FilterTermsTitle','FilterTermsComment',NULL,NULL, 0),
  239. ('header_extra_content', NULL, 'textarea', 'Tracking', '', 'HeaderExtraContentTitle', 'HeaderExtraContentComment', NULL, NULL, 1),
  240. ('footer_extra_content', NULL, 'textarea', 'Tracking', '', 'FooterExtraContentTitle', 'FooterExtraContentComment', NULL, NULL, 1),
  241. ('show_documents_preview', NULL, 'radio', 'Tools', 'false', 'ShowDocumentPreviewTitle', 'ShowDocumentPreviewComment', NULL, NULL, 1),
  242. ('htmlpurifier_wiki', NULL, 'radio', 'Editor', 'false', 'HtmlPurifierWikiTitle', 'HtmlPurifierWikiComment', NULL, NULL, 0),
  243. ('cas_activate', NULL, 'radio', 'CAS', 'false', 'CasMainActivateTitle', 'CasMainActivateComment', NULL, NULL, 0),
  244. ('cas_server', NULL, 'textfield', 'CAS', '', 'CasMainServerTitle', 'CasMainServerComment', NULL, NULL, 0),
  245. ('cas_server_uri', NULL, 'textfield', 'CAS', '', 'CasMainServerURITitle', 'CasMainServerURIComment', NULL, NULL, 0),
  246. ('cas_port', NULL, 'textfield', 'CAS', '', 'CasMainPortTitle', 'CasMainPortComment', NULL, NULL, 0),
  247. ('cas_protocol', NULL, 'radio', 'CAS', '', 'CasMainProtocolTitle', 'CasMainProtocolComment', NULL, NULL, 0),
  248. ('cas_add_user_activate', NULL, 'radio', 'CAS', 'false', 'CasUserAddActivateTitle', 'CasUserAddActivateComment', NULL, NULL, 0),
  249. ('update_user_info_cas_with_ldap', NULL, 'radio', 'CAS', 'true', 'UpdateUserInfoCasWithLdapTitle', 'UpdateUserInfoCasWithLdapComment', NULL, NULL, 0),
  250. ('student_page_after_login', NULL, 'textfield', 'Platform', '', 'StudentPageAfterLoginTitle', 'StudentPageAfterLoginComment', NULL, NULL, 0),
  251. ('teacher_page_after_login', NULL, 'textfield', 'Platform', '', 'TeacherPageAfterLoginTitle', 'TeacherPageAfterLoginComment', NULL, NULL, 0),
  252. ('drh_page_after_login', NULL, 'textfield', 'Platform', '', 'DRHPageAfterLoginTitle', 'DRHPageAfterLoginComment', NULL, NULL, 0),
  253. ('sessionadmin_page_after_login', NULL, 'textfield', 'Session', '', 'SessionAdminPageAfterLoginTitle', 'SessionAdminPageAfterLoginComment', NULL, NULL, 0),
  254. ('student_autosubscribe', NULL, 'textfield', 'Platform', '', 'StudentAutosubscribeTitle', 'StudentAutosubscribeComment', NULL, NULL, 0),
  255. ('teacher_autosubscribe', NULL, 'textfield', 'Platform', '', 'TeacherAutosubscribeTitle', 'TeacherAutosubscribeComment', NULL, NULL, 0),
  256. ('drh_autosubscribe', NULL, 'textfield', 'Platform', '', 'DRHAutosubscribeTitle', 'DRHAutosubscribeComment', NULL, NULL, 0),
  257. ('sessionadmin_autosubscribe', NULL, 'textfield', 'Session', '', 'SessionadminAutosubscribeTitle', 'SessionadminAutosubscribeComment', NULL, NULL, 0),
  258. ('scorm_cumulative_session_time', NULL, 'radio', 'Course', 'true', 'ScormCumulativeSessionTimeTitle', 'ScormCumulativeSessionTimeComment', NULL, NULL, 0),
  259. ('allow_hr_skills_management', NULL, 'radio', 'Gradebook', 'true', 'AllowHRSkillsManagementTitle', 'AllowHRSkillsManagementComment', NULL, NULL, 1),
  260. ('enable_help_link', NULL, 'radio', 'Platform', 'true', 'EnableHelpLinkTitle', 'EnableHelpLinkComment', NULL, NULL, 0),
  261. ('teachers_can_change_score_settings', NULL, 'radio', 'Gradebook', 'true', 'TeachersCanChangeScoreSettingsTitle', 'TeachersCanChangeScoreSettingsComment', NULL, NULL, 1),
  262. ('allow_users_to_change_email_with_no_password', NULL, 'radio', 'User', 'false', 'AllowUsersToChangeEmailWithNoPasswordTitle', 'AllowUsersToChangeEmailWithNoPasswordComment', NULL, NULL, 0),
  263. ('show_admin_toolbar', NULL, 'radio', 'Platform', 'do_not_show', 'ShowAdminToolbarTitle', 'ShowAdminToolbarComment', NULL, NULL, 1),
  264. ('allow_global_chat', NULL, 'radio', 'Platform', 'true', 'AllowGlobalChatTitle', 'AllowGlobalChatComment', NULL, NULL, 1),
  265. ('languagePriority1', NULL, 'radio', 'Languages', 'course_lang', 'LanguagePriority1Title', 'LanguagePriority1Comment', NULL, NULL, 0),
  266. ('languagePriority2', NULL, 'radio', 'Languages','user_profil_lang', 'LanguagePriority2Title', 'LanguagePriority2Comment', NULL, NULL, 0),
  267. ('languagePriority3', NULL, 'radio', 'Languages','user_selected_lang', 'LanguagePriority3Title', 'LanguagePriority3Comment', NULL, NULL, 0),
  268. ('languagePriority4', NULL, 'radio', 'Languages', 'platform_lang','LanguagePriority4Title', 'LanguagePriority4Comment', NULL, NULL, 0),
  269. ('login_is_email', NULL, 'radio', 'Platform', 'false', 'LoginIsEmailTitle', 'LoginIsEmailComment', NULL, NULL, 0),
  270. ('courses_default_creation_visibility', NULL, 'radio', 'Course', '2', 'CoursesDefaultCreationVisibilityTitle', 'CoursesDefaultCreationVisibilityComment', NULL, NULL, 1),
  271. ('allow_browser_sniffer', NULL, 'radio', 'Tuning', 'false', 'AllowBrowserSnifferTitle', 'AllowBrowserSnifferComment', NULL, NULL, 0),
  272. ('enable_wami_record',NULL,'radio','Tools','false','EnableWamiRecordTitle','EnableWamiRecordComment',NULL,NULL, 0),
  273. ('gradebook_enable_grade_model', NULL, 'radio', 'Gradebook', 'false', 'GradebookEnableGradeModelTitle', 'GradebookEnableGradeModelComment', NULL, NULL, 1),
  274. ('teachers_can_change_grade_model_settings', NULL, 'radio', 'Gradebook', 'true', 'TeachersCanChangeGradeModelSettingsTitle', 'TeachersCanChangeGradeModelSettingsComment', NULL, NULL, 1),
  275. ('gradebook_default_weight', NULL, 'textfield', 'Gradebook', '100', 'GradebookDefaultWeightTitle', 'GradebookDefaultWeightComment', NULL, NULL, 0),
  276. ('ldap_description', NULL, 'radio', 'LDAP', NULL, 'LdapDescriptionTitle', 'LdapDescriptionComment', NULL, NULL, 0),
  277. ('shibboleth_description', NULL, 'radio', 'Shibboleth', 'false', 'ShibbolethMainActivateTitle', 'ShibbolethMainActivateComment', NULL, NULL, 0),
  278. ('facebook_description', NULL, 'radio', 'Facebook', 'false', 'FacebookMainActivateTitle', 'FacebookMainActivateComment', NULL, NULL, 0),
  279. ('gradebook_locking_enabled', NULL, 'radio', 'Gradebook', 'false', 'GradebookEnableLockingTitle', 'GradebookEnableLockingComment', NULL, NULL, 0),
  280. ('gradebook_default_grade_model_id', NULL, 'select', 'Gradebook', '', 'GradebookDefaultGradeModelTitle', 'GradebookDefaultGradeModelComment', NULL, NULL, 1),
  281. ('allow_session_admins_to_manage_all_sessions', NULL, 'radio', 'Session', 'false', 'AllowSessionAdminsToSeeAllSessionsTitle', 'AllowSessionAdminsToSeeAllSessionsComment', NULL, NULL, 1),
  282. ('allow_skills_tool', NULL, 'radio', 'Platform', 'true', 'AllowSkillsToolTitle', 'AllowSkillsToolComment', NULL, NULL, 1),
  283. ('allow_public_certificates', NULL, 'radio', 'Course', 'false', 'AllowPublicCertificatesTitle', 'AllowPublicCertificatesComment', NULL, NULL, 1),
  284. ('platform_unsubscribe_allowed', NULL, 'radio', 'Platform', 'false', 'PlatformUnsubscribeTitle', 'PlatformUnsubscribeComment', NULL, NULL, 1),
  285. ('activate_email_template', NULL, 'radio', 'Platform', 'false', 'ActivateEmailTemplateTitle', 'ActivateEmailTemplateComment', NULL, NULL, 0),
  286. ('enable_iframe_inclusion', NULL, 'radio', 'Editor', 'false', 'EnableIframeInclusionTitle', 'EnableIframeInclusionComment', NULL, NULL, 1),
  287. ('show_hot_courses', NULL, 'radio', 'Platform', 'true', 'ShowHotCoursesTitle', 'ShowHotCoursesComment', NULL, NULL, 1),
  288. ('enable_webcam_clip',NULL,'radio','Tools','false','EnableWebCamClipTitle','EnableWebCamClipComment',NULL,NULL, 0),
  289. ('use_custom_pages', NULL, 'radio','Platform','false','UseCustomPagesTitle','UseCustomPagesComment', NULL, NULL, 1),
  290. ('tool_visible_by_default_at_creation','documents','checkbox','Tools','true','ToolVisibleByDefaultAtCreationTitle','ToolVisibleByDefaultAtCreationComment',NULL,'Documents', 1),
  291. ('tool_visible_by_default_at_creation','learning_path','checkbox','Tools','true','ToolVisibleByDefaultAtCreationTitle','ToolVisibleByDefaultAtCreationComment',NULL,'LearningPath', 1),
  292. ('tool_visible_by_default_at_creation','links','checkbox','Tools','true','ToolVisibleByDefaultAtCreationTitle','ToolVisibleByDefaultAtCreationComment',NULL,'Links', 1),
  293. ('tool_visible_by_default_at_creation','announcements','checkbox','Tools','true','ToolVisibleByDefaultAtCreationTitle','ToolVisibleByDefaultAtCreationComment',NULL,'Announcements', 1),
  294. ('tool_visible_by_default_at_creation','forums','checkbox','Tools','true','ToolVisibleByDefaultAtCreationTitle','ToolVisibleByDefaultAtCreationComment',NULL,'Forums', 1),
  295. ('tool_visible_by_default_at_creation','quiz','checkbox','Tools','true','ToolVisibleByDefaultAtCreationTitle','ToolVisibleByDefaultAtCreationComment',NULL,'Quiz', 1),
  296. ('tool_visible_by_default_at_creation','gradebook','checkbox','Tools','true','ToolVisibleByDefaultAtCreationTitle','ToolVisibleByDefaultAtCreationComment',NULL,'Gradebook', 1),
  297. ('prevent_session_admins_to_manage_all_users', NULL, 'radio', 'Session', 'false', 'PreventSessionAdminsToManageAllUsersTitle', 'PreventSessionAdminsToManageAllUsersComment', NULL, NULL, 1),
  298. ('documents_default_visibility_defined_in_course', NULL,'radio','Tools','false','DocumentsDefaultVisibilityDefinedInCourseTitle','DocumentsDefaultVisibilityDefinedInCourseComment',NULL, NULL, 1),
  299. ('enabled_mathjax', NULL, 'radio', 'Editor', 'false', 'EnableMathJaxTitle', 'EnableMathJaxComment', NULL, NULL, 0),
  300. ('meta_twitter_site', NULL, 'textfield', 'Tracking', '', 'MetaTwitterSiteTitle', 'MetaTwitterSiteComment', NULL, NULL, 1),
  301. ('meta_twitter_creator', NULL, 'textfield', 'Tracking', '', 'MetaTwitterCreatorTitle', 'MetaTwitterCreatorComment', NULL, NULL, 1),
  302. ('meta_title', NULL, 'textfield', 'Tracking', '', 'MetaTitleTitle', 'MetaTitleComment', NULL, NULL, 1),
  303. ('meta_description', NULL, 'textfield', 'Tracking', '', 'MetaDescriptionTitle', 'MetaDescriptionComment', NULL, NULL, 1),
  304. ('meta_image_path', NULL, 'textfield', 'Tracking', '', 'MetaImagePathTitle', 'MetaImagePathComment', NULL, NULL, 1),
  305. ('allow_teachers_to_create_sessions', NULL, 'radio', 'Session', 'false', 'AllowTeachersToCreateSessionsTitle', 'AllowTeachersToCreateSessionsComment', NULL, NULL, 0),
  306. ('institution_address',NULL,'textfield','Platform','','InstitutionAddressTitle','InstitutionAddressComment',NULL,NULL, 1),
  307. ('chamilo_database_version', NULL, 'textfield', NULL, '0', 'DatabaseVersion', '', NULL, NULL, 0),
  308. ('cron_remind_course_finished_activate', NULL, 'radio', 'Crons', 'false', 'CronRemindCourseFinishedActivateTitle', 'CronRemindCourseFinishedActivateComment', NULL, NULL, 1),
  309. ('cron_remind_course_expiration_frequency', NULL, 'textfield', 'Crons', '2', 'CronRemindCourseExpirationFrequencyTitle', 'CronRemindCourseExpirationFrequencyComment', NULL, NULL, 1),
  310. ('cron_remind_course_expiration_activate', NULL, 'radio', 'Crons', 'false', 'CronRemindCourseExpirationActivateTitle', 'CronRemindCourseExpirationActivateComment', NULL, NULL, 1),
  311. ('allow_coach_feedback_exercises',NULL,'radio','Session','true','AllowCoachFeedbackExercisesTitle','AllowCoachFeedbackExercisesComment',NULL,NULL, 0),
  312. ('allow_my_files',NULL,'radio','Platform','true','AllowMyFilesTitle','AllowMyFilesComment','',NULL, 1);
  313. INSERT INTO settings_options (variable, value, display_text)
  314. VALUES
  315. ('show_administrator_data','true','Yes'),
  316. ('show_administrator_data','false','No'),
  317. ('show_tutor_data','true','Yes'),
  318. ('show_tutor_data','false','No'),
  319. ('show_teacher_data','true','Yes'),
  320. ('show_teacher_data','false','No'),
  321. ('homepage_view','activity','HomepageViewActivity'),
  322. ('homepage_view','2column','HomepageView2column'),
  323. ('homepage_view','3column','HomepageView3column'),
  324. ('homepage_view','vertical_activity','HomepageViewVerticalActivity'),
  325. ('homepage_view','activity_big','HomepageViewActivityBig'),
  326. ('show_toolshortcuts','true','Yes'),
  327. ('show_toolshortcuts','false','No'),
  328. ('allow_group_categories','true','Yes'),
  329. ('allow_group_categories','false','No'),
  330. ('server_type','production','ProductionServer'),
  331. ('server_type','test','TestServer'),
  332. ('allow_name_change','true','Yes'),
  333. ('allow_name_change','false','No'),
  334. ('allow_officialcode_change','true','Yes'),
  335. ('allow_officialcode_change','false','No'),
  336. ('allow_registration','true','Yes'),
  337. ('allow_registration','false','No'),
  338. ('allow_registration','approval','AfterApproval'),
  339. ('allow_registration_as_teacher','true','Yes'),
  340. ('allow_registration_as_teacher','false','No'),
  341. ('allow_lostpassword','true','Yes'),
  342. ('allow_lostpassword','false','No'),
  343. ('allow_user_headings','true','Yes'),
  344. ('allow_user_headings','false','No'),
  345. ('allow_personal_agenda','true','Yes'),
  346. ('allow_personal_agenda','false','No'),
  347. ('display_coursecode_in_courselist','true','Yes'),
  348. ('display_coursecode_in_courselist','false','No'),
  349. ('display_teacher_in_courselist','true','Yes'),
  350. ('display_teacher_in_courselist','false','No'),
  351. ('permanently_remove_deleted_files','true','YesWillDeletePermanently'),
  352. ('permanently_remove_deleted_files','false','NoWillDeletePermanently'),
  353. ('dropbox_allow_overwrite','true','Yes'),
  354. ('dropbox_allow_overwrite','false','No'),
  355. ('dropbox_allow_just_upload','true','Yes'),
  356. ('dropbox_allow_just_upload','false','No'),
  357. ('dropbox_allow_student_to_student','true','Yes'),
  358. ('dropbox_allow_student_to_student','false','No'),
  359. ('dropbox_allow_group','true','Yes'),
  360. ('dropbox_allow_group','false','No'),
  361. ('dropbox_allow_mailing','true','Yes'),
  362. ('dropbox_allow_mailing','false','No'),
  363. ('extended_profile','true','Yes'),
  364. ('extended_profile','false','No'),
  365. ('student_view_enabled','true','Yes'),
  366. ('student_view_enabled','false','No'),
  367. ('show_navigation_menu','false','No'),
  368. ('show_navigation_menu','icons','IconsOnly'),
  369. ('show_navigation_menu','text','TextOnly'),
  370. ('show_navigation_menu','iconstext','IconsText'),
  371. ('enable_tool_introduction','true','Yes'),
  372. ('enable_tool_introduction','false','No'),
  373. ('page_after_login', 'index.php', 'CampusHomepage'),
  374. ('page_after_login', 'user_portal.php', 'MyCourses'),
  375. ('page_after_login', 'main/auth/courses.php', 'CourseCatalog'),
  376. ('breadcrumbs_course_homepage', 'get_lang', 'CourseHomepage'),
  377. ('breadcrumbs_course_homepage', 'course_code', 'CourseCode'),
  378. ('breadcrumbs_course_homepage', 'course_title', 'CourseTitle'),
  379. ('example_material_course_creation', 'true', 'Yes'),
  380. ('example_material_course_creation', 'false', 'No'),
  381. ('use_session_mode', 'true', 'Yes'),
  382. ('use_session_mode', 'false', 'No'),
  383. ('allow_email_editor', 'true' ,'Yes'),
  384. ('allow_email_editor', 'false', 'No'),
  385. ('show_email_addresses','true','Yes'),
  386. ('show_email_addresses','false','No'),
  387. ('upload_extensions_list_type', 'blacklist', 'Blacklist'),
  388. ('upload_extensions_list_type', 'whitelist', 'Whitelist'),
  389. ('upload_extensions_skip', 'true', 'Remove'),
  390. ('upload_extensions_skip', 'false', 'Rename'),
  391. ('show_number_of_courses', 'true', 'Yes'),
  392. ('show_number_of_courses', 'false', 'No'),
  393. ('show_empty_course_categories', 'true', 'Yes'),
  394. ('show_empty_course_categories', 'false', 'No'),
  395. ('show_back_link_on_top_of_tree', 'true', 'Yes'),
  396. ('show_back_link_on_top_of_tree', 'false', 'No'),
  397. ('show_different_course_language', 'true', 'Yes'),
  398. ('show_different_course_language', 'false', 'No'),
  399. ('split_users_upload_directory', 'true', 'Yes'),
  400. ('split_users_upload_directory', 'false', 'No'),
  401. ('hide_dltt_markup', 'false', 'No'),
  402. ('hide_dltt_markup', 'true', 'Yes'),
  403. ('display_categories_on_homepage','true','Yes'),
  404. ('display_categories_on_homepage','false','No'),
  405. ('default_forum_view', 'flat', 'Flat'),
  406. ('default_forum_view', 'threaded', 'Threaded'),
  407. ('default_forum_view', 'nested', 'Nested'),
  408. ('survey_email_sender_noreply', 'coach', 'CourseCoachEmailSender'),
  409. ('survey_email_sender_noreply', 'noreply', 'NoReplyEmailSender'),
  410. ('openid_authentication','true','Yes'),
  411. ('openid_authentication','false','No'),
  412. ('gradebook_enable','true','Yes'),
  413. ('gradebook_enable','false','No'),
  414. ('user_selected_theme','true','Yes'),
  415. ('user_selected_theme','false','No'),
  416. ('allow_course_theme','true','Yes'),
  417. ('allow_course_theme','false','No'),
  418. ('show_closed_courses', 'true', 'Yes'),
  419. ('show_closed_courses', 'false', 'No'),
  420. ('ldap_version', '2', 'LDAPVersion2'),
  421. ('ldap_version', '3', 'LDAPVersion3'),
  422. ('visio_use_rtmpt','true','Yes'),
  423. ('visio_use_rtmpt','false','No'),
  424. ('add_users_by_coach', 'true', 'Yes'),
  425. ('add_users_by_coach', 'false', 'No'),
  426. ('extend_rights_for_coach', 'true', 'Yes'),
  427. ('extend_rights_for_coach', 'false', 'No'),
  428. ('extend_rights_for_coach_on_survey', 'true', 'Yes'),
  429. ('extend_rights_for_coach_on_survey', 'false', 'No'),
  430. ('show_session_coach', 'true', 'Yes'),
  431. ('show_session_coach', 'false', 'No'),
  432. ('allow_users_to_create_courses','true','Yes'),
  433. ('allow_users_to_create_courses','false','No'),
  434. ('breadcrumbs_course_homepage', 'session_name_and_course_title', 'SessionNameAndCourseTitle'),
  435. ('allow_message_tool', 'true', 'Yes'),
  436. ('allow_message_tool', 'false', 'No'),
  437. ('allow_social_tool', 'true', 'Yes'),
  438. ('allow_social_tool', 'false', 'No'),
  439. ('allow_students_to_browse_courses','true','Yes'),
  440. ('allow_students_to_browse_courses','false','No'),
  441. ('show_email_of_teacher_or_tutor ', 'true', 'Yes'),
  442. ('show_email_of_teacher_or_tutor ', 'false', 'No'),
  443. ('show_session_data ', 'true', 'Yes'),
  444. ('show_session_data ', 'false', 'No'),
  445. ('allow_use_sub_language', 'true', 'Yes'),
  446. ('allow_use_sub_language', 'false', 'No'),
  447. ('show_glossary_in_documents', 'none', 'ShowGlossaryInDocumentsIsNone'),
  448. ('show_glossary_in_documents', 'ismanual', 'ShowGlossaryInDocumentsIsManual'),
  449. ('show_glossary_in_documents', 'isautomatic', 'ShowGlossaryInDocumentsIsAutomatic'),
  450. ('allow_terms_conditions', 'true', 'Yes'),
  451. ('allow_terms_conditions', 'false', 'No'),
  452. ('search_enabled', 'true', 'Yes'),
  453. ('search_enabled', 'false', 'No'),
  454. ('search_show_unlinked_results', 'true', 'SearchShowUnlinkedResults'),
  455. ('search_show_unlinked_results', 'false', 'SearchHideUnlinkedResults'),
  456. ('show_courses_descriptions_in_catalog', 'true', 'Yes'),
  457. ('show_courses_descriptions_in_catalog', 'false', 'No'),
  458. ('allow_coach_to_edit_course_session','true','Yes'),
  459. ('allow_coach_to_edit_course_session','false','No'),
  460. ('show_glossary_in_extra_tools', 'none', 'None'),
  461. ('show_glossary_in_extra_tools', 'exercise', 'Exercise'),
  462. ('show_glossary_in_extra_tools', 'lp', 'Learning path'),
  463. ('show_glossary_in_extra_tools', 'exercise_and_lp', 'ExerciseAndLearningPath'),
  464. ('send_email_to_admin_when_create_course','true','Yes'),
  465. ('send_email_to_admin_when_create_course','false','No'),
  466. ('go_to_course_after_login','true','Yes'),
  467. ('go_to_course_after_login','false','No'),
  468. ('math_asciimathML','true','Yes'),
  469. ('math_asciimathML','false','No'),
  470. ('enabled_asciisvg','true','Yes'),
  471. ('enabled_asciisvg','false','No'),
  472. ('include_asciimathml_script','true','Yes'),
  473. ('include_asciimathml_script','false','No'),
  474. ('youtube_for_students','true','Yes'),
  475. ('youtube_for_students','false','No'),
  476. ('block_copy_paste_for_students','true','Yes'),
  477. ('block_copy_paste_for_students','false','No'),
  478. ('more_buttons_maximized_mode','true','Yes'),
  479. ('more_buttons_maximized_mode','false','No'),
  480. ('students_download_folders','true','Yes'),
  481. ('students_download_folders','false','No'),
  482. ('users_copy_files','true','Yes'),
  483. ('users_copy_files','false','No'),
  484. ('allow_students_to_create_groups_in_social','true','Yes'),
  485. ('allow_students_to_create_groups_in_social','false','No'),
  486. ('allow_send_message_to_all_platform_users','true','Yes'),
  487. ('allow_send_message_to_all_platform_users','false','No'),
  488. ('use_users_timezone', 'true', 'Yes'),
  489. ('use_users_timezone', 'false', 'No'),
  490. ('allow_user_course_subscription_by_course_admin', 'true', 'Yes'),
  491. ('allow_user_course_subscription_by_course_admin', 'false', 'No'),
  492. ('show_link_bug_notification', 'true', 'Yes'),
  493. ('show_link_bug_notification', 'false', 'No'),
  494. ('course_validation', 'true', 'Yes'),
  495. ('course_validation', 'false', 'No'),
  496. ('sso_authentication', 'true', 'Yes'),
  497. ('sso_authentication', 'false', 'No'),
  498. ('sso_authentication_protocol', 'http://', 'http://'),
  499. ('sso_authentication_protocol', 'https://', 'https://'),
  500. ('enabled_wiris','true','Yes'),
  501. ('enabled_wiris','false','No'),
  502. ('allow_spellcheck','true','Yes'),
  503. ('allow_spellcheck','false','No'),
  504. ('force_wiki_paste_as_plain_text','true','Yes'),
  505. ('force_wiki_paste_as_plain_text','false','No'),
  506. ('enabled_googlemaps','true','Yes'),
  507. ('enabled_googlemaps','false','No'),
  508. ('enabled_imgmap','true','Yes'),
  509. ('enabled_imgmap','false','No'),
  510. ('enabled_support_svg','true','Yes'),
  511. ('enabled_support_svg','false','No'),
  512. ('pdf_export_watermark_enable','true','Yes'),
  513. ('pdf_export_watermark_enable','false','No'),
  514. ('pdf_export_watermark_by_course','true','Yes'),
  515. ('pdf_export_watermark_by_course','false','No'),
  516. ('enabled_insertHtml','true','Yes'),
  517. ('enabled_insertHtml','false','No'),
  518. ('students_export2pdf','true','Yes'),
  519. ('students_export2pdf','false','No'),
  520. ('show_users_folders','true','Yes'),
  521. ('show_users_folders','false','No'),
  522. ('show_default_folders','true','Yes'),
  523. ('show_default_folders','false','No'),
  524. ('show_chat_folder','true','Yes'),
  525. ('show_chat_folder','false','No'),
  526. ('enabled_text2audio','true','Yes'),
  527. ('enabled_text2audio','false','No'),
  528. ('enabled_support_pixlr','true','Yes'),
  529. ('enabled_support_pixlr','false','No'),
  530. ('show_groups_to_users','true','Yes'),
  531. ('show_groups_to_users','false','No'),
  532. ('accessibility_font_resize', 'true', 'Yes'),
  533. ('accessibility_font_resize', 'false', 'No'),
  534. ('hide_courses_in_sessions','true','Yes'),
  535. ('hide_courses_in_sessions','false','No'),
  536. ('enable_quiz_scenario', 'true', 'Yes'),
  537. ('enable_quiz_scenario', 'false', 'No'),
  538. ('enable_nanogong','true','Yes'),
  539. ('enable_nanogong','false','No'),
  540. ('show_documents_preview', 'true', 'Yes'),
  541. ('show_documents_preview', 'false', 'No'),
  542. ('htmlpurifier_wiki', 'true', 'Yes'),
  543. ('htmlpurifier_wiki', 'false', 'No'),
  544. ('cas_activate', 'true', 'Yes'),
  545. ('cas_activate', 'false', 'No'),
  546. ('cas_protocol', 'CAS1', 'CAS1Text'),
  547. ('cas_protocol', 'CAS2', 'CAS2Text'),
  548. ('cas_protocol', 'SAML', 'SAMLText'),
  549. ('cas_add_user_activate', 'false', 'No'),
  550. ('cas_add_user_activate', 'platform', 'casAddUserActivatePlatform'),
  551. ('cas_add_user_activate', 'extldap', 'casAddUserActivateLDAP'),
  552. ('update_user_info_cas_with_ldap', 'true', 'Yes'),
  553. ('update_user_info_cas_with_ldap', 'false', 'No'),
  554. ('scorm_cumulative_session_time','true','Yes'),
  555. ('scorm_cumulative_session_time','false','No'),
  556. ('allow_hr_skills_management', 'true', 'Yes'),
  557. ('allow_hr_skills_management', 'false', 'No'),
  558. ('enable_help_link', 'true', 'Yes'),
  559. ('enable_help_link', 'false', 'No'),
  560. ('allow_users_to_change_email_with_no_password', 'true', 'Yes'),
  561. ('allow_users_to_change_email_with_no_password', 'false', 'No'),
  562. ('show_admin_toolbar', 'do_not_show', 'DoNotShow'),
  563. ('show_admin_toolbar', 'show_to_admin', 'ShowToAdminsOnly'),
  564. ('show_admin_toolbar', 'show_to_admin_and_teachers', 'ShowToAdminsAndTeachers'),
  565. ('show_admin_toolbar', 'show_to_all', 'ShowToAllUsers'),
  566. ('use_custom_pages','true','Yes'),
  567. ('use_custom_pages','false','No'),
  568. ('languagePriority1','platform_lang','PlatformLanguage'),
  569. ('languagePriority1','user_profil_lang','UserLanguage'),
  570. ('languagePriority1','user_selected_lang','UserSelectedLanguage'),
  571. ('languagePriority1','course_lang','CourseLanguage'),
  572. ('languagePriority2','platform_lang','PlatformLanguage'),
  573. ('languagePriority2','user_profil_lang','UserLanguage'),
  574. ('languagePriority2','user_selected_lang','UserSelectedLanguage'),
  575. ('languagePriority2','course_lang','CourseLanguage'),
  576. ('languagePriority3','platform_lang','PlatformLanguage'),
  577. ('languagePriority3','user_profil_lang','UserLanguage'),
  578. ('languagePriority3','user_selected_lang','UserSelectedLanguage'),
  579. ('languagePriority3','course_lang','CourseLanguage'),
  580. ('languagePriority4','platform_lang','PlatformLanguage'),
  581. ('languagePriority4','user_profil_lang','UserLanguage'),
  582. ('languagePriority4','user_selected_lang','UserSelectedLanguage'),
  583. ('languagePriority4','course_lang','CourseLanguage'),
  584. ('allow_global_chat', 'true', 'Yes'),
  585. ('allow_global_chat', 'false', 'No'),
  586. ('login_is_email','true','Yes'),
  587. ('login_is_email','false','No'),
  588. ('courses_default_creation_visibility', '3', 'OpenToTheWorld'),
  589. ('courses_default_creation_visibility', '2', 'OpenToThePlatform'),
  590. ('courses_default_creation_visibility', '1', 'Private'),
  591. ('courses_default_creation_visibility', '0', 'CourseVisibilityClosed'),
  592. ('allow_browser_sniffer', 'true', 'Yes'),
  593. ('allow_browser_sniffer', 'false', 'No'),
  594. ('enable_wami_record', 'true', 'Yes'),
  595. ('enable_wami_record', 'false', 'No'),
  596. ('teachers_can_change_score_settings', 'true', 'Yes'),
  597. ('teachers_can_change_score_settings', 'false', 'No'),
  598. ('teachers_can_change_grade_model_settings', 'true', 'Yes'),
  599. ('teachers_can_change_grade_model_settings', 'false', 'No'),
  600. ('gradebook_locking_enabled', 'true', 'Yes'),
  601. ('gradebook_locking_enabled', 'false', 'No'),
  602. ('gradebook_enable_grade_model', 'true', 'Yes'),
  603. ('gradebook_enable_grade_model', 'false', 'No'),
  604. ('allow_session_admins_to_manage_all_sessions', 'true', 'Yes'),
  605. ('allow_session_admins_to_manage_all_sessions', 'false', 'No'),
  606. ('allow_skills_tool', 'true', 'Yes'),
  607. ('allow_skills_tool', 'false', 'No'),
  608. ('allow_public_certificates', 'true', 'Yes'),
  609. ('allow_public_certificates', 'false', 'No'),
  610. ('platform_unsubscribe_allowed', 'true', 'Yes'),
  611. ('platform_unsubscribe_allowed', 'false', 'No'),
  612. ('activate_email_template', 'true', 'Yes'),
  613. ('activate_email_template', 'false', 'No'),
  614. ('enable_iframe_inclusion', 'true', 'Yes'),
  615. ('enable_iframe_inclusion', 'false', 'No'),
  616. ('show_hot_courses', 'true', 'Yes'),
  617. ('show_hot_courses', 'false', 'No'),
  618. ('enable_webcam_clip', 'true', 'Yes'),
  619. ('enable_webcam_clip', 'false', 'No'),
  620. ('prevent_session_admins_to_manage_all_users', 'true', 'Yes'),
  621. ('prevent_session_admins_to_manage_all_users', 'false', 'No'),
  622. ('documents_default_visibility_defined_in_course', 'true', 'Yes'),
  623. ('documents_default_visibility_defined_in_course', 'false', 'No'),
  624. ('enabled_mathjax','true','Yes'),
  625. ('enabled_mathjax','false','No'),
  626. ('allow_teachers_to_create_sessions', 'true', 'Yes'),
  627. ('allow_teachers_to_create_sessions', 'false', 'No'),
  628. ('cron_remind_course_finished_activate', 'false', 'No'),
  629. ('cron_remind_course_finished_activate', 'true', 'Yes'),
  630. ('cron_remind_course_expiration_activate', 'false', 'No'),
  631. ('cron_remind_course_expiration_activate', 'true', 'Yes'),
  632. ('allow_coach_feedback_exercises','true','Yes'),
  633. ('allow_coach_feedback_exercises','false','No'),
  634. ('allow_my_files','true','Yes'),
  635. ('allow_my_files','false','No');
  636. INSERT INTO language (original_name, english_name, isocode, dokeos_folder, available) VALUES
  637. ('العربية','arabic','ar','arabic',0),
  638. ('Asturianu','asturian','ast','asturian',0),
  639. ('Euskara','basque','eu','basque',1),
  640. ('বাংলা','bengali','bn','bengali',0),
  641. ('Bosanski','bosnian','bs','bosnian',1),
  642. ('Português do Brasil','brazilian','pt-BR','brazilian',1),
  643. ('Български','bulgarian','bg','bulgarian',1),
  644. ('Català','catalan','ca','catalan',0),
  645. ('Hrvatski','croatian','hr','croatian',0),
  646. ('Česky','czech','cs','czech',0),
  647. ('Dansk','danish','da','danish',0),
  648. ('دری','dari','prs','dari',0),
  649. ('Nederlands','dutch','nl','dutch',1),
  650. ('English','english','en','english',1),
  651. ('Esperanto','esperanto','eo','esperanto',0),
  652. ('Føroyskt', 'faroese', 'fo', 'faroese', 0),
  653. ('Suomi','finnish','fi','finnish',0),
  654. ('Français','french','fr','french',1),
  655. ('Furlan','friulian','fur','friulian',0),
  656. ('Galego','galician','gl','galician',1),
  657. ('ქართული','georgian','ka','georgian',0),
  658. ('Deutsch','german','de','german',1),
  659. ('Ελληνικά','greek','el','greek',1),
  660. ('עברית','hebrew','he','hebrew',0),
  661. ('हिन्दी','hindi','hi','hindi',0),
  662. ('Magyar','hungarian','hu','hungarian',1),
  663. ('Bahasa Indonesia','indonesian','id','indonesian',1),
  664. ('Italiano','italian','it','italian',1),
  665. ('日本語','japanese','ja','japanese',0),
  666. ('한국어','korean','ko','korean',0),
  667. ('Latviešu','latvian','lv','latvian',1),
  668. ('Lietuvių','lithuanian','lt','lithuanian',0),
  669. ('Македонски','macedonian','mk','macedonian',0),
  670. ('Bahasa Melayu','malay','ms','malay',0),
  671. ('Norsk','norwegian','no','norwegian',0),
  672. ('Occitan','occitan','oc','occitan',0),
  673. ('پښتو','pashto','ps','pashto',0),
  674. ('فارسی','persian','fa','persian',0),
  675. ('Polski','polish','pl','polish',1),
  676. ('Português europeu','portuguese','pt','portuguese',1),
  677. ('Runasimi','quechua_cusco','qu','quechua_cusco',0),
  678. ('Română','romanian','ro','romanian',0),
  679. ('Русский','russian','ru','russian',0),
  680. ('Srpski','serbian','sr','serbian',0),
  681. ('中文(简体)','simpl_chinese','zh','simpl_chinese',0),
  682. ('Slovenčina','slovak','sk','slovak',1),
  683. ('Slovenščina','slovenian','sl','slovenian',1),
  684. ('الصومالية','somali','so','somali',0),
  685. ('Español','spanish','es','spanish',1),
  686. ('Kiswahili','swahili','sw','swahili',0),
  687. ('Svenska','swedish','sv','swedish',0),
  688. ('Tagalog', 'tagalog', 'tl', 'tagalog',1),
  689. ('ไทย','thai','th','thai',0),
  690. ('Tibetan', 'tibetan', 'bo', 'tibetan', 0),
  691. ('繁體中文','trad_chinese','zh-TW','trad_chinese',0),
  692. ('Türkçe','turkish','tr','turkish',0),
  693. ('Українська','ukrainian','uk','ukrainian',0),
  694. ('Tiếng Việt','vietnamese','vi','vietnamese',0),
  695. ('isiXhosa', 'xhosa', 'xh', 'xhosa', 0),
  696. ('Yorùbá','yoruba','yo','yoruba',0);
  697. -- Set parent language to Spanish for all close-by languages, same for Italian, French, Portuguese and Chinese
  698. UPDATE language SET parent_id = 49 WHERE english_name = 'quechua_cusco';
  699. UPDATE language SET parent_id = 49 WHERE english_name = 'galician';
  700. UPDATE language SET parent_id = 49 WHERE english_name = 'esperanto';
  701. UPDATE language SET parent_id = 49 WHERE english_name = 'catalan';
  702. UPDATE language SET parent_id = 49 WHERE english_name = 'asturian';
  703. UPDATE language SET parent_id = 28 WHERE english_name = 'friulian';
  704. UPDATE language SET parent_id = 18 WHERE english_name = 'occitan';
  705. UPDATE language SET parent_id = 40 WHERE english_name = 'brazilian';
  706. UPDATE language SET parent_id = 45 WHERE english_name = 'trad_chinese';
  707. INSERT INTO course_category VALUES (1,'Language skills','LANG',NULL,1,0,'TRUE','TRUE'),(2,'PC Skills','PC',NULL,2,0,'TRUE','TRUE'),(3,'Projects','PROJ',NULL,3,0,'TRUE','TRUE');
  708. INSERT INTO course_module VALUES
  709. (1,'calendar_event','calendar/agenda.php','agenda.gif',1,1,'basic'),
  710. (2,'link','link/link.php','links.gif',4,1,'basic'),
  711. (3,'document','document/document.php','documents.gif',3,1,'basic'),
  712. (4,'student_publication','work/work.php','works.gif',3,2,'basic'),
  713. (5,'announcement','announcements/announcements.php','valves.gif',2,1,'basic'),
  714. (6,'user','user/user.php','members.gif',2,3,'basic'),
  715. (7,'forum','forum/index.php','forum.gif',1,2,'basic'),
  716. (8,'quiz','exercice/exercice.php','quiz.gif',2,2,'basic'),
  717. (9,'group','group/group.php','group.gif',3,3,'basic'),
  718. (10,'course_description','course_description/','info.gif',1,3,'basic'),
  719. (11,'chat','chat/chat.php','chat.gif',0,0,'external'),
  720. (12,'dropbox','dropbox/index.php','dropbox.gif',4,2,'basic'),
  721. (13,'tracking','tracking/courseLog.php','statistics.gif',1,3,'courseadmin'),
  722. (14,'homepage_link','link/link.php?action=addlink','npage.gif',1,1,'courseadmin'),
  723. (15,'course_setting','course_info/infocours.php','reference.gif',1,1,'courseadmin'),
  724. (16,'External','','external.gif',0,0,'external'),
  725. (17,'AddedLearnpath','','scormbuilder.gif',0,0,'external'),
  726. (18,'conference','conference/index.php?type=conference','conf.gif',0,0,'external'),
  727. (19,'conference','conference/index.php?type=classroom','conf.gif',0,0,'external'),
  728. (20,'learnpath','newscorm/lp_controller.php','scorms.gif',5,1,'basic'),
  729. (21,'blog','blog/blog.php','blog.gif',1,2,'basic'),
  730. (22,'blog_management','blog/blog_admin.php','blog_admin.gif',1,2,'courseadmin'),
  731. (23,'course_maintenance','course_info/maintenance.php','backup.gif',2,3,'courseadmin'),
  732. (24,'survey','survey/survey_list.php','survey.gif',2,1,'basic'),
  733. (25,'wiki','wiki/index.php','wiki.gif',2,3,'basic'),
  734. (26,'gradebook','gradebook/index.php','gradebook.gif',2,2,'basic'),
  735. (27,'glossary','glossary/index.php','glossary.gif',2,1,'basic'),
  736. (28,'notebook','notebook/index.php','notebook.gif',2,1,'basic'),
  737. (29,'attendance','attendance/index.php','attendance.gif',2,1,'basic'),
  738. (30,'course_progress','course_progress/index.php','course_progress.gif',2,1,'basic');
  739. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 1, 'legal_accept','Legal',0,0, NOW());
  740. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 1, 'already_logged_in','Already logged in',0,0, NOW());
  741. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 1, 'update_type','Update script type',0,0, NOW());
  742. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 10, 'tags','tags',0,0, NOW());
  743. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 1, 'rssfeeds','RSS',0,0, NOW());
  744. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 1, 'dashboard', 'Dashboard', 0, 0, NOW());
  745. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 11, 'timezone', 'Timezone', 0, 0, NOW());
  746. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, default_value, created_at) values (1, 4, 'mail_notify_invitation', 'MailNotifyInvitation',0,1,'1', NOW());
  747. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, default_value, created_at) values (1, 4, 'mail_notify_message', 'MailNotifyMessage',0,1,'1', NOW());
  748. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, default_value, created_at) values (1, 4, 'mail_notify_group_message','MailNotifyGroupMessage',0,1,'1', NOW());
  749. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 1, 'user_chat_status','User chat status',0,0, NOW());
  750. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 1, 'google_calendar_url','Google Calendar URL',0,0, NOW());
  751. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, default_value, created_at) VALUES (2, 13, 'special_course', 'Special course', 1 , 1, '', NOW());
  752. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (2, 10, 'tags', 'Tags', 1, 1, NOW());
  753. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (2, 19, 'video_url', 'VideoUrl', 1, 1, NOW());
  754. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (3, 16, 'image', 'Image', 1, 1, NOW());
  755. INSERT INTO extra_field (extra_field_type, field_type, variable, display_text, visible, changeable, created_at) VALUES (1, 1, 'captcha_blocked_until_date', 'Account locked until', 0, 0, NOW());
  756. INSERT INTO extra_field_options (field_id, option_value, display_text, option_order) VALUES (8, '1', 'AtOnce',1);
  757. INSERT INTO extra_field_options (field_id, option_value, display_text, option_order) VALUES (8, '8', 'Daily',2);
  758. INSERT INTO extra_field_options (field_id, option_value, display_text, option_order) VALUES (8, '0', 'No',3);
  759. INSERT INTO extra_field_options (field_id, option_value, display_text, option_order) VALUES (9, '1', 'AtOnce',1);
  760. INSERT INTO extra_field_options (field_id, option_value, display_text, option_order) VALUES (9, '8', 'Daily',2);
  761. INSERT INTO extra_field_options (field_id, option_value, display_text, option_order) VALUES (9, '0', 'No',3);
  762. INSERT INTO extra_field_options (field_id, option_value, display_text, option_order) VALUES (10, '1', 'AtOnce',1);
  763. INSERT INTO extra_field_options (field_id, option_value, display_text, option_order) VALUES (10, '8', 'Daily',2);
  764. INSERT INTO extra_field_options (field_id, option_value, display_text, option_order) VALUES (10, '0', 'No',3);
  765. INSERT INTO access_url(url, description, active, created_by, tms) VALUES ('http://localhost/',' ',1,1, NOW());
  766. -- Adding the platform templates
  767. INSERT INTO system_template (title, comment, image, content) VALUES
  768. ('TemplateTitleCourseTitle', 'TemplateTitleCourseTitleDescription', 'coursetitle.gif', '
  769. <head>
  770. {CSS}
  771. <style type="text/css">
  772. .gris_title {
  773. color: silver;
  774. }
  775. h1
  776. {
  777. text-align: right;
  778. }
  779. </style>
  780. </head>
  781. <body>
  782. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  783. <tbody>
  784. <tr>
  785. <td style="vertical-align: middle; width: 50%;" colspan="1" rowspan="1">
  786. <h1>TITULUS 1<br>
  787. <span class="gris_title">TITULUS 2</span><br>
  788. </h1>
  789. </td>
  790. <td style="width: 50%;">
  791. <img style="width: 100px; height: 100px;" alt="Chamilo logo" src="{COURSE_DIR}images/logo_chamilo.png"></td>
  792. </tr>
  793. </tbody>
  794. </table>
  795. <p><br>
  796. <br>
  797. </p>
  798. </body>
  799. ');
  800. /*
  801. INSERT INTO system_template (title, comment, image, content) VALUES
  802. ('TemplateTitleCheckList', 'TemplateTitleCheckListDescription', 'checklist.gif', '
  803. <head>
  804. {CSS}
  805. </head>
  806. <body>
  807. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  808. <tbody>
  809. <tr>
  810. <td style="vertical-align: top; width: 66%;">
  811. <h3>Lorem ipsum dolor sit amet</h3>
  812. <ul>
  813. <li>consectetur adipisicing elit</li>
  814. <li>sed do eiusmod tempor incididunt</li>
  815. <li>ut labore et dolore magna aliqua</li>
  816. </ul>
  817. <h3>Ut enim ad minim veniam</h3>
  818. <ul>
  819. <li>quis nostrud exercitation ullamco</li>
  820. <li>laboris nisi ut aliquip ex ea commodo consequat</li>
  821. <li>Excepteur sint occaecat cupidatat non proident</li>
  822. </ul>
  823. <h3>Sed ut perspiciatis unde omnis</h3>
  824. <ul>
  825. <li>iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam</li>
  826. <li>eaque ipsa quae ab illo inventore veritatis</li>
  827. <li>et quasi architecto beatae vitae dicta sunt explicabo.&nbsp;</li>
  828. </ul>
  829. </td>
  830. <td style="background: transparent url({IMG_DIR}postit.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; width: 33%; text-align: center; vertical-align: bottom;">
  831. <h3>Ut enim ad minima</h3>
  832. Veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur.<br>
  833. <h3>
  834. <img style="width: 180px; height: 144px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_smile.png "><br></h3>
  835. </td>
  836. </tr>
  837. </tbody>
  838. </table>
  839. <p><br>
  840. <br>
  841. </p>
  842. </body>
  843. ');
  844. */
  845. INSERT INTO system_template (title, comment, image, content) VALUES
  846. ('TemplateTitleTeacher', 'TemplateTitleTeacherDescription', 'yourinstructor.gif', '
  847. <head>
  848. {CSS}
  849. <style type="text/css">
  850. .text
  851. {
  852. font-weight: normal;
  853. }
  854. </style>
  855. </head>
  856. <body>
  857. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  858. <tbody>
  859. <tr>
  860. <td></td>
  861. <td style="height: 33%;"></td>
  862. <td></td>
  863. </tr>
  864. <tr>
  865. <td style="width: 25%;"></td>
  866. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right; font-weight: bold;" colspan="1" rowspan="1">
  867. <span class="text">
  868. <br>
  869. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Duis pellentesque.</span>
  870. </td>
  871. <td style="width: 25%; font-weight: bold;">
  872. <img style="width: 180px; height: 241px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_case.png "></td>
  873. </tr>
  874. </tbody>
  875. </table>
  876. <p><br>
  877. <br>
  878. </p>
  879. </body>
  880. ');
  881. INSERT INTO system_template (title, comment, image, content) VALUES
  882. ('TemplateTitleLeftList', 'TemplateTitleListLeftListDescription', 'leftlist.gif', '
  883. <head>
  884. {CSS}
  885. </head>
  886. <body>
  887. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  888. <tbody>
  889. <tr>
  890. <td style="width: 66%;"></td>
  891. <td style="vertical-align: bottom; width: 33%;" colspan="1" rowspan="4">&nbsp;<img style="width: 180px; height: 248px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_reads.png "><br>
  892. </td>
  893. </tr>
  894. <tr align="right">
  895. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">Lorem
  896. ipsum dolor sit amet.
  897. </td>
  898. </tr>
  899. <tr align="right">
  900. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  901. Vivamus
  902. a quam.&nbsp;<br>
  903. </td>
  904. </tr>
  905. <tr align="right">
  906. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  907. Proin
  908. a est stibulum ante ipsum.</td>
  909. </tr>
  910. </tbody>
  911. </table>
  912. <p><br>
  913. <br>
  914. </p>
  915. </body>
  916. ');
  917. INSERT INTO system_template (title, comment, image, content) VALUES
  918. ('TemplateTitleLeftRightList', 'TemplateTitleLeftRightListDescription', 'leftrightlist.gif', '
  919. <head>
  920. {CSS}
  921. </head>
  922. <body>
  923. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; height: 400px; width: 720px;" border="0" cellpadding="15" cellspacing="6">
  924. <tbody>
  925. <tr>
  926. <td></td>
  927. <td style="vertical-align: top;" colspan="1" rowspan="4">&nbsp;<img style="width: 180px; height: 294px;" alt="Trainer" src="{COURSE_DIR}images/trainer/trainer_join_hands.png "><br>
  928. </td>
  929. <td></td>
  930. </tr>
  931. <tr>
  932. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right;">Lorem
  933. ipsum dolor sit amet.
  934. </td>
  935. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: left;">
  936. Convallis
  937. ut.&nbsp;Cras dui magna.</td>
  938. </tr>
  939. <tr>
  940. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right;">
  941. Vivamus
  942. a quam.&nbsp;<br>
  943. </td>
  944. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: left;">
  945. Etiam
  946. lacinia stibulum ante.<br>
  947. </td>
  948. </tr>
  949. <tr>
  950. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right;">
  951. Proin
  952. a est stibulum ante ipsum.</td>
  953. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: left;">
  954. Consectetuer
  955. adipiscing elit. <br>
  956. </td>
  957. </tr>
  958. </tbody>
  959. </table>
  960. <p><br>
  961. <br>
  962. </p>
  963. </body>
  964. ');
  965. INSERT INTO system_template (title, comment, image, content) VALUES
  966. ('TemplateTitleRightList', 'TemplateTitleRightListDescription', 'rightlist.gif', '
  967. <head>
  968. {CSS}
  969. </head>
  970. <body style="direction: ltr;">
  971. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  972. <tbody>
  973. <tr>
  974. <td style="vertical-align: bottom; width: 50%;" colspan="1" rowspan="4"><img style="width: 300px; height: 199px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_points_right.png"><br>
  975. </td>
  976. <td style="width: 50%;"></td>
  977. </tr>
  978. <tr>
  979. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 50%;">
  980. Convallis
  981. ut.&nbsp;Cras dui magna.</td>
  982. </tr>
  983. <tr>
  984. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 50%;">
  985. Etiam
  986. lacinia.<br>
  987. </td>
  988. </tr>
  989. <tr>
  990. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 50%;">
  991. Consectetuer
  992. adipiscing elit. <br>
  993. </td>
  994. </tr>
  995. </tbody>
  996. </table>
  997. <p><br>
  998. <br>
  999. </p>
  1000. </body>
  1001. ');
  1002. /*
  1003. INSERT INTO system_template (title, comment, image, content) VALUES
  1004. ('TemplateTitleComparison', 'TemplateTitleComparisonDescription', 'compare.gif', '
  1005. <head>
  1006. {CSS}
  1007. </head>
  1008. <body>
  1009. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1010. <tr>
  1011. <td style="height: 10%; width: 33%;"></td>
  1012. <td style="vertical-align: top; width: 33%;" colspan="1" rowspan="2">&nbsp;<img style="width: 180px; height: 271px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_standing.png "><br>
  1013. </td>
  1014. <td style="height: 10%; width: 33%;"></td>
  1015. </tr>
  1016. <tr>
  1017. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 33%; text-align: right;">
  1018. Lorem ipsum dolor sit amet.
  1019. </td>
  1020. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 33%;">
  1021. Convallis
  1022. ut.&nbsp;Cras dui magna.</td>
  1023. </tr>
  1024. </body>
  1025. ');
  1026. */
  1027. INSERT INTO system_template (title, comment, image, content) VALUES
  1028. ('TemplateTitleDiagram', 'TemplateTitleDiagramDescription', 'diagram.gif', '
  1029. <head>
  1030. {CSS}
  1031. </head>
  1032. <body>
  1033. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1034. <tbody>
  1035. <tr>
  1036. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; height: 33%; width: 33%;">
  1037. <br>
  1038. Etiam
  1039. lacinia stibulum ante.
  1040. Convallis
  1041. ut.&nbsp;Cras dui magna.</td>
  1042. <td colspan="1" rowspan="3">
  1043. <img style="width: 350px; height: 267px;" alt="Alaska chart" src="{COURSE_DIR}images/diagrams/alaska_chart.png "></td>
  1044. </tr>
  1045. <tr>
  1046. <td colspan="1" rowspan="1">
  1047. <img style="width: 300px; height: 199px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_points_right.png "></td>
  1048. </tr>
  1049. <tr>
  1050. </tr>
  1051. </tbody>
  1052. </table>
  1053. <p><br>
  1054. <br>
  1055. </p>
  1056. </body>
  1057. ');
  1058. INSERT INTO system_template (title, comment, image, content) VALUES
  1059. ('TemplateTitleDesc', 'TemplateTitleCheckListDescription', 'description.gif', '
  1060. <head>
  1061. {CSS}
  1062. </head>
  1063. <body>
  1064. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1065. <tbody>
  1066. <tr>
  1067. <td style="width: 50%; vertical-align: top;">
  1068. <img style="width: 48px; height: 49px; float: left;" alt="01" src="{COURSE_DIR}images/small/01.png " hspace="5"><br>Lorem ipsum dolor sit amet<br><br><br>
  1069. <img style="width: 48px; height: 49px; float: left;" alt="02" src="{COURSE_DIR}images/small/02.png " hspace="5">
  1070. <br>Ut enim ad minim veniam<br><br><br>
  1071. <img style="width: 48px; height: 49px; float: left;" alt="03" src="{COURSE_DIR}images/small/03.png " hspace="5">Duis aute irure dolor in reprehenderit<br><br><br>
  1072. <img style="width: 48px; height: 49px; float: left;" alt="04" src="{COURSE_DIR}images/small/04.png " hspace="5">Neque porro quisquam est</td>
  1073. <td style="vertical-align: top; width: 50%; text-align: right;" colspan="1" rowspan="1">
  1074. <img style="width: 300px; height: 291px;" alt="Gearbox" src="{COURSE_DIR}images/diagrams/gearbox.jpg "><br></td>
  1075. </tr><tr></tr>
  1076. </tbody>
  1077. </table>
  1078. <p><br>
  1079. <br>
  1080. </p>
  1081. </body>
  1082. ');
  1083. /*
  1084. INSERT INTO system_template (title, comment, image, content) VALUES
  1085. ('TemplateTitleObjectives', 'TemplateTitleObjectivesDescription', 'courseobjectives.gif', '
  1086. <head>
  1087. {CSS}
  1088. </head>
  1089. <body>
  1090. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1091. <tbody>
  1092. <tr>
  1093. <td style="vertical-align: bottom; width: 33%;" colspan="1" rowspan="2">
  1094. <img style="width: 180px; height: 271px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_chair.png "><br>
  1095. </td>
  1096. <td style="height: 10%; width: 66%;"></td>
  1097. </tr>
  1098. <tr>
  1099. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; text-align: left; width: 66%;">
  1100. <h3>Lorem ipsum dolor sit amet</h3>
  1101. <ul>
  1102. <li>consectetur adipisicing elit</li>
  1103. <li>sed do eiusmod tempor incididunt</li>
  1104. <li>ut labore et dolore magna aliqua</li>
  1105. </ul>
  1106. <h3>Ut enim ad minim veniam</h3>
  1107. <ul>
  1108. <li>quis nostrud exercitation ullamco</li>
  1109. <li>laboris nisi ut aliquip ex ea commodo consequat</li>
  1110. <li>Excepteur sint occaecat cupidatat non proident</li>
  1111. </ul>
  1112. </td>
  1113. </tr>
  1114. </tbody>
  1115. </table>
  1116. <p><br>
  1117. <br>
  1118. </p>
  1119. </body>
  1120. ');
  1121. */
  1122. INSERT INTO system_template (title, comment, image, content) VALUES
  1123. ('TemplateTitleCycle', 'TemplateTitleCycleDescription', 'cyclechart.gif', '
  1124. <head>
  1125. {CSS}
  1126. <style>
  1127. .title
  1128. {
  1129. color: white; font-weight: bold;
  1130. }
  1131. </style>
  1132. </head>
  1133. <body>
  1134. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="8" cellspacing="6">
  1135. <tbody>
  1136. <tr>
  1137. <td style="text-align: center; vertical-align: bottom; height: 10%;" colspan="3" rowspan="1">
  1138. <img style="width: 250px; height: 76px;" alt="arrow" src="{COURSE_DIR}images/diagrams/top_arrow.png ">
  1139. </td>
  1140. </tr>
  1141. <tr>
  1142. <td style="height: 5%; width: 45%; vertical-align: top; background-color: rgb(153, 153, 153); text-align: center;">
  1143. <span class="title">Lorem ipsum</span>
  1144. </td>
  1145. <td style="height: 5%; width: 10%;"></td>
  1146. <td style="height: 5%; vertical-align: top; background-color: rgb(153, 153, 153); text-align: center;">
  1147. <span class="title">Sed ut perspiciatis</span>
  1148. </td>
  1149. </tr>
  1150. <tr>
  1151. <td style="background-color: rgb(204, 204, 255); width: 45%; vertical-align: top;">
  1152. <ul>
  1153. <li>dolor sit amet</li>
  1154. <li>consectetur adipisicing elit</li>
  1155. <li>sed do eiusmod tempor&nbsp;</li>
  1156. <li>adipisci velit, sed quia non numquam</li>
  1157. <li>eius modi tempora incidunt ut labore et dolore magnam</li>
  1158. </ul>
  1159. </td>
  1160. <td style="width: 10%;"></td>
  1161. <td style="background-color: rgb(204, 204, 255); width: 45%; vertical-align: top;">
  1162. <ul>
  1163. <li>ut enim ad minim veniam</li>
  1164. <li>quis nostrud exercitation</li><li>ullamco laboris nisi ut</li>
  1165. <li> Quis autem vel eum iure reprehenderit qui in ea</li>
  1166. <li>voluptate velit esse quam nihil molestiae consequatur,</li>
  1167. </ul>
  1168. </td>
  1169. </tr>
  1170. <tr align="center">
  1171. <td style="height: 10%; vertical-align: top;" colspan="3" rowspan="1">
  1172. <img style="width: 250px; height: 76px;" alt="arrow" src="{COURSE_DIR}images/diagrams/bottom_arrow.png ">&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;
  1173. </td>
  1174. </tr>
  1175. </tbody>
  1176. </table>
  1177. <p><br>
  1178. <br>
  1179. </p>
  1180. </body>
  1181. ');
  1182. /*
  1183. INSERT INTO system_template (title, comment, image, content) VALUES
  1184. ('TemplateTitleLearnerWonder', 'TemplateTitleLearnerWonderDescription', 'learnerwonder.gif', '
  1185. <head>
  1186. {CSS}
  1187. </head>
  1188. <body>
  1189. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1190. <tbody>
  1191. <tr>
  1192. <td style="width: 33%;" colspan="1" rowspan="4">
  1193. <img style="width: 120px; height: 348px;" alt="learner wonders" src="{COURSE_DIR}images/silhouette.png "><br>
  1194. </td>
  1195. <td style="width: 66%;"></td>
  1196. </tr>
  1197. <tr align="center">
  1198. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  1199. Convallis
  1200. ut.&nbsp;Cras dui magna.</td>
  1201. </tr>
  1202. <tr align="center">
  1203. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  1204. Etiam
  1205. lacinia stibulum ante.<br>
  1206. </td>
  1207. </tr>
  1208. <tr align="center">
  1209. <td style="background: transparent url({IMG_DIR}faded_grey.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 66%;">
  1210. Consectetuer
  1211. adipiscing elit. <br>
  1212. </td>
  1213. </tr>
  1214. </tbody>
  1215. </table>
  1216. <p><br>
  1217. <br>
  1218. </p>
  1219. </body>
  1220. ');
  1221. */
  1222. INSERT INTO system_template (title, comment, image, content) VALUES
  1223. ('TemplateTitleTimeline', 'TemplateTitleTimelineDescription', 'phasetimeline.gif', '
  1224. <head>
  1225. {CSS}
  1226. <style>
  1227. .title
  1228. {
  1229. font-weight: bold; text-align: center;
  1230. }
  1231. </style>
  1232. </head>
  1233. <body>
  1234. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="8" cellspacing="5">
  1235. <tbody>
  1236. <tr class="title">
  1237. <td style="vertical-align: top; height: 3%; background-color: rgb(224, 224, 224);">Lorem ipsum</td>
  1238. <td style="height: 3%;"></td>
  1239. <td style="vertical-align: top; height: 3%; background-color: rgb(237, 237, 237);">Perspiciatis</td>
  1240. <td style="height: 3%;"></td>
  1241. <td style="vertical-align: top; height: 3%; background-color: rgb(245, 245, 245);">Nemo enim</td>
  1242. </tr>
  1243. <tr>
  1244. <td style="vertical-align: top; width: 30%; background-color: rgb(224, 224, 224);">
  1245. <ul>
  1246. <li>dolor sit amet</li>
  1247. <li>consectetur</li>
  1248. <li>adipisicing elit</li>
  1249. </ul>
  1250. <br>
  1251. </td>
  1252. <td>
  1253. <img style="width: 32px; height: 32px;" alt="arrow" src="{COURSE_DIR}images/small/arrow.png ">
  1254. </td>
  1255. <td style="vertical-align: top; width: 30%; background-color: rgb(237, 237, 237);">
  1256. <ul>
  1257. <li>ut labore</li>
  1258. <li>et dolore</li>
  1259. <li>magni dolores</li>
  1260. </ul>
  1261. </td>
  1262. <td>
  1263. <img style="width: 32px; height: 32px;" alt="arrow" src="{COURSE_DIR}images/small/arrow.png ">
  1264. </td>
  1265. <td style="vertical-align: top; background-color: rgb(245, 245, 245); width: 30%;">
  1266. <ul>
  1267. <li>neque porro</li>
  1268. <li>quisquam est</li>
  1269. <li>qui dolorem&nbsp;&nbsp;</li>
  1270. </ul>
  1271. <br><br>
  1272. </td>
  1273. </tr>
  1274. </tbody>
  1275. </table>
  1276. <p><br>
  1277. <br>
  1278. </p>
  1279. </body>
  1280. ');
  1281. /*
  1282. INSERT INTO system_template (title, comment, image, content) VALUES
  1283. ('TemplateTitleStopAndThink', 'TemplateTitleStopAndThinkDescription', 'stopthink.gif', '
  1284. <head>
  1285. {CSS}
  1286. </head>
  1287. <body>
  1288. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1289. <tbody>
  1290. <tr>
  1291. <td style="vertical-align: bottom; width: 33%;" colspan="1" rowspan="2">
  1292. <img style="width: 180px; height: 169px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_staring.png ">
  1293. <br>
  1294. </td>
  1295. <td style="height: 10%; width: 66%;"></td>
  1296. </tr>
  1297. <tr>
  1298. <td style="background: transparent url({IMG_DIR}postit.png ) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; width: 66%; vertical-align: middle; text-align: center;">
  1299. <h3>Attentio sectetur adipisicing elit</h3>
  1300. <ul>
  1301. <li>sed do eiusmod tempor incididunt</li>
  1302. <li>ut labore et dolore magna aliqua</li>
  1303. <li>quis nostrud exercitation ullamco</li>
  1304. </ul><br></td>
  1305. </tr>
  1306. </tbody>
  1307. </table>
  1308. <p><br>
  1309. <br>
  1310. </p>
  1311. </body>
  1312. ');
  1313. */
  1314. INSERT INTO system_template (title, comment, image, content) VALUES
  1315. ('TemplateTitleTable', 'TemplateTitleCheckListDescription', 'table.gif', '
  1316. <head>
  1317. {CSS}
  1318. <style type="text/css">
  1319. .title
  1320. {
  1321. font-weight: bold; text-align: center;
  1322. }
  1323. .items
  1324. {
  1325. text-align: right;
  1326. }
  1327. </style>
  1328. </head>
  1329. <body>
  1330. <br />
  1331. <h2>A table</h2>
  1332. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px;" border="1" cellpadding="5" cellspacing="0">
  1333. <tbody>
  1334. <tr class="title">
  1335. <td>City</td>
  1336. <td>2005</td>
  1337. <td>2006</td>
  1338. <td>2007</td>
  1339. <td>2008</td>
  1340. </tr>
  1341. <tr class="items">
  1342. <td>Lima</td>
  1343. <td>10,40</td>
  1344. <td>8,95</td>
  1345. <td>9,19</td>
  1346. <td>9,76</td>
  1347. </tr>
  1348. <tr class="items">
  1349. <td>New York</td>
  1350. <td>18,39</td>
  1351. <td>17,52</td>
  1352. <td>16,57</td>
  1353. <td>16,60</td>
  1354. </tr>
  1355. <tr class="items">
  1356. <td>Barcelona</td>
  1357. <td>0,10</td>
  1358. <td>0,10</td>
  1359. <td>0,05</td>
  1360. <td>0,05</td>
  1361. </tr>
  1362. <tr class="items">
  1363. <td>Paris</td>
  1364. <td>3,38</td>
  1365. <td >3,63</td>
  1366. <td>3,63</td>
  1367. <td>3,54</td>
  1368. </tr>
  1369. </tbody>
  1370. </table>
  1371. <br>
  1372. </body>
  1373. ');
  1374. INSERT INTO system_template (title, comment, image, content) VALUES
  1375. ('TemplateTitleAudio', 'TemplateTitleAudioDescription', 'audiocomment.gif', '
  1376. <head>
  1377. {CSS}
  1378. </head>
  1379. <body>
  1380. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1381. <tbody>
  1382. <tr>
  1383. <td>
  1384. <div align="center">
  1385. <span style="text-align: center;">
  1386. <embed type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" width="300" height="20" bgcolor="#FFFFFF" src="{REL_PATH}main/inc/lib/mediaplayer/player.swf" allowfullscreen="false" allowscriptaccess="always" flashvars="file={COURSE_DIR}audio/ListeningComprehension.mp3&amp;autostart=true"></embed>
  1387. </span></div>
  1388. <br>
  1389. </td>
  1390. <td colspan="1" rowspan="3"><br>
  1391. <img style="width: 300px; height: 341px; float: right;" alt="image" src="{COURSE_DIR}images/diagrams/head_olfactory_nerve.png "><br></td>
  1392. </tr>
  1393. <tr>
  1394. <td colspan="1" rowspan="1">
  1395. <img style="width: 180px; height: 271px;" alt="trainer" src="{COURSE_DIR}images/trainer/trainer_glasses.png"><br></td>
  1396. </tr>
  1397. <tr>
  1398. </tr>
  1399. </tbody>
  1400. </table>
  1401. <p><br>
  1402. <br>
  1403. </p>
  1404. </body>
  1405. ');
  1406. INSERT INTO system_template (title, comment, image, content) VALUES
  1407. ('TemplateTitleVideo', 'TemplateTitleVideoDescription', 'video.gif', '
  1408. <head>
  1409. {CSS}
  1410. </head>
  1411. <body>
  1412. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 720px; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1413. <tbody>
  1414. <tr>
  1415. <td style="width: 50%; vertical-align: top;">
  1416. <div style="text-align: center;" id="player810625-parent">
  1417. <div style="border-style: none; overflow: hidden; width: 320px; height: 240px; background-color: rgb(220, 220, 220);">
  1418. <div id="player810625">
  1419. <div id="player810625-config" style="overflow: hidden; display: none; visibility: hidden; width: 0px; height: 0px;">url={REL_PATH}main/default_course_document/video/flv/example.flv width=320 height=240 loop=false play=false downloadable=false fullscreen=true displayNavigation=true displayDigits=true align=left dispPlaylist=none playlistThumbs=false</div>
  1420. </div>
  1421. <embed
  1422. type="application/x-shockwave-flash"
  1423. src="{REL_PATH}main/inc/lib/mediaplayer/player.swf"
  1424. width="320"
  1425. height="240"
  1426. id="single"
  1427. name="single"
  1428. quality="high"
  1429. allowfullscreen="true"
  1430. flashvars="width=320&height=240&autostart=false&file={REL_PATH}main/default_course_document/video/flv/example.flv&repeat=false&image=&showdownload=false&link={REL_PATH}main/default_course_document/video/flv/example.flv&showdigits=true&shownavigation=true&logo="
  1431. />
  1432. </div>
  1433. </div>
  1434. </td>
  1435. <td style="background: transparent url({IMG_DIR}faded_grey.png) repeat scroll center top; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; vertical-align: top; width: 50%;">
  1436. <h3><br>
  1437. </h3>
  1438. <h3>Lorem ipsum dolor sit amet</h3>
  1439. <ul>
  1440. <li>consectetur adipisicing elit</li>
  1441. <li>sed do eiusmod tempor incididunt</li>
  1442. <li>ut labore et dolore magna aliqua</li>
  1443. </ul>
  1444. <h3>Ut enim ad minim veniam</h3>
  1445. <ul>
  1446. <li>quis nostrud exercitation ullamco</li>
  1447. <li>laboris nisi ut aliquip ex ea commodo consequat</li>
  1448. <li>Excepteur sint occaecat cupidatat non proident</li>
  1449. </ul>
  1450. </td>
  1451. </tr>
  1452. </tbody>
  1453. </table>
  1454. <p><br>
  1455. <br>
  1456. </p>
  1457. <style type="text/css">body{}</style><!-- to fix a strange bug appearing with firefox when editing this template -->
  1458. </body>
  1459. ');
  1460. INSERT INTO system_template (title, comment, image, content) VALUES
  1461. ('TemplateTitleFlash', 'TemplateTitleFlashDescription', 'flash.gif', '
  1462. <head>
  1463. {CSS}
  1464. </head>
  1465. <body>
  1466. <center>
  1467. <table style="background: transparent url({IMG_DIR}faded_blue_horizontal.png ) repeat scroll 0% 50%; -moz-background-clip: initial; -moz-background-origin: initial; -moz-background-inline-policy: initial; text-align: left; width: 100%; height: 400px;" border="0" cellpadding="15" cellspacing="6">
  1468. <tbody>
  1469. <tr>
  1470. <td align="center">
  1471. <embed width="700" height="300" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" src="{COURSE_DIR}flash/SpinEchoSequence.swf" play="true" loop="true" menu="true"></embed></span><br />
  1472. </td>
  1473. </tr>
  1474. </tbody>
  1475. </table>
  1476. <p><br>
  1477. <br>
  1478. </p>
  1479. </center>
  1480. </body>
  1481. ');
  1482. INSERT INTO user_friend_relation_type (id, title)
  1483. VALUES
  1484. (1,'SocialUnknow'),
  1485. (2,'SocialParent'),
  1486. (3,'SocialFriend'),
  1487. (4,'SocialGoodFriend'),
  1488. (5,'SocialEnemy'),
  1489. (6,'SocialDeleted');
  1490. INSERT INTO skill (name, icon, description, short_code, access_url_id, updated_at) VALUES ('Root', '', '', 'root', 1, now());
  1491. INSERT INTO skill_rel_skill VALUES(1, 1, 0, 0, 0);
  1492. INSERT INTO course_type (id, name) VALUES (1, 'All tools');
  1493. INSERT INTO course_type (id, name) VALUES (2, 'Entry exam');
  1494. INSERT INTO sequence_rule (description)
  1495. VALUES ('If user completes 70% of an entity or group of items, he will be able to access another entity or group of items');
  1496. INSERT INTO sequence_condition (description, mat_op, param, act_true, act_false) VALUES ('<= 100%','<=', 100.0, 2, 0), ('>= 70%','>=', 70.0, 0, '');
  1497. INSERT INTO sequence_rule_condition VALUES
  1498. (1,1,1),
  1499. (2,1,2);
  1500. INSERT INTO sequence_method (description,formula, assign, met_type, act_false) VALUES
  1501. ('Add completed item','v#2 + $complete_items;', 2, 'add', ''),
  1502. ('Update progress by division', 'v#2 / v#3 * 100;', 1, 'div', ''),
  1503. ('Update items count', '$total_items;', 3,'update', ''),
  1504. ('Enable success', '1;', 4, 'success', ''),
  1505. ('Store success date', '(empty(v#5))? api_get_utc_datetime() : v#5;', 5, 'success', ''),
  1506. ('Enable availability', '1;', 6, 'pre', ''),
  1507. ('Store availability start date', '(empty(v#7))? api_get_utc_datetime() : v#7;', 7, 'pre', ''),
  1508. ('Store availability end date', '(empty($available_end_date))? api_get_utc_datetime($available_end_date) : "0000-00-00 00:00:00";', 8, 'pre', ''),
  1509. ('Increase the items count', 'v#3 + $total_items;', 3,'add', ''),
  1510. ('Update completed items', '$complete_items;', 2,'update', ''),
  1511. ('Update progress', '$complete_items / $total_items * 100;', 1, 'update', '');
  1512. INSERT INTO sequence_rule_method VALUES
  1513. (1,1,1,1),
  1514. (2,1,2,3),
  1515. (3,1,3,0),
  1516. (4,1,4,0),
  1517. (5,1,5,0),
  1518. (6,1,6,0),
  1519. (7,1,7,0),
  1520. (8,1,8,0),
  1521. (9,1,9,2),
  1522. (10,1,10,0),
  1523. (11,1,11,0);
  1524. INSERT INTO sequence_variable VALUES
  1525. (1, 'Percentile progress', 'advance', 0.0),
  1526. (2, 'Completed items', 'complete_items', 0),
  1527. (3, 'Items count', 'total_items', 0),
  1528. (4, 'Completed', 'success', 0),
  1529. (5, 'Completion date', 'success_date', '0000-00-00 00:00:00'),
  1530. (6, 'Available', 'available', 0),
  1531. (7, 'Availability start date', 'available_start_date', '0000-00-00 00:00:00'),
  1532. (8, 'Availability end date', 'available_end_date', '0000-00-00 00:00:00');
  1533. INSERT INTO sequence_formula VALUES
  1534. (1,1,2),
  1535. (2,2,2),
  1536. (3,2,3),
  1537. (4,2,1),
  1538. (5,3,3),
  1539. (6,4,4),
  1540. (7,5,5),
  1541. (8,6,6),
  1542. (9,7,7),
  1543. (10,8,8),
  1544. (11,9,3),
  1545. (12,10,2),
  1546. (13,11,1);
  1547. INSERT INTO sequence_valid VALUES
  1548. (1,1,1),
  1549. (2,1,2);
  1550. INSERT INTO sequence_type_entity VALUES
  1551. (1,'Lp', 'Learning Path','c_lp'),
  1552. (2,'Quiz', 'Quiz and Tests','c_quiz'),
  1553. (3,'LpItem', 'Items of a Learning Path','c_lp_item');
  1554. -- Version 1.10.0.39
  1555. INSERT INTO settings_current
  1556. (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable)
  1557. VALUES
  1558. ('hide_home_top_when_connected', '', 'radio', 'Platform', 'false', 'HideHomeTopContentWhenLoggedInText', 'HideHomeTopContentWhenLoggedInComment', NULL, '', true),
  1559. ('hide_global_announcements_when_not_connected','','radio','Platform','false', 'HideGlobalAnnouncementsWhenNotLoggedInText','HideGlobalAnnouncementsWhenNotLoggedInComment',NULL,'', true),
  1560. ('course_creation_use_template','','select_course','Course','','CourseCreationUsesTemplateText','CourseCreationUsesTemplateComment',NULL,'',true),
  1561. ('allow_strength_pass_checker','','radio','Security','true','EnablePasswordStrengthCheckerText','EnablePasswordStrengthCheckerComment',NULL,'',true),
  1562. ('allow_captcha','','radio','Security','false','EnableCaptchaText','EnableCaptchaComment',NULL,'',true),
  1563. ('captcha_number_mistakes_to_block_account','','textfield','Security',5,'CaptchaNumberOfMistakesBeforeBlockingAccountText','CaptchaNumberOfMistakesBeforeBlockingAccountComment',NULL,'',true),
  1564. ('captcha_time_to_block','','textfield','Security',5,'CaptchaTimeAccountIsLockedText','CaptchaTimeAccountIsLockedComment',NULL,'',true),
  1565. ('drh_can_access_all_session_content','','radio','Session','true','DRHAccessToAllSessionContentText','DRHAccessToAllSessionContentComment',NULL,'',true),
  1566. ('display_groups_forum_in_general_tool','','radio','Tools','true','ShowGroupForaInGeneralToolText','ShowGroupForaInGeneralToolComment',NULL,'',true),
  1567. ('allow_tutors_to_assign_students_to_session','','radio','Session','false','TutorsCanAssignStudentsToSessionsText','TutorsCanAssignStudentsToSessionsComment',NULL,'',true);
  1568. INSERT INTO settings_options (variable, value, display_text)
  1569. VALUES
  1570. ('hide_home_top_when_connected','true','Yes'),
  1571. ('hide_home_top_when_connected','false','No'),
  1572. ('hide_global_announcements_when_not_connected','true','Yes'),
  1573. ('hide_global_announcements_when_not_connected','false','No'),
  1574. ('allow_strength_pass_checker','true','Yes'),
  1575. ('allow_strength_pass_checker','false','No'),
  1576. ('allow_captcha','true','Yes'),
  1577. ('allow_captcha','false','No'),
  1578. ('drh_can_access_all_session_content','true','Yes'),
  1579. ('drh_can_access_all_session_content','false','No'),
  1580. ('display_groups_forum_in_general_tool','true','Yes'),
  1581. ('display_groups_forum_in_general_tool','false','No'),
  1582. ('allow_tutors_to_assign_students_to_session','true','Yes'),
  1583. ('allow_tutors_to_assign_students_to_session','false','No');
  1584. UPDATE user SET username_canonical = username;
  1585. -- Version 1.10.0.40
  1586. INSERT INTO settings_current (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable)
  1587. VALUES
  1588. ('allow_lp_return_link', NULL, 'radio', 'Course', 'true', 'AllowLearningPathReturnLinkTitle', 'AllowLearningPathReturnLinkComment', NULL, NULL, 1),
  1589. ('hide_scorm_export_link', NULL, 'radio', 'Course', 'false', 'HideScormExportLinkTitle', 'HideScormExportLinkComment', NULL, NULL, 1),
  1590. ('hide_scorm_copy_link', NULL, 'radio', 'Course', 'false', 'HideScormCopyLinkTitle', 'HideScormCopyLinkComment', NULL, NULL, 1),
  1591. ('hide_scorm_pdf_link', NULL, 'radio', 'Course', 'true', 'HideScormPdfLinkTitle', 'HideScormPdfLinkComment', NULL, NULL, 1),
  1592. ('session_days_before_coach_access', NULL, 'textfield', 'Session', '0', 'SessionDaysBeforeCoachAccessTitle', 'SessionDaysBeforeCoachAccessComment', NULL, NULL, 1),
  1593. ('session_days_after_coach_access', NULL, 'textfield', 'Session', '0', 'SessionDaysAfterCoachAccessTitle', 'SessionDaysAfterCoachAccessComment', NULL, NULL, 1),
  1594. ('pdf_logo_header', NULL, 'radio', 'Course', 'false', 'PdfLogoHeaderTitle', 'PdfLogoHeaderComment', NULL, NULL, 1),
  1595. ('order_user_list_by_official_code', NULL, 'radio', 'Platform', 'false', 'OrderUserListByOfficialCodeTitle', 'OrderUserListByOfficialCodeComment', NULL, NULL, 1),
  1596. ('email_alert_manager_on_new_quiz', NULL, 'radio', 'Tools', 'true', 'AlertManagerOnNewQuizTitle', 'AlertManagerOnNewQuizComment', NULL, NULL, 1),
  1597. ('show_official_code_exercise_result_list', NULL, 'radio', 'Tools', 'false', 'ShowOfficialCodeInExerciseResultListTitle', 'ShowOfficialCodeInExerciseResultListComment', NULL, NULL, 1),
  1598. ('course_catalog_hide_private', NULL, 'radio', 'Platform', 'false', 'HidePrivateCoursesFromCourseCatalogTitle', 'HidePrivateCoursesFromCourseCatalogComment', NULL, NULL, 1),
  1599. ('catalog_show_courses_sessions', NULL, 'radio', 'Platform', '0', 'CoursesCatalogueShowSessionsTitle', 'CoursesCatalogueShowSessionsComment', NULL, NULL, 1),
  1600. ('auto_detect_language_custom_pages', NULL, 'radio', 'Platform', 'true', 'AutoDetectLanguageCustomPagesTitle', 'AutoDetectLanguageCustomPagesComment', NULL, NULL, 1),
  1601. ('lp_show_reduced_report', NULL, 'radio', 'Tools', 'false', 'LearningPathShowReducedReportTitle', 'LearningPathShowReducedReportComment', NULL, NULL, 1),
  1602. ('allow_session_course_copy_for_teachers', NULL, 'radio', 'Session', 'false', 'AllowSessionCourseCopyForTeachersTitle', 'AllowSessionCourseCopyForTeachersComment', NULL, NULL, 1),
  1603. ('hide_logout_button', NULL, 'radio', 'Platform', 'false', 'HideLogoutButtonTitle', 'HideLogoutButtonComment', NULL, NULL, 1),
  1604. ('redirect_admin_to_courses_list', NULL, 'radio', 'Platform', 'false', 'RedirectAdminToCoursesListTitle', 'RedirectAdminToCoursesListComment', NULL, NULL, 1),
  1605. ('course_images_in_courses_list', NULL, 'radio', 'Course', 'true', 'CourseImagesInCoursesListTitle', 'CourseImagesInCoursesListComment', NULL, NULL, 1),
  1606. ('student_publication_to_take_in_gradebook', NULL, 'radio', 'Gradebook', 'first', 'StudentPublicationSelectionForGradebookTitle', 'StudentPublicationSelectionForGradebookComment', NULL, NULL, 1),
  1607. ('certificate_filter_by_official_code', NULL, 'radio', 'Gradebook', 'false', 'FilterCertificateByOfficialCodeTitle', 'FilterCertificateByOfficialCodeComment', NULL, NULL, 1),
  1608. ('exercise_max_ckeditors_in_page', NULL, 'textfield', 'Tools', '0', 'MaxCKeditorsOnExerciseResultsPageTitle', 'MaxCKeditorsOnExerciseResultsPageComment', NULL, NULL, 1),
  1609. ('document_if_file_exists_option', NULL, 'radio', 'Tools', 'rename', 'DocumentDefaultOptionIfFileExistsTitle', 'DocumentDefaultOptionIfFileExistsComment', NULL, NULL, 1),
  1610. ('add_gradebook_certificates_cron_task_enabled', NULL, 'radio', 'Tools', 'false', 'GradebookCronTaskGenerationTitle', 'GradebookCronTaskGenerationComment', NULL, NULL, 1),
  1611. ('openbadges_backpack', NULL, 'textfield', 'Gradebook', 'https://backpack.openbadges.org/', 'OpenBadgesBackpackUrlTitle', 'OpenBadgesBackpackUrlComment', NULL, NULL, 1),
  1612. ('cookie_warning', NULL, 'radio', 'Tools', 'false', 'CookieWarningTitle', 'CookieWarningComment', NULL, NULL, 1),
  1613. ('hide_course_group_if_no_tools_available', NULL, 'radio', 'Tools', 'false', 'HideCourseGroupIfNoToolAvailableTitle', 'HideCourseGroupIfNoToolAvailableComment', NULL, NULL, 1),
  1614. ('catalog_allow_session_auto_subscription', NULL, 'radio', 'Session', 'false', 'CatalogueAllowSessionAutoSubscriptionTitle', 'CatalogueAllowSessionAutoSubscriptionTitle', NULL, NULL, 1),
  1615. ('registration.soap.php.decode_utf8', NULL, 'radio', 'Platform', 'false', 'SoapRegistrationDecodeUtf8Title', 'SoapRegistrationDecodeUtf8Comment', NULL, NULL, 1),
  1616. ('allow_delete_attendance', NULL, 'radio', 'Tools', 'true', 'AttendanceDeletionEnableTitle', 'AttendanceDeletionEnableComment', NULL, NULL, 1),
  1617. ('gravatar_enabled', NULL, 'radio', 'Platform', 'false', 'GravatarPicturesTitle', 'GravatarPicturesComment', NULL, NULL, 1),
  1618. ('gravatar_type', NULL, 'radio', 'Platform', 'mm', 'GravatarPicturesTypeTitle', 'GravatarPicturesTypeComment', NULL, NULL, 1),
  1619. ('limit_session_admin_role', NULL, 'radio', 'Session', 'false', 'SessionAdminPermissionsLimitTitle', 'SessionAdminPermissionsLimitComment', NULL, NULL, 1),
  1620. ('show_session_description', NULL, 'radio', 'Session', 'false', 'ShowSessionDescriptionTitle', 'ShowSessionDescriptionComment', NULL, NULL, 1),
  1621. ('hide_certificate_export_link_students', NULL, 'radio', 'Gradebook', 'false', 'CertificateHideExportLinkStudentTitle', 'CertificateHideExportLinkStudentComment', NULL, NULL, 1),
  1622. ('hide_certificate_export_link', NULL, 'radio', 'Gradebook', 'false', 'CertificateHideExportLinkTitle', 'CertificateHideExportLinkComment', NULL, NULL, 1),
  1623. ('dropbox_hide_course_coach', NULL, 'radio', 'Tools', 'false', 'DropboxHideCourseCoachTitle', 'DropboxHideCourseCoachComment', NULL, NULL, 1),
  1624. ('dropbox_hide_general_coach', NULL, 'radio', 'Tools', 'false', 'DropboxHideGeneralCoachTitle', 'DropboxHideGeneralCoachComment', NULL, NULL, 1),
  1625. ('sso_force_redirect', NULL, 'radio', 'Security', 'false', 'SSOForceRedirectTitle', 'SSOForceRedirectComment', NULL, NULL, 1),
  1626. ('session_course_ordering', NULL, 'radio', 'Session', 'false', 'SessionCourseOrderingTitle', 'SessionCourseOrderingComment', NULL, NULL, 1),
  1627. ('gamification_mode', NULL, 'radio', 'Platform', '0', 'GamificationModeTitle', 'GamificationModeComment', NULL, NULL, 1),
  1628. ('prevent_multiple_simultaneous_login', NULL, 'radio', 'Security', 'false', 'PreventMultipleSimultaneousLoginTitle', 'PreventMultipleSimultaneousLoginComment', NULL, NULL, 0),
  1629. ('gradebook_detailed_admin_view', NULL, 'radio', 'Gradebook', 'false', 'ShowAdditionalColumnsInStudentResultsPageTitle', 'ShowAdditionalColumnsInStudentResultsPageComment', NULL, NULL, 1),
  1630. ('course_catalog_published', NULL, 'radio', 'Course', 'false', 'CourseCatalogIsPublicTitle', 'CourseCatalogIsPublicComment', NULL, NULL, 0),
  1631. ('user_reset_password', NULL, 'radio', 'Security', 'false', 'ResetPasswordTokenTitle', 'ResetPasswordTokenComment', NULL, NULL, 0),
  1632. ('user_reset_password_token_limit', NULL, 'textfield', 'Security', '3600', 'ResetPasswordTokenLimitTitle', 'ResetPasswordTokenLimitComment', NULL, NULL, 0),
  1633. ('my_courses_view_by_session', NULL, 'radio', 'Session', 'false', 'ViewMyCoursesListBySessionTitle', 'ViewMyCoursesListBySessionComment', NULL, NULL, 0),
  1634. ('show_full_skill_name_on_skill_wheel', NULL, 'radio', 'Platform', 'false', 'ShowFullSkillNameOnSkillWheelTitle', 'ShowFullSkillNameOnSkillWheelComment', NULL, NULL, 1);
  1635. INSERT INTO settings_options (variable, value, display_text)
  1636. VALUES
  1637. ('allow_lp_return_link', 'true', 'Yes'),
  1638. ('allow_lp_return_link', 'false', 'No'),
  1639. ('hide_scorm_export_link', 'true', 'Yes'),
  1640. ('hide_scorm_export_link', 'false', 'No'),
  1641. ('hide_scorm_copy_link', 'true', 'Yes'),
  1642. ('hide_scorm_copy_link', 'false', 'No'),
  1643. ('hide_scorm_pdf_link', 'true', 'Yes'),
  1644. ('hide_scorm_pdf_link', 'false', 'No'),
  1645. ('pdf_logo_header', 'true', 'Yes'),
  1646. ('pdf_logo_header', 'false', 'No'),
  1647. ('order_user_list_by_official_code', 'true', 'Yes'),
  1648. ('order_user_list_by_official_code', 'false', 'No'),
  1649. ('email_alert_manager_on_new_quiz', 'true', 'Yes'),
  1650. ('email_alert_manager_on_new_quiz', 'false', 'No'),
  1651. ('show_official_code_exercise_result_list', 'true', 'Yes'),
  1652. ('show_official_code_exercise_result_list', 'false', 'No'),
  1653. ('course_catalog_hide_private', 'true', 'Yes'),
  1654. ('course_catalog_hide_private', 'false', 'No'),
  1655. ('catalog_show_courses_sessions', '0', 'CatalogueShowOnlyCourses'),
  1656. ('catalog_show_courses_sessions', '1', 'CatalogueShowOnlySessions'),
  1657. ('catalog_show_courses_sessions', '2', 'CatalogueShowCoursesAndSessions'),
  1658. ('auto_detect_language_custom_pages', 'true', 'Yes'),
  1659. ('auto_detect_language_custom_pages', 'false', 'No'),
  1660. ('lp_show_reduced_report', 'true', 'Yes'),
  1661. ('lp_show_reduced_report', 'false', 'No'),
  1662. ('allow_session_course_copy_for_teachers', 'true', 'Yes'),
  1663. ('allow_session_course_copy_for_teachers', 'false', 'No'),
  1664. ('hide_logout_button', 'true', 'Yes'),
  1665. ('hide_logout_button', 'false', 'No'),
  1666. ('redirect_admin_to_courses_list', 'true', 'Yes'),
  1667. ('redirect_admin_to_courses_list', 'false', 'No'),
  1668. ('course_images_in_courses_list', 'true', 'Yes'),
  1669. ('course_images_in_courses_list', 'false', 'No'),
  1670. ('student_publication_to_take_in_gradebook', 'first', 'First'),
  1671. ('student_publication_to_take_in_gradebook', 'last', 'Last'),
  1672. ('certificate_filter_by_official_code', 'true', 'Yes'),
  1673. ('certificate_filter_by_official_code', 'false', 'No'),
  1674. ('document_if_file_exists_option', 'rename', 'Rename'),
  1675. ('document_if_file_exists_option', 'overwrite', 'Overwrite'),
  1676. ('add_gradebook_certificates_cron_task_enabled', 'true', 'Yes'),
  1677. ('add_gradebook_certificates_cron_task_enabled', 'false', 'No'),
  1678. ('cookie_warning', 'true', 'Yes'),
  1679. ('cookie_warning', 'false', 'No'),
  1680. ('hide_course_group_if_no_tools_available', 'true', 'Yes'),
  1681. ('hide_course_group_if_no_tools_available', 'false', 'No'),
  1682. ('catalog_allow_session_auto_subscription', 'true', 'Yes'),
  1683. ('catalog_allow_session_auto_subscription', 'false', 'No'),
  1684. ('registration.soap.php.decode_utf8', 'true', 'Yes'),
  1685. ('registration.soap.php.decode_utf8', 'false', 'No'),
  1686. ('allow_delete_attendance', 'true', 'Yes'),
  1687. ('allow_delete_attendance', 'false', 'No'),
  1688. ('gravatar_enabled', 'true', 'Yes'),
  1689. ('gravatar_enabled', 'false', 'No'),
  1690. ('gravatar_type', 'mm', 'mistery-man'),
  1691. ('gravatar_type', 'identicon', 'identicon'),
  1692. ('gravatar_type', 'monsterid', 'monsterid'),
  1693. ('gravatar_type', 'wavatar', 'wavatar'),
  1694. ('limit_session_admin_role', 'true', 'Yes'),
  1695. ('limit_session_admin_role', 'false', 'No'),
  1696. ('show_session_description', 'true', 'Yes'),
  1697. ('show_session_description', 'false', 'No'),
  1698. ('hide_certificate_export_link_students', 'true', 'Yes'),
  1699. ('hide_certificate_export_link_students', 'false', 'No'),
  1700. ('hide_certificate_export_link', 'true', 'Yes'),
  1701. ('hide_certificate_export_link', 'false', 'No'),
  1702. ('dropbox_hide_course_coach', 'true', 'Yes'),
  1703. ('dropbox_hide_course_coach', 'false', 'No'),
  1704. ('dropbox_hide_general_coach', 'true', 'Yes'),
  1705. ('dropbox_hide_general_coach', 'false', 'No'),
  1706. ('sso_force_redirect', 'true', 'Yes'),
  1707. ('sso_force_redirect', 'false', 'No'),
  1708. ('session_course_ordering', 'true', 'Yes'),
  1709. ('session_course_ordering', 'false', 'No'),
  1710. ('gamification_mode', '1', 'Yes'),
  1711. ('gamification_mode', '0', 'No'),
  1712. ('prevent_multiple_simultaneous_login', 'true', 'Yes'),
  1713. ('prevent_multiple_simultaneous_login', 'false', 'No'),
  1714. ('gradebook_detailed_admin_view', 'true', 'Yes'),
  1715. ('gradebook_detailed_admin_view', 'false', 'No'),
  1716. ('course_catalog_published', 'true', 'Yes'),
  1717. ('course_catalog_published', 'false', 'No'),
  1718. ('user_reset_password', 'true', 'Yes'),
  1719. ('user_reset_password', 'false', 'No'),
  1720. ('my_courses_view_by_session', 'true', 'Yes'),
  1721. ('my_courses_view_by_session', 'false', 'No'),
  1722. ('show_full_skill_name_on_skill_wheel', 'true', 'Yes'),
  1723. ('show_full_skill_name_on_skill_wheel', 'false', 'No');
  1724. -- Version 1.11.0.1
  1725. INSERT INTO settings_current (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable)
  1726. VALUES
  1727. ('messaging_allow_send_push_notification', NULL, 'radio', 'WebServices', 'false', 'MessagingAllowSendPushNotificationTitle', 'MessagingAllowSendPushNotificationComment', NULL, NULL, 0),
  1728. ('messaging_gdc_project_number', NULL, 'textfield', 'WebServices', '', 'MessagingGDCProjectNumberTitle', 'MessagingGDCProjectNumberComment', NULL, NULL, 0),
  1729. ('messaging_gdc_api_key', NULL, 'textfield', 'WebServices', '', 'MessagingGDCApiKeyTitle', 'MessagingGDCApiKeyComment', NULL, NULL, 0);
  1730. INSERT INTO settings_options (variable, value, display_text)
  1731. VALUES
  1732. ('messaging_allow_send_push_notification', 'true', 'Yes'),
  1733. ('messaging_allow_send_push_notification', 'false', 'No');
  1734. -- Version 1.11.0.2
  1735. INSERT INTO settings_current (variable, subkey, type, category, selected_value, title, comment, scope, subkeytext, access_url_changeable)
  1736. VALUES
  1737. ('teacher_can_select_course_template', NULL, 'radio', 'Course', 'false', 'TeacherCanSelectCourseTemplateTitle', 'TeacherCanSelectCourseTemplateComment', NULL, NULL, 0);
  1738. INSERT INTO settings_options (variable, value, display_text)
  1739. VALUES
  1740. ('teacher_can_select_course_template', 'true', 'Yes'),
  1741. ('teacher_can_select_course_template', 'false', 'No');
  1742. UPDATE settings_current SET selected_value = '1.11.0.2' WHERE variable = 'chamilo_database_version';