[Snippet] Fix Azure SQL Database error for WarZ

[oNouro]

This is for whoever that using Azure SQL instead private SQL server and getting error when login into game or register cause of MD5 Hash function is using some permission in master database and Azure don't let it.

open FN_CreateMD5Password in your database function
replace all of this and edit SALT to your

ALTER PROCEDURE [dbo].[FN_CreateMD5Password]    @in_Password varchar(100),    [USER=1333447295]Out[/USER]_MD5 varchar(32) OUTPUTASBEGIN    SET NOCOUNT ON;    declare [USER=2000229135]pas[/USER]SWORD_SALT varchar(100) = 'YOUR_SALT'    set [USER=1333447295]Out[/USER]_MD5 = CONVERT(VARCHAR(32), HashBytes('MD5', [USER=2000229135]pas[/USER]SWORD_SALT + @in_Password), 2) -- FOR AZURE    --set [USER=1333447295]Out[/USER]_MD5 = SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('md5', [USER=2000229135]pas[/USER]SWORD_SALT + @in_Password)), 3, 999)END

and this also work with all version of MSSQL server (Maybe)

Maybe this game not dead yet :
Sorry for my fukkin bad English.​