Index: branches/5.2.x/_install/install_data.sql =================================================================== diff -u -r14613 -r15003 --- branches/5.2.x/_install/install_data.sql (.../install_data.sql) (revision 14613) +++ branches/5.2.x/_install/install_data.sql (.../install_data.sql) (revision 15003) @@ -1,26 +1,26 @@ -UPDATE Category SET IsMenu = 1 WHERE Template = 'index'; +UPDATE Categories SET IsMenu = 1 WHERE Template = 'index'; -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(200, 1, NULL, 1, '', 'About', '', '', '', '', 'About', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -3, NULL, 0, NULL, 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', -1, 200, '|1|200|', 12, 13, 'Content/About', NULL, 2, 2, 2, 1257194911, 0, '#default_design#', '#default_design#', 0, '', 0, '', 'About', '', '', '', '', 'About', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(201, 1, NULL, 1, '', 'Products', '', '', '', '', 'Products', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -4, NULL, 0, NULL, 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', -1, 201, '|1|201|', 14, 15, 'Content/Products', NULL, 2, 2, 2, 1257197984, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Products', '', '', '', '', 'Products', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(202, 1, NULL, 1, '', 'Services', '', '', '', '', 'Services', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -5, NULL, 0, NULL, 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', -1, 202, '|1|202|', 16, 17, 'Content/Services', NULL, 2, 2, 2, 1257200289, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Services', '', '', '', '', 'Services', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); -INSERT INTO Category (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(203, 1, NULL, 1, '', 'Contact Us', '', '', '', '', 'Contact-Us', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257208139, 0, 1, -6, NULL, 0, NULL, 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', -1, 203, '|1|203|', 18, 19, 'Content/Contact-Us', NULL, 2, 2, 2, 1257208178, 0, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Us', '', '', '', '', 'Contact Us', '', '', '', '', NULL, NULL, 1, 0, 1, 'thankyou', '', 0); +INSERT INTO Categories (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(200, 1, NULL, 1, '', 'About', '', '', '', '', 'About', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -3, NULL, 0, NULL, 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', 'Content&|&About', -1, 200, '|1|200|', 12, 13, 'Content/About', NULL, 2, 2, 2, 1257194911, 0, '#default_design#', '#default_design#', 0, '', 0, '', 'About', '', '', '', '', 'About', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); +INSERT INTO Categories (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(201, 1, NULL, 1, '', 'Products', '', '', '', '', 'Products', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -4, NULL, 0, NULL, 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', 'Content&|&Products', -1, 201, '|1|201|', 14, 15, 'Content/Products', NULL, 2, 2, 2, 1257197984, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Products', '', '', '', '', 'Products', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); +INSERT INTO Categories (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(202, 1, NULL, 1, '', 'Services', '', '', '', '', 'Services', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257194857, 0, 1, -5, NULL, 0, NULL, 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', 'Content&|&Services', -1, 202, '|1|202|', 16, 17, 'Content/Services', NULL, 2, 2, 2, 1257200289, -1, '#default_design#', '#default_design#', 0, '', 0, '', 'Services', '', '', '', '', 'Services', '', '', '', '', NULL, NULL, 1, 0, NULL, NULL, '', 0); +INSERT INTO Categories (CategoryId, Type, SymLinkCategoryId, ParentId, Name, l1_Name, l2_Name, l3_Name, l4_Name, l5_Name, Filename, AutomaticFilename, Description, l1_Description, l2_Description, l3_Description, l4_Description, l5_Description, CreatedOn, EditorsPick, Status, Priority, MetaKeywords, CachedDescendantCatsQty, CachedNavbar, l1_CachedNavbar, l2_CachedNavbar, l3_CachedNavbar, l4_CachedNavbar, l5_CachedNavbar, CreatedById, ResourceId, ParentPath, TreeLeft, TreeRight, NamedParentPath, MetaDescription, HotItem, NewItem, PopItem, Modified, ModifiedById, CachedTemplate, Template, UseExternalUrl, ExternalUrl, UseMenuIconUrl, MenuIconUrl, l1_Title, l2_Title, l3_Title, l4_Title, l5_Title, l1_MenuTitle, l2_MenuTitle, l3_MenuTitle, l4_MenuTitle, l5_MenuTitle, MetaTitle, IndexTools, IsMenu, Protected, FormId, FormSubmittedTemplate, FriendlyURL, ThemeId) VALUES(203, 1, NULL, 1, '', 'Contact Us', '', '', '', '', 'Contact-Us', 1, NULL, NULL, NULL, NULL, NULL, NULL, 1257208139, 0, 1, -6, NULL, 0, NULL, 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', 'Content&|&Contact Us', -1, 203, '|1|203|', 18, 19, 'Content/Contact-Us', NULL, 2, 2, 2, 1257208178, 0, '#form_design#', '#form_design#', 0, '', 0, '', 'Contact Us', '', '', '', '', 'Contact Us', '', '', '', '', NULL, NULL, 1, 0, 1, 'thankyou', '', 0); UPDATE IdGenerator SET lastid = lastid + 100; -INSERT INTO PageContent VALUES(DEFAULT, 1, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), '
Once upon a time, there was a webmaster wanna-be Dwayne Wiener working for a company Techno-funky Gadgets, Inc. Dwayne was in charge of the company’s website: responsible for keeping information current, maintaining lists of products and services, posting specials and press releases, and updating the portfolio.
\r\nDwayne was not very happy because every little update to the website had to be done by web designers, who were always late and charged a lot of money. As a result of that, the website was outdated, stagnant and non-performing.
\r\n
\r\n
\r\n“There must be another way!” Dwayne thought in despair. This is how Dwayne found In-Portal Content Management System that puts companies back in control of their websites. The Content Management System (or CMS) allows companies to maintain and update their websites in-house, allowing for a more efficient delivery of critical information, and reducing operating costs of the website.
Dwayne equipped the company’s website with the In-Portal CMS, allowing Dwayne and other personnel at Techno-funky Gadgets to make updates to the website at their convenience. First Dwayne was worried that updating the website is complicated and would require special knowledge of web design and programming. Then Dwayne discovered that the system is very easy to use and is similar to Microsoft© Word™, with all the familiar tools and interfaces. It is completely online-based and can be accessed from any computer connected to the Internet, without any need for special software. The system is also very secure: only authorized personnel can make changes to the website.
\r\nThe uneasy days were over and Dwayne was happy once again. Techno-funky Gadget’a website became one of the best in the industry, the company was saving a lot of money, and clients loved dealing with Techno-funky Gadgets because the website was appealing and easy to use. Dwayne was praised for the technical innovation, became a well known Internet guru around the office, and finally got the well-deserved promotion to the position of a Webmaster.
', NULL, NULL, NULL, NULL); -INSERT INTO PageContent VALUES(DEFAULT, 5, (SELECT CategoryId FROM <%TABLE_PREFIX%>Category WHERE Template = 'index'), 'Once upon a time, there was a webmaster wanna-be Dwayne Wiener working for a company Techno-funky Gadgets, Inc. Dwayne was in charge of the company’s website: responsible for keeping information current, maintaining lists of products and services, posting specials and press releases, and updating the portfolio.
\r\nDwayne was not very happy because every little update to the website had to be done by web designers, who were always late and charged a lot of money. As a result of that, the website was outdated, stagnant and non-performing.
\r\n
\r\n
\r\n“There must be another way!” Dwayne thought in despair. This is how Dwayne found In-Portal Content Management System that puts companies back in control of their websites. The Content Management System (or CMS) allows companies to maintain and update their websites in-house, allowing for a more efficient delivery of critical information, and reducing operating costs of the website.
Dwayne equipped the company’s website with the In-Portal CMS, allowing Dwayne and other personnel at Techno-funky Gadgets to make updates to the website at their convenience. First Dwayne was worried that updating the website is complicated and would require special knowledge of web design and programming. Then Dwayne discovered that the system is very easy to use and is similar to Microsoft© Word™, with all the familiar tools and interfaces. It is completely online-based and can be accessed from any computer connected to the Internet, without any need for special software. The system is also very secure: only authorized personnel can make changes to the website.
\r\nThe uneasy days were over and Dwayne was happy once again. Techno-funky Gadget’a website became one of the best in the industry, the company was saving a lot of money, and clients loved dealing with Techno-funky Gadgets because the website was appealing and easy to use. Dwayne was praised for the technical innovation, became a well known Internet guru around the office, and finally got the well-deserved promotion to the position of a Webmaster.
', NULL, NULL, NULL, NULL); +INSERT INTO PageContent VALUES(DEFAULT, 5, (SELECT CategoryId FROM <%TABLE_PREFIX%>Categories WHERE Template = 'index'), 'Techno-funky Gadgets is a company of tomorrow. We are setting industry standards by utilizing cutting edge technologies and innovations, while opening new frontiers and possibilities for our customers. Dedicated to the design, production, and delivery of innovative giggalmators, agathokakologs, and hundreds of other products and services over the last 25 years, Techno-funky Gadgets is uniquely able to offer its clients expert advice and comprehensive range of products to help them with any aspect of life. The products and services that we develop and make available on the market are used in every day lives of millions of people. Imagine yourself without a giggalmator today, and you will understand exactly what impact Techno-funky Gadgets has on the global community.
\r\nOur mission is to fulfill each and every one of our customers’ needs. We value personal approach, diligence and professionalism, and we place trust at the center of every relationship, always staying committed to our customer. Our Customer Service Representatives are so dedicated to their job – they give out their personal numbers to clients, maintaining our reputation of a world class service company! All of our products and services come with an unlimited lifetime warranty, as Techno-funky Gadgets takes pride in delivering only the highest quality products and services.
\r\nCustomers that choose Techno-funky Gadgets can rest assured that they have made a wise decision. Their business will always be safe in the hands of professionals who are not only experts in their respective fields, but who also greatly enjoy doing what they do best.
\r\nProducts by Techno-funky Gadgets come in a wide variety of shapes, sizes, colors, sounds, resolutions and tastes. Our award-winning products are enjoyed by everyone: from children to great-grandparents; from pre-schoolers to PhD’s; from artists to CFO’s; from rich to poor, from boring to funny. However you like it – Techno-funky Gadgets can cater to your needs.
\r\n\r\n\r\n
\r\n
\r\n
Techno-funky Gadgets is committed to excellence in all aspects of business. Just as our products are of the highest quality, our services bring the utmost satisfaction to our clients. We strive to make the world a better place, and our services have been designed with that goal in mind.
\r\nThe packages described herein are available for general public; however, if you have a special request, please let us know and we will do our best to accommodate you.
\r\n
\r\nIs your office lacking performance? Are you a Manager whose subordinates are unproductive? Nothing gets done around the office? Has your secretary been typing up that memo about doing work on time, for the past four days? If you answered “Yes” to any of the above questions, this Boosting Package is for you! $copmpany has all of our productivity problems solved: the package consists of one Office Drill Sergeant and two Assistants.
As we always do what’s in the best interest of our Client, this is a service we provide for a maximum period of one week at a time, so as not to increase employee turnover in your Company. You will have the Office Drill Sergeant at your workplace from morning and until night, ensuring that no one under your command slacks off. This is our most popular office service, and the only one, according to our clients, that significantly increases productivity in the office.
\r\nTechno-funky Gadgets believes that plants must not be dusty. After a number of extensive and very reliable surveys, Techno-funky Gadgets received reassurance that many people in the world have the same concern.
\r\nThis Package includes:
\r\n1. Plant-dusting of all plants – both inside and outside of your house
\r\n2. A set of our revolutionary Plant Dusters, engineered and produced by Techno-funky Gadgets
\r\n3. Actual planting of 3 new plants of your choice
\r\n4. BONUS: A complimentary video of various plant-dusting techniques!
Techno-funky Gadgets only hires the top-of-the-class graduates of the World Plant-Dusting Institute, administer rigorous tests to ensure qualification, and hold mandatory Seminars to ensure that all of our top-notch dusters stay atop the newest industry developments and standards.
\r\nThis package does not disappoint – we leave your plants spotless, green, and dust-free!
\r\n If you have any questions, comments, concerns, or if you would like to request general information about any of our products or services, please contact us in a way that is the most convenient for you:\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
Techno-funky Gadgets, Inc
\r\n1234 Funky Drive
\r\nDwayneville, Alaska 00190
\r\nUnited States
Phone: 847-816-1231
\r\nE-mail: info@company.com