[help] account creation

[4pLay]

does anybody have a query to manually create an account other than these 3 queries that i already have...

USE [Account]
exec dbo.cabal_tool_registerAccount 'ID' ,'PASS'
GO

USE [Account]
exec dbo.cabal_tool_registerAccount 'id' ,'psw', 'email'
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER  FUNCTION [dbo].[fn_md5]     @<i><b><a href="http://forum.ragezone.com/members/2000209952.html" target="_blank">Data</a></b></i> varchar(255)) 
RETURNS CHAR(32)  AS  
BEGIN
	return SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5',    @<i><b><a href="http://forum.ragezone.com/members/2000209952.html" target="_blank">Data</a></b></i>)), 3, 32)
END


Exec dbo.cabal_tool_registeraccount 'XXX' , 'XXX'

got some error's everytime i execute them, maybe i missed something or i just can't see it infront of my eyes...

thank you god bless!

 

[samus]

do u use a clean database?

 

[4pLay]

do u use a clean database?

i use toasts files for fresh start... what should i do next mate? im really getting lost here.:$:

thanks god bless!

 

[mack071997]

try to use this

USE [ACCOUNT]
GO


DECLARE return_value int


EXEC return_value = [dbo].[cabal_tool_registerAccount]
id = N'test22',
password = N'1234',
email = N'test@gmail.com'


SELECT 'Return Value' = return_value


GO

 

[4pLay]

try to use this

USE [ACCOUNT]
GO


DECLARE return_value int


EXEC return_value = [dbo].[cabal_tool_registerAccount]
id = N'test22',
password = N'1234',
email = N'test@gmail.com'


SELECT 'Return Value' = return_value


GO

need some help on steps to do when you install sql 2014?

maybe i missed out something?

 

[Myster Dev]

need some help on steps to do when you install sql 2014?

maybe i missed out something?

if you're using Cabal Pilipinas files much better is to convert database from 2014 to 2008 so any tools will work on it

 

[4pLay]

if you're using Cabal Pilipinas files much better is to convert database from 2014 to 2008 so any tools will work on it

yeah,.. so i downgraded my sql to 2k8 and it seems toasts DB's are not compatible with 2k14 sql. now everythin's ok but i have not yet started to up everythin' to cabal pilipinas files...