Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[help] account creation

█║▌║▌║TheMerc iful║▌║▌║█
Member
Joined
Jan 29, 2005
Messages
1,360
Reaction score
80
does anybody have a query to manually create an account other than these 3 queries that i already have...

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

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

Code:
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'

4pLay - [help] account creation - RaGEZONE Forums

4pLay - [help] account creation - RaGEZONE Forums






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!
 
Last edited:
█║▌║▌║TheMerc iful║▌║▌║█
Member
Joined
Jan 29, 2005
Messages
1,360
Reaction score
80
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?

4pLay - [help] account creation - RaGEZONE Forums


maybe i missed out something?
 
Upvote 0
█║▌║▌║TheMerc iful║▌║▌║█
Member
Joined
Jan 29, 2005
Messages
1,360
Reaction score
80
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...
 
Upvote 0
Back
Top