常用修改

关于高级SQL版本登陆账号错误解决方法

关于SQL数据库属性为90（2005）以上。

LS里出现COdbcBindColumn::Execute - [Microsoft][ODBC SQL Server Driver][SQL Server]此查询使用的不是 ANSI 外部联接运算符("=" 或 "=")。若要不进行修改即运行此查询，请使用 ALTER DATABASE 的 SET COMPATIBILITY_LEVEL 选项将当前数据库的兼容级别设置为 80。

极力建议使用 ANSI 外部联接运算符(LEFT OUTER JOIN、RIGHT OUTER JOIN)重写此查询。

在将来的 SQL Server 版本中，即使在向后兼容模式下，也不支持非 ANSI 联接运算符。

以上有二点解决:

1：把数据库属性改2000也就是80。现在高级版SQL里边不兼容SQL2000.就用第二种方法解决。 2：用16进制软件修改把NSLoginServer.exe应用程序也就是我们通常说的LS把*=改成=

列子

UserId *= p.UserId

改

UserId = p.UserId

增加武器

这一课讲如何在数据库中添加新的装备比如是108武器打开数据库MAIN_DB_1表ItemParams

我们都知道数据库中有2把103武器一把是8266 1把是8234 这个属性武器

怎么加108数据我现在就加下 103武器是8266 +1就是108武器这里边属性可以自己改怎么改都行现在在吧属性这个武器代码加上8234 +1=8235如果这个不加就没有属性 8235这个属性还要在ItemExtParams表里加上这个属性8235 我加上了有6种属性好了就到这里

108 武器

修改经验

修改经验需要重启对应国家地图

update MAIN_DB_1.dbo.NpcParams set Exp=Exp*0.2;
update MAIN_DB_1.dbo.NpcParams2 set Exp=Exp*0.2;


UPDATE [dbo].[NpcParams] set Exp=Exp*2
UPDATE [dbo].[NpcParams2] set Exp=Exp*2

NpcParams+NpcParams2 的和除以2 就是经验

修改爆率

根据自己的数据来修改。

UPDATE NpcDropItemParams2
SET   Pro01 = 1000, Pro02 = 1000, Pro03 = 1000, Pro04 = 1000, Pro05 = 1000,
      Pro06 = 1000, Pro07 = 1000, Pro08 = 1000, Pro09 = 1000, Pro10 = 1000,
      Pro11 = 1000, Pro12 = 1000, Pro13 = 1000, Pro14 = 1000, Pro15 = 1000,
      Pro16 = 1000, Pro17 = 1000, Pro18 = 1000, Pro19 = 1000, Pro20 = 1000,
      Pro21 = 1000, Pro22 = 1000, Pro23 = 1000, Pro24 = 1000, Pro25 = 1000,
      Pro26 = 1000, Pro27 = 1000, Pro28 = 1000, Pro29 = 1000, Pro30 = 1000,
      Pro31 = 1000, Pro32 = 1000, Pro33 = 1000, Pro34 = 1000, Pro35 = 1000,
      Pro36 = 1000, Pro37 = 1000, Pro38 = 1000, Pro39 = 1000, Pro40 = 1000,
      Pro41 = 1000, Pro42 = 1000, Pro43 = 1000, Pro44 = 1000, Pro45 = 1000,
      Pro46 = 1000, Pro47 = 1000, Pro48 = 1000
WHERE (Pro01 = 5000) AND (Pro02 = 5000) AND (Pro03 = 5000) AND (Pro04 = 5000) AND
      (Pro05 = 5000) AND (Pro06 = 5000) AND (Pro08 = 5000) AND (Pro07 = 5000) AND
      (Pro10 = 5000) AND (Pro09 = 5000) AND (Pro11 = 5000) AND (Pro12 = 5000) AND
      (Pro13 = 5000) AND (Pro14 = 5000) AND (Pro15 = 5000) AND (Pro16 = 5000) AND
      (Pro17 = 5000) AND (Pro18 = 5000) AND (Pro19 = 5000) AND (Pro20 = 5000) AND
      (Pro21 = 5000) AND (Pro22 = 5000) AND (Pro23 = 5000) AND (Pro24 = 5000) AND
      (Pro25 = 5000) AND (Pro27 = 5000) AND (Pro26 = 5000) AND (Pro28 = 5000) AND
      (Pro29 = 5000) AND (Pro30 = 5000) AND (Pro31 = 5000) AND (Pro32 = 5000) AND
      (Pro33 = 5000) AND (Pro34 = 5000) AND (Pro35 = 5000) AND (Pro36 = 5000) AND
      (Pro37 = 5000) AND (Pro38 = 5000) AND (Pro39 = 5000) AND (Pro40 = 5000) AND
      (Pro41 = 5000) AND (Pro42 = 5000) AND (Pro43 = 5000) AND (Pro44 = 5000) AND
      (Pro45 = 5000) AND (Pro46 = 5000) AND (Pro47 = 5000) AND (Pro48 = 5000)

UPDATE NpcDropItemParams2 SET Pro01=0 WHERE ItemId01=0
UPDATE NpcDropItemParams2 SET Pro02=0 WHERE ItemId02=0
UPDATE NpcDropItemParams2 SET Pro03=0 WHERE ItemId03=0
UPDATE NpcDropItemParams2 SET Pro04=0 WHERE ItemId04=0
UPDATE NpcDropItemParams2 SET Pro05=0 WHERE ItemId05=0
UPDATE NpcDropItemParams2 SET Pro06=0 WHERE ItemId06=0
UPDATE NpcDropItemParams2 SET Pro07=0 WHERE ItemId07=0
UPDATE NpcDropItemParams2 SET Pro08=0 WHERE ItemId08=0
UPDATE NpcDropItemParams2 SET Pro09=0 WHERE ItemId09=0
UPDATE NpcDropItemParams2 SET Pro10=0 WHERE ItemId10=0
UPDATE NpcDropItemParams2 SET Pro11=0 WHERE ItemId11=0
UPDATE NpcDropItemParams2 SET Pro12=0 WHERE ItemId12=0
UPDATE NpcDropItemParams2 SET Pro13=0 WHERE ItemId13=0
UPDATE NpcDropItemParams2 SET Pro14=0 WHERE ItemId14=0
UPDATE NpcDropItemParams2 SET Pro15=0 WHERE ItemId15=0
UPDATE NpcDropItemParams2 SET Pro16=0 WHERE ItemId16=0
UPDATE NpcDropItemParams2 SET Pro17=0 WHERE ItemId17=0
UPDATE NpcDropItemParams2 SET Pro18=0 WHERE ItemId18=0
UPDATE NpcDropItemParams2 SET Pro19=0 WHERE ItemId19=0
UPDATE NpcDropItemParams2 SET Pro20=0 WHERE ItemId20=0
UPDATE NpcDropItemParams2 SET Pro21=0 WHERE ItemId21=0
UPDATE NpcDropItemParams2 SET Pro22=0 WHERE ItemId22=0
UPDATE NpcDropItemParams2 SET Pro23=0 WHERE ItemId23=0
UPDATE NpcDropItemParams2 SET Pro24=0 WHERE ItemId24=0
UPDATE NpcDropItemParams2 SET Pro25=0 WHERE ItemId25=0
UPDATE NpcDropItemParams2 SET Pro26=0 WHERE ItemId26=0
UPDATE NpcDropItemParams2 SET Pro27=0 WHERE ItemId27=0
UPDATE NpcDropItemParams2 SET Pro28=0 WHERE ItemId28=0
UPDATE NpcDropItemParams2 SET Pro29=0 WHERE ItemId29=0
UPDATE NpcDropItemParams2 SET Pro30=0 WHERE ItemId30=0
UPDATE NpcDropItemParams2 SET Pro31=0 WHERE ItemId31=0
UPDATE NpcDropItemParams2 SET Pro32=0 WHERE ItemId32=0
UPDATE NpcDropItemParams2 SET Pro33=0 WHERE ItemId33=0
UPDATE NpcDropItemParams2 SET Pro34=0 WHERE ItemId34=0
UPDATE NpcDropItemParams2 SET Pro35=0 WHERE ItemId35=0
UPDATE NpcDropItemParams2 SET Pro36=0 WHERE ItemId36=0
UPDATE NpcDropItemParams2 SET Pro37=0 WHERE ItemId37=0
UPDATE NpcDropItemParams2 SET Pro38=0 WHERE ItemId38=0
UPDATE NpcDropItemParams2 SET Pro39=0 WHERE ItemId39=0
UPDATE NpcDropItemParams2 SET Pro40=0 WHERE ItemId40=0
UPDATE NpcDropItemParams2 SET Pro41=0 WHERE ItemId41=0
UPDATE NpcDropItemParams2 SET Pro42=0 WHERE ItemId42=0
UPDATE NpcDropItemParams2 SET Pro43=0 WHERE ItemId43=0
UPDATE NpcDropItemParams2 SET Pro44=0 WHERE ItemId44=0
UPDATE NpcDropItemParams2 SET Pro45=0 WHERE ItemId45=0
UPDATE NpcDropItemParams2 SET Pro46=0 WHERE ItemId46=0
UPDATE NpcDropItemParams2 SET Pro47=0 WHERE ItemId47=0
UPDATE NpcDropItemParams2 SET Pro48=0 WHERE ItemId48=0

人物增加技能

set identity_insert SkillList ON
INSERT INTO SkillList(Seq, AliasSeq,SkillId,SkillLevel,SkillExp)
Values(7368, 1730, 3073, 1, 0)
set identity_insert SkillList OFF

关于高级SQL版本登陆账号错误解决方法​

增加武器​

108 武器​

修改经验​

修改爆率​

人物增加技能​