Topic: Changes the character name in Mu Online
MsSQL script to Changes the character name in Mu Online
use muonline
Update dbo.AccountCharacter
SET GameID1 = 'New nick' WHERE GameID1='Old nick' and Id = 'Acount name'
Update dbo.AccountCharacter
SET GameID2 = 'New nick' WHERE GameID2='Old nick' and Id = 'Acount name'
Update dbo.AccountCharacter
SET GameID3 = 'New nick' WHERE GameID3='Old nick' and Id = 'Acount name'
Update dbo.AccountCharacter
SET GameID4 = 'New nick' WHERE GameID4='Old nick' and Id = 'Acount name'
Update dbo.AccountCharacter
SET GameID5 = 'New nick' WHERE GameID5='Old nick' and Id = 'Acount name'
Update dbo.Character
SET Name = 'New nick' WHERE AccountID = 'Acount name' AND Name = 'Old nick'
Update dbo.Guild
SET G_Master = 'New nick' WHERE G_Master = 'Old nick'
Update dbo.GuildMember
SET Name = 'New nick' WHERE Name = 'Old nick'
Update dbo.OptionData
SET Name = 'New nick' WHERE Name = 'Old nick'
Credits:
- iBimbo (Rz)
- oggyss por la query
- 007jodex...Simpe busqueda y explicacion