hel me pliz acount create SQL

01/13/2012 22:47 KLR#1
hello I need help.

can you tell me the steps to create an account on the SQL
01/13/2012 23:05 Lumi#2
First you press "New Query"..
Then you Copy this:

PHP Code:
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 ID', N'PW in MD5', N'F', N'A', N'', N'', 'F', NULL, NULL, NULL, '0')
GO

INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] ([account], [gamecode], [tester], [m_chLoginAuthority], [regdate], [BlockTime], [EndTime], [WebTime], [isuse], [secession], [email])
VALUES
(N'Account ID', N'A000', N'2', N'F', GETDATE(), N'', N'', N'20050101', N'O', NULL, N'')
GO 
And Paste in your Query.

So now on the Account ID you write your Wish ID.

And on "PW IN MD5" You go in this Site -> [Only registered and activated users can see links. Click Here To Register...]
and Write so... "kikugalanet(yourpasswort).. Example: kikugalanethello.

And
Code:
 N'F',
F = User, Z = Admin, P = Gamemaster.

Sorry for my Bad English. xD
01/13/2012 23:29 .Crash#3
Ore use that it´s easier to use i think

PHP Code:
USE [ACCOUNT_DBF]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[usp_CreateNewAccount]
        @account = N'ACCOUNTNAME',
        @pw = N'PASSWORD IN MD5',
        @cash = 0,
        @email = N'[Only registered and activated users can see links. Click Here To Register...]'

GO 
01/13/2012 23:50 N8Schatten#4
und wie kan man dabei die Autorisiereung einstellen?
01/14/2012 00:00 .Crash#5
So schwer ist das doch nu net da nen query zu schreiben ;D

Admin für Charackter / Admin for Character
PHP Code:
USE [CHARACTER_01_DBF]
GO
update [CHARACTER_TBL] set m_chAuthority = P' where m_szName = 'CHARACTERNAME'
GO 
Admin für Account / Admin for Account
PHP Code:
USE [ACCOUNT_DBF]
GO
update [ACCOUNT_TBL_DETAIL] set m_chLoginAuthority = 'P' where account = 'ACCOUNTNAME'
GO 
Einen davon zu benutzen reicht / It´s enough to use one of them
01/14/2012 00:02 N8Schatten#6
Jetzt is das script vollständig mehr wollte ich garnet^^