[Help] How to auto add premium in new account?

[kiybla1qz]

Everyone Good

I want to Auto Add premium in new account please help me

thank

[MentaL]

[Yuri-BR]

Try it

in WZ_ACCOUNT_CREATE

Add

update UsersData set IsPremium = 1 where CustomerID=@CustomerID

[kiybla1qz]

Try it

in WZ_ACCOUNT_CREATE

Add

update UsersData set IsPremium = 1 where CustomerID=@CustomerID

thank you for help, I will set a date to?




For example, the premium 3 days in new account.

[Yuri-BR]

thank you for help, I will set a date to?




For example, the premium 3 days in new account.

PremiumExpireDate = '2014-16-11 00:00:00.000'

[kiybla1qz]

this?


update UsersData set IsPremium = 1 PremiumExpireDate = '2014-16-11 00:00:00.000' where CustomerID=@CustomerID

[erickstyle]

update UsersData set isPremium=1 WHERE CustomerID=@CustomerID
update UsersData set PremiumExpireDate=DATEADD(DAY, 3, GETDATE()) WHERE CustomerID=@CustomerID


3 days Premium

[Noobly]

You could just do this if your server is using account types

Open WZ_ACCOUNT_CREATE then you will see this.

declare @KeyserialType int = 0

0 = Legend acc
2 = Normal acc