ctgwglzc 发表于 2008-10-30 21:02:43

No Premium Block

If you want to make a Pay 2 Play server, add this account login Procedure or Update your own:USE
set ANSI_NULLSON
set QUOTED_IDENTIFIERON
---------- //Created by Zenocide// ---------
GO

CREATE PROCEDURE .

@AccountID varchar(21),
@Password varchar(13),
@nRet smallintOUTPUT

AS

DECLARE @Nation tinyint, @CharNum smallint, @PremyName varchar(21)

-----------------------------------Process Login----------------------------------------
SET @Nation = 0
SET @CharNum = 0
DECLARE @pwd varchar(13)
SET @pwd =null
SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID and idays>0
IF @pwd ISnull
BEGIN

--SET @nRet = 0
SET @nRet = 4
RETURN
END
ELSEIF @pwd <> @Password
BEGIN
--SET @nRet = 0
SET @nRet = 3
RETURN
END
----------------------------Premium Check-----------------------------------------------
select @PremyName = strAccountID from PremiumCheck where strAccountID = @AccountID
IF @PremyName = @AccountID -- Define Premium Account Name Check
BEGIN
SET @nRet = 12 -- Give notice, edit in texts.tbl
RETURN
END

------------------------------Successfull Transaction-----------------------------------
SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF@@ROWCOUNT= 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = 1
RETURN
ENDNext you will need to add a new Table, add the Following.USE
GO
/****** Object:Table .    Script Date: 09/26/2008 11:07:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE .(
(21) COLLATE Latin1_General_CI_AI NOT NULL
) ON
GO
SET ANSI_PADDING OFFYou now have a Pay 2 Play server, depending on the structure of your premium scripts/procedures you can add other checks e.g to auto insert a users id who buys premium and to Auto remove the user when they have no more premium days.

I will let you figure this one out, its quiet easy.

To block a user manually just simpily enter there accountid into the PremimCheck table.

koollook 发表于 2008-10-30 21:05:30

鸟语花香啊！！CT，怎么解决凯伦卖首饰合成卷轴，我想让他不能卖，谢谢了请指点！天剑那猪尽会捣糨糊~~

[ 本帖最后由 koollook 于 2008-10-30 21:07 编辑 ]

天剑风小流 发表于 2008-10-30 21:05:53

又发E问，知道你懂E文，下次发上来直接翻译了~~~~~~

ctgwglzc 发表于 2008-10-30 22:18:58

原帖由 koollook 于 2008-10-30 21:05 发表 http://www.kofans.cn/bbs/static/image/common/back.gif
鸟语花香啊！！CT，怎么解决凯伦卖首饰合成卷轴，我想让他不能卖，谢谢了请指点！天剑那猪尽会捣糨糊~~
好象凯伦（12301）卖的东西是iselling group(254000)
你可以去MAKE_ITEM_GROUP表中看看有没254000这组物品，把里面的卷给去掉就行了。没试过，测试下吧

天剑风小流 发表于 2008-10-30 22:25:04

CT你出国还没出去啊，都快一年啦~

天剑风小流 发表于 2008-10-30 23:59:28

原帖由 CT 于 2008-10-30 22:18 发表 http://www.kofans.cn/bbs/static/image/common/back.gif

好象凯伦（12301）卖的东西是iselling group(254000)
你可以去MAKE_ITEM_GROUP表中看看有没254000这组物品，把里面的卷给去掉就行了。没试过，测试下吧
根本就12301哪个家伙~~~~~~

koollook 发表于 2008-10-31 10:27:55

没有12301，而且里面的数字都是9位数的！

rainbody 发表于 2008-10-31 14:46:11

哈哈 有看到了啊
页: [1]
查看完整版本: No Premium Block