Fischer Tirado

How to fix orphaned SQL Server users

2010-05-19T10:05:00.001-07:00

Summary

When you restore a Microsoft SQL Server database on a different machine, you cannot access the database until you fix the permissions.

Detail

The problem is that the user in the database is an "orphan". This means that there is no login id or password associated with the user. This is true even if there is a login id that matches the user, since there is a GUID (called a SID in Microsoft-speak) that has to match as well.

This used to be a pain to fix, but currently (SQL Server 2000, SP3) there is a stored procedure that does the heavy lifting.

All of these instructions should be done as a database admin, with the restored database selected.

First, make sure that this is the problem. This will lists the orphaned users:

EXEC sp_change_users_login 'Report'

If you already have a login id and password for this user, fix it by doing:

EXEC sp_change_users_login 'Auto_Fix', 'user'

If you want to create a new login id and password for this user, fix it by doing:

EXEC sp_change_users_login 'Auto_Fix', 'user', 'login', 'password'

Visual Basic 6.0 - Data Types

2009-07-03T11:51:00.000-07:00

• Byte The Byte data type is an 8-bit variable which can store value from 0 to 255. This data type is very useful for storing binary data. It can also be very useful when sending/receiving byte values to/from a Basic Stamp or PIC.

• Double The Double data type is a 64-bit floating point number used when high accuracy is needed. These variables can range from -1.79769313486232e308 to -4.94065645841247e-324 for negative values and from 4.94065645841247e-324 to 1.79769313486232e308 for positive values.

• Integer The Integer data type is a 16-bit number which can range from -32768 to 32767. Integers should be used when you are working with values that can not contain fractional numbers.

• Long The Long data type is a 32-bit number which can range from -2,147,483,648 to 2,147,483,647. Long variables can only contain non-fractional integer values. I myself use Long variables over Integers for increased performance. Most Win32 functions use this data type for this reason.

• Single The Single data type is a 32-bit number ranging from -3.402823e38 to -1.401298e-45 for negative values and from 1.401298e-45 to 3.402823e38 for positive values. When you need fractional numbers within this range, this is the data type to use.

• String The String data type is usually used as a variable-length type of variable. A variable-length string can contain up to approximately 2 billion characters. Each character has a value ranging from 0 to 255 based on the ASCII character set. Strings are used when Text is involved.

Twitter API PHP

2009-04-20T14:15:00.000-07:00

/*
Ejemplo de instancia
*/

require_once('class/twitter.class.php');

/* Metodo Constructor para Twitter */
$twitter = new Twitter('miusuario','mipass');

// Ejemplo :)
echo "

Todos los mensajes de Fayerwayer

";
echo "

";
print_r($twitter->lineaTiempo('fayerwayer'));
echo "

";

// Quieres realmente postear este mensaje? Descomentalo
//$twitter->postearMensaje('Mi mensaje de pruebas desde API PHP para Twitter por framirez');

// Todos mis seguidores
echo "

Todos mis seguidores

";
echo "

";
print_r($twitter->seguidores());
echo "

";

// Ahora quiero ver todos mis mensajes
echo "

Todos mis mensajes

";
echo "

";
foreach($twitter->lineaTiempo() as $mensajes):
echo "Mensaje: " . $mensajes['mensaje'] . " posteado a las " . $mensajes['hora'] . " desde " . $mensajes['desde'] ."
";
endforeach;
echo "

";

/*

@author: Fabian Ramirez Sepulveda
@email : framirez(ARROB)gurunet.cl
@web : http://www.gurunet.cl/framirez

@desc: Proyecto para tener una API desde PHP mas accesible y facil para usuarios no avanzados.

@metodos:
lineaTiempo( $nickNameAmigo=opcional) - "Nos retorna todos los ultimos 10 mensajes que nuestro amigo o nosotros hemos posteado"
tomarMensaje($idmensaje) - "Nos retorna el detalle completo del mensaje"
postearMensaje($mensaje) - "Posteamos en tiempo real el mensaje desde PHP"
seguidores() - "Nos retorna todos nuestros amigos que nos siguen"
*/

// Libreria necesaria para procesar Xpath
require_once('XPath.class.php');

class Twitter {

var $usuario='';
var $password='';

// Headers de nuestro cliente
var $agente = 'Twitter PHP Class by framirez';
var $headers = array('X-Twitter-Client: Twitter PHP by framirez',
'X-Twitter-Client-Version: 1.0',
'X-Twitter-Client-URL: http://www.gurunet.cl/framirez');

// Curl
var $ch;

// Respuesta
var $respuesta;

var $xml;

function Twitter($usuario=null, $password=null) {
$this->usuario = $usuario;
$this->password = $password;

// Metodo constructor automaticamente llama a Xpath
$this->xml = new XPath();
}
/*
@desc: Retornamos el maximo de 10 mensajes de amigos o mios
*/
function lineaTiempo($nick = null) {

if(empty($nick)):
$this->ch = curl_init("http://twitter.com/statuses/user_timeline.xml");
$this->xml->importFromString($this->setearOpcionesCurl());
else:
$this->ch = curl_init("http://twitter.com/statuses/user_timeline/" . $nick . ".xml");
$this->xml->importFromString($this->setearOpcionesCurl());
endif;

// Xpath Match
$id = $this->xml->match('//id');
$nickname = $this->xml->match('//screen_name');
$texto = $this->xml->match('//text');
$hora = $this->xml->match('//created_at');
$desde = $this->xml->match('//location');
$deDonde = $this->xml->match('//source');

// Variables Temporales
$i=0;
$arregloMensajes = array();

// Recorro el arreglo
for($i=0;$i$arregloMensajes[$i]['id'] = $this->xml->getData($id[$i]);
$arregloMensajes[$i]['usuario'] = $this->xml->getData($nickname[$i]);
$arregloMensajes[$i]['mensaje'] = $this->xml->getData($texto[$i]);
$arregloMensajes[$i]['hora'] = $this->xml->getData($hora[$i]);
$arregloMensajes[$i]['desde'] = $this->xml->getData($desde[$i]);
$arregloMensajes[$i]['donde_proviene'] = $this->xml->getData($deDonde[$i]);
$i++;
endfor;

$this->xml->reset();
return $arregloMensajes;
}

function tomarMensaje($id) {
$this->ch = curl_init("http://twitter.com/statuses/user_timeline.xml");
$this->xml->importFromString($this->setearOpcionesCurl());

// Xpath Match
$id = $this->xml->match('//id');
$nickname = $this->xml->match('//screen_name');
$texto = $this->xml->match('//text');
$hora = $this->xml->match('//created_at');
$desde = $this->xml->match('//location');
$deDonde = $this->xml->match('//source');

// Variables Temporales
$arregloMensajes = array();

// Recorro el arreglo
$arregloMensajes['id'] = $this->xml->getData($id[0]);
$arregloMensajes['usuario'] = $this->xml->getData($nickname[0]);
$arregloMensajes['mensaje'] = $this->xml->getData($texto[0]);
$arregloMensajes['hora'] = $this->xml->getData($hora[0]);
$arregloMensajes['desde'] = $this->xml->getData($desde[0]);
$arregloMensajes['donde_proviene'] = $this->xml->getData($deDonde[0]);

$this->xml->reset();
return $arregloMensajes;
}

function postearMensaje($mensaje) {

if(empty($mensaje)):
die("Debes pasar como parametro el mensaje");
else:
$this->ch = curl_init("http://twitter.com/statuses/update.xml");
$this->xml->importFromString($this->setearOpcionesCurl('status=' . urlencode($mensaje)));
$this->xml->reset();
endif;

return true;
}

function seguidores() {
$this->ch = curl_init("http://twitter.com/statuses/followers.xml");
$this->xml->importFromString($this->setearOpcionesCurl());
// Xpath Match
$id = $this->xml->match('//id');
$nickname = $this->xml->match('//screen_name');
$nombre = $this->xml->match('//name');
$desde = $this->xml->match('//location');
$web = $this->xml->match('//url');
$foto = $this->xml->match('//profile_image_url');
$descripcion = $this->xml->match('//description');

// Variables Temporales
$i=0;
$arregloMensajes = array();

// Recorro el arreglo
for($i=0;$i$arregloMensajes[$i]['id'] = $this->xml->getData($id[$i]);
$arregloMensajes[$i]['nombre'] = $this->xml->getData($nombre[$i]);
$arregloMensajes[$i]['desde'] = $this->xml->getData($desde[$i]);
$arregloMensajes[$i]['usuario'] = $this->xml->getData($nickname[$i]);
$arregloMensajes[$i]['web'] = $this->xml->getData($web[$i]);
$arregloMensajes[$i]['foto'] = $this->xml->getData($foto[$i]);
$arregloMensajes[$i]['descripcion'] = $this->xml->getData($descripcion[$i]);
$i++;
endfor;

$this->xml->reset();
return $arregloMensajes;
}

function setearOpcionesCurl($post=false) {
// Autentificamos
curl_setopt($this->ch, CURLOPT_USERPWD, $this->usuario.':'.$this->password);

if(!empty($post)){
curl_setopt($this->ch, CURLOPT_POST, true);
curl_setopt($this->ch, CURLOPT_POSTFIELDS, $post);
}

curl_setopt($this->ch, CURLOPT_VERBOSE, 1);
curl_setopt($this->ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($this->ch, CURLOPT_USERAGENT, $this->agente);

// Setamos la respuesta
$respuesta = curl_exec($this->ch);
curl_close($this->ch);

unset($this->ch);

return $respuesta;
}

}

?>

Free-Lance: Servicios

2009-02-05T13:31:00.001-08:00

Free-Lance

Se realizan aplicaciones, programas, módulos y formularios para páginas web (HTML o Flash)Asesoramiento completo en el desarrollo de websites, mas de 10 años de experiencia.

TARIFARIO:

Módulos PHP:

(*)	Catálogo de Productos/Servicios	$150
(*)	Tienda Virtual (Catálogo + Carrito + Pago con VISA)	$200
(*)	Administrador de contenido CMS (actualiza paginas en línea)	$150
(*)	Administrador de contenido Multi-Idiomas	$200
(*)	Oportunidades laborales en línea (recluta personal y genera reportes)	$150
(*)	Buscador de Inmuebles (publicacion y venta de inmuebles)	$180
(*)	Envío de postales electrónicas	$100
(*)	Módulo de encuestas en línea (Crear encuestas, reportes, estadísticas)	$120
(*)	Blogs administrables	$100

Formularios PHP:

(*)	Formulario de Contacto	$15
(*)	Formulario Recomienda esta página	$15
(*)	Formulario de Sugerencias	$15
(*)	Formulario de Registro(zona segura con usuario/password)	$50

Formularios Flash:

(*)	Formulario de Contacto	$20
(*)	Formulario Recomienda esta página	$20
(*)	Formulario de Sugerencias	$20

Otras aplicaciones:

Intranets / Extranets (PHP, .Net)
(Depende de la evaluación previa)

(*) Soporte en Hosting y Dominios
(*) Mailing (publicidad sólo a clientes)

Datos de Contacto
Email: fishdev@gmail.com
Messenger: fishercom@hotmail.com

(*) Se aceptan transferencias en viaBCP
(*) Los precios mostrados son de referencia

Flash Cookies: Local Shared Objects

2009-01-23T13:14:00.000-08:00

Flash Cookies: Local Shared Objects

Before Flash MX it was pretty tricky to "remember" the data in a Flash movie. It could be done with a standard browser cookie (which can be hard to implement for someone with intermediate Flash skills), using a server-side script such as PHP or ASP or offline in Flash projector files with the undocumented fscommand "save". Flash MX's Shared objects allow you to store and retrieve the information within a Flash movie easily. Lets see how it works.

What is a local shared object?
Flash MX Shared objects are a new feature that allow you to store information on the clients machine the same way as cookies would and retrieve it at a later time. An example of a suitable application for Shared objects data could be to remember the user's name, the number of the level he last played in a game,his highscore or anything else you can imagine.

Shared objects are stored in .sol files located in the Flash player directory of the user's profile, example: "C:/Documents and
Settings/Administrator/ApplicationData/Macromedia/Flash Player", and have their own format.

Here is a working example of a movie using the Shared Object. Type in your name and age and click on "Save". Then, refresh this page to let Flash read and display the stored data:

Creating a shared object
First, we have to create a local shared object within a Flash movie. To do so,just put this line of code in the first frame of your movie:

local_data = SharedObject.getLocal("user_data");

Now we have created an Object named "local_data" which is associated with a shared object on the local hard-drive named user_data. Note that in the feature, this data can be read from other movies from the same domain that created the Shared Object.

Writing data
Lets store something in our fresh created Shared Object. Lets say, we want to store the user's name and his age in it. To do so, use this:

local_data.data.user_name = "John Smith";
local_data.data.user_age = 23;
local_data.flush()

Note that this code must be in the same level where you have created the Shared Object.

The flush() command is optional, it is used to write the information to disk immediately. If you don't use this command, Flash MX writes the shared object to a file when the SWF movie is closed or when the shared object is garbage-collected because it no longer has any references to it.

Reading data
To retrieve data from a saved Shared Object, just use the following syntax:

stored_user_name = local_data.data.user_name;
stored_user_age = local_data.data.user_age;

Don't forget that you still have to create the local_data shared object first. Now, the user's name is stored in a variable called "stored_user_name" and the user's age in the variable "stored_user_age"and you can use it anywhere in your movie.

You can store more information in one Shared Object file in the same way. Similar to the way how we have saved simple text variables you can store whole arrays and other objects.

Important Point
There are some important things to remember when using the local Shared Objects in your movies:

The primary drawback of shared objects is that it can be overwritten/disabled/erased by the user (right click on the swf, and click on settings), so avoid to store information which is absolutely necessary to let the application work properly. Think of it as an additional feature.

The amount of the information you can store in a local Shared Object from one domain is set to 100 kb by default. If you will try to store more information, the Flash player will ask the user for a permission to increase this limit. Be sure the stage of your movie is at least this is the minimum size Macromedia Flash MX requires to display the dialog box.

Additional information
This tutorial covers the basics of the local Shared Object feature. You can read more about it and take a look at additional features at the Macromedia website:
What is a Shared Object ?
Using local shared objects in Macromedia Flash MX

PHP Input FIlter

2009-01-23T12:23:00.000-08:00

Cleaning up your inputs

Cleaning up your inputs from $_POST, $GET and $_REQUEST is an important task if you’re looking at security of your PHP applications. You can prevent most kinds on Cross Site Scripting (XSS) attacks if you know how to clean up the user inputs. Here’s how to do it using an Input filtering class from PHP Classes. To get started, head over to the PHP Classes page for the Input Filter Class by Daniel Morris and download the class file.

Once you get the class file, here’s how you can go about cleaning up your input variables.

< ?php $before = $_REQUEST['before']; $myFilter = new InputFilter(); $after = $myFilter->process($before); echo $after; ?>

So if you pass the string “<>alert(’xss’);< /script> to the before in the code above, the input filter changes this to alert(’xss’); after removing the script tags. All you have to do is to instantiate the InputFilter class with the following line:

$myFilter = new InputFilter();

and run your string to be processed using the process class:

$after = $myFilter->process($before);

You can also send entire arrays to be processed by the InputFilter class:

$_POST = $myFilter->process($_POST);

This class can also be used to remove specific HTML tags from your input string. Let’s say for example, you want to remove all the bold tags <> and <> from your html string, all you need to do is :

< ?php include 'class.inputfilter.php'; $before = $_REQUEST['before']; $tags = array("b","strong"); $myFilter = new InputFilter($tags, array(),1, 1); $after = $myFilter->process($before); echo $after; ?>

If we pass the string “<> test< /strong> <>hello world< /em>” the output of the script will be “test <>hello world < /em>”

If you’d like to retain only the <> and <> tags in the above example, change line 4 to read

$myFilter = new InputFilter($tags, array(),0, 1);

This will change the output to <>test < /strong> hello world

Let’s break up the constructor for the InputFilter class :

InputFilter($tagsArray, $attrArray, $tagsMethod , $attrMethod);

$tagsArray is an array of user defined tags

$arrtArray is an array of user defined attributes

$tagsMethod = 0 or 1 where 0 is used when only user defined tags should be allowed. 1 is used to strip the user defined tags.

Similarly $attrMethod is used to retain user defined attributes is it’s set as 0 and to strip user defined attributes if set to 1.

Let’s see the attribute filtering provided by this class in action. Let’s take the following html string as an example:

< xsrc="test.jpg" mce_src="test.jpg" target="_blank" onclick="dosomething();" onmouseover="dosomethingelse();">

Let’s make an filter to just retain the src and target attributes in the html above

$tags = array("img","b"); $attr = array("src","target"); $myFilter = new InputFilter($tags, $attr,0, 0); $after = $myFilter->process($before);

It’s as simple as that.

Curriculum Vitae

2004-09-06T13:57:00.000-07:00

Fischer Tirado Enco
Analista de Sistemas
MCAD ID: 3086009
fishdev@gmail.com

EXPERIENCIA PROFESIONAL

Asix S.A. / Lima, Perú (Junio 2000 – presente)
Asesores, proveedores de soluciones integrales y desarrolladores de software enfocados en generar valor en empresas del sector privado y entidades del gobierno.

Jefe de Sistemas
· Dirección y desarrollo de proyectos en aplicaciones internet, intranets, extranets y workflows para clientes como Backus, Banco de Crédito del Perú, Telefónica del Perú, Telecom Italia Mobile, entre otros.
· Desarrollo de los módulos de administración de contenido e integración de plataformas y bases de datos para viaBCP, viaPersonal y viaInmuebles del Banco de Crédito.
· Implementación y asesoría para el desarrollo de la plataforma web de Backus. A través de esta plataforma, Backus genera más de US$80,000 mensuales de ingresos por la compra de cerveza Cristal y souvenirs.

Media S.A. / Lima, Perú (Diciembre 1999 – Abril 2000)
Asesores, proveedores de soluciones integrales y desarrolladores de sistemas.

Analista y Desarrollador de Sistemas
· Desarrollo de módulos de solicitudes de información y rediseño del web-site del Banco Santander Central Hispano (BSCH).
· Desarrollo del sistema de control de clientes para el área de ventas de Media S.A.
· Desarrollo del sistema de control de itenerarios a nivel internet para Serlipsa- Swissport.
· Desarrollo de módulos de búsqueda, rediseño y administración de contenido del web-site de Tekno.

Banco de Crédito / Lima, Perú (Agosto 1999 – Noviembre 1999)

Analista Programador
· Desarrollo del Directorio Telefónico en ambiente Web usando SQL Server 6.5, ASP, DHTML.
· Actualización del Sistema de Reportes de Tasas y Tarifas (Desarrollado para su intranet).
· Desarrollo del Sistema de Control de Proyectos y Registro de Horas en ambiente Web usando SQL 6.5, ASP, DHTML.

Cyberlink S.A. / Lima, Perú (Enero 1999 – Julio 1999)
Asesores, proveedores de soluciones integrales y desarrolladores de sistemas.

Analista Programador
· Modulo de mantenimiento para un kiosko multimedia interactivo del Banco Wiese Sudameris.
· Participación en el desarrollo del Nuevo Sistema de Trámite Documentario ONP(workflow desarrollado en ASP y SQL 7).

FORMACION ACADEMICA

Diploma Técnico en Tecnologías de la Información.
Institución: Instituto Superior Julio Cesar Tello, Lima – Perú. Graduación: Diciembre 1997.

OTRA EXPERIENCIA

· Lenguajes de Programación: Visual Studio 6.0, Visual Studio .Net (C#, VB, Web Services), ODBC, OLEDB Providers, Component Services, ASP, PHP, XML, WML, WAP, DHTML, JavaScript.
· Bases de Datos: MS. SQL Server 7.0/2000, Oracle 8i/9i PL/SQL, MySQL, MS. Access.
· Plataformas de Desarrollo: WINDOWS NT/2000, MS Internet Information Server, Exchange Server, UNIX – LINUX, Apache Server, Oracle Internet Application Server.
· Aplicativos: Macromedia Dreamweaver MX, Macromedia Flash MX, Internet Explorer 4.0/5.5/6.0, Netscape Navigator 4.7 - 7.0, MS Office 2000, Adobe Photoshop 7.0.

Cursos Adicionales

Agosto 1998 Telematic – INICTELSeminario CONTEC ‘98 (Comercio Electrónico, dynamic HTML, MS Exchange Server, Site Server, Lotus Notes, Novell Netware 5.0, MS Internet Information Server)

Marzo 1999 Microsoft PerúDeveloper Days (Track 1 Desarrollando aplicaciones en 3 capas, Windows DNA)

Enero 2000 Microsoft PerúDeveloper Days (Track 1 Desarrollando aplicaciones con Windows 2000)

Marzo 2001 Microsoft PerúCurso de Comercio Electrónico (MS Comerse Server 2000, BizTalk Server, XML)

Marzo 2002 Oracle PerúThink 9i (Oracle 9i, OAS, J2EE, Servlets, Portlets)

Diciembre 2002 Microsoft PerúDeveloper Days (Desarrollo de aplicaciones en VS .Net, Internet Mobile ToolKit, Web Services)

Agosto - Diciembre 2003 Microsoft Perú (Cibertec)
Developing Microsoft ASP.NET Web Applications Using Visual Studio .NET
Developing Microsoft .NET Applications for Windows (Visual Basic .NET)
Building COM+ Applications Using Microsoft .NET Enterprise Services
Developing XML Web Services Using Microsoft ASP.NET
Exámenes de certificación MCAD aprobados:
Exam 70–305*: Developing and Implementing Web Applications with Microsoft Visual Basic® .NET and Microsoft Visual Studio® .NET
Exam 70–306*: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
Exam 70–310*: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework