本来是作为转生程序的一部分的,后来玩家对转生看法不一致,没有采用改名程序。
现将原始SQL脚本分享给大家,希望对大家有帮助。
脚本提供:魂之武者-联谊会 Dream 2004-05-25
适用范围:双数据库(单数据库版的请将数据库名修改即可)
回复后可见脚本,使用方法:复制脚本到mssql的查询分析器的查询窗口中,执行即可
注意事项:改名时请先确认名字没有与其他老玩家的名字重复
DECLARE @username varchar(14),@username_new varchar(14)
set @username='老名字'
set @username_new='新名字'
UPDATE [NewMuhonGame].[dbo].[del_Item_0]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[del_Item_1]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[del_Item_2]
SET [Charid] = @username_new
WHERE [Charid] like @username
织梦好,好织梦
UPDATE [NewMuhonGame].[dbo].[del_Item_3]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[del_Item_4]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[del_Item_5]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[del_Item_6]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[del_Item_7]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[del_Item_8]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[del_Item_9]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Del_TblGUILDMEMBERINFO]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_0]
SET [Charid] = @username_new
WHERE [Charid] like @username
织梦内容管理系统 UPDATE [NewMuhonGame].[dbo].[Item_1]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_2]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_3]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_4]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_5]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_6]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_7]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_8]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_9]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Item_UserMake_Log]
内容来自dedecms
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[ItemMoneyLog]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[TblCharinfoTimeLog]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[TblCharinfoTimeLog]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[TblGUILDLOG]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[TblGUILDMEMBERINFO]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[TblHistoryCharinfoBase]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[TblLogCharDeath]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Temp_Money]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Charinfo_Base]
copyright dedecms SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[zsok]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[CharInfo_Macro]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Charinfo_Option]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Charinfo_Skill]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[CHARINFO_TIME]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Charinfo_Whisper_Reject_List]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[CMSLogTable]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Del_Charinfo_Base]
SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[Del_Charinfo_Skill]
copyright dedecms SET [Charid] = @username_new
WHERE [Charid] like @username
UPDATE [NewMuhonGame].[dbo].[TblLogCharGuildMoney]
SET [strOwner] = @username_new
WHERE [strOwner] like @username
UPDATE [NewMuhonGame].[dbo].[temp_TblCharGuildMoney]
SET [strOwner] = @username_new
WHERE [strOwner] like @username
UPDATE [NewMuhonGame].[dbo].[TblCharGuildMoney]
SET [strOwner] = @username_new
WHERE [strOwner] like @username
UPDATE [NewMuhonGame].[dbo].[ItemLog]
SET [FirstOwner] = @username_new
WHERE [FirstOwner] like @username
UPDATE [NewMuhonGame].[dbo].[ItemLog]
SET [LastOwner] = @username_new
WHERE [LastOwner] like @username