[TUTORIAL/SQL] How to change autobroadcast name

[Etox]

Hey today I will show you how to change your autobroadcast name.

Basically what this does is to change something in your Trinity_String, so instead of it saying Autobroad cast it can say whatever you want. I will show you.

set
@Text := '|cffffff00[|c00077766Lucky-Gaming News|cffffff00]: |cFFF222FF%s|r';

UPDATE trinity_string SET content_default=@Text WHERE entry=11000 LIMIT 1;

So if I run this query in my world database, my Autoroadcast will say "Lucky-Gaming News". If you edit the text which is there already to for example "EmuDevs", it will say that instead. Like this.

set
@Text := '|cffffff00[|c00077766EmuDevs|cffffff00]: |cFFF222FF%s|r';

UPDATE trinity_string SET content_default=@Text WHERE entry=11000 LIMIT 1;

It will look the same with EmuDevs, as it does for Lucky.Gaming or Obivion WoW, or whatever your server name is.

Before you ask, yes this works for the latest TrinityCore revision.

Hope you like it! If you wonder about something just send me a PM.

Best Regards, Etox.

 

[Tommy]

Very nice, thanks for sharing!

 

[ZeuS]

There is a problem with this query !

After using this SQL Query , my Auto broadcast system not working anymore ... It doesn't show any of my broadcasts !
BTW I checked world.config file and it is enabled !

Anyone know how to fix this issue ?

 

[Etox]

Then your probably edited the query or something? Works perfect for me.

 

[Skrbx]

The "code" given above have some weird characters which can be a problem. Anyway in query given i dont see the point of the definition of string variable which is used in next line (the update query). If you are going to use a variable only once in any kind of code, there is no point of declaring a variable for it.

 

[slp13at420]

kewl nice info tnx :RpS_thumbsup:

 

[Plikaplouk]

Thanks dude !