Bazaar is a multifunction system that does Web Conferencing, IRC chat, link management, and sgml publication (for the ICAAP system). Bazaar uses MySQL at the back end and features customizable interfaces, API, multiple languages and a host of other featu
Be the first to post a text review of Bazaar - MySQL Educational System. Rate and review a project by clicking thumbs up or thumbs down in the right column.
You can download Bazaar Learning Management System version 7.11 from the Files section. Please read the INSTALL file for details on how to get it up and running. Also read the Release note if you are upgrading from an earlier version. New Modules : Some of the new Modules/Resources added are Glossary and Blog. Comments and criticisms are most welcome. If you have any, please post them on our current Bazaar 7 system at http://klaatu.pc.athabascau.ca/cgi-bin/b7/main.pl?rid=29
08/20/2004 - Added a field to the modPortfolioAttachments. This field is to control if the file belong to the admin user or the poster. alter table modPortfolioAttachments add column Admin Enum ('Yes', 'No') not null default 'No' after MimeType; 08/31/2004 - Added a new module for the Glossary module. This module allows you to add glossary terms to the system. See b7/modGlossary for more information 10/08/2004 - Added a new module to the system called Blog. This is a blogging system and it can be used for all things. See b7/modBlog for more information 10/28/2004 - Added the ability to include the event start dates/times and event end dates/times create table modCalenderEvents_bak select * from modCalenderEvents; alter table modCalenderEvents change column EventMonth EventMonth varchar (2) not null; update modCalenderEvents set EventMonth = concat(0,EventMonth) where length(EventMonth) = 1; alter table modCalenderEvents change column EventDay EventDay varchar (2) not null; update modCalenderEvents set EventDay = concat(0,EventDay) where length(EventDay) = 1; alter table modCalenderEvents change column EventHour EventHour varchar (2) not null; update modCalenderEvents set EventHour = concat(0,EventHour) where length(EventHour) = 1; alter table modCalenderEvents change column EventMinutes EventMinutes varchar (2) not null; update modCalenderEvents set EventMinutes = concat(0,EventMinutes) where length(EventMinutes) = 1; alter table modCalenderEvents add column Tempdate varchar (19) after ReminderSentTime; alter table modCalenderEvents add column EventStartDate varchar (12) not null after LastModified; alter table modCalenderEvents add column EventEndDate varchar (12) not null after EventStartDate; update modCalenderEvents set TempDate = concat(EventYear,'-',EventMonth,'-',EventDay,' ',EventHour,':',EventMinutes,':','00'); update modCalenderEvents set EventStartDate = DATE_FORMAT(Tempdate, '%Y%m%d%H%i'); update modCalenderEvents set EventEndDate = DATE_FORMAT(Tempdate + INTERVAL DurationHours+DurationMinutes/60 HOUR, '%Y%m%d%H%i'); alter table modCalenderEvents drop column TempDate; alter table modCalenderEvents drop column EventYear; alter table modCalenderEvents drop column EventMonth; alter table modCalenderEvents drop column EventDay; alter table modCalenderEvents drop column EventHour; alter table modCalenderEvents drop column EventMinutes; alter table modCalenderEvents drop column DurationMinutes; alter table modCalenderEvents drop column DurationHours; 01/01/2005 # Sat 13th Nov, 2004 # modForums alter table modForums drop column CheckSpelling; alter table modForums drop column SpellCheckPath; alter table modForums drop column ZipPath; # modGuestBook drop table modGuestBook; delete from Resources where ResourceType="Config" and Title="modGuestBook"; delete from modConfigModules where ModuleId='modGuestBook'; # modAssignment drop table modAssignment; delete from Resources where ResourceType="Config" and Title="modAssignment"; delete from modConfigModules where ModuleId='modAssignment'; # modBlog drop table modBlog; delete from Resources where ResourceType="Config" and Title="modBlog"; delete from modConfigModules where ModuleId='modBlog'; # modPrivateMail alter table modPrivateMail drop column CheckSpelling; alter table modPrivateMail drop column SpellCheckPath; # modSendEmail alter table modSendEmail drop column CheckSpelling; alter table modSendEmail drop column SpellCheckPath; # b7/createtables.sql alter table System add column DocumentPath varchar (128) not null default '/var/www/html/' after UploadDir; alter table System add column DefaultLanguage char (2) not null default 'EN' after DocumentPath; alter table System add column ZipPath varchar (64) not null default '/usr/bin/zip' after DefaultLanguage; alter table System add column UnZipPath varchar (64) not null default '/usr/bin/unzip' after ZipPath; alter table System add column EnableSpellCheck Enum ('Yes', 'No') not null default 'No' after UnZipPath; alter table System add column SpellCheckPath varchar (64) not null default '/usr/bin/ispell' after EnableSpellCheck; alter table System add column EnableHtmlEditor Enum ('Yes', 'No') not null default 'Yes' after SpellCheckPath; # Sun 14th Nov, 2004 update System set UploadDir = concat(LocalPath,UploadDir); alter table System modify column UploadDir varchar ( 100 ) not null default '/var/www/cgi-bin/b7/attachments/'; 01/07/2005 - Changed the File Assignment Drop box to accept multiple files rename table modDropboxFiles to modDropboxEntries; create table modDropboxEntryFiles ( AttachId int (9) not null auto_increment, key index1( AttachId ) ) select FileId,ResourceId,Filename,MimeType,Postdate as CreationDate, IP from modDropboxEntries; alter table modDropboxEntries drop column MimeType; alter table modDropboxEntries drop column Filename; 01/21/2005 - Added the OwnerId to the Files table rename table modDropboxEntryFiles to modDropboxEntryFiles_bak; create table modDropboxEntryFiles ( AttachId int (9) not null auto_increment, key index1( AttachId ) ) select F1.FileId,F1.ResourceId,F1.Filename,F1.MimeType,F1.CreationDate, F1.IP, E1.PosterId from modDropboxEntries as E1, modDropboxEntryFiles_bak as F1 where F1.FileId=E1.FileId and F1.ResourceId=E1.ResourceId order by F1.FileId; drop table modDropboxEntryFiles_bak; 02/08/2005 - Added a table for the languages create table Languages ( Id int ( 9 ) not null auto_increment, ISO varchar ( 10 ) not null default 'EN', Name varchar ( 128 ), primary key indx1 (Id) ); insert into Languages values(null, 'EN', 'English'); # Added first draft of Spanish language translation insert into Languages values(null, 'ES', 'Spanish'); 03/15/2005 - Added first draft of French language translation insert into Languages values(null, 'FR', 'French'); 03/23/2005 - Added first draft of German language translation insert into Languages values(null, 'DE', 'German'); 08/02/2005 : Release Bazaar Version 7.11 =================================================================
Be the first person to add a text review.
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?
Thanks for your review!
Get credit for your review by logging in via OpenID. Click your account provider: