[Question] I can't to change Premium Account !

[plemaster]

Hoooo my god! @@



" Free User Account " changed " Premium User Account "........success!!

thnk for advice by error0024

" try to increase the duration of payminutes " <<<< i edit this ...

i put it 99999(minute) ^.^

very happy !!!!

[snaity]

guy u seted wrong, type just put 2 and in ServiceKind put 5

here an create coount procedure can auto add premium to accounts

USE [account]
GO
/****** Object:  StoredProcedure [dbo].[cabal_tool_registerAccount]    Script Date: 07/17/2008 05:23:01 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** Object:  Stored Procedure dbo.cabal_tool_registerAccount    Script Date: 2008-4-14 21:40:21 ******/


ALTER  PROCEDURE [dbo].[cabal_tool_registerAccount]   (@id varchar(32),  @password  varchar(32))
AS
begin tran
	declare @UserNum as int

	insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo ) 
	values(@id, dbo.fn_md5(@password), '0', 1, '7700000000000' )

	set @UserNum = @@identity

	INSERT INTO [cabal_charge_auth]
           ([UserNum]
           ,[Type]
           ,[ExpireDate]
           ,[PayMinutes]
           ,[ServiceKind])
     VALUES
           (@UserNum
           ,2
           ,DATEADD(year, 10, getdate())
           ,999999
           ,5)

	select @UserNum as usernum
commit

and here a query to set all already registred account to premium

UPDATE [account].[dbo].[cabal_charge_auth] SET
           [Type] = 2
           ,[ExpireDate] = DATEADD(year, 10, getdate())
           ,[PayMinutes] = 999999
           ,[ServiceKind] = 5

[xz3r0x]

snaity what type is 2? because i browsed several stored proc and, somewhere i saw, type = 0 --uncharged type = 1 --charged but no value of 2

[plemaster]

guy u seted wrong, type just put 2 and in ServiceKind put 5

here an create coount procedure can auto add premium to accounts

USE [account]
GO
/****** Object:  StoredProcedure [dbo].[cabal_tool_registerAccount]    Script Date: 07/17/2008 05:23:01 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
 
/****** Object:  Stored Procedure dbo.cabal_tool_registerAccount    Script Date: 2008-4-14 21:40:21 ******/
 
 
ALTER  PROCEDURE [dbo].[cabal_tool_registerAccount]   (@id varchar(32),  @password  varchar(32))
AS
begin tran
    declare @UserNum as int
 
    insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo ) 
    values(@id, dbo.fn_md5(@password), '0', 1, '7700000000000' )
 
    set @UserNum = @@identity
 
    INSERT INTO [cabal_charge_auth]
           ([UserNum]
           ,[Type]
           ,[ExpireDate]
           ,[PayMinutes]
           ,[ServiceKind])
     VALUES
           (@UserNum
           ,2
           ,DATEADD(year, 10, getdate())
           ,999999
           ,5)
 
    select @UserNum as usernum
commit

and here a query to set all already registred account to premium

UPDATE [account].[dbo].[cabal_charge_auth] SET
           [Type] = 2
           ,[ExpireDate] = DATEADD(year, 10, getdate())
           ,[PayMinutes] = 999999
           ,[ServiceKind] = 5

my db is change

[Type] = 2 >>> 5
[ServiceKind] = 5 >> 1

thnk sir ^.^

[error0024]

no problem for the duration heh :P
nice

[dordort]

Thank you error! =]
Problem solved for me too. :)