hV6uTEyw

1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jul 15, 2016 at 12:12 PM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `camaleon_shotel`
21--
22CREATE DATABASE IF NOT EXISTS `camaleon_shotel` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
23USE `camaleon_shotel`;
24
25DELIMITER $$
26--
27-- Procedures
28--
29DROP PROCEDURE IF EXISTS `ACTUALIZA_HCINN_HOTELRESERVATION_INVOICE_DETAILS`$$
30CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_HCINN_HOTELRESERVATION_INVOICE_DETAILS`(IN PAR_id int(11),IN PAR_invoiceId int(11),IN PAR_reservationId int(11),IN PAR_descripction varchar(500),IN PAR_status tinyint(11),IN PAR_count int(11),IN PAR_amount float(11),IN PAR_prod_id int(11))
31BEGIN
32 update hcinn_hotelreservation_invoice_details set invoiceId= PAR_invoiceId, reservationId= PAR_reservationId, descripction= PAR_descripction, status= PAR_status, count= PAR_count, amount= PAR_amount, prod_id= PAR_prod_id where id = PAR_id; 
33END$$
34
35DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_ACTIVIDAD`$$
36CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_ACTIVIDAD`(IN PAR_act_id int(11),IN PAR_act_nombre varchar(50),IN PAR_act_fecha date,IN PAR_act_usuario int(11),IN PAR_act_estado tinyint(11),IN PAR_ser_id int(11))
37BEGIN
38 update tbl_actividad set act_nombre= PAR_act_nombre, act_fecha= PAR_act_fecha, act_usuario= PAR_act_usuario, act_estado= PAR_act_estado, ser_id= PAR_ser_id where act_id = PAR_act_id; 
39END$$
40
41DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_AREAS_HOTELES`$$
42CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_AREAS_HOTELES`(IN PAR_arhot_id int(11),IN PAR_arhot_nombre varchar(50),IN PAR_arhot_fecha date,IN PAR_arhot_estado tinyint(11),IN PAR_tiar_id int(11),IN PAR_room_id int(11))
43BEGIN
44 update tbl_areas_hoteles set arhot_nombre= PAR_arhot_nombre, arhot_fecha= PAR_arhot_fecha, arhot_estado= PAR_arhot_estado, tiar_id= PAR_tiar_id, room_id= PAR_room_id where arhot_id = PAR_arhot_id; 
45END$$
46
47DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_AREAS_HOTELES_X_PRODUCTOS`$$
48CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_AREAS_HOTELES_X_PRODUCTOS`(IN PAR_ahpro_id int(11),IN PAR_ahpro_cantidad int(11),IN PAR_ahpro_fecha date,IN PAR_ahpro_estado tinyint(11),IN PAR_prod_id int(11),IN PAR_arhot_id int(11))
49BEGIN
50 update tbl_areas_hoteles_x_productos set ahpro_cantidad= PAR_ahpro_cantidad, ahpro_fecha= PAR_ahpro_fecha, ahpro_estado= PAR_ahpro_estado, prod_id= PAR_prod_id, arhot_id= PAR_arhot_id where ahpro_id = PAR_ahpro_id; 
51END$$
52
53DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_CARGO`$$
54CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_CARGO`(IN PAR_car_id int(11),IN PAR_car_nombre varchar(50),IN PAR_car_fecha date,IN PAR_car_estado tinyint(11),IN PAR_car_usuario int(11))
55BEGIN
56 update tbl_cargo set car_nombre= PAR_car_nombre, car_fecha= PAR_car_fecha, car_estado= PAR_car_estado, car_usuario= PAR_car_usuario where car_id = PAR_car_id; 
57END$$
58
59DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_INTERNO`$$
60CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_INTERNO`(IN PAR_int_id int(11),IN PAR_int_nombre varchar(50),IN PAR_int_apellidos varchar(50),IN PAR_int_identificacion varchar(20),IN PAR_int_telefono varchar(20),IN PAR_int_celular varchar(20),IN PAR_int_email varchar(50),IN PAR_int_fecha date,IN PAR_int_estado tinyint(11),IN PAR_int_usuario int(11),IN PAR_tidoc_id int(11),IN PAR_car_id int(11))
61BEGIN
62 update tbl_interno set int_nombre= PAR_int_nombre, int_apellidos= PAR_int_apellidos, int_identificacion= PAR_int_identificacion, int_telefono= PAR_int_telefono, int_celular= PAR_int_celular, int_email= PAR_int_email, int_fecha= PAR_int_fecha, int_estado= PAR_int_estado, int_usuario= PAR_int_usuario, tidoc_id= PAR_tidoc_id, car_id= PAR_car_id where int_id = PAR_int_id; 
63END$$
64
65DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_INTERNO_X_ACTIVIDAD`$$
66CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_INTERNO_X_ACTIVIDAD`(IN PAR_intact_id int(11),IN PAR_intact_fecha date,IN PAR_intact_estado tinyint(11),IN PAR_intact_realizado tinyint(11),IN PAR_intact_realizado_fecha datetime,IN PAR_intact_confirmado tinyint(11),IN PAR_intact_confirmado_fecha datetime,IN PAR_intact_observacion varchar(500),IN PAR_act_id int(11),IN PAR_intarho_id int(11))
67BEGIN
68 update tbl_interno_x_actividad set intact_fecha= PAR_intact_fecha, intact_estado= PAR_intact_estado, intact_realizado= PAR_intact_realizado, intact_realizado_fecha= PAR_intact_realizado_fecha, intact_confirmado= PAR_intact_confirmado, intact_confirmado_fecha= PAR_intact_confirmado_fecha, intact_observacion= PAR_intact_observacion, act_id= PAR_act_id, intarho_id= PAR_intarho_id where intact_id = PAR_intact_id; 
69END$$
70
71DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_INTERNO_X_AREAS_HOTELES`$$
72CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_INTERNO_X_AREAS_HOTELES`(IN PAR_intarho_id int(11),IN PAR_intarho_fecha_inicial date,IN PAR_intarho_fecha_final date,IN PAR_intarho_estado tinyint(11),IN PAR_int_id int(11),IN PAR_arhot_id int(11))
73BEGIN
74 update tbl_interno_x_areas_hoteles set intarho_fecha_inicial= PAR_intarho_fecha_inicial, intarho_fecha_final= PAR_intarho_fecha_final, intarho_estado= PAR_intarho_estado, int_id= PAR_int_id, arhot_id= PAR_arhot_id where intarho_id = PAR_intarho_id; 
75END$$
76
77DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_LAVANDERIA`$$
78CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_LAVANDERIA`(IN `PAR_lav_id` INT(11), IN `PAR_lav_fecha_llegada` DATE, IN `PAR_lav_fecha_salida` VARCHAR(15), IN `PAR_prod_id` INT(11), IN `PAR_int_id` INT(11), IN `PAR_lav_estado` TINYINT(11))
79BEGIN
80
81if PAR_lav_fecha_salida = '0' then
82	set PAR_lav_fecha_salida = null;
83end if;
84
85
86update tbl_lavanderia set lav_fecha_llegada= PAR_lav_fecha_llegada, lav_fecha_salida= PAR_lav_fecha_salida, prod_id= PAR_prod_id, int_id= PAR_int_id, lav_estado= PAR_lav_estado where lav_id = PAR_lav_id; 
87END$$
88
89DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_MENSAJES`$$
90CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_MENSAJES`(IN PAR_msg_id int(11),IN PAR_msg_fecha date,IN PAR_msg_visto tinyint(11),IN PAR_msg_mensaje varchar(500),IN PAR_intarho_id int(11))
91BEGIN
92 update tbl_mensajes set msg_fecha= PAR_msg_fecha, msg_visto= PAR_msg_visto, msg_mensaje= PAR_msg_mensaje, intarho_id= PAR_intarho_id where msg_id = PAR_msg_id; 
93END$$
94
95DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_PRODUCTOS`$$
96CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_PRODUCTOS`(IN PAR_prod_id int(11),IN PAR_prod_nombre varchar(50),IN PAR_prod_valor decimal(11),IN PAR_prod_fecha date,IN PAR_prod_estado tinyint(11),IN PAR_tip_id tinyint(11))
97BEGIN
98 update tbl_productos set prod_nombre= PAR_prod_nombre, prod_valor= PAR_prod_valor, prod_fecha= PAR_prod_fecha, prod_estado= PAR_prod_estado, tip_id= PAR_tip_id where prod_id = PAR_prod_id; 
99END$$
100
101DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_SERVICIOS`$$
102CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_SERVICIOS`(IN PAR_ser_id int(11),IN PAR_ser_nombre varchar(50),IN PAR_ser_fecha date,IN PAR_ser_usuario int(11),IN PAR_ser_estado tinyint(11))
103BEGIN
104 update tbl_servicios set ser_nombre= PAR_ser_nombre, ser_fecha= PAR_ser_fecha, ser_usuario= PAR_ser_usuario, ser_estado= PAR_ser_estado where ser_id = PAR_ser_id; 
105END$$
106
107DROP PROCEDURE IF EXISTS `ACTUALIZA_TBL_TIPO_DOCUMENTO`$$
108CREATE DEFINER=`root`@`localhost` PROCEDURE `ACTUALIZA_TBL_TIPO_DOCUMENTO`(IN PAR_tidoc_id int(11),IN PAR_tidoc_nombre varchar(50),IN PAR_tidoc_fecha date,IN PAR_car_estado tinyint(11),IN PAR_tidoc_usuario int(11))
109BEGIN
110 update tbl_tipo_documento set tidoc_nombre= PAR_tidoc_nombre, tidoc_fecha= PAR_tidoc_fecha, car_estado= PAR_car_estado, tidoc_usuario= PAR_tidoc_usuario where tidoc_id = PAR_tidoc_id; 
111END$$
112
113DROP PROCEDURE IF EXISTS `CONSULTA_HCINN_HOTELRESERVATION_INVOICE_DETAILS`$$
114CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_HCINN_HOTELRESERVATION_INVOICE_DETAILS`(IN PAR_id int(11))
115BEGIN
116 SELECT id,invoiceId,reservationId,descripction,status,count,amount,prod_id FROM hcinn_hotelreservation_invoice_details WHERE id = PAR_id; 
117END$$
118
119DROP PROCEDURE IF EXISTS `CONSULTA_TBL_ACTIVIDAD`$$
120CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_ACTIVIDAD`(IN PAR_act_id int(11))
121BEGIN
122 SELECT act_id,act_nombre,act_fecha,act_usuario,act_estado,ser_id FROM tbl_actividad WHERE act_id = PAR_act_id; 
123END$$
124
125DROP PROCEDURE IF EXISTS `CONSULTA_TBL_ACTIVIDADPorSer_id`$$
126CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_ACTIVIDADPorSer_id`(IN PAR_ser_id int(11))
127BEGIN
128 SELECT
129act_id,act_nombre,act_fecha,act_usuario,act_estado,ser_id
130FROM tbl_actividad WHERE ser_id = PAR_ser_id; 
131END$$
132
133DROP PROCEDURE IF EXISTS `CONSULTA_TBL_AREAS_HOTELES`$$
134CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_AREAS_HOTELES`(IN `PAR_arhot_id` INT(11))
135BEGIN
136 SELECT arhot_id,arhot_nombre,arhot_fecha,arhot_estado,tiar_id,room_id FROM tbl_areas_hoteles WHERE arhot_id = PAR_arhot_id; 
137END$$
138
139DROP PROCEDURE IF EXISTS `CONSULTA_TBL_AREAS_HOTELESPorTiar_id`$$
140CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_AREAS_HOTELESPorTiar_id`(IN `PAR_tiar_id` INT(11))
141BEGIN
142 SELECT
143	arhot_id,
144	arhot_nombre,
145	arhot_fecha,
146	arhot_estado,
147	tiar.tiar_id,
148	room.room_id,
149	room.room_name,
150	case arhot_estado when 1 then 'Activo' else 'Inactivo' end as estado,
151	tiar.tiar_nombre
152FROM tbl_areas_hoteles arhot
153left join hcinn_hotelreservation_rooms room on room.room_id = arhot.room_id
154inner join tbl_tipo_areas tiar on tiar.tiar_id = arhot.tiar_id
155
156WHERE arhot.tiar_id = PAR_tiar_id; 
157END$$
158
159DROP PROCEDURE IF EXISTS `CONSULTA_TBL_AREAS_HOTELES_X_PRODUCTOSPorArhot_id`$$
160CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_AREAS_HOTELES_X_PRODUCTOSPorArhot_id`(IN PAR_arhot_id int(11))
161BEGIN
162 
163	SELECT
164		coalesce(ahpro_id,0) as ahpro_id,
165		coalesce(ahpro_cantidad,1) as ahpro_cantidad,
166		ahpro_fecha,
167		ahpro_estado,
168		prod.prod_id,
169		prod.prod_nombre,
170		prod.prod_valor,
171		arhot_id,
172		concat(coalesce(ahpro_id,0),':',prod.prod_id) as id,
173		case coalesce(ahpro_id,0) when 0 then 'false' else 'true' end as seleccionar
174	FROM 
175	tbl_productos prod
176	left join tbl_areas_hoteles_x_productos ahpro on prod.prod_id = ahpro.prod_id and arhot_id = PAR_arhot_id and ahpro_estado = 1
177	where prod.prod_estado = 1
178;
179END$$
180
181DROP PROCEDURE IF EXISTS `CONSULTA_TBL_AREAS_HOTELES_X_PRODUCTOSPorProd_id`$$
182CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_AREAS_HOTELES_X_PRODUCTOSPorProd_id`(IN PAR_prod_id int(11))
183BEGIN
184 SELECT
185ahpro_id,ahpro_cantidad,ahpro_fecha,ahpro_estado,prod_id,arhot_id
186FROM tbl_areas_hoteles_x_productos WHERE prod_id = PAR_prod_id; 
187END$$
188
189DROP PROCEDURE IF EXISTS `CONSULTA_TBL_CARGO`$$
190CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_CARGO`(IN PAR_car_id int(11))
191BEGIN
192 SELECT car_id,car_nombre,car_fecha,car_estado,car_usuario FROM tbl_cargo WHERE car_id = PAR_car_id; 
193END$$
194
195DROP PROCEDURE IF EXISTS `CONSULTA_TBL_INTERNO`$$
196CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_INTERNO`(IN PAR_int_id int(11))
197BEGIN
198 SELECT int_id,int_nombre,int_apellidos,int_identificacion,int_telefono,int_celular,int_email,int_fecha,int_estado,int_usuario,tidoc_id,car_id FROM tbl_interno WHERE int_id = PAR_int_id; 
199END$$
200
201DROP PROCEDURE IF EXISTS `CONSULTA_TBL_INTERNOPorCar_id`$$
202CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_INTERNOPorCar_id`(IN `PAR_car_id` INT(11))
203BEGIN
204 SELECT
205int_id, concat( int_nombre,' ',int_apellidos ) as int_nombrecompleto,int_identificacion,int_telefono,int_celular,int_email,int_fecha,int_estado,int_usuario,tidoc_id,car_id
206FROM tbl_interno 
207WHERE car_id = PAR_car_id
208and int_estado = 1
209; 
210END$$
211
212DROP PROCEDURE IF EXISTS `CONSULTA_TBL_INTERNOPorTidoc_id`$$
213CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_INTERNOPorTidoc_id`(IN PAR_tidoc_id int(11))
214BEGIN
215 SELECT
216int_id,int_nombre,int_apellidos,int_identificacion,int_telefono,int_celular,int_email,int_fecha,int_estado,int_usuario,tidoc_id,car_id
217FROM tbl_interno WHERE tidoc_id = PAR_tidoc_id; 
218END$$
219
220DROP PROCEDURE IF EXISTS `CONSULTA_TBL_INTERNO_X_ACTIVIDADPorAct_id`$$
221CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_INTERNO_X_ACTIVIDADPorAct_id`(IN PAR_act_id int(11))
222BEGIN
223 SELECT
224intact_id,intact_fecha,intact_estado,intact_realizado,intact_realizado_fecha,intact_confirmado,intact_confirmado_fecha,intact_observacion,act_id,intarho_id
225FROM tbl_interno_x_actividad WHERE act_id = PAR_act_id; 
226END$$
227
228DROP PROCEDURE IF EXISTS `CONSULTA_TBL_INTERNO_X_AREAS_HOTELESPorArhot_id`$$
229CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_INTERNO_X_AREAS_HOTELESPorArhot_id`(IN PAR_arhot_id int(11))
230BEGIN
231 SELECT
232intarho_id,intarho_fecha_inicial,intarho_fecha_final,intarho_estado,int_id,arhot_id
233FROM tbl_interno_x_areas_hoteles WHERE arhot_id = PAR_arhot_id; 
234END$$
235
236DROP PROCEDURE IF EXISTS `CONSULTA_TBL_LAVANDERIA`$$
237CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_LAVANDERIA`(IN PAR_lav_id int(11))
238BEGIN
239 SELECT lav_id,lav_fecha_llegada,lav_fecha_salida,prod_id,int_id,lav_estado FROM tbl_lavanderia WHERE lav_id = PAR_lav_id; 
240END$$
241
242DROP PROCEDURE IF EXISTS `CONSULTA_TBL_LAVANDERIAPorProd_id`$$
243CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_LAVANDERIAPorProd_id`(IN PAR_prod_id int(11))
244BEGIN
245 SELECT
246lav_id,lav_fecha_llegada,lav_fecha_salida,prod_id,int_id,lav_estado
247FROM tbl_lavanderia WHERE prod_id = PAR_prod_id; 
248END$$
249
250DROP PROCEDURE IF EXISTS `CONSULTA_TBL_MENSAJES`$$
251CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_MENSAJES`(IN PAR_msg_id int(11))
252BEGIN
253 SELECT msg_id,msg_fecha,msg_visto,msg_mensaje,intarho_id FROM tbl_mensajes WHERE msg_id = PAR_msg_id; 
254END$$
255
256DROP PROCEDURE IF EXISTS `CONSULTA_TBL_MENSAJESPorIntarho_id`$$
257CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_MENSAJESPorIntarho_id`(IN PAR_intarho_id int(11))
258BEGIN
259 SELECT
260msg_id,msg_fecha,msg_visto,msg_mensaje,intarho_id
261FROM tbl_mensajes WHERE intarho_id = PAR_intarho_id; 
262END$$
263
264DROP PROCEDURE IF EXISTS `CONSULTA_TBL_PRODUCTOS`$$
265CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_PRODUCTOS`(IN PAR_prod_id int(11))
266BEGIN
267 SELECT prod_id,prod_nombre,prod_valor,prod_fecha,prod_estado FROM tbl_productos WHERE prod_id = PAR_prod_id; 
268END$$
269
270DROP PROCEDURE IF EXISTS `CONSULTA_TBL_SERVICIOS`$$
271CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_SERVICIOS`(IN PAR_ser_id int(11))
272BEGIN
273 SELECT ser_id,ser_nombre,ser_fecha,ser_usuario,ser_estado FROM tbl_servicios WHERE ser_id = PAR_ser_id; 
274END$$
275
276DROP PROCEDURE IF EXISTS `CONSULTA_TBL_TIPO_DOCUMENTO`$$
277CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TBL_TIPO_DOCUMENTO`(IN PAR_tidoc_id int(11))
278BEGIN
279 SELECT tidoc_id,tidoc_nombre,tidoc_fecha,car_estado,tidoc_usuario FROM tbl_tipo_documento WHERE tidoc_id = PAR_tidoc_id; 
280END$$
281
282DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_HCINN_HOTELRESERVATION_INVOICE_DETAILS`$$
283CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_HCINN_HOTELRESERVATION_INVOICE_DETAILS`()
284BEGIN
285 SELECT
286	id,
287	invoiceId,
288	reservationId,
289	descripction,
290	status,
291	count,
292	amount,
293	prod.prod_id,
294	prod.prod_nombre as Producto,
295	prod.prod_valor as ValorProducto, 
296	prod.tip_id
297FROM 
298	hcinn_hotelreservation_invoice_details hoinde
299	inner join tbl_productos prod on hoinde.prod_id = prod.prod_id; 
300END$$
301
302DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_ACTIVIDAD`$$
303CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_ACTIVIDAD`()
304BEGIN
305 SELECT
306	act_id,
307	act_nombre,
308	act_fecha,
309	act_usuario,
310	act_estado,
311	case act_estado when 1 then 'Activo' else 'Inactivo' end as estado,
312	act.ser_id,
313	ser.ser_nombre,
314	usu.username as usuario
315FROM tbl_actividad act
316inner join tbl_servicios ser on ser.ser_id = act.ser_id
317inner join hcinn_users usu on usu.id=act.act_usuario
318; 
319
320END$$
321
322DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_AREAS_HOTELES`$$
323CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_AREAS_HOTELES`()
324BEGIN
325 SELECT
326arhot_id,arhot_nombre,arhot_fecha,arhot_estado,tiar_id,room_id
327FROM tbl_areas_hoteles; 
328END$$
329
330DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_AREAS_HOTELES_X_PRODUCTOS`$$
331CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_AREAS_HOTELES_X_PRODUCTOS`()
332BEGIN
333 SELECT
334ahpro_id,ahpro_cantidad,ahpro_fecha,ahpro_estado,prod_id,arhot_id
335FROM tbl_areas_hoteles_x_productos; 
336END$$
337
338DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_CARGO`$$
339CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_CARGO`()
340BEGIN
341 SELECT
342	car_id,
343	car_nombre,
344	car_fecha,
345	car_estado,
346	case car_estado when 1 then 'Activo' else 'Inactivo' end as estado,
347	car_usuario
348FROM tbl_cargo; 
349END$$
350
351DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_INTERNO`$$
352CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_INTERNO`()
353BEGIN
354 SELECT
355	inte.int_id,
356	inte.int_nombre,
357	inte.int_apellidos,
358	inte.int_identificacion,
359	inte.int_telefono,
360	inte.int_celular,
361	inte.int_email,
362	inte.int_fecha,
363	inte.int_estado,
364	case inte.int_estado when 1 then 'Activo' else 'Inactivo' end as estado,
365	inte.int_usuario,
366	inte.tidoc_id,
367	inte.car_id,
368	car.car_nombre,
369	tidoc.tidoc_nombre,
370	usu.username,
371	concat(inte.int_nombre,' ',inte.int_apellidos) int_nombrecompleto
372FROM tbl_interno inte
373inner join tbl_cargo car on car.car_id = inte.car_id
374inner join tbl_tipo_documento tidoc on tidoc.tidoc_id = inte.tidoc_id
375inner join hcinn_users usu on usu.id = inte.int_usuario
376; 
377END$$
378
379DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_INTERNO_X_AREAS_HOTELES`$$
380CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_INTERNO_X_AREAS_HOTELES`()
381BEGIN
382 SELECT
383intarho_id,intarho_fecha_inicial,intarho_fecha_final,intarho_estado,int_id,arhot_id,
384room.room_name
385FROM tbl_interno_x_areas_hoteles intarho
386inner join hcinn_hotelreservation_rooms room on room.room_id = intarho.room_id
387
388; 
389END$$
390
391DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_LAVANDERIA`$$
392CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_LAVANDERIA`()
393BEGIN
394 SELECT
395	lav.lav_id,
396	lav.lav_fecha_llegada,
397	coalesce(lav.lav_fecha_salida,' ') as lav_fecha_salida,
398	lav.prod_id,
399	lav.int_id,
400	lav.lav_estado,
401    case lav_estado when 1 then 'Activo' else 'Inactivo' end as estado,
402	prod.prod_nombre as prenda,
403	concat(int_nombre,' ',int_apellidos) as persona
404FROM 
405	tbl_lavanderia lav
406	inner join tbl_productos prod on prod.prod_id = lav.prod_id
407	inner join tbl_interno inte on inte.int_id = lav.int_id
408; 
409END$$
410
411DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_MENSAJES`$$
412CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_MENSAJES`()
413BEGIN
414 SELECT
415msg_id,msg_fecha,msg_visto,msg_mensaje,intarho_id
416FROM tbl_mensajes; 
417END$$
418
419DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_PRODUCTOS`$$
420CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_PRODUCTOS`()
421BEGIN
422 SELECT
423	prod_id,
424	prod_nombre,
425	prod_valor,
426	prod_fecha,
427	prod_estado,
428	case prod_estado when 1 then 'Activo' else 'Inactivo' end as estado,
429	tip_id
430FROM tbl_productos; 
431END$$
432
433DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_SERVICIOS`$$
434CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_SERVICIOS`()
435BEGIN
436 SELECT
437	ser_id,
438	ser_nombre,
439	ser_fecha,
440	ser_usuario,
441	ser_estado,
442	case ser_estado when 1 then 'Activo' else 'Inactivo' end as estado,
443	usu.username as usuario
444FROM tbl_servicios ser
445inner join hcinn_users usu on usu.id=ser.ser_usuario
446
447; 
448END$$
449
450DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_TIPO_AREAS`$$
451CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_TIPO_AREAS`()
452BEGIN
453 SELECT
454	tiar_id,
455	tiar_nombre,
456	tiar_fecha,
457	tiar_estado,
458	case tiar_estado when 1 then 'Activo' else 'Inactivo' end as estado
459FROM tbl_tipo_areas; 
460END$$
461
462DROP PROCEDURE IF EXISTS `CONSULTA_TODOS_TBL_TIPO_DOCUMENTO`$$
463CREATE DEFINER=`root`@`localhost` PROCEDURE `CONSULTA_TODOS_TBL_TIPO_DOCUMENTO`()
464BEGIN
465 SELECT
466	tidoc_id,
467	tidoc_nombre,
468	tidoc_fecha,
469	car_estado,
470	case car_estado when 1 then 'Activo' else 'Inactivo' end as estado,
471	tidoc_usuario
472FROM tbl_tipo_documento; 
473END$$
474
475DROP PROCEDURE IF EXISTS `ELIMINA_HCINN_HOTELRESERVATION_INVOICE_DETAILS`$$
476CREATE DEFINER=`root`@`localhost` PROCEDURE `ELIMINA_HCINN_HOTELRESERVATION_INVOICE_DETAILS`(IN PAR_id int(11))
477BEGIN
478 delete from hcinn_hotelreservation_invoice_details where id=PAR_id; 
479END$$
480
481DROP PROCEDURE IF EXISTS `ELIMINA_TBL_ACTIVIDAD`$$
482CREATE DEFINER=`root`@`localhost` PROCEDURE `ELIMINA_TBL_ACTIVIDAD`(IN PAR_act_id int(11))
483BEGIN
484 delete from tbl_actividad where act_id=PAR_act_id; 
485END$$
486
487DROP PROCEDURE IF EXISTS `ELIMINA_TBL_AREAS_HOTELES`$$
488CREATE DEFINER=`root`@`localhost` PROCEDURE `ELIMINA_TBL_AREAS_HOTELES`(IN PAR_arhot_id int(11))
489BEGIN
490 delete from tbl_areas_hoteles where arhot_id=PAR_arhot_id; 
491END$$
492
493DROP PROCEDURE IF EXISTS `ELIMINA_TBL_CARGO`$$
494CREATE DEFINER=`root`@`localhost` PROCEDURE `ELIMINA_TBL_CARGO`(IN PAR_car_id int(11))
495BEGIN
496 delete from tbl_cargo where car_id=PAR_car_id; 
497END$$
498
499DROP PROCEDURE IF EXISTS `ELIMINA_TBL_INTERNO`$$
500CREATE DEFINER=`root`@`localhost` PROCEDURE `ELIMINA_TBL_INTERNO`(IN PAR_int_id int(11))
501BEGIN
502 delete from tbl_interno where int_id=PAR_int_id; 
503END$$
504
505DROP PROCEDURE IF EXISTS `ELIMINA_TBL_LAVANDERIA`$$
506CREATE DEFINER=`root`@`localhost` PROCEDURE `ELIMINA_TBL_LAVANDERIA`(IN PAR_lav_id int(11))
507BEGIN
508 delete from tbl_lavanderia where lav_id=PAR_lav_id; 
509END$$
510
511DROP PROCEDURE IF EXISTS `ELIMINA_TBL_PRODUCTOS`$$
512CREATE DEFINER=`root`@`localhost` PROCEDURE `ELIMINA_TBL_PRODUCTOS`(IN PAR_prod_id int(11))
513BEGIN
514 delete from tbl_productos where prod_id=PAR_prod_id; 
515END$$
516
517DROP PROCEDURE IF EXISTS `ELIMINA_TBL_SERVICIOS`$$
518CREATE DEFINER=`root`@`localhost` PROCEDURE `ELIMINA_TBL_SERVICIOS`(IN PAR_ser_id int(11))
519BEGIN
520 delete from tbl_servicios where ser_id=PAR_ser_id; 
521END$$
522
523DROP PROCEDURE IF EXISTS `ELIMINA_TBL_TIPO_DOCUMENTO`$$
524CREATE DEFINER=`root`@`localhost` PROCEDURE `ELIMINA_TBL_TIPO_DOCUMENTO`(IN PAR_tidoc_id int(11))
525BEGIN
526 delete from tbl_tipo_documento where tidoc_id=PAR_tidoc_id; 
527END$$
528
529DROP PROCEDURE IF EXISTS `INSERTA_HCINN_HOTELRESERVATION_INVOICE_DETAILS`$$
530CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_HCINN_HOTELRESERVATION_INVOICE_DETAILS`(OUT PAR_id int(11),IN PAR_invoiceId int(11),IN PAR_reservationId int(11),IN PAR_descripction varchar(500),IN PAR_status tinyint(11),IN PAR_count int(11),IN PAR_amount float(11),IN PAR_prod_id int(11))
531BEGIN
532 insert into hcinn_hotelreservation_invoice_details (invoiceId,reservationId,descripction,status,count,amount,prod_id) values(PAR_invoiceId,PAR_reservationId,PAR_descripction,PAR_status,PAR_count,PAR_amount,PAR_prod_id);
533set PAR_id = LAST_INSERT_ID(); 
534END$$
535
536DROP PROCEDURE IF EXISTS `INSERTA_TBL_ACTIVIDAD`$$
537CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_ACTIVIDAD`(OUT PAR_act_id int(11),IN PAR_act_nombre varchar(50),IN PAR_act_fecha date,IN PAR_act_usuario int(11),IN PAR_act_estado tinyint(11),IN PAR_ser_id int(11))
538BEGIN
539 insert into tbl_actividad (act_nombre,act_fecha,act_usuario,act_estado,ser_id) values(PAR_act_nombre,PAR_act_fecha,PAR_act_usuario,PAR_act_estado,PAR_ser_id);
540set PAR_act_id = LAST_INSERT_ID(); 
541END$$
542
543DROP PROCEDURE IF EXISTS `INSERTA_TBL_AREAS_HOTELES`$$
544CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_AREAS_HOTELES`(OUT PAR_arhot_id int(11),IN PAR_arhot_nombre varchar(50),IN PAR_arhot_fecha date,IN PAR_arhot_estado tinyint(11),IN PAR_tiar_id int(11),IN PAR_room_id int(11))
545BEGIN
546 insert into tbl_areas_hoteles (arhot_nombre,arhot_fecha,arhot_estado,tiar_id,room_id) values(PAR_arhot_nombre,PAR_arhot_fecha,PAR_arhot_estado,PAR_tiar_id,PAR_room_id);
547set PAR_arhot_id = LAST_INSERT_ID(); 
548END$$
549
550DROP PROCEDURE IF EXISTS `INSERTA_TBL_AREAS_HOTELES_X_PRODUCTOS`$$
551CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_AREAS_HOTELES_X_PRODUCTOS`(OUT PAR_ahpro_id int(11),IN PAR_ahpro_cantidad int(11),IN PAR_ahpro_fecha date,IN PAR_ahpro_estado tinyint(11),IN PAR_prod_id int(11),IN PAR_arhot_id int(11))
552BEGIN
553 insert into tbl_areas_hoteles_x_productos (ahpro_cantidad,ahpro_fecha,ahpro_estado,prod_id,arhot_id) values(PAR_ahpro_cantidad,PAR_ahpro_fecha,PAR_ahpro_estado,PAR_prod_id,PAR_arhot_id);
554set PAR_ahpro_id = LAST_INSERT_ID(); 
555END$$
556
557DROP PROCEDURE IF EXISTS `INSERTA_TBL_CARGO`$$
558CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_CARGO`(OUT PAR_car_id int(11),IN PAR_car_nombre varchar(50),IN PAR_car_fecha date,IN PAR_car_estado tinyint(11),IN PAR_car_usuario int(11))
559BEGIN
560 insert into tbl_cargo (car_nombre,car_fecha,car_estado,car_usuario) values(PAR_car_nombre,PAR_car_fecha,PAR_car_estado,PAR_car_usuario);
561set PAR_car_id = LAST_INSERT_ID(); 
562END$$
563
564DROP PROCEDURE IF EXISTS `INSERTA_TBL_INTERNO`$$
565CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_INTERNO`(OUT `PAR_int_id` INT(11), IN `PAR_int_nombre` VARCHAR(50), IN `PAR_int_apellidos` VARCHAR(50), IN `PAR_int_identificacion` VARCHAR(20), IN `PAR_int_telefono` VARCHAR(20), IN `PAR_int_celular` VARCHAR(20), IN `PAR_int_email` VARCHAR(50), IN `PAR_int_fecha` DATE, IN `PAR_int_estado` TINYINT(11), IN `PAR_int_usuario` INT(11), IN `PAR_tidoc_id` INT(11), IN `PAR_car_id` INT(11))
566BEGIN
567DECLARE PAR_usr_id INT DEFAULT 0;
568
569insert into tbl_interno (int_nombre,int_apellidos,int_identificacion,int_telefono,int_celular,int_email,int_fecha,int_estado,int_usuario,tidoc_id,car_id) values(PAR_int_nombre,PAR_int_apellidos,PAR_int_identificacion,PAR_int_telefono,PAR_int_celular,PAR_int_email,PAR_int_fecha,PAR_int_estado,PAR_int_usuario,PAR_tidoc_id,PAR_car_id);
570set PAR_int_id = LAST_INSERT_ID(); 
571
572END$$
573
574DROP PROCEDURE IF EXISTS `INSERTA_TBL_INTERNO_X_ACTIVIDAD`$$
575CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_INTERNO_X_ACTIVIDAD`(OUT PAR_intact_id int(11),IN PAR_intact_fecha date,IN PAR_intact_estado tinyint(11),IN PAR_intact_realizado tinyint(11),IN PAR_intact_realizado_fecha datetime,IN PAR_intact_confirmado tinyint(11),IN PAR_intact_confirmado_fecha datetime,IN PAR_intact_observacion varchar(500),IN PAR_act_id int(11),IN PAR_intarho_id int(11))
576BEGIN
577 insert into tbl_interno_x_actividad (intact_fecha,intact_estado,intact_realizado,intact_realizado_fecha,intact_confirmado,intact_confirmado_fecha,intact_observacion,act_id,intarho_id) values(PAR_intact_fecha,PAR_intact_estado,PAR_intact_realizado,PAR_intact_realizado_fecha,PAR_intact_confirmado,PAR_intact_confirmado_fecha,PAR_intact_observacion,PAR_act_id,PAR_intarho_id);
578set PAR_intact_id = LAST_INSERT_ID(); 
579END$$
580
581DROP PROCEDURE IF EXISTS `INSERTA_TBL_INTERNO_X_AREAS_HOTELES`$$
582CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_INTERNO_X_AREAS_HOTELES`(OUT PAR_intarho_id int(11),IN PAR_intarho_fecha_inicial date,IN PAR_intarho_fecha_final date,IN PAR_intarho_estado tinyint(11),IN PAR_int_id int(11),IN PAR_arhot_id int(11))
583BEGIN
584 insert into tbl_interno_x_areas_hoteles (intarho_fecha_inicial,intarho_fecha_final,intarho_estado,int_id,arhot_id) values(PAR_intarho_fecha_inicial,PAR_intarho_fecha_final,PAR_intarho_estado,PAR_int_id,PAR_arhot_id);
585set PAR_intarho_id = LAST_INSERT_ID(); 
586END$$
587
588DROP PROCEDURE IF EXISTS `INSERTA_TBL_LAVANDERIA`$$
589CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_LAVANDERIA`(OUT `PAR_lav_id` INT(11), IN `PAR_lav_fecha_llegada` DATE, IN `PAR_lav_fecha_salida` VARCHAR(15), IN `PAR_prod_id` INT(11), IN `PAR_int_id` INT(11), IN `PAR_lav_estado` TINYINT(11))
590BEGIN
591
592if PAR_lav_fecha_salida = '0' then
593	set PAR_lav_fecha_salida = null;
594end if;
595
596 insert into tbl_lavanderia (lav_fecha_llegada,lav_fecha_salida,prod_id,int_id,lav_estado) values(PAR_lav_fecha_llegada,PAR_lav_fecha_salida,PAR_prod_id,PAR_int_id,PAR_lav_estado);
597 set PAR_lav_id = LAST_INSERT_ID(); 
598
599
600END$$
601
602DROP PROCEDURE IF EXISTS `INSERTA_TBL_MENSAJES`$$
603CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_MENSAJES`(OUT PAR_msg_id int(11),IN PAR_msg_fecha date,IN PAR_msg_visto tinyint(11),IN PAR_msg_mensaje varchar(500),IN PAR_intarho_id int(11))
604BEGIN
605 insert into tbl_mensajes (msg_fecha,msg_visto,msg_mensaje,intarho_id) values(PAR_msg_fecha,PAR_msg_visto,PAR_msg_mensaje,PAR_intarho_id);
606set PAR_msg_id = LAST_INSERT_ID(); 
607END$$
608
609DROP PROCEDURE IF EXISTS `INSERTA_TBL_PRODUCTOS`$$
610CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_PRODUCTOS`(OUT PAR_prod_id int(11),IN PAR_prod_nombre varchar(50),IN PAR_prod_valor decimal(11),IN PAR_prod_fecha date,IN PAR_prod_estado tinyint(11),IN PAR_tip_id tinyint(11))
611BEGIN
612 insert into tbl_productos (prod_nombre,prod_valor,prod_fecha,prod_estado,tip_id) values(PAR_prod_nombre,PAR_prod_valor,PAR_prod_fecha,PAR_prod_estado,PAR_tip_id);
613set PAR_prod_id = LAST_INSERT_ID(); 
614END$$
615
616DROP PROCEDURE IF EXISTS `INSERTA_TBL_SERVICIOS`$$
617CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_SERVICIOS`(OUT PAR_ser_id int(11),IN PAR_ser_nombre varchar(50),IN PAR_ser_fecha date,IN PAR_ser_usuario int(11),IN PAR_ser_estado tinyint(11))
618BEGIN
619 insert into tbl_servicios (ser_nombre,ser_fecha,ser_usuario,ser_estado) values(PAR_ser_nombre,PAR_ser_fecha,PAR_ser_usuario,PAR_ser_estado);
620set PAR_ser_id = LAST_INSERT_ID(); 
621END$$
622
623DROP PROCEDURE IF EXISTS `INSERTA_TBL_TIPO_DOCUMENTO`$$
624CREATE DEFINER=`root`@`localhost` PROCEDURE `INSERTA_TBL_TIPO_DOCUMENTO`(OUT PAR_tidoc_id int(11),IN PAR_tidoc_nombre varchar(50),IN PAR_tidoc_fecha date,IN PAR_car_estado tinyint(11),IN PAR_tidoc_usuario int(11))
625BEGIN
626 insert into tbl_tipo_documento (tidoc_nombre,tidoc_fecha,car_estado,tidoc_usuario) values(PAR_tidoc_nombre,PAR_tidoc_fecha,PAR_car_estado,PAR_tidoc_usuario);
627set PAR_tidoc_id = LAST_INSERT_ID(); 
628END$$
629
630DROP PROCEDURE IF EXISTS `UCD_BORRADATOS`$$
631CREATE DEFINER=`root`@`localhost` PROCEDURE `UCD_BORRADATOS`()
632BEGIN
633
634truncate table hcinn_hotelreservation_confirmations;
635truncate table hcinn_hotelreservation_confirmations_documentos;
636truncate table hcinn_hotelreservation_confirmations_extra_options;
637truncate table hcinn_hotelreservation_confirmations_feature_options;
638truncate table hcinn_hotelreservation_confirmations_guests;
639truncate table hcinn_hotelreservation_confirmations_payments;
640truncate table hcinn_hotelreservation_confirmations_rooms;
641truncate table hcinn_hotelreservation_confirmations_rooms_airport_transfer;
642truncate table hcinn_hotelreservation_confirmations_room_prices;
643truncate table hcinn_hotelreservation_confirmations_taxes;
644truncate table hcinn_hotelreservation_datos_facturas;
645
646
647END$$
648
649DROP PROCEDURE IF EXISTS `UCP_ACTUALIZA_TBL_INTERNO_USUARIO`$$
650CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_ACTUALIZA_TBL_INTERNO_USUARIO`(IN `PAR_int_email` VARCHAR(50), IN `PAR_int_email_ant` VARCHAR(50), IN `PAR_int_password` VARCHAR(100))
651    NO SQL
652begin
653
654update hcinn_users 
655set username = PAR_int_email, 
656    email = PAR_int_email, 
657    password = PAR_int_password
658where email = PAR_int_email_ant;
659
660end$$
661
662DROP PROCEDURE IF EXISTS `UCP_ACTUALIZA_VALORES`$$
663CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_ACTUALIZA_VALORES`(in PAR_ConfimationId INT, in PAR_Total decimal(18.2),PAR_amount decimal(18.2), in PAR_Detalles blob)
664BEGIN
665
666	UPDATE hcinn_hotelreservation_confirmations
667		set total = PAR_Total
668	WHERE 
669	confirmation_id = PAR_ConfimationId
670;
671	UPDATE hcinn_hotelreservation_invoices 
672		SET amount = PAR_amount,
673		reservationAmount = PAR_amount,
674		content = PAR_Detalles
675	WHERE confirmation_id = PAR_ConfimationId
676;
677
678END$$
679
680DROP PROCEDURE IF EXISTS `UCP_CONSULTA_DATOS_FACTURA`$$
681CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_DATOS_FACTURA`(in Par_fecha Date, in Par_arhot_id int)
682BEGIN
683
684select 
685 hcinn_hotelreservation_confirmations.confirmation_id,
686 coalesce(hcinn_hotelreservation_invoices.id,0) as id
687
688from hcinn_hotelreservation_confirmations
689left join hcinn_hotelreservation_invoices on 
690		hcinn_hotelreservation_confirmations.confirmation_id = hcinn_hotelreservation_invoices.confirmation_id
691where arhot_id = Par_arhot_id
692and Par_fecha between start_date and end_date;
693
694END$$
695
696DROP PROCEDURE IF EXISTS `UCP_CONSULTA_DETALLECONFIRMACION`$$
697CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_DETALLECONFIRMACION`(in PAR_ConfimationId INT)
698BEGIN
699
700SELECT 
701	hotel.`hotel_name`,
702	hotel.`hotel_description`,
703	hotel.`hotel_county`,
704	hotel.`hotel_city`,
705	hotel.`hotel_address`,
706	hotel.`hotel_stars`,
707	hotel.`hotel_phone`,
708	hotel.`reservation_cost_val`,
709	(select picture.`hotel_picture_path` from `hcinn_hotelreservation_hotel_pictures` picture  where picture.hotel_id = confir.hotel_id limit 1,1) as picture,
710	confir.start_date,
711	confir.end_date,
712	(select count(confir_room.room_id) from hcinn_hotelreservation_confirmations_rooms confir_room where confir_room.confirmation_id = confir.confirmation_id) rooms,
713	confir.remarks,
714	country.country_name,
715	confir.adults as total_adults,
716	confir.children + confir.juniors + confir.babies as total_children
717FROM 
718	`hcinn_hotelreservation_hotels` hotel
719	inner join `hcinn_hotelreservation_confirmations` confir on hotel.hotel_id = confir.hotel_id
720	inner join hcinn_hotelreservation_countries country on country.country_id = hotel.country_id
721where
722confir.confirmation_id = PAR_ConfimationId
723;
724
725END$$
726
727DROP PROCEDURE IF EXISTS `UCP_CONSULTA_EXTRASCONFIRMACION`$$
728CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_EXTRASCONFIRMACION`(in PAR_ConfimationId INT)
729BEGIN
730
731SELECT 
732
733	`extra_option_name`,
734	`extra_option_price`
735
736FROM 
737	`hcinn_hotelreservation_confirmations_extra_options` 
738WHERE 
739	confirmation_id = PAR_ConfimationId
740;
741
742END$$
743
744DROP PROCEDURE IF EXISTS `UCP_CONSULTA_INTERNO_ACTIVIDADPorArhot_idIntarho_fecha_inicial`$$
745CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_INTERNO_ACTIVIDADPorArhot_idIntarho_fecha_inicial`(in PAR_arhot_id int,in PAR_intarho_fecha_inicial date)
746BEGIN
747
748SELECT
749        intact_id,
750        intact_fecha,
751        intact_estado,
752        intact_realizado,
753        intact_realizado_fecha,
754        intact_confirmado,
755        intact_confirmado_fecha,
756        coalesce(intact_observacion,' ') as intact_observacion,
757    	act.act_id,
758		act.act_nombre,
759        nombrecompleto,
760        intarho_id,
761		concat( coalesce(intact_id,'0'),':',act.act_id) as id,
762		case when coalesce(intact_realizado,'0') = 0 then 'false' else 'true' end as Seleccionar,
763		case when coalesce(intact_confirmado,'0') = 0 then 'false' else 'true' end as Checkear
764
765FROM tbl_actividad act
766left join
767(
768    SELECT
769        intact_id,
770        intact_fecha,
771        intact_estado,
772        intact_realizado,
773        intact_realizado_fecha,
774        intact_confirmado,
775        intact_confirmado_fecha,
776
777        intact_observacion,
778    	act_id,
779        concat(inter.int_nombre,' ',inter.int_apellidos ) as nombrecompleto,
780        intarho.intarho_id
781    FROM 
782   	tbl_interno_x_actividad intact
783    inner join tbl_interno_x_areas_hoteles intarho on intact.intarho_id = intarho.intarho_id
784    inner join tbl_interno inter on intarho.int_id = inter.int_id
785	where
786	intarho.intarho_fecha_inicial = PAR_intarho_fecha_inicial
787	and intarho.intarho_id = PAR_arhot_id
788) as inter on inter.act_id = act.act_id;
789
790END$$
791
792DROP PROCEDURE IF EXISTS `UCP_CONSULTA_ITEMSCONFIRMACION`$$
793CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_ITEMSCONFIRMACION`(in PAR_ConfimationId INT)
794BEGIN
795
796SELECT 
797
798	rooms.room_name, 
799	rooms.room_price_1,
800	rooms.max_adults,
801	rooms.max_children,
802	rooms.room_description
803
804FROM 
805	`hcinn_hotelreservation_confirmations_rooms` confir_rooms
806	inner join hcinn_hotelreservation_rooms rooms on rooms.`room_id` = confir_rooms.`room_id`
807WHERE 
808	confir_rooms.confirmation_id = PAR_ConfimationId
809;
810
811END$$
812
813DROP PROCEDURE IF EXISTS `UCP_CONSULTA_LIMPIEZA`$$
814CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_LIMPIEZA`(IN PAR_intarho_id INT)
815BEGIN
816
817SELECT count(`intact_id`) - (SELECT count(act_id) FROM `tbl_actividad` where act_estado = 1) as cantidad
818FROM 
819`tbl_interno_x_actividad` intact
820WHERE `intact_realizado` = 1 and `intact_confirmado` = 1
821and `intarho_id` = PAR_intarho_id
822and `intact_estado` = 1;
823
824
825END$$
826
827DROP PROCEDURE IF EXISTS `UCP_CONSULTA_MENSAJESPorInterno`$$
828CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_MENSAJESPorInterno`(in PAR_int_id int)
829BEGIN
830
831	select 
832		msg.msg_id,
833		msg.msg_fecha, 
834		msg.msg_visto, 
835		msg.msg_mensaje, 
836		msg.intarho_id,
837		concat(tiar.tiar_nombre,' ',arhot.arhot_nombre) as lugarhotel
838		
839	from
840	tbl_mensajes msg
841	inner join tbl_interno_x_areas_hoteles intarho on intarho.intarho_id = msg.intarho_id
842	inner join tbl_interno inte on inte.int_id = intarho.int_id
843	inner join tbl_areas_hoteles arhot on arhot.arhot_id =  intarho.arhot_id
844	inner join tbl_tipo_areas tiar on tiar.tiar_id = arhot.tiar_id
845	where inte.int_id = PAR_int_id
846	and msg.msg_visto = 1
847	;
848END$$
849
850DROP PROCEDURE IF EXISTS `UCP_CONSULTA_TBL_INTERNO_USUARIO`$$
851CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_TBL_INTERNO_USUARIO`(IN `PAR_int_email` VARCHAR(50))
852    NO SQL
853BEGIN
854SELECT * FROM `hcinn_users` WHERE `email` = PAR_int_email;
855END$$
856
857DROP PROCEDURE IF EXISTS `UCP_CONSULTA_TODOS_ROOMS`$$
858CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_TODOS_ROOMS`()
859SELECT * FROM
860hcinn_hotelreservation_rooms$$
861
862DROP PROCEDURE IF EXISTS `UCP_CONSULTA_TODOS_TBL_INTERNO_X_AREAS_HOTELESPorFechaPorArhotId`$$
863CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_CONSULTA_TODOS_TBL_INTERNO_X_AREAS_HOTELESPorFechaPorArhotId`(IN `PAR_Fecha` DATE, IN `PAR_Arhot_id` INT(11))
864BEGIN
865	SELECT
866		intarho_id,
867		intarho_fecha_inicial,
868		intarho_fecha_final,
869		case intarho_estado when 0 then 'No asignado' when 1 then 'Asignado' when 2 then 'Realizado' end as Estado,
870		intarho_estado,
871		inte.int_id,
872		intarho.arhot_id,
873		concat(inte.int_nombre,' ',inte.int_apellidos) as nombrecompleto,
874		arhot.tiar_id
875	FROM 
876		tbl_areas_hoteles arhot
877		inner join tbl_interno_x_areas_hoteles intarho on arhot.arhot_id = intarho.arhot_id
878		inner join tbl_interno inte on inte.int_id = intarho.int_id and int_estado = 1
879	where
880		intarho_fecha_inicial = PAR_Fecha
881		and intarho.arhot_id = PAR_Arhot_id
882		and intarho.intarho_estado = 1
883;
884END$$
885
886DROP PROCEDURE IF EXISTS `UCP_COSONSULTA_LAVANDERIAPorFechaProd_id`$$
887CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_COSONSULTA_LAVANDERIAPorFechaProd_id`(in Par_prod_id int,in PAR_lav_fecha_llegada datetime)
888BEGIN
889
890	SELECT * FROM
891	tbl_lavanderia
892	where
893	lav_fecha_llegada = PAR_lav_fecha_llegada
894	and prod_id = PAR_prod_id
895	and lav_estado = 1;
896
897END$$
898
899DROP PROCEDURE IF EXISTS `UCP_ELIMINA_TBL_INTERNO_USUARIO`$$
900CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_ELIMINA_TBL_INTERNO_USUARIO`(IN `PAR_int_email` VARCHAR(50))
901    NO SQL
902BEGIN
903
904DELETE FROM hcinn_user_usergroup_map 
905WHERE user_id in(
906					SELECT ID FROM hcinn_users where email = PAR_int_email
907    			);
908
909delete FROM hcinn_users where email = PAR_int_email;
910
911END$$
912
913DROP PROCEDURE IF EXISTS `UCP_INSERTA_TBL_INTERNO_USUARIO`$$
914CREATE DEFINER=`root`@`localhost` PROCEDURE `UCP_INSERTA_TBL_INTERNO_USUARIO`(IN `PAR_int_nombre` VARCHAR(50), IN `PAR_int_apellidos` VARCHAR(50), IN `PAR_int_passsword` VARCHAR(100), IN `PAR_int_email` VARCHAR(50))
915    DETERMINISTIC
916BEGIN
917DECLARE PAR_usr_id INT DEFAULT 0;
918insert into hcinn_users (`name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`)
919values ( concat(PAR_int_nombre,' ',PAR_int_apellidos),PAR_int_email,PAR_int_email,PAR_int_passsword,0,0,now(),now(),now(),0,'',now(),0);
920
921insert into hcinn_user_usergroup_map(`user_id`, `group_id`)
922values(PAR_usr_id,11);
923
924END$$
925
926DELIMITER ;
927
928-- --------------------------------------------------------
929
930--
931-- Table structure for table `hcinn_assets`
932--
933-- Creation: Jun 21, 2016 at 07:10 PM
934--
935
936DROP TABLE IF EXISTS `hcinn_assets`;
937CREATE TABLE IF NOT EXISTS `hcinn_assets` (
938  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
939  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set parent.',
940  `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
941  `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
942  `level` int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
943  `name` varchar(50) NOT NULL COMMENT 'The unique name for the asset.\n',
944  `title` varchar(100) NOT NULL COMMENT 'The descriptive title for the asset.',
945  `rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.',
946  PRIMARY KEY (`id`),
947  UNIQUE KEY `idx_asset_name` (`name`),
948  KEY `idx_lft_rgt` (`lft`,`rgt`),
949  KEY `idx_parent_id` (`parent_id`)
950) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=274 ;
951
952--
953-- Dumping data for table `hcinn_assets`
954--
955
956INSERT INTO `hcinn_assets` (`id`, `parent_id`, `lft`, `rgt`, `level`, `name`, `title`, `rules`) VALUES
957(1, 0, 0, 499, 0, 'root.1', 'Root Asset', '{"core.login.site":{"2":1,"6":1},"core.login.admin":{"4":1,"6":1},"core.login.offline":{"6":1},"core.admin":{"8":1},"core.manage":[],"core.create":{"3":1,"4":0,"6":1},"core.delete":{"4":0,"6":1},"core.edit":{"4":0,"6":1},"core.edit.state":{"4":0,"5":1,"6":1},"core.edit.own":{"3":1,"4":0,"6":1}}'),
958(2, 1, 1, 2, 1, 'com_admin', 'com_admin', '{}'),
959(3, 1, 3, 6, 1, 'com_banners', 'com_banners', '{"core.admin":{"4":0},"core.manage":{"4":0},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
960(4, 1, 7, 8, 1, 'com_cache', 'com_cache', '{"core.admin":{"4":0},"core.manage":{"4":0}}'),
961(5, 1, 9, 10, 1, 'com_checkin', 'com_checkin', '{"core.admin":{"4":0},"core.manage":{"4":0}}'),
962(6, 1, 11, 12, 1, 'com_config', 'com_config', '{}'),
963(7, 1, 13, 18, 1, 'com_contact', 'com_contact', '{"core.admin":{"4":0},"core.manage":{"4":0},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
964(8, 1, 19, 148, 1, 'com_content', 'com_content', '{"core.admin":{"4":0,"7":1,"15":1},"core.manage":{"4":0,"6":1,"15":1},"core.create":{"3":1},"core.delete":[],"core.edit":{"4":1},"core.edit.state":{"5":1},"core.edit.own":[]}'),
965(9, 1, 149, 150, 1, 'com_cpanel', 'com_cpanel', '{}'),
966(10, 1, 151, 152, 1, 'com_installer', 'com_installer', '{"core.admin":{"4":0,"7":1},"core.manage":{"4":0,"6":1},"core.delete":{"7":0},"core.edit.state":{"7":0}}'),
967(11, 1, 153, 154, 1, 'com_languages', 'com_languages', '{"core.admin":{"4":0,"7":1},"core.manage":{"4":0,"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
968(12, 1, 155, 156, 1, 'com_login', 'com_login', '{}'),
969(13, 1, 157, 158, 1, 'com_mailto', 'com_mailto', '{}'),
970(14, 1, 159, 160, 1, 'com_massmail', 'com_massmail', '{}'),
971(15, 1, 161, 162, 1, 'com_media', 'com_media', '{"core.admin":{"4":0,"7":1},"core.manage":{"4":0,"6":1},"core.create":{"3":1},"core.delete":{"5":1}}'),
972(16, 1, 163, 164, 1, 'com_menus', 'com_menus', '{"core.admin":{"4":0,"7":1},"core.manage":{"4":0,"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
973(17, 1, 165, 166, 1, 'com_messages', 'com_messages', '{"core.admin":{"4":0},"core.manage":{"4":0}}'),
974(18, 1, 167, 366, 1, 'com_modules', 'com_modules', '{"core.admin":{"4":0,"7":1},"core.manage":{"4":0,"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
975(19, 1, 367, 370, 1, 'com_newsfeeds', 'com_newsfeeds', '{"core.admin":{"4":0},"core.manage":{"4":0},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
976(20, 1, 371, 372, 1, 'com_plugins', 'com_plugins', '{"core.admin":{"4":0},"core.manage":{"4":0},"core.edit":[],"core.edit.state":[]}'),
977(21, 1, 373, 374, 1, 'com_redirect', 'com_redirect', '{"core.admin":{"4":0},"core.manage":{"4":0}}'),
978(22, 1, 375, 376, 1, 'com_search', 'com_search', '{"core.admin":{"4":0},"core.manage":{"4":0}}'),
979(23, 1, 377, 378, 1, 'com_templates', 'com_templates', '{"core.admin":{"4":0},"core.options":[],"core.manage":{"4":0},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
980(24, 1, 379, 380, 1, 'com_users', 'com_users', '{"core.admin":{"4":0,"7":1},"core.manage":{"4":0,"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":{"15":0}}'),
981(25, 1, 381, 386, 1, 'com_weblinks', 'com_weblinks', '{"core.admin":{"4":0},"core.manage":{"4":0},"core.create":{"3":1},"core.delete":[],"core.edit":{"4":1},"core.edit.state":{"5":1},"core.edit.own":[]}'),
982(26, 1, 387, 388, 1, 'com_wrapper', 'com_wrapper', '{}'),
983(27, 8, 20, 47, 2, 'com_content.category.2', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
984(28, 3, 4, 5, 2, 'com_banners.category.3', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
985(29, 7, 14, 15, 2, 'com_contact.category.4', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
986(30, 19, 368, 369, 2, 'com_newsfeeds.category.5', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
987(31, 25, 382, 383, 2, 'com_weblinks.category.6', 'Uncategorised', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
988(32, 8, 48, 61, 2, 'com_content.category.7', 'Blog', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
989(33, 27, 21, 22, 3, 'com_content.article.1', 'Layouts', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
990(34, 76, 80, 81, 4, 'com_content.article.2', 'Desayuno Tipo Americano', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
991(35, 67, 63, 64, 3, 'com_content.article.3', 'Restaurante', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
992(36, 27, 23, 24, 3, 'com_content.article.4', 'UIkit', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
993(37, 27, 25, 26, 3, 'com_content.article.5', 'Dummy Content', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
994(38, 27, 27, 28, 3, 'com_content.article.6', 'Features', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
995(39, 27, 29, 30, 3, 'com_content.article.7', 'Nano Theme', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
996(40, 32, 49, 50, 3, 'com_content.article.8', 'Joomla Templates', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
997(41, 32, 51, 52, 3, 'com_content.article.9', 'Beautiful Icons', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
998(42, 32, 53, 54, 3, 'com_content.article.10', 'Warp Framework', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
999(43, 32, 55, 56, 3, 'com_content.article.11', 'ZOO Extension', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1000(44, 32, 57, 58, 3, 'com_content.article.12', 'Free Social Icons', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1001(47, 27, 31, 32, 3, 'com_content.article.14', 'Slideshow', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1002(48, 27, 33, 34, 3, 'com_content.article.15', 'Lightbox', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1003(49, 67, 65, 66, 3, 'com_content.article.16', 'Servicios del Hotel', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1004(50, 27, 35, 36, 3, 'com_content.article.17', 'Twitter', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1005(51, 27, 37, 38, 3, 'com_content.article.18', 'Media Player', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1006(52, 27, 39, 40, 3, 'com_content.article.19', 'Galeria', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1007(53, 67, 67, 68, 3, 'com_content.article.20', 'Ubicación', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1008(54, 27, 41, 42, 3, 'com_content.article.21', 'Accordion', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1009(55, 27, 43, 44, 3, 'com_content.article.22', 'Slideset', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1010(56, 7, 16, 17, 2, 'com_contact.category.8', 'Reserve con nosotros', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
1011(57, 25, 384, 385, 2, 'com_weblinks.category.9', 'YOOtheme Links', '{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}'),
1012(59, 1, 389, 390, 1, 'com_finder', 'com_finder', '{"core.admin":{"4":0},"core.manage":{"4":0},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1013(63, 27, 45, 46, 3, 'com_content.article.13', 'Widgetkit', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1014(65, 32, 59, 60, 3, 'com_content.article.23', 'Widgetkit', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1015(67, 8, 62, 73, 2, 'com_content.category.10', 'Hotel', '{"core.create":{"3":1},"core.delete":[],"core.edit":[],"core.edit.state":{"5":1},"core.edit.own":{"3":1}}'),
1016(69, 8, 74, 119, 2, 'com_content.category.11', 'Restaurante', '{"core.create":{"3":1},"core.delete":[],"core.edit":[],"core.edit.state":{"5":1},"core.edit.own":{"3":1}}'),
1017(70, 76, 78, 79, 4, 'com_content.article.24', 'Desayuno Saludable con Granola', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1018(71, 76, 82, 83, 4, 'com_content.article.25', 'Macedonia de Frutas', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1019(72, 76, 84, 85, 4, 'com_content.article.26', 'Omelettes', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1020(73, 76, 76, 77, 4, 'com_content.article.27', 'Desayuno Continental', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1021(74, 76, 88, 89, 4, 'com_content.article.28', 'Quesadillas', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1022(75, 76, 86, 87, 4, 'com_content.article.29', 'Porciones', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1023(76, 69, 75, 90, 3, 'com_content.category.12', 'Desayunos', '{"core.create":{"3":1},"core.delete":[],"core.edit":[],"core.edit.state":{"5":1},"core.edit.own":{"3":1}}'),
1024(77, 69, 91, 104, 3, 'com_content.category.13', 'Almuerzos', '{"core.create":{"3":1},"core.delete":[],"core.edit":[],"core.edit.state":{"5":1},"core.edit.own":{"3":1}}'),
1025(78, 77, 92, 93, 4, 'com_content.article.30', 'Carnes', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1026(79, 77, 94, 95, 4, 'com_content.article.31', 'Ensalada Caesar con pollo', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1027(80, 77, 96, 97, 4, 'com_content.article.32', 'Espaguetis', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1028(81, 77, 98, 99, 4, 'com_content.article.33', 'Rapidas', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1029(82, 77, 100, 101, 4, 'com_content.article.34', 'Salchipapas', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1030(83, 77, 102, 103, 4, 'com_content.article.35', 'Arepa con hogai', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1031(84, 69, 105, 110, 3, 'com_content.category.14', 'Bebidas', '{"core.create":{"3":1},"core.delete":[],"core.edit":[],"core.edit.state":{"5":1},"core.edit.own":{"3":1}}'),
1032(85, 84, 106, 107, 4, 'com_content.article.36', 'Bebidas', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1033(86, 84, 108, 109, 4, 'com_content.article.37', 'Vinos', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1034(87, 69, 111, 114, 3, 'com_content.category.15', 'Postre', '{"core.create":{"3":1},"core.delete":[],"core.edit":[],"core.edit.state":{"5":1},"core.edit.own":{"3":1}}'),
1035(88, 87, 112, 113, 4, 'com_content.article.38', 'Postres', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1036(89, 69, 115, 118, 3, 'com_content.category.16', 'Café - Bar', '{"core.create":{"3":1},"core.delete":[],"core.edit":[],"core.edit.state":{"5":1},"core.edit.own":{"3":1}}'),
1037(90, 89, 116, 117, 4, 'com_content.article.39', 'Carta - Café Bar', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1038(92, 1, 391, 392, 1, 'com_aclmanager', 'com_aclmanager', '{"core.admin":{"4":0},"core.manage":{"4":0},"core.edit":[],"aclmanager.diagnostic":[]}'),
1039(93, 1, 393, 394, 1, 'com_categories', 'com_categories', '{"core.admin":{"4":0},"core.manage":{"4":0}}'),
1040(94, 1, 395, 396, 1, 'com_joomlaupdate', 'com_joomlaupdate', '{"core.admin":{"4":0},"core.manage":{"4":0},"core.delete":[],"core.edit.state":[]}'),
1041(96, 18, 172, 173, 2, 'com_modules.module.1', 'Main Menu', '{"core.delete":{"6":1,"4":0},"core.edit":{"6":1,"4":0},"core.edit.state":{"6":1,"4":0,"5":1},"module.edit.frontend":[]}'),
1042(97, 18, 174, 175, 2, 'com_modules.module.2', 'Login', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1043(98, 18, 176, 177, 2, 'com_modules.module.3', 'Popular Articles', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1044(99, 18, 178, 179, 2, 'com_modules.module.4', 'Recently Added Articles', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1045(100, 18, 180, 181, 2, 'com_modules.module.6', 'Unread Messages', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1046(101, 18, 182, 183, 2, 'com_modules.module.7', 'Online Users', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1047(102, 18, 184, 185, 2, 'com_modules.module.8', 'Toolbar', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1048(103, 18, 186, 187, 2, 'com_modules.module.9', 'Quick Icons', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1049(104, 18, 188, 189, 2, 'com_modules.module.10', 'Logged-in Users', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1050(105, 18, 190, 191, 2, 'com_modules.module.12', 'Admin Menu', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1051(106, 18, 192, 193, 2, 'com_modules.module.13', 'Admin Submenu', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1052(107, 18, 194, 195, 2, 'com_modules.module.14', 'User Status', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1053(108, 18, 196, 197, 2, 'com_modules.module.15', 'Title', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1054(109, 18, 198, 199, 2, 'com_modules.module.17', 'Breadcrumbs', '{"core.delete":{"6":1,"4":0},"core.edit":{"6":1,"4":0},"core.edit.state":{"6":1,"4":0,"5":1},"module.edit.frontend":[]}'),
1055(110, 18, 200, 201, 2, 'com_modules.module.19', 'Bottom A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1056(111, 18, 202, 203, 2, 'com_modules.module.20', 'Bottom A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1057(112, 18, 204, 205, 2, 'com_modules.module.21', 'Bottom A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1058(113, 18, 206, 207, 2, 'com_modules.module.22', 'Bottom A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1059(114, 18, 208, 209, 2, 'com_modules.module.27', 'Bottom B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1060(115, 18, 210, 211, 2, 'com_modules.module.28', 'Bottom B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1061(116, 18, 212, 213, 2, 'com_modules.module.29', 'Bottom B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1062(117, 18, 214, 215, 2, 'com_modules.module.30', 'Bottom B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1063(118, 18, 216, 217, 2, 'com_modules.module.32', 'Footer', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1064(119, 18, 218, 219, 2, 'com_modules.module.34', 'Main Bottom', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1065(120, 18, 220, 221, 2, 'com_modules.module.35', 'Main Bottom', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1066(121, 18, 222, 223, 2, 'com_modules.module.36', 'Main Top', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1067(122, 18, 224, 225, 2, 'com_modules.module.37', 'Main Top', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1068(123, 18, 226, 227, 2, 'com_modules.module.38', 'Logo', '{"core.delete":{"6":1,"4":0},"core.edit":{"6":1,"4":0},"core.edit.state":{"6":1,"4":0,"5":1},"module.edit.frontend":[]}'),
1069(124, 18, 228, 229, 2, 'com_modules.module.39', 'Login', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1070(125, 18, 230, 231, 2, 'com_modules.module.40', 'Buscar', '{"core.delete":{"6":1,"4":0},"core.edit":{"6":1,"4":0},"core.edit.state":{"6":1,"4":0,"5":1},"module.edit.frontend":[]}'),
1071(126, 18, 232, 233, 2, 'com_modules.module.41', 'Sub Menu', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1072(127, 18, 234, 235, 2, 'com_modules.module.42', 'Sidebar Menu', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1073(128, 18, 236, 237, 2, 'com_modules.module.43', 'Sidebar A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1074(129, 18, 238, 239, 2, 'com_modules.module.44', 'Sidebar A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1075(130, 18, 240, 241, 2, 'com_modules.module.48', 'Latest News', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1076(131, 18, 242, 243, 2, 'com_modules.module.49', 'Login', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1077(132, 18, 244, 245, 2, 'com_modules.module.50', 'Descargar Folleto', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1078(133, 18, 246, 247, 2, 'com_modules.module.53', 'Carta', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1079(134, 18, 248, 249, 2, 'com_modules.module.54', 'Joomla & WordPress', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1080(135, 18, 250, 251, 2, 'com_modules.module.55', 'UIkit', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1081(136, 18, 252, 253, 2, 'com_modules.module.57', 'Sidebar B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1082(137, 18, 254, 255, 2, 'com_modules.module.58', 'Sidebar B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1083(138, 18, 256, 257, 2, 'com_modules.module.59', 'Sidebar B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1084(140, 18, 258, 259, 2, 'com_modules.module.62', 'Top A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1085(141, 18, 260, 261, 2, 'com_modules.module.63', 'Top A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1086(142, 18, 262, 263, 2, 'com_modules.module.64', 'Top A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1087(143, 18, 264, 265, 2, 'com_modules.module.65', 'Top A', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1088(144, 18, 266, 267, 2, 'com_modules.module.66', 'Icons Shipping', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1089(145, 18, 268, 269, 2, 'com_modules.module.67', 'Icons E-Commerce', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1090(146, 18, 270, 271, 2, 'com_modules.module.68', 'Icons Buildings', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1091(147, 18, 272, 273, 2, 'com_modules.module.69', 'Icons Hosting', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1092(148, 18, 274, 275, 2, 'com_modules.module.71', 'Top B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1093(149, 18, 276, 277, 2, 'com_modules.module.72', 'Top B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1094(150, 18, 278, 279, 2, 'com_modules.module.73', 'Top B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1095(151, 18, 280, 281, 2, 'com_modules.module.74', 'Top B', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1096(153, 18, 282, 283, 2, 'com_modules.module.77', 'Get Widgetkit', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1097(156, 18, 284, 285, 2, 'com_modules.module.80', 'Multilanguage status', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1098(157, 18, 286, 287, 2, 'com_modules.module.81', 'Joomla Version', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1099(158, 18, 288, 289, 2, 'com_modules.module.89', 'Icons Blog', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1100(159, 18, 290, 291, 2, 'com_modules.module.90', 'Icons Space', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1101(160, 18, 292, 293, 2, 'com_modules.module.91', 'Icons Halloween', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1102(161, 18, 294, 295, 2, 'com_modules.module.92', 'Icons Credit Cards', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1103(162, 18, 296, 297, 2, 'com_modules.module.97', 'Features UIkit', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1104(163, 18, 298, 299, 2, 'com_modules.module.99', 'Offcanvas', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1105(164, 18, 300, 301, 2, 'com_modules.module.100', 'Offcanvas Menu', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1106(165, 18, 302, 303, 2, 'com_modules.module.102', 'Logo small', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1107(166, 18, 304, 305, 2, 'com_modules.module.103', 'Quienes somos - home', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1108(167, 18, 306, 307, 2, 'com_modules.module.104', 'Parallax Top Frontpage', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1109(168, 18, 308, 309, 2, 'com_modules.module.106', 'texto quienes somos - home', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1110(169, 18, 310, 311, 2, 'com_modules.module.107', 'Yootheme Products Frontpage', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1111(170, 18, 312, 313, 2, 'com_modules.module.108', 'Parallax Bottom', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1112(172, 18, 314, 315, 2, 'com_modules.module.110', 'Qick Contact', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1113(173, 18, 316, 317, 2, 'com_modules.module.111', 'Reconocimientos', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1114(176, 18, 318, 319, 2, 'com_modules.module.114', 'pestañas', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1115(182, 1, 397, 398, 1, 'com_jhotelreservation', 'jhotelreservation', '{"core.admin":{"7":1,"14":1},"core.manage":{"6":1,"14":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1116(183, 67, 69, 70, 3, 'com_content.article.40', 'cuartos disponibles', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1117(184, 1, 399, 400, 1, 'com_amallaves', 'com_amallaves', '{"core.admin":{"4":0,"7":1,"11":1,"13":1},"core.manage":{"4":0,"6":1,"12":1,"13":1},"core.create":{"12":1},"core.delete":{"12":1},"core.edit":{"12":1},"core.edit.state":{"12":1}}'),
1118(185, 8, 120, 135, 2, 'com_content.category.17', 'Planes', '{"core.create":{"3":1,"4":0},"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1},"core.edit.own":{"3":1,"4":0}}'),
1119(186, 8, 136, 143, 2, 'com_content.category.18', 'Habitaciones', '{"core.create":{"3":1,"4":0},"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1},"core.edit.own":{"3":1,"4":0}}'),
1120(187, 8, 144, 147, 2, 'com_content.category.19', 'Comentarios', '{"core.create":{"3":1,"4":0},"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1},"core.edit.own":{"3":1,"4":0}}'),
1121(188, 185, 121, 122, 3, 'com_content.article.41', 'Plan Conozca Bogotá', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1122(189, 185, 123, 124, 3, 'com_content.article.42', 'Plan de Aniversario', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1123(190, 185, 125, 126, 3, 'com_content.article.43', 'Plan de Cumpleaños', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1124(191, 185, 127, 128, 3, 'com_content.article.44', 'Plan por Villa de Leiva y Sitios Turisticos', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1125(192, 185, 129, 130, 3, 'com_content.article.45', 'Plan Salud y belleza', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1126(193, 185, 131, 132, 3, 'com_content.article.46', 'Plan Visa', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1127(194, 185, 133, 134, 3, 'com_content.article.47', 'Plan Zipaquira', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1128(195, 186, 137, 138, 3, 'com_content.article.48', 'Habitación Doble Superior – Cama King', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1129(196, 186, 139, 140, 3, 'com_content.article.49', 'Habitación Doble – Cama matrimonial', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1130(197, 186, 141, 142, 3, 'com_content.article.50', 'Habitación Twin – 2 Camas', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1131(198, 1, 401, 402, 1, 'com_jcomments', 'jcomments', '{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1132(199, 187, 145, 146, 3, 'com_content.article.51', 'Comentarios', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1133(200, 67, 71, 72, 3, 'com_content.article.52', 'Descripción', '{"core.delete":{"4":0},"core.edit":{"4":0},"core.edit.state":{"4":0,"5":1}}'),
1134(201, 18, 170, 171, 2, 'com_modules.module.134', 'Flotante Btn', '{"core.delete":{"6":1,"4":0},"core.edit":{"6":1,"4":0},"core.edit.state":{"6":1,"4":0,"5":1},"module.edit.frontend":[]}'),
1135(202, 1, 403, 404, 1, 'com_extplorer', 'extplorer', '{"core.admin":[],"core.manage":[]}'),
1136(203, 18, 320, 321, 2, 'com_modules.module.120', 'JFeaturedHotels', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1137(204, 18, 322, 323, 2, 'com_modules.module.121', 'RESERVACIÓN EN LÍNEA', '{"core.delete":{"6":1,"4":0},"core.edit":{"6":1,"4":0},"core.edit.state":{"6":1,"4":0,"5":1},"module.edit.frontend":[]}'),
1138(205, 18, 324, 325, 2, 'com_modules.module.122', 'JHotelSearchFilter', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1139(206, 18, 326, 327, 2, 'com_modules.module.123', 'JHotelSlider', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1140(207, 18, 328, 329, 2, 'com_modules.module.124', 'JNearByHotels', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1141(208, 18, 330, 331, 2, 'com_modules.module.125', 'JQueryLogin', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1142(209, 18, 332, 333, 2, 'com_modules.module.126', 'INFORMACIÓN DE LA RESERVA', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1143(210, 18, 334, 335, 2, 'com_modules.module.127', 'JTopHotels', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1144(211, 18, 336, 337, 2, 'com_modules.module.128', 'JTopOffers', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1145(212, 18, 338, 339, 2, 'com_modules.module.129', 'OFERTA DE LA SEMANA', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1146(213, 18, 340, 341, 2, 'com_modules.module.130', 'Redes Sociales -  Slider', '{"core.delete":{"6":1,"4":0},"core.edit":{"6":1,"4":0},"core.edit.state":{"6":1,"4":0,"5":1},"module.edit.frontend":[]}'),
1147(214, 18, 342, 343, 2, 'com_modules.module.131', 'Art Sexy Lightbox Lite Edition', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1148(215, 18, 344, 345, 2, 'com_modules.module.132', 'Los Más Comentados', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1149(216, 18, 346, 347, 2, 'com_modules.module.133', 'Slideshow Planes Inicio', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1150(217, 18, 168, 169, 2, 'com_modules.module.135', 'logo camaleon pie', '{"core.delete":[],"core.edit":[],"core.edit.state":[]}'),
1151(218, 1, 405, 406, 1, 'com_tags', 'com_tags', '{}'),
1152(219, 1, 407, 408, 1, 'com_contenthistory', 'com_contenthistory', '{}'),
1153(220, 1, 409, 410, 1, 'com_ajax', 'com_ajax', '{}'),
1154(221, 1, 411, 412, 1, 'com_postinstall', 'com_postinstall', '{}'),
1155(222, 1, 413, 414, 1, 'com_widgetkit', 'com_widgetkit', '{}'),
1156(223, 18, 348, 349, 2, 'com_modules.module.136', 'Widgetkit', '{}'),
1157(224, 1, 415, 416, 1, 'com_realestatemanager', 'RealEstateManager', '{}'),
1158(225, 1, 417, 418, 1, '#__rem_main_categories.46', '#__rem_main_categories.46', '{}'),
1159(226, 1, 419, 420, 1, '#__rem_main_categories.47', '#__rem_main_categories.47', '{}'),
1160(227, 1, 421, 422, 1, '#__rem_main_categories.48', '#__rem_main_categories.48', '{}'),
1161(228, 1, 423, 424, 1, '#__rem_main_categories.49', '#__rem_main_categories.49', '{}'),
1162(229, 1, 425, 426, 1, '#__rem_main_categories.50', '#__rem_main_categories.50', '{}'),
1163(230, 1, 427, 428, 1, '#__rem_houses.2', '#__rem_houses.2', '{}'),
1164(231, 1, 429, 430, 1, '#__rem_houses.3', '#__rem_houses.3', '{}'),
1165(232, 1, 431, 432, 1, '#__rem_houses.4', '#__rem_houses.4', '{}'),
1166(233, 18, 350, 351, 2, 'com_modules.module.137', 'HOTELES DISPONIBLES', '{"core.delete":[],"core.edit":[],"core.edit.state":[],"module.edit.frontend":[]}'),
1167(234, 18, 352, 353, 2, 'com_modules.module.138', 'mapa hoteles  real estate home', '{"core.delete":[],"core.edit":[],"core.edit.state":[],"module.edit.frontend":[]}'),
1168(235, 18, 354, 355, 2, 'com_modules.module.139', 'Realestate similar Free', '{"core.delete":[],"core.edit":[],"core.edit.state":[],"module.edit.frontend":[]}'),
1169(236, 18, 356, 357, 2, 'com_modules.module.140', 'CALCULADORA REAL ESTATE', '{"core.delete":[],"core.edit":[],"core.edit.state":[],"module.edit.frontend":[]}'),
1170(237, 18, 358, 359, 2, 'com_modules.module.141', 'LOS MÁS POPULARES', '{"core.delete":[],"core.edit":[],"core.edit.state":[],"module.edit.frontend":[]}'),
1171(238, 18, 360, 361, 2, 'com_modules.module.142', 'Slideshow Home Promociones shotel', '{"core.delete":{"6":1,"4":0},"core.edit":{"6":1,"4":0},"core.edit.state":{"6":1,"4":0,"5":1},"module.edit.frontend":[]}'),
1172(239, 1, 433, 434, 1, '#__rem_houses.5', '#__rem_houses.5', '{}'),
1173(240, 1, 435, 436, 1, '#__rem_houses.6', '#__rem_houses.6', '{}'),
1174(241, 1, 437, 438, 1, '#__rem_houses.7', '#__rem_houses.7', '{}'),
1175(242, 1, 439, 440, 1, '#__rem_houses.8', '#__rem_houses.8', '{}'),
1176(243, 1, 441, 442, 1, '#__rem_main_categories.51', '#__rem_main_categories.51', '{}'),
1177(244, 1, 443, 444, 1, '#__rem_houses.9', '#__rem_houses.9', '{}'),
1178(245, 1, 445, 446, 1, '#__rem_houses.10', '#__rem_houses.10', '{}'),
1179(246, 1, 447, 448, 1, '#__rem_houses.11', '#__rem_houses.11', '{}'),
1180(247, 1, 449, 450, 1, '#__rem_houses.12', '#__rem_houses.12', '{}'),
1181(248, 1, 451, 452, 1, '#__rem_houses.13', '#__rem_houses.13', '{}'),
1182(249, 1, 453, 454, 1, '#__rem_houses.14', '#__rem_houses.14', '{}'),
1183(250, 1, 455, 456, 1, '#__rem_houses.15', '#__rem_houses.15', '{}'),
1184(251, 18, 362, 363, 2, 'com_modules.module.143', 'GTranslate', '{"core.delete":[],"core.edit":[],"core.edit.state":[],"module.edit.frontend":[]}'),
1185(252, 18, 364, 365, 2, 'com_modules.module.144', 'imagen boton reserva', '{"core.delete":{"6":1,"4":0},"core.edit":{"6":1,"4":0},"core.edit.state":{"6":1,"4":0,"5":1},"module.edit.frontend":[]}'),
1186(253, 1, 457, 458, 1, '#__rem_houses.16', '#__rem_houses.16', '{}'),
1187(254, 1, 459, 460, 1, '#__rem_houses.17', '#__rem_houses.17', '{}'),
1188(255, 1, 461, 462, 1, '#__rem_houses.18', '#__rem_houses.18', '{}'),
1189(256, 1, 463, 464, 1, '#__rem_houses.19', '#__rem_houses.19', '{}'),
1190(257, 1, 465, 466, 1, '#__rem_houses.20', '#__rem_houses.20', '{}'),
1191(258, 1, 467, 468, 1, '#__rem_houses.21', '#__rem_houses.21', '{}'),
1192(259, 1, 469, 470, 1, '#__rem_houses.22', '#__rem_houses.22', '{}'),
1193(260, 1, 471, 472, 1, '#__rem_houses.23', '#__rem_houses.23', '{}'),
1194(261, 1, 473, 474, 1, '#__rem_houses.24', '#__rem_houses.24', '{}'),
1195(262, 1, 475, 476, 1, '#__rem_houses.25', '#__rem_houses.25', '{}'),
1196(263, 1, 477, 478, 1, '#__rem_houses.26', '#__rem_houses.26', '{}'),
1197(264, 1, 479, 480, 1, '#__rem_houses.27', '#__rem_houses.27', '{}'),
1198(265, 1, 481, 482, 1, '#__rem_houses.28', '#__rem_houses.28', '{}'),
1199(266, 1, 483, 484, 1, '#__rem_houses.29', '#__rem_houses.29', '{}'),
1200(267, 1, 485, 486, 1, '#__rem_houses.30', '#__rem_houses.30', '{}'),
1201(268, 1, 487, 488, 1, '#__rem_houses.31', '#__rem_houses.31', '{}'),
1202(269, 1, 489, 490, 1, '#__rem_houses.32', '#__rem_houses.32', '{}'),
1203(270, 1, 491, 492, 1, '#__rem_houses.33', '#__rem_houses.33', '{}'),
1204(271, 1, 493, 494, 1, '#__rem_houses.34', '#__rem_houses.34', '{}'),
1205(272, 1, 495, 496, 1, '#__rem_houses.35', '#__rem_houses.35', '{}'),
1206(273, 1, 497, 498, 1, '#__rem_houses.36', '#__rem_houses.36', '{}');
1207
1208-- --------------------------------------------------------
1209
1210--
1211-- Table structure for table `hcinn_associations`
1212--
1213-- Creation: Jun 21, 2016 at 07:10 PM
1214--
1215
1216DROP TABLE IF EXISTS `hcinn_associations`;
1217CREATE TABLE IF NOT EXISTS `hcinn_associations` (
1218  `id` int(11) NOT NULL COMMENT 'A reference to the associated item.',
1219  `context` varchar(50) NOT NULL COMMENT 'The context of the associated item.',
1220  `key` char(32) NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.',
1221  PRIMARY KEY (`context`,`id`),
1222  KEY `idx_key` (`key`)
1223) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1224
1225-- --------------------------------------------------------
1226
1227--
1228-- Table structure for table `hcinn_banners`
1229--
1230-- Creation: Jun 21, 2016 at 07:10 PM
1231--
1232
1233DROP TABLE IF EXISTS `hcinn_banners`;
1234CREATE TABLE IF NOT EXISTS `hcinn_banners` (
1235  `id` int(11) NOT NULL AUTO_INCREMENT,
1236  `cid` int(11) NOT NULL DEFAULT '0',
1237  `type` int(11) NOT NULL DEFAULT '0',
1238  `name` varchar(255) NOT NULL DEFAULT '',
1239  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
1240  `imptotal` int(11) NOT NULL DEFAULT '0',
1241  `impmade` int(11) NOT NULL DEFAULT '0',
1242  `clicks` int(11) NOT NULL DEFAULT '0',
1243  `clickurl` varchar(200) NOT NULL DEFAULT '',
1244  `state` tinyint(3) NOT NULL DEFAULT '0',
1245  `catid` int(10) unsigned NOT NULL DEFAULT '0',
1246  `description` text NOT NULL,
1247  `custombannercode` varchar(2048) NOT NULL,
1248  `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
1249  `ordering` int(11) NOT NULL DEFAULT '0',
1250  `metakey` text NOT NULL,
1251  `params` text NOT NULL,
1252  `own_prefix` tinyint(1) NOT NULL DEFAULT '0',
1253  `metakey_prefix` varchar(255) NOT NULL DEFAULT '',
1254  `purchase_type` tinyint(4) NOT NULL DEFAULT '-1',
1255  `track_clicks` tinyint(4) NOT NULL DEFAULT '-1',
1256  `track_impressions` tinyint(4) NOT NULL DEFAULT '-1',
1257  `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
1258  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1259  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1260  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1261  `reset` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1262  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1263  `language` char(7) NOT NULL DEFAULT '',
1264  `created_by` int(10) unsigned NOT NULL DEFAULT '0',
1265  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
1266  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1267  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
1268  `version` int(10) unsigned NOT NULL DEFAULT '1',
1269  PRIMARY KEY (`id`),
1270  KEY `idx_state` (`state`),
1271  KEY `idx_own_prefix` (`own_prefix`),
1272  KEY `idx_metakey_prefix` (`metakey_prefix`),
1273  KEY `idx_banner_catid` (`catid`),
1274  KEY `idx_language` (`language`)
1275) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1276
1277-- --------------------------------------------------------
1278
1279--
1280-- Table structure for table `hcinn_banner_clients`
1281--
1282-- Creation: Jun 21, 2016 at 07:10 PM
1283--
1284
1285DROP TABLE IF EXISTS `hcinn_banner_clients`;
1286CREATE TABLE IF NOT EXISTS `hcinn_banner_clients` (
1287  `id` int(11) NOT NULL AUTO_INCREMENT,
1288  `name` varchar(255) NOT NULL DEFAULT '',
1289  `contact` varchar(255) NOT NULL DEFAULT '',
1290  `email` varchar(255) NOT NULL DEFAULT '',
1291  `extrainfo` text NOT NULL,
1292  `state` tinyint(3) NOT NULL DEFAULT '0',
1293  `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
1294  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1295  `metakey` text NOT NULL,
1296  `own_prefix` tinyint(4) NOT NULL DEFAULT '0',
1297  `metakey_prefix` varchar(255) NOT NULL DEFAULT '',
1298  `purchase_type` tinyint(4) NOT NULL DEFAULT '-1',
1299  `track_clicks` tinyint(4) NOT NULL DEFAULT '-1',
1300  `track_impressions` tinyint(4) NOT NULL DEFAULT '-1',
1301  PRIMARY KEY (`id`),
1302  KEY `idx_own_prefix` (`own_prefix`),
1303  KEY `idx_metakey_prefix` (`metakey_prefix`)
1304) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1305
1306-- --------------------------------------------------------
1307
1308--
1309-- Table structure for table `hcinn_banner_tracks`
1310--
1311-- Creation: Jun 21, 2016 at 07:10 PM
1312--
1313
1314DROP TABLE IF EXISTS `hcinn_banner_tracks`;
1315CREATE TABLE IF NOT EXISTS `hcinn_banner_tracks` (
1316  `track_date` datetime NOT NULL,
1317  `track_type` int(10) unsigned NOT NULL,
1318  `banner_id` int(10) unsigned NOT NULL,
1319  `count` int(10) unsigned NOT NULL DEFAULT '0',
1320  PRIMARY KEY (`track_date`,`track_type`,`banner_id`),
1321  KEY `idx_track_date` (`track_date`),
1322  KEY `idx_track_type` (`track_type`),
1323  KEY `idx_banner_id` (`banner_id`)
1324) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1325
1326-- --------------------------------------------------------
1327
1328--
1329-- Table structure for table `hcinn_categories`
1330--
1331-- Creation: Jun 21, 2016 at 07:10 PM
1332--
1333
1334DROP TABLE IF EXISTS `hcinn_categories`;
1335CREATE TABLE IF NOT EXISTS `hcinn_categories` (
1336  `id` int(11) NOT NULL AUTO_INCREMENT,
1337  `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.',
1338  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
1339  `lft` int(11) NOT NULL DEFAULT '0',
1340  `rgt` int(11) NOT NULL DEFAULT '0',
1341  `level` int(10) unsigned NOT NULL DEFAULT '0',
1342  `path` varchar(255) NOT NULL DEFAULT '',
1343  `extension` varchar(50) NOT NULL DEFAULT '',
1344  `title` varchar(255) NOT NULL,
1345  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
1346  `note` varchar(255) NOT NULL DEFAULT '',
1347  `description` mediumtext,
1348  `published` tinyint(1) NOT NULL DEFAULT '0',
1349  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
1350  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1351  `access` int(10) unsigned DEFAULT NULL,
1352  `params` text NOT NULL,
1353  `metadesc` varchar(1024) NOT NULL COMMENT 'The meta description for the page.',
1354  `metakey` varchar(1024) NOT NULL COMMENT 'The meta keywords for the page.',
1355  `metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.',
1356  `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
1357  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1358  `modified_user_id` int(10) unsigned NOT NULL DEFAULT '0',
1359  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1360  `hits` int(10) unsigned NOT NULL DEFAULT '0',
1361  `language` char(7) NOT NULL,
1362  `version` int(10) unsigned NOT NULL DEFAULT '1',
1363  PRIMARY KEY (`id`),
1364  KEY `cat_idx` (`extension`,`published`,`access`),
1365  KEY `idx_access` (`access`),
1366  KEY `idx_checkout` (`checked_out`),
1367  KEY `idx_path` (`path`),
1368  KEY `idx_left_right` (`lft`,`rgt`),
1369  KEY `idx_alias` (`alias`),
1370  KEY `idx_language` (`language`)
1371) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
1372
1373--
1374-- Dumping data for table `hcinn_categories`
1375--
1376
1377INSERT INTO `hcinn_categories` (`id`, `asset_id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `extension`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`, `modified_user_id`, `modified_time`, `hits`, `language`, `version`) VALUES
1378(1, 0, 0, 0, 37, 0, '', 'system', 'ROOT', 'root', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{}', '', '', '', 43, '2009-10-18 16:07:09', 0, '0000-00-00 00:00:00', 0, '*', 1),
1379(2, 27, 1, 1, 2, 1, 'uncategorised', 'com_content', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 43, '2010-06-28 13:26:37', 0, '0000-00-00 00:00:00', 0, '*', 1),
1380(3, 28, 1, 3, 4, 1, 'uncategorised', 'com_banners', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":"","foobar":""}', '', '', '{"page_title":"","author":"","robots":""}', 43, '2010-06-28 13:27:35', 0, '0000-00-00 00:00:00', 0, '*', 1),
1381(4, 29, 1, 5, 6, 1, 'uncategorised', 'com_contact', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 43, '2010-06-28 13:27:57', 0, '0000-00-00 00:00:00', 0, '*', 1),
1382(5, 30, 1, 7, 8, 1, 'uncategorised', 'com_newsfeeds', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 43, '2010-06-28 13:28:15', 0, '0000-00-00 00:00:00', 0, '*', 1),
1383(6, 31, 1, 9, 10, 1, 'uncategorised', 'com_weblinks', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 43, '2010-06-28 13:28:33', 0, '0000-00-00 00:00:00', 0, '*', 1),
1384(7, 32, 1, 11, 12, 1, 'blog', 'com_content', 'Blog', 'blog', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2011-05-02 11:42:21', 0, '0000-00-00 00:00:00', 0, '*', 1),
1385(8, 56, 1, 13, 14, 1, 'reserve-con-nosotros', 'com_contact', 'Reserve con nosotros', 'reserve-con-nosotros', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2011-11-18 16:32:10', 43, '2014-01-30 19:50:26', 0, '*', 1),
1386(9, 57, 1, 15, 16, 1, 'yootheme-links', 'com_weblinks', 'YOOtheme Links', 'yootheme-links', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2012-01-22 12:45:00', 0, '0000-00-00 00:00:00', 0, '*', 1),
1387(10, 67, 1, 17, 18, 1, 'hotel', 'com_content', 'Hotel', 'hotel', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2014-01-21 13:19:48', 0, '0000-00-00 00:00:00', 0, '*', 1),
1388(11, 69, 1, 19, 30, 1, 'restaurante', 'com_content', 'Restaurante', 'restaurante', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2014-01-28 19:11:07', 0, '0000-00-00 00:00:00', 0, '*', 1),
1389(12, 76, 11, 20, 21, 2, 'restaurante/desayunos', 'com_content', 'Desayunos', 'desayunos', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2014-01-29 21:20:54', 0, '0000-00-00 00:00:00', 0, '*', 1),
1390(13, 77, 11, 22, 23, 2, 'restaurante/almuerzos', 'com_content', 'Almuerzos', 'almuerzos', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2014-01-29 21:23:34', 0, '0000-00-00 00:00:00', 0, '*', 1),
1391(14, 84, 11, 24, 25, 2, 'restaurante/bebidas', 'com_content', 'Bebidas', 'bebidas', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2014-01-30 15:09:49', 0, '0000-00-00 00:00:00', 0, '*', 1),
1392(15, 87, 11, 26, 27, 2, 'restaurante/postre', 'com_content', 'Postre', 'postre', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2014-01-30 19:07:25', 0, '0000-00-00 00:00:00', 0, '*', 1),
1393(16, 89, 11, 28, 29, 2, 'restaurante/cafe-bar', 'com_content', 'Café - Bar', 'cafe-bar', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 43, '2014-01-30 19:17:59', 0, '0000-00-00 00:00:00', 0, '*', 1),
1394(17, 185, 1, 31, 32, 1, 'planes', 'com_content', 'Planes', 'planes', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 1, '2015-03-10 19:24:32', 0, '0000-00-00 00:00:00', 0, '*', 1),
1395(18, 186, 1, 33, 34, 1, 'habitaciones', 'com_content', 'Habitaciones', 'habitaciones', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 1, '2015-03-10 19:24:52', 0, '0000-00-00 00:00:00', 0, '*', 1),
1396(19, 187, 1, 35, 36, 1, 'comentarios', 'com_content', 'Comentarios', 'comentarios', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":""}', '', '', '{"author":"","robots":""}', 1, '2015-03-10 19:25:17', 0, '0000-00-00 00:00:00', 0, '*', 1);
1397
1398-- --------------------------------------------------------
1399
1400--
1401-- Table structure for table `hcinn_contact_details`
1402--
1403-- Creation: Jun 21, 2016 at 07:10 PM
1404--
1405
1406DROP TABLE IF EXISTS `hcinn_contact_details`;
1407CREATE TABLE IF NOT EXISTS `hcinn_contact_details` (
1408  `id` int(11) NOT NULL AUTO_INCREMENT,
1409  `name` varchar(255) NOT NULL DEFAULT '',
1410  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
1411  `con_position` varchar(255) DEFAULT NULL,
1412  `address` text,
1413  `suburb` varchar(100) DEFAULT NULL,
1414  `state` varchar(100) DEFAULT NULL,
1415  `country` varchar(100) DEFAULT NULL,
1416  `postcode` varchar(100) DEFAULT NULL,
1417  `telephone` varchar(255) DEFAULT NULL,
1418  `fax` varchar(255) DEFAULT NULL,
1419  `misc` mediumtext,
1420  `image` varchar(255) DEFAULT NULL,
1421  `email_to` varchar(255) DEFAULT NULL,
1422  `default_con` tinyint(1) unsigned NOT NULL DEFAULT '0',
1423  `published` tinyint(1) NOT NULL DEFAULT '0',
1424  `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
1425  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1426  `ordering` int(11) NOT NULL DEFAULT '0',
1427  `params` text NOT NULL,
1428  `user_id` int(11) NOT NULL DEFAULT '0',
1429  `catid` int(11) NOT NULL DEFAULT '0',
1430  `access` int(10) unsigned DEFAULT NULL,
1431  `mobile` varchar(255) NOT NULL DEFAULT '',
1432  `webpage` varchar(255) NOT NULL DEFAULT '',
1433  `sortname1` varchar(255) NOT NULL,
1434  `sortname2` varchar(255) NOT NULL,
1435  `sortname3` varchar(255) NOT NULL,
1436  `language` char(7) NOT NULL,
1437  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1438  `created_by` int(10) unsigned NOT NULL DEFAULT '0',
1439  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
1440  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1441  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
1442  `metakey` text NOT NULL,
1443  `metadesc` text NOT NULL,
1444  `metadata` text NOT NULL,
1445  `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if article is featured.',
1446  `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
1447  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1448  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1449  `version` int(10) unsigned NOT NULL DEFAULT '1',
1450  `hits` int(10) unsigned NOT NULL DEFAULT '0',
1451  PRIMARY KEY (`id`),
1452  KEY `idx_access` (`access`),
1453  KEY `idx_checkout` (`checked_out`),
1454  KEY `idx_state` (`published`),
1455  KEY `idx_catid` (`catid`),
1456  KEY `idx_createdby` (`created_by`),
1457  KEY `idx_featured_catid` (`featured`,`catid`),
1458  KEY `idx_language` (`language`),
1459  KEY `idx_xreference` (`xreference`)
1460) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
1461
1462--
1463-- Dumping data for table `hcinn_contact_details`
1464--
1465
1466INSERT INTO `hcinn_contact_details` (`id`, `name`, `alias`, `con_position`, `address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`, `mobile`, `webpage`, `sortname1`, `sortname2`, `sortname3`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`, `version`, `hits`) VALUES
1467(1, 'Reservas', 'reservas', '', 'Cll 24 D # 40-76', 'Bogotá', 'Cundinamarca', 'Colombia', '111321', '(57-1) 2446834', '', '', '', 'reservas@corferiasinn.com', 0, 1, 0, '0000-00-00 00:00:00', 1, '{"show_contact_category":"","show_contact_list":"","presentation_style":"","show_name":"","show_position":"","show_email":"","show_street_address":"","show_suburb":"","show_state":"","show_postcode":"","show_country":"","show_telephone":"","show_mobile":"","show_fax":"","show_webpage":"","show_misc":"","show_image":"","allow_vcard":"","show_articles":"","show_profile":"","show_links":"","linka_name":"","linka":false,"linkb_name":"","linkb":false,"linkc_name":"","linkc":false,"linkd_name":"","linkd":false,"linke_name":"","linke":"","contact_layout":"","show_email_form":"","show_email_copy":"","banned_email":"","banned_subject":"","banned_text":"","validate_session":"","custom_reply":"","redirect":""}', 0, 8, 1, '(57-1) 321 213 4240', '', '', '', '', '*', '2011-11-18 16:33:47', 43, '', '2014-01-21 16:46:57', 43, '', '', '{"robots":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0),
1468(2, 'Gerencia', 'gerencia', '', 'Cll 24 D # 40-76', 'Bogota', 'Cundinamarca', 'Colombia', '111321', '(57-1) 2446834', '', '', '', 'gerencia@corferiasinn.com', 0, 1, 0, '0000-00-00 00:00:00', 2, '{"show_contact_category":"","show_contact_list":"","presentation_style":"","show_name":"","show_position":"","show_email":"","show_street_address":"","show_suburb":"","show_state":"","show_postcode":"","show_country":"","show_telephone":"","show_mobile":"","show_fax":"","show_webpage":"","show_misc":"","show_image":"","allow_vcard":"","show_articles":"","show_profile":"","show_links":"","linka_name":"","linka":false,"linkb_name":"","linkb":false,"linkc_name":"","linkc":false,"linkd_name":"","linkd":false,"linke_name":"","linke":"","contact_layout":"","show_email_form":"","show_email_copy":"","banned_email":"","banned_subject":"","banned_text":"","validate_session":"","custom_reply":"","redirect":""}', 0, 8, 1, '(57-1) 321 213 4240 ', '', '', '', '', '*', '2011-11-18 16:35:05', 43, '', '2014-01-21 16:41:04', 43, '', '', '{"robots":"","rights":""}', 0, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0);
1469
1470-- --------------------------------------------------------
1471
1472--
1473-- Table structure for table `hcinn_content`
1474--
1475-- Creation: Jun 21, 2016 at 07:10 PM
1476--
1477
1478DROP TABLE IF EXISTS `hcinn_content`;
1479CREATE TABLE IF NOT EXISTS `hcinn_content` (
1480  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1481  `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.',
1482  `title` varchar(255) NOT NULL DEFAULT '',
1483  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
1484  `introtext` mediumtext NOT NULL,
1485  `fulltext` mediumtext NOT NULL,
1486  `state` tinyint(3) NOT NULL DEFAULT '0',
1487  `catid` int(10) unsigned NOT NULL DEFAULT '0',
1488  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1489  `created_by` int(10) unsigned NOT NULL DEFAULT '0',
1490  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
1491  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1492  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
1493  `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
1494  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1495  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1496  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1497  `images` text NOT NULL,
1498  `urls` text NOT NULL,
1499  `attribs` varchar(5120) NOT NULL,
1500  `version` int(10) unsigned NOT NULL DEFAULT '1',
1501  `ordering` int(11) NOT NULL DEFAULT '0',
1502  `metakey` text NOT NULL,
1503  `metadesc` text NOT NULL,
1504  `access` int(10) unsigned NOT NULL DEFAULT '0',
1505  `hits` int(10) unsigned NOT NULL DEFAULT '0',
1506  `metadata` text NOT NULL,
1507  `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if article is featured.',
1508  `language` char(7) NOT NULL COMMENT 'The language code for the article.',
1509  `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
1510  PRIMARY KEY (`id`),
1511  KEY `idx_access` (`access`),
1512  KEY `idx_checkout` (`checked_out`),
1513  KEY `idx_state` (`state`),
1514  KEY `idx_catid` (`catid`),
1515  KEY `idx_createdby` (`created_by`),
1516  KEY `idx_featured_catid` (`featured`,`catid`),
1517  KEY `idx_language` (`language`),
1518  KEY `idx_xreference` (`xreference`)
1519) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;
1520
1521--
1522-- Dumping data for table `hcinn_content`
1523--
1524
1525INSERT INTO `hcinn_content` (`id`, `asset_id`, `title`, `alias`, `introtext`, `fulltext`, `state`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`, `featured`, `language`, `xreference`) VALUES
1526(1, 33, 'Layouts', 'layouts', '<p>Warp comes with a sophisticated layout system to create any kind of sidebar or widget layout. You can easily manage the sidebar''s positions and widths in the theme administration. Widgets can have different styles and be placed in any position offered by this theme. Each position has its own layout. You can align widgets side-by-side, stack them or choose your own grid layout. Show or hide widgets on mobile devices, while the grid adapts perfectly to your layout.</p>\r\n\r\n<img src="images/yootheme/features_layouts.svg" width="560" height="320" alt="Warp Layout System" title="Warp Layout System" />', '', 1, 2, '2011-05-02 11:45:23', 43, '', '2013-06-25 15:24:10', 42, 0, '0000-00-00 00:00:00', '2011-05-02 11:45:23', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":null,"urlatext":"","targeta":"","urlb":null,"urlbtext":"","targetb":"","urlc":null,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 5, 10, '', '', 1, 776, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1527(2, 34, 'Desayuno Tipo Americano', 'desayuno-tipo-americano', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/tip_americano.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/tip_americano.jpg"></a>\r\n', '\r\n\r\n      <h2 class="uk-margin-top-remove">Saludable</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> 2 tajadas de pan tostado o arepa</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> 2 huevos</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Pueden estar acompañados de queso, jamón, cebolla o tomate, según el gusto del cliente</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Tinto</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Chocolate</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Jugo de naranja</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Jugo de naranja o de mora, de guanábana o de lulo</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Porción de fruta</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>\r\n\r\nValor: Incluido en la tarifa\r\n', 1, 12, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:21:55', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 46, 11, '', '', 1, 186, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1528(3, 35, 'Restaurante', 'restaurante', '<a class="uk-align-medium-right" data-lightbox="width:852;height:480;autoplay:true;" href="http://www.yootheme.com/videos/zoo_video_tour.mp4"><img src="images/yootheme/restaurante2.jpg" width="300" height="141" alt="Nuestro Restaurante de terraza"></a>\r\n\r\n<p>Nuestro servicio de restaurante cuenta con una capacidad de atención para 30 personas en la zona interna y 15 en la terraza.</p>\r\n\r\n<h2>Podra disfrutar</h2>\r\n\r\n<p>De desayuno con jugos naturales, variedad de fruta, panes jamon y queso, huevos al gusto y bebida caleinte.</p>\r\n\r\n\r\n<img class="uk-align-center" src="images/yootheme/restaurante1.jpg" alt="Nuestro restaurante">\r\n\r\n<h2 class="uk-h3">Restaurante Interno</h2>\r\n\r\n<p>Nuestro salón interno de restaurante cuenta con televisión de 32" HD.</p>', '', 1, 10, '2011-05-02 11:47:22', 43, '', '2014-01-21 13:43:07', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:22', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 19, 4, '', '', 1, 136, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1529(4, 36, 'UIkit', 'uikit', '<div class="uk-grid">\r\n			<div class="uk-width-1-1">\r\n\r\n				<div class="uk-button-group">\r\n					<button class="uk-button" type="submit">Button</button>\r\n					<div data-uk-dropdown>\r\n						<a href="#" class="uk-button"><i class="uk-icon-caret-down"></i></a>\r\n						<div class="uk-dropdown uk-dropdown-width-2">\r\n\r\n							<div class="uk-grid">\r\n\r\n								<div class="uk-width-1-2">\r\n									<ul class="uk-nav uk-nav-dropdown uk-panel">\r\n										<li class="uk-nav-header">Header</li>\r\n										<li><a href="#">Item</a></li>\r\n										<li><a href="#">Item</a></li>\r\n										<li class="uk-nav-divider"></li>\r\n										<li><a href="#">Separated item</a></li>\r\n										<li class="uk-parent">\r\n											<a href="#">Parent</a>\r\n											<ul class="uk-nav-sub">\r\n												<li><a href="#">Sub item</a>\r\n													<ul>\r\n														<li><a href="#">Sub item</a></li>\r\n													</ul>\r\n												</li>\r\n											</ul>\r\n										</li>\r\n									</ul>\r\n								</div>\r\n\r\n								<div class="uk-width-1-2">\r\n									<ul class="uk-nav uk-nav-dropdown uk-panel">\r\n										<li class="uk-nav-header">Header</li>\r\n										<li><a href="#">Item</a></li>\r\n										<li><a href="#">Item</a></li>\r\n										<li class="uk-nav-divider"></li>\r\n										<li><a href="#">Separated item</a></li>\r\n										<li class="uk-parent">\r\n											<a href="#">Parent</a>\r\n											<ul class="uk-nav-sub">\r\n												<li><a href="#">Sub item</a>\r\n													<ul>\r\n														<li><a href="#">Sub item</a></li>\r\n													</ul>\r\n												</li>\r\n											</ul>\r\n										</li>\r\n									</ul>\r\n								</div>\r\n\r\n							</div>\r\n\r\n						</div>\r\n					</div>\r\n				</div>\r\n\r\n				<div class="uk-button-group">\r\n					<button class="uk-button uk-button-primary" type="submit">Primary</button>\r\n					<div data-uk-dropdown>\r\n						<a href="#" class="uk-button uk-button-primary"><i class="uk-icon-caret-down"></i></a>\r\n						<div class="uk-dropdown uk-dropdown-small">\r\n							<ul class="uk-nav uk-nav-dropdown">\r\n								<li class="uk-nav-header">Header</li>\r\n								<li><a href="#">Item</a></li>\r\n								<li><a href="#">Item</a></li>\r\n								<li class="uk-nav-divider"></li>\r\n								<li><a href="#">Separated item</a></li>\r\n								<li class="uk-parent">\r\n									<a href="#">Parent</a>\r\n									<ul class="uk-nav-sub">\r\n										<li><a href="#">Sub item</a>\r\n											<ul>\r\n												<li><a href="#">Sub item</a></li>\r\n											</ul>\r\n										</li>\r\n									</ul>\r\n								</li>\r\n							</ul>\r\n						</div>\r\n					</div>\r\n				</div>\r\n\r\n				<div class="uk-button-group">\r\n					<button class="uk-button uk-button-success" type="submit">Success</button>\r\n					<div data-uk-dropdown>\r\n						<a href="#" class="uk-button uk-button-success"><i class="uk-icon-caret-down"></i></a>\r\n						<div class="uk-dropdown">\r\n							<ul class="uk-nav uk-nav-dropdown">\r\n								<li class="uk-nav-header">Header</li>\r\n								<li><a href="#">Item</a></li>\r\n								<li><a href="#">Item</a></li>\r\n								<li class="uk-nav-divider"></li>\r\n								<li><a href="#">Separated item</a></li>\r\n								<li class="uk-parent">\r\n									<a href="#">Parent</a>\r\n									<ul class="uk-nav-sub">\r\n										<li><a href="#">Sub item</a>\r\n											<ul>\r\n												<li><a href="#">Sub item</a></li>\r\n											</ul>\r\n										</li>\r\n									</ul>\r\n								</li>\r\n							</ul>\r\n						</div>\r\n					</div>\r\n				</div>\r\n\r\n				<div class="uk-button-group">\r\n					<button class="uk-button uk-button-danger" type="submit">Danger</button>\r\n					<div data-uk-dropdown>\r\n						<a href="#" class="uk-button uk-button-danger"><i class="uk-icon-caret-down"></i></a>\r\n						<div class="uk-dropdown">\r\n							<ul class="uk-nav uk-nav-dropdown">\r\n								<li class="uk-nav-header">Header</li>\r\n								<li><a href="#">Item</a></li>\r\n								<li><a href="#">Item</a></li>\r\n								<li class="uk-nav-divider"></li>\r\n								<li><a href="#">Separated item</a></li>\r\n								<li class="uk-parent">\r\n									<a href="#">Parent</a>\r\n									<ul class="uk-nav-sub">\r\n										<li><a href="#">Sub item</a>\r\n											<ul>\r\n												<li><a href="#">Sub item</a></li>\r\n											</ul>\r\n										</li>\r\n									</ul>\r\n								</li>\r\n							</ul>\r\n						</div>\r\n					</div>\r\n				</div>\r\n\r\n				<button class="uk-button" type="submit" disabled>Disabled</button>\r\n				<button class="uk-button" data-uk-tooltip title="Bazinga!">Tooltip</button>\r\n\r\n				<button class="uk-button" data-uk-modal="{target:''#modal-1''}">Modal</button>\r\n				<div id="modal-1" class="uk-modal">\r\n					<div class="uk-modal-dialog">\r\n						<button type="button" class="uk-modal-close uk-close"></button>\r\n						<h1>Headline</h1>\r\n						<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n					</div>\r\n				</div>\r\n\r\n				<button class="uk-button" data-uk-offcanvas="{target:''#offcanvas-3''}">Off-canvas</button>\r\n				<button class="uk-button-link" type="submit">Button link</button>\r\n\r\n				<div id="offcanvas-3" class="uk-offcanvas">\r\n\r\n					<div class="uk-offcanvas-bar">\r\n\r\n						<ul class="uk-nav uk-nav-offcanvas uk-nav-parent-icon" data-uk-nav>\r\n							<li><a href="#">Item</a></li>\r\n							<li class="uk-active"><a href="#">Active</a></li>\r\n\r\n							<li class="uk-parent">\r\n								<a href="#">Parent</a>\r\n								<ul class="uk-nav-sub">\r\n									<li><a href="#">Sub item</a></li>\r\n									<li><a href="#">Sub item</a>\r\n										<ul>\r\n											<li><a href="#">Sub item</a></li>\r\n											<li><a href="#">Sub item</a></li>\r\n										</ul>\r\n									</li>\r\n								</ul>\r\n							</li>\r\n\r\n							<li class="uk-parent">\r\n								<a href="#">Parent</a>\r\n								<ul class="uk-nav-sub">\r\n									<li><a href="#">Sub item</a></li>\r\n									<li><a href="#">Sub item</a></li>\r\n								</ul>\r\n							</li>\r\n\r\n							<li><a href="#">Item</a></li>\r\n\r\n							<li class="uk-nav-header">Header</li>\r\n							<li><a href="#"><i class="uk-icon-star"></i> Item</a></li>\r\n							<li><a href="#"><i class="uk-icon-twitter"></i> Item</a></li>\r\n							<li class="uk-nav-divider"></li>\r\n							<li><a href="#"><i class="uk-icon-rss"></i> Item</a></li>\r\n						</ul>\r\n\r\n						<form class="uk-search">\r\n							<input class="uk-search-field" type="search" placeholder="search...">\r\n							<button class="uk-search-close" type="reset"></button>\r\n						</form>\r\n\r\n						<div class="uk-panel">\r\n							<h3 class="uk-panel-title">Title</h3>\r\n							Lorem ipsum dolor sit amet, <a href="#">consetetur</a> sadipscing elitr.\r\n						</div>\r\n\r\n						<div class="uk-panel">\r\n							<h3 class="uk-panel-title">Title</h3>\r\n							Lorem ipsum dolor sit amet, <a href="#">consetetur</a> sadipscing elitr.\r\n						</div>\r\n\r\n					</div>\r\n\r\n				</div>\r\n\r\n				<a href="#" class="uk-close"></a>\r\n				<a href="#" class="uk-close uk-close-alt"></a>\r\n\r\n			</div>\r\n		</div>\r\n\r\n		<hr class="uk-grid-divider">\r\n\r\n		<div class="uk-grid" data-uk-grid-margin>\r\n\r\n			<div class="uk-width-medium-1-2">\r\n\r\n				<div class="uk-grid" data-uk-grid-margin>\r\n\r\n					<div class="uk-width-1-1">\r\n						<ul class="uk-breadcrumb">\r\n							<li><a href="#">Home</a></li>\r\n							<li><a href="#">Blog</a></li>\r\n							<li><span>Category</span></li>\r\n							<li class="uk-active"><span>Post</span></li>\r\n						</ul>\r\n					</div>\r\n\r\n					<div class="uk-width-1-1">\r\n\r\n						<article class="uk-article">\r\n\r\n							<h1 class="uk-article-title">Article title</h1>\r\n\r\n							<p class="uk-article-meta">Written by Super User on 12 April. Posted in Blog</p>\r\n\r\n							<div class="uk-grid" data-uk-grid-margin>\r\n								<div class="uk-width-medium-1-2">\r\n									<a class="uk-thumbnail uk-overlay-toggle" href="#">\r\n										<div class="uk-overlay">\r\n											<img src="http://placekitten.com/300/90" alt="">\r\n											<div class="uk-overlay-area"></div>\r\n										</div>\r\n										<div class="uk-thumbnail-caption">Caption</div>\r\n									</a>\r\n								</div>\r\n\r\n								<div class="uk-width-medium-1-2">\r\n									<a class="uk-thumbnail uk-overlay-toggle" href="#">\r\n										<div class="uk-overlay">\r\n											<img src="http://placekitten.com/300/90" alt="">\r\n											<div class="uk-overlay-caption">Caption</div>\r\n										</div>\r\n									<div class="uk-thumbnail-caption">Caption</div>\r\n									</a>\r\n								</div>\r\n							</div>\r\n\r\n							<p class="uk-article-lead">Lorem ipsum dolor sit amet.</p>\r\n							<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>\r\n<pre><code>&lt;div class="myclass"&gt;...&lt;/div&gt;</code></pre>\r\n							<hr class="uk-article-divider">\r\n							<div class="uk-grid" data-uk-grid-margin>\r\n\r\n								<div class="uk-width-medium-1-5">\r\n									<span class="uk-text-muted">text-muted</span><br>\r\n									<span class="uk-text-info">text-info</span><br>\r\n									<span class="uk-text-success">text-success</span><br>\r\n									<span class="uk-text-warning">text-warning</span><br>\r\n									<span class="uk-text-danger">text-danger</span>\r\n								</div>\r\n\r\n								<div class="uk-width-medium-3-10">\r\n									<a href="#">a element</a><br>\r\n									<em>em element</em><br>\r\n									<strong>strong</strong><br>\r\n									<code>code element</code><br>\r\n									<del>del element</del>\r\n								</div>\r\n\r\n								<div class="uk-width-medium-2-5">\r\n									<ins>ins element</ins><br>\r\n									<mark>mark element</mark><br>\r\n									<q>q <q>inside</q> a q element </q><br>\r\n									<abbr title="Abbreviation Element">abbr element</abbr><br>\r\n									<dfn title="Defines a definition term">dfn element</dfn>\r\n								</div>\r\n\r\n								<div class="uk-width-1-1">\r\n									<p class="uk-text-center">\r\n										<span class="uk-badge">Badge</span>\r\n										<span class="uk-badge uk-badge-notification">1</span>\r\n										<span class="uk-badge uk-badge-success">Success</span>\r\n										<span class="uk-badge uk-badge-success uk-badge-notification">4</span>\r\n										<span class="uk-badge uk-badge-warning">Warning</span>\r\n										<span class="uk-badge uk-badge-warning uk-badge-notification">3</span>\r\n										<span class="uk-badge uk-badge-danger">Danger</span>\r\n										<span class="uk-badge uk-badge-danger uk-badge-notification">4</span>\r\n									</p>\r\n								</div>\r\n\r\n								<div class="uk-width-medium-1-2">\r\n									<h1 class="uk-display-inline">h1</h1>\r\n									<h2 class="uk-display-inline">h2</h2>\r\n									<h3 class="uk-display-inline">h3</h3>\r\n									<h4 class="uk-display-inline">h4</h4>\r\n									<h5 class="uk-display-inline">h5</h5>\r\n									<h6 class="uk-display-inline">h6</h6>\r\n								</div>\r\n\r\n								<div class="uk-width-medium-1-2">\r\n									<blockquote>\r\n										<p> Lorem ipsum dolor.</p>\r\n										<small>Someone famous</small>\r\n									</blockquote>\r\n								</div>\r\n\r\n							</div>\r\n\r\n						</article>\r\n\r\n					</div>\r\n\r\n					<div class="uk-width-1-1">\r\n						<ul class="uk-comment-list">\r\n							<li>\r\n								<article class="uk-comment">\r\n									<header class="uk-comment-header">\r\n										<img class="uk-comment-avatar" src="http://placekitten.com/50/50" alt="">\r\n										<h4 class="uk-comment-title">Author</h4>\r\n										<p class="uk-comment-meta">May 2, 2090 at 1:55 pm</p>\r\n									</header>\r\n									<div class="uk-comment-body">\r\n										<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna.</p>\r\n									</div>\r\n								</article>\r\n							</li>\r\n						</ul>\r\n					</div>\r\n\r\n					<div class="uk-width-1-1">\r\n						<ul class="uk-pagination">\r\n							<li class="uk-disabled"><span>«</span></li>\r\n							<li class="uk-active"><span>1</span></li>\r\n							<li><a href="#">2</a></li>\r\n							<li><a href="#">3</a></li>\r\n							<li><a href="#">4</a></li>\r\n							<li><span>...</span></li>\r\n							<li><a href="#">20</a></li>\r\n							<li><a href="#">»</a></li>\r\n						</ul>\r\n					</div>\r\n\r\n				</div>\r\n\r\n			</div>\r\n\r\n			<div class="uk-width-medium-1-2">\r\n\r\n				<div class="uk-grid" data-uk-grid-margin>\r\n\r\n					<div class="uk-width-medium-1-2">\r\n\r\n						<div class="uk-panel">\r\n							<ul class="uk-nav uk-nav-side uk-nav-parent-icon" data-uk-nav>\r\n								<li class="uk-nav-header">Header</li>\r\n								<li class="uk-nav-divider"></li>\r\n								<li class="uk-active"><a href="#">Active</a></li>\r\n								<li class="uk-parent">\r\n									<a href="#">Parent</a>\r\n									<ul class="uk-nav-sub">\r\n										<li><a href="#">Sub item</a></li>\r\n										<li><a href="#">Sub item</a>\r\n											<ul>\r\n												<li><a href="#">Sub item</a></li>\r\n												<li><a href="#">Sub item</a></li>\r\n											</ul>\r\n										</li>\r\n									</ul>\r\n								</li>\r\n								<li><a href="#">Item</a></li>\r\n							</ul>\r\n						</div>\r\n\r\n						<div class="uk-panel uk-panel-divider">\r\n							<h3 class="uk-panel-title">Divider</h3>\r\n							Lorem ipsum <a href="#">dolor</a> sit amet, consectetur adipisicing elit.\r\n						</div>\r\n\r\n						<div class="uk-panel uk-panel-header">\r\n							<h3 class="uk-panel-title">Header</h3>\r\n							Lorem ipsum <a href="#">dolor</a> sit amet, consectetur adipisicing elit.\r\n						</div>\r\n\r\n					</div>\r\n\r\n					<div class="uk-width-medium-1-2">\r\n\r\n						<div class="uk-panel uk-panel-box">\r\n							<h3 class="uk-panel-title">Box</h3>\r\n							Lorem ipsum <a href="#">dolor</a> sit amet, consectetur adipisicing elit.\r\n						</div>\r\n\r\n						<div class="uk-panel uk-panel-box uk-panel-box-primary">\r\n							<h3 class="uk-panel-title">Box primary</h3>\r\n							Lorem ipsum <a href="#">dolor</a> sit amet, consectetur adipisicing elit.\r\n						</div>\r\n\r\n						<div class="uk-panel uk-panel-box uk-panel-box-secondary">\r\n							<h3 class="uk-panel-title">Box secondary</h3>\r\n							Lorem ipsum <a href="#">dolor</a> sit amet, consectetur adipisicing elit.\r\n						</div>\r\n\r\n					</div>\r\n\r\n				</div>\r\n\r\n				<div class="uk-grid" data-uk-grid-margin>\r\n\r\n					<div class="uk-width-1-2">\r\n						<div class="uk-alert" data-uk-alert>\r\n							<a class="uk-alert-close uk-close"></a>\r\n							<p>Info message</p>\r\n						</div>\r\n					</div>\r\n\r\n					<div class="uk-width-1-2">\r\n						<div class="uk-alert uk-alert-success" data-uk-alert>\r\n							<a class="uk-alert-close uk-close"></a>\r\n							<p>Success message</p>\r\n						</div>\r\n					</div>\r\n\r\n					<div class="uk-width-1-2">\r\n						<div class="uk-alert uk-alert-warning" data-uk-alert>\r\n							<a class="uk-alert-close uk-close"></a>\r\n							<p>Warning message</p>\r\n						</div>\r\n					</div>\r\n\r\n					<div class="uk-width-1-2">\r\n						<div class="uk-alert uk-alert-danger" data-uk-alert>\r\n							<a class="uk-alert-close uk-close"></a>\r\n							<p>Danger message</p>\r\n						</div>\r\n					</div>\r\n\r\n					<div class="uk-width-1-2">\r\n						<div class="uk-progress">\r\n							<div class="uk-progress-bar" style="width: 55%;">55%</div>\r\n						</div>\r\n					</div>\r\n\r\n					<div class="uk-width-1-2">\r\n						<div class="uk-progress uk-progress-success">\r\n							<div class="uk-progress-bar" style="width: 55%;">55%</div>\r\n						</div>\r\n					</div>\r\n\r\n					<div class="uk-width-1-2">\r\n						<div class="uk-progress uk-progress-warning">\r\n							<div class="uk-progress-bar" style="width: 55%;">55%</div>\r\n						</div>\r\n					</div>\r\n\r\n					<div class="uk-width-1-2">\r\n						<div class="uk-progress uk-progress-danger">\r\n							<div class="uk-progress-bar" style="width: 55%;">55%</div>\r\n						</div>\r\n					</div>\r\n\r\n					<div class="uk-width-1-2">\r\n						<fieldset class="uk-form">\r\n							<legend>Form states</legend>\r\n							<div class="uk-form-row">\r\n								<input type="text" placeholder="Text Input" class="uk-width-1-1">\r\n							</div>\r\n							<div class="uk-form-row">\r\n								<input type="text" placeholder="form-success" value="form-success" class="uk-width-1-1 uk-form-success">\r\n							</div>\r\n							<div class="uk-form-row">\r\n								<input type="text" placeholder="form-danger" value="form-danger" class="uk-width-1-1 uk-form-danger">\r\n							</div>\r\n							<div class="uk-form-row">\r\n								<input type="text" placeholder="form disabled" class="uk-width-1-1" disabled>\r\n							</div>	\r\n						</fieldset>\r\n					</div>\r\n\r\n					<div class="uk-width-1-2">\r\n						<fieldset class="uk-form">\r\n							<legend>Form styles</legend>\r\n							<div class="uk-form-row">\r\n								<input type="text" placeholder="form-large" class="uk-form-large uk-form-width-small">\r\n								<button class="uk-button uk-button-large" type="reset">Large</button>\r\n							</div>\r\n							<div class="uk-form-row">\r\n								<input type="text" placeholder="form-small" class="uk-form-small uk-form-width-small">\r\n								<button class="uk-button uk-button-small" type="reset">Small</button>\r\n							</div>							\r\n							<div class="uk-form-row">\r\n								<input type="text" placeholder="form-blank" class="uk-form-width-small uk-form-blank">\r\n								<button class="uk-button uk-button-mini" type="reset">Mini</button>\r\n							</div>\r\n						</fieldset>\r\n					</div>				\r\n\r\n				</div>\r\n\r\n			</div>\r\n\r\n		</div>\r\n\r\n		<hr class="uk-grid-divider">\r\n\r\n		<div class="uk-grid" data-uk-grid-margin>\r\n\r\n			<div class="uk-width-medium-1-4">\r\n\r\n				<ul class="uk-subnav uk-subnav-line">\r\n					<li class="uk-active"><a href="#">Active</a></li>\r\n					<li><a href="#">Item</a></li>\r\n					<li><span>Disabled</span></li>\r\n				</ul>\r\n\r\n			</div>\r\n			<div class="uk-width-medium-1-4">\r\n\r\n				<ul class="uk-subnav uk-subnav-pill">\r\n					<li class="uk-active"><a href="#">Active</a></li>\r\n					<li><a href="#">Item</a></li>\r\n					<li><span>Disabled</span></li>\r\n				</ul>\r\n\r\n			</div>\r\n			<div class="uk-width-medium-1-4">\r\n\r\n				<ul class="uk-tab" data-uk-tab>\r\n					<li class="uk-active"><a href="#">Active</a></li>\r\n					<li><a href="#">Item</a></li>\r\n					<li class="uk-disabled"><a href="#">Disabled</a></li>\r\n				</ul>\r\n\r\n			</div>\r\n			<div class="uk-width-medium-1-4">\r\n\r\n				<a href="#" class="uk-icon-button uk-icon-github"></a>\r\n				<a href="#" class="uk-icon-button uk-icon-twitter"></a>\r\n				<a href="#" class="uk-icon-button uk-icon-dribbble"></a>\r\n				<a href="#" class="uk-icon-button uk-icon-html5"></a>\r\n\r\n			</div>\r\n		</div>\r\n\r\n		<hr class="uk-grid-divider">\r\n\r\n		<div class="uk-grid uk-grid-divider" data-uk-grid-margin>\r\n			<div class="uk-width-medium-1-4">\r\n\r\n				<ul class="uk-list uk-list-line">\r\n					<li>List item 1</li>\r\n					<li>List item 2</li>\r\n					<li>List item 3</li>\r\n				</ul>\r\n\r\n			</div>\r\n\r\n			<div class="uk-width-medium-1-4">\r\n\r\n				<ul class="uk-list uk-list-striped">\r\n					<li>List item 1</li>\r\n					<li>List item 2</li>\r\n					<li>List item 3</li>\r\n				</ul>\r\n\r\n			</div>\r\n			<div class="uk-width-medium-1-4">\r\n\r\n				<table class="uk-table uk-table-striped uk-table-condensed uk-table-hover">\r\n					<caption>Table caption</caption>\r\n					<thead>\r\n						<tr>\r\n							<th>Table</th>\r\n							<th>Heading</th>\r\n						</tr>\r\n					</thead>\r\n					<tbody>\r\n						<tr>\r\n							<td>Table</td>\r\n							<td>Data</td>\r\n						</tr>\r\n						<tr>\r\n							<td>Table</td>\r\n							<td>Data</td>\r\n						</tr>\r\n					</tbody>\r\n				</table>\r\n\r\n			</div>\r\n			<div class="uk-width-medium-1-4">\r\n\r\n				<dl class="uk-description-list uk-description-list-line">\r\n					<dt>Description lists</dt>\r\n					<dd>Description text.</dd>\r\n					<dt>Description lists</dt>\r\n					<dd>Description text.</dd>\r\n				</dl>\r\n\r\n			</div>\r\n		</div>', '', 1, 2, '2011-05-02 11:47:45', 43, '', '2013-07-15 14:59:22', 42, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:45', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":null,"urlatext":"","targeta":"","urlb":null,"urlbtext":"","targetb":"","urlc":null,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 13, 13, '', '', 1, 170, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1530(5, 37, 'Dummy Content', 'dummy-content', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', '', 1, 2, '2011-05-02 11:48:08', 43, '', '2011-05-02 13:45:48', 42, 0, '0000-00-00 00:00:00', '2011-05-02 11:48:08', '0000-00-00 00:00:00', '', '', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","alternative_readmore":"","article_layout":""}', 2, 14, '', '', 1, 9, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1531(6, 38, 'Features', 'features', '<p class="uk-article-lead">This theme is built on the <a href="http://www.warp-framework.com">Warp framework</a>, a well-engineered theme framework for WordPress and Joomla, and utilizes all of its latest features. The user interface is powered by <a href="http://www.getuikit.com">UIkit</a>, a lightweight and modular front-end framework, which provides the theme''s styling. The theme also comes with a wide range of different <a href="index.php?option=com_content&amp;view=article&amp;id=1&amp;Itemid=103">layouts and widget variations</a>.</p>\r\n\r\n<h2>Styles</h2>\r\n<p>We provide lovingly crafted style variations to give you a glimpse of what is possible with this theme. The built-in theme customizer allows you to modify colors, fonts, sizes and much more without any CSS knowledge. Just choose your colors with the color picker and adjust the theme with only a few clicks. Click on one of the images to see the style.</p>\r\n\r\n<div class="uk-grid">\r\n    <div class="uk-width-1-2">\r\n      <div class="uk-panel uk-panel-box">\r\n        <a class="uk-thumbnail uk-overlay-toggle" href="index.php?option=com_content&amp;view=article&amp;id=6&amp;Itemid=102&amp;style=default">\r\n            <div class="uk-overlay">\r\n                <img src="images/yootheme/features_style_01.jpg" width="390" height="280" alt="Load Style" title="Load Style">\r\n                <div class="uk-overlay-area"></div>\r\n            </div>\r\n            <div class="uk-thumbnail-caption">Default</div>\r\n        </a>\r\n      </div>\r\n    </div>\r\n    <div class="uk-width-1-2">\r\n      <div class="uk-panel uk-panel-box">\r\n        <a class="uk-thumbnail uk-overlay-toggle" href="index.php?option=com_content&amp;view=article&amp;id=6&amp;Itemid=102&amp;style=city">\r\n            <div class="uk-overlay">\r\n                <img src="images/yootheme/features_style_02.jpg" width="390" height="280" alt="Load Style" title="Load Style">\r\n                <div class="uk-overlay-area"></div>\r\n            </div>\r\n            <div class="uk-thumbnail-caption">City</div>\r\n        </a>\r\n        </div>\r\n    </div>\r\n</div>\r\n<div class="uk-grid">\r\n    <div class="uk-width-1-2">\r\n      <div class="uk-panel uk-panel-box">\r\n        <a class="uk-thumbnail uk-overlay-toggle" href="index.php?option=com_content&amp;view=article&amp;id=6&amp;Itemid=102&amp;style=fashion">\r\n            <div class="uk-overlay">\r\n                <img src="images/yootheme/features_style_03.jpg" width="390" height="280" alt="Load Style" title="Load Style">\r\n                <div class="uk-overlay-area"></div>\r\n            </div>\r\n            <div class="uk-thumbnail-caption">Fashion</div>\r\n        </a>\r\n        </div>\r\n    </div>\r\n    <div class="uk-width-1-2">\r\n      <div class="uk-panel uk-panel-box">\r\n        <a class="uk-thumbnail uk-overlay-toggle" href="index.php?option=com_content&amp;view=article&amp;id=6&amp;Itemid=102&amp;style=forest">\r\n            <div class="uk-overlay">\r\n                <img src="images/yootheme/features_style_04.jpg" width="390" height="280" alt="Load Style" title="Load Style">\r\n                <div class="uk-overlay-area"></div>\r\n            </div>\r\n            <div class="uk-thumbnail-caption">Forest</div>\r\n        </a>\r\n        </div>\r\n    </div>\r\n</div>\r\n<div class="uk-grid">\r\n    <div class="uk-width-1-2">\r\n      <div class="uk-panel uk-panel-box">\r\n        <a class="uk-thumbnail uk-overlay-toggle" href="index.php?option=com_content&amp;view=article&amp;id=6&amp;Itemid=102&amp;style=office">\r\n            <div class="uk-overlay">\r\n                <img src="images/yootheme/features_style_05.jpg" width="390" height="280" alt="Load Style" title="Load Style">\r\n                <div class="uk-overlay-area"></div>\r\n            </div>\r\n            <div class="uk-thumbnail-caption">Office</div>\r\n        </a>\r\n        </div>\r\n    </div>\r\n    <div class="uk-width-1-2">\r\n      <div class="uk-panel uk-panel-box">\r\n        <a class="uk-thumbnail uk-overlay-toggle" href="index.php?option=com_content&amp;view=article&amp;id=6&amp;Itemid=102&amp;style=trekking">\r\n            <div class="uk-overlay">\r\n                <img src="images/yootheme/features_style_06.jpg" width="390" height="280" alt="Load Style" title="Load Style">\r\n                <div class="uk-overlay-area"></div>\r\n            </div>\r\n            <div class="uk-thumbnail-caption">Trekking</div>\r\n        </a>\r\n        </div>\r\n    </div>\r\n</div>\r\n<div class="uk-grid">\r\n    <div class="uk-width-1-2">\r\n      <div class="uk-panel uk-panel-box">\r\n        <a class="uk-thumbnail uk-overlay-toggle" href="index.php?option=com_content&amp;view=article&amp;id=6&amp;Itemid=102&amp;style=volcano">\r\n            <div class="uk-overlay">\r\n                <img src="images/yootheme/features_style_07.jpg" width="390" height="280" alt="Load Style" title="Load Style">\r\n                <div class="uk-overlay-area"></div>\r\n            </div>\r\n            <div class="uk-thumbnail-caption">Volcano</div>\r\n        </a>\r\n        </div>\r\n    </div>\r\n    <div class="uk-width-1-2">\r\n      <div class="uk-panel uk-panel-box">\r\n        <a class="uk-thumbnail uk-overlay-toggle" href="index.php?option=com_content&amp;view=article&amp;id=6&amp;Itemid=102&amp;style=stadium">\r\n            <div class="uk-overlay">\r\n                <img src="images/yootheme/features_style_08.jpg" width="390" height="280" alt="Load Style" title="Load Style">\r\n                <div class="uk-overlay-area"></div>\r\n            </div>\r\n            <div class="uk-thumbnail-caption">Stadium</div>\r\n        </a>\r\n      </div>\r\n    </div>\r\n</div>\r\n\r\n\r\n<h2 class="uk-article-title">Parallax</h2>\r\n<p>To use our unique parallax effect, just add the <code>.parallax</code> class to a <code>&lt;div&gt;</code> element and modify it the way you want with the <code>data-*</code> attributes. </p>\r\n\r\n \r\n<table class="uk-table uk-table-striped uk-table-hover">\r\n  <thead>\r\n    <tr>\r\n      <th>Syntax name</th>\r\n      <th>Description</th>\r\n      <th>Default value</th>\r\n    </tr>\r\n  </thead>\r\n  <tbody>\r\n    <tr>\r\n      <td><code>data-sizeratio=""</code></td>\r\n      <td>Defines the height in relation to the width.</td>\r\n      <td><code>0.5</code></td>\r\n    </tr>\r\n    <tr>\r\n      <td><code>data-ratio=""</code></td>\r\n      <td>Defines the effect speed. The higher the value, the more slower the effect speed. <code>"1"</code> is the natural scroll speed.</td>\r\n      <td><code>8</code></td>\r\n    </tr>\r\n    <tr>\r\n      <td><code>data-maxdiff=""</code></td>\r\n      <td>Defines a maximal scroll hight.</td>\r\n      <td><code>false</code></td>\r\n    </tr>\r\n    <tr>\r\n      <td><code>data-start=""</code></td>\r\n      <td>Defines a starting position.</td>\r\n      <td><code>0</code></td>\r\n    </tr>\r\n    <tr>\r\n      <td><code>data-mode=""</code></td>\r\n      <td>Defines, when the parallax effects begins. <code>"inview"</code> starts once the parallax is in view of the browser frame. <code>"dock"</code> starts when the browser frame top docks to the parallax.</td>\r\n      <td><code>inview</code></td>\r\n    </tr>\r\n    <tr>\r\n      <td><code>data-childanimation=""</code></td>\r\n      <td>Defines, if the child element is animated with <code>"true"</code> or <code>"false"</code>.</td>\r\n      <td><code>true</code></td>\r\n    </tr>\r\n    <tr>\r\n      <td><code>data-childdir=""</code></td>\r\n      <td>Defines the direction of child elements. <code>"-1"</code> will scroll to top. <code>"1"</code> will scroll to bottom.</td>\r\n      <td><code>1</code></td>\r\n    </tr>\r\n    <tr>\r\n      <td><code>data-childratio=""</code></td>\r\n      <td>Defines the speed of child elements. <code>"-1"</code> will scroll to top. <code>"1"</code> will scroll to bottom.</td>\r\n      <td><code>3</code></td>\r\n    </tr>\r\n    <tr>\r\n      <td><code>data-childopacity=""</code></td>\r\n      <td>Adds or removes a fade-out effect from child elements by using the value <code>"true"</code> or <code>"false"</code>.</td>\r\n      <td><code>true</code></td>\r\n    </tr>\r\n  </tbody>\r\n</table>\r\n\r\n<h3>Parallax example</h3>\r\n<pre>\r\n&lt;div class="parallax" id="parallax-top-image" data-childopacity="false" data-sizeratio="0.12" data-childdir="1"&gt;\r\n   &lt;div&gt;This is the child element&lt;/div&gt;\r\n&lt;/div&gt;\r\n</pre>\r\n\r\n\r\n<h2 class="uk-article-title">Custom Widgetkit Styles</h2>\r\n<p>We created a custom style for our <a href="index.&amp;php?option=com_content&amp;view=article&amp;id=22&amp;Itemid=144">Widgetkit Slideset</a>, perfectly fitting the theme. To apply this style, follow these steps:</p>\r\n\r\n<h3>Slideset</h3>\r\n<ol>\r\n  <li>Download and unzip the bonus styles package for Widgetkit available in the download area</li>\r\n  <li>Copy the folder <strong>slideset/styles/capture</strong></li>\r\n  <li>Joomla: Paste it to <strong>media/widgetkit/widgets/slideset/styles</strong><br /> WordPress: Paste it to <strong>wp-content/plugins/widgetkit/widgets/slideset/styles</strong></li>\r\n  <li>Now you can select the style "Capture" in the settings of your Widgetkit Slideset</li>\r\n</ol>\r\n\r\n<h2 class="uk-article-title">Social Icons</h2>\r\n\r\n<p>Use the modifier .uk-icon-button class to create an icon button.</p>\r\n\r\n<a href="#" class="uk-icon-button uk-icon-twitter"></a>\r\n<a href="#" class="uk-icon-button uk-icon-rss"></a>\r\n<a href="#" class="uk-icon-button uk-icon-facebook"></a>\r\n<a href="#" class="uk-icon-button uk-icon-flickr"></a>\r\n<a href="#" class="uk-icon-button uk-icon-xing"></a>\r\n<a href="#" class="uk-icon-button uk-icon-google-plus"></a>\r\n<a href="#" class="uk-icon-button uk-icon-youtube"></a>\r\n<a href="#" class="uk-icon-button uk-icon-dribbble "></a>\r\n<a href="#" class="uk-icon-button uk-icon-github"></a>\r\n<p>Here is a little code example how to add them:</p>\r\n<pre>\r\n  &lt;a href=&quot;#&quot; class=&quot;uk-icon-button uk-icon-twitter&quot;&gt;&lt;/a&gt;\r\n  &lt;a href=&quot;#&quot; class=&quot;uk-icon-button uk-icon-facebook&quot;&gt;&lt;/a&gt;\r\n  &lt;a href=&quot;#&quot; class=&quot;uk-icon-button uk-icon-google-plus&quot;&gt;&lt;/a&gt;\r\n</pre>\r\n\r\n<p><a href="http://www.getuikit.com/docs/icon.html" target="blank">Here</a> is an overview of all icons provided by <a href="http://fortawesome.github.io/Font-Awesome/" target="blank">Font Awesome</a>.</p>\r\n', '', 1, 2, '2011-05-02 11:48:41', 43, '', '2013-09-30 15:28:38', 42, 0, '0000-00-00 00:00:00', '2011-05-02 11:48:41', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 41, 15, '', '', 1, 293, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1532(7, 39, 'Nano Theme', 'nano-theme', ' ', '', 1, 2, '2011-05-02 11:49:24', 43, '', '2016-06-29 20:08:35', 1, 0, '0000-00-00 00:00:00', '2011-05-02 11:49:24', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"0","link_titles":"0","show_tags":"0","show_intro":"0","info_block_position":"","show_category":"0","link_category":"0","show_parent_category":"0","link_parent_category":"0","show_author":"0","link_author":"0","show_create_date":"0","show_modify_date":"0","show_publish_date":"0","show_item_navigation":"0","show_icons":"0","show_print_icon":"0","show_email_icon":"0","show_vote":"0","show_hits":"0","show_noauth":"0","urls_position":"0","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 17, 16, '', '', 1, 10800, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1533(8, 40, 'Joomla Templates', 'joomla-templates', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n', '\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 7, '2013-04-12 11:50:02', 43, '', '2013-09-27 08:58:18', 42, 0, '0000-00-00 00:00:00', '2013-04-12 11:50:02', '0000-00-00 00:00:00', '{"image_intro":"images\\/yootheme\\/blog_themes.jpg","float_intro":"none","image_intro_alt":"","image_intro_caption":"","image_fulltext":"images\\/yootheme\\/blog_themes.jpg","float_fulltext":"none","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 40, 1, '', '', 1, 87, '{"robots":"","author":"","rights":"","xreference":""}', 1, '*', ''),
1534(9, 41, 'Beautiful Icons', 'beautiful-icons', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n', '\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 7, '2013-03-15 11:50:30', 43, '', '2013-09-27 09:01:11', 42, 0, '0000-00-00 00:00:00', '2013-03-15 11:50:30', '0000-00-00 00:00:00', '{"image_intro":"images\\/yootheme\\/blog_icons.jpg","float_intro":"none","image_intro_alt":"","image_intro_caption":"","image_fulltext":"images\\/yootheme\\/blog_icons.jpg","float_fulltext":"none","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 9, 3, '', '', 1, 15, '{"robots":"","author":"","rights":"","xreference":""}', 1, '*', ''),
1535(10, 42, 'Warp Framework', 'warp-theme-framework', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n', '\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 7, '2013-03-20 11:50:55', 43, '', '2013-09-27 09:00:13', 42, 0, '0000-00-00 00:00:00', '2013-03-20 11:50:55', '0000-00-00 00:00:00', '{"image_intro":"images\\/yootheme\\/blog_warp.jpg","float_intro":"none","image_intro_alt":"","image_intro_caption":"","image_fulltext":"images\\/yootheme\\/blog_warp.jpg","float_fulltext":"none","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 9, 2, '', '', 1, 18, '{"robots":"","author":"","rights":"","xreference":""}', 1, '*', '');
1536INSERT INTO `hcinn_content` (`id`, `asset_id`, `title`, `alias`, `introtext`, `fulltext`, `state`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`, `featured`, `language`, `xreference`) VALUES
1537(11, 43, 'ZOO Extension', 'zoo-extension', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n', '\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 7, '2013-02-28 11:51:30', 43, '', '2013-09-27 09:04:17', 42, 0, '0000-00-00 00:00:00', '2013-02-28 11:51:30', '0000-00-00 00:00:00', '{"image_intro":"images\\/yootheme\\/blog_zoo.png","float_intro":"none","image_intro_alt":"","image_intro_caption":"","image_fulltext":"images\\/yootheme\\/blog_zoo.png","float_fulltext":"none","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 9, 5, '', '', 1, 6, '{"robots":"","author":"","rights":"","xreference":""}', 1, '*', ''),
1538(12, 44, 'Free Social Icons', 'free-social-icons', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n', '\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 7, '2013-01-14 11:51:53', 43, '', '2013-09-27 09:06:58', 42, 0, '0000-00-00 00:00:00', '2013-01-14 11:51:53', '0000-00-00 00:00:00', '{"image_intro":"images\\/yootheme\\/blog_social_icons.jpg","float_intro":"none","image_intro_alt":"","image_intro_caption":"","image_fulltext":"images\\/yootheme\\/blog_social_icons.jpg","float_fulltext":"none","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 9, 6, '', '', 1, 7, '{"robots":"","author":"","rights":"","xreference":""}', 1, '*', ''),
1539(13, 63, 'Widgetkit', 'widgetkit', '<p>Widgetkit is the next generation tool set for Joomla and WordPress. This toolkit is the first of its kind! It provides a simple and user-friendly way to enrich your websites experience with slideshows, galleries, lightboxes and much more. All widgets make use of modern web technologies like HTML5 markup, CSS3 features and jQuery based JavaScripts. Widgetkit is fully responsive and all widgets and their effects adapt perfectly for all device resolutions. It supports touch gestures and makes use of smooth CSS3 animations. Here is a short feature roundup:</p>\r\n\r\n<h2>Features</h2>\r\n\r\n<ul class="uk-list uk-list-space">\r\n  <li><i class="uk-icon uk-icon-ok"></i> Available for Joomla and WordPress</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> All widgets are fully responsive</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Use shortcodes to show widgets anywhere</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Clean and lightweight code</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Semantic HTML5 markup</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Asset file minification and compression</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Supports touch gestures for mobile devices</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Uses hardware accelerated CSS3 animations</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Built with HTML5, CSS3, PHP 5.3+ and the latest jQuery version</li>\r\n</ul>\r\n\r\n<h2 class="uk-h3">How It Works</h2>\r\n\r\n<p>Widgetkit basically acts as a platform for all our widgets. It installs as a single component in Joomla or as a plugin in WordPress. The Widgetkit dashboard presents you an overview of all widgets. You can create, edit or delete all widgets and their content in one place. And after you have created the content for your first widget, you can either use a shortcode or a module to display your widget anywhere on your website. In fact, you can do both. Because once have you created a widget, you are able to display it multiple times and reuse it on different parts of your website.</p>\r\n\r\n<a class="uk-button" href="http://www.yootheme.com/widgetkit" target="_blank">Visit Website</a>', '', 1, 2, '2011-06-08 11:15:54', 43, '', '2013-06-26 07:21:47', 42, 0, '0000-00-00 00:00:00', '2011-06-08 11:15:54', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":null,"urlatext":"","targeta":"","urlb":null,"urlbtext":"","targetb":"","urlc":null,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 20, 9, '', '', 1, 130, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1540(14, 47, 'Slideshow', 'slideshow', '<p>The Widgetkit Slideshow is the ultimate image and content slideshow for Joomla and WordPress. It''s flexible, easy to customize and completely built with HTML5 and CSS3. </p>\r\n\r\n<h2>Features</h2>\r\n\r\n<ul class="uk-list uk-list-space">\r\n  <li><i class="uk-icon uk-icon-ok"></i> Clean and very lightweight code</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> 17 eye-catching transition effects</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Fully responsive including all effects</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Uses hardware accelerated CSS3 animations</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Supports HTML captions</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Swipe navigation on mobile devices</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Built with HTML5, CSS3, PHP 5.3+ and the latest jQuery version</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Works with Joomla and WordPress</li>\r\n</ul>\r\n\r\n<h2>Slideshow Screen Example</h2>\r\n<p>This is an image slideshow with the famous Ken Burns effect.</p>\r\n[widgetkit id=45]\r\n\r\n<h2>Slideshow Default Example</h2>\r\n<p>This is an image slideshow with eye-catching transition effects.</p>\r\n[widgetkit id=10]\r\n\r\n<h2>Showcase Box Example</h2>\r\n<p>This a content showcase using all the features from the Slideset widget as a navigation. Any kind of HTML content can be used inside the navigation.</p>\r\n[widgetkit id=37]\r\n\r\n<h2>Showcase Button Example</h2>\r\n<p>This is an image slideshow with some nice navigation buttons. You can place any kind of HTML in the navigation buttons.</p>\r\n[widgetkit id=41]\r\n\r\n<h2>Tabs Example</h2>\r\n<p>This is a classic, tabbed slideshow. Tabs can be aligned to the left, right and center.</p>\r\n[widgetkit id=35]\r\n\r\n<h2>Tabs Bar Example</h2>\r\n<p>This is a slideshow with a tabbed navigation bar. Tabs can be aligned to the left, right and center.</p>\r\n[widgetkit id=34]\r\n\r\n<h2>List Example</h2>\r\n<p>This is a slideshow with a vertical tabbed list as a navigation.</p>\r\n[widgetkit id=36]\r\n\r\n<h2>How To Use</h2>\r\n\r\n<p>The Widgetkit Slideshow takes full advantage of the very user-friendly Widgetkit administration user interface. It has never been easier to create and manage all the slideshows and their different slides in one place. After you created a slideshow you can load it anywhere in your theme using shortcodes or the universal Widgetkit Joomla module or WordPress widget.</p>', '', 1, 2, '2011-06-08 11:16:09', 43, '', '2014-01-20 17:06:09', 43, 0, '0000-00-00 00:00:00', '2011-06-08 11:16:09', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 17, 8, '', '', 1, 75, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1541(15, 48, 'Lightbox', 'lightbox', '<p>The Widgetkit Lightbox allows you to view images, HTML and multi-media content on a dark dimmed overlay without having to leave the current page.</p>\r\n\r\n<h2>Features</h2>\r\n\r\n<ul class="uk-list uk-list-space">\r\n  <li><i class="uk-icon uk-icon-ok"></i> Display images, videos, HTML, Iframes, Ajax requests and SWF</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Supports YouTube, Vimeo, MP4 (h.264), WebM and FLV movies</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Group lightboxes and mix different content types</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Responsive design to fit all device resolutions</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Load other widgets in a lightbox</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> 3 different opening and closing transitions</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> 4 different caption styles</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Keyboard and mouse scroll wheel navigation</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Built on the latest jQuery version</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Works with Joomla and WordPress</li>\r\n</ul>\r\n\r\n<h2>Examples</h2>\r\n\r\n<p>Different animations - <code>fade</code>, <code>elastic</code> and <code>none</code></p>\r\n<p class="gallery">\r\n  <a data-lightbox="transitionIn:fade;transitionOut:fade;" href="images/yootheme/widgetkit/lightbox/image1_lightbox.jpg"><img src="images/yootheme/widgetkit/lightbox/image1.jpg" width="180" height="120" alt="Lightbox Image" /></a>\r\n  <a data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/widgetkit/lightbox/image2_lightbox.jpg"><img src="images/yootheme/widgetkit/lightbox/image2.jpg" width="180" height="120" alt="Lightbox Image" /></a>\r\n  <a data-lightbox="transitionIn:none;transitionOut:none;" href="images/yootheme/widgetkit/lightbox/image3_lightbox.jpg"><img src="images/yootheme/widgetkit/lightbox/image3.jpg" width="180" height="120" alt="Lightbox Image" /></a>\r\n</p>\r\n\r\n<p>Different title positions - <code>float</code>, <code>inside</code> and <code>over</code></p>\r\n<p class="gallery">\r\n  <a data-lightbox="group:mygroup1;titlePosition:float" href="images/yootheme/widgetkit/lightbox/image4_lightbox.jpg" title="Title Position: Float"><img src="images/yootheme/widgetkit/lightbox/image4.jpg" width="180" height="120" alt="Lightbox Image" /></a>\r\n  <a data-lightbox="group:mygroup1;titlePosition:inside" href="images/yootheme/widgetkit/lightbox/image5_lightbox.jpg" title="Title Position: Inside"><img src="images/yootheme/widgetkit/lightbox/image5.jpg" width="180" height="120" alt="Lightbox Image" /></a>\r\n  <a data-lightbox="group:mygroup1;titlePosition:over;padding:0" href="images/yootheme/widgetkit/lightbox/image6_lightbox.jpg" title="Title Position: Over and Padding set to 0"><img src="images/yootheme/widgetkit/lightbox/image6.jpg" width="180" height="120" alt="Lightbox Image" /></a>\r\n</p>\r\n\r\n<p>Various examples in one gallery (try also using the keyboard and mouse scroll wheel)</p>\r\n<ul>\r\n  <li><a data-lightbox="group:mygroup2" href="http://www.youtube.com/watch?v=R55e-uHQna0" title="YouTube Video">YouTube</a></li>\r\n  <li><a data-lightbox="group:mygroup2" href="http://vimeo.com/15261921" title="Vimeo Video">Vimeo</a></li>\r\n  <li><a data-lightbox="group:mygroup2;autoplay:true;" href="http://www.yootheme.com/videos/mediaplayer.mp4" title="MP4 (h.264)">MP4 (h.264)</a></li>\r\n  <li><a data-lightbox="group:mygroup2" href="http://www.adobe.com/jp/events/cs3_web_edition_tour/swfs/perform.swf" title="Flash Swf">Swf</a></li>\r\n  <li><a data-lightbox="group:mygroup2" href="#inline" title="Inline Content from the Website">Inline</a></li>\r\n  <li><a data-lightbox="group:mygroup2;width:1000;height:600" title="Iframe" href="http://www.wikipedia.org">Iframe</a></li>\r\n</ul>\r\n\r\n<div style="display: none;">\r\n  <div id="inline" style="width: 400px; height: 100px; overflow: auto;">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</div>\r\n</div>\r\n\r\n<h2>Load Widgets In A Lightbox</h2>\r\n<p>Use <code>#wk-ID</code> to load widgets like slideshows or galleries in a lightbox. For example: <a data-lightbox="width:600;height:300;" href="#wk-50" title="Widgetkit Slideshow">Widgetkit Slideshow</a></p>\r\n<pre>&lt;a data-lightbox=&quot;width:600;height:300;&quot; href=&quot;#wk-10&quot;&gt;Lightbox&lt;/a&gt;</pre>\r\n\r\n<h2>How To Use</h2>\r\n\r\n<p>Use the HTML5 custom data attribute <code>data-lightbox</code> to activate the lightbox. You can set various lightbox parameters to the data attribute. For example:</p>\r\n\r\n<pre>&lt;a data-lightbox=&quot;width:1000;height:600;&quot; href=&quot;http://www.wikipedia.org&quot;&gt;Lightbox&lt;/a&gt;</pre>\r\n\r\n<p>Here is a list of the most common parameters:</p>\r\n\r\n<ul>\r\n  <li><strong>titlePosition</strong> - How should the title show up? (<code>float</code>, <code>outside</code>, <code>inside</code> or <code>over</code>)</li>\r\n  <li><strong>transitionIn</strong> - Set a opening transition. (<code>fade</code>, <code>elastic</code>, or <code>none</code>)</li>\r\n  <li><strong>transitionOut</strong> - Set a closing transition (<code>fade</code>, <code>elastic</code>, or <code>none</code>)</li>\r\n  <li><strong>overlayShow</strong> - Set to <code>true</code> or <code>false</code></li>\r\n  <li><strong>scrolling</strong> - Set to <code>yes</code> or <code>no</code></li>\r\n  <li><strong>width</strong> - Set a width in pixel</li>\r\n  <li><strong>height</strong> - Set a height in pixel</li>\r\n  <li><strong>padding</strong> - Set a padding in pixel</li>\r\n</ul>', '', 1, 2, '2011-06-08 11:16:20', 43, '', '2013-06-25 09:01:31', 42, 0, '0000-00-00 00:00:00', '2011-06-08 11:16:20', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":null,"urlatext":"","targeta":"","urlb":null,"urlbtext":"","targetb":"","urlc":null,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 8, 7, '', '', 1, 27, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1542(16, 49, 'Servicios del Hotel', 'servicios-del-hotel', '<ul class="uk-list uk-list-space">\r\n  <li><i class="uk-icon uk-icon-ok"></i> Bebida de Bienvenida</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Terraza</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Bussiness Center</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Servicios de llamadas locales, nacionales e internacionales</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Internet inalámbrico en todo el hotel</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Restaurante</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Room Service</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Lavandería</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Atención personalizada 24 horas en recepción</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Llamadas  par despertar(a petición del cliente)</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Servicio de médico de urgencias 24 horas(a petición del cliente)</li>\r\n</ul>\r\n\r\n\r\n<div>\r\n  <a data-spotlight="effect:left;" data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/widgetkit/lightbox/image1_lightbox.jpg">\r\n    <img src="images/yootheme/widgetkit/lightbox/image1.jpg" width="180" height="120" alt="Spotlight Image" />\r\n  </a>\r\n  <a data-spotlight="effect:left;" data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/widgetkit/lightbox/image2_lightbox.jpg">\r\n    <img src="images/yootheme/widgetkit/lightbox/image2.jpg" width="180" height="120" alt="Spotlight Image" />\r\n  </a>\r\n  <a data-spotlight="effect:left;" data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/widgetkit/lightbox/image3_lightbox.jpg">\r\n    <img src="images/yootheme/widgetkit/lightbox/image3.jpg" width="180" height="120" alt="Spotlight Image" />\r\n  </a>\r\n</div>\r\n\r\n<div>\r\n  <a data-spotlight="effect:fade;" data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/widgetkit/lightbox/image4_lightbox.jpg">\r\n    <img src="images/yootheme/widgetkit/lightbox/image4.jpg" width="180" height="120" alt="Spotlight Image" />\r\n    <div class="overlay remove-padding"><img src="images/yootheme/widgetkit/lightbox/image4_spotlight.jpg" width="180" height="120" alt="Spotlight Image" /></div>\r\n  </a>\r\n  <a data-spotlight="effect:right;" data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/widgetkit/lightbox/image5_lightbox.jpg">\r\n    <img src="images/yootheme/widgetkit/lightbox/image5.jpg" width="180" height="120" alt="Spotlight Image" />\r\n  </a>\r\n  <a data-spotlight="effect:right;" data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/widgetkit/lightbox/image6_lightbox.jpg">\r\n    <img src="images/yootheme/widgetkit/lightbox/image6.jpg" width="180" height="120" alt="Spotlight Image" />\r\n  </a>\r\n</div>', '', 1, 10, '2011-06-08 11:16:32', 43, '', '2014-01-21 15:10:25', 43, 0, '0000-00-00 00:00:00', '2011-06-08 11:16:32', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 14, 3, '', '', 1, 60, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1543(17, 50, 'Twitter', 'twitter', '<p>The Widgetkit Twitter module is the neatest way to display tweets directly on your website. All displayed tweets get cached so they show up super fast, even if Twitter is not available.</p>\r\n\r\n<h2>Features</h2>\r\n\r\n<ul class="uk-list uk-list-space">\r\n  <li><i class="uk-icon uk-icon-ok"></i> Filter tweets by hashtags, words, from users, to users, referencing users</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Block tweets using a blacklist</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Tweets are cached for high performance</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Tweets show up even if Twitter is not available</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> 3 different styles to show your tweets</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Responsive design to fit all device resolutions</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Built with HTML5 using article and time elements</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Works with Joomla and WordPress</li>\r\n</ul>\r\n\r\n<h2>How To Use</h2>\r\n\r\n<p>Create a Twitter module in Joomla or a Twitter widget in WordPress and publish it in a module position. A lot of options are available to choose which tweets you want to show.</p>\r\n\r\n<p>For example you can show only tweets from a specific user or tweets that contain a certain hash-tag or a specific word. All options can be combined. To filter by more than one word or user use a space between them. For example: <code>yootheme joomla</code>.</p>', '', 1, 2, '2011-06-08 11:16:47', 43, '', '2013-06-25 09:02:12', 42, 0, '0000-00-00 00:00:00', '2011-06-08 11:16:47', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":null,"urlatext":"","targeta":"","urlb":null,"urlbtext":"","targetb":"","urlc":null,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 6, 5, '', '', 1, 21, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1544(18, 51, 'Media Player', 'media-player', '<p>The Widgetkit Media Player is a HTML5 audio and video player completely built with HTML and CSS. You can easily embed video files into your website by using the HTML5 video element. A Flash player fallback is included for all unsupported browsers.</p>\r\n\r\n<h2>Features</h2>\r\n\r\n<ul class="uk-list uk-list-space">\r\n  <li><i class="uk-icon uk-icon-ok"></i> Native playback for modern HTML5 browsers</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Supports MP4 (h.264), WebM, FLV, WMV and MP3 files</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Completely built with HTML and CSS</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Responsive design to fit all device resolutions</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Same UI in all browsers</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Create your own skins</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Flash player fallback for unsupported browsers</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Works with Joomla and WordPress</li>\r\n</ul>\r\n\r\n<h2>Examples</h2>\r\n\r\n<video width="640" height="360" poster="http://www.yootheme.com/videos/mediaplayer.jpg" controls="controls" preload="none">\r\n  <source type="video/mp4" src="http://www.yootheme.com/videos/mediaplayer.mp4" />\r\n</video>\r\n\r\n<p>This is a MP3 Audio Sample:</p>\r\n\r\n<audio src="http://www.yootheme.com/videos/mediaplayer.mp3" type="audio/mp3" controls="control" preload="none"></audio>\r\n\r\n<h2>How To Use</h2>\r\n\r\n<p>Use the HTML5 <code>video</code> element to embed video in your website. For example:</p>\r\n\r\n<pre>&lt;video src="/video.mp4" width="320" height="240"&gt;&lt;/video&gt;</pre>\r\n\r\n<p>You can also provide multiple sources, to add support for the different video formats like h.264, WebM or Ogg:</p>\r\n\r\n<pre>&lt;video width="320" height="240"&gt;\r\n  &lt;source type="video/mp4"  src="/video.mp4" /&gt;\r\n  &lt;source type="video/webm" src="/video.webm" /&gt;\r\n  &lt;source type="video/ogg"  src="/video.ogv" /&gt;\r\n&lt;/video&gt;\r\n</pre>\r\n\r\n\r\n<p>Use the HTML5 <code>audio</code> element to embed MP3 files in your website. For example:</p>\r\n\r\n<pre>&lt;audio src="/audio.mp3" type="audio/mp3"&gt;&lt;/audio&gt;</pre>', '', 1, 2, '2011-07-31 16:01:48', 43, '', '2013-06-25 09:02:31', 42, 0, '0000-00-00 00:00:00', '2011-07-31 16:01:48', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":null,"urlatext":"","targeta":"","urlb":null,"urlbtext":"","targetb":"","urlc":null,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 6, 4, '', '', 1, 15, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1545(19, 52, 'Galeria', 'galeria', '[widgetkit id=23]', '', 1, 2, '2011-07-31 16:02:04', 43, '', '2015-03-11 16:42:24', 1, 0, '0000-00-00 00:00:00', '2011-07-31 16:02:04', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 12, 3, '', '', 1, 44, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1546(20, 53, 'Ubicación', 'ubicacion', '<p>Estamos ubicados estratégicamente cerca del Centro Internacional de Negocios y Exposiciones de Bogotá y a tan solo 2 minutos de la Embajada de los Estados Unidos de America</p>\r\n\r\n[widgetkit id=26]\r\n\r\n\r\n\r\n\r\n\r\n', '', 1, 10, '2011-07-31 16:02:22', 43, '', '2015-08-22 03:48:49', 1, 0, '0000-00-00 00:00:00', '2011-07-31 16:02:22', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 9, 2, '', '', 1, 94, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1547(21, 54, 'Accordion', 'accordion', '<p>The Widgetkit Accordion enables you to display a set of items in a compact space. When clicking on each item''s header, it expands or collapses its content section.</p>\r\n\r\n<h2>Features</h2>\r\n\r\n<ul class="uk-list uk-list-space">\r\n  <li><i class="uk-icon uk-icon-ok"></i> Clean and very lightweight code</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Responsive design to fit all device resolutions</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Smooth transitions on content section toggle</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Option to automatically match the height of varying content</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Option to auto collapse or allow multiple opened items</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Built with HTML5, CSS3, PHP 5.3+ and the latest jQuery version</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Works with Joomla and WordPress</li>\r\n</ul>\r\n\r\n<h2>Example</h2>\r\n\r\n[widgetkit id=30]\r\n\r\n<h2>How To Use</h2>\r\n\r\n<p>The Widgetkit Accordion lets you easily create and manage all the accordion''s contents through the user-friendly Widgetkit administration interface. After you have created an accordion, you can load it anywhere on your website using shortcodes or the universal Widgetkit Joomla module or WordPress widget.</p>', '', 1, 2, '2011-07-31 16:02:38', 43, '', '2013-06-25 14:22:32', 42, 1, '2015-02-12 07:07:29', '2011-07-31 16:02:38', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":null,"urlatext":"","targeta":"","urlb":null,"urlbtext":"","targetb":"","urlc":null,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 10, 1, '', '', 1, 25, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1548(22, 55, 'Slideset', 'slideset', '<p>The Widgetkit Slideset takes your product showcase to the next level. It provides a sleek way to show multiple sets of items and uses smooth effects while looping through them.</p>\r\n\r\n<h2>Features</h2>\r\n\r\n<ul class="uk-list uk-list-space">\r\n  <li><i class="uk-icon uk-icon-ok"></i> Clean and very lightweight code</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Eye-catching transition effects</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Fully responsive including all effects</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Support of named custom sets</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Swipe navigation on mobile phones</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Built with HTML5, CSS3, PHP 5.3+ and the latest jQuery version</li>\r\n  <li><i class="uk-icon uk-icon-ok"></i> Works with Joomla and WordPress</li>\r\n</ul>\r\n\r\n<h2>Slide Example</h2>\r\n<p>The sets are auto generated (4 items per set), item names are shown and it uses the slide effect and navigation buttons.</p>\r\n[widgetkit id=32]\r\n\r\n<h2>Zoom Example</h2>\r\n<p>The sets are arranged manually, sets names are used as a navigation and it uses the zoom effect.</p>\r\n[widgetkit id=33]\r\n\r\n<h2>Drops Example</h2>\r\n<p>The sets show the item names and it uses the drops effect and navigation buttons.</p>\r\n[widgetkit id=49]\r\n\r\n<h2>Deck Example</h2>\r\n<p>This auto generated sets uses prev/next buttons as a navigation and the deck effect.</p>\r\n[widgetkit id=43]\r\n\r\n<h2>How To Use</h2>\r\n\r\n<p>The Widgetkit Slideset takes full advantage of the very user-friendly Widgetkit administration interface. You can create and manage all slidesets and their different items in one place. After you have created a slideset, you can load it anywhere on your website using shortcodes or the universal Widgetkit Joomla module or WordPress widget.</p>', '', 1, 2, '2011-07-31 16:02:55', 43, '', '2013-06-28 15:49:56', 42, 0, '0000-00-00 00:00:00', '2011-07-31 16:02:55', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":null,"urlatext":"","targeta":"","urlb":null,"urlbtext":"","targetb":"","urlc":null,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 10, 0, '', '', 1, 51, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1549(23, 65, 'Widgetkit', 'widgetkit-extension', '<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n', '\r\n\r\n<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>', 1, 7, '2013-03-13 11:50:55', 43, '', '2013-09-27 09:02:09', 42, 0, '0000-00-00 00:00:00', '2013-03-13 11:50:55', '0000-00-00 00:00:00', '{"image_intro":"images\\/yootheme\\/blog_widgetkit.jpg","float_intro":"none","image_intro_alt":"","image_intro_caption":"","image_fulltext":"images\\/yootheme\\/blog_widgetkit.jpg","float_fulltext":"none","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 11, 4, '', '', 1, 3, '{"robots":"","author":"","rights":"","xreference":""}', 1, '*', ''),
1550(24, 70, 'Desayuno Saludable con Granola', 'desayuno-saludable-con-granola', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/desayuno_granola.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/desayuno_granola.jpg"></a>\r\n', '\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Copa de granola con yogurt natural</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> jugo de naranja</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> café o té</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> porción de fruta</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 7.800 cop</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', 1, 12, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:21:40', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 45, 11, '', '', 1, 184, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1551(25, 71, 'Macedonia de Frutas', 'macedonia-de-frutas', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/macedonia.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/macedonia.jpg"></a>\r\n', '\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Porción de frutas endulzada con miel</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> tostadas de pan</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> queso crema y mermelada</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> jugo de naranja</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> café o te</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 7.100 cop </li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>\r\n', 1, 12, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:22:13', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 43, 11, '', '', 1, 181, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1552(26, 72, 'Omelettes', 'omelettes', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/omelettes.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/omelettes.jpg"></a>\r\n', '\r\n<ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Omelette de huevo</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> queso</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> acompañamiento a elección</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> pan tostado</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> porción de fruta</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> jugo de naranja</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> café, té o chocolate</li>\r\n      </ul>\r\n      <h2 class="uk-margin-top-remove">Acompañamientos</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> mazorca</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Champiñones</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Jamón</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Tomate</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 9.000 cop</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', 1, 12, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:22:31', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 44, 11, '', '', 1, 181, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1553(27, 73, 'Desayuno Continental', 'desayuno-continental', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/continental.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/continental.jpg"></a>\r\n', '\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Huevo</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Jamón</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Queso</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Cebolla</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Tomate</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Mantequilla</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Salsa napolitana</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Pan/ Arepa</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Porción de fruta</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Jugo de naranja</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Café</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 6.000 cop </li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', 1, 12, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:21:23', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 44, 11, '', '', 1, 180, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', '');
1554INSERT INTO `hcinn_content` (`id`, `asset_id`, `title`, `alias`, `introtext`, `fulltext`, `state`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`, `featured`, `language`, `xreference`) VALUES
1555(28, 74, 'Quesadillas', 'quesadillas', '<div class="uk-grid" data-uk-grid-margin>\r\n  \r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/quesadilla.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/quesadilla.jpg"></a>\r\n', '\r\n      \r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Quesadillas a elección</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> porción de fruta</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> jugo de naranja</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> café, té o chocolate</li>\r\n      </ul>\r\n<h2 class="uk-margin-top-remove">Quesadillas:</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Rellena de queso + tomate + jamón</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Rellena de queso + tocineta</li>\r\n      </ul>\r\n<h2 class="uk-margin-top-remove">Valor:</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Rellena de queso + tomate + jamón: 6.000 cop </li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Rellena de queso + tocineta: 7.500 cop </li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>\r\n', 1, 12, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:23:00', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 43, 11, '', '', 1, 183, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1556(29, 75, 'Porciones', 'porciones', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <h2 class="uk-margin-top-remove">Incluye</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Papaya</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Melón</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Banano</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Kiwi</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Chocolate</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 7.800 cop</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', '', 1, 12, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:22:46', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 45, 11, '', '', 1, 181, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1557(30, 78, 'Carnes', 'carnes', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/carnes.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/carnes.jpg"></a>\r\n', '\r\n\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Pollo</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> pescado o carne de res a la plancha</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> una salsa a elección</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> dos acompañamientos</li>\r\n</ul>\r\n<h2 class="uk-margin-top-remove">Acompañamientos</h2>\r\n <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> puré de papa con tocineta o cilantro</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Ensalada mini caesar</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Papas a francesa</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Ensalada de tomate y cebolla</li>\r\n      </ul>\r\n\r\n<h2 class="uk-margin-top-remove">Salsas</h2>\r\n <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Blanca con champiñones</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Napolitana con queso por encima</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Salsa de mostaza</li>\r\n\r\n      </ul>\r\n\r\n<h2 class="uk-margin-top-remove">Valor</h2>\r\n <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Pollo con salsa y dos acompañamientos: 20.000 cop</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Carne con salsa napolitana y dos acompañamientos: 20.000 cop</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>\r\n                                     \r\n', 1, 13, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:38:15', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 46, 11, '', '', 1, 183, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1558(31, 79, 'Ensalada Caesar con pollo', 'ensalada-caesar-con-pollo', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/ensalada_caesar.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/ensalada_caesar.jpg"></a>\r\n', '\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Variedad de lechugas</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> croutons de pan</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> pollo</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> queso parmesano</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> acompañado de aderezo especial y/o vinagreta</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 15.000 cop </li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>\r\n\r\n', 1, 13, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:42:29', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 46, 11, '', '', 1, 182, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1559(32, 80, 'Espaguetis', 'espaguetis', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/espagueti.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/espagueti.jpg"></a>\r\n', '\r\n\r\n      \r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Espaguetis</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> salsa a elección</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> acompañados de pan tostado con mantequilla de ajo y queso parmesano</li>\r\n</ul>\r\n<h2 class="uk-margin-top-remove">Salsas</h2>\r\n<ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Clásica bechamel con champiñones y pollo</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Clásica Bolognesa con carne</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 15.700 cop</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>\r\n\r\n + , .\r\n•	: \r\n                     \r\n\r\n\r\n', 1, 13, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:46:58', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 47, 11, '', '', 1, 189, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1560(33, 81, 'Rapidas', 'rapidas', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/hamburguesa.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/hamburguesa.jpg"></a>\r\n', '\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Hamburguesa de carne</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> lechuga</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> tomate</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> cebolla</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> jamón y queso acompañada de papas a la francesa</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 10.000 cop</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>\r\n\r\n', 1, 13, '2011-05-02 11:47:01', 43, '', '2014-01-29 21:58:59', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 44, 11, '', '', 1, 187, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1561(34, 82, 'Salchipapas', 'salchipapas', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/salchipapas.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/salchipapas.jpg"></a>\r\n', '\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> deliciosas papas a la francesa con las mejores salchichas</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> salsa a su elección ( mayonesa, salsa de tomate o bbq)</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 8.000 cop</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>\r\n', 1, 13, '2011-05-02 11:47:01', 43, '', '2014-01-30 14:55:46', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 45, 11, '', '', 1, 183, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1562(35, 83, 'Arepa con hogai', 'arepa-con-hogao', '<div class="uk-grid">\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/yootheme/desayunos/arepahogao.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/yootheme/desayunos/arepahogao.jpg" /></a>\r\n', '\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Arepa paisa a la plancha</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Hogao con carne o pollo</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Queso</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 5.500 cop</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>\r\n', 1, 13, '2011-05-02 11:47:01', 43, '', '2015-07-08 20:55:18', 27, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 47, 11, '', '', 1, 182, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1563(36, 85, 'Bebidas', 'bebidas', '<div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/desayunos/gaseosa.jpg" class="uk-align-right uk-margin-bottom-remove"><img width="150" height="230" src="images/yootheme/desayunos/gaseosa.jpg"></a>\r\n\r\n      <h2 class="uk-margin-top-remove">Gaseosa</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Gaseosa Coca-Cola</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 3.000</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n\r\n<div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/desayunos/jugos.jpg" class="uk-align-right uk-margin-bottom-remove"><img width="150" height="230" src="images/yootheme/desayunos/jugos.jpg"></a>\r\n\r\n      <h2 class="uk-margin-top-remove">Jugos</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Jugos de fruta natural en agua o en leche</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 3.000</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n\r\n\r\n<div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/desayunos/cerveza.jpg" class="uk-align-right uk-margin-bottom-remove"><img width="150" height="230" src="images/yootheme/desayunos/cerveza.jpg"></a>\r\n\r\n      <h2 class="uk-margin-top-remove">Cerveza</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Cerveza club Colombia</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 4.000</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n\r\n<div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/desayunos/malteada.jpg" class="uk-align-right uk-margin-bottom-remove"><img width="150" height="230" src="images/yootheme/desayunos/malteada.jpg"></a>\r\n\r\n      <h2 class="uk-margin-top-remove">Malteadas</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Malteadas de fruta y helado</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 6.500</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>', '', 1, 14, '2011-05-02 11:47:01', 43, '', '2014-01-30 19:44:22', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 67, 11, '', '', 1, 189, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1564(37, 86, 'Vinos', 'vinos', '<div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/desayunos/vinos.jpg" class="uk-align-right uk-margin-bottom-remove"><img width="150" height="230" src="images/yootheme/desayunos/vinos.jpg"></a>\r\n\r\n      <h2 class="uk-margin-top-remove">Vinos</h2>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Copa de malbec</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 8.000 cop</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Copa de chardonay</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 8.000 cop</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n', '', 1, 14, '2011-05-02 11:47:01', 43, '', '2014-01-30 19:42:56', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 67, 11, '', '', 1, 189, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1565(38, 88, 'Postres', 'postres', '<div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="transitionIn:elastic;transitionOut:elastic;" href="images/yootheme/desayunos/postre.jpg" class="uk-align-right uk-margin-bottom-remove"><img width="230" height="150" src="images/yootheme/desayunos/postre.jpg"></a>\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Copa de helado de vainilla con salsa de caramelo o chocolate</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 6.000 cop</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Ensalada de frutas</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 4.000  cop</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Fresas con crema</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Valor: 4.000 cop</li>\r\n      </ul>\r\n    </div>\r\n  </div>\r\n', '', 1, 15, '2011-05-02 11:47:01', 43, '', '2014-01-30 19:42:26', 43, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 69, 11, '', '', 1, 193, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1566(39, 90, 'Carta - Café Bar', 'carta-cafe-bar', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n<p>En Tu Kasa Inn queremos que tengas un momento único siempre…. Como lo logramos, ofreciendo lo mejor:</p>\r\n    <div class="uk-panel uk-panel-box">\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Tinto</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Café con leche: ½ leche ½ café</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Machiatto : café con intensidad media y espuma de leche encima</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Cortado: cafe cortado con 1/3 de leche y espuma</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Latte: ½ café ½ leche y espuma de leche</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Cappuchino: café con poca leche y mucha espuma con canela y chocolate</li>\r\n</ul>\r\n<h2 class="uk-margin-top-remove">Con Ron</h2>\r\n<ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Mojito tradicional: al mejor estilo cubano mezcla de yerba buena + ron blanco + limón + soda</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Daiquiri de limón: el tradicional daiquiri ron blanco + jugo de limón+ azúcar</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Daiquiri de fresa: una mezcla increíble de Ron blanco + jugo de limón + fresas + azúcar</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Cuba libre: deliciosa combinación de ron oscuro + limón y coca cola</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Mai tai: El mejor ron de coco y jugos tropicales (piña, naranja y durazno ) </li>\r\n      </ul>\r\n\r\n\r\n<h2 class="uk-margin-top-remove">Con vodka</h2>\r\n<ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Caipiroska: mezcla que no puedes perderte: jugo de limón + vodka</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Cosmopolitan: combinación de vodka + cointreau + jugo de arándanos y limón</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Sunshine: jugos de naranja, piña y mango + vodka</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Vampiro: combinación de vodka con el dulce sabor de la granadina</li>\r\n      </ul>\r\n\r\n\r\n<h2 class="uk-margin-top-remove">Con otros licores</h2>\r\n<ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Garibaldi: jugo de naranja + cointreau</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> White lady: ginebra+ cointreu + jugo de limón</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Gin tonic: clasica ginebra+ agua tonica + limón</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Alexander: deliciosa mezcla cremosa crema de cacao + ginebra+ crema de leche</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> piña colada: leche de coco + jugo de piña + ron blanco y leche condensada si lo desea</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Margarita: tequila+ cointreau + jugo de limón y azúcar pídalo con el borde de su copa dulce o salado</li>\r\n      </ul>\r\n\r\n\r\n<h2 class="uk-margin-top-remove">Cervezas  Nacionales</h2>\r\n<ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Club Colombia (Roja, Negra, Rubia)</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Aguila</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Poker</li>\r\n      </ul>\r\n\r\n\r\n<h2 class="uk-margin-top-remove">Artesanales del bbc (bogota beer company)</h2>\r\n<ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Chapinero porter</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Monserrate roja</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Candelaria clásica</li>\r\n      </ul>\r\n\r\n<h2 class="uk-margin-top-remove">Extranjeras </h2>\r\n<ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Corona ( pídala michelada)</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Heiniken</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Budweiser</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Miller</li>\r\n      </ul>\r\n    </div>\r\n\r\n  </div>\r\n</div>', '', 1, 16, '2011-05-02 11:47:01', 43, '', '2015-08-22 03:49:21', 1, 0, '0000-00-00 00:00:00', '2011-05-02 11:47:01', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 51, 11, '', '', 1, 197, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1567(40, 183, 'cuartos disponibles', 'cuartos-disponibles', 'INFORMACIÓN DE LA RESERVA', '', 1, 10, '2014-06-16 17:21:16', 43, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2014-06-16 17:21:16', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 1, 1, '', '', 1, 8, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1568(41, 188, 'Plan Conozca Bogotá', 'plan-conozca-bogota', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/slider_home/slide_5.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/slider_home/slide_5.jpg"></a>\r\n', '\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Noche de alojamiento para dos, habitación ejecutiva</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Desayuno tipo americano</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> City tour</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Recorrido por el centro de la ciudad</li>\r\n        \r\n      </ul>\r\n<p style="color:#C01111">NOTA:Tiempo de recorrido es aproximadamente de 5 horas</p>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', 1, 17, '2015-03-10 20:05:04', 1, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2015-03-10 20:05:04', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 1, 6, '', '', 1, 10, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1569(42, 189, 'Plan de Aniversario', 'plan-de-aniversario', '<div class="uk-grid" data-uk-grid-margin="">\r\n<div class="uk-width-medium-1-1">\r\n<div class="uk-panel uk-panel-box"><a data-lightbox="on" href="images/slider_home/slide_1.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/slider_home/slide_1.jpg" border="0" /></a>', '\r\n<ul class="uk-list uk-list-space">\r\n<li>Bebida de bienvenida</li>\r\n<li>Noche de alojamiento para dos, Habitación Ejecutiva</li>\r\n<li>Desayuno</li>\r\n<li>Pétalos de rosa</li>\r\n<li>Media botella de vino</li>\r\n<li><span style="font-size: 12.16px; line-height: 1.3em;">Obsequio</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>', 1, 17, '2015-03-10 20:13:11', 1, '', '2015-09-10 15:49:21', 30, 0, '0000-00-00 00:00:00', '2015-03-10 20:13:11', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 2, 5, '', '', 1, 15, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1570(43, 190, 'Plan de Cumpleaños', 'plan-de-cumpleanos', '<div class="uk-grid" data-uk-grid-margin="">\r\n<div class="uk-width-medium-1-1">\r\n<div class="uk-panel uk-panel-box"><a data-lightbox="on" href="images/slider_home/slide_2.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/slider_home/slide_2.jpg" border="0" /></a>', '\r\n<ul class="uk-list uk-list-space">\r\n<li>Bebida de bienvenida</li>\r\n<li>Noche de alojamiento para dos, Habitación Ejecutiva</li>\r\n<li>Desayuno</li>\r\n<li>Decoración con globos</li>\r\n<li>Media botella de vino</li>\r\n<li>Torta de cumpleaños</li>\r\n<li>Regalo sorpresa para el cumpleañero</li>\r\n</ul>\r\n<p style="color: #c01111;"> </p>\r\n</div>\r\n</div>\r\n</div>', 1, 17, '2015-03-10 20:14:04', 1, '', '2015-09-10 15:51:12', 30, 0, '0000-00-00 00:00:00', '2015-03-10 20:14:04', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 2, 4, '', '', 1, 12, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1571(44, 191, 'Plan por Villa de Leiva y Sitios Turisticos', 'plan-por-villa-de-leiva-y-sitios-turisticos', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/slider_home/slide_8.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/slider_home/slide_8.jpg"></a>\r\n', '\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Noche de alojamiento para dos</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Desayuno tipo americano</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Tour por Villa de leyva y Sitios Turisticos</li>\r\n        \r\n      </ul>\r\n\r\n<p style="color:#C01111">NOTA:El recorrido dura todo un día</p>\r\n    </div>\r\n\r\n  </div>\r\n</div>', 0, 17, '2015-03-10 20:14:43', 1, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2015-03-10 20:14:43', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 1, 3, '', '', 1, 2, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1572(45, 192, 'Plan Salud y belleza', 'plan-salud-y-belleza', '<div class="uk-grid" data-uk-grid-margin="">\r\n<div class="uk-width-medium-1-1">\r\n<div class="uk-panel uk-panel-box"><a data-lightbox="on" href="images/slider_home/slide_4_b.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/slider_home/slide_4_b.jpg" border="0" /></a>', '\r\n<ul class="uk-list uk-list-space">\r\n<li>Alojamiento para dos</li>\r\n<li>Desayuno tipo americano</li>\r\n<li>Traslado aeropuerto-hotel hotel-spa hotel-aeropuerto</li>\r\n<li>Spa (masaje relajante)</li>\r\n</ul>\r\n<p style="color: #c01111;">NOTA:El valor del masaje relajante en el SPA es de $73.000 COP, por persona</p>\r\n</div>\r\n</div>\r\n</div>', 0, 17, '2015-03-10 20:16:21', 1, '', '2015-09-10 15:54:53', 30, 0, '0000-00-00 00:00:00', '2015-03-10 20:16:21', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 2, 2, '', '', 1, 3, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1573(46, 193, 'Plan Visa', 'plan-visa', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/slider_home/slide_3.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/slider_home/slide_3.jpg"></a>\r\n', '\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Alojamiento para dos</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Desayuno tipo americano</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Traslado hotel-embajada</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Traslado hotel-tomada de huella</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Traslado aeropuerto-hotel-aeropuerto (en horarios establecidos)</li>\r\n        \r\n      </ul>\r\n\r\n<p style="color:#C01111">NOTA:No cuenta con retorno hacia el hotel  en el traslado desde la Embajada Americana y donde se toman la huella. </p>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', 1, 17, '2015-03-10 20:17:02', 1, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2015-03-10 20:17:02', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 1, 1, '', '', 1, 11, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1574(47, 194, 'Plan Zipaquira', 'plan-zipaquira', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/slider_home/slide_6.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/slider_home/slide_6.jpg"></a>\r\n', '\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Noche de alojamiento para dos</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Desayuno tipo americano</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Tour por Zipaquira</li>\r\n        \r\n      </ul>\r\n\r\n<p style="color:#C01111">NOTA:Tiempo de espera en la Catedral de Sal es de 2 Horas, en el tour no incluye entrada a la Catedral</p>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', 0, 17, '2015-03-10 20:18:20', 1, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2015-03-10 20:18:20', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 1, 0, '', '', 1, 3, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1575(48, 195, 'Habitación Doble Superior – Cama King', 'habitacion-doble-superior-cama-king', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/habitaciones/habitacion_doble_superior.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/habitaciones/habitacion_doble_superior.jpg"></a>\r\n', '\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> King Size: Areas de 14 mts2. Un ambiente con una cama King.</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Escritorio</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Luz artificial cálida</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Teléfono inalámbrico</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Cajilla de seguridad</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Televisor  LCD 32”Full HD</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', 1, 18, '2015-03-10 20:31:53', 1, '', '0000-00-00 00:00:00', 0, 1, '2015-11-25 20:53:27', '2015-03-10 20:31:53', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 1, 2, '', '', 1, 7, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1576(49, 196, 'Habitación Doble – Cama matrimonial', 'habitacion-doble-cama-matrimonial', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/habitaciones/habitacion_doble.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/habitaciones/habitacion_doble.jpg"></a>\r\n', '\r\n\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Doble: Áreas de 14 mts2. Un ambiente  con una cama matrimonial.</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Escritorio</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Luz artificial cálida</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Teléfono inalámbrico</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Cajilla de seguridad</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Televisor  LCD 32”Full HD</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', 1, 18, '2015-03-10 20:32:29', 1, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2015-03-10 20:32:29', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 1, 1, '', '', 1, 11, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', '');
1577INSERT INTO `hcinn_content` (`id`, `asset_id`, `title`, `alias`, `introtext`, `fulltext`, `state`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`, `featured`, `language`, `xreference`) VALUES
1578(50, 197, 'Habitación Twin – 2 Camas', 'habitacion-twin-2-camas', '<div class="uk-grid" data-uk-grid-margin>\r\n\r\n  <div class="uk-width-medium-1-1">\r\n\r\n    <div class="uk-panel uk-panel-box">\r\n\r\n      <a data-lightbox="on" href="images/habitaciones/habitacion_twin.jpg"><img class="uk-align-right uk-margin-bottom-remove" src="images/habitaciones/habitacion_twin.jpg"></a>\r\n', '\r\n\r\n\r\n      <ul class="uk-list uk-list-space">\r\n        <li><i class="uk-icon uk-icon-ok"></i> Twin: Áreas de 15 mts2. Un ambiente con dos camas.</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Escritorio</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Luz artificial cálida</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Teléfono inalámbrico</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Cajilla de seguridad</li>\r\n        <li><i class="uk-icon uk-icon-ok"></i> Televisor  LCD 32”Full HD</li>\r\n      </ul>\r\n\r\n    </div>\r\n\r\n  </div>\r\n</div>', 1, 18, '2015-03-10 20:33:11', 1, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2015-03-10 20:33:11', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 1, 0, '', '', 1, 29, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1579(51, 199, 'Comentarios', 'comentarios', '<p>Los Comentarios son escritos por nuestros clientes que se han alojado en HOTEL TUKASAINN.</p>', '', 1, 19, '2015-03-10 20:52:53', 1, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2015-03-10 20:52:53', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 1, 0, '', '', 1, 18, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', ''),
1580(52, 200, 'Descripción', 'descripcion', '<h2>HOTEL TUKASAINN</h2>\r\n\r\n<p>El Hotel se encuentra a 100 metros del centro de convenciones de Bogotá. Ofrece conexión Wi-Fi gratuita y llamadas locales gratuitas. Sirve desayunos y alberga un restaurante. </p>\r\n<br>\r\n<p>Presenta un diseño contemporáneo, en tonos rojos y blancos. Las habitaciones tienen suelo laminado y baño privado. Están equipadas con teléfono inalámbrico, cajilla de seguridad, ordenador portátil, TV de pantalla plana y minibar. </p>\r\n<br>\r\n<p>El hotel está a 1 km del Centro Comercial Gran Estación cerca del Museo del Oro y Monserrate. </p>\r\n<br>\r\n<p>El desayuno americano diario incluye huevos, fruta fresca, café y zumos. También hay un restaurante a la carta.</p>\r\n<br>\r\n\r\n<img class="uk-align-center" src="images/yootheme/recepcion.jpg" alt="Nuestro restaurante">', '', 1, 10, '2015-03-11 13:32:46', 1, '', '2015-08-22 03:48:25', 1, 0, '0000-00-00 00:00:00', '2015-03-11 13:32:46', '0000-00-00 00:00:00', '{"image_intro":"","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}', '{"urla":false,"urlatext":"","targeta":"","urlb":false,"urlbtext":"","targetb":"","urlc":false,"urlctext":"","targetc":""}', '{"show_title":"","link_titles":"","show_intro":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","urls_position":"","alternative_readmore":"","article_layout":"","show_publishing_options":"","show_article_options":"","show_urls_images_backend":"","show_urls_images_frontend":""}', 3, 0, '', '', 1, 9, '{"robots":"","author":"","rights":"","xreference":""}', 0, '*', '');
1581
1582-- --------------------------------------------------------