[New] Tool To Make SQL Soon

[wolfvb]

Hi all
iam work at tool to make SQL For Pet Only it to Hard
and i Got alot of Problem at it but i will finsh it
and this tool will help all people to make the SQL of pets
and soon i will make a lot of version the start is hard but the will easy i i code this one
and i work also in a PM&GM Code DB and Donation list on ur server to
make u know who donate and how match and when
some pic:
this the sql maker not finish yet

the PM Code data and codes add by cloud strife

the last on is List Of Donation


i will Post the SQL and Donation list very soon after i finish the SQl program
thanks elitepvpers for make me know in eo all i know and thanks to any one help me ever

[hani2012]

great i wait for it wolfvb

[wolfvb]

it will come soon i work on it now it will great to make sql for pet and i will make one for
suits

[haizamlee]

wow...great idea...

[wolfvb]

thank man and i will finish it i code all program now
now i work at sql to make it work will out any problem
but i think to use the program u need to know how to make the sql
cuz u need to know what is cq_action ids and Cq_Itemtype and cq_monstertype
and this i can't make it easy i only make it easy to how know how to make it
it will faster

[40z10Q]

yeah .nice idea wolfvb .

[wolfvb]

that the way like u will get the sql

 Spoiler

PHP Code:

DELETE FROM cq_action WHERE id >= (aID) and id <= (aID5);

INSERT INTO cq_action (id,id_next,id_nextfail,type,data,param) 
VALUES 
((aID),(aID2),(aID4),508,0,'1 0 52'),
((aID2),(aID3),0,502,(PetID),''),
((aID3),(aID4),0,501,(PetID2),''),
((aID4),(aID5),0,1085,0,'gmlog/action_log 380,%user_name[%user_id],0,0,(PetID2),0,0,(PetID),0,0'),
((aID4),0,0,126,0,'Please~make~one~space~in~your~eudemon~bag~free!'),
((aID5),0,0,126,0,'Congratulations!~You~have~obtained~a~(petname)~egg!');


DELETE FROM cq_itemtype WHERE id = (PetID);
DELETE FROM cq_itemtype WHERE id = (PetID2);
DELETE FROM cq_itemtype WHERE id >= (PetID3) and id <= (PetID5);
DELETE FROM cq_itemtype WHERE id >= (PetID6) and id <= (PetID8);

INSERT INTO cq_itemtype (id,name,monopoly,price,id_action,attack_max,attack_min,defense,dodge,life,gem1,magic_def,atk_range,hitrate,monster_type,able_mask,exp_type,emoney)
VALUES
((PetID), '(petname)',28,4321,(PetID3),0,0,0,0,0,0,0,0,0,(PetID2),0,0,100000),
((PetID2),'(petname)',4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
((PetID3),'(petname)',0,250,0,0,0,0,0,0,32,0,1,9000,72020,2,1,0),
((PetID4),'(petname)',0,250,0,0,0,0,0,0,32,0,1,9000,72021,2,1,0),
((PetID5),'(petname)',0,250,0,0,0,0,0,0,32,0,1,9000,72022,2,1,0),
((PetID6),'(petname)',0,250,0,0,0,0,0,0,32,0,1,9000,76020,2,1,0),
((PetID7),'(petname)',0,250,0,0,0,0,0,0,32,0,1,9000,76021,2,1,0),
((PetID8),'(petname)',0,250,0,0,0,0,0,0,32,0,1,9000,76022,2,1,0);


DELETE FROM cq_eudemon_rbn_type WHERE id >= (PetID3) and id <= (PetID5);
DELETE FROM cq_eudemon_rbn_type WHERE id >= (PetID6) and id <= (PetID8);

INSERT INTO cq_eudemon_rbn_type (id,phy_atk,phy_def) 
VALUES 
((PetID3),1,1),
((PetID4),1,1),
((PetID5),1,1),
((PetID6),1,1),
((PetID7),1,1),
((PetID8),1,1);

DELETE FROM cq_grade WHERE id >= (PetID3) and id <= (PetID5);
DELETE FROM cq_grade WHERE id >= (PetID6) and id <= (PetID8);

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,reborn_limit) 
VALUES 
((PetID3),20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,1000,9999),
((PetID4),20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,1000,9999),
((PetID5),20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,1000,9999),
((PetID6),20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,1000,9999),
((PetID7),20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,1000,9999),
((PetID8),20,290,1,2500,6250,53,16,95,21,10000,22000,347,24,99,13,15000,33000,102,9,99,22,14000,27500,683,0,0,0,0,0,0,0,0,0,0,0,0,11,56,37,5000,12500,177,50,130,200,0,1000,9999);


DELETE FROM cq_monstertype WHERE id >= (monID) and id <= (monID3)
DELETE FROM cq_monstertype WHERE id >= (monID4) and id <= (monID7);

INSERT INTO cq_monstertype (id,name,type,lookface,life,attack_range,view_range,attack_speed,level,attack_user,size_add,drop_armet,drop_necklace,drop_armor,drop_ring,drop_weapon,drop_shield,drop_shoes,magic_type,magic_hitrate,atk_hitrate,ai_type,defence,profession) 
VALUES
((monID),'(petname)',1,(look),100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
((monID2),'(petname)',1,(look),100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
((monID3),'(petname)',1,(look),100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
((monID4),'(petname)',1,(look),100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
((monID5),'(petname)',1,(look),100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900),
((monID6),'(petname)',1,(look),100,7,15,1000,1,32775,3,99,99,99,99,99,99,99,0,0,75,1,10000,900);


DELETE FROM cq_goods WHERE itemtype = (PetID);

INSERT INTO cq_goods (id,ownerid,itemtype) 
VALUES 
((PetID),1207,(PetID)); 


I Finsh it who can test it
u need to know how to make the pet sql to work will with the program


the Program finished
u can get it

[Thorlon]

Great ideas, i cant wait.
Thanks

[wolfvb]

thanks
for all

[Marcus*]

good luck with them wolfvb they will help a lot of people when ur done

[shadowkiller990]

wow thats looks awsome lol gonna help new players out alot

[wolfvb]

not only new all will be helped
pro and noops

[Mo®talKing]

nice work wolfvb ... keep up