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

thx zeyden for design :D

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

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?

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

---

Normal start.


http://img30.imageshack.us/img30/688/wyx.png

I try to identify

http://img821.imageshack.us/img821/2326/5ijf.png

register

http://img827.imageshack.us/img827/3545/u1g6.png



When I accept register

http://img593.imageshack.us/img593/3193/fyxu.png



I do not know what to do :C help please

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

---

I did and nothing.
What am I doing wrong? HELP :C

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.

No web guide craer from 0?
How install xampp ejemplo guia full
:C

Lol...execute the installer...click on ok and after some ok clicks later...klick on install...finished

Well I install it, and do not know why I get this error: S I did everything the video

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.

All procedures are included, else use my release there are all procedures original from sky-fighter

Forgot password function:

http://i159.photobucket.com/albums/t...psb9b4e920.jpg


http://i159.photobucket.com/albums/t...ps6833773c.jpg

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

Quote:

---

Originally Posted by ttlove9

Forgot password function:

http://i159.photobucket.com/albums/t...psb9b4e920.jpg


http://i159.photobucket.com/albums/t...ps6833773c.jpg

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

---

really nice!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!