|
You last visited: Today at 23:51
Advertisement
Guild Creation
Discussion on Guild Creation within the Shaiya PServer Development forum part of the Shaiya Private Server category.
08/17/2014, 01:35
|
#1
|
elite*gold: 0 
Join Date: Mar 2014
Posts: 38
Received Thanks: 4
|
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?
|
|
|
|
08/17/2014, 11:36
|
#2
|
elite*gold: 0
Join Date: May 2012
Posts: 394
Received Thanks: 392
|
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
|
|
|
|
|
08/17/2014, 14:32
|
#3
|
elite*gold: 0
Join Date: Mar 2014
Posts: 38
Received Thanks: 4
|
Quote:
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?
|
|
|
|
|
08/17/2014, 15:50
|
#4
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,455
|
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
|
#5
|
elite*gold: 0
Join Date: Mar 2014
Posts: 38
Received Thanks: 4
|
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!
|
|
|
|
|
08/17/2014, 16:03
|
#6
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,455
|
|
|
|
|
|
08/17/2014, 16:05
|
#7
|
elite*gold: 0
Join Date: Mar 2014
Posts: 38
Received Thanks: 4
|
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
|
#8
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,455
|
You need to restart your server. Everything guild-related is effective as it is in the ps_game memory.
|
|
|
|
|
08/17/2014, 16:50
|
#9
|
elite*gold: 0
Join Date: Mar 2014
Posts: 38
Received Thanks: 4
|
ah ok. thanks 
restarted it and still not there o.o shud i restart my comp?
|
|
|
|
|
08/17/2014, 17:20
|
#10
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,455
|
That's weird, did you insert characters into the guild as well ?
|
|
|
|
|
08/17/2014, 17:33
|
#11
|
elite*gold: 0
Join Date: Mar 2014
Posts: 38
Received Thanks: 4
|
no o.o should i have? create accounts and create toons?
|
|
|
|
|
08/17/2014, 17:44
|
#12
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,455
|
Yes, obviously.
|
|
|
|
|
08/17/2014, 17:52
|
#13
|
elite*gold: 0
Join Date: Mar 2014
Posts: 38
Received Thanks: 4
|
even with that, it didnt work
|
|
|
|
|
08/17/2014, 18:00
|
#14
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,455
|
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
|
#15
|
elite*gold: 0
Join Date: Mar 2014
Posts: 38
Received Thanks: 4
|
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?
|
|
|
|
 |
|
Similar Threads
|
[HELP]Guild + emblem creation issue
09/21/2017 - Dekaron Private Server - 6 Replies
Hi , It was supposed to be easy to create a guild especially if you were the creator , but in this case , I've encountered this scenario.
I've created a guild name let us say 'Test' after the 'Test' guild was created my guild-creator character doesn't have any rank even a default rank doesn't applied. I am expecting that my character should be the Guild Master , but it did not .. when I checked my character's rank it is blank..
So next one I tried to create a guild emblem but after the...
|
Guild Creation
09/01/2011 - Dekaron Private Server - 0 Replies
We are sorry but we just got this letter and we comply with the msg
"
To Elitepvpers
The account Cataracts - Daemon Strother has been reported for multiple crimes by the US state department of illegal Child sexual abuse!
law § 2243 - Sexual abuse of a minor or ward:
(a) Of a Minor.— Whoever, in the special maritime and territorial jurisdiction of the United States or in a Federal prison, or in any prison, institution, or facility in which persons are held in custody by direction of or...
|
[Help] Problem in Guild Creation
03/30/2011 - Shaiya - 12 Replies
Hi guys, i am geting a error in Guild Creation.
I can Create one Guild, but if i Shutdown my server, the Guild dont appears in next Server Start. Cause the Guild only stay recorded in Memory.
in my logs i have detected the error, that also happen when i try execute the script to create manually in SQL Query.
I already have looked about this error in Google, but dont sucess in all results.
If somebody know how fix, and can help me, i thank you now ;)
PS_DBAGENT__system.log:...
|
[Guild Creation] Name Hack?
08/17/2009 - Dekaron - 3 Replies
Hey, a while ago you could make a guild using [ ' { + ` ~ characters in the guild name. Now you cant. It says "you have typed incorrect language"
I want to make a guild using this in the name: '
How can I do this, now that there is a filter?
I see people using invalid names. So there must be a way to make a guild using those characters.
Guild trying to create/example: John'sClub
|
All times are GMT +1. The time now is 23:52.
|
|
