select * from rghb6_ciudadano where documento like 'SELF[documento]' and documento not like password

[?php $user = JFactory::getUser(); $db = JFactory::getDBO(); if($_REQUEST["id_data"] != "") { $db->setQuery("select * from rghb6_ciudadano where documento = '".$_REQUEST["documento"]."' and cf_id <> '".$_REQUEST["id_data"]."'"); $prod = $db->loadObject(); $db->setQuery("select * from rghb6_ciudadano where documento = '".$_REQUEST["documento"]."' and cf_id = '".$_REQUEST["id_data"]."'"); $prod2 = $db->loadObject(); } $session = JFactory::getSession(); $central = $session->get("var23"); $exists = ""; if($prod) { $exists = "1"; } if($central == "1") { //actualizar o guardar ciudadano en intranet central. //obtener intranet central del plugin de autenticación ciudadano: $database = JFactory::getDBO(); $database->setQuery("select * from #__extensions where type = 'plugin' and name = 'plg_authentication_ciudadano' and enabled = 1"); $plug = $database->loadObject(); if($plug and !$prod2 and $exists != "1") { if($plug->params != "") { $plugparams = json_decode($plug->params); if($plugparams) { $url = $plugparams->url; $form->data["url"] = $url; if($url != "") { $query = "select * from rghb6_ciudadano where documento = '".$_REQUEST["documento"]."'"; $sql = rawurlencode(str_replace(array("#"),array("PREFIX"),$query)); $json_url = $url.'/index.php?option=com_formasonline&task=get_sql_data&view=json&sql='.$sql; $result = file_get_contents($json_url); $ociu = NULL; if($result != "") { $jsonobj = json_decode($result); foreach($jsonobj as $row) { $exists = "1"; } } } } } } } echo $exists; ?>

rghb6_ciudadano

documento

#__users

email