Lol what is this ?

11/24/2010 12:48 Minotaurr#1
Hey....

If I want to put in the code for the web..... this code:

Code:
[COLOR="Green"]USE [ACCOUNT_DBF]
GO
/****** Object:  StoredProcedure [dbo].[webCreateAcc]    Script Date: 11/14/2010 13:35:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[webCreateAcc] 
	@account 	VARCHAR(15),
	@password 	VARCHAR(36),
	@email		VARCHAR(120)

AS

SET NOCOUNT  ON

DECLARE @DateActivated AS CHAR(8)

IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN
	INSERT INTO ACCOUNT_TBL (account, [password], id_no1, id_no2, isuse, member, realname, cash) 
		VALUES (@account, @password, @password, @password, 'T', 'A', 'F', '0')

	SET @DateActivated =  CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
	--UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = @DateYesterday WHERE account = @userid		
	--INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
	--	VALUES (@account, 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')

	INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse, email)
		VALUES (@account, 'A000', '2', 'F', GETDATE(), @DateActivated, '20990101', '20050101', 'O', @email)

END
--ELSE BEGIN
--print '->Account exists = ' 
--print @account 
--END[/COLOR]
Then Ill get the errror:

Msg 208, Level 16, State 6, Procedure webCreateAcc, Line 22
Invalid object name 'dbo.webCreateAcc'.

Does someone can help me ??
Is this the right code ?
Or can someone give me a working code ?

Thx
Dope
11/24/2010 12:52 Crown3r#2
Use this WebCreateAcc.sql ;)

[Only registered and activated users can see links. Click Here To Register...]
11/24/2010 13:08 Minotaurr#3
Ah thx !!
11/24/2010 13:20 Minotaurr#4
New error......
When I put register...
Ill see this:

Code:
[COLOR="Red"]Warning: mssql_execute() [function.mssql-execute]: message: Procedure or function 'webCreateAcc' expects parameter '@email', which was not supplied. (severity 16) in E:\FLYFF PS FILES !!!\Xampp\htdocs\register\register.php on line 39

Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed in E:\FLYFF PS FILES !!!\Xampp\htdocs\register\register.php on line 39
Something is wrong on the execution[/COLOR]
11/24/2010 13:30 Crown3r#5
Do you have to at xampp apache and Mysql?
11/24/2010 13:50 Minotaurr#6
I already fixed it, thanks for help Crown3r, your the best e*pvper helper !!

Ciao

#closerequest