Premium not inserted

[mirceagab]

So check this out.i have all the settings done

The trigger is on.the reg page is tested and worked.All permissions granted.But after a centos reboot premium is not inserted anymore in db,and it creates free users only.It happend before the reboot but after a relog the premium worked...

The problem seems to be from the REG page cus if i add an account manualy it works...

[MentaL]

[Netgear]

what client are u using and post ur Trigger here

[Yamachi]

are you using the stored procedure ACCOUNT.cabal_tool_registerAccount?

[mirceagab]

CREATE TRIGGER [fixlogin] ON [dbo].[cabal_auth_table]
FOR INSERT, UPDATE, DELETE
AS
begin
update cabal_auth_table set login = 0
end


This was the trigger that worked till now.And this is the php line in reg page to add the premium..

$sql3 = mssql_query("INSERT INTO dbo.cabal_charge_auth (UserNum,Type,ExpireDate,PayMinutes,ServiceKind) VALUES ('$total_users','5','8/19/2009','9999','1') ");

[[hidden]]

yes it is your reg page. add code to include the complete stored procedure, to include entry into the premium table.

test by simply checking the premium (cabal_charge_auth) table after registration.

note if an entry is added for every new account or not. recode from there.

[chumpywumpy]

CREATE TRIGGER [fixlogin] ON [dbo].[cabal_auth_table]
FOR INSERT, UPDATE, DELETE
AS
begin
update cabal_auth_table set login = 0
end

That trigger is nothing to do with premium or new accounts. It was a fudge used to avoid certain problems during login before we got the fix.

Remove that trigger immediately. If it is there then your players can duplicate items!

I don't know why you are adding your premium that way as it is much more work than is needed. Just amend the registration stored procedure to do it for you.
http://forum.ragezone.com/showthread.php?t=452000

[mirceagab]

sry i ment to post this trigger

CREATE TRIGGER [premiumforall] ON [dbo].[cabal_charge_auth]
FOR INSERT, UPDATE, DELETE
AS
UPDATE [account].[dbo].[cabal_charge_auth] SET
[Type] = 5
,[ExpireDate] = DATEADD(year, 10, getdate())
,[PayMinutes] = 999999
,[ServiceKind] = 1

And btw chumpy i use that way also...and still doesnt work.

Hidden i did check and its not inserting nothing in acabal_charge_auth..not even the account with authtype 1...and it worked before...

sorry for double posting but still didn't solved this.Any ideeas?

[cypher]

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.