Help

03/28/2024 03:29 BilKid#1
Why is this action not working?
any way to resolve?

INSERT INTO `cq_action` VALUES ('1000000', '0000', '0000', '8001', '3', '1 88510143 null 采集中');
03/28/2024 20:03 no_1#2
Quote:
Originally Posted by BilKid View Post
Why is this action not working?
any way to resolve?

INSERT INTO `cq_action` VALUES ('1000000', '0000', '0000', '8001', '3', '1 88510143 null 采集中');
INSERT INTO `cq_action` (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES
(1000000, 0000, 0000, 8001, 3, "1 88510143 null 采集中'");
03/28/2024 23:35 BilKid#3
Quote:
Originally Posted by no_1 View Post
INSERT INTO `cq_action` (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`) VALUES
(1000000, 0000, 0000, 8001, 3, "1 88510143 null 采集中'");
Sorry, I guess I wasn't very specific.

When it reaches this line, the action would have to go to [88510143] but this is not happening.
I tried several ways but I couldn't make it work, I looked in other dbs, but they are all the same.
There are several actions like this in db, but none of them work, they all stop there.

if I do it like this:
INSERT INTO `cq_action` VALUES ('1000000', '88510143', '88510143', '8001', '3', '1 88510143 null Collecting');
It will work but it won't do the spoon character action, jump straight to the other action.
03/29/2024 09:47 hknippon#4
add 88510143 in cq task
03/29/2024 12:52 BilKid#5
Quote:
Originally Posted by hknippon View Post
add 88510143 in cq task
Thanks for the tip, but it didn't work.

I discovered that if I do it like this:

INSERT INTO `cq_action` VALUES ('1000000', '0000', '0000', '8001', '3', '0 88510143 null Collecting');
changing 1 to 0
It works, it has a collection effect, but it does not respect the count and it already executes the next action in the sequence.
03/30/2024 06:53 hknippon#6
ACTION_NEW_COUNTDOWN = 8000, // Countdown, data = time (seconds), Param = script executed after the countdown is over.When data = 0, it means that the countdown is turned off and the script is not executed.

//Note: Only one countdown can be displayed for a number at the same time, so before adding a countdown, be sure to end the previous countdown.

ACTION_NEW_COUNTDOWN2 =8001, //Countdown, data = time (seconds), “1 98120001 RichGod_Ground is removing the holy sword” //(1 means immovable, use skills or point NPCs or running will be interrupted, 0 means other operations).98120001 Script executed after the countdown is over.“RichGod_Ground” is an action effect (corresponding to 3deffect.ini file, written as “null” when no special effects are required), “The holy sword is being pulled out” is the text displayed on the client.

/When /data = 0, it means that the countdown is turned off and the script is not executed.

//Note: Only one countdown can be displayed for a number at the same time, so before adding a countdown, be sure to end the previous countdown.

ACTION_NEW_COUNTDOWN3 =8002, // Countdown to the current map task.Data = copy ID value, Param = "script executed after the countdown ends".After switching the map, the countdown ends automatically and the script is not executed.

//Note: This script type must be executed after it is transferred to the copy map. In addition, the map number must be greater than 400,000,000 or more, and it is only valid for the copy type map.

//The relevant configuration of the copy is set in the cq_duplicate table, refer to "Duplicate.Detailed description in the ”ini" file.The x and y of the cq_duplicate table represent the coordinates to which the invitee is transferred after accepting it.

//In addition, players in maps with a map ID greater than or equal to 4000000000 will not be invited.

ACTION_NEW_COUNTDOWN4 =8003, //Hidden countdown script type, time information will not appear on the client.Data = time (seconds), Param = script executed after the countdown is over.When data = 0, it means that the countdown is turned off and the script is not executed.
03/30/2024 22:31 BilKid#7
Quote:
Originally Posted by hknippon View Post
ACTION_NEW_COUNTDOWN = 8000, // Countdown, data = time (seconds), Param = script executed after the countdown is over.When data = 0, it means that the countdown is turned off and the script is not executed.

//Note: Only one countdown can be displayed for a number at the same time, so before adding a countdown, be sure to end the previous countdown.

ACTION_NEW_COUNTDOWN2 =8001, //Countdown, data = time (seconds), “1 98120001 RichGod_Ground is removing the holy sword” //(1 means immovable, use skills or point NPCs or running will be interrupted, 0 means other operations).98120001 Script executed after the countdown is over.“RichGod_Ground” is an action effect (corresponding to 3deffect.ini file, written as “null” when no special effects are required), “The holy sword is being pulled out” is the text displayed on the client.

/When /data = 0, it means that the countdown is turned off and the script is not executed.

//Note: Only one countdown can be displayed for a number at the same time, so before adding a countdown, be sure to end the previous countdown.

ACTION_NEW_COUNTDOWN3 =8002, // Countdown to the current map task.Data = copy ID value, Param = "script executed after the countdown ends".After switching the map, the countdown ends automatically and the script is not executed.

//Note: This script type must be executed after it is transferred to the copy map. In addition, the map number must be greater than 400,000,000 or more, and it is only valid for the copy type map.

//The relevant configuration of the copy is set in the cq_duplicate table, refer to "Duplicate.Detailed description in the ”ini" file.The x and y of the cq_duplicate table represent the coordinates to which the invitee is transferred after accepting it.

//In addition, players in maps with a map ID greater than or equal to 4000000000 will not be invited.

ACTION_NEW_COUNTDOWN4 =8003, //Hidden countdown script type, time information will not appear on the client.Data = time (seconds), Param = script executed after the countdown is over.When data = 0, it means that the countdown is turned off and the script is not executed.
I tried these variations, but without success.

but thanks for the tip.

I don't know what's happening, no time option is working in my DB.
For this reason, there are many quests that don't work.
03/31/2024 06:45 hknippon#8
can you test out the original timer action in the db, see if it works or not

if not, does your region been set to chinese?
03/31/2024 14:41 BilKid#9
Quote:
Originally Posted by hknippon View Post
can you test out the original timer action in the db, see if it works or not

if not, does your region been set to chinese?
Thanks a lot for the help
I've already tested the original team,
yes my server is configured for Chinese

but so far I haven't been successful.
03/31/2024 14:45 BilKid#10
I still haven't been successful in finding out why it doesn't work.
I ran some servers here and only one worked normally, I tried to study the DB, but without success.
If anyone could help me.
04/04/2024 09:33 hknippon#11
maybe your db is missing some table? check if its the same with other db