help for vip

[cover]

any one knows how to set up vip server files muemu season 6 epi 3


thanks in advance
RageZone Member

[MentaL]

[Dope Boy One]

check this for VIP : http://forum.ragezone.com/f196/muemu...9/#post8671595
and this too : http://forum.ragezone.com/f196/muemu...9/#post8663241

But however, you can deal with it if your Website supports your files versions without this.

[cover]

To make VIP Account auto expire, edit stored procedure "WZ_GetAccountLevel" in database <<< sir Dope Boy One you know how to do that ??

[Dope Boy One]

There is a guide about it on release, but however if you are using website like DMN CMS, and maybe imperialcms too, there is automatcly working via website, you don't need something else.

[cover]

There is a guide about it on release, but however if you are using website like DMN CMS, and maybe imperialcms too, there is automatcly working via website, you don't need something else.

im using mvcore website i forgot to write on my 1st post
any release, tutorials for mvcore sir ?

[RevolGaming]

You can make it another way with:
- create a table where you store username, vip exp date
- on the website with php you create a basic script (Player buy vip access, than you put the name into the table + an exp date)
- with a cron job you select the usernames from this table and write into a txt file
- you replace the connectmember.txt path in the gs config with your vip.txt path
- you reload the gs in every 30 sec -60 sec

You are done, if somebody buy vip access, than his username will be in the txt and than the gs will read the username.

[cover]

You can make it another way with:
- create a table where you store username, vip exp date
- on the website with php you create a basic script (Player buy vip access, than you put the name into the table + an exp date)
- with a cron job you select the usernames from this table and write into a txt file
- you replace the connectmember.txt path in the gs config with your vip.txt path
- you reload the gs in every 30 sec -60 sec

You are done, if somebody buy vip access, than his username will be in the txt and than the gs will read the username.

sir you have any tutorials or video tutorials its hard for me to do without guide i am beginner and i dont have this >> connectmember.txt
on my gs ..

thanks in advance

[RevolGaming]

It was a solution what I used before, first of all please learn a little bit and than make your muserver! If you have a little experience you will see its much more easyer and you can fix problems.

[cover]

Where do i put this code please help last step ahead

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER Procedure [dbo].[WZ_GetAccountLevel] @account varchar(10)
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @CurrentAccountLevel int
DECLARE @CurrentAccountExpireDate smalldatetime

SELECT @CurrentAccountLevel=AccountLevel,@CurrentAccountExpireDate=AccountExpireDate FROM MEMB_INFO WHERE memb___id @account

IF(@CurrentAccountLevel <> 0 AND getdate() > @CurrentAccountExpireDate)
BEGIN
SET @CurrentAccountLevel = 0

UPDATE MEMB_INFO SET AccountLevel=@CurrentAccountLevel,AccountExpireDate=@CurrentAccountExpireDate WHERE memb___id @account
END

SELECT @CurrentAccountLevel As AccountLevel,@CurrentAccountExpireDate As AccountExpireDate

SET NOCOUNT OFF
SET XACT_ABORT OFF

END
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

[KarLi]

how to run SQL query code

[cover]

thanks sir KarLi i will try it