j<dZddlmZddlZddlZddlmZmZmZm Z ddl m Z ddl m Z ddlmZddlmZdd lmZmZdd lmZdd lmZdd lmZmZdd lmZd/d0dZd1dZd2dZ d3dZ!d4d!Z"d5d$Z#d6d&Z$d7d.Z%dS)8z Game Design Matrix Seeder for FreeExile. Pulls canonical data from all game catalogs and populates the SQLite central matrix. Strictly decoupled from engine execution. ) annotationsN)AnyDictListOptional)get_canonical_acts) ZoneEngine)create_canonical_npcs)create_default_quest_engine)CORE_GENUS_SPECSSUB_SPECIES_CATALOG)get_base_weapon_catalog)create_standard_active_skills)CANONICAL_AFFIX_DEFINITIONSSTANDARD_ILVLS)calculate_piecewise_exp_curveFconnOptional[sqlite3.Connection]forceboolreturnDict[str, Any]c>|$ddlm}||S|}|s |dpdgd}|dpdgd}|dpdgd}|dkr|dkr |d krd d iSn#t j$rYnwxYwt|}| |S) u^Nạp dữ liệu hạt giống chuẩn có kiểm tra trạng thái bảng nếu force=False.Nr)GameDesignMatrixService)rzSELECT COUNT(*) FROM story_actsz+SELECT COUNT(*) FROM progression_benchmarksz)SELECT COUNT(*) FROM party_scaling_matrixdstatusalready_seeded) 'server.world.game_design_matrix_servicerseed_canonical_datacursorexecutefetchonesqlite3OperationalErrorseed_all_canonical_datacommit)rrrcurs_cntb_cntp_cntress ?C:\Projects\FreeExile\server\world\game_design_matrix_seeder.pyr r sB |SSSSSS&&((<<5<III ++--C  [[!BCCLLNNUSTRUWXYE[[!NOOXXZZa_`^acdeE[[!LMMVVXX_]^\_abcEqyyUc\\eqjj "233'    D 1$77CKKMMM JsB%C%%C76C7sqlite3.ConnectionDict[str, int]cFi}|}|ddD]}|d|t}|D]{\}}t |j\}}|d|jjt|jj|j |j |||j |j |j |jf |t||d<t!} | jD]t\} } t%| } |d| j| | j| jj| jj| j| jdz| j| j| j| jf ut| j|d<t9} | D]M}|d |j|j|j |jj|j|j|j |j!fNt| |d <d }tEjD]\}\}}}}}tGj$|g}|D]j\}}d |j%d |%}|d||j||d|d||||jdf |dz }k||d<tM}|j'D]\}}d}d}|j(r$|j(d j)}|j(d j*}|j+r |j+d nd}d|j,j-D} t]||j/}!|d|j0|j/|j |j1j|j2|!||||j,j3|j,j4|j,j tkj6| df t|j'|d<to}"|"D]\}#}$|d|$j8|$j9|$j:|$j;j|$j<j|$j=j|$j>j|$j?j|$j@j|$j2|$jA|$jB|$jC|$jDft|"|d<t}%|%D]\}&}'tkj6d|'jFDd}(|d|'jG|'jH|'j@j|'jIj|'jJj|'jK|'jL|'jM|'jNj|(f t|%|d<d })tD]v}*tkj6d|*jPD}+|d|*jQ|*jR|*jSj|*jT|*jU|*jV|*jW|*jX|+f |)dz })w|)|d <t},tdd!D]}-|,|-}.td"|-dz d#zzd}/td$d%|-dz zzd}0td&d'|-dz zzd}1td(d)|-dz zzd}2t|-}3|d*|-|.j]|.j^|.j_|/|0|1|2|3|.j`|.ja|.jb|.jcf d+|d,<t||| | |}4|4|d-<gd.}5|ed/|5t|5|d0<gd1}6|ed2|6t|6|d3<gd4}7|ed5|7t|7|d6<gd7}8|ed8|8t|8|d9<|S):uSNạp toàn bộ dữ liệu hạt giống từ các Catalog chuẩn vào Database.z.UPDATE quests SET prerequisite_quest_id = NULL)portal_quarantine_rulesteleport_configsloot_allocation_modesparty_scaling_matrixcross_relationshipsprogression_benchmarks affix_tiersskills weapon_basesquestsmonster_archetypesnpcszones story_actsz DELETE FROM z INSERT OR REPLACE INTO story_acts (act_id, act_order, title, subtitle, level_min, level_max, primary_zone_id, climax_boss_id, climax_boss_name, description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) r>z INSERT OR REPLACE INTO zones (zone_id, act_id, name, zone_type, environment, min_level, max_level, bounds_width, bounds_height, default_spawn_x, default_spawn_y) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) r=z INSERT OR REPLACE INTO npcs (npc_id, name, title, role, zone_id, x, y, dialogue_tree_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?) r<rmob__z INSERT OR REPLACE INTO monster_archetypes (archetype_id, genus, sub_species_code, name, base_hp, base_dmg, base_scale, native_element, min_level) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) z ()r;Nc8g|]}|j|j|jdS))item_idnamecount)rErFquantity).0rs r- z+seed_all_canonical_data..zs8    16AJ G G   aC INSERT OR REPLACE INTO quests (quest_id, act_id, title, quest_type, required_level, zone_id, prerequisite_quest_id, target_monster_id, target_count, reward_exp, reward_meridian_points, reward_title, reward_items_json) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) F) ensure_asciir:a5 INSERT OR REPLACE INTO weapon_bases (weapon_id, name_vi, name_en, weapon_class, weapon_category, grip_style, sect, clan, element, required_level, base_dmg_min, base_dmg_max, attack_speed, crit_chance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) r9cg|] }|j SrF)rIts r-rKz+seed_all_canonical_data..s666!qv666rLz INSERT OR REPLACE INTO skills (skill_id, skill_name, element, sect, weapon_requirement, base_damage, energy_cost, cooldown_ms, combo_role, tags_json) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) r8cg|] }|j SrOrP)rIslots r-rKz+seed_all_canonical_data..sJJJd JJJrLz INSERT OR REPLACE INTO affix_tiers (mod_id, name, affix_type, tier, required_ilvl, min_value, max_value, weight, allowed_slots_json) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) r7eY@g<@g4@gQ?gT@g?g(@gq= ףp?a INSERT OR REPLACE INTO progression_benchmarks (level, target_exp, exp_to_next_level, cumulative_exp, player_base_hp, player_benchmark_dps, monster_base_hp, monster_base_dps, max_affix_tier_allowed, death_penalty_ratio, level_gap_safe_range, level_gap_penalty_exp, monster_benchmark_exp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) rr6r5))rCg?rVrVrV.@z'Solo: Base 1.0x HP, +0% EXP/Loot/Rarity)g?>@I@rZrYrWz-Party 2: HP+50%, EXP+30%, Qty+50%, Rarity+30%)g@N@rUrUr\rWz/Party 3: HP+100%, EXP+60%, Qty+100%, Rarity+60%)g@V@b@r_r^rWz/Party 4: HP+150%, EXP+90%, Qty+150%, Rarity+90%)g@^@i@rbrarWz1Party 5: HP+200%, EXP+120%, Qty+200%, Rarity+120%)r @r_@o@rdr_rWz1Party 6: HP+250%, EXP+150%, Qty+250%, Rarity+150%zDINSERT OR REPLACE INTO party_scaling_matrix VALUES (?,?,?,?,?,?,?,?)r4)) PERMANENTzPermanent AllocationrVrCz(Permanent item lock for allocated player)SHORTzShort Allocationg@rz&5.0s temporary lock, then free for all) FREE_FOR_ALLz Free-For-AllrVrz)Instant free pickup for all party membersz?INSERT OR REPLACE INTO loot_allocation_modes VALUES (?,?,?,?,?)r3)) PARTY_MEMBERrc$@rCrCzCTeleport to party member (cast 3.5s, cd 10s, cancel on move/damage))FRIENDrcrirCrCz=Teleport to friend (cast 3.5s, cd 10s, cancel on move/damage)) GUILDMATErcrirCrCz@Teleport to guildmate (cast 3.5s, cd 10s, cancel on move/damage)) TOWN_PORTALrcrirCrCzATeleport via Town Portal to Hideout/Sanctuary (cast 3.5s, cd 10s)zV     *++E'N ! " "Dpp  j#(CIsx}ck35RURWY\Ym n  p p p p IIE&MMJZJ`JbJb  FF 7Hj+&*5"55"*   HhDUZ--//DD(..2B2BDDG KK5:xI1L1L1L1L1LgW_akmxm}@AB  C C C Q MM #0E /00L#399;;$ $ e    :)!,6J)!,9J494PZ-a00VZ  \/   %T5<88  N L K   !      L  L ( L  J|% 8 8 8     (,677E(O&''G--//  Q  K I I N  JO L  O O IN  L L      * LLE.+ , ,F,,..  Q:66qv666UKKK  J L IN FK % M M M L        &kkE(OK,JJJe6IJJJKK   L N   ! J   M M L       q &E-344NQ}}  s#UcAg--q11ddsQw/0!44TTcAg./33ddsQw/0!44*3//   !5#:E

dddddd}||dS)NrCrXr[r]r`) ACT_I_HUNGER ACT_II_MIASMAACT_III_CRUCIBLEACT_IV_TITAN_HUNTACT_V_SOVEREIGNcr)r order_maps r-rzrz&s+!"QAdez{||I == $ $$rL range_strtuple[int, int]c|dddddd}d|vrt|d} t|dt|dfS#t$rYnwxYwdS) NuCấpLevel+-rrC)rCr?)replacestripsplitr ValueError)r cleanpartss r-rvrv+s   gr * * 2 27B ? ? G GR P P V V X XE e|| C   uQx~~''((#eAhnn.>.>*?*?? ?    D  5s+A B99 CCrc>dddddd}||dS)Nrrr)zone_boundless_sanctuaryzone_player_hideoutzone_tang_kiem_nhaizone_ancient_sword_barrowzone_boundless_sandstormr )r zone_act_maps r-rr6s3$2>-O$6L   G^ 4 44rLr Optional[str]cFd|vs|dkrdSd|vs|dkrdS|dkrdnd S) N tang_kiemrrancientrrrrrrO)rrs r-rr?sPh&N":":$$H/ 9 9**)/3E)E)E % %KeerLrcTttD]\}}||kr|dzcSdS)NrC) enumerater)ridxilvls r-rrGs=~.. T $;;7NNN  2rLr(sqlite3.Cursorrrrr<rc(d|Dd|Dzd|Dzd|jDz}|d|t |S)NcVg|]&}d|jjd|jjdd|jf'S) rel_act_zone_ACTACT_CONTAINS_ZONEZONE)rxryr}rIas r-rKz-_seed_cross_relationships..OsIpq & & &qu{.QsI   qr & & &qu{.SsD   `a # # #VQY8I5RSRZ[   rLc Hg|]\}}|jpgD]}d|d|d|dd|f S)rel_quest_prereq_rAQUESTQUEST_REQUIRES_PREREQUISITE)r)rIqidqpres r-rKz-_seed_cross_relationships..Usi    CqG_Gece  ?B )S ( (3 ( ('38UW^`cd    rLzINSERT OR REPLACE INTO cross_relationships (relation_id, source_type, source_id, relation_type, target_type, target_id) VALUES (?, ?, ?, ?, ?, ?))valuesrrurr)r(rrr<r relationss r-rrNsuyvAvAvCvC  vzwBwBwDwD     ei       "288::    IOO \ y>>rL)NF)rrrrrr)rr.rr/)rrrr)r rrr )rrrr)rrrrrr)rrrr) r(r(rrrrr<rrrrr)&__doc__ __future__rrr$typingrrrrserver.world.storyline_catalogrserver.world.zone_enginer server.world.npc_catalogr server.world.quest_enginer &server.world.monster_archetype_catalogr r server.world.weapon_catalogrserver.world.martial_catalogrserver.world.item_affix_catalogrr$server.world.level_progression_curverr r&rzrvrrrrrOrLr-rOs #""""" ,,,,,,,,,,,,======//////::::::AAAAAAXXXXXXXX??????FFFFFFWWWWWWWWNNNNNN(xxxxv%%%% 5555ffffrL