新江湖OL装备数据库修改参数课案.docx
《新江湖OL装备数据库修改参数课案.docx》由会员分享,可在线阅读,更多相关《新江湖OL装备数据库修改参数课案.docx(15页珍藏版)》请在冰豆网上搜索。
![新江湖OL装备数据库修改参数课案.docx](https://file1.bdocx.com/fileroot1/2022-11/28/25d189c4-37b0-47b9-8e11-e3097782dca9/25d189c4-37b0-47b9-8e11-e3097782dca91.gif)
新江湖OL装备数据库修改参数课案
天下英雄出我辈,一入江湖岁月催。
鸿图霸业谈笑中,不胜人生一场醉。
提剑跨骑挥鬼雨,白骨如山鸟惊飞。
尘世如潮人如水,只叹江湖几人回。
新江湖OL增加帐号及GM管理权限步骤:
1、开始菜单--所有程序--MicrosoftSQLServer--企业管理器(打开)。
2、控制台根目录--MicrosoftSQLServers--SQLServer组--(Local)(WindowsNT)--数据库--ACCOUNT--表(右边)--MemberInfo(右键)--打开表--返回所有行。
3、uID为用户名,uPassword为加密型密码
(默认密码:
E10ADC3949BA59ABBE56E057F20F883E,即123456)
uTCASH为商城金钱,最高数值:
999999999
修改等级,装备及其他参数步骤:
1、开始菜单--所有程序--MicrosoftSQLServer--企业管理器(打开)。
2、控制台根目录--MicrosoftSQLServers--SQLServer组--(Local)(WindowsNT)--数据库--GAME01--表(右边)--AvatarInfo(右键)--打开表--查询。
在AvatarInfo对话框中,选择uID,在条件选项中输入帐号后(右键--运行)。
uID为帐号;
aUpgradeValue1/aUpgradeValue2/aUpgradeValue3/uUseLuckItem2可修改至999999999;
aNewWorldExitTime为超境界时间;
aDoubleDrugExpT/aDoubleDrugExpTime2/aProtectForDeath/aProtectForDestroy可修改至999999999;
aUseExpandStoreDate1/aUseExpandStoreDate1为扩展背包和仓库时间,示例:
22221212为2222年12月12日过期;
aLevel等级/aGeneralExperience经验/aSkillPoint资质/aHonor名誉/aStateBonusPoint剩余点数
1127290091525000500100
14520000000005000500100
+33满经验为:
2000000000
aVitality活力点数/aStrength力量点数/aKi内力点数/aWisdom敏捷点数
1000150010001000
aEatLifePotion血丹数量/aEatManaPotion魔丹数量/aChulgooTime铁口洞时间
20001000500000000
aPetExpPotion/aLuckyBox/aLuckyTime/aKiDoubleTime/aCriticalDoubleTime/
999999999999999
aGunSinBuTimes
999
最高数值:
999999999
aMoneyHONG背包金钱/aStoreMoneyHONG仓库金钱
21000000002100000000
最高数值:
210000000(21亿)
aStoreItem仓库第1页/aStoreItemValue强化数据1
输入装备代码输入强化组合代码
aStoreItem2仓库第2页/aStoreItemValue2强化数据2
输入装备代码输入强化组合代码
aGuildName帮会名称
苍穹天下
强化组合代码详解:
强化120%代码:
000000040(120÷3=40)
组合12代码:
000003072(256×12=3072)
强化120%组合12代码:
000003112(40+3072=3112)
具体算法:
(120÷3)+(256×12)=3112
绑定强满组满装备代码:
000068648
装备库调整代码:
200%天蝠+200%乌鸦+200%喜鹊+200%佛光+200%海马+200%金刚:
aStoreItem(仓库第1页):
99229096992671009926610099226100992271009922810000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
aStoreItemValue(强化数据):
240360000040037850040000000500000400240360000500000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
200%凤凰+200%蝴蝶+200%骷髅:
aStoreItem(仓库第1页):
99001100990001009899910000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
aStoreItemValue(强化数据):
040559742040051879040559742000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
武神套装(披风+戒指+三派神群):
aStoreItem(仓库第1页):
99217000991970009919850000000000992140009921400099214000000000009921500099215000992150000000000099216000992160009921600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
aStoreItemValue(强化数据):
000003112000003112000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
全套圣诞首饰(宝):
aStoreItem(仓库第1页):
99279000099280000
aStoreItemValue(强化数据):
000003112000003112
正派10级(宝)强化120%组12套装:
aStoreItem(仓库第1页):
102140001042400010004000106320001088400010758000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112
正派45级(明)强化120%组12套装:
aStoreItem(仓库第1页):
130********16000130310001304800013062000130780001309300013108000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派65级(明)强化120%组12套装:
aStoreItem(仓库第1页):
133********70000133790001311400013099000130840001306800013054000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派85级(明)强化120%组12套装:
aStoreItem(仓库第1页):
133********85000133670001306000013090000130740001312000013105000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派95级(明)强化120%组12套装:
aStoreItem(仓库第1页):
133********94000133880001313200013138000131340001314400013141000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派100级(神)强化120%组12套装:
aStoreItem(仓库第1页):
150********09000150010001501300015021000150170001503300015025000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派105级(明)强化120%组12套装:
aStoreItem(仓库第1页):
134********71000134170001324900013306000132760001336000013333000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派110级(神)强化120%组12套装:
aStoreItem(仓库第1页):
150********11000150030001501500015023000150190001503100015027000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派+3级(神)强化120%组12套装:
aStoreItem(仓库第1页):
151********59000151150001518100015225000152030001526900015247000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派+9级(神)强化120%组12套装:
aStoreItem(仓库第1页):
151********63000151190001518500015229000152070001527300015251000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派+11级(明)强化120%组12套装:
aStoreItem(仓库第1页):
6129500061298000612920006108200061085000610880006109100061094000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派+21级(神)强化120%组12套装:
aStoreItem(仓库第1页):
151********71000151270001519300015237000152150001528100015259000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派+26级(明)强化120%组12套装:
aStoreItem(仓库第1页):
6134000061343000613370006120200061205000612080006121100061214000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派+27级(神)强化120%组12套装:
aStoreItem(仓库第1页):
151********75000151310001519700015241000152190001528500015263000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派+33级(宝运)强化120%组12套装:
aStoreItem(仓库第1页):
8214200082144000821490008215000082154000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112
正派+33级(明)强化120%组12套装:
aStoreItem(仓库第1页):
8381500083818000838120008374900083752000837560008375800083761000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派+33级(神)强化120%组12套装:
aStoreItem(仓库第1页):
151********79000151350001520200015246000152230001528900015268000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
正派60级武技+通用武技:
aStoreItem(仓库第1页):
005480000054900000550000005510000054600000547000900270009002500090026000007080000071000000709000
邪派10级(宝)强化120%组12套装:
aStoreItem(仓库第1页):
300050003042500030215000306330003088500030758000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112
邪派45级(明)强化120%组12套装:
aStoreItem(仓库第1页):
3300100033031000330160003304800033078000330620003310800033093000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派65级(明)强化120%组12套装:
aStoreItem(仓库第1页):
3336100033379000333700003305400033084000330680003311400033099000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派85级(明)强化120%组12套装:
aStoreItem(仓库第1页):
3336700033385000333760003306000033074000330900003312000033105000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派95级(明)强化120%组12套装:
aStoreItem(仓库第1页):
3338800033394000333910003313200033138000331340003314400033141000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派100级(神)强化120%组12套装:
aStoreItem(仓库第1页):
3500100035009000350050003501300035021000350170003503300035025000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派105级(明)强化120%组12套装:
aStoreItem(仓库第1页):
3341700033471000334440003324900033300000332730003336000033327000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派110级(神)强化120%组12套装:
aStoreItem(仓库第1页):
3500300035011000350070003501500035023000350190003502900035027000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派+3级(神)强化120%组12套装:
aStoreItem(仓库第1页):
3511500035159000351370003518100035225000352030003526900035247000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派+9级(神)强化120%组12套装:
aStoreItem(仓库第1页):
3511900035163000351410003518500035229000352070003527300035251000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派+11级(明)强化120%组12套装:
aStoreItem(仓库第1页):
7129200071298000712950007108200071085000710880007109100071094000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派+21级(神)强化120%组12套装:
aStoreItem(仓库第1页):
3512700035171000351490003519300035237000352150003528100035259000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派+24级(神)强化120%组12套装:
aStoreItem(仓库第1页):
3504100035061000350510003507100035091000350810003511100035101000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派+26级(明)强化120%组12套装:
aStoreItem(仓库第1页):
7133700071343000713400007120200071205000712080007121100071214000
aStoreItemValue(强化数据):
000003112000003112000003112000003112000003112000003112000003112000003112
邪派+27级(神)强化120%组12套装:
aStoreItem(仓库第1页):
3513100035175000351530003519700035241000352190003528500035263000
aStoreItemValue(强化数据):
000003