Guild Creation

[Truth1010]

Thanks for the extra input Nubness, i didn't even stop to think about the other tables used with Guild Creation. To make your guild public, i would suggest setting up a hamachi client, then you can easily get your friends connecting to you (upto 5 i think with free hamachi)

You just install hamahi, then use the network ip it gives you in your game.exe / ini files. Then send your friends the game.exe used to connect to your server (get them to join your hamachi network too)

[QueenElsa]

alright. thanks!

[Penchod-Shaiya]

you actually need to add only 2 places which is at DBO.GuildChars and DBO.Guilds

 Spoiler

1) Add you Guild and give it a correct ID (Old ID + 1) into dbo.Guilds
2) Add your guild information and how much etins etc... into dbo.Guilds
3) Add your CharacterID into dbo.GuildChars and make it leader by giving it Rank 1
4) Restart your server and if you have done this correctly then it should work.

A small script on how to do this through DB

1) Adding the GUILD to your GUILDS list (Guild manager merchant):

 Spoiler

INSERT INTO [PS_Gamedata].[dbo].[Guilds] values
(The guild ID of your guild (place in the number next to your last GuildID number,
'Name of your Guild',
'ACCOUNT NAME OF YOUR GUILD LEADDER',
CHARID OF YOUR GUILD LEADER,
'NAME OF YOUR GUILD LEADER',
0 for light and 1 for dark,
Keep this a 1 since you are the only member (Count of guild memebrs),
Guild Points . how much points in GRB ranking,
KEEP THIS AT 0 SO YOUR GUILD IS NOT DELETED,
CreateDate just put it like 10.10.2010,
delete Date just put it as NULL)

2) Adding your Character into the Guild (pressing G in game) list:

 Spoiler

INSERT INTO [PS_Gamedata].[dbo].[GuildChars] values
(PUT IN THE GUILD ID OF THE GUILD YOU CREATED,
PUT IN YOUR CHARACTER ID,
GUILD LEVEL (Leave it as 1 if you want to be FAIR,
Deleted? LEAVE IT AS 0 IF YOUR MAKING A NEW GUILD,
JOINEDDATE ? just put 10.10.2010,
LEAVEDATE Keep it as NULL)

THE SCRIPT FOR ADDING GUILD:

 Spoiler

INSERT INTO [PS_Gamedata].[dbo].[Guilds] values
(50,'Admins','Admin',501,'[ADM]TruePeace',0,1,0,0,10.10.2010,NULL)

THE RESULT I GOT:

 Spoiler

(1 row(s) affected)

HOW IT LOOKS LIKE:



THE SCRIPT FOR ADDING GUILD MEMBER:

 Spoiler

INSERT INTO [PS_Gamedata].[dbo].[GuildChars] values (50,501,1,0,'10.10.2010',NULL)

THE RESULT I GOT:

 Spoiler

(1 row(s) affected)

HOW IT LOOKS LIKE:


THESE 2 steps will allow you to see and use a guild (to get a guild house you have to add the information to GUILD DETAILS) but the information gets added automatically once you logon and relog (or it is every 10 mins after GRB that guild stuff gets updated).

WHAT could possibly update dbo.GuildDetails?
If you read the trigger it says once the "REMARK" is update it TRUNUCATE the OLD row and RE-Creates it with the SAME possible information meaning just change your remark for guild and it should be added in game!

YES I tested this and it works.