Guild Creation

[QueenElsa]

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?

[Truth1010]

Make sure you have the guilds fix in your database first, to stop any other errors/dc's.


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

[QueenElsa]

Originally Posted by Truth1010

Make sure you have the guilds fix in your database first, to stop any other errors/dc's.


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?

[nubness]

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.

[QueenElsa]

Originally Posted by nubness

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!

[nubness]

[QueenElsa]

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

[nubness]

You need to restart your server. Everything guild-related is effective as it is in the ps_game memory.

[QueenElsa]

ah ok. thanks

restarted it and still not there o.o shud i restart my comp?

[nubness]

That's weird, did you insert characters into the guild as well ?

[QueenElsa]

no o.o should i have? create accounts and create toons?

[nubness]

Yes, obviously.

[QueenElsa]

even with that, it didnt work

[nubness]

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.

[QueenElsa]

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?