So after using this query your GM char will can login without any crashes and noone will can pm you. Atleast silence for GM's :-)
Enjoy :-)Code:USE [SRO_VT_SHARD]
UPDATE dbo._Char SET CharName16 = '[GM] XioLi' WHERE CharName16 = '[GM]XioLi'
GO
Printable View
So after using this query your GM char will can login without any crashes and noone will can pm you. Atleast silence for GM's :-)
Enjoy :-)Code:USE [SRO_VT_SHARD]
UPDATE dbo._Char SET CharName16 = '[GM] XioLi' WHERE CharName16 = '[GM]XioLi'
GO
lol .... just add to your char name "[GM] *NAME*"...
nice Idea .. thxx for share :)
[GM]+Space+Name ^^
So you don't want to care about player issues ingame ;o - I know that there are many ones who're simply spamming. But it's easier for a player with a problem to pm a GM ingame than doing it through a forum or whatever ^^ But that's just my opinion
lol what a funny query, too hard just to do the space yourself? xD
i was thinking that too... isnt this just pressing the spacebar on your name with the already GM tags in _char OoQuote:
Originally Posted by RealityT90
People, go and try to understand them :huh:Quote:
Originally Posted by kellogz
Its more about not getting spammed with 10m plýs or something. So you can work out real problem via MSG e.g.Quote:
Originally Posted by Caipi
lol only got crash when change name for [gm] when you have guild in char
Cause you've got to change it as well in _GuildMember
yeap Caipi is right.
So you'd better change it like e.g...
PHP Code:USE SRO_VT_SHARD
Declare @Title varchar(25) SET @Title = '[GM]'
Declare @CharNick varchar(25) SET @CharNick = 'XioLi'
Update _Char SET CharName16 = @Title + ' ' + @CharNick WHERE CharName16 = @Title + @CharNick
Update _GuildMember SET CharName = @Title + ' ' + @CharNick WHERE CharName = @Title + @CharNick
Nice idea!