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

All i did was set it to 5, didn't touch the dates at all and it works for me.

And what client are you using?

And what client are you using?
Plz help me to make Premium!

I use the chinese client + darkxl patch + snaity patch.

I know me too.. but what version of the client?
I am using 21.0.0222.
Plz try to help me guys! :(

Yes i use TFN client and have bug on PREMIUM, so i think there are some errors in database!

So plz, how to fix it?!

i fix it many times..........it still ' Free User'

plemaster...
expiredate 2551 isn't that too mcuh? :O try 2009 or 2010
you got read what i wrote? :O
i meant it doesn't say error0024
error0024 is my name...try to read

try to increase the duration of payminutes

Quote:

---

Originally Posted by error0024

plemaster...
expiredate 2551 isn't that too mcuh? :O try 2009 or 2010
you got read what i wrote? :O
i meant it doesn't say error0024
error0024 is my name...try to read

try to increase the duration of payminutes

---

i'm sorry ><

expiredate 2551 Time zone's (GMT+07:00) Bangkok, Hanoi, Jakarta

it equate with 2008


... try to increase the duration of payminutes i'll try

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