Hey!
I'm mainly a flyff developer so i need some FlyFF website help from html coders or whatever it's coded with
, Well the thing i need help with is connecting my database to the website, i can log in succsessfully and i can also see the rankings on the server with the characters etc, but i can't register a account, since it says in the top left corner Es besteht derzeit keine Datenbankverbindung. ( There is currently no database connection). i use the Sapphire website can some one help me with this via teamviewer or just msg me i would appreciate it alot!
Have a nice day!
Regards Laitila
Link to website
idk if it works 24/7 atm
Edit: I have database connection now but i can't still register correctly i think it's beacuse i can't execute this
usp_createAccount, ACCOUNT_TBL & ACCOUNT_TBL_DETAIL
usp_createAccount
USE [ACCOUNT_DBF]
GO
/****** Object: StoredProcedure [dbo].[usp_createAccount] Script Date: 08/22/2013 12:08:16 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_createAccount]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_createAccount]
GO
USE [ACCOUNT_DBF]
GO
/****** Object: StoredProcedure [dbo].[usp_createAccount] Script Date: 08/22/2013 12:08:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[usp_createAccount]
@account varchar(32),
@pw varchar(32),
@cash int = 0,
@email varchar(100) = '',
@gefra smallint = 0,
@geant varchar(50),
@birthday varchar(10),
@ip varchar(39),
@lang varchar(3)
as
set nocount on
set xact_abort on
if not exists (select * from ACCOUNT_TBL where account = @account)
begin
begin tran
INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,i d_no2,realname,OldPassword,cash)
VALUES(@account, @pw, 'T', 'A', @pw, @pw, 'P',@pw, @cash)
INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLog inAuthority,regdate,BlockTime,EndTime,WebTime,isus e,secession, email,secretquestion,secretanswer,birthday,regIP)
VALUES(@account,'A000','2','F',GETDATE(),CONVERT(C HAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()), 112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, @email, @gefra, @geant, @birthday,@ip)
if @@error <> 0
begin
rollback tran
select -1
end
else
begin
commit tran
select 1
end
end
else
begin
select 0
end
GO
Error : Msg 207, Level 16, State 1, Procedure usp_createAccount, Line 22
Invalid column name 'OldPassword'.
ACCOUNT_TBL
USE [ACCOUNT_DBF]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ACCOUNT_TBL_votepoints]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ACCOUNT_TBL] DROP CONSTRAINT [DF_ACCOUNT_TBL_votepoints]
END
GO
USE [ACCOUNT_DBF]
GO
/****** Object: Table [dbo].[ACCOUNT_TBL] Script Date: 08/22/2013 12:07:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
ALTER TABLE [dbo].[ACCOUNT_TBL] ADD
[votepoints] [int] NOT NULL
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[ACCOUNT_TBL] ADD CONSTRAINT [DF_ACCOUNT_TBL_votepoints] DEFAULT ((0)) FOR [votepoints]
GO
Error : Msg 4901, Level 16, State 1, Line 2
ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'votepoints' cannot be added to non-empty table 'ACCOUNT_TBL' because it does not satisfy these conditions.
Msg 1752, Level 16, State 0, Line 2
Column 'votepoints' in table 'ACCOUNT_TBL' is invalid for creating a default constraint.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
ACCOUNT_TBL_DETAIL
USE [ACCOUNT_DBF]
GO
/****** Object: Table [dbo].[ACCOUNT_TBL_DETAIL] Script Date: 05/07/2013 12:23:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD
[secretquestion] [smallint] NULL,
[secretanswer] [varchar](50) NULL,
[birthday] [varchar](10) NULL,
[latestpassword] [varchar](32) NULL,
[BanReason] [varchar](50) NULL,
[regIP] [varchar](39) NULL,
[lang] [varchar](3) NULL
GO
SET ANSI_PADDING OFF
GO
ERROR: Msg 2705, Level 16, State 4, Line 2
Column names in each table must be unique. Column name 'secretquestion' in table 'dbo.ACCOUNT_TBL_DETAIL' is specified more than once.
That's it thanks for reading and i hope i get some help with this
