one more question Chumpy

[ultimatehex]

in mssql=>database=>account i cant find cabal_tool_registeraccount ...i search all post on this forum to see how can i make autopremium and i fail.i want every new account to be premium can you help me Chumpy


By the way,thx a lot for your tutorials,files and suport you really are my master ,keep going on :D

[MentaL]

[chumpywumpy]

Look in the stored procedure for the following line:

values(@UserNum, 0, DATEADD(day, 100 getdate()), 0)

The red number is the account type. 0 is a free account and 1 is charged (premium). The blue number is the expiry date (the dateadd function is adding 100 days to today's date). Simply change the 0 to 1 to make all new chars premium and change the 100 if you want them to have more than 100 days of prem.

[ultimatehex]

i cant find values(@UserNum, 0, DATEADD(day, 100 getdate()), 0) where is or where i must to put it ?? this is what i dont understood

[chumpywumpy]

It's here:

/****** 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)
values(@UserNum, 0, DATEADD(day, 100 getdate()), 0)

select @UserNum as usernum
commit

[ultimatehex]

in my data base is doesnt exist cabal_tool_registerAccount i search in entreprise manager and sql query ...nothing i cant found cabal_tool_registerAccount...this is the problem....i use ssql 2000 and chumpy database


sry my foul ,im stupid i found it :D

[cypher]

it`s not a table, it`s a stored procedure!