you actually need to add only 2 places which is at DBO.GuildChars and DBO.Guilds
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):
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:
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:
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:
HOW IT LOOKS LIKE:
[Only registered and activated users can see links. Click Here To Register...]
THE SCRIPT FOR ADDING GUILD MEMBER:
INSERT INTO [PS_Gamedata].[dbo].[GuildChars] values (50,501,1,0,'10.10.2010',NULL)
THE RESULT I GOT:
HOW IT LOOKS LIKE:
[Only registered and activated users can see links. Click Here To Register...]
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.