Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)

Status
Not open for further replies.
Junior Spellweaver
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
 
Skilled Illusionist
Joined
Jul 10, 2008
Messages
371
Reaction score
94
missing procedure atum2_db_account.dbo.Website_Register_CheckAccountExist

from 1st error message on last screen

correct all missing procedure by create and implement these one after that this will work.
 
Skilled Illusionist
Joined
Jul 10, 2008
Messages
371
Reaction score
94
read create thing(procedure in your case) asked by error message (it's need read a line or two, this must be more easier than post), and you will solve your problem.
 
Junior Spellweaver
Joined
Dec 3, 2012
Messages
162
Reaction score
130
Forgot password function:

ttlove9 - [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher) - RaGEZONE Forums



ttlove9 - [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher) - RaGEZONE Forums



Guide:
+ Enable extension php_openssl.dll in php.ini
+ Config host, port, username, password in forgotpwd.php
:D:
 

Attachments

You must be registered for see attachments list
Last edited:
Initiate Mage
Joined
Feb 11, 2013
Messages
6
Reaction score
2
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
 
Joined
Sep 7, 2011
Messages
1,323
Reaction score
528
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

in query, delete the procedures, atum_ChangePassword, atum_GetCharacterCount, atum_GetRanking, Website_Login_GetAccountData, Website_Register_Create_Account, Website_Register_CheckAccountExist. Those procedures are already in the databases.
 
Initiate Mage
Joined
Sep 27, 2014
Messages
1
Reaction score
0
Hi,

First: thanks so much for this post and thanks for share the web site


i need help with this error:

ttlove9 - [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher) - RaGEZONE Forums



ttlove9 - [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher) - RaGEZONE Forums



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
 
Initiate Mage
Joined
Dec 20, 2010
Messages
41
Reaction score
2
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


For my friend Daryl and who need it


with permission by ttlove

try this procedure for Clean Ace Online 4.3 source code

Code:
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

but if it does not work, check the design of the table, and correct all values



Sorry for my bad english. Si lo quieren en español me lo piden
 
Status
Not open for further replies.
Back
Top