Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
not It wants to create account, I can not logiarme nothing: C HELP!
Advertencia : odbc_exec () [ function.odbc-exec ]: SQL error: [Microsoft] [ODBC SQL Server Driver] [SQL Server] No se pudo encontrar el procedimiento almacenado 'atum2_db_account.dbo.Website_Login_GetAccountData', el estado SQL 37000 en SQLExecDirect en. C : \ xampp \ htdocs \ account.php on line 292
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
Quote:
Originally Posted by
lolsay
C : \ xampp \ htdocs \ account.php on line 292
Quote:
Originally Posted by
lolsay
account.php on line 292
check that line
Quote:
Originally Posted by
lolsay
No se pudo encontrar el procedimiento almacenado
means what?
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
Quote:
Originally Posted by
lolsay
not It wants to create account, I can not logiarme nothing: C HELP!
Advertencia : odbc_exec () [ function.odbc-exec ]: SQL error: [Microsoft] [ODBC SQL Server Driver] [SQL Server] No se pudo encontrar el procedimiento almacenado 'atum2_db_account.dbo.Website_Login_GetAccountData', el estado SQL 37000 en SQLExecDirect en. C : \ xampp \ htdocs \ account.php on line 292
Check procedure [atum2_db_account].[dbo].[Website_Login_GetAccountData]:
Code:
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
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
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
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
I did and nothing.
What am I doing wrong? HELP :C
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
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.
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
No web guide craer from 0?
How install xampp ejemplo guia full
:C
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
Lol...execute the installer...click on ok and after some ok clicks later...klick on install...finished
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
Well I install it, and do not know why I get this error: S I did everything the video
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
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.
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
All procedures are included, else use my release there are all procedures original from sky-fighter
1 Attachment(s)
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
Forgot password function:
Guide:
+ Enable extension php_openssl.dll in php.ini
+ Config host, port, username, password in forgotpwd.php
:D:
Re: [Video Guide] Working Ace WebPage + Autoupdate client (Version and Launcher)
Quote:
Originally Posted by
ttlove9
Forgot password function:
Guide:
+ Enable extension
php_openssl.dll in php.ini
+ Config host, port, username, password in forgotpwd.php
:D:
really nice!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!