How To Make Guild In DB?

[QuikSilveR1]

how to me a new guild in db?
i know there are/was a topic about how to make one in db but i cant find it ^^
could any1 post a tutorial of how to?^^

[MentaL]

[Flohle]

hm I also can't find the thread xD well..never worked for me :P I made all ingame ;)

    a) Add the Guild in the [Guild] table.

The GID must be the PID of the GuildLeader. The other fields aren't that important, but ofcource you must enter a Name of the guild.

The Leader,Subleader etc. fields are the ingame title.

b) Add the GuildLeader to the [GuildMember] table

Lets say the Guildmaster is archer, and his PID is 1 ,then it would be 

1,1,2,0,0

The Date value is how long time to people can join a new guild.

c) Change the GID for the Player, in the [Player] Table

If you haven't done so yet :-) 

d) Restart the server.

Yes, a nessary evil. Guild updates in a database require a DB update.

~Originally posted by TheDeathArt

[QuikSilveR1]

hm I also can't find the thread xD well..never worked for me :P I made all ingame ;)

    a) Add the Guild in the [Guild] table.

The GID must be the PID of the GuildLeader. The other fields aren't that important, but ofcource you must enter a Name of the guild.

The Leader,Subleader etc. fields are the ingame title.

b) Add the GuildLeader to the [GuildMember] table

Lets say the Guildmaster is archer, and his PID is 1 ,then it would be 

1,1,2,0,0

The Date value is how long time to people can join a new guild.

c) Change the GID for the Player, in the [Player] Table

If you haven't done so yet :-) 

d) Restart the server.

Yes, a nessary evil. Guild updates in a database require a DB update.

~Originally posted by TheDeathArt

found a better guide ^^


1. Find the PID of the player who shall become guild leader (KAL_DB -> Player)

2. Open KAL_DB-> Guild
GID = PID from the player (Leader)
Name = guild name
Stadard = make 0 I guess its from the guild mark (Flag)
Exp = Guild Exp make it 16kk
TodayMessage = leave it clean...
Leader = position name for leader (LeaderOf Guildname) ^^
SubLeader = same shit for sub
Centurion = dunno write some shit
Ten = position name for chief
Regular = member position name
Temp = temp member position name
all other make 0

3. Open KAL_DB -> Guild Member
and insert...
GID = Leader PID
PID = Leader PID
Class = 1 for Leader
ConnectTell = 1 dunno what that is
Date = 0 should work ...

4. Open KAL_DB -> Player and search for your leader
scroll to right there is a col which is called GID write the PID in this field
so last step... next col is called GRole, make it 3

5. Login and look if it works, bb


tnx anyway :)

[borbiii]

http://forum.ragezone.com/f388/makin...nto-db-327127/ <--- look Thread :P

[pinos]

Its Works For Me Thanks QuikSilveR1 Its Realy Easy :P