Guild Creation

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?

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

Quote:

Originally Posted by Truth1010 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?

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.

Quote:

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!

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

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

ah ok. thanks :)

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

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

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

Yes, obviously.

even with that, it didnt work

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.

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?