MIXED: How To Add a colored welcome message ingame

If you want to add a (single) welcome message, with or without the color, you need to add a (name) GREET in player.string table.

Run this:

INSERT INTO `string`(`name`, `text`) VALUES ('GREET', '|cFFffa200|H|htest string');

Result:

If you removed the db_string feature, you can do it via quest as well:

quest greet_message begin
    state start begin
        when login begin
            chat("|cFFffa200|H|htest string")
        end
    end
end