武器含有最新吸血特殊的属性修改。 SHAPE值：戒指136 手镯137 项链138的特殊属性是吸血，anicoun这个属性大家看到了吧，很多人不知道是什么用吧，这里你可以在0--100之间调整，数值越高，吸血越猛烈，调到100后，带两手镯，两戒指，一项链，基本是不死之身，只要你一挥出刀马上满HP，建议调为30，很明显的吸血装备.
F[BJhN*]a
补充：武器 204的特殊属性也是吸血的。但是要注意的是。如果武器也加入了会产生一些奇怪的效果。有的时候会挥不出来刀。不要怪偶没有提醒哦？
配套SQL查询指令
F[BJhN*]a
--思路：将所有玩家仓库/身上/包袱中的装备全部放入一个临时表，再从临时表中查询MAKEINDEX重复的装备并遂个删除
F[BJhN*]a
-- 删除的记录记在日志文件TBL__DELLOG中。
F[BJhN*]a
--日期：2003/04/29
F[BJhN*]a
--修正日期：2003/05/20
---建立临时表
F[BJhN*]a
if exists (select * from dbo.sysobjects where id = object_id(N＇[dbo].[TBL_ALLITEM]＇) and OBJECTPROPERTY(id, N＇IsUserTable＇) = 1)
F[BJhN*]a
drop table [dbo].[TBL_ALLITEM]
F[BJhN*]a
GO
CREATE TABLE [dbo].[TBL_ALLITEM] (
F[BJhN*]a
[FLD_CHARACTER] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
F[BJhN*]a
[FLD_TYPE] [tinyint] NULL ,
F[BJhN*]a
[FLD_MAKEINDEX] [int] NOT NULL ,
F[BJhN*]a
[FLD_TID] [varchar] (30) NOT NULL ,
F[BJhN*]a
[FLD_INDEX] [int] NOT NULL ,
F[BJhN*]a
[Name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
F[BJhN*]a
[Place] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
F[BJhN*]a
) ON [PRIMARY]
F[BJhN*]a
GO
--从玩家身上/包袱获取数据
F[BJhN*]a
INSERT INTO [muddb].[dbo].[TBL_ALLITEM]([FLD_CHARACTER], [FLD_TYPE], [FLD_MAKEINDEX],[FLD_TID],[FLD_INDEX],[Name],[Place])
F[BJhN*]a
SELECT [FLD_CHARACTER], [FLD_TYPE], [FLD_MAKEINDEX], LTRIM(STR([FLD_MAKEINDEX]))+LTRIM(STR([FLD_INDEX])) AS FLD_TID,[FLD_INDEX],[Name],＇身上＇ AS Place
F[BJhN*]a
FROM [muddb].[dbo].[TBL_ITEM],[muddb].[dbo].[StdItems]
F[BJhN*]a
WHERE [FLD_INDEX]-1=[Idx]
F[BJhN*]a
GO
--从仓库获取数据
F[BJhN*]a
INSERT INTO [muddb].[dbo].[TBL_ALLITEM]([FLD_CHARACTER], [FLD_TYPE], [FLD_MAKEINDEX],[FLD_TID],[FLD_INDEX],[Name],[Place])
F[BJhN*]a
SELECT [FLD_CHARACTER], [FLD_TYPE], [FLD_MAKEINDEX], LTRIM(STR([FLD_MAKEINDEX]))+LTRIM(STR([FLD_INDEX])) AS FLD_TID,[FLD_INDEX],[Name],＇仓库＇ AS Place
F[BJhN*]a
FROM [muddb].[dbo].[TBL_SAVEDITEM],[muddb].[dbo].[StdItems]
F[BJhN*]a
WHERE [FLD_INDEX]-1=[Idx]
F[BJhN*]a
GO
--记录将要删除的复制装备
F[BJhN*]a
if not exists (select * from dbo.sysobjects where id = object_id(N＇[muddb].[dbo].[TBL__DELLOG]＇) and OBJECTPROPERTY(id, N＇IsUserTable＇) = 1)
F[BJhN*]a
CREATE TABLE [muddb].[dbo].[TBL__DELLOG] (
F[BJhN*]a
[删除日期] datetime not null,
F[BJhN*]a
[FLD_MAKEINDEX] [int] NOT NULL ,
F[BJhN*]a
[角色名] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
F[BJhN*]a
[装备代码] [int] NULL ,
F[BJhN*]a
[装备名称] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL,
F[BJhN*]a
[存放地点] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
F[BJhN*]a
) ON [PRIMARY]
GO
INSERT INTO [muddb].[dbo].[TBL__DELLOG]([删除日期],[FLD_MAKEINDEX],[装备代码],[装备名称],[角色名],[存放地点])
F[BJhN*]a
SELECT getdate() as 删除日期,[FLD_MAKEINDEX] , [FLD_INDEX]-1 AS 装备代码,[Name] AS 装备名称,[FLD_CHARACTER] AS 角色名, [Place] AS 存放地点
F[BJhN*]a
FROM [muddb].[dbo].[TBL_ALLITEM]
F[BJhN*]a
WHERE ((([FLD_TID]) In
F[BJhN*]a
(SELECT [FLD_TID] FROM [TBL_ALLITEM] As Tmp GROUP BY [FLD_TID] HAVING Count([FLD_TID])>1 )))
F[BJhN*]a
ORDER BY [FLD_MAKEINDEX]
GO
F[BJhN*]a
--遂个删除复制装备
F[BJhN*]a
DECLARE @T_ID char (30),@I_MAKEINDEX int , @V_Place varchar (10)
F[BJhN*]a
DECLARE D_ITEMS_cursor CURSOR FOR
SELECT [FLD_TID],[FLD_MAKEINDEX],[Place]
F[BJhN*]a
FROM [muddb].[dbo].[TBL_ALLITEM]
F[BJhN*]a
WHERE ((([FLD_TID]) In
F[BJhN*]a
(SELECT [FLD_TID] FROM [TBL_ALLITEM] As Tmp GROUP BY [FLD_TID]
F[BJhN*]a
HAVING Count([FLD_TID])>1 )))
F[BJhN*]a
ORDER BY [FLD_MAKEINDEX]
OPEN D_ITEMS_cursor
FETCH NEXT FROM D_ITEMS_cursor INTO @T_ID,@I_MAKEINDEX,@V_Place
WHILE @@FETCH_STATUS = 0
BEGIN
BEGIN
F[BJhN*]a
IF @V_Place = ＇仓库＇
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_SAVEDITEM] WHERE [FLD_MAKEINDEX] = @I_MAKEINDEX
F[BJhN*]a
ELSE
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_ITEM] WHERE [FLD_MAKEINDEX] = @I_MAKEINDEX
F[BJhN*]a
END
FETCH NEXT FROM D_ITEMS_cursor INTO @T_ID,@I_MAKEINDEX,@V_Place
END
CLOSE D_ITEMS_cursor
F[BJhN*]a
DEALLOCATE D_ITEMS_cursor
GO
if exists (select * from dbo.sysobjects where id = object_id(N＇[dbo].[TBL_ALLITEM]＇) and OBJECTPROPERTY(id, N＇IsUserTable＇) = 1)
F[BJhN*]a
drop table [dbo].[TBL_ALLITEM]
GO
F[BJhN*]a
--------------------------------------------------------------
F[BJhN*]a
--作者：口吃的男人
F[BJhN*]a
--说明：此SQL脚本专为删除垃圾数据而写
F[BJhN*]a
--思路：提取所有已删除或者级别小于21的角色名最后一次登陆在2003年7月30号以前的，
F[BJhN*]a
并删除与此角色相关的装备及技能
F[BJhN*]a
--最后修正日期：2003/05/20
F[BJhN*]a
WHERE [FLD_DELETED]=1 AND FLD_UPDATEDATETIME < ＇2003 - 7 - 30＇ (删除7月30以前没有登陆的所有用户)
F[BJhN*]a
------------------------------------------------------------------
F[BJhN*]a
DECLARE @username char(15)
F[BJhN*]a
DECLARE D_lj_cursor CURSOR FOR
SELECT [FLD_CHARACTER] FROM [muddb].[dbo].[TBL_CHARACTER]
F[BJhN*]a
WHERE [FLD_DELETED]=1 OR ([FLD_LEVEL]<21 AND FLD_UPDATEDATETIME < ＇2003 - 7 - 30＇)
OPEN D_lj_cursor
FETCH NEXT FROM D_lj_cursor INTO @username
WHILE @@FETCH_STATUS = 0
BEGIN
F[BJhN*]a
PRINT ＇正在删除 ＇+@username+＇ 的相关资料......＇
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_MAGIC] WHERE [FLD_CHARACTER] = @username
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_ITEM] WHERE [FLD_CHARACTER] = @username
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_SAVEDITEM] WHERE [FLD_CHARACTER] = @username
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_QUEST] WHERE [FLD_CHARACTER] = @username
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_SKILL] WHERE [FLD_CHARACTER] = @username
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_CURRENTABILITY] WHERE [FLD_CHARACTER] = @username
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_ABILITY] WHERE [FLD_CHARACTER] = @username
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_CHARACTER] WHERE [FLD_CHARACTER] = @username
FETCH NEXT FROM D_lj_cursor INTO @username
END
CLOSE D_lj_cursor
F[BJhN*]a
DEALLOCATE D_lj_cursor
------------------------------------------------------------------
F[BJhN*]a
SQL中查询自己定意级别,多久没登录的语句!
F[BJhN*]a
SQL中执行上面命令就可以了
F[BJhN*]a
SELECT *
F[BJhN*]a
FROM TBL_CHARACTER
F[BJhN*]a
WHERE (FLD_LEVEL < 21) AND (FLD_UPDATEDATETIME < ＇2003 - 7 - 30＇)
F[BJhN*]a
--------------------------------------------------------------
F[BJhN*]a
查询人物
F[BJhN*]a
SELECT *
F[BJhN*]a
FROM TBL_CHARACTER
F[BJhN*]a
WHERE (FLD_INDEX = ＇34＇)
F[BJhN*]a
--------------------------------------------------------------
F[BJhN*]a
--人身上的物品代码为34的物品全部删除掉，还有仓库的
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_ITEM]
F[BJhN*]a
WHERE [FLD_INDEX]=34
DELETE FROM [muddb].[dbo].[TBL_SAVEDITEM]
F[BJhN*]a
WHERE [FLD_INDEX]=34
-------------------------------------------------------------
F[BJhN*]a
/*查找身上与箱子里的复制物品*/
F[BJhN*]a
SQL中执行上面命令就可以了
F[BJhN*]a
SELECT *
F[BJhN*]a
FROM TBL_ITEM
F[BJhN*]a
WHERE (FLD_MAKEINDEX IN
F[BJhN*]a
(SELECT fld_makeindex
F[BJhN*]a
FROM tbl_saveditem))
F[BJhN*]a
ORDER BY FLD_MAKEINDEX
--------------------------------------------------------------
F[BJhN*]a
--角色改名,所有相关资料随同转移到新角色上面。
F[BJhN*]a
--@username 原名
F[BJhN*]a
--@username1 新角色名
DECLARE @username varchar(10),@username1 varchar(10)
F[BJhN*]a
set @username=＇口吃的男人＇
F[BJhN*]a
set @username1=＇不再口吃＇
UPDATE [muddb].[dbo].[TBL_QUEST]
F[BJhN*]a
SET [FLD_CHARACTER] = @username1
F[BJhN*]a
WHERE [FLD_CHARACTER] like @username
UPDATE [muddb].[dbo].[TBL_MAGIC]
F[BJhN*]a
SET [FLD_CHARACTER] = @username1
F[BJhN*]a
WHERE [FLD_CHARACTER] like @username
UPDATE [muddb].[dbo].[TBL_ITEM]
F[BJhN*]a
SET [FLD_CHARACTER] = @username1
F[BJhN*]a
WHERE [FLD_CHARACTER] like @username
UPDATE [muddb].[dbo].[TBL_SAVEDITEM]
F[BJhN*]a
SET [FLD_CHARACTER] = @username1
F[BJhN*]a
WHERE [FLD_CHARACTER] like @username
UPDATE [muddb].[dbo].[TBL_CHARACTER]
F[BJhN*]a
SET [FLD_CHARACTER] = @username1
F[BJhN*]a
WHERE [FLD_CHARACTER] like @username
UPDATE [muddb].[dbo].[TBL_ABILITY]
F[BJhN*]a
SET [FLD_CHARACTER] = @username1
F[BJhN*]a
WHERE [FLD_CHARACTER] like @username
------------------------------------------------------------------
F[BJhN*]a
--调级
F[BJhN*]a
DECLARE @username varchar(10)
F[BJhN*]a
set @username=＇口吃的男人＇
UPDATE [muddb].[dbo].[TBL_CHARACTER]
F[BJhN*]a
SET [FLD_LEVEL]=40
F[BJhN*]a
WHERE [FLD_CHARACTER] like @username
UPDATE [muddb].[dbo].[TBL_ABILITY]
F[BJhN*]a
SET [FLD_LEVEL]=40
F[BJhN*]a
WHERE [FLD_CHARACTER] like @username
F[BJhN*]a
------------------------------------------------------------------
F[BJhN*]a
--删除技能
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_MAGIC]
F[BJhN*]a
--删除包中的物品
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_ITEM]
F[BJhN*]a
--删除仓库物品
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_SAVEDITEM]
F[BJhN*]a
--删除任务数据
F[BJhN*]a
DELETE FROM [muddb].[dbo].[TBL_QUEST]
--调整所有玩家级别为七级，金钱为5000,经验为0
F[BJhN*]a
UPDATE [muddb].[dbo].[TBL_CHARACTER]
F[BJhN*]a
SET [FLD_LEVEL]=7, [FLD_GOLD]=5000
F[BJhN*]a
UPDATE [muddb].[dbo].[TBL_ABILITY]
F[BJhN*]a
SET [FLD_LEVEL]=7,[FLD_EXP] = 0
F[BJhN*]a
----------------------------------------------------------------
F[BJhN*]a
SELECT *
F[BJhN*]a
FROM TBL_CHARACTER
F[BJhN*]a
where FLD_CHARACTER=＇非凡＇
选择所有项目来自于表格TBL_CHARACTER,列出符合条件为"非凡"的人物名称.
SELECT *
F[BJhN*]a
FROM TBL_MAGIC
F[BJhN*]a
where FLD_CHARACTER=＇xtwfgypm＇
SELECT *
F[BJhN*]a
FROM TBL_CHARACTER
F[BJhN*]a
where FLD_USERID=＇3680550＇
选择所有项目来自于表格TBL_CHARACTER,列出符合条件为"3680550"的帐号id
SELECT *
F[BJhN*]a
FROM TBL_SAVEDITEM
F[BJhN*]a
where FLD_DURA=＇41000＇
选择所有项目来自于表格TBL_SAVEDITEM(人物的仓库),列出符合条件为"41000"的持久度或纯度.
SELECT *
F[BJhN*]a
FROM TBL_ITEM
F[BJhN*]a
where FLD_INDEX=＇286＇
选择所有项目来自于表格TBL_ITEM(人物包袱),列出符合条件为"286"的物品序号
SELECT *
F[BJhN*]a
FROM TBL_ITEM
F[BJhN*]a
where FLD_MAKEINDEX=＇220076414＇
选择所有项目来自于表格TBL_ITEM(人物包袱),列出符合条件为"220076414"的制造时间戳.
F[BJhN*]a
