Junior Spellweaver
- Joined
- Dec 3, 2012
- Messages
- 162
- Reaction score
- 130
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
Forgot password function:
Guide:
+ Enable extension php_openssl.dll in php.ini
+ Config host, port, username, password in forgotpwd.php
:
Could not find stored procedure 'atum2_db_account.dbo.Website_Register_Create_Account'.
yeah and wath can i do for repair this error?[/CENTER]There is your problem
Msg 2714, Level 16, State 3, Procedure atum_ChangePassword, Line 3
There is already an object named 'atum_ChangePassword' in the database.
Msg 2714, Level 16, State 3, Procedure atum_GetCharacterCount, Line 2
There is already an object named 'atum_GetCharacterCount' in the database.
Msg 2714, Level 16, State 3, Procedure atum_GetRanking, Line 2
There is already an object named 'atum_GetRanking' in the database.
Msg 2714, Level 16, State 3, Procedure Website_Login_GetAccountData, Line 2
There is already an object named 'Website_Login_GetAccountData' in the database.
Msg 213, Level 16, State 1, Procedure Website_Register_Create_Account, Line 11
Column name or number of supplied values does not match table definition.
Msg 2714, Level 16, State 3, Procedure Website_Register_CheckAccountExist, Line 2
There is already an object named 'Website_Register_CheckAccountExist' in the database.
This when i start query on DB why?
And This is the error on website
odbc_exec() [
C:\xampp\htdocs\register.php on line 111]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'atum2_db_account.dbo.Website_Register_Create_Account'., SQL state 37000 in SQLExecDirect in
Warning: odbc_result() expects parameter 1 to be resource, boolean given inC:\xampp\htdocs\register.php on line 114
Hi,
First: thanks so much for this post and thanks for share the web site
i need help with this error:
IMG
IMG
i read the post and coments, but, I came here
i use DB from Clean Ace Online 4.3 source code.zip
Thanks, and sorry for my bad english
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 ((SELECT MAX(AccountUniqueNumber)+1 AS id FROM td_Account),@i_AccountName ,@i_Password ,0 ,@i_Sex ,@i_BirthYear,GetDate(),GetDate(),0,0,0,0,0, GetDate(),NULL, NULL,0,NULL,@i_Email,NULL,0,NULL,NULL)
SELECT 1 AS [RETURN]
RETURN
GO