Guild Creation

08/17/2014 01:35 QueenElsa#1
is there a way to create a guild through the database? i know that there is a sheet for guilds but how do i edit it or add a guild?

i know that it would be simpler to create a guild with the requirements. i got up to 3 accounts then everything dc lol but i wana know how it works like editing and creating guilds thru db. can anyone help?
08/17/2014 11:36 Truth1010#2
Make sure you have the guilds fix in your database first, to stop any other errors/dc's.
[Only registered and activated users can see links. Click Here To Register...]

Then, once you have done he necessary fixes.
In your database.
Ps_GameData
Tables > Guilds
Depending on your sql version (im on 2014, most are on 2008 or 2012)
Right click on guilds, then edit / edit all rows.
Then you simple fill the columns with your data, eg. guild master name, etc
08/17/2014 14:32 QueenElsa#3
Quote:
Originally Posted by Truth1010 View Post
Make sure you have the guilds fix in your database first, to stop any other errors/dc's.
[Only registered and activated users can see links. Click Here To Register...]

Then, once you have done he necessary fixes.
In your database.
Ps_GameData
Tables > Guilds
Depending on your sql version (im on 2014, most are on 2008 or 2012)
Right click on guilds, then edit / edit all rows.
Then you simple fill the columns with your data, eg. guild master name, etc
ok thanks! i will post an update of how its going after i try the fixes and all

so i was able to create a guild and execute it but, when i log into the game. the guild doesn't exist. how is that possible?
08/17/2014 15:50 nubness#4
There's more tables you need to insert data into. I'm sorry but I don't know which ones exactly. I will make a guild myself shortly and tell you everything you need to insert in tables.
08/17/2014 15:57 QueenElsa#5
Quote:
Originally Posted by nubness View Post
There's more tables you need to insert data into. I'm sorry but I don't know which ones exactly. I will make a guild myself shortly and tell you everything you need to insert in tables.
its alright and thank u tons!
08/17/2014 16:03 nubness#6
[Only registered and activated users can see links. Click Here To Register...]
08/17/2014 16:05 QueenElsa#7
ooh i see, so i have to edit those and it will appear on my toon?

tried it. not sure if i did it right because its not appearing on my toon
08/17/2014 16:33 nubness#8
You need to restart your server. Everything guild-related is effective as it is in the ps_game memory.
08/17/2014 16:50 QueenElsa#9
ah ok. thanks :)

restarted it and still not there o.o shud i restart my comp?
08/17/2014 17:20 nubness#10
That's weird, did you insert characters into the guild as well ?
08/17/2014 17:33 QueenElsa#11
no o.o should i have? create accounts and create toons?
08/17/2014 17:44 nubness#12
Yes, obviously.
08/17/2014 17:52 QueenElsa#13
even with that, it didnt work
08/17/2014 18:00 nubness#14
I know some databases are different than others, and can cause issues. A quick solution would be to make your server public for a few minutes and have a few friends help you create a guild.
08/17/2014 18:03 QueenElsa#15
alright but no idea how to make it public lol. and i figured out that i didn't do the guildstoreditems but idk what a boolean is. and i fixed the guildrankpoint.

do the accounts/toons in guild have to b on separate accounts or can they mostly be on 1 account?