-- Table structure for table `Collection_130`
--

CREATE TABLE `Collection_130` (
  `Collection_130_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_130_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_130_2` varchar(254) DEFAULT NULL,
  `Collection_130_3` varchar(254) DEFAULT NULL,
  `Collection_130_4` text,
  `Collection_130_5` varchar(254) NOT NULL DEFAULT '',
  `Collection_130_6` varchar(254) DEFAULT NULL,
  `Collection_130_7` int(11) DEFAULT NULL,
  `Collection_130_8` varchar(254) DEFAULT NULL,
  `Collection_130_9` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_130_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_130`
--

INSERT INTO `Collection_130` VALUES (1,'Oxiem Store Category','/images/contentimages/image_20_4_66.gif','/images/contentimages/image_20_4_66.gif','Vivamus et mi at arcu mattis iaculis. Nullam posuere tristique tortor. In bibendum. Aenean ornare, nunc eget pretium porttitor, sem est pretium leo, non euismod nulla dui non diam. \r\nPellentesque dictum faucibus leo.','products-store-category','on',NULL,NULL,NULL),(2,'Software','/images/contentimages/image_20_4_67.gif','/images/contentimages/image_20_4_67.gif','Aliquam risus justo, mollis in, laoreet a, consectetuer nec, risus. Nunc blandit sodales lacus. Nam luctus semper mi. In eu diam. Phasellus rutrum elit vel nisi. Cras mauris nulla, egestas quis, cursus at, venenatis ac, ante. \r\nFusce accumsan enim et arcu.','software','on',NULL,NULL,NULL),(3,'Banners','/images/contentimages/image_20_4_66.gif','/images/contentimages/image_20_4_66.gif','Aliquam risus justo, mollis in, laoreet a, consectetuer nec, risus. \r\nNunc blandit sodales lacus. \r\nNam luctus semper mi. In eu diam.','banners','on',NULL,NULL,NULL);

--
-- Table structure for table `Collection_131`
--

CREATE TABLE `Collection_131` (
  `Collection_131_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_131_1` bigint(20) NOT NULL DEFAULT '0',
  `Collection_131_2` varchar(254) DEFAULT NULL,
  `Collection_131_3` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Collection_131_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=80 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_131`
--

INSERT INTO `Collection_131` VALUES (12,5,'asad',200),(54,2,'Suspendisse potenti',20);

--
-- Table structure for table `Collection_132`
--

CREATE TABLE `Collection_132` (
  `Collection_132_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_132_1` int(11) DEFAULT NULL,
  `Collection_132_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_132_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=154 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_132`
--

INSERT INTO `Collection_132` VALUES (153,5,1);

--
-- Table structure for table `Collection_133`
--

CREATE TABLE `Collection_133` (
  `Collection_133_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_133_1` varchar(254) DEFAULT NULL,
  `Collection_133_2` bigint(20) DEFAULT NULL,
  `Collection_133_3` bigint(20) DEFAULT NULL,
  `Collection_133_4` varchar(254) DEFAULT NULL,
  `Collection_133_5` varchar(254) DEFAULT NULL,
  `Collection_133_16` int(11) DEFAULT NULL,
  `Collection_133_17` int(11) DEFAULT NULL,
  `Collection_133_18` varchar(254) DEFAULT NULL,
  `Collection_133_19` int(11) DEFAULT NULL,
  `Collection_133_20` varchar(254) DEFAULT NULL,
  `Collection_133_21` varchar(254) DEFAULT NULL,
  `Collection_133_22` int(11) DEFAULT NULL,
  `Collection_133_23` double DEFAULT NULL,
  `Collection_133_24` double DEFAULT NULL,
  `Collection_133_25` double DEFAULT NULL,
  `Collection_133_26` double DEFAULT NULL,
  `Collection_133_27` double DEFAULT NULL,
  `Collection_133_28` varchar(254) DEFAULT NULL,
  `Collection_133_30` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_133_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_133`
--

INSERT INTO `Collection_133` VALUES (56,'tclbqm3ml538k1iphu0ca4rnp6',NULL,1292848361,'109.99.39.27',' ',NULL,1,'on',NULL,NULL,NULL,NULL,20,20,0,0,0,NULL,NULL),(55,'b8sckrovuv497bp5df30ka66f5',35,1284646407,'109.99.39.27','on',NULL,1,'on',141,'on',NULL,NULL,385,375,10,0,0,NULL,'45502'),(57,'j9nmcnqhr1148iek8u3urtrub6',NULL,1341297147,'109.102.13.1',' ',NULL,1,'on',141,NULL,NULL,NULL,300,200,0,100,0,NULL,'45502'),(58,'d0vdtgvm7ke4m09e29knuas7d4',NULL,1351776018,'109.102.13.1',' ',2,1,'on',NULL,NULL,NULL,NULL,290,200,0,100,10,NULL,NULL),(59,'8btj086atk8319eot9llfdsmv2',0,1356534551,'79.119.181.187',' ',NULL,1,'on',NULL,NULL,NULL,NULL,300,200,0,100,0,NULL,NULL);

--
-- Table structure for table `Collection_134`
--

CREATE TABLE `Collection_134` (
  `Collection_134_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_134_1` bigint(20) DEFAULT NULL,
  `Collection_134_2` int(11) DEFAULT NULL,
  `Collection_134_3` bigint(20) DEFAULT NULL,
  `Collection_134_4` int(11) DEFAULT NULL,
  `Collection_134_5` double DEFAULT NULL,
  `Collection_134_6` varchar(254) DEFAULT NULL,
  `Collection_134_7` varchar(254) DEFAULT NULL,
  `Collection_134_8` varchar(254) DEFAULT NULL,
  `Collection_134_9` int(11) DEFAULT NULL,
  `Collection_134_10` double DEFAULT NULL,
  `Collection_134_11` text,
  `Collection_134_12` int(11) DEFAULT NULL,
  `Collection_134_13` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_134_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_134`
--

INSERT INTO `Collection_134` VALUES (10,56,2,1,54,20,'Suspendisse potenti','oXiem Advanced',NULL,NULL,20,'',2,NULL),(9,55,2,25,54,20,'Suspendisse potenti','oXiem Advanced',NULL,NULL,15,'25% off, for 25 or more products purchased ',2,NULL),(11,57,5,1,12,200,'asad','oXiem New Edited',NULL,0,200,'',1,NULL),(12,58,5,1,12,200,'asad','oXiem New Edited',NULL,0,200,'',1,NULL),(13,59,5,1,12,200,'asad','oXiem New Edited',NULL,0,200,'',1,NULL);

--
-- Table structure for table `Collection_135`
--

CREATE TABLE `Collection_135` (
  `Collection_135_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_135_1` varchar(254) DEFAULT NULL,
  `Collection_135_2` bigint(20) DEFAULT NULL,
  `Collection_135_3` varchar(254) DEFAULT NULL,
  `Collection_135_4` bigint(20) DEFAULT NULL,
  `Collection_135_5` double DEFAULT NULL,
  `Collection_135_6` varchar(254) DEFAULT NULL,
  `Collection_135_7` text,
  PRIMARY KEY (`Collection_135_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_135`
--

INSERT INTO `Collection_135` VALUES (1,'20$ discount',NULL,'20DISC',1347821640,20,NULL,'<p>Just a $20 discount for purchases greater than $20</p>'),(2,'50% discount from the marchandise value',5,'5DISCOUNT',1379444100,NULL,NULL,'<p>This coupon gives a 50% discount from all purchased products.</p>\r\n'),(3,'Free Shipping',NULL,'SHIPME',1347821700,NULL,'on','<p>This coupon will make the shipping fee to be $0</p>');

--
-- Table structure for table `Collection_136`
--

CREATE TABLE `Collection_136` (
  `Collection_136_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_136_1` varchar(254) DEFAULT NULL,
  `Collection_136_2` varchar(254) DEFAULT NULL,
  `Collection_136_3` double DEFAULT NULL,
  PRIMARY KEY (`Collection_136_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_136`
--

INSERT INTO `Collection_136` VALUES (1,'Parcel Post','on',100),(2,'Priority Mail','on',15),(3,'Pick up',NULL,0);

--
-- Table structure for table `Collection_137`
--

CREATE TABLE `Collection_137` (
  `Collection_137_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_137_1` int(11) DEFAULT NULL,
  `Collection_137_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_137_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=207 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_137`
--

INSERT INTO `Collection_137` VALUES (21,NULL,1),(22,NULL,3),(23,NULL,2),(24,NULL,1),(25,NULL,3),(26,NULL,2),(27,NULL,1),(28,NULL,3),(29,NULL,2),(30,NULL,1),(31,NULL,3),(32,NULL,2),(33,NULL,1),(34,NULL,3),(35,NULL,2),(36,NULL,1),(37,NULL,3),(38,NULL,2),(39,NULL,1),(40,NULL,3),(41,NULL,2),(42,NULL,1),(43,NULL,3),(44,NULL,2),(45,NULL,1),(46,NULL,3),(47,NULL,2),(48,NULL,1),(49,NULL,3),(50,NULL,2),(51,NULL,1),(52,NULL,3),(53,NULL,2),(206,5,2);

--
-- Table structure for table `Collection_138`
--

CREATE TABLE `Collection_138` (
  `Collection_138_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_138_1` int(11) DEFAULT NULL,
  `Collection_138_2` varchar(254) NOT NULL DEFAULT '',
  `Collection_138_3` varchar(254) NOT NULL DEFAULT '',
  `Collection_138_4` varchar(254) DEFAULT NULL,
  `Collection_138_5` varchar(254) NOT NULL DEFAULT '',
  `Collection_138_6` varchar(254) DEFAULT NULL,
  `Collection_138_7` varchar(254) NOT NULL DEFAULT '',
  `Collection_138_8` int(11) NOT NULL DEFAULT '0',
  `Collection_138_9` varchar(254) NOT NULL DEFAULT '',
  `Collection_138_10` varchar(254) NOT NULL DEFAULT '',
  `Collection_138_11` varchar(254) DEFAULT NULL,
  `Collection_138_12` varchar(254) NOT NULL DEFAULT '',
  PRIMARY KEY (`Collection_138_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_138`
--

INSERT INTO `Collection_138` VALUES (2,0,'Dinescu','Daniel','Oxiem','Address','sss','Springfield',36,'455402','423423','32423','ddinescu@oxiem.com'),(3,55,'Dinescu','Daniel',NULL,'dadas',NULL,'Springfield',36,'455402','43242','4322','ddinescu@oxiem.com');

--
-- Table structure for table `Collection_139`
--

CREATE TABLE `Collection_139` (
  `Collection_139_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_139_1` int(11) DEFAULT NULL,
  `Collection_139_2` varchar(254) NOT NULL DEFAULT '',
  `Collection_139_3` varchar(254) NOT NULL DEFAULT '',
  `Collection_139_4` varchar(254) NOT NULL DEFAULT '',
  `Collection_139_5` varchar(254) DEFAULT NULL,
  `Collection_139_6` varchar(254) NOT NULL DEFAULT '',
  `Collection_139_7` int(11) NOT NULL DEFAULT '0',
  `Collection_139_8` varchar(254) DEFAULT NULL,
  `Collection_139_9` varchar(254) DEFAULT NULL,
  `Collection_139_10` varchar(254) NOT NULL DEFAULT '',
  PRIMARY KEY (`Collection_139_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_139`
--

INSERT INTO `Collection_139` VALUES (2,55,'Dinescu','Daniel','dadas',NULL,'Springfield',36,'43242',NULL,'455402');

--
-- Table structure for table `Collection_14`
--

CREATE TABLE `Collection_14` (
  `Collection_14_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_14_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_14_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_14`
--

INSERT INTO `Collection_14` VALUES (1,'Web Page Content'),(2,'Module Content'),(3,'Master Template'),(6,'Web Page Snippet'),(10,'Email Content');

--
-- Table structure for table `Collection_140`
--

CREATE TABLE `Collection_140` (
  `Collection_140_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_140_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_140_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_140`
--

INSERT INTO `Collection_140` VALUES (1,'VISA'),(2,'MASTERCARD'),(3,'AMERICAN EXPRESS');

--
-- Table structure for table `Collection_141`
--

CREATE TABLE `Collection_141` (
  `Collection_141_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_141_1` int(11) DEFAULT NULL,
  `Collection_141_2` int(11) DEFAULT NULL,
  `Collection_141_3` int(11) DEFAULT NULL,
  `Collection_141_4` int(11) DEFAULT NULL,
  `Collection_141_5` varchar(254) NOT NULL DEFAULT '',
  `Collection_141_6` varchar(254) NOT NULL DEFAULT '',
  `Collection_141_7` varchar(254) NOT NULL DEFAULT '',
  `Collection_141_8` varchar(254) NOT NULL DEFAULT '',
  PRIMARY KEY (`Collection_141_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_141`
--


--
-- Table structure for table `Collection_142`
--

CREATE TABLE `Collection_142` (
  `Collection_142_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_142_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_142_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_142`
--

INSERT INTO `Collection_142` VALUES (1,'January'),(2,'February'),(3,'March'),(4,'April'),(5,'May'),(6,'June'),(7,'July'),(8,'August'),(9,'September'),(10,'October'),(11,'November'),(12,'December');

--
-- Table structure for table `Collection_143`
--

CREATE TABLE `Collection_143` (
  `Collection_143_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_143_1` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_143_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2014 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_143`
--

INSERT INTO `Collection_143` VALUES (2010,2010),(2011,2011),(2012,2012);

--
-- Table structure for table `Collection_144`
--

CREATE TABLE `Collection_144` (
  `Collection_144_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_144_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_144_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_144`
--

INSERT INTO `Collection_144` VALUES (1,'Invalid security code.'),(2,'Invalid card number.'),(3,'Invalid card expiration date (card has expired).');

--
-- Table structure for table `Collection_146`
--

CREATE TABLE `Collection_146` (
  `Collection_146_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_146_1` int(11) DEFAULT NULL,
  `Collection_146_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_146_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_146`
--

INSERT INTO `Collection_146` VALUES (91,5,2);

--
-- Table structure for table `Collection_147`
--

CREATE TABLE `Collection_147` (
  `Collection_147_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_147_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_147_2` varchar(254) DEFAULT NULL,
  `Collection_147_3` text,
  PRIMARY KEY (`Collection_147_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=151 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_147`
--

INSERT INTO `Collection_147` VALUES (141,'Credit Card','on',NULL),(149,'eCheck',NULL,NULL),(150,'Purchase Order','on',NULL);

--
-- Table structure for table `Collection_148`
--

CREATE TABLE `Collection_148` (
  `Collection_148_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_148_1` varchar(254) NOT NULL DEFAULT '',
  PRIMARY KEY (`Collection_148_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_148`
--

INSERT INTO `Collection_148` VALUES (1,'Checking'),(2,'Business Checking'),(3,'Savings');

--
-- Table structure for table `Collection_149`
--

CREATE TABLE `Collection_149` (
  `Collection_149_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_149_1` int(11) DEFAULT NULL,
  `Collection_149_2` varchar(254) NOT NULL DEFAULT '',
  `Collection_149_3` varchar(254) NOT NULL DEFAULT '',
  `Collection_149_4` int(11) NOT NULL DEFAULT '0',
  `Collection_149_5` varchar(254) NOT NULL DEFAULT '',
  PRIMARY KEY (`Collection_149_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_149`
--


--
-- Table structure for table `Collection_15`
--

CREATE TABLE `Collection_15` (
  `Collection_15_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_15_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_15_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_15`
--

INSERT INTO `Collection_15` VALUES (1,'Standard HTML Content'),(3,'Dynamic Generated Content (Text Area)');

--
-- Table structure for table `Collection_150`
--

CREATE TABLE `Collection_150` (
  `Collection_150_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_150_1` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_150_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_150`
--


--
-- Table structure for table `Collection_151`
--

CREATE TABLE `Collection_151` (
  `Collection_151_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_151_1` int(11) NOT NULL DEFAULT '0',
  `Collection_151_2` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Collection_151_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_151`
--

INSERT INTO `Collection_151` VALUES (1,36,7.25);

--
-- Table structure for table `Collection_152`
--

CREATE TABLE `Collection_152` (
  `Collection_152_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_152_1` int(11) DEFAULT NULL,
  `Collection_152_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_152_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_152`
--


--
-- Table structure for table `Collection_153`
--

CREATE TABLE `Collection_153` (
  `Collection_153_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_153_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_153_2` double NOT NULL DEFAULT '0',
  `Collection_153_3` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Collection_153_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_153`
--

INSERT INTO `Collection_153` VALUES (1,'up to $15',0,15),(2,'$15.01 to $30.00',15.01,30),(3,'$30.01 to $40.00',30.01,40),(4,'$40.01 to $50',40.01,50),(5,'$50.01 to $75',50.01,75),(6,'$75.01 to $100',75.01,100),(7,'$100.01 to $125',100.01,125),(8,'$125.01 to $150',125.01,150),(9,'$150.01 to $200',150.01,200),(10,'over $200.00',200.01,0);

--
-- Table structure for table `Collection_154`
--

CREATE TABLE `Collection_154` (
  `Collection_154_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_154_1` int(11) NOT NULL DEFAULT '0',
  `Collection_154_2` int(11) NOT NULL DEFAULT '0',
  `Collection_154_3` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`Collection_154_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_154`
--

INSERT INTO `Collection_154` VALUES (1,1,1,5.95),(2,1,2,8.45),(3,2,1,7.95),(4,2,2,10.45),(5,3,1,8.95),(6,3,2,11.45),(7,4,1,10.5),(8,4,2,13),(9,5,1,12.5),(10,5,2,15),(11,6,1,13.5),(12,6,2,16),(13,7,1,14.5),(14,7,2,17),(15,8,1,15.5),(16,8,2,18),(17,9,1,17.5),(18,9,2,20),(19,10,1,19.5),(20,10,2,22);

--
-- Table structure for table `Collection_159`
--

CREATE TABLE `Collection_159` (
  `Collection_159_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_159_1` varchar(254) DEFAULT NULL,
  `Collection_159_2` varchar(254) DEFAULT NULL,
  `Collection_159_3` varchar(254) DEFAULT NULL,
  `Collection_159_4` varchar(254) DEFAULT NULL,
  `Collection_159_5` varchar(254) DEFAULT NULL,
  `Collection_159_6` varchar(254) DEFAULT NULL,
  `Collection_159_7` varchar(254) DEFAULT NULL,
  `Collection_159_8` varchar(254) DEFAULT NULL,
  `Collection_159_9` varchar(254) DEFAULT NULL,
  `Collection_159_10` varchar(254) DEFAULT NULL,
  `Collection_159_11` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_159_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_159`
--

INSERT INTO `Collection_159` VALUES (1,'Shopping Cart','users@oxiem.com','Your account information','Shopping Cart','receipt@oxiem.com','The receipt for your purchase','Shopping Cart - receipt','receipt@oxiem.com','Receipt for new purchase','ddinescu@oxiem.com','on');

--
-- Table structure for table `Collection_16`
--

CREATE TABLE `Collection_16` (
  `Collection_16_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_16_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_16_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_16`
--

INSERT INTO `Collection_16` VALUES (1,'American English'),(2,'French'),(3,'German'),(4,'Spanish');

--
-- Table structure for table `Collection_160`
--

CREATE TABLE `Collection_160` (
  `Collection_160_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_160_1` int(11) DEFAULT NULL,
  `Collection_160_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_160_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_160`
--


--
-- Table structure for table `Collection_162`
--

CREATE TABLE `Collection_162` (
  `Collection_162_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_162_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_162_2` text,
  PRIMARY KEY (`Collection_162_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_162`
--

INSERT INTO `Collection_162` VALUES (1,'$5 off all signups after the first signup','if ($quantity > 1)\r\n{\r\n$ReturnVal[\'Value\'] = $price + ( ($price - 5) * ($quantity - 1) );\r\n$ReturnVal[\'Text\']  = $row[\'Collection_162_1\'];\r\n}');

--
-- Table structure for table `Collection_163`
--

CREATE TABLE `Collection_163` (
  `Collection_163_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_163_1` int(11) DEFAULT NULL,
  `Collection_163_2` int(11) DEFAULT NULL,
  `Collection_163_3` bigint(20) DEFAULT NULL,
  `Collection_163_4` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_163_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_163`
--


--
-- Table structure for table `Collection_17`
--

CREATE TABLE `Collection_17` (
  `Collection_17_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_17_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_17_2` varchar(254) DEFAULT NULL,
  `Collection_17_3` varchar(254) NOT NULL DEFAULT '',
  `Collection_17_4` int(11) DEFAULT NULL,
  `Collection_17_5` int(11) DEFAULT NULL,
  `Collection_17_6` int(11) DEFAULT NULL,
  `Collection_17_7` text,
  `Collection_17_8` text,
  `Collection_17_9` bigint(20) DEFAULT NULL,
  `Collection_17_10` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_17_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=564 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_17`
--

INSERT INTO `Collection_17` VALUES (1,'CONTENT - Homepage','Homepage','index',1,689,2,NULL,NULL,1188476751,'on'),(302,'Site Blog - Archive Page','Site Blog - Archive Page','blog-archives',1,1,305,NULL,NULL,1202238406,'on'),(2,'CONTENT - About Us','About Us','about',1,1,560,'dskaj dksaj das d\r\nsakdsa jjd\r\na dksa dsad\r\n sa dksaj d\r\nads ak jdsa','sad sa\r\ndsakdjsa\r\ndsa dsak jsda\r\ndsak dsadsadsa ',1188476791,'on'),(3,'CONTENT - Page Not Found','Page Not Found','notfound',1,1,4,NULL,NULL,1192445387,'on'),(4,'EMAIL - Collection Email','Collections Email','email/collection-email',2,7,8,NULL,NULL,1193136464,'on'),(5,'EMAIL - Lost Password','Your Lost Password','email/lost-password',2,7,9,NULL,NULL,1193158688,'on'),(6,'FORMS - Login','Login','login',1,1,6,NULL,NULL,1193158837,'on'),(7,'FORMS - Send Lost Password','Your Lost Password','forgotpassword',1,1,10,NULL,NULL,1193158890,'on'),(8,'EMAIL - Newsletter October','October Newsletter','email/newsletter-oct-2007',2,7,14,NULL,NULL,1193397714,'on'),(9,'FORMS - Edit Account','Edit Account Info','edit-account',1,1,19,NULL,NULL,1199457569,'on'),(10,'FORMS - Register','Register','register',1,1,15,NULL,NULL,1199457664,'on'),(11,'FORMS - Register - Done','Register','register-done',1,1,16,NULL,NULL,1199457691,'on'),(12,'FORMS - Welcome','Welcome','welcome',1,1,17,NULL,NULL,1199457739,'on'),(13,'FORMS - Logout','Logout','logout',1,1,20,NULL,NULL,1199457870,'on'),(14,'CONTENT - Contact Us','Contact Us','contact-us',1,1,25,NULL,NULL,1204545858,'on'),(15,'CONTENT - Contact Us TQ','Contact Us','contact-us-thank-you',1,1,26,NULL,NULL,1204545886,'on'),(232,'CALENDAR - Content Page - Weekly','Weekly Calendar','calendar-weekly',1,1,247,NULL,NULL,1196781665,'on'),(233,'CALENDAR - One Event','One Event','event',1,1,251,NULL,NULL,1196781731,'on'),(234,'CALENDAR - One Venue','One Venue','venues',1,1,252,NULL,NULL,1196781835,'on'),(236,'CALENDAR - Content Page','Calendar','calendar',3,1,245,NULL,NULL,1196869511,'on'),(237,'NEWS - Archive','News Archive','news/archives/index',1,1,256,NULL,NULL,1201543735,'on'),(238,'NEWS - Archives Category News','Archives Category News','news/archives/category-news',1,1,257,NULL,NULL,1201543768,'on'),(239,'NEWS - Archives One News','Archive One News','news/archives/one-ne',1,1,258,NULL,NULL,1201543832,'on'),(240,'NEWS - Category News','Category News','news/category-newslist',1,1,260,NULL,NULL,1201543916,'on'),(241,'NEWS - Main news Page','News and Info','news/index',1,1,261,NULL,NULL,1201544091,'on'),(242,'NEWS - One News','One News','news/one-news-display',1,1,262,NULL,NULL,1201544235,'on'),(303,'Site Blog - Article','Site Blog - Article','blog-article',1,1,306,NULL,NULL,1202288097,'on'),(304,'Site Blog - Edit Comment','Edit Comment','edit-comment',1,1,307,NULL,NULL,1202314489,'on'),(305,'Site Blog - Delete Comment','Delete Comment','delete-comment',1,1,308,NULL,NULL,1202318682,'on'),(306,'Site Blog - Delete Article','Delete Article','delete-article',1,1,309,NULL,NULL,1202319081,'on'),(307,'Site Blog - Add Article','Add Article','add-article',1,1,310,NULL,NULL,1202319706,'on'),(308,'Site Blog - Edit Article','Edit Article','edit-article',1,1,311,NULL,NULL,1202321493,'on'),(426,'IBuildResults - Contact Form','IBuildResults - Contact Form','ibuild-contact-us',1,1,503,NULL,NULL,1223050853,'on'),(422,'SYSTEM - Preview Contents','SYSTEM - Preview Contents','system/preview-contents',1,651,498,NULL,NULL,1221744642,'on'),(150,'VIDEOS - Sample Content','Videos','videos',1,1,151,NULL,NULL,1222701678,'on'),(418,'GALLERY - Filter','GALLERY - Filter','galleryfilter',1,11,160,NULL,NULL,1220979873,'on'),(417,'GALLERY - Content Page','Photo Gallery','photo-gallery',1,1,663,NULL,NULL,1220885572,'on'),(301,'Site Blog - Topic Page','Topic Page','blog-topics',1,1,304,NULL,NULL,1202232702,'on'),(300,'CONTENT - Blog','Blog','blog',1,1,301,NULL,NULL,1202075982,'on'),(231,'CALENDAR - Content Page - Daily','Daily Calendar','calendar-daily',1,1,244,NULL,NULL,1225721988,'on'),(429,'IBuildResults - Display Rows','Display Rows','ibuild-contact-us-display',1,1,505,NULL,NULL,1227274633,'on'),(431,'Content - Site Map','Site Map','site-map',1,1,507,NULL,NULL,1228324442,'on'),(432,'CONTENT - Search','Search :: {{$smarty.get.words}}','search',1,1,508,NULL,NULL,1228325048,'on'),(28,'SHOPPING CART - Add Product','Add Product','addproduct',1,39,37,NULL,NULL,1197031742,'on'),(29,'SHOPPING CART - AJAX - Display Big Cart','SHOPPING CART - AJAX - Display Big Cart','displaycart',1,39,38,NULL,NULL,1197031779,'on'),(30,'SHOPPING CART - Categories Page','Categories Page','store/categories',1,1,41,NULL,NULL,1197031810,'on'),(31,'SHOPPING CART - Checkout','Checkout','checkout',1,1,44,NULL,NULL,1197031846,'on'),(32,'SHOPPING CART - Edit Cart','Edit Cart Details','shopping-cart',1,1,47,NULL,NULL,1197031873,'on'),(33,'SHOPPING CART - One Product Detail','Product Detail','products/details',1,1,51,NULL,NULL,1197032096,'on'),(34,'SHOPPING CART - Payment Check','SHOPPING CART - Payment Check','checkout/payment-check',1,1,52,NULL,NULL,1197032148,'on'),(35,'SHOPPING CART - Payment Information','Payment Information','checkout/payment-information',1,1,53,NULL,NULL,1197032235,'on'),(36,'SHOPPING CART - Personal Information','Personal Information','checkout/personal-information',1,1,54,NULL,NULL,1197032277,'on'),(37,'SHOPPING CART - Products Page','Store','products/index',1,1,57,NULL,NULL,1197032317,'on'),(38,'SHOPPING CART - Remove Product','Remove Product','remove-product',1,1,58,NULL,NULL,1197032440,'on'),(39,'SHOPPING CART - Shipping Information','Shipping Information','checkout/shipping-information',1,1,61,NULL,NULL,1197032494,'on'),(73,'SHOPPING CART - Change Options In Product Page','SHOPPING CART - Change Options In Product Page','getOptionsForProduct',1,39,130,NULL,NULL,1200658631,'on'),(75,'SHOPPING CART - Order History','Order History','orders',1,1,137,NULL,NULL,1200920642,'on'),(76,'SHOPPING CART - Order History','SHOPPING CART - Order History','orderdetails',1,39,138,NULL,NULL,1200924354,'on'),(77,'SHOPPING CART - Additional Information','Additional Information Required','checkout/additional-information',1,1,139,NULL,NULL,1219061021,'on'),(40,'SHOPPING CART - One Product - without category','SHOPPING CART - One Product - without category','store-products/index',1,1,62,NULL,NULL,1222267023,'on'),(41,'EMAIL - Receipt Sent to User','User Receipt','checkout/email/receipt-to-user',2,7,143,NULL,NULL,1219075071,'on'),(42,'Email - Automatic new user email','new user registration email','email/automaticnewuser',2,7,142,NULL,NULL,1219075177,'on'),(438,'EMAIL - Collection Text Email','EMAIL - Collection Text Email','email/text-collection-email',2,11,518,NULL,NULL,1239271430,'on'),(439,'SYSTEM - Tree View','SYSTEM - Tree View','system/treeview',1,11,522,NULL,NULL,1249807826,'on'),(440,'SYSTEM - Tree View - Details','SYSTEM - Tree View - Details','system/treeviewdetails',1,11,523,NULL,NULL,1249810501,'on'),(441,'EMAIL - Approval Email','EMAIL - Approval Email','email/approvalemail',2,7,524,NULL,NULL,1258629172,'on'),(443,'FORMS - Welcome Copy','Welcome Copy','welcome-copy',1,1,528,NULL,NULL,1259253001,'on'),(469,'a Content Page','Content Page','contentpage',1,1,560,NULL,NULL,1276691260,'on'),(470,'a Landing Page','Landing Page','landingpage',1,688,561,NULL,NULL,1276692745,'on'),(483,'SYSTEM - Phone Records','SYSTEM - Phone Records','system/phone-records',1,1,579,NULL,NULL,1278154652,'on'),(520,'CALENDAR - XML Feed','Events XML Feed','xml/events',1,39,621,NULL,NULL,1279735845,'on'),(546,'Content - Pricing','Pricing','pricing',1,1,667,NULL,NULL,1327082891,'on'),(547,'Content - roi-calculator','roi-calculator','roi-calculator',1,1,668,NULL,NULL,1327082931,'on'),(558,'Load Content','Load Content','load-content',1,1,677,NULL,NULL,1346161566,'on'),(559,'SYSTEM - Tree View - Migration - Details','SYSTEM - Tree View - Migration - Details','system/treeviewdetails-migrate',1,11,678,NULL,NULL,1351242345,'on'),(562,'CONTENT - Request Info','Request Info','request-info',1,1,690,NULL,NULL,1386348343,'on'),(563,'CONTENT - Request Info','Request Info','request-info-thank-you',1,1,691,NULL,NULL,1386348366,'on');

--
-- Table structure for table `Collection_18`
--

CREATE TABLE `Collection_18` (
  `Collection_18_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_18_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_18_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_18`
--

INSERT INTO `Collection_18` VALUES (1,'Content Page'),(2,'Email Message'),(3,'Non-Page');

--
-- Table structure for table `Collection_19`
--

CREATE TABLE `Collection_19` (
  `Collection_19_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_19_1` int(11) DEFAULT NULL,
  `Collection_19_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_19_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1162 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_19`
--

INSERT INTO `Collection_19` VALUES (1161,17,3),(1160,17,1),(1159,17,2),(1149,304,2),(1148,304,3),(1147,304,1),(1118,305,3),(1117,305,1),(1116,305,2),(1124,306,3),(1123,306,5),(1122,306,4),(1144,307,3),(1134,308,1),(1129,309,1),(1113,310,5),(1112,310,3),(1111,310,1),(1139,311,3),(1110,310,2),(1109,310,4),(1115,305,5),(1114,305,4),(1121,306,3),(1120,306,2),(1119,306,1),(1128,309,2),(1127,309,4),(1126,309,5),(1125,309,3),(1133,308,4),(1132,308,5),(1131,308,2),(1130,308,3),(1138,311,2),(1137,311,5),(1136,311,4),(1135,311,1),(1143,307,2),(1142,307,5),(1141,307,4),(1140,307,1),(1146,304,5),(1145,304,4),(1020,579,2);

--
-- Table structure for table `Collection_2`
--

CREATE TABLE `Collection_2` (
  `Collection_2_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_2_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_2_2` varchar(254) DEFAULT NULL,
  `Collection_2_3` varchar(254) DEFAULT NULL,
  `Collection_2_4` varchar(254) DEFAULT NULL,
  `Collection_2_5` varchar(254) DEFAULT NULL,
  `Collection_2_7` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_2_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_2`
--

INSERT INTO `Collection_2` VALUES (1,'Content Administrator',NULL,NULL,NULL,NULL,556),(2,'Administrators','on','on','on','on',3),(3,'Site Users',NULL,NULL,NULL,NULL,NULL),(6,'News, Events, Content Editors',NULL,'on','on','on',NULL);

--
-- Table structure for table `Collection_20`
--

CREATE TABLE `Collection_20` (
  `Collection_20_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_20_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_20_2` varchar(254) DEFAULT NULL,
  `Collection_20_3` int(11) DEFAULT NULL,
  `Collection_20_4` varchar(254) DEFAULT NULL,
  `Collection_20_` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_20_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=206 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_20`
--

INSERT INTO `Collection_20` VALUES (204,'Test to S3',NULL,2,'http://o2v1.s3.amazonaws.com/6a00d8341bf67c53ef0153928ec329970b-800wi.jpg',NULL),(205,'Test image','yup',1,'/content/images/eagle-stock-image.png',NULL);

--
-- Table structure for table `Collection_21`
--

CREATE TABLE `Collection_21` (
  `Collection_21_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_21_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_21_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_21`
--

INSERT INTO `Collection_21` VALUES (1,'Banner'),(2,'Content'),(3,'Logo'),(4,'Product'),(5,'Rotator Image'),(6,'Site Icon'),(7,'Thumbnail'),(8,'Quick Upload');

--
-- Table structure for table `Collection_22`
--

CREATE TABLE `Collection_22` (
  `Collection_22_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_22_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_22_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_22`
--

INSERT INTO `Collection_22` VALUES (1,'Yes'),(2,'No');

--
-- Table structure for table `Collection_23`
--

CREATE TABLE `Collection_23` (
  `Collection_23_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_23_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_23_2` varchar(254) DEFAULT NULL,
  `Collection_23_3` int(11) DEFAULT NULL,
  `Collection_23_4` varchar(254) DEFAULT NULL,
  `Collection_23_5` varchar(254) NOT NULL DEFAULT '',
  PRIMARY KEY (`Collection_23_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_23`
--

INSERT INTO `Collection_23` VALUES (48,'aa','aa',NULL,'','/content/documents/svn-book.pdf');

--
-- Table structure for table `Collection_236`
--

CREATE TABLE `Collection_236` (
  `Collection_236_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_236_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_236_2` bigint(20) DEFAULT NULL,
  `Collection_236_3` bigint(20) DEFAULT NULL,
  `Collection_236_4` text,
  `Collection_236_5` varchar(254) DEFAULT NULL,
  `Collection_236_6` varchar(254) DEFAULT NULL,
  `Collection_236_7` int(11) DEFAULT NULL,
  `Collection_236_8` int(11) DEFAULT NULL,
  `Collection_236_9` bigint(20) DEFAULT NULL,
  `Collection_236_10` bigint(20) DEFAULT NULL,
  `Collection_236_11` varchar(254) DEFAULT NULL,
  `Collection_236_12` varchar(254) DEFAULT NULL,
  `Collection_236_13` varchar(254) DEFAULT NULL,
  `Collection_236_14` varchar(254) DEFAULT NULL,
  `Collection_236_15` varchar(254) DEFAULT NULL,
  `Collection_236_16` varchar(254) DEFAULT NULL,
  `Collection_236_17` varchar(254) DEFAULT NULL,
  `Collection_236_18` int(11) DEFAULT NULL,
  `Collection_236_19` varchar(254) DEFAULT NULL,
  `Collection_236_20` varchar(254) DEFAULT NULL,
  `Collection_236_21` int(11) DEFAULT NULL,
  `Collection_236_22` text,
  PRIMARY KEY (`Collection_236_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_236`
--

INSERT INTO `Collection_236` VALUES (58,'Training',1331697600,1335931140,'<p>Training</p>\r\n',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'on','22f2f2',2,NULL),(59,'Demo',1387389600,1387828740,'<p>Demo for Town and Country</p>\r\n','','',6,1,1,0,'','','','','','','',1,'on','22f2f2',2,'Lorem Ipsum Dolor Imet');

--
-- Table structure for table `Collection_237`
--

CREATE TABLE `Collection_237` (
  `Collection_237_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_237_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_237_2` varchar(254) DEFAULT NULL,
  `Collection_237_3` varchar(254) DEFAULT NULL,
  `Collection_237_4` int(11) DEFAULT NULL,
  `Collection_237_5` varchar(254) DEFAULT NULL,
  `Collection_237_6` varchar(254) DEFAULT NULL,
  `Collection_237_7` varchar(254) DEFAULT NULL,
  `Collection_237_8` varchar(254) DEFAULT NULL,
  `Collection_237_9` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_237_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_237`
--

INSERT INTO `Collection_237` VALUES (1,'My Place','address','city',3,'12345','04040122435','Place Owner','owner@email.com','/images/contentimages/image_20_4_24.jpg'),(6,'Oxiem',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `Collection_238`
--

CREATE TABLE `Collection_238` (
  `Collection_238_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_238_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_238_2` text,
  `Collection_238_3` varchar(254) DEFAULT NULL,
  `Collection_238_4` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_238_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_238`
--

INSERT INTO `Collection_238` VALUES (1,'Skill Development',NULL,'2003ff',NULL),(2,'Curiculum Development',NULL,'22f2f2','on');

--
-- Table structure for table `Collection_239`
--

CREATE TABLE `Collection_239` (
  `Collection_239_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_239_1` int(11) DEFAULT NULL,
  `Collection_239_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_239_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_239`
--

INSERT INTO `Collection_239` VALUES (38,22,1),(39,22,2),(45,21,2),(42,24,2);

--
-- Table structure for table `Collection_24`
--

CREATE TABLE `Collection_24` (
  `Collection_24_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_24_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_24_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_24`
--

INSERT INTO `Collection_24` VALUES (1,'User Documents'),(3,'User Manuals'),(15,'chris documents');

--
-- Table structure for table `Collection_240`
--

CREATE TABLE `Collection_240` (
  `Collection_240_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_240_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_240_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_240`
--

INSERT INTO `Collection_240` VALUES (1,'Does Not Repeat'),(2,'Daily'),(3,'Weekly'),(4,'Monthly'),(5,'Yearly');

--
-- Table structure for table `Collection_241`
--

CREATE TABLE `Collection_241` (
  `Collection_241_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_241_4` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_241_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_241`
--

INSERT INTO `Collection_241` VALUES (1,'Day Of Month'),(2,'Day of the Week');

--
-- Table structure for table `Collection_25`
--

CREATE TABLE `Collection_25` (
  `Collection_25_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_25_1` varchar(254) DEFAULT NULL,
  `Collection_25_2` int(11) DEFAULT NULL,
  `Collection_25_3` text,
  PRIMARY KEY (`Collection_25_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_25`
--

INSERT INTO `Collection_25` VALUES (7,'returnLookupIdAndValue',1,'$lookupKey = $WorkFlowReturnArray[\'InsertedID\'];\r\n$lookupCollection  = $this -> getCollection($CollectionID);\r\n\r\n$lookupColumn = $lookupCollection[0][\'LookupColumn\'];\r\n$lookupColumnName = $this->_getCollectionFieldName($CollectionID, $lookupColumn);\r\n\r\n$lookupValue = $SubmittedData[$lookupColumnName];\r\n\r\n$variableToEcho = \'<script type=\"text/javascript\">\';\r\n\r\n$variableToEcho .= \'var oo = window.parent.document.getElementById(\"\'.$ExtraGetParams[\'fieldname\'].\'\");\';\r\n$variableToEcho .= \'var objOption=window.parent.document.createElement(\"option\");\';\r\n$variableToEcho .= \'objOption.innerHTML = \"\'.$lookupValue.\'\";\';			\r\n$variableToEcho .= \'objOption.value = \"\'.$lookupKey.\'\";\';\r\n$variableToEcho .= \'oo.appendChild(objOption);\';		\r\n$variableToEcho .= \'objOption.selected = \"true\";\';\r\n$variableToEcho .= \'window.parent.$(\"#\'.$ExtraGetParams[\'dname\'].$ExtraGetParams[\'fieldname\'].\'\").dialog( \"close\" );\';\r\n$variableToEcho .= \'</script>\';\r\n\r\necho $variableToEcho;\r\ndie(\'\');');

--
-- Table structure for table `Collection_26`
--

CREATE TABLE `Collection_26` (
  `Collection_26_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_26_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_26_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_26`
--

INSERT INTO `Collection_26` VALUES (29,'October Newsletter 2007');

--
-- Table structure for table `Collection_273`
--

CREATE TABLE `Collection_273` (
  `Collection_273_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_273_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_273_2` varchar(254) DEFAULT NULL,
  `Collection_273_3` text,
  `Collection_273_4` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_273_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_273`
--

INSERT INTO `Collection_273` VALUES (1,'Press Releases','',NULL,1);

--
-- Table structure for table `Collection_274`
--

CREATE TABLE `Collection_274` (
  `Collection_274_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_274_1` bigint(20) DEFAULT NULL,
  `Collection_274_2` bigint(20) DEFAULT NULL,
  `Collection_274_3` varchar(254) NOT NULL DEFAULT '',
  `Collection_274_4` varchar(254) DEFAULT NULL,
  `Collection_274_5` text,
  `Collection_274_6` text,
  `Collection_274_7` varchar(254) DEFAULT NULL,
  `Collection_274_8` varchar(254) DEFAULT NULL,
  `Collection_274_9` varchar(254) DEFAULT NULL,
  `Collection_274_10` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_274_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_274`
--

INSERT INTO `Collection_274` VALUES (8,1217368800,1471410000,'Experience Something Fresh!!!!!!!!!!','Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer luctus dictum sem. Nunc porta lectus.','Lorem ipsum dolor sit amet, consectetuer adipiscing elit.\r\nInteger luctus dictum sem. Nunc porta lectus.','<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer luctus dictum sem. Nunc porta lectus..</p>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer luctus dictum sem. Nunc porta lectus..</p>\r\n<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Integer luctus dictum sem. Nunc porta lectus..</p>\r\n','/images/newsdefault.gif','/images/newsdefault.gif','',''),(9,1376024400,1408510800,'Proin Enim Turpis, Molestie At','Aliquam odio lorem, molestie eget, venenatis ac, ultrices vel, dolor. Ut iaculis.','Aliquam odio lorem, molestie eget, venenatis ac, ultrices vel, dolor. Ut iaculis. Suspendisse quam nunc, accumsan vel, fermentum arcu.','<p>Aliquam odio lorem, molestie eget, venenatis ac, ultrices vel, dolor.</p>\r\n<p>Ut iaculis. Suspendisse quam nunc, accumsan vel, fermentum arcu.</p>\r\n','/images/newsdefault.gif','/images/newsdefault.gif','',''),(13,1267552860,1267725660,'News That Needs Approval',NULL,NULL,'<p>fdsfds!</p>\r\n<p>f</p>\r\n<p>d</p>\r\n<p>sfsf</p>\r\n',NULL,NULL,NULL,NULL),(16,1334758500,1334844900,'Demo of CMS',NULL,'Town & Country',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `Collection_275`
--

CREATE TABLE `Collection_275` (
  `Collection_275_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_275_1` int(11) DEFAULT NULL,
  `Collection_275_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_275_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_275`
--

INSERT INTO `Collection_275` VALUES (105,8,1),(106,9,1),(98,13,1),(102,16,2);

--
-- Table structure for table `Collection_276`
--

CREATE TABLE `Collection_276` (
  `Collection_276_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_276_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_276_2` varchar(254) DEFAULT NULL,
  `Collection_276_3` bigint(20) DEFAULT NULL,
  `Collection_276_4` varchar(254) DEFAULT NULL,
  `Collection_276_5` varchar(254) DEFAULT NULL,
  `Collection_276_6` varchar(254) DEFAULT NULL,
  `Collection_276_7` int(11) DEFAULT NULL,
  `Collection_276_8` varchar(254) DEFAULT NULL,
  `Collection_276_9` text,
  `Collection_276_10` varchar(254) DEFAULT NULL,
  `Collection_276_11` text,
  PRIMARY KEY (`Collection_276_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_276`
--

INSERT INTO `Collection_276` VALUES (1,'Home','/',1,'on',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Events','/events/',2,'on','','',NULL,'',NULL,'',NULL),(3,'News','/news/',3,'on','','',NULL,'',NULL,'/images/minset.jpg',NULL),(4,'Photo Gallery','/photo-gallery.html',4,'on',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Contents','/landingpage.html',5,'on','','',NULL,'',NULL,'/images/minset.jpg','/contact-us.html'),(15,'Photo Galleries List',NULL,1,NULL,NULL,NULL,4,'on','{{getCollectionByCategory CollectionID=80 ColumnID=3 Value=\'on\' OrderColumn=2 var=AllGalleries}}\r\n{{foreach from=$AllGalleries item=gv key=gk name=n}}\r\n	<li><a class=\"level2{{if $gv.Collection_80_ID eq $smarty.get.gallery}} selected{{/if}}\" href=\"/photo-gallery/{{$gv.Collection_80_ID}}.html\">{{$gv.Collection_80_1}}</a></li>\r\n{{/foreach}}',NULL,NULL),(7,'Content','/contentpage.html',NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL),(8,'About Us','/about.html',2,'on','','',NULL,'',NULL,'',NULL),(9,'Contact Us','/contact-us.html',3,NULL,NULL,NULL,7,NULL,NULL,NULL,NULL),(10,'Contact Us Thank You','/contact-us-thank-you.html',3,NULL,'on',NULL,7,NULL,NULL,NULL,NULL),(33,'Pricing','/pricing.html',1,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL),(16,'News Categories List','',1,'','','',3,'on','{{getCollectionByCategory CollectionID=273 OrderColumn=4 var=CResults}} \r\n{{foreach from=$CResults item=gv key=gk name=catleft}}\r\n<li><a href=\"/news/{{$gv.Collection_273_ID}}/\" class=\"level2{{if $smarty.foreach.catleft.index eq 0}} first{{/if}}{{if $gv.Collection_273_ID eq $smarty.get.category and $smarty.get.archives eq 0}} selected{{/if}}\">{{$gv.Collection_273_1}}</a></li>			\r\n{{/foreach}}','',NULL),(17,'News Archives','/news/archives/',2,NULL,NULL,NULL,3,NULL,NULL,NULL,NULL),(18,'News Archives Categories List',NULL,1,NULL,NULL,NULL,17,'on','{{getCollectionByCategory CollectionID=273 OrderColumn=4 var=CResults}} \r\n{{foreach from=$CResults item=gv key=gk name=catleft}}\r\n<li><a href=\"/news/archives/{{$gv.Collection_273_ID}}/\" class=\"level3{{if $gv.Collection_273_ID eq $smarty.get.category and $smarty.get.archives eq 1}} selected{{/if}}\">{{$gv.Collection_273_1}}</a></li>			\r\n{{/foreach}}',NULL,NULL),(19,'Calendar Views','',1,'','','',2,'on','{{assign var=GettedValues value=$smarty.get}}\r\n{{assign var=FilterGet value=\'\'}}\r\n{{assign var=FilterGet2 value=\'\'}}\r\n{{if $GettedValues|@count gt 0}}\r\n\r\n{{if $GettedValues.year neq \'\'}}\r\n	{{assign var=FilterGet2 value=$FilterGet2|concat:\'y-\'|concat:$GettedValues.year|concat:\'/\'}}\r\n{{/if}}\r\n\r\n{{if $GettedValues.month neq \'\'}}\r\n	{{assign var=FilterGet2 value=$FilterGet2|concat:\'m-\'|concat:$GettedValues.month|concat:\'/\'}}\r\n{{/if}}\r\n\r\n\r\n\r\n{{createOptions CollectionID=238 Column=1 var=EventTypes}}\r\n{{foreach from=$EventTypes item=v key=k name=n}}\r\n				{{assign var=val value=\'type\'|concat:$k}}\r\n				{{if $GettedValues.$val eq \'on\'}}{{assign var=FilterGet value=$FilterGet|concat:\'&type\'|concat:$k|concat:\'=on\'}}{{/if}}\r\n{{/foreach}}\r\n\r\n{{if $FilterGet neq \'\'}}{{assign var=FilterGet value=\'?filter=1\'|concat:$FilterGet}}{{/if}}\r\n\r\n{{/if}}\r\n\r\n	<li><a  href=\"/events/{{$FilterGet2}}{{$FilterGet}}\" class=\"level2 first{{assign var=tmp value=$smarty.server.REQUEST_URI|explode:\'/events/\'}}{{if $tmp|@count gt 1}} selected{{/if}}\">Monthly View</a></li>\r\n	<li><a href=\"/events-weekly/{{$FilterGet2}}{{$FilterGet}}\" {{assign var=tmp value=$smarty.server.REQUEST_URI|explode:\'/events-weekly/\'}}{{if $tmp|@count gt 1}}class=\"selected\"{{/if}}>Weekly View</a></li>\r\n	<li><a href=\"/events-daily/{{$FilterGet2}}{{$FilterGet}}\" {{assign var=tmp value=$smarty.server.REQUEST_URI|explode:\'/events-daily/\'}}{{if $tmp|@count gt 1}}class=\"selected\"{{/if}}>Daily View</a></li>','',NULL),(20,'Videos','/videos.html',6,'on',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'Videos List',NULL,1,NULL,NULL,NULL,20,'on','{{getCollectionByCategory CollectionID=50 ColumnID=7 Value=\'on\' OrderColumn=6 OrderWay=1 var=AllVideos}}\r\n{{if $AllVideos|@count gt 0}}\r\n		{{foreach from=$AllVideos item=v key=k}}\r\n		<li><a href=\"/videos/{{$v.Collection_50_ID}}.html\" class=\"level2{{if $v.Collection_50_ID eq $smarty.get.video}} selected{{/if}}\">{{$v.Collection_50_1}}</a></li>\r\n		{{/foreach}}\r\n{{/if}}',NULL,NULL),(34,'roi-calculator','/roi-calculator.html',2,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL);

--
-- Table structure for table `Collection_3`
--

CREATE TABLE `Collection_3` (
  `Collection_3_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_3_1` int(11) DEFAULT NULL,
  `Collection_3_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_3_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=157 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_3`
--

INSERT INTO `Collection_3` VALUES (149,22,2),(146,1,2),(148,30,1),(147,30,2),(142,2,1),(141,2,2),(130,37,3),(131,-1,3),(132,38,3),(133,39,3);

--
-- Table structure for table `Collection_30`
--

CREATE TABLE `Collection_30` (
  `Collection_30_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_30_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_30_2` varchar(254) DEFAULT NULL,
  `Collection_30_3` varchar(254) DEFAULT NULL,
  `Collection_30_4` varchar(254) DEFAULT NULL,
  `Collection_30_5` text,
  `Collection_30_6` int(11) DEFAULT NULL,
  `Collection_30_7` varchar(254) DEFAULT NULL,
  `Collection_30_8` varchar(254) DEFAULT NULL,
  `Collection_30_9` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_30_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_30`
--

INSERT INTO `Collection_30` VALUES (1,'Unique User Names','on',NULL,NULL,'$UserName 		= $SubmittedData[\'Collection_1_1\'];\r\n		\r\n	$res = $this -> getRowByColValue($CollectionID , 1 , $UserName);\r\n	if (count($res) > 0)\r\n	{\r\n		$ruleErrors[] = \"Username \".$UserName.\" is already taken\" ;\r\n	}',1,'on','on',NULL),(2,'Unique Email Address','on',NULL,NULL,'$UserName 		= $SubmittedData[\'Collection_1_5\'];\r\n		\r\n	$res = $this -> getRowByColValue($CollectionID , 5 , $UserName);\r\n	if (count($res) > 0)\r\n	{\r\n		$ruleErrors[] = \"Email address \".$UserName.\" is already taken\" ;\r\n	}',1,'on','on',NULL),(3,'Unique User Names for Edit',NULL,'on',NULL,'    $res = $this -> getRowById($CollectionID , $EditID);\r\n	$UserName 		= $SubmittedData[\'Collection_1_1\'];\r\n	$OldUserName = $res[\'Collection_1_1\'];\r\n		\r\n	$res = $this -> getRowsByColValue($CollectionID , 1 , $UserName);\r\n	\r\n	if ($UserName == $OldUserName)\r\n	{\r\n		//do nothing\r\n	}\r\n	else\r\n	{\r\n		if (count($res) > 0)\r\n		{\r\n			$ruleErrors[] = \"Username \".$UserName.\" is already taken\" ;\r\n		}	\r\n	}',1,'on','on',NULL),(4,'Unique Email Address for Edit',NULL,'on',NULL,'    $res = $this -> getRowById($CollectionID , $EditID);\r\n	$UserName 		= $SubmittedData[\'Collection_1_5\'];\r\n	$OldUserName 	= $res[\'Collection_1_5\'];\r\n		\r\n	$res = $this -> getRowsByColValue($CollectionID , 5 , $UserName);\r\n	\r\n	if ($UserName == $OldUserName)\r\n	{\r\n		//do nothing\r\n	}\r\n	else\r\n	{\r\n		if (count($res) > 0)\r\n		{\r\n			$ruleErrors[] = \"Email address \".$UserName.\" is already taken\" ;\r\n		}	\r\n	}',1,'on','on',NULL),(8,'Do not delete Company Information Row',NULL,NULL,'on','$ruleErrors[] = \"Company Information can\'t be deleted. Please edit the existing row.\" ;',12,'on','on',1),(9,'Do not add Company Information Row','on',NULL,NULL,'$ruleErrors[] = \"Company Information can\'t be added. Please edit the existing row.\" ;',12,'on','on',1),(10,'Test S3 Settings Before Saving','on','on',NULL,'\r\ndefine(\'S3_Development_Key\', $SubmittedData[\'Collection_389_2\'] );\r\ndefine(\'S3_Development_Secret\', $SubmittedData[\'Collection_389_3\']);\r\nrequire_once $_SERVER[\'DOCUMENT_ROOT\'].\'/classes/StorageS3Amazon/sdk.class.php\';\r\n\r\n$BucketName = $SubmittedData[\'Collection_389_4\'];\r\n\r\ntry {\r\n						\r\n						$s3 = new AmazonS3();\r\n						\r\n						$response = $s3->get_bucket_list();\r\n						\r\n						if (count($response) == 0)\r\n						{\r\n								$ruleErrors[] = \'There was an error connecting to S3, bucket name \' . addslashes($BucketName) . \'. Please check the keys and bucket name.\';\r\n						}\r\n						else\r\n						{\r\n							$foundBucket = 0;\r\n							foreach ($response as $k => $v)\r\n							{\r\n										if (strtolower($v) == strtolower($BucketName))\r\n										{\r\n												$foundBucket = 1;\r\n										}\r\n							}\r\n							\r\n							if ($foundBucket == 0)\r\n							{\r\n									//we try to create the bucket\r\n									//check if exists first\r\n									try {\r\n											\r\n											$response = $s3->if_bucket_exists($BucketName);\r\n																						\r\n											if (!$response)\r\n											{\r\n													//we try to create the bucket\r\n													$response = $s3->create_bucket($BucketName, AmazonS3::REGION_US_E1);\r\n													if (!$response->isOK())\r\n													{\r\n															$ruleErrors[] = \'There was an error connecting to S3. Failed creating bucket \' . addslashes($BucketName) . \'. \';\r\n													}\r\n											}\r\n											\r\n											\r\n									}\r\n									catch(Exception $ex) {\r\n											\r\n											$ruleErrors[] = \'There was an error connecting to S3. The bucket name \' . addslashes($BucketName) . \' is not a valid bucket name. \';\r\n									}				\r\n									\r\n									\r\n							}\r\n							\r\n						}\r\n						\r\n												\r\n}						\r\ncatch(Exception $ex) {\r\n				\r\n						$ruleErrors[] = \'There was an error connecting to S3, bucket name \' . addslashes($BucketName) . \'. Please check the keys and bucket name.\';\r\n}			',389,'on',NULL,1),(11,'Test S3 Settings Before Delete Bucket',NULL,NULL,'on','\r\n$S3SubmittedData = $this -> getRowById(389, $DeleteID);\r\n\r\ndefine(\'S3_Development_Key\', $S3SubmittedData[\'Collection_389_2\'] );\r\ndefine(\'S3_Development_Secret\', $S3SubmittedData[\'Collection_389_3\']);\r\nrequire_once $_SERVER[\'DOCUMENT_ROOT\'].\'/classes/StorageS3Amazon/sdk.class.php\';\r\n\r\n$BucketName = $S3SubmittedData[\'Collection_389_4\'];\r\n\r\ntry {\r\n						\r\n						$s3 = new AmazonS3();\r\n						\r\n						$response = $s3->get_bucket_list();\r\n						\r\n						\r\n						$response = $s3->delete_bucket($BucketName);\r\n						\r\n																	\r\n						if (!$response->isOK())\r\n						{\r\n										$ruleErrors[] = \'There was an error connecting to S3. Failed deleting bucket \' . addslashes($BucketName) . \'. The bucket might not be empty. If you belive it is empty, please try again. \';\r\n						}\r\n											\r\n						\r\n												\r\n}						\r\ncatch(Exception $ex) {\r\n				\r\n						$ruleErrors[] = \'There was an error deleting S3, bucket name \' . addslashes($BucketName) . \'. Please check the keys and bucket name.\';\r\n}			',389,'on',NULL,1),(12,'Delete File From Remote Storage',NULL,NULL,'on','//this rule should be executed last , right before we are going to delete the\r\n//row from the collection\r\n\r\nif (count($errors) == 0 && count($ruleErrors) == 0)\r\n{\r\n\r\ninclude_once $_SERVER[\'DOCUMENT_ROOT\'].\'/classes/class.storage.php\';\r\n$storage = new StorageAPI($this);\r\n\r\n$storage->setUserID($UserID);\r\n$storage->setAdmin($SuperAdminUser);\r\n\r\n$storage->deleteFileById($DeleteID);\r\n\r\n\r\n}//end if delete file',381,'on',NULL,100);

--
-- Table structure for table `Collection_303`
--

CREATE TABLE `Collection_303` (
  `Collection_303_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_303_1` varchar(254) DEFAULT NULL,
  `Collection_303_2` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_303_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_303`
--

INSERT INTO `Collection_303` VALUES (1,'/calendar.html',1228383184),(2,'/calendar-weekly.html',1228383223),(3,'/calendar-daily.html',1228383234),(4,'/about-us.html',1228383253),(5,'/contact-us.html',1228383273);

--
-- Table structure for table `Collection_304`
--

CREATE TABLE `Collection_304` (
  `Collection_304_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_304_1` varchar(254) DEFAULT NULL,
  `Collection_304_2` int(11) DEFAULT NULL,
  `Collection_304_3` bigint(20) DEFAULT NULL,
  `Collection_304_4` text,
  `Collection_304_5` text,
  `Collection_304_6` varchar(254) DEFAULT NULL,
  `Collection_304_7` varchar(254) DEFAULT NULL,
  `Collection_304_8` varchar(254) DEFAULT NULL,
  `Collection_304_9` varchar(254) DEFAULT NULL,
  `Collection_304_10` varchar(254) DEFAULT NULL,
  `Collection_304_11` varchar(254) DEFAULT NULL,
  `Collection_304_12` varchar(254) DEFAULT NULL,
  `Collection_304_13` text,
  PRIMARY KEY (`Collection_304_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_304`
--

INSERT INTO `Collection_304` VALUES (10,'Slide 1',1,10,'Hollwich Kushner<br/>USES PURETI HERE.','<p><strong>Worldwide Leader</strong> in Sustainable Surface Treatments. Fusce leo orci, susct augue imperdiet set eid lacia. Eed sicropot aigie meced mo nuseide. Pureti susced augue impieo orci, susct augue imperdiet set eid.</p>','Learn More','/link1.html','More Info','/link2','/images/desktop/rot1.jpg','/images/tablet/slide1.jpg','/images/mobile/rot3.jpg','The subcopy right here'),(11,'Slide 2',1,20,'Car Headline<br/>Goes Right Here.','<p><strong>Worldwide Leader</strong> in Sustainable Surface Treatments. Fusce leo orci, susct augue imperdiet set eid lacia. Eed sicropot aigie meced mo nuseide. Pureti susced augue impieo orci, susct augue imperdiet set eid.</p>','Learn More','/link1.html','More Info','/link2','/images/desktop/rot2.jpg','/images/tablet/slide2.jpg','/images/mobile/rot2.jpg','The subcopy right here'),(12,'Slide 3',1,30,'SOLAR PANEL<br/>Goes Right Here.','<p><strong>Worldwide Leader</strong> in Sustainable Surface Treatments. Fusce leo orci, susct augue imperdiet set eid lacia. Eed sicropot aigie meced mo nuseide. Pureti susced augue impieo orci, susct augue imperdiet set eid.</p>','Learn More','/link3.html','More Info','/link4','/images/desktop/rot3.jpg','/images/tablet/slide3.jpg','/images/mobile/rot1.jpg','The subcopy right here');

--
-- Table structure for table `Collection_31`
--

CREATE TABLE `Collection_31` (
  `Collection_31_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_31_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_31_2` varchar(254) DEFAULT NULL,
  `Collection_31_3` varchar(254) DEFAULT NULL,
  `Collection_31_4` varchar(254) DEFAULT NULL,
  `Collection_31_5` text,
  `Collection_31_6` int(11) DEFAULT NULL,
  `Collection_31_7` varchar(254) DEFAULT NULL,
  `Collection_31_8` varchar(254) DEFAULT NULL,
  `Collection_31_9` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_31_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_31`
--

INSERT INTO `Collection_31` VALUES (1,'Add New User to Users Group','on',NULL,NULL,'$new_column_values = array( \'Collection_3_1\'=> $inserted_id  , \'Collection_3_2\'=> 3 );\r\n$this->insertCollectionRow_(3, $new_column_values , \'\' , \'\');',1,NULL,'on',1),(11,'User Group Access Delete',NULL,NULL,'on','$ugroupDelete = \"DELETE FROM collectionrowrolexref  WHERE UserGroupId= \'\".intval($DeleteID).\"\'\";\r\n$this->db->query($ugroupDelete);',2,'on',NULL,1),(3,'Add Event on front end Behaviour','on',NULL,NULL,'if ($_GET[\'dialog\'] == 1)\r\n{\r\nprint \'<script type=\"text/javascript\">\';\r\nprint \'			window.parent.window.parent.location=\"/events/$inserted_id.html\";\';\r\nprint \'			window.parent.close();\';\r\nprint \'			window.parent.window.parent.location= \"/events/\'.$inserted_id.\'.html\";\';\r\nprint \'</script>\';\r\ndie();\r\n}',236,'on',NULL,NULL),(4,'Delete Event on front end Behaviour',NULL,NULL,'on','if ($_GET[\'dialog\'] == 1)\r\n{\r\nprint \'<script type=\"text/javascript\">\';\r\nprint \'			window.parent.window.parent.location=\"/calendar.html\";\';\r\nprint \'			window.parent.close();\';\r\nprint \'			window.parent.window.parent.location= \"/calendar.html\";\';\r\nprint \'</script>\';\r\ndie();\r\n}',236,'on',NULL,NULL),(5,'Redirect after adding an Article','on',NULL,NULL,'header(\'Location: /blog-article.html?article=\'. $inserted_id); die();',61,NULL,NULL,NULL),(6,'Redirect after Editing Article',NULL,'on',NULL,'header(\'Location: /blog-article.html?article=\'. $_GET[\'article\']);',61,NULL,NULL,NULL),(7,'Redirect After Editing Comment',NULL,'on',NULL,'header(\'Location: /blog-article.html?article=\'. $_GET[\'article\']);',62,NULL,NULL,NULL),(8,'Redirect to Display New Comment','on',NULL,NULL,'header(\'Location: /blog-article.html?article=\'. $_GET[\'article\']);',62,NULL,NULL,NULL),(9,'Redirect After Editing File Name',NULL,'on',NULL,'global $UseAsFCKDialog;\r\nif (1 != $UseAsFCKDialog)\r\n{\r\n	return;\r\n}\r\n\r\n$output =\r\n<<< OUTPUT\r\n<script type=\"text/javascript\">\r\n window.parent.window.parent.location = \"/{$_POST [\'Collection_17_3\']}.html\";\r\n</script>\r\nOUTPUT;\r\n\r\necho $output;\r\nexit ();',17,'on',NULL,NULL),(10,'Make sure years and ID on credit card form are matching','on','on',NULL,'$q= \"UPDATE Collection_143 SET Collection_143_ID = Collection_143_1\";\r\n	$this->db->query($q);',143,'on','on',1),(12,'Dropbox Storage Access Tokens','on','on',NULL,'if ($ApplyFor == COLLECTION_WORKFLOW_APPLY_IN_ADMIN_ADD )\r\n{\r\n	$DropboxID = $WorkFlowReturnArray[\'InsertedID\'];\r\n}\r\nelse\r\n{\r\n	$DropboxID = $WorkFlowReturnArray[\'EditedID\'];\r\n}	\r\n\r\n$DropboxInfo = $this->getRowById($CollectionID , $DropboxID);\r\n\r\ninclude_once $_SERVER[\'DOCUMENT_ROOT\'].\'/classes/StorageDropbox/src/Dropbox/autoload.php\';\r\n\r\n$oauth = new Dropbox_OAuth_PEAR($DropboxInfo[\'Collection_390_3\'],$DropboxInfo[\'Collection_390_4\']);\r\n\r\n$dropbox = new Dropbox_API($oauth);\r\n\r\ntry {\r\n\r\n$tokens = $oauth->getRequestToken();\r\n$_SESSION[\'oauth_tokens\'] = $tokens;\r\n\r\n}\r\ncatch(Exception $ex) {\r\n	if ($ApplyFor == COLLECTION_WORKFLOW_APPLY_IN_ADMIN_ADD )\r\n	{\r\n		$DURL = $_SERVER[\'REQUEST_URI\'] . \'&eid=\'.$DropboxID;\r\n	}\r\n	else\r\n	{\r\n		$DURL = $_SERVER[\'REQUEST_URI\'];\r\n	}	\r\n	die(\'The dropbox settings do not seem to be good. Please <a href=\"\'.$DURL.\'\">check them and try again</a>. \');\r\n}\r\n\r\nheader (\'Location: \'.$oauth->getAuthorizeUrl(urlencode(\'http://\'.$_SERVER[\'HTTP_HOST\'].\'/\'.ADMIN_APP_DIR.\'/admin.php?module_id=11&menu_id=7&collectionid=90&colid=2&dboxid=\'.$DropboxID)));\r\ndie();',390,'on',NULL,1),(13,'Clear Menu Cache Upon Editing Adding Deleting a site menu item','on','on','on','$smarty->clear_cache(null,\'menu-top\');\r\n$smarty->clear_cache(null,\'menu\');',276,'on','',1),(14,'Cache -  Clear Notables','on','on','on','$smarty->clear_cache(null,\'menu-notable\');',414,'on','',1),(15,'Cache - Clear Content','on','on','on','$CacheRowID = 0;\r\n\r\nif (isset($WorkFlowReturnArray[\'EditedID\']))\r\n{\r\n		$CacheRowID = intval($WorkFlowReturnArray[\'EditedID\']);\r\n}\r\n\r\nif (isset($WorkFlowReturnArray[\'InsertedID\']) && $CacheRowID == 0)\r\n{\r\n		$CacheRowID = intval($WorkFlowReturnArray[\'InsertedID\']);\r\n}\r\n\r\nif (isset($DeleteID) && $CacheRowID == 0)\r\n{\r\n		$CacheRowID = intval($DeleteID);\r\n}\r\n\r\nif ($CacheRowID > 0)\r\n{\r\n		global $PearCachingOptions;\r\n\r\n		require_once(BASE_DIR.\'/classes/CacheLite/Cache/Lite/Output.php\');\r\n\r\n		$cache = new Cache_Lite($PearCachingOptions);\r\n\r\n		//we will try to remove the simple id\r\n		$cache->remove($CacheRowID, \'block\');\r\n\r\n		//we will try to remove the group\r\n		$cache->clean(\'pageblock\'.$CacheRowID);\r\n\r\n		\r\n\r\n}\r\n//we also need to refresh all header images.\r\n$smarty->clear_cache(null,\'menu-css\');\r\n$smarty->clear_cache(null,\'adlets\');\r\n$smarty->clear_cache(null,\'benefits\');\r\n',13,'on','',1),(16,'Cache - Clear Company Info','on','on','on','global $PearCachingOptions;\r\n\r\n		require_once(BASE_DIR.\'/classes/CacheLite/Cache/Lite/Output.php\');\r\n\r\n		$cache = new Cache_Lite($PearCachingOptions);\r\n\r\n		if ($data = $cache->get(\'companyinformation\')) \r\n		{\r\n			$cache->remove(\'companyinformation\');\r\n\r\n		}\r\n		',12,'on','',1),(17,'Cache - Clear Adlets','on','on','on','$smarty->clear_cache(null,\'adlets\');',408,'on','',1),(18,'Cache - Clear Benefits','on','on','on','$smarty->clear_cache(null,\'benefits\');\r\n$smarty->clear_cache(null,\'menu-home-benefits\');\r\n',412,'on','',1),(19,'Cache -  Clear Rotators','on','on','on','$smarty->clear_cache(null,\'menu-rotator\');\r\n$smarty->clear_cache(null,\'menu-css\');',304,'on','',1),(20,'Cache - Clear Quotes','on','on','on','$smarty->clear_cache(null,\'menu-rotator\');',410,'on','',10);

--
-- Table structure for table `Collection_32`
--

CREATE TABLE `Collection_32` (
  `Collection_32_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_32_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_32_2` varchar(254) NOT NULL DEFAULT '',
  `Collection_32_3` varchar(254) DEFAULT NULL,
  `Collection_32_4` text,
  `Collection_32_5` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_32_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_32`
--


--
-- Table structure for table `Collection_324`
--

CREATE TABLE `Collection_324` (
  `Collection_324_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_324_1` varchar(254) DEFAULT NULL,
  `Collection_324_2` varchar(254) DEFAULT NULL,
  `Collection_324_3` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_324_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_324`
--

INSERT INTO `Collection_324` VALUES (1,'Twitter','http://twitter.com/statuses/user_timeline/87007988.rss',2),(2,'Blog','http://blog.oxiem.com/feed/',3);

--
-- Table structure for table `Collection_327`
--

CREATE TABLE `Collection_327` (
  `Collection_327_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_327_1` varchar(254) NOT NULL,
  `Collection_327_2` varchar(254) NOT NULL,
  PRIMARY KEY (`Collection_327_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_327`
--


--
-- Table structure for table `Collection_339`
--

CREATE TABLE `Collection_339` (
  `Collection_339_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_339_1` varchar(254) DEFAULT NULL,
  `Collection_339_2` int(11) DEFAULT NULL,
  `Collection_339_3` varchar(254) DEFAULT NULL,
  `Collection_339_4` varchar(254) DEFAULT NULL,
  `Collection_339_5` bigint(20) DEFAULT NULL,
  `Collection_339_6` bigint(20) DEFAULT NULL,
  `Collection_339_7` bigint(20) DEFAULT NULL,
  `Collection_339_8` bigint(20) DEFAULT NULL,
  `Collection_339_9` varchar(254) DEFAULT NULL,
  `Collection_339_10` varchar(254) DEFAULT NULL,
  `Collection_339_11` text,
  `Collection_339_12` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_339_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_339`
--

INSERT INTO `Collection_339` VALUES (1,'News Feed',274,'Our News','News from Oxiem',3,5,1,5,'on','/news/item-{{$RowID}}.html',NULL,1);

--
-- Table structure for table `Collection_341`
--

CREATE TABLE `Collection_341` (
  `Collection_341_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_341_1` varchar(254) DEFAULT NULL,
  `Collection_341_2` bigint(20) DEFAULT NULL,
  `Collection_341_3` varchar(254) DEFAULT NULL,
  `Collection_341_4` text,
  `Collection_341_5` text,
  `Collection_341_6` text,
  `Collection_341_7` text,
  PRIMARY KEY (`Collection_341_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_341`
--

INSERT INTO `Collection_341` VALUES (1,'25% Discount on more than 24 products',1,'on','//we search for this particular product in the shopping cart\r\n					$q = \"SELECT * FROM Collection_134 WHERE Collection_134_1=\'\".$cartID.\"\' AND Collection_134_2=\'\".$productID.\"\' AND Collection_134_4=\'\".$priceID.\"\' AND Collection_134_5 > 0\";\r\n					$res = $db->query($q);\r\n					$productDetails = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n					\r\n					if ($productDetails[\'Collection_134_3\'] >= 25)\r\n					{\r\n							//we need to change the price with discount to be -25% off\r\n							$addToCartData 	= array();\r\n							$addToCartData[\'Collection_134_10\'] = ceil(75 * $productDetails[\'Collection_134_5\'] / 100) ;	\r\n							$addToCartData[\'Collection_134_11\'] = \"25% off, for 25 or more products purchased \";\r\n							$db->extended->autoExecute(\'Collection_134\', $addToCartData , MDB2_AUTOQUERY_UPDATE, \' Collection_134_ID = \' . $productDetails[\'Collection_134_ID\']);\r\n					}\r\n					else\r\n					{\r\n							$addToCartData 	= array();\r\n							$addToCartData[\'Collection_134_10\'] = $productDetails[\'Collection_134_5\'] ;	\r\n							$addToCartData[\'Collection_134_11\'] = \"\";\r\n							$db->extended->autoExecute(\'Collection_134\', $addToCartData , MDB2_AUTOQUERY_UPDATE, \' Collection_134_ID = \' . $productDetails[\'Collection_134_ID\']);\r\n					}\r\n					\r\n					','//we search for this particular product in the shopping cart\r\n					$q = \"SELECT * FROM Collection_134 WHERE Collection_134_1=\'\".$cartID.\"\' AND Collection_134_2=\'\".$productID.\"\' AND Collection_134_4=\'\".$priceID.\"\' AND Collection_134_5 > 0\";\r\n					$res = $db->query($q);\r\n					$productDetails = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n					\r\n					if ($productDetails[\'Collection_134_3\'] >= 25)\r\n					{\r\n							//we need to change the price with discount to be -25% off\r\n							$addToCartData 	= array();\r\n							$addToCartData[\'Collection_134_10\'] = ceil(75 * $productDetails[\'Collection_134_5\'] / 100) ;	\r\n							$addToCartData[\'Collection_134_11\'] = \"25% off, for 25 or more products purchased \";\r\n							$db->extended->autoExecute(\'Collection_134\', $addToCartData , MDB2_AUTOQUERY_UPDATE, \' Collection_134_ID = \' . $productDetails[\'Collection_134_ID\']);\r\n					}\r\n					else\r\n					{\r\n							$addToCartData 	= array();\r\n							$addToCartData[\'Collection_134_10\'] = $productDetails[\'Collection_134_5\'] ;	\r\n							$addToCartData[\'Collection_134_11\'] = \"\";\r\n							$db->extended->autoExecute(\'Collection_134\', $addToCartData , MDB2_AUTOQUERY_UPDATE, \' Collection_134_ID = \' . $productDetails[\'Collection_134_ID\']);\r\n					}\r\n					\r\n					',NULL,'<p>If you purchase 25 or more products, you will receive a 25% discount. <a href=\"javascript://\" id=\"buy25productsnow\">Buy 25 products now</a>.</p>\r\n{{capture name=aaaa assign=jq}}\r\n	$(\'#buy25productsnow\').click(function(){\r\n	$(\'.itemquantityfield\').val(\'25\');\r\n	$(\'#addtocartlink\').click();\r\n	});\r\n{{/capture}}\r\n{{assign var=JavaScriptJQueryCode value=$JavaScriptJQueryCode|concat:\" \"|concat:$jq}}'),(2,'For every 25 items purchased a free product is added to the cart',2,'on','//we search for this particular product in the shopping cart\r\n					$q = \"SELECT * FROM Collection_134 WHERE Collection_134_1=\'\".$cartID.\"\' AND Collection_134_2=\'\".$productID.\"\' AND Collection_134_4=\'\".$priceID.\"\' AND Collection_134_5 > 0\";\r\n					$res = $db->query($q);\r\n					$productDetails = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n					\r\n					if ($productDetails[\'Collection_134_3\'] >= 25)\r\n					{\r\n							// first we check if there is a free product of this type already added\r\n							$q = \"SELECT * FROM Collection_134 WHERE Collection_134_1=\'\".$cartID.\"\' AND Collection_134_13 = \" . $productDetails[\'Collection_134_ID\'];\r\n							$res = $db->query($q);\r\n							\r\n							$freeQuantity = floor($productDetails[\'Collection_134_3\'] / 25);\r\n							\r\n							if ($res ->numRows() == 0)\r\n							{\r\n												$addToCartData = array();\r\n												$addToCartData[\'Collection_134_1\'] = $cartID;\r\n												$addToCartData[\'Collection_134_2\'] = $productID;\r\n												$addToCartData[\'Collection_134_3\'] = $freeQuantity;\r\n												$addToCartData[\'Collection_134_4\'] = $priceID;\r\n												$addToCartData[\'Collection_134_5\'] = 0;\r\n												$addToCartData[\'Collection_134_6\'] = \"Free Product\";\r\n												$addToCartData[\'Collection_134_7\'] = $productDetails[\'Collection_134_7\'];\r\n												$addToCartData[\'Collection_134_8\'] = NULL;\r\n												$addToCartData[\'Collection_134_9\'] = $productDetails[\'Collection_134_9\'];\r\n												$addToCartData[\'Collection_134_10\'] = 0;\r\n												$addToCartData[\'Collection_134_11\'] = \'Free Product for more than 25 products purchased\';\r\n												$addToCartData[\'Collection_134_12\'] = $productDetails[\'Collection_134_12\'];\r\n												$addToCartData[\'Collection_134_13\'] = $productDetails[\'Collection_134_ID\'];\r\n												\r\n												$id = $db->extended->getBeforeID(\'Collection_134\');\r\n												$result = $db->extended->autoExecute(\'Collection_134\', $addToCartData, MDB2_AUTOQUERY_INSERT);\r\n												$id = $db->extended->getAfterID($id, \'Collection_134\');\r\n							\r\n							}\r\n							else\r\n							{\r\n											$addToCartData = array();\r\n											$addToCartData[\'Collection_134_3\'] = $freeQuantity;\r\n											$row = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n											\r\n											$db->extended->autoExecute(\'Collection_134\', $addToCartData , MDB2_AUTOQUERY_UPDATE, \' Collection_134_ID = \' . $row[\'Collection_134_ID\']);\r\n											\r\n											\r\n							}//if there is free product\r\n							\r\n							\r\n							\r\n					}\r\n					\r\n					\r\n					','//we search for this particular product in the shopping cart\r\n					$q = \"SELECT * FROM Collection_134 WHERE Collection_134_1=\'\".$cartID.\"\' AND Collection_134_2=\'\".$productID.\"\' AND Collection_134_4=\'\".$priceID.\"\' AND Collection_134_5 > 0\";\r\n					$res = $db->query($q);\r\n					$productDetails = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n					\r\n					if ($productDetails[\'Collection_134_3\'] >= 25)\r\n					{\r\n							// first we check if there is a free product of this type already added\r\n							$q = \"SELECT * FROM Collection_134 WHERE Collection_134_1=\'\".$cartID.\"\' AND Collection_134_13 = \" . $productDetails[\'Collection_134_ID\'];\r\n							$res = $db->query($q);\r\n							\r\n							$freeQuantity = floor($productDetails[\'Collection_134_3\'] / 25);\r\n							\r\n							if ($res ->numRows() == 0)\r\n							{\r\n												$addToCartData = array();\r\n												$addToCartData[\'Collection_134_1\'] = $cartID;\r\n												$addToCartData[\'Collection_134_2\'] = $productID;\r\n												$addToCartData[\'Collection_134_3\'] = $freeQuantity;\r\n												$addToCartData[\'Collection_134_4\'] = $priceID;\r\n												$addToCartData[\'Collection_134_5\'] = 0;\r\n												$addToCartData[\'Collection_134_6\'] = \"Free Product\";\r\n												$addToCartData[\'Collection_134_7\'] = $productDetails[\'Collection_134_7\'];\r\n												$addToCartData[\'Collection_134_8\'] = NULL;\r\n												$addToCartData[\'Collection_134_9\'] = $productDetails[\'Collection_134_9\'];\r\n												$addToCartData[\'Collection_134_10\'] = 0;\r\n												$addToCartData[\'Collection_134_11\'] = \'Free Product for more than 25 products purchased\';\r\n												$addToCartData[\'Collection_134_12\'] = $productDetails[\'Collection_134_12\'];\r\n												$addToCartData[\'Collection_134_13\'] = $productDetails[\'Collection_134_ID\'];\r\n												\r\n												$id = $db->extended->getBeforeID(\'Collection_134\');\r\n												$result = $db->extended->autoExecute(\'Collection_134\', $addToCartData, MDB2_AUTOQUERY_INSERT);\r\n												$id = $db->extended->getAfterID($id, \'Collection_134\');\r\n							\r\n							}\r\n							else\r\n							{\r\n											$addToCartData = array();\r\n											$addToCartData[\'Collection_134_3\'] = $freeQuantity;\r\n											$row = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n											\r\n											$db->extended->autoExecute(\'Collection_134\', $addToCartData , MDB2_AUTOQUERY_UPDATE, \' Collection_134_ID = \' . $row[\'Collection_134_ID\']);\r\n											\r\n											\r\n							}//if there is free product\r\n							\r\n							\r\n							\r\n					}\r\n					else\r\n					{\r\n							//we simply erase the free product\r\n							$q = \"DELETE FROM Collection_134 WHERE Collection_134_1=\'\".$cartID.\"\' AND Collection_134_13 = \" . $productDetails[\'Collection_134_ID\'];\r\n							$res = $db->query($q);\r\n							\r\n					}\r\n					\r\n					','//we simply erase the free product if any\r\n							$q = \"DELETE FROM Collection_134 WHERE Collection_134_1=\'\".$cartID.\"\' AND Collection_134_13 = \" . $cardDetailID;\r\n							$res = $db->query($q);','<p>For each 25 products of this type in the cart, you will receive one free. <a href=\"javascript://\" id=\"buy25productsnow\">Buy 25 products now</a>.</p>\r\n{{capture name=aaaa assign=jq}}\r\n	$(\'#buy25productsnow\').click(function(){\r\n	$(\'.itemquantityfield\').val(\'25\');\r\n	$(\'#addtocartlink\').click();\r\n	});\r\n{{/capture}}\r\n{{assign var=JavaScriptJQueryCode value=$JavaScriptJQueryCode|concat:\" \"|concat:$jq}}');

--
-- Table structure for table `Collection_342`
--

CREATE TABLE `Collection_342` (
  `Collection_342_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_342_1` int(11) DEFAULT NULL,
  `Collection_342_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_342_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_342`
--

INSERT INTO `Collection_342` VALUES (18,5,1);

--
-- Table structure for table `Collection_38`
--

CREATE TABLE `Collection_38` (
  `Collection_38_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_38_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_38_2` int(11) DEFAULT NULL,
  `Collection_38_3` varchar(254) DEFAULT NULL,
  `Collection_38_4` varchar(254) DEFAULT NULL,
  `Collection_38_5` varchar(254) DEFAULT NULL,
  `Collection_38_6` text,
  `Collection_38_7` bigint(20) DEFAULT NULL,
  `Collection_38_8` bigint(20) DEFAULT NULL,
  `Collection_38_9` bigint(20) DEFAULT NULL,
  `Collection_38_10` int(11) DEFAULT NULL,
  `Collection_38_11` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_38_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_38`
--

INSERT INTO `Collection_38` VALUES (2,'Page',NULL,NULL,NULL,NULL,NULL,0,NULL,3,NULL,NULL),(3,'Edit This Page\'s Content',1,'&id=13&eid={{$page.Collection_17_6}}',NULL,NULL,NULL,900,350,NULL,2,'&tabcode=Content'),(5,'Edit This Page\'s Details',1,'&id=17&eid={{$page.Collection_17_ID}}',NULL,NULL,NULL,900,350,NULL,2,'&tabcode=Content'),(6,'Sign Out',NULL,NULL,NULL,'/logout.html',NULL,0,NULL,5,NULL,NULL),(7,'Advanced',NULL,NULL,NULL,'/o2/',NULL,0,NULL,1,NULL,NULL),(13,'Create a New Page',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL),(16,'News',NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL),(17,'Add News',1,'&id=274',NULL,NULL,NULL,900,600,NULL,16,NULL);

--
-- Table structure for table `Collection_381`
--

CREATE TABLE `Collection_381` (
  `Collection_381_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_381_1` varchar(254) NOT NULL,
  `Collection_381_2` int(11) DEFAULT NULL,
  `Collection_381_3` text,
  `Collection_381_4` bigint(20) DEFAULT NULL,
  `Collection_381_5` int(11) DEFAULT NULL,
  `Collection_381_6` bigint(20) DEFAULT NULL,
  `Collection_381_7` int(11) DEFAULT NULL,
  `Collection_381_8` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_381_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_381`
--


--
-- Table structure for table `Collection_383`
--

CREATE TABLE `Collection_383` (
  `Collection_383_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_383_1` varchar(254) NOT NULL,
  `Collection_383_2` varchar(254) DEFAULT NULL,
  `Collection_383_3` int(11) DEFAULT NULL,
  `Collection_383_4` bigint(20) DEFAULT NULL,
  `Collection_383_5` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_383_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_383`
--

INSERT INTO `Collection_383` VALUES (1,'Image','',3,2,'Images'),(2,'Document','',3,4,'Files'),(3,'Video','',3,1,'VideoImages'),(4,'Zip (archive)',NULL,NULL,NULL,NULL),(5,'Undetermined','on',NULL,NULL,NULL),(6,'Audio','',NULL,0,'');

--
-- Table structure for table `Collection_389`
--

CREATE TABLE `Collection_389` (
  `Collection_389_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_389_2` varchar(254) NOT NULL,
  `Collection_389_3` varchar(254) NOT NULL,
  `Collection_389_4` varchar(254) NOT NULL,
  `Collection_389_5` varchar(254) NOT NULL,
  `Collection_389_6` varchar(254) NOT NULL,
  `Collection_389_7` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_389_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_389`
--

INSERT INTO `Collection_389` VALUES (1,'AKIAJ2M4SWQGFPRVYBTA','+aK7hJbrwlqwHB2boivLWGEJ7Q+ubQNrjS1J7FZS','o2v1','http://{{$bucket}}.s3.amazonaws.com','o2v1 Bucket','on');

--
-- Table structure for table `Collection_39`
--

CREATE TABLE `Collection_39` (
  `Collection_39_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_39_1` int(11) DEFAULT NULL,
  `Collection_39_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_39_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_39`
--

INSERT INTO `Collection_39` VALUES (1,1,NULL),(2,2,1),(3,3,2),(4,4,2),(5,5,2),(6,6,1),(7,7,1),(8,8,1),(9,9,8),(10,10,1),(11,11,10);

--
-- Table structure for table `Collection_390`
--

CREATE TABLE `Collection_390` (
  `Collection_390_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_390_2` varchar(254) NOT NULL,
  `Collection_390_3` varchar(254) NOT NULL,
  `Collection_390_4` varchar(254) NOT NULL,
  `Collection_390_5` varchar(254) DEFAULT NULL,
  `Collection_390_6` varchar(254) DEFAULT NULL,
  `Collection_390_7` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_390_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_390`
--

INSERT INTO `Collection_390` VALUES (1,'o2v1 dropbox','raipxkg4ylgx7y7','kkrl4efzvpxs4u5',NULL,'4cloirggzw4l4uo','1sdx3z212w9e2gu');

--
-- Table structure for table `Collection_392`
--

CREATE TABLE `Collection_392` (
  `Collection_392_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_392_1` varchar(254) NOT NULL,
  `Collection_392_2` bigint(20) DEFAULT NULL,
  `Collection_392_3` varchar(254) DEFAULT NULL,
  `Collection_392_4` varchar(254) DEFAULT NULL,
  `Collection_392_5` int(11) DEFAULT NULL,
  `Collection_392_6` bigint(20) DEFAULT NULL,
  `Collection_392_7` varchar(254) DEFAULT NULL,
  `Collection_392_8` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_392_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_392`
--

INSERT INTO `Collection_392` VALUES (1,'s3',2,'','',389,6,'',7),(2,'DropBox',3,'','',390,2,'',5),(3,'Local Folder',1,'on','on',397,2,'on',4);

--
-- Table structure for table `Collection_393`
--

CREATE TABLE `Collection_393` (
  `Collection_393_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_393_1` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_393_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_393`
--

INSERT INTO `Collection_393` VALUES (1,'/photo-gallery.html'),(2,'/videos.html'),(3,'/pricing.html'),(4,'ref=roi');

--
-- Table structure for table `Collection_394`
--

CREATE TABLE `Collection_394` (
  `Collection_394_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_394_1` varchar(254) DEFAULT NULL,
  `Collection_394_2` text,
  `Collection_394_3` bigint(20) DEFAULT NULL,
  `Collection_394_4` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_394_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_394`
--

INSERT INTO `Collection_394` VALUES (1,'REQUEST ADDRESS','if (!isset($_SESSION[\'AIPagesVisitedStack\']))\r\n{\r\n			$_SESSION[\'AIPagesVisitedStack\'] = array();\r\n}\r\n\r\nif (!isset($_SESSION[\'AIQuickLinksDetails\']))\r\n{\r\n			$_SESSION[\'AIQuickLinksDetails\'] = array();\r\n}\r\n\r\nif ($_SERVER[\'REDIRECT_URL\'] != \'/notfound.html\')\r\n{\r\n\r\n		$AIPagesVisitedStack = $_SESSION[\'AIPagesVisitedStack\']; \r\n		$AIQuickLinksDetails = $_SESSION[\'AIQuickLinksDetails\'];\r\n		\r\n		//get the current visited URL\r\n		$AIPathParts = parse_url($_SERVER[\'REQUEST_URI\']);\r\n		\r\n		//we search to see if the path is in the list of favourite links list\r\n		$q = \"SELECT Collection_393.* , Collection_396.* FROM Collection_393 INNER JOIN Collection_396 ON Collection_396_1 = Collection_393_ID WHERE \'\".addslashes($_SERVER[\'REQUEST_URI\']).\"\' REGEXP Collection_393_1 = 1 Order By Collection_396_4 \";\r\n		$res = $db->query($q);\r\n				\r\n		if ($res->numRows() > 0)\r\n		{\r\n				\r\n				//push the url visited\r\n				array_unshift($AIPagesVisitedStack , $AIPathParts[\'path\']);\r\n				\r\n				$AIPagesVisitedStack = array_unique($AIPagesVisitedStack);\r\n		\r\n				if (count($AIPagesVisitedStack) > 5)\r\n				{\r\n						array_pop($AIPagesVisitedStack);\r\n				}\r\n				\r\n				\r\n				$AIQuickLinksDetails[$AIPathParts[\'path\']] = $db->queryAll($q);\r\n			\r\n				\r\n		}		\r\n		\r\n		\r\n		//publish the data\r\n		$_SESSION[\'AIPagesVisitedStack\'] = $AIPagesVisitedStack;\r\n		$_SESSION[\'AIQuickLinksDetails\'] = $AIQuickLinksDetails;\r\n				\r\n		\r\n}		',100,'on');

--
-- Table structure for table `Collection_395`
--

CREATE TABLE `Collection_395` (
  `Collection_395_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_395_1` varchar(254) DEFAULT NULL,
  `Collection_395_2` text,
  `Collection_395_3` bigint(20) DEFAULT NULL,
  `Collection_395_4` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_395_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_395`
--

INSERT INTO `Collection_395` VALUES (1,'Change Quick Links Based On Latest URL Visited','if ( isset($_SESSION[\'AIPagesVisitedStack\']) && isset($_SESSION[\'AIQuickLinksDetails\']) )\r\n{\r\n	\r\n	\r\n	$AILinksToChange = array();\r\n	\r\n	if (count($_SESSION[\'AIPagesVisitedStack\']) > 0 )\r\n	{\r\n			\r\n			\r\n			foreach ($_SESSION[\'AIPagesVisitedStack\'] as $k => $AILink)\r\n			{\r\n					//if we have the data to change for this link, we try to change it\r\n					if (isset($_SESSION[\'AIQuickLinksDetails\'][$AILink]))\r\n					{\r\n						\r\n						\r\n						foreach ($_SESSION[\'AIQuickLinksDetails\'][$AILink] as $kk => $AIPagesForLink)	\r\n						{\r\n							$tmpAILinkChange = array();\r\n							\r\n							$tmpAILinkChange[\'URL\'] = $AIPagesForLink[\'Collection_396_2\'];\r\n							$tmpAILinkChange[\'Text\'] = $AIPagesForLink[\'Collection_396_3\'];\r\n							\r\n							$AILinksToChange[] = $tmpAILinkChange;\r\n						}	\r\n					\r\n					}//end if we have to change the link\r\n			}//end foreach links to change\r\n			\r\n			\r\n									\r\n			if (count($AILinksToChange) > 0)\r\n			{\r\n					$AIhtml = str_get_html($templatedata);\r\n					\r\n					//we get all the links from the quicklinks div\r\n					$AICount = 0;					\r\n					foreach($AIhtml->find(\'div#ai-quicklinks ul li a\') as $e)\r\n					{\r\n						if (isset($AILinksToChange[$AICount]))\r\n						{\r\n								$e->innertext = $AILinksToChange[$AICount][\'Text\'];\r\n								$e->href = $AILinksToChange[$AICount][\'URL\'];\r\n						}		\r\n						\r\n						$AICount++;\r\n					}	\r\n					\r\n					\r\n					\r\n					$templatedata = $AIhtml->save();\r\n\r\n					// clean up memory\r\n					$AIhtml->clear();\r\n					unset($AIhtml);\r\n			\r\n			}\r\n			\r\n	}\r\n	\r\n	\r\n}//end if we have something to change inside the quicklinks\r\n\r\n',100,'on');

--
-- Table structure for table `Collection_396`
--

CREATE TABLE `Collection_396` (
  `Collection_396_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_396_1` int(11) NOT NULL,
  `Collection_396_2` varchar(254) NOT NULL,
  `Collection_396_3` varchar(254) NOT NULL,
  `Collection_396_4` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_396_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_396`
--

INSERT INTO `Collection_396` VALUES (1,1,'/video-gallery.html','Check Out the Video Gallery',NULL),(2,1,'/login.html','Login to our Site',NULL),(3,2,'/photo-gallery.html','Check Out the Photo Gallery',NULL),(4,3,'/roi-calculator.html','ROI',NULL),(5,4,'/roi-calculator.html','ROI Calculator',1);

--
-- Table structure for table `Collection_397`
--

CREATE TABLE `Collection_397` (
  `Collection_397_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_397_2` varchar(254) NOT NULL,
  `Collection_397_3` varchar(254) NOT NULL,
  `Collection_397_4` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_397_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_397`
--

INSERT INTO `Collection_397` VALUES (1,'Videos','/videos/',''),(2,'Images','/images/',''),(3,'Gallery Photos','/galleryphotos/',''),(4,'Documents','/documents/','on');

--
-- Table structure for table `Collection_398`
--

CREATE TABLE `Collection_398` (
  `Collection_398_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_398_1` int(11) NOT NULL,
  `Collection_398_2` varchar(254) NOT NULL,
  `Collection_398_3` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_398_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_398`
--

INSERT INTO `Collection_398` VALUES (1,2,'application/pdf','on'),(2,2,'application/msword',''),(3,1,'image','on'),(4,2,'application/vnd.openxmlformats',''),(5,4,'application/x-zip',NULL),(6,3,'application/octet-stream','on'),(7,3,'video','on'),(8,2,'text/plain',''),(9,6,'audio','on'),(10,2,'application/x-download','on'),(11,3,'video/x-flv','on');

--
-- Table structure for table `Collection_399`
--

CREATE TABLE `Collection_399` (
  `Collection_399_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_399_1` varchar(254) NOT NULL,
  `Collection_399_3` varchar(254) NOT NULL,
  `Collection_399_4` varchar(254) DEFAULT NULL,
  `Collection_399_5` bigint(20) NOT NULL,
  `Collection_399_6` bigint(20) NOT NULL,
  `Collection_399_7` varchar(254) NOT NULL,
  `Collection_399_8` varchar(254) DEFAULT NULL,
  `Collection_399_9` varchar(254) DEFAULT NULL,
  `Collection_399_10` varchar(254) DEFAULT NULL,
  `Collection_399_11` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_399_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_399`
--

INSERT INTO `Collection_399` VALUES (1,'Contact Oxiem','http://www.oxiem.com/contact-us.html','http://o2v1.s3.amazonaws.com/img.png',0,0,'QR Test',NULL,NULL,NULL,NULL);

--
-- Table structure for table `Collection_4`
--

CREATE TABLE `Collection_4` (
  `Collection_4_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_4_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_4_2` varchar(254) DEFAULT NULL,
  `Collection_4_3` text,
  `Collection_4_4` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_4_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=418 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_4`
--

INSERT INTO `Collection_4` VALUES (1,'Users','on',NULL,2),(2,'Allowed to View','on',NULL,2),(3,'UserGroupsXref',NULL,NULL,2),(4,'Collection Access','on',NULL,2),(5,'UserCollectionsXRef',NULL,NULL,2),(6,'SystemModules','on',NULL,2),(7,'UserSystemModulesXref','on',NULL,2),(8,'Admin Menu','on','Defines the left menu in o2.',2),(9,'CMS Collections Tabs','on',NULL,2),(10,'States',NULL,NULL,NULL),(11,'Countries',NULL,NULL,NULL),(12,'Company Information','on',NULL,6),(13,'Content Profile','on',NULL,1),(14,'Content Types',NULL,NULL,NULL),(15,'Content Formats','on',NULL,NULL),(16,'Content Language Types','on',NULL,NULL),(17,'Page Profile','on',NULL,1),(18,'Page Types','on',NULL,2),(19,'ContentGroupsXref','on',NULL,NULL),(20,'Images Profile',NULL,NULL,3),(21,'Image Types',NULL,NULL,3),(22,'Yes No','on',NULL,NULL),(23,'Documents',NULL,NULL,3),(24,'Document Type',NULL,NULL,3),(25,'CMS Functions',NULL,NULL,2),(26,'Collection List','on',NULL,2),(30,'Collection Rules','on',NULL,2),(31,'Collection Behaviours','on',NULL,2),(32,'Contact Us',NULL,NULL,5),(276,'Site Menu',NULL,NULL,1),(38,'Front End Admin Menu','on',NULL,2),(39,'Front End Admin Menu XRef','on',NULL,2),(236,'Events',NULL,NULL,1),(237,'Event Venues',NULL,NULL,1),(238,'Event Types',NULL,NULL,1),(239,'Event Types XRef',NULL,NULL,NULL),(240,'Event Repeat',NULL,NULL,NULL),(241,'Event Repeat By',NULL,NULL,NULL),(273,'News Categories',NULL,NULL,1),(274,'News Articles',NULL,NULL,1),(275,'News Categories XRef',NULL,NULL,NULL),(80,'Galleries',NULL,NULL,3),(81,'Gallery Pictures',NULL,NULL,3),(90,'CMS Scripts','on',NULL,2),(91,'CMS Display Templates','on',NULL,2),(50,'Videos',NULL,NULL,3),(89,'CMS Resize Options','on',NULL,2),(92,'CMS Display Form Fields','on',NULL,2),(93,'CMS Behaviours Form Fields','on',NULL,2),(303,'Google Sitemap Extra URLs','',NULL,NULL),(129,'Products','on',NULL,4),(130,'Product Categories','on',NULL,4),(131,'Product Prices','on',NULL,4),(132,'Product Categories Xref','on',NULL,4),(133,'Shopping Cart','on',NULL,4),(134,'Shopping Cart Details','on',NULL,4),(135,'Coupon Codes','on',NULL,4),(136,'Delivery Methods','on',NULL,4),(137,'Product Delivery XRef','on',NULL,4),(138,'Personal Billing Information','on',NULL,4),(139,'Personal Shipping Information','on',NULL,4),(140,'Credit Card Types','on',NULL,4),(141,'Credit Card Form','on',NULL,4),(142,'Credit Card Months','on',NULL,4),(143,'Credit Card Years','on',NULL,4),(144,'Credit Card Error Messages','on',NULL,4),(146,'Product Upsell XRef','on',NULL,4),(147,'Payment Methods','on',NULL,4),(148,'Bank Account Types','on',NULL,4),(149,'eCheck Form','on',NULL,4),(150,'Check By Mail Form','on',NULL,4),(151,'Tax Rates','on',NULL,4),(152,'Product Relationship','on',NULL,4),(153,'Total Price Ranges','on',NULL,4),(154,'Price Ranges Delivery XRef','on',NULL,4),(159,'Shopping Cart Settings','on',NULL,4),(160,'Product Options XRef','on',NULL,4),(162,'Product Option Rules','on',NULL,4),(163,'Product Options','on',NULL,4),(304,'Homepage Rotator',NULL,NULL,1),(62,'Blog Comments',NULL,'If the blog system is used, this is where blog comments are stored',1),(61,'Blog Discussions',NULL,NULL,1),(60,'Blog Topics',NULL,NULL,1),(94,'CMS Formulas','on',NULL,2),(324,'RSS Feeds',NULL,NULL,3),(95,'CMS Workflows','on',NULL,2),(96,'WFLOW - Write to Database','on',NULL,2),(97,'WFLOW - Email on Submit','on',NULL,2),(98,'WFLOW - Redirect','on',NULL,2),(99,'WFLOW - Approval','on',NULL,2),(100,'WFLOW - Approval - Collection Rows','on',NULL,NULL),(101,'WFLOW - Execute Rules','on',NULL,2),(102,'WFLOW - Execute Simple Behaviours','on',NULL,2),(103,'CMS Workflows Occurance','on',NULL,2),(104,'WFLOW - Audit',NULL,NULL,2),(105,'WFLOW - Audit - Records',NULL,NULL,2),(327,'Toll Free Numbers',NULL,NULL,2),(339,'RSS Feeds from Collections',NULL,'Create RSS feeds from any collection.',3),(341,'Shopping Cart - Product Discounts',NULL,'',4),(342,'Shopping Cart - Product Discounts XREF',NULL,NULL,4),(390,'Storage Parameters - DropBox','on',NULL,6),(392,'Storage Types','on',NULL,6),(381,'Files','on','A list of all files stored when Remote Storage module is active.',3),(383,'File Types','on',NULL,6),(389,'Storage Parameters - S3','on',NULL,6),(393,'AI - Favourite Links','on','',2),(394,'AI - Gather Info Code','on',NULL,2),(395,'AI - Use Gathered Info Code','on',NULL,2),(396,'AI - Link Destinations',NULL,NULL,2),(397,'Storage Parameters - Local Folders','on',NULL,6),(398,'Mime Types','',NULL,NULL),(399,'QR Codes','',NULL,NULL),(400,'Content Migration','on',NULL,6),(401,'301 Redirects','on',NULL,1),(403,'Content Migration - Page Types','on',NULL,6),(404,'Content Migration - Template Fields to Show','on',NULL,6),(405,'Content Migration - Relations','on',NULL,6),(408,'Content Adlets','','',NULL),(409,'Adlets Shown On Content','','',NULL),(410,'Quotes','','',NULL),(411,'XREF - Content Quotes','',NULL,NULL),(412,'Benefits','','',NULL),(413,'Content Benefits','','',NULL),(414,'Notables','',NULL,NULL),(415,'Rotator Quotes','',NULL,NULL),(416,'Homepage Tabs','',NULL,NULL),(417,'Request Quote','',NULL,NULL);

--
-- Table structure for table `Collection_400`
--

CREATE TABLE `Collection_400` (
  `Collection_400_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_400_1` varchar(254) DEFAULT NULL,
  `Collection_400_2` int(11) DEFAULT NULL,
  `Collection_400_3` int(11) DEFAULT NULL,
  `Collection_400_4` text,
  `Collection_400_5` text,
  `Collection_400_6` text,
  `Collection_400_7` text,
  `Collection_400_8` text,
  PRIMARY KEY (`Collection_400_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_400`
--

INSERT INTO `Collection_400` VALUES (1,'BENEFITS',NULL,5,'Benefits','Use Light to Clean Air and Buildings','PURETi treated surfaces prevent grime growth and reverse pollution outdoors. Indoors, PURETi eliminates odors and improves air quality. Buildings and windows stay cleaner. White roofs stay cooler. Inside air is healthier and odor free. One long lasting application saves time, money, water, chemicals and energy.',NULL,'Transform Almost Any Surface into a Self-Cleaning Air Purifier to Save More and Clean Less'),(2,'POLLUTION CONTROL',1,1,'Pollution Control','“Reduce, Reuse, Recycle and………………Reverseâ€','Concrete, asphalt and other building materials – treated with PURETi and exposed to light - actively and continuously reduce the indirect greenhouse gases (NOx and SOx) and particulates (PM 2.5 and PM 10) that cause smog. The impact is powerful. One lane mile (or 6000m2) will remove one ton of NOx per year – year after year. This is the equivalent of planting x number of trees.',NULL,'“PURETi treated roads, bridges and buildings use sunlight to eat smog and become “solutions to pollutionâ€.'),(3,'SELF-CLEANING',1,1,'Self-cleaning','“Use the Power of Light to Cleanâ€','PURETi water based, architectural finishes use light to keep surfaces twice as clean for twice 	as long. One cost effective application works for 5 years or more to keep windows, walls, roofs and concrete looking new with minimal rain or rinsing. Preserve your building’s intended appearance. Enhance your brand. PURETi prevents grime growth – even	on the north side of the building in the shade.',NULL,'Sun Washing with PURETi cuts pressure washing time and cost'),(4,'ODOR ELIMINATION',1,1,'Odor Elimination','The Future of Fresh – Using Light to Eat Smoke, Pet, Food and Human Odors','PURETi works exceptionally well in all indoor environments – hotels, rental cars, schools, homes, offices and rest rooms – to purify the air. PURETi does not mask odors. It breaks them down. As air circulates the room, any pet, smoke, food or human malodors are oxidized at the molecular level; leaving interior air smelling fresh and healthy. And unlike sprays and candles, one safe, sustainable application of PURETi works wonders for months and years.',NULL,'PURETi treated windows, curtains and light fixtures deliver a powerful odor eliminating benefit for a long lasting sense of freshness.'),(5,'IAQ IMPROVEMENT',1,1,'Iaq Improvement','Achieve Superior Indoor Air Quality with PURETi','PURETi treated windows, window coverings and light fixtures act as air scrubbers to reduce VOCs in interior spaces by 50% or more. The difference is noticeable, immediate and remarkably beneficial.\r\nPURETi is so powerful at purifying air that it has been incorporated into an FDA recognized protocol to help children with severe respiratory disease. Benefits to the healthy population are projected to be improved attendance, higher productivity and lower health care costs.',NULL,'PURETi breaks down VOCs (volatile organic compounds) and dust (organic particulates) to help improve respiratory health.'),(6,'SUSTAINABILITY',1,1,'Sustainability','Reduce, Reuse, Recycle………and Reverse','Life cycle analysis shows PURETi to be a tremendous net environmental good – removing NOX, methane, and VOCs from the air while reducing energy used for cleaning. PURETi helps save water by reducing washing cycles and helps save energy by making white roofs more reflective and solar panels more efficient. One cost effective application of PURETi lasts for 5 years or more to deliver a broad spectrum of sustainable environmental benefits.',NULL,'PURETi is keeping the Duomo visibly cleaner and helping to reduce pollution in Milan in the process – safely and sustainably.'),(7,'COST SAVINGS',1,1,'Cost Savings','Clean building cost savings and an ROI under three years.','PURETi saves money in so many ways – from the hard ROI of reduced window washing and cool roof and solar panel energy savings to the soft ROI of increased guest satisfaction and retention and improved worker health and efficiency. Cleaner building materials last longer. PURETi treated buildings will stay cleaner to last longer to cut replacement cycles and preserve assets.',NULL,'PURETi is a low cost capital expense that delivers years and years of operational savings from reduced washing and facility preservation.'),(8,'INDUSTRIES',NULL,5,'Industries','An Innovative Solution to Real Business Problems','PURETi treated surfaces provide a wide range of environmental, economic, and health benefits that make a difference to our customers’ businesses.  Adding PURETi to a maintenance regimen or directly to products can provide a real competitive advantage.\r\nImproved Guest Satisfaction\r\nCost Savings\r\nEnergy Efficiency\r\nProduct Differentiation\r\nSustainability \r\nClick on the industry boxes below to learn more about how companies can innovate:',NULL,'PURETi’s breakthrough is making photocatalytic functionality cost effective for many different industries.'),(9,'HOSPITALITY',8,1,'Hospitality','Hospitality:  Odor Free Guest Rooms','Keeping hotel guest rooms smelling fresh is a constant challenge. Smoke odors, food odors, human odors, mold and mildew – can all ruin the positive that positive first impression when guests walk into their room. Sprays provide only temporary relief, and some guests are sensitive to perfumes.\r\nPURETi is a powerful, safe, and sustained-action odor eliminator. We offer two different cost-effective solutions for hotel owners who want to give their guests the cleanest air possible.\r\nProfessional Application: A trained PURETi technician provides a comprehensive treatment. Step one is a thorough disinfection of the room using a safe sanitizing fog. Step two is the professional application of PURETi Clear to the interior windows, curtains, and light fixtures – anywhere that gets light. As air circulates, the odor molecules contact the PURETi-treated surfaces and get instantly oxidized.  One treatment is warrantied to last at least three years.\r\nPump Spray Application for your Housekeeping Staff: We also sell a version of our product called PURETi Fresh that does not require professional spray equipment. A simple fine mist spray bottle is all you need. PURETi Fresh destroys odors like our Clear product, but it is not as durable. Have your Housekeeping staff use it during your regular deep cleaning cycles to add photocatalytic odor-fighting capability to your windows, curtains, and light fixtures.  Your guests will notice the difference.',NULL,'PURETi helps hoteliers meet their dual goals of guest satisfaction and sustainability.'),(10,'FACILITY MAINTENANCE',8,1,'Facility Maintenance','Save time, energy, and money by reducing your exterior washing regimen.','The leading ingredients in building grime are:\r\n1. Micro-particles of tire rubber (organic)\r\n2. Soot from the exhaust of cars and factories (organic)\r\n3. Silicates (inorganic sand and soil)\r\n4. In some climates, black mold (organic)\r\nHigh pressure water is required to clean most outside surfaces because the organic contaminants form glue-like bonds that are very hard to break.\r\nPURETi oxidizes (breaks down) the organic particles at the molecular level before they can stick to the surface.\r\nPURETi does not break down sand, but the sand rinses easily because there is no “glueâ€ to hold it in place. \r\nStop power washing and start “Sun Washingâ€ with PURETi\r\nApply PURETi to outside surfaces that need to stay clean to reap the following benefits:\r\nHard ROI\r\nReduced frequency and intensity of pressure washing\r\nWindow cleaning can be done half as often, and with half the effort\r\nSolar panel output and solar reflectance can be increased\r\nSoft ROI\r\nMeasurable contribution to corporate sustainability goals\r\nBrand Enhancement - buildings look great between cleanings\r\nLEED points for innovation',NULL,'PURETi treated glass, facades, roofs, solar panels, and hardscape all stay cleaner, longer.'),(11,'AUTO AND TRANSIT',8,1,'Auto And Transit','Lots of Cars = Lots of Odors','Many products can get window glass clean.  And many other products claim to fight odors. PURETi can do both in one simple application. PURETi Fresh is a non-toxic, environmentally friendly glass cleaner that also cleans the air. PURETi Fresh’s active ingredient uses the energy from natural sunlight to safely break down organic grime, odors, and pollutants. In the presence of light, the glass surface keeps itself cleaner, resists fogging, and improves the air quality inside the cabin. One application gradually and continuously reduces pet odors, smoke odors, food odors, and harmful VOCs for months.\r\nPURETi Fresh comes in a simple spray bottle that can be used by maintenance staff or operators. The product is sprayed on and wiped clean with the reusable microfiber towel that comes with the bottle. Whenever the vehicle is in the sun, the chemistry is working. Visibility is improved and the air will smell like…nothing. PURETi does not mask odors or overwhelm them with perfumes, it destroys them.  \r\nPURETi is a sustainable solution that delivers real value. Customer complaints go down, guest and employee satisfaction goes up, and costs are reduced.',NULL,'PURETi offers an innovative solution to not on clean windows, but clean the air inside taxis, rental cars, buses, trains, and commercial fleet vehicles.'),(12,'ARCHITECTURE AND DESIGN',8,1,'Architecture And Design','Architects Specify PURETi products for Sustainability and Cost Advantages','Green today means environmentally benign, products that do no harm or are less harmful than they have been.  Green tomorrow will mean environmentally beneficial, products that actively clean and improve our world.\r\nPURETi can be a major contributor to sustainability efforts by making surfaces proactively improve air quality, conserve water and energy, and significantly reduce the use of chemicals used in cleaning.\r\nOutdoors:  Specify PURETi applications on the building envelope and hardscapes.  Transform buildings into air scrubbers.\r\nEnergy Savings:  Cool White Roofs and Solar Panels are essential parts of building sustainability, but they cannot work at their best if they are dirty.  PURETi can be applied before or after installation to keep them cleaner longer and preserve the intended functionality.  \r\nIndoors:  Sustainability is not just about natural resources, it is about human resources.  Healthy indoor air is an essential part of well-being and productivity.  Specify PURETi and PURETi-treated products indoors to reduce odors and VOCs.\r\nThe “NOx Neutralâ€ Facility:  Every outdoor surface treated with PURETi works to reverse pollution, in part by breaking down NOx.  Spray enough surface area, and you can offset a major pollution effect caused by the cars driving to a building every day.  Don’t just reduce pollution, reverse it.\r\n',NULL,'PURETi’s cost effective solutions making adding self-cleaning functionality to new builds and retrofits a solid business decision.'),(13,'MANUFACTURING',8,1,'Manufacturing','Product Innovation for OEMs','Any product that is regularly exposed to UVA light can be transformed into a self-cleaning air purifier without any change in its design characteristics. Unlike most current methods, which require mixing, gluing, or high heat to apply, PURETi can be spray applied at the end of the manufacturing process. PURETi dries in ambient temperatures, leaving a nano-thin layer that cannot be seen or felt. Depending on the application and the intended use, the product will remain photocatalytic for five years or more.\r\nApplications include:\r\nFabrics\r\nTile\r\nGlass\r\nBuilding Materials\r\nLight Fixtures\r\nOutdoor furniture\r\nWindow coverings\r\nRoofing material\r\nSolar panels\r\nContact us to learn more about how applying PURETi to your existing products can provide a true competitive advantage',NULL,'One cost-effective coat of PURETi at the end of the production line adds self-cleaning, air purifying functionality for pennies a square foot.'),(14,'HEALTHCARE',8,1,'Healthcare','PURETi in Healthcare','When PURETi is applied to any surface that gets UVA light, it breaks down organic matter at the molecular level. One application lasts for years, providing a constant source of cleaning even when human or mechanical means don’t touch the surface. Airborne particles are oxidized when they hit a light-activated surface. Windows, light fixtures, and window coverings can become part of the cleaning solution. In Spain, outpatient surgical centers recently reported their highest audit scores ever in PURET-treated rooms.',NULL,'Cleaning and disinfection in patient care environments is of critical importance. PURETi can Use the Power of Light to Clean in an innovative way the supplements existing programs.'),(15,'SOLAR',8,1,'Solar','Get More from your Solar Investment','Solar panels, film and mirrors all soil, blocking light and locking in efficiency-draining heat. Dirty panels can reduce PV solar output by 5%-30%. Thermal solar can lose up to 40%. Maintenance on solar panels is never done often enough because it is often difficult to do and you don’t want to risk damaging the equipment.\r\nPURETi is a cost-effective solution to the cleaning challenge. PURETi uses light energy to clean, saving water, energy and labor costs in maintenance, and more than paying for itself though improved output. Panels can be treated prior to application or inline at the time of the next cleaning.\r\nPURETI’s invisible coating blocks less than 1% of light transmission. It more than offsets that minor loss through keeping the panel cleaner longer, and it seems to keep PV panels about 2 degrees cooler, too. A single application lasts for 5 years. For about $0.10 to $0.15 per square foot of product cost (initial cleaning and labor not included), you can get more out of your solar investment for years to come.\r\nOh, and those solar panels will also now be air scrubbers, cleaning the air around them of NOx, Sox, and other airborne pollutants.',NULL,'Reduce Derating due to soiling with PURETi'),(16,'HISTORIC',8,1,'Historic','Preserving Historic Architecture','Many of the world’s great architectural achievements are under constant attack from pollution. Automotive and industrial grime soil the appearance and damage the surface.  Erecting scaffolding to support restoration projects is expensive and disappoints tourists. Applying PURETi after a cleaning will help keep the building cleaner, longer, while also turning the structure into an air scrubber that reverses air pollution. PURETi reduces the frequency and the intensity of the cleaning program, which is better for the building and the viewing public.\r\nLearn more about how PURETi worked at the world famous Duomo of Milan (hyperlink to Case Study in 6.4)',NULL,'PURETi can keep national treasures clean while reducing disruptive maintenance.'),(17,'OUTDOOR ADVERTISING',8,1,'Outdoor Advertising','PURETi keeps the messages clearer','Keeping outdoor furniture and advertising spaces clean is a major expense. Even slight reductions in this cost can produce big benefits. PURETi-treated surfaces break down organic grime caused by auto exhaust and micro-particles of soot and tire rubber. These particles mar the surface, attract dirt, and are difficult to clean. When PURETi is applied to a cleaned surface, it will stay cleaner longer, and be much easier to clean, likely with a simple rinsing.',NULL,'Advertisers pay to get their message out. PURETi can keep those ads cleaner, improving customer satisfaction and lowering costs. '),(18,'AGRICULTURE',8,1,'Agriculture','Healthy air produces healthier animals','In 2009, Italian scientists (need hyperlink to study) studied the effects of putting a photocatalyst in a pig barn.  As expected the light-activated chemistry worked to break down many airborne pollutants, and the ammonia levels in the air dropped.  The pleasant surprise was that the pigs in the barn were healthier, and produced a higher yield on their feed.  More research is needed about this exciting opportunity to make our food chain healthier by improving the quality of the air.',NULL,'Concentrated animal farm environments produce air quality and odor challenges for humans and animals alike. Research has shown that PCO can make a difference.'),(19,'APPLICATIONS',NULL,5,'Applications','PURETi Applications:  A World of Possibilities','With PURETi, it is now possible to put the power of photocatalytic titania onto almost any surface that gets light, and to do so cost effectively. \r\nOutdoors, PURETi adds self-cleaning and pollution reversing functionality\r\nIndoors, surfaces become odor eliminators and improve indoor air quality.',NULL,'PURETi’s water-based spray will bond to almost any surface, allowing application to an incredibly diverse range of products and building structures.'),(20,'COMMERCIAL BUILDINGS',19,1,'Commercial Buildings','Commercial Buildings offer multiple opportunities to put PURETi to work.','Lowering the cost of ownership and maintenance is a challenge for everyone from the architect to the facilities maintenance manager. Keeping surfaces clean enhances the appearance and longevity of the building, and reduces the burden on overworked facilities maintenance departments. A single application of PURETi lasts for 5 years or more, lowering costs and enhancing the appearance and value of the property. \r\nIndoors, there is an increasing amount of attention being paid to indoor air quality(hyperlink to 1.4) and its impact on the health and productivity of the workforce. PURETi applied to the interior surface of windows, light fixtures, blinds, and window coverings can lower VOCs and reduce odors.\r\nSolar panels (hyperlink to 2.6.2) can lose 20% or more of their efficiency as they get dirty. PURETi can mitigate de-rating due to soiling and increase energy output. PURETi provides a measurable contribution to corporate sustainability goals. Every square foot of PURETi treated surface works to break down pollutants in the air, including NOx. Making an office complex NOx Neutral (hypelink to 5.9 Nox Calculator) is now a possibility. If sufficient amount of surface is treated, it will reverse one polluting impact not only of the building, but of the cars the occupants drove to work that day.',NULL,'Whether the goal is reduced cost, improved appearance, or a commitment to sustainability, PURETi can make a cost-effective contribution.'),(21,'WINDOWS',20,1,'Windows','Reduce the Cost of Window washing','People have been talking for years about self-cleaning glass. Unfortunately, it didn’t work as well as many hoped, it was only available on new glass, and it was insanely expensive. PURETI address all three of these issues. PURETi Clear can be spray applied to any clean glass – in the factory or on existing structures. It dries to form a clear, invisible, nano-thin film that is durably bonded to the glass. PURETi is more photocatalytic, meaning in produces more cleaning power, than the leading products. And it costs less.\r\nThere are many benefits to putting PURETi on glass. Organic pollutants that would normally stick like glue to the glass – microparticles of rubber, soot from factories, exhaust from cars – are oxidized on contact. Rain or a light rinsing cleans any remaining dirt from the surface. Save labor and energy costs by reducing your window washing regimen. And every square foot of glass you treat contributes to your sustainability goals by breaking down air pollution, too.\r\nAs you can see from the independent test results below, PURETi is clearly superior.',NULL,'A true advance in self-cleaning glass.'),(22,'ROOFS',20,1,'Roofs','Cool Roofs: Maintaining Solar Reflectance','White roofs are an important element of an energy saving strategy. But roofs lose their reflective capacity by 30% or more as they soil. One spray application of PURETi can Use the Power of Light to Clean, breaking down organic matter that soils the roof and provides a sticky surface for dirt to adhere. Future cleanings are made easier. This type of project produces a hard ROI not only on reduced cleaning costs, but on the energy savings it generates.\r\nPURETi can be applied to an existing roof at the time of the next cleaning, or it can be applied to roofing material in the factory. Contact Us (hyperlink to contact us) to learn more or get a quote.\r\nClick here to learn more about how a loss of solar reflectance hurts energy efficiency (link to 5.1 Testing and Studies white roof paper from LBL)',NULL,'PURETi can help keep the roof cleaner, longer.'),(23,'FACADES & HARDSCAPE',20,1,'Facades & Hardscape','Facades and Hardscapes.','The leading ingredients in building grime are:\r\n1. Micro-particles of tire rubber (organic)\r\n2. Soot from the exhaust of cars and factories (organic)\r\n3. Silicates (inorganic sand and soil)\r\n4. In some climates, black mold (organic)\r\nHigh pressure water is required to clean most outside surfaces because the organic contaminants form glue-like bonds that are very hard to break.\r\nPURETi oxidizes (breaks down) the organic particles at the molecular level before they can stick to the surface.\r\nPURETi does not break down sand, but the sand rinses easily because there is no “glueâ€ to hold it in place. \r\nStop power washing and start “Sun Washingâ€ with PURETi.\r\nA sustainable fringe benefit: In addition to lower costs and improving facility appearance, PURETi treated surfaces also help the environment by reversing air pollution. Every square foot of PURETi treated surface works to break down pollutants in the air, including NOx. Making an office complex NOx Neutral (hypelink to 5.9 Nox Calculator) is now a possibility. If sufficient amount of surface is treated, it will reverse one polluting impact not only of the building, but of the cars the occupants drove to work that day.',NULL,'Reduce the frequency and intensity of pressure washing.'),(24,'BATHROOMS',20,1,'Bathrooms','The Rest Room of the Future – Today!','PURETi transforms the light fixtures and light activated surfaces in a restroom into powerful air scrubbers that set a new standard for safe, sustainable IAQ. Stopping spraying nasty chemicals and start breathing PURETi fresh air.',NULL,'Transform every light activated surface in the restroom into a cleaner'),(25,'OFFICE INTERIORS',20,1,'Office Interiors','Air Quality in the Workplace','The quality of our work environment affects the quality of our work. The building community is increasing their focus on the quality of the air we breathe inside, which can be far more polluted than the air outside. PURETi can be part of the solution. Spraying PURETi on the surfaces that get sufficient UVA light, including the inside of windows, light fixtures, and blinds, turns those surfaces into air purifiers. Lower VOC levels and reduce odors. One cost effective application lasts for years, continuously scrubbing the air and giving your people cleaner air to breathe.\r\nPURETi can also be used to accelerate “flush outsâ€ in green building commissioning.',NULL,'Provide your employees with the cleanest air possible to contribute to their health and productivity.'),(26,'RESIDENTIAL BUILDINGS',19,1,'Residential Buildings','Homes and apartments offer multiple opportunities to put PURETi to work.','There is an increasing amount of attention being paid to indoor air quality(hyperlink to 1.4) and its impact on the health. PURETi applied to the interior surface of windows, light fixtures, blinds, and window coverings can lower VOCs and reduce odors. Only apply PURETi on surfaces that get direct light – there is no need to spray more. Normal air circulation brings the pollutants to the treated surfaces where the UVA energy provides the oxidizing power. Pet odors, smoke odors, and cooking odors are all organic material that can be destroyed. The result is not a perfume cover-up; it is refreshingly pure, odor free air.',NULL,'Provide healthier indoor air for your family.'),(27,'WINDOW COVERINGS',26,1,'Window Coverings','Use the sunlight at the windows to clean the air','Curtains and blinds have long been a place where odors go to linger. With PURETi they become a cleaning engine. A PURET-treated window and curtains can provide enough air scrubbing power to leave a whole room smelling fresh. Normal air circulation brings the pollutants to the treated surfaces where the UVA energy coming through the windows provides the oxidizing power. Pet odors, smoke odors, and cooking odors are all organic material that can be destroyed. The result is not a perfume cover-up; it is refreshingly pure, odor free air.\r\nBuy products already treated with PURETi, or add PURETi as an aftermarket coating. It is completely invisible and won’t change the look or feel of the windows or curtains in any way. All you notice is the cleaner air. A single application lasts 3 years or more.',NULL,'Eliminate odors and improve indoor air quality'),(28,'LIGHTING',26,1,'Lighting','Lighting','Sed dapibus vitae elit id tristique. Quisque erat nibh, tempus sed quam sed, vestibulum cursus ligula. Integer auctor porttitor est, quis venenatis tortor tincidunt non. Mauris condimentum, eros id posuere ornare, nibh sapien volutpat elit, ut sollicitudin risus nunc non neque. Suspendisse sit amet lectus purus. Mauris at posuere libero. Donec aliquet lacinia vestibulum. Integer condimentum odio eget eleifend vehicula. Fusce arcu nibh, posuere eget magna ac, pulvinar tincidunt massa. ',NULL,'Aliquam erat volutpat. Aliquam erat volutpat. Nunc nisl leo, aliquam quis iaculis a, placerat in massa. Donec dignissim interdum rhoncus.'),(29,'AUTO & TRANSIT',19,1,'Auto & Transit','Auto & Transit','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc a lorem elementum, tempus augue eleifend, viverra velit. Maecenas vitae nisl nec purus sagittis condimentum. Nullam fringilla posuere odio, a laoreet mi egestas eu. Quisque sed bibendum ligula. Nam sit amet metus convallis, consectetur augue et, bibendum ante. Ut lorem massa, malesuada sit amet sollicitudin ac, pellentesque non tellus. Donec at sollicitudin eros. Interdum et malesuada fames ac ante ipsum primis in faucibus. ',NULL,'Phasellus purus neque, suscipit sed faucibus id, tincidunt vel ipsum. Mauris commodo purus vitae est aliquet, eu feugiat risus auctor.'),(30,'INFRASTRUCTURE',19,1,'Infrastructure','Infrastructure and Public Works','The invention of smog-eating cement introduced the idea that roadways could be part of the solution to air pollution and global warming. PURETi takes this idea to the next level by providing greater efficacy, greater versatility, and lower cost. PURETi can be sprayed to existing roadways (no re-paving necessary) and unlike smog-eating cement, PURETi can be applied to asphalt. Learn more about PURETi’s NOx reducing capability.\r\nEvery modern public works project is expected to minimize its environmental impact.  Maintaining facilities that are always in the public eye is also a challenge. Facility owners and operators around the globe are learning the PURETi can keep their properties cleaner, reducing the cost of building maintenance.  \r\nSunLife Stadium\r\nBarca\r\n',NULL,'Public facilities offer a great venue for PURETi to maintain appearance and deliver sustainability benefits.'),(31,'STADIUMS',30,1,'Stadiums','Stadium Maintenance','Stadium operators around the world are learning that a single application of PURETi can keep their building in showcase condition, while saving significant costs on pressure washing.\r\nIn the photos above, you can see the results after only six weeks. Both rows of stadium concrete were pressure washed clean. The one on the right was treated with PURETi. The left side began to get dirty again from a combination of soot, grime, and black mold. Another pressure washing was soon required. The PURETi treated side stayed clean, with no need for additional pressure washing.\r\nLuxury boxes are another prime target for a PURETi treatment, eliminating odors and improving air quality for the highest value customers.',NULL,'PURETi can reduce the need for harsh pressure washing'),(32,'ROADS, BARRIERS & BRIDGES',30,1,'Roads, Barriers & Bridges','Roads can be part of the air pollution solution','Much attention has been paid to reducing auto emissions, but a world of zero emissions is far in the future. Photocatalytic titania is a proven solution to NOx, SOx, and ground level ozone problems we face today. PURETi makes this technology cost-effective and easy to apply. PURETi can be sprayed on any road surface:  concrete, asphalt, barriers, and sound walls. The total amount of pollution reversal depends on a variety of environmental conditions, but in laboratory settings we have seen PURETi treated surfaces reduce 75% of the NOx (hyperlink to case study on NOx) passing over them.\r\nResearchers at Louisiana State University tested PURETi on asphalt and concluded that “PURETi’s results in reducing NOx are very impressive. It holds great potential to make a real difference in pollution reduction.â€(hyperlink to Hassan study). Sustainable cities of the future must incorporate this technology to mitigate the harm caused by auto and industrial emissions.',NULL,'Reduce, reuse, recycle…Reverse!'),(33,'BUILDING MATERIALS',19,1,'Building Materials','Innovation for OEMs:  Building Materials','Customers are concerned about total cost of ownership and sustainability.  Building materials coated with PURETi have a competitive advantage over those that do not.  For any material that sees light, PURETi transforms the surface into a self-cleaning air purifier.  Customers get a lower-maintenance product, and one that truly differentiates itself from the competition by adding odor eliminating or pollution reversing functionality.   It’s invisible layer of titania does not change the design characteristics in any way, making it an easy addition.\r\nBut what about the cost? Spraying PURETi in-line at the end of a production process is the most cost-effective form of application.  PURETi goes on with great efficiency: one gallon covers 3,000 to 4,000 square feet, depending on substrate porosity.  Total cost to apply is only pennies per square foot.  Contact us (hyperlink to contact us) to learn more about application equipment and how PURETi can make your products both greener and less expensive to own.',NULL,'PURETi can be applied most cost effectively in-line at the end of the production process.'),(34,'TILE',33,1,'Tile','Photocatalytic tile:  The PURETi Advantage','Most existing “self-cleaning tilesâ€ bake titanium dioxide into a glaze on the surface, or they “glueâ€ it to the surface. A simple spray application of PURETi dries at ambient temperatures in seconds and bonds for years.\r\nThe difference in efficacy and cost is striking. See the pictures below and click through to the video to see for yourself.',NULL,'PURETi takes a new approach to make a significant advance in efficacy.'),(35,'WINDOWS & CURTAIN WALL',33,1,'Windows & Curtain Wall','Windows & Curtain Wall','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc a lorem elementum, tempus augue eleifend, viverra velit. Maecenas vitae nisl nec purus sagittis condimentum. Nullam fringilla posuere odio, a laoreet mi egestas eu. Quisque sed bibendum ligula. Nam sit amet metus convallis, consectetur augue et, bibendum ante. Ut lorem massa, malesuada sit amet sollicitudin ac, pellentesque non tellus. Donec at sollicitudin eros. Interdum et malesuada fames ac ante ipsum primis in faucibus. Interdum et malesuada fames ac ante ipsum primis in faucibus. Pellentesque venenatis odio ut neque iaculis, in bibendum tortor malesuada. Donec sit amet congue nunc, sit amet laoreet turpis. Maecenas molestie malesuada quam ac venenatis. ',NULL,'Phasellus purus neque, suscipit sed faucibus id, tincidunt vel ipsum. Mauris commodo purus vitae est aliquet, eu feugiat risus auctor. '),(36,'FIXTURES & FABRICS',19,1,'Fixtures & Fabrics','Interior Furnishings Become Air Purifiers','PURETi’s light-activated technology works indoors too. Ultraviolet light levels are much lower indoors than out, but certain household fixtures are close enough to light sources to generate a significant benefit if they are treated with PURETi. Blinds, window shears, and light fixtures can generate enough air scrubbing power to leave a whole room smelling fresh. Normal air circulation brings the pollutants to the PURETi treated surfaces, where they are oxidized. A single application, either in the factory or as an aftermarket application, works for years. PURETi is completely invisible on the surface, so there is no impact on color or other aesthetics.\r\nHotel rooms, hospital rooms, offices, restaurants, and residences can all improve the quality of their indoor air by adding PURETi-treated furnishings to the décor.  \r\nOutdoor fabrics for awnings, umbrellas, and patio furniture are bathed in sunlight, generating enough oxidizing power to keep them cleaner, longer.',NULL,'Smoke odors, pet odors, food odors, and even VOC’s can be broken down, creating a healthier indoor environment'),(37,'FIXTURES & LIGHTING',36,1,'Fixtures & Lighting','Lighting and Light Fixtures','Light fixtures are becoming more efficient every day, but PURETi can create product differentiation in two other ways.\r\nPURETi can turn the light fixture into a remarkable odor eliminator and air purifier.  \r\nPURETi can help keep the light fixture and deflector cleaner, improving light transmission for years. This can be a real differentiator for government and industrial customers with demanding specifications.\r\nPURETi can be applied to the light source itself, but much of the benefit comes from the treated surface on the fixture immediately surrounding the light. More surface area generates more cleaning power. The simple spray application can be done in a home or office where the lights are already installed, or it can be done at the end of the production line in a factory.\r\nIncandescent bulbs do not give off UVA light, but fluorescent, halogen, and some LED bulbs generate more than enough to activate PURETi.\r\n',NULL,'Artificial light indoors can be used to improve indoor air quality'),(38,'TEXTILES',36,1,'Textiles','Fabrics','Curtains and window treatments have long been a place where odors go to live. No more. With PURETi treated fabrics oxidize organic compounds like smoke odor, cooking odor, pet odors, and even VOCs. Natural sunlight coming through the window typically generates more than enough light energy to purify the air in an entire room.\r\nOutdoor fabrics are bathed in sunlight, but they are susceptible to soiling. Soot and smog cling to the surface, which in turn attracts dirt. The combination is difficult to clean. With PURETi, the soot and smog are oxidized and the dirt can be easily washed away with a rain or a light rinsing.',NULL,'Indoors and out, PURETi adds amazing functionality to fabrics'),(39,'TECHNOLOGY',NULL,5,'Technology','Sustainable UV-PCO Technology','PURETi surface treatments deliver a level of sustainable self-cleaning, air purifying, and odor eliminating benefits never before seen in the world. The idea of using light to clean, not chemicals, may seem implausible or even too good to be true. However, as with all truly innovative technologies, PURETi surface treatments were developed through years of research and scientific breakthroughs. The end result is a family of products that greatly benefit the environment, while supplying the world with tangible, sustainable solutions to grime and foul material buildup, poor air quality, and odor.\r\nPURETi UV-PCO technology is rooted in sound science and can be easily understood through some of the most fundamental properties of chemistry.',NULL,'Transform Almost Any Surface into a Self-Cleaning Air Purifier to Save More and Clean Less'),(40,'HOW IT WORKS',39,1,'How It Works','How it works','There is a continuous interplay of two forces in nature—organic matter gets created and organic matter is broken up or decomposed.Photosynthesis is the natural process of light energy hitting plants and triggering the creation of organic matter. Plants combine light energy from the sun, hydrogen from water, carbon dioxide and nitrogen from ground fertilizer to create the organic molecules of life.\r\nPhotocatalysis is a form of photosynthesis that actually reverses plant based photosynthesis. It’s a natural process whereby light energy hits a mineral and triggers a chemical process that results in the breakdown or decomposition or organic matter. UV-PCO (ultra violet photocatalysis) is a technology that accelerates the naturaldecomposition of organic matter.\r\nBy definition, photocatalysis is the acceleration of a photoreaction in the presence of a catalyst. A catalyst is a substance that accelerates or speeds up a chemical reaction without being used up in that chemical reaction. For example, in the catalytic converters used in automobiles, platinum accelerates the chemical breakdown of exhaust into harmless gases and the platinum is not used up in the process. In UV-PCO, light energy from the sun or fluorescent lamps energizes a mineral called anatase titanium dioxide (TiO2) and the natural chemical breakdown of organic molecules such as grime, foul material, and VOCs is accelerated. The TIO2 is not used up in the process, so the UV-PCO process can continue to breakdown organic molecules over-and-over again until only harmless gas is left.\r\nThere are four basic component that must be present in order for UV-PCO to proactively and continuously break-down organic matter: TiO2, light, water vapor (always present in the air as humidity), and air flow.',NULL,'Understanding PURETi Core Technology:  Ultra Violet Photocatalysis (UV-PCO)'),(41,'VIDEO',40,1,'Video','Video',NULL,NULL,NULL),(42,'PHOTOCATALYSIS',40,1,'Photocatalysis','The Chemistry of UV-PCO','Photocatalytic Oxidation (PCO) occurs when UV-A light (from sunlight, fluorescent light or UV-A LEDs) energizes titanium dioxide(TiO2) and triggers two chemical reactions that lead to the near instantaneous formation of hydroxyl radicals and super oxide anions. These highly reactive chemical agents then instantly interact at the treated surface to accelerate the environmentally beneficial decomposition of all organic pollutants (mold, oil, rubber, bio-film, methane and VOCs) through oxidation and to reduce/neutralize inorganic pollutants (such as NOx and SOx).\r\nHydroxyl radicals (OH*), nature’s strongest non-poisonous oxidizing agent, are formed when the light energized TiO2 pulls a hydrogen atom away from the H2O water vapor in the air (humidity). The hydroxyl radicals formed on the treated surfaceact like pac-men and aggressively attack the carbon hydrogen bonds that are present in all organic molecules over and over until nothing is left from this oxidation process except water and a small amount of CO2. Life Cycle Analyses of PCO have found the technology to be a major net environmental good. The small amount of CO2 produced is more than offset by the gains from reducing methane, NOx and VOCs (all major criteria pollutants) in the atmosphere and the gains from reduced water, chemical and energy usage through reduced maintenance.\r\nSuper oxide anions (O2-), one of nature’s strongest reducing agents, are formed when oxygen molecules in the air (O2) interact with light energized TiO2 and receive an extra electron creating O2-. When polluted air comes into contact with a PURETI treated surface, these super oxide anions interact with the NOx (the highest heat retaining major greenhouse gas and the key ingredient in acid rain and smog) and remove it from the atmosphere reducing it to benign nitrates. The light activated, smog-reducing power of PCO technology is extensively documented and definitively proven in the scientific literature.\r\nThis process all happens in billionths of a second and continues to scrub the air as long as light, humidity, PURETi and air flow are present. The self-cleaning function of photocatalytic surfaces are further assisted by the fact that photocatalytically active surfaces are hydrophilic or water sheeting. This water sheeting effect allows small amounts of water to easily rinse away any inorganic particulates that may be held to the surface by gravity or electrostatic forces.',NULL,NULL),(43,'HOT IT IS APPLIED',39,1,'Hot It Is Applied','How PURETi is applied','PURETi is applied to manufactured building materials and fixtures in factories or to the interior or exterior of the built environment.\r\nIn factories, PURETi is typically applied at the end of the production line via robotically controlled spray, coating or printing methods.\r\nIn the built environment, PURETi is applied by trained and certified applicators using specialized spray equipment to deposit a super thin film that dries in seconds and cures in hours to form an invisible polymeric like ceramic film that is durably bonded to the treated surface.',NULL,NULL),(44,'HOW IT COMPARES',39,1,'How It Compares','How PURETi compares','PCO technology was first discovered in Japan in 1968 and the first photocatalytic products (self-cleaning ceramic tiles and glass) were introduced in 1998. These initial 1st generation products, made by melting powders of TiO2 into the outer layer with high heat and expensive equipment, were later joined by powder based smog reducing cement (TX Active) and coil coated aluminum cladding (EcoClean). The initial PCO coating products launched in 2000 and bonded TiO2 powders or sol gels by using various adhesives such as sodium silicate or siloxanes.\r\nPURETi is a 3rd generation advance in PCO technology, discovered and manufactured in America, that is covered by 9 US patents and represents a true solution of water and TiO2 that is remarkably adhesive of its own accord. PURETi technology bonds to virtually any building surface more clearly and more thinly and with more crystals of TiO2 than any known competitor.\r\nAs a result, PURETi requires less light to work, delivers greater photocatalytic benefit and is more cost effective than any known competitor. Any 1st or 2nd generation PCO product can be produced with greater photocatalytic power and at lower cost with a simple spray application of PURETi.\r\nLink to Queens IPS test reports',NULL,NULL),(45,'PRODUCTS',39,1,'Products','Products','Chart showing PURETi products and target substrates.',NULL,NULL),(46,'CLEAR',45,5,'Clear','PURETi Clear','PURETi Clear is a water-based surface treatment that keeps glass clean by eliminating the build-up of grime and foul material in a sustainable and environmentally beneficial manner. PURETi Clear’s advanced photocatalytic activity and water sheeting functionality helps keeps glass free of unsightly organic matter without causing any visual distortion or haziness. One application of PURETi Clear’s patented water-based UV-PCO technology delivers self-cleaning and environmental benefits for years.\r\nMSDS (5.2.1) and TPB (5.3.1)',NULL,NULL),(47,'FRESH',45,5,'Fresh','Transform your car windows into odor eliminating air purifiers.','PURETi Fresh is a non-toxic, environmentally friendly glass cleaner that also cleans the air. PURETi Fresh’s active ingredient uses the energy from natural sunlight to safely break down organic grime, odors, and pollutants. In the presence of light, the glass surface keeps itself cleaner, resists fogging, and improves the air quality inside the cabin. One application reduces pet odors, smoke odors, food odors, and harmful VOCs for months.',NULL,'Many products can get window glass clean. PURETi Fresh not only cleans your window, but uses the power of light to keep the window cleaner longer and reduce odors and harmful VOCs in the air.'),(48,'COAT',45,5,'Coat','PURETi Coat','PURETi Coat is a cost effective one-step spray on solution for road (concrete or asphalt) or roofing surfaces.\r\nMSDS (5.2.3) and TPB (5.3.3)',NULL,NULL),(49,'BASE AND CLEAN',45,5,'Base And Clean','PURETi Base and Clean','PURETi  Clean™  transforms virtually any surface into a sustainable, \r\nself-cleaning material that proactively eliminates grime and foul material buildup, improves air quality, and eradicates organic malodors. Powered by the most advanced water-based UV-PCO (ultraviolet photocatalysis) technology available today, PURETi Clean uses the light, not chemicals to create sustainable, clean surfaces that benefit the environment in ways never-before seen.\r\nPURETi Base is the clear, highly adhesive, primer used on all rigid, opaque substrates including: concrete, asphalt, metal, plastic, stone, tile and painted surfaces.\r\nMSDS (5.2) and TPB (5.3)',NULL,NULL),(50,'FAQ\'S',39,1,'Faq\'s','FAQs','1. How is PURETi applied?\r\nPURETi is sold in solution form consisting of 99% water and 1% nano Titanium Oxide (TiO2) encapsulated in water.  When sprayed onto a surface, PURETi dries in seconds and cures in 24-36 hours to form a clear, hard, water permeable, inorganic mineral film that is 40nm thin.  To put this in perspective, 1nm = 1 billionth of a meter, and 40nm (working thickness for PURETi to do its job) = 1/25,000 the thickness of a business card.\r\nChemical and physical bonds – Van der Waals forces and hydrogen hooks-  bond PURETi to the material being treated, making it a very durable, tightly bonded mineral film that can be described as a polymeric like ceramic.\r\n2. How does PURETi work?\r\nPURETi’s patented 3-day production process results in a solution that can be spray-applied electrostatically to form a clear, durable, 40 nanometer-thin mineral film on virtually any construction material - glass, metal, stone, concrete, paint, plastic, etc.  When ultraviolet light (from the sun or fluorescent tubes) energizes the TiO2 crystal in PURETi-applied nano-thin mineral films, an energy band gap is created within the crystal that causes it to act like a magnet and pull a hydrogen atom off H2O molecules that are present in everyday humidity, leaving a hydroxyl radical (OH-).\r\nThe hydroxyl radical (OH-) is the strongest non-poisonous oxidizing agent in nature and literally acts like a pac-man to rip apart the carbon hydrogen bonds in any organic compound that comes in contact with it.  All of this happens in nanoseconds and within angstroms of the PURETi-treated surface.  The TiO2 in PURETi serves as a catalyst to trigger these reactions (safely decomposing organic matter into H2O and CO2) and does not get consumed in these reactions.  In the presence of light, PURETi becomes a perpetual hydroxyl radical creator.  Short-chain hydrocarbons get destroyed the fastest, with longer-chained molecules taking longer.  No heat is generated by the photocatalytic process.\r\nA second set of reactions is equally powerful at combatting urban smog. This happens when the photocatalytic process causes an electron to pop onto an oxygen molecule, creating O2-, a super-oxide aniline.  This interacts with SO2 and NO2, the chief ingredients in smog, reducing these molecules to relatively harmless neutrals.\r\nPURETi is also super-hydrophilic, which makes glass super-slippery. As a result, rain sheets off, taking organic dirt particles with it.  It also makes glass non-fogging.\r\nPURETi is non-flammable, and will quickly disperse if spilled.\r\n3. What substances will damage or remove PURETi once it has cured?\r\nSince TiO2 acts as a catalyst that does not get consumed by the photocatalytic process, it will continue doing its job as long as it is not physically scraped off or painted over. While the layer of TiO2 is extremely thin (40nm), it is inorganic and extremely tough, making it very hard to remove.\r\n4. Warranty?\r\nPURETi warrants its product for 5 years (exterior) and 3 years (interior). Actual life span will probably be longer.\r\nThe reason the warranty is shorter with interior spaces is that siloxanes – an inert chemical present in interior environments in increasing numbers - may invisibly cover up the PURETi layer and block receptor sites critical to the photocatalytic process.\r\n5. Is PURETi non-toxic and safe for humans and animals?\r\nYes. TiO2 is GRAS according to the FDA and European Science Commission has determined TiO2 to be safe in all forms – active and inactive, nano and micro. The National Science Foundation has registered PURETi as safe for material surface contact. NIOSH has found PURETi application methods to be safe. There are no respirable powders with PURETi and near zero risk of human contact. Independent university tests have found that PURETi requires great force to abrade and that it abrades in flakes larger than 100nm and above the threshold of concern.\r\n6. Will PURETi kill germs?\r\nPURETi makes no claims to being to germ-killing in the US, as that would require being regulated by the EPA, which currently classifies germ-killing substances as pesticides. Independent tests have found PURETi to deliver log 4 reductions in gram negative and gram positive bacteria and a variety of viruses in less than an hour. In Asia it is widely believed that TiO2 stopped the spread of the SARS virus back in 1999.\r\n7. What will interfere with PURETi doing its job?\r\nPainting over PURETi will block the light and stop the photocatalytic process (photocatalysis). Similarly, applying wax over PURETi will block the moisture need to activate photocatalysis. Gum, bird droppings and other large masses of light blocking matter will also limit PURETi’s functionality.\r\nSince normal household paint is many times thicker than PURETi, the PURETi layer can readily be painted over if the homeowner wants to change the color of PURETi-treated siding.\r\n8. What materials does PURETi not get along with?\r\na) Teflon, silicone, wax and polypropylene all reject PURETi’s water based carrier and are the only four materials to which PURETi will not bond.\r\nb) Wax applied over PURETi will block the moisture needed to activate photocatalysis.\r\nc) PURETi may degrade certain organic substrates, such as latex paint or soft plastic, then fall off the material being treated.  In these cases, a first coat of non-photoactive PURETi primer (called Base) can applied that will not damage the organic material, followed by a second coat of photoactive PURETi that will do the job.  In a production process where the cure process is being accelerated from 24 hours down to only seconds, the first coat can be followed immediately by the second.\r\n9. How quickly does PURETi work?\r\nActivation occurs immediately after the source of UV light is turned on; however, it takes a while for all the hydrocarbons, VOC’s, NOx and SOx in a room or in the air outside a building or solar panel to come in contact with the TiO2 crystals.\r\nEffective residence time can be speeded up by pulling more of the polluted air per unit of time in close proximity to PURETi, where it can be destroyed. Deactivation occurs within minutes after the source of UV light is removed.\r\n10. Will PURETi work with reflected light and how much light is needed?\r\nUV light bounces around just like visible light, so reflected or ambient light works fine to activate PURETi.\r\nThere is a range of functionality that PURETi delivers that depends on the amount of light it receives.\r\nOutdoors – PURETi claims a full set of self-cleaning and air purifying benefits. These functionalities only require 0.1mW/cm2 of UV-A light. Direct sunlight delivers over 1mW/cm2 and the north side of buildings – even in the shade – receive more than 0.001mW/cm2 of UV-A light.\r\nIndoors – PURETi claims a more limited, but still powerful and highly marketable, set of odor eliminating and IAQ, respiratory health improving benefits. These functionalities only require 0.001mW/cm2 of UV-A light – one hundredth the amount of light required for full self-cleaning. This level of light is found at window surfaces and light fixture surfaces.\r\n11. Will PURETi work under water?\r\nThe light intensity needed to activate PURETi falls off sharply under water.  5-6 inches is about the limit of effectiveness in salt water, up to 1 foot in non-salt water, depending on its clarity.\r\n12. Operating limits\r\na) PURETi will work down to 0 degrees C (32 degrees F), at which point the water PURETi is suspended in will freeze.\r\nb) Since PURETi in solution form is 99%+ water, it is best applied at a temperature that is not too hot to touch, otherwise it will evaporate too quickly.\r\nc) Once cured, PURETi’s upper temperature limit is 600 degrees C.  Above that it melts into the rutile form of TiO2.\r\nIn between freezing and 600 degrees C, PURETi is not particularly sensitive to temperature, nor is its performance impacted by pressure.\r\n13. Will PURETi eat dust?\r\nSince most indoor dust consists of skin and hair particles, which are organic, PURETi will consume these forms of dust as they come in contact with a PURETi-treated surface.\r\nInorganic dust (ie sand) will still be attracted to PURETi-cleaned windows, but without the “stickyâ€ organic grime to stick to, inorganic dust will fall off.\r\nOutdoors, inorganic fine sand on a PURETi-treated solar panel can be easily blown off by a strong wind gust or leaf-blower, whereas it will continue to stick to untreated panels.\r\nPURETi can be overwhelmed if the amount of dust, grime, algae or mold buildup occurs too quickly and blocks light.\r\nPURETi’s ability to eat large volumes of livestock-generated dust, which is a big problem in pig and cattle enclosures, has not been tested.\r\n14. Will PURETi work better on rough or smooth surfaces?\r\nPURETi will work equally well on both surfaces.\r\n15. Can PURETi be sprayed on fluorescent bulbs without impacting the bulb’s performance or life?\r\nIt will destroy VOC’s, and shouldn’t impact the bulb’s life. However, the limited surface area makes bulbs a far less significant target for application than the reflectors or lamp shades that surround these bulbs.\r\n16. How do the sprayers know if they’ve missed a spot?\r\nSince PURETi is 99% water, it leaves a visible sheen as it is being applied, so any missed spot is immediately visible.  To make sure PURETi is applied uniformly, sprayers are taught to do a series of sprays across a surface, then a series of up-and-down motions.\r\n17. What does the sprayer have to do differently under windy conditions?\r\nGet closer. Above four stories, extra measures are typically required to block the wind.\r\n18. Surfaces to avoid\r\nTeflon, polypropylene, wax, silicone and embossed stainless steel that’s designed to look like aluminum – (PURETi will tend to pool in the cracks and look milky).',NULL,NULL),(51,'SAFETY',39,1,'Safety','Safety','Ut nec nulla id dui pulvinar viverra quis vel ipsum. Praesent orci massa, sagittis ut leo non, facilisis ornare tortor. Nunc erat purus, congue eu porttitor at, hendrerit eget sem. Vivamus molestie lectus vitae est fermentum mattis. Proin suscipit lacus quis tristique imperdiet. Praesent dictum bibendum semper. Morbi vitae justo sed neque egestas vestibulum a sit amet leo. ',NULL,'Donec ipsum leo, ultricies porttitor dolor vel, commodo mollis nisl. Donec molestie mauris magna, vel elementum erat vehicula a.'),(52,'RESOURCES',NULL,5,'Resources','“Any Sufficiently Advanced Technology is Virtually Indistinguishable from Magicâ€ – Arthur C. Clarke','PURETi, as the world leader in advanced photocatalytic surface treatments, works on an ongoing basis with dozens of national, university and independent test laboratories to confirm its performance claims and insure its safe and sustainable approach to health and the environment. As a manufacturer, the company distributes its solutions through a highly qualified network of strategic allies, licensed manufacturers, certified applicators and international distributors.',NULL,'PURETI is a NASA Dual Use Technology Partner, the owner of 9 US patents in advanced photocatalytic solutions and the manufacturing and research hub of a growing global network of supremely qualified partners and distributers.'),(53,'TESTING & STUDIES',52,1,'Testing & Studies','First - do no harm. Next - do a whole lot of Good','PURETi is, at its heart, a health care company. Towards that end we put safety first and take environmental concerns very seriously. We endeavor to be transparent, collaborative and scientifically rigorous in our approach. PURETi is a NASA Dual Use Technology Partner and we routinely and openly test with national, university and independent laboratories.\r\n5.1.1 – Safety and Environmental (6-6 pdfs)\r\n5.1.2 – Air Quality Tests and Studies (6-8 pdfs)\r\n5.1.3 – Self-Cleaning Tests and Studies (6-8 pdfs)\r\n5.1.4 - Infection Control Studies (6-8 pdfs)\r\n5.1.5 – General (not PURETi specific) PCO Studies',NULL,'PURETi’s mission is to be the safest, most sustainable and effective photocatalytic solution in the world and we test to that standard.'),(54,'MSDS',52,1,'Msds','Safety Data Sheets','Listed below are the Safety Data Sheets for PURETi water based solutions:\r\nPURETi Clear (5.2.1)\r\nPURETi Fresh (5.2.2)\r\nPURETi Coat (5.2.3)\r\nPURETi Base (5.2.4)\r\nPURETi Clean (5.2.5)\r\n',NULL,'PURETi is committed to producing safe products that benefit the world and transparency in all its documentation re: materials.'),(55,'TECHNICAL BULLETINS',52,1,'Technical Bulletins','Technical Product Bulletins','Learn more about PURETi and how it is best applied here:\r\nPURETi Clear (5.3.1)\r\nPURETi Fresh (5.3.2)\r\nPURETi Coat (5.3.3)\r\nPURETi Base (5.3.4)\r\nPURETi Clean (5.3.5)\r\nProduct Selection Chart (5.3.6)',NULL,'PURETi is the safest, simplest, most cost effective and sustainable photocatalytic surface treatment when properly applied.'),(56,'PARTNERS',52,1,'Partners','PURETi Teams with the Best','“We all love innovation, but you can only have innovation if someone has the guts to go first.â€ PURETi’s partners are world class in what they do. They have also stepped up and shown the courage of their convictions, their commitment to sustainability and their leadership in innovation by taking the time to evaluate and team with PURETi. We salute them and thank them for their support and urge you to connect with them.\r\nLogos of\r\nHOK\r\nJCI\r\nDTZ\r\nFalcon Water Free\r\nVital Oxide',NULL,'PURETi has developed a global network of strategic allies – architects, manufacturers and experts in facility management and service – that are dedicated to using light to clean air and buildings.'),(57,'DISTRIBUTORS',52,1,'Distributors','It takes a Highly Qualified and Trained Village','The potential of PURETi to protect and improve any surface exposed to light represents tremendous opportunity to improve the environment; save energy, water and cost and improve human health. Learn about the firms who are helping us achieve that potential here:\r\nDomestic\r\nJCI\r\nDTZ\r\nExpert NJS\r\nInternational\r\nItaly\r\nSpain\r\nUnited Kingdom\r\nCarribbean',NULL,'PURETi distributors and applicators are hand selected to sell, service and support the PURETi program and exceed client expectations.'),(58,'CASE STUDIES',52,1,'Case Studies','It takes a Highly Qualified and Trained Village','The potential of PURETi to protect and improve any surface exposed to light represents tremendous opportunity to improve the environment; save energy, water and cost and improve human health. Learn about the firms who are helping us achieve that potential here:\r\nDomestic\r\nJCI\r\nDTZ\r\nExpert NJS\r\nInternational\r\nItaly\r\nSpain\r\nUnited Kingdom\r\nCarribbean',NULL,'PURETi distributors and applicators are hand selected to sell, service and support the PURETi program and exceed client expectations.'),(59,'AAPG',58,1,'Aapg','Case Study:  The Asthma and Allergy Prevention Group','The Asthma and Allergy Prevention Group has developed an FDA approved medical device for the treatment of Cystic Fibrosis.  A team of physicians and engineers with expertise in the field of creating pure air environments in hospitals took on the challenge of bringing that air into the home.  PURETi is an integral part of this comprehensive approach to the treatment of disease.',NULL,'Bringing Hospital Grade Clean Air Into the Home'),(60,'WHITE PAPERS',52,1,'White Papers','White Papers','Listed below are the White Papers:\r\nPURETi and the Safety\r\nPURETi and Life Cycle Analysis',NULL,'We are pleased to provide the following resources to allow our customers and our partners to learn more about PURETi and cutting edge applications of photocatalytic titania.'),(61,'NOX CALCULATOR',52,1,'Nox Calculator','PURETi and NOx reduction','Independent lab results (link to 5.1 Queens IPS NOX) have shown that PURETi treated surfaces can eliminate 75% of the NOx that passes over them, in the presence of UVA light.University studies(link to 5.1) have shown surface-applied PURETi to be 2-9x more effective at removing NOx than embedded smog eating cement, depending on environmental conditions.One lane mile of PURETi treated road can remove one ton of NOx from the atmosphere every year.\r\nIf one car emits 1.4 grams of NOx for every mile driven, this is the equivalent of eliminating a polluting effect of 52 cars driving over 650,000 miles, every year.\r\nTreating enough surface on an office campus, including the roof, solar panels, windows, and facades, can offset the polluting effect of every car in the parking lot commuting to and from the building.  This makes a facility NOx Neutral not just from the building perspective, but from a total occupancy perspective.',NULL,'NOx is an indirect greenhouse gas and a key ingredient in acid rain and smog.'),(63,'NEWS FEED/RECENT EVENTS',66,2,'News Feed/recent Events','/events/','/events/',NULL,NULL),(64,'PRESS RELEASES',66,2,'Press Releases',NULL,'/news/1/',NULL,NULL),(65,'AWARDS',66,1,'Awards','PURETi Company Awards','PURETi and product results have received recognition from leading organizations around the world.\r\nSelected Awards and Recognition\r\n2013 Architectural Products Innovation Award\r\n2012 Edison Award in Materials Technology - Safety & Sustainability Category\r\n2012 Material of the Year Award from Material ConneXion\r\n2012 Katerva Award for Sustainability\r\n2011 Popular Science Magazine Green Tech Innovative Product of the Year Award\r\nNASA Dual Use Technology Partner\r\nNSF International Indoor Advantage Gold Certifications\r\nEU SCCS\r\nQualifies projects for LEED points under the U.S. Green Building Council standards.\r\nSelected Research',NULL,NULL),(66,'News & Info',NULL,2,'News & Info',NULL,'/news/',NULL,NULL);

--
-- Table structure for table `Collection_401`
--

CREATE TABLE `Collection_401` (
  `Collection_401_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_401_1` varchar(254) NOT NULL,
  `Collection_401_2` varchar(254) NOT NULL,
  PRIMARY KEY (`Collection_401_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_401`
--

INSERT INTO `Collection_401` VALUES (1,'/','/about-us.html');

--
-- Table structure for table `Collection_403`
--

CREATE TABLE `Collection_403` (
  `Collection_403_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_403_1` varchar(254) DEFAULT NULL,
  `Collection_403_2` int(11) DEFAULT NULL,
  `Collection_403_3` bigint(20) DEFAULT NULL,
  `Collection_403_4` varchar(254) DEFAULT NULL,
  `Collection_403_5` int(11) DEFAULT NULL,
  `Collection_403_6` int(11) DEFAULT NULL,
  `Collection_403_7` text,
  PRIMARY KEY (`Collection_403_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_403`
--

INSERT INTO `Collection_403` VALUES (1,'Content',1,1,'CONTENT',1,1,'{{$content}}\r\n'),(2,'External Link',1,100,'LINK',NULL,NULL,NULL),(3,'Dynamic Page',1,90,'DYNAMIC',3,2,NULL),(4,'Homepage',689,3,'HOME',1,1,'{{$content}}'),(5,'Lander',688,2,'LANDER',1,1,'{{$content}}');

--
-- Table structure for table `Collection_404`
--

CREATE TABLE `Collection_404` (
  `Collection_404_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_404_1` int(11) DEFAULT NULL,
  `Collection_404_2` varchar(254) DEFAULT NULL,
  `Collection_404_3` text,
  `Collection_404_4` text,
  PRIMARY KEY (`Collection_404_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_404`
--

INSERT INTO `Collection_404` VALUES (1,2,'1','',''),(2,2,'2','',''),(3,2,'3','',''),(4,2,'6','Place the URL where to send the site visitor on the first line of this textbox.','$(\'#Collection_400_6_row .collection_field_name\').text(\'URL\');'),(5,2,'4','','$(\'#Collection_400_4_row .collection_field_name\').text(\'Link Text\');');

--
-- Table structure for table `Collection_405`
--

CREATE TABLE `Collection_405` (
  `Collection_405_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_405_1` varchar(254) DEFAULT NULL,
  `Collection_405_2` bigint(20) DEFAULT NULL,
  `Collection_405_3` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_405_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_405`
--

INSERT INTO `Collection_405` VALUES (1,'Content',6,6),(2,'Notes - Files for Download (PDF, XLS, ect.) ',7,2),(3,'H1',5,14),(4,'Intro',8,15);

--
-- Table structure for table `Collection_408`
--

CREATE TABLE `Collection_408` (
  `Collection_408_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_408_1` varchar(254) DEFAULT NULL,
  `Collection_408_2` text,
  `Collection_408_3` text,
  `Collection_408_4` varchar(254) DEFAULT NULL,
  `Collection_408_5` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_408_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_408`
--

INSERT INTO `Collection_408` VALUES (1,'Pureti susce augue cuside leo sustain.','Pureti susce augue cuside leo sustain.','<p>Vestibulum non orci quis turpis adipisg consequat vel et augue. Aenean sed mattis orci, eget sodales quam. Fusce feugiat quam vel eros tincidunt, quis dignissim lectus aliquam. Integer sed lacinia nunc, et convallis mi. Morbi suipit turpis at massa sodales ultricies. Cur vulputate nibh eu odio suscipit elentum.</p>\r\n','/images/content1.jpg',1),(2,'Fuseco sicropot meciedo lorgumed.','Fuseco sicropot meciedo lorgumed.','<p>estibulum non orci quis turpis adipisg consequat vel et augue. Aenean sed mattis orci, eget sodales quam. Fusce feugiat quam vel eros tincidunt, quis dignissim lectus aliquam. Integer sed lacinia nunc, et convallis mi. Morbi suipit turpis at massa sodales ultricies. Cur vulputate nibh eu odio suscipit elentum.</p>\r\n','/images/content2.jpg',1),(3,'Aguemeciedo  lacueded  sustainabilty.','Aguemeciedo  lacueded  sustainabilty.','<p>estibulum non orci quis turpis adipisg consequat vel et augue. Aenean sed mattis orci, eget sodales quam. Fusce feugiat quam vel eros tincidunt, quis dignissim lectus aliquam. Integer sed lacinia nunc, et convallis mi. Morbi suipit turpis at massa sodales ultricies. Cur vulputate nibh eu odio suscipit elentum.</p>\r\n','/images/content3.jpg',1);

--
-- Table structure for table `Collection_409`
--

CREATE TABLE `Collection_409` (
  `Collection_409_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_409_1` int(11) DEFAULT NULL,
  `Collection_409_2` int(11) DEFAULT NULL,
  `Collection_409_3` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_409_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_409`
--

INSERT INTO `Collection_409` VALUES (1,560,3,1),(2,560,2,2),(3,560,1,3);

--
-- Table structure for table `Collection_410`
--

CREATE TABLE `Collection_410` (
  `Collection_410_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_410_1` varchar(254) DEFAULT NULL,
  `Collection_410_2` int(11) DEFAULT NULL,
  `Collection_410_3` text,
  `Collection_410_4` varchar(254) DEFAULT NULL,
  `Collection_410_5` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_410_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_410`
--

INSERT INTO `Collection_410` VALUES (1,'Quote 1',1,'Pureti doeducer rudocpuo scede munduce agonsd. doed rudouo scede munduce agonsd.','Johnson Controls','John Tompson'),(2,'Quote 2',1,'Pureti doeducer rudocpuo scede munduce agonsd. doed rudouo scede munduce agonsd.','Lorem Ipsum','Dolor Imet');

--
-- Table structure for table `Collection_411`
--

CREATE TABLE `Collection_411` (
  `Collection_411_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_411_1` int(11) DEFAULT NULL,
  `Collection_411_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_411_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_411`
--

INSERT INTO `Collection_411` VALUES (4,561,2),(3,561,1);

--
-- Table structure for table `Collection_412`
--

CREATE TABLE `Collection_412` (
  `Collection_412_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_412_1` varchar(254) DEFAULT NULL,
  `Collection_412_2` int(11) DEFAULT NULL,
  `Collection_412_3` varchar(254) DEFAULT NULL,
  `Collection_412_4` text,
  `Collection_412_5` int(11) DEFAULT NULL,
  `Collection_412_6` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_412_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_412`
--

INSERT INTO `Collection_412` VALUES (1,' Uses Light To Clean',1,'/images/l1.png','Aliquam nec tincidunt tellus, in imperdiet est. Fuse leo orci, lacinia a velit sed, eleifend susct augue. Duam nec tincunt tellus.',1,20),(2,' Cleans Windows',1,'/images/l2.png','Aliquam nec tincidunt tellus, in imperdiet est. Fuse leo orci, lacinia a velit sed, eleifend susct augue. Duam nec tincunt tellus.',NULL,NULL),(3,' Saves Time',1,'/images/l3.png','Aliquam nec tincidunt tellus, in imperdiet est. Fuse leo orci, lacinia a velit sed, eleifend susct augue. Duam nec tincunt tellus.',NULL,NULL),(4,' Purifies the Air',1,'/images/l4.png','Aliquam nec tincidunt tellus, in imperdiet est. Fuse leo orci, lacinia a velit sed, eleifend susct augue. Duam nec tincunt tellus.',NULL,NULL),(5,'One Step',1,'/images/l5.png','Aliquam nec tincidunt tellus, in imperdiet est. Fuse leo orci, lacinia a velit sed, eleifend susct augue. Duam nec tincunt tellus.',NULL,NULL),(6,' Any Fabric an Air Cleaner',1,'/images/l6.png','Aliquam nec tincidunt tellus, in imperdiet est. Fuse leo orci, lacinia a velit sed, eleifend susct augue. Duam nec tincunt tellus.',1,10);

--
-- Table structure for table `Collection_413`
--

CREATE TABLE `Collection_413` (
  `Collection_413_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_413_1` int(11) NOT NULL,
  `Collection_413_2` int(11) NOT NULL,
  `Collection_413_3` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_413_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_413`
--

INSERT INTO `Collection_413` VALUES (1,561,6,10),(2,561,2,20),(3,561,4,30),(4,561,3,40),(5,561,1,50),(6,561,5,60);

--
-- Table structure for table `Collection_414`
--

CREATE TABLE `Collection_414` (
  `Collection_414_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_414_1` varchar(254) DEFAULT NULL,
  `Collection_414_2` int(11) DEFAULT NULL,
  `Collection_414_3` bigint(20) DEFAULT NULL,
  `Collection_414_4` varchar(254) DEFAULT NULL,
  `Collection_414_5` text,
  PRIMARY KEY (`Collection_414_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_414`
--

INSERT INTO `Collection_414` VALUES (1,'Hertz',1,10,'/images/desktop/logo1.png','http://www.hertz.com'),(2,'Hertz 2',1,40,'/images/desktop/logo1.png','http://www.hertz.com'),(3,'HWKN',1,20,'/images/desktop/logo2.png','http://www.hwkn.com'),(4,'Johnson Controls',1,30,'/images/desktop/logo3.png','http://www.johnson-controls.com');

--
-- Table structure for table `Collection_415`
--

CREATE TABLE `Collection_415` (
  `Collection_415_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_415_1` int(11) DEFAULT NULL,
  `Collection_415_2` int(11) DEFAULT NULL,
  `Collection_415_3` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_415_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_415`
--

INSERT INTO `Collection_415` VALUES (1,10,1,10),(2,10,2,20),(3,11,1,10),(4,11,2,20),(5,12,1,10),(6,12,2,20);

--
-- Table structure for table `Collection_416`
--

CREATE TABLE `Collection_416` (
  `Collection_416_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_416_1` varchar(254) DEFAULT NULL,
  `Collection_416_2` int(11) DEFAULT NULL,
  `Collection_416_3` bigint(20) DEFAULT NULL,
  `Collection_416_4` varchar(254) DEFAULT NULL,
  `Collection_416_5` text,
  `Collection_416_6` text,
  `Collection_416_7` varchar(254) DEFAULT NULL,
  `Collection_416_8` varchar(254) DEFAULT NULL,
  `Collection_416_9` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_416_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_416`
--

INSERT INTO `Collection_416` VALUES (1,'Manufactures',1,10,'/images/htab1.jpg','Reque ut, sagittis nuncated toe bedo.','Aliquam nec tincidunt tellus, in imperdiet est. Fusce leo orci, lacinia a velit sed, eleifend susct augue. Aliquam nec tincidunt tellus, in imperdiet est. Fusce le orci, lacinia a velit sed, eleifend suscipit augue. Aliquam nec do.','Read More','/link1.html',1),(2,'Architecture',1,20,'/images/htab1.jpg','Architecture','Aliquam nec tincidunt tellus, in imperdiet est. Fusce leo orci, lacinia a velit sed, eleifend susct augue. Aliquam nec tincidunt tellus, in imperdiet est. Fusce le orci, lacinia a velit sed, eleifend suscipit augue. Aliquam nec do.','Learn More','/link2.html',2),(3,'Hospitality',1,30,'/images/htab1.jpg','Hospitality','Aliquam nec tincidunt tellus, in imperdiet est. Fusce leo orci, lacinia a velit sed, eleifend susct augue. Aliquam nec tincidunt tellus, in imperdiet est. Fusce le orci, lacinia a velit sed, eleifend suscipit augue. Aliquam nec do.','Learn More','/link2.html',2),(4,'Healthcare',1,40,'/images/htab1.jpg','Healthcare','Aliquam nec tincidunt tellus, in imperdiet est. Fusce leo orci, lacinia a velit sed, eleifend susct augue. Aliquam nec tincidunt tellus, in imperdiet est. Fusce le orci, lacinia a velit sed, eleifend suscipit augue. Aliquam nec do.','Learn More','/link2.html',2),(5,'Property Management',1,60,'/images/htab1.jpg','Property Management','Aliquam nec tincidunt tellus, in imperdiet est. Fusce leo orci, lacinia a velit sed, eleifend susct augue. Aliquam nec tincidunt tellus, in imperdiet est. Fusce le orci, lacinia a velit sed, eleifend suscipit augue. Aliquam nec do.','Learn More','/link2.html',2);

--
-- Table structure for table `Collection_417`
--

CREATE TABLE `Collection_417` (
  `Collection_417_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_417_1` varchar(254) DEFAULT NULL,
  `Collection_417_2` varchar(254) DEFAULT NULL,
  `Collection_417_3` text,
  `Collection_417_4` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_417_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Collection_417`
--


--
-- Table structure for table `Collection_5`
--

CREATE TABLE `Collection_5` (
  `Collection_5_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_5_1` int(11) DEFAULT NULL,
  `Collection_5_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_5_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_5`
--


--
-- Table structure for table `Collection_50`
--

CREATE TABLE `Collection_50` (
  `Collection_50_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_50_1` varchar(254) DEFAULT NULL,
  `Collection_50_2` varchar(254) DEFAULT NULL,
  `Collection_50_3` varchar(254) DEFAULT NULL,
  `Collection_50_4` varchar(254) DEFAULT NULL,
  `Collection_50_5` varchar(254) DEFAULT NULL,
  `Collection_50_6` bigint(20) DEFAULT NULL,
  `Collection_50_7` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_50_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_50`
--

INSERT INTO `Collection_50` VALUES (4,'Sample Video','/content/videos/video_50_2_4.flv','/content/videos/video_50_3_4.flv','/content/videos/video_50_4_4.jpg','/content/videos/video_50_5_4.jpg',1228848408,'on');

--
-- Table structure for table `Collection_6`
--

CREATE TABLE `Collection_6` (
  `Collection_6_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_6_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_6_2` varchar(254) NOT NULL DEFAULT '',
  PRIMARY KEY (`Collection_6_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_6`
--

INSERT INTO `Collection_6` VALUES (1,'Collection Preview Module','collection_preview.php'),(2,'Collections Profile','collections.php'),(3,'Collection Settings Profile','collection_settings.php'),(4,'Collection Admin','collection.php'),(5,'Dashboard','dashboard.php'),(10,'Email Profile','EmailProfile.php'),(9,'Collection Templates Module','collection_templates.php'),(11,'Execute Code','ExecuteProfile.php'),(12,'Collection Reports Profile','collection_reports.php'),(13,'Collection Workflows','collection_workflows.php'),(14,'Collection List Preview','collection_list_preview.php');

--
-- Table structure for table `Collection_60`
--

CREATE TABLE `Collection_60` (
  `Collection_60_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_60_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_60_2` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_60_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_60`
--

INSERT INTO `Collection_60` VALUES (1,'My Blog Topic 1',1),(2,'My Blog Topic 2',2);

--
-- Table structure for table `Collection_61`
--

CREATE TABLE `Collection_61` (
  `Collection_61_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_61_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_61_2` int(11) NOT NULL DEFAULT '0',
  `Collection_61_3` text NOT NULL,
  `Collection_61_4` text,
  `Collection_61_5` bigint(20) DEFAULT NULL,
  `Collection_61_6` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_61_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_61`
--

INSERT INTO `Collection_61` VALUES (1,'Nullam posuere tristique tortor. In bibendum.',1,'<div class=\"body\">\r\n<p>Aliquam risus justo, mollis in, laoreet a, consectetuer nec, risus. Nunc blandit sodales lacus. Nam luctus semper mi. In eu diam. Phasellus rutrum elit vel nisi. Cras mauris nulla, egestas quis, cursus at, venenatis ac, ante. Fusce accumsan enim et arcu. Duis sagittis libero at lacus. Suspendisse lacinia nulla eget urna.</p>\r\n<ul>\r\n    <li>Tristique</li>\r\n    <li>Aenean</li>\r\n    <li>Pretium</li>\r\n</ul>\r\n<p>In hac habitasse platea dictumst. Duis porttitor. Sed vulputate elementum nisl. Vivamus et mi at arcu mattis iaculis. Nullam posuere tristique tortor. In bibendum. Aenean ornare, nunc eget pretium porttitor, sem est pretium leo, non euismod nulla dui non diam. Pellentesque dictum faucibus leo. Vestibulum ac ante. Sed in est. Sed sodales nisl sit amet augue. Donec ultrices, augue ullamcorper posuere laoreet, turpis massa tristique justo, sed egestas metus magna sed purus. Fusce eleifend, dui ut posuere auctor, justo elit posuere sapien, at blandit enim quam fringilla mi.</p>\r\n</div>\r\n<p>In hac habitasse platea dictumst. Duis porttitor. Sed vulputate elementum nisl. Vivamus et mi at arcu mattis iaculis. Nullam posuere tristique tortor. In bibendum. Aenean ornare, nunc eget pretium porttitor, sem est pretium leo, non euismod nulla dui non diam. Pellentesque dictum faucibus leo. Vestibulum ac ante. Sed in est. Sed sodales nisl sit amet augue. Donec ultrices, augue ullamcorper posuere laoreet, turpis massa tristique justo, sed egestas metus magna sed purus. Fusce eleifend, dui ut posuere auctor, justo elit posuere sapien, at blandit enim quam fringilla mi.</p>','\r\n\r\nAliquam risus justo, mollis in, laoreet a, consectetuer nec, risus. Nunc blandit sodales lacus. Nam luctus semper mi. In eu diam. Phasellus rutrum elit vel nisi. Cras mauris nulla, egestas quis, cursus at, venenatis ac, ante. Fusce accumsan enim et arcu. Duis sagittis libero at lacus. Suspendisse lacinia nulla eget urna.  \r\n\r\n    \r\n-  Tristique  \r\n-  Aenean  \r\n-  Pretium  \r\n\r\n\r\n\r\nIn hac habitasse platea dictumst. Duis porttitor. Sed vulputate elementum nisl. Vivamus et mi at arcu mattis iaculis. Nullam posuere tristique tortor. In bibendum. Aenean ornare, nunc eget pretium porttitor, sem est pretium leo, non euismod nulla dui non diam. Pellentesque dictum faucibus  ...',1239899307,1);

--
-- Table structure for table `Collection_62`
--

CREATE TABLE `Collection_62` (
  `Collection_62_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_62_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_62_2` text NOT NULL,
  `Collection_62_3` int(11) DEFAULT NULL,
  `Collection_62_4` int(11) DEFAULT NULL,
  `Collection_62_5` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_62_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_62`
--

INSERT INTO `Collection_62` VALUES (1,'In hac habitasse platea dictumst. Duis porttitor','Vestibulum ac ante. Sed in est. Sed sodales nisl sit amet augue. \r\nDonec ultrices, augue ullamcorper posuere laoreet, turpis massa tristique justo. \r\nSed egestas metus magna sed purus.',1,1,1239899556),(2,'Sed sodales nisl sit amet augue. ','Sed vulputate elementum nisl. \r\nVivamus et mi at arcu mattis iaculis. Nullam posuere tristique tortor. \r\nIn bibendum.',1,1,1239899584);

--
-- Table structure for table `Collection_7`
--

CREATE TABLE `Collection_7` (
  `Collection_7_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_7_1` int(11) DEFAULT NULL,
  `Collection_7_2` int(11) DEFAULT NULL,
  PRIMARY KEY (`Collection_7_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_7`
--

INSERT INTO `Collection_7` VALUES (70,1,10),(69,1,6),(68,1,5),(67,1,9),(66,1,3),(65,1,4),(64,1,1),(63,1,2),(71,1,11);

--
-- Table structure for table `Collection_8`
--

CREATE TABLE `Collection_8` (
  `Collection_8_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_8_1` varchar(254) NOT NULL DEFAULT '',
  `Collection_8_2` int(11) DEFAULT NULL,
  `Collection_8_3` varchar(254) DEFAULT NULL,
  `Collection_8_4` varchar(254) DEFAULT NULL,
  `Collection_8_5` text,
  `Collection_8_6` int(11) DEFAULT NULL,
  `Collection_8_7` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_8_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_8`
--

INSERT INTO `Collection_8` VALUES (2,'Users',NULL,NULL,NULL,NULL,NULL,2),(44,'Events',1,'&id=236','',NULL,11,50),(4,'System Settings',1,'&id=12&eid=1','',NULL,11,90),(5,'Dashboard',5,NULL,NULL,NULL,NULL,1),(6,'Site Users',1,'&id=1',NULL,NULL,2,NULL),(18,'Files',1,'&id=381','',NULL,17,12),(11,'Manage',NULL,NULL,NULL,NULL,NULL,3),(12,'All Content',1,'&id=13','',NULL,11,10),(13,'Pages',1,'&id=17','',NULL,11,20),(14,'User Groups',1,'&id=2',NULL,NULL,2,NULL),(15,'Collections',2,NULL,NULL,NULL,17,NULL),(16,'Admin Menu',1,'&id=8',NULL,NULL,17,NULL),(17,'System Modules',NULL,NULL,NULL,NULL,NULL,4),(22,'News',1,'&id=274','',NULL,11,60),(45,'Files Types',1,'&id=383','',NULL,17,13),(24,'Site Menu',1,'&id=276',NULL,NULL,11,7),(34,'Page Content',1,'&id=13&CollectionColumns[]=13-3&CollectionOperators[]=1&CFilterSelValue[]=1&CFilterTxtValue[]=&st=&Search=Apply+Filter&FilterSave=0&FilterName=','',NULL,11,1),(27,'Download Google Sitemap',11,'&collectionid=8&colid=5',NULL,'require_once \'MDB2.php\';\r\n	$db = MDB2::factory(DSN);\r\n    $db->setFetchMode(MDB2_FETCHMODE_ASSOC); \r\n    $db->setOption(\'portability\', MDB2_PORTABILITY_NONE);\r\n    $db->loadModule(\'Extended\');\r\n	\r\n	$CID = 276;\r\n	$CollectionTableName = \'Collection_\'.$CID;\r\n	//get the rotator name and nav browser info\r\n	$SQL = \"SELECT $CollectionTableName.*  FROM  $CollectionTableName WHERE 1 \";\r\n	$Pages = $db->queryAll($SQL);\r\n	foreach ($Pages as $k => $v)\r\n	{\r\n		foreach ($v as $kk => $vv)\r\n		{\r\n			$Pages[$k][$kk] = utf8_encode(htmlspecialchars ($vv));\r\n		}\r\n	}\r\n	\r\n	//we need to get news pages\r\n	$News[][\'Link\'] = \'/news/\';\r\n	$News[][\'Link\'] = \'/news/archives/\';\r\n	\r\n	$SQL = \"SELECT Collection_273.*  FROM  Collection_273 WHERE 1 \";\r\n	$NewsCategories = $db->queryAll($SQL);\r\n	if ($NewsCategories)\r\n	{\r\n		foreach ($NewsCategories as $k => $v)\r\n		{\r\n			$News[][\'Link\'] = \'/news/\'.$v[\'Collection_273_ID\'].\"/\";\r\n		}\r\n	}\r\n	\r\n	$SQL = \"SELECT Collection_275.* , Collection_274.*  FROM  Collection_274 INNER JOIN Collection_275 ON Collection_275_1 = Collection_274_ID WHERE 1  Group By Collection_274_ID \";\r\n	$NewsArticles = $db->queryAll($SQL);\r\n	if ($NewsArticles)\r\n	{\r\n		foreach ($NewsArticles as $k => $v)\r\n		{\r\n			$News[][\'Link\'] = \'/news/\'.$v[\'Collection_275_2\'].\"/\".$v[\'Collection_274_ID\'].\"/\";\r\n		}\r\n	}\r\n	\r\n	//we get the events\r\n	$SQL = \"SELECT Collection_236.*  FROM  Collection_236 WHERE 1 \";\r\n	$Events = $db->queryAll($SQL);\r\n	\r\n	//we get the events\r\n	$SQL = \"SELECT Collection_303.*  FROM  Collection_303 WHERE 1 \";\r\n	$Extra = $db->queryAll($SQL);\r\n	\r\n	\r\n		$filename = \'sitemap.xml\';\r\n		header(\"Content-type: text/xml\");\r\n        header(\"Content-Disposition: attachment; filename=\\\"$filename\\\"\");\r\n        header(\"Expires: 0\");\r\n        header(\"Cache-Control: must-revalidate, post-check=0,pre-check=0\");\r\n        header(\"Pragma: public\");\r\n	\r\n	$smarty->assign(\"Extra\", $Extra);\r\n	$smarty->assign(\"Events\", $Events);\r\n	$smarty->assign(\"News\", $News);\r\n	$smarty->assign(\"Pages\", $Pages);\r\n	$smarty->display(\'pagesXML.html\');\r\n',17,NULL),(28,'Front End Menu Tree',1,'&id=38',NULL,NULL,17,NULL),(35,'Bulk Page Add',11,'&menu_id=5&module_id=11&collectionid=90&colid=2&nd=1',NULL,NULL,17,1000),(36,'Homepage Rotator',1,'&id=304',NULL,NULL,11,40),(50,'Homepage Tabs',1,'&id=416','',NULL,11,42),(40,'Content that needs looked at',1,'&id=400&gs=&st=Collection_400_5+is+null&Search=Apply+Filter&FilterSave=0&FilterName=&&eid=2',NULL,NULL,11,-3),(41,'CM - Upload Site Map',11,'&menu_id=8&module_id=11&collectionid=90&colid=2&nd=1','',NULL,17,900),(42,'CM - Migrate Content',11,'&menu_id=10&module_id=11&collectionid=90&colid=2&nd=1','',NULL,17,910),(46,'Content Adlets',1,'&id=408','',NULL,11,11),(47,'Quotes',1,'&id=410','',NULL,11,13),(48,'Content Benefits',1,'&id=412','',NULL,11,12),(49,'Notables',1,'&id=414','',NULL,11,130),(51,'Request Info',1,'&id=417','',NULL,11,11000);

--
-- Table structure for table `Collection_80`
--

CREATE TABLE `Collection_80` (
  `Collection_80_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_80_1` varchar(254) DEFAULT NULL,
  `Collection_80_2` bigint(20) DEFAULT NULL,
  `Collection_80_3` varchar(254) DEFAULT NULL,
  `Collection_80_4` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`Collection_80_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_80`
--

INSERT INTO `Collection_80` VALUES (1,'Site Gallery',1,'on','/images/gallery/image-1.jpg'),(4,'Small Gallery',2,'on','/images/gallery/image-2.jpg');

--
-- Table structure for table `Collection_81`
--

CREATE TABLE `Collection_81` (
  `Collection_81_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_81_1` varchar(254) DEFAULT NULL,
  `Collection_81_2` varchar(254) DEFAULT NULL,
  `Collection_81_3` varchar(254) DEFAULT NULL,
  `Collection_81_4` varchar(254) DEFAULT NULL,
  `Collection_81_5` int(11) DEFAULT NULL,
  `Collection_81_6` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_81_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_81`
--

INSERT INTO `Collection_81` VALUES (35,'Photo 1','/content/galleryphotos/eagle-stock-image-1.jpg','/content/galleryphotos/eagle-stock-image.jpg','Photo 1',1,NULL),(36,'Photo 2','/content/galleryphotos/photo_81_2_36.jpg','/content/galleryphotos/photo_81_3_36.jpg','Photo 2',1,NULL),(37,'Photo 3','/content/galleryphotos/photo_81_2_37.jpg','/content/galleryphotos/photo_81_3_37.jpg','Photo 3',1,NULL),(38,'Photo 4','/content/galleryphotos/photo_81_2_38.jpg','/content/galleryphotos/photo_81_3_38.jpg','Photo 4',1,NULL),(39,'Photo 5','/content/galleryphotos/photo_81_2_39.jpg','/content/galleryphotos/photo_81_3_39.jpg','Photo 5',1,NULL),(40,'Photo 6','/content/galleryphotos/photo_81_2_40.jpg','/content/galleryphotos/photo_81_3_40.jpg','Photo 6',1,NULL),(41,'Photo 7','/content/galleryphotos/photo_81_2_41.jpg','/content/galleryphotos/photo_81_3_41.jpg','Photo 7',1,NULL),(42,'Photo 8','/content/documents/quiz-widget.jpg','/content/documents/tnail-quiz-widget.jpg','Photo 8',1,NULL);

--
-- Table structure for table `Collection_89`
--

CREATE TABLE `Collection_89` (
  `Collection_89_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_89_1` varchar(254) DEFAULT NULL,
  `Collection_89_2` bigint(20) DEFAULT NULL,
  `Collection_89_3` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_89_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_89`
--

INSERT INTO `Collection_89` VALUES (1,'Event Main Image',200,150),(2,'Event Small Image',80,80);

--
-- Table structure for table `Collection_9`
--

CREATE TABLE `Collection_9` (
  `Collection_9_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_9_1` varchar(254) DEFAULT NULL,
  `Collection_9_2` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Collection_9_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_9`
--

INSERT INTO `Collection_9` VALUES (1,'Content',1),(2,'System',100),(3,'Media',7),(4,'Shopping Cart',10),(5,'Site Forms',8),(6,'Settings',90);

--
-- Table structure for table `Collection_90`
--

CREATE TABLE `Collection_90` (
  `Collection_90_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Collection_90_1` varchar(254) DEFAULT NULL,
  `Collection_90_2` text,
  PRIMARY KEY (`Collection_90_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Collection_90`
--

INSERT INTO `Collection_90` VALUES (1,'Copy Collection Row','$CollectionID = $_GET[\'cid\'];\r\n$rowId = $_GET[\'rowid\'];\r\n$queryString = $_GET[\'querystring\'];\r\n\r\n$admin = false; \r\nif($_SESSION[\'FrontEndAdmin\'] == 1)\r\n{\r\n	$admin = true;\r\n}\r\n\r\nif(!$admin && !$api->CanUserAccess($_SESSION[\'AAuserid\'],  $CollectionID, $rowId))\r\n{\r\n		header(\'Location: admin.php?copy=0&\'.urldecode($queryString).\'eid=\'.$rowId.\'\');\r\n}\r\nelse\r\n{\r\n\r\n$selectedRow = $api-> getCollectionSingleRow (array(\'collection_id\' =>$CollectionID , \'row_id\' => $rowId));\r\nunset($selectedRow[$api->_getCollectionFieldName($CollectionID, \'ID\')]);\r\n\r\n$PUAccess = array();\r\n$RowUserAccess = $api->selectCollectionUserGroupAccessRow($CollectionID, $rowId);\r\nforeach ($RowUserAccess as $key => $value)\r\n{  \r\n	$PUAccess[$value[\'UserGroupId\']] = $value[\'UserGroupId\'];\r\n}\r\n\r\n$NewRowID = $api->insertCollectionRow_($CollectionID, $selectedRow , \'\' , \'\');\r\n$api->updateCollectionUserGroupAccessRow($CollectionID, $NewRowID, $PUAccess, $_SESSION[\'AAuserid\']);\r\n\r\n\r\nheader(\'Location: admin.php?copy=1&\'.urldecode($queryString).\'eid=\'.$NewRowID.\'\');\r\n\r\n}\r\n\r\ndie();\r\n'),(2,'Delete All Collection Rows','$CollectionID = $_GET[\'cid\'];\r\n$queryString = $_GET[\'querystring\'];\r\n\r\n$admin = false; \r\nif($_SESSION[\'FrontEndAdmin\'] == 1)\r\n{\r\n	$admin = true;\r\n}\r\n\r\n$selectedRow = $api-> getCollectionSingleRow (array(\'collection_id\' => 4, \'row_id\' => $CollectionID));\r\n$columnName = $api->_getCollectionFieldName(4, \'2\');\r\n\r\nif ($selectedRow[$columnName] == \'on\')\r\n{\r\n	header(\'Location: admin.php?systemerase=1&\'.urldecode($queryString));\r\n	die();\r\n}\r\n\r\nif(!$admin && !$api->CanUserAccess($_SESSION[\'AAuserid\'],  4, $CollectionID))\r\n{\r\n		header(\'Location: admin.php?erase=0&\'.urldecode($queryString));\r\n		die();\r\n}\r\nelse\r\n{\r\n\r\n$queryArray = array(\'collection_id\'=>$CollectionID);\r\n	\r\n	if(!$admin)\r\n	{\r\n		$queryArray[\'userId\']=$_SESSION[\'AAuserid\'];\r\n	}\r\n	\r\n	$table = $api->Filter($queryArray);\r\n	\r\n	$NumResults = count($table[\'AllResults\']);\r\n\r\n	$columnName = $api->_getCollectionFieldName($CollectionID, \'ID\');\r\n	$collectionSettings  = $api->getCollectionSettings($CollectionID);\r\n	$taxonomy = $api->getCollectionTaxonomy($CollectionID);\r\n	\r\n	foreach ($table[\'Results\'] as $k => $v)\r\n	{\r\n		$did = $v[$columnName];\r\n				\r\n		$args = array(  \'CollectionID\' => $CollectionID ,\r\n							\'ApplyFor\' => 3 , //admin front end\r\n							\'UserID\' => $user_id ,\r\n							\'SuperAdminUser\' => $admin ,\r\n							\'SubmittedData\' => $_POST ,\r\n							\'ExtraGetParams\' => $_GET ,\r\n							\'CollectionSettings\' => $collectionSettings ,\r\n							\'CollectionTaxonomy\' => $taxonomy ,\r\n							\'UploadDirectory\'  => $UploadDirectory ,\r\n							\'UploadPrefix\'  => $UploadPrefix ,\r\n							\'Smarty\'  => $smarty ,\r\n							\'DeleteID\' => intval($did),\r\n							\'OverrideWorkflowIDs\'=> array(0=>6)\r\n						 );	\r\n						 \r\n		$WorkFlowReturnArray = $api -> Workflow ( $args );				 	\r\n		\r\n	}\r\n\r\n\r\n}\r\n\r\nheader(\'Location: admin.php?erase=1&\'.urldecode($queryString));\r\ndie();'),(3,'Script to delete All entries from a Shopping Cart','require_once(\"MDB2.php\");\r\n$db = MDB2::factory(DSN);\r\n $db->setFetchMode(MDB2_FETCHMODE_ASSOC); \r\n $db->setOption(\'portability\', MDB2_PORTABILITY_NONE);\r\n $db->loadModule(\'Extended\');\r\nforeach ($_POST[\'deleteCollectionIDs\'] as $k => $v)\r\n{\r\n	$q = \"DELETE FROM Collection_\" . $v .\" WHERE Collection_\".$v.\"_\". $_POST[\'deleteFieldIDs\'][$k] .\" = \".$_POST[\'deleteFieldValues\'][$k].\" \";\r\n	$db->query($q);\r\n}\r\n\r\n$q = \"DELETE FROM Collection_\" . $_POST[\'parentCollectionID\'] .\" WHERE Collection_\".$_POST[\'parentCollectionID\'].\"_ID = \".$_POST[\'parentID\'] .\" \";\r\n$db->query($q);\r\n	\r\n	header(\'Location: \'. $_POST[\'originalURL\']);\r\n	die();'),(4,'Collection Fields JS Array','$CollectionID = $_GET[\'cid\'];\r\n$taxonomy = $api->getCollectionTaxonomyOrdered($CollectionID);\r\n\r\nforeach ($taxonomy  as $record)\r\n{\r\n	echo \"fields[\".$record[\"CollectionFieldId\"].\"] = \'\".str_replace(\"\'\",\"\\\'\",$record[\"CollectionFieldName\"]) .\"\';\";\r\n}\r\n\r\n'),(5,'Site Builder Macro','include $_SERVER[\'DOCUMENT_ROOT\'].\'/classes/PHPExcel/PHPExcel.php\';\r\ninclude $_SERVER[\'DOCUMENT_ROOT\'].\'/classes/PHPExcel/PHPExcel/Reader/Excel2007.php\';\r\n\r\n$errors = array();\r\n\r\nif ($_POST[\'acceptanduploaddata\'] == 1)\r\n{\r\n				\r\n		foreach ($_POST[\'importRow\'] as $k => $v)\r\n		{\r\n		if ($_POST[\'pageAdd\'][$k] == 1)\r\n		{\r\n			 $externalLink = intval($_POST[\'ExternalURL\'][$k]);\r\n			 \r\n			 if ( $externalLink == 0)\r\n			 {\r\n			 		//we check to see if we add the page or not\r\n					$q = \"SELECT * FROM Collection_17 WHERE Collection_17_3 = \'\".addslashes($_POST[\'PageFileName\'][$k]).\"\'\";\r\n					$res = $dbh->query($q);\r\n					\r\n					if ($res->numRows() == 0)\r\n					{\r\n								\r\n								if ($_POST[\'ContentNumeric\'][$k] == 1)\r\n								{\r\n										//we add the content based on an already created content\r\n										$q  = \"SELECT * FROM Collection_13 WHERE Collection_13_ID = \'\".$_POST[\'ContentToUse\'][$k].\"\'\";\r\n										$res = $dbh->query($q);\r\n										$row = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n										\r\n										$block_column_values = array(\r\n												\'Collection_13_1\' => \'CNT - \' . $_POST[\'PageName\'][$k],\r\n												\'Collection_13_2\' => \'\',\r\n												\'Collection_13_3\' => $row[\'Collection_13_3\'],\r\n												\'Collection_13_4\' => $row[\'Collection_13_4\'],\r\n												\'Collection_13_6\' => $row[\'Collection_13_6\'],\r\n												\'Collection_13_7\' => date(time()),\r\n												\'Collection_13_8\' => $row[\'Collection_13_8\'],\r\n												\'Collection_13_9\' => $row[\'Collection_13_9\']				\r\n										);\r\n										\r\n								}\r\n								else\r\n								{\r\n								\r\n										$CUSE = $_POST[\'ContentToUse\'][$k];\r\n										$CNT = html_entity_decode($_POST[\'CData\'.$CUSE]);\r\n										\r\n										$block_column_values = array(\r\n												\'Collection_13_1\' => \'CNT - \' . $_POST[\'PageName\'][$k],\r\n												\'Collection_13_2\' => \'\',\r\n												\'Collection_13_3\' => 1,\r\n												\'Collection_13_4\' => 1,\r\n												\'Collection_13_6\' => $CNT,\r\n												\'Collection_13_7\' => date(time()),\r\n												\'Collection_13_8\' => NULL,\r\n												\'Collection_13_9\' => NULL			\r\n										);\r\n								\r\n								}\r\n								\r\n								$ThisPageContentID = $api->insertCollectionRow_(13, $block_column_values , \'\' , \'\');\r\n								//$api -> insertCollectionUserGroupAccessRow(13, $ThisPageContentID, $ugroups, $UserID);\r\n								\r\n								//we add the actual page\r\n								$page_column_values = array(\r\n										\'Collection_17_1\' => \'CNT - \' . $_POST[\'PageName\'][$k],\r\n										\'Collection_17_2\' => $_POST[\'PageName\'][$k],\r\n										\'Collection_17_3\' => $_POST[\'PageFileName\'][$k],\r\n										\'Collection_17_4\' => 1,\r\n										\'Collection_17_5\' => $_POST[\'TemplateToUse\'][$k],\r\n										\'Collection_17_6\' => $ThisPageContentID,\r\n										\'Collection_17_7\' => \'\',\r\n										\'Collection_17_8\' => \'\',\r\n										\'Collection_17_9\' => date(time()),\r\n										\'Collection_17_10\' => \'on\'				\r\n								);\r\n								\r\n								$ThisPageID = $api->insertCollectionRow_(17, $page_column_values , \'\' , \'\');\r\n								//$api -> insertCollectionUserGroupAccessRow(17, $ThisPageID, $ugroups, $UserID);\r\n								\r\n					}//end add page\r\n			 \r\n			 }\r\n			 \r\n			 $TheParentPageName = $_POST[\'ParentPageName\'][$k];\r\n			 \r\n			 if ($TheParentPageName == \'\')\r\n			 {\r\n			 	$ParentID = NULL;\r\n			 }\r\n			 else\r\n			 {\r\n			 	$q = \"SELECT * FROM Collection_276 WHERE Collection_276_1 = \'\".addslashes($TheParentPageName).\"\'\";\r\n				$res = $dbh->query($q);\r\n				\r\n				if ($res->numRows() == 0)\r\n				{\r\n						$ParentID = NULL;\r\n				}\r\n				else\r\n				{\r\n						$row = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n						$ParentID = $row[\'Collection_276_ID\'];\r\n						\r\n				}\r\n				\r\n			 }\r\n			 \r\n			 $sortorder = 0;\r\n			 \r\n			 if ($ParentID == NULL)\r\n			 {\r\n			 		$q= \"SELECT * FROM Collection_276 WHERE Collection_276_7 IS NULL OR Collection_276_7 = \'\' Order By Collection_276_3 DESC\";			 \r\n			 }\r\n			 else\r\n			 {\r\n			 		$q= \"SELECT * FROM Collection_276 WHERE Collection_276_7 = \'\".$ParentID.\"\' Order By Collection_276_3 DESC\";\r\n			 }\r\n			 \r\n			 		$res = $dbh->query($q);\r\n					if($res->numRows() == 0)\r\n					{\r\n						$sortorder = 1;\r\n					}\r\n					else\r\n					{\r\n						$row = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n						$sortorder = intval($row[\'Collection_276_3\']) + 10;\r\n					}\r\n			 \r\n			 \r\n			 //time to add the site menu item\r\n			 $site_column_values = array(\r\n										\'Collection_276_1\' => $_POST[\'PageName\'][$k],\r\n										\'Collection_276_2\' => $_POST[\'PageURL\'][$k],\r\n										\'Collection_276_3\' => $sortorder,\r\n										\'Collection_276_4\' => \'on\',\r\n										\'Collection_276_5\' => NULL,\r\n										\'Collection_276_6\' => $_POST[\'PageNewWindow\'][$k],\r\n										\'Collection_276_7\' => $ParentID,\r\n										\'Collection_276_8\' => NULL,\r\n										\'Collection_276_9\' => NULL			\r\n								);\r\n			 $ThisSitePageID = $api->insertCollectionRow_(276, $site_column_values , \'\' , \'\');\r\n			//$api -> insertCollectionUserGroupAccessRow(276, $ThisSitePageID, $ugroups, $UserID);\r\n			\r\n		}//end if page and site menu add\r\n		}//end foreach import\r\n		\r\n		header(\'Location: /\'.ADMIN_APP_DIR.\'/admin.php?menu_id=6&module_id=11&collectionid=90&colid=2&nd=1\');\r\n		die();\r\n}\r\n\r\n//we check to see if we have something to upload\r\nif ($_POST[\'uploadexcelfile\'] == 1)\r\n{\r\n		$error = $_FILES[\"excelfile\"][\"error\"];\r\n		\r\n		if ($error == UPLOAD_ERR_OK ) {\r\n		\r\n					$fileName = $_FILES[\"excelfile\"][\"tmp_name\"];\r\n					\r\n					$inputFileType = PHPExcel_IOFactory::identify($fileName);\r\n					\r\n					if ($inputFileType == \'Excel2007\')\r\n					{\r\n				\r\n								$objReader = new PHPExcel_Reader_Excel2007();\r\n								$objReader->setReadDataOnly(true);\r\n								$objPHPExcel = $objReader->load($fileName);\r\n								\r\n								//$locatedSheet = $objPHPExcel->getSheetByName(\'ContentSheet\');\r\n								\r\n								//get the first sheet and start looping through the results\r\n								$ImportedData = array();\r\n								\r\n								$objWorksheet 		= $objPHPExcel->getActiveSheet();\r\n								$highestRow 		= $objWorksheet->getHighestRow(); // e.g. 10\r\n								$highestColumn 		= $objWorksheet->getHighestColumn(); // e.g \'F\'\r\n								$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); // e.g. 5\r\n								\r\n								//we skpi the first row\r\n								$firstRow = 2;\r\n								\r\n								for ($row = $firstRow; $row <= $highestRow; ++$row) {\r\n			 \r\n					 					$rowArray = array();\r\n										$rowArray[\'PageName\'] = $objWorksheet->getCellByColumnAndRow(0, $row)->getValue();\r\n										$rowArray[\'ParentPageName\'] = $objWorksheet->getCellByColumnAndRow(1, $row)->getValue();\r\n										$rowArray[\'PageURL\'] = $objWorksheet->getCellByColumnAndRow(2, $row)->getValue();\r\n										$rowArray[\'PageNewWindow\'] = $objWorksheet->getCellByColumnAndRow(3, $row)->getValue();\r\n										$rowArray[\'Content\'] = $objWorksheet->getCellByColumnAndRow(4, $row)->getValue();\r\n										$rowArray[\'Template\'] = $objWorksheet->getCellByColumnAndRow(5, $row)->getValue();\r\n										\r\n										$ImportedData[] = $rowArray;\r\n										\r\n								}//end loop through		\r\n					 \r\n								\r\n								if (count($ImportedData) == 0)\r\n								{\r\n									$errors[] = \"There is nothing to import. Please check the excel file.\";\r\n								}\r\n								else\r\n								{\r\n										\r\n										$Contents = array();\r\n										$ActContents = array();\r\n										\r\n										$TmpImportedData = $ImportedData;\r\n										\r\n										//we make a first loop to see if we have the required contents and templates\r\n										foreach ($ImportedData as $k => $v)\r\n										{\r\n												if (is_numeric($v[\'Content\']))\r\n												{\r\n														$ImportedData[$k][\'ContentNumeric\'] = 1;\r\n														$q= \"SELECT * FROM Collection_13 WHERE Collection_13_ID = \".$v[\'Content\'];\r\n														$res = $dbh->query($q);\r\n														if ($res->numRows() == 0)\r\n														{\r\n																$ImportedData[$k][\'Errors\'][] =  \'The content with id \' . $v[\'Content\'] . \' does not exist.\';\r\n																$Contents[$v[\'Content\']] = 0;\r\n																$ImportedData[$k][\'Issues\'] = 1;\r\n														}\r\n														else\r\n														{\r\n																$Contents[$v[\'Content\']] = 1;\r\n														}\r\n												}\r\n												else\r\n												{\r\n														$ImportedData[$k][\'ContentNumeric\'] = 0;\r\n														if ($v[\'Content\'] != \'\')\r\n														{\r\n																	//we look for the sheet\r\n																	$locatedSheet = $objPHPExcel->getSheetByName($v[\'Content\']);\r\n																	$contentforsheet = \'\';\r\n																	if ($locatedSheet)\r\n																		$contentforsheet = $locatedSheet->getCellByColumnAndRow(0, 1)->getValue();\r\n																	\r\n																	if ($contentforsheet != \'\')\r\n																	{\r\n																		$Contents[$v[\'Content\']] = 1;\r\n																		$ActContents[$v[\'Content\']] = htmlentities($contentforsheet);\r\n																	}\r\n																	else\r\n																	{\r\n																		$ImportedData[$k][\'Errors\'][] =  \'There is no sheet named \' . $v[\'Content\'] . \' or the right cell on this sheet is not filled with content.\';\r\n																		$Contents[$v[\'Content\']] = 0;\r\n																		$ImportedData[$k][\'Issues\'] = 1;\r\n																	}\r\n														}\r\n														\r\n												}\r\n												\r\n												if (is_numeric($v[\'Template\']))\r\n												{\r\n														$q= \"SELECT * FROM Collection_13 WHERE Collection_13_ID = \".$v[\'Template\'];\r\n														$res = $dbh->query($q);\r\n														if ($res->numRows() == 0)\r\n														{\r\n																$ImportedData[$k][\'Template\'] = 1;\r\n														}\r\n														else\r\n														{\r\n																\r\n														}\r\n												}\r\n												else\r\n												{\r\n														if ($v[\'Content\'] != \'\')\r\n														{\r\n															$ImportedData[$k][\'Template\'] = 1;\r\n														}	\r\n														\r\n												}\r\n												\r\n												\r\n												//we need to know if the url is external or internal\r\n												$urlData = parse_url($v[\'PageURL\']);\r\n												\r\n												if (isset($urlData[\'host\']))\r\n												{\r\n														$ImportedData[$k][\'ExternalURL\'] = 1;\r\n												}\r\n												else\r\n												{\r\n														$ImportedData[$k][\'ExternalURL\'] = 0;\r\n												}\r\n												\r\n												\r\n												if (isset($urlData[\'path\']) && !isset($urlData[\'host\']))\r\n												{\r\n														//internal link\r\n														if ($urlData[\'path\'] == \'/\')\r\n														{\r\n															$pageFileName = \'index\';\r\n														}\r\n														else\r\n														{\r\n																//remove the  first slash\r\n																$pageFileName = substr($urlData[\'path\'], 1);\r\n																$pageFileNameDetails = pathinfo ($urlData[\'path\']);\r\n																$pageFileName = substr($pageFileName, 0 , -( strlen($pageFileNameDetails[\'extension\']) + 1 ) );\r\n														}		\r\n														\r\n														//check to see if we have a page with that filename\r\n														$q = \"SELECT * FROM Collection_17 WHERE Collection_17_3 = \'\".addslashes($pageFileName).\"\'\";\r\n														$res = $dbh->query($q);\r\n														\r\n														$ImportedData[$k][\'PageAlreadyExists\'] = 0;\r\n														\r\n														if ($res->numRows() > 0)\r\n														{\r\n																$row = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n																$ImportedData[$k][\'PageAlreadyExists\'] = 1;\r\n																$ImportedData[$k][\'Issues\'] = 1;\r\n																$ImportedData[$k][\'Errors\'][] = \'There is a page with that filename already created on the site. You can still add the page, but only a site menu item will be added. <a href=\"/\'.ADMIN_APP_DIR.\'/admin.php?menu_id=13&module_id=1&id=17&eid=\'.$row[\'Collection_17_ID\'].\'\" target=\"_blank\">See Page</a>\';\r\n														}\r\n														\r\n														//check if the site menu link exists but only for internal links\r\n														$q = \"SELECT * FROM Collection_276 WHERE Collection_276_2 = \'\".addslashes($v[\'PageURL\']).\"\'\";\r\n														$res = $dbh->query($q);\r\n														\r\n														if ($res->numRows() > 0)\r\n														{\r\n																$row = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n																$ImportedData[$k][\'Issues\'] = 1;\r\n																$ImportedData[$k][\'Errors\'][] = \'There is a site menu link with that URL already created on the site. You can still add the site menu, but there can be issues with the site menu having duplicate URLs. <a href=\"/\'.ADMIN_APP_DIR.\'/admin.php?menu_id=13&module_id=1&id=276&eid=\'.$row[\'Collection_276_ID\'].\'\" target=\"_blank\">See Site Menu</a>\';\r\n														}\r\n														\r\n																												\r\n														$ImportedData[$k][\'PageFileName\'] = $pageFileName;\r\n														\r\n														//we check the page filename for duplicates\r\n														$found  = 0;\r\n														for ($i = 0; $i < $k; $i++)\r\n														{\r\n																if ($ImportedData[$i][\'PageFileName\'] == $pageFileName)\r\n																{\r\n																		$found = 1;\r\n																}\r\n														}\r\n														\r\n														if ($found == 1)\r\n														{\r\n																$ImportedData[$k][\'Errors\'][] = \'There is another row in this excel file that will use the same page. Only a site menu entry will be created. The page will be created upon adding the previous row with the same file name.\';\r\n														}\r\n														\r\n														\r\n												}\r\n												else\r\n												{\r\n														if (!isset($urlData[\'host\']))\r\n														{\r\n															$ImportedData[$k][\'Issues\'] = 1;\r\n															$ImportedData[$k][\'Errors\'][] = \'The page url does not seem to be okay, please correct and reupload.\';\r\n														}	\r\n												}\r\n												\r\n												//we check the parents to be okay $TmpImportedData\r\n												if ($v[\'ParentPageName\'] != \'\')\r\n												{\r\n														$found  = 0;\r\n														for ($i = 0; $i < $k; $i++)\r\n														{\r\n																if ($TmpImportedData[$i][\'PageName\'] == $v[\'ParentPageName\'])\r\n																{\r\n																		$found = 1;\r\n																}\r\n														}\r\n														\r\n														if ($found == 0)\r\n														{\r\n															$q = \"SELECT * FROM Collection_276 WHERE Collection_276_1 = \'\".addslashes($v[\'ParentPageName\']).\"\'\";\r\n															$res = $dbh->query($q);\r\n														\r\n															if ($res->numRows() > 0)\r\n															{\r\n																	$found = 1;\r\n																	$ImportedData[$k][\'Errors\'][] = \'This page does not have this parent page in the current excel file, but it is found in the current site menu tree configuration.\';\r\n															}\r\n														\r\n														}\r\n														\r\n														if ($found == 0)\r\n														{\r\n																$ImportedData[$k][\'Issues\'] = 1;\r\n																$ImportedData[$k][\'Errors\'][] = \'The parent page can´t be found. Please make sure that the parent page lives in a row above this row we are testing.\';\r\n														}\r\n												\r\n												}\r\n\r\n												\r\n										\r\n										}//end foreach loop\r\n										\r\n										\r\n										$smarty->assign(\'ImportedData\'		, $ImportedData);\r\n										$smarty->assign(\'ActContents\'		, $ActContents);\r\n										$smarty->assign(\'Contents\'			, $Contents);\r\n										\r\n										\r\n								}//end if we have something to import		\r\n								\r\n								\r\n								\r\n					}\r\n					else\r\n					{\r\n							$errors[] = \"The uploaded file type has to be in Excel2007 format.\";\r\n					}			//end if file type is not good\r\n					\r\n					\r\n					\r\n		\r\n		\r\n		}\r\n		else\r\n		{\r\n				$errors[] = \"There was a problem with the upload. Please try again.\";\r\n		\r\n		}//end if upload error\r\n\r\n}\r\n\r\n\r\n\r\n$smarty->assign(\'errors\',$errors);\r\n\r\n$page = array (\r\n			\"PageTitle\"    => \"Site Builder Macro\"\r\n 		);\r\n$smarty->assign(\"page\",$page);\r\n$smarty->display(ADMIN_APP_DIR.\'/site-builder-macro.html\');'),(6,'Site Builder Macro - Done','$page = array (\r\n			\"PageTitle\"    => \"Site Builder Macro - Done\"\r\n 		);\r\n$smarty->assign(\"page\",$page);\r\n$smarty->display(ADMIN_APP_DIR.\'/site-builder-macro-done.html\');'),(7,'DropboxStorage Access Token Set','$DropboxInfo = $api->getRowById(390 , intval($_GET[\'dboxid\']));\r\n\r\ninclude_once $_SERVER[\'DOCUMENT_ROOT\'].\'/classes/StorageDropbox/src/Dropbox/autoload.php\';\r\n\r\n$oauth = new Dropbox_OAuth_PEAR($DropboxInfo[\'Collection_390_3\'],$DropboxInfo[\'Collection_390_4\']);\r\nprint_r($_SESSION);\r\n$dropbox = new Dropbox_API($oauth);\r\n\r\n$oauth->setToken($_SESSION[\'oauth_tokens\']);\r\n\r\n$tokens = $oauth->getAccessToken();\r\n\r\n$q = \"UPDATE Collection_390 SET Collection_390_6 = \'\".addslashes($tokens[\'token\']).\"\' WHERE Collection_390_ID = \'\".intval($_GET[\'dboxid\']).\"\'\";\r\n$dbh->query($q);\r\n\r\n$q = \"UPDATE Collection_390 SET Collection_390_7 = \'\".addslashes($tokens[\'token_secret\']).\"\' WHERE Collection_390_ID = \'\".intval($_GET[\'dboxid\']).\"\'\";\r\n$dbh->query($q);\r\n\r\nheader(\'Location: /\'.ADMIN_APP_DIR.\'/admin.php?module_id=1&action=update&id=390&&eid=\'.intval($_GET[\'dboxid\']));\r\ndie();'),(8,'Content For Client Macro','include $_SERVER[\'DOCUMENT_ROOT\'].\'/classes/PHPExcel/PHPExcel.php\';\r\ninclude $_SERVER[\'DOCUMENT_ROOT\'].\'/classes/PHPExcel/PHPExcel/Reader/Excel2007.php\';\r\n\r\n$errors = array();\r\n\r\nif ($_POST[\'acceptanduploaddata\'] == 1)\r\n{\r\n		\r\n		$q = \"TRUNCATE TABLE Collection_400\";\r\n		$res = $dbh->query($q);\r\n				\r\n		$parentIDs = array();\r\n		\r\n		foreach ($_POST[\'importRow\'] as $k => $v)\r\n		{\r\n				\r\n				\r\n				$addArray = array();\r\n				\r\n				$addArray[\'Collection_400_1\'] = $_POST[\'PageName\'][$v];\r\n				$addArray[\'Collection_400_4\'] = ucwords(strtolower($_POST[\'PageName\'][$v]));\r\n				$addArray[\'Collection_400_3\'] = $_POST[\'pageActTemplate\'][$v];\r\n				\r\n				$addArray[\'Collection_400_2\'] = NULL;\r\n				\r\n				if (intval($_POST[\'ParentPageID\'][$v]) > 0)\r\n				{\r\n							$addArray[\'Collection_400_2\'] = $parentIDs[$_POST[\'ParentPageID\'][$v]];\r\n				}\r\n				\r\n				$ThisSitePageID = $api->insertCollectionRow_(400, $addArray , \'\' , \'\');\r\n				\r\n				$parentIDs[$v] = $ThisSitePageID;\r\n		\r\n		}//end foreach\r\n		\r\n		\r\n		header(\'Location: /\'.ADMIN_APP_DIR.\'/admin.php?module_id=1&action=update&id=400\');\r\n		die(\'\');\r\n}\r\n\r\n//we check to see if we have something to upload\r\nif ($_POST[\'uploadexcelfile\'] == 1)\r\n{\r\n		$error = $_FILES[\"excelfile\"][\"error\"];\r\n		\r\n		\r\n		\r\n		if ($error == UPLOAD_ERR_OK ) {\r\n		\r\n					$fileName = $_FILES[\"excelfile\"][\"tmp_name\"];\r\n					\r\n					$inputFileType = PHPExcel_IOFactory::identify($fileName);\r\n					$Level = 0;\r\n					$Counter = 0;\r\n					$Stack = array();\r\n					\r\n					$q = \"SELECT * FROM Collection_403 WHERE 1\";			\r\n					$res= $dbh->query($q);\r\n					\r\n					$Templates = array();\r\n					while ($row = $res->fetchRow(MDB2_FETCHMDOE_ASSOC))\r\n					{\r\n							$Templates[$row[\'Collection_403_4\']] = $row[\'Collection_403_ID\'];\r\n					}//end while\r\n					\r\n					\r\n					if ($inputFileType == \'Excel2007\')\r\n					{\r\n				\r\n								$objReader = new PHPExcel_Reader_Excel2007();\r\n								$objReader->setReadDataOnly(true);\r\n								$objPHPExcel = $objReader->load($fileName);\r\n								\r\n								//$locatedSheet = $objPHPExcel->getSheetByName(\'ContentSheet\');\r\n								\r\n								//get the first sheet and start looping through the results\r\n								$ImportedData = array();\r\n								\r\n								$objWorksheet 		= $objPHPExcel->getActiveSheet();\r\n								$highestRow 		= $objWorksheet->getHighestRow(); // e.g. 10\r\n								$highestColumn 		= $objWorksheet->getHighestColumn(); // e.g \'F\'\r\n								$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); // e.g. 5\r\n								\r\n								\r\n								\r\n								//we skpi the first row\r\n								$firstRow = 2;\r\n								\r\n								for ($row = $firstRow; $row <= $highestRow; ++$row) {\r\n			 \r\n					 					$TheLevel = 0;\r\n										$CellValue = \'\';\r\n										while ($TheLevel <= $highestColumnIndex)\r\n										{\r\n											$CellValue = $objWorksheet->getCellByColumnAndRow($TheLevel, $row)->getValue();\r\n											if ($CellValue != \'\')\r\n											{\r\n													break;\r\n											}\r\n											$TheLevel++;\r\n										}\r\n										\r\n																			\r\n										\r\n										if ($CellValue != \'\' )\r\n										{\r\n											\r\n																			\r\n											$rowArray = array();\r\n											$rowArray[\'PageName\'] = $CellValue;\r\n											\r\n											//we need to search one more cell further to see if we have the type of page stored\r\n											$tmpTheLevel = $TheLevel + 1;\r\n											$PageType = $objWorksheet->getCellByColumnAndRow($tmpTheLevel, $row)->getValue();\r\n											\r\n											if ($PageType == \'\')\r\n											{\r\n													//we need to assign manually the level\r\n													if ($TheLevel == 0)\r\n													{\r\n															$PageType = \'HOME\';\r\n													}\r\n													else\r\n													{\r\n															if ($TheLevel == 1)\r\n															{\r\n																	$PageType = \'LANDER\';\r\n															}\r\n															else\r\n															{\r\n																	$PageType = \'CONTENT\';\r\n															}\r\n													}\r\n											}//end if finding the page type\r\n											\r\n											$rowArray[\'Template\'] = $PageType;\r\n											\r\n											if ($TheLevel == 1 || $TheLevel == 0)\r\n											{\r\n													$rowArray[\'ParentPageName\'] = \'\';\r\n													$TheLevel = 1;\r\n											}\r\n											else\r\n											{\r\n													$tmpTheLevel = $TheLevel - 1;\r\n													\r\n													$rowArray[\'ParentPage\'] = $Stack[$tmpTheLevel];\r\n													$rowArray[\'ParentPageName\'] = $ImportedData[$Stack[$tmpTheLevel]][\'PageName\'];\r\n											\r\n											}//end if the level is 1 or 2\r\n										\r\n																					\r\n										$ImportedData[$Counter] = $rowArray;\r\n										\r\n										//the next row can only have this item as the parent\r\n										$Stack[$TheLevel] = $Counter;\r\n										\r\n										$Counter++;\r\n										\r\n										\r\n										\r\n										\r\n										}//end if cell value is empty and we need to skip the row\r\n										\r\n								}//end loop through		\r\n								\r\n								\r\n								\r\n								if (count($ImportedData) == 0)\r\n								{\r\n									$errors[] = \"There is nothing to import. Please check the excel file.\";\r\n								}\r\n								else\r\n								{\r\n										foreach ($ImportedData as $k => $v)\r\n										{\r\n												//we need to check if we have a template\r\n												$q = \"SELECT * FROM Collection_403 WHERE Collection_403_4 = \'\". addslashes($v[\'Template\']) . \"\'\";\r\n												$res = $dbh->query($q);\r\n												\r\n												if ($res->numRows() == 0)\r\n												{\r\n														$ImportedData[$k][\'Errors\'][] = \'This item does not have a valid template. The file should be edited and reuploaded.\';\r\n												}\r\n											\r\n										}\r\n										\r\n										$smarty->assign(\'ImportedData\'		, $ImportedData);\r\n										$smarty->assign(\'Templates\'			, $Templates);\r\n										\r\n								}//end if we have something to import		\r\n								\r\n								\r\n								\r\n					}\r\n					else\r\n					{\r\n							$errors[] = \"The uploaded file type has to be in Excel2007 format.\";\r\n					}			//end if file type is not good\r\n					\r\n					\r\n					\r\n		\r\n		\r\n		}\r\n		else\r\n		{\r\n				$errors[] = \"There was a problem with the upload. Please try again.\";\r\n		\r\n		}//end if upload error\r\n\r\n}\r\n\r\n\r\n\r\n$smarty->assign(\'errors\',$errors);\r\n\r\n$page = array (\r\n			\"PageTitle\"    => \"Initial Content Upload\"\r\n 		);\r\n$smarty->assign(\"page\",$page);\r\n$smarty->display(ADMIN_APP_DIR.\'/site-map-builder-macro.html\');'),(9,'Content For Client Macro - Done','$page = array (\r\n			\"PageTitle\"    => \"Initial Content Upload - Done\"\r\n 		);\r\n$smarty->assign(\"page\",$page);\r\n$smarty->display(ADMIN_APP_DIR.\'/site-map-builder-macro-done.html\');'),(10,'Content Migrate','/*\r\n		Collection 400 is the collection that stores the whole content tree\r\n		Collection 403 is the collection used for defining all the page types\r\n		\r\n*/\r\n\r\n\r\n	\r\n$q = \"SELECT * FROM Collection_400 INNER JOIN Collection_403 ON Collection_403_ID = Collection_400_3 group by Collection_400_ID Order By Collection_400_1\";\r\n$allRows = $dbh->queryAll($q);\r\n\r\n$q = \"SELECT * FROM Collection_403 Order By Collection_403_1\";\r\n$allTemplates = $dbh->queryAll($q);\r\n\r\n$q = \"SELECT * FROM Collection_405 Order By Collection_405_1\";\r\n$allFieldRelations = $dbh->queryAll($q);\r\n\r\n$q = \"SELECT CollectionFieldID , CollectionFieldName FROM CollectionTaxonomy WHERE CollectionID = 13 Order By CollectionSortOrder  \";\r\n$allFieldRelationsContent = $dbh->getAssoc($q);\r\n\r\n$q = \"SELECT CollectionFieldID , CollectionFieldName FROM CollectionTaxonomy WHERE CollectionID = 400 Order By CollectionSortOrder \";\r\n$allFieldRelationsMigration = $dbh->getAssoc($q);\r\n\r\n$smarty->assign(\'allFieldRelations\',$allFieldRelations);\r\n$smarty->assign(\'allFieldRelationsContent\',$allFieldRelationsContent);\r\n$smarty->assign(\'allFieldRelationsMigration\',$allFieldRelationsMigration);\r\n\r\n$smarty->assign(\'allRows\',$allRows);	\r\n$smarty->assign(\'allTemplates\',$allTemplates);\r\n	\r\n$smarty->assign(\'errors\',$errors);\r\n$smarty->assign(\'ourTreeID\',400);\r\n\r\n\r\nif ($_POST[\'migrate\'] == 1)\r\n{\r\n		/* \r\n				we start migrating the content \r\n		*/\r\n		\r\n		 include_once $_SERVER[\"DOCUMENT_ROOT\"] .\"/classes/classTree.php\";\r\n		 $tree 					= new Tree(); \r\n		 $CID 					= 400;\r\n		 $collectionSettings  	= $api ->getCollectionSettings($CID);\r\n		\r\n		 $TreeSettings 			= $collectionSettings[9];\r\n		 $SCID 					= $TreeSettings[\'ParentMenuColumn\'];\r\n		 $DisplayColumn 		= $TreeSettings[\'DisplayColumn\'];\r\n		\r\n		 $tree->setup(\'Collection_\'.$CID , \'Collection_\'.$CID.\'_ID\' , \'Collection_\'.$CID.\'_\'.$DisplayColumn , \'Collection_\'.$CID.\'_\'.$SCID);\r\n		 \r\n		 $rootId = $tree -> getRootID();\r\n		 \r\n		 function getNodePath ($NodeID , $tree)\r\n		 {\r\n		 			$tmpCatId = $NodeID;\r\n					$pathArray = array();\r\n					$pathArray[] = $Node;\r\n					while ( $tmpCatId != $rootId )\r\n					{\r\n							$parentCategories = $tree -> getParentsForNode ($tmpCatId);\r\n										\r\n							if (count($parentCategories) == 0)\r\n							{\r\n								$tmpCatId = $rootId;\r\n							}\r\n							else\r\n							{\r\n								$tmpCatId = $parentCategories[0][\'CategoryID\'];\r\n								$pathArray[] = $tmpCatId;\r\n							}\r\n							\r\n					}\r\n						\r\n							\r\n					$tmp = array();\r\n					$k = 0;\r\n					for ($i = count ($pathArray); $i--; $i>-1)\r\n					{\r\n						$tmp[$k] = $pathArray[$i];\r\n						$k++;\r\n					}\r\n					\r\n					return $tmp;\r\n					\r\n		 }//end function \r\n		 \r\n		 function textToParagraph ($text)\r\n		 {\r\n		 		$t = \"\";\r\n				foreach(preg_split(\"/((\\r?\\n)|(\\r\\n?))/\", $text) as $line){\r\n					// do stuff with $line\r\n					if($line !=\'\')\r\n					$t .= \"<p>\".$line.\"</p>\\n\";\r\n				} \r\n				return $t;\r\n		 }\r\n		 \r\n		/*\r\n				STEP 1\r\n				initialize all variables that we are going to use\r\n				\r\n		*/\r\n		\r\n		$ContentIDs 	= array();\r\n		$PageIDs 		= array();\r\n		$SideMenuIDs 	= array();\r\n		$URLs 			= array();\r\n		$ParentsIDs		= array();\r\n		\r\n		$MigrateFieldName = $api->_getCollectionFieldName(405,2);\r\n		$ContentFieldName = $api->_getCollectionFieldName(405,3);\r\n		\r\n		/*\r\n				STEP 2\r\n				prepare URLs and an array that stores ID and Parent ID\r\n		*/\r\n		\r\n		foreach ($allRows as $k => $v)\r\n		{\r\n				$url 	= preg_replace(\'/[^a-zA-Z0-9\\s\\._\\-]/\', \'\', strtolower($v[\'Collection_400_4\']));\r\n				$url 	= str_replace(\' \',\'-\',$url);\r\n				$url 	= str_replace(\'--\',\'-\',$url);\r\n				\r\n				$URLs[$v[\'Collection_400_ID\']] = $url;\r\n				$ParentsIDs[$v[\'Collection_400_ID\']] = $v[\'Collection_400_2\'];\r\n				\r\n		}//end foreach\r\n		\r\n		foreach ($allTemplates  as $k => $v)\r\n		{\r\n				$Templates[$v[\'Collection_403_ID\']] = $v;\r\n		\r\n		}//end foreach\r\n		/*\r\n				STEP 3\r\n				We need to know if a row has children or not\r\n		*/\r\n		$tmp = array();\r\n		foreach ($ParentsIDs as $k => $v)\r\n		{\r\n				$tmp[intval($v)] = intval($k);\r\n		}//end foreach\r\n		unset($tmp[0]);\r\n		\r\n		$HasChildrenArray = $tmp;\r\n		\r\n		\r\n		/*\r\n				STEP 4\r\n				Loop through all the items and start creating content , pages and site menu items\r\n		*/\r\n		\r\n		\r\n		foreach ($allRows as $k => $v)\r\n		{\r\n				$CreateContent = 1;\r\n				$CreatePage = 1;\r\n				$CreateSiteMenu = 1;\r\n				$PageDuplicate = 0;\r\n				$SiteMenuDuplicate = 0;\r\n				\r\n				$thePath = getNodePath ($v[\'Collection_400_ID\'] , $tree);\r\n				\r\n				$url = \"\";\r\n				\r\n				foreach ($thePath as $kpath => $vpath)\r\n				{\r\n						if ($vpath == \"\")\r\n						{\r\n						\r\n						}\r\n						else\r\n						{\r\n								$url.= \"/\".$URLs[$vpath];\r\n						}\r\n				}\r\n				\r\n				$url.= \"/\".$URLs[$v[\'Collection_400_ID\']];\r\n				\r\n				$urlforpage = substr($url,1);\r\n				\r\n				if ($HasChildrenArray[$v[\'Collection_400_ID\']])\r\n				{\r\n					$url.= \"/\";\r\n				}\r\n				else\r\n				{\r\n					$url.= \".html\";\r\n				}\r\n				\r\n				print \"<h3>\".$v[\'Collection_400_1\'] . \"</h3>\";\r\n				//print_r($thePath);\r\n				//print \"<br/>\".$url . \"<hr/>\";\r\n				\r\n				//there is an exception to this URL creation way\r\n				//if the page type is external link then the URL will be the one that is found inside the first line of the body content field\r\n				if ($v[\'Collection_400_3\'] == 2)\r\n				{\r\n					$url = strtok($v[\'Collection_400_6\'], \"\\n\");\r\n					\r\n					//we will also set the flag to not create content and page\r\n					$CreateContent 		= 0;\r\n					$CreatePage 		= 0;\r\n					\r\n				}	\r\n				\r\n				//if the page type is of home type , then we need the url to be /\r\n				if ($v[\'Collection_400_3\'] == 4)\r\n				{\r\n					$url = \"/\";\r\n					$urlforpage = \"index\";\r\n				}	\r\n				\r\n				\r\n				//before we add, we need to make sure there is no other content that will share the same page url\r\n				//if yes, we will have to update that page / content\r\n				$q = \"SELECT * FROM Collection_17 INNER JOIN Collection_13 ON Collection_13_ID = Collection_17_6 WHERE Collection_17_3 = \'\".$urlforpage.\"\' \";\r\n				$res = $dbh->query($q);\r\n				if ($res->numRows() > 0)\r\n				{\r\n						$PageDuplicate = 1;\r\n						$theDuplicatePage = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n				}		\r\n				\r\n				//we also need to look for a duplicate site menu item\r\n				$q = \"SELECT * FROM Collection_276  WHERE Collection_276_2 = \'\".$url.\"\' \";\r\n				$res = $dbh->query($q);\r\n				if ($res->numRows() > 0)\r\n				{\r\n						$SiteMenuDuplicate = 1;\r\n						$theDuplicateSiteMenu = $res->fetchRow(MDB2_FETCHMODE_ASSOC);\r\n				}		\r\n				\r\n				/*\r\n						WE CREATE THE CONTENT\r\n				*/\r\n				$ContentID = NULL;\r\n				if ($CreateContent == 1)\r\n				{\r\n							$Content = array();\r\n							$Content[\'Collection_13_1\'] = \'CNT - \'. $v[\'Collection_400_1\'];\r\n							\r\n							foreach ($allFieldRelations as $ak =>$av)\r\n							{\r\n									$FN1 = $api->_getCollectionFieldName(13,$av[$ContentFieldName]);\r\n									$FN2 = $api->_getCollectionFieldName(400,$av[$MigrateFieldName]);\r\n									\r\n									//exception\r\n									if ($av[$ContentFieldName] == 6)\r\n									{\r\n										$Content[$FN1] = textToParagraph ($v[$FN2]);\r\n									}\r\n									else\r\n									{\r\n										$Content[$FN1] = $v[$FN2];\r\n									}	\r\n							}//end foreach\r\n							\r\n							\r\n							\r\n							//if there is a special code \r\n							$TemplateCode = $Templates[$v[$api->_getCollectionFieldName(400,3)]][$api->_getCollectionFieldName(403,7)] ;\r\n							if ($TemplateCode != \'\')\r\n							{\r\n									//we need to compile the template and get the content\r\n									$smarty->assign(\'content\',textToParagraph ($v[$api->_getCollectionFieldName(400,6)]));\r\n									$smarty->assign(\'otherContent\', $v);\r\n									$Content[$api->_getCollectionFieldName(13,6)] = $smarty->fetch(\'string:\'.$TemplateCode);\r\n							}\r\n							\r\n							//content fields based on page type\r\n							$Content[\'Collection_13_3\'] = $Templates[$v[$api->_getCollectionFieldName(400,3)]][$api->_getCollectionFieldName(403,6)];\r\n							$Content[\'Collection_13_4\'] = $Templates[$v[$api->_getCollectionFieldName(400,3)]][$api->_getCollectionFieldName(403,5)];\r\n							\r\n							\r\n							\r\n							if ($PageDuplicate == 0)\r\n							{\r\n								$ContentID = $dbh->extended->getBeforeID(\'Collection_13\');\r\n								$dbh-> extended->autoExecute(\'Collection_13\', $Content, MDB2_AUTOQUERY_INSERT);\r\n								$ContentID = $dbh->extended->getAfterID($ContentID, \'Collection_13\');\r\n							}\r\n							else\r\n							{\r\n								$dbh->extended->autoExecute(\'Collection_13\', $Content, MDB2_AUTOQUERY_UPDATE, \' Collection_13_ID = \' . $theDuplicatePage[\'Collection_13_ID\']);	\r\n								$ContentID = $theDuplicatePage[\'Collection_13_ID\'];\r\n							}	\r\n							\r\n							\r\n				}//end if create content\r\n				/*\r\n						WE CREATE THE PAGE\r\n				*/\r\n				if ($CreatePage == 1 && $ContentID != NULL)\r\n				{\r\n						$Page = array();\r\n						$Page[\'Collection_17_1\'] = \'CNT - \'.$v[\'Collection_400_1\'];\r\n						$Page[\'Collection_17_2\'] = $v[\'Collection_400_4\'];\r\n						$Page[\'Collection_17_3\'] = $urlforpage;\r\n						$Page[\'Collection_17_4\'] = 1;\r\n						$Page[\'Collection_17_5\'] = $Templates[$v[$api->_getCollectionFieldName(400,3)]][$api->_getCollectionFieldName(403,2)] ;\r\n						$Page[\'Collection_17_6\'] = $ContentID;\r\n						$Page[\'Collection_17_7\'] = NULL;\r\n						$Page[\'Collection_17_8\'] = NULL;\r\n						$Page[\'Collection_17_9\'] = date(time());\r\n						$Page[\'Collection_17_10\'] = \'on\';\r\n						\r\n						if ($PageDuplicate == 0)\r\n						{\r\n							$PageID = $dbh->extended->getBeforeID(\'Collection_17\');\r\n							$dbh-> extended->autoExecute(\'Collection_17\', $Page, MDB2_AUTOQUERY_INSERT);\r\n							$PageID = $dbh->extended->getAfterID($PageID, \'Collection_17\');\r\n						}\r\n						else\r\n						{\r\n							$dbh->extended->autoExecute(\'Collection_17\', $Page, MDB2_AUTOQUERY_UPDATE, \' Collection_17_ID = \' . $theDuplicatePage[\'Collection_17_ID\']);	\r\n							$PageID = $theDuplicatePage[\'Collection_17_ID\'];\r\n						}	\r\n				\r\n				}//end if\r\n				\r\n				/*\r\n						WE CREATE THE SITE MENU\r\n				*/\r\n				if ($CreateSiteMenu == 1)\r\n				{\r\n						$SiteMenu = array();\r\n						$SiteMenu[\'Collection_276_1\'] = $v[\'Collection_400_4\'];\r\n						$SiteMenu[\'Collection_276_2\'] = $url;\r\n						$SiteMenu[\'Collection_276_3\'] = NULL;\r\n						$SiteMenu[\'Collection_276_4\'] = \'on\';\r\n						$SiteMenu[\'Collection_276_5\'] = NULL;\r\n						$SiteMenu[\'Collection_276_6\'] = NULL;\r\n						$SiteMenu[\'Collection_276_7\'] = NULL;\r\n						$SiteMenu[\'Collection_276_8\'] = NULL;\r\n						$SiteMenu[\'Collection_276_9\'] = NULL;\r\n						\r\n						if ($v[\'Collection_400_3\'] == 2)\r\n						{\r\n							$SiteMenu[\'Collection_276_6\'] = \'on\';\r\n						}\r\n						\r\n						if ($SiteMenuDuplicate == 0 )\r\n						{\r\n							$SiteMenuID = $dbh->extended->getBeforeID(\'Collection_276\');\r\n							$dbh-> extended->autoExecute(\'Collection_276\', $SiteMenu, MDB2_AUTOQUERY_INSERT);\r\n							$SiteMenuID = $dbh->extended->getAfterID($SiteMenuID, \'Collection_276\');\r\n						}\r\n						else\r\n						{\r\n							$SiteMenuID = $theDuplicateSiteMenu[\'Collection_276_ID\'];\r\n							$dbh->extended->autoExecute(\'Collection_276\', $SiteMenu, MDB2_AUTOQUERY_UPDATE, \' Collection_276_ID = \' . $theDuplicateSiteMenu[\'Collection_276_ID\']);	\r\n						}\r\n						\r\n						//we need to store this value so we can create the site menu tree structure a little bit later\r\n						$SideMenuIDs[$v[\'Collection_400_ID\']]  = $SiteMenuID;\r\n				\r\n				}//end if create site menu\r\n				\r\n				\r\n				\r\n				\r\n				\r\n				\r\n		}//end foreach all rows\r\n		\r\n		\r\n		/*\r\n				STEP 5\r\n				Go over the site menu one more time to be able to recreate the content site menu\r\n		*/\r\n		foreach ($allRows as $k => $v)\r\n		{\r\n				$TheID = $v[\'Collection_400_ID\'];\r\n				$TheParentID = $v[\'Collection_400_2\'];\r\n				\r\n				if ($TheParentID > 0)\r\n				{\r\n						$TheSiteMenuID = $SideMenuIDs[$TheID];\r\n						$TheSiteMenuParentID = $SideMenuIDs[$TheParentID];\r\n						\r\n						\r\n						$q = \"UPDATE Collection_276 SET Collection_276_7 = \'\".$TheSiteMenuParentID.\"\' WHERE Collection_276_ID = \'\".$TheSiteMenuID.\"\' \";\r\n						$dbh->query($q);\r\n						\r\n				}\r\n		\r\n		}//end foreach \r\n		\r\n		header(\'Location: /\'.ADMIN_APP_DIR.\'/admin.php?menu_id=11&module_id=11&collectionid=90&colid=2&nd=1\');\r\n		die(\'done\');\r\n\r\n}//end we start migrating the content\r\n\r\n\r\n$page = array (\r\n			\"PageTitle\"    => \"Content Migration\"\r\n 		);\r\n		\r\n		\r\n$smarty->assign(\"page\",$page);\r\n$smarty->display(ADMIN_APP_DIR.\'/site-map-builder-migrate.html\');'),(11,'Content Migrate - Done','$page = array (\r\n			\"PageTitle\"    => \"Content Migrate - Done\"\r\n 		);\r\n$smarty->assign(\"page\",$page);\r\n$smarty->display(ADMIN_APP_DIR.\'/site-map-builder-migrate-done.html\');');

--
