Note that maximum level is 95 if you only set in AikaServer.ini to 99.
EXP that goes past lv95 will show as minus.
You can still set lv99 in DB for unlocking all skills., although char info still show as 95.
CLASSINFO
You don't need job change quest from lv50 to 51. But it is required in some equipment.
1 = Warriors >?> 2 = Conqueror
11 = Paladins >?> 12 = Templar
21 = Riflemen >?> 22 = Sniper
31 = Dual Gunners >?> 32 = Pistoleer
41 = Warlocks >?> 42 = Arcanist
51 = Clerics >?> 52 = Saints
On my character database, i use 12 which is Paladino in PTBR
But on my guild info, i use 11 which is Templario in PTBR
while at it, here is some guide to create Guild database
GUILDS Tables
:
ID (index default number start from 1),
SLOT (idk, i assume it is for guild logo),
NAME (guild name obviously,
NATION (use nation id where the guild registered),
EXPERIENCE (pontos in TLJ, guild exp),
LEVEL (maximum level is 5),
TOTALMEMBER (guild member count, level 1 max member is 32, level 5 guild is 128 members),
BRAVUREPOINTS (points required for activating guild skills),
SKILLPOINTS (to upgrade guild skills),
PROMOTE (possibly related to guild levelup, might be boolean),
NOTICE1-3 & SITE (guild info),
RANK1-5 (random number, it is the option where you assign role for each rank. 0 is no role, 1 is invite only, 215 is all role. Rank 5 is master and MUST BE 255),
ALLY_LEADER (guild_ID that will lead alliances, guild master became Marshall),
GUILD_ALLY1_NAME (the name string of each guild inside alliance, can be empty)
GUILD_ALLY1_INDEX (guild_id of the guild alliances, 0 for none),
STORAGE_GOLD (guild warehouse gold, also for using skills),
LEADER_CHAR_INDEX (char ID used for the guild master maybe).
Note that it is recommended to assign ally guild in game. Using navicat to assign alliance might not give shout role. Leader character might need to relog after assigning alliances.
GUILDS_PLAYER Table
:
GUILD_INDEX (guild ID),
CHAR_INDEX (char ID that will be assigned to a guild),
NAME (character name),
PLAYER_RANK (assign rank from 0-4. 4 is Master),
CLASSINFO (refer above for list),
LEVEL (character level shown in guild member list. input 99 will have output 98, etc),
LOGGED (1 is online, 0 is offline),
LAST_LOGIN (0 for default)
Lastly assign
GUILD_INDEX inside
CHARACTER table
it is still buggy and there are no contribution points, no guild skills to learn. You are supposed to use "Promote" button in guild info to raise guild level. You might want to try manually create 6 accounts and normally make guild, it is work.
For LMA, just go to Castle Siege War NPC and enter. 1 guild is enough. The default or first CSW one don't have specific time for CSW like normal server.