Auto Join Guild

[[GameAdvisor]Finn]

Hi epvp. i think auto join guild when character is new create is possible but anyone know what query of that?
Ex. i create guild for UoF and AoL
then new character auto join guild base on his Faction..
if someone know this query im glad

Thanks in advance

[oldjayy]

Assuming there will be only one guild per faction following could do the job.
You will need to add it to your usp_Create_Char_R stored procedure.

DECLARE @GuildID INT
DECLARE @faction tinyint
SET @faction = (SELECT Country FROM UserMaxGrow WHERE UserUID = @UserUID)
SET @GuildID = (SELECT GuildID FROM Guilds WHERE Country = @faction)
INSERT INTO GuildChars(GuildID, CharID, GuildLevel, Del, JoinDate, LeaveDate)
VALUES(@GuildID,@CharID,5,0,getdate(),NULL)

[[GameAdvisor]Finn]

Originally Posted by oldjayy

Assuming there will be only one guild per faction following could do the job.
You will need to add it to your usp_Create_Char_R stored procedure.

Thank you sir but in my mined is like starter gears
Starting guild I put the guild id on table like when i add starting item on BaseGearDefs.

Ex. I make guild for Dark so all new create dark auto join on dark guild i put and same to Light guild.

Thanks for answer if you know sir

[oldjayy]

USE PS_GameData
CREATE TABLE dbo.StarterGuilds
(
GuildID int,
Faction tinyint
)

DECLARE @GuildID INT
DECLARE @faction tinyint
SET @faction = (SELECT Country FROM UserMaxGrow WHERE UserUID = @UserUID)
SET @GuildID = (SELECT GuildID FROM StarterGuilds WHERE Faction = @faction)
INSERT INTO GuildChars(GuildID, CharID, GuildLevel, Del, JoinDate, LeaveDate)
VALUES(@GuildID,@CharID,5,0,getdate(),NULL)

Faction 0 is AoL 1 is UoF

[[GameAdvisor]Finn]

Originally Posted by oldjayy

Faction 0 is AoL 1 is UoF

Thank you sir.. i see its already insert in guildchars the new character i create.. but the problem is not show the guild on character i create..

[oldjayy]

DECLARE @GuildID INT
DECLARE @faction tinyint
SET @faction = (SELECT Country FROM UserMaxGrow WHERE UserUID = @UserUID)
SET @GuildID = (SELECT GuildID FROM StarterGuilds WHERE Faction = @faction)

INSERT INTO GuildChars(GuildID, CharID, GuildLevel, JoinDate)
VALUES(@GuildID, @CharID, 5, GETDATE())

UPDATE Guilds SET TotalCount += 1 WHERE GuildID=@GuildID

Make sure the guild exists in dbo.Guilds in a correct way.

[[GameAdvisor]Finn]

Originally Posted by oldjayy

Make sure the guild exists in dbo.Guilds in a correct way.

yes sir its exists but when i create new character is not show .. then only show if i restart the server!

[Realp0rta]

-------------------------------------------------------------------------------------------------------

DECLARE @D INT
DECLARE @ tinyint
SET @ = (SELECT Country FROM UserMaxGrow WHERE UserUID = @ID)
SET @D = (SELECT GuildID FROM StarterGuilds WHERE Faction = @)
SET @D = (SELECT @ FROM Chars)

INSERT INTO GuildChars(GuildID, CharID, GuildLevel, JoinDate)
VALUES @D, @, 5, GETDATE())

UPDATE Guilds SET TotalCount += 1 WHERE GuildID @D
-------------------------------------------------------------------------------------------------------