AbbyGunZ UploadEmblems

<?php
if(!@session_start())
{
    die("No se pudo iniciar la session");
}
$link = mssql_connect("s00rk","sa","contraseña");
mssql_select_db("GunzDB",$link);

function limpiar($variable)
{
    $original = $variable;
    $search = array('chr(', 'chr=', 'chr%20', '%20chr', 'wget%20', '%20wget', 'wget(',
        'cmd=', '%20cmd', 'cmd%20', 'rush=', '%20rush', 'rush%20',
        'union%20', '%20union', 'union(', 'union=', 'echr(', '%20echr', 'echr%20', 'echr=',
        'esystem(', 'esystem%20', 'cp%20', '%20cp', 'cp(', 'mdir%20', '%20mdir', 'mdir(',
        'mcd%20', 'mrd%20', 'rm%20', '%20mcd', '%20mrd', '%20rm',
        'mcd(', 'mrd(', 'rm(', 'mcd=', 'mrd=', 'mv%20', 'rmdir%20', 'mv(', 'rmdir(',
        'chmod(', 'chmod%20', '%20chmod', 'chmod(', 'chmod=', 'chown%20', 'chgrp%20', 'chown(', 'chgrp(',
        'locate%20', 'grep%20', 'locate(', 'grep(', 'diff%20', 'kill%20', 'kill(', 'killall',
        'passwd%20', '%20passwd', 'passwd(', 'telnet%20', 'vi(', 'vi%20',
        'insert%20into', 'select%20', 'fopen', 'fwrite', '%20like', 'like%20',
        '$_request', '$_get', '$request', '$get', '.system', 'HTTP_PHP', '&aim', '%20getenv', 'getenv%20',
        'new_password', '&icq','/etc/password','/etc/shadow', '/etc/groups', '/etc/gshadow',
        'HTTP_USER_AGENT', 'HTTP_HOST', '/bin/ps', 'wget%20', 'uname\x20-a', '/usr/bin/id',
        '/bin/echo', '/bin/kill', '/bin/', '/chgrp', '/chown', '/usr/bin', 'g\+\+', 'bin/python',
        'bin/tclsh', 'bin/nasm', 'perl%20', 'traceroute%20', 'ping%20', '.pl', 'lsof%20',
        '/bin/mail', '.conf', 'motd%20', 'HTTP/1.', '.inc.php', 'config.php', 'cgi-', '.eml',
        'file\://', 'window.open', '<script>', 'javascript\://','img src', 'img%20src','.jsp','ftp.exe',
        'xp_enumdsn', 'xp_availablemedia', 'xp_filelist', 'xp_cmdshell', 'nc.exe', '.htpasswd',
        'servlet', '/etc/passwd', 'wwwacl', '~root', '~ftp', '.js', '.jsp', 'admin_', '.history',
        'bash_history', '.bash_history', '~nobody', 'server-info', 'server-status', 'reboot%20', 'halt%20',
        'powerdown%20', '/home/ftp', '/home/www', 'secure_site, ok', 'chunked', 'org.apache', '/servlet/con',
        '<script', 'UPDATE', 'SELECT', 'DROP', '/robot.txt' ,'/perl' ,'mod_gzip_status', 'db_mysql.inc', '.inc', 'select%20from',
        'select from', 'drop%20', 'getenv', 'http_', '_php', 'php_', 'phpinfo()', '<?php', '?>', 'sql=');

        $variable = str_replace($search, '', $variable);

        $variable = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$variable);
        $variable = trim($variable);
        $variable = strip_tags($variable);
        $variable = addslashes($variable);
        $variable = str_replace("'", "''", $variable);
        if($original != $variable)
        {
            $variable = "";
        }
    return $variable;
}
function redir($mensaje, $url)
{
        echo "<script>alert('".$mensaje."');window.location = \"".$url."\";</script>";
}

if($_GET['paso'] != 2 && $_GET['paso'] != 3)
{
    ?>
    <form name="emblemaloguear" method="post" action="?paso=2">
        <center>
            Usuario: <input type="text" name="us" /> <br />
            Contrase&ntilde;a: <input type="password" name="pass" /><br />
            <input type="submit" name="loguear" value="Entrar" />
        </center>
    </form>
    <?
}else if($_GET['paso'] == 2){
    $usuario = limpiar($_POST['us']);
    $pass = limpiar($_POST['pass']);
    $sql = mssql_query("SELECT AID FROM [Login] WITH(nolock) WHERE UserID = '".$usuario."' AND Password = '".$pass."'");
    if(mssql_num_rows($sql) != 1)
    {
        redir("Usuario y/o Contraseña Incorrecta","/");
        die();
    }
    $r = mssql_fetch_object($sql);
    $_SESSION['Emblema']['AID'] = $r->AID;

    $sql = mssql_query("SELECT CID FROM Character WITH(nolock) WHERE AID = '".$_SESSION['Emblema']['AID']."'");
    if(!mssql_num_rows($sql))
    {
        redir("No tienes ningun personaje","/");
        die();
    }

    $existe = 0;
    ?>
    <form name="emblemasclans" method="post" enctype="multipart/form-data" action="?paso=3">
        <center>
            Clan: <select name="clanclid">
                    <? while($r = mssql_fetch_object($sql)){
                            $sql0 = mssql_query("SELECT CLID, Name FROM Clan WITH(nolock) WHERE MasterCID = '".$r->CID."'");
                            if(mssql_num_rows($sql0))
                            {
                                $rr = mssql_fetch_object($sql0);
                                ?>
                                <option value="<?=$rr->CLID?>"><?=$rr->Name?></option>
                                <?
                                $existe++;
                            }
                        }
                    ?>
                 </select><br />
            <? if($existe > 0) { ?>
            <input type="file" name="clanemblema" /><br />
            <input type="submit" name="subir" value="Subir Emblema" />
            <? }else{ echo "No eres master de ningun Clan"; session_unset($_SESSION['Emblema']['AID']); } ?>
        </center>
    </form>
    <?
}else if($_GET['paso'] == 3 && is_numeric($_SESSION['Emblema']['AID'])){
    $destino = "./emblemas/";
    $clid = limpiar($_POST['clanclid']);
    $archivo = basename( $_FILES['clanemblema']['name']);
    $ext = pathinfo($archivo);
    $ext = strtolower($ext['extension']);
    if(!is_numeric($clid))
    {
        redir("Error inesperado 0x001","/");
        die();
    }
    if($ext != "jpg" && $ext != "png" && $ext != "jpeg")
    {
        redir("Tipo de archivo no permitido","/");
        die();
    }
    $sql = mssql_query("SELECT CLID, EmblemUrl FROM Clan WITH(nolock) WHERE CLID = '".$clid."'");
    if(mssql_num_rows($sql))
    {
        $r = mssql_fetch_object($sql);
        if(!empty($r->EmblemUrl))
        {
            @unlink($destino.$r->EmblemUrl);
        }
        if(move_uploaded_file($_FILES['clanemblema']['tmp_name'], $destino.$clid.".".$ext))
        {
            mssql_query ("UPDATE Clan SET EmblemChecksum = EmblemChecksum + 1 WHERE Name = '".$clid."'");
            mssql_query ("UPDATE Clan SET EmblemUrl = '".$clid.".".$ext."' WHERE Name = '".$clid."'");
            session_unset($_SESSION['Emblema']['AID']);
            redir("Emblema Subido Satisfactoriamente","/");
            die();
        }
        redir("Error inesperado 0x003","/");
        die();
    }
    redir("Error inesperado 0x003","/");
    die();
}
?>