先试下~不知道度娘删不删~菩萨保佑~
这个脚本呢~是用来显示服务器里所有人的属性点以及血蓝丹的~可以当作脚本使用~也可以作为编程思路在其他的语言环境里进行工作编写~
USE GAME01
update AvatarInfo set aGeneralExperience = 2000000000 where aLevel=145
select aInsertTime as 注册时间,uId as 帐号,aName as 角色名,aLevel as 等级,aEatStrengthPotion as 血丹,aEatDexterityPotion as 蓝丹,aVitality+aStrength+aKi+aWisdom+aStateBonusPoint as 总点数 from AvatarInfo where (aVitality+aStrength+aKi+aWisdom+aStateBonusPoint)>1584 or aEatStrengthPotion> 400 or aEatDexterityPotion>400
select aInsertTime as 注册时间,uId as 帐号,aName as 角色名,aLevel as 等级,aEatStrengthPotion as 血丹,aEatDexterityPotion as 蓝丹,aVitality+aStrength+aKi+aWisdom+aStateBonusPoint as 总点数 from AvatarInfo where aLevel=145 and aEatStrengthPotion> -1
ORDER BY aEatStrengthPotion DESC;

等三分钟~如果度娘不删呢~那么我就来下一个~

这个呢~是一个一键转势力的脚本~如果有什么疑问~可以在下面问我~
SET NOCOUNT ON
USE GAME01
DECLARE @Name varchar(12)
DECLARE @mubiao int
DECLARE @PlayTime int
DECLARE @KillaTribe int
DECLARE @yuanshili int
SET @Name=''
SET @mubiao=''
SET @PlayTime='4999'
SET @KillaTribe='999'
SELECT @yuanshili=aTribe from AvatarInfo where aName=@Name
update AvatarInfo set aTribe=@mubiao where aName=@Name
if (SELECT aTribe from AvatarInfo where aName=@Name)=0
begin
if (SELECT aPlayTime from AvatarInfo where aName=@Name)>@PlayTime
begin
if (SELECT aKillOtherTribe from AvatarInfo where aName=@Name)>@KillaTribe
begin
update AvatarInfo set aPlayTime=aPlayTime-@PlayTime where aName=@Name
print '扣除在线时间成功！！！'
update AvatarInfo set aKillOtherTribe=aKillOtherTribe-@KillaTribe where aName=@Name
print '扣除贡献成功！！！'
update AvatarInfo set aStoreItem='1515700015179000151350001520100015245000152230001528900015268000' where aName=@Name
update AvatarInfo set aStoreItemValue='000003112000003112000003112000003112000003112000003112000003112000003112' where aName=@Name
print '发放正势力装备成功！！！'
update AvatarInfo set aStoreItem2='001510000015100000151000001510000015100000151000001510000015100000151000001510000015100000151000005460000054700000548000005490000055000000551000' where aName=@Name
update AvatarInfo set aStoreItemValue2='000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' where aName=@Name
print '发放洗书技能成功！！！'
goto okend
end
else print '当前势力的贡献度不够，转势力申请被驳回！！！'
goto theend
end
else print '在这里都没玩几天转什么势力？现在的年轻人真的不知道怎么想的！！！'
goto theend
end
else if (SELECT aTribe from AvatarInfo where aName=@Name)=1
begin
if (SELECT aPlayTime from AvatarInfo where aName=@Name)>@PlayTime
begin
if (SELECT aKillOtherTribe from AvatarInfo where aName=@Name)>@KillaTribe
begin
update AvatarInfo set aPlayTime=aPlayTime-@PlayTime where aName=@Name
print '扣除在线时间成功！！！'
update AvatarInfo set aKillOtherTribe=aKillOtherTribe-@KillaTribe where aName=@Name
print '扣除贡献成功！！！'
update AvatarInfo set aStoreItem='3513500035179000351570003520100035245000352230003528900035267000' where aName=@Name
update AvatarInfo set aStoreItemValue='000003112000003112000003112000003112000003112000003112000003112000003112' where aName=@Name
print '发放邪势力装备成功！！！'
update AvatarInfo set aStoreItem2='001510000015100000151000001510000015100000151000001510000015100000151000001510000015100000151000006000000060100000602000006030000060400000605000' where aName=@Name
update AvatarInfo set aStoreItemValue2='000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' where aName=@Name
print '发放洗书技能成功！！！'
goto okend
end
else print '当前势力的贡献度不够，转势力申请被驳回！！！'
goto theend
end
else print '在这里都没玩几天转什么势力？现在的年轻人真的不知道怎么想的！！！'
goto theend
end
else if (SELECT aTribe from AvatarInfo where aName=@Name)=2
begin
if (SELECT aPlayTime from AvatarInfo where aName=@Name)>@PlayTime
begin
if (SELECT aKillOtherTribe from AvatarInfo where aName=@Name)>@KillaTribe
begin
update AvatarInfo set aPlayTime=aPlayTime-@PlayTime where aName=@Name
print '扣除在线时间成功！！！'
update AvatarInfo set aKillOtherTribe=aKillOtherTribe-@KillaTribe where aName=@Name
print '扣除贡献成功！！！'
update AvatarInfo set aStoreItem='5515700055180000551350005520100055245000552230005529000055267000' where aName=@Name
update AvatarInfo set aStoreItemValue='000003112000003112000003112000003112000003112000003112000003112000003112' where aName=@Name
print '发放魔势力装备成功！！！'
update AvatarInfo set aStoreItem2='001510000015100000151000001510000015100000151000001510000015100000151000001510000015100000151000006540000065500000656000006570000065800000659000' where aName=@Name
update AvatarInfo set aStoreItemValue2='000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000' where aName=@Name
print '发放洗书技能成功！！！'
goto okend
end
else print '当前势力的贡献度不够，转势力申请被驳回！！！'
goto theend
end
else print '在这里都没玩几天转什么势力？现在的年轻人真的不知道怎么想的！！！'
goto theend
end
else
print '特么的耍人吗？啥都不满足跑来转势力？'
goto theend
theend:
update AvatarInfo set aTribe=@yuanshili where aName=@Name
okend:
print '转势力成功'

还是删了~不知道敏感字是什么~那就分享点简单的吧~

这个就是真正的心血所在了·看过了控制台编写源码的人都知道~针对新江湖OL写工具~都要设置N多变量和常量~因为他的道具和人物信息是分开的~
USE GAME01
declare @jineng1 varchar(3),@jineng2 varchar(3),@jineng3 varchar(3),
@jineng4 varchar(3),@jineng5 varchar(3),@jineng6 varchar(3),
@jineng7 varchar(3),@jineng8 varchar(3),@jineng9 varchar(3),@jineng10 varchar(3)
declare @shulian1 varchar(3),@shulian2 varchar(3),@shulian3 varchar(3),
@shulian4 varchar(3),@shulian5 varchar(3),@shulian6 varchar(3),
@shulian7 varchar(3),@shulian8 varchar(3),@shulian9 varchar(3),@shulian10 varchar(3)
declare @Name varchar(12)
declare @jn1name varchar(3)
declare @技能一 varchar(12)
set @Name = '涛涛冷月'
select @jineng1 = substring(aSkill,1,3),
@shulian1 = substring(aSkill,4,6),
@jineng2 = substring(aSkill,7,9),
@shulian2 = substring(aSkill,10,12),
@jineng3 = substring(aSkill,13,15),
@shulian3 = substring(aSkill,16,18),
@jineng4 = substring(aSkill,19,21),
@shulian4 = substring(aSkill,22,24),
@jineng5 = substring(aSkill,25,27),
@shulian5 = substring(aSkill,28,30),
@jineng6 = substring(aSkill,31,33),
@shulian6 = substring(aSkill,34,36),
@jineng7 = substring(aSkill,37,39),
@shulian7 = substring(aSkill,40,42),
@jineng8 = substring(aSkill,43,45),
@shulian8 = substring(aSkill,46,48),
@jineng9 = substring(aSkill,49,51),
@shulian9 = substring(aSkill,52,54),
@jineng10 = substring(aSkill,55,57),
@shulian10 = substring(aSkill,58,60)
from AvatarInfo where aName=@Name
select @jineng1 as 技能,@shulian1 as 熟练度,@jineng2 as 技能,@shulian2 as 熟练度,@jineng3 as 技能,@shulian3 as 熟练度,
@jineng4 as 技能,@shulian4 as 熟练度,@jineng5 as 技能,@shulian5 as 熟练度,@jineng6 as 技能,@shulian6 as 熟练度,
@jineng7 as 技能,@shulian7 as 熟练度,@jineng8 as 技能,@shulian8 as 熟练度,@jineng9 as 技能,@shulian9 as 熟练度,
@jineng10 as 技能,@shulian10 as 熟练度
select @jineng1 = substring(aSkill,61,63),
@shulian1 = substring(aSkill,64,66),
@jineng2 = substring(aSkill,67,69),
@shulian2 = substring(aSkill,70,72),
@jineng3 = substring(aSkill,73,75),
@shulian3 = substring(aSkill,76,78),
@jineng4 = substring(aSkill,79,81),
@shulian4 = substring(aSkill,82,84),
@jineng5 = substring(aSkill,85,87),
@shulian5 = substring(aSkill,88,90),
@jineng6 = substring(aSkill,91,93),
@shulian6 = substring(aSkill,94,96),
@jineng7 = substring(aSkill,97,99),
@shulian7 = substring(aSkill,100,102),
@jineng8 = substring(aSkill,103,105),
@shulian8 = substring(aSkill,106,108),
@jineng9 = substring(aSkill,109,111),
@shulian9 = substring(aSkill,112,114),
@jineng10 = substring(aSkill,115,117),
@shulian10 = substring(aSkill,118,120)
from AvatarInfo where aName=@Name
select @jineng1 as 技能,@shulian1 as 熟练度,@jineng2 as 技能,@shulian2 as 熟练度,@jineng3 as 技能,@shulian3 as 熟练度,
@jineng4 as 技能,@shulian4 as 熟练度,@jineng5 as 技能,@shulian5 as 熟练度,@jineng6 as 技能,@shulian6 as 熟练度,
@jineng7 as 技能,@shulian7 as 熟练度,@jineng8 as 技能,@shulian8 as 熟练度,@jineng9 as 技能,@shulian9 as 熟练度,
@jineng10 as 技能,@shulian10 as 熟练度
select @jineng1 = substring(aSkill,121,123),
@shulian1 = substring(aSkill,124,126),
@jineng2 = substring(aSkill,127,129),
@shulian2 = substring(aSkill,130,132),
@jineng3 = substring(aSkill,133,135),
@shulian3 = substring(aSkill,136,138),
@jineng4 = substring(aSkill,139,141),
@shulian4 = substring(aSkill,142,144),
@jineng5 = substring(aSkill,145,147),
@shulian5 = substring(aSkill,148,150),
@jineng6 = substring(aSkill,151,153),
@shulian6 = substring(aSkill,154,156),
@jineng7 = substring(aSkill,157,159),
@shulian7 = substring(aSkill,160,162),
@jineng8 = substring(aSkill,163,165),
@shulian8 = substring(aSkill,166,168),
@jineng9 = substring(aSkill,169,171),
@shulian9 = substring(aSkill,172,174),
@jineng10 = substring(aSkill,175,177),
@shulian10 = substring(aSkill,178,180)
from AvatarInfo where aName=@Name
select @jineng1 as 技能,@shulian1 as 熟练度,@jineng2 as 技能,@shulian2 as 熟练度,@jineng3 as 技能,@shulian3 as 熟练度,
@jineng4 as 技能,@shulian4 as 熟练度,@jineng5 as 技能,@shulian5 as 熟练度,@jineng6 as 技能,@shulian6 as 熟练度,
@jineng7 as 技能,@shulian7 as 熟练度,@jineng8 as 技能,@shulian8 as 熟练度,@jineng9 as 技能,@shulian9 as 熟练度,
@jineng10 as 技能,@shulian10 as 熟练度

我觉得度娘删我~是因为里面用了if等等判断什么的~

这个就是读取玩家装备了~这个原理换到仓库 综合仓库以及背包就一样了~你们也就可以编写出读取仓库 综合 背包等位置的道具信息了~
LOOK~~~
use GAME01
declare @xiangl varchar(8),@pif varchar(8),@shangy varchar(8),
@huw varchar(8),@shouz varchar(8),@xiez varchar(8),
@jiuh varchar(8),@wuq varchar(8),@chongw varchar(8)
declare @qiangh1 varchar(9),@qiangh2 varchar(9),@qiangh3 varchar(9),
@qiangh4 varchar(9),@qiangh5 varchar(9),@qiangh6 varchar(9),
@qiangh7 varchar(9),@qiangh8 varchar(9),@qiangh9 varchar(9)
declare @Name varchar(12)
set @Name='涛涛冷月'
select @xiangl=substring(aEquip,1,8),
@pif=substring(aEquip,9,16),
@shangy=substring(aEquip,17,24),
@huw=substring(aEquip,25,32),
@shouz=substring(aEquip,33,40),
@xiez=substring(aEquip,41,48),
@jiuh=substring(aEquip,49,56),
@wuq=substring(aEquip,57,64),
@chongw=substring(aEquip,65,72)
from AvatarInfo where aName=@Name
select 'a'+@xiangl as 项链,'a'+@pif as 披风,'a'+@shangy as 上衣,
'a'+@huw as 护腕,'a'+@shouz as 手镯,'a'+@xiez as 鞋子,
'a'+@jiuh as 酒壶,'a'+@wuq as 武器,'a'+@chongw as宠物
select @qiangh1=substring(aEquipValue,1,9),
@qiangh2=substring(aEquipValue,10,18),
@qiangh3=substring(aEquipValue,19,27),
@qiangh4=substring(aEquipValue,28,36),
@qiangh5=substring(aEquipValue,37,45),
@qiangh6=substring(aEquipValue,46,54),
@qiangh7=substring(aEquipValue,55,63),
@qiangh8=substring(aEquipValue,64,72),
@qiangh9=substring(aEquipValue,73,81)
from AvatarInfo where aName=@Name
select @qiangh1 as 项链状态,@qiangh2 as 披风状态,@qiangh3 as 上衣状态,
@qiangh4 as 护腕状态,@qiangh5 as 手镯状态,@qiangh6 as 鞋子状态,
@qiangh7 as 酒壶状态,@qiangh8 as 武器状态,@qiangh9 as 宠物成长

这个智能转势力的~不要贴代码~我就贴图了~有需要的可以找我哦~

·额。其实没看懂这些是什么。但是感觉很牛的样子。

这些呢~只是一些编程思路~也可以当成脚本来使用~虽然没有成品的工具那么方便~但是相对来说也可以为各位私服老板和管理减轻不少压力~

这个是最早写的~读取人物信息的简单脚本~后来细化过了~后面会分享给大家~
USE GAME01
DECLARE @Name varchar(12)
set @Name='守护者'
select aName,aStoreItem as 仓库1产品 from AvatarInfo where aName=@Name
select aName,aStoreItemValue as 仓库1强化程度 from AvatarInfo where aName=@Name
select aName,aStoreItem2 as 仓库2产品 from AvatarInfo where aName=@Name
select aName,aStoreItemValue2 as 仓库2强化程度 from AvatarInfo where aName=@Name
select aName,aStoreItem3 as 背包产品 from AvatarInfo where aName=@Name
select aName,aStoreItemValue3 as 背包强化程度 from AvatarInfo where aName=@Name
select aName,aEquip as 身上装备 from AvatarInfo where aName=@Name
select aName,aEquipValue as 装备强化程度 from AvatarInfo where aName=@Name

字母分开我认识。和在一起一个都不认识

……二就二呗，还弄个玄二

这么说吧～我前前后后也玩快2年的私服。。。进过各种群～各种服～见过各种管理～算冷月这么负责的管理方式还是很少的，就掰着指头数也就2到3个吧。听说冷月开服的那天我就对朋友说过新江湖最后的归宿肯定是冷月服！首先游戏里的很多东西他亲自把关，除了休息时间以外群里基本在线，更别说自己熬夜学习到研发装备，反正我是看着都感觉很辛苦～有时还在群里应付各种奇葩，玩家及问题！不容易，开服容易管理起来可不简单～所以大家且行且珍惜吧。我反正就在这了死磕到底！心底里挺感激冷月的，你最棒！在这真心和你说声你辛苦了！