<?php
function load_template($vista,  $data=array()) {
    $CI = &get_instance();
  
    $CI->load->view('templates/header',  $data);
    
    if ($vista != "main/main_view") {
		if (!empty($data['breadcrumb'])){
			$data['nivel_usuario']=ca_nivel_usuario();
			$CI->load->view('templates/breadcrumb', $data);
		}
	}
	$CI->load->view($vista,  $data);
	

	
    $CI->load->view('templates/footer',  $data);
}


function generatePassword($length = 9, $strength = 0) {
    $vowels = 'aeuy';
    $consonants = 'bdghjmnpqrstvz';
    if ($strength & 1) {
        $consonants .= 'BDGHJLMNPQRSTVWXZ';
    }
    if ($strength & 2) {
        $vowels .= "AEUY";
    }
    if ($strength & 4) {
        $consonants .= '23456789';
    }
    if ($strength & 8) {
        $consonants .= '@#$%';
    }
    
    $password = '';
    $alt = time() % 2;
    for ($i = 0; $i < $length; $i++) {
        if ($alt == 1) {
            $password .= $consonants[(rand() % strlen($consonants))];
            $alt = 0;
        } else {
            $password .= $vowels[(rand() % strlen($vowels))];
            $alt = 1;
        }
    }
    return $password;
}



function dejar_numericos($cadena){
	return preg_replace('/[^\d-]/', '', $cadena);
}


function dejar_alfanumericos($cadena){
	return preg_replace('/[^\w-_]/', '', $cadena);
}

function dejar_alfanumericos_y_espacios($cadena){
	return preg_replace('/[^\s\w-_]/', '', $cadena);
}

function registrar_evento($controlador, $tipo_evento, $descripcion ,$usuario_id=0, $galeria_id=0, $media_id=0, $comentario_id=0, $grupo_id=0){
        $CI = &get_instance();
		
		$CI->load->helper('tiempo');
		
		
		$fecha_ahora_mysql = unix_to_mysql(timestamp_now());

        if ($CI->db->query('INSERT INTO log (date, controller, type, description, uid, gid, mid, cid, group_id) VALUES(\''.$fecha_ahora_mysql .'\',\''. $controlador .'\',\''.$tipo_evento.'\',\''. $descripcion .'\',\''. $usuario_id .'\',\''. $galeria_id .'\',\''. $media_id .'\',\''. $comentario_id .'\',\''. $grupo_id .'\')' )) {
            return 0;
        }else{
            return -1;
        }
}


function buscar_portada_aux($gid){
	$CI = &get_instance();
	$subsubgrupos = $CI->db->query('select * from groups where parent=\''. $gid . '\' ORDER BY RAND()');
	if ($subsubgrupos->num_rows()>0){
		foreach ($subsubgrupos->result() as $sg){
			if (ca_es_grupo_visible($sg->gid)){
				$subgrupo = $CI->db->query('select * from groups where gid=\''. $sg->gid . '\' ORDER BY RAND()');
				$galeria_principal = $subgrupo->row()->main_gallery;
				if ($galeria_principal!=0){
					$galeria = $CI->db->query('select * from galleries where gid=\''. $galeria_principal . '\'');
					if (count($galeria->result())>0){
						return $galeria->row()->gid;
					}
					else {
						return 0;
					}
				}
			}
		}		
		foreach ($subsubgrupos->result() as $sg){
			if (ca_es_grupo_visible($sg->gid)){
				return buscar_portada_aux($sg->gid);		
			}
		}
	}
	return 0;		
}


function buscar_portada_grupo($sg){
	 $CI = &get_instance();
	$subgrupo = $CI->db->query('select * from groups where gid=\''. $sg->gid . '\' ORDER BY RAND()');
	
	if (! ca_es_grupo_visible($subgrupo->row()->gid)){
		$sg->cover = '../../no_cover';
		return;
	}
	
	$galeria_principal = $subgrupo->row()->main_gallery;
	if ($galeria_principal!=0){
		$galeria = $CI->db->query('select * from galleries where gid=\''. $galeria_principal . '\'');
		
		if ((count($galeria->result())>0) && ca_es_galeria_visible($galeria->row()->gid)){
			$sg->cover = $galeria->row()->cover;	
		}
		else {
			$sg->cover = '../../no_cover';
		}
		
	}
	else {
		 $galeria_seleccionada = buscar_portada_aux($sg->gid);
		 if ($galeria_seleccionada>0) {
		 	$galeria = $CI->db->query('select * from galleries where gid=\''. $galeria_seleccionada . '\'');
		 	$sg->main_gallery = $galeria_seleccionada;
		 	$sg->cover = $galeria->row()->cover;
		 }
		 else {
		 	$sg->cover = '../../no_cover';
		 }
	}		
}

function buscar_portada($subgrupos){
	foreach ($subgrupos as $sg){
		buscar_portada_grupo($sg);
	}
}


function grupo_esta_vacio($gid){
	$CI = &get_instance();
	$subgrupos = $CI->db->query('select * from groups where parent=\''. $gid . '\'');
	
	if ($subgrupos->num_rows() == 0){
		$galerias = $CI->db->query('select * from galleries where group_id=\''. $gid . '\'');
		if ($galerias->num_rows() == 0){
			return TRUE;
		}
	}
	return FALSE;
}


?>