❓ Most Common Q&A

1. How to set the required compose star so it only needs 19★? ✅ New and old Engines

Open the cq_eudemon_rbn_rqr table → find the column sacrifice_starlev.

- Change all values higher than 1900 to 1900.
- This makes all composes require only 19★, regardless of main eudemon’s stars. 


-- Example: force compose to only need 19★
UPDATE cq_eudemon_rbn_rqr SET sacrifice_starlev=1900 WHERE sacrifice_starlev > 1900;

2. How to make your eudemon hatch with high stars? ✅ New and old Engines

Open the cq_grade table → find the column rarity.

- Higher value = higher starting stars when pet hatches.
- Example: set 10000 → pet hatches with ~100★.

⚠️ Do not set too high or the pet may fail to summon. 


-- Example: make pet ID 380 hatch with ~100★
UPDATE cq_grade SET rarity=10000 WHERE id=380;

3. How to switch a eudemon from Warrior to Mage (or vice versa)? ✅ New and old Engines

Open the cq_itemtype table → find the pet’s ID → check the able_mask column.

- 7 = mount + merge (mount pets only)
- 3 = can merge (Mage → Warrior change may also need cq_grade)
- 2 = cannot merge (Warrior → Mage requires edits in cq_grade + cq_action skills) 


-- Example: change pet ID 12345 to mergeable
UPDATE cq_itemtype SET able_mask=3 WHERE id=12345;

4. How to change the eudemon compose rate? ✅ New and old Engines

Open the cq_eudemon_rbn_rqr table → check the columns min and max.

- Increasing max = higher score gained each compose.
- Adjust both min and max to balance growth speed.

⚠️ Backup your table before bulk updates. 


-- Double compose rate for all rows
UPDATE cq_eudemon_rbn_rqr SET min = min * 2, max = max * 2;
    

-- Restore back (divide by same factor)
UPDATE cq_eudemon_rbn_rqr SET min = min / 2, max = max / 2;

💡 Tip: If you multiply by 3 or 4, you must divide back by the same factor to restore original values.

5. How to remove the requirement of same attribute when compose eudemon? ✅ New and old Engines

Open the cq_eudemon_rbn_rqr table → find the sacrifice_dmg_type column.
- 0 = does not require same attribute
- 1 = requires same attribute
Change values from 1 → 0 to remove the restriction.

6. How to modify success/failure rate when composing eudemons? ✅ New and old Engines

Open the cq_eudemon_rbn_rqr table → look for the column suc_percent.

- Set to 100 → compose will never fail.
- Set to 75 (or lower) → compose will often fail.

⚠️ Adjust carefully, too high may break balance, too low frustrates players. 


-- Example: make all compose always succeed
UPDATE cq_eudemon_rbn_rqr SET suc_percent=100;
    

-- Example: make compose harder (higher chance to fail)
UPDATE cq_eudemon_rbn_rqr SET suc_percent=75;

7. How to change Legion War days? ✅ Old Engines

Open the cq_config table → look for ID 191.
Change the 3rd and 4th field values:
- 1 = Monday
- 3 = Wednesday
- up to 7 = Sunday
Copy the modified table as a patch to update daily on server restart.
⚠️ In new engine, this is handled by MSG, not database.

8. How to modify VIP batch hatch time? ✅ Old Engines

Open the cq_config table → look for rows where type = 3101–3107.

- 3101 = VIP level 1
- 3107 = VIP level 7

The column data1 = hatch time in seconds.
Example: 1 = 1 second.

⚠️ Newer engines usually adjust this via GM tools instead of database edits. 


-- Example: set VIP 7 batch hatch time to 5 seconds
UPDATE cq_config SET data1=5 WHERE type=3107;
    

-- Example: set VIP 1 batch hatch time to instant (1 second)
UPDATE cq_config SET data1=1 WHERE type=3101;

9. How to modify skill experience and level requirements? ✅ New and old Engines

Open the cq_magictype table.
- need_exp = experience required to upgrade
- need_level = character level required to upgrade skill
Lower the values to make skills level up faster.

10. How to modify leveling speed? ✅ New and old Engines

Open the cq_levexp table.
Modify both usruplevExp and euduplevExp (must stay equal).
Lowering these values will increase leveling speed for characters and pets.

11. How to increase max level beyond 132? ✅ Old Engines

Open the cq_config table → look for level cap row (default 132).
Change the value to desired cap (max supported = 255).
⚠️ Do not exceed 255 or server will break.

12. How to modify Broadcast limit and cost? ✅ New Engines

This is controlled by MSG plugin.
Open MSG config → find broadcast/chat settings → edit limit and cost per message.
Default cost is usually set in Emoney.

13. How to change the login welcome text? ✅ New and old Engines

Open client ini/StrRes.ini → find entry 10052=....
Edit the message to any custom welcome text.
Example: Welcome to My EO Server!

14. How to set default VIP level on login? ✅ New and old Engines

There are a few ways to assign VIP levels automatically or manually: 


-- Example: set all existing accounts to VIP 3
UPDATE account SET vip=3;
    

-- Example: set single account to VIP 7
UPDATE account SET vip=7 WHERE name='TestAccount';

15. How to unlock all Legion Totems? ✅ New and old Engines

Open the cq_syndicate table → find your legion’s row → edit the column totem_pole.

- Set the value to 18446744073709551615 → instantly unlocks all totems.
- Set the value to 0 → reset (lock all totems).

⚠️ Only apply to the correct legion ID to avoid unintended changes. 


-- Example: unlock all totems for Legion ID 1001
UPDATE cq_syndicate SET totem_pole=18446744073709551615 WHERE id=1001;
    

-- Example: reset all totems for Legion ID 1001
UPDATE cq_syndicate SET totem_pole=0 WHERE id=1001;

16. How to edit items in the Emoney (EP) shop? ✅ New and old Engines

Open cq_goods table → rows with ownerid=1207 are EP Shop items.
- itemtype = item ID being sold
- Price comes from cq_itemtype last column.
⚠️ Client ini/itemtype.dat must match the same price → edit with tool.

17. How to change the appearance of monsters, eudemons (pets), or NPCs? ✅ New and old Engines

1. Monster & Eudemon Lookface:
- Open the cq_monstertype table.
- Find the monster or pet ID you want to modify.
- Locate the lookface column (4th column).
- Change it to the new model code (example: 439 = Dragon King model).

2. Eudemon Evolution Stages:
- Each pet has 6 related lookface IDs:
• 10710, 10790 = non-evolved appearance
• 10711, 10791 = first evolution appearance
• 10712, 10792 = second evolution appearance
- Modify these values to change how the pet looks in each stage.

3. NPC Lookface:
- Open the cq_npc table.
- Find the NPC ID you want to modify.
- In the lookface column (5th column), replace the value with the model code you want.

Note: Always check and use the correct lookface codes. Wrong codes may cause NPCs, monsters, or pets to not display properly.

18. How to modify the Castle system? ✅ Old Engines

First, make sure your castle system is enabled and working normally on the server.

1. Database side:
- Open cq_castle_lev_req table.
- The first few columns are requirements such as Money, Emoney, Woods, Population.
- The last column BuildNumEveryday = max number of units you can build per day. (Max limit: 255)
- It is strongly recommended to adjust this value, and also adjust the Population column.

2. Client side:
- Open ini/CastleLevReq.ini in the client.
- Format looks like this:

[Level xx]
Money=xxxxx
Emoney=xxxxx
Woods=xxxxx
Population=xxxxx
Item=xxxxx
BuildNumEveryday=xxxxx
- Explanation:
• Money = gold required
• Emoney = EP required
• Woods = wood requirement
• Population = population requirement
• Item = required items
• BuildNumEveryday = daily unit build limit

3. Existing Castles:
- Open cq_castle table.
- Adjust population and food values.
- ⚠️ Do not exceed the values in max_population and max_food columns.
- The build_oper_times column = how many units have already been built today.

✅ After editing both DB and INI, restart the server + client to apply changes.

19. How to batch edit monster drop rates? ✅ New and old Engines

Open the cq_dropitemrule table.

- chance = drop rate value
• 200000 = low
• 500000 = medium
• 1000000 = high
- item0–item14 = item IDs dropped (from cq_itemtype)

⚠️ Always backup your database before making changes. 


-- Example: batch lower all 500k drop rates to 200k
UPDATE cq_dropitemrule SET chance=200000 WHERE chance=500000;
    

-- Example: change last item slot (item14) to drop item ID 729020
UPDATE cq_dropitemrule SET item14=729020 WHERE item14=1060020;

20. How to increase lottery draw attempts? ✅ New and old Engines

Open cq_action table.
- Find ID 3700982 → edit param phase = 10 to 1000 = 1000 draws/day.
- To remove spam message, find ID 8930000 → change phase = 0 to 990. This delays system notice until 990th draw.

21. How to make the lottery draw give the items you want? ✅ New and old Engines

Open cq_lottery table with Navicat.

- ID: follow the sequence from above.
- type: set to 1.
- rank: priority. Higher rank = easier to be drawn.
  Example: rank 1 (hardest), rank 2, rank 3 (easiest).
- chance: luck value (0%–100%) within the same rank.
- prize_name: item name.
- prize_item: item ID.
- color: item color.
- holenum: socket count (max 2).
- addition_lev: item level (max 12).
- Other stats can go up to 255, warghostexp up to 8.

⚠️ Only applies to weapons/equipment. For other items, set unused fields to 0.

22. How to increase the number of eudemon you can summon? ✅ New and old Engines

Open the cq_user table → find the column medal_select.

- Set the value to the number of eudemons you want to carry.
- Example: 3 = summon 3 eudemons at once.

⚠️ Do not set too high, it may break balance (mass eudemon spam in PvP). 


-- Example: allow player to summon 3 eudemons
UPDATE cq_user SET medal_select=3 WHERE name='Test[PM]';

23. How to clean old/unnecessary data? ✅ New and old Engines

For detailed instructions on which tables to clear and how to safely reset your EO database, please check the full guide here:

👉 Reset Database Tutorial

⚠️ Always back up your database before deleting or resetting.

24. How to connect Navicat to the database?

- Open Navicat → top-right Connection.
- Connection name: anything.
- Username/password: usually test/test or root/root.
- If unsure, check your server config files.
- Leave other options default, then connect.
✅ Once connected, you can browse and edit DB tables.

25. How to add 12-pack uni or Special Ball in the shop? ✅ New and old Engines

- Open cq_goods.
- First column = ID, second = 1207, third = item code.
- Codes:
  • 12-pack uni = 813000
  • Special Ball = 729032

After saving, these items will be sold in the EP shop.

26. How to properly add a new eudemon? ✅ New and old Engines

Database:
Add entries into: cq_action, cq_monstertype, cq_itemtype, cq_grade, cq_eudmon_rbn_type, cq_dyna_rank_type, cq_totem_pole_type, cq_talentgain, cq_goods.

Client:
Edit files in ANI folder (ItemMiniIcon, PetFace, MapItemIcon).
Edit configs in INI folder (itemtype.dat, shop.dat, 3dmotion.ini, 3dobject.ini, 3DSimpleObj.ini, 3DSimpleRole.ini, 3DTexture.ini, armor.ini).
Update eudemon-related configs: Eudbook.ini, EudbookDes.ini, PetDescribe.ini, Totempole.ini, SysTotemPillar.ini.

⚠️ Use existing eudemons as reference when adding new ones.

27. How to change the number of eudemon warehouse pages? ✅ New and old Engines

Open the cq_npc table → search for the eudemon warehouse NPC (e.g. ID 1970, name Maisie).

Edit the column data3 which controls page count: 


-- Example: set warehouse NPC (ID 1970) to 20 pages
UPDATE cq_npc SET data3=100 WHERE id=1970;

28. How to change NPC position? ✅ New and old Engines

Open the cq_npc table and adjust these columns:

Example: Equipment Upgrade NPC → mapid=1000, cellx=158, celly=400. 


-- Example: move NPC ID 1970 to Cronus (1000, 158, 400)
UPDATE cq_npc SET mapid=1000, cellx=158, celly=400 WHERE id=1970;

29. How to change GM announcements shown at screen center? ✅ New and old Engines

Open cq_action table.
Sort by TYPE column.
Look for entries where TYPE = 125 and DATA = 2011.
Edit the message text.

30. How to make equipment indestructible? ✅ New and old Engines

Open cq_action table.
Look for rows with durability settings.
The 8th column value controls durability:
- 4 = indestructible
- 0 = normal
- 1 = unidentified
- 2 = unrepairable

You can also configure gems, soul levels, and attributes by editing the respective columns.
⚠️ Always back up before editing.

31. How to get all item IDs and data? ✅ New and old Engines

Use Navicat to connect to your database.
Open cq_itemtype table.
Export the data → you will get a full list of item IDs and their attributes.

32. How to change login screen image? ✅ Old Engines

For step-by-step instructions on replacing the login background, please check the full guide here:

👉 Change Login Background Tutorial

⚠️ Make sure to keep a backup of the original file before replacing.

33. How to instantly become business partner? ✅ New and old Engines

In cq_partner table:
Change column date type to tinyint.
After trading, relog once → instantly becomes business partner.

34. How to edit NPCs and monsters? ✅ New and old Engines

- NPC: in cq_npc (id, name, lookface, task0, cellx, celly, mapid).
- Monster: in cq_monstertype (name, lookface, life, attack, dodge, defence, actions).
You can also edit summoned pets here since they are monsters too.

35. How to modify items? ✅ New and old Engines

Database: cq_itemtype → edit stats.
Client: edit ini/itemtype.dat for display changes.
⚠️ Both server and client must match.

36. How to assign GM/PM status? ✅ New and old Engines

Open the cq_user or cq_user_new table → find your character.

- Add [PM] or [GM] after the name.
- Example: Test → Test[PM].

⚠️ Use carefully, GM/PM accounts have full privileges in-game. 


-- Example: assign PM status to character "Test"
UPDATE cq_user SET name='Test[PM]' WHERE name='Test';
    

-- Example: assign GM status to character "Test"
UPDATE cq_user SET name='Test[GM]' WHERE name='Test';

37. How to configure mount dismount behavior? ✅ Old Engines

Open cq_config table.
Find row where type = 1100.
Edit data1:
- 1 = normal attack won’t dismount
- 2 = XP normal won’t dismount
- 4 = displacement XP won’t dismount
- 8 = skill won’t dismount
- 16 = displacement skill won’t dismount
- 31 = never dismount (any action).

38. How to modify the number of hatch slots? ✅ New and old Engines

Open the cq_user table → find the column eud_pack_size.

- Set the value to how many slots you want available.
- Example: 6 = you can hatch 6 eudemons at once.

⚠️ Do not set too high, it may cause bugs or crashes. 


-- Example: set player hatch slots to 6
UPDATE cq_user SET eud_pack_size=6 WHERE name='Test[PM]';

39. How to change the avatar picture? ✅ New and old Engines

The EO client uses DDS images for most avatars. You can edit them using Photoshop with a DDS plugin or Paint.NET (recommended).

- data/pic/face/24 → small chat avatar (JPEG, 24×24).
- data/pic/face/64 → top-left round avatar (DDS, 64×64, transparent circle).
- data/pic/face/128 → big avatar in equipment window (both DDS + JPEG, 128×128).

Example: if the avatar ID is 190001 → replace:
• 24/190001.jpg (24×24)
• 64/190001.dds (64×64)
• 128/190001.jpg + 190001.dds (128×128)

💡 Tip: If face/64 folder doesn’t exist, create it manually.

40. How to jail and unjail a player? ✅ New and old Engines

Use the cheat_time column in cq_user. 


-- Jail a player
UPDATE cq_user SET cheat_time=9999 WHERE name='Test[PM]';
    

-- Unjail a player
UPDATE cq_user SET cheat_time=0 WHERE name='Test[PM]';

41. How to mute and unmute a player? ✅ New and old Engines

Use the disableFlag column in cq_user. 


-- Mute a player
UPDATE cq_user SET disableFlag=1 WHERE name='Test[PM]';
    

-- Unmute a player
UPDATE cq_user SET disableFlag=0 WHERE name='Test[PM]';

42. How to change Legion Pole and Shield HP? ✅ New and old Engines

Open the cq_dynanpc table → search for the Legion NPC you want to edit.
- Legion Pole = ID 21150
- Legion Shield = ID 21151

Find the columns life and maxlife and set them to the HP values you want.
After saving, restart the server for changes to take effect. 


-- Example: set Legion Pole (21150) HP
UPDATE cq_dynanpc SET life=500000, maxlife=500000 WHERE id=21150;
    

-- Example: set Legion Shield (21151) HP
UPDATE cq_dynanpc SET life=300000, maxlife=300000 WHERE id=21151;

43. How to restrict GM login by IP? ✅ Old Engines

To prevent unauthorized GM access, add rules in the cq_config table that bind GM login to a specific IP address.

- type 1031 and type 8000 must both be added.
- Replace 127.0.0.1 with the IP address you want to allow.

⚠️ Each row needs a unique id value. 


-- Restrict GM login to IP 127.0.0.1 (type 1031)
INSERT INTO cq_config (id, type, data1, data2, data3, data4, data5, str) 
VALUES (9001, 1031, 1, 0, 0, 0, 0, '127.0.0.1');
    

-- Restrict GM login to IP 127.0.0.1 (type 8000)
INSERT INTO cq_config (id, type, data1, data2, data3, data4, data5, str) 
VALUES (9002, 8000, 1, 0, 0, 0, 0, '127.0.0.1');

44. How to make guards look like players? ✅ Old Engines

Open the cq_monstertype table → find the row for the guard NPC.

Edit the column lookface:
- 1 = player male look
- 2 = player female look 


-- Example: change guard to male player look
UPDATE cq_monstertype SET lookface=1 WHERE id=xxxx;
    

-- Example: change guard to female player look
UPDATE cq_monstertype SET lookface=2 WHERE id=xxxx;

45. How to fix item names that are too long to display? ✅ New and old Engines

In your database, edit the cq_itemtype table.

- Right-click cq_itemtype → Design Table
- Find the column name
- Change its length from 15 to 20

This allows longer item names to display correctly. 


-- Example: increase name column size from 15 to 20
ALTER TABLE cq_itemtype MODIFY name VARCHAR(20);

46. How to make items stack in one slot? ✅ New and old Engines

Open your database → go to cq_itemtype table → find the item you want to edit.

- Adjust the column amount_limit.
- Example: set 10 → 10 of the same item will stack into one slot.

⚠️ Note: if the item is recyclable, the whole stack will be recycled at once. 


-- Example: set item ID 123456 to stack up to 10 per slot
UPDATE cq_itemtype SET amount_limit=10 WHERE id=123456;

47. How to restrict normal players from teleporting to VIP maps? ✅ New and old Engines

Open the cq_map table → find the VIP map you want to restrict (example: ID 1914).

- Edit the column type.
- Set its value to 1075838980.

After saving, restart the server to apply changes.
✅ This prevents normal players from using dimensional teleport into that map. 


-- Example: restrict teleport access for map ID 1914
UPDATE cq_map SET type=1075838980 WHERE id=1914;

48. How to fix nobility ranking table so names display correctly? ✅ New and old Engines

Open the cq_donation_dynasort_rec table → add a missing column name.

- Field name: name
- Type: varchar
- Length: 16
- Allow NULL: Yes
- Default: NULL

⚠️ The column must be placed as the 4th column in the table. 


-- Add missing "name" column to nobility ranking table
ALTER TABLE cq_donation_dynasort_rec 
ADD COLUMN name VARCHAR(16) NULL DEFAULT NULL AFTER id3;

49. How to fix infinite family EXP reward bug? ✅ Old Engines

To fix unlimited EXP rewards from family NPCs:

1. Open cq_dynanpc → check if column harvest_date exists.
  • If missing, add: harvest_date INT(4) DEFAULT 0

2. Open cq_family_attr → check if index0–index6 exist.
  • If missing, add them as INT(4) DEFAULT 0.

✅ After adding these fields, family EXP rewards will no longer be infinite. 


-- Add missing harvest_date column
ALTER TABLE cq_dynanpc ADD COLUMN harvest_date INT(4) DEFAULT 0;
    

-- Add missing index0–index6 columns
ALTER TABLE cq_family_attr 
ADD COLUMN index0 INT(4) DEFAULT 0,
ADD COLUMN index1 INT(4) DEFAULT 0,
ADD COLUMN index2 INT(4) DEFAULT 0,
ADD COLUMN index3 INT(4) DEFAULT 0,
ADD COLUMN index4 INT(4) DEFAULT 0,
ADD COLUMN index5 INT(4) DEFAULT 0,
ADD COLUMN index6 INT(4) DEFAULT 0;

50. How to make a PM character act like an NPC (green name)? ✅ New and old Engines

You can make a PM appear like an NPC (green name, monsters ignore him, players can interact) by changing the character’s ID.

⚠️ Important: When you change the character ID, all items, pets, and skills will lose their owner link.
You must also update their owner IDs in related tables (cq_item, cq_magictype, cq_eudemon, etc). 


-- Example: change PM "Test[PM]" to act as NPC
UPDATE cq_user SET id=10 WHERE name='Test[PM]';