[help]Global inventory any place for only premium

[Ghislanine]

[h=1][HELP] Global inventory any place for only premium[/h]https://forum.ragezone.com/f792/help-global-inventory-premium-1019023/
I follow this post, but it doesn't work.Please help me.I use the PandemicZ source

---

declare @ IsPremium int
select @ IsPremium from UsersData where CustomerID=@in_CustomerID


if @ IsPremium = 1) begin


update UsersChars set
GameFlags=1
where CharID=@in_CharID


end

 

[Yuri-BR]

properly would be like

declare @IsPremium int;
select @IsPremium from UsersData where CustomerID=@in_CustomerID


if (@IsPremium = 1) begin
update UsersChars set GameFlags=1 where CharID=@in_CharID
end

and check for the existence of this column IsPremium in the table UsersData



or if is new source code try it

declare @PremiumExpireTime datetime;
select @PremiumExpireTime = PremiumExpireTime from UsersData where CustomerID = @in_CustomerID;


if(@PremiumExpireTime > GETDATE()) begin
update UsersChars set GameFlags = 1 where CustomerID = @in_CustomerID;
end