how I can create a guild through the database?
:rtfm::rtfm: :D:D
:rtfm::rtfm: :D:D
how I can create a guild through the database?
04/21/2011 17:07
emohardkore#1
04/22/2011 05:00
[GM]Recover#2
ps_gamedata.dbo.guilds
04/23/2011 19:00
Svinseladden#3
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:-)
04/23/2011 19:35
Gatewayto#4
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
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
04/25/2011 08:48
kheyo#5
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 :)
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 :)
04/25/2011 11:08
Svinseladden#6
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
04/25/2011 11:12
Svinseladden#7
when i tried this i get:Quote:
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 :)
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.
04/29/2011 13:16
adamkoolkid23#8
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.