NGUI Button isEnabled does not work BUG

Yeah,
If you set isEnabled = false of a UIButton in NGUI, the color of the button does not change even it is disabled.

It is a bug actually, you should change the NGUI isEnabled source code as follows:

public bool isEnabled
    {
        get
        {
            if (!enabled) return false;
            Collider col = collider;
            return col && col.enabled;
        }
        set
        {
            Collider col = collider;
            if (col != null) col.enabled = value;
            else enabled = value;
            UpdateColor(value, false);
        }
    }

Here is the link:
http://www.tasharen.com/forum/index.php?topic=6893.msg32520#msg32520

Note:
This bug is fixed after 3.x version, not sure which exactly.

BM FONT - How to get rid of black background from text

This is a weird issue I experience with BM Font.

Even if you select `White Text or Black Text with Alpha` option, it seems the BM Font does not recognize the setting and export the file with black backgorund.

Well, the solution is simple,

On Export Options, just select the Bit Depth as `32` not `8` (default).

Volla !

Vertex Color Shader in unity

Hi,
I have realized Unity3d does not have a shader for vertex colored models.

Since it is one of the easiest ways to color your model in Blender (Vertex Painting), you might need this shader:

Go to your assests folder - Create - Shader.
Give a name to your shader and paste the code below: (The name in code is "Vertex Colored", you can change it with your shader name).

Keep in mind, that you need create a material for your model if it is not created. Then you can choose this shader on material's shader list.

And make the ambient light white to see it properly. (Render Settings - Ambient Light)

Cheers


Vertex Color Shader Script

Source:
http://wiki.unity3d.com/index.php?title=VertexColor

Shader " Vertex Colored" {
Properties {
    _Color ("Main Color", Color) = (1,1,1,1)
    _SpecColor ("Spec Color", Color) = (1,1,1,1)
    _Emission ("Emmisive Color", Color) = (0,0,0,0)
    _Shininess ("Shininess", Range (0.01, 1)) = 0.7
    _MainTex ("Base (RGB)", 2D) = "white" {}
}

SubShader {
    Pass {
        Material {
            Shininess [_Shininess]
            Specular [_SpecColor]
            Emission [_Emission]    
        }
        ColorMaterial AmbientAndDiffuse
        Lighting On
        SeperateSpecular On
        SetTexture [_MainTex] {
            Combine texture * primary, texture * primary
        }
        SetTexture [_MainTex] {
            constantColor [_Color]
            Combine previous * constant DOUBLE, previous * constant
        } 
    }
}

Fallback " VertexLit", 1
}

Blogger - Add Code Highlight

If you like to highlight the codes you share in blogger, what you can do is:

Go to link
http://formatmysourcecode.blogspot.com/

Paste your code in there, press `format text` and get your html code.
Then, in your entry, go to `HTML` section and paste your code.

That's all,
SyntaxHighlighter and other highlighters were very frustrating for me..

Microsoft SQL Server, Error: 18456 – Login failed for user.

If you encounter this error while connecting to the SQL Server  SQL authentication, the solution is simpe.

Connect to the server with Windows Authentication

Just check 2 things:

1. Go to Security -> Logins and right click to the user -> Properties -> Status
Login section should be Enabled

2. Right click to the Database Engine, Go to Properties -> Security 
In Server Authentication section, make sure

SQL Server and Windows Authentication Mode is selected.

It would need a SQL Server restart, which you can do by:
Start - > Run - > Services.msc

Go to SQL Server  and Restart it.

Thats all !

Unity3d - Round double / float values

Hi,
To be able to round the values in unity csharp you need the code below:

float rawValue = 5.521f;
rawValue = Mathf.Round(rawvalue * 100f) / 100f);
//it should return 5.5

In order to increase decimals, just use 1000 or 10000 etc.

MS SQL Adding Unique Column / Columns

Hi,
I always keep forgetting this sql command,
if you have a table and you want to create unique columns use following statement:

ALTER TABLE dbo.tablename ADD CONSTRAINT constraintName UNIQUE (col1, col2, col3)

like:
ALTER TABLE dbo.User ADD CONSTRAINT uqUPE UNIQUE (username, phone, email)

This prevents you to insert a row with the same username AND phone AND email. (all of them should be same, only one or two can also be added)


You can also do the same thing for just one column. If you d like to have 3 columns to be unique separately, just create 3 statements for each column, so you ll have 3 constraint checks for each column.

Cheers,
Deniz