- Joined
- Dec 3, 2012
- Messages
- 162
- Reaction score
- 130
Execute this query and try again:
Code:
USE [atum2_db_account]
GO
/****** Object: StoredProcedure [dbo].[atum_ChangePassword] Script Date: 09/03/2013 13:09:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[atum_ChangePassword]
@i_AccName VARCHAR(20),
@i_newPassword VARCHAR(40)
AS
UPDATE [atum2_db_account].[dbo].[td_Account] SET [Password] = @i_newPassword WHERE [AccountName] = @i_AccName
GO
USE [atum2_db_1]
GO
/****** Object: StoredProcedure [dbo].[atum_GetCharacterCount] Script Date: 09/03/2013 13:19:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[atum_GetCharacterCount]
AS
SELECT COUNT(*) as CharacterCount FROM [atum2_db_1].[dbo].[td_Character] WHERE Race <= 2
GO
USE [atum2_db_1]
GO
/****** Object: StoredProcedure [dbo].[atum_GetRanking] Script Date: 09/03/2013 13:20:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[atum_GetRanking]
@order INT
AS
IF(@order = 1)
BEGIN
SELECT UniqueNumber,CharacterName,UnitKind,[Level],RacingPoint,ArenaWin,ArenaLose,GuildName,InfluenceType,dbo.atum_GetGearString(UnitKind) AS gear FROM [atum2_db_1].[dbo].[td_Character] WHERE Race <= 2 ORDER BY RacingPoint DESC
END
ELSE IF(@order = 2)
BEGIN
SELECT UniqueNumber,CharacterName,UnitKind,[Level],RacingPoint,ArenaWin,ArenaLose,GuildName,InfluenceType,dbo.atum_GetGearString(UnitKind) AS gear FROM [atum2_db_1].[dbo].[td_Character] WHERE Race <= 2 ORDER BY ArenaWin DESC
END
ELSE IF(@order = 3)
BEGIN
SELECT UniqueNumber,CharacterName,UnitKind,[Level],RacingPoint,ArenaWin,ArenaLose,GuildName,InfluenceType,dbo.atum_GetGearString(UnitKind) AS gear FROM [atum2_db_1].[dbo].[td_Character] WHERE Race <= 2 ORDER BY ArenaLose DESC
END
ELSE
BEGIN
SELECT UniqueNumber,CharacterName,UnitKind,[Level],RacingPoint,ArenaWin,ArenaLose,GuildName,InfluenceType,dbo.atum_GetGearString(UnitKind) AS gear FROM [atum2_db_1].[dbo].[td_Character] WHERE Race <= 2 ORDER BY [Level] DESC
END
GO
USE [atum2_db_account]
GO
/****** Object: StoredProcedure [dbo].[Website_Login_GetAccountData2] Script Date: 09/03/2013 13:13:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Website_Login_GetAccountData2]
@i_AccName VARCHAR(20)
AS
/*SELECT Password WHERE AccountName = @i_AccName*/
SELECT Password,AccountType,CashPoint FROM [atum2_db_account].[dbo].[td_Account] WHERE AccountName = @i_AccName
GO
USE [atum2_db_account]
GO
/****** Object: StoredProcedure [dbo].[Website_Login_GetAccountData] Script Date: 09/03/2013 13:14:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Website_Login_GetAccountData]
@i_AccName VARCHAR(20)
AS
SELECT COUNT(*) AS 'AccountCount' FROM [atum2_db_account].[dbo].[td_Account] WHERE AccountName = @i_AccName
GO
USE [atum2_db_account]
GO
/****** Object: StoredProcedure [dbo].[Website_Register_Create_Account] Script Date: 09/03/2013 13:21:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Website_Register_Create_Account]
@i_AccountName VARCHAR(20),
@i_Password VARCHAR(32),
@i_Sex TINYINT,
@i_BirthYear INT,
@i_Email VARCHAR(40)
AS
INSERT INTO [atum2_db_account].[dbo].[td_Account] VALUES (@i_AccountName ,@i_Password ,0 ,@i_Sex ,@i_BirthYear,GetDate(),GetDate(),0,0,0,0,0, GetDate(),NULL, NULL,0,NULL,@i_Email,0)
SELECT 1 AS [RETURN]
RETURN
GO
USE [atum2_db_account]
GO
/****** Object: StoredProcedure [dbo].[Website_Register_CheckAccountExist] Script Date: 09/03/2013 13:21:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Website_Register_CheckAccountExist]
@i_AccName VARCHAR(20)
AS
SELECT COUNT(*) AS 'AccountCount' FROM [atum2_db_account].[dbo].[td_Account] WHERE AccountName = @i_AccName
GO