Update Guild Name Color

A good understanding of How to select a color value?

You will need to obtain the guild ID for the guild whose name color you want to update. You can use the following query to get the guild ID from the database.

SELECT ID FROM SRO_VT_SHARD.._Guild WHERE [Name] = 'guild_name'

Stored Procedure: _Guild_UpdateNameColor

Parameters:

• @GuildID INT - Target guild ID
• @Color INT - Color value

Let us first test whether the command works by using the following code, which will change the name color of a specific guild to red.

USE [vPlus]
GO
DECLARE @GuildID INT = (SELECT ID FROM SRO_VT_SHARD.._Guild WHERE [Name] = 'guild_name')
EXEC _Guild_UpdateNameColor @GuildID, 16715792;

For real usage, use @GuildID directly from your calling procedure.

EXEC _Guild_UpdateNameColor @GuildID, 16715792;