fe表NGMdisable NGMlocal貌似关系二次登录喵
/*boss显血*/
UPDATE QuestDifficultyInfo set showbosshp=1;
/*疲劳为0*/
UPDATE QuestInfo set fatiguepointCount=0;
/* 修复海基任务 */
update StoryLineInfo set classrestriction= '1023' where classrestriction='511';
/*副本收益*/
UPDATE QuestGoalInfo set gold=gold*5, minap=minap*2 ,maxap=maxap*2;
UPDATE QuestGoalInfo set xp =10 where xp=0;
/*副本無限制*/
UPDATE QuestInfo set MaxPlayCount=null;
UPDATE QuestPeriodInfo set MaxPlayCount=null;
/*宠物有效时间*/
UPDATE PetInfo set maxactivetime = 31536000;
/*附魔成功率*/
UPDATE EnchantInfo set minsuccessratio = 50 where minsuccessratio<50;
UPDATE EnchantInfo set maxsuccessratio = 75 where maxsuccessratio<75;
/*角色栏*/
UPDATE "main"."FeatureMatrix" SET "ZH-TW"=10, "ZH-TW-X-GM"=10 WHERE "Feature"='MaxCharacterSlot';
UPDATE "main"."FeatureMatrix" SET "ZH-TW"=12, "ZH-TW-X-GM"=12 WHERE "Feature"='MaxCharacterSlotWithPurchase';
UPDATE "main"."FeatureMatrix" SET "ZH-TW"=null, "ZH-TW-X-GM"=null WHERE "Feature"='Solo_Mode';
UPDATE "main"."FeatureMatrix" SET "ZH-TW"=1, "ZH-TW-X-GM"=1 WHERE "Feature"='PurchaseSlot';
/*二次登录*/
UPDATE "main"."FeatureMatrix" SET "ZH-TW"=1, "ZH-TW-X-GM"=1 WHERE "Feature"='NGM_disable';
/*商店*/
UPDATE "main"."FeatureMatrix" SET "ZH-TW"=NULL, "ZH-TW-X-GM"=NULL WHERE "Feature"='CashShop';
/* 盖联商店修复 */
UPDATE "main"."ShopInfo" SET "Feature"=NULL WHERE "ShopID"='GERENS1_Shop';
/*设置商城价格为0*/
UPDATE "main"."CustomizePriceInfo" SET "price"=0;
/*物品快捷栏叠加上限提升9999*/
update "MAIN"."ItemClassInfo" set "QuickSlotMaxStack"=9999 where "QuickSlotMaxStack" > 0 and "QuickSlotMaxStack" < 9999;
/*物品叠加上限提升9999*/
update "MAIN"."ItemClassInfo" set "MaxStack"=9999 where "MaxStack" > 1 and "MaxStack" < 9999;
/*+15卷轴+5星卷轴 此处将这两个道具改为单格叠加上限9999，使用期限更改为无限期*/
update "MAIN"."ItemClassInfo" set "MaxStack"=9999,"ExpireIn"=NULL WHERE "ItemClass"='coupon_ferghus_update' or "ItemClass"='quality_plus_coupon';
/*24人本开船组队 一条是开启，一条是还原*/
update questinfo set questset =1, disableusership='False', EnableUserDSMode='False' where id in ('quest_dragon_ancient_siglint','quest_dragon_ancient_bugeikloth','quest_dragon_ancient_elculous','quest_giant_spider_all','quest_bear_giant');
update questinfo set questset =2000, disableusership='True', EnableUserDSMode='True' where id in ('quest_dragon_ancient_siglint','quest_dragon_ancient_bugeikloth','quest_dragon_ancient_elculous','quest_giant_spider_all','quest_bear_giant');
/* 修复海基，戴丽雅任务 */
update StoryLineInfo set classrestriction= '2047' where classrestriction='511' or classrestriction='1023';
/* 修复海基，戴丽雅物品 */
update ItemClassInfo set classrestriction= '2047' where classrestriction='511' or classrestriction='1023';
/* 修复海基创建 */
update ItemClassInfo set ItemClass = 'hagie_noluck_inner_free' where ItemClass ='hagie_noluck_inner_armor';
update EquipItemInfo set ItemClass = 'hagie_noluck_inner_free' where ItemClass ='hagie_noluck_inner_armor';
update CustomizeDefaultInfo set ItemClass = 'hagie_noluck_inner_free' where ItemClass ='hagie_noluck_inner_armor';
update CustomizePriceInfo set ItemClass = 'hagie_noluck_inner_free' where ItemClass ='hagie_noluck_inner_armor';
update CustomizeItemInfo set ItemClass = 'hagie_noluck_inner_free' where ItemClass ='hagie_noluck_inner_armor';
/*创建角色*/
update "main"."FeatureMatrix" SET "ZH-TW"='1', "ZH-TW-X-GM"='1' WHERE "Feature"='S3_CharacterCreation';
update featurematrix set "zh-TW"=NULL,"zh-TW-X-GM"=NULL where feature ='CharacterTransferSystem';
StatusEffectGroupInfo客户端需要添加键值combatcount
StoryLineInfo 任务xml调用表
+15卷轴+5星卷轴
coupon_ferghus_update[VALUE:15]
quality_plus_coupon[VALUE:5]
等级跳跃药水90
level_jumping_potion[VALUE:90]
新时装代码 然并卵喵。
randomitem_avatar_female_necromancer
角色物品表替换
SELECT * from Costume where CID = 636083339721311668
/*压缩数据库*/
VACUUM;
avatar_female_reine_lower_jajp eq_datealive03_jpn_female_lower AVATAR_PANTS AVATAR AVATAR_PANTS EQUIPMENT cloth 600.01 2 1 0 0 0 0 1 1 1 0 0 1446 0 0 1 0 0 0 Disable Disable DEFAULT female_reine_lower
avatar_female_reine_upper_jajp eq_datealive03_jpn_female_upper AVATAR_TUNIC AVATAR AVATAR_TUNIC EQUIPMENT cloth 600.01 2 1 0 0 0 0 1 1 1 0 0 1446 0 0 1 0 0 0 Disable Disable DEFAULT female_reine_upper
avatar_female_reine_foot_jajp eq_datealive03_jpn_foot
avatar_female_reine_head_jajp
female_reine_foot eq_datealive03_jpn_foot BOOTS CLOTH CLOTH_GLOVES EQUIPMENT cloth 200.02 1 1 0 0 1000 0 1 1 1 0
female_reine_head eq_datealive03_jpn_head HELM CLOTH CLOTH_HELM EQUIPMENT cloth 200.03 1 1 0 0 1000 0 1 1 1 0
female_reine_lower eq_datealive03_jpn_female_lower PANTS CLOTH CLOTH_PANTS EQUIPMENT cloth 200.04 1 1 0 0 1000 0 1 1 1 0
female_reine_upper eq_datealive03_jpn_female_upper TUNIC CLOTH CLOTH_TUNIC EQUIPMENT cloth 200.05 1 1 0 0 1000 0 1 1 1 0
datealive
添加约会大作战眼镜
avatar_female_reine_head_jajp
INSERT INTO "main"."EquipItemInfo" VALUES ('avatar_female_reine_head_jajp', 'AVATAR', '600', '0', '1000', '1', 'innerarmor', 'innerarmor', 'innerarmor', 0, 0, 0, 0, 0, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0.0, null, null, 0, 0, 1, null);
INSERT INTO "main"."ItemClassInfo" VALUES ('avatar_female_reine_head_jajp', 'eq_datealive03_jpn_head', null, 'AVATAR_HELM', 'AVATAR', 'AVATAR_HELM', 'EQUIPMENT', 'cloth', 600.01, 2, 1, 0, 0, 0, 0, null, 4, 1, 1, 0, null, 0, 1446, 0, 0, 1, 0, 0, 0, 'Disable', 'Disable', 'CASH', null, 'female_reine_head', 0, 0, null);
/*添加两个翅膀*/
INSERT INTO "main"."ItemClassInfo" VALUES ('glas_black_wing_rear', 'eq_whitewing_upper', null, 'REAR', 'REAR', 'REAR_WING', 'EQUIPMENT', 'cloth', 180.01, 1, 1, 0, 0, 0, 0, null, 5, 1, 1, 0, null, 0, 1023, 0, 0, 0, 3, 0, 0, 'Disable', 'Disable', null, 'UseRearSlot', null, 0, 0, null);
INSERT INTO "main"."ItemClassInfo" VALUES ('glas_white_wing_rear', 'eq_whitewing_upper', null, 'REAR', 'REAR', 'REAR_WING', 'EQUIPMENT', 'cloth', 180.01, 1, 1, 0, 0, 0, 0, null, 5, 1, 1, 0, null, 0, 1023, 0, 0, 0, 3, 0, 0, 'Disable', 'Disable', null, 'UseRearSlot', null, 0, 0, null);
INSERT INTO "main"."EquipItemInfo" VALUES ('glas_black_wing_rear', 'WING', 11535, 10000, -1, 1, 'metal_dark', 'metal_dark', 'metal_dark', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.0, null, null, 0, 0, 0, 'UseRearSlot');
INSERT INTO "main"."EquipItemInfo" VALUES ('glas_white_wing_rear', 'WING', 11536, 10000, -1, 1, 'white', 'white', 'white', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.0, null, null, 0, 0, 0, 'UseRearSlot');
AVATAR_HELM
/*ItemClassInfo*/
INSERT INTO "main"."ItemClassInfo" VALUES ('avatar_female_bunny_suit_general_foot', 'eq_pc_female_bunny_suit_foot', null, 'AVATAR_BOOTS', 'AVATAR', 'AVATAR_BOOTS', 'EQUIPMENT', 'cloth', 600.01, 2, 1, 0, 0, 0, 0, null, 4, 1, 1, 0, null, 0, 1446, 0, 0, 1, 0, 0, 0, 'Disable', 'Disable', 'CASH', null, 'female_bunny_suit_foot', 0, 0, null);
/*EquipItemInfo*/
INSERT INTO "main"."EquipItemInfo" VALUES ('avatar_female_bunny_suit_general_foot', 'AVATAR', '600', '0', '1000', '1', 'innerarmor', 'innerarmor', 'innerarmor', 0, 0, 0, 0, 0, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0.0, null, null, 0, 0, 1, null);
冰雪公主
avatar_frozen_general_female_foot
avatar_frozen_general_female_hand
avatar_frozen_general_female_head
avatar_frozen_general_female_lower
avatar_frozen_general_female_upper
诅神
avatar_female_necromancer_foot_general
avatar_female_necromancer_foot_rare
avatar_female_necromancer_hand_general
avatar_female_necromancer_hand_rare
avatar_female_necromancer_head_general
avatar_female_necromancer_head_rare
avatar_female_necromancer_lower_general
avatar_female_necromancer_lower_rare
avatar_female_necromancer_upper_general
avatar_female_necromancer_upper_rare
avatar_male_necromancer_foot_general
avatar_male_necromancer_foot_rare
avatar_male_necromancer_hand_general
avatar_male_necromancer_hand_rare
avatar_male_necromancer_head_general
avatar_male_necromancer_head_rare
avatar_male_necromancer_lower_general
avatar_male_necromancer_lower_rare
avatar_male_necromancer_upper_general
avatar_male_necromancer_upper_rare
东方的巫女
avatar_female_fox_foot_jajp
avatar_female_fox_foot_jajp_rare
avatar_female_fox_foot_rare
avatar_female_fox_foot_rare
avatar_female_fox_hand_jajp
avatar_female_fox_hand_jajp_rare
avatar_female_fox_hand_rare
avatar_female_fox_hand_rare
avatar_female_fox_head_jajp
avatar_female_fox_head_jajp_rare
avatar_female_fox_head_rare
avatar_female_fox_head_rare
avatar_female_fox_lower_jajp
avatar_female_fox_lower_jajp_rare
avatar_female_fox_lower_rare
avatar_female_fox_lower_rare
avatar_female_fox_rare_foot
avatar_female_fox_rare_hand
avatar_female_fox_rare_head
avatar_female_fox_rare_lower
avatar_female_fox_rare_upper
avatar_female_fox_upper_jajp
avatar_female_fox_upper_jajp_rare
avatar_female_fox_upper_rare
avatar_female_fox_upper_rare
约会大作战十香cos(发型不错)
avatar_female_tohka_foot_jajp
avatar_female_tohka_hand_jajp
avatar_female_tohka_head_jajp
avatar_female_tohka_upper_jajp
新加时装喵
avatar_female_necromancer_foot_rare
avatar_female_necromancer_hand_rare
avatar_female_necromancer_head_rare
avatar_female_necromancer_lower_rare
avatar_female_necromancer_upper_rare
avatar_frozen_general_female_foot
avatar_frozen_general_female_hand
avatar_frozen_general_female_head
avatar_frozen_general_female_lower
avatar_frozen_general_female_upper
avatar_female_fox_foot_rare
avatar_female_fox_hand_rare
avatar_female_fox_head_rare
avatar_female_fox_lower_rare
avatar_female_fox_upper_rare
avatar_female_tohka_foot_jajp
avatar_female_tohka_hand_jajp
avatar_female_tohka_head_jajp
avatar_female_tohka_upper_jajp
avatar_female_reine_head_jajp
avatar_frozen_general_female_foot
avatar_frozen_general_female_hand
avatar_frozen_general_female_head
avatar_frozen_general_female_lower
avatar_frozen_general_female_upper
avatar_female_kibelius_general_upper
avatar_female_kibelius_general_lower
avatar_female_kibelius_general_head
avatar_female_kibelius_general_hand
avatar_female_kibelius_general_foot
avatar_bunny_rare_female_foot
avatar_bunny_rare_female_hand
avatar_bunny_rare_female_head
avatar_bunny_rare_female_lower
avatar_bunny_rare_female_upper
glas_white_wing_rear
glas_black_wing_rear
fe表
advanceduiui界面设置
PunishWhiteListSetForLevelJumping_disable 跳級白名單
PurchaseSlot 購買槽
Solo_Mode 是否單機運行
NewCharacterDialog_V4_Summary
UserCareSystem
randomitem_avatar_frozen_general_female 自添加冰雪公主套
再CustomizeItemInfo CustomizeItemInfo两表中添加国服或者台服的以下相关记录
randomitem_avatar_frozen_general_female
avatar_frozen_general_female_head
avatar_frozen_general_female_upper
avatar_frozen_general_female_lower
avatar_frozen_general_female_hand
avatar_frozen_general_female_foot
从customizeiteminfo里找到时装代码然后修改randomitem
（随便选一套时装改名最先面的id要是全表独立的 不然客户端跳出给你看）
randomitemrecipeclass randomitemrecipe三张表
customizeiteminfo表 加入沙龙的时装结构
AVATAR_PACKAGE 304 randomitem_avatar_frozen_general_female 1 True False HEROES_ITEM_NAME_randomitem_avatar_frozen_general_female zh-TW AvatarBeauty
AVATAR_HELM 305 avatar_frozen_general_female_head 1 True False HEROES_ITEM_NAME_avatar_frozen_general_female_head zh-TW AvatarBeauty
AVATAR_TUNIC 306 avatar_frozen_general_female_upper 1 True False HEROES_ITEM_NAME_avatar_frozen_general_female_upper zh-TW AvatarBeauty
AVATAR_PANTS 307 avatar_f False HEROES_ITEM_NAME_avatar_frozen_general_female_lower zh-TW AvatarBeauty
AVATAR_GLOVES 308 avatar_frozen_general_female_hand 1 Truerozen_general_female_lower 1 True False HEROES_ITEM_NAME_avatar_frozen_general_female_hand zh-TW AvatarBeauty
AVATAR_BOOTS 309 avatar_frozen_general_female_foot 1 True False HEROES_ITEM_NAME_avatar_frozen_general_female_foot zh-TW AvatarBeauty
customizepriceinfo表 加入沙龙的时装结构
avatar_frozen_general_female_foot -1 0 zh-TW AvatarBeauty
avatar_frozen_general_female_hand -1 0 zh-TW AvatarBeauty
avatar_frozen_general_female_head -1 0 zh-TW AvatarBeauty
avatar_frozen_general_female_lower -1 0 zh-TW AvatarBeauty
avatar_frozen_general_female_upper -1 0 zh-TW AvatarBeauty
randomitem_avatar_frozen_general_female -1 0 zh-TW AvatarBeauty
/*补全时装信息*/
INSERT INTO "main"."CustomizeItemInfo" VALUES ('AVATAR_PACKAGE', 'orderID', 'randomitem_套装箱子id', 1, 'TRUE', 'FALSE', 'HEROES_ITEM_NAME_randomitem_套装箱子id', 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizeItemInfo" VALUES ('AVATAR_HELM', 'orderID', 'head', 1, 'TRUE', 'FALSE', 'HEROES_ITEM_NAME_head', 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizeItemInfo" VALUES ('AVATAR_TUNIC', 'orderID', 'upper', 1, 'TRUE', 'FALSE', 'HEROES_ITEM_NAME_upper', 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizeItemInfo" VALUES ('AVATAR_PANTS', 'orderID', 'lower', 1, 'TRUE', 'FALSE', 'HEROES_ITEM_NAME_lower', 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizeItemInfo" VALUES ('AVATAR_GLOVES', 'orderID', 'hand', 1, 'TRUE', 'FALSE', 'HEROES_ITEM_NAME_hand', 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizeItemInfo" VALUES ('AVATAR_BOOTS', 'orderID', 'foot', 1, 'TRUE', 'FALSE', 'HEROES_ITEM_NAME_foot', 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizePriceInfo" VALUES ('randomitem_套装箱子id', -1, 0, 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizePriceInfo" VALUES ('head', -1, 0, 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizePriceInfo" VALUES ('upper', -1, 0, 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizePriceInfo" VALUES ('lower', -1, 0, 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizePriceInfo" VALUES ('hand', -1, 0, 'zh-TW', 'AvatarBeauty');
INSERT INTO "main"."CustomizePriceInfo" VALUES ('foot', -1, 0, 'zh-TW', 'AvatarBeauty');
/*添加时装包或者道具包(客户端不需要执行*/
INSERT INTO "main"."RandomItem" VALUES ('套装箱子编号', NULL, NULL, 'randomitem_套装箱子id', NULL, 1, NULL, NULL, 0, 0, -1, -1);
INSERT INTO "main"."RandomItemRecipeClass" VALUES ('套装箱子编号', 'randomitem_套装箱子id', NULL, 1, 时装数量, null);
INSERT INTO "main"."RandomItemRecipe" VALUES ('套装箱子编号', 'randomitem_套装箱子id', NULL, 'foot', 1, 0.5, 'FFFFFF', 'FFFFFF', 'FFFFFF', 0, 0, 0, 0, NULL);
INSERT INTO "main"."RandomItemRecipe" VALUES ('套装箱子编号', 'randomitem_套装箱子id', NULL, 'hand', 1, 0.5, 'FFFFFF', 'FFFFFF', 'FFFFFF', 0, 0, 0, 0, NULL);
INSERT INTO "main"."RandomItemRecipe" VALUES ('套装箱子编号', 'randomitem_套装箱子id', NULL, 'head', 1, 0.5, 'FFFFFF', 'FFFFFF', 'FFFFFF', 0, 0, 0, 0, NULL);
INSERT INTO "main"."RandomItemRecipe" VALUES ('套装箱子编号', 'randomitem_套装箱子id', NULL, 'lower', 1, 0.5, 'FFFFFF', 'FFFFFF', 'FFFFFF', 0, 0, 0, 0, NULL);
INSERT INTO "main"."RandomItemRecipe" VALUES ('套装箱子编号', 'randomitem_套装箱子id', NULL, 'upper', 1, 0.5, 'FFFFFF', 'FFFFFF', 'FFFFFF', 0, 0, 0, 0, NULL);
镜湖单人开门
Go to "EntityAttribute" Table
Search "1408771" in "EntityId"
Set value "1" in "StartDisabled" string
trig_ghostwall
targetname trig_ghostwall
1411074 雷龙开门 1411072 设置为0
1408518 蜘蛛开门
1411586 1411588 冰龙开门 开船直接打
1408518 classname trigger_once
1408518 targetname trig_ghostwall
1408518 StartDisabled 0
红龙1408256 1408002 1408003 开场被关门打狗喵
1407999
关于副本多boss
QuestInfo拿到副本id 用副本id去Sectors表里找对应的Sectorid
sectorid去Entity表里找SectorID对应的ID此id对应EntityAttribute表中的EntityID
再该表中
classname trigger_once
targetname trigger_boss
StartDisabled 1
OnStartTouch npc_template_maker_3,Enable,0,0,-1
OnStartTouch command_server,command,cc_ds_start_quest_timer,0,-1
classname npc_template_maker
targetname npc_template_maker_3
StartDisabled 1
TemplateName npc_bear ds_giant
DestinationGroup spawn_point_room_1_boss
MaxNPCCount 1
MaxLiveChildren 1
SpawnFrequency 0.8
SpawnElite 0
DropItem 3
这类就是对应的boss诞生触发其中MaxNPCCount 1 MaxLiveChildren 1这两条是管最大诞生数量的
SpawnFrequency 0.8是刷新频率
其他条目待研究
PurchaseSlot 購買槽
Solo_Mode 是否單機運行
INSERT INTO "main"."QuestPeriodInfo" VALUES ('quest_s3_ep4_woodenelf_free_battle', '2010-07-21 01:00:00.000', 24, null, 'zhTW', 357);
fiona_inner_swimsuit1
fiona_inner_swimsuit2
fiona_inner_swimsuit3
arisha_inner_swimsuit1
arisha_inner_swimsuit2
arisha_inner_swimsuit3
fiona_inner_armor03
