<?php $valor = $_GET["valor"]; echo desencriptar($valor); function encriptar($cadena) { $key = 'ilumovil'; // Una clave de codificacion, debe usarse la misma para encriptar y desencriptar $encrypted = base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_256, md5($key), $cadena, MCRYPT_MODE_CBC, md5(md5($key)))); return $encrypted; //Devuelve el string encriptado } function desencriptar($cadena) { $key = 'ilumovil'; // Una clave de codificacion, debe usarse la misma para encriptar y desencriptar $decrypted = rtrim(mcrypt_decrypt(MCRYPT_RIJNDAEL_256, md5($key), base64_decode($cadena), MCRYPT_MODE_CBC, md5(md5($key))), ""); return $decrypted; //Devuelve el string desencriptado }
function getResultadoEvaluacionNoSPAC($idEvaluacion, $idCompetencia) { global $conn; $params = array(":idcompetencia" => $idCompetencia, ":idusuario" => $idEvaluacion); $sql = "SELECT rc_id, rc_valor FROM rrhh.rrc_relacomptencia, rrhh.rre_resultadoevaluacion WHERE rc_id = re_idrelacompetencia AND rc_fechabaja IS NULL AND re_fechabaja IS NULL AND rc_idcompetencia = :idcompetencia AND re_idusuario = :idusuario"; $stmt = DBExecSql($conn, $sql, $params); $minValor = 9999; while ($row = DBGetQuery($stmt)) { $valor = substr(desencriptar($row["RC_VALOR"]), strlen($row["RC_ID"])); if ($valor < $minValor) $minValor = $valor; } switch ($minValor) { case 1: $result = "Estadio Inicial"; break; case 2: $result = "En Desarrollo"; break; case 3: $result = "Consolidado"; break; case 4: $result = "Referencia e Influencia"; break; default: $result = ""; } return $result; }
":idcompetencia" => $row["EC_ID"], ":idusuario" => $idEvaluacion); $sql = "SELECT rc_descripcion, rc_id, re_idrelacompetencia FROM rrhh.rrc_relacomptencia, rrhh.rre_resultadoevaluacion WHERE rc_id = re_idrelacompetencia(+) AND rc_fechabaja IS NULL AND re_fechabaja IS NULL AND rc_idcompetencia = :idcompetencia AND rc_combo = :combo AND re_idusuario(+) = :idusuario ORDER BY rc_orden"; $stmt3 = DBExecSql($conn, $sql, $params); while ($rowOpciones = DBGetQuery($stmt3)) { $selected = (($rowOpciones["RC_ID"] == $rowOpciones["RE_IDRELACOMPETENCIA"])?"selected":""); $html.= "<option ".$selected." value=\"".$rowOpciones["RC_ID"]."\">".substr(desencriptar($rowOpciones["RC_DESCRIPCION"]), strlen($rowOpciones["RC_ID"]))."</option>"; } $html.= "</select></div>"; } $html.= "</div>"; } ?> window.parent.document.getElementById('divNoSPAC').innerHTML = '<?php echo $html; ?> '; setTimeout('ajustarAnchoCombos()', 500); <? }
<? require_once($_SERVER["DOCUMENT_ROOT"]."/constants.php"); require_once($_SERVER["DOCUMENT_ROOT"]."/../Common/database/db_funcs.php"); require_once($_SERVER["DOCUMENT_ROOT"]."/../Common/miscellaneous/general.php"); require_once("crypt.php"); echo strlen(encriptar("1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 1234567890 qwe rty uio pas dfg hjk lñz xcv bnm 123456789 abc def ghi jkl22"))."<br>"; echo strlen(encriptar("________________1____________________________________1______________________________2__________________________3____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________dsfsdfsdfsdfsdfdsfsdfsdf_____"))."<br>"; exit; $sql = "SELECT rc_descripcion, rc_id, rc_valor FROM rrhh.rrc_relacomptencia"; $stmt = DBExecSql($conn, $sql); while ($row = DBGetQuery($stmt)) { $params = array(":descripcion" => encriptar($row["RC_ID"].$row["RC_DESCRIPCION"]), ":id" => $row["RC_ID"], ":valor" => encriptar($row["RC_ID"].$row["RC_VALOR"])); $sql = "UPDATE rrhh.rrc_relacomptencia SET rc_descripcion = :descripcion, rc_valor = :valor WHERE rc_id = :id"; // DBExecSql($conn, $sql, $params); echo substr(desencriptar($row["RC_VALOR"]), strlen($row["RC_ID"]))." - ".substr(desencriptar($row["RC_DESCRIPCION"]), strlen($row["RC_ID"]))."<br/>"; } echo "OK<br />"; echo "*** CORRERLO SOLO UNA VEZ ***<br />"; ?>
/** * Realiza la Decodificacion de un valor encriptado * @param string $valor <p>El valor a desencriptar</p> * @return string <p>La cadena desencriptada</p> */ function desencriptarValor($valor) { return desencriptar($valor, CLAVE_AES); }