black coffin

Restore deleted ASP.net user membership

2010-10-20T03:11:00.000-07:00

If you accidentally delete asp.net user from membership using this code Membership.DeleteUser but you have a backup of your previous database then you can restore it using the following sql.
assume :
your current database name is MYDB and your previous database name is MYDB2.
you must know the userid of the deleted user. you can get the userid using this code
   select * from MYDB2.dbo.aspnet_users where username like '%somename%'

USE [MYDB]
GO
/****** Object: StoredProcedure [dbo].[RestoreMembershipDeleteUser]    Script Date: 10/19/2010 11:23:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE proc [dbo].[RestoreMembershipDeleteUser](@userid uniqueidentifier)
as
begin

if not exists (select * from MYDB2.dbo.aspnet_users where userid=@userid)
begin
    print 'userid not found in prev aspnet_users'
    return 0
end
if not exists (select * from MYDB2.dbo.aspnet_membership where userid=@userid)
begin
    print 'userid not found in prev aspnet_membership'
    return 0
end
--get information from backup database
--MYDB2 is the backup database
declare @ApplicationId uniqueidentifier
declare @UserName nvarchar(256)
declare @Email nvarchar(256)
declare @CreateDate datetime
declare @Password   nvarchar(128)
declare @PasswordSalt nvarchar(128)
declare @IsApproved bit
declare @IsLockedOut bit
declare @LastLoginDate datetime
declare @FailedPasswordAttemptCount int
declare @FailedPasswordAttemptWindowStart datetime
declare @FailedPasswordAnswerAttemptCount int
declare @FailedPasswordAnswerAttemptWindowStart datetime
declare @LastPasswordChangedDate datetime
declare @LastLockoutDate datetime
declare @LastActivityDate datetime

select @UserName = username from MYDB2.dbo.aspnet_users where userid=@userid
select
    @ApplicationId = Applicationid,
    @Email = email,
    @CreateDate =CreateDate,
    @Password=Password,
    @PasswordSalt=PasswordSalt,
    @IsApproved = IsApproved,
    @IsLockedOut = IsLockedOut,
    @LastLoginDate = LastLoginDate,
    @LastPasswordChangedDate = LastPasswordChangedDate,
    @LastLockoutDate = LastLockoutDate,
    @FailedPasswordAttemptCount = FailedPasswordAttemptCount,
    @FailedPasswordAttemptWindowStart = FailedPasswordAttemptWindowStart,
    @FailedPasswordAnswerAttemptCount = FailedPasswordAnswerAttemptCount,
    @FailedPasswordAnswerAttemptWindowStart = FailedPasswordAnswerAttemptWindowStart
from MYDB2.dbo.aspnet_membership
where userid=@userid

declare @TranStarted   bit

set @TranStarted = 0
if( @@TRANCOUNT = 0 )
begin
begin transaction
set @TranStarted = 1
end
else
    set @TranStarted = 0

--delete existing data
delete from aspnet_Membership WHERE UserID = @userid
if( @@ERROR <> 0 )
begin
    print 'error delete aspnet_Membership'
    goto Cleanup
end

delete from aspnet_Users WHERE UserID = @userid
if( @@ERROR <> 0 )
begin
    print 'error delete aspnet_Users'
    goto Cleanup
end

declare @ReturnValue int
EXEC @ReturnValue = dbo.aspnet_Users_CreateUser @ApplicationId, @UserName, 0, @CreateDate, @UserId OUTPUT
if( @@ERROR <> 0 or @ReturnValue = -1)
begin
    print 'error exec aspnet_Users_CreateUser'
    goto Cleanup
end

if not exists (select * from aspnet_Membership where userid=@userid)
begin
INSERT INTO aspnet_Membership
                ( ApplicationId,
                  UserId,
                  Password,
                  PasswordSalt,
                  Email,
                  LoweredEmail,
                  IsApproved,
                  IsLockedOut,
                  CreateDate,
                  LastLoginDate,
                  LastPasswordChangedDate,
                  LastLockoutDate,
                  FailedPasswordAttemptCount,
                  FailedPasswordAttemptWindowStart,
                  FailedPasswordAnswerAttemptCount,
                  FailedPasswordAnswerAttemptWindowStart
                  )
    values
        (@applicationid,
        @userid,
        @Password,
        @PasswordSalt,
        @email,
        lower(@email),
        @IsApproved,
        @IsLockedOut,
        @CreateDate,
        @LastLoginDate,
        @LastPasswordChangedDate,
        @LastLockoutDate,
        @FailedPasswordAttemptCount,
        @FailedPasswordAttemptWindowStart,
        @FailedPasswordAnswerAttemptCount,
        @FailedPasswordAnswerAttemptWindowStart)
    if( @@ERROR <> 0 )
    begin
        print 'error insert aspnet_Membership'
        goto Cleanup
    end
end

if( @TranStarted = 1 )
begin
    set @TranStarted = 0
    COMMIT TRANSACTION
end

    return 0
Cleanup:

    IF( @TranStarted = 1 )
    BEGIN
        SET @TranStarted = 0
        print 'rollback'
        ROLLBACK TRANSACTION
    END

    RETURN -1
end

Poken, a business card replacement

2010-01-26T22:36:00.000-08:00

POKEN is a cute little gadget designed to make sharing your social networking contact details a lot easier. In essence, POKEN is really a modern day version of the business card. Just hold 2 of them together and you’ll be connected through all of the social networks you already use such as Facebook, Twitter, LinkedIn and 45 others. In Japan and Europe these little guys have already become very popular. Now they are finally available in the U.S. for $20 a pop. There are two kinds of POKENs. First there is the adorable “the Spark” which comes in an adorable design including a Geisha, a Rap Star a Panda Bear and an Alien. The second type is the pokenPULSE which looks much like an ordinary USB key and it also has 2GB of memory. But despite the fact that the pokenPULSE resembles an ordinary USB key, it actually isn’t drab at all – it comes in several colorful designs, but you have to remove its cap to actually see the designs. source

Microsoft Office: The Movie

2010-01-14T03:02:00.001-08:00

Here is the new Microsoft Office 2010 The Movie. It's very funny :))

Google Book Downloader

2010-01-13T15:15:00.000-08:00

Google Book Downloade Screenshot

Google Book Downloader is small utility which allows you to save book from google book to your local filesystem as image file (jpg or png). First you have to download it from Google Book Downloader. All you have to do is just enter the book url on text box and select an empty folder to save the downloaded images, then press Go button. After the book is loaded in the browser, you have to scroll the book’s page till the end of page. The Google Book Downloader will copy the images of each page from your browser cache to specified folder.

Creating MP3 Media Player Using MFC and FMod

2010-01-13T15:00:00.000-08:00

FMod Media Player

Do you want to create MP3 player using free library?? Then I suggest you to use FMod. It's free and support almost all musics file formats (wav, mp2, mp3, ogg, wma, raw, mid, mod, s3m, it, xm, fsb, rmi, sgt). The documentation is quite complete and easy to use. But if you need more detail example of how creating MP3 player or audio player using FMod then I suggest you to look into my previous work. Here is the MFC source code and the demo application

Ohara : your free information organizer

2010-01-13T07:10:00.000-08:00


Creating Notes	Organize E-Books

Ohara is your free information organizer

It can manage almost anything like text (RTF even html), PDF file, contact, bookmark, serial number and password. You can organize the information you store in Ohara with collection and tag, display them per page, flag it, order by date created or date modified and more.

Ohara is portable

You dont even need to install it, all you need is just extract it. You can copy it from one computer to another computer safely. You can also put it on a flash drive and run it directly from there. It's very simple!

Get It Now

System Requirements
Minimum System
* Windows 7 or Windows XP SP2 or Windows Vista
* .NET Framework 3.0 required for Windows XP(free download from Microsoft)
* 800MHz processor (CPU)
* 512MB of RAM
* Adobe Acrobat Reader 9 or above (download)
* 1024 x 768 screen resolution

Otsu Thresholding Source Code

2008-12-22T23:58:00.000-08:00

//Otsu Thresholding
function TLVQ.GetTValue(bmp:TBitmap):integer;
var
x,y,min,nmin,max,nmax,intens:integer;
T,TNext:double;
begin
//initialize
min:=255;
max:=0;
//cari intensitas tertinggi dan terendah dalam image
for y:= 0 to bmp.Height-1 do
begin
for x:=0 to bmp.Width-1 do
begin
//nilai r,g,b sama pada image greyscale
intens := GetRValue(bmp.Canvas.Pixels[x,y]);
if(intens>max)then max:=intens;
if(intens end;
end;
//hitung T awal
T:=0.5*(min+max);
while (true) do
begin
//
nmin:=0;nmax:=0;max:=0;min:=0;
for y:= 0 to bmp.Height-1 do
begin
for x:=0 to bmp.Width-1 do
begin
//nilai r,g,b sama pada image greyscale
intens := GetRValue(bmp.Canvas.Pixels[x,y]);
if(intens>=T)then
begin
max:= max + intens;
inc(nmax);
end
else
begin
min:= min + intens;
inc(nmin);
end;
end;
end;
TNext := 0.5*((min/nmin)+(max/nmax));
if abs(T-TNext)<0.5 then
break;
T := TNext;
end;
result := Round(T);
end;

Antivirus 360 is not antivirus

2008-12-14T17:35:00.000-08:00

This morning i try to install antivirus 360, for the first time i thought it was a new antivirus software. I was surprised when i got this pic after i finished scan my computer.

Oooh sh**t i dont know what kind of creature that nesting in my computer. so i try to click Remove button. then this dialog comes out

but wait a second, i remember that i already have an antivirus installed in my comp. but why there are so many malwares that not detected by my anti virus. its strange.. so i try to search using google. i type antivirus 360. and i visit this blog http://www.bleepingcomputer.com/malware-removal/remove-antivirus-360.
Ooh no, look at this : Antivirus 360 is a rogue anti-spyware program that uses false scan results and aggressive advertising in order to promote itself. This rogue is advertised by the Vundo Trojan and is replacing the Antivirus 2009 rogue program that Vundo has been aggressively advertising.
So i try to end this fu##ing morning by removing this software using Malwarebytes (http://download.bleepingcomputer.com/malwarebytes/mbam-setup.exe) as suggested in that blog.

Visual Studio 2008 vs Netbeans 6.1

2008-12-10T19:05:00.000-08:00

Just look it by yourself :)

Installing PHP 5 with Oracle 10 in IIS 6 on Windows Server 2003

2008-12-08T22:28:00.000-08:00

environment windows server 2003 r2 with iis6 installed
1. download and extract php5.2.5.zip from php.net to c:\php\
2. move php.ini-recommended to php.ini
edit php.ini
set the extension_dir to c:\php\ext
set cgi.force_redirect = 0
uncomment extension=php_oci8.dll
comment doc_root=
3. Add "C:\PHP" to the PATH environment variable. Right click my computer>properties>advanced>Environment Variables
4. Add to the registry HKEY_LOCAL_MACHINE\SOFTWARE\PHP\IniFilePath = C:\PHP
or run this .reg script
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\PHP]
"IniFilePath"="C:\\PHP"
5. install oracle 10.0.1g, if in the installation (copying database) error occured then start the service from services in administrative tools and continue installation.
6. download and extract oracle instantclient basic lite from http://www.oracle.com/technology/tech/oci/instantclient/index.html to x directory
7. copy all files from x directory to c:\php\, c:\php\ext, c:\windows and c:\windows\system32
8. download and extract pecl4win from http://pecl4win.php.net/ext.php/php_oci8.dll php_oci8.dll php-5.2.1 (5_2). copy php_oci8.dll to c:\php, c:\php\ext, c:\windows and c:\windows\system32 folder
9. from start menu > run, type inetmgr and enter. right click the web site that you want to set up php, and choose properties.
in the Home Directory tab click Configuration, and in the Mappings tab click Add
set the Executable to C:\php\php5isapi.dll and the extension to .php
10. still in IIS Manager click Web Service Extensions and click Add a new Web service extension...
enter PHP as Extension Name, click Add and browse to php5isapi.dll file in C:\php.
Check the Set extension status to Allowed checkbox and click OK
11. Still in IIS Manager, right click the web site that you want to set up php, and choose properties. In the Home Directory change the Execute permissions dropdown to Scripts only.
12. run iisreset or reboot your computer
Hope this works:D

Hide your file using NTFS Alternate Data Stream

2008-12-05T01:54:00.000-08:00

There are so many way to hide files. The most used way to hide files is using file attribute. You just have to right click the file, choose Properties then check the file attributes to hidden.

Some people using software that use Device driver to lock the file. so when accessing any protected file or folder, dialog box querying password appears on the screen. If valid password entered, user gets access to the file or folder, otherwise not.

But i prefer using NTFS feature (Alternate Data Stream) to hide my files. the easiest way to convert a file to a stream is using XStream. just try it your self

Java Performance

2008-12-04T22:58:00.000-08:00

I am sure you already know that the java performance is really suck

Help.. Kill me

2008-12-04T01:59:00.000-08:00

Disturbing Pics

2008-12-03T19:51:00.000-08:00