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

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 !!!!

http://img135.imageshack.us/img135/9...miumzb6.th.jpg

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

here an create coount procedure can auto add premium to accounts

Code:

---

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

Code:

---

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

---

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

Quote:

---

Originally Posted by 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

Code:

---

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

Code:

---

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 ^.^

no problem for the duration heh :P
nice

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