04 Project - Business intelligence
include('./php_lib/conexion.php');
?>
include('./includes/header.php');
?>
include('./includes/top.php');
// Recuperamos la categoria si la hay seleccionada
if(isset($_GET["vid_cat_id"]) && is_numeric($_GET["vid_cat_id"]) && $_GET["vid_cat_id"]<=1000){
$vid_cat_id=$_GET["vid_cat_id"];
$sql="SELECT * FROM categoria WHERE cat_tipo1='0' AND cat_activo='1' AND cat_id='".$vid_cat_id."' ";
$result=mysql_query($sql,$database);
if($num_reg=mysql_num_rows($result)==1){
$reg = mysql_fetch_object($result);
$vid_cat_id = $reg->cat_id;
} else {
$sql="SELECT * FROM categoria WHERE cat_tipo1='0' AND cat_activo='1' LIMIT 1";
$result=mysql_query($sql,$database);
if($num_reg=mysql_num_rows($result)>0){
$reg = mysql_fetch_object($result);
$vid_cat_id = $reg->cat_id;
}
}
}else{
$sql="SELECT * FROM categoria WHERE cat_tipo1='0' AND cat_activo='1' LIMIT 1";
$result=mysql_query($sql,$database);
if($num_reg=mysql_num_rows($result)>0){
$reg = mysql_fetch_object($result);
$vid_cat_id = $reg->cat_id;
}
}
if(isset($_GET["vid_subcat_id"]) && is_numeric($_GET["vid_subcat_id"]) && $_GET["vid_subcat_id"]<=1000){
$vid_subcat_id=$_GET["vid_subcat_id"];
$sql="SELECT * FROM categoria WHERE cat_tipo1='0'
AND cat_tipo2='1'
AND cat_cat_id='".$vid_cat_id."'
AND cat_activo='1'
AND cat_id='".$vid_subcat_id."' ";
$result=mysql_query($sql,$database);
if($num_reg=mysql_num_rows($result)==1){
$reg = mysql_fetch_object($result);
$vid_subcat_id = $reg->cat_id;
} else {
$sql="SELECT * FROM categoria WHERE cat_tipo1='0' AND cat_tipo2='1' AND cat_cat_id='".$vid_cat_id."' AND cat_activo='1' LIMIT 1";
$result=mysql_query($sql,$database);
if($num_reg=mysql_num_rows($result)>0){
$reg = mysql_fetch_object($result);
$vid_subcat_id = $reg->cat_id;
}
}
}else{
$sql="SELECT * FROM categoria WHERE cat_tipo1='0' AND cat_tipo2='1' AND cat_cat_id='".$vid_cat_id."' AND cat_activo='1' LIMIT 1";
$result=mysql_query($sql,$database);
if($num_reg=mysql_num_rows($result)>0){
$reg = mysql_fetch_object($result);
$vid_subcat_id = $reg->cat_id;
}
}
?>
Soporte
La zona de soporte le proporciona acceso a vídeos informativos y documentación para usuarios. Accediendo como cliente autenticado tendrá acceso a documentación más precisa y detallada.
global $database;
$sql="SELECT * FROM categoria WHERE
cat_tipo1='0'
AND cat_tipo2='0'
AND cat_activo='1' ";
$result=mysql_query($sql,$database);
if($num_reg=mysql_num_rows($result)>0){ // Existe
?>
Categoría:
global $database;
$sql="SELECT * FROM categoria WHERE
cat_tipo1='0'
AND cat_tipo2='1'
AND cat_cat_id='".$vid_cat_id."'
AND cat_activo='1' ";
$result_subcat=mysql_query($sql,$database);
if($num_reg_subcat=mysql_num_rows($result_subcat)>0){ // Existe
?>
Subcategoría:
} else { ?>
Lo sentimos, no hay subcategorias que mostrar.
}
?>
Vídeos
} // Fin del IF
global $database;
$sql="SELECT * FROM video_publico, categoria WHERE
vid_cat_id=cat_id
AND cat_tipo1='0'
AND cat_tipo2='1'
AND cat_activo='1'
AND vid_cat_id='".$vid_subcat_id."'
AND vid_activo='1'
ORDER BY vid_orden DESC";
$result=mysql_query($sql,$database);
if($num_reg=mysql_num_rows($result)>0){ // Existe
// Cargamos la variable con los datos
while($reg = mysql_fetch_object($result)){
?>
Notice: Undefined variable: reg in /home/vhosts/users/04project.es/webdocs/http/soporte.php on line 196
Notice: Trying to get property of non-object in /home/vhosts/users/04project.es/webdocs/http/soporte.php on line 196
Notice: Undefined variable: reg in /home/vhosts/users/04project.es/webdocs/http/soporte.php on line 198
Notice: Trying to get property of non-object in /home/vhosts/users/04project.es/webdocs/http/soporte.php on line 198
} // Fin Fin del WHILE
} // Fin del IF
?>
Acceso clientes
Para un soporte más completo,
acceda con sus datos de cliente:
Documentos
global $database;
$sql="SELECT * FROM descarga WHERE des_activo='1' AND des_privada='0' ORDER BY des_orden DESC ";
$result=mysql_query($sql,$database);
if($num_reg=mysql_num_rows($result)>0){ // Existe
// Cargamos la variable con los datos
while($reg = mysql_fetch_object($result)){
?>
Notice: Undefined variable: reg in /home/vhosts/users/04project.es/webdocs/http/soporte.php on line 240
Notice: Trying to get property of non-object in /home/vhosts/users/04project.es/webdocs/http/soporte.php on line 240
Notice: Undefined variable: reg in /home/vhosts/users/04project.es/webdocs/http/soporte.php on line 241
Notice: Trying to get property of non-object in /home/vhosts/users/04project.es/webdocs/http/soporte.php on line 241