[Tutorial] How to start Guild/Castle War.

[bd0rk's]

Oups I didnt read goodly i think ^^

Kind Regards, bd0rk's

 

[fungamer]

Hi all any pls help me i no have gate on cw and flag who need repair this?

 

[vivian11]

Follow the steps to complete,Siege unsuccessful applicants,Who can help？Tell me the reasons for the failure of trade unions for siege....

 

[Dark_TReX]

how do change the castle owner guild after the cw is over ?
Do i add a new row in castle owner @ db ? or replace the old one.

 

[rus1an94]

re upload the link please

 

[ObuolYs]

how do change the castle owner guild after the cw is over ?
Do i add a new row in castle owner @ db ? or replace the old one.

Replace old, because there could be only one owner.

 

[aviavi]

re upload please

 

[i tund i]

Where i can get gate for castle and flag :O

 

[Konaide]

Again ... just do exactly what tutor said:

1. start "Enterprise Manager" (your SQL-Server-Manager)
2. select: Databases->kal_db->Tables->Guild (right mouse - return all rows)
3. Enter following:
GID = (Your Char's ID ... mine was 519)
Name = Adminguild
Standard = 0
Exp = 16000000
TodayMessage = Nice weather
Leader = Leader
SubLeader = Subleader
Centurion = Manager
Ten = Chief
Regular = Member
Temp = TempMember
SubLeaderAble = 3
Centurionable = 1
TenAble = 1
RegularAble = 0
TempAble = 0
AID = 0

--> now you made your first guild! ... but wait! There is nobody in this guild
3b.
Select from Databases->kal_db->Tables->GuildMember
Enter following (right mouse - return all rows):
GID = (Your Guild-Leader-Char's ID ... mine was 519)
PID = 519 (Your Guild-Leader Char ID)
Class = 1 (= Leader)
ConnectTell = 1
Date = 0

--> now you got your Leader registered in your guild. (you can add some more - but i guess its not needed - didnt tried it)
To add more member ... just copy this line and only change PID into Char ID of the new Guildmembers - and set Class = 5 (cause there can be only 1 Leader).

4. Register for War
select: Databases->kal_db->Tables->GuildCastle (right mouse - return all rows)
Enter following:
CID = 1
GID = 519 (Your Guild-ID (which is your Guild-leaders id)
Tax = 1 (didnt figured out what this does atm ... but it worked with 1)
TaxRate = 85
Gatelimit = 1

select: Databases->kal_db->Tables->GuildWar (right mouse - return all rows)
Enter following:
CID = 1
AID = 0
GID = 519

5. Getting into war
Start all servers (Auth, Login, Main)
Start Client
Login with Admin-Char
type "/declare" (a notice will tell you to go to Castle War Keeper and register for war...
type "/warbegin" CW should start.

(As i entered the guildwar-thing ... War started automatical at login... so you might dont even have to do the admin part).

If i where you, i would use 1. War to get everything testet (like cannons, gates ... whatever you want). When war is over, KAL correct all wrong entries automatically by overwriting them.
Next war you already got a Castle Owner and only have to do "/declare" ... everyone can go to register for war... and "/warbegin" ... new "Attackerguild" will fight for them to be Castle-Owner.

Even though i didnt tell anything new ... i hope i could help a bit.



Offtopic: (Just in case you did everything above, but you still dont have that Char with 519-ID... and you cant figure out where to get that id:

Select from Databases->kal_db->Tables->Player (Return all rows)
There should be at least 1 line with entries which could look familiar to you (like Name = "Admin" or sth. ...) Your Char ID = PID. Use this 3-digit Number to build your guild.

Oh ... but if your just in that database (kal_db->Tables->Player) you can alter
Contribute = 0 to 450
This way your guild should have 16000000 EXP + 450 Contribution points = LvL 4 Guild.
(restart all servers and your client ... so that they know you got enough Contri-Points)

* Based on MSSQL 2000 - dont know if it works for 2005 - but cant be that different