|
You last visited: Today at 16:55
Advertisement
Hellp me in error !!
Discussion on Hellp me in error !! within the Flyff Private Server forum part of the Flyff category.
12/14/2014, 16:03
|
#1
|
elite*gold: 0
Join Date: Oct 2013
Posts: 47
Received Thanks: 0
|
Hellp me in error !!
Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'ACCOUNT_DBF.dbo.usp_createAccount'., SQL state 37000 in SQLExecDirect in C:\xampp\htdocs\sites\regist.php on line 108
|
|
|
12/14/2014, 16:26
|
#2
|
elite*gold: 0
Join Date: Dec 2013
Posts: 228
Received Thanks: 99
|
Try to use this.
Code:
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),
@votepoints int = 0
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,id_no2,realname,OldPassword,cash)
VALUES(@account, @pw, 'T', 'A', @pw, @pw, 'P',@pw, @cash)
INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession, email,secretquestion,secretanswer,birthday,regIP)
VALUES(@account,'A000','2','F',GETDATE(),CONVERT(CHAR(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
|
|
|
12/14/2014, 20:21
|
#3
|
elite*gold: 0
Join Date: Oct 2013
Posts: 47
Received Thanks: 0
|
Execut in SQL Error
Quote:
Originally Posted by Grening
Try to use this.
Code:
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),
@votepoints int = 0
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,id_no2,realname,OldPassword,cash)
VALUES(@account, @pw, 'T', 'A', @pw, @pw, 'P',@pw, @cash)
INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession, email,secretquestion,secretanswer,birthday,regIP)
VALUES(@account,'A000','2','F',GETDATE(),CONVERT(CHAR(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
|
Execut in SQL Error
|
|
|
|
Similar Threads
|
Hellp me in error !!
11/24/2014 - Flyff Private Server - 0 Replies
Hellp me cancel error
2014/11/24 17:36:40
RemoveUser(): *pUser->m_pKey is '
2014/11/24 17:37:24
RemoveUser(): *pUser->m_pKey is '
2014/11/24 17:37:39
RemoveUser(): *pUser->m_pKey is '
2014/11/24 17:38:15
RemoveUser(): *pUser->m_pKey is '
|
HELLP!! ME PLEASE ERROR
08/30/2011 - Flyff Private Server - 3 Replies
WOLLEN diesen Fehler beheben mit mir geschieht.
2011 / 29.08 12.28.22 GetMoverProp range_error min: 0, max: 1575, Index: 1653
Wenn ich öffne die Map Server I drop
|
KSRO net.error or (?????????) problem plz hellp
10/30/2010 - Silkroad Online - 9 Replies
hellp me whit ksro problem when i try 2 start the game it pops -???????- when i try to start from loader it pops net.error..... wtf i dont know what 2 dou can some one hellp me ? plz
|
[HELLP]I need hellp with NavicatforMySQL and Wamp server please hellp me
01/05/2010 - CO2 Private Server - 1 Replies
How to use this shits please hellp me!!!
i cant connect to any new created connections in Navicat
in Wamp server when i start all programs all crasshes and stop automatically
|
Please Hellp me with this error!
01/04/2010 - CO2 Private Server - 12 Replies
Why no1 can't connect to my server???Please hellp me:(Idont want to be alone on my own server xD
|
All times are GMT +2. The time now is 16:55.
|
|