fragge über acc direckt in die db ein fügen

[Rmstyler]

also ich versuche ein acc einzu fügen dan komm ja des

USE [ACCOUNT_DBF]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[usp_CreateNewAccount]
@account = N'zukia',
@pw = N'f262a2005175e944e9a9ef2c3bccd345'

SELECT 'Return Value' = @return_value

GO

dan auf execute



dan kommt da so eine fehler meldung

Msg 207, Level 16, State 1, Procedure usp_CreateNewAccount, Line 11
Ungültiger Spaltenname 'account'.


habe schon alles probiert und komm einfach nicht drauf danke is foraus

[Veston]

V15 ???

[Rmstyler]

ja

[Lightings]

USE [ACCOUNT_DBF]
GO

INSERT INTO [dbo].[ACCOUNT_TBL] ([account], [password], [isuse], [member], [id_no1], [id_no2], [realname], [reload], [OldPassword], [TempPassword], [cash])
VALUES
(N'hier der name ', N'PW IN MD5', N'T', N'A', NULL, 0, N'P', NULL, 0, NULL, 0)
GO

INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] ([account], [gamecode], [tester], [m_chLoginAuthority], [regdate], [BlockTime], [EndTime], [WebTime], [isuse], [secession], [email])
VALUES
(N'hier muss auch noch der name rein', N'A000', N'2', N'Z', '20080818 00:51:35.700', N'20010101', N'20990101', N'20050101', N'O', NULL, NULL)
GO

[Sedrika]

Originally Posted by Lightings

USE [ACCOUNT_DBF]
GO

INSERT INTO [dbo].[ACCOUNT_TBL] ([account], [password], [isuse], [member], [id_no1], [id_no2], [realname], [reload], [OldPassword], [TempPassword], [cash])
VALUES
(N'hier der name ', N'PW IN MD5', N'T', N'A', NULL, 0, N'P', NULL, 0, NULL, 0)
GO

INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] ([account], [gamecode], [tester], [m_chLoginAuthority], [regdate], [BlockTime], [EndTime], [WebTime], [isuse], [secession], [email])
VALUES
(N'hier muss auch noch der name rein', N'A000', N'2', N'Z', '20080818 00:51:35.700', N'20010101', N'20990101', N'20050101', N'O', NULL, NULL)
GO

Eher so.

USE [ACCOUNT_DBF]
GO

INSERT INTO [dbo].[ACCOUNT_TBL] ([account], [password], [isuse], [member], [id_no1], [id_no2], [realname], [reload], [OldPassword], [TempPassword], [cash])
VALUES
(N'ACCOUNT_NAME ', N'PW IN MD5', N'T', N'A', NULL, 0, N'P', NULL, 0, NULL, 0)
GO

INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] ([account], [gamecode], [tester], [m_chLoginAuthority], [regdate], [BlockTime], [EndTime], [WebTime], [isuse], [secession], [email])
VALUES
(N'ACCOUNT_NAME', N'A000', N'2', N'Z', '20080818 00:51:35.700', N'20010101', N'20990101', N'20050101', N'O', NULL, NULL)
GO

Das "Z" steht für den Character rang.
Z = Admin
P = Game Master
F = Normal

[Lightings]

Hääh? Hab ich doch genauso.!?

[Sedrika]

ja aber nicht gezeigt wo pw unso hinkommt ^^ wollte es nur nochmal verdeutlichen

[Lightings]

Achso. Hab vergessen das Rot zu färben.