搜索
 找回密码
 加入

AI程序有关的问题

雪皓松松 2012-5-27 18:09:41 2040
在服务端下,AI程序是关联数据库哪些表和存储过程,求解答。
随机推荐

5 回复

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

评分

1

查看全部评分

雪皓松松
2012-5-27 11:40:37
楼主
wyxklm 发表于 2012-5-27 00:07
自己开分析器就能看到了。这有几个你看看:
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
多谢,数据库表中ZONE_INFO和ZONE_INFO2这两个表有什么不同?之间有联系吗?为什么我删掉ZONE_I ...


一直都是改zone_info,info2冒似是没啥用
雪皓松松
2012-5-27 12:23:15
楼主
ctgwglzc 发表于 2012-5-27 12:09
一直都是改zone_info,info2冒似是没啥用

多谢CT,那查看AI的分析器在哪里下载..我不知道是哪个软件。
wyxklm
2012-5-27 18:09:41
sql的分析器/查询分析器用SQL都有的!
ctgwglzc
2012-5-28 13:00
对哦。查询分析器是sql企业管理器内置的功能之一 
高级模式
游客