3D MMOARPG仙侠手游巨作《蜀山战纪》手游,同名电视剧官方唯一正版授权,吴奇隆首次担当手游监制游戏采用唯美写实画风,力邀电视剧原班人马配音,完美再现经典剧情,打造极致仙侠体验。 玩家在游戏中将化身一代剑侠,体验御剑飞行,热血空战遨游九天;捕捉极品灵宠,变异资质群攻秒怪;参与万人国战,三大阵营边境激情PK;主宰仙魔两界之战,正邪仅在一念之间!贺岁2016,震撼的蜀山,全新的剑侠1月底震撼来袭!
select res_id,res_name,r_index_id,default_r_i_id,flag from(select top 9 res_id,res_name,r_index_id,default_r_i_id,0 as flag from T_D_Resource where res_is_audit=1 and res_run_flat='Android' and channel_id=4 and default_r_c_id=160 order by newid() )a union select res_id,res_name,r_index_id,default_r_i_id,1 as flag from T_D_Resource where res_id=97039 order by flag desc