[HELP] Super eud crystal and special exp ball issues

[aiman596]

hi all,its been 2 months since i learn to to make my on own pserver.after im done with the translation(mostly),today im try to change the compose rate and find out that the eud crystal and special exp ball not working.i have no idea on how to troubleshoot the error and thinking that maybe the error is in the cq action(since im messing with cq action the most) .hope anyone can help me and ty in advance.

[T.h.u.n.d.e.r]

Hi there!

When you click on any item, usually the action will appear on your left hand side on the game chat section in yellow color. The very first number appeared when you clicked on that item, is the first ID that start the whole action for that item. Search in your cq_action for that ID and see what is the issue, feel free to post the action in here we can have a look to see if there is a mistake. If you are pressing on an item and its not showing any action at all, this simply means one of two things.

1- It has not action, the item need an action to be placed on id action column in cq_itemtype for this item.
2- The item have an action, but it is missing a task. This mostly can be fixed by adding a new cq_task line for the first number of action that the item have, which is usually the number that in the id action column in cq_itemtype.

[aiman596]

its not showing any action at all.the item id is in the cq itemtype but not in cq task(the id should be the same with the cq itemtype right?)

[SoulNecturn]

"Super eud crystal and special exp ball issues"
THESE kind of items Does NOT use any actions via cq_actions... never had and wont be.
These items are premade with certain default procedure. What you can decide is to spawn this item with certain amount (data field?? dont remember).
Thats all.

[T.h.u.n.d.e.r]

Originally Posted by aiman596

its not showing any action at all.the item id is in the cq itemtype but not in cq task(the id should be the same with the cq itemtype right?)

Hi there, this is an example of my Super Magic Crystal:

/* cq_action*/

INSERT INTO `cq_action` VALUES ('10245260', '10245261', '10245264', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('10245261', '10245262', '0000', '0502', '748390', '0');
INSERT INTO `cq_action` VALUES ('10245262', '10245263', '0000', '0501', '500002', '1 1 2 0 0 0 0 0 10000 0 0 0 0');
INSERT INTO `cq_action` VALUES ('10245263', '0000', '0000', '0126', '0', 'Congratulations! You got 1 Magic Crystal.');
INSERT INTO `cq_action` VALUES ('10245264', '0000', '0000', '0126', '0', 'Pleasve leave 1 empy space in your bag');


/* cq_task */
INSERT INTO `cq_task` VALUES ('10245260'', '10245260'', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');


"10245260" is the first action id. therefore, its on the id action column in cq_itemtype. This identify when you press on that item, this action will be executed. In addition, it have a dedicated task for it, therefore, its also in cq_task.

When clicking on that item, you will receive a crystal that has 10,000 Power (number in green). This is pretty high, therefore its a super crystal. In most source codes, the crystal itself (ID in green red) usually works, I don't believe the problem will be on the crystal itself. What is the ID of your item?

[aiman596]

Originally Posted by T.h.u.n.d.e.r

Hi there!

When you click on any item, usually the action will appear on your left hand side on the game chat section in yellow color. The very first number appeared when you clicked on that item, is the first ID that start the whole action for that item. Search in your cq_action for that ID and see what is the issue, feel free to post the action in here we can have a look to see if there is a mistake. If you are pressing on an item and its not showing any action at all, this simply means one of two things.

1- It has not action, the item need an action to be placed on id action column in cq_itemtype for this item.
2- The item have an action, but it is missing a task. This mostly can be fixed by adding a new cq_task line for the first number of action that the item have, which is usually the number that in the id action column in cq_itemtype.

Originally Posted by T.h.u.n.d.e.r

Hi there, this is an example of my Super Magic Crystal:

/* cq_action*/

INSERT INTO `cq_action` VALUES ('10245260', '10245261', '10245264', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('10245261', '10245262', '0000', '0502', '748390', '0');
INSERT INTO `cq_action` VALUES ('10245262', '10245263', '0000', '0501', '500002', '1 1 2 0 0 0 0 0 10000 0 0 0 0');
INSERT INTO `cq_action` VALUES ('10245263', '0000', '0000', '0126', '0', 'Congratulations! You got 1 Magic Crystal.');
INSERT INTO `cq_action` VALUES ('10245264', '0000', '0000', '0126', '0', 'Pleasve leave 1 empy space in your bag');


/* cq_task */
INSERT INTO `cq_task` VALUES ('10245260'', '10245260'', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');


"10245260" is the first action id. therefore, its on the id action column in cq_itemtype. This identify when you press on that item, this action will be executed. In addition, it have a dedicated task for it, therefore, its also in cq_task.

When clicking on that item, you will receive a crystal that has 10,000 Power (number in green). This is pretty high, therefore its a super crystal. In most source codes, the crystal itself (ID in green red) usually works, I don't believe the problem will be on the crystal itself. What is the ID of your item?

hi, here is my cq action for the eud crytal

REPLACE INTO `cq_action` VALUES (0000000010245160, 0000000010245161, 0000000010245164, 0508, 0, '1 0 50');
REPLACE INTO `cq_action` VALUES (0000000010245161, 0000000010245162, 0000000000000000, 0502, 1024516, '0');
REPLACE INTO `cq_action` VALUES (0000000010245162, 0000000010245163, 0000000000000000, 0501, 500002, '1 1 2 0 0 0 0 0 200 0 0 0 2');
REPLACE INTO `cq_action` VALUES (0000000010245163, 0000000000000000, 0000000000000000, 0126, 0, 'Congratulations!~You~have~got~1~magic~crystal~[gift].Open~your~backpack~and~have~a~look!');
REPLACE INTO `cq_action` VALUES (0000000010245164, 0000000000000000, 0000000000000000, 0126, 0, 'Your~backpack~is~full,~you~cannot~use~the~Holy~Be ast~Magic~Crystal~Gift~Pack!');

and here is cq task

INSERT INTO `cq_task` VALUES (10245160, 10245160, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0);

still not working

[T.h.u.n.d.e.r]

Hey, just to confirm.
The item you are using in the game is: 1024516?
Also can you confirm that in cq_itemtype for item (1024516) the id_action is = 10245160

If you can confirm the above then:

Try running the action in the game, see if it gives you the crystal or not.
/processaction 10245160

If the action is working, then the item is not running the action for some reason, check your itemtype again.

[aiman596]

10245160 is a small eudemon crystal pack with id action 10245160.
in-game item is eudemon crystal(50002) with id action 0.

after running the action u mention above,it doesn`t gimme me anything except parameter of cq action for 10245160 and 10245161 in the chat box

[T.h.u.n.d.e.r]

So to confirm, item 10245160, when you press on it nothing happens?

Double check your crystal ID, the right ID for the crystal, the right id is 500002 not 50002. You missing a 0.

You should have a pack, when you press on that pack, it will give you a crystal with whatever power you need, as shown on the code above. So make sure you get the crystal from the pack, don't just get the crystal itself.

If this also not working, I can give you a new code with a new item. We can try that then.

[aiman596]

yeah, my bad.its 500002.

and yeah,i got the crystal from the pack.i have no problem with the pack.but still nothing happen when i right click the crystal.

[T.h.u.n.d.e.r]

Hey try this:
1 - Run this action
REPLACE INTO `cq_action` VALUES (0000000010245162, 0000000010245163, 0000000000000000, 0501, 500002, '1 1 2 0 0 0 0 0 500 0 0 0 0');
2- Reload the action in the game
/reloadaction 10245162
3 - Get a new pack and press on it to get the crystal and test it again:
/awarditem 10245160

[aiman596]

/awarditem 10245160 doesnt give me anything.the crystal change to 500 but still cant use

[T.h.u.n.d.e.r]

My bad, its /awarditem 1024516

Then this should give you the crystal. How did you test the new crystal, did you run the new action or just used /awarditem 500002 ?

If it is still not working, try the super crystal. Hopefully you have this item in your DB already.

1 - Run the query again:
REPLACE INTO `cq_action` VALUES (0000000010245162, 0000000010245163, 0000000000000000, 0501, 831100, '1 1 2 0 0 0 0 0 500 0 0 0 0');

2- /reloadaction 10245162
3- /awarditem 1024516
4- Then test again by pressing on the pack and use the crystal.

[aiman596]

still cant,i notice that there is a system notification pop up at the top left corner every time i right click a crystal.saying thst unable to use the item

[T.h.u.n.d.e.r]

Hey, have you tried it in on a different pet perhaps?

I never seen crystals bugged before, unless this is a new source/database. Again it might be the crystal ID is different in your source. As you saw there is different IDs for crystals as used on the action above. Some of these IDs are 831100 and 500002. Maybe test out and see what other crystals you have in game like the one you claim from the VIP or VIP NPC in soder.