function Login()
{
$link = Conectarse();
$consulta = "SELECT * FROM [022BDCOMUN].DBO.USUARIOS\r\nWHERE usuario='{$this->user}' AND contrasena='{$this->pass}' AND idtipousuario=2 ";
$resultado = mssql_query($consulta, $link) or die(mssql_error());
$fila = mssql_fetch_array($resultado);
if (!$fila[0]) {
echo '<script>
alert("Usuario o Password errados, por favor verifique.")
self.location = "/adm-reserva/"
</script>';
} else {
if (!isset($_SESSION)) {
@session_start();
}
$_SESSION['id_usuario'] = $fila['id_usuario'];
$_SESSION['nombres'] = $fila['nombres'];
$_SESSION['apellidos'] = $fila['apellidos'];
$_SESSION['starsoft'] = $fila['starsoft'];
$_SESSION['idempresa'] = $fila['idempresa'];
$_SESSION['idarea'] = $fila['idarea'];
$_SESSION['aud_jefe'] = $fila['aud_jefe'];
header("Location: /adm-reserva/home");
}
}
function Registrar($nombres, $apellidos, $dni, $starsoft, $tipousuario, $area)
{
$link = Conectarse();
$consulta = "SELECT * from [022BDCOMUN].DBO.usuarios WHERE dni='{$dni}'";
$resultado = mssql_query($consulta) or die(mssql_error());
if (mssql_num_rows($resultado) == 0) {
$SQL = "INSERT INTO [022BDCOMUN].dbo.usuarios(nombres,apellidos,dni,starsoft,\r\n \tidarea,idempresa,usuario_starsoft,centro_costos,aud_jefe,usuario,contrasena,\r\n \tidtipousuario)\r\n VALUES('{$nombres}','{$apellidos}','{$dni}','{$starsoft}','{$area}','1','','','',\r\n \t'{$dni}','{$dni}','{$tipousuario}')";
$RESULT = mssql_query($SQL);
if (!$RESULT) {
echo "<script>\r\n\t alert('Error');\r\n\t window.location='/adm-reserva/consulta/usuarios';\r\n\t </script>";
} else {
header('Location: /adm-reserva/consulta/usuarios');
}
} else {
echo "<script>\r\n\t alert('Ya esta registrado');\r\n\t window.location='/adm-reserva/consulta/usuarios';\r\n\t </script>";
}
}
private function _connect()
{
switch ($this->_engine) {
case "mssql":
$this->_dbhandle = mssql_connect($this->_server, $this->_user, $this->_pass);
if (!$this->_dbhandle) {
die('No pudo conectarse: ' . mssql_error());
}
$selected = $this->_selectdb();
break;
case "mysql":
$this->_dbhandle = mysql_connect($this->_server, $this->_user, $this->_pass);
if (!$this->_dbhandle) {
die('No pudo conectarse: ' . mysql_error());
}
mysql_set_charset('utf8', $this->_dbhandle);
$selected = $this->_selectdb();
break;
}
}
function Existe($nrorequi, $usuario, $solicitante)
{
$link = Conectarse();
$consulta = "SELECT * from [010BDCOMUN].DBO.REQUISC where NROREQUI='{$nrorequi}' AND \r\nCODSOLIC='{$solicitante}'";
$resultado = mssql_query($consulta) or die(mssql_error());
if (mssql_num_rows($resultado) == 0) {
echo "<script>\r\n alert('No existe el RQ o no te pertenece');\r\n window.location='/reserva/pages/registrar-rq';\r\n </script>";
} else {
$consulta1 = "SELECT * from [022BDCOMUN].DBO.AUD_RQ where NROREQUI='{$nrorequi}' AND \r\nCODSOLIC='{$solicitante}'";
$resultado1 = mssql_query($consulta1) or die(mssql_error());
if (mssql_num_rows($resultado1) == 0) {
$SQL = "INSERT INTO AUD_RQ VALUES('{$nrorequi}','{$solicitante}','RQ','{$usuario}',GETDATE(),'P','','','')";
$RESULT = mssql_query($SQL);
if (!$RESULT) {
echo "<script>\r\nalert('Error al Registrar);\r\nwindow.location='/reserva/pages/registrar-rq';\r\n</script>";
} else {
echo "<script>\r\nalert('Registro exitoso');\r\nwindow.location='/reserva/pages/registrar-rq';\r\n</script>";
}
} else {
echo "<script>\r\n alert('YA ESTA REGISTRADO');\r\n window.location='/reserva/pages/registrar-rq';\r\n </script>";
}
}
}
function AgregarArticulo($kit, $codigo, $cantidad)
{
$link = Conectarse();
$consulta = "SELECT * FROM [010BDCOMUN].DBO.MAEART WHERE ACODIGO='{$codigo}'";
$resultado = mssql_query($consulta) or die(mssql_error());
if (mssql_num_rows($resultado) == 0) {
echo "<script>\r\nalert('No existe el código');\r\nwindow.location='/reserva/pages/kit-reparacion?id={$kit}';\r\n</script>";
} else {
$consulta = "SELECT * FROM [022BDCOMUN].DBO.KITS_REPARACION \r\nWHERE CODKIT='{$kit}' AND CODART='{$codigo}'";
$resultado = mssql_query($consulta) or die(mssql_error());
if (mssql_num_rows($resultado) == 0) {
$SQL = "INSERT INTO [022BDCOMUN].DBO.KITS_REPARACION\r\n(CODART,CODKIT,CANART,KDESCRI,KUNIDAD,FECHA_CREACION)\r\n SELECT ACODIGO,'{$kit}','{$cantidad}',ADESCRI,AUNIDAD,GETDATE() from \r\n [010BDCOMUN].DBO.MAEART WHERE \r\nACODIGO='{$codigo}'";
$RESULT = mssql_query($SQL);
if (!$RESULT) {
echo "error";
} else {
echo "<script>\r\n\twindow.location='/reserva/pages/kit-reparacion?id={$kit}';\r\n\t</script>";
}
} else {
echo "<script>\r\nalert('Ya esta registrado');\r\nwindow.location='/reserva/pages/kit-reparacion?id={$kit}';\r\n</script>";
}
}
}
<?php
ob_start();
session_start();
include 'dbconn.php';
include 'header_info.php';
include '../conn/conn_x.php';
//error_reporting( error_reporting() & ~E_WARNING);
//error_reporting( error_reporting() & ~E_NOTICE );
$url_i_ = $_SESSION['url'] = print_r($_REQUEST['url_i'], true);
$token = $_SESSION['token'] = print_r($_REQUEST['token_i'], true);
include '../track/track.php';
echo 'Download starting....<br/>';
$token_check_s = mssql_query("SELECT * FROM wasp_planet.dbo.f_token WHERE token ='{$token}'", $dbhandle) or die(mssql_error());
//May not be running
$token_s = mssql_fetch_array($token_check_s);
//May not be running
$row_d = mysql_fetch_assoc($url_check);
if ($token_s) {
if ($token_s['used'] == 0) {
/* Download Documenting */
$display_u = "SELECT * FROM games WHERE url = '{$url_i_}'";
$display_u_proc = mysql_query($display_u);
$row_u = mysql_fetch_assoc($display_u_proc);
$g_id = $row_u["g_id"];
$u_id = $row_u["u_id"];
$used = 1;
//Update used to 1
$used_update = mssql_query("UPDATE wasp_planet.dbo.f_token SET used = '1' WHERE token = '{$token}'", $dbhandle);
if ($used_update) {
?>
public function fetch_value($table, $field, $condition = null)
{
if (!$table || !$field) {
exit("Arguments Missing !!");
}
$query = "select {$field} from {$table}";
if ($condition != null) {
$query = "select {$field} from {$table} where {$condition}";
}
$this->query = $query;
$this->result = mssql_query($query) or $this->setError(mssql_error(), mssql_errno());
if ($this->result) {
$this->rows = intval(mssql_num_rows($this->result));
$this->row = mssql_fetch_object($this->result);
return $this->row->{$field};
}
}
<div class="row">
<form action="../procesos/registrarconsultarkit.php" method="POST">
<input type="hidden" name="tipo" value="rep">
<div class="col-md-12">
<h3 class="text-success">CONSULTAR KIT DE REPARACIÓN</h3>
<div class="form-group">
<select name="codigo" class="form-control"required>
<option value="">[SELECCIONAR]</option>
<?php
$link = Conectarse();
$SQL = "SELECT CODKIT,KDESCRI FROM KITS_REPARACION WHERE KUNIDAD='REP'\r\nORDER BY CODKIT";
$RESULT = mssql_query($SQL) or die(mssql_error());
while ($row = mssql_fetch_array($RESULT)) {
?>
<option value ="<?php
echo $row['CODKIT'];
?>
">
<?php
echo $row['CODKIT'] . ' - ' . $row['KDESCRI'];
?>
</option>
<?php
}
?>
</select>
</div>
<?php
// Establish connection
$host = $PHPSPLOIT["HOST"];
$user = $PHPSPLOIT["USER"];
$pass = $PHPSPLOIT["PASS"];
$conn = @mssql_connect($host, $user, $pass);
if (!$conn) {
return error("ERROR: %s: %s", @mssql_errno(), @mssql_error());
}
//@mssql_close($connect);
// NOTE:
// commented due to a bug in rare servers (bug found in iis6.0/php5.2.11)
return "OK";
public function getServerVersion($driver, $dbIP, $dbPort, $dbUser, $dbPasswd, $dbSourcename)
{
if (strlen(trim($dbIP)) <= 0) {
$dbIP = DB_HOST;
}
if ($link = @mssql_connect($dbIP, $dbUser, $dbPasswd)) {
@mssql_select_db(DB_NAME, $link);
$oResult = @mssql_query("select substring(@@version, 21, 6) + ' (' + CAST(SERVERPROPERTY ('productlevel') as varchar(10)) + ') ' + CAST(SERVERPROPERTY('productversion') AS VARCHAR(15)) + ' ' + CAST(SERVERPROPERTY ('edition') AS VARCHAR(25)) as version; ", $link);
$aResult = @mssql_fetch_array($oResult);
@mssql_free_result($oResult);
$v = $aResult[0];
} else {
throw new Exception(@mssql_error($link));
}
return isset($v) ? $v : 'none';
}
public function getErrorMsg()
{
$msg = '';
if ($this->conn_id) {
$msg = mssql_error($this->conn_id);
} else {
$msg = mssql_error();
}
return $msg;
}
public function connect()
{
if ($this->connected) {
return $this->connected;
}
$failed = false;
try {
$this->db = mssql_connect($this->url, $this->auth1, $this->auth2) or $failed = true;
if ($failed && $this->debug) {
echo "Could not connect to database: " . htmlspecialchars(mssql_error());
}
} catch (Exception $e) {
$failed = true;
}
if ($failed) {
$this->connected = false;
return false;
} else {
mssql_select_db($this->dbname, $this->db) or $failed = true;
if ($failed && $this->debug) {
echo "Could not select database named '" . htmlspecialchars($this->dbname) . "': " . mysqli_error();
$this->connected = false;
return false;
}
$this->connected = true;
return true;
}
}
function ReservaVacia($reserva, $usuario)
{
$link = Conectarse();
$consulta = "SELECT C.NRORESERVA,C.OT,C.USUARIO,C.CENTROCOSTO,\r\nC.TIPO FROM [022BDCOMUN].DBO.RESERVA_CAB AS C\r\nWHERE C.ESTADO='00' AND C.USUARIO='{$usuario}' AND C.NRORESERVA='{$reserva}'\r\nAND C.NRORESERVA NOT IN (SELECT D.NRORESERVA FROM [022BDCOMUN].DBO.RESERVA_DET AS D)\r\nORDER BY C.NRORESERVA";
$resultado = mssql_query($consulta) or die(mssql_error());
if (mssql_num_rows($resultado) == 0) {
echo "";
} else {
echo "<a href='../procesos/reserva?reserva={$reserva}&tipo=reservavacia'>\r\n<i class='fa fa-trash text-danger fa-3x'></i></a>";
}
}
/**
* Execute a batch query
* @return mixed A database resource if successful, FALSE if not.
*/
function queryBatch($abort_on_error = true, $p_transaction_safe = false)
{
$this->_errorNum = 0;
$this->_errorMsg = '';
if ($p_transaction_safe) {
$si = mssql_get_server_info($this->_resource);
preg_match_all("/(\\d+)\\.(\\d+)\\.(\\d+)/i", $si, $m);
if ($m[1] >= 4) {
$this->_sql = 'START TRANSACTION;' . $this->_sql . '; COMMIT;';
} else {
if ($m[2] >= 23 && $m[3] >= 19) {
$this->_sql = 'BEGIN WORK;' . $this->_sql . '; COMMIT;';
} else {
if ($m[2] >= 23 && $m[3] >= 17) {
$this->_sql = 'BEGIN;' . $this->_sql . '; COMMIT;';
}
}
}
}
$query_split = preg_split("/[;]+/", $this->_sql);
$error = 0;
foreach ($query_split as $command_line) {
$command_line = trim($command_line);
if ($command_line != '') {
$this->_cursor = mssql_query($command_line, $this->_resource);
if (!$this->_cursor) {
$error = 1;
$this->_errorNum .= mssql_errno($this->_resource) . ' ';
$this->_errorMsg .= mssql_error($this->_resource) . " SQL={$command_line} <br />";
if ($abort_on_error) {
return $this->_cursor;
}
}
}
}
return $error ? false : true;
}
$retval = mssql_query($sql);
if (!$retval) {
die('Could not enter data: ' . mssql_error());
}
if ($retval) {
header('Location:viewtags.php?id=' . $dbid);
//http_redirect("viewtags.php", array("id" => $dbid), true, HTTP_REDIRECT_PERM);
}
exit;
}
} else {
if ($_SERVER["REQUEST_METHOD"] == "GET") {
if (isset($_GET['tid']) && is_numeric($_GET['tid']) && $_GET['tid'] > 0) {
// query database
$tid = $_GET['tid'];
$resTag = mssql_query("SELECT * FROM RM_Tag WHERE TagID={$tid}") or die(mssql_error());
$rowTag = mssql_fetch_array($resTag);
if ($rowTag) {
//TagCode, TagName, TagOrder, TagIsActive , InstantCustomerCampaignID_C
// get data from database
$formData['TagID'] = $rowTag['TagID'];
$formData['TagCode'] = $rowTag['TagCode'];
$formData['TagName'] = $rowTag['TagName'];
$formData['TagOrder'] = $rowTag['TagOrder'];
$formData['TagIsActive'] = $rowTag['TagIsActive'];
$formData['InstantCustomerCampaignID_C'] = $rowTag['InstantCustomerCampaignID_C'];
}
}
}
}
?>
function mssql_to_table($sql)
{
$fields_array = array();
$num_fields = 0;
$num_row = 0;
// find position of "FROM" in query
$fpos = strpos($sql, 'from');
// get string starting from the first word after "FROM"
$strfrom = substr($sql, $fpos + 5, 50);
// Find position of the first space after the first word in the string
$Opos = strpos($strfrom, ' ');
//Get table name. If query pull data from more then one table only first table name will be read.
$table = substr($strfrom, 0, $Opos);
// Get result from query
$result = mssql_query($sql) or die('Invalid query: ' . mssql_error());
$num_row = mssql_numrows($result);
print '<html>';
print '<head><title>';
print 'View ' . $table . '</title>';
print '<link rel="stylesheet" href="style.css">';
print "</head>";
print '<body><br>';
if ($num_row > 0) {
//Get number of fields in query
$num_fields = mssql_num_fields($result);
# get column metadata
$i = 0;
//Set table width 15% for each column
$width = 15 * $num_fields;
print '<br><table width=' . $width . '% align="center"><tr>';
print '<tr><th colspan=' . $num_fields . '>View ' . $table . '</th></tr>';
while ($i < $num_fields) {
//Get fields (columns) names
$meta = mssql_fetch_field($result);
$fields_array[] = $meta->name;
//Display column headers in upper case
print '<th><b>' . strtoupper($fields_array[$i]) . '</b></th>';
$i = $i + 1;
}
print '</tr>';
//Get values for each row and column
while ($row = mssql_fetch_row($result)) {
print '<tr>';
for ($i = 0; $i < $num_fields; $i++) {
//Display values for each row and column
print '<td>' . $row[$i] . '</td>';
}
print '</tr>';
}
}
return;
}
public function show_error()
{
return mssql_error($this->link);
}
function mxsql_error()
{
global $db_type;
if ($db_type == 'mysql') {
return mysql_error();
} else {
return mssql_error();
}
}
</script>
</head>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-3 column">
<form action="../registrar/copia-reporte.php" method="POST">
<div class="form-group">
<label for="">ORDEN DE TRABAJO:</label>
<select name="ot" class="form-control" required autofocus>
<option value="">[SELECCIONAR]</option>
<?php
include '../bd/conexionSQL.php';
$linkSQL = ConectarseSQL();
$Sql = "SELECT CODIGOOT FROM [020BDCOMUN].DBO.CENCOSOT \n WHERE USUARIO in ('4','6')\n AND\nCODIGOOT IN (SELECT OF_COD FROM [011BDCOMUN].dbo.ORD_FAB\nWHERE OF_ESTADO ='ACTIVO') ORDER BY CODIGOOT";
$result = mssql_query($Sql) or die(mssql_error());
while ($row = mssql_fetch_array($result)) {
?>
<option value ="<?php
echo $row['CODIGOOT'];
?>
"><?php
echo $row['CODIGOOT'];
?>
</option>
<?php
}
?>
</select>
</div>
private function execute_mssql($sSQL)
{
try {
//$this->oTfw->set_sql($sSQL);
$oResult = mssql_query($sSQL);
//@mssql_query("SET NAMES utf8");
if (!$oResult) {
$sMensaje = "Sentencia SQL con errores: " . mssql_error() . "\n";
$sMensaje .= "SQL =" . $sSQL;
die($sMensaje);
}
} catch (Exception $e) {
}
}
<?php
//Proceso de conexión con la base de datos
include '../bd/conexion.php';
$link = Conectarse();
//Iniciar Sesión
session_start();
//Validar si se está ingresando con sesión correctamente
if (!$_SESSION) {
echo '<script language = javascript>
alert("usuario no autenticado")
self.location = "/codrise/compras/carga-de-datos/acceso"
</script>';
}
$id_usuario = $_SESSION['id_usuario'];
$consulta = "SELECT apellidos,dni FROM [020BDCOMUN].DBO.USUARIOS\r\n\tWHERE id_usuario='" . $id_usuario . "'";
$resultado = mssql_query($consulta, $link) or die(mssql_error());
$fila = mssql_fetch_array($resultado);
$apellidos = $fila['apellidos'];
$edad = $fila['edad'];
protected function throwMssqlException()
{
throw new jqGrid_Exception_DB(mssql_error(), null, mssql_errno());
}
