ur saintbear wont work??? :O come here :D

01/27/2008 10:32 DragonPKZ#1
thnx goes 2 pfj511

run this script
Code:
update cq_itemtype set id_action = 6960304 where id = 729210

delete from the cation where id >= 6960304 and id <= 6960307

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (6960304, 6960305, 4008103, 0501, 1081860, '');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (6960305, 6960306, 0000, 0502, 729210, '');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (6960306, 6960307, 0000, 1085, 0, 'gmlog/action_log 340,%user_name[%user_id],0,0,0,0,119,0,1,0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (6960307, 0000, 0000, 0126, 0, 'congratulation! you have obtain a  new edu egg!');
if u dont know how for most people just download sql attachment :D
and just run it :D
thnx to pfj511 again :D
01/27/2008 11:17 pfj511#2
Code:
update cq_itemtype set id_action = 6960304 where id = 729210

delete from the cation where id >= 6960304 and id <= 6960307

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (6960304, 6960305, 4008103, 0501, 1081860, '');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (6960305, 6960306, 0000, 0502, 729210, '');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (6960306, 6960307, 0000, 1085, 0, 'gmlog/action_log 340,%user_name[%user_id],0,0,0,0,119,0,1,0');

INSERT INTO cq_action
   (`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (6960307, 0000, 0000, 0126, 0, 'congratulation! you have obtain a  new edu egg!');
01/27/2008 19:03 jackyyll#3
Also, if you're saintbear stats are bugged:

Code:
UPDATE cq_grade SET mgc_min_a=16, mgc_min_b=99, mgc_min_c=21, mgc_max_a=24, mgc_max_b=99, mgc_max_c=26, mgc_min_grow_a=8320, mgc_min_grow_b=20500, mgc_min_grow_c=308, mgc_max_grow_a=12480, mgc_max_grow_b=30750, mgc_max_grow_c=91 WHERE id = 1071860;
UPDATE cq_eudemon_rbn_type SET phy_atk=0, phy_def=0 WHERE id = 1071860;
01/28/2008 03:43 pfj511#4
Quote:
Originally Posted by jackyyll View Post
Also, if you're saintbear stats are bugged:

Code:
UPDATE cq_grade SET mgc_min_a=16, mgc_min_b=99, mgc_min_c=21, mgc_max_a=24, mgc_max_b=99, mgc_max_c=26, mgc_min_grow_a=8320, mgc_min_grow_b=20500, mgc_min_grow_c=308, mgc_max_grow_a=12480, mgc_max_grow_b=30750, mgc_max_grow_c=91 WHERE id = 1071860;
UPDATE cq_eudemon_rbn_type SET phy_atk=0, phy_def=0 WHERE id = 1071860;
you must update 6 line in cq_grade table :

1071860 1071861 1071862 1079860 1079861 1079862
01/28/2008 06:48 jackyyll#5
Oh, stupid me! That's why it didn't work! Thanks man!

Code:
UPDATE cq_grade SET mgc_min_a=16, mgc_min_b=99, mgc_min_c=21, mgc_max_a=24, mgc_max_b=99, mgc_max_c=26, mgc_min_grow_a=8320, mgc_min_grow_b=20500, mgc_min_grow_c=308, mgc_max_grow_a=12480, mgc_max_grow_b=30750, mgc_max_grow_c=91 WHERE id = 1071860;
UPDATE cq_eudemon_rbn_type SET phy_atk=0, phy_def=0 WHERE id = 1071860;
UPDATE cq_grade SET mgc_min_a=16, mgc_min_b=99, mgc_min_c=21, mgc_max_a=24, mgc_max_b=99, mgc_max_c=26, mgc_min_grow_a=8320, mgc_min_grow_b=20500, mgc_min_grow_c=308, mgc_max_grow_a=12480, mgc_max_grow_b=30750, mgc_max_grow_c=91 WHERE id = 1071861;
UPDATE cq_eudemon_rbn_type SET phy_atk=0, phy_def=0 WHERE id = 1071861;
UPDATE cq_grade SET mgc_min_a=16, mgc_min_b=99, mgc_min_c=21, mgc_max_a=24, mgc_max_b=99, mgc_max_c=26, mgc_min_grow_a=8320, mgc_min_grow_b=20500, mgc_min_grow_c=308, mgc_max_grow_a=12480, mgc_max_grow_b=30750, mgc_max_grow_c=91 WHERE id = 1071862;
UPDATE cq_eudemon_rbn_type SET phy_atk=0, phy_def=0 WHERE id = 1071862;
UPDATE cq_grade SET mgc_min_a=16, mgc_min_b=99, mgc_min_c=21, mgc_max_a=24, mgc_max_b=99, mgc_max_c=26, mgc_min_grow_a=8320, mgc_min_grow_b=20500, mgc_min_grow_c=308, mgc_max_grow_a=12480, mgc_max_grow_b=30750, mgc_max_grow_c=91 WHERE id = 1079860;
UPDATE cq_eudemon_rbn_type SET phy_atk=0, phy_def=0 WHERE id = 1079860;
UPDATE cq_grade SET mgc_min_a=16, mgc_min_b=99, mgc_min_c=21, mgc_max_a=24, mgc_max_b=99, mgc_max_c=26, mgc_min_grow_a=8320, mgc_min_grow_b=20500, mgc_min_grow_c=308, mgc_max_grow_a=12480, mgc_max_grow_b=30750, mgc_max_grow_c=91 WHERE id = 1079861;
UPDATE cq_eudemon_rbn_type SET phy_atk=0, phy_def=0 WHERE id = 1079861;
UPDATE cq_grade SET mgc_min_a=16, mgc_min_b=99, mgc_min_c=21, mgc_max_a=24, mgc_max_b=99, mgc_max_c=26, mgc_min_grow_a=8320, mgc_min_grow_b=20500, mgc_min_grow_c=308, mgc_max_grow_a=12480, mgc_max_grow_b=30750, mgc_max_grow_c=91 WHERE id = 1079862;
UPDATE cq_eudemon_rbn_type SET phy_atk=0, phy_def=0 WHERE id = 1079862;
01/28/2008 15:12 jinyeow#6
how to open it?
01/29/2008 01:26 jackyyll#7
Does anyone elses saintbear not get MATK on their servers?
02/01/2008 13:16 nooneatall#8
need fix for this stats of this pets as well..
eudemon | stat | max stats for min/max

MageAtkDef - ini patk 10/20 | patkgr 2.50/5.000
MageMatk - ini patk 20/30 | patkgr 5.000/7.500
Magemdef - ini patk 20/30 | patkgr 5.000/7.500
MageGos - ini patk 10/20 | patkgr 2.50/5.000
Magetinna - ini patk 20/30 | patkgr 5.000/7.500
Magepipy - ini patk 20/30 | patkgr 5.000/7.500
Magepeppy - ini patk 20/30 | patkgr 5.000/7.500
ShadowMageLiz - ini patk 10/20 | patkgr 2.50/5.000
HellfirePike - ini patk 20/30 | patkgr 5.000/7.500
EudemonAdam - ini patk 99/99
EudemonDiana - ini patk 99/99
BloodPhantom - ini patk 99/99

these stats need to be added to the according pets..