[Release] Ethernal e socket weapons em BI e Bag clean para Binario

ola pessoal eu tbm ja vi pessoas a pedir estes dois npc para o binario eu vou posta-los voces ja devem saber como se mete quem nao souber esta na parte binario como se poem o npc e so procurar Wink

eu so mexo em loft e coemu eu nao uso binario Wink

Creditos: 4botters Wink

Ethernal

Código:
UPDATE `cq_action` SET `id`='5109600',`id_next`='5109601',`id_nextfail`='0',`type`='101',`data`='0',`param`='Tortoise Gem is an ancient rarity. It can not only reduce the damages taken, but also upgrade the blessed equipment. If we cr' WHERE (`id`='5109600');
UPDATE `cq_action` SET `id`='5109601',`id_next`='5109604',`id_nextfail`='0',`type`='101',`data`='0',`param`='aft it with blessed equipment, its power will be brought into full play. Only i know the recipe.' WHERE (`id`='5109601');
UPDATE `cq_action` SET `id`='5109604',`id_next`='5109602',`id_nextfail`='0',`type`='102',`data`='0',`param`='I~Want~to~upgrade~my~blessed~equipment. 5109605' WHERE (`id`='5109604');
UPDATE `cq_action` SET `id`='5109602',`id_next`='5109603',`id_nextfail`='0',`type`='102',`data`='0',`param`='How~can~i~upgrade~my~blessed~attribute? 5109610' WHERE (`id`='5109602');
UPDATE `cq_action` SET `id`='5109603',`id_next`='5054400',`id_nextfail`='0',`type`='102',`data`='0',`param`='What,s~the~use~of~this~oven? 5060550' WHERE (`id`='5109603');
UPDATE `cq_action` SET `id`='5054400',`id_next`='9518721',`id_nextfail`='0',`type`='102',`data`='0',`param`='~MaKe~-1~. 5054405' WHERE (`id`='5054400');
UPDATE `cq_action` SET `id`='9518721',`id_next`='610067',`id_nextfail`='0',`type`='102',`data`='0',`param`='------- 9518725' WHERE (`id`='9518721');
UPDATE `cq_action` SET `id`='5109605',`id_next`='5109650',`id_nextfail`='0',`type`='101',`data`='0',`param`='You choose Which item to add God attribute to.' WHERE (`id`='5109605');
UPDATE `cq_action` SET `id`='5109650',`id_next`='5109651',`id_nextfail`='0',`type`='102',`data`='0',`param`='Headwear. 5109660' WHERE (`id`='5109650');
UPDATE `cq_action` SET `id`='5109651',`id_next`='5109652',`id_nextfail`='0',`type`='102',`data`='0',`param`='Necklace. 5109661' WHERE (`id`='5109651');
UPDATE `cq_action` SET `id`='5109652',`id_next`='5109653',`id_nextfail`='0',`type`='102',`data`='0',`param`='Ring,~Heavy~ring,~Bracelet. 5109662' WHERE (`id`='5109652');
UPDATE `cq_action` SET `id`='5109653',`id_next`='5109654',`id_nextfail`='0',`type`='102',`data`='0',`param`='Weapon. 5109663' WHERE (`id`='5109653');
UPDATE `cq_action` SET `id`='5109654',`id_next`='5109655',`id_nextfail`='0',`type`='102',`data`='0',`param`='Armor,~Coat,~Robe. 5109664' WHERE (`id`='5109654');
UPDATE `cq_action` SET `id`='5109655',`id_next`='5109656',`id_nextfail`='0',`type`='102',`data`='0',`param`='Shield. 5109665' WHERE (`id`='5109655');
UPDATE `cq_action` SET `id`='5109656',`id_next`='5109657',`id_nextfail`='0',`type`='102',`data`='0',`param`='Boots. 5109666' WHERE (`id`='5109656');
UPDATE `cq_action` SET `id`='5109657',`id_next`='610067',`id_nextfail`='0',`type`='102',`data`='0',`param`='Let~me~think~it~over. 0' WHERE (`id`='5109657');
UPDATE `cq_action` SET `id`='5109610',`id_next`='5109620',`id_nextfail`='0',`type`='101',`data`='0',`param`='Only blessed equipment can be upgraded. Super Tortoise Gems are required. After blessed attribute is upgraded, more damages ta' WHERE (`id`='5109610');
UPDATE `cq_action` SET `id`='5109620',`id_next`='5109621',`id_nextfail`='0',`type`='101',`data`='0',`param`='ken will be reduced. When blessed attribute reaches level 4 (the highest), the damage taken will be reduced by 7.' WHERE (`id`='5109620');
UPDATE `cq_action` SET `id`='5109621',`id_next`='610067',`id_nextfail`='0',`type`='102',`data`='0',`param`='How~many~super~tortoise~gems~are~required? 5109625' WHERE (`id`='5109621');
UPDATE `cq_action` SET `id`='5109625',`id_next`='5110965',`id_nextfail`='0',`type`='101',`data`='0',`param`='If you want to upgrade your blessed attribute to level 2, you must have level-1 blessed equipment And U Can MaKe It Now.' WHERE (`id`='5109625');
UPDATE `cq_action` SET `id`='5109626',`id_next`='5110966',`id_nextfail`='0',`type`='101',`data`='0',`param`='pgrade your blessed attribute to level, 3 you must have level-2 blessed equipment and 3 super of you want you upgrade blessed' WHERE (`id`='5109626');
UPDATE `cq_action` SET `id`='5109627',`id_next`='5110967',`id_nextfail`='0',`type`='101',`data`='0',`param`='attribute to level 4, you must have level-3 blessed equipment and 5 super.
' WHERE (`id`='5109627');
UPDATE `cq_action` SET `id`='5109628',`id_next`='610067',`id_nextfail`='0',`type`='102',`data`='0',`param`='I~see.~Thanks. 0' WHERE (`id`='5109628');
UPDATE `cq_action` SET `id`='5060550',`id_next`='5060551',`id_nextfail`='0',`type`='101',`data`='0',`param`=' ....' WHERE (`id`='5060550');
UPDATE `cq_action` SET `id`='5060551',`id_next`='5060552',`id_nextfail`='0',`type`='101',`data`='0',`param`='.' WHERE (`id`='5060551');
UPDATE `cq_action` SET `id`='5060552',`id_next`='5060553',`id_nextfail`='0',`type`='101',`data`='0',`param`='..' WHERE (`id`='5060552');
UPDATE `cq_action` SET `id`='5060553',`id_next`='5060554',`id_nextfail`='0',`type`='102',`data`='0',`param`='.. 5109635' WHERE (`id`='5060553');
UPDATE `cq_action` SET `id`='5060554',`id_next`='5060555',`id_nextfail`='0',`type`='102',`data`='0',`param`='.. 5060560' WHERE (`id`='5060554');
UPDATE `cq_action` SET `id`='5060555',`id_next`='610067',`id_nextfail`='0',`type`='102',`data`='0',`param`='...? 102100' WHERE (`id`='5060555');
UPDATE `cq_action` SET `id`='5054405',`id_next`='5054406',`id_nextfail`='0',`type`='101',`data`='0',`param`=' To~do~-1~in~the~iteam~you~must~pay~5~TortoiseGem.' WHERE (`id`='5054405');
UPDATE `cq_action` SET `id`='5054412',`id_next`='5054414',`id_nextfail`='0',`type`='102',`data`='0',`param`='(Coronet--Hat--Earring) 5054421' WHERE (`id`='5054412');
UPDATE `cq_action` SET `id`='5054414',`id_next`='5054415',`id_nextfail`='0',`type`='102',`data`='0',`param`='Necklace 5054450' WHERE (`id`='5054414');
UPDATE `cq_action` SET `id`='5054415',`id_next`='5054416',`id_nextfail`='0',`type`='102',`data`='0',`param`='Ring 5054470' WHERE (`id`='5054415');
UPDATE `cq_action` SET `id`='5054416',`id_next`='5054417',`id_nextfail`='0',`type`='102',`data`='0',`param`='Wapen 5054490' WHERE (`id`='5054416');
UPDATE `cq_action` SET `id`='5054417',`id_next`='5054418',`id_nextfail`='0',`type`='102',`data`='0',`param`='Armor 5054510' WHERE (`id`='5054417');
UPDATE `cq_action` SET `id`='5054418',`id_next`='5054419',`id_nextfail`='0',`type`='102',`data`='0',`param`='Shield 5054530' WHERE (`id`='5054418');
UPDATE `cq_action` SET `id`='5054419',`id_next`='5054420',`id_nextfail`='0',`type`='102',`data`='0',`param`='Boots 5054550' WHERE (`id`='5054419');
UPDATE `cq_action` SET `id`='5054420',`id_next`='610067',`id_nextfail`='0',`type`='102',`data`='0',`param`='Thank~you. 0' WHERE (`id`='5054420');
UPDATE `cq_action` SET `id`='5054445',`id_next`='5054446',`id_nextfail`='0',`type`='101',`data`='0',`param`=' This~iteam~is~-1~soory~you~can,t~-3.' WHERE (`id`='5054445');
UPDATE `cq_action` SET `id`='5054446',`id_next`='610067',`id_nextfail`='0',`type`='102',`data`='0',`param`='Thanks. 0' WHERE (`id`='5054446');
UPDATE `cq_action` SET `id`='5054514',`id_next`='5054515',`id_nextfail`='0',`type`='101',`data`='0',`param`=' Do~you~want~to~open~-~in~the~iteam.' WHERE (`id`='5054514');
UPDATE `cq_action` SET `id`='5054515',`id_next`='5054516',`id_nextfail`='0',`type`='102',`data`='0',`param`='Thanks. 5054520' WHERE (`id`='5054515');
UPDATE `cq_action` SET `id`='5054516',`id_next`='610067',`id_nextfail`='0',`type`='102',`data`='0',`param`='No~Thx. 0' WHERE (`id`='5054516');
UPDATE `cq_action` SET `id`='610067',`id_next`='610011',`id_nextfail`='0',`type`='104',`data`='0',`param`='10 10 67' WHERE (`id`='610067');



Socket weapon em BI

Código:
~REPLACE cq_action VALUES (5684810,0000,0000,2007,0, 'SocketMaster 0002 1 6120 0 0 %user_map_id %user_map_x %user_map_y 0 0 0 5684811 0 0 0 0 0 0 0 0 0 0 0');
REPLACE cq_action VALUES (5684811,5684812,0000,101,0, '%user_name.~I~Offer~Weapon~Sockets~In~the~Follwing~Order~');
REPLACE cq_action VALUES (5684812,5684813,0000,101,0, '1st~Socket~-~1~DBScroll~Required');
REPLACE cq_action VALUES (5684813,5684814,0000,101,0, '2nd~Socket~-~2~DBScrolls~Required');
REPLACE cq_action VALUES (5684814,5684815,0000,102,0, 'OK.~I~am~Ready! 5684816');
REPLACE cq_action VALUES (5684815,1504,0000,102,0, 'Let~me~think~about~it. 0');
REPLACE cq_action VALUES (5684816,5684817,5684820,504,0, 'ChkHole 1');
REPLACE cq_action VALUES (5684817,5684850,5684821,504,0, 'ChkHole 2');
REPLACE cq_action VALUES (5684820,5684822,5684860,506,0, '720028 720028 1');
REPLACE cq_action VALUES (5684821,5684823,5684860,506,0, '720028 720028 2');
REPLACE cq_action VALUES (5684822,5684824,0000,504,0, 'MakeHole 1');
REPLACE cq_action VALUES (5684823,5684825,0000,504,0, 'MakeHole 2');
REPLACE cq_action VALUES (5684860,5684861,0000,101,0, 'Sorry.~You~do~not~have~the~Required~DBScroll~or~DBScrolls.');
REPLACE cq_action VALUES (5684861,1504,0000,102,0, 'Ok.~Sorry 0');
REPLACE cq_action VALUES (5684850,5684851,0000,101,0, 'Sorry~you~have~2~Sockets~in~First~Weapon~Slot.');
REPLACE cq_action VALUES (5684851,1504,0000,102,0, 'Ok.~Let~me~look 0');
REPLACE cq_action VALUES (5684824,5684826,0000,101,0, 'Congratz.~You~have~made~your~First~Socket~in~First~Weapon~Slot.');
REPLACE cq_action VALUES (5684826,1504,0000,102,0, 'Ok.~Thanks. 0');
REPLACE cq_action VALUES (5684825,5684827,0000,101,0, 'Congratz.~You~have~made~2~Sockets~in~First~Weapon~Slot.');
REPLACE cq_action VALUES (5684827,1504,0000,102,0, 'Ok.~Thanks. 0');

REPLACE cq_task VALUES (5684810,5684810,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684811,5684811,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684812,5684812,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684813,5684813,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684814,5684814,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684815,5684815,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684816,5684816,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684817,5684817,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684820,5684820,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684821,5684821,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684822,5684822,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684823,5684823,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684860,5684860,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684861,5684861,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684850,5684850,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684851,5684851,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684824,5684824,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684826,5684826,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684825,5684825,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);
REPLACE cq_task VALUES (5684827,5684827,0000,"","",0,0,0,0,1000,0000,0000,0,-1,0);



Npc que limpa a bag (bag clean)

Código:
INSERT INTO `cq_npc` VALUES ('23981', '0', '0', 'InventoryCleaner', '0002', '3694', '-1', '1002', '0428', '0387', '224393101', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', 'None', '0000', '00', '00', '0000', '00', null);

INSERT INTO cq_action VALUES (224393101,224393102,0000,0101,0,"This~was~made~by~patcac~i~can~clear~ur~inventory~u~want~to?.");
INSERT INTO cq_action VALUES (224393102,224393103,0000,0102,0,"Hell~Ya 324393101");
INSERT INTO cq_action VALUES (224393103,15003,0000,0102,0,"No~Tnx 0");


INSERT INTO cq_action VALUES (324393101,324393102,0000,0101,0,"patcac~says:~Are~u~Preaty~sure?.");
INSERT INTO cq_action VALUES (324393102,324393103,0000,0102,0,"Ya 114193148");
INSERT INTO cq_action VALUES (324393103,15003,0000,0102,0,"Tnx 0");

REPLACE INTO cq_action VALUES (114193148, 424393101, 0000, 0127, 0, 'DELETE FROM cq_item WHERE position="0" AND player_id=%user_id');
INSERT INTO cq_action VALUES (424393101,424393102,0000,0101,0,"patcac~says:Please~RELOG!");
INSERT INTO cq_action VALUES (424393102,15003,0000,0102,0,"Ok 0");