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

[lolsay]

ttlove9 , St34lth4ng3l


Thanks I managed to fix the error for your help! THANK YOU

TY ALL ♥

[Treboldi Erik]

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

[St34lth4ng3l]

Could not find stored procedure 'atum2_db_account.dbo.Website_Register_Create_Account'.

There is your problem

[Treboldi Erik]

[/CENTER]There is your problem

yeah and wath can i do for repair this error?
ty :)

[WARonline]

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.

[DarylDixon]

Hi,

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


i need help with this error:







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

[DragonLord]

http://php.net/manual/en/function.odbc-exec.php

RTFM.

[cam46]

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

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