Hello everyone can anyone here help me...i try use zukilos thread how to add dance book skill at db side but i found it cant use and i also try but the result is nothing work...so can anyone here give some new and working query
Here below is what my cq action for dance book maybe someone can check it and fix it..
cq action
1032610 1032611 1032612 1020 0 check 1052
1032611 0 0 1010 2005 You~already~have~learned~this~skill!
1032612 1032613 0 1020 0 learn 1052
1032613 1032614 0 502 726199
1032614 0 0 1010 2005 您学会了快乐桑巴
1032620 1032621 1032622 1020 0 check 1053
1032621 0 0 1010 2005 You~already~have~learned~this~skill!
1032622 1032623 0 1020 0 learn 1053
1032623 1032624 0 502 726200
1032624 0 0 1010 2005 您学会了曼舞轻灵
1032630 1032631 1032632 1020 0 check 1054
1032631 0 0 1010 2005 You~already~have~learned~this~skill!
1032632 1032633 0 1020 0 learn 1054
1032633 1032634 0 502 726201
1032634 0 0 1010 2005 您学会了动感摇摆
1032640 1032641 1032646 1025 0
1032641 1032642 1032643 1020 0 check 1055
1032642 0 0 1010 2005 You~already~have~learned~this~skill!
1032643 1032644 0 1020 0 learn 1055
1032644 1032645 0 502 726202
1032645 0 0 1010 2005 您学会了护花倾情
1032646 0 0 126 0 你没有配偶不能学习此技能！
1032660 1032661 1032666 1025 0
1032661 1032662 1032663 1020 0 check 1056
1032662 0 0 1010 2005 You~already~have~learned~this~skill!
1032663 1032664 0 1020 0 learn 1056
1032664 1032665 0 502 726203
1032665 0 0 1010 2005 您学会了对舞燃情
1032666 0 0 126 0 你没有配偶不能学习此技能！
1032680 1032681 1032686 1025 0
1032681 1032682 1032683 1020 0 check 1057
1032682 0 0 1010 2005 You~already~have~learned~this~skill!
1032683 1032684 0 1020 0 learn 1057
1032684 1032685 0 502 726204
1032685 0 0 1010 2005 您学会了恰恰节拍
1032686 0 0 126 0 你没有配偶不能学习此技能！
1032690 1032691 1032692 1020 0 check 1069
1032691 0 0 1010 2005 You~already~have~learned~this~skill!
1032692 1032693 0 1020 0 learn 1069
1032693 1032694 0 502 726220
1032694 0 0 1010 2005 您学会了梦幻华尔
cq_itemtype
726199 DanceSkill 0 0 70 0 0 0 0 0 0 0 5000000 1032610 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100000 0 0 0 0 0 0 0 0 0 0 0 0
726200 DanceSkill 0 0 70 0 0 0 0 0 0 0 5000000 1032620 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100000 0 0 0 0 0 0 0 0 0 0 0 0
726201 DanceSkill 0 0 70 0 0 0 0 0 0 0 5000000 1032630 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100000 0 0 0 0 0 0 0 0 0 0 0 0
726202 DanceSkill 0 0 125 0 0 0 0 0 0 100 5000000 1032641 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100000 0 0 0 0 0 0 0 0 0 0 0 0
726203 DanceSkill 0 0 125 0 0 0 0 0 0 100 5000000 1032661 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500000 0 0 0 0 0 0 0 0 0 0 0 0
726204 DanceSkill 0 0 125 0 0 0 0 0 0 100 5000000 1032681 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500000 0 0 0 0 0 0 0 0 0 0 0 0
726220 DanceSkill 0 0 125 0 0 0 0 0 0 100 5000000 1032690 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500000 0 0 0 0 0 0 0 0 0 0 0 0
cq magictype
10522 1052 22 快乐桑巴 0 0 0 2 2 0 0 20 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10521 1052 22 快乐桑巴 0 0 0 2 1 0 0 15 0 100 0 0 20 0 0 0 5400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10520 1052 22 快乐桑巴 0 0 0 2 0 0 0 10 0 100 0 0 20 0 0 0 2400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10532 1053 22 曼舞轻灵 0 0 0 2 2 0 0 20 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10531 1053 22 曼舞轻灵 0 0 0 2 1 0 0 15 0 100 0 0 20 0 0 0 5400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10530 1053 22 曼舞轻灵 0 0 0 2 0 0 0 10 0 100 0 0 20 0 0 0 2400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10542 1054 22 动感摇摆 0 0 0 2 2 0 0 20 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10541 1054 22 动感摇摆 0 0 0 2 1 0 0 15 0 100 0 0 20 0 0 0 5400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10540 1054 22 动感摇摆 0 0 0 2 0 0 0 10 0 100 0 0 20 0 0 0 2400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10552 1055 22 护花倾情 0 0 0 2 2 0 0 26 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10551 1055 22 护花倾情 0 0 0 2 1 0 0 18 0 100 0 0 20 0 0 0 7200 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10550 1055 22 护花倾情 0 0 0 2 0 0 0 12 0 100 0 0 20 0 0 0 3600 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10562 1056 22 对舞燃情 0 0 0 2 2 0 0 26 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10561 1056 22 对舞燃情 0 0 0 2 1 0 0 18 0 100 0 0 20 0 0 0 7200 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10560 1056 22 对舞燃情 0 0 0 2 0 0 0 12 0 100 0 0 20 0 0 0 3600 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10572 1057 22 恰恰节拍 0 0 0 2 2 0 0 26 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10571 1057 22 恰恰节拍 0 0 0 2 1 0 0 18 0 100 0 0 20 0 0 0 7200 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10570 1057 22 恰恰节拍 0 0 0 2 0 0 0 12 0 100 0 0 20 0 0 0 3600 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10690 1069 22 梦幻华尔 0 0 0 2 0 0 0 12 0 100 0 0 20 0 0 0 3600 0 0 0 0 60 0 0 0 0 0 100 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10691 1069 22 梦幻华尔 0 0 0 2 1 0 0 18 0 100 0 0 20 0 0 0 7200 0 0 0 0 60 0 0 0 0 0 100 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10692 1069 22 梦幻华尔 0 0 0 2 2 0 0 26 0 100 0 0 20 0 0 0 0 0 0 0 0 60 0 0 0 0 0 100 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
so maybe someone can chek them all and give some new and latest also working query to add dance book skill for db side
:)
Here below is what my cq action for dance book maybe someone can check it and fix it..
cq action
1032610 1032611 1032612 1020 0 check 1052
1032611 0 0 1010 2005 You~already~have~learned~this~skill!
1032612 1032613 0 1020 0 learn 1052
1032613 1032614 0 502 726199
1032614 0 0 1010 2005 您学会了快乐桑巴
1032620 1032621 1032622 1020 0 check 1053
1032621 0 0 1010 2005 You~already~have~learned~this~skill!
1032622 1032623 0 1020 0 learn 1053
1032623 1032624 0 502 726200
1032624 0 0 1010 2005 您学会了曼舞轻灵
1032630 1032631 1032632 1020 0 check 1054
1032631 0 0 1010 2005 You~already~have~learned~this~skill!
1032632 1032633 0 1020 0 learn 1054
1032633 1032634 0 502 726201
1032634 0 0 1010 2005 您学会了动感摇摆
1032640 1032641 1032646 1025 0
1032641 1032642 1032643 1020 0 check 1055
1032642 0 0 1010 2005 You~already~have~learned~this~skill!
1032643 1032644 0 1020 0 learn 1055
1032644 1032645 0 502 726202
1032645 0 0 1010 2005 您学会了护花倾情
1032646 0 0 126 0 你没有配偶不能学习此技能！
1032660 1032661 1032666 1025 0
1032661 1032662 1032663 1020 0 check 1056
1032662 0 0 1010 2005 You~already~have~learned~this~skill!
1032663 1032664 0 1020 0 learn 1056
1032664 1032665 0 502 726203
1032665 0 0 1010 2005 您学会了对舞燃情
1032666 0 0 126 0 你没有配偶不能学习此技能！
1032680 1032681 1032686 1025 0
1032681 1032682 1032683 1020 0 check 1057
1032682 0 0 1010 2005 You~already~have~learned~this~skill!
1032683 1032684 0 1020 0 learn 1057
1032684 1032685 0 502 726204
1032685 0 0 1010 2005 您学会了恰恰节拍
1032686 0 0 126 0 你没有配偶不能学习此技能！
1032690 1032691 1032692 1020 0 check 1069
1032691 0 0 1010 2005 You~already~have~learned~this~skill!
1032692 1032693 0 1020 0 learn 1069
1032693 1032694 0 502 726220
1032694 0 0 1010 2005 您学会了梦幻华尔
cq_itemtype
726199 DanceSkill 0 0 70 0 0 0 0 0 0 0 5000000 1032610 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100000 0 0 0 0 0 0 0 0 0 0 0 0
726200 DanceSkill 0 0 70 0 0 0 0 0 0 0 5000000 1032620 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100000 0 0 0 0 0 0 0 0 0 0 0 0
726201 DanceSkill 0 0 70 0 0 0 0 0 0 0 5000000 1032630 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100000 0 0 0 0 0 0 0 0 0 0 0 0
726202 DanceSkill 0 0 125 0 0 0 0 0 0 100 5000000 1032641 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100000 0 0 0 0 0 0 0 0 0 0 0 0
726203 DanceSkill 0 0 125 0 0 0 0 0 0 100 5000000 1032661 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500000 0 0 0 0 0 0 0 0 0 0 0 0
726204 DanceSkill 0 0 125 0 0 0 0 0 0 100 5000000 1032681 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500000 0 0 0 0 0 0 0 0 0 0 0 0
726220 DanceSkill 0 0 125 0 0 0 0 0 0 100 5000000 1032690 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 500000 0 0 0 0 0 0 0 0 0 0 0 0
cq magictype
10522 1052 22 快乐桑巴 0 0 0 2 2 0 0 20 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10521 1052 22 快乐桑巴 0 0 0 2 1 0 0 15 0 100 0 0 20 0 0 0 5400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10520 1052 22 快乐桑巴 0 0 0 2 0 0 0 10 0 100 0 0 20 0 0 0 2400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10532 1053 22 曼舞轻灵 0 0 0 2 2 0 0 20 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10531 1053 22 曼舞轻灵 0 0 0 2 1 0 0 15 0 100 0 0 20 0 0 0 5400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10530 1053 22 曼舞轻灵 0 0 0 2 0 0 0 10 0 100 0 0 20 0 0 0 2400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10542 1054 22 动感摇摆 0 0 0 2 2 0 0 20 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10541 1054 22 动感摇摆 0 0 0 2 1 0 0 15 0 100 0 0 20 0 0 0 5400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10540 1054 22 动感摇摆 0 0 0 2 0 0 0 10 0 100 0 0 20 0 0 0 2400 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10552 1055 22 护花倾情 0 0 0 2 2 0 0 26 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10551 1055 22 护花倾情 0 0 0 2 1 0 0 18 0 100 0 0 20 0 0 0 7200 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10550 1055 22 护花倾情 0 0 0 2 0 0 0 12 0 100 0 0 20 0 0 0 3600 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10562 1056 22 对舞燃情 0 0 0 2 2 0 0 26 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10561 1056 22 对舞燃情 0 0 0 2 1 0 0 18 0 100 0 0 20 0 0 0 7200 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10560 1056 22 对舞燃情 0 0 0 2 0 0 0 12 0 100 0 0 20 0 0 0 3600 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10572 1057 22 恰恰节拍 0 0 0 2 2 0 0 26 0 100 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10571 1057 22 恰恰节拍 0 0 0 2 1 0 0 18 0 100 0 0 20 0 0 0 7200 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10570 1057 22 恰恰节拍 0 0 0 2 0 0 0 12 0 100 0 0 20 0 0 0 3600 0 0 0 0 0 0 0 0 0 0 60 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10690 1069 22 梦幻华尔 0 0 0 2 0 0 0 12 0 100 0 0 20 0 0 0 3600 0 0 0 0 60 0 0 0 0 0 100 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10691 1069 22 梦幻华尔 0 0 0 2 1 0 0 18 0 100 0 0 20 0 0 0 7200 0 0 0 0 60 0 0 0 0 0 100 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10692 1069 22 梦幻华尔 0 0 0 2 2 0 0 26 0 100 0 0 20 0 0 0 0 0 0 0 0 60 0 0 0 0 0 100 0 0 0 800 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
so maybe someone can chek them all and give some new and latest also working query to add dance book skill for db side
:)