Fóruns do Joomla.com.br e JoomlaBrasil.org

Olá,

Percebi que o nem o Mambo nem o PHPNuke tem opções de instalação para este servidor. O PHPBB2 contem suporte para o MS SQL, e venho utilizando-o com este tipo de servidor com bastante sucesso (principalmente em intranets).

Como sou desenvolvedor para Intranets e Extranets e utilizo plataforma IIS, rodando tanto PHP quanto ASP, acho que seria um interessante desenvolvimento, pois acredito que existam outros desenvolvedores que seriam atraidos a ferramenta MAMBO caso ela contivesse esta capacidade.

Tenho pleno dominio de servidores MS SQL e posso auxiliar no desenvolvimento dos Scripts SQL específicos para este servidor.

Já inicie e conversão dos Scripts originais de criação e população do banco de dados do Mambo.

Espero obter ajuda junto a comunicade de usuários do Mambo para criarmos os Scripts PHP necessários a comunicação com o MS SQL.

Segue algumas das conversões que fiz:

Post edited by: FabianoCavalcanti, at: 06/05/2004 18:16

Post edited by: FabianoCavalcanti, at: 06/05/2004 18:20

drop_table_mssql.sql
/*
# Script Principal
# --------------------------------------------------------
*/

if exists (select * from sysobjects where name = \'meubr7_banner\') drop table meubr7_banner
if exists (select * from sysobjects where name = \'meubr7_bannerclient\') drop table meubr7_bannerclient
if exists (select * from sysobjects where name = \'meubr7_bannerfinish\') drop table meubr7_bannerfinish
if exists (select * from sysobjects where name = \'meubr7_categories\') drop table meubr7_categories
if exists (select * from sysobjects where name = \'meubr7_components\') drop table meubr7_components
if exists (select * from sysobjects where name = \'meubr7_contact_details\') drop table meubr7_contact_details
if exists (select * from sysobjects where name = \'meubr7_content\') drop table meubr7_content
if exists (select * from sysobjects where name = \'meubr7_content_frontpage\') drop table meubr7_content_frontpage
if exists (select * from sysobjects where name = \'meubr7_content_rating\') drop table meubr7_content_rating
if exists (select * from sysobjects where name = \'meubr7_core_acl_aro\') drop table meubr7_core_acl_aro
if exists (select * from sysobjects where name = \'meubr7_core_acl_aro_groups\') drop table meubr7_core_acl_aro_groups
if exists (select * from sysobjects where name = \'meubr7_core_acl_aro_sections\') drop table meubr7_core_acl_aro_sections
if exists (select * from sysobjects where name = \'meubr7_core_acl_groups_aro_map\') drop table meubr7_core_acl_groups_aro_map
if exists (select * from sysobjects where name = \'meubr7_core_log_items\') drop table meubr7_core_log_items
if exists (select * from sysobjects where name = \'meubr7_core_log_searches\') drop table meubr7_core_log_searches
if exists (select * from sysobjects where name = \'meubr7_groups\') drop table meubr7_groups
if exists (select * from sysobjects where name = \'meubr7_help\') drop table meubr7_help
if exists (select * from sysobjects where name = \'meubr7_menu\') drop table meubr7_menu
if exists (select * from sysobjects where name = \'meubr7_messages\') drop table meubr7_messages
if exists (select * from sysobjects where name = \'meubr7_messages_cfg\') drop table meubr7_messages_cfg
if exists (select * from sysobjects where name = \'meubr7_modules\') drop table meubr7_modules
if exists (select * from sysobjects where name = \'meubr7_modules_menu\') drop table meubr7_modules_menu
if exists (select * from sysobjects where name = \'meubr7_newsfeeds\') drop table meubr7_newsfeeds
if exists (select * from sysobjects where name = \'meubr7_newsfeedscache\') drop table meubr7_newsfeedscache
if exists (select * from sysobjects where name = \'meubr7_newsflash\') drop table meubr7_newsflash
if exists (select * from sysobjects where name = \'meubr7_poll_data\') drop table meubr7_poll_data
if exists (select * from sysobjects where name = \'meubr7_poll_date\') drop table meubr7_poll_date
if exists (select * from sysobjects where name = \'meubr7_poll_menu\') drop table meubr7_poll_menu
if exists (select * from sysobjects where name = \'meubr7_polls\') drop table meubr7_polls
if exists (select * from sysobjects where name = \'meubr7_sections\') drop table meubr7_sections
if exists (select * from sysobjects where name = \'meubr7_session\') drop table meubr7_session
if exists (select * from sysobjects where name = \'meubr7_stats_agents\') drop table meubr7_stats_agents
if exists (select * from sysobjects where name = \'meubr7_templates\') drop table meubr7_templates
if exists (select * from sysobjects where name = \'meubr7_users\') drop table meubr7_users
if exists (select * from sysobjects where name = \'meubr7_usertypes\') drop table meubr7_usertypes
if exists (select * from sysobjects where name = \'meubr7_weblinks\') drop table meubr7_weblinks

help_mssql.sql
*
# Adicionando dados na tabela meubr7_help
*/
SET IDENTITY_INSERT [meubr7_help] ON

INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (1,\'eng\',\'\',\'Introduction to Mambo Open Source 4.5\',\'Introduction\',0,2,\'Welcome to Mambo Open Source Version 4.5. Mambo is a powerful and easy to use Content Management System (and more).Mambo uses a unique tool based management interface called the Administrator to make website management easy, productive and fun, without compromising power.Mambo\'\'s power lies in being extraordinarily easy to set up and simple to use.\\r\\nMaking the simple complicated is commonplace \\r\\nmaking the complicated simple,\\r\\nawesomely simple, that\'\'s creativity.\\r\\n- Charles Mingus \\r\\n\\r\\n\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (2,\'eng\',\'\',\'Site\',\'Site Configuration\',0,4,\'\\r\\n \\r\\n \\r\\n Menu bar :: Site :: Configuration\\r\\n Configuration is the first available option on the Menu bar.\\r\\n \\r\\n \\r\\n \\r\\n \\r\\n \\r\\n \\r\\n \\r\\n \\r\\n \\r\\n \\r\\n Site configuration provides 4 tab controlled options: Site, Database , System and Meta data.\\r\\n Let\'\'s look at them one at a time.\\r\\n \\r\\n Site Configuration - first tabbed workspace\\r\\n \\r\\n Site Off-line: is effectively a switch to turn your website Frontend on or off. You might use this option if you are extensively updating your website and do not wish users to see the site half finished.\\r\\n \\r\\n Off-line Message: The off-line message is what your users will see if the Site off-line switch is in the \'\'Off\'\' position.\\r\\n Language: Sets the default language for your website.\\r\\n Default Page: This option determines which section of your website will serve as the Homepage. Default option are the sections Home, News, Articles, Weblinks, FAQ and Contact Us.\\r\\n Site Name: This option allows you to set the content of the title bar of your site.\\r\\n Authorization: When set to \'\'Yes\'\' users will require a login and password in order to view the site.\\r\\n [ NOTE: Correct me if I\'\'m wrong =), may well be]\\r\\n Use banner: \\r\\n Cookie Lifetime: \\r\\n Debug site:\\r\\n \\r\\n Site Configuration -second tabbed workspace - Database\\r\\n Warning: Very important settings. If your mambo website has been installed on your behalf do not alter these settings.\\r\\n The settings available in this tabbed workspace are:\\r\\n Hostname: Typically set to Local host.\\r\\n MySQL Username: The username used to access your Mambo database.\\r\\n MySQL Password: The password used to access your Mambo database. \\r\\n MySQL Database: The name of the database your Mambo install uses.\\r\\n MySQL Database Prefix: The prefix used for records in your Mambo database.\\r\\n \\r\\n Site Configuration -third tabbed workspace - System\\r\\n These items are predefined during the installation and are not configurable through this tab.\\r\\n Absolute Path: The directory information used by Mambo on the Server to orientate it to it\'\'s surrounding system.\\r\\n Live Site: This is the absolute URL (web address) for your install of Mambo.\\r\\n \\r\\n Site Configuration -fourth tabbed workspace - Meta data\\r\\n A meta tag is a tag (that is, a coding statement) in the Hypertext Markup Language (HTML) that describes some \\r\\n aspect of the contents of a Web page.\\r\\n The Description and Keyword Meta tags have a bearing on how Search Engines will index your site.\\r\\n Meta Description: A description of your website, limit your description to twenty characters and make it \\r\\n just that, descriptive, and pertinent to your site\'\'s contents.\\r\\n Meta Keywords: The optimal number of characters for a keyword description is said to be between 300 and 500. Do not repeat words and separate all keywords with a comma or a space.\\r\\n\\r\\n\\r\\n \\r\\n \\r\\n\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (3,\'eng\',\'\',\'Global Configuration\',\'Global Configuration\',2,1,\'\\r\\nSystem configuration can be changed ...\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (4,\'eng\',\'\',\'Media Manager\',\'Media Manager\',2,2,\'\\r\\n \\r\\n \\r\\n The Media Manager\'\'s purpose is to allow the easy insertion of content, other than text, into your website.\\r\\n The Media Manager is the second option available under the Site menu item.\\r\\n \\r\\n Upon selecting Media Manager a new window is spawned. The Media Manager window has it\'\'s own Toolbar and Workspace.\\r\\n \\r\\n The Media Manager allows you to easily upload and manage many standard file types. \\r\\n File types available include:\\r\\n .jpg - image files.\\r\\n \\r\\n .png - image files.\\r\\n \\r\\n .gif - image files.\\r\\n \\r\\n .bmp - image files.\\r\\n \\r\\n .swf - Shockwave Flash interactive media.\\r\\n \\r\\n .doc - Microsoft Word documents.\\r\\n \\r\\n .xls - Excel Spread Sheets.\\r\\n \\r\\n .ppt - Power Point presentations.\\r\\n and .pdf - Adobe Acrobat documents.\\r\\n \\r\\n TUTORIAL: Uploading a file.\\r\\n Click the File Upload Tool. \\r\\n \\r\\n \\r\\n \\r\\n An Upload Utility appears in the in a pop up window.\\r\\n \\r\\n Click Browse. \\r\\n \\r\\n You will be presented with a standard navigation dialog.\\r\\n Navigate to the location of the image that you would like to upload.\\r\\n Select the file \\r\\n Click \'\'OK\'\' or \'\'OPEN\'\'\\r\\n Click Upload. Your image or document will upload and thereafter be available in the Media Manager Gallery for that file type.\\r\\n TIP: Make sure your files have the correct file extension for their image or document type. This will help the Media Mananger organise images into their appropriate galleries for you.\\r\\n \\r\\n \\r\\n\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (5,\'eng\',\'\',\'Menu Manager\',\'Menu Manager\',2,3,\'\\r\\n \\r\\n \\r\\n The Menu Manager menu option has a sub menu with three options.\\r\\n \\r\\n Main Levels - controls the top most menu items in the hierarchy.\\r\\n Sub Levels - controls menu items beneath the main menu items.\\r\\n User Menu - controls menu items that a logged in user will see.\\r\\n The Main Level Menu Manager contains a tool set for adding, deleting, publishing, unpublishing, organising and editing items, content sections and components in the Main Level menu.\\r\\n \\r\\n \\r\\n\\r\\n \\r\\n\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (6,\'eng\',\'\',\'Preview\',\'Preview\',2,4,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (7,\'eng\',\'\',\'Template Manager\',\'Template Manager\',2,6,\'\\r\\nWelcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (8,\'eng\',\'\',\'User Administration\',\'User Administration\',2,7,\'Types of Users
\\r\\n\\r\\n
\\r\\na) Public
\\r\\n
\\r\\nb) Registered
\\r\\n
\\r\\nc) Special
\\r\\n
\\r\\nHow to Create Special Users:
\\r\\n
\\r\\nYou can create Special Users for the Users whom\\r\\nyou wish and give them access to submit news, articles, FAQ\'\'s and Web\\r\\nLinks. These Special Users will be the only ones able to view the User Menu Module if you configure the User Menu Module to be viewable only by Special Users.
\\r\\n
\\r\\nTo configure this, go to the Administrator Menu (which is the admin control panel) and choose Modules on the menu bar, then click on Manage Modules. Then double click on User Menu to edit. Now choose access level : Special
\\r\\n
\\r\\nThe result of this configuration will be that only users whom you have defined as Special can submit from the frontend.\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (9,\'eng\',\'\',\'Content\',\'Manging your site content\',0,5,\'The Content core component is the workhorse that provides you much of the functionality for delivering *stuff*?? to your website.\\r\\nThe procedure for creating Content is as follows:\\r\\n\\r\\nCreate a Section for your Content, for example, Hobbies.\\r\\nCreate Categories for your Content, for example, Astronomy or Kite Flying.\\r\\nCreate Content items under the categories you have created.\\r\\nThat\'\'s it.\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (10,\'eng\',\'\',\'Managing sections\',\'Sections\',9,1,\'New to MOS 4.5 is the ability for you to manage your own Sections. Previous versions of MOS came with the built in Sections of News (also referred to as Stories), Articles and FAQ\'\'s. You now have the ability to create your own Sections, for example, Hobbies, Poems, etc.\\r\\nYou must create at least one Section before you can create any Content in the MOS Administror or Frontend.\\r\\nTo manage Sections navigate to Content -> Add/Edit Sections on the menubar.\\r\\nClick on the \'\'New\'\' icon in the toolbar.\\r\\nThe \'\'Title\'\' is a shorter name that is used for display in menus.\\r\\nThe \'\'Section Name\'\' is typically displayed as a heading for the list of Categories.\\r\\nThe \'\'Description\'\' is the text that will be displayed under the heading.\\r\\nAn \'\'Image\'\' can be selected to be displayed to the left or right of the description.\\r\\nWhen you are done, click on the \'\'Save\'\' icon to save your new section. You will be alerted if you have missed any mandatory fields. Attend to these and click on the \'\'Save\'\' icon again.\\r\\nYou will be returned to the Section list where you should see the Section you just created. You can edit your new Section, or any other section by selecting the checkbox to the left of the section name and clicking on the \'\'Edit\'\' icon. Alternatively, just click on the name of the Section (this is a hyperlink) to edit the section.\\r\\nHover your mouse over Content in the menubar. You will see that your new Section has been added to the drop-down menu and that you add new items and categories to the Section. Note that you must also create at least one category before you can add a new content item. So, hover your mouse over the name of your new Section (for example Hobbies) and select, for example, \'\'Hobbies Categories\'\'.\\r\\n \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (11,\'eng\',\'\',\'Managing categories\',\'Categories\',9,2,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (12,\'eng\',\'\',\'Managing Items\',\'Managing Items\',9,3,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (13,\'eng\',\'\',\'Components\',\'Components\',0,6,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (14,\'eng\',\'\',\'Installing a component\',\'Installing a component\',13,1,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (15,\'eng\',\'\',\'Managing site banner clients\',\'Banners\',13,1,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (16,\'eng\',\'\',\'Managing banners\',\'Managing banners\',13,2,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (17,\'eng\',\'\',\'Contact Details\',\'Contact Details\',13,4,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (18,\'eng\',\'\',\'Managing site newflashes\',\'Newflashes\',13,5,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (19,\'eng\',\'\',\'Managing weblinks\',\'Weblinks\',13,6,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (20,\'eng\',\'\',\'Modules\',\'Modules\',0,7,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (21,\'eng\',\'\',\'System\',\'System\',0,8,\'Welcome to the Mambo Open Source Help System\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (22,\'eng\',\'\',\'Logout\',\'Logout\',0,9,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (23,\'eng\',\'\',\'Help\',\'Help\',0,10,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (24,\'eng\',\'\',\'Help Index\',\'Help Index\',23,1,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (25,\'eng\',\'\',\'Credits\',\'Credits\',23,2,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (26,\'eng\',\'\',\'GNU/GPL License\',\'GNU/GPL License\',23,3,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (27,\'eng\',\'\',\'Database backup\',\'Database backup\',21,1,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (28,\'eng\',\'\',\'Database restore\',\'Database restore\',21,2,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (29,\'eng\',\'\',\'Global Checkin\',\'Global Checkin\',21,2,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (30,\'eng\',\'\',\'System Info\',\'System Info\',21,3,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (31,\'eng\',\'\',\'Installing a module\',\'Installing a module\',20,1,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (32,\'eng\',\'\',\'Managing modules\',\'Managing modules\',20,2,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (33,\'eng\',\'\',\'Managing Polls\',\'Polls\',20,3,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (34,\'eng\',\'\',\'Managing newsfeed categories\',\'Managing newsfeed categories\',20,4,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (35,\'eng\',\'\',\'Managing newsfeeds\',\'Managing newsfeeds\',20,4,\'Welcome to the Mambo Open Source Help System \',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (36,\'eng\',\'\',\'Terminology used in Mambo Open Source\',\'Terminology\',0,1,\'\\r\\nMambo Open Source is referred to by the acronym MOS or simply as \'\'Mambo\'\' throughout this document.\\r\\nAdministrator\\r\\nThe MOS Administrator is the GUI (Graphical User Interface) for managing your website. \\r\\n The Administrator contains all the necessary tools for adding content, such as text and images, to your website.\\r\\nBlogging\\r\\nBlogging in the context of MOS is the listing of records in a summary form, for example, by link only or showing just the Introductory text\\r\\nCategory\\r\\nA Category is the name for a collection of items that are related in some way. For example: The category \'\'Fish\'\' may contain the records \'\'Herring\'\', \'\'Haddock\'\' and \'\'Stickleback\'\'.\\r\\nComponents\\r\\nComponents are the Mambo content elements that appear in the centre of a three column Mambo layout or on the right of a two column Mambo layout. Components are core elements of Mambo functionality. Mambo components include: News, Articles and Banners.\\r\\nDatabase\\r\\nA database is an organized collection of information. It contains a collection of records that you can search, sort and analyze rapidly. \\r\\nFrontend\\r\\nThe MOS Frontend is the website displayed to your users, containing all the content added in the Administrator.\\r\\nItem\\r\\nAn Item is a discrete piece of content within the Mambo hierarchy. A item can be: An article, a news article or a link.\\r\\nModules\\r\\nModules extend the capabilities of Mambo giving the software new capacities. Modules are the flanking content appearing on either side of the component content area. Modules are very easy to install using the Administrator. Mambo modules may include: A calendar, N feeds or the latest weather. Mambo modules are being produced all the time by the Mambo community.\\r\\nRecord\\r\\nA Record is a generic term for a \'\'row\'\' in the database. A record very often represents a \'\'piece\'\' of content. The dynamic functionality and much of the content of Mambo relies on a database in order to function.\\r\\nSection\\r\\nA Section is a collection of Categories that are related in some way. Think of it this way: A section might be called \'\'News\'\', categories in this section might be \'\'Today\'\'s News\'\', \'\'Yesterdays News\'\' and \'\'Other News\'\'.\\r\\nWorkspace\\r\\nThe Workspace is the section of the Mambo Administrator where the business of configuration and content publishing takes place. The workspace dynamically updates as you select tools and menu options. The workspace can include: Html editing, article and link management and series of other features..(etc)\\r\\n\\r\\n\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (37,\'eng\',\'\',\'MOS Administrator General Concepts\',\'General Concepts\',0,3,\'\\r\\n \\r\\n \\r\\n The Administrator is the control centre of your Mambo powered website.\\r\\n All site construction, editing and publishing takes place through the Administrator\'\'s elegant interface. \\r\\n The Administrator is divided into three sections, the Menu bar, the Tool bar and the Work space. \\r\\nNOTE: Help has been highlighted separately, but is in fact a part of the toolbar. \\r\\n \\r\\n The Menu Bar\\r\\n The menu bar is divided into seven sections. \\r\\n Site, Content, Components, Modules, System, Logout and Help. \\r\\n Each section has an associated drop down menu, with the exception of the Logout option.\\r\\n The menu bar is your navigation centre within the Administrator.\\r\\n Toolbar :: Tools\\r\\n \\r\\n \\r\\n \\r\\n \\r\\n New item - starts the input process for a new article, news item or link.\\r\\n \\r\\n \\r\\n \\r\\n Edit - allows you to edit an item previously created.\\r\\n \\r\\n \\r\\n \\r\\n Delete or Remove - removes a category and items or item from your website.\\r\\n \\r\\n \\r\\n \\r\\n Publish - makes a category or item available to your users.\\r\\n \\r\\n \\r\\n \\r\\n Unpublish - makes a category or item unavailable to your users but does not delete it.\\r\\n \\r\\n \\r\\n \\r\\n Save - saves a newly created item or the results of the editing process.\\r\\n \\r\\n \\r\\n \\r\\n Cancel - cancels item creation and editing activities without saving.\\r\\n \\r\\n \\r\\n \\r\\n Workspace\\r\\n The Workspace is the area immediately below the Administrator Menu bar and Tool bar that \\r\\n updates when you make a menu selection or use a tool from the tool bar.\\r\\n \\r\\n \\r\\n Mambo Hierarchy\\r\\n Content input into the MOS hierarchy via the Administrator is divided into logical descending sets:\\r\\n \\r\\n\\r\\n\\r\\n \\r\\n\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (38,\'eng\',\'\',\'Introduction to Template Help\',\'Introduction\',0,1,\'This is where we teach you to make templates \\r\\nTemplates are files with simple HTML code with special includes that give you hooks into the MOS framework. Templates only define the HTML structure/appearance but define where, and sometimes how, the information from the database should be inserted.\\r\\nThe leading principle of templating is creating reusable code. For example, if you had a header and footer on every page of your proposed site, you would do well to include it in a template to be used by every page. In the event that you want to make changes to the header in all pages, you will only have to make changes in one file.\',4,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (39,\'eng\',\'\',\'Getting Started\',\'Getting Started\',0,2,\'This tutorial will guide you through the process of developing a new template from scratch.\\r\\nFor example, you\'\'ve just downloaded the latest version of MOS 4.5 or better. You\'\'ve created all the content for the site but your client isn\'\'t really crazy about any of the templates supplied, nor are they fussed over what\'\'s on offer on any of the Mambo fan sites. Your client wants something different that makes them stand out from other MOS sites.\',4,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (40,\'eng\',\'\',\'The Basic Page Layout\',\'Page Layout\',39,1,\'First, you need to work out how the web site will look. Your client may have had a graphic artist prepare a concept sketch of what the look-and-feel should be. A number of graphic images may have also been provided to you for you to include in the template.\\r\\nSo, let\'\'s get started. You can use any HTML editor/web design software, like Macromedia Dreamweaver, Microsoft FrontPage, EditPlus, Quanta or even the ever faithful Notepad.\',4,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (41,\'eng\',\'\',\'Template Files\',\'Template Files\',0,3,\'All files are found under the /templates directory. \',4,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (42,\'eng\',\'\',\'Stylesheet Standards\',\'Stylesheet Standards\',0,4,\'Here\'\'s the stylesheet standards. \',4,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (43,\'eng\',\'\',\'Adding the Body Content\',\'Body Content\',39,2,\'This is how we add the main body content. \',4,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (44,\'eng\',\'\',\'Adding Menus and Modules\',\'Menus and Modules\',39,3,\'This is how we add in the menus and modules.\',4,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (45,\'eng\',\'\',\'Adding the Pathway\',\'Pathway\',39,4,\'Here\'\'s how to add the pathway (sometimes known as breadcrumbs).\',4,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (46,\'eng\',\'\',\'The Frontpage Component\',\'Frontpage\',0,1,\'The Frontpage Component selects all the contents published content items in the site marked for the front page. It then displays them in a \'\'blog\'\' style.\\r\\nThe Frontpage component has a number of parameters to manipulate the display.\\r\\ncount: The total number of items to display\\r\\nintro: The number of items to display with the intro text shown\\r\\nimage: 0 if you do not want embedded images displayed, 1 otherwise\\r\\nheader: Text to display as a header to all the of displayed items\\r\\nempty: Text to be displayed if there are no items found to be marked for the front page.\\r\\nAn example set of parameters might look like the following:\\r\\ncount=6intro=3image=1header=Welcome to the Frontpageempty=I don\'\'t have anything to display\',6,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (47,\'eng\',\'\',\'Adding and Editting Users\',\'Add/Edit User\',8,1,\'\\r\\nWith this menu you can Add, Edit, and Mass Mail Users. You can also Delete Users, once you are in the Edit section.
\\r\\n
\\r\\n1. New User – There are two ways that Users can be created on your site. Your visitors can create their own account, by registering via your Login Form, or you can add your own Users if you want a selected group to visit your site, or selected content pages.
\\r\\n
\\r\\n2. Edit Users – On this screen you can edit your Users, delete them if they are no longer authorized to be a User, or correct typing errors.
\\r\\n
\\r\\nWhen you want to edit a User, click on his or her Name, or check the box to the left of their name, and click on Edit. This will take you to a second screen, where you can edit your Users. Name, Username and Email\\r\\nare self explanitory. If you want to change the password, just type\\r\\na new password. If you don’t want to change the password, leave\\r\\nthe fields blank!
\\r\\n
\\r\\nIn the next field, User Type, you can change the User\'\'s level of authorization.
\\r\\n
\\r\\n User – A User has access to view sections of your site, which are only viewable to those with the status of User.\\r\\n Editor – An Editor has authorization from your site\'\'s Log In, to add his/her own content to certain pages on your site.\\r\\n Administrator – An Administrator\\r\\nis able to change some of the important settings on your site, like\\r\\nchanging templates, and adding Modules, and Components etc. They\\r\\ncan administer lesser users (editors and users) but cannot create other\\r\\nAdministrators.\\r\\n Super Administrator – The Super Administrator\\r\\nhas complete control over the site, and can change any aspect of the\\r\\nsite that they wishes to. The Super Administrator can create any other\\r\\nuser type (except another Super Administrator).\\r\\n
\\r\\nGroup – Groups can be Registered or Special. If you wish to authorize some or all of your Users to view sections of your site that contain Special Content, select Special. Select Registered for those you want to view sections that are reserved for Registered Users only.
\\r\\n
\\r\\nBlock User – \'\'Yes\'\' or \'\'No\'\'. If you really don’t want a certain Registered user to spoil your site, you can block this user. This prevents him/her from viewing, and contributing to your site, using the same User name or email\\r\\nthat he/she had registered with. This feature is important to sites\\r\\nthat visitors can sign up to for example, a community web site, where registered users can make contributions.
\\r\\n
\\r\\nReceive Submission Emails – Choose \'\'Yes\'\' or \'\'No\'\'. If the User wants to receive emails from the Administratorof\\r\\nthe site, select \'\'YES\'\'. If not, select \'\'NO\'\'. You can temporarily choose\\r\\n\'\'Yes\'\' or \'\'No\'\' depending on your needs, and change this setting later on.
\\r\\n
\\r\\nWhen you are finished configuring the User section, and you are satisfied, click on SAVE, at the top of the Menu bar. If you do not want to SAVE, click on CANCEL.
\\r\\n
\\r\\n\\r\\nNote: – Please do not use your browsers Back button as you will lose your configuration.\\r\\n\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (48,\'eng\',\'\',\'Mass Mail\',\'Mass Mail\',8,2,\'\\r\\n
\\r\\n\',3,0,0)
INSERT INTO meubr7_help ([id],lang,context,name,title,parent,ordering,helptext,catid,checked_out,checked_out_time) VALUES (49,\'eng\',\'\',\'Statistics\',\'Statistics\',2,5,\'\\r\\n
\\r\\n\',3,0,0)

SET IDENTITY_INSERT [meubr7_help] OFF[/code:1]

esta está parcialmente feito

mambo_mssql.sql

/*
# Estrutura da tabela [meubr7_banner]
*/
if exists (select * from sysobjects where name = \'meubr7_banner\') drop table meubr7_banner

CREATE TABLE [meubr7_banner] (
[bid] int IDENTITY(1,1) PRIMARY KEY,
[cid] int NOT NULL default \'0\',
[type] varchar(10) NOT NULL default \'banner\',
[name] varchar(50) NOT NULL default \'\',
[imptotal] int NOT NULL default \'0\',
[impmade] int NOT NULL default \'0\',
[clicks] int NOT NULL default \'0\',
[imageurl] varchar(100) NOT NULL default \'\',
[clickurl] varchar(200) NOT NULL default \'\',
[date] datetime default NULL,
[showBanner] smallint NOT NULL default \'0\',
[checked_out] smallint NOT NULL default \'0\',
[checked_out_time] smalldatetime default NULL,
[editor] varchar(50) default NULL,
[custombannercode] text
)

CREATE INDEX [viewbanner] ON [meubr7_banner]([showBanner])

/*
# Inserindo dados na tabela [meubr7_banner]
*/
SET IDENTITY_INSERT [meubr7_banner] ON

SET IDENTITY_INSERT [meubr7_banner] OFF
----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_bannerclient]
*/
if exists (select * from sysobjects where name = \'meubr7_bannerclient\') drop table meubr7_bannerclient

CREATE TABLE [meubr7_bannerclient] (
[cid] int IDENTITY(1,1) PRIMARY KEY,
[name] varchar(60) NOT NULL default \'\',
[contact] varchar(60) NOT NULL default \'\',
[email] varchar(60) NOT NULL default \'\',
[extrainfo] text NOT NULL,
[checked_out] smallint NOT NULL default \'0\',
[checked_out_time] smalldatetime default NULL,
[editor] varchar(50) default NULL
)

/*
# Inserindo dados na tabela [meubr7_bannerclient]
*/
SET IDENTITY_INSERT [meubr7_bannerclient] ON

SET IDENTITY_INSERT [meubr7_bannerclient] OFF
----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_bannerfinish]
*/
if exists (select * from sysobjects where name = \'meubr7_bannerfinish\') drop table meubr7_bannerfinish

CREATE TABLE [meubr7_bannerfinish] (
[bid] int IDENTITY(1,1) PRIMARY KEY,
[cid] int NOT NULL default \'0\',
[type] varchar(10) NOT NULL default \'\',
[name] varchar(50) NOT NULL default \'\',
[impressions] int NOT NULL default \'0\',
[clicks] int NOT NULL default \'0\',
[imageurl] varchar(50) NOT NULL default \'\',
[datestart] datetime default NULL,
[dateend] datetime default NULL,
)

/*
# Inserindo dados na tabela [meubr7_bannerfinish]
*/
SET IDENTITY_INSERT [meubr7_bannerfinish] ON

SET IDENTITY_INSERT [meubr7_bannerfinish] OFF
----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_categories]
*/
if exists (select * from sysobjects where name = \'meubr7_categories\') drop table meubr7_categories

CREATE TABLE [meubr7_categories] (
[id] int IDENTITY(1,1) PRIMARY KEY,
[title] varchar(50) NOT NULL default \'\',
[name] varchar(255) NOT NULL default \'\',
[image] varchar(100) NOT NULL default \'\',
[section] varchar(20) NOT NULL default \'\',
[image_position] varchar(10) NOT NULL default \'\',
[description] text NOT NULL,
[published] smallint NOT NULL default \'0\',
[checked_out] int NOT NULL default \'0\',
[checked_out_time] datetime NOT NULL default 0,
[editor] varchar(50) default NULL,
[ordering] int NOT NULL default \'0\',
[access] smallint NOT NULL default \'0\',
[count] int NOT NULL default \'0\'
)

CREATE INDEX [cat_idx] ON [meubr7_categories]([section],[published],[access])
CREATE INDEX [idx_section] ON [meubr7_categories]([section])
CREATE INDEX [idx_access] ON [meubr7_categories]([access])
CREATE INDEX [idx_checkout] ON [meubr7_categories]([checked_out])

/*
# Inserindo dados na tabela [meubr7_categories]
*/
SET IDENTITY_INSERT meubr7_categories ON

INSERT INTO [meubr7_categories] ([id],[title],[name],[image],[section],[image_position],[description],[published],[checked_out],[checked_out_time],[editor],[ordering],[access],[count]) VALUES (1,\'Latest\', \'Latest News\', \'pastarchives.jpg\', \'1\', \'left\', \'The latest news from the Mambo Open Source Team\', 1, 0, 0, \'\', 0, 0, 1)
INSERT INTO [meubr7_categories] ([id],[title],[name],[image],[section],[image_position],[description],[published],[checked_out],[checked_out_time],[editor],[ordering],[access],[count]) VALUES (2,\'MOS\', \'Mambo Open Source\', \'meubr7_asterisk.png\', \'com_weblinks\', \'left\', \'A selection of links that are all related to the Mambo Open Source project.\', 1, 0, 0, NULL, 0, 0, 0)
INSERT INTO [meubr7_categories] ([id],[title],[name],[image],[section],[image_position],[description],[published],[checked_out],[checked_out_time],[editor],[ordering],[access],[count]) VALUES (3,\'Administrator\', \'Administrator\', \'\', \'help\', \'left\', \'MOS Administrator Help\', 1, 0, 0, NULL, 1, 0, 0)
INSERT INTO [meubr7_categories] ([id],[title],[name],[image],[section],[image_position],[description],[published],[checked_out],[checked_out_time],[editor],[ordering],[access],[count]) VALUES (4,\'Templates\', \'Templates\', \'\', \'help\', \'left\', \'MOS Templates Help and Tutorials\', 1, 0, 0, NULL, 3, 0, 0)
INSERT INTO [meubr7_categories] ([id],[title],[name],[image],[section],[image_position],[description],[published],[checked_out],[checked_out_time],[editor],[ordering],[access],[count]) VALUES (5,\'Developers\', \'Developers\', \'\', \'help\', \'left\', \'MOS Developers\'\' API\', 1, 0, 0, NULL, 4, 0, 0)
INSERT INTO [meubr7_categories] ([id],[title],[name],[image],[section],[image_position],[description],[published],[checked_out],[checked_out_time],[editor],[ordering],[access],[count]) VALUES (6,\'Components\', \'Components\', \'\', \'help\', \'left\', \'Components Help\', 1, 0, 0, NULL, 2, 0, 0)

SET IDENTITY_INSERT meubr7_categories OFF
----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_components]
*/
if exists (select * from sysobjects where name = \'meubr7_components\') drop table meubr7_components

CREATE TABLE [meubr7_components] (
[id] int IDENTITY(1,1) PRIMARY KEY,
[name] varchar(50) NOT NULL default \'\',
[link] varchar(255) NOT NULL default \'\',
[menuid] int NOT NULL default \'0\',
[parent] int NOT NULL default \'0\',
[admin_menu_link] varchar(255) NOT NULL default \'\',
[admin_menu_alt] varchar(255) NOT NULL default \'\',
[option] varchar(50) NOT NULL default \'\',
[ordering] int NOT NULL default \'0\',
[admin_menu_img] varchar(255) NOT NULL default \'\',
[iscore] smallint NOT NULL default \'0\'
)

/*
# Inserindo dados na tabela [meubr7_components]
*/
SET IDENTITY_INSERT meubr7_components ON

INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (1,\'Banners\', \'\', 0, 0, \'\', \'Banner Management\', \'com_banners\', 0, \'js/ThemeOffice/component.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (2,\'Manage Banners\', \'\', 0, 1, \'option=com_banners\', \'Active Banners\', \'com_banners\', 1, \'js/ThemeOffice/edit.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (3,\'Manage Clients\', \'\', 0, 1, \'option=com_banners&task=listclients\', \'Manage Clients\', \'com_banners\', 2, \'js/ThemeOffice/categories.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (4,\'Web Links\', \'option=com_weblinks\', 0, 0, \'\', \'Manage Weblinks\', \'com_weblinks\', 0, \'js/ThemeOffice/component.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (5,\'Newsflash\', \'\', 0, 0, \'option=com_newsflash\', \'Manage newsflashes\', \'com_newsflash\', 0, \'js/ThemeOffice/component.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (6,\'Contact\', \'option=com_contact\', 0, 0, \'option=com_contact\', \'Edit contact details\', \'com_contact\', 0, \'js/ThemeOffice/component.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (7,\'Weblink Items\', \'\', 0, 4, \'option=com_weblinks\', \'View existing weblinks\', \'com_weblinks\', 1, \'js/ThemeOffice/edit.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (8,\'Weblink Categories\', \'\', 0, 4, \'option=categories&section=com_weblinks\', \'Manage weblink categories\', \'\', 2, \'js/ThemeOffice/categories.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (9,\'FrontPage\', \'option=com_frontpage\', 0, 0, \'\', \'Manage Front Page Items\', \'com_frontpage\', 0, \'js/ThemeOffice/component.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (10,\'Manage Items\', \'\', 0, 9, \'option=com_frontpage\', \'Manage FrontPage Items\', \'com_frontpage\', 1, \'js/ThemeOffice/edit.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (11,\'Settings\', \'\', 0, 9, \'option=com_frontpage&act=settings\', \'FrontPage Settings\', \'com_frontpage\', 2, \'js/ThemeOffice/config.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (12,\'Polls\', \'option=com_poll\', 0, 0, \'option=com_poll\', \'Manage Polls\', \'com_poll\', 0, \'js/ThemeOffice/component.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (13,\'News Feeds\', \'\', 0, 0, \'\', \'News Feeds Management\', \'com_newsfeeds\', 0, \'js/ThemeOffice/component.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (14,\'Manage News Feeds\', \'\', 0, 13, \'option=com_newsfeeds\', \'Manage News Feeds\', \'com_newsfeeds\', 1, \'js/ThemeOffice/edit.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (15,\'Manage Categories\', \'\', 0, 13, \'option=categories&section=com_newsfeeds\', \'Manage Categories\', \'\', 2, \'js/ThemeOffice/categories.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (16,\'Newsfeeds (Component)\', \'option=com_newsfeeds\', \'\', \'\', \'\',\'\', \'\', \'\', \'\', \'\')
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (17,\'Media Manager\', \'\', 0, 0, \'option=com_media\', \'Media Manager\', \'com_media\', 0, \'js/ThemeOffice/media.png\', 1)
INSERT INTO [meubr7_components] ([id],name,link,menuid,parent,admin_menu_link,admin_menu_alt,[option],ordering,admin_menu_img,iscore) VALUES (18,\'Login\', \'option=com_login\', 0, 0, \'\', \'\', \'com_login\', 0, \'\', 1)

SET IDENTITY_INSERT meubr7_components OFF
----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_contact_details]
*/
if exists (select * from sysobjects where name = \'meubr7_contact_details\') drop table meubr7_contact_details

CREATE TABLE [meubr7_contact_details] (
[id] int IDENTITY(1,1) PRIMARY KEY,
[name] varchar(100) NOT NULL default \'\',
[con_position] varchar(50) default NULL,
[address] text,
[suburb] varchar(50) default NULL,
[state] varchar(20) default NULL,
[country] varchar(50) default NULL,
[postcode] varchar(10) default NULL,
[telephone] varchar(25) default NULL,
[fax] varchar(25) default NULL,
[misc] text,
[image] varchar(100) default NULL,
[imagepos] varchar(20) default NULL,
[email_to] varchar(100) default NULL,
[default_con] smallint NOT NULL default \'0\',
[published] smallint NOT NULL default \'0\',
[checked_out] int NOT NULL default \'0\',
[checked_out_time] datetime NOT NULL default 0,
[ordering] int NOT NULL default \'0\',
)

/*
# Inserindo dados na tabela [meubr7_contact_details]
*/
SET IDENTITY_INSERT meubr7_contact_details ON

SET IDENTITY_INSERT meubr7_contact_details OFF
----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_content]
*/
if exists (select * from sysobjects where name = \'meubr7_content\') drop table meubr7_content

CREATE TABLE [meubr7_content] (
[id] int IDENTITY(1,1) PRIMARY KEY,
[title] varchar(100) NOT NULL default \'\',
[title_alias] varchar(100) NOT NULL default \'\',
[introtext] text NOT NULL,
[fulltext] text NOT NULL,
[state] smallint NOT NULL default \'0\',
[sectionid] int NOT NULL default \'0\',
[mask] int NOT NULL default \'0\',
[catid] int NOT NULL default \'0\',
[created] datetime NOT NULL default 0,
[created_by] int NOT NULL default \'0\',
[created_by_alias] varchar(100) NOT NULL default \'\',
[modified] datetime NOT NULL default 0,
[modified_by] int NOT NULL default \'0\',
[checked_out] int NOT NULL default \'0\',
[checked_out_time] datetime NOT NULL default 0,
[publish_up] datetime NOT NULL default 0,
[publish_down] datetime NOT NULL default 0,
[images] text NOT NULL,
[urls] text NOT NULL,
[attribs] text NOT NULL,
[version] int NOT NULL default \'1\',
[parentid] int NOT NULL default \'0\',
[ordering] float NOT NULL default \'0\',
[metakey] text NOT NULL,
[metadesc] text NOT NULL,
[access] int NOT NULL default \'0\',
[hits] int NOT NULL default \'0\'
)

CREATE INDEX [idx_section] ON [meubr7_content]([sectionid])
CREATE INDEX [idx_access] ON [meubr7_content]([access])
CREATE INDEX [idx_checkout] ON [meubr7_content]([checked_out])
CREATE INDEX [idx_state] ON [meubr7_content]([state])
CREATE INDEX [idx_catid] ON [meubr7_content]([catid])
CREATE INDEX [idx_mask] ON [meubr7_content]([mask])

/*
# Inserindo dados na tabela [meubr7_content]
*/
SET IDENTITY_INSERT [meubr7_content] ON

INSERT INTO [meubr7_content] ([id],title,title_alias,introtext,fulltext,state,sectionid,mask,catid,created,created_by,created_by_alias,modified,modified_by,checked_out,checked_out_time,publish_up,publish_down,images,urls,attribs,version,parentid,ordering,metakey,metadesc,access,hits) VALUES (1,\'Welcome to Mambo Open Source\', \'Welcome\', \'If you\'\'ve read anything at all about portals, you\'\'ll probably know at least three things: Portals are the most exciting way to do business, Portals can be really, I mean really, complicated and lastly Portals are absolutely, outrageously, often unaffordably expensive. {mosimage}Mambo Open Source is set to change all that ... Mambo Open Source is different from the normal models for portal software. For a start, it\'\'s not complicated. Mambo has been developed for the masses. It\'\'s licensed under the GNU/GPL license, easy to install and administer and reliable. Mambo doesn\'\'t even require the user or administrator of the system to know HTML to operate it once it\'\'s up and running.\', \'Mambo features:\\r\\n\\r\\nCompletely database driven site engins \\r\\nNews, products or services sections fully editable and manageable \\r\\nTopics sections can be added to by contributing authors \\r\\nFully customisable layouts including left, center and right menu boxes \\r\\nBrowser upload of images to your own library for use anywhere in the site \\r\\nDynamic Forum/Poll/Voting booth for on-the-spot results \\r\\nRuns on Linux, FreeBSD, MacOSX server, Solaris and AIX \\r\\n\\r\\nExtensive Administration:\\r\\n\\r\\nChange order of objects including news, FAQs, articles etc. \\r\\nRandom Newsflash generator \\r\\nRemote author submission module for News, Articles, FAQs and Links \\r\\nObject hierarchy - as many sections, departments, divisions and pages as you want \\r\\nImage library - store all your PNGs, PDFs, DOCs, XLSs, GIFs and JPEGs online for easy use \\r\\nAutomatic Path-Finder. Place a picture and let Mambo fix the link \\r\\nNews feed manager. Choose from over 360 news feeds from around the world \\r\\nArchive manager. Put your old articles into cold storage rather than throw them out \\r\\nEmail-a-friend and Print-format for every story and article \\r\\nIn-line Text editor similar to Word Pad \\r\\nUser editable look and feel \\r\\nPolls/Surveys - Now put a different one on each page \\r\\nCustom Page Modules. Download custom page modules to spice up your site \\r\\nTemplate Manager. Download templates and implement them in seconds \\r\\nLayout preview. See how it looks before going live \\r\\nBanner manager. Make money out of your site\', 1, 1, 0, 1, \'2003-06-12 11:54:06\', 62, \'Web Master\', \'2003-06-12 12:33:27\', 62, 0, 0, \'2003-01-01 00:00:00\', 0, \'meubr7_asterisk.png|left|Another logo|0\', \'\', \'\', 1, 0, \'1\', \'\', \'\', 0, 0)

SET IDENTITY_INSERT [meubr7_content] OFF
----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_content_frontpage]
*/
if exists (select * from sysobjects where name = \'meubr7_content_frontpage\') drop table meubr7_content_frontpage

CREATE TABLE [meubr7_content_frontpage] (
[content_id] int PRIMARY KEY default \'0\',
[ordering] int NOT NULL default \'0\'
)

/*
# Inserindo dados na tabela [meubr7_content_frontpage]
*/

INSERT INTO [meubr7_content_frontpage] VALUES (1, 1)

----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_content_rating]
*/
if exists (select * from sysobjects where name = \'meubr7_content_rating\') drop table meubr7_content_rating

CREATE TABLE [meubr7_content_rating] (
[content_id] int PRIMARY KEY default \'0\',
[rating_sum] int NOT NULL default \'\',
[rating_count] int NOT NULL default \'0\',
[lastip] varchar(50) NOT NULL default \'\'
)

/*
# Inserindo dados na tabela [meubr7_content_rating]
*/

----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_groups]
*/
if exists (select * from sysobjects where name = \'meubr7_groups\') drop table meubr7_groups

CREATE TABLE [meubr7_groups] (
[id] smallint PRIMARY KEY default \'0\',
[name] varchar(50) NOT NULL default \'\'
)

/*
# Inserindo dados na tabela [meubr7_groups]
*/

INSERT INTO [meubr7_groups] VALUES (0, \'Public\')
INSERT INTO [meubr7_groups] VALUES (1, \'Registered\')
INSERT INTO [meubr7_groups] VALUES (2, \'Special\')
----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_help]
*/
if exists (select * from sysobjects where name = \'meubr7_help\') drop table meubr7_help

CREATE TABLE [meubr7_help] (
[id] int IDENTITY(1,1) PRIMARY KEY,
[lang] char(3) NOT NULL default \'eng\',
[context] varchar(40) NOT NULL default \'\',
[name] varchar(40) NOT NULL default \'\',
[title] varchar(100) NOT NULL default \'\',
[parent] int NOT NULL default \'0\',
[ordering] int NOT NULL default \'0\',
[helptext] text NOT NULL,
[catid] int NOT NULL default \'0\',
[checked_out] int NOT NULL default \'0\',
[checked_out_time] datetime NOT NULL default 0
)

CREATE INDEX [id] ON [meubr7_help]([id])
CREATE INDEX [IdLangIdx] ON [meubr7_help]([id],[lang])
CREATE INDEX [id_2] ON [meubr7_help]([id])


/*
# Inserindo dados na tabela [meubr7_help]
*/

----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_help]
*/
if exists (select * from sysobjects where name = \'meubr7_menu\') drop table [meubr7_menu]

CREATE TABLE [meubr7_menu] (
[id] int IDENTITY(1,1) PRIMARY KEY,
[menutype] varchar(25) default NULL,
[name] varchar(100) default NULL,
[link] text,
[type] varchar(50) NOT NULL default \'\',
[published] smallint NOT NULL default \'0\',
[parent] int NOT NULL default \'0\',
[componentid] int NOT NULL default \'0\',
[sublevel] int default \'0\',
[ordering] int default \'0\',
[checked_out] int NOT NULL default \'0\',
[checked_out_time] datetime NOT NULL default 0,
[pollid] int NOT NULL default \'0\',
[browserNav] smallint default \'0\',
[access] smallint NOT NULL default \'0\',
[utaccess] smallint NOT NULL default \'0\',
[params] text NOT NULL
)

CREATE INDEX [componentid] ON [meubr7_menu]([componentid],[menutype],[published],[access])
CREATE INDEX [menutype] ON [meubr7_menu]([menutype])

/*
# Inserindo dados na tabela [meubr7_menu]
*/
SET IDENTITY_INSERT [meubr7_menu] ON

INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (1, \'mainmenu\', \'Home\', \'index.php?option=com_frontpage\', \'components\', 1, 0, 9, 0, 1, 0, 0, 0, 0, 0, 3, \'count=6\\r\\nintro=3\\r\\nimage=1\\r\\nheader=Welcome to the Frontpage\\r\\nempty=I do not have anything to display\\r\\norderby=ordering\')
INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (2, \'mainmenu\', \'News\', \'index.php?option=content&task=section&id=1\', \'content_section\', 1, 0, 1, 0, 2, 0, 0, 0, 0, 0, 3, \'\')
INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (3, \'mainmenu\', \'Contact Us\', \'index.php?option=com_contact\', \'components\', 1, 0, 6, 0, 5, 0, 0, 0, 0, 0, 3, \'\')
INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (4, \'mainmenu\', \'The Web Links\', \'index.php?option=com_weblinks\', \'components\', 1, 0, 4, 0, 4, 0, 0, 0, 0, 0, 3, \'\')
INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (5, \'mainmenu\', \'MamboServer\', \'http://www.mamboserver.com\', \'url\', 1, 0, 0, 0, 7, 0, 0, 0, 0, 0, 3, \'\')
INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (6, \'mainmenu\', \'Administrator\', \'administrator\'\'s\', \'url\', 1, 0, 0, 0, 8, 0, 0, 0, 0, 0, 3, \'\')
INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (21, \'usermenu\', \'Your Details\', \'index.php?option=com_user&task=UserDetails\', \'url\', 1, 0, 0, 0, 1, 0, \'2000-01-01 00:00:00\', 0, 0, 1, 3, \'\')
INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (22, \'usermenu\', \'Submit News\', \'index.php?option=content&task=new&sectionid=1&Itemid=0\', \'url\', 1, 0, 0, 0, 2, 0, \'2000-01-01 00:00:00\', 0, 0, 1, 2, \'\')
INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (23, \'usermenu\', \'Submit WebLink\', \'index.php?option=com_weblinks&task=new\', \'url\', 1, 0, 0, 0, 4, 0, \'2000-01-01 00:00:00\',0, 0, 1, 2, \'\')
INSERT INTO [meubr7_menu] ([id],menutype,[name],link,type,published,parent,componentid,sublevel,ordering,checked_out,checked_out_time,pollid,browserNav,access,utaccess,params) VALUES (24, \'usermenu\', \'Check-In My Items\', \'index.php?option=com_user&task=CheckIn\', \'url\', 1, 0, 0, 0, 5, 0, 0, 0, 0, 1, 2, \'\')

SET IDENTITY_INSERT [meubr7_menu] OFF

----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_messages]
*/
if exists (select * from sysobjects where name = \'meubr7_messages\') drop table [meubr7_messages]

CREATE TABLE [meubr7_messages] (
[message_id] int IDENTITY(1,1) PRIMARY KEY,
[user_id_from] int NOT NULL default \'0\',
[user_id_to] int NOT NULL default \'0\',
[folder_id] int NOT NULL default \'0\',
[date_time] datetime NOT NULL default 0,
[state] int NOT NULL default \'0\',
[priority] int NOT NULL default \'0\',
[subject] varchar(230) NOT NULL default \'\',
[message] text NOT NULL
)

---------------------------------------------------------

/*
# Estrutura da tabela [meubr7_messages_cfg]
*/
if exists (select * from sysobjects where name = \'meubr7_messages_cfg\') drop table [meubr7_messages_cfg]

CREATE TABLE [meubr7_messages_cfg] (
[user_id] int IDENTITY(1,1) PRIMARY KEY,
[cfg_name] varchar(100) NOT NULL default \'\',
[cfg_value] varchar(255) NOT NULL default \'\',
)

----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_modules]
*/
if exists (select * from sysobjects where name = \'meubr7_modules\') drop table [meubr7_modules]

CREATE TABLE [meubr7_modules] (
[id] int IDENTITY(1,1) PRIMARY KEY,
[title] text NOT NULL,
[content] text NOT NULL,
[ordering] smallint NOT NULL default \'0\',
[position] varchar(10) default NULL,
[checked_out] int NOT NULL default \'0\',
[checked_out_time] datetime NOT NULL default 0,
[published] smallint NOT NULL default \'0\',
[module] varchar(50) default NULL,
[numnews] int NOT NULL default \'0\',
[access] smallint NOT NULL default \'0\',
[showtitle] smallint NOT NULL default \'1\',
[params] text NOT NULL,
[iscore] smallint NOT NULL default \'0\',
)

CREATE INDEX [published] ON [meubr7_modules]([published],[access])
CREATE INDEX [newsfeeds] ON [meubr7_modules]([module],[published])

/*
# Inserindo dados na tabela [meubr7_modules]
*/
SET IDENTITY_INSERT [meubr7_modules] ON

INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (1, \'Polls\', \'\', 1, \'right\', 0, 0, 1, \'mod_poll\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (2, \'User Menu\', \'\', 2, \'left\', 0, 0, 1, \'mod_mainmenu\', 0, 1, 1, \'menutype=usermenu\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (3, \'Main Menu\', \'\', 1, \'left\', 0, 0, 1, \'mod_mainmenu\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (4, \'Login Form\', \'\', 3, \'left\', 0, 0, 1, \'mod_login\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (5, \'Syndicate\', \'\', 2, \'right\', 0, 0, 1, \'mod_rssfeed\', 0, 0, 0, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (6, \'Browser Prefs\', \'\', 3, \'right\', 0, 0, 0, \'mod_browser_prefs\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (7, \'Hit Counter\', \'\', 1, \'user2\', 0, 0, 1, \'mod_counter\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (8, \'Latest News\', \'\', 4, \'right\', 0, 0, 0, \'mod_latestnews\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (9, \'Newsfeeds\', \'\', 5, \'right\', 0, 0, 0, \'mod_newsfeeds\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (10, \'Online Users\', \'\', 5, \'left\', 0, 0, 0, \'mod_online\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (11, \'Statistics\', \'\', 4, \'left\', 0, 0, 0, \'mod_stats\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (12, \'Who\'\'s Online\', \'\', 1, \'user1\', 0, 0, 1, \'mod_whosonline\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (13, \'Most Read\', \'\', 6, \'right\', 0, 0, 0, \'mod_mostread\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (14, \'Template Chooser\',\'\',6,\'left\',0,0,0,\'mod_templatechooser\', 0, 0, 1, \'show_preview=1\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (15, \'Archive\', \'\', 7, \'left\', 0, 0, 0, \'mod_archive\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (16, \'Sections\', \'\', 8, \'left\', 0, 0, 0, \'mod_sections\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (17, \'Newsflash\', \'\', 1, \'top\', 0, 0, 1, \'mod_newsflash\', 0, 0, 1, \'\', 1)
INSERT INTO [meubr7_modules] ([id],[title],[content],[ordering],[position],[checked_out],[checked_out_time],[published],[module],[numnews],[access],[showtitle],[params],[iscore]) VALUES (18, \'Related Items\', \'\', 9, \'left\', 0, 0, 1, \'mod_related_items\', 0, 0, 1, \'\', 1)

SET IDENTITY_INSERT [meubr7_modules] OFF

----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_modules_menu]
*/
if exists (select * from sysobjects where name = \'meubr7_modules_menu\') drop table [meubr7_modules_menu]

CREATE TABLE [meubr7_modules_menu] (
[moduleid] int PRIMARY KEY default \'0\',
[menuid] int NOT NULL default \'0\',
)

/*
# Inserindo dados na tabela [meubr7_modules_menu]
*/

INSERT INTO [meubr7_modules_menu] VALUES (1, 1)
INSERT INTO [meubr7_modules_menu] VALUES (2, 0)
INSERT INTO [meubr7_modules_menu] VALUES (3, 0)
INSERT INTO [meubr7_modules_menu] VALUES (4, 0)
INSERT INTO [meubr7_modules_menu] VALUES (5, 1)
INSERT INTO [meubr7_modules_menu] VALUES (6, 0)
INSERT INTO [meubr7_modules_menu] VALUES (7, 0)
INSERT INTO [meubr7_modules_menu] VALUES (8, 0)
INSERT INTO [meubr7_modules_menu] VALUES (9, 0)
INSERT INTO [meubr7_modules_menu] VALUES (10, 0)
INSERT INTO [meubr7_modules_menu] VALUES (11, 0)
INSERT INTO [meubr7_modules_menu] VALUES (12, 0)
INSERT INTO [meubr7_modules_menu] VALUES (13, 0)
INSERT INTO [meubr7_modules_menu] VALUES (14, 0)
INSERT INTO [meubr7_modules_menu] VALUES (16, 1)
INSERT INTO [meubr7_modules_menu] VALUES (17, 0)

----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_newsfeeds]
*/
if exists (select * from sysobjects where name = \'meubr7_newsfeeds\') drop table [meubr7_newsfeeds]

CREATE TABLE [meubr7_newsfeeds] (
[catid] int NOT NULL default \'0\',
[id] int IDENTITY(1,1) PRIMARY KEY,
[name] text NOT NULL,
[link] text NOT NULL,
[filename] varchar(200) default NULL,
[published] smallint NOT NULL default \'0\',
[numarticles] int NOT NULL default \'1\',
[cache_time] int NOT NULL default \'3600\',
[checked_out] smallint NOT NULL default \'0\',
[checked_out_time] datetime NOT NULL default 0,
[ordering] int NOT NULL default \'0\',
)

CREATE INDEX [published] ON [meubr7_newsfeeds]([published])

----------------------------------------------------------

/*
# Estrutura da tabela [meubr7_newsfeedscache]
*/
if exists (select * from sysobjects where name = \'meubr7_newsfeedscache\') drop table [meubr7_newsfeedscache]

CREATE TABLE [meubr7_newsfeedscache] (
[time] varchar(14) default NULL,
[cachefile] varchar(50) NOT NULL default \'\',
[filedata] text NOT NULL
)

/*
# Estrutura da tabela [meubr7_newsflash]
*/
if exists (select * from sysobjects where name = \'meubr7_newsflash\') drop table [meubr7_newsflash]

CREATE TABLE [meubr7_newsflash] (
[id] int IDENTITY(1,1) PRIMARY KEY,
[title] varchar(50) NOT NULL default \'\',
[content] text NOT NULL,
[published] smallint NOT NULL default \'0\',
[checked_out] int NOT NULL default \'0\',
[checked_out_time] datetime NOT NULL default 0,
[catid] int NOT NULL default \'0\',
[publish_up] datetime NOT NULL default 0,
[publish_down] datetime NOT NULL default 0,
[access] int NOT NULL default \'0\'
)

/*
# Inserindo dados na tabela [meubr7_modules_menu]
*/
SET IDENTITY_INSERT [meubr7_newsflash] ON

INSERT INTO [meubr7_newsflash] ([id],[title],[content],[published],[checked_out],[checked_out_time],[catid],[publish_up],[publish_down],[access]) VALUES (1, \'Newsflash 1\', \'Mambo Open Source 4.5 is \'\'Power In Simplicity\'\'!. It has never been easier to create your own dynamic site. Manage all your content from the best CMS admin interface.\', 1, 0, 0, \'\', 0, 0, 0)
INSERT INTO [meubr7_newsflash] ([id],[title],[content],[published],[checked_out],[checked_out_time],[catid],[publish_up],[publish_down],[access]) VALUES (2, \'Newsflash 2\', \'Yesterday all servers in the U.S. went out on strike in a bid to get more RAM and better CPUs. A spokes person said that the need for better RAM was due to some fool increasing the front-side bus speed. In future, busses will be told to slow down in residential motherboards.\', 1, 0, 0, \'\', 0, 0, 0)
INSERT INTO [meubr7_newsflash] ([id],[title],[content],[published],[checked_out],[checked_out_time],[catid],[publish_up],[publish_down],[access]) VALUES (3, \'Newsflash 3\', \'Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn\'\'t mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by itslef but the wrod as a wlohe.\', 1, 0, 0, \'\', 0, 0, 0)

SET IDENTITY_INSERT [meubr7_newsflash] OFF

Olá FabianoCavalcanti

Tudo bem ?

boa iniciativa a tua.

Confesso que não saco nada de MS SQL Server

Espero que você encontre apoio de outros usuários embora a nossa comunidade ainda seja pequena e recente (ainda não completamos 1 mês de existência)

Parece que a versão 5 dará suporte a outros Bancos de Dados.

Fique avontade para usar este espaço para desenvolver o seu trabalho

Você também pode registrar um projeto no Mosforge.net

Um dos nossos objetivos é este, o de estimular o desenvolvimento de projetos para o mambo

é isso aí FabianoCavalcanti

Um abraço

Fabio

Nossa! Que legal, um conterrâneo...

Você sabe que aqui, nós "MS Developers", somos "Barneys" não é?!

Bom, eu estou com vc, tenho 20 anos de experiência em VB desde o GwBasic, e tenho muitos códigos em ASP e ASP.Net.

Inclusive um, que gera boletos na WEB, e que há mais de 5 anos funciona em vários clientes e nunca foi barrado em nenhum Firewall, rede, nada. Já homologado para 132 bancos, inclusive internacionais.

Quero traduzí-lo para PHP, topa fazer?