Add Guild Point

You will need to obtain the guild ID for the guild you want to add guild points to. 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_AddGuildPoints

Parameters:

• @GuildID INT - Target guild ID
• @GPoints INT - Guild points

Let us first test whether the command works by using the following code, which will add 100000 guild points to a specific guild.

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

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

EXEC _Guild_AddGuildPoints @GuildID, 100000;