首页 > 其他分享 >如何更新SuyaUi的版本?

如何更新SuyaUi的版本?

时间:2022-10-13 19:47:57浏览次数:45  
标签:__ Center SuyaUi drop 更新 Suya Ui 版本 procedure

若打算升级SuyaUi,可按照如下流程操作:

1.执行如下代码

use SRO_Center
select 'drop table '+ name + ';' from sys.tables where name like '__Suya_Ui_Center_%'
select 'drop procedure '+ name + ';' from sys.procedures where name like '__Suya_Ui_Center_%'

您会得到类似如下的结果:(一定要执行第一步的语句,↓下面的结果每个版本不同)

drop table __Suya_Ui_Center_Tab_Alchemy_Blender_History;
drop table __Suya_Ui_Center_Tab_Alchemy_Blender_Map;
drop table __Suya_Ui_Center_Tab_Alchemy_Recycle_Cost;
drop table __Suya_Ui_Center_Tab_Alchemy_Recycle_Param;
drop table __Suya_Ui_Center_Tab_Alchemy_Transform_Ac;
drop table __Suya_Ui_Center_Tab_Alchemy_Transform_Ar;
drop table __Suya_Ui_Center_Tab_Alchemy_Transform_Param;
drop table __Suya_Ui_Center_Tab_Alchemy_Transform_We;
drop table __Suya_Ui_Center_Tab_Boss_RespawnTimer;
drop table __Suya_Ui_Center_Tab_Box_Data;
drop table __Suya_Ui_Center_Tab_Box_History;
drop table __Suya_Ui_Center_Tab_Cdk_Data;
drop table __Suya_Ui_Center_Tab_Cdk_Group;
drop table __Suya_Ui_Center_Tab_Hwan_Color_Data;
drop table __Suya_Ui_Center_Tab_Layout;
drop table __Suya_Ui_Center_Tab_Link_Color;
drop table __Suya_Ui_Center_Tab_Lottery_Betting;
drop table __Suya_Ui_Center_Tab_Lottery_Bonus;
drop table __Suya_Ui_Center_Tab_Lottery_LuckeyNumber;
drop table __Suya_Ui_Center_Tab_Lottery_Option;
drop table __Suya_Ui_Center_Tab_Module_Option;
drop table __Suya_Ui_Center_Tab_News_Data;
drop table __Suya_Ui_Center_Tab_News_Type;
drop table __Suya_Ui_Center_Tab_Request_Stack;
drop table __Suya_Ui_Center_Tab_Scene_Buff;
drop table __Suya_Ui_Center_Tab_Scene_Data;
drop table __Suya_Ui_Center_Tab_Scene_Exp;
drop table __Suya_Ui_Center_Tab_Scene_Option;
drop table __Suya_Ui_Center_Tab_Scene_Point;
drop table __Suya_Ui_Center_Tab_Scene_Register;
drop table __Suya_Ui_Center_Tab_Scene_Reward;
drop table __Suya_Ui_Center_Tab_Scene_Tmp_Data;
drop table __Suya_Ui_Center_Tab_Scene_Tmp_Pos;
drop table __Suya_Ui_Center_Tab_Schedule;
drop table __Suya_Ui_Center_Tab_ScheduleWheel;
drop table __Suya_Ui_Center_Tab_Sign_Data;
drop table __Suya_Ui_Center_Tab_Sign_Limit;
drop table __Suya_Ui_Center_Tab_Sign_Quest;
drop table __Suya_Ui_Center_Tab_Sign_RecvLog;
drop table __Suya_Ui_Center_Tab_Silk_Data;
drop table __Suya_Ui_Center_Tab_System_Price;
drop procedure __Suya_Ui_Center_Pro_3809_GetTitleColorAndBoxItemCount;
drop procedure __Suya_Ui_Center_Pro_Alchemy_Blender;
drop procedure __Suya_Ui_Center_Pro_Alchemy_BlenderData;
drop procedure __Suya_Ui_Center_Pro_Alchemy_Calc;
drop procedure __Suya_Ui_Center_Pro_Alchemy_GetCost;
drop procedure __Suya_Ui_Center_Pro_Alchemy_GetData;
drop procedure __Suya_Ui_Center_Pro_Alchemy_Recycal;
drop procedure __Suya_Ui_Center_Pro_Alchemy_Transform;
drop procedure __Suya_Ui_Center_Pro_Boss_GetData;
drop procedure __Suya_Ui_Center_Pro_Boss_UpdateRespawnTime;
drop procedure __Suya_Ui_Center_Pro_Box_GetData;
drop procedure __Suya_Ui_Center_Pro_Box_GetHistory;
drop procedure __Suya_Ui_Center_Pro_Box_GetItem;
drop procedure __Suya_Ui_Center_Pro_Cdk_Execute;
drop procedure __Suya_Ui_Center_Pro_Lottery_Betting;
drop procedure __Suya_Ui_Center_Pro_Lottery_GetBonus;
drop procedure __Suya_Ui_Center_Pro_Lottery_GetData;
drop procedure __Suya_Ui_Center_Pro_Lottery_Open;
drop procedure __Suya_Ui_Center_Pro_Module_Execute;
drop procedure __Suya_Ui_Center_Pro_Module_GetData;
drop procedure __Suya_Ui_Center_Pro_Module_GlobalColor;
drop procedure __Suya_Ui_Center_Pro_Module_HwanColor;
drop procedure __Suya_Ui_Center_Pro_Module_ResetGuild;
drop procedure __Suya_Ui_Center_Pro_Module_ResetJob;
drop procedure __Suya_Ui_Center_Pro_Module_ResetPoint;
drop procedure __Suya_Ui_Center_Pro_Module_ResetRedName;
drop procedure __Suya_Ui_Center_Pro_Module_ResetSkill;
drop procedure __Suya_Ui_Center_Pro_News_GetData;
drop procedure __Suya_Ui_Center_Pro_Rank_GetData;
drop procedure __Suya_Ui_Center_Pro_Request_Handle;
drop procedure __Suya_Ui_Center_Pro_Request_Insert;
drop procedure __Suya_Ui_Center_Pro_Request_Reset;
drop procedure __Suya_Ui_Center_Pro_Scene_Assessment;
drop procedure __Suya_Ui_Center_Pro_Scene_CheckCharRefundCost;
drop procedure __Suya_Ui_Center_Pro_Scene_CheckLimit;
drop procedure __Suya_Ui_Center_Pro_Scene_Failed;
drop procedure __Suya_Ui_Center_Pro_Scene_GetData;
drop procedure __Suya_Ui_Center_Pro_Scene_GetDelay;
drop procedure __Suya_Ui_Center_Pro_Scene_GetHelp;
drop procedure __Suya_Ui_Center_Pro_Scene_GetIcon;
drop procedure __Suya_Ui_Center_Pro_Scene_GetOption;
drop procedure __Suya_Ui_Center_Pro_Scene_GetRealTimeData;
drop procedure __Suya_Ui_Center_Pro_Scene_GetRegisterCharListAndPoints;
drop procedure __Suya_Ui_Center_Pro_Scene_GetTopCharList;
drop procedure __Suya_Ui_Center_Pro_Scene_Initialize;
drop procedure __Suya_Ui_Center_Pro_Scene_LeaveScene;
drop procedure __Suya_Ui_Center_Pro_Scene_Refund;
drop procedure __Suya_Ui_Center_Pro_Scene_Register;
drop procedure __Suya_Ui_Center_Pro_Scene_SendBuff;
drop procedure __Suya_Ui_Center_Pro_Scene_SendReward;
drop procedure __Suya_Ui_Center_Pro_Scene_SetEffect;
drop procedure __Suya_Ui_Center_Pro_Scene_Settlement;
drop procedure __Suya_Ui_Center_Pro_Scene_Settlement_CharListInside;
drop procedure __Suya_Ui_Center_Pro_Schedule_Next;
drop procedure __Suya_Ui_Center_Pro_Sign_GetData;
drop procedure __Suya_Ui_Center_Pro_Sign_GetReward;
drop procedure __Suya_Ui_Center_Pro_Sign_SignIn;
drop procedure __Suya_Ui_Center_Pro_Silk_GetData;
drop procedure __Suya_Ui_Center_Pro_System_ClearDB;
drop procedure __Suya_Ui_Center_Pro_System_GetItemType;
drop procedure __Suya_Ui_Center_Pro_System_InventoryDelete;
drop procedure __Suya_Ui_Center_Pro_System_InventorySelect;
drop procedure __Suya_Ui_Center_Pro_System_Layout;
drop procedure __Suya_Ui_Center_Pro_System_Payment;
drop procedure __Suya_Ui_Center_Pro_System_RColor;
drop procedure __Suya_Ui_Center_Pro_System_RMagic;

执行上述语句,会删除SRO_Center库内与SuyaUi有关的所有数据表和存储过程。

2.将"..\SuyaUi Simple1.**\服务器文件\Plugin"内的2个dll文件覆盖到中心管理器的Plugin文件夹内
3.执行_INIT.sql
4.将新版本的SuyaUiSDK.dll、SuyaUiCRL.dll和Media文件夹复制到..\SMC\Patch_Internal\中,更新游戏

更新完成。

标签:__,Center,SuyaUi,drop,更新,Suya,Ui,版本,procedure
From: https://www.cnblogs.com/anzf/p/16789397.html

相关文章

  • 卸载SuyaUi
    如何卸载SuyaUi?1.删除中心管理器的Plugin文件夹内的两个dll文件2.将media\resinfo\ginterface.txt替换为未安装过SuyaUi的3.将sro_client.exe替换为未安装过SuyaUi的,卸......
  • 版本发布存在的问题
    1、涉及到前后端都有修改的,需要前后端同步发版本,避免单方面发版本出现各种无效bug,浪费测试资源;2、版本发布涉及到表结构修改、新增表、初始化数据*(代码里写死的、数据库里......
  • Unity---2020版本连接Mysql报错
    连接Mysql需要Mysql.data打包发布后无法连接数据库需要导入I18N.dll,I18N.CJK.dll,I18N.West.dll导入System.Data.dll2020版本以上不需要导入System.Data.dll如......
  • 西门子发布Smart 200 V2.5版本
    西门子悄悄发布了Smart200的V2.5版本,以下这些PLC型号是可以支持V2.5版本:CPUSR20,AC/DC/继电器6ES7288-1SR20-0AA0CPUST20,DC/DC/DC6ES7288-1ST20-0AA0CPUSR30,AC/DC/继电......
  • MySQL——MVCC--多版本并发控制机制
    前言以下的分析均在mysql的InnoDB引擎下。假设此时事务A与事务B同时执行。一、定义:MVCC(Multi-VersionConcurrencyControl,多版本并发控制)一种并发控制机制,在数据库中用......
  • css面试题大全(持续更新)
    介绍一下css的盒子模型?​css盒子模型详解css选择符有哪些?css3新增伪类有那些?​元素选择符与关系选择符属性选择符伪类选择符,CSS3新增伪类伪对象(伪元素)选择符css那些属性......
  • ogg不同版本之间同步
    环境:主库ogg版本:21C从库ogg版本:12C 同步遇到的问题:2022-10-1314:52:48ERROROGG-02598File/goldengate12c/dirdat/cp000000000,withtrailformatrelea......
  • SuyaUi接口调用示例
    向保管箱投放物品insertinto__Suya_Ui_Center_Tab_Box_Datavalues(@CharID,@Type,@Name,@Code,@Count,@From,@Reason)@CharID必填@CharID@Type......
  • Debian 如何更新源
    1.备份sudomv/etc/apt/sources.list/etc/apt/sources.list.bak2.编辑源sudovim/etc/apt/sources.listvim内容为debhttp://mirrors.aliyun.com/debian/bus......
  • git使用:代码回退到某个版本
    一、更新本地仓库gitreset--hard版本号(只更新了本地,但是远方没有更新,gitpull后仍存在最新版本)二、更新远方仓库gitreset--hard版本号gitpushorigin<分支名>......