[Release] 4 Mice Pet Sql Script and Client Files

[haciveli]

as many want the new pets in their server, ill release a sql script that i wasted my life making lol. note their are some bugs that i havnt fixed yet.

1. Pets cant learn skills, still dnt know how to fix that

2. Their compose rates might be bugged not sure though

the client files Shop.dat are my servers shop.dat so if you arnt using pfj511 patches from b4, dnt bother downloading the client files.

their are also many items but i never included them in the script, you can manually add them yourself

SpcExpBall packs in shopping mall,
4th summon stone in shopping mall (pm me if u want the client files for it)
chainchop
invisiblity
dye system
most casuals in shopping mall (xmas, tranquil etc...)
x3 potion in shopping mall
Super Gold Bag
and many more

Credits for DarkDebi for giving me the GrRates of pets
Credits for Funhacker/ BiG-MaC for dye system,

the rest of the stuff are my work. pets will work but slight bugs, u can try and fix yourself

EDIT: patch 5017 is the client files for the 4th summon stone
EDIT #2: Added sql script for 4th summon stone

[erreway]

nice

[PsykoChyld]

Nicely Done, But you do know that a Certin someone will snag your **** then put it in his "know all guide" and not give you credit for the hard work you did. Gave you thanks for the hard work you put into it

[haciveli]

ye i know some ppl will do that, but every1 can c this thread so they will know it was me that did it

[Rawsteeey]

not work :/

[Err] 1054 - Unknown column 'rbn_rqr_type' in 'field list'
[Err] INSERT INTO cq_grade
(`id`, `life_a`, `life_b`, `life_c`, `life_grow_a`, `life_grow_b`, `life_grow_c`, `phy_min_a`, `phy_min_b`, `phy_min_c`, `phy_min_grow_a`, `phy_min_grow_b`, `phy_min_grow_c`, `phy_max_a`, `phy_max_b`, `phy_max_c`, `phy_max_grow_a`, `phy_max_grow_b`, `phy_max_grow_c`, `phy_def_a`, `phy_def_b`, `phy_def_c`, `phy_def_grow_a`, `phy_def_grow_b`, `phy_def_grow_c`, `mgc_min_a`, `mgc_min_b`, `mgc_min_c`, `mgc_min_grow_a`, `mgc_min_grow_b`, `mgc_min_grow_c`, `mgc_max_a`, `mgc_max_b`, `mgc_max_c`, `mgc_max_grow_a`, `mgc_max_grow_b`, `mgc_max_grow_c`, `mgc_def_a`, `mgc_def_b`, `mgc_def_c`, `mgc_def_grow_a`, `mgc_def_grow_b`, `mgc_def_grow_c`, `luck_a`, `luck_b`, `luck_c`, `dmg_type`, `rarity`, `metempsychosis`, `reborn_limit`, `rbn_rqr_type`, `auto_trade_type`)
VALUES
(1071490, 188, 188, 0, 3000, 7500, 296, 88, 88, 0, 9400, 23000, 138, 88, 88, 0, 15600, 39000, 46, 88, 88, 0, 9000, 22500, 243, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 88, 88, 0, 5000, 12500, 1844, 50, 100, 200, 0, 380, 0, 2500, 0, 0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[haciveli]

right click cq_grade and select design table add these two columns

Name Type Length Decimals Allow Null
------------------------------------------------------------------------------------------
rbn_rqr_type Int 4 0 No
Auto_trade_type Int 4 0 No

[Rawsteeey]

got it ty

[apoxdeath]

Originally Posted by PsykoChyld

Nicely Done, But you do know that a Certin someone will snag your **** then put it in his "know all guide" and not give you credit for the hard work you did. Gave you thanks for the hard work you put into it

lol yea ur right he will .... thanx haciveli gj

and i got this problem...

[Err] 1054 - Unknown column 'rbn_rqr_type' in 'field list'
[Err] INSERT INTO cq_grade
(`id`, `life_a`, `life_b`, `life_c`, `life_grow_a`, `life_grow_b`, `life_grow_c`, `phy_min_a`, `phy_min_b`, `phy_min_c`, `phy_min_grow_a`, `phy_min_grow_b`, `phy_min_grow_c`, `phy_max_a`, `phy_max_b`, `phy_max_c`, `phy_max_grow_a`, `phy_max_grow_b`, `phy_max_grow_c`, `phy_def_a`, `phy_def_b`, `phy_def_c`, `phy_def_grow_a`, `phy_def_grow_b`, `phy_def_grow_c`, `mgc_min_a`, `mgc_min_b`, `mgc_min_c`, `mgc_min_grow_a`, `mgc_min_grow_b`, `mgc_min_grow_c`, `mgc_max_a`, `mgc_max_b`, `mgc_max_c`, `mgc_max_grow_a`, `mgc_max_grow_b`, `mgc_max_grow_c`, `mgc_def_a`, `mgc_def_b`, `mgc_def_c`, `mgc_def_grow_a`, `mgc_def_grow_b`, `mgc_def_grow_c`, `luck_a`, `luck_b`, `luck_c`, `dmg_type`, `rarity`, `metempsychosis`, `reborn_limit`, `rbn_rqr_type`, `auto_trade_type`)
VALUES
(1071490, 188, 188, 0, 3000, 7500, 296, 88, 88, 0, 9400, 23000, 138, 88, 88, 0, 15600, 39000, 46, 88, 88, 0, 9000, 22500, 243, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 88, 88, 0, 5000, 12500, 1844, 50, 100, 200, 0, 380, 0, 2500, 0, 0);
[Msg] Finished - Unsuccessfully


and i did what u said to do in ealier post did not help...maybe i did something wrong?

[haciveli]

Originally Posted by apoxdeath

lol yea ur right he will .... thanx haciveli gj

and i got this problem...

[Err] 1054 - Unknown column 'rbn_rqr_type' in 'field list'
[Err] INSERT INTO cq_grade
(`id`, `life_a`, `life_b`, `life_c`, `life_grow_a`, `life_grow_b`, `life_grow_c`, `phy_min_a`, `phy_min_b`, `phy_min_c`, `phy_min_grow_a`, `phy_min_grow_b`, `phy_min_grow_c`, `phy_max_a`, `phy_max_b`, `phy_max_c`, `phy_max_grow_a`, `phy_max_grow_b`, `phy_max_grow_c`, `phy_def_a`, `phy_def_b`, `phy_def_c`, `phy_def_grow_a`, `phy_def_grow_b`, `phy_def_grow_c`, `mgc_min_a`, `mgc_min_b`, `mgc_min_c`, `mgc_min_grow_a`, `mgc_min_grow_b`, `mgc_min_grow_c`, `mgc_max_a`, `mgc_max_b`, `mgc_max_c`, `mgc_max_grow_a`, `mgc_max_grow_b`, `mgc_max_grow_c`, `mgc_def_a`, `mgc_def_b`, `mgc_def_c`, `mgc_def_grow_a`, `mgc_def_grow_b`, `mgc_def_grow_c`, `luck_a`, `luck_b`, `luck_c`, `dmg_type`, `rarity`, `metempsychosis`, `reborn_limit`, `rbn_rqr_type`, `auto_trade_type`)
VALUES
(1071490, 188, 188, 0, 3000, 7500, 296, 88, 88, 0, 9400, 23000, 138, 88, 88, 0, 15600, 39000, 46, 88, 88, 0, 9000, 22500, 243, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 88, 88, 0, 5000, 12500, 1844, 50, 100, 200, 0, 380, 0, 2500, 0, 0);
[Msg] Finished - Unsuccessfully


and i did what u said to do in ealier post did not help...maybe i did something wrong?

right click cq_grade and select design table add these two columns

Name Type Length Decimals Allow Null
------------------------------------------------------------------------------------------
rbn_rqr_type Int 4 0 No
Auto_trade_type Int 4 0 No

if u did that it should work, if u need more help i can teamview u if u want

[apoxdeath]

THANX MAN! lol

[ForsakenDeath]

can u release scripts for making all items in shopping mall work? im noob at it xD i dont know how to do it if someone could help that would be nice of them

[haciveli]

Originally Posted by ForsakenDeath

can u release scripts for making all items in shopping mall work? im noob at it xD i dont know how to do it if someone could help that would be nice of them

ok i will release, the script asap

[haciveli]

ok, this is the sql script which adds the items in shopping mall that i have added into the cq_goods table so you can buy them, and also sets the items prices in cq_itemtype

if you notice any items that dont, work, or have different prices, let me know asap and i will fix it.

ps. sorry for double post just wanted ppl to know i added this in

[ahmedpotop]

cool haci at last u began to help ppl well had college so i were off for nearly a week now back D:

[cyberghoser1]

haciveli thanks mice pets work, as you said compose is not right but its not a problem, the only problem i have is that i can not see the icons of dyes in shoping mall and can not buy them for the other items its ok almost for all