1 (edited by Hacker 2009-10-17 19:48:27)

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