how I can create a guild through the database?

emohardkore · 04/21/2011, 17:07

[GM]Recover · 04/22/2011, 05:00

ps_gamedata.dbo.guilds

Svinseladden · 04/23/2011, 19:00

is there a step by step tutorial or anyone that can show how? new server and i don't want to make 7 accounts and use all my friends pc just to make the first one:-)

Gatewayto · 04/23/2011, 19:35

It maybe easier to show you then to write a tutorial because making a guild on server side requires UserID, CharID and server reboot to have guild information show at guild master (not 100% sure on server reboot).

But Shaiyatoplist basiclly show you where to go already (ps_gamedata.dbo.guilds
). Just gather all the require column information. It's very much like creating an account or character (gather all the column information, then popluate them.

You can add me to your skype if you require more assistance.

Skype: Gatewaytoo

kheyo · 04/25/2011, 08:48

GO into your database...

Expand GameData, then expand Programmability, then expand stored procedures. Find the procedure called dbo.usp_Create_Guild2_E

(the first one only does guilds table, the Guild2 does details and guilds tables)

Right click and select execute. Type in the info and Execute the procedure.

Will take effect at restart

Svinseladden · 04/25/2011, 11:08

i get: thing is i follow id numbers and stuff like that. but i get :no data was updated. the data in row 1 was not committed. error source: .net sqlclient data provider. error message: the ole db provider "sqlncli10" for linked server "ps_userb01" does not contain the table ""ps-userdata"."dbo"."createdguilds"".the table either does not exist or the current user does not have the permissions on that table

Svinseladden · 04/25/2011, 11:12

Quote:

Originally Posted by kheyo

GO into your database...

Expand GameData, then expand Programmability, then expand stored procedures. Find the procedure called dbo.usp_Create_Guild2_E

(the first one only does guilds table, the Guild2 does details and guilds tables)

Right click and select execute. Type in the info and Execute the procedure.

Will take effect at restart

when i tried this i get:

Msg 7314, Level 16, State 1, Procedure Trig_Guilds_Insert, Line 7
The OLE DB provider "SQLNCLI10" for linked server "PS_USERDB01" does not contain the table ""PS_UserData"."dbo"."CreatedGuilds"". The table either does not exist or the current user does not have permissions on that table.

adamkoolkid23 · 04/29/2011, 13:16

also bear in mind that creating a guild through the database will not allow players to apply in game to the guild. If anyone wants to join your guild you will have to add them manually through the database.