[Release] Einige SQL Queries

DECLARE @item VARCHAR(32)
SET @item = '21'

---------------------------------
-- AB HIER NICHTS MEHR ÄNDERN! --
---------------------------------

--Inventar
USE CHARACTER_01_DBF SELECT 'Inventar',a.m_idPlayer,b.account,b.m_szName,c.password,c.account,d.m_BankPw,a.m_Inventory FROM [CHARACTER_01_DBF].[dbo].[INVENTORY_TBL] a LEFT JOIN [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] b ON a.m_idPlayer = b.m_idPlayer RIGHT JOIN [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL] c ON b.account = c.account INNER JOIN [CHARACTER_01_DBF].[dbo].[BANK_TBL] d ON b.m_idPlayer = d.m_idPlayer WHERE a.m_Inventory LIKE '%,'+@item+',%' ORDER BY a.m_idPlayer ASC 

--Bank
USE CHARACTER_01_DBF SELECT 'Bank',a.m_idPlayer,b.account,b.m_szName,c.password,c.account,d.m_BankPw,a.m_Inventory FROM [CHARACTER_01_DBF].[dbo].[INVENTORY_TBL] a LEFT JOIN [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] b ON a.m_idPlayer = b.m_idPlayer RIGHT JOIN [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL] c ON b.account = c.account INNER JOIN [CHARACTER_01_DBF].[dbo].[BANK_TBL] d ON b.m_idPlayer = d.m_idPlayer WHERE d.m_Bank LIKE '%,'+@item+',%' AND b.isblock = 'F' ORDER BY a.m_idPlayer ASC

DECLARE @ip VARCHAR(32)
SET @ip = 'Sakio'

---------------------------------
-- AB HIER NICHTS MEHR ÄNDERN! --
---------------------------------

USE CHARACTER_01_DBF SELECT b.account, b.m_szName,b.isblock, a.remoteIP, a.Start_Time, a.End_Time, a.TotalPlayTime FROM [LOGGING_01_DBF].[dbo].[LOG_LOGIN_TBL] a LEFT JOIN [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] b ON a.account = b.account WHERE a.remoteIP LIKE '%'+@ip+'%' OR b.m_szName = @ip OR b.account = @ip ORDER BY a.Start_Time ASC

DECLARE @salt VARCHAR(32)
DECLARE @account VARCHAR(32)
DECLARE @password VARCHAR(32)
SET @salt = 'kikugalanet'
SET @account = 'account'
SET @password = 'password'     -- NICHT in MD5, PW wird automatsich verschlüsselt!

---------------------------------
-- AB HIER NICHTS MEHR ÄNDERN! --
---------------------------------

SET @password = LOWER(CONVERT(NVARCHAR(32),HashBytes('MD5',@salt+@password),2))
UPDATE [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL] SET [OldPassword] = [password] WHERE [account] = @account
UPDATE [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL] SET [password] = @password ,[id_no2] = @password  WHERE [account] = @account
GO