雪皓松松 发表于 2012-5-25 13:28:55

AI程序有关的问题

在服务端下,AI程序是关联数据库哪些表和存储过程,求解答。

wyxklm 发表于 2012-5-27 00:07:05

自己开分析器就能看到了。这有几个你看看:
SELECT ServerNo, ZoneNo FROM ZONE_INFO2
go
SELECT MagicNum, Moral, SkillLevel, Skill, Msp, HP, ItemGroup, UseItem, CastTime, ReCastTime, SuccessRate, Type1, Type2, Range, Etc FROM MAGIC
go
SELECT iNum, Type, Delay, COmboCount, ComboType, Hit, HitRate, Range, AddDamage, ComboDamage FROM MAGIC_TYPE1
go
SELECT iNum, HitType, HitRate, AddDamage, AddRange, NeedArrow, AddDamagePlus FROM MAGIC_TYPE2
go
SELECT iNum, Attribute, DirectType, Angle, Duration, EndDamage, FirstDamage, TimeDamage, Radius FROM MAGIC_TYPE3
go
SELECT iNum, BuffType, Radius, Duration, AttackSpeed, Speed, AC, Attack, MagicAttack, MaxHP, HitRate, AvoidRate, Str, Sta, Dex, Intel, Cha, FireR, ColdR, LightningR, MagicR, DiseaseR, PoisonR, MaxHPPct, ACPct, MaxMP, MaxMPPct, ExpPct FROM MAGIC_TYPE4
go
SELECT nIndex, byValidGroup, byNatoinChange, shMonsterNum, shHitrate, byRadius, shDuration, nNeedItem, byTargetChange, byStateChange, byVisoin, shDamage FROM MAGIC_TYPE7
go
SELECT level, Exp FROM LEVEL_UP
go
SELECT sIndex, iItem01, sPersent01, iItem02, sPersent02, iItem03, sPersent03, iItem04, sPersent04, iItem05, sPersent05 FROM K_MONSTER_ITEM
go
SELECT iItemGroupNum, iItem_1, iItem_2, iItem_3, iItem_4, iItem_5, iItem_6, iItem_7, iItem_8, iItem_9, iItem_10, iItem_11, iItem_12, iItem_13, iItem_14, iItem_15, iItem_16, iItem_17, iItem_18, iItem_19, iItem_20, iItem_21, iItem_22, iItem_23, iItem_24, iItem_25, iItem_26, iItem_27, iItem_28, iItem_29, iItem_30 FROM MAKE_ITEM_GROUP
go
SELECT byLevelGrade, sUpgradeItem, sMagicItem, sGereralItem FROM MAKE_ITEM_LARECODE
go
SELECT byItemIndex, byGrade_1, byGrade_2, byGrade_3, byGrade_4, byGrade_5, byGrade_6, byGrade_7, byGrade_8, byGrade_9 FROM MAKE_ITEM_GRADECODE
go
SELECT byLevel, sClass_1, sClass_2, sClass_3, sClass_4, sClass_5, sClass_6, sClass_7 FROM MAKE_DEFENSIVE
go
SELECT byLevel, sClass_1, sClass_2, sClass_3, sClass_4, sClass_5, sClass_6, sClass_7, sClass_8, sClass_9, sClass_10, sClass_11, sClass_12 FROM MAKE_WEAPON
go
SELECT sSid, strName, sPid, sSize, iWeapon1, iWeapon2, byGroup, byActType, byRank, byTitle, iSellingGroup, sLevel, iExp, iLoyalty, iHpPoint, sMpPoint, sAtk, sAc, sHitRate, sEvadeRate, sDamage, sAttackDelay, bySpeed1, bySpeed2, sStandtime, iMagic1, iMagic2, iMagic3, sFireR, sColdR, sLightningR, sMagicR, sDiseaseR, sPoisonR, sLightR, sBulk, bySearchRange, byAttackRange, byTracingRange, byType, byFamily, iMoney, sItem, byDirectAttack, byMagicAttack FROM K_MONSTER
go

雪皓松松 发表于 2012-5-27 11:40:37

wyxklm 发表于 2012-5-27 00:07 static/image/common/back.gif
自己开分析器就能看到了。这有几个你看看:
SELECT ServerNo, ZoneNo FROM ZONE_INFO2
go


{:1_209:}多谢,数据库表中ZONE_INFO和ZONE_INFO2这两个表有什么不同?之间有联系吗?为什么我删掉ZONE_INFO2表,服务端也能正常启动,是不是只要ZONE_INFO这个表就好了?

ctgwglzc 发表于 2012-5-27 12:09:37

雪皓松松 发表于 2012-5-27 11:40 static/image/common/back.gif
多谢,数据库表中ZONE_INFO和ZONE_INFO2这两个表有什么不同?之间有联系吗?为什么我删掉ZONE_I ...

一直都是改zone_info,info2冒似是没啥用

雪皓松松 发表于 2012-5-27 12:23:15

ctgwglzc 发表于 2012-5-27 12:09 static/image/common/back.gif
一直都是改zone_info,info2冒似是没啥用

多谢CT,那查看AI的分析器在哪里下载..我不知道是哪个软件。

wyxklm 发表于 2012-5-27 18:09:41

sql的分析器/查询分析器用SQL都有的!
页: [1]
查看完整版本: AI程序有关的问题